їPor quй este error en la consola? MYSQL.
#1

Код:
CALLBACK: SaveAccount(playerid)
{
	GetPlayerPos(playerid, PlayerInfo[playerid][pPosX], PlayerInfo[playerid][pPosY], PlayerInfo[playerid][pPosZ]);
	GetPlayerHealth(playerid, PlayerInfo[playerid][pVida]), GetPlayerArmour(playerid, PlayerInfo[playerid][pChaleco]);
    format(Query, 200, "UPDATE `ev_cuentas` SET `Vida`='%f', `Chaleco`='%f', `Administrador`='%d', `Nivel`='%d', `PosX`='%f', `PosY`='%f', `PosZ`='%f', `Edad`='%d' WHERE `Nombre`='%s'", PlayerInfo[playerid][pVida], PlayerInfo[playerid][pChaleco],
    PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pNivel], PlayerInfo[playerid][pPosX], PlayerInfo[playerid][pPosY], PlayerInfo[playerid][pPosZ], PlayerInfo[playerid][pEdad], NombreJugador(playerid));
    mysql_function_query(TuberiaMYSQL, Query, true, "OnQueryFinish", "ii", 0, playerid);
    return 1;
}
Error: [14:26:25] [ERROR] ID: 1064 - Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 - Callback - OnQueryFinish - Query: UPDATE ev_cuentas SET Vida = 100.000000, Chaleco = 0.000000, Administrador = 0, Nivel = 1, `PosX = 1642.410034, PosY= -2329.688964, PosZ =14.036091, Edad = 20 WHERE Nombre = Gonzalo2
Reply
#2

Creo que es por las pocas celdas
Reply
#3

Aumenta el buffer del query

Quote:

format(Query, 512, "UPDATE `ev_cuentas` SET `Vida`='%f', `Chaleco`='%f', `Administrador`='%d', `Nivel`='%d', `PosX`='%f', `PosY`='%f', `PosZ`='%f', `Edad`='%d' WHERE `Nombre`='%s'", PlayerInfo[playerid][pVida], PlayerInfo[playerid][pChaleco],
PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pNivel], PlayerInfo[playerid][pPosX], PlayerInfo[playerid][pPosY], PlayerInfo[playerid][pPosZ], PlayerInfo[playerid][pEdad], NombreJugador(playerid));

Reply
#4

Quote:
Originally Posted by Eloy
Посмотреть сообщение
Aumenta el buffer del query
Gracias.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)