SA-MP Forums Archive
HELP!!! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: HELP!!! (/showthread.php?tid=491880)



HELP!!! - Vege - 01.02.2014

Код:
[21:18:13] [join] Jixy_Scott has joined the server (1:192.168.1.1)
[21:18:20] [debug] Server crashed while executing whatever.amx
[21:18:20] [debug] AMX backtrace:
[21:18:20] [debug] #0 native mysql_fetch_field_row () [003d6700] from mysql.DLL
[21:18:20] [debug] #1 0018e85c in MySQL_Login (playerid=1) at D:\Game\Scripting\gamemodes\whatever.pwn:26835
[21:18:20] [debug] #2 0018b1e0 in public OnDialogResponse (playerid=1, dialogid=4766, response=1, listitem=-1, inputtext[]=@0x0030e22c "123456") at D:\Game\Scripting\gamemodes\whatever.pwn:26574
[21:18:20] [debug] System backtrace:
[21:18:20] [debug] #0 003d952e in ?? () from D:\Game\Scripting\plugins\mysql.DLL
[21:18:20] [debug] #1 003d67d3 in ?? () from D:\Game\Scripting\plugins\mysql.DLL
[21:18:20] [debug] #2 004010b6 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #3 6fc939e2 in ?? () from D:\Game\Scripting\plugins\crashdetect.DLL
[21:18:20] [debug] #4 6fc95e26 in ?? () from D:\Game\Scripting\plugins\crashdetect.DLL
[21:18:20] [debug] #5 6fc8bf3f in ?? () from D:\Game\Scripting\plugins\crashdetect.DLL
[21:18:20] [debug] #6 6fc93a0e in ?? () from D:\Game\Scripting\plugins\crashdetect.DLL
[21:18:20] [debug] #7 0046dac1 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #8 00452850 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #9 77de1fbd in ?? () from C:\Windows\SYSTEM32\ntdll.dll
[21:18:20] [debug] #10 00498cc9 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #11 0045b26a in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #12 003d16df in ?? () from D:\Game\Scripting\plugins\mysql.DLL
[21:18:20] [debug] #13 003d81b2 in ?? () from D:\Game\Scripting\plugins\mysql.DLL
[21:18:20] [debug] #14 00488bdd in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #15 5c8b01f8 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #16 61750824 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #17 85084e8b in ?? ()
[21:18:20] [debug] #18 530674c9 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #19 fd9a6be8 in ?? ()
[21:18:20] [debug] #20 0c4e8bff in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #21 0674c985 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #22 a7eee853 in ?? ()
[21:18:20] [debug] #23 4e8bfffd in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #24 74c98514 in ?? () from C:\Windows\System32\mswsock.dll
[21:18:20] [debug] #25 91e85306 in ?? ()
[21:18:20] [debug] #26 8bfffd89 in ?? ()
[21:18:20] [debug] #27 74c9850e in ?? () from C:\Windows\System32\mswsock.dll
[21:18:20] [debug] #28 c5e85306 in ?? ()
[21:18:20] [debug] #29 57fffe01 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #30 85387e8b in ?? ()
[21:18:20] [debug] #31 d91774ff in ?? ()
[21:18:20] [debug] #32 d80c2444 in ?? ()
[21:18:20] [debug] #33 4b072c0d in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #34 743ee800 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #35 8b500000 in ?? ()
[21:18:20] [debug] #36 1d16e8cf in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #37 4e8bffff in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #38 5fc98534 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #39 d9e83074 in ?? ()
[21:18:20] [debug] #40 ebffff0d in ?? ()
[21:18:20] [debug] #41 02f88329 in ?? ()
[21:18:20] [debug] #42 05d92475 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #43 004f2510 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #44 082444d8 in ?? () from D:\Game\Scripting\samp-server.exe
[21:18:20] [debug] #45 00abefb0 in ?? ()
What's the problem :/ ?

pawn Код:
stock MySQL_Login(playerid)
{
    new query[300], result[256], string[256];
    format(query, sizeof(query), "SELECT * FROM `Accounts` WHERE `Nick` = '%s'", GetName(playerid));
    mysql_query(query);
    mysql_store_result();
    new rows = mysql_num_rows();
    if(rows)
    {
        while(mysql_retrieve_row())
        {
            mysql_fetch_field_row(result,"Admin");
            PlayerInfo[playerid][Admin] = strval(result);
            mysql_fetch_field_row(result,"Helper");
            PlayerInfo[playerid][Helper] = strval(result);
            mysql_fetch_field_row(result,"VIP");
            PlayerInfo[playerid][vipplayer] = strval(result);
            mysql_fetch_field_row(result,"Score");
            PlayerInfo[playerid][Score] = strval(result);
            mysql_fetch_field_row(result,"Money");
            PlayerInfo[playerid][Money] = strval(result);
            mysql_fetch_field_row(result,"Kills");
            PlayerInfo[playerid][Kills] = strval(result);
            mysql_fetch_field_row(result,"Deaths");
            PlayerInfo[playerid][Deaths] = strval(result);
        }
    }




case 4766:
        {
           if(!response)
           {
                Kick(playerid);
           }
            new query[256], escapepass[100], string[256];
            mysql_real_escape_string(inputtext, escapepass);
            format(query, sizeof(query), "SELECT * FROM `Accounts` WHERE `Nick` = '%s' AND `Password` = '%s'", GetName(playerid), escapepass);
            mysql_query(query);
            mysql_store_result();
            new numrows = mysql_num_rows();
            if(numrows == 1)
            {
                MySQL_Login(playerid); //line 26574
            }
            else
            {
                format(string, sizeof(string), "[ERROR] "cwhite"Incorrect Password");
                SCM(playerid, red, string);
                format(string, sizeof(string),""cwhite"Welcome "cred"%s "cwhite"you are already registered\nKindly enter           password to login to your account\n"cred"Incorrect password!", PlayerName2(playerid));
                ShowPlayerDialog(playerid, 4766, DIALOG_STYLE_PASSWORD, "Login",string,"Login","");
            }
            mysql_free_result();
        }
I am using MySQL plugin version R6.