[kikpp]

ok so i made a custom city...how would i get the mobs and gameobjects in the same spot out into an SQL...pls answer

[Arugos]

dude i ****ing love your signet and btw i need to know how too

[Clain]

1. Open navicat, heidisql, etc.
2. Click on the ascent (world) database.
3. Find the tables creature_spawns and gameobject_spawns.
4. Right click them and click export data.
5. Go through the export wizard and make it export as an sql.
6. Once it is done open the file and delete the queries that you didn't spawn (Basically just delete them until only your queries are in there referring to the thigns you spawned)

[kikpp]

Basically just delete them until only your queries are in there referring to the thigns you spawned

what do you mean by that...like after you dump the SQL file, just delete everything until you come to your gameobjects and vendors? cuz tht doesnt sound right

[*Alexz*]

its right and it takes forever xD

[kikpp]

so really the people who make custom cities (not Illidan1) but others have no life? lol (jk for all you city makers out there)

[SectorSeven]

Meh Illidan1 has a life.

[Clain]

It doesn't take that long lol

[kikpp]

that's why i said

not illidan1

[Anarchy [RD]]

Originally Posted by clainsux

1. Open navicat, heidisql, etc.
2. Click on the ascent (world) database.
3. Find the tables creature_spawns and gameobject_spawns.
4. Right click them and click export data.
5. Go through the export wizard and make it export as an sql.
6. Once it is done open the file and delete the queries that you didn't spawn (Basically just delete them until only your queries are in there referring to the thigns you spawned)

Damn you Clain, beat me to it :P

[kate1]

Find the id (after export) you spawned first and copy that, the whole way down to the end, paste into another sql-file. Remeber to have the sql-command for inserting GO spawns/NPC spawns atthe start. I have no life? that hurts very much in my hearth mate!

[warsheep]

When creating new cities, you should use a clean gameobject_spawns table, and export it, that way you don't have to spend hours deleting everything

[kikpp]

so Kate1...wat i would do is export gameobject_spawn table into another SQL then write .go spawn at the very top?