How to View Player stats in MySQL? - 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: How to View Player stats in MySQL? (
/showthread.php?tid=476439)
How to View Player stats in MySQL? -
hewittpro - 18.11.2013
Hey How do I go through all the players stats in the database? PHPMyAdmin is what i'm using right now but can someone just tell me how to go through the information and edit it? thanks guys!
Re: How to View Player stats in MySQL? -
Wizzy951 - 18.11.2013
I didn't get, are you trying to edit the information in PhpMyAdmin or you want to edit information ingame ?
Re: How to View Player stats in MySQL? -
Isolated - 18.11.2013
Use queries to select the information you want, then highlight it and depending on the version you are using you should be able to edit it, otherwise use UPDATE.
Код:
UPDATE `Table` SET `column` = value WHERE `Username` = `Username`;
or to select
Код:
SELECT * FROM `Table` WHERE `Username`;
That is using a wildcard, if you want to use it without that's fine just enter the column name.