SA-MP Forums Archive
problem with the mysql admin - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: problem with the mysql admin (/showthread.php?tid=650834)



problem with the mysql admin - wallen - 07.03.2018

Well i made a little system that when you log in rcon you get level 4.

PHP код:
    if(success)
    {
        foreach(new 
playerid Player){
         if(
pInfo[playerid][Level] != 4// to check if the player DOESN'T has the level 4.
        
{
            new 
query[256], str[150];
            
mysql_format(Databasequerysizeof(query), "UPDATE `players` SET `ADMIN` = '%i' WHERE `players`.`ID` = %i"pInfo[playerid][Admin], pInfo[playerid][ID]);
            
pInfo[playerid][Admin] = 4;
            
SendClientMessage(playerid, -"You logged in throught rcon and got automatically level 4 admin.");
            
            if(
pInfo[playerid][Admin] > 4)
               
format(str,sizeof(str), "{0066ff}(admin) %s has logged as server management (rcon)."PlayerName[playerid]);
             
SendMessageToAdmins(str);}
        }
    } 
But when i get admin level 4 on name "test2" then i create another account named "test3" i still got the admin from the old account.


Re: problem with the mysql admin - Sew_Sumi - 07.03.2018

Then you aren't clearing the admin level on player disconnect. And because you reconnect to the same ID, you get that left over admin level.


Re: problem with the mysql admin - rfr - 07.03.2018

did you reset the enum or variable because the server for example thinks you're still id 0 all the time unless you reset all vars on disconnect so it doesnt read old data

temporary solution for this is

OnPlayerDisconnect(playerid)
{
pInfo[playerid][Admin] = 0;
return 1;
}


for means for all users with the playerid = playerid (e.g. 0), it will reset it to 0 so if another player comes on with playerid of 0, their admin level will be 0 since the previous player (with id) disconnected and the server set it to 0.


Re: problem with the mysql admin - wallen - 07.03.2018

Yeah,il'll try to figure it out once ill get back to pc


Re: problem with the mysql admin - Sew_Sumi - 07.03.2018

Quote:
Originally Posted by rfr
Посмотреть сообщение
temporary solution for this is

OnPlayerDisconnect(playerid)
{
pInfo[playerid][Admin] = 0;
return 1;
}
That is THE solution... Variables don't magically clear themselves.