WoW-Info — информационный World of Warcraft портал

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);