How to empty out the creature/gameobject without deleting the creatures<blank server>

[runiker]

This is a very simple guide on how to delete where all teh creature spawns on diff maps (note this is for the whole map)


ALWAYS BACKUP YOUR FILES BEFORE MODIFYING

not alot of people think about thsi but it is usfull when you want to delete a whole map to modify it or make it your own for a repack. ehter way heres the guide.

first off let me start out by saying this is for people who want to sped a good amount of time modify a map.

first open up navicat.
go to creature_spawns or Gameobject_spawns what ever you want to delete

then if you only what to delete one map in the "map" colom hit sort decending.

i will take this time to post the diffrent map names and number



0 Eastern Kingdoms
1 Kalimdor
30 Alterac Valley
33 Shadowfang Keep
34 The Stockades
35 Stormwind Vault - UNUSED
36 The Deadmines
43 Wailing Caverns
47 Razorfen Kraul
48 Blackfathom Deeps
70 Uldaman
90 Gnomeregan
109 The Sunken Temple
129 Razorfen Downs
169 EmeraldDream
189 The Scarlet Monastery
209 Zul'Farrak
229 Blackrock Spire
230 Blackrock Depths
249 Onyxia's Lair
269 Opening of the Dark Portal
289 Scholomance
309 Zul'Gurub
329 Stratholme
349 Maraudon
369 Deeprun Tram
389 Ragefire Chasm
409 Molten Core
429 Dire Maul
449 Alliance Military Barracks
450 Horde Military Barracks
469 Blackwing Lair
489 Warsong Gulch
509 Ruins of Ahn'Qiraj
529 Arathi Basin
530 Outlands
531 Temple of Ahn'Qiraj
532 Karazhan
533 Naxxramas
534 The Battle for Mount Hyjal
540 The Shattered Halls
542 The Blood Furnace
543 Hellfire Ramparts
544 Magtheridon's Lair
545 The Steam Vaults
546 The Underbog
547 The Slave Pens
548 Serpentshrine Cavern
550 Tempest Keep
552 The Arcatraz
553 The Botanica
554 The Mechanar
555 Shadow Labyrinth
556 Sethekk Halls
557 Mana-Tombs
558 Auchenai Crypts
560 Escape from Durnholde
562 Blade's Edge Arena
564 Black Temple
565 Gruul's Lair
568 Zul'Aman


ok highlight all the rows that have the same map id in it.
then click delete.
now you are done but all the creatures/game objects Are still in the database but not on the maps this is good if you would like to relocate them. or if they spawn in more then one map.

--sorry for the long post code box not working

[Szharz]

Very nice runi, repx2 for u,

Limatikus / Pwnmaster / Shock from cannabiswow.

[Equ1N0X]

SIMPLER SOLUTION: Int he bow where you cna enter text in your DB program (like navicat's query box) enter:

Delete from creature_spawns WHERE map = 'ID'

Delete from Gameobject_spawns WHERE map = 'ID'

then execute query into database. alot less effort.

[runiker]

well thank you for that knowledge man but i am new to this and thats the way i found out lol!

[godzofwarcraft]

nice, very nice