As i have noticed there are no guides on this topic or atleast no popular guides so Basically, i've seen this on a different forum and dont want any rep or fame, all praises go to Udead Over at AC Web.
I'll be showing you how to make a teleporter via SQL.
Say we are making a port to Dalaran.
I would start off in the table "Npc_text'
The id is what links the text to Gossip_menu table. I'l set it to 99999
text0_0 is what the npc will say on the top of the menu (not clickable")
I'l set it to "Want a port to Dalaran?"
We are finished with that table. Now go to the "Gossip_menu" table
The entry is what links it to creature_template. Il set it to 89323
The textid is what I put in "Npc_text" Set it to 99999
Leave the rest at 0
We are finished with that table. Now go to "Gossip_menu_option" table
The menu_id is the id I put in "Gossip_menu" Set it to 89323
The id is the "id" of the option THIS MUST BE UNIQUE IF YOU PLAN ON HAVING MORE THAN 1 OPTION ON THE SAME NPC.
The option_icon is the picture on the left of the Text. Here are a few id's:
option_text is what the option will say. Il put it as "Beam to Dalaran Scotty!"Code:GOSSIP_ICON_CHAT = 0, //white chat bubble GOSSIP_ICON_VENDOR = 1, //brown bag GOSSIP_ICON_TAXI = 2, //flight GOSSIP_ICON_TRAINER = 3, //book GOSSIP_ICON_INTERACT_1 = 4, //interaction wheel GOSSIP_ICON_INTERACT_2 = 5, //interaction wheel GOSSIP_ICON_MONEY_BAG = 6, //brown bag with yellow dot GOSSIP_ICON_TALK = 7, //white chat bubble with black dots GOSSIP_ICON_TABARD = 8, //tabard GOSSIP_ICON_BATTLE = 9, //two swords GOSSIP_ICON_DOT = 10, //yellow dot
I can't explain option_id,,,,,,just set it to 1
Nor can I explain npc_option_npcflag....set it to 1
Action_menu_id is only If you want to create a sub-menu, this is the ID to link to to create that sub-menu. We do not need this.
Action_poi_id is If you want a POI (point of interest) to display on the minimap, this is the `entry` from `points_of_interest`. We do not need this.
Action_script_id is the script that is located in gossip_scripts. We ARE using this. Set it to 999999.
We are done with that table. Now go to the "gossip_scripts" table.
The ID is what we put the "action_script_id". Set it to 999999
Delay is the wait time in seconds for the script to activate. We will leave it at 0 for this.
Command is what kind of script your making. We are using 6, but if your making something else here is a list of commands:
Set "datalong" for what your mapId is (from typing.gps ingame) ours will beCode:0 TALK Creature say/whisper/yell/textemote. 1 EMOTE Play emote on creature. 2 FIELD_SET Change the value at an index for the player. 3 MOVE_TO Relocate creature to a destination. 4 FLAG_SET Turns on bits on a flag field at an index for the player. 5 FLAG_REMOVE Turns off bits on a flag field at an index for the player. 6 TELEPORT_TO Teleports the player to a location. 7 QUEST_EXPLORED Satisfies the explore requirement for a quest. 8 KILL_CREDIT Gives kill credit to the player. 9 RESPAWN_GAMEOBJECT Spawns a despawned gameobject. 10 TEMP_SUMMON_CREATURE Temporarily summons a creature. 11 OPEN_DOOR Opens a door gameobject (type == 0). 12 CLOSE_DOOR Closes a door gameobject (type == 0). 13 ACTIVATE_OBJECT Activates an object. 14 REMOVE_AURA Removes an aura due to a spell. 15 CAST_SPELL Casts a spell. 16 PLAY_SOUND Plays a soun. 17 CREATE_ITEM Creates specified amount of items for the player. 18 DESPAWN_SELF Forces creature to despawn. 19 nuttin There is no command 19. 20 LOAD_PATH Load path to unit, then unit starts waypoint movement. 21 CALLSCRIPT_TO_UNIT Calls script from one of *_scripts table with given unit as source. 22 KILL Changes state of the creature to dead and optionally removes its corpse. 30 ORIENTATION Changes unit's orientation (Used in Waypoint Scripts) 31 EQUIP Sets creature equipment. 32 MODEL Sets creature model. 33 CLOSE_GOSSIP Closes gossip window. This command is only used for Gossip Scripts. 34 PLAYMOVIE Plays movie.
571
Set X for what your "X" coordinate is.
Set Y for what your "Y" coordinate is.
Set Z for what your "Z" coordinate is.
Set O for what your "orientation" is.
Be sure to set the gossip_menu_id in "Creature_template" to whatever your ID you used in gossip_menu. In our case, 89323
Then You are done! Congratulations, you have just made a teleporter by using SQL.
simply passing on a great guide!