DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level>67 AND npc.type='L2Monster';

 

 

I used this sql script and I got this error... I wanna delete all monsters >67 lvl

 

script working normal but I got this error what is wrong?

 

 

INFO   - Van Halter

WARN  VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175.
WARN  VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175.
WARN  VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175.
WARN  VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175.
WARN  VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175.



and this

INFO  NPCTable: No npc correlating with id: 18345
INFO  NPCTable: No npc correlating with id: 18346
INFO  NPCTable: No npc correlating with id: 20627
INFO  NPCTable: No npc correlating with id: 20627
INFO  NPCTable: No npc correlating with id: 20627

fixed