MySQL r37 account login problem
#6

You're not even requesting a query, this could do the job:

PHP код:
public OnAccountLoad(playerid)
{
    new 
query[128];
    
    
format(querysizeof(query), "SELECT * FROM `accounts` WHERE Name = '%e'"GetPlayerNameEx(playerid0)); // replace getplayernameex with your own function
    
new Cache:result mysql_query(MySQL_Connectionquery); // replace mysql_connection with your own
    
new count cache_get_row_count();
    
    for(new 
0counti++)
    {
        
PlayerInfo[playerid][pAdminLevel] = cache_get_field_content_int(0"AdminLevel");
    }
    
TogglePlayerSpectating(playeridfalse);
    
SpawnPlayer(playerid);
    
SendClientMessage(playerid, -1"You have successfully logged in.");
    return 
1;

I haven't tested it, but it might work.
Reply


Messages In This Thread
MySQL r37 account login problem - by legho - 23.12.2015, 12:26
Re: MySQL r37 account login problem - by TwinkiDaBoss - 23.12.2015, 13:21
Re: MySQL r37 account login problem - by legho - 23.12.2015, 13:28
Re: MySQL r37 account login problem - by Jimmy0wns - 23.12.2015, 13:31
Re: MySQL r37 account login problem - by legho - 23.12.2015, 13:33
Re: MySQL r37 account login problem - by Jimmy0wns - 23.12.2015, 13:38
Re: MySQL r37 account login problem - by legho - 23.12.2015, 13:46
Re: MySQL r37 account login problem - by TwinkiDaBoss - 23.12.2015, 15:24
Re: MySQL r37 account login problem - by legho - 23.12.2015, 15:49
Re: MySQL r37 account login problem - by legho - 23.12.2015, 15:54

Forum Jump:


Users browsing this thread: 1 Guest(s)