Help Duplicate Entryes

[0flee]

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

[Rootware]

Try this one:

 

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

 

[0flee]

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