13.09.2016, 04:57
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.
Y esto es lo que me muestra el mysql_log cuando la uso.
Код:
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;
}
Код:
[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
