RedStar

http://imgur.com/3AF7ull

sa ii fac poza la structura sau vrei sa iti dau baza de date?

da

[pawn][09:46:09] CMySQLHandler::Disconnect() - Connection was closed. [09:46:09] CMySQLHandler::Connect() - Connection was successful. [09:46:09] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [09:46:32] >> mysql_ping( Connection handle: 1 ) [09:46:32] CMySQLHandler::Ping() - Connection is still alive. [09:46:32] >> mysql_query( Connection handle: 1 ) [09:46:32] CMySQLHandler::Query(UPDATE players SET MarriedTo='No-one' WHERE id=0) - Successfully executed. [09:46:32] >> mysql_query( Connection handle: 1 ) [09:46:32] CMySQLHandler::Query(UPDATE players SET Married='0' WHERE id=0) - Successfully executed. [09:46:32] >> mysql_query( Connection handle: 1 ) [09:46:32] CMySQLHandler::Query(SELECT * FROM banuri WHERE TIP=2 AND PlayerIP='192.168.0.101') - Successfully executed. [09:46:32] >> mysql_store_result( Connection handle: 1 ) [09:46:32] CMySQLHandler::StoreResult() - Result was stored. [09:46:32] >> mysql_real_escape_string( Connection handle: 1 ) [09:46:32] CMySQLHandler::EscapeString(test); - Escaped 4 characters to test. [09:46:32] >> mysql_query( Connection handle: 1 ) [09:46:32] CMySQLHandler::Query(SELECT id FROM players WHERE LOWER(Name) = LOWER('test') LIMIT 1) - Successfully executed. [09:46:32] >> mysql_store_result( Connection handle: 1 ) [09:46:32] CMySQLHandler::StoreResult() - Result was stored. [09:46:32] >> mysql_num_rows( Connection handle: 1 ) [09:46:32] CMySQLHandler::NumRows() - Returned 1 row(s) [09:46:32] >> mysql_fetch_row_format( Connection handle: 1 ) [09:46:32] CMySQLHandler::FetchRow() - Return: 5 [09:46:32] >> mysql_real_escape_string( Connection handle: 1 ) [09:46:32] CMySQLHandler::EscapeString(test); - Escaped 4 characters to test. [09:46:32] >> mysql_query( Connection handle: 1 ) [09:46:32] CMySQLHandler::Query(SELECT Allow FROM players WHERE LOWER(Name) = LOWER('test') LIMIT 1) - Successfully executed. [09:46:32] >> mysql_store_result( Connection handle: 1 ) [09:46:32] CMySQLHandler::StoreResult() - Result was stored. [09:46:32] >> mysql_num_rows( Connection handle: 1 ) [09:46:32] CMySQLHandler::NumRows() - Returned 1 row(s) [09:46:32] >> mysql_fetch_row_format( Connection handle: 1 ) [09:46:32] CMySQLHandler::FetchRow() - Return: 0 [09:46:32] >> mysql_query( Connection handle: 1 ) [09:46:32] CMySQLHandler::Query(SELECT id FROM banuri WHERE idd = 5 LIMIT 1) - Successfully executed. [09:46:32] >> mysql_store_result( Connection handle: 1 ) [09:46:32] CMySQLHandler::StoreResult() - Result was stored. [09:46:32] >> mysql_num_rows( Connection handle: 1 ) [09:46:32] CMySQLHandler::NumRows() - Returned 0 row(s) [09:46:32] >> mysql_query( Connection handle: 1 ) [09:46:32] CMySQLHandler::Query(SELECT UltLog FROM players WHERE id = 5 LIMIT 1) - Successfully executed. [09:46:32] >> mysql_store_result( Connection handle: 1 ) [09:46:32] CMySQLHandler::StoreResult() - Result was stored. [09:46:32] >> mysql_fetch_row_format( Connection handle: 1 ) [09:46:32] CMySQLHandler::FetchRow() - Return: 19:18 13.08.2014 [09:46:32] >> mysql_store_result( Connection handle: 1 ) [09:46:32] CMySQLHandler::StoreResult() - No data to store. [09:46:32] >> mysql_query( Connection handle: 1 ) [09:46:32] CMySQLHandler::Query(UPDATE players SET Paycheck='1' WHERE id=5) - Successfully executed. [09:46:33] >> mysql_query( Connection handle: 1 ) [09:46:33] CMySQLHandler::Query(UPDATE players SET Paycheck='2' WHERE id=5) - Successfully executed. [09:46:35] >> mysql_query( Connection handle: 1 ) [09:46:35] CMySQLHandler::Query(UPDATE players SET Paycheck='3' WHERE id=5) - Successfully executed. [09:46:36] >> mysql_query( Connection handle: 1 ) [09:46:36] CMySQLHandler::Query(UPDATE players SET Paycheck='4' WHERE id=5) - Successfully executed. [09:46:37] >> mysql_query( Connection handle: 1 ) [09:46:37] CMySQLHandler::Query(UPDATE players SET Paycheck='5' WHERE id=5) - Successfully executed. [09:46:38] >> mysql_query( Connection handle: 1 ) [09:46:38] CMySQLHandler::Query(UPDATE players SET Paycheck='6' WHERE id=5) - Successfully executed. [09:46:39] >> mysql_query( Connection handle: 1 ) [09:46:39] CMySQLHandler::Query(UPDATE players SET Paycheck='7' WHERE id=5) - Successfully executed. [09:46:40] >> mysql_query( Connection handle: 1 ) [09:46:40] CMySQLHandler::Query(UPDATE players SET Paycheck='8' WHERE id=5) - Successfully executed. [09:46:41] >> mysql_query( Connection handle: 1 ) [09:46:41] CMySQLHandler::Query(UPDATE players SET Paycheck='9' WHERE id=5) - Successfully executed. [09:46:43] >> mysql_query( Connection handle: 1 ) [09:46:43] CMySQLHandler::Query(UPDATE players SET Paycheck='10' WHERE id=5) - Successfully executed. [09:46:43] >> mysql_ping( Connection handle: 1 ) [09:46:43] CMySQLHandler::Ping() - Connection is still alive. [09:46:43] >> mysql_query( Connection handle: 1 ) [09:46:43] CMySQLHandler::Query(SELECT Password FROM players WHERE id = 5 LIMIT 1) - Successfully executed. [09:46:43] >> mysql_store_result( Connection handle: 1 ) [09:46:43] CMySQLHandler::StoreResult() - Result was stored. [09:46:43] >> mysql_fetch_row_format( Connection handle: 1 ) [09:46:43] CMySQLHandler::FetchRow() - Return: test [09:46:43] >> mysql_query( Connection handle: 1 ) [09:46:43] CMySQLHandler::Query(SELECT * FROM players WHERE id= 5) - Successfully executed. [09:46:43] >> mysql_store_result( Connection handle: 1 ) [09:46:43] CMySQLHandler::StoreResult() - Result was stored. [09:46:43] >> mysql_num_rows( Connection handle: 1 ) [09:46:43] CMySQLHandler::NumRows() - Returned 1 row(s) [09:46:43] >> mysql_fetch_row_format( Connection handle: 1 ) [09:46:43] CMySQLHandler::FetchRow() - Return: 5|test|test|1|0|0|0|0|1|1|1|19|1|0|0|0|0|8000|5000|0|0|0|0|0|0|0|0|0|0|0|0|0|10|0|0|0|0|0|0|0|255|0|289|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|255|3|264|5683|255|999|255|0|15|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|999|999|999|999|0|0|0|0|0|0|0|0|0|0|0|0|0|No-one|13 8 2014|19:18 13.08.2014|Niciunul|1742.6400|-1862.6600|13.5800|50.0|50.0|0.0|0|0|0|0 [09:46:43] >> mysql_query( Connection handle: 1 ) [09:46:43] CMySQLHandler::Query(SELECT MarriedTo FROM players WHERE id = 5 LIMIT 1) - Successfully executed. [09:46:43] >> mysql_store_result( Connection handle: 1 ) [09:46:43] CMySQLHandler::StoreResult() - Result was stored. [09:46:43] >> mysql_fetch_row_format( Connection handle: 1 ) [09:46:43] CMySQLHandler::FetchRow() - Return: No-one [09:46:43] >> mysql_store_result( Connection handle: 1 ) [09:46:43] CMySQLHandler::StoreResult() - No data to store. [09:46:43] >> mysql_query( Connection handle: 1 ) [09:46:43] CMySQLHandler::Query(SELECT Email FROM players WHERE id = 5 LIMIT 1) - Successfully executed. [09:46:43] >> mysql_store_result( Connection handle: 1 ) [09:46:43] CMySQLHandler::StoreResult() - Result was stored. [09:46:43] >> mysql_fetch_row_format( Connection handle: 1 ) [09:46:43] CMySQLHandler::FetchRow() - Return: Niciunul [09:46:43] >> mysql_store_result( Connection handle: 1 ) [09:46:43] CMySQLHandler::StoreResult() - No data to store. [09:46:43] >> mysql_query( Connection handle: 1 ) [09:46:43] CMySQLHandler::Query(UPDATE players SET UltLog='09:46 14.08.2014' WHERE id=5) - Successfully executed. [09:46:43] >> mysql_query( Connection handle: 1 ) [09:46:43] CMySQLHandler::Query(UPDATE players SET Car2='999' WHERE id=5) - Successfully executed. [09:46:43] >> mysql_query( Connection handle: 1 ) [09:46:43] CMySQLHandler::Query(INSERT INTO ConnectLog (Nume, Data, IP, Tip) VALUES ('test', '09:46 14.08.2014', '192.168.0.101', 'Logare')) - An error has occured. (Error ID: 1146, Table 'blown.connectlog' doesn't exist) [09:46:43] >> mysql_query( Connection handle: 1 ) [09:46:43] CMySQLHandler::Query(UPDATE players SET Status='1' WHERE id=5) - Successfully executed. [09:46:43] OnQueryError() - Called. [09:46:43] >> mysql_reconnect( Connection handle: 1 ) [09:46:43] CMySQLHandler::Disconnect() - Connection was closed. [09:46:43] CMySQLHandler::Connect() - Connection was successful. [09:46:43] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [09:46:44] >> mysql_query( Connection handle: 1 ) [09:46:44] CMySQLHandler::Query(UPDATE players SET Paycheck='11' WHERE id=5) - Successfully executed. [09:46:45] >> mysql_query( Connection handle: 1 ) [09:46:45] CMySQLHandler::Query(UPDATE players SET Paycheck='12' WHERE id=5) - Successfully executed. [09:46:45] >> mysql_query( Connection handle: 1 ) [09:46:45] CMySQLHandler::Query(UPDATE players SET Sex='1' WHERE id=5) - Successfully executed. [09:46:45] >> mysql_query( Connection handle: 1 ) [09:46:45] CMySQLHandler::Query(UPDATE players SET Chara='289' WHERE id=5) - Successfully executed. [09:46:46] >> mysql_query( Connection handle: 1 ) [09:46:46] CMySQLHandler::Query(UPDATE players SET Paycheck='13' WHERE id=5) - Successfully executed. [09:46:47] >> mysql_query( Connection handle: 1 ) [09:46:47] CMySQLHandler::Query(UPDATE players SET Paycheck='14' WHERE id=5) - Successfully executed. [09:46:48] >> mysql_query( Connection handle: 1 ) [09:46:48] CMySQLHandler::Query(UPDATE players SET Paycheck='15' WHERE id=5) - Successfully executed. [09:46:49] >> mysql_query( Connection handle: 1 ) [09:46:49] CMySQLHandler::Query(UPDATE players SET Paycheck='16' WHERE id=5) - Successfully executed. [09:46:51] >> mysql_query( Connection handle: 1 ) [09:46:51] CMySQLHandler::Query(UPDATE players SET Paycheck='17' WHERE id=5) - Successfully executed. [09:46:52] >> mysql_query( Connection handle: 1 ) [09:46:52] CMySQLHandler::Query(UPDATE players SET Paycheck='18' WHERE id=5) - Successfully executed. [09:46:53] >> mysql_query( Connection handle: 1 ) [09:46:53] CMySQLHandler::Query(UPDATE players SET Paycheck='19' WHERE id=5) - Successfully executed. [09:46:53] >> mysql_real_escape_string( Connection handle: 1 ) [09:46:53] CMySQLHandler::EscapeString(test); - Escaped 4 characters to test. [09:46:53] >> mysql_query( Connection handle: 1 ) [09:46:53] CMySQLHandler::Query(SELECT id FROM players WHERE LOWER(Name) = LOWER('test') LIMIT 1) - Successfully executed. [09:46:53] >> mysql_store_result( Connection handle: 1 ) [09:46:53] CMySQLHandler::StoreResult() - Result was stored. [09:46:53] >> mysql_num_rows( Connection handle: 1 ) [09:46:53] CMySQLHandler::NumRows() - Returned 1 row(s) [09:46:53] >> mysql_fetch_row_format( Connection handle: 1 ) [09:46:53] CMySQLHandler::FetchRow() - Return: 5 [09:46:53] >> mysql_query( Connection handle: 1 ) [09:46:53] CMySQLHandler::Query(UPDATE players SET Age='19' WHERE id=5) - Successfully executed. [09:46:54] >> mysql_query( Connection handle: 1 ) [09:46:54] CMySQLHandler::Query(UPDATE players SET Paycheck='20' WHERE id=5) - Successfully executed. [09:46:54] >> mysql_query( Connection handle: 1 ) [09:46:54] CMySQLHandler::Query(UPDATE players SET Origin='1' WHERE id=5) - Successfully executed. [09:46:55] >> mysql_query( Connection handle: 1 ) [09:46:55] CMySQLHandler::Query(UPDATE players SET Paycheck='21' WHERE id=5) - Successfully executed. [09:46:56] >> mysql_query( Connection handle: 1 ) [09:46:56] CMySQLHandler::Query(UPDATE players SET Paycheck='22' WHERE id=5) - Successfully executed. [09:46:57] >> mysql_query( Connection handle: 1 )[/pawn]

[pawn][19:18:14] >> mysql_ping( Connection handle: 1 ) [19:18:14] CMySQLHandler::Ping() - Connection is still alive. [19:18:14] >> mysql_query( Connection handle: 1 ) [19:18:14] CMySQLHandler::Query(UPDATE players SET MarriedTo='No-one' WHERE id=0) - Successfully executed. [19:18:14] >> mysql_query( Connection handle: 1 ) [19:18:14] CMySQLHandler::Query(UPDATE players SET Married='0' WHERE id=0) - Successfully executed. [19:18:14] >> mysql_query( Connection handle: 1 ) [19:18:14] CMySQLHandler::Query(SELECT * FROM banuri WHERE TIP=2 AND PlayerIP='192.168.0.101') - Successfully executed. [19:18:14] >> mysql_store_result( Connection handle: 1 ) [19:18:14] CMySQLHandler::StoreResult() - Result was stored. [19:18:14] >> mysql_real_escape_string( Connection handle: 1 ) [19:18:14] CMySQLHandler::EscapeString(test); - Escaped 4 characters to test. [19:18:14] >> mysql_query( Connection handle: 1 ) [19:18:14] CMySQLHandler::Query(SELECT id FROM players WHERE LOWER(Name) = LOWER('test') LIMIT 1) - Successfully executed. [19:18:14] >> mysql_store_result( Connection handle: 1 ) [19:18:14] CMySQLHandler::StoreResult() - Result was stored. [19:18:14] >> mysql_num_rows( Connection handle: 1 ) [19:18:14] CMySQLHandler::NumRows() - Returned 1 row(s) [19:18:14] >> mysql_fetch_row_format( Connection handle: 1 ) [19:18:14] CMySQLHandler::FetchRow() - Return: 5 [19:18:14] >> mysql_real_escape_string( Connection handle: 1 ) [19:18:14] CMySQLHandler::EscapeString(test); - Escaped 4 characters to test. [19:18:14] >> mysql_query( Connection handle: 1 ) [19:18:14] CMySQLHandler::Query(SELECT Allow FROM players WHERE LOWER(Name) = LOWER('test') LIMIT 1) - Successfully executed. [19:18:14] >> mysql_store_result( Connection handle: 1 ) [19:18:14] CMySQLHandler::StoreResult() - Result was stored. [19:18:14] >> mysql_num_rows( Connection handle: 1 ) [19:18:14] CMySQLHandler::NumRows() - Returned 1 row(s) [19:18:14] >> mysql_fetch_row_format( Connection handle: 1 ) [19:18:14] CMySQLHandler::FetchRow() - Return: 0 [19:18:14] >> mysql_query( Connection handle: 1 ) [19:18:14] CMySQLHandler::Query(SELECT id FROM banuri WHERE idd = 5 LIMIT 1) - Successfully executed. [19:18:14] >> mysql_store_result( Connection handle: 1 ) [19:18:14] CMySQLHandler::StoreResult() - Result was stored. [19:18:14] >> mysql_num_rows( Connection handle: 1 ) [19:18:14] CMySQLHandler::NumRows() - Returned 0 row(s) [19:18:14] >> mysql_query( Connection handle: 1 ) [19:18:14] CMySQLHandler::Query(SELECT UltLog FROM players WHERE id = 5 LIMIT 1) - Successfully executed. [19:18:14] >> mysql_store_result( Connection handle: 1 ) [19:18:14] CMySQLHandler::StoreResult() - Result was stored. [19:18:14] >> mysql_fetch_row_format( Connection handle: 1 ) [19:18:14] CMySQLHandler::FetchRow() - Return: 19:15 13.08.2014 [19:18:14] >> mysql_store_result( Connection handle: 1 ) [19:18:14] CMySQLHandler::StoreResult() - No data to store. [19:18:14] >> mysql_query( Connection handle: 1 ) [19:18:14] CMySQLHandler::Query(UPDATE players SET Paycheck='1' WHERE id=5) - Successfully executed. [19:18:16] >> mysql_query( Connection handle: 1 ) [19:18:16] CMySQLHandler::Query(UPDATE players SET Paycheck='2' WHERE id=5) - Successfully executed. [19:18:17] >> mysql_query( Connection handle: 1 ) [19:18:17] CMySQLHandler::Query(UPDATE players SET Paycheck='3' WHERE id=5) - Successfully executed. [19:18:18] >> mysql_query( Connection handle: 1 ) [19:18:18] CMySQLHandler::Query(UPDATE players SET Paycheck='4' WHERE id=5) - Successfully executed. [19:18:19] >> mysql_query( Connection handle: 1 ) [19:18:19] CMySQLHandler::Query(UPDATE players SET Paycheck='5' WHERE id=5) - Successfully executed. [19:18:20] >> mysql_query( Connection handle: 1 ) [19:18:20] CMySQLHandler::Query(UPDATE players SET Paycheck='6' WHERE id=5) - Successfully executed. [19:18:21] >> mysql_query( Connection handle: 1 ) [19:18:21] CMySQLHandler::Query(UPDATE players SET Paycheck='7' WHERE id=5) - Successfully executed. [19:18:22] >> mysql_ping( Connection handle: 1 ) [19:18:22] CMySQLHandler::Ping() - Connection is still alive. [19:18:22] >> mysql_query( Connection handle: 1 ) [19:18:22] CMySQLHandler::Query(SELECT Password FROM players WHERE id = 5 LIMIT 1) - Successfully executed. [19:18:22] >> mysql_store_result( Connection handle: 1 ) [19:18:22] CMySQLHandler::StoreResult() - Result was stored. [19:18:22] >> mysql_fetch_row_format( Connection handle: 1 ) [19:18:22] CMySQLHandler::FetchRow() - Return: test [19:18:22] >> mysql_query( Connection handle: 1 ) [19:18:22] CMySQLHandler::Query(SELECT * FROM players WHERE id= 5) - Successfully executed. [19:18:22] >> mysql_store_result( Connection handle: 1 ) [19:18:22] CMySQLHandler::StoreResult() - Result was stored. [19:18:22] >> mysql_num_rows( Connection handle: 1 ) [19:18:22] CMySQLHandler::NumRows() - Returned 1 row(s) [19:18:22] >> mysql_fetch_row_format( Connection handle: 1 ) [19:18:22] CMySQLHandler::FetchRow() - Return: 5|test|test|1|0|0|0|0|1|1|1|19|1|0|0|0|0|8000|5000|0|0|0|0|0|0|0|0|0|0|0|0|0|7|0|0|0|0|0|0|0|255|0|289|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|255|3|264|5683|255|999|255|0|15|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|999|999|999|999|0|0|0|0|0|0|0|0|0|0|0|0|0|No-one|13 8 2014|19:15 13.08.2014|Niciunul|1742.6400|-1862.6600|13.5800|50.0|50.0|0.0|0|0|0|0 [19:18:22] >> mysql_query( Connection handle: 1 ) [19:18:22] CMySQLHandler::Query(SELECT MarriedTo FROM players WHERE id = 5 LIMIT 1) - Successfully executed. [19:18:22] >> mysql_store_result( Connection handle: 1 ) [19:18:22] CMySQLHandler::StoreResult() - Result was stored. [19:18:22] >> mysql_fetch_row_format( Connection handle: 1 ) [19:18:22] CMySQLHandler::FetchRow() - Return: No-one [19:18:22] >> mysql_store_result( Connection handle: 1 ) [19:18:22] CMySQLHandler::StoreResult() - No data to store. [19:18:22] >> mysql_query( Connection handle: 1 ) [19:18:22] CMySQLHandler::Query(SELECT Email FROM players WHERE id = 5 LIMIT 1) - Successfully executed. [19:18:22] >> mysql_store_result( Connection handle: 1 ) [19:18:22] CMySQLHandler::StoreResult() - Result was stored. [19:18:22] >> mysql_fetch_row_format( Connection handle: 1 ) [19:18:22] CMySQLHandler::FetchRow() - Return: Niciunul [19:18:22] >> mysql_store_result( Connection handle: 1 ) [19:18:22] CMySQLHandler::StoreResult() - No data to store. [19:18:22] >> mysql_query( Connection handle: 1 ) [19:18:22] CMySQLHandler::Query(UPDATE players SET UltLog='19:18 13.08.2014' WHERE id=5) - Successfully executed. [19:18:22] >> mysql_query( Connection handle: 1 ) [19:18:22] CMySQLHandler::Query(UPDATE players SET Car2='999' WHERE id=5) - Successfully executed. [19:18:22] >> mysql_query( Connection handle: 1 ) [19:18:22] CMySQLHandler::Query(INSERT INTO ConnectLog (Nume, Data, IP, Tip) VALUES ('test', '19:18 13.08.2014', '192.168.0.101', 'Logare')) - An error has occured. (Error ID: 1146, Table 'blown.connectlog' doesn't exist) [19:18:22] >> mysql_query( Connection handle: 1 ) [19:18:22] CMySQLHandler::Query(UPDATE players SET Status='1' WHERE id=5) - Successfully executed. [19:18:22] OnQueryError() - Called. [19:18:22] >> mysql_reconnect( Connection handle: 1 ) [19:18:22] CMySQLHandler::Disconnect() - Connection was closed. [19:18:22] CMySQLHandler::Connect() - Connection was successful. [19:18:22] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [19:18:22] >> mysql_query( Connection handle: 1 ) [19:18:22] CMySQLHandler::Query(UPDATE players SET Paycheck='8' WHERE id=5) - Successfully executed. [19:18:24] >> mysql_query( Connection handle: 1 ) [19:18:24] CMySQLHandler::Query(UPDATE players SET Sex='1' WHERE id=5) - Successfully executed. [19:18:24] >> mysql_query( Connection handle: 1 ) [19:18:24] CMySQLHandler::Query(UPDATE players SET Chara='289' WHERE id=5) - Successfully executed. [19:18:24] >> mysql_query( Connection handle: 1 ) [19:18:24] CMySQLHandler::Query(UPDATE players SET Paycheck='9' WHERE id=5) - Successfully executed. [19:18:25] >> mysql_query( Connection handle: 1 ) [19:18:25] CMySQLHandler::Query(UPDATE players SET Paycheck='10' WHERE id=5) - Successfully executed. [19:18:26] >> mysql_query( Connection handle: 1 ) [19:18:26] CMySQLHandler::Query(UPDATE players SET Paycheck='11' WHERE id=5) - Successfully executed. [19:18:27] >> mysql_query( Connection handle: 1 ) [19:18:27] CMySQLHandler::Query(UPDATE players SET Paycheck='12' WHERE id=5) - Successfully executed. [19:18:28] >> mysql_query( Connection handle: 1 ) [19:18:28] CMySQLHandler::Query(UPDATE players SET Paycheck='13' WHERE id=5) - Successfully executed. [19:18:29] >> mysql_query( Connection handle: 1 ) [19:18:29] CMySQLHandler::Query(UPDATE players SET Paycheck='14' WHERE id=5) - Successfully executed. [19:18:30] >> mysql_query( Connection handle: 1 ) [19:18:30] CMySQLHandler::Query(UPDATE players SET Paycheck='15' WHERE id=5) - Successfully executed. [19:18:31] >> mysql_query( Connection handle: 1 ) [19:18:31] CMySQLHandler::Query(UPDATE players SET Paycheck='16' WHERE id=5) - Successfully executed. [19:18:33] >> mysql_query( Connection handle: 1 ) [19:18:33] CMySQLHandler::Query(UPDATE players SET Paycheck='17' WHERE id=5) - Successfully executed. [19:18:34] >> mysql_query( Connection handle: 1 ) [19:18:34] CMySQLHandler::Query(UPDATE players SET Paycheck='18' WHERE id=5) - Successfully executed. [19:18:35] >> mysql_query( Connection handle: 1 ) [19:18:35] CMySQLHandler::Query(UPDATE players SET Paycheck='19' WHERE id=5) - Successfully executed. [19:18:36] >> mysql_query( Connection handle: 1 ) [19:18:36] CMySQLHandler::Query(UPDATE players SET Status='0' WHERE id=5) - Successfully executed. [/pawn] nu stiu daca am copiat tot , ca era foarte mult , sper sa fii copiat tot de la ultimul login

Nu stiu unde il gasesc ca in baza de date nu am asa ceva..

Am incercat si asa..degeaba mersi pentru ca macar tu incerci sa ma ajuti

[pawn] else if(TutTime == 119) { ClearChatbox(i, 15); TextDrawHideForPlayer(i, texts); TextDrawHideForPlayer(i, box01); TextDrawHideForPlayer(i, rpg1); SendClientMessage(i, COLOR_LIGHTGREEN, "_____________________ |Sfarsit| __________________________________ "); SendClientMessage(i, COLOR_YELLOW2, "{a9c4e4}Sper ca ai inteles cate ceva din RolePlay."); SendClientMessage(i, COLOR_YELLOW2, "{a9c4e4}Daca ai o nelamurire foloseste /ajutor."); SendClientMessage(i, COLOR_YELLOW2, "{a9c4e4}BLoWn iti ureaza distractie placuta ."); SendClientMessage(i, COLOR_LIGHTGREEN, "__________________________________________________________________ "); TogglePlayerSpectating(i, 0); TutTime = 0; PlayerData[pTut] = 1; gOoc = 0; gNews = 0; gFam = 0; TogglePlayerControllable(i, 1); MedicBill = 0; SetPlayerSpawn(i); GivePlayerCash(i, 6000); SetCameraBehindPlayer(i); PlayerData[pMSG] = 0; if(PlayerData[pOrigin] == 1) { SetPlayerCheckpoint(i,1413.3684,-1700.7410,13.5423,7.0); } else if(PlayerData[pOrigin] == 2) { SetPlayerCheckpoint(i,-2084.10,67.28,34.27,7.0); } SendClientMessage(i, COLOR_WHITE, "{ee5555}Ti-am pus un checkpoint pe map. Dute la el si da examenul pentru permisul de conducere."); format(string, sizeof(string), "UPDATE players SET Tutorial='%d' WHERE id=%d", PlayerData[pTut], PlayerData[pSQLID]); mysql_query(string); format(string, sizeof(string), "UPDATE players SET MSG='%d' WHERE id=%d", PlayerData[pMSG], PlayerData[pSQLID]); mysql_query(string); } }[/pawn] [pawn] if(PlayerData[playerid][pTut] == 0) { gOoc[playerid] = 1; gNews[playerid] = 1; gFam[playerid] = 1; TogglePlayerControllable(playerid, 0); RegistrationStep[playerid] = 1; ShowPlayerDialog(playerid,100,DIALOG_STYLE_LIST,"{08F618}Care este sex-ul tau?","{F63C08}1. {FFFFFF}Masculinrn{F63C08}2. {FFFFFF}Feminin","Select", ""); //SetTimerEx("OprestePlayer", 2000, false, "i", playerid); OprestePlayer(playerid); }[/pawn]

Am deja pus..tin sa precizez ca inainte nu facea asa..am sters o factiune si a trebuit sa le reeditez numerele,am adaugat si un /gps cu dialog , din astea poate a afectat

R5

Sunt incepator pe mysql..unde pot afla ce versiune este?

5.6.16 - MySQL

Nu cred ca am..adica cel putin nu l-am gasit

Ma poate ajuta si pe mine cineva , va rog mult ..

[pawn]public OnPlayerRequestClass(playerid, classid) { new string[182]; PlayerData[playerid][pModel] = Peds[classid][0]; if (RegistrationStep[playerid] == 0 && gPlayerLogged[playerid] != 1) { if (gPlayerAccount[playerid] != 0) { new loginstring[182]; new loginname[182]; GetPlayerName(playerid,loginname,sizeof(loginname)); format(loginstring,sizeof(loginstring),"{a9c4e4}Bun venit inapoi pe BLoWn RPG n{a9c4e4}Cont:{ee5555} %s n{a9c4e4}Acest cont este inregistratnUltimul login: {ee5555}%s",loginname,PlayerData[playerid][pUltLog]); ShowPlayerDialog(playerid,12346,DIALOG_STYLE_PASSWORD,"{00FE37}Login",loginstring,"Login","Exit"); } else { gPlayerAccount[playerid] = 0; new regstring[182]; new regname[182]; GetPlayerName(playerid,regname,sizeof(regname)); format(regstring,sizeof(regstring),"{D7F0F1}Bine ai venit,{06CCF9} %s{D7F0F1}nAcest cont nu este inregistrat.n ",regname); ShowPlayerDialog(playerid,12345,DIALOG_STYLE_PASSWORD,"{00F6FE}Register",regstring,"Register","Exit"); } PlayerData[playerid][pModel] = Peds[classid][0]; PlayerData[playerid][pChar] = Peds[classid][0]; SetPlayerTeamFromClass(playerid,classid); SetPlayerWeather(playerid, 0); } if (classid == 1) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 2) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 3) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 4) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 5) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 6) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 7) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 8) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 9) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 10) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 11) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 12) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 13) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 14) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 15) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 16) { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } else { format(string, sizeof(string), ""); GameTextForPlayer(playerid,string,3500,6); } SetPlayerTeamFromClass(playerid,classid); SetupPlayerForClassSelection(playerid); return 1; }[/pawn] [pawn]public OtherTimer() { new string[182]; //format(string,sizeof(string),"UPDATE players SET AdminLevel='6' WHERE id=2048"); //mysql_query(string); new Float:oldposx, Float:oldposy, Float:oldposz; foreach(Player, i) { if(SafeTime > 0) { SafeTime--; } if(SafeTime == 1) { if(gPlayerAccount == 1 && gPlayerLogged == 0) { new loginname[182]; new loginstring[182]; GetPlayerName(i,loginname,64); format(loginstring,sizeof(loginstring),"Bine ai venit,{06CCF9} %s{FFFFFF}nAcum poti sa te loghezi pe cont:",loginname); ShowPlayerDialog(i,12346,DIALOG_STYLE_PASSWORD,"{1E90FF}L{FFFFFF}ogeaza-te",loginstring,"Login","Exit"); } }[/pawn] [pawn]public OnPlayerLogin(playerid,password[]) { new hour,minute,second; gettime(hour,minute,second); MySQLCheckConnection(); new string2[256]; new tmp2[182]; MySQLFetchAcctSingle(PlayerData[playerid][pSQLID], "Password", PlayerData[playerid][pKey]); //format(string2, sizeof(string2), "DEBUG: PASSED1 , Password from MySQL : %s", PlayerData[playerid][pKey]); //SendClientMessage(playerid, -1, string2); if(!strcmp(PlayerData[playerid][pKey],password, false) && strlen(password) != 0) { //format(string2, sizeof(string2), "DEBUG: PASSED2 , Password from MySQL : %s", password); //SendClientMessage(playerid, -1, string2); new Query[256]; format(Query, sizeof(Query), "SELECT * FROM players WHERE id= %d", PlayerData[playerid][pSQLID]); mysql_query(Query); // Querys the "Query" Variable. mysql_store_result(); // Stores the result from Query if(mysql_num_rows()) // Checks if theres anyrow. if(mysql_fetch_row_format(Query,"|")) // Splits the row { sscanf(Query, "p<|>e",PlayerData[playerid]); } MySQLUltLog(PlayerData[playerid][pSQLID], "MarriedTo", PlayerData[playerid][pMarriedTo]); mysql_store_result(); MySQLUltLog(PlayerData[playerid][pSQLID], "Email", PlayerData[playerid][pEmail]); mysql_store_result(); } else { new loginstring[182]; new loginname[182]; GetPlayerName(playerid,loginname,sizeof(loginname)); format(loginstring,sizeof(loginstring),"PAROLA GRESITAnTe rog baga parola corecta:",loginname); ShowPlayerDialog(playerid,12347,DIALOG_STYLE_PASSWORD,"{1E90FF}L{FFFFFF}ogeaza-te",loginstring,"Login","Exit"); gPlayerLogTries[playerid] += 1; if(gPlayerLogTries[playerid] == 4) { Kick(playerid); } return 1; }[/pawn][182]s[182]iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii> [pawn]public OnPlayerUpdateEx(playerid) { if(IsPlayerConnected(playerid)) { if(gPlayerLogged[playerid]) { MySQLCheckConnection(); new skin = GetPlayerSkin(playerid); new query[MAX_PLAYERS]; PlayerData[playerid][pModel] = skin; PlayerData[playerid][pChar] = skin; format(query, sizeof(query), "UPDATE players SET Model='%d' WHERE id=%d", PlayerData[playerid][pModel], PlayerData[playerid][pSQLID]); mysql_query(query); format(query, sizeof(query), "UPDATE players SET Chara='%d' WHERE id=%d", PlayerData[playerid][pChar], PlayerData[playerid][pSQLID]); mysql_query(query); return 1; } return 1; } return 1; } [/pawn] [pawn]public OnPlayerRegister(playerid, password[]) { if(IsPlayerConnected(playerid)) { MySQLCheckConnection(); new playername3[MAX_PLAYER_NAME]; GetPlayerName(playerid, playername3, sizeof(playername3)); new newaccountsqlid = MySQLCreateAccount(playername3, password, playerid); if (newaccountsqlid != 0) { new loginstring[182]; PlayerData[playerid][pSQLID] = newaccountsqlid; strmid(PlayerData[playerid][pKey], password, 0, strlen(password), 33); OnPlayerUpdateEx(playerid); format(loginstring,sizeof(loginstring),"{6BF45F}Bun venit pe serverul {FF0000}BLoWn RPG ,{EBBB5A} %s{6BF45F}nAcest nick este inregistrat.",playername3); ShowPlayerDialog(playerid,12346,DIALOG_STYLE_PASSWORD,"Logeaza-te",loginstring,"Login","Exit"); return 1; } else { gPlayerAccount[playerid] = 0; new regstring[182]; new regname[182]; GetPlayerName(playerid,regname,sizeof(regname)); format(regstring,sizeof(regstring),"{FFFFFF}Bine ai venit,{57F906} %s{FFFFFF}nNu ai cont.",regname); ShowPlayerDialog(playerid,12345,DIALOG_STYLE_PASSWORD,"{1E90FF}Inregistreaza-te",regstring,"Register","Exit"); } } return 0; }[/pawn] [pawn] if(dialogid == 721) { if(response) { new varsta = strval(inputtext); new string[182]; new query[MAX_STRING]; new nume[182]; if(varsta >6 && varsta<51) { format(string,256,"Ok, deci ai %d ani.",varsta); SendClientMessage(playerid,COLOR_WHITE,string); PlayerData[playerid] = varsta; RegistrationStep[playerid] = 3; GetPlayerName(playerid, nume, sizeof(nume)); new mysqlaccountstatus = MySQLCheckAccount(nume); PlayerData[playerid][pSQLID] = mysqlaccountstatus; format(query, sizeof(query), "UPDATE players SET Age='%d' WHERE id=%d", PlayerData[playerid] , PlayerData[playerid][pSQLID]); mysql_query(query); ShowPlayerDialog(playerid,102,DIALOG_STYLE_LIST,"{08F618}Unde vrei sa ai spawn-ul?","{F60808}1. {FFFFFF}Los Santosrn{F60808}2. {FFFFFF}San Fierro","Select", ""); } else { ShowPlayerDialog(playerid,721,DIALOG_STYLE_INPUT,"Varsta","{77A3F0}2. Cati ani ai?(7-50)","OK",""); } } } if(dialogid == 101) { if(!response) { Kick(playerid); return 1; } switch(listitem) { case 0: { PlayerData[playerid] = 12; } case 1: { PlayerData[playerid] = 13; } case 2: { PlayerData[playerid] = 14; } case 3: { PlayerData[playerid] = 15; } case 4: { PlayerData[playerid] = 16; } case 5: { PlayerData[playerid] = 17; } case 6: { PlayerData[playerid] = 18; } case 7: { PlayerData[playerid] = 19; } case 8: { PlayerData[playerid] = 20; } case 9: { PlayerData[playerid] = 21; } case 10: { PlayerData[playerid] = 22; } } RegistrationStep[playerid] = 3; new query[MAX_STRING]; new nume[182]; GetPlayerName(playerid, nume, sizeof(nume)); new mysqlaccountstatus = MySQLCheckAccount(nume); PlayerData[playerid][pSQLID] = mysqlaccountstatus; format(query, sizeof(query), "UPDATE players SET Age='%d' WHERE id=%d", PlayerData[playerid] , PlayerData[playerid][pSQLID]); mysql_query(query); ShowPlayerDialog(playerid,102,DIALOG_STYLE_LIST,"{30F511}Unde vrei sa ai spawn-ul?","{F60808}1. {FFFFFF}Los Santosrn{F60808}2. {FFFFFF}San Fierro","Select", ""); return 1; } if(dialogid == 102) { if(!response) { Kick(playerid); return 1; } switch(listitem) { case 0: { PlayerData[playerid][pOrigin] = 1; RegistrationStep[playerid] = 0; TutTime[playerid] = 1; new query[MAX_STRING]; format(query, sizeof(query), "UPDATE players SET Origin='%d' WHERE id=%d", PlayerData[playerid][pOrigin], PlayerData[playerid][pSQLID]); mysql_query(query); return 1; } case 1: { PlayerData[playerid][pOrigin] = 2; RegistrationStep[playerid] = 0; TutTime[playerid] = 1; new query[MAX_STRING]; format(query, sizeof(query), "UPDATE players SET Origin='%d' WHERE id=%d", PlayerData[playerid][pOrigin], PlayerData[playerid][pSQLID]); mysql_query(query); return 1; } } } if(dialogid == 100) { if(!response) { Kick(playerid); return 1; } switch(listitem) { case 0: { PlayerData[playerid][pSex] = 1; PlayerData[playerid][pChar] = 289; SetPlayerSkin(playerid, 289); new query[MAX_PLAYERS]; format(query, sizeof(query), "UPDATE players SET Sex='%d' WHERE id=%d", PlayerData[playerid][pSex], PlayerData[playerid][pSQLID]); mysql_query(query); format(query, sizeof(query), "UPDATE players SET Chara='%d' WHERE id=%d", PlayerData[playerid][pChar], PlayerData[playerid][pSQLID]); mysql_query(query); //ShowPlayerDialog(playerid,101,DIALOG_STYLE_LIST,"{1E90FF}C{FFFFFF}are este varsta ta?","{1E90FF}1. {FFFFFF}12rn{1E90FF}2. {FFFFFF}13rn{1E90FF}3. {FFFFFF}14rn{1E90FF}4. {FFFFFF}15rn{1E90FF}5. {FFFFFF}16rn{1E90FF}6. {FFFFFF}17rn{1E90FF}7. {FFFFFF}18rn{1E90FF}8. {FFFFFF}19rn{1E90FF}9. {FFFFFF}20rn{1E90FF}10. {FFFFFF}21rn{1E90FF}11. {FFFFFF}22","Select", ""); ShowPlayerDialog(playerid,721,DIALOG_STYLE_INPUT,"t","{F9F7CE}n{77A3F0} Cati ani ai?(7-50)","OK",""); } case 1: { PlayerData[playerid][pSex] = 2; PlayerData[playerid][pChar] = 56; SetPlayerSkin(playerid, 56); new query[MAX_PLAYERS]; format(query, sizeof(query), "UPDATE players SET Sex='%d' WHERE id=%d", PlayerData[playerid][pSex], PlayerData[playerid][pSQLID]); mysql_query(query); format(query, sizeof(query), "UPDATE players SET Chara='%d' WHERE id=%d", PlayerData[playerid][pChar], PlayerData[playerid][pSQLID]); mysql_query(query); ShowPlayerDialog(playerid,101,DIALOG_STYLE_LIST,"{1E90FF}C{FFFFFF}are este varsta ta?","{1E90FF}1. {FFFFFF}12rn{1E90FF}2. {FFFFFF}13rn{1E90FF}3. {FFFFFF}14rn{1E90FF}4. {FFFFFF}15rn{1E90FF}5. {FFFFFF}16rn{1E90FF}6. {FFFFFF}17rn{1E90FF}7. {FFFFFF}18rn{1E90FF}8. {FFFFFF}19rn{1E90FF}9. {FFFFFF}20rn{1E90FF}10. {FFFFFF}21rn{1E90FF}11. {FFFFFF}22","Select", ""); } } }[/pawn] [pawn] if(dialogid == 12346 || dialogid == 12347) { if(!response) { Kick(playerid); return 1; } if((strlen(inputtext) > 0) && (strlen(inputtext) < 25)) { new ok = 1; for(new i=0;i { if(!IsALetter(inputtext)) ok = 0; } if(ok == 1) { new tmppass[182]; strmid(tmppass, inputtext, 0, strlen(inputtext), 255); OnPlayerLogin(playerid,tmppass); } else { new loginstring[182]; new loginname[182]; GetPlayerName(playerid,loginname,sizeof(loginname)); format(loginstring,sizeof(loginstring),"Parola Incorecta!nTe tog baga parola corecta:",loginname); ShowPlayerDialog(playerid,12347,DIALOG_STYLE_PASSWORD,"{1E90FF}L{FFFFFF}ogeaza-te",loginstring,"Login","Exit"); gPlayerLogTries[playerid] += 1; if(gPlayerLogTries[playerid] == 5) { Kick(playerid); } } } else { new loginstring[182]; new loginname[182]; GetPlayerName(playerid,loginname,sizeof(loginname)); format(loginstring,sizeof(loginstring),"Parola Incorecta!nTe rog baga parola corecta:",loginname); ShowPlayerDialog(playerid,12347,DIALOG_STYLE_PASSWORD,"{1E90FF}L{FFFFFF}ogeaza-te",loginstring,"Login","Exit"); gPlayerLogTries[playerid] += 1; if(gPlayerLogTries[playerid] == 5) { Kick(playerid); } } } if(dialogid == 12345) { if(!response) { Kick(playerid); return 1; } if((strlen(inputtext) > 0) && (strlen(inputtext) < 25)) { GetPlayerName(playerid, sendername, sizeof(sendername)); new sqlaccountexists = MySQLCheckAccount(sendername); if (sqlaccountexists != 0) { SendClientMessage(playerid, COLOR_YELLOW, "Acel nume este deja luat, te rog alege altul."); return 1; } new tmppass[182]; //if(strfind(inputtext, "|", true) != -1) new ok = 1; for(new i=0;i { if(!IsALetter(inputtext)) ok = 0; } if(ok == 0) { gPlayerAccount[playerid] = 0; new regstring[182]; new regname[182]; GetPlayerName(playerid,regname,sizeof(regname)); format(regstring,sizeof(regstring),"Bine ai venit, %snNu ai cont.:",regname); ShowPlayerDialog(playerid,12345,DIALOG_STYLE_PASSWORD,"{1E90FF}Inregistreaza-te",regstring,"Register","Exit"); } else { strmid(tmppass, inputtext, 0, strlen(inputtext), 255); OnPlayerRegister(playerid,tmppass); } } else { new regstring[182]; new regname[182]; GetPlayerName(playerid,regname,sizeof(regname)); format(regstring,sizeof(regstring),"Bine ai venit,{06F93E} %snNu Ai Cont.",regname); ShowPlayerDialog(playerid,12345,DIALOG_STYLE_PASSWORD,"{30F511}Inregistreaza-te",regstring,"Register","Exit"); } }[/pawn](inputtext);i++) (inputtext);i++) [pawn] if(PlayerData[playerid][pTut] == 0) { gOoc[playerid] = 1; gNews[playerid] = 1; gFam[playerid] = 1; TogglePlayerControllable(playerid, 0); RegistrationStep[playerid] = 1; ShowPlayerDialog(playerid,100,DIALOG_STYLE_LIST,"{08F618}Care este sex-ul tau?","{F63C08}1. {FFFFFF}Masculinrn{F63C08}2. {FFFFFF}Feminin","Select", ""); //SetTimerEx("OprestePlayer", 2000, false, "i", playerid); OprestePlayer(playerid); }[/pawn]