30.12.2012, 21:02
NOANY, still 0 D:
pawn Код:
[22:17:49]
[22:17:49] ---------------------------
[22:17:49] MySQL Debugging activated (12/30/12)
[22:17:49] ---------------------------
[22:17:49]
[22:17:49] >> mysql_connect( )
[22:17:49] CMySQLHandler::CMySQLHandler() - constructor called.
[22:17:49] CMySQLHandler::CMySQLHandler() - Connecting to "XXX.XX.XX.XXX" | DB: "XXXXXX_XXXX" | Username: "8060_bcrp" ...
[22:17:50] CMySQLHandler::Connect() - Connection was successful.
[22:17:50] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[22:17:50] >> mysql_ping( Connection handle: 1 )
[22:17:50] CMySQLHandler::Ping() - Connection is still alive.
[22:17:50] >> mysql_query( Connection handle: 1 )
[22:17:50] CMySQLHandler::Query(resultID) - Threaded query with id 100 started. (Extra ID: 0)
[22:17:50] >> mysql_connect( )
[22:17:50] CMySQLHandler::Connect() - Connection was successful.
[22:17:50] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[22:17:50] CMySQLHandler::ProcessQueryThread(CREATE TABLE IF NOT EXISTS `samp_ban` (`BanID` int(6) NOT NULL AUTO_INCREMENT,`user_banned` varchar(24) NOT NULL,`user_banned_ip` varchar(15) NOT NULL,`user_banner` varchar(24) NOT NULL,`ban_reason` varchar(40) NOT NULL,`ban_timestamp` timestamp NOT NULL,`ban_time` int(10) NOT NULL,PRIMARY KEY (`BanID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)
[22:17:50] OnQueryFinish(100,"CREATE TABLE IF NOT EXISTS `samp_ban` (`BanID` int(6) NOT NULL AUTO_INCREMENT,`user_banned` varchar(24) NOT NULL,`user_banned_ip` varchar(15) NOT NULL,`user_banner` varchar(24) NOT NULL,`ban_reason` varchar(40) NOT NULL,`ban_timestamp` timestamp NOT NULL,`ban_time` int(10) NOT NULL,PRIMARY KEY (`BanID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;") - Called.
[22:18:24] >> mysql_query_callback( Connection handle: 1 )
[22:18:24] CMySQLHandler::Query("jban_OnQueryFinish") - Custom callback query with index 102 started (ExtraID: 0)
[22:18:24] >> mysql_real_escape_string( Connection handle: 1 )
[22:18:24] CMySQLHandler::EscapeString(Oscii_Shively); - Escaped 13 characters to Oscii_Shively.
[22:18:24] >> mysql_query( Connection handle: 1 )
[22:18:24] CMySQLHandler::ProcessQueryThread(SELECT user_banner, ban_reason, TIMESTAMPDIFF(MINUTE, NOW(), DATE_ADD(ban_timestamp, INTERVAL ban_time MINUTE)) FROM `samp_ban` WHERE user_banned_ip = '192.168.0.3' AND (NOW() <= DATE_ADD(ban_timestamp, INTERVAL ban_time MINUTE) OR ban_time = 0)) - Data is getting passed to jban_OnQueryFinish() - (Threadsafe: Yes)
[22:18:24] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: 0)
[22:18:24] jban_OnQueryFinish(102,"SELECT user_banner, ban_reason, TIMESTAMPDIFF(MINUTE, NOW(), DATE_ADD(ban_timestamp, INTERVAL ban_time MINUTE)) FROM `samp_ban` WHERE user_banned_ip = '192.168.0.3' AND (NOW() <= DATE_ADD(ban_timestamp, INTERVAL ban_time MINUTE) OR ban_time = 0)") - Called.
[22:18:24] >> mysql_store_result( Connection handle: 1 )
[22:18:24] CMySQLHandler::StoreResult() - Result was stored.
[22:18:24] >> mysql_num_rows( Connection handle: 1 )
[22:18:24] CMySQLHandler::NumRows() - Returned 0 row(s)
[22:18:24] >> mysql_free_result( Connection handle: 1 )
[22:18:24] CMySQLHandler::FreeResult() - Result was successfully free'd.
[22:18:24] CMySQLHandler::ProcessQueryThread(SELECT * FROM players WHERE Username = 'Oscii_Shively') - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)
[22:18:24] OnQueryFinish(1,"SELECT * FROM players WHERE Username = 'Oscii_Shively'") - Called.
[22:18:24] >> mysql_store_result( Connection handle: 1 )
[22:18:24] CMySQLHandler::StoreResult() - Result was stored.
[22:18:24] >> mysql_num_rows( Connection handle: 1 )
[22:18:24] CMySQLHandler::NumRows() - Returned 1 row(s)
[22:18:24] >> mysql_retrieve_row( Connection handle: 1 )
[22:18:24] >> mysql_fetch_field_row( Connection handle: 1 )
[22:18:24] CMySQLHandler::FetchField("Password") - B87E41BB83A4B9B5DBD145F15C2F32F91A533E4AC98AFBC6FF97D26CDACC07BB096895DAE7FE543F2C4EA81F2E6146200215CB1D58C9959D764ED9D50A3B7A52
[22:18:24] >> mysql_fetch_field_row( Connection handle: 1 )
[22:18:24] CMySQLHandler::FetchField("ID") - 9
[22:18:24] >> mysql_fetch_field_row( Connection handle: 1 )
[22:18:24] CMySQLHandler::FetchField("Money") - 0
[22:18:24] >> mysql_fetch_field_row( Connection handle: 1 )
[22:18:24] CMySQLHandler::FetchField("Admin") - 7
[22:18:24] >> mysql_fetch_field_row( Connection handle: 1 )
[22:18:24] CMySQLHandler::FetchField("PosX") - -145.727005
[22:18:24] >> mysql_fetch_field_row( Connection handle: 1 )
[22:18:24] CMySQLHandler::FetchField("PosY") - 1206.778808
[22:18:24] >> mysql_fetch_field_row( Connection handle: 1 )
[22:18:24] CMySQLHandler::FetchField("PosZ") - 19.689229
[22:18:24] >> mysql_fetch_field_row( Connection handle: 1 )
[22:18:24] CMySQLHandler::FetchField("PosR") - 172.503402
[22:18:24] >> mysql_fetch_field_row( Connection handle: 1 )
[22:18:24] CMySQLHandler::FetchField("Health") - 100
[22:18:24] >> mysql_fetch_field_row( Connection handle: 1 )
[22:18:24] CMySQLHandler::FetchField("Armour") - 0
[22:18:24] >> mysql_fetch_field_row( Connection handle: 1 )
[22:18:24] CMySQLHandler::FetchField("Interior") - 0
[22:18:24] >> mysql_fetch_field_row( Connection handle: 1 )
[22:18:24] CMySQLHandler::FetchField("VirtualWorld") - 0
[22:18:24] >> mysql_fetch_field_row( Connection handle: 1 )
[22:18:24] CMySQLHandler::FetchField("Skin") - 147
[22:18:24] >> mysql_free_result( Connection handle: 1 )
[22:18:24] CMySQLHandler::FreeResult() - Result was successfully free'd.
[22:18:48] >> mysql_query( Connection handle: 1 )
[22:18:48] CMySQLHandler::Query(resultID) - Threaded query with id 4 started. (Extra ID: 0)
[22:18:48] CMySQLHandler::ProcessQueryThread(UPDATE players SET Health = '100.000000', Armour = '0.000000', PosX = '-147.720626', PosY = '1191.628906', PosZ = '19.742187', PosR = '172.503402', Interior = 0, Skin = 147, Money = 0 WHERE ID = 9) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)
[22:18:48] OnQueryFinish(4,"UPDATE players SET Health = '100.000000', Armour = '0.000000', PosX = '-147.720626', PosY = '1191.628906', PosZ = '19.742187', PosR = '172.503402', Interior = 0, Skin = 147, Money = 0 WHERE ID = 9") - Called.