[16:27:42] [debug]Server crashed while executing new.amx [16:27:42] [debug]AMX backtrace: [16:27:42] [debug]#0 native sql_num_rows () from sql.so [16:27:42] [debug]#1 003c9418 in public OnDialogResponse (playerid=0, dialogid=5, response=1, listitem=-1, inputtext[]=@0041e01c "1234@mail.ru") at C:\Users\Денис\Desktop\[1]World Role Play\4\gamemodes\new.pwn:27256 [16:27:42] [debug]Native backtrace: [16:27:42] [debug]#0 b6761e8b in _ZN10StackTraceC1EPv () from plugins/crashdetect4.15.1.so [16:27:42] [debug]#1 b675abcf in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect4.15.1.so [16:27:42] [debug]#2 b675bdbc in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect4.15.1.so [16:27:42] [debug]#3 b675c226 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect4.15.1.so [16:27:42] [debug]#4 b6761adc in ?? () from plugins/crashdetect4.15.1.so [16:27:42] [debug]#5 b776640c in ?? () [16:27:42] [debug]#6 b6fbbb98 in _ZN7Natives12sql_num_rowsEP6tagAMXPi () from plugins/sql.so [16:27:42] [debug]#7 080950b4 in ?? () from ./7890 [16:27:42] [debug]#8 b675d94b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect4.15.1.so [16:27:42] [debug]#9 b67608f8 in ?? () from plugins/crashdetect4.15.1.so [16:27:42] [debug]#10 b6764916 in amx_Exec () from plugins/crashdetect4.15.1.so [16:27:42] [debug]#11 b675cbe6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect4.15.1.so [16:27:42] [debug]#12 b6760659 in ?? () from plugins/crashdetect4.15.1.so [16:27:42] [debug]#13 080a667f in ?? () from ./7890 [16:27:42] [debug]#14 080b2864 in ?? () from ./7890 [16:27:42] [debug]#15 08071d38 in ?? () from ./7890 [16:27:42] [debug]#16 08071e32 in ?? () from ./7890 [16:27:42] [debug]#17 0807bc20 in ?? () from ./7890 [16:27:42] [debug]#18 080ae9fd in ?? () from ./7890 [16:27:42] [debug]#19 080aebc2 in ?? () from ./7890 [16:27:42] [debug]#20 080a9e9a in ?? () from ./7890 [16:27:42] [debug]#21 b747c4d3 in __libc_start_main () from /lib/i386-linux-gnu/libc.so.6
(Pawno:27256):
Код
if(!IsValidEmail(inputtext)) { SendClientMessage(playerid,CGRAY,"E-Mail не верный. Повторите ввод."); ShowPlayerDialog(playerid,dRegister2,1,"{ffffad}Регистрация","\n\n\n\n{ffffad}\tУкажите вашу {99b4ff}почту\n\n\n\n","Далее","Назад"); } else { sql_escape_string(zConn, inputtext, pData[playerid][pEmail], 24); new code; code = 1000; SetPVarInt(playerid,"emailcode",code); new querys[300]; format(querys,sizeof(querys),"SELECT `id` FROM `accounts` WHERE `email` = '%s'",inputtext); new Result:r = sql_query(zConn, querys, QUERY_CACHED); if(sql_num_rows(r)) { SendClientMessage(playerid,CGRAY,"Данный eMail уже используется"); sql_free_result(r); SPFD(playerid,dRegister,3,"Регистрация","Далее","Выход","{"#cWHITE"}\tДобро пожаловать на сервер.\n\tВаш логин: {"#cBLUE"}%s{"#cWHITE"}\n\n\tДанный аккаунт свободен.\n\tЧтобы зарегистрироваться введите пароль:",pData[playerid][pNickname]); return 1; } sql_free_result(r); ShowPlayerDialog(playerid,dRegister3,0,"{ffffad}Регистрация","\n\t{ffffad}Выберите ваш пол:","Мужской","Женский"); } } case dRegister3: { if(response) pData[playerid] [pSex]= 1; //муж else pData[playerid] [pSex]= 2; //жен ShowPlayerDialog(playerid,dRegister4,0,"{ffcf00}Регистрация","{"#cORANGE"}Выберите ваш цвет кожи:","Светлый","Черный"); } case dRegister4: { if(response) pData[playerid] [pColor]= 0; else pData[playerid] [pColor]= 1; if(!response) ShowPlayerDialog(playerid,dRegister5,2,"{ffcf00}Регистрация","Выберите национальность:{"#cORANGE"}\nАмериканец\nЯпонец\nИтальянец\nМексиканец\nЛатиноамериканец\nИспанец\nРусский\nПортугалец\nФранцуз","Далее","В начало"); //Белые else { format(pData[playerid][pLanguage], 7,"%s", LANG_NONE); ShowPlayerDialog(playerid,dRegister6,1,"{ffcf00}Регистрация","Укажите ваш возраст (игровой):","Регистрация","В начало"); } } case dRegister5: { if(!response) {SPFD(playerid,dRegister,3,"Регистрация","Далее","Выход","{"#cWHITE"}\tДобро пожаловать на сервер.\n\tВаш логи: {"#cBLUE"}%s{"#cWHITE"}\n\n\tДанный аккаунт свободен.\n\tЧтобы зарегистрироваться введите пароль:",pData[playerid][pNickname]); return 1;} else {
SQL_log
Код
[16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 13)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 13, next_row = -1)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 13)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 13, next_row = -1)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 13)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 13, next_row = -1)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 13)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 13, next_row = -1)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 13)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 13, next_row = -1)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 13)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 13, next_row = -1)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 13)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 13, next_row = -1)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 13)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 13, next_row = -1)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 13)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 13, next_row = -1)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 13)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 13, next_row = -1)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 13)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 13, next_row = -1)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 13)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 13, next_row = -1)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 13)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 13, next_row = -1)... [16:26:48] [debug]Natives::sql_free_result: Freeing statement (stmt->id = 13)... [16:26:48] [debug]Natives::sql_query: Executing statement (stmt->id = 14, stmt->query = SELECT `nickname` FROM `accounts` WHERE `id` = '77')... [16:26:48] [debug]Natives::sql_query: Statement executed (stmt->id = 14, stmt->error = 0). No callback found! [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 14)... [16:26:48] [debug]Natives::sql_free_result: Freeing statement (stmt->id = 14)... [16:26:48] [debug]Natives::sql_query: Executing statement (stmt->id = 15, stmt->query = SELECT * FROM `gangs` ORDER BY `id`)... [16:26:48] [debug]Natives::sql_query: Statement executed (stmt->id = 15, stmt->error = 0). No callback found! [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 15)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 15)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 15)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 15, next_row = -1)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 15)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 15)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 15, next_row = -1)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 15)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 15)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 15, next_row = -1)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 15)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 15)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 15, next_row = -1)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 15)... [16:26:48] [debug]Natives::sql_fetch_row: Fetching a row (stmt->id = 15)... [16:26:48] [debug]Natives::sql_next_row: Retrieving next row (stmt->id = 15, next_row = -1)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 15)... [16:26:48] [debug]Natives::sql_free_result: Freeing statement (stmt->id = 15)... [16:26:48] [debug]Natives::sql_query: Executing statement (stmt->id = 16, stmt->query = SELECT * FROM `delivery`)... [16:26:48] [debug]Natives::sql_query: Statement executed (stmt->id = 16, stmt->error = 0). No callback found! [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 16)... [16:26:48] [debug]Natives::sql_free_result: Freeing statement (stmt->id = 16)... [16:26:48] [debug]ProccessTick: Executing query callback (stmt->id = 3, stmt->error = 0, stmt->callback = )... [16:26:48] [debug]ProccessTick: Erasing query (stmt->id = 3)... [16:27:14] [debug]Natives::sql_query: Executing statement (stmt->id = 17, stmt->query = INSERT INTO `log_transfer` VALUES ('','-1','0','2015-9-30 16:27:14','0','0','0','win'))... [16:27:14] [debug]Natives::sql_query: Executing statement callback (stmt->id = 17, stmt->error = 2013, stmt->callback = )... [16:27:14] [debug]Natives::sql_query: Scheduling statement (stmt->id = 18, stmt->query = UPDATE `accounts` SET `money` = '0' WHERE `id` = '0', stmt->callback = ) for execution... [16:27:14] [debug]ProccessTick: Erasing query (stmt->id = 17)... [16:27:14] [debug]SQL_Worker[1]: Executing query (stmt->id = 18, stmt->query = UPDATE `accounts` SET `money` = '0' WHERE `id` = '0')... [16:27:14] [debug]ProccessTick: Executing query callback (stmt->id = 18, stmt->error = 0, stmt->callback = )... [16:27:14] [debug]ProccessTick: Erasing query (stmt->id = 18)... [16:27:17] [debug]Natives::sql_escape_string: Escaping (conn->id = 1) string 'Denis_Schenev'... [16:27:17] [debug]Natives::sql_query: Scheduling statement (stmt->id = 19, stmt->query = SELECT * FROM `accounts` WHERE `nickname` = 'Denis_Schenev', stmt->callback = OnPlayerLoaded) for execution... [16:27:17] [debug]SQL_Worker[1]: Executing query (stmt->id = 19, stmt->query = SELECT * FROM `accounts` WHERE `nickname` = 'Denis_Schenev')... [16:27:17] [debug]ProccessTick: Executing query callback (stmt->id = 19, stmt->error = 0, stmt->callback = OnPlayerLoaded)... [16:27:17] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 19)... [16:27:17] [debug]Natives::sql_free_result: Freeing statement (stmt->id = 19)... [16:27:17] [debug]Natives::sql_query: Executing statement (stmt->id = 20, stmt->query = INSERT INTO `log_transfer` VALUES ('','-1','0','2015-9-30 16:27:17','0','0','0','win'))... [16:27:17] [debug]Natives::sql_query: Statement executed (stmt->id = 20, stmt->error = 0). No callback found! [16:27:17] [debug]Natives::sql_query: Scheduling statement (stmt->id = 21, stmt->query = UPDATE `accounts` SET `money` = '0' WHERE `id` = '0', stmt->callback = ) for execution... [16:27:17] [debug]SQL_Worker[1]: Executing query (stmt->id = 21, stmt->query = UPDATE `accounts` SET `money` = '0' WHERE `id` = '0')... [16:27:17] [debug]ProccessTick: Executing query callback (stmt->id = 21, stmt->error = 0, stmt->callback = )... [16:27:17] [debug]ProccessTick: Erasing query (stmt->id = 21)... [16:27:26] [debug]Natives::sql_escape_string: Escaping (conn->id = 1) string '123456'... [16:27:42] [debug]Natives::sql_escape_string: Escaping (conn->id = 1) string '1234@mail.ru'... [16:27:42] [debug]Natives::sql_query: Executing statement (stmt->id = 22, stmt->query = SELECT `id` FROM `accounts` WHERE `email` = '1234@mail.ru')... [16:27:42] [debug]Natives::sql_query: Executing statement callback (stmt->id = 22, stmt->error = 2013, stmt->callback = )... [16:27:42] [debug]Natives::sql_num_rows: Retrieving the count of rows (stmt->id = 22)...
трудно сказать что то по mysql , т.к с ним в основном не работал. Ну дело похоже в старых плагинах нужно обновить скиньте список плагинов что у вас вписаны в мод.
Загрузка страницы, займет меньше минуты...
zm-jail.ru 
