SA-MP Forums Archive
[HELP] mysql login problem - 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] mysql login problem (/showthread.php?tid=495756)



[HELP] mysql login problem - Luca12 - 18.02.2014

Hello So I was type my corect password and I spawned and dialog appear and it says that is the password incorect


Re: [HELP] mysql login problem - [D]ry[D]esert - 18.02.2014

NO Code = NO Help


Re: [HELP] mysql login problem - Luca12 - 18.02.2014

here's the login part

pawn Код:
if(dialogid == 1)
    {
        if(response)
        {
            if(strlen(inputtext) < MIN_DUZINA_LOZINKE || strlen(inputtext) > MAX_DUZINA_LOZINKE)
            {
                new LozinkaString[128];
                format(LozinkaString,sizeof LozinkaString,"*G-Unit: Lozinka ne smije biti manja od %d,a veca od %d!",MIN_DUZINA_LOZINKE,MAX_DUZINA_LOZINKE);
                SendClientMessage(playerid,0xDB023EFF,LozinkaString);
                new name[MAX_PLAYER_NAME],loginstring[512];
                GetPlayerName(playerid,name,sizeof(name));
                format(loginstring,sizeof(loginstring),"{00C0FF}_____________________________________\n\n{FFFFFF}Dobrodošao na G-Unit RolePlay/Dm Server! {00C0FF}\n\n%s\n{FFFFFF}Vas je korisnicki racun pronadjen!\n\nMolimo upisi lozinku da udjes na server:\n{00C0FF}_______________________________________",name);
                ShowPlayerDialog(playerid,1,DIALOG_STYLE_PASSWORD,"{FFFFFF}Prijava",loginstring,"Logiraj","Izlaz");
                return 1;
            }
            new query[200],pname[24],escapepass[500];
            GetPlayerName(playerid,pname,24);
            format(query, sizeof(query),"SELECT `Nick` FROM users WHERE Nick = '%s' AND Password = SHA1('%s')",pname,escapepass);
            mysql_query(query);
            mysql_store_result();
            mysql_real_escape_string(inputtext,escapepass);
            new numrows = mysql_num_rows();
            if(numrows == 0)
            {
                MYSQL_Login(playerid);
            }
            if(!numrows)
            {
                new name[MAX_PLAYER_NAME];
                GetPlayerName(playerid,name,sizeof(name));
                new loginstring[512];
                format(loginstring,sizeof(loginstring),"{00C0FF}________________________________{F81414}\n[Greska] Unijeli ste kratku ili netocnu lozinku\n\n{FFFFFF}Vas je racun pronadjen!\n{00C0FF}%s\n\n{FFFFFF}Molimo upisite vasu lozinku:\n{00C0FF}_____________________________________",name);
                ShowPlayerDialog(playerid,1,DIALOG_STYLE_PASSWORD,"{FFFFFF}Prijava",loginstring,"Logiraj","Izlaz");
                hPokusajiLogiranja[playerid]++;
                if(hPokusajiLogiranja[playerid] >= MAX_POKUSAJA_LOGIRANJA)
                {
                    SCM(playerid,0xDB023EFF,"G-Protect: {FFFFFF}Vas account je trenutno iskljucen sa servera! Unijeli ste 3 puta netocnu lozinku!");
                    SCM(playerid,COLOR_WHITE,"G-Protect: Vasa IP adresa je banana!");
                    KickWithMessage(playerid);
                    h_Ban(playerid);
                }
            }
            mysql_free_result();
        }
        return 1;
    }



Re: [HELP] mysql login problem - Luca12 - 19.02.2014

anyone?thankks