Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --- FIRST 25 LINES ---
- [18:35:25]
- [18:35:25] ---------------------------
- [18:35:25] MySQL Debugging activated (03/22/10)
- [18:35:25] ---------------------------
- [18:35:25]
- [18:35:25] >> mysql_connect( )
- [18:35:25] CMySQLHandler::CMySQLHandler() - constructor called.
- [18:35:25] -- Connecting to "localhost" | DB: "gamedb" | Username: "lsrp" ...
- [18:35:25] CMySQLHandler::Connect() - Connection was successful.
- [18:35:25] >> mysql_connect( )
- [18:35:25] CMySQLHandler::CMySQLHandler() - constructor called.
- [18:35:25] -- Connecting to "localhost" | DB: "gamedb" | Username: "lsrp2" ...
- [18:35:25] CMySQLHandler::Connect() - Connection was successful.
- [18:35:25] >> mysql_query( Connection handle: 1 )
- [18:35:25] CMySQLHandler::Query(SELECT UNIX_TIMESTAMP()) - Successfully executed.
- [18:35:25] >> mysql_store_result( Connection handle: 1 )
- [18:35:25] CMySQLHandler::StoreResult() - Result was stored.
- [18:35:25] >> mysql_num_rows( Connection handle: 1 )
- [18:35:25] CMySQLHandler::NumRows() - Returned 1 rows(s)
- [18:35:25] >> mysql_fetch_int( Connection handle: 1 )
- [18:35:25] CMySQLHandler::FetchRow() - Return: 1269279325
- [18:35:25] >> mysql_free_result( Connection handle: 1 )
- [18:35:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
- [18:35:25] >> mysql_query( Connection handle: 1 )
- [18:35:25] CMySQLHandler::Query(SELECT * FROM `cars` ORDER BY `id` ASC) - Successfully executed.
- --- LAST 47 LINES (after I connect) ---
- [18:35:48] CMySQLHandler::EscapeString(Ryan_Fenix); - Escaped 10 characters to Ryan_Fenix.
- [18:35:48] >> mysql_query( Connection handle: 1 )
- [18:35:48] CMySQLHandler::Query(SELECT `id` FROM `users` WHERE `username` = BINARY 'Ryan_Fenix' LIMIT 1) - Successfully executed.
- [18:35:48] >> mysql_store_result( Connection handle: 1 )
- [18:35:48] CMySQLHandler::StoreResult() - Result was stored.
- [18:35:48] >> mysql_num_rows( Connection handle: 1 )
- [18:35:48] CMySQLHandler::NumRows() - Returned 1 rows(s)
- [18:35:48] >> mysql_fetch_int( Connection handle: 1 )
- [18:35:48] CMySQLHandler::FetchRow() - Return: 1
- [18:35:48] >> mysql_free_result( Connection handle: 1 )
- [18:35:48] CMySQLHandler::FreeResult() - Result was successfully free'd.
- [18:35:51] >> mysql_query( Connection handle: 1 )
- [18:35:51] CMySQLHandler::Query(SELECT `id`, `from`, `to` FROM `requestchange` WHERE `done` = '0' ORDER BY `id` ASC LIMIT 1) - Successfully executed.
- [18:35:51] >> mysql_store_result( Connection handle: 1 )
- [18:35:51] CMySQLHandler::StoreResult() - Result was stored.
- [18:35:51] >> mysql_num_rows( Connection handle: 1 )
- [18:35:51] CMySQLHandler::NumRows() - Returned 0 rows(s)
- [18:35:51] >> mysql_free_result( Connection handle: 1 )
- [18:35:51] CMySQLHandler::FreeResult() - Result was successfully free'd.
- [18:35:52] >> mysql_real_escape_string( Connection handle: 1 )
- [18:35:52] CMySQLHandler::EscapeString(Ryan_Fenix); - Escaped 10 characters to Ryan_Fenix.
- [18:35:52] >> mysql_real_escape_string( Connection handle: 1 )
- [18:35:52] CMySQLHandler::EscapeString(pass); - Escaped 7 characters to pass.
- [18:35:52] >> mysql_query( Connection handle: 2 )
- [18:35:52] CMySQLHandler::Query(SELECT u.*, c.gender, c.age, c.origin FROM gamedb.users u LEFT JOIN lsrp.char c ON c.pid = u.id WHERE u.username = BINARY 'Ryan_Fenix' AND u.password = MD5('pass') LIMIT 1,resultID) - Threaded query $
- [18:35:52] CMySQLHandler::ProcessQueryThread(SELECT u.*, c.gender, c.age, c.origin FROM gamedb.users u LEFT JOIN lsrp.char c ON c.pid = u.id WHERE u.username = BINARY 'Ryan_Fenix' AND u.password = MD5('pass') LIMIT 1, Resultid: 10)$
- [18:35:52] OnQueryFinish("SELECT u.*, c.gender, c.age, c.origin FROM gamedb.users u LEFT JOIN lsrp.char c ON c.pid = u.id WHERE u.username = BINARY 'Ryan_Fenix' AND u.password = MD5('pass') LIMIT 1",10) - Called.
- [18:35:52] >> mysql_store_result( Connection handle: 1 )
- [18:35:52] CMySQLHandler::StoreResult() - No data to store.
- [18:35:52] >> mysql_num_rows( Connection handle: 1 )
- [18:35:52] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
- [18:35:54] >> mysql_real_escape_string( Connection handle: 1 )
- [18:35:54] CMySQLHandler::EscapeString(Ryan_Fenix); - Escaped 10 characters to Ryan_Fenix.
- [18:35:54] >> mysql_real_escape_string( Connection handle: 1 )
- [18:35:54] CMySQLHandler::EscapeString(pass); - Escaped 7 characters to pass.
- [18:35:54] >> mysql_query( Connection handle: 2 )
- [18:35:54] CMySQLHandler::Query(SELECT u.*, c.gender, c.age, c.origin FROM gamedb.users u LEFT JOIN lsrp.char c ON c.pid = u.id WHERE u.username = BINARY 'Ryan_Fenix' AND u.password = MD5('pass') LIMIT 1,resultID) - Threaded query $
- [18:35:54] CMySQLHandler::ProcessQueryThread(SELECT u.*, c.gender, c.age, c.origin FROM gamedb.users u LEFT JOIN lsrp.char c ON c.pid = u.id WHERE u.username = BINARY 'Ryan_Fenix' AND u.password = MD5('pass') LIMIT 1, Resultid: 10)$
- [18:35:56] >> mysql_query( Connection handle: 1 )
- [18:35:56] CMySQLHandler::Query(SELECT `id`, `from`, `to` FROM `requestchange` WHERE `done` = '0' ORDER BY `id` ASC LIMIT 1) - Successfully executed.
- [18:35:56] >> mysql_store_result( Connection handle: 1 )
- [18:35:56] CMySQLHandler::StoreResult() - Result was stored.
- [18:35:56] >> mysql_num_rows( Connection handle: 1 )
- [18:35:56] CMySQLHandler::NumRows() - Returned 0 rows(s)
- [18:35:56] >> mysql_free_result( Connection handle: 1 )
- [18:35:56] CMySQLHandler::FreeResult() - Result was successfully free'd.
- [18:35:59] CMySQLHandler::~CMySQLHandler() - deconstructor called.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement