As sledmore was saying you can create a new table in your database and add a new database, clear it all out, get a backup of your current database and add users back and just reset the rooms (you will not be able to add rooms cause you will need a different catalog which makes different furniture ID's) then just do what Sledmore said
He wouldn't be able to keep rooms, if hes on R63B then it has a different catalog with different numbers and the rooms rely on the items table which contains the ID of the furniture <so you would get random furniture in rooms>You do not need to reset rooms, or items. It depends on the new database, but all can be kept with the simplest of SQL knowledge.
I'm working on the Emulator Side for example I want to learn how to turn regular bcstorm using the new SWF with Ducks CoinsYou'd look at the database structure. I've moved a large hotel from Phoenix to the leaked PlusEMU, didn't take long at all.
However, we reset some tables such as;
Rest I was able to simply transfer w/ basic SQL knowledge. If you use any other emulator than PlusEMU, you will need to work on the emulator side and chang how items save and load, as it's more than one table in most other emulators.
- Achievements
- Quests
- Wired
- user_quests
- user_achievements