1. Open navicat or anny other mysql editor
2. Open world and then Teleport_coords, and it will look like this:
3. Now go to teleport - Wowhead Search
4. find a spell wich looks like this
Make sure it says Teleport Units
5. copy the spell id its the last nubers in the adress field.
6. now go to the teleport_coords tab and make a new row and insert in first column (id) the spell id (last nubers in adress field). And Name type name of the spell, i use to call it the same name as the portal we will make later. like Teleport To Mall or something like that.
7. Go ingame and place your char where u want the portal to take you. and wirte .gps and you will get MapId, position X, position Y and positon Z.
8. write those numbers in the teleport_coords tab. Save and close that tab.
CREATING THE OBJECT.
9. open up Gameobject_names table.
10. Make a new row.
11.In Entry type a high number like the one on picture. (this will be the spawn ID). In type insert number 22. Display id can be orgrimmar portal id if u want, use a portal display id. In this Tut i will use 8046 wich is Death gate portal. In name write what u want the portal called. then go to spellfocus and here you insert the ID u made in teleport_coords. And last, Insert 1 to sound1. then ur done
12. Save and exit. Now restart your server and do .go spawn (the id in gameobject_names) and after that id make a space and 1 it will make it stay forever.