[exDDDD]

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;
}