SA-MP Forums Archive
MySQL - data refresh - 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: MySQL - data refresh (/showthread.php?tid=650952)


MySQL - data refresh - Oficer - 10.03.2018

Hi, I have problem with MySQL BlueG r-41, I have command with query:
PHP код:
CMD:giveadmin(playerid, params[])
{
    new query[500];
    mysql_format(DB, query, sizeof(query), "UPDATE `test` SET `Admin`='%s' WHERE `Nick`='%s'", params, GetPlayerNick(playerid)); 
    mysql_query(DB, query); 
    return 1;
} 
And enum with data player
{
....
Admin
}

PHP код:
forward OnAccountLoad(playerid);  <-- When player is logging
public OnAccountLoad(playerid)
{
...
cache_get_value_int(0, "Admin", Player[playerid][Admin]);
} 
When Player is in game data are loaded and level admin is correct, but when I change this level I always must leave the game, to data has been re-loaded. How refresh data player in game ? (This is version MySQL with cache)

sorry for my english, I'm polish.

Re: MySQL - data refresh - PepsiCola23 - 10.03.2018

you also has to set his variable so it applies imeddiately.

PHP код:
CMD:giveadmin(playerid, params[]) 
{ 
    Player[playerid][Admin] = params;
    new query[500]; 
    mysql_format(DB, query, sizeof(query), "UPDATE `test` SET `Admin`='%s' WHERE `Nick`='%s'", params, GetPlayerNick(playerid));  
    mysql_query(DB, query);  
    return 1; 
}