| Welcome, Guest |
You have to register before you can post on our site.
|
| Online Users |
There are currently 263 online users.
» 0 Member(s) | 260 Guest(s)
Bing, Google, Yandex
|
| Latest Threads |
Open Mp Server resartint ...
Forum: Support
Last Post: passedthedemon
Yesterday, 10:16 PM
» Replies: 0
» Views: 8
|
AntyCheat System [SA-MP/O...
Forum: Filterscripts
Last Post: 2PAC_
2025-07-12, 09:17 PM
» Replies: 7
» Views: 8,409
|
Iron Horizon Roleplay[v1....
Forum: Advertisements
Last Post: MikeNGRP
2025-07-11, 11:44 PM
» Replies: 0
» Views: 30
|
[MAP PACK] 5 NEW LS BUILD...
Forum: Videos and Screenshots
Last Post: Apollo4430
2025-07-11, 12:20 AM
» Replies: 1
» Views: 3,345
|
Open.mp / SAMP Query
Forum: Releases
Last Post: laex
2025-07-09, 04:07 AM
» Replies: 2
» Views: 131
|
some text appearing in my...
Forum: Support
Last Post: Sizy
2025-07-08, 07:33 AM
» Replies: 0
» Views: 38
|
Offensive-Core: TDM
Forum: Gamemodes
Last Post: NikitaFoxze
2025-07-08, 12:13 AM
» Replies: 3
» Views: 3,688
|
Second Generation Rolepla...
Forum: Advertisements
Last Post: JamesT
2025-07-06, 10:28 AM
» Replies: 0
» Views: 54
|
Servidor RPG profissões
Forum: Advertisements
Last Post: tcharlesmeurer
2025-07-05, 11:35 PM
» Replies: 0
» Views: 35
|
EVO Anti-Cheat
Forum: Libraries
Last Post: Eduardo_AC
2025-07-05, 11:05 PM
» Replies: 2
» Views: 120
|
|
|
Question about open.mp and SAxVCxLC |
|
Posted by: vico - 2020-11-11, 04:15 AM - Forum: General Discussions
- Replies (2)
|
 |
Hello!
First things first: let me say i searched the forums but cant find anything remotely similar to what i'm going to ask. If indeed there are other similar threads and i wasn't able to find, i humbly sorry.
SAxVCxLC, which for those who don't know is a mod who add the landmasses of Vice City and Liberty City (GTA III) alongside (not replacing) San Andreas.
From their Readme:
Quote:Adds the GTA Vice City and Liberty City maps into GTA San Andreas. GTA SA remains fully playable and moddable: mods for SA work also with SAxVCxLC. SAxVCxLC is clean basis for modding by external mods.
I don't know what will be the stance of open.mp about support for TCs, so i'm here to ask if the devs have intentions, even for long term, to add some kind of support for this expanded gameworld, i mean a way to start a server and be able to, via pawn, interact with the other landmasses (place objects, teleport players, etc).
Particularly for me that would be a huge draw-in to make a server after all those years.
Thanks in advance for all your work with open.mp keeping the community alive!
|
|
|
|
Help - Split MySQL |
|
Posted by: wearLy - 2020-11-10, 01:54 PM - Forum: Pawn Scripting
- No Replies
|
 |
Everything goes well, except in the vehicle and accessory loops.
Code: [color=#24292e][size=x-small][font=SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace]// MySQL:
g_MysqlRaceCheck[playerid];
// create orm instance and register all needed variables
new ORM: ormid = PlayerInfo[playerid][ORM_ID] = orm_create("player", mySQL_Server);
orm_addvar_int(ormid, PlayerInfo[playerid][pID], "id");
orm_addvar_string(ormid, PlayerName[playerid], MAX_PLAYER_NAME, "nome");
orm_addvar_string(ormid, PlayerInfo[playerid][pKey], 65, "senha");
orm_addvar_int(ormid, PlayerInfo[playerid][pLevel], "level");
orm_addvar_int(ormid, PlayerInfo[playerid][pExp], "respeitos");
orm_addvar_int(ormid, PlayerInfo[playerid][pConnectTime], "horas_jogadas");
orm_addvar_int(ormid, PlayerInfo[playerid][pCash], "dinheiro");
orm_addvar_int(ormid, PlayerInfo[playerid][pConta], "dinheiro_banco");
orm_addvar_int(ormid, PlayerInfo[playerid][pOuros], "ouros");
orm_addvar_int(ormid, PlayerInfo[playerid][pCashVip], "cash");
orm_addvar_int(ormid, PlayerInfo[playerid][pKills], "assassinatos");
orm_addvar_int(ormid, PlayerInfo[playerid][pDeaths], "mortes");
orm_addvar_int(ormid, PlayerInfo[playerid][pSkin], "skin");
orm_addvar_int(ormid, PlayerInfo[playerid][pPayDay], "timer_payday");
orm_addvar_int(ormid, PlayerInfo[playerid][pPegouVIP], "vip_pegou");
new string_save[355];
new string_read[18][60];
new string[50];
for(new carro; carro < MAX_PLAYER_CARROS; carro)
{
// Veiculo informa??es
format(string, sizeof string, "veiculo_%d", carro);
orm_addvar_string(ormid, string_save, sizeof (string_save), string);
split(string_save, string_read, '|');
PlayerConce[playerid][carro][conce_valid]? = strval(string_read[0]);
PlayerConce[playerid][carro][conce_model]? = strval(string_read[1]);
PlayerConce[playerid][carro][conce_pos][0] = floatstr(string_read[2]);
PlayerConce[playerid][carro][conce_pos][1] = floatstr(string_read[3]);
PlayerConce[playerid][carro][conce_pos][2] = floatstr(string_read[4]);
PlayerConce[playerid][carro][conce_pos][3] = floatstr(string_read[5]);
PlayerConce[playerid][carro][conce_health] = floatstr(string_read[6]);
PlayerConce[playerid][carro][conce_color][0] = strval(string_read[7]);
PlayerConce[playerid][carro][conce_color][1] = strval(string_read[8]);
PlayerConce[playerid][carro][conce_preco] = strval(string_read[9]);
PlayerConce[playerid][carro][conce_gasolina] = strval(string_read[10]);
PlayerConce[playerid][carro][conce_estacionado] = strval(string_read[11]);
PlayerConce[playerid][carro][conce_seguro] = strval(string_read[12]);
PlayerConce[playerid][carro][conce_alarme]? = strval(string_read[13]);
PlayerConce[playerid][carro][conce_date] = strval(string_read[14]);
PlayerConce[playerid][carro][conce_despesas] = strval(string_read[15]);
format(PlayerConce[playerid][carro][conce_placa], 25, string_read[16]);
format(PlayerConce[playerid][carro][conce_textol], 75, string_read[17]);
// Tunning
format(string, sizeof string, "tune_%d", carro);
orm_addvar_string(ormid, string_save, 258, string);
split(string_save, string_read, '|');
for(new component; component != 15; component) {
PlayerConce[playerid][carro][conce_tune][component] = strval(string_read[component]);
}
}
for(new index; index != MAX_PLAYER_ATTACHED_OBJECTS; index)
{
// Acessorios Informa??es
format(string, sizeof string, "itens_%d", index);
orm_addvar_string(ormid, string_save, sizeof(string_save), string);
split(string_save, string_read, '|');
format(acessorioInfo[playerid][index][acessorioNome], 75, string_read[1]);
acessorioInfo[playerid][index][acessorioValid]? = strval(string_read[0]);
acessorioInfo[playerid][index][acessorioModelo] = strval(string_read[2]);
acessorioInfo[playerid][index][acessorioBone] = strval(string_read[3]);
// Coordenadas
acessorioInfo[playerid][index][acessorioPos][0] = floatstr(string_read[4]);
acessorioInfo[playerid][index][acessorioPos][1] = floatstr(string_read[5]);
acessorioInfo[playerid][index][acessorioPos][2] = floatstr(string_read[6]);
// Rota??o
acessorioInfo[playerid][index][acessorioRot][0] = floatstr(string_read[7]);
acessorioInfo[playerid][index][acessorioRot][1] = floatstr(string_read[8]);
acessorioInfo[playerid][index][acessorioRot][2] = floatstr(string_read[9]);
// Tamanho
acessorioInfo[playerid][index][acessorioTam][0] = floatstr(string_read[10]);
acessorioInfo[playerid][index][acessorioTam][1] = floatstr(string_read[11]);
acessorioInfo[playerid][index][acessorioTam][2] = floatstr(string_read[12]);
}
orm_setkey(ormid, "nome");
// tell the orm system to load all data, assign it to our variables and call our callback when ready
orm_load(ormid, "OnPlayerLoginCheck", "dd", playerid, g_MysqlRaceCheck[playerid]);[/font][/size][/color]
|
|
|
|
Help with FCNPC |
|
Posted by: dwp12345 - 2020-11-10, 04:53 AM - Forum: Pawn Scripting
- Replies (1)
|
 |
I want to make npc stop following player by distance.
here is my code,
Code: public FCNPC_Moving(npcid)
{
new Float:p[3];
? ? for(new i =0 ; i < GetMaxPlayers(); i )
{
? ? if(IsPlayerNPC(i)) continue;
FCNPC_GetPosition(npcid,p[0],p[1],p[2]);
if(IsPlayerInRangeOfPoint(i,10,p[0],p[1],p[2]))
{
if(IsPlayerInRangeOfPoint(i,1,p[0],p[1],p[2]))
{
FCNPC_Punch(npcid,p[0],p[1],p[2],50);
}
else
{
? ? FCNPC_GoToPlayer(npcid, i, FCNPC_MOVE_TYPE_AUTO, FCNPC_MOVE_SPEED_AUTO, FCNPC_MOVE_MODE_AUTO, FCNPC_MOVE_PATHFINDING_AUTO, 0.0, true, 0.0, 1.5, 250);
? ? ? ? ? ? ? ??
}
}
}
return 1;
}
|
|
|
|
| Good Advertising Sites |
|
Posted by: Torque - 2020-11-07, 09:42 PM - Forum: General Discussions
- Replies (4)
|
|
I understand that it's incredibly hard to open a new SAMP community. There's aren't many new users coming in, and pretty much everybody who is still playing SAMP is already established in their current communities.
However, I still want to reach out and try and bring in some potential players to my servers. Besides this forum (Which lets face is, is mostly consisted of developers, not players), what sites are out there to help me get the word out about my SAMP roleplay community?
Thanks.
|
|
|
|
Problema de guardado con SQL. |
|
Posted by: nittro - 2020-11-07, 08:04 PM - Forum: Programaci?n
- No Replies
|
 |
Mi problema es que el sistema de registro va bien, pero al desconectarse y loguear otra vez, coloca todos los datos en 0. Estaba probando el sistema hasta que ocurrio.
PHP Code: new DB:sqldb;
new guardadordeCuenta;
enum d@usuario
{
ID,
Nivel,
NivelStaff,
Vip,
bool:Ingreso,
Muteado,
Dinero,
Vida,
Chaleco,
Genero,
Float:PosX,
Float:PosZ,
Float:PosY,
bool:NewSpawn
};
new Cuenta[MAX_PLAYERS][d@usuario];
forward GuardarCuentas();
/*
*=======================================*
*===============Dialogos================*
*=======================================*
*/
#define DIALOGO_REGISTRO (0)
#define DIALOGO_INGRESO (1)
#define DIALOGO_GENERO (2)
public OnGameModeInit()
{
//Conectar al SQlite.
sqldb = db_open("sqldb.db");
//Crear la tabla Sqlite.
db_query(sqldb, "CREATE TABLE IF NOT EXISTS `usuarios` (ID INTEGER PRIMARY KEY AUTOINCREMENT, Nombre TEXT, Llave TEXT, Nivel NUMERIC, NivelStaff NUMERIC, Vip NUMERIC, Muteado NUMERIC, Vida NUMERIC, Chaleco NUMERIC, Dinero NUMERIC, Genero NUMERIC, PosX FLOAT, PosY FLOAT, PosZ FLOAT)");
// Algunos Timers sobre la base de datos SQlite.
guardadordeCuenta = SetTimer("GuardarCuentas", 120000, true); // Guardar cuentas cada dos minutos.
}
public OnGameModeExit()
{
//Cierro la base de datos.
db_close(sqldb);
return 1;
}
public OnPlayerConnect(playerid)
{
ReiniciarD(playerid);
new query[(59)];
format(query, sizeof(query), "SELECT * FROM usuarios WHERE Nombre = '%s' COLLATE NOCASE", DB_Escape(Nombre(playerid)));
new DBResult:R = db_query(sqldb, query);
if(db_num_rows(R))
{
ShowPlayerDialog(playerid,DIALOGO_INGRESO,DIALOG_STYLE_PASSWORD,""GRISCLARO"? "AZULMARINO"Bienvenido de nuevo al servidor",""ROJO"Escribe tu contrase?a para ingresar al servidor.","Ingresar","Salir");
}
else
{
ShowPlayerDialog(playerid,DIALOGO_REGISTRO,DIALOG_STYLE_INPUT,""GRISCLARO"? "AZULMARINO"Bienvenido al servidor",""ROJO"Escribe tu contrase?a para poder guardar tus datos.",""TURQUESA"Registrar",""ROJO"Salir");
}
db_free_result(R);
return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
//Guardar posici?n del jugador.
new Float:x, Float:y, Float:z;
GetPlayerPos(playerid, x,y,z);
Cuenta[playerid][PosX] = x;
Cuenta[playerid][PosY] = y;
Cuenta[playerid][PosZ] = z;
GuardarCuenta(playerid);
ReiniciarD(playerid);
return 1;
}
public OnDialogResponse(playerid,dialogid,response,listitem,inputtext[])
{
if(dialogid == DIALOGO_INGRESO)
{
if(!response)Kick(playerid);
if(response){
new query[(76�)];
format(query,sizeof(query),"SELECT * FROM usuarios WHERE Nombre = '%s' AND Llave = '%s' COLLATE NOCASE",DB_Escape(Nombre(playerid)),DB_Escape(inputtext));
new DBResult:R = db_query(sqldb,query);
if(db_num_rows(R)){
Cuenta[playerid][ID]? ? ? = db_get_field_assoc_int(R,"ID");
Cuenta[playerid][Nivel]? ? = db_get_field_assoc_int(R,"Nivel");
Cuenta[playerid][NivelStaff]? ? = db_get_field_assoc_int(R,"NivelStaff");
Cuenta[playerid][Dinero]? = db_get_field_assoc_int(R,"Dinero");
Cuenta[playerid][Vida] = db_get_field_assoc_int(R,"Vida");
Cuenta[playerid][Chaleco] = db_get_field_assoc_int(R,"Chaleco");
Cuenta[playerid][Vip]? ? ? = db_get_field_assoc_int(R,"Vip");
? ? Cuenta[playerid][Muteado]? = db_get_field_assoc_int(R,"Muteado");
? ? Cuenta[playerid][Genero] = db_get_field_assoc_int(R,"Genero");
? ? Cuenta[playerid][PosX] = db_get_field_assoc_float(R, "PosX");
? ? Cuenta[playerid][PosY] = db_get_field_assoc_float(R, "PosY");
? ? Cuenta[playerid][PosZ] = db_get_field_assoc_float(R, "PosZ");
? format(query,sizeof(query),"~y~%s~n~~b~usted Ingreso con exito.",Nombre(playerid));
GameTextForPlayer(playerid,query,4000,5);
Cuenta[playerid][Ingreso] = true;
Cuenta[playerid][NewSpawn] = false;
}else return ShowPlayerDialog(playerid,DIALOGO_INGRESO,DIALOG_STYLE_PASSWORD,""GRISCLARO"? "AZULMARINO"Bienvenido de nuevo al servidor",""TURQUESA"Escribe tu contrase?a para ingresar al servidor.\n"ROJO"La contrase?a que has ingresado es incorrecta.",""TURQUESA"Ingresar",""ROJO"Salir");
db_free_result(R);
}}
if(dialogid == DIALOGO_REGISTRO)
{
if(!response)Kick(playerid);
if(response)
{
if(strlen(inputtext) < 4 || strlen(inputtext) > 32) return ShowPlayerDialog(playerid,DIALOGO_REGISTRO,DIALOG_STYLE_INPUT,""GRISCLARO"? "AZULMARINO"Bienvenido al servidor",""ROJO"Escribe tu contrase?a para poder guardar tus datos.",""TURQUESA"Registrar",""ROJO"Salir");
ShowPlayerDialog(playerid, DIALOGO_GENERO, DIALOG_STYLE_MSGBOX, ""GRISCLARO"? "AZULMARINO"?Excelente!",""ROJO"Selecciona tu genero para poder continuar.", "Hombre", "Mujer");
new query[(144�)];
format(query,sizeof(query),"INSERT INTO usuarios (Nombre,Llave,Dinero,NivelStaff,Vip,Nivel,Muteado,PosX,PosY,PosZ) VALUES ('%s','%s','0','0','0','0','0','0', '0', '0')",Nombre(playerid),inputtext);
db_query(sqldb,query);
format(query,sizeof(query),"~y~%s~n~~b~usted fue registrado con exito.",Nombre(playerid));
GameTextForPlayer(playerid,query,4000,5);
Cuenta[playerid][Ingreso] = true;
Cuenta[playerid][NewSpawn] = true;
}
}
if(dialogid == DIALOGO_GENERO)
{
if(!response)Kick(playerid);
if(!response)
{
new query[60];
format(query,sizeof(query),"INSERT INTO usuarios (Genero) VALUES ('1')");
Cuenta[playerid][Genero] = 1;
}
else
{
new query[60];
format(query,sizeof(query),"INSERT INTO usuarios (Genero) VALUES ('0')");
Cuenta[playerid][Genero] = 0;
}
}
return 1;
}
// Evitar bugs //
public OnPlayerRequestSpawn(playerid)
{
if(Cuenta[playerid][Ingreso] == false)
{
GameTextForPlayer(playerid,"~r~~n~~n~Primero debes ingresar/registrarte.",2000,5);
return 0;
}
return 1;
}
public OnPlayerUpdate(playerid)
{
if(GetPlayerMoney(playerid) != Cuenta[playerid][Dinero])
{
ResetPlayerMoney(playerid);
GivePlayerMoney(playerid,Cuenta[playerid][Dinero]);
}
if(GetPlayerScore(playerid) != Cuenta[playerid][Nivel])
{
SetPlayerScore(playerid,Cuenta[playerid][Nivel]);
}
if(IsPlayerAdmin(playerid) && !TienePermisos(playerid))
{
new msg[(57)];
format(msg,sizeof(msg),"%s fue expulsado por ingresar a la rcon sin autorizaci?n.",Nombre(playerid));
SendClientMessageToAll(-1,msg);
Kick(playerid);
}
return 1;
}
public OnPlayerSpawn(playerid)
{
if(Cuenta[playerid][NewSpawn] == false)
{
SetPlayerPos(playerid, Cuenta[playerid][PosX], Cuenta[playerid][PosY], Cuenta[playerid][PosZ]);
SetPlayerInterior(playerid, 0);
}
else
{
new posal = random(3);
switch(posal)
{
case 0: SetPlayerPos(playerid, 1682.7462,-2292.2656,13.5168);
case 1: SetPlayerPos(playerid, 1663.3788,-2286.2458,5.2656);
case 2: SetPlayerPos(playerid, 1682.0084,-2286.5540,-1.2325);
}
SetPlayerInterior(playerid, 0);
}
return 1;
}
// GuardarCuentas //
public GuardarCuentas()
{
for(new i=0;i<MAX_PLAYERS;i)
{
if(IsPlayerConnected(i))
{
GuardarCuenta(i);
}
}
return 1;
}
// Restablecer datos por defecto //
stock ReiniciarD(playerid)
{
Cuenta[playerid][Ingreso]? = false;
Cuenta[playerid][ID] = -1;
Cuenta[playerid][Dinero]? ? = 0;
Cuenta[playerid][Vida] = 0;
Cuenta[playerid][Chaleco] = 0;
Cuenta[playerid][NivelStaff]? ? = 0;
Cuenta[playerid][Vip]? ? ? = 0;
Cuenta[playerid][Nivel]? ? = 0;
Cuenta[playerid][Muteado]? = 0;
Cuenta[playerid][Genero] = 0;
Cuenta[playerid][PosX] = 0.0;
Cuenta[playerid][PosY] = 0.0;
Cuenta[playerid][PosZ] = 0.0;
}
// Verificar si la Cuenta existe //
stock CuentaExistente(name[])
{
new query[(42)];
format(query,sizeof(query),"SELECT * FROM usuarios WHERE Nombre = '%s'",name);
new DBResult:R = db_query(sqldb,query);
if(db_num_rows(R))
{
return true;
}
db_free_result(R);
return false;
}
// Escape //
stock DB_Escape(text[]){
new ret[80 * 2],
ch,
i,
j;
while ((ch = text[i]) && j < sizeof (ret))
{
if (ch == '\'')
{
if (j < sizeof (ret) - 2)
{
ret[j] = '\'';
ret[j] = '\'';
}
}
else if (j < sizeof (ret))
{
ret[j] = ch;
}
else
{
j;
}
}
ret[sizeof (ret) - 1] = '\0';
return ret;
}
stock Nombre(playerid)
{
new name[24];
GetPlayerName(playerid,name,sizeof(name));
return name;
}
stock GuardarCuenta(playerid)
{
if(CuentaExistente(Nombre(playerid)))
{
new query[400];
format(query,sizeof(query),"UPDATE usuarios SET Nivel = '%d', Dinero = '%d', NivelStaff = '%d', Vip = '%d', Muteado = '%d', PosX = '%f', PosY = '%f' PosZ = '%f' WHERE Nombre = '%s'",Cuenta[playerid][Nivel],Cuenta[playerid][Dinero],Cuenta[playerid][NivelStaff],Cuenta[playerid][Vip],Cuenta[playerid][Muteado],Cuenta[playerid][PosX],Cuenta[playerid][PosY],Cuenta[playerid][PosZ],Nombre(playerid));
db_query(sqldb,query);
}
}
}
Los logs:
PHP Code: [15:43:41] [db_log_queries]: CREATE TABLE IF NOT EXISTS `usuarios` (ID INTEGER PRIMARY KEY AUTOINCREMENT, Nombre TEXT, Llave TEXT, Nivel NUMERIC, NivelStaff NUMERIC, Vip NUMERIC, Muteado NUMERIC, Vida NUMERIC, Chaleco NUMERIC, Dinero NUMERIC, Genero NUMERIC, PosX FLOAT, PosY FLOAT, PosZ FLOAT)
[15:43:41] Nova Roleplay.
[15:43:41] Number of vehicle models: 0
[15:44:34] [connection] 127.0.0.1:61684 requests connection cookie.
[15:44:35] [connection] incoming connection: 127.0.0.1:61684 id: 0
[15:44:35] [join] Phillip_Blackstone has joined the server (0:127.0.0.1)
[15:44:35] [db_log_queries]: SELECT * FROM usuarios WHERE Nombre = 'Phillip_Blackstone' COLLATE NOCASE
[15:44:39] [db_log_queries]: INSERT INTO usuarios (Nombre,Llave,Dinero,NivelStaff,Vip,Nivel,Muteado,PosX,PosY,PosZ) VALUES ('Phillip_Blackstone','20061219','0','0','0','0','0','0', '0', '0')
[15:44:54] [db_log_queries]: SELECT * FROM usuarios WHERE Nombre = 'Phillip_Blackstone'
[15:44:54] [db_log_queries]: UPDATE usuarios SET Nivel = '0', Dinero = '0', NivelStaff = '0', Vip = '0', Muteado = '0', PosX = '1668.851074', PosY = '-2242.367187' PosZ = '7.907007' WHERE Nombre = 'Phillip_Blackstone'
[15:44:54] [part] Phillip_Blackstone has left the server (0:1)
[15:45:47] [connection] 127.0.0.1:63435 requests connection cookie.
[15:45:48] [connection] incoming connection: 127.0.0.1:63435 id: 0
[15:45:48] [join] Phillip_Blackstone has joined the server (0:127.0.0.1)
[15:45:48] [db_log_queries]: SELECT * FROM usuarios WHERE Nombre = 'Phillip_Blackstone' COLLATE NOCASE
[15:45:51] [db_log_queries]: SELECT * FROM usuarios WHERE Nombre = 'Phillip_Blackstone'
[15:45:51] [db_log_queries]: UPDATE usuarios SET Nivel = '0', Dinero = '0', NivelStaff = '0', Vip = '0', Muteado = '0', PosX = '0.000000', PosY = '0.000000' PosZ = '0.000000' WHERE Nombre = 'Phillip_Blackstone'
[15:45:59] [db_log_queries]: SELECT * FROM usuarios WHERE Nombre = 'Phillip_Blackstone' AND Llave = '20061219' COLLATE NOCASE
[15:46:06] [db_log_queries]: SELECT * FROM usuarios WHERE Nombre = 'Phillip_Blackstone'
[15:46:06] [db_log_queries]: UPDATE usuarios SET Nivel = '0', Dinero = '0', NivelStaff = '0', Vip = '0', Muteado = '0', PosX = '0.000000', PosY = '0.000000' PosZ = '-87.565048' WHERE Nombre = 'Phillip_Blackstone'
[15:46:06] [part] Phillip_Blackstone has left the server (0:1)
|
|
|
|
| OnPlayerEditDynamicObject |
|
Posted by: JaKe Elite - 2020-11-07, 01:46 PM - Forum: Support
- Replies (1)
|
|
OnPlayerEditDynamicObject acts weird, randomly saving / cancelling the player's object edit session. OnPlayerEditAttachedObject is affected as well.
Any clue or hints on what might cause this?
|
|
|
|
| How to save message with custom color to database? |
|
Posted by: Zow - 2020-11-06, 06:04 PM - Forum: Pawn Scripting
- Replies (7)
|
|
PHP Code: CMD:save(playerid, params[])
{
? ? new message[100];
? ? sscanf(params, "s[100]", message);
? ? format(PlayerInfo[playerid][pMessage], 100, message);
SaveMessage(playerid);
? ? return 1;
}
CMD:show(playerid, params[])
{
? ? new string[100];
? ? if (!strcmp(PlayerInfo[playerid][pMessage], "None", true))
? ? ? ? ?return SendClientMessage(playerid, COLOR_YELLOW, "No message");
? ? format(string, sizeof string, "%s", PlayerInfo[playerid][pMessage]);
? ? SendClientMessage(playerid, COLOR_WHITE, string);
? ? return 1;
}
SaveMessage(playerid)
{
new query[256];
mysql_format(dbCon, query, sizeof(query), "UPDATE `players` SET `MessageText` = '%e' WHERE `ID` = '%d'",
PlayerInfo[playerid][pMessage],
PlayerInfo[playerid][pSQLID]);
mysql_tquery(dbCon, query);
return 1;
}
/save {F60000}Message {FFFFFF}Message
But its only save Message?Message?
This is what I want
![[Image: unknown.png]](https://media.discordapp.net/attachments/483912132207968260/774332655936339978/unknown.png)
|
|
|
|
|
