How To Save Player Stats On mysql-

How To Save Player Stats On 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 Save Player Stats On mysql- (/showthread.php?tid=522826)

How To Save Player Stats On mysql- - danish007 - 29.06.2014

How can i save player stats or anything like
if i've added pDonator in PlayerInfo Enum How Can i Save This On Mysql databse?

i've a scritp there is other things saved
code

Код:

format(query,sizeof(query),"UPDATE playerdata SET LsResume = '%d',LsClass = '%d',LsTeam = '%d' WHERE UserName = '%s'",PlayerInfo[playerid][pResume],PlayerInfo[playerid][pClass],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pName]);
				mysql_query(query);

can any one teach me how can i save if i make new things?

Re: How To Save Player Stats On mysql- - Pottus - 29.06.2014

Either make a new table or create new columns and update your queries if your system is in use you might want to manually create the new columns then update your create table queries.

Re: How To Save Player Stats On mysql- - danish007 - 29.06.2014

Код:

format(query,sizeof(query),"UPDATE playerdata SET LsFishInventory = '%d'",PlayerInfo[playerid][pFishes]);
mysql_query(query);

i've made this according to old colums it will work? but its not working

How can i?

Re: How To Save Player Stats On mysql- - Konstantinos - 29.06.2014

The above will update for all the rows. Use it as the example of your first post and when you want to add a new field, add the field's name and its value to the query.

Re: How To Save Player Stats On mysql- - danish007 - 29.06.2014

Quote:

Originally Posted by Konstantinos

The above will update for all the rows. Use it as the example of your first post and when you want to add a new field, add the field's name and its value to the query.

aight, Konstantinos You Helped Me 100's of times thank you so much

Re: How To Save Player Stats On mysql- - danish007 - 29.06.2014

Quote:

Originally Posted by Konstantinos

The above will update for all the rows. Use it as the example of your first post and when you want to add a new field, add the field's name and its value to the query.

Not Working Bro

I want to Save LsFishInventory can u make it?

Re: How To Save Player Stats On mysql- - danish007 - 29.06.2014

please help

Re: How To Save Player Stats On mysql- - danish007 - 29.06.2014

whats wrong with this? why it won't save?

PHP код:



mysql_get_field("SfFishInventory",wdata);

PlayerInfo[playerid][pFishes] = strval(wdata);

PHP код:



format(query,sizeof(query),"UPDATE playerdata SET SfFishInventory= '%d' WHERE UserName = '%s'",PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pName]);

mysql_query(query);