Skip to content

Duplicate Entryes

Featured Replies

Hello all. I do a small mistake. And this mistake it is on custom_spawnlist. I duplicated all spawns. Npcs/monsters. How i can delete duplicated spawns? It is a command on sql or query?
Greetings

Try this one:

 

CREATE TABLE `spawnlist_tmp` SELECT DISTINCT * FROM `spawnlist`;
DROP TABLE `spawnlist`;
RENAME TABLE `spawnlist_tmp` TO `spawnlist`;

 

  • Author

Oh, i use host database. There it is something like ALTER..

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.