SQL - Eliminar Npc´s

Iniciado por Swarlog, Jun 23, 2025, 07:36 PM

Tema anterior - Siguiente tema
Imprimir
Ir Abajo Páginas1
Acciones del Usuario

Swarlog

Jun 23, 2025, 07:36 PM
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]
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
Imprimir
Ir Arriba Páginas1
Acciones del Usuario