[Gangster-rocks]

I've just started with mysql R7, Well, My registration system works fine, but my login system doesn't work, here is the codes

pawn Код:

//dialog
else if(dialogid == 1)
    {
        if(!response) return Kick(playerid);
        if(strlen(inputtext) <= 0) return SCM(playerid,-1,"{FFCC66}[SERVER]: {ffffff}You must input a password."),  ShowPlayerDialog(playerid,1,DIALOG_STYLE_PASSWORD,"{FFFFFF}Login",""COL_RED"INSERT A PASSWORD!","Login","QUIT");
        if(response)
        {
            new query[400];
            format(query,400,"SELECT username FROM stats WHERE username = '%s' AND password = '%s'",GN(playerid),escstring(inputtext));
            mysql_function_query(dbHandle,query,false,"CheckPassword","i",playerid);
        }
    }
//The function for the query.
function CheckPassword(playerid)
{
    new rows,fields;
    cache_get_data(rows,fields,dbHandle);
    if(!rows)
    {
        ShowPlayerDialog(playerid,1,DIALOG_STYLE_PASSWORD,"{ffffff}Login","Wrong password","Login","Close");
    }
    else if(rows == 1)
    {
        LoadAccount(playerid);
    }
}

login system allows me to login with any password

[-Prodigy-]

Try

pawn Код:

mysql_function_query(dbHandle,query,true,"CheckPassword","i",playerid);

[Gangster-rocks]

Thanks for helping, but i've already solved it.

[Scenario]

Hash your passwords!!!

[Gangster-rocks]

Quote:

Originally Posted by RealCop228 Hash your passwords!!!

Am using a ucp for my server, i can't hash password tho.

[Scenario]

That doesn't mean anything! Use Whirlpool hashing!