16.09.2011, 14:27
pawn Код:
new rBit1: IsPlayerLogged <MAX_PLAYERS>;
debug:
pawn Код:
[16:27:57] >> mysql_connect( )
[16:27:57] CMySQLHandler::CMySQLHandler() - constructor called.
[16:27:57] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sa:mp" | Username: "root" ...
[16:27:57] CMySQLHandler::Connect() - Connection was successful.
[16:27:57] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[16:27:57] >> mysql_query( Connection handle: 1 )
[16:27:57] CMySQLHandler::Query(SELECT * FROM `house` WHERE `HouseID` = '0' LIMIT 1) - Successfully executed.
[16:27:57] >> mysql_store_result( Connection handle: 1 )
[16:27:57] CMySQLHandler::StoreResult() - Result was stored.
[16:27:57] >> mysql_num_rows( Connection handle: 1 )
[16:27:57] CMySQLHandler::NumRows() - Returned 1 row(s)
[16:27:57] >> mysql_fetch_row_format( Connection handle: 1 )
[16:27:57] CMySQLHandler::FetchRow() - Return: None|-2521.331542|-623.472229|132.771697|1527.22998|-11.574499|1002.097106|3|1000|0|0
[16:27:57] >> mysql_free_result( Connection handle: 1 )
[16:27:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:27:57] >> mysql_free_result( Connection handle: 1 )
[16:27:57] CMySQLHandler::FreeResult() - The result is already empty.
[16:27:57] >> mysql_query( Connection handle: 1 )
[16:27:57] CMySQLHandler::Query(SELECT * FROM `house` WHERE `HouseID` = '2' LIMIT 1) - Successfully executed.
[16:27:57] >> mysql_store_result( Connection handle: 1 )
[16:27:57] CMySQLHandler::StoreResult() - Result was stored.
[16:27:57] >> mysql_num_rows( Connection handle: 1 )
[16:27:57] CMySQLHandler::NumRows() - Returned 1 row(s)
[16:27:57] >> mysql_fetch_row_format( Connection handle: 1 )
[16:27:57] CMySQLHandler::FetchRow() - Return: None|-2504.253662|-624.849975|132.722702|2350.339843|-1181.649902|1027.976562|5|15000|2|2
[16:27:57] >> mysql_free_result( Connection handle: 1 )
[16:27:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:27:57] >> mysql_free_result( Connection handle: 1 )
[16:27:57] CMySQLHandler::FreeResult() - The result is already empty.
[16:27:57] >> mysql_query( Connection handle: 1 )
[16:27:57] CMySQLHandler::Query(SELECT * FROM `house` WHERE `HouseID` = '1' LIMIT 1) - Successfully executed.
[16:27:57] >> mysql_store_result( Connection handle: 1 )
[16:27:57] CMySQLHandler::StoreResult() - Result was stored.
[16:27:57] >> mysql_num_rows( Connection handle: 1 )
[16:27:57] CMySQLHandler::NumRows() - Returned 1 row(s)
[16:27:57] >> mysql_fetch_row_format( Connection handle: 1 )
[16:27:57] CMySQLHandler::FetchRow() - Return: None|-2514.513916|-631.377807|134.059402|2324.419921|-1145.568359|1050.710083|12|5000|1|1
[16:27:57] >> mysql_free_result( Connection handle: 1 )
[16:27:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:27:57] >> mysql_free_result( Connection handle: 1 )
[16:27:57] CMySQLHandler::FreeResult() - The result is already empty.
[16:28:09] >> mysql_real_escape_string( Connection handle: 1 )
[16:28:09] CMySQLHandler::EscapeString(Tony_Stark); - Escaped 10 characters to Tony_Stark.
[16:28:09] >> mysql_query_callback( Connection handle: 1 )
[16:28:09] CMySQLHandler::Query("sOnQueryFinish") - Custom callback query with index 102 started (ExtraID: 0)
[16:28:09] >> mysql_real_escape_string( Connection handle: 1 )
[16:28:09] CMySQLHandler::EscapeString(Tony_Stark); - Escaped 10 characters to Tony_Stark.
[16:28:09] >> mysql_query( Connection handle: 1 )
[16:28:09] CMySQLHandler::Query(SELECT * FROM `racuni` WHERE `Korisnik` = 'Tony_Stark' LIMIT 1) - Successfully executed.
[16:28:09] >> mysql_store_result( Connection handle: 1 )
[16:28:09] CMySQLHandler::StoreResult() - Result was stored.
[16:28:09] >> mysql_num_rows( Connection handle: 1 )
[16:28:09] CMySQLHandler::NumRows() - Returned 1 row(s)
[16:28:09] >> mysql_free_result( Connection handle: 1 )
[16:28:09] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:28:09] CMySQLHandler::ProcessQueryThread(SELECT * FROM `bans` WHERE Banned = 'Tony_Stark') - Data is getting passed to sOnQueryFinish() - (Threadsafe: Yes)
[16:28:09] sOnQueryFinish(102,"SELECT * FROM `bans` WHERE Banned = 'Tony_Stark'") - Called.
[16:28:09] >> mysql_store_result( Connection handle: 1 )
[16:28:09] CMySQLHandler::StoreResult() - Result was stored.
[16:28:09] >> mysql_num_rows( Connection handle: 1 )
[16:28:09] CMySQLHandler::NumRows() - Returned 0 row(s)
[16:28:09] >> mysql_free_result( Connection handle: 1 )
[16:28:09] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:28:11] >> mysql_real_escape_string( Connection handle: 1 )
[16:28:11] CMySQLHandler::EscapeString(Tony_Stark); - Escaped 10 characters to Tony_Stark.
[16:28:11] >> mysql_query( Connection handle: 1 )
[16:28:11] CMySQLHandler::Query(SELECT * FROM `racuni` WHERE `Korisnik` = 'Tony_Stark' AND `Lozinka` = 'pass' LIMIT 1) - Successfully executed.
[16:28:11] >> mysql_store_result( Connection handle: 1 )
[16:28:11] CMySQLHandler::StoreResult() - Result was stored.
[16:28:11] >> mysql_num_rows( Connection handle: 1 )
[16:28:11] CMySQLHandler::NumRows() - Returned 1 row(s)
[16:28:11] >> mysql_fetch_row_format( Connection handle: 1 )
[16:28:11] CMySQLHandler::FetchRow() - Return: Tony_Stark|pass|0|0|0|0|0|0|0|0|0|192.168.1.233
[16:28:11] >> mysql_free_result( Connection handle: 1 )
[16:28:11] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:28:46] >> mysql_real_escape_string( Connection handle: 1 )
[16:28:46] CMySQLHandler::EscapeString(Tony_Stark); - Escaped 10 characters to Tony_Stark.
[16:28:46] >> mysql_query( Connection handle: 1 )
[16:28:46] CMySQLHandler::Query(UPDATE `racuni` SET `Bodovi` = 0, `Novac` = 0, `Ubojstva` = 0, `Smrti` = 0, `Code` = 0, `Warns` = 0, `Online` = 0, `VIP` = 0, `Admin` = 0 WHERE `Korisnik` = 'Tony_Stark') - Successfully executed.
[16:28:46] >> mysql_free_result( Connection handle: 1 )
[16:28:46] CMySQLHandler::FreeResult() - The result is already empty.
Also I don't understand this
pawn Код:
[16:28:46] CMySQLHandler::Query(UPDATE `racuni` SET `Bodovi` = 0, `Novac` = 0, `Ubojstva` = 0, `Smrti` = 0, `Code` = 0, `Warns` = 0, `Online` = 0, `VIP` = 0, `Admin` = 0 WHERE `Korisnik` = 'Tony_Stark') - Successfully executed.