Adjusting Server Currency
Does anyone know of a an easy way to update the currency (platinum, silver, gold and copper) for all characters on a server at once? I am guessing there may be some MySQL query that could be ran to adjust it, but I am not exactly sure how to do that since all of that info is stored in the Player Profile Blob and I don't know how to access that.
What I am trying to do is maybe run a query that does something like dividing all player currency by 10. Then, I would also want to run a second simpler query to update all item prices over a certain amount to be divided by 10 as well. I think I can figure out the one for updating item prices, but if anyone knows how to update characters for currency on the character, in their bank and in their shared bank, I would appreciate it. Thanks :) |
This may be of no help to you since it seems you want to reduce inflation on your server but for just adding money to accounts the "shared bank" is not part of the combined character information. It is set at the account level.
I used that to pull some "Funny Plat" out of the system. It, of course, does no good for the money that wasn't stored there. I'd be very interested to see an answer on this too. |
Quote:
|
Thanks, AndMetal! That sorta makes sense. Though, I imagine it would be pretty confusing for someone who isn't as familiar with the packet structures lol.
The only thing I can't seem to figure out from that is how I would divide the current value by 10. Normally in SQL, I could just tell it to do something like plat = (plat / 10), but since this isn't an actual named field, I am not sure how to do that exactly. This will definitely take some testing on my test server before I could even think about doing it on the real server lol. Also, a backup of the accounts table will be a good idea before any changes like that. |
All times are GMT -4. The time now is 03:04 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.