31.05.2011, 21:45
I have problem about login.
When you type /password with correct password, then it says invalid password and server (cmd runner) shutdowned.
http://www.upload.ee/files/1383751/prrp.pwn.html
That is gamemode, what im using, while it problem had.
Any know what problem is and how solve it?
Btw i putted some many MySQLCheckConnection() and still says Dead Connection.
When you type /password with correct password, then it says invalid password and server (cmd runner) shutdowned.
http://www.upload.ee/files/1383751/prrp.pwn.html
That is gamemode, what im using, while it problem had.
Any know what problem is and how solve it?
Код:
[00:42:12] ---------------------------
[00:42:12] MySQL Debugging activated (06/01/11)
[00:42:12] ---------------------------
[00:42:12]
[00:42:12] >> mysql_connect( )
[00:42:12] CMySQLHandler::CMySQLHandler() - constructor called.
[00:42:12] CMySQLHandler::CMySQLHandler() - Connecting to "127.0.0.1" | DB: "prrp" | Username: "root" ...
[00:42:12] CMySQLHandler::Connect() - Connection was successful.
[00:42:12] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[00:42:12] >> mysql_ping( Connection handle: 1 )
[00:42:12] CMySQLHandler::Ping() - Connection is still alive.
[00:42:12] >> mysql_query( Connection handle: 1 )
[00:42:12] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: -1)
[00:42:12] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[00:42:17] >> mysql_real_escape_string( Connection handle: 1 )
[00:42:17] CMySQLHandler::EscapeString(Martin_Sulov); - Escaped 12 characters to ****_******.
[00:42:17] >> mysql_query( Connection handle: 1 )
[00:42:17] CMySQLHandler::Query(SELECT * FROM Accounts WHERE Username = '*****_*******') - Successfully executed.
[00:42:17] >> mysql_store_result( Connection handle: 1 )
[00:42:17] CMySQLHandler::StoreResult() - Result was stored.
[00:42:17] >> mysql_num_rows( Connection handle: 1 )
[00:42:17] CMySQLHandler::NumRows() - Returned 1 row(s)
[00:42:17] >> mysql_free_result( Connection handle: 1 )
[00:42:17] CMySQLHandler::FreeResult() - Result was successfully free'd.
[00:42:18] >> mysql_ping( Connection handle: 1 )
[00:42:18] CMySQLHandler::Ping() - Connection is still alive.
[00:42:20] >> mysql_ping( Connection handle: 1 )
[00:42:20] CMySQLHandler::Ping() - Connection is still alive.
[00:42:20] >> mysql_real_escape_string( Connection handle: 1 )
[00:42:20] CMySQLHandler::EscapeString(Martin_Sulov); - Escaped 12 characters to ******_******.
[00:42:20] >> mysql_query( Connection handle: 1 )
[00:42:20] CMySQLHandler::Query(SELECT * FROM Accounts WHERE Username = '******_******') - Successfully executed.
[00:42:20] >> mysql_store_result( Connection handle: 1 )
[00:42:20] CMySQLHandler::StoreResult() - Result was stored.
[00:42:20] >> mysql_num_rows( Connection handle: 1 )
[00:42:20] CMySQLHandler::NumRows() - Returned 1 row(s)
[00:42:20] >> mysql_free_result( Connection handle: 1 )
[00:42:20] CMySQLHandler::FreeResult() - Result was successfully free'd.
[00:42:20] >> mysql_ping( Connection handle: 1 )
[00:42:20] CMySQLHandler::Ping() - Connection is still alive.
[00:42:20] >> mysql_ping( Connection handle: 1 )
[00:42:20] CMySQLHandler::Ping() - Connection is still alive.
[00:42:20] >> mysql_real_escape_string( Connection handle: 1 )
[00:42:20] CMySQLHandler::EscapeString(Martin_Sulov); - Escaped 12 characters to ****_*****.
[00:42:20] >> mysql_real_escape_string( Connection handle: 1 )
[00:42:20] CMySQLHandler::EscapeString(p4r00l); - Escaped 6 characters to ******.
[00:42:20] >> mysql_query( Connection handle: 1 )
[00:42:20] CMySQLHandler::Query(resultID) - Threaded query with id 0 started. (Extra ID: 0)
[00:42:20] CMySQLHandler::ProcessQueryThread(SELECT * FROM Accounts WHERE Username = '*******_******' AND Password = md5(sha1('********'))) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)
[00:42:20] OnQueryFinish(0,"SELECT * FROM Accounts WHERE Username = '******_*******' AND Password = md5(sha1('******'))") - Called.
[00:42:20] >> mysql_num_rows( Connection handle: 1 )
[00:42:20] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[00:42:20] >> mysql_ping( Connection handle: 1 )
Код:
SA-MP Dedicated Server ---------------------- v0.3c, ©2005-2010 SA-MP Team [00:42:12] filterscripts = "" (string) [00:42:12] [00:42:12] Server Plugins [00:42:12] -------------- [00:42:12] Loading plugin: mysql [00:42:12] > MySQL plugin R5 successfully loaded. [00:42:12] Loaded. [00:42:12] Loading plugin: streamer [00:42:12] *** Streamer Plugin v2.5.2 by Incognito loaded *** [00:42:12] Loaded. [00:42:12] Loading plugin: sscanf [00:42:12] [00:42:12] =============================== [00:42:12] sscanf plugin loaded. [00:42:12] © 2009 Alex "******" Cole [00:42:12] =============================== [00:42:12] Loaded. [00:42:12] Loading plugin: dns [00:42:12] *** DNS Plugin v2.4 by Incognito loaded *** [00:42:12] Loaded. [00:42:12] Loaded 4 plugins. [00:42:12] [00:42:12] Filter Scripts [00:42:12] --------------- [00:42:12] Loaded 0 filter scripts. [00:42:12] MYSQL: Attempting to connect to server... [00:42:12] MYSQL: Database connection established. [00:42:12] | Roleplay | [00:42:12] Number of vehicle models: 13 [00:42:17] Incoming connection: 127.0.0.1:3618 [00:42:17] [join] ********_********* has joined the server (0:127.0.0.1)