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);