+ open.mp forum (https://forum.open.mp)
-- Forum: SA-MP (https://forum.open.mp/forumdisplay.php?fid=3)
--- Forum: Pawn Scripting (https://forum.open.mp/forumdisplay.php?fid=10)
--- Thread: [Pawn] refresh query every 1 sec (/showthread.php?tid=1970)
refresh query every 1 sec - Zow - 2021-05-01
I want to refresh pCoin after people refill wallet
but I don't know how to do it better
just want real time Coin after refill
Code:
ptask RefreshCoinTimer[1000](playerid) {
? ? if (!LoginStatus[playerid]) {
? ? ? ? return 0;
? ? }
? ? new
? ? ? ? query[100]
? ? ;
? ? mysql_format(dbCon, query, sizeof(query),
? ? "\
? ? ? ? SELECT \
? ? ? ? ? ? pCoin \
? ? ? ? FROM \
? ? ? ? ? ? players \
? ? ? ? WHERE \
? ? ? ? ? ? ID= %d\
? ? ",
? ? ? ? PlayerInfo[playerid][pID]
? ? );
? ? mysql_tquery(dbCon, query, "RefreshCoin", "i", playerid);
? ? return 1;
}
forward RefreshCoin(playerid);
public RefreshCoin(playerid) {
? ? cache_get_value_name_int(0, "pCoin", coin);
? ? PlayerInfo[playerid][pCoin] = coin;
}RE: refresh query every 1 sec - AbyssMorgan - 2021-05-01
Best solution if you dont show player coin in GUI. When player buy coin update coin in database side. If player want use coin in game then get current value from database and if he have enought coin then also update it in database side.
RE: refresh query every 1 sec - Radical - 2021-05-01
Refresh query every 1 second is terrible.
Add a command like /coin and ask the user to type this command if he/she refills the wallet and then refresh the pCoin.
The AbyssMorgan's solution is also good.
RE: refresh query every 1 sec - Y_Less - 2021-05-01
How do you refill the wallet? Is it only ingame, or can you do that externally (e.g. from a website)?
RE: refresh query every 1 sec - Zow - 2021-05-01
(2021-05-01, 05:17 PM)Y_Less Wrote: How do you refill the wallet?? Is it only ingame, or can you do that externally (e.g. from a website)?
Yes, from a website
refill > update coin and just do some crazy stuff to load them real time
this is how my refill site look like