[losrivarola98]

Me sale este error en una consulta en OnQueryFinish:

Код:

[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

Lineas en el pawn:

pawn Код:

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;

[ReyMysterio]

Cambie al presente Cуdigo

pawn Код:

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;

[Daniel-92]

El query usas muchos caracteres con 270 no te alcanza, cambiale a 512.

pawn Код:

new Query[512];

[losrivarola98]

Quote:

Originally Posted by Daniel-92 El query usas muchos caracteres con 270 no te alcanza, cambiale a 512. pawn Код: new Query[512];

Muchisimas gracias a ti