- Joined
- Mar 7, 2012
- Messages
- 12,871
- Reaction score
- 710
- Points
- 113
PHP:
delete from K_NPCPOS where NpcID not in (Select sSid from K_NPC) and ActType >= 100
delete from K_NPCPOS where NpcID not in (Select sSid from K_MONSTER) and ActType <=99
delete from K_NPCPOS where npcid not in (Select ssid from K_NPC) and npcid not in (Select ssid from K_MONSTER)
