[ERROR] ID: 1064 - Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`Misiones' at line 1 - Callback - OnQueryFinish - Query: UPDATE `usuarios` SET `Dinero`='45745', `Nivel`='3', `Nivel VIP`='4', `Nivel administrativo`='3', `Jails`='0', `Kicks`='0', `Muertes`='0', `Asesinatos`='0', `Pildoras`='10', `Advertencias`='0', `Horas jugadas`='0', `Puede loguear`='0', `Misiones ganadas`='0', `Misiones
new Query[270];
format(Query,sizeof(Query),"UPDATE `usuarios` SET `Dinero`='%d', `Nivel`='%d', `Nivel VIP`='%d', `Nivel administrativo`='%d', `Jails`='%d', `Kicks`='%d', `Muertes`='%d', `Asesinatos`='%d', `Pildoras`='%d', `Advertencias`='%d', `Horas jugadas`='%d', `Puede loguear`='%d', `Misiones ganadas`='%d', `Misiones fallidas`='%d', `Carreras ganadas`='%d', `Vehiculos robados`='%d', `Bombas plantadas`='%d', `Supervivencias ganadas`='%d' WHERE `Nombre`='%s'",
GetPlayerMoney(playerid),GetPlayerScore(playerid),GetPVarInt(playerid,"VIP"),GetPVarInt(playerid,"Admin"),GetPVarInt(playerid,"Jails"),GetPVarInt(playerid,"Kicks"),GetPVarInt(playerid,"Muertes"),GetPVarInt(playerid,"Asesinatos"),GetPVarInt(playerid,"Pildoras"),GetPVarInt(playerid,"Advs"),GetPVarInt(playerid,"Horas"),GetPVarInt(playerid,"Puede"),GetPVarInt(playerid,"MGanadas"),GetPVarInt(playerid,"MFallidas"),GetPVarInt(playerid,"CGanadas"),
GetPVarInt(playerid,"Robados"),GetPVarInt(playerid,"Bombas"),GetPVarInt(playerid,"Supervivencias"),Nombre[playerid]);
mysql_function_query(Conexion,Query,true,"OnQueryFinish","ii",0,playerid);
return 1;
new Query[270];
format(Query,sizeof(Query),"UPDATE `usuarios` SET Dinero='%d', Nivel='%d', Nivel VIP='%d', Nivel administrativo='%d', Jails='%d', Kicks='%d', Muertes='%d', Asesinatos='%d', Pildoras='%d', Advertencias='%d', Horas jugadas='%d', Puede loguear='%d', Misiones ganadas='%d', Misiones fallidas='%d', Carreras ganadas='%d', Vehiculos robados='%d', Bombas plantadas='%d', Supervivencias ganadas='%d' WHERE `Nombre`='%s'",
GetPlayerMoney(playerid),GetPlayerScore(playerid),GetPVarInt(playerid,"VIP"),GetPVarInt(playerid,"Admin"),GetPVarInt(playerid,"Jails"),GetPVarInt(playerid,"Kicks"),GetPVarInt(playerid,"Muertes"),GetPVarInt(playerid,"Asesinatos"),GetPVarInt(playerid,"Pildoras"),GetPVarInt(playerid,"Advs"),GetPVarInt(playerid,"Horas"),GetPVarInt(playerid,"Puede"),GetPVarInt(playerid,"MGanadas"),GetPVarInt(playerid,"MFallidas"),GetPVarInt(playerid,"CGanadas"),
GetPVarInt(playerid,"Robados"),GetPVarInt(playerid,"Bombas"),GetPVarInt(playerid,"Supervivencias"),Nombre[playerid]);
mysql_function_query(Conexion,Query,true,"OnQueryFinish","ii",0,playerid);
return 1;
new Query[512];
El query usas muchos caracteres con 270 no te alcanza, cambiale a 512.
pawn Код:
|