Step 1 :: Creating the TP spell
>In this step, we will be updating a row in the DB<
Open up SQLyog or Navicat and connect to your database.
Next, open up the table ' teleport_coords '
and here are the tables you will see
ID
These are the ID's of each teleport spell. Press CTRL + F and search for 11409.
NAME
Here, you will see the name " Teleport to Booty Bay ", you can change this name to anything you want. In this guide, i will change it to "Hyjal"
MAPID
Here is where you will need to enter the map ID that your portal will tele you to.
You can use .gps to figure out your coordinates. In this guide, i will use the map " 1 "
X
This is the X coordinate ( North and South ) I will use " -8918 "
Y
This is the Y coordinate (East and West ). I will use " 540 "
Z
This is the Z coordinate ( Or height ) I will use " 118 "
If you are unsure about this one, make sure you always round up a number or two, so that you dont port under the ground.
TOTRIGGER
This can be left at " 0 "
Step 2 :: Creating the Game Object
>In this step, we shall create the portal<
Open up the table Gameobject_names
You will see these fields:
ENTRY
This can be any number you choose, just make sure it hasn't been used already! In this guide, i will use " 1234567 "
TYPE
This is the type of game object it will be. Since we want a portal, put " 22 " in this field.
DISPLAYID
This is the display / model of the gameobject. You can take your pick from here:
4393 = Darnassus
4396 = Stormwind
4394 = Ironforge
4398 = Undercity
4395 = Orgrimmar
4397 = Thunder Bluff
6956 = Silvermoon
6955 = Exodar
Since my portal will put you ontop of the stormwind walls, i will use " 4396 " for stormwind.
Spellfocus
This field is important! This must be the same number as the ID you used to create your Teleport spell. If you recall from the top of this guide, we edited the spell " 11409 ". So that is the number i will put there.
Sound2 to Unknown14
These fields remain at default " 0 "
Step 3 :: Spawning the game object.
Here is the fun part, start up your server and log in on a gm account.
Now find an area you wish to place the portal, and use the command:
.go spawn 1234567
1234567 can be replaced with the ID you chose to create your GameObject with.
DO NOT MOVE ONCE YOU'VE SPAWNED THE PORTAL. This is vital for step 4
Sorry Didn't Realize This When I Made This Guide But Instead Of Doing This Upcoming Step When You Spawn The Portal Just Put 1 At The End
Example: .go spawn 66678 1
There Ya Go Now It's Permanent.
Step 4 :: Getting the object to stay forever.
This part will make it so the Portal will not disappear after server restart
Assuming that you did not move when you spawned the game object, you should be on the same coordinate plane as the game object. What does that mean? Well, its simple. When you spawned the gameobject, it was assigned to a point on a coordinate plane ( X,Y,Z,O ), and since you didn't move, you are still on the same point as it. At this point, i want you to do a .gps to find out what coordinates you are on. now make sure you KEEP those points! If you know them, now you can move
Open up navicat, and open the table ' Gameobject_spawns '
And you will see these fields:
ID
This is a reserved space for your gameobject. Do not mistake this for your gameobject's entry ID! This is completely seperate. If you go to the end of the list, it gets pretty high. A free ID would be " 257655 " So that is what i will use.
ENTRY
This is the entry of the gameobject we created. Assuming you followed the guide, i would put " 1234567 "
MAP
Here is where we use the Coords from the earlier .GPS command. The next 4 fields are up to you, it just places your gameobject on the map when you restart the server. Since im putting this portal near the tree in the trade district (SW) i will put " 0 "
X
This is the X coordinate that your gameobject will be placed on. I will use " -235.95 "
Y
This is the Y coordinate that your gameobject will be placed on. I will use " 645.78 "
Z
This is the Z coordinate that your gameobject will be placed on. I will use " 23.001 "
FACING
This is the direction your Gameobject will be facing. Please note that if you leave it at default ( '0' ), then it will be facing directly north. I will use " 0 "
O1
This is an option field, but is not needed, so leave it at 0
O2
This is another option field, but is not needed, so leave it at 0
O3
Make sure this is set at 1
O4
Make sure this is set at 0
STATE
This is what type of state your gameobject will be in once its spawned. Since we want it at its normal state, put down " 1 ".
FLAGS
This is just another option you can assign to your game object, just leave this at 0.
FACTION
This is what faction will be able to see and use the portal. leaving it at " 0 " will allow all factions to use it.
SCALE
The size of your GO, i will use " 1 "
StateNPClink
If its linked to a quest or NPC, this field will be needed. But since it is not, leave this
Field at " 0 ".