Page 1 of 1

Delete the server devise - Supprimer les pièces du serveur

Posted: 10 May 2020, 15:37
by Yourte
Hello,

I am looking to remove the coins from my server to be able to launch a new economy.

Would you know how, I can proceed so that my players are no longer a coin in their possession?
Thank you for your help.

Bonjour,

Je cherche à supprimer les pièces de mon serveur pour pouvoir lancer une nouvelle économie.
Sauriez-vous comment, je peux procéder pour que mes joueurs ne sont plus de pièce en leur possession ?

Je vous remercie pour votre aide.

Re: Delete the server devise - Supprimer les pièces du serveur

Posted: 14 May 2020, 13:18
by Nyuton
hi,
you can delete all coins in player inventories and containers using this SQL query:

Code: Select all

DELETE FROM items WHERE ObjectTypeID IN (1059,1060,1061);
Restart the server afterwards.

Note this will not delete coin offers and charged coins in trading posts.