Deleting NPCs

[mrhat187]

So I didn't need all the NPC's that are present by default so I delted about 10 of them, now when I try to edit the arena_wariors table I get errors, so I can't move NPC's to other arenas whats the deal?

[a_bertrand]

The NPC are within arena_warriors and npc_warriors. As arena_warriors looks at the npc_warriors table, if you delete first the npc_warriors entry and then the arena_warriors you will get errors. So start deleting from arena_warriors and then the npc_warriors one.

BTW you can cleanup nearly all by doing:

 

delete from arena_warriors where warrior_id > 3;
delete from npc_warriors where id > 3;