(Solved) How do I add/remove dressing room items? (100.02)

[voxelkitten]

(Solved) I'd like to remove the temporary 7 and 14 day mounts and add in the correct ones so I can purchase them in-game.

[MentaL]

[tya0411]

I dunno if I got them all, but here's a script for the productmarkinfo table that has the temp mounts removed:
https://drive.google.com/file/d/19sA...ew?usp=sharing

You'd have to delete all records from the productmarkinfo table, the run this script. Make a backup of your planetdb first!

[voxelkitten]

I dunno if I got them all, but here's a script for the productmarkinfo table that has the temp mounts removed:
https://drive.google.com/file/d/19sA...ew?usp=sharing

You'd have to delete all records from the productmarkinfo table, the run this script. Make a backup of your planetdb first!

Thank you I will try this. I have a question how do I safely backup my planetdb? Ever since I got my server up and running I'm always scared to touch anything in the program in case I make a mistake and break my server.

[tya0411]

In SSMS, you can right-click the db -> tasks -> backup. It's worth mentioning that the arbiter/worldserver need to be restarted after re-populating that table.

[voxelkitten]

In SSMS, you can right-click the db -> tasks -> backup. It's worth mentioning that the arbiter/worldserver need to be restarted after re-populating that table.

I see. And let's say I wanted to revert back to my backup, what do I do in this instance?
I'm just keeping note of everything for future tinkering, apologies in advance. >.<

[tya0411]

I see. And let's say I wanted to revert back to my backup, what do I do in this instance?
I'm just keeping note of everything for future tinkering, apologies in advance. >.<

In that case it would be db -> tasks -> restore. It will allow you to restore the db to the backup you made

[voxelkitten]

In that case it would be db -> tasks -> restore. It will allow you to restore the db to the backup you made

Aha gotcha. Thanks so much for the help! :)