• Страница 1 из 1
  • 1
Модератор форума: drifter-dron, admin, TweIk  
Форум » Pawno » Вопросы по скриптингу » Регистрация через SQL
Регистрация через SQL
denis5819Дата: Среда, 30.09.2015, 16:54:51 | Сообщение # 1

Группа: Пользователи
Сообщений: 1
Помогите, когда регистрируюсь выключается сервер.

Server_LOG

Код
[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)...


Скачать мод: https://yadi.sk/d/R0PWLxJtjNfYy
Скачать SQL: https://yadi.sk/d/ZtryLxABjNi5V
 
СообщениеПомогите, когда регистрируюсь выключается сервер.

Server_LOG

Код
[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)...


Скачать мод: https://yadi.sk/d/R0PWLxJtjNfYy
Скачать SQL: https://yadi.sk/d/ZtryLxABjNi5V

Автор - denis5819
Дата добавления - 30.09.2015 в 16:54:51
adminДата: Четверг, 01.10.2015, 23:02:18 | Сообщение # 2

Группа: Администраторы
Сообщений: 3869
трудно сказать что то по mysql , т.к с ним в основном не работал.
Ну дело похоже в старых плагинах нужно обновить скиньте список плагинов что у вас вписаны в мод.


zm-jail.ru

Разработка сайта samp-pawno.ru


 
Сообщениетрудно сказать что то по mysql , т.к с ним в основном не работал.
Ну дело похоже в старых плагинах нужно обновить скиньте список плагинов что у вас вписаны в мод.

Автор - admin
Дата добавления - 01.10.2015 в 23:02:18
Форум » Pawno » Вопросы по скриптингу » Регистрация через SQL
  • Страница 1 из 1
  • 1
Поиск:
Загрузка страницы, займет меньше минуты...
Загрузка...

Статистика Форума
Последнии темы Читаемые темы Лучшие пользователи Новые пользователи
pawno урок автоматические ворота
обращение к скриптерам.
Услуги скриптинга и Так же MAP's
pawno(основым скриптинга для новичков)
Вопросы по скриптингу
Ваши ошибки при компиляции GM/FS
DistHost.Pro - это одна из начинающих компаний
[Продажа] Admin Panel System 1.3
Ищу команду разработчиков
Заказ шаблон
Вопрос
[Продажа] Battleground TDM

Вопросы по скриптингу

(1082)

Считаем до 1000

(274)

Ваши ошибки при компиляция gm

(260)

Набор в команду

(80)

Ваши ошибки при компиляции GM/FS

(72)

Баннеробмен

(64)

несколько команд на samp 0.3 c

(64)

вопроосы по скриптингу от 22.04.2013

(64)

Оценки сайта samp-pawno.ru

(55)

Заказ хостинга

(51)

Набор в команду(форум)

(45)

Урок №61 по созданию системы авто для GodFather

(45)

admin

(3869)

[east_side]_trane

(443)

TWiX

(316)

valych

(501)

drifter-dron

(477)

danik_rok

(317)

Dimka_71rus

(360)

Drifter96

(300)

MaNb9K

(220)

[MTA]MaPeR5518

(181)

Dima_Tkach

(107)

Nik_Ull

(184)

nikitos2004tukov

(Воскресенье 22:42:11)

Giovanni_Masini

(Воскресенье 09:08:42)

33pavlovkostya

(Пятница 09:23:23)

vporub

(Четверг 18:13:04)

nitrest03

(Вторник 22:40:39)

thebestdanceradio

(Вторник 18:57:33)

ovvf

(Понедельник 04:11:50)

gulajux

(Четверг 13:18:44)

serega7449

(Понедельник 18:56:35)

ezdackovmatvei

(Понедельник 15:51:17)

andreyzaytsev99

(Воскресенье 17:59:45)

rs-aka

(Воскресенье 14:06:37)

Вверх
05:07:54
ОбновитьСмайлыУправление мини-чатом
ЧАТ-PAWNO
2010-2018

vkontakte :samp-pawno.ru: