MySQl SavePlayerData error - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (
https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQl SavePlayerData error (
/showthread.php?tid=230027)
MySQl SavePlayerData error -
exDDDD - 22.02.2011
error
Код:
[19:16:27] MySQL Debugging activated (02/21/11)
[19:16:27] ---------------------------
[19:16:27]
[19:47:32] >> mysql_real_escape_string( Connection handle: 1 )
[19:47:32] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD.
[19:47:32] >> mysql_query( Connection handle: 1 )
[19:47:32] CMySQLHandler::Query(SELECT id FROM players WHERE LOWER(username) = LOWER('exDDD') LIMIT 1) - Successfully executed.
[19:47:32] >> mysql_store_result( Connection handle: 1 )
[19:47:32] CMySQLHandler::StoreResult() - Result was stored.
[19:47:32] >> mysql_num_rows( Connection handle: 1 )
[19:47:32] CMySQLHandler::NumRows() - Returned 0 row(s)
[19:47:37] >> mysql_real_escape_string( Connection handle: 1 )
[19:47:37] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD.
[19:47:37] >> mysql_real_escape_string( Connection handle: 1 )
[19:47:37] CMySQLHandler::EscapeString(******); - Escaped 6 characters to ******.
[19:47:37] >> mysql_query( Connection handle: 1 )
[19:47:37] CMySQLHandler::Query(INSERT INTO players (username, password) VALUES ('exDDD', '******')) - Successfully executed.
[19:47:38] >> mysql_query( Connection handle: 1 )
[19:47:38] CMySQLHandler::Query(SELECT Password FROM players WHERE id = 0 LIMIT 1) - Successfully executed.
[19:47:38] >> mysql_store_result( Connection handle: 1 )
[19:47:38] CMySQLHandler::StoreResult() - Result was stored.
[19:47:38] >> mysql_fetch_row_format( Connection handle: 1 )
[19:47:39] >> mysql_query( Connection handle: 1 )
[19:47:39] CMySQLHandler::Query(SELECT Password FROM players WHERE id = 0 LIMIT 1) - Successfully executed.
[19:47:39] >> mysql_store_result( Connection handle: 1 )
[19:47:39] CMySQLHandler::StoreResult() - Result was stored.
[19:47:39] >> mysql_fetch_row_format( Connection handle: 1 )
[19:47:39] >> mysql_query( Connection handle: 1 )
[19:47:39] CMySQLHandler::Query(SELECT * FROM players WHERE id = 0 LIMIT 1) - Successfully executed.
[19:47:39] >> mysql_store_result( Connection handle: 1 )
[19:47:39] CMySQLHandler::StoreResult() - Result was stored.
[19:47:39] >> mysql_fetch_row_format( Connection handle: 1 )
[19:47:39] >> mysql_free_result( Connection handle: 1 )
[19:47:39] CMySQLHandler::FreeResult() - Result was successfully free'd.
[19:49:28] >> mysql_query( Connection handle: 1 )
[19:49:28] CMySQLHandler::Query(UPDATE `players` SET `Level` = '1', `AdminLevel` = '0', `DonateRank` = '0', `PointsUpgrade` = '0', `ConnectTime` = '101', `Reg` = '77', `Sex` = '77' WHERE `username` = 'Multiple users found, please narrow earch';) - Successfully executed.
[19:50:07] >> mysql_query( Connection handle: 1 )
[19:50:07] CMySQLHandler::Query(UPDATE `players` SET `Level` = '1', `AdminLevel` = '0', `DonateRank` = '0', `PointsUpgrade` = '0', `ConnectTime` = '101', `Reg` = '77', `Sex` = '77' WHERE `username` = 'Multiple users found, please narrow earch';) - Successfully executed.
[19:55:20] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[19:55:20] CMySQLHandler::FreeResult() - The result is already empty.
[19:55:20] CMySQLHandler::Disconnect() - Connection was closed.
pawn Код:
public SavePlayerData(playerid)
{
if(gPlayerLogged[playerid])
{
new query[MAX_STRING];
PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0))
{
PlayerInfo[playerid][pPos_x] = 1684.9;
PlayerInfo[playerid][pPos_y] = -2244.5;
PlayerInfo[playerid][pPos_z] = 13.5;
}
format(query, MAX_STRING, "UPDATE `players` SET `Level` = '%d', `AdminLevel` = '%d', `DonateRank` = '%d', `PointsUpgrade` = '%d', `ConnectTime` = '%d', `Reg` = '%d', `Sex` = '%d' WHERE `username` = '%s';", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][gPupgrade], ReturnName(playerid));
mysql_query(query);
}
return 1;
}