Server crashes when I login (MySQL)
#9

pawn Code:
case DIALOG_LOGIN:
        {
            if(!response)
            {
                SendClientMessage(playerid, RED, "You must login before you spawn!");
                ShowDialog(playerid, DIALOG_LOGIN);
            }
            if(response)
            {
                new query[200], pname[24], escapepass[100];
                GetPlayerName(playerid, pname, 24);
                mysql_real_escape_string(inputtext, escapepass);
                format(query, sizeof(query), "SELECT `user` FROM playerdata WHERE user = '%s' AND password = SHA1('%s')", pname, escapepass);
                mysql_query(query);
                mysql_store_result();
                new numrows = mysql_num_rows();
                if(numrows == 1)
                {
                    MySQL_Login(playerid);
                    Muted[playerid] = 0;
                    SendClientMessage(playerid, GREEN, "You have successfully logged in");
                    new string[256];
                    Clan[playerid] = pInfo[playerid][pClan];
                }
Reply


Messages In This Thread
Server crashes when I login (MySQL) - by MythicalMarauder - 03.01.2015, 14:35
Re: Server crashes when I login (MySQL) - by Kelbac - 03.01.2015, 14:37
Re: Server crashes when I login (MySQL) - by NLFMaster - 03.01.2015, 14:37
Re: Server crashes when I login (MySQL) - by Gaurav_Rawat - 03.01.2015, 14:43
Re: Server crashes when I login (MySQL) - by MythicalMarauder - 03.01.2015, 14:48
Re: Server crashes when I login (MySQL) - by NLFMaster - 03.01.2015, 14:49
Re: Server crashes when I login (MySQL) - by MythicalMarauder - 03.01.2015, 14:56
Re: Server crashes when I login (MySQL) - by NLFMaster - 03.01.2015, 14:59
Re: Server crashes when I login (MySQL) - by MythicalMarauder - 03.01.2015, 15:00
Re: Server crashes when I login (MySQL) - by NLFMaster - 03.01.2015, 15:07

Forum Jump:


Users browsing this thread: 1 Guest(s)