Remove all npcs from zone

[inico]

00000000000000000000000000000000000000000000000000000000000000

[predattak]

i don't think so .. but u can make some .npc delete macro and it will be more easy u know with the gameobjects it's a little hard but u can manage it without some script or something ..

[stoneharry]

DELETE FROM `creature_spawns` WHERE `zoneID` = 'x';

Do something like that. No idea what zone ID or trinity structure is.

[myran2]

DELETE FROM creature where map = ID

You can't delete NPCs by zone, only by map.

[stoneharry]

DELETE FROM `creature` WHERE `map` = 'ID' AND `x` BETWEEN '5' AND '20000'; <-- Do something like that to calculate the rough area of the zone then. Sucks that trinity doesn't have zones in spawns. 0o

[inico]

DELETE FROM `creature` WHERE `map` = 'ID' AND `x` BETWEEN '5' AND '20000'; <-- Do something like that to calculate the rough area of the zone then. Sucks that trinity doesn't have zones in spawns. 0o

Thanks! i will try :P

[Harambeqt]

Or just

DELETE FROM `creature_spaws` WHERE `map` = 'ID'

Zone id or map if its working.

I don't know the map id, look for it in the db on some of the npcs spawned in the basin ex. Loque'nahak
If there is a map id in the mangos Db, havent been working with wow emus for a few months -.-'

i don't think so .. but u can make some .npc delete macro and it will be more easy u know with the gameobjects it's a little hard but u can manage it without some script or something ..

Thats just so damn funny...
The Gobjects will be hard :P

[stoneharry]

MapID != ZoneID.

If you delete from mapid it will remove everything in Northrend.

[Harambeqt]

MapID != ZoneID.

If you delete from mapid it will remove everything in Northrend.

DELETE FROM creature where map = ID

You can't delete NPCs by zone, only by map.

Harry, have you done it on mang ?