[guitardude01]

I have a login and register system that uses MYSQL. For some reason, even if the user enters the right or wrong password, it says that the password is incorrect, any suggestions?

PHP код:

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    new name1[MAX_PLAYER_NAME+1];
    GetPlayerName(playerid, name1, sizeof(name1));
    switch( dialogid )
    {
        case DIALOG_REGISTER:
        {
            if (!response) return Kick(playerid);
            if(response)
            {
                if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, ""COL_WHITE"Registering...",""COL_RED"You have not entered a password.\n"COL_WHITE"Type a password below to register a new account.","Register","Quit");
                WP_Hash(pVariables[playerid][pPassword], 129, inputtext);
                pVariables[playerid][pMoney] = 1500;
                mysql_format(mysql, query, sizeof(query), "INSERT INTO `users` (`Username`, `Password`, `IP`, `Admin`, `Helper`, `VIP`, `Money`, `PosX`, `PosY`, `PosZ`) VALUES ('%s', '%s', '%s', 0, 0, 0, 1500, '%f', '%f', '%f')", Name[playerid], pVariables[playerid][pPassword], IP[playerid], Spawn_X, Spawn_Y, Spawn_Z);
                mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);
            }
        }
        case DIALOG_LOGIN:
        {
            if ( !response ) return Kick ( playerid );
            if( response )
            {
                new hpass[129];
                WP_Hash(hpass, 129, inputtext);
                if(!strcmp(hpass, pVariables[playerid][pPassword]))
                {
                    mysql_format(mysql, query, sizeof(query), "SELECT * FROM `users` WHERE `Username` = '%s' LIMIT 1", name1);
                    mysql_tquery(mysql, query, "OnAccountLoad", "i", playerid);
                }
                else
                {
                    ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD,""COL_WHITE"Login",""COL_RED"You have entered an incorrect password.\n"COL_WHITE"Type your password below to login.","Login","Quit");
                }
                return 1;
            }
        }
    }
    return 1;
} 


[guitardude01]

Any suggestions?

[ball]

Show pVariables[playerid][pPassword]

[guitardude01]

PHP код:

pVariables[playerid][pPassword] = cache_get_field_content(0, "Password", dest); 


[guitardude01]

Ok, its getting what they're typed in, but it wont retrieve their real password. When it trys to retrieve it, it says NULL.

[guitardude01]

Anyone?

[DobbysGamertag]

Have you read the documentation?

pawn Код:

cache_get_field_content(row, const field_name[], destination[], connectionHandle = 1, max_len = sizeof(destination))

So for you:

pawn Код:

cache_get_field_content(0,"Password",pVariables[playerid][pPassword],dbhandle,sizeof(pVariables[playerid][pPassword]));

Then try:

pawn Код:

printf("%s",pVariables[playerid][pPassword]);

Just in-case you're on a windows server with MySQL. The field names are converted to lowercase occasionally. So 'Password' may be 'password'.

[Fred1993]

in my sql i use this command to save the password in database

Quote:

mysql_real_escape_string(inputtext, inputtext);

It works fine for me..
it stores the password as the user entered, and also you can compair it when the user enter password on login

[guitardude01]

None of these work

[guitardude01]

Anyone?