Teleporter (ArkCore 4.0.6)

/* Custom Teleporter written by ozeneu  modified by Nomad, shared by ExonatioN on "Emudevs.com" */
DELETE FROM creature_template WHERE entry = '95000';

INSERT INTO creature_template (entry, modelid1, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, Health_mod, Mana_mod, Armor_mod, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, dmg_multiplier, unit_class, unit_flags, TYPE, type_flags, InhabitType, RegenHealth, flags_extra) VALUES
('95000', '28227', "ViperWow", "Teleportation", 'Directions', '50000', 71, 71, 1.56, 1.56, 1.56, 35, 35, 3, 1, 1.14286, 1.25, 1, 1, 1, 2, 7, 138936390, 3, 1, 2);

DELETE FROM creature_template_addon WHERE Entry = '190000' ;

INSERT INTO creature_template_addon (entry, mount, bytes1, bytes2, emote, path_id, auras) VALUES
('190000', 0, 0, 0, 0, 0, '35766 0');

DELETE FROM gossip_menu WHERE entry>'50000'-1 AND entry<'50000'+9;
DELETE FROM npc_text WHERE ID>'300000'-1 AND ID<'300000'+5;

INSERT INTO gossip_menu (entry, text_id) VALUES
('50000'+4, '300000'+3),
('50000'+3, '300000'+2),
('50000'+2, '300000'+2),
('50000'+1, '300000'+2),
('50000'+8, '300000'+4),
('50000'+7, '300000'+4),
('50000'+6, '300000'+4),
('50000'+5, '300000'+4),
('50000', '300000'+1),
('50000', '300000');

INSERT INTO npc_text (ID, text0_0, em0_1) VALUES
('300000'+4, '$BWhere do you wish to go ?$B', 0),
('300000'+3, '$BBe careful with choosing location,I will not be there to help.$B', 0),
('300000'+2, '$BReady for some dungeon exploring?$B', 0),
('300000'+1, '$BFor the  Alliance!$B', 6),
('300000', '$BFor the Horde!$B', 6);

DELETE FROM gossip_menu_option WHERE menu_id>'50000'-1 AND menu_id<'50000'+9;
DELETE FROM gossip_scripts WHERE id>'50000'-1 AND id<'50000'+135;
DELETE FROM conditions WHERE (SourceTypeOrReferenceId = 15 OR SourceTypeOrReferenceId=14) AND (SourceGroup>'50000'-1 AND SourceGroup<'50000'+9);

INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, ConditionTypeOrReference, ConditionValue1, Comment) VALUES
(15, '50000', 1, 6, 469, 'Stormwind'),
(15, '50000'+5, 2, 6, 469, 'Dun Morogh'),
(15, '50000'+5, 3, 6, 67, 'Tirisfal Glades'),
(15, '50000'+5, 4, 6, 67, 'Ghostlands'),
(15, '50000'+5, 5, 6, 469, 'Loch modan'),
(15, '50000'+5, 6, 6, 67, 'Silverpine Forest'),
(15, '50000'+5, 7, 6, 469, 'Westfall'),
(15, '50000'+5, 8, 6, 469, 'Redridge mountains'),
(15, '50000'+5, 9, 6, 469, 'Duskwood'),
(15, '50000'+5, 11, 6, 469, 'Wetlands'),
(15, '50000'+6, 0, 6, 469, 'Azuremyst Isle'),
(15, '50000'+6, 1, 6, 469, 'Teldrassil'),
(15, '50000'+6, 2, 6, 67, 'Durotar'),
(15, '50000'+6, 3, 6, 67, 'Mulgore'),
(15, '50000'+6, 4, 6, 469, 'Bloodmyst Isle'),
(15, '50000'+6, 5, 6, 469, 'Darkshore'),
(15, '50000'+6, 6, 6, 67, 'The Barrens'),
(15, '50000'+5, 1, 6, 67, 'Eversong Woods'),
(15, '50000'+5, 0, 6, 469, 'Elwynn Forest'),
(15, '50000'+4, 22, 6, 67, 'Zul\'Aman'),
(15, '50000', 2, 6, 67, 'Orgrimmar'),
(15, '50000', 3, 6, 469, 'Darnassus'),
(15, '50000', 4, 6, 469, 'Ironforge'),
(15, '50000', 5, 6, 469, 'Exodar'),
(15, '50000', 6, 6, 67, 'Thunder bluff'),
(15, '50000', 7, 6, 67, 'Undercity'),
(15, '50000', 8, 6, 67, 'Silvermoon city'),
(15, '50000'+1, 0, 6, 469, 'Gnomeregan'),
(15, '50000'+1, 1, 6, 469, 'The Deadmines'),
(15, '50000'+1, 2, 6, 469, 'The Stockade'),
(15, '50000'+1, 3, 6, 67, 'Ragefire Chasm'),
(15, '50000'+1, 4, 6, 67, 'Razorfen Downs'),
(15, '50000'+1, 5, 6, 67, 'Razorfen Kraul'),
(15, '50000'+1, 6, 6, 67, 'Scarlet Monastery'),
(15, '50000'+1, 7, 6, 67, 'Shadowfang Keep'),
(15, '50000'+1, 8, 6, 67, 'Wailing Caverns'),
(15, '50000'+6, 9, 6, 67, 'Thousand Needles'),
(14,'50000', '300000'+1, 6, 469, 'Honor and Respect for the Alliance'),
(14, '50000', '300000', 6, 67, 'Honor and Respect for the Horde');

INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text) VALUES
('50000', 1, 2, 'Stormwind', 1, 1, '50000', 0, '50000', 0, 0, 'Ready to go in  Stormwind?'),
('50000', 2, 2, 'Orgrimmar', 1, 1, '50000', 0, '50000'+1, 0, 0, 'Ready to go in  Orgrimmar?'),
('50000', 3, 2, 'Darnassus', 1, 1, '50000', 0, '50000'+8, 0, 0, 'Ready to go in  Darnassus?'),
('50000', 4, 2, 'Ironforge', 1, 1, '50000', 0, '50000'+9, 0, 0, 'Ready to go in  Ironforge?'),
('50000', 5, 2, 'Exodar', 1, 1, '50000', 0, '50000'+10, 0, 0, 'Ready to go in  Exodar?'),
('50000', 6, 2, 'Thunder bluff', 1, 1, '50000', 0, '50000'+11, 0, 0, 'Ready to go in  Thunder bluff?'),
('50000', 7, 2, 'Undercity', 1, 1, '50000', 0, '50000'+12, 0, 0, 'Ready to go in  Undercity?'),
('50000', 8, 2, 'Silvermoon city', 1, 1, '50000', 0, '50000'+13, 0, 0, 'Ready to go in  Silvermoon city?'),
('50000', 9, 2, 'Dalaran', 1, 1, '50000', 0, '50000'+5, 0, 0, 'Ready to go in  Dalaran?'),
('50000', 10, 2, 'Shattrath', 1, 1, '50000', 0, '50000'+3, 0, 0, 'Ready to go in  Shattrath?'),
('50000', 11, 2, 'Booty bay', 1, 1, '50000', 0, '50000'+2, 0, 0, 'Ready to go in  Booty bay?'),
('50000', 12, 2, 'Gurubashi arena', 1, 1, '50000', 0, '50000'+6, 0, 0, 'Ready to go in  Arena?'),
('50000', 13, 3, 'Eastern Kingdoms', 1, 1, '50000'+5, 0, 0, 0, 0, NULL),
('50000', 14, 3, 'Kalimdor', 1, 1, '50000'+6, 0, 0, 0, 0, NULL),
('50000', 15, 3, 'Outland', 1, 1, '50000'+7, 0, 0, 0, 0, NULL),
('50000', 16, 3, 'Northrend', 1, 1, '50000'+8, 0, 0, 0, 0, NULL),
('50000', 17, 9, 'Cataclysm Zone', 1, 1, '50000'+1, 0, 0, 0, 0, NULL),
('50000', 18, 9, 'BC Dungeons', 1, 1, '50000'+2, 0, 0, 0, 0, NULL),
('50000', 19, 9, 'Wrath Dungeons', 1, 1, '50000'+3, 0, 0, 0, 0, NULL),
('50000', 20, 9, 'Raid Teleports', 1, 1, '50000'+4, 0, 0, 0, 0, NULL),
('50000'+1, 0, 2, 'Tol Barad', 1, 1, 0, 0, '50000'+14, 0, 0, 'Ready to go in  Tol Barad?'),
('50000'+1, 1, 2, 'The Lost Isles', 1, 1, 0, 0, '50000'+15, 0, 0, 'Ready to go in  The Lost Isles?'),
('50000'+1, 2, 2, 'Grim Batol', 1, 1, 0, 0, '50000'+16, 0, 0, 'Ready to go in  Grim Batol?'),
('50000'+1, 3, 2, 'Tol Barad', 1, 1, 0, 0, '50000'+17, 0, 0, 'Ready to go in  Tol Barad?'),
('50000'+1, 4, 2, 'The Lost Isles', 1, 1, 0, 0, '50000'+18, 0, 0, 'Ready to go in  The Lost Isles?'),
('50000'+1, 5, 2, 'Grim Batol', 1, 1, 0, 0, '50000'+19, 0, 0, 'Ready to go in  Razorfen Grim Batol?'),
('50000'+1, 9, 2, 'The Abyssal Maw', 1, 1, 0, 0, '50000'+23, 0, 0, 'Ready to go in  The Abyssal Maw?'),
('50000'+1, 10, 2, 'Halls of Origination', 1, 1, 0, 0, '50000'+24, 0, 0, 'Ready to go in  Halls of Origination?'),
('50000'+1, 11, 2, 'Ruins of Glineas', 1, 1, 0, 0, '50000'+25, 0, 0, 'Ready to go in  Ruins of Glineas?'),
('50000'+1, 12, 2, 'The Bastion of Twilight', 1, 1, 0, 0, '50000'+26, 0, 0, 'Ready to go in  The Bastion of Twilight?'),
('50000'+1, 13, 2, 'Deepholme', 1, 1, 0, 0, '50000'+27, 0, 0, 'Ready to go in  Deepholme?'),
('50000'+1, 14, 2, 'Blackwing Descent', 1, 1, 0, 0, '50000'+28, 0, 0, 'Ready to go in  Blackwing Descent?'),
('50000'+1, 15, 2, 'The Vortex Pinnacle', 1, 1, 0, 0, '50000'+29, 0, 0, 'Ready to go in  The Vortex Pinnacle?'),
('50000'+1, 16, 2, 'Lost City of the Tolvir', 1, 1, 0, 0, '50000'+30, 0, 0, 'Ready to go in  Lost City of the Tolvir?'),
('50000'+1, 17, 2, 'Mount Hyjal', 1, 1, 0, 0, '50000'+31, 0, 0, 'Ready to go in  Mount Hyjal?'),
('50000'+1, 18, 2, 'The Maelstrom', 1, 1, 0, 0, '50000'+32, 0, 0, 'Ready to go in  The Maelstrom?'),
('50000'+1, 19, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+2, 0, 2, 'Auchindoun', 1, 1, 0, 0, '50000'+33, 0, 0, 'Ready to go in  Auchindoun?'),
('50000'+2, 1, 2, 'Caverns of Time', 1, 1, 0, 0, '50000'+34, 0, 0, 'Ready to go in  Caverns of Time?'),
('50000'+2, 2, 2, 'Coilfang Reservoir', 1, 1, 0, 0, '50000'+35, 0, 0, 'Ready to go in  Coilfang Reservoir?'),
('50000'+2, 3, 2, 'Hellfire Citadel', 1, 1, 0, 0, '50000'+36, 0, 0, 'Ready to go in  Hellfire Citadel?'),
('50000'+2, 4, 2, 'Magisters\' Terrace', 1, 1, 0, 0, '50000'+37, 0, 0, 'Ready to go in  Magisters\' Terrace?'),
('50000'+2, 5, 2, 'Tempest Keep', 1, 1, 0, 0, '50000'+38, 0, 0, 'Ready to go in  Tempest Keep?'),
('50000'+2, 6, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+3, 0, 2, 'Azjol-Nerub', 1, 1, 0, 0, '50000'+39, 0, 0, 'Ready to go in  Azjol-Nerub?'),
('50000'+3, 1, 2, 'The Culling of Stratholme', 1, 1, 0, 0, '50000'+40, 0, 0, 'Ready to go in  The Culling of Stratholme?'),
('50000'+3, 2, 2, 'Trial of the Champion', 1, 1, 0, 0, '50000'+41, 0, 0, 'Ready to go in  Trial of the Champion?'),
('50000'+3, 3, 2, 'Drak\'Tharon Keep', 1, 1, 0, 0, '50000'+42, 0, 0, 'Ready to go in  Drak\'Tharon Keep?'),
('50000'+3, 4, 2, 'Gundrak', 1, 1, 0, 0, '50000'+43, 0, 0, 'Ready to go in  Gundrak?'),
('50000'+3, 5, 2, 'Icecrown Citadel Dungeons', 1, 1, 0, 0, '50000'+44, 0, 0, 'Ready to go in  Icecrown Citadel Dungeons?'),
('50000'+3, 6, 2, 'The Nexus Dungeons', 1, 1, 0, 0, '50000'+45, 0, 0, 'Ready to go in  The Nexus Dungeons?'),
('50000'+3, 7, 2, 'The Violet Hold', 1, 1, 0, 0, '50000'+46, 0, 0, 'Ready to go in  The Violet Hold?'),
('50000'+3, 8, 2, 'Halls of Lightning', 1, 1, 0, 0, '50000'+47, 0, 0, 'Ready to go in  Halls of Lightning?'),
('50000'+3, 9, 2, 'Halls of Stone', 1, 1, 0, 0, '50000'+48, 0, 0, 'Ready to go in  Halls of Stone?'),
('50000'+3, 10, 2, 'Utgarde Keep', 1, 1, 0, 0, '50000'+49, 0, 0, 'Ready to go in  Utgarde Keep?'),
('50000'+3, 11, 2, 'Utgarde Pinnacle', 1, 1, 0, 0, '50000'+50, 0, 0, 'Ready to go in  Utgarde Pinnacle?'),
('50000'+3, 12, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+4, 0, 2, 'Black Temple', 1, 1, 0, 0, '50000'+51, 0, 0, 'Ready to go in  Black Temple?'),
('50000'+4, 1, 2, 'Blackwing Lair', 1, 1, 0, 0, '50000'+52, 0, 0, 'Ready to go in  Blackwing Lair?'),
('50000'+4, 2, 2, 'Hyjal Summit', 1, 1, 0, 0, '50000'+53, 0, 0, 'Ready to go in  Hyjal Summit?'),
('50000'+4, 3, 2, 'Serpentshrine Cavern', 1, 1, 0, 0, '50000'+54, 0, 0, 'Ready to go in  Serpentshrine Cavern?'),
('50000'+4, 4, 2, 'Trial of the Crusader', 1, 1, 0, 0, '50000'+55, 0, 0, 'Ready to go in  Trial of the Crusader?'),
('50000'+4, 5, 2, 'Gruul\'s Lair', 1, 1, 0, 0, '50000'+56, 0, 0, 'Ready to go in  Gruul\'s Lair?'),
('50000'+4, 6, 2, 'Magtheridon\'s Lair', 1, 1, 0, 0, '50000'+57, 0, 0, 'Ready to go in  Magtheridon\'s Lair?'),
('50000'+4, 7, 2, 'Icecrown Citadel', 1, 1, 0, 0, '50000'+58, 0, 0, 'Ready to go in  Icecrown Citadel?'),
('50000'+4, 8, 2, 'Karazhan', 1, 1, 0, 0, '50000'+59, 0, 0, 'Ready to go in  Karazhan?'),
('50000'+4, 9, 2, 'Molten Core', 1, 1, 0, 0, '50000'+60, 0, 0, 'Ready to go in  Molten Core?'),
('50000'+4, 10, 2, 'Naxxramas', 1, 1, 0, 0, '50000'+61, 0, 0, 'Ready to go in  Naxxramas?'),
('50000'+4, 11, 2, 'Onyxia\'s Lair', 1, 1, 0, 0, '50000'+62, 0, 0, 'Ready to go in  Onyxia\'s Lair?'),
('50000'+4, 12, 2, 'Ruins of Ahn\'Qiraj', 1, 1, 0, 0, '50000'+63, 0, 0, 'Ready to go in  Ruins of Ahn\'Qiraj?'),
('50000'+4, 13, 2, 'Sunwell Plateau', 1, 1, 0, 0, '50000'+64, 0, 0, 'Ready to go in  Sunwell Plateau?'),
('50000'+4, 14, 2, 'The Eye', 1, 1, 0, 0, '50000'+65, 0, 0, 'Ready to go in  The Eye?'),
('50000'+4, 15, 2, 'Temple of Ahn\'Qiraj', 1, 1, 0, 0, '50000'+66, 0, 0, 'Ready to go in  Temple of Ahn\'Qiraj?'),
('50000'+4, 16, 2, 'The Eye of Eternity', 1, 1, 0, 0, '50000'+67, 0, 0, 'Ready to go in  The Eye of Eternity?'),
('50000'+4, 17, 2, 'The Obsidian Sanctum', 1, 1, 0, 0, '50000'+68, 0, 0, 'Ready to go in  The Obsidian Sanctum?'),
('50000'+4, 18, 2, 'Ulduar', 1, 1, 0, 0, '50000'+69, 0, 0, 'Ready to go in  Ulduar?'),
('50000'+4, 19, 2, 'Vault of Archavon', 1, 1, 0, 0, '50000'+70, 0, 0, 'Ready to go in  Vault of Archavon?'),
('50000'+4, 21, 2, 'Zul\'Gurub', 1, 1, 0, 0, '50000'+72, 0, 0, 'Ready to go in  Zul\'Gurub?'),
('50000'+4, 22, 2, 'Zul\'Aman', 1, 1, 0, 0, '50000'+73, 0, 0, 'Ready to go in  Zul\'Aman?'),
('50000'+4, 23, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+5, 0, 2, 'Elwynn Forest', 1, 1, 0, 0, '50000'+74, 0, 0, 'Ready to go in  Elwynn Forest?'),
('50000'+5, 1, 2, 'Eversong Woods', 1, 1, 0, 0, '50000'+75, 0, 0, 'Ready to go in  Eversong Woods?'),
('50000'+5, 2, 2, 'Dun Morogh', 1, 1, 0, 0, '50000'+76, 0, 0, 'Ready to go in  Dun Morogh?'),
('50000'+5, 3, 2, 'Tirisfal Glades', 1, 1, 0, 0, '50000'+77, 0, 0, 'Ready to go in  Tirisfal Glades?'),
('50000'+5, 4, 2, 'Ghostlands', 1, 1, 0, 0, '50000'+78, 0, 0, 'Ready to go in  Ghostlands?'),
('50000'+5, 5, 2, 'Loch modan', 1, 1, 0, 0, '50000'+79, 0, 0, 'Ready to go in  Loch modan?'),
('50000'+5, 6, 2, 'Silverpine Forest', 1, 1, 0, 0, '50000'+80, 0, 0, 'Ready to go in  Silverpine Forest?'),
('50000'+5, 7, 2, 'Westfall', 1, 1, 0, 0, '50000'+81, 0, 0, 'Ready to go in  Westfall?'),
('50000'+5, 8, 2, 'Redridge mountains', 1, 1, 0, 0, '50000'+82, 0, 0, 'Ready to go in  Redridge mountains?'),
('50000'+5, 9, 2, 'Duskwood', 1, 1, 0, 0, '50000'+83, 0, 0, 'Ready to go in  Duskwood?'),
('50000'+5, 10, 2, 'Hillsbrad Foothills', 1, 1, 0, 0, '50000'+84, 0, 0, 'Ready to go in  Hillsbrad Foothills?'),
('50000'+5, 11, 2, 'Wetlands', 1, 1, 0, 0, '50000'+85, 0, 0, 'Ready to go in  Wetlands?'),
('50000'+5, 12, 2, 'Alterac Mountains', 1, 1, 0, 0, '50000'+86, 0, 0, 'Ready to go in  Alterac Mountains?'),
('50000'+5, 13, 2, 'Arathi Highlands', 1, 1, 0, 0, '50000'+87, 0, 0, 'Ready to go in  Arathi Highlands?'),
('50000'+5, 14, 2, 'Stranglethorn Vale', 1, 1, 0, 0, '50000'+88, 0, 0, 'Ready to go in  Stranglethorn Vale?'),
('50000'+5, 15, 2, 'Badlands', 1, 1, 0, 0, '50000'+89, 0, 0, 'Ready to go in  Badlands?'),
('50000'+5, 16, 2, 'Swamp of Sorrows', 1, 1, 0, 0, '50000'+90, 0, 0, 'Ready to go in  Swamp of Sorrows?'),
('50000'+5, 17, 2, 'The Hinterlands', 1, 1, 0, 0, '50000'+91, 0, 0, 'Ready to go in  The Hinterlands?'),
('50000'+5, 18, 2, 'Searing Gorge', 1, 1, 0, 0, '50000'+92, 0, 0, 'Ready to go in  Searing Gorge?'),
('50000'+5, 19, 2, 'The Blasted Lands', 1, 1, 0, 0, '50000'+93, 0, 0, 'Ready to go in  The Blasted Lands?'),
('50000'+5, 20, 2, 'Burning Steppes', 1, 1, 0, 0, '50000'+94, 0, 0, 'Ready to go in  Burning Steppes?'),
('50000'+5, 21, 2, 'Western Plaguelands', 1, 1, 0, 0, '50000'+95, 0, 0, 'Ready to go in  Western Plaguelands?'),
('50000'+5, 22, 2, 'Eastern Plaguelands', 1, 1, 0, 0, '50000'+96, 0, 0, 'Ready to go in  Eastern Plaguelands?'),
('50000'+5, 23, 2, 'Isle of Quel\'Danas', 1, 1, 0, 0, '50000'+97, 0, 0, 'Ready to go in  Isle of Quel\'Danas?'),
('50000'+5, 24, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+6, 0, 2, 'Azuremyst Isle', 1, 1, 0, 0, '50000'+98, 0, 0, 'Ready to go in  Azuremyst Isle?'),
('50000'+6, 1, 2, 'Teldrassil', 1, 1, 0, 0, '50000'+99, 0, 0, 'Ready to go in  Teldrassil?'),
('50000'+6, 2, 2, 'Durotar', 1, 1, 0, 0, '50000'+100, 0, 0, 'Ready to go in  Durotar?'),
('50000'+6, 3, 2, 'Mulgore', 1, 1, 0, 0, '50000'+101, 0, 0, 'Ready to go in  Mulgore?'),
('50000'+6, 4, 2, 'Bloodmyst Isle', 1, 1, 0, 0, '50000'+102, 0, 0, 'Ready to go in  Bloodmyst Isle?'),
('50000'+6, 5, 2, 'Darkshore', 1, 1, 0, 0, '50000'+103, 0, 0, 'Ready to go in  Darkshore?'),
('50000'+6, 6, 2, 'The Barrens', 1, 1, 0, 0, '50000'+104, 0, 0, 'Ready to go in  The Barrens?'),
('50000'+6, 7, 2, 'Stonetalon Mountains', 1, 1, 0, 0, '50000'+105, 0, 0, 'Ready to go in  Stonetalon Mountains?'),
('50000'+6, 8, 2, 'Ashenvale Forest', 1, 1, 0, 0, '50000'+106, 0, 0, 'Ready to go in  Ashenvale Forest?'),
('50000'+6, 9, 2, 'Thousand Needles', 1, 1, 0, 0, '50000'+107, 0, 0, 'Ready to go in  Thousand Needles?'),
('50000'+6, 10, 2, 'Desolace', 1, 1, 0, 0, '50000'+108, 0, 0, 'Ready to go in  Desolace?'),
('50000'+6, 11, 2, 'Dustwallow Marsh', 1, 1, 0, 0, '50000'+109, 0, 0, 'Ready to go in  Dustwallow Marsh?'),
('50000'+6, 12, 2, 'Feralas', 1, 1, 0, 0, '50000'+110, 0, 0, 'Ready to go in  Feralas?'),
('50000'+6, 13, 2, 'Tanaris Desert', 1, 1, 0, 0, '50000'+111, 0, 0, 'Ready to go in  Tanaris Desert?'),
('50000'+6, 14, 2, 'Azshara', 1, 1, 0, 0, '50000'+112, 0, 0, 'Ready to go in  Azshara?'),
('50000'+6, 15, 2, 'Felwood', 1, 1, 0, 0, '50000'+113, 0, 0, 'Ready to go in  Felwood?'),
('50000'+6, 16, 2, 'Un\'Goro Crater', 1, 1, 0, 0, '50000'+114, 0, 0, 'Ready to go in  Un\'Goro Crater?'),
('50000'+6, 17, 2, 'Silithus', 1, 1, 0, 0, '50000'+115, 0, 0, 'Ready to go in  Silithus?'),
('50000'+6, 18, 2, 'Winterspring', 1, 1, 0, 0, '50000'+116, 0, 0, 'Ready to go in  Winterspring?'),
('50000'+6, 19, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+7, 0, 2, 'Hellfire Peninsula', 1, 1, 0, 0, '50000'+117, 0, 0, 'Ready to go in  Hellfire Peninsula?'),
('50000'+7, 1, 2, 'Zangarmarsh', 1, 1, 0, 0, '50000'+118, 0, 0, 'Ready to go in  Zangarmarsh?'),
('50000'+7, 2, 2, 'Terokkar Forest', 1, 1, 0, 0, '50000'+119, 0, 0, 'Ready to go in  Terokkar Forest?'),
('50000'+7, 3, 2, 'Nagrand', 1, 1, 0, 0, '50000'+120, 0, 0, 'Ready to go in  Nagrand?'),
('50000'+7, 4, 2, 'Blade\'s Edge Mountains', 1, 1, 0, 0, '50000'+121, 0, 0, 'Ready to go in  Blade\'s Edge Mountains?'),
('50000'+7, 5, 2, 'Netherstorm', 1, 1, 0, 0, '50000'+122, 0, 0, 'Ready to go in  Netherstorm?'),
('50000'+7, 6, 2, 'Shadowmoon Valley', 1, 1, 0, 0, '50000'+123, 0, 0, 'Ready to go in  Shadowmoon Valley?'),
('50000'+7, 7, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL),
('50000'+8, 0, 2, 'Borean Tundra', 1, 1, 0, 0, '50000'+124, 0, 0, 'Ready to go in  Borean Tundra?'),
('50000'+8, 1, 2, 'Howling Fjord', 1, 1, 0, 0, '50000'+125, 0, 0, 'Ready to go in  Howling Fjord?'),
('50000'+8, 2, 2, 'Dragonblight', 1, 1, 0, 0, '50000'+126, 0, 0, 'Ready to go in  Dragonblight?'),
('50000'+8, 3, 2, 'Grizzly Hills', 1, 1, 0, 0, '50000'+127, 0, 0, 'Ready to go in  Grizzly Hills?'),
('50000'+8, 4, 2, 'Zul\'Drak', 1, 1, 0, 0, '50000'+128, 0, 0, 'Ready to go in  Zul\'Drak?'),
('50000'+8, 5, 2, 'Sholazar Basin', 1, 1, 0, 0, '50000'+129, 0, 0, 'Ready to go in  Sholazar Basin?'),
('50000'+8, 6, 2, 'Crystalsong Forest', 1, 1, 0, 0, '50000'+130, 0, 0, 'Ready to go in  Crystalsong Forest?'),
('50000'+8, 7, 2, 'Storm Peaks', 1, 1, 0, 0, '50000'+132, 0, 0, 'Ready to go in  Storm Peaks?'),
('50000'+8, 8, 2, 'Icecrown', 1, 1, 0, 0, '50000'+133, 0, 0, 'Ready to go in  Icecrown?'),
('50000'+8, 9, 2, 'Wintergrasp', 1, 1, 0, 0, '50000'+134, 0, 0, 'Ready to go in  Wintergrasp?'),
('50000'+8, 10, 7, 'Back..', 1, 1, '50000', 0, 0, 0, 0, NULL);

INSERT INTO gossip_scripts (id, delay, command, datalong, datalong2, dataint, x, y, z, o) VALUES
('50000', 0, 6, 0, 0, 0, -8842.09, 626.358, 94.0867, 3.61363),
('50000'+1, 0, 6, 1, 0, 0, 1546.449951, -4404.390137, 18.208300, 1.670500),
('50000'+2, 0, 6, 0, 0, 0, -14281.9, 552.564, 8.90422, 0.860144),
('50000'+3, 0, 6, 530, 0, 0, -1887.62, 5359.09, -12.4279, 4.40435),
('50000'+5, 0, 6, 571, 0, 0, 5809.55, 503.975, 657.526, 2.38338),
('50000'+6, 0, 6, 0, 0, 0, -13181.8, 339.356, 42.9805, 1.18013),
('50000'+8, 0, 6, 1, 0, 0, 9869.91, 2493.58, 1315.88, 2.78897),
('50000'+9, 0, 6, 0, 0, 0, -4900.47, -962.585, 501.455, 5.40538),
('50000'+10, 0, 6, 530, 0, 0, -3864.92, -11643.7, -137.644, 5.50862),
('50000'+11, 0, 6, 1, 0, 0, -1274.45, 71.8601, 128.159, 2.80623),
('50000'+12, 0, 6, 0, 0, 0, 1633.75, 240.167, -43.1034, 6.26128),
('50000'+13, 0, 6, 530, 0, 0, 9738.28, -7454.19, 13.5605, 0.043914),
('50000'+14, 0, 6, 732, 0, 0, -707, 1183, 106, 2),
('50000'+15, 0, 6, 648, 0, 0, 1783, 2278, 192, 5),
('50000'+16, 0, 6, 0, 0, 0, -4060, -3451, 281, 0),
('50000'+17, 0, 6, 732, 0, 0, -707, 1183, 106, 2),
('50000'+18, 0, 6, 648, 0, 0, 1783, 2278, 192, 5),
('50000'+19, 0, 6, 0, 0, 0, -4060, -3451, 281, 0),
('50000'+23, 0, 6, 0, 0, 0, -5596, 5410, -1796, 5),
('50000'+24, 0, 6, 1, 0, 0, -10209, -1839, 20, 3),
('50000'+25, 0, 6, 0, 0, 0, -1936, 1900, 90, 0),
('50000'+26, 0, 6, 0, 0, 0, -4891, -4235, 829, 2),
('50000'+27, 0, 6, 646, 0, 0, 1024, 646, 157, 4),
('50000'+28, 0, 6, 0, 0, 0, -7539, -1196, 477, 2),
('50000'+29, 0, 6, 1, 0, 0, -11511, -2308, 608, 3),
('50000'+30, 0, 6, 1, 0, 0, -10672, -1305, 16, 3),
('50000'+31, 0, 6, 1, 0, 0, 4664, -3685, 957, 3),
('50000'+32, 0, 6, 730, 0, 0, 848, 1052, -6, 5),
('50000'+33, 0, 6, 530, 0, 0, -3324.49, 4943.45, -101.239, 4.63901),
('50000'+34, 0, 6, 1, 0, 0, -8369.65, -4253.11, -204.272, -2.70526),
('50000'+35, 0, 6, 530, 0, 0, 738.865, 6865.77, -69.4659, 6.27655),
('50000'+36, 0, 6, 530, 0, 0, -347.29, 3089.82, 21.394, 5.68114),
('50000'+37, 0, 6, 530, 0, 0, 12884.6, -7317.69, 65.5023, 4.799),
('50000'+38, 0, 6, 530, 0, 0, 3100.48, 1536.49, 190.3, 4.62226),
('50000'+39, 0, 6, 571, 0, 0, 3707.86, 2150.23, 36.76, 3.22),
('50000'+40, 0, 6, 1, 0, 0, -8756.39, -4440.68, -199.489, 4.66289),
('50000'+41, 0, 6, 571, 0, 0, 8590.95, 791.792, 558.235, 3.13127),
('50000'+42, 0, 6, 571, 0, 0, 4765.59, -2038.24, 229.363, 0.887627),
('50000'+43, 0, 6, 571, 0, 0, 6722.44, -4640.67, 450.632, 3.91123),
('50000'+44, 0, 6, 571, 0, 0, 5643.16, 2028.81, 798.274, 4.60242),
('50000'+45, 0, 6, 571, 0, 0, 3782.89, 6965.23, 105.088, 6.14194),
('50000'+46, 0, 6, 571, 0, 0, 5693.08, 502.588, 652.672, 4.0229),
('50000'+47, 0, 6, 571, 0, 0, 9136.52, -1311.81, 1066.29, 5.19113),
('50000'+48, 0, 6, 571, 0, 0, 8922.12, -1009.16, 1039.56, 1.57044),
('50000'+49, 0, 6, 571, 0, 0, 1203.41, -4868.59, 41.2486, 0.283237),
('50000'+50, 0, 6, 571, 0, 0, 1267.24, -4857.3, 215.764, 3.22768),
('50000'+51, 0, 6, 530, 0, 0, -3649.92, 317.469, 35.2827, 2.94285),
('50000'+52, 0, 6, 229, 0, 0, 152.451, -474.881, 116.84, 0.001073),
('50000'+53, 0, 6, 1, 0, 0, -8177.89, -4181.23, -167.552, 0.913338),
('50000'+54, 0, 6, 530, 0, 0, 797.855, 6865.77, -65.4165, 0.005938),
('50000'+55, 0, 6, 571, 0, 0, 8515.61, 714.153, 558.248, 1.57753),
('50000'+56, 0, 6, 530, 0, 0, 3530.06, 5104.08, 3.50861, 5.51117),
('50000'+57, 0, 6, 530, 0, 0, -336.411, 3130.46, -102.928, 5.20322),
('50000'+58, 0, 6, 571, 0, 0, 5855.22, 2102.03, 635.991, 3.57899),
('50000'+59, 0, 6, 0, 0, 0, -11118.9, -2010.33, 47.0819, 0.649895),
('50000'+60, 0, 6, 230, 0, 0, 1126.64, -459.94, -102.535, 3.46095),
('50000'+61, 0, 6, 571, 0, 0, 3668.72, -1262.46, 243.622, 4.785),
('50000'+62, 0, 6, 1, 0, 0, -4708.27, -3727.64, 54.5589, 3.72786),
('50000'+63, 0, 6, 1, 0, 0, -8409.82, 1499.06, 27.7179, 2.51868),
('50000'+64, 0, 6, 530, 0, 0, 12574.1, -6774.81, 15.0904, 3.13788),
('50000'+65, 0, 6, 530, 0, 0, 3088.49, 1381.57, 184.863, 4.61973),
('50000'+66, 0, 6, 1, 0, 0, -8240.09, 1991.32, 129.072, 0.941603),
('50000'+67, 0, 6, 571, 0, 0, 3784.17, 7028.84, 161.258, 5.79993),
('50000'+68, 0, 6, 571, 0, 0, 3472.43, 264.923, -120.146, 3.27923),
('50000'+69, 0, 6, 571, 0, 0, 9222.88, -1113.59, 1216.12, 6.27549),
('50000'+70, 0, 6, 571, 0, 0, 5453.72, 2840.79, 421.28, 0),
('50000'+72, 0, 6, 0, 0, 0, -11916.7, -1215.72, 92.289, 4.72454),
('50000'+73, 0, 6, 530, 0, 0, 6851.78, -7972.57, 179.242, 4.64691),
('50000'+74, 0, 6, 0, 0, 0, -9449.06, 64.8392, 56.3581, 3.07047),
('50000'+75, 0, 6, 530, 0, 0, 9024.37, -6682.55, 16.8973, 3.14131),
('50000'+76, 0, 6, 0, 0, 0, -5603.76, -482.704, 396.98, 5.23499),
('50000'+77, 0, 6, 0, 0, 0, 2274.95, 323.918, 34.1137, 4.24367),
('50000'+78, 0, 6, 530, 0, 0, 7595.73, -6819.6, 84.3718, 2.56561),
('50000'+79, 0, 6, 0, 0, 0, -5405.85, -2894.15, 341.972, 5.48238),
('50000'+80, 0, 6, 0, 0, 0, 505.126, 1504.63, 124.808, 1.77987),
('50000'+81, 0, 6, 0, 0, 0, -10684.9, 1033.63, 32.5389, 6.07384),
('50000'+82, 0, 6, 0, 0, 0, -9447.8, -2270.85, 71.8224, 0.283853),
('50000'+83, 0, 6, 0, 0, 0, -10531.7, -1281.91, 38.8647, 1.56959),
('50000'+84, 0, 6, 0, 0, 0, -385.805, -787.954, 54.6655, 1.03926),
('50000'+85, 0, 6, 0, 0, 0, -3517.75, -913.401, 8.86625, 2.60705),
('50000'+86, 0, 6, 0, 0, 0, 275.049, -652.044, 130.296, 0.502032),
('50000'+87, 0, 6, 0, 0, 0, -1581.45, -2704.06, 35.4168, 0.490373),
('50000'+88, 0, 6, 0, 0, 0, -11921.7, -59.544, 39.7262, 3.73574),
('50000'+89, 0, 6, 0, 0, 0, -6782.56, -3128.14, 240.48, 5.65912),
('50000'+90, 0, 6, 0, 0, 0, -10368.6, -2731.3, 21.6537, 5.29238),
('50000'+91, 0, 6, 0, 0, 0, 112.406, -3929.74, 136.358, 0.981903),
('50000'+92, 0, 6, 0, 0, 0, -6686.33, -1198.55, 240.027, 0.916887),
('50000'+93, 0, 6, 0, 0, 0, -11184.7, -3019.31, 7.29238, 3.20542),
('50000'+94, 0, 6, 0, 0, 0, -7979.78, -2105.72, 127.919, 5.10148),
('50000'+95, 0, 6, 0, 0, 0, 1743.69, -1723.86, 59.6648, 5.23722),
('50000'+96, 0, 6, 0, 0, 0, 2280.64, -5275.05, 82.0166, 4.7479),
('50000'+97, 0, 6, 530, 0, 0, 12806.5, -6911.11, 41.1156, 2.22935),
('50000'+98, 0, 6, 530, 0, 0, -4192.62, -12576.7, 36.7598, 1.62813),
('50000'+99, 0, 6, 1, 0, 0, 9889.03, 915.869, 1307.43, 1.9336),
('50000'+100, 0, 6, 1, 0, 0, 228.978, -4741.87, 10.1027, 0.416883),
('50000'+101, 0, 6, 1, 0, 0, -2473.87, -501.225, -9.42465, 0.6525),
('50000'+102, 0, 6, 530, 0, 0, -2095.7, -11841.1, 51.1557, 6.19288),
('50000'+103, 0, 6, 1, 0, 0, 6463.25, 683.986, 8.92792, 4.33534),
('50000'+104, 0, 6, 1, 0, 0, -575.772, -2652.45, 95.6384, 0.006469),
('50000'+105, 0, 6, 1, 0, 0, 1574.89, 1031.57, 137.442, 3.8013),
('50000'+106, 0, 6, 1, 0, 0, 1919.77, -2169.68, 94.6729, 6.14177),
('50000'+107, 0, 6, 1, 0, 0, -5375.53, -2509.2, -40.432, 2.41885),
('50000'+108, 0, 6, 1, 0, 0, -656.056, 1510.12, 88.3746, 3.29553),
('50000'+109, 0, 6, 1, 0, 0, -3350.12, -3064.85, 33.0364, 5.12666),
('50000'+110, 0, 6, 1, 0, 0, -4808.31, 1040.51, 103.769, 2.90655),
('50000'+111, 0, 6, 1, 0, 0, -6940.91, -3725.7, 48.9381, 3.11174),
('50000'+112, 0, 6, 1, 0, 0, 3117.12, -4387.97, 91.9059, 5.49897),
('50000'+113, 0, 6, 1, 0, 0, 3898.8, -1283.33, 220.519, 6.24307),
('50000'+114, 0, 6, 1, 0, 0, -6291.55, -1158.62, -258.138, 0.457099),
('50000'+115, 0, 6, 1, 0, 0, -6815.25, 730.015, 40.9483, 2.39066),
('50000'+116, 0, 6, 1, 0, 0, 6658.57, -4553.48, 718.019, 5.18088),
('50000'+117, 0, 6, 530, 0, 0, -207.335, 2035.92, 96.464, 1.59676),
('50000'+118, 0, 6, 530, 0, 0, -220.297, 5378.58, 23.3223, 1.61718),
('50000'+119, 0, 6, 530, 0, 0, -2266.23, 4244.73, 1.47728, 3.68426),
('50000'+120, 0, 6, 530, 0, 0, -1610.85, 7733.62, -17.2773, 1.33522),
('50000'+121, 0, 6, 530, 0, 0, 2029.75, 6232.07, 133.495, 1.30395),
('50000'+122, 0, 6, 530, 0, 0, 3271.2, 3811.61, 143.153, 3.44101),
('50000'+123, 0, 6, 530, 0, 0, -3681.01, 2350.76, 76.587, 4.25995),
('50000'+124, 0, 6, 571, 0, 0, 2954.24, 5379.13, 60.4538, 2.55544),
('50000'+125, 0, 6, 571, 0, 0, 682.848, -3978.3, 230.161, 1.54207),
('50000'+126, 0, 6, 571, 0, 0, 2678.17, 891.826, 4.37494, 0.101121),
('50000'+127, 0, 6, 571, 0, 0, 4017.35, -3403.85, 290, 5.35431),
('50000'+128, 0, 6, 571, 0, 0, 5560.23, -3211.66, 371.709, 5.55055),
('50000'+129, 0, 6, 571, 0, 0, 5614.67, 5818.86, -69.722, 3.60807),
('50000'+130, 0, 6, 571, 0, 0, 5411.17, -966.37, 167.082, 1.57167),
('50000'+132, 0, 6, 571, 0, 0, 6120.46, -1013.89, 408.39, 5.12322),
('50000'+133, 0, 6, 571, 0, 0, 8323.28, 2763.5, 655.093, 2.87223),
('50000'+134, 0, 6, 571, 0, 0, 4522.23, 2828.01, 389.975, 0.215009);