Page 1 of 2

Currency, Supply runs, not saving

Posted: Wed Mar 26, 2014 3:52 pm
by Keldegar
I'm having an issue on my server where player currency, supply runs they have done, etc. are not saving when the user logs out.

Any ideas what this could be?

Re: Currency, Supply runs, not saving

Posted: Wed Mar 26, 2014 5:12 pm
by kjLotus
probably an issue with char_points table, if nobody else is having the same problem then it's probably because your table structure is wrong

Re: Currency, Supply runs, not saving

Posted: Wed Mar 26, 2014 8:04 pm
by Keldegar
i think it's because i need to update, it's been a few months since the last pull.

how do I update without losing all my char data and customizations? have a good guide for updating?

Re: Currency, Supply runs, not saving

Posted: Thu Mar 27, 2014 8:06 am
by whasf
Edit the design of the table, and manually add in the new fields

Re: Currency, Supply runs, not saving

Posted: Thu Mar 27, 2014 8:28 am
by nasomi
There is an issue I've been ahving where if a player has less than 200 tabs and they buy refresh, it resets their tabs to zero.

Re: Currency, Supply runs, not saving

Posted: Thu Mar 27, 2014 11:55 am
by Keldegar
whasf i don't need to update the lua or cpp files for the new currency packets?

Re: Currency, Supply runs, not saving

Posted: Thu Mar 27, 2014 11:57 am
by kjLotus
Keldegar wrote:whasf i don't need to update the lua or cpp files for the new currency packets?
if you update one thing, you better update everything

Re: Currency, Supply runs, not saving

Posted: Thu Mar 27, 2014 12:06 pm
by Keldegar
that's what I thought -- so how do you update without erasing all of the player data or custom item things? is there a guide? I tried to search the wiki for updating, but didn't find anything. how do private servers update and preserve their user-base?

for WoW (MangOS) their updates to .sql were append updates, they did not erase any data.

Re: Currency, Supply runs, not saving

Posted: Thu Mar 27, 2014 12:14 pm
by kjLotus
git will merge code files for you, for the database you'll have to execute some alter table statements to keep your data

Re: Currency, Supply runs, not saving

Posted: Thu Mar 27, 2014 12:17 pm
by Keldegar
how do I compare my database to the current sql files? is there an easy way?

thanks for your help, by the way.