this is my tut for this...
1. go ingame to the place where you want the portal to travel you
2. tipe .gps and note down x y and z coordinate, the map id and orientation
3. create a new text document which contains the following lines:
Code:
INSERT INTO areatrigger_template
(id, name, required_level, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20010(or another unused id), "Name of Place", (reqired level to use), (mapid), "x coordinate", "y coordinate", "z coordinate", (mapid), "x coordinate", "y coordinate", "z coordinate", "orientation");
INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName)
VALUES
(300010(or another unused id), 27, 4396, "name of the portal", 0, 0, 1, (id of the entry before (first number), 0, 0, 0, 0, 0, 0, 0, 0, 0, "" );
so e.g.
Code:
INSERT INTO areatrigger_template
(id, name, required_level, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20010, "teleport: arena", 0, 0, "-13232.994141", "219.281677", "31.930302", 0, "-13232.994141", "219.281677", "31.930302", "1.110165");
INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName )
VALUES
(300010, 27, 4396, "to arena", 0, 0, 1, 20010, 0, 0, 0, 0, 0, 0, 0, 0, 0, "" );
4. save the document
5. change ending to .sql (not necessary)
6. apply it on your mangos db
7. you can the portal now add ingame with .addgo (2. entered id) so in example .addgo 300010