Currency, Supply runs, not saving

[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?

[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

[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?

[whasf]

Edit the design of the table, and manually add in the new fields

[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.

[Keldegar]

whasf i don't need to update the lua or cpp files for the new currency packets?

[kjLotus]

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

[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.

[kjLotus]

git will merge code files for you, for the database you'll have to execute some alter table statements to keep your data

[Keldegar]

how do I compare my database to the current sql files? is there an easy way?

thanks for your help, by the way.