[Loinal]

Hey guys i started my new mysql admin system from MySQL 3-9 by Jeason and i have a problem that auto login is not working

PHP код:

public OnAccountCheck(playerid)
{
    new rows, fields; //a variable that will be used to retrieve rows and fields in the database.
    cache_get_data(rows, fields, mysql);//let's get the rows and fields from the database.
    if(rows) //if there is row
    {
        cache_get_field_content(0, "IP", IP[playerid], mysql, 16);
        new newIP[16];
        GetPlayerIp(playerid, newIP, 16);
        IsPlayerRegisterd[playerid] = 1;
        if(strlen(IP[playerid]) != 0 && !strcmp(IP[playerid], newIP, true)) //Checks that the MySQL IP has a value and that they are the same.
        {
            GameTextForPlayer(playerid, "Loading Account", 3000, 3);
            new query[100];
            mysql_tquery(mysql, query, "OnAccountLoad", "i", playerid);
        }
        else
        {
            (!strlen(IP[playerid]) || strcmp(IP[playerid], newIP, true));
            //then
            cache_get_field_content(0, "Password", pData[playerid][Password], mysql, 129);
            //we will load player's password into pData[playerid][Password] to be used in logging in
            pData[playerid][ID] = cache_get_field_content_int(0, "ID"); //now let's load player's ID into pData[playerid][ID] so we can use it later
            printf("%s", pData[playerid][Password]); //OPTIONAL: Just for debugging. If it didn't show your password, then there must be something wrong while getting player's password
            new st4[2016+1000];
            ShowPlayerDialog(playerid, dLOGIN, DIALOG_STYLE_INPUT, "Login", "In order to play, you need to login", "Login", "Quit"); //And since we found a result from the database, which means, there is an account; we will show a login dialog
        }
    }
    else //if we didn't find any rows from the database, that means, no accounts were found
    {
        ShowPlayerDialog(playerid, dREGISTER, DIALOG_STYLE_INPUT, "Register", "In order to play, you need to register.", "Register", "Quit");
        //So we show them a dialog register
    }
    return 1;
} 


On account load

PHP код:

public OnAccountLoad(playerid)
{
    new score;
     pData[playerid][Admin] = cache_get_field_content_int(0, "Admin"); //we're getting a field 4 from row 0. And since it's an integer, we use cache_get_row_int
     pData[playerid][VIP] = cache_get_field_content_int(0, "VIP"); //Above
     pData[playerid][Money] = cache_get_field_content_int(0, "Money");//Above
     pData[playerid][Kills] = cache_get_field_content_int(0,"Kills");
     pData[playerid][Deaths] = cache_get_field_content_int(0, "Deaths");
     score = cache_get_field_content_int(0, "Score");
     SetPlayerScore(playerid, score);
     GivePlayerMoney(playerid, pData[playerid][Money]);//Let's set their money
     //For player's position, set it once they spawn(OnPlayerSpawn)
    SendClientMessage(playerid, 0xFF0000F, "Successfully logged in"); //tell them that they have successfully logged in
    return 1;
} 


[Quinncell]

Whats the problem?Do you want us to guess or?

[Loinal]

i said "i have a problem that auto login is not working"

it doesn't load the player data

[Stuntff]

Код:

new name[MAX_PLAYER_NAME];
GetPlayerName(playerid,name,MAX_PLAYER_NAME):
new query[100];
format(query,sizeof(query),"SELECT * FROM `accounts` WHERE Name = '%s'",name);
mysql_tquery(mysql, query, "OnAccountLoad", "i", playerid);

[Loinal]

Where

[ReshiramZekrom]

Do you see "GameTextForPlayer(playerid, "Loading Account", 3000, 3); " in game? Or it doesn't show?

[Loinal]

I dont

[ReshiramZekrom]

Quote:

Originally Posted by Loinal I dont

So the problem it's before.

Try to add this printf before the strcmp check:

PHP код:

printf("IP: %s, %s", newIP, IP[playerid]); 


So when you'll execute the function you'll know exactly where is the problem

[Loinal]

Not working

[ReshiramZekrom]

Quote:

Originally Posted by Loinal Not working

What do you mean with not working? Did you understand my message and what is the aim of that?