[Sanady]

Hello When I restart my internet for new IP i try to login into my account but I can`t login.I don`t know why

Here is code

pawn Код:

stock LoginPlayer(playerid,const password[])
{
    new string[165], buffer[129];
    WP_Hash(buffer,sizeof(buffer),password);
    format(Query,sizeof(Query),"SELECT Password FROM `Accounts` WHERE `Username` = '%s' AND `Password` = '%s'",GetPName(playerid),buffer);
    mysql_query(Query);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        format(string,sizeof(string),""embed_sw"[LOGIN]"embed_white"You have been logged in! Welcome back, "embed_orange"%s"embed_white"!",GetPName(playerid));
        SendClientMessage(playerid,green,string);
        LoadStats(playerid);
        pData[playerid][Logged] = 1;
        PlaySound(playerid,1057);
    }
    else
    {
        pData[playerid][FailedLogins]++;
        format(string,sizeof(string),"{FFFFFF}Attempts left: "corange"%i \n{FFFFFF}Hey, "cred"%s{FFFFFF}! \nYour account is registered{FFFFFF}.\nPlease enter the password {FFFFFF}to log in!",3-pData[playerid][FailedLogins],GetPName(playerid));
        ShowPlayerDialog(playerid,Logindialog,DIALOG_STYLE_INPUT,""cgreen2"Log in",string,"Login","");
        PlaySound(playerid,1055);
        if(pData[playerid][FailedLogins] == 3)
        {
            format(string,sizeof(string),""embed_sw"[AUTOLOGIN] "embed_red"%s "embed_white"has been automatically kicked as he entered the wrong login password "embed_orange"3 "embed_white"times in a row",GetPName(playerid));
            SendClientMessageToAll(red,string);
            SendClientMessage(playerid,red,""embed_sw"[AUTOLOGIN]"embed_white"You have been kicked as you have entered the wrong login password "embed_orange"3 "embed_white"times!");
            PlaySound(playerid,1141);
            Kick(playerid);
        }
    }
    mysql_free_result();
    return 1;
}

I am using Blood Register/Login System

[CROSS_Hunter]

check your script files and see if you have the correct directories that the registration system requires

[Sanady]

Quote:

Originally Posted by CROSS_Hunter check your script files and see if you have the correct directories that the registration system requires

Hahahaahah It`s MySQL.It`s all about databases and saving.But Password loading is bugged how I see but I don`t know how to fix it.Please Someone else can help me ?

[kelvin22]

pawn Код:

stock LoginPlayer(playerid,const password[])
{
    new string[165], buffer[60];
    WP_Hash(buffer,sizeof(buffer),password);
    mysql_real_escape_string(password, buffer);
    format(Query,sizeof(Query),"SELECT Password FROM `Accounts` WHERE `Username` = '%s' AND `Password` = '%s'",GetPName(playerid),buffer);
    format(Query,sizeof(Query),"SELECT * FROM `Accounts` WHERE `Username` = '%s' AND `Password` = '%s'",GetPName(playerid),buffer);
    mysql_query(Query);
    mysql_store_result();
    if(!mysql_num_rows() == 0)
    {
        format(string,sizeof(string),""embed_sw"[LOGIN]"embed_white"You have been logged in! Welcome back, "embed_orange"%s"embed_white"!",GetPName(playerid));
        SendClientMessage(playerid,green,string);
        LoadStats(playerid);
        pData[playerid][Logged] = 1;
        PlaySound(playerid,1057);
    }
    else
    {
        pData[playerid][FailedLogins]++;
        format(string,sizeof(string),"{FFFFFF}Attempts left: "corange"%i \n{FFFFFF}Hey, "cred"%s{FFFFFF}! \nYour account is registered{FFFFFF}.\nPlease enter the password {FFFFFF}to log in!",3-pData[playerid][FailedLogins],GetPName(playerid));
        ShowPlayerDialog(playerid,Logindialog,DIALOG_STYLE_INPUT,""cgreen2"Log in",string,"Login","");
        PlaySound(playerid,1055);
        if(pData[playerid][FailedLogins] == 3)
        {
            format(string,sizeof(string),""embed_sw"[AUTOLOGIN] "embed_red"%s "embed_white"has been automatically kicked as he entered the wrong login password "embed_orange"3 "embed_white"times in a row",GetPName(playerid));
            SendClientMessageToAll(red,string);
            SendClientMessage(playerid,red,""embed_sw"[AUTOLOGIN]"embed_white"You have been kicked as you have entered the wrong login password "embed_orange"3 "embed_white"times!");
            PlaySound(playerid,1141);
            Kick(playerid);
        }
    }
    mysql_free_result();
    return 1;
}

This should work, but try it I haven't test it.

[Sanady]

Quote:

Originally Posted by kelvin22 pawn Код: stock LoginPlayer(playerid,const password[]) {     new string[165], buffer[60];     WP_Hash(buffer,sizeof(buffer),password);     mysql_real_escape_string(password, buffer);     format(Query,sizeof(Query),"SELECT Password FROM `Accounts` WHERE `Username` = '%s' AND `Password` = '%s'",GetPName(playerid),buffer);     format(Query,sizeof(Query),"SELECT * FROM `Accounts` WHERE `Username` = '%s' AND `Password` = '%s'",GetPName(playerid),buffer);     mysql_query(Query);     mysql_store_result();     if(!mysql_num_rows() == 0)     {         format(string,sizeof(string),""embed_sw"[LOGIN]"embed_white"You have been logged in! Welcome back, "embed_orange"%s"embed_white"!",GetPName(playerid));         SendClientMessage(playerid,green,string);         LoadStats(playerid);         pData[playerid][Logged] = 1;         PlaySound(playerid,1057);     }     else     {         pData[playerid][FailedLogins]++;         format(string,sizeof(string),"{FFFFFF}Attempts left: "corange"%i \n{FFFFFF}Hey, "cred"%s{FFFFFF}! \nYour account is registered{FFFFFF}.\nPlease enter the password {FFFFFF}to log in!",3-pData[playerid][FailedLogins],GetPName(playerid));         ShowPlayerDialog(playerid,Logindialog,DIALOG_STYLE_INPUT,""cgreen2"Log in",string,"Login","");         PlaySound(playerid,1055);         if(pData[playerid][FailedLogins] == 3)         {             format(string,sizeof(string),""embed_sw"[AUTOLOGIN] "embed_red"%s "embed_white"has been automatically kicked as he entered the wrong login password "embed_orange"3 "embed_white"times in a row",GetPName(playerid));             SendClientMessageToAll(red,string);             SendClientMessage(playerid,red,""embed_sw"[AUTOLOGIN]"embed_white"You have been kicked as you have entered the wrong login password "embed_orange"3 "embed_white"times!");             PlaySound(playerid,1141);             Kick(playerid);         }     }     mysql_free_result();     return 1; } This should work, but try it I haven't test it.

It`s not working Anyone else ?