[SQL] Eliminar Npc´s

[Swarlog]

Con este code, podemos eliminar el tipo de Npc de nuestra base de datos; en este caso todos los de lvl 90 e inferior.

Código [Seleccionar] Expandir

DELETE spawnlist, npc FROM spawnlist, npc WHERE  spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND  npc.TYPE='L2Monster';
DELETE spawnlist, npc FROM spawnlist, npc WHERE  spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND  npc.TYPE='L2FestivalMonster';
DELETE spawnlist, npc FROM spawnlist, npc WHERE  spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND  npc.TYPE='L2Minion';
DELETE spawnlist, npc FROM spawnlist, npc WHERE  spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND  npc.TYPE='L2Chest';
DELETE spawnlist, npc FROM spawnlist, npc WHERE  spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND  npc.TYPE='L2FeedableBeast';
DELETE spawnlist, npc FROM spawnlist, npc WHERE  spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND  npc.TYPE='L2RiftInvader';
DELETE spawnlist, npc FROM spawnlist, npc WHERE  spawnlist.npc_templateid=npc.idTemplate AND npc.level<90 AND  npc.TYPE='L2RaidBoss';
By KingBorracho69