Now Open up either HeidiSQL, Navicat or SQLyog.
Connect via information:

ArcEmu:

Code:

User: root
Password: root

Ascent/AC-web:

Code:

User: root
Password: ascent
or Password: root

Now go to your World Database and open up the table Gameobject_names

Code:

How to Import with With HeidiSQL:
Go to the tab named : Query.
Click on Import button in the main menues at the top and click "Import SQL file" and it will load the sql file.
Now Hit F9 or click on the first green arrow located at the right side of the Query txt.
Now u have imported your Gameobject's.

Code:

How to Import with SQLyog and Navicat:
Open the Database named World or ascent.
Then Right click on it and click "Execute Batch File"
Browse and find your SQL files and click on them. Now click Start and it will load the files into the Database.

Now that u imported your Gameobject's it's time to spawn them.

To make a custom Area:
First find a good flat place in WoW by flying around a bit. Recommend
"The Emerald Dream"
Now begin spawning Grass around with command:

Code:

.gameobject spawn 185178 1

spawn around until u feel it's enough.
Now u can start spawning trees and things with:

Code:

.gameobject spawn 185174 1

Remember to always have the "1" behind the Gameobject Command, or else the Gameobject will be deleted after a server restart.
Now you can spawn NPC's around that u make in the Database.
I will not tell you how. Search for another post how to make one.
Now spawn it and let it bee. To make the place more interesting you can make the NPC move around by using the command:

Code:

.waypoint add

this command makes the selected NPC to walk to the spawned Waypoint.
You can make it walk around anywhere you want.
Now if you want the NPC to not take so long brakes on the waypoint stop you can use:

Code:

.waypoint wattime x

change the "x" to a number. if u choose "1000" it will be 1 second! so if u want 3 seconds waittime u set in number "3000".
You can spawn alot more like houses and things but then it will be more like a city like in one of the next steps.

Now How to make a custom instance!
Find a nice place you want your instance to be (you dont need to replace anything, just find a nice place with some flat and some highlited area).
Now begin spawning gameobject's like: Flame orbs and things.
There is alot of Gameobject's so you can search your Database for it.
Now like if u want a natural Instance with Flowers and trees start spawning them aruond the area.

Now start spawning bigger trees like a fountain tree from the emerald dream:

Code:

.go spawn 70067 1

Now if you come to a place with a mountain or a hill or something that u cant walk upstairs use this command to spawn a small steel stage you can make a floor of by spawning, jump on it, walk a bit forward and spawn again. i use this much.
Stage to make stairs:

Code:

.go spawn 185301 1

you can also use a table wich is used by alot of people:

Code:

.go spawn 181075 1

Now spawn some fence around so that no-one can go there.
Tip: Use the .ch fly and make a macro. then spawn the fenca while flying up in ca, .mod speed 2.5 and spawn until it's high enough.
Fence (really low):

Code:

.go spawn 180035 1

Spawn some NPC's around and bosses.
If you want to make the NPC's to drop item's then make some by going to:

Code:

http://www.wow-v.com

Create an account and click on weapon tool now make item's and such.
Check my video on how to make a Frostmourne here:

Code:

http://www.youtube.com/watch?v=IngkiUNK8aI

Now go to the table creatureloot and make new rows for each drop.
there's alot of guides out there so just search for them.
You can spawn fire and things if you want an evil looking instance.
i recommend:

Code:

.go spawn 176746 1

it's with smoke and everything!
spawn your NPC's done and then:
Congratioulations you made your own custom instance!

Now for the last step:
How to make a custom city!
First off:
BE PATIENT!
IT TAKES A LONG TIME TO MAKE A BIG CITY!

Let's start

First start spawning houses. They look like Human houses but works good for a city.
House:

Ok now start spawning where you want them and customise your city with vendor's, NPC's, Guards walking around using the

Code:

.waypoint add

command.
Congratioulation's You have made your own place in the World of warcraft!

Hopw this threath was helpfull.
Now i really need a brake.
CYA!!!

PICTURES:

NOTE: YOU HAVE TO RUN ALL THE SQL FILES BEFORE USING THIS!!!NOTE:
I DIDNT MAKE ALL THE SQL FILES. THE FILES 350 Gameobject's AND THE 150 WAS MADE BY RyeRye HERE ON THE FORUM.
THE FILE SAYS blah by sasoritail.sql I DIDNT MAKE THE SQL'S. ALL THE CREDIT'S OF 500 OBJECT's IN THIS POST GOES TO RyeRye!
SO DONT GIVE ME +Rep FOR HIS GO'S!
TY

looks great! But just wondering. How do I make custom gameobjects? I want like a caste,keep that i would like to have. And have been looking for it in my database couldnt find it. So were do i make a caste to a gameobject? + rep if u help with that. and + rep for this will use those gameobjects