20.07.2011, 20:45
The new
Код:
[23:49:16] [23:49:16] --------------------------- [23:49:16] MySQL Debugging activated (07/20/11) [23:49:16] --------------------------- [23:49:16] [23:49:16] >> mysql_connect( ) [23:49:16] CMySQLHandler::CMySQLHandler() - constructor called. [23:49:16] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp" | Username: "root" ... [23:49:16] CMySQLHandler::Connect() - Connection was successful. [23:49:16] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [23:49:16] >> mysql_ping( Connection handle: 1 ) [23:49:16] CMySQLHandler::Ping() - Connection is still alive. [23:49:55] >> mysql_ping( Connection handle: 1 ) [23:49:55] CMySQLHandler::Ping() - Connection is still alive. [23:49:55] >> mysql_real_escape_string( Connection handle: 1 ) [23:49:55] CMySQLHandler::EscapeString(Larry_Dee); - Escaped 9 characters to Larry_Dee. [23:49:55] >> mysql_query( Connection handle: 1 ) [23:49:55] CMySQLHandler::Query(SELECT `id` FROM `players` WHERE LOWER(Name) = LOWER('Larry_Dee') LIMIT 1) - Successfully executed. [23:49:55] >> mysql_store_result( Connection handle: 1 ) [23:49:55] CMySQLHandler::StoreResult() - Result was stored. [23:49:55] >> mysql_num_rows( Connection handle: 1 ) [23:49:55] CMySQLHandler::NumRows() - Returned 1 row(s) [23:49:55] >> mysql_fetch_row_format( Connection handle: 1 ) [23:49:55] CMySQLHandler::FetchRow() - Return: 1 [23:49:55] >> mysql_query( Connection handle: 1 ) [23:49:55] CMySQLHandler::Query(SELECT Lock FROM `players` WHERE id = 1 LIMIT 1) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lock FROM `players` WHERE id = 1 LIMIT 1' at line 1) [23:49:55] >> mysql_store_result( Connection handle: 1 ) [23:49:55] CMySQLHandler::StoreResult() - No data to store. [23:49:55] >> mysql_fetch_row_format( Connection handle: 1 ) [23:49:55] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result) [23:49:57] >> mysql_ping( Connection handle: 1 ) [23:49:57] CMySQLHandler::Ping() - Connection is still alive. [23:49:57] >> mysql_query( Connection handle: 1 ) [23:49:57] CMySQLHandler::Query(SELECT Password FROM `players` WHERE id = 1 LIMIT 1) - Successfully executed. [23:49:57] >> mysql_store_result( Connection handle: 1 ) [23:49:57] CMySQLHandler::StoreResult() - Result was stored. [23:49:57] >> mysql_fetch_row_format( Connection handle: 1 ) [23:49:57] CMySQLHandler::FetchRow() - Return: asd [23:49:57] >> mysql_query( Connection handle: 1 ) [23:49:57] CMySQLHandler::Query(SELECT * FROM `players`) - Successfully executed. [23:49:57] >> mysql_store_result( Connection handle: 1 ) [23:49:57] CMySQLHandler::StoreResult() - Result was stored. [23:49:57] >> mysql_num_rows( Connection handle: 1 ) [23:49:57] CMySQLHandler::NumRows() - Returned 1 row(s) [23:49:57] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:57] CMySQLHandler::FetchField("Level") - [23:49:57] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:57] CMySQLHandler::FetchField("Money") - [23:49:57] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Admin") - [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Vip") - [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Pos_x") - [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Pos_y") - [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Pos_z") - [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Carkey") - [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Carkey2") - [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Carkey3") - [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Fcarkey") - [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Health") - [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Respect") - [23:49:58] >> mysql_fetch_row_format( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchRow() - Return: 1|larry_dee|asd|3|5000000|10|0|111.805|-78.8418|2|0|0|0|0|0|0|0|0|0|0|100|0|0|0|0|0||0000-00-00||0|0|0|0 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Mask") - 0 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Maskuse") - 0 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Leader") - 0 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Member") - 0 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Char") - 0 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Int") - 0 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("VirWorld") - 0 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Walkie") - 0 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Walkiefreq") - [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Lock") - 0 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Ban Reason") - [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Lock Date") - 0000-00-00 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Locked By") - [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Tut") - 0 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Sex") - 0 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Origin") - 0 [23:49:58] >> mysql_fetch_field_row( Connection handle: 1 ) [23:49:58] CMySQLHandler::FetchField("Age") - 0 [23:49:58] >> mysql_free_result( Connection handle: 1 ) [23:49:58] CMySQLHandler::FreeResult() - Result was successfully free'd. [23:50:18] >> mysql_ping( Connection handle: 1 ) [23:50:18] CMySQLHandler::Ping() - Connection is still alive. [23:50:18] >> mysql_real_escape_string( Connection handle: 1 ) [23:50:18] CMySQLHandler::EscapeString(a); - Escaped 1 characters to a. [23:50:18] >> mysql_query( Connection handle: 1 ) [23:50:18] CMySQLHandler::Query(UPDATE `players` SET Password='a',Level=0,Money=0,Admin=0,Vip=0,Pos_x=1110290096,Pos_y=1115890745,Pos_z=1076627572,Carkey=0,Carkey2=0,Carkey3=0,Fcarkey=0,Leader=0,Member=0,Rank=0,Char=0,VirWorld=0,Int=0,Health=1120403456 WHERE id=1) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Char=0,VirWorld=0,Int=0,Health=1120403456 WHERE id=1' at line 1) [23:50:18] >> mysql_query( Connection handle: 1 ) [23:50:18] CMySQLHandler::Query(UPDATE `players` SET Mask=0,Maskuse=0,Walkie=0,Wtfreq=0,Lock=0,Ban Reason=0,Lock Date=0,Locked By=0,Tut=0,Sex=0,Origin=0,Age=0 WHERE id=1) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lock=0,Ban Reason=0,Lock Date=0,Locked By=0,Tut=0,Sex=0,Origin=0,Age=0 WHERE id=' at line 1) [23:50:24] CMySQLHandler::~CMySQLHandler() - deconstructor called. [23:50:24] CMySQLHandler::FreeResult() - The result is already empty. [23:50:24] CMySQLHandler::Disconnect() - Connection was closed.