[SEnergy]

edit: well login/register is working so far, but I have this error: I can enter ANY password to login, any suggestions?

PHP код:

    if(dialogid == iLoginDialog)
    {
        if(response)
        {
            if(strlen(inputtext) > 0)
            {
                new EscapedText[60];
                mysql_real_escape_string(inputtext, EscapedText);
                new len = strlen(EscapedText);
                format(Query, sizeof(Query), "SELECT `Password` FROM `RL` WHERE `Username` = '%s';", pName);
                mysql_query(Query);
                new result[60];
                mysql_fetch_field_row(result, "Password");
                if(strcmp(EscapedText, result, true, len) == 0)
                {
                    TogglePlayerSpectating(playerid, false);
                    return 1;
                }
            }
            ShowPlayerDialog(playerid, iLoginDialog, DIALOG_STYLE_PASSWORD, "Login", "Enter Your Password!", "Login", "Cancel");
        }
        else
            return 0;
    } 


[Misiur]

Put this under mysql_query in OnPlayerConnect

pawn Код:

printf("User %d looked up in database with response %d", playerid, mysql_errno());

After you connect this will pop up in server console - if the response is diffrent than 0, then query returned an error.

On a sidenote: You've forgotten about executing query in login dialog.

[SEnergy]

Quote:

Originally Posted by Misiur Put this under mysql_query in OnPlayerConnect pawn Код: printf("User %d looked up in database with response %d", playerid, mysql_errno()); After you connect this will pop up in server console - if the response is diffrent than 0, then query returned an error. On a sidenote: You've forgotten about executing query in login dialog.

response 2005, what now?

[Misiur]

Quote:

ERROR 2005 (HY000): Unknown MySQL server host 'XXX'

Your connection host is invalid

[SEnergy]

Quote:

Originally Posted by Misiur Your connection host is invalid

my connection host is the same I'm using for my website, which is working fine, I guess I'll have to install mysql on pc ;/

edit: it's working, thanks!

edit2: well, I can enter ANY password to login, any suggestions?

PHP код:

    if(dialogid == iLoginDialog)
    {
        if(response)
        {
            if(strlen(inputtext) > 0)
            {
                new EscapedText[60];
                mysql_real_escape_string(inputtext, EscapedText);
                new len = strlen(EscapedText);
                format(Query, sizeof(Query), "SELECT `Password` FROM `RL` WHERE `Username` = '%s';", pName);
                mysql_query(Query);
                new result[60];
                mysql_fetch_field_row(result, "Password");
                if(strcmp(EscapedText, result, true, len) == 0)
                {
                    TogglePlayerSpectating(playerid, false);
                    return 1;
                }
            }
            ShowPlayerDialog(playerid, iLoginDialog, DIALOG_STYLE_PASSWORD, "Login", "Enter Your Password!", "Login", "Cancel");
        }
        else
            return 0;
    } 


[doreto]

You cant use website datebase for home server

[SEnergy]

bump?