How to make a teleporter With SQL. [Trinity] menu

User Tag List

Results 1 to 3 of 3
  1. #1
    Verosk's Avatar Sergeant
    Join Date
    Oct 2010
    Thanks G/R
    Trade Feedback
    0 (0%)
    0 Post(s)
    0 Thread(s)

    How to make a teleporter With SQL. [Trinity]

    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 option_icon is the picture on the left of the Text. Here are a few id's:

    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
    option_text is what the option will say. Il put it as "Beam to Dalaran Scotty!"
    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:

    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.
    Set "datalong" for what your mapId is (from typing.gps ingame) ours will be
    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!

    These ads disappear when you log in.

  2. #2
    Nokia123's Avatar Member
    Join Date
    Dec 2007
    Thanks G/R
    Trade Feedback
    0 (0%)
    0 Post(s)
    0 Thread(s)
    Just awful, did not help at all

  3. #3
    hogs1397's Avatar Private
    Join Date
    Jun 2012
    Thanks G/R
    Trade Feedback
    0 (0%)
    0 Post(s)
    0 Thread(s)
    Useful for me. thx

Similar Threads

  1. [Question] how to make Heirlooms Vendor with suctions for (trinity core)
    By 3Majed in forum WoW EMU Questions & Requests
    Replies: 2
    Last Post: 09-30-2016, 04:20 PM
  2. [Question] How to make items buyable with Marks and Token
    By Spurven in forum World of Warcraft Emulator Servers
    Replies: 10
    Last Post: 10-29-2007, 04:25 AM
  3. How to Make a Character with Cool Letters
    By Cyboi in forum World of Warcraft Guides
    Replies: 62
    Last Post: 08-21-2007, 01:52 PM
  4. [Live Servers] How to do small teleports with Cheat Engine
    By Neozak in forum World of Warcraft Guides
    Replies: 13
    Last Post: 08-15-2007, 12:03 PM
  5. How to make a trainer with CHEATENGINE
    By Midnight_killa in forum World of Warcraft Bots and Programs
    Replies: 28
    Last Post: 02-25-2007, 04:52 AM
All times are GMT -5. The time now is 03:37 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2020 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search