їPor quй no guarda el jugador? MYSQL.
#1

Buenas, los datos del jugador siempre se estбn quedando de 0 cuando quiero guardar las cuentas y hay informaciуn en el mysql_log, asн es mi funciуn.

Код:
CALLBACK: ActualizarJugador(playerid)
{
    new Query[512];
    if(GetPlayerState(playerid) != PLAYER_STATE_SPECTATING)
    {
        GetPlayerPos(playerid, InformacionJugador_[playerid][pPos][0], InformacionJugador_[playerid][pPos][1], InformacionJugador_[playerid][pPos][2]);
        InformacionJugador_[playerid][pInterior] = GetPlayerInterior(playerid), InformacionJugador_[playerid][pVirtualWorld] = GetPlayerVirtualWorld(playerid);
    }
    format(Query, sizeof(Query), "UPDATE users SET PosX = %f, PosY = %f, PosZ = %f, Skin = %d, Dinero = %d, Nivel = %d, Interior = %d, VirtualWorld = %d WHERE SQLID = %d", InformacionJugador_[playerid][pPos][0], InformacionJugador_[playerid][pPos][1],
	InformacionJugador_[playerid][pPos][2], InformacionJugador_[playerid][pSkin], InformacionJugador_[playerid][pDinero], InformacionJugador_[playerid][pNivel], InformacionJugador_[playerid][pInterior], InformacionJugador_[playerid][pVirtualWorld],
	InformacionJugador_[playerid][pSQLID]);
	mysql_query(MySQL, Query);
    return 1;
}
Y esto es lo que me muestra el mysql_log cuando la uso.

Код:
[07:37:16 09/14/16] [DEBUG] mysql_format - connection: 1, len: 260, format: "INSERT INTO users (`Usuario`, `Password`, `Salt`) VALUES ('%e', '%e', '%e')"
[07:37:16 09/14/16] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO ev_cuentas (`Usuario`, `Password`, `Salt`) VALUES ('", callback: "(null)", format: "(null)"
[07:37:16 09/14/16] [DEBUG] cache_insert_id - connection: 1
[07:37:16 09/14/16] [WARNING] cache_insert_id - no active cache
[07:37:16 09/14/16] [DEBUG] mysql_format - connection: 1, len: 100, format: "UPDATE users SET Dinero = '%d' WHERE SQLID = '%d'"
[07:37:16 09/14/16] [ERROR] mysql_format - no value for specifier "%d" available
[07:37:16 09/14/16] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE ev_cuentas SET Dinero = '0' WHERE SQLID = ''", callback: "(null)", format: "(null)"
[07:37:16 09/14/16] [DEBUG] mysql_query - connection: 1, query: "UPDATE users SET PosX = 0.000000, PosY = 0.000000, PosZ = 0", use_cache: true
[07:37:16 09/14/16] [DEBUG] CMySQLQuery::Execute - starting query execution
[07:37:16 09/14/16] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.847 milliseconds
[07:37:16 09/14/16] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[07:37:16 09/14/16] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[07:37:16 09/14/16] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[07:37:16 09/14/16] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 90.197 milliseconds
[07:37:16 09/14/16] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[07:37:16 09/14/16] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[07:37:16 09/14/16] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.333 milliseconds
[07:37:16 09/14/16] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
Reply


Messages In This Thread
їPor quй no guarda el jugador? MYSQL. - by Fagrinht - 13.09.2016, 04:57
Re: їPor quй no guarda el jugador? MYSQL. - by N3cromancer - 13.09.2016, 20:51
Respuesta: Re: їPor quй no guarda el jugador? MYSQL. - by Fagrinht - 14.09.2016, 03:29
Respuesta: їPor quй no guarda el jugador? MYSQL. - by Eloy - 06.10.2016, 03:59
Respuesta: їPor quй no guarda el jugador? MYSQL. - by Fagrinht - 06.10.2016, 17:49

Forum Jump:


Users browsing this thread: 1 Guest(s)