Skip to content

Instantly share code, notes, and snippets.

@MantisLord

MantisLord/0003_Custom_Vengeance_NPCs.sql Secret

Last active December 18, 2020 05:07
Show Gist options
  • Save MantisLord/53af9ff48493938a8996b13a5a899844 to your computer and use it in GitHub Desktop.
Save MantisLord/53af9ff48493938a8996b13a5a899844 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
0003_Custom_Vengeance_NPCs.sql
-- =============================================
-- Light's Vengeance Custom NPCs and Gameobjects
-- =============================================
DELETE FROM creature_template WHERE entry IN (100000,100100,100200,100300,100400,100500,100600,100601,100602,100700,100800,100801,100900);
DELETE FROM creature_template WHERE entry IN (100501,100502,100503);
INSERT INTO creature_template (Entry, Name, SubName, IconName, MinLevel, MaxLevel, HeroicEntry, ModelId1, ModelId2, ModelId3, ModelId4, Faction, Scale, Family, CreatureType, InhabitType, RegenerateStats, RacialLeader, NpcFlags, UnitFlags, DynamicFlags, ExtraFlags, CreatureTypeFlags, SpeedWalk, SpeedRun, Detection, CallForHelp, Pursuit, Leash, Timeout, UnitClass, `Rank`, Expansion, HealthMultiplier, PowerMultiplier, DamageMultiplier, DamageVariance, ArmorMultiplier, ExperienceMultiplier, MinLevelHealth, MaxLevelHealth, MinLevelMana, MaxLevelMana, MinMeleeDmg, MaxMeleeDmg, MinRangedDmg, MaxRangedDmg, Armor, MeleeAttackPower, RangedAttackPower, MeleeBaseAttackTime, RangedBaseAttackTime, DamageSchool, MinLootGold, MaxLootGold, LootId, PickpocketLootId, SkinningLootId, KillCredit1, KillCredit2, MechanicImmuneMask, SchoolImmuneMask, ResistanceHoly, ResistanceFire, ResistanceNature, ResistanceFrost, ResistanceShadow, ResistanceArcane, PetSpellDataId, MovementType, TrainerType, TrainerSpell, TrainerClass, TrainerRace, TrainerTemplateId, VendorTemplateId, EquipmentTemplateId, GossipMenuId, AIName, ScriptName) VALUES
('100000','Raid Messenger','Light''s Vengeance','','73','73','0','24735','24735','24735','24735','35','1','0','7','3','3','0','1','0','0','0','0','1','1.14286','20','0','0','0','0','1','3','1','1','1','1','1','1','1','7588','7588','0','0','2','2','0','0','7','11','0','2000','2000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','100000','50000','',''),
('100100','Dungeon Messenger','Light''s Vengeance','','73','73','0','22968','22968','22968','22968','35','1','0','7','3','3','0','1','0','0','0','0','1','1.14286','20','0','0','0','0','1','3','1','1','1','1','1','1','1','7588','7588','0','0','2','2','0','0','7','11','0','2000','2000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2133','50100','',''),
('100200','Alliance Greeter','Light''s Vengeance','','1','1','0','2968','10214','22775','2968','534','1','0','7','3','3','0','1','0','0','0','0','1','1.14286','20','0','0','0','0','1','2','0','1','1','1','1','1','1','42','42','0','0','2','2','0','0','7','11','0','2000','2000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','50200','','npc_vengeance_greeter'),
('100300','Horde Greeter','Light''s Vengeance','','1','1','0','15730','4059','4523','4526','714','1','0','7','3','3','0','1','0','0','0','0','1','1.14286','20','0','0','0','0','1','2','0','1','1','1','1','1','1','42','42','0','0','2','2','0','0','7','11','0','2000','2000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','50200','','npc_vengeance_greeter'),
('100400','Alliance Realm Information','Light''s Vengeance','','1','1','0','24755','24755','24755','24755','35','1','0','7','3','3','0','1','0','0','0','0','1','1.14286','20','0','0','0','0','1','2','0','1','1','1','1','1','1','42','42','0','0','2','2','0','0','7','11','0','2000','2000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','50300','',''),
('100500','Horde Realm Information','Light''s Vengeance','','1','1','0','11803','11803','11803','11803','35','1','0','7','3','3','0','1','0','0','0','0','1','1.14286','20','0','0','0','0','1','2','0','1','1','1','1','1','1','42','42','0','0','2','2','0','0','7','11','0','2000','2000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','50300','',''),
('100600','Enchantment Crystal','','','1','1','0','11659','11659','11659','11659','35','0.75','0','7','3','3','0','1','0','0','0','0','1','1.14286','20','0','0','0','0','1','0','0','1','1','1','1','1','1','42','42','0','0','2','2','0','0','7','11','0','2000','2000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','npc_enchantment_crystal'),
('100601','Dual Specialization Crystal','','','1','1','0','11659','11659','11659','11659','35','1','0','7','3','3','0','1','0','0','0','0','1','1.14286','20','0','0','0','0','1','0','0','1','1','1','1','1','1','42','42','0','0','2','2','0','0','7','11','0','2000','2000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','npc_custom_dualspec'),
(100602, 'Barber', '', '', 70, 70, 0, 23766, 0, 0, 0, 35, 1, 0, 7, 3, 3, 0, 1, 0, 0, 0, 0, 1, 1.14286, 20, 0, 0, 0, 0, 1, 0, 0, 1, 1, 1, 1, 1, 1, 42, 42, 0, 0, 2, 2, 0, 0, 7, 11, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 'npc_vengeance_barber'),
(100700, 'Grandmaster''s Training Dummy', '', '', 73, 73, 0, 16074, 0, 0, 0, 7, 1.5, 0, 9, 3, 0, 0, 0, 32768, 0, 64, 4, 1, 1.14286, 20, 0, 0, 0, 0, 1, 1, 1, 1000, 1, 1, 1, 1, 1, 7888000, 7888000, 0, 0, 0, 0, 0, 0, 7684, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8585235, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 'npc_target_dummy'),
(100800, 'Advanced Training Dummy', '', '', 70, 70, 0, 3019, 0, 0, 0, 7, 1, 0, 9, 3, 3, 0, 0, 0, 0, 64, 0, 1, 1.14286, 20, 0, 0, 0, 0, 1, 0, 1, 200, 1, 1, 1, 1, 1, 1397200, 1397200, 0, 0, 2, 2, 0, 0, 4691, 0, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 8585235, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 'npc_target_dummy'),
(100801, 'Beginner Training Dummy', '', '', 63, 63, 0, 3019, 0, 0, 0, 7, 0.75, 0, 9, 3, 3, 0, 0, 0, 0, 64, 0, 1, 1.14286, 20, 0, 0, 0, 0, 1, 0, 1, 200, 1, 1, 1, 1, 1, 1397200, 1397200, 0, 0, 2, 2, 0, 0, 4691, 0, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 8585235, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 'npc_target_dummy'),
(100501, 'Alliance Enlistment Officer', 'Light''s Vengeance', '', 1, 1, 0, 12075, 0, 0, 0, 534, 1, 0, 7, 3, 3, 0, 945, 768, 0, 0, 0, 1.2, 1.14286, 20, 0, 0, 0, 0, 1, 0, 1, 15, 1, 1, 1, 1, 1, 630, 630, 0, 0, 2, 2, 0, 0, 15, 1, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100501, 0, '', 'npc_enlistment_officer'),
(100502, 'Horde Enlistment Officer', 'Light''s Vengeance', '', 1, 1, 0, 12080, 0, 0, 0, 714, 1, 0, 7, 3, 3, 0, 945, 768, 0, 0, 0, 1.2, 1.14286, 20, 0, 0, 0, 0, 1, 0, 1, 15, 1, 1, 1, 1, 1, 630, 630, 0, 0, 2, 2, 0, 0, 15, 1, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100502, 0, '', 'npc_enlistment_officer'),
(100503, 'Master Provisioner', 'Light''s Vengeance', '', 70, 70, 0, 22899, 0, 0, 0, 35, 2.5, 0, 7, 1, 3, 0, 945, 768, 0, 0, 0, 1, 1.14286, 20, 0, 0, 0, 0, 1, 0, 0, 1, 1, 1, 1, 1, 1, 2768, 2768, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100503, 0, '', 'npc_enlistment_officer'),
('100900','Realm Information','Light''s Vengeance','','1','1','0','6328','6328','6328','6328','35','1','0','7','3','3','0','1','0','0','0','0','1','1.14286','20','0','0','0','0','1','2','0','1','1','1','1','1','1','42','42','0','0','2','2','0','0','7','11','0','2000','2000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','50300','','');
DELETE FROM gameobject_template WHERE entry IN (400000,400001,400002,400003);
INSERT INTO `gameobject_template` (entry, `type`, displayId, name, IconName, castBarCaption, faction, flags, ExtraFlags, `size`, data0, data1, data2, data3, data4, data5, data6, data7, data8, data9, data10, data11, data12, data13, data14, data15, data16, data17, data18, data19, data20, data21, data22, data23, CustomData1, mingold, maxgold, ScriptName) values
(400000, 5, 343, 'Teleporter Circle', '', '', 0, 0, 0, 0.75, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(400001, 2, 210, 'Training Dummy Information', '', '', 0, 0, 0, 0.75, 0, 0, 2, 50404, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(400002, 2, 1327, 'Portal', '', '', 0, 0, 0, 1.4, 0, 0, 0, 51000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(400003, 3, 928, 'Giant Book Floor', '', '', 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
DELETE FROM creature_equip_template WHERE entry IN (100501,100502,100503,100000);
INSERT INTO creature_equip_template (entry, equipentry1, equipentry2, equipentry3) VALUES
(100501,12584,18825,0), -- Grand Marshal's Longsword, Grand Marshal's Aegis
(100502,16345,18826,0), -- High Warlord's Blade, High Warlord's Shield Wall
(100503,28487,2081,0), -- Monster - Work Wrench, Ethereal (Purple Glow), Monster - Torch, Offhand
(100000,13706,35073,0); -- Monster - Axe, 2H Horde Black Tombstone, Brutal Gladiator's Redoubt
DELETE FROM creature_template_addon WHERE entry IN (100000,100100,100200,100300,100501,100502,100503);
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `b2_0_sheath`, `b2_1_flags`, `emote`, `moveflags`, `auras`) VALUES
('100000','0','0','1','0','375','0','35838'), -- STATE_READY2H, Ghost Visual
('100100','0','0','1','0','333','0','35838'), -- STATE_READY1H, Ghost Visual
('100200','0','0','0','0','0','0','35838'), -- Ghost Visual
('100300','0','0','0','0','0','0','35838'), -- Ghost Visual
('100501','0','0','1','0','333','0','35838'), -- Ghost Visual, STATE_READY1H
('100502','0','0','1','0','333','0','35838'), -- Ghost Visual, STATE_READY1H
('100503','0','0','1','0','0','0','35838'); -- Ghost Visual
DELETE FROM creature WHERE id IN (100000,100100,100200,100300,100400,100500);
INSERT INTO creature (guid, id, map, spawnMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType) VALUES
(180001,100000,530,0,0,0,-3647.07,315.873,35.3595,5.96742,25,25,0,0,7588,0,0,0), -- Black Temple
(180002,100000,530,0,0,0,6850.89,-7995.011,192.36881,1.433062,25,25,0,0,7588,0,0,0), -- Zul'Aman
(180003,100100,530,0,0,0,12884.34,-7337.6,65.4872,1.392411,25,25,0,0,7588,0,0,0), -- Magisters' Terrace
(180004,100000,530,0,0,0,12556.3,-6774.45,15.0784,6.24727,25,25,0,0,7588,0,0,0), -- Sunwell Plateau
-- Alliance Light's Vengeance Greeter NPC Spawns
(180201,100200,0,1,3374,0,-8931.93, -132.83, 82.88, 3.26, 25,25,0,0,42,0,0,0), -- Northshire (Human)
(180202,100200,0,1,3355,0, -6213.47, 330.64, 383.68, 3.15, 25,25,0,0,42,0,0,0), -- Coldridge Valley (Dwarf and Gnome)
(180203,100200,1,1,1982,0, 10317.40, 821.00, 1326.37, 2.15, 25,25,0,0,42,0,0,0), -- Shadowglen (Night Elf)
(180204,100200,530,1,16490,0,-1968.69, -11876.47, 48.80, 4.48, 25,25,0,0,42,0,0,0), -- Blood Watch (Draenei 20+)
(180205,100200,530,1,16490,0,-3983.02, -13898.48, 96.30, 5.32, 25,25,0,0,42,0,0,0), -- Ammen Vale (Draenei)
(180206,100200,1,1,0,0,2757.02,-398.38,111.461,5.83229,25,25,0,0,42,0,0,0), -- Astranaar, Ashenvale (Alliance 20+)
(180207,100200,0,1,0,0,-10530.1,-1174.96,28.104,1.69525,25,25,0,0,42,0,0,0), -- Darkshire, Duskwood (Alliance 20+)
(180208,100200,0,1,0,0,-9248.25,-2166.63,64.0582,3.07986,25,25,0,0,42,0,0,0), -- Lakeshire, Redridge Mountains (Alliance 20+)
(180209,100200,0,1,0,0,-5362.45,-2956.97,323.848,0.857575,25,25,0,0,42,0,0,0), -- Thelsamar, Loch Modan (Alliance 20+)
(180210,100200,1,1,0,0,2715.53,1493.84,236.82,2.36479,25,25,0,0,42,0,0,0), -- Stonetalon Peak, Stonetalon Mountains (Alliance 20+)
(180211,100200,0,1,0,0,-846.075,-546.52,11.0796,1.53876,25,25,0,0,42,0,0,0), -- Southshore, Hillsbrad Foothills (Alliance 20+)
(180212,100200,0,1,0,0,-3794.24,-832.551,9.65552,6.19475,25,25,0,0,42,0,0,0), -- Menethil Harbor, Wetlands (Alliance 20+)
-- Horde Light's Vengeance Greeter NPC Spawns
(180301,100300,1,1,4390,0,-607.47, -4248.13, 38.95, 3.27, 25,25,0,0,42,0,0,0), -- Valley of Trials (Orc and Troll)
(180302,100300,0,1,1027,0,1656.367,1682.592,120.78681,0.06632,25,25,0,0,42,0,0,0), -- Deathknell (Undead)
(180303,100300,1,1,2130,0,-2913.71, -254.67, 52.94, 3.70, 25,25,0,0,42,0,0,0), -- Camp Narache (Tauren)
(180304,100300,530,1,15504,0,7572.59, -6819.23, 86.64, 0.09, 25,25,0,0,42,0,0,0), -- Tranquillien (Blood Elf 20+)
(180305,100300,530,1,15504,0,10354.33, -6370.34, 36.04, 1.92, 25,25,0,0,42,0,0,0), -- Sunstrider Isle (Blood Elf)
(180306,100300,1,1,0,0,913.12,921.155,106.258,4.09974,25,25,0,0,42,0,0,0), -- Sun Rock Retreat, Stonetalon Mountains (Horde 20+)
(180307,100300,1,1,0,0,-2363.12,-1963.87,96.0848,0.17341,25,25,0,0,42,0,0,0), -- Camp Taurajo, The Barrens (Horde 20+)
(180308,100300,1,1,0,0,2333.13,-2543.09,101.565,2.5894,25,25,0,0,42,0,0,0), -- Splintertree Post, Ashenvale (Horde 20+)
(180309,100300,0,1,0,0,505.088,1639.41,125.942,4.90182,25,25,0,0,42,0,0,0), -- The Sepulcher, Silverpine Forest (Horde 20+)
(180310,100300,0,1,0,0,-29.2284,-915.915,54.8742,4.301,25,25,0,0,42,0,0,0), -- Tarren Mill, Hillsbrad Foothills (Horde 20+)
(180311,100300,1,1,0,0,-428.479,-2657.02,96.3332,3.16669,25,25,0,0,42,0,0,0), -- The Crossroads, The Barrens (Horde 20+)
-- Alliance Realm Information NPC Spawns
(180401,100400,0,1,0,0,-8852.23,639.835,96.3843,0.958539,25,25,0,0,42,0,0,0), -- Stormwind
(180402,100400,0,1,0,0,-4895.91,-962.374,501.448,3.02565,25,25,0,0,42,0,0,0), -- Ironforge
(180403,100400,1,1,0,0,9941.17,2500.68,1317.96,4.15784,25,25,0,0,42,0,0,0), -- Darnassus
(180404,100400,530,1,0,0,-3905.68,-11610,-138.054,3.82175,25,25,0,0,42,0,0,0), -- Exodar
-- Horde Realm Information NPC Spawns
(180501,100500,1,1,0,0,1588.4,-4394.55,6.46053,4.92048,25,25,0,0,42,0,0,0), -- Orgrimmar
(180502,100500,1,1,0,0,-1265.43,49.056,127.614,0.284943,25,25,0,0,42,0,0,0), -- Thunder Bluff
(180503,100500,0,1,0,0,1563.83,263.1,-43.1027,5.59063,25,25,0,0,42,0,0,0), -- Undercity
(180504,100500,530,1,0,0,9513.37,-7300.74,14.4663,3.22001,25,25,0,0,42,0,0,0); -- Silvermoon City
-- add portal objects - despawned by default
DELETE FROM gameobject WHERE guid BETWEEN 300160 AND 300211;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`,`spawntimesecsmax`, `animprogress`, `state`) values
-- Classic Dungeon Ports Back To PTR Base
('300160','400002','1','0','-3514.7','1123.7','161.026','3.18951','0','0','0','0','1','1','100','1'),
('300161','400002','329','0','3388.34','-3379.91','142.758','3.0908','0','0','0','0','1','1','100','1'),
('300162','400002','289','0','191.748','126.756','136.697','3.14476','0','0','0','0','1','1','100','1'),
('300163','400002','230','0','457.177','34.6375','-69.451','1.56179','0','0','0','0','1','1','100','1'),
('300164','400002','109','0','-312.912','99.8684','-131.85','6.27819','0','0','0','0','1','1','100','1'),
('300165','400002','209','0','1210.88','842.603','8.92341','3.16518','0','0','0','0','1','1','100','1'),
('300166','400002','349','0','753.632','-621.518','-32.9648','4.7498','0','0','0','0','1','1','100','1'),
('300167','400002','70','0','-228.742','46.1557','-46.0197','4.68553','0','0','0','0','1','1','100','1'),
('300168','400002','129','0','2593.14','1110.8','50.9636','1.60626','0','0','0','0','1','1','100','1'),
('300169','400002','0','0','2841.7','-688.601','139.33','2.00294','0','0','0','0','1','1','100','1'),
('300170','400002','90','0','-328.649','-3.68268','-152.846','5.85897','0','0','0','0','1','1','100','1'),
('300171','400002','47','0','1940.62','1540.8','81.8905','3.98674','0','0','0','0','1','1','100','1'),
('300172','400002','34','0','48.5276','0.624905','-16.2335','3.13019','0','0','0','0','1','1','100','1'),
('300173','400002','48','0','-150.698','104.815','-40.1936','1.4214','0','0','0','0','1','1','100','1'),
('300174','400002','33','0','-228.972','2109.7','76.8898','1.267','0','0','0','0','1','1','100','1'),
('300175','400002','36','0','-14.7696','-386.369','62.7103','4.84216','0','0','0','0','1','1','100','1'),
('300176','400002','43','0','-162.999','132.661','-73.7355','5.83','0','0','0','0','1','1','100','1'),
('300177','400002','389','0','2.30476','-8.69099','-15.7848','1.60026','0','0','0','0','1','1','100','1'),
('300178','400002','229','0','78.071','-226.853','49.7684','1.69922','0','0','0','0','1','1','100','1'),
-- Classic Raid Portals Back To PTR Base
('300179','400002','229','0','129.03','-319.003','70.9556','3.2763','0','0','0','0','1','1','100','1'),
('300180','400002','409','0','1085.72','-476.182','-107.314','0.492129','0','0','0','0','1','1','100','1'),
('300181','400002','249','0','30.8192','-56.0592','-5.19956','1.58057','0','0','0','0','1','1','100','1'),
('300182','400002','469','0','-7672.67','-1107.07','396.652','3.74521','0','0','0','0','1','1','100','1'),
('300183','400002','309','0','-11916.5','-1231.92','92.5334','1.64541','0','0','0','0','1','1','100','1'),
(300184, 400002, 509, 0, -8436.53, 1519.17, 31.907, 2.61799, 0, 0, 0.965925, 0.258821, 25, 25, 100, 1), -- AQ20
(300185, 400002, 531, 0, -8221.35, 2014.34, 129.071, 0.872665, 0, 0, 0.422618, 0.906308, 25, 25, 100, 1), -- AQ40
(300186, 400002, 533, 0, 3005.87, -3435.01, 293.882, 0, 0, 0, 0, 1, 25, 25, 100, 1), -- Naxx
-- TBC Dungeon Portals Back to PTR Base
(300187, 400002, 543, 0, -1355.24, 1641.12, 68.2491, 1.12531, 0, 0, 0.533434, 0.845842, 25, 25, 100, 1), -- Hellfire Ramparts
(300188, 400002, 542, 0, -3.9967, 14.6363, -44.8009, 4.88748, 0, 0, 0.642574, -0.766224, 25, 25, 100, 1), -- Blood Furnace
(300189, 400002, 540, 0, -40.8716, -19.7538, -13.8065, 1.11133, 0, 0, 0.527508, 0.84955, 25, 25, 100, 1), -- Shattered Halls
(300190, 400002, 547, 0, 120.101, -131.957, -0.801547, 1.47574, 0, 0, 0.672713, 0.739903, 25, 25, 100, 1), -- Slave Pens
(300191, 400002, 546, 0, 9.71391, -16.2008, -2.75334, 5.57082, 0, 0, 0.348699, -0.937235, 25, 25, 100, 1), -- Underbog
(300192, 400002, 545, 0, -13.8425, 6.7542, -4.2586, 0, 0, 0, 0, 1, 25, 25, 100, 1), -- Steamvault
(300193, 400002, 557, 0, 0.0191, 0.9478, -0.9543, 3.03164, 0, 0, 0.998489, 0.0549486, 25, 25, 100, 1), -- Mana Tombs
(300194, 400002, 558, 0, -21.8975, 0.16, -0.1206, 0.0353412, 0, 0, 0.0176697, 0.999844, 25, 25, 100, 1), -- Auchenai Crypts
(300195, 400002, 556, 0, -4.6811, -0.0930796, 0.0062, 0.0353424, 0, 0, 0.0176703, 0.999844, 25, 25, 100, 1), -- Sethekk Halls
(300196, 400002, 555, 0, 0.488033, -0.215935, -1.12788, 3.15888, 0, 0, 0.999963, -0.00864356, 25, 25, 100, 1), -- Shadow Labyrinth
(300197, 400002, 560, 0, 2741.68, 1312.64, 14.0413, 2.79253, 0, 0, 0.984808, 0.173647, 25, 25, 100, 1), -- Old Hillsbrad Foothills
(300198, 400002, 269, 0, -1491.61, 7056.51, 32.1011, 1.74533, 0, 0, 0.766045, 0.642787, 25, 25, 100, 1), -- Black Morass
(300199, 400002, 553, 0, 40.0395, -28.613, -1.1189, 2.35856, 0, 0, 0.924332, 0.38159, 25, 25, 100, 1), -- The Botanica
(300200, 400002, 552, 0, -1.23165, 0.0143459, -0.204293, 0.0157123, 0, 0, 0.00785607, 0.999969, 25, 25, 100, 1), -- The Arcatraz
(300201, 400002, 554, 0, -28.906, 0.680314, -1.81282, 0.0345509, 0, 0, 0.0172746, 0.999851, 25, 25, 100, 1), -- The Mechanar
-- TBC Raid Portals Back To PTR Base
(300202, 400002, 532, 0, -11101.8, -1998.31, 49.8927, 0.690367, 0, 0, 0.338369, 0.941013, 25, 25, 100, 1), -- Karazhan
(300203, 400002, 565, 0, 62.7842, 35.462, -3.9835, 1.41844, 0, 0, 0.651242, 0.75887, 25, 25, 100, 1), -- Gruul's Lair
(300204, 400002, 544, 0, 187.843, 35.9232, 67.9252, 4.79879, 0, 0, 0.675909, -0.736985, 25, 25, 100, 1), -- Magtheridon's Lair
(300205, 400002, 548, 0, 2.5343, -0.022318, 821.727, 0.004512, 0, 0, 0.002256, 0.999997, 25, 25, 100, 1), -- Serpentshrine Cavern
(300206, 400002, 550, 0, -10.8021, -1.15045, -2.42833, 6.22821, 0, 0, 0.0274842, -0.999622, 25, 25, 100, 1), -- The Eye
(300207, 400002, 534, 0, 4252.72, -4226.16, 868.222, 2.35619, 0, 0, 0.923879, 0.382686, 25, 25, 100, 1), -- Hyjal Summit
(300208, 400002, 564, 0, 96.4462, 1002.35, -86.9984, 6.15675, 0, 0, 0.0631755, -0.998002, 25, 25, 100, 1), -- Black Temple
(300209, 400002, 568, 0, 120.7, 1776, 43.455, 4.7713, 0, 0, 0.685975, -0.727625, 25, 25, 100, 1), -- Zul'Aman
-- Quel'thalas Portal Back to PTR Base
(300210, 400002, 0, 0, 4306.02, -2758.27, 16.6246, 3.65715, 0, 0, 0.966958, -0.254935, 25, 25, 100, 1),
-- Dueling Area Portal
(300211, 400002, 530, 0, -1972.12, 5107.44, 7.5194, 4.3598, 0, 0, 0.820162, -0.572132, 25, 25, 100, 1);
DELETE FROM gossip_menu WHERE entry IN (50000,50100,50200,50300,50201,50202,50203,50204,50205);
INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES
-- Primary Gossip
('50000','50000','0','0'), -- RAID NPC
('50100','50100','0','0'), -- DUNGEON NPC
('50200','50200','0','0'), -- START ZONE GREETERS
('50300','50300','0','0'), -- CAPTIAL CITY GREETERS
-- Secondary Gossips
('50201','50201','0','0'),
('50202','50202','0','0'),
('50203','50203','0','0'),
('50204','50204','0','0'),
('50205','50205','0','0');
DELETE FROM gossip_menu_option WHERE menu_id IN (50200,50300);
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`, `condition_id`) VALUES
-- START ZONE GREETERS
('50200','1','0','Contact Us','100','1','50205','0','0','0','0',NULL,'0'),
('50200','2','7','What is Light''s Vengeance?','101','1','50201','0','0','0','0',NULL,'0'),
('50200','3','6','Donating to Light''s Vengeance','102','1','50202','0','0','0','0',NULL,'0'),
('50200','4','4','Reporting Game Problems or Bugs','103','1','50203','0','0','0','0',NULL,'0'),
('50200','5','8','Cheating Policy','104','1','50204','0','0','0','0',NULL,'0'),
-- CAPTIAL CITY GREETERS
('50300','1','0','Contact Us','1','1','50205','0','0','0','0',NULL,'0'),
('50300','2','7','What Is Light''s Vengeance?','1','1','50201','0','0','0','0',NULL,'0'),
('50300','3','6','Donating to Light''s Vengeance','1','1','50202','0','0','0','0',NULL,'0'),
('50300','4','4','Reporting Game Problems or Bugs','1','1','50203','0','0','0','0',NULL,'0'),
('50300','5','8','Cheating Policy','1','1','50204','0','0','0','0',NULL,'0');
DELETE FROM npc_text WHERE id IN (50000,50100,50200,50300,50201,50202,50203,50204,50205);
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) VALUES
-- Primary Gossip Texts
('50000','I am a Light''s Vengeance Raid Messenger.$B$BI have been sent here to advise all travellers that there has been a catastrophic series of events inside this raid. Due to the eminent danger from the creatures lurking on the other side of this portal we have magically sealed it for the safety and security of Azeroth.$B$BEvery effort is being made to contain the situation and we will advise you when the portal is opened again.$B$BThank you for your understanding!','','0','1','0','274','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50100','I am a Light''s Vengeance Dungeon Messenger.$B$BI have been sent here to advise all travellers that the safety of Azeroth is in jeopardy! We have magically sealed this dungeon to protect Azeroth from the creatures within.$B$BEvery effort is being made to resolve the situation and we will advise you when the portal is opened again.$B$BThank you for your understanding!','','0','1','0','274','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50200','Welcome, $N!$B$BI am stationed here to help adventurers like you get started on the realm. The staff hopes you enjoy your stay on Light''s Vengeance and looks forward to crossing paths with you on your journey. How may I assist you?','','0','1','0','3','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50300','Greetings, $N!$B$BI am an emissary from Light''s Vengeance. I provide information to assist travellers on their adventures. How may I help you?','','0','1','0','3','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
-- Secondary Gossip texts
('50201','Light''s Vengeance is a community of nostalgic/oldschool WoW enthusiasts. We strive to provide a safe and friendly environment for all of our players to enjoy.$B$BOur realms are under continual development as we work on improving the game and providing the very best experience possible to our players. We are a highly dedicated team that has been working on WoW emulation since early in the game''s history.$B$BOur website is located at:$B$B|cFF0008E8www.lightsvengeance.com|r$B$B','','0','1','0','1','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
-- ('50202','Thank you for your interest in donating!$B$BAt this point, we are not accepting donations as server operation costs are already covered for the foreseeable future.$B$BRegardless of the status of donations, we will ALWAYS be a free-to-play server with absolutely zero "pay-to-win" elements.','','0','1','0','66','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50202','Thank you for your interest in donating!$B$Bhttps://www.paypal.me/vengeancewow$B$BYour contributions help cover hosting costs of our website and game server.$B$BRegardless of the status of donations, we will ALWAYS be a free-to-play server with absolutely zero "pay-to-win" elements.','','0','1','0','66','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50203','|cFF0008E8Reporting Game Problems or Bugs|r$B$BWe have a bug tracker system available for members. You can find a link on our website, or you can use:$B$B|cFF0008E8gitlab.com/lights-vengeance/issues/issues|r$B$BIf you require immediate in-game support, feel free to contact staff on Discord to discuss the issue. We will do our best to help you as soon as possible (it may take us 15-20 minutes to respond if we are AFK).','','0','1','0','1','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50204','|cFF0008E8Light''s Vengeance Cheating Policy|r$B$BLight''s Vengeance has a zero-tolerance policy for cheating, and is equipped with an active anti-cheat detection system. $B$BWe aim to create an equal opportunity, respectful, and enjoyable environment for all of our players. In return, we expect players to uphold a certain level of integrity.$B$BIf you suspect another player of cheating, we request that you report the incident to the development team on Discord.$B$B','','0','1','0','1','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50205','|cFF0008E8Contact Us|r$B$BWe have an official Discord channel that is the center of our community outside of the forums:$B$B|cFF0008E8https://discord.gg/6RZmRFA|r$B$BYou can communicate there with the staff and other players. This is the fastest way to reach a staff member if you have any questions or concerns.$B$BWe look forward to meeting you, and wish you luck on your journey through Light''s Vengeance!','','0','1','0','1','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0');
-- clear out existing vendor list of npc 26302 "Enchantments Vendor" - will use npc_enchantment_crystal script instead
DELETE FROM npc_vendor WHERE entry=26302;
UPDATE creature_template SET `Name`='Enchantments', NpcFlags=1 WHERE Entry=26302;
-- General Goods Vendor 26304
UPDATE creature_template SET `SubName`='Reagents & Consumables', VendorTemplateId=26304 WHERE Entry=26304;
DELETE FROM npc_vendor WHERE entry=26304;
DELETE FROM npc_vendor_template WHERE entry=26304;
INSERT INTO npc_vendor_template (entry, item, maxcount, incrtime, ExtendedCost, condition_id, comments) VALUES
-- All classes
('26304', '22829', '0', '0', '0', '0', 'Super Healing Potion'),
('26304', '21991', '0', '0', '0', '0', 'Heavy Netherweave Bandage'),
('26304', '29451', '0', '0', '0', '0', 'Clefthoof Ribs'),
('26304', '29449', '0', '0', '0', '0', 'Bladespire Bagel'),
('26304', '29450', '0', '0', '0', '0', 'Telaari Grapes'),
-- Mana users
('26304', '32453', '0', '0', '0', '15033', 'Star\'s Tears'),
('26304', '22832', '0', '0', '0', '15033', 'Super Mana Potion'),
-- Ranged users
('26304', '34581', '0', '0', '0', '15048', 'Mysterious Arrow'),
('26304', '34582', '0', '0', '0', '15048', 'Mysterious Shell'),
-- Priest/Mage
('26304', '17056', '0', '0', '0', '16000', 'Light Feather'),
-- Druid
('26304', '22147', '0', '0', '0', '21', 'Flintweed Seed'),
('26304', '22148', '0', '0', '0', '21', 'Wild Quillvine'),
-- Paladin
('26304', '21177', '0', '0', '0', '14', 'Symbol of Kings'),
('26304', '17033', '0', '0', '0', '14', 'Symbol of Divinity'),
-- Mage
('26304', '17020', '0', '0', '0', '18', 'Arcane Powder'),
('26304', '17031', '0', '0', '0', '18', 'Rune of Teleportation'),
('26304', '17032', '0', '0', '0', '18', 'Rune of Portals'),
-- Shaman
('26304', '17057', '0', '0', '0', '17', 'Shiny Fish Scales'),
('26304', '17058', '0', '0', '0', '17', 'Fish Oil'),
('26304', '17030', '0', '0', '0', '17', 'Ankh'),
-- Warlock
('26304', '5565', '0', '0', '0', '19', 'Infernal Stone'),
('26304', '16583', '0', '0', '0', '19', 'Demonic Figurine'),
('26304', '6265', '0', '0', '0', '19', 'Soul Shard'),
-- Rogue
('26304', '5140', '0', '0', '0', '16', 'Flash Powder'),
('26304', '3776', '0', '0', '0', '16', 'Crippling Poison II'),
('26304', '9186', '0', '0', '0', '16', 'Mind-numbing Poison III'),
('26304', '21927', '0', '0', '0', '16', 'Instant Poison VII'),
('26304', '22054', '0', '0', '0', '16', 'Deadly Poison VII'),
('26304', '22055', '0', '0', '0', '16', 'Wound Poison V'),
-- Priest
('26304', '17028', '0', '0', '0', '112', 'Holy Candle'),
('26304', '17029', '0', '0', '0', '112', 'Sacred Candle');
UPDATE creature_template SET NpcFlags=NpcFlags|1048576 WHERE Entry IN (14623,14879,15972,22516);
UPDATE creature_template SET ModelId1=1122 WHERE Entry=14623;
UPDATE creature_template SET ModelId1=19924 WHERE Entry=14879;
UPDATE creature_template SET ModelId1=10706 WHERE Entry=15972;
UPDATE creature_template SET ModelId1=19936 WHERE Entry=22516;
DELETE FROM battlemaster_entry WHERE entry IN (26007,14623,14879,15972,22516);
INSERT INTO battlemaster_entry (entry, bg_template) VALUES
(26007, 6), -- Arena
(14623, 2), -- Warsong Gulch
(14879, 3), -- Arathi Basin
(15972, 1), -- Alterac Valley
(22516, 7); -- Eye of the Storm
DELETE FROM gossip_menu WHERE entry IN (51000,51001,51002,51003,51004,51005,51100,51200,51201,50400,50500,50600);
INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES
('51000','51000','0','0'), -- Portal Main Menu
('51001','51001','0','0'), -- TBC Dungeons
('51005','51005','0','0'), -- TBC Dungeons (cont.)
('51002','51002','0','0'), -- Classic Dungeons
('51003','51003','0','0'), -- Classic Dungeons (cont.)
('51004','51004','0','0'), -- Cities
('51100','51100','0','0'), -- Raid Portal
('50400','50400','0','0'), -- Enchantment Crystal
('50500','50500','0','0'), -- TBC Raids
('50600','50600','0','0'); -- Classic Raids
DELETE FROM npc_text WHERE id IN (51000,51001,51002,51003,51004,51005,51100,50400,50401,50500,50600);
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) VALUES
('51000','Where would you like to go? (you must be in a raid group to travel to raids or have GM mode turned on)','','0','1','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('51001','TBC Dungeons','','0','1','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('51002','Classic Dungeons','','0','1','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('51003','Classic Dungeons (cont.)','','0','1','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('51004','Cities','','0','1','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('51005','TBC Dungeons (cont.)','','0','1','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('51100','Teleport To Raid (you must be in a raid group)','','0','1','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50400','To begin, select which item you wish to enchant.','','0','1','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50401','Select an enchant for this item:','','0','1','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50500','TBC Raids','','0','1','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50600','Classic Raids','','0','1','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0');
DELETE FROM gossip_menu_option WHERE menu_id IN (51000,51001,51002,51003,51004,51005,50500,50600);
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`, `condition_id`) VALUES
-- Main Menu
('51000','0','9','TBC Dungeons','1','1','51001','0','0','0','0',NULL,'0'),
('51000','1','9','Classic Dungeons','1','1','51002','0','0','0','0',NULL,'0'),
('51000','2','9','TBC Raids','1','1','50500','0','0','0','0',NULL,'0'),
('51000','3','9','Classic Raids','1','1','50600','0','0','0','0',NULL,'0'),
('51000','4','8','Cities','1','1','51004','0','0','0','0',NULL,'0'),
('51000','5','2','PTR Base','1','1','0','0','51200','0','0',NULL,'0'),
('51000','6','2','Dueling Area','1','1','0','0','51201','0','0',NULL,'0'),
-- TBC Dungeons
('51001','0','2','Hellfire Ramparts','1','1','0','0','51019','0','0',NULL,'0'),
('51001','1','2','The Blood Furnace','1','1','0','0','51020','0','0',NULL,'0'),
('51001','2','2','The Shattered Halls','1','1','0','0','51021','0','0',NULL,'0'),
('51001','3','2','The Slave Pens','1','1','0','0','51022','0','0',NULL,'0'),
('51001','4','2','The Underbog','1','1','0','0','51023','0','0',NULL,'0'),
('51001','5','2','The Steamvault','1','1','0','0','51024','0','0',NULL,'0'),
('51001','6','2','Mana-Tombs','1','1','0','0','51025','0','0',NULL,'0'),
('51001','7','4','Page 2 ->','1','1','51005','0','0','0','0',NULL,'0'),
('51001','8','4','Return to Main Menu','1','1','51000','0','0','0','0',NULL,'0'),
-- TBC Dungeons (cont.)
('51005','0','2','Sethekk Halls','1','1','0','0','51026','0','0',NULL,'0'),
('51005','1','2','Auchenai Crypts','1','1','0','0','51027','0','0',NULL,'0'),
('51005','2','2','Shadow Labyrinth','1','1','0','0','51028','0','0',NULL,'0'),
('51005','3','2','Old Hillsbrad Foothills','1','1','0','0','51029','0','0',NULL,'0'),
('51005','4','2','The Black Morass','1','1','0','0','51030','0','0',NULL,'0'),
('51005','5','2','The Mechanar','1','1','0','0','51031','0','0',NULL,'0'),
('51005','6','2','The Botanica','1','1','0','0','51032','0','0',NULL,'0'),
('51005','7','2','The Arcatraz','1','1','0','0','51033','0','0',NULL,'0'),
('51005','8','4','<- Page 1','1','1','51001','0','0','0','0',NULL,'0'),
('51005','9','4','Return to Main Menu','1','1','51000','0','0','0','0',NULL,'0'),
-- Classic Dungeons
('51002','11','4','Return to Main Menu','1','1','51000','0','0','0','0',NULL,'0'),
('51002','10','4','Page 2 ->','1','1','51003','0','0','0','0',NULL,'0'),
('51002','9','2','Razorfen Downs','1','1','0','0','51008','0','0',NULL,'0'),
('51002','8','2','Scarlet Monastery','1','1','0','0','51009','0','0',NULL,'0'),
('51002','7','2','Gnomeregan','1','1','0','0','51010','0','0',NULL,'0'),
('51002','6','2','Razorfen Kraul','1','1','0','0','51011','0','0',NULL,'0'),
('51002','5','2','The Stockade','1','1','0','0','51012','0','0',NULL,'0'),
('51002','4','2','Blackfathom Deeps','1','1','0','0','51013','0','0',NULL,'0'),
('51002','3','2','Shadowfang Keep','1','1','0','0','51014','0','0',NULL,'0'),
('51002','2','2','The Deadmines','1','1','0','0','51015','0','0',NULL,'0'),
('51002','1','2','Wailing Caverns','1','1','0','0','51016','0','0',NULL,'0'),
('51002','0','2','Ragefire Chasm','1','1','0','0','51017','0','0',NULL,'0'),
-- Classic Dungeons (cont.)
('51003','10','4','Return to Main Menu','1','1','51000','0','0','0','0',NULL,'0'),
('51003','9','4','<- Page 1','1','1','51002','0','0','0','0',NULL,'0'),
('51003','8','2','Dire Maul','1','1','0','0','51000','0','0',NULL,'0'),
('51003','7','2','Stratholme','1','1','0','0','51001','0','0',NULL,'0'),
('51003','6','2','Scholomance','1','1','0','0','51002','0','0',NULL,'0'),
('51003','5','2','Lower Blackrock Spire','1','1','0','0','51018','0','0',NULL,'0'),
('51003','4','2','Blackrock Depths','1','1','0','0','51003','0','0',NULL,'0'),
('51003','3','2','Sunken Temple','1','1','0','0','51004','0','0',NULL,'0'),
('51003','2','2','Zul\'Farrak','1','1','0','0','51005','0','0',NULL,'0'),
('51003','1','2','Maraudon','1','1','0','0','51006','0','0',NULL,'0'),
('51003','0','2','Uldaman','1','1','0','0','51007','0','0',NULL,'0'),
-- Cities
('51004','0','2','Stormwind','1','1','0','0','51034','0','0',NULL,'4'),
('51004','1','2','Ironforge','1','1','0','0','51035','0','0',NULL,'4'),
('51004','2','2','Darnassus','1','1','0','0','51036','0','0',NULL,'4'),
('51004','3','2','Exodar','1','1','0','0','51037','0','0',NULL,'4'),
('51004','4','2','Orgrimmar','1','1','0','0','51038','0','0',NULL,'3'),
('51004','5','2','Undercity','1','1','0','0','51039','0','0',NULL,'3'),
('51004','6','2','Thunder Bluff','1','1','0','0','51040','0','0',NULL,'3'),
('51004','7','2','Silvermoon City','1','1','0','0','51041','0','0',NULL,'3'),
('51004','8','4','Return to Main Menu','1','1','51000','0','0','0','0',NULL,'0'),
-- TBC Raids
('50500','0','2','Karazhan','1','1','0','0','51108','0','0',NULL,'0'),
('50500','1','2','Gruul''s Lair','1','1','0','0','51109','0','0',NULL,'0'),
('50500','2','2','Magtheridon''s Lair','1','1','0','0','51110','0','0',NULL,'0'),
('50500','3','2','Serpentshrine Cavern','1','1','0','0','51111','0','0',NULL,'0'),
('50500','4','2','The Eye','1','1','0','0','51112','0','0',NULL,'0'),
('50500','5','2','Hyjal Summit','1','1','0','0','51113','0','0',NULL,'0'),
('50500','6','2','Black Temple','1','1','0','0','51114','0','0',NULL,'0'),
('50500','7','2','Zul''Aman','1','1','0','0','51115','0','0',NULL,'0'),
('50500','8','4','Return to Main Menu','1','1','51000','0','0','0','0',NULL,'0'),
-- Classic Raids
('50600','0','2','Upper Blackrock Spire','1','1','0','0','51100','0','0',NULL,'0'),
('50600','1','2','Molten Core','1','1','0','0','51101','0','0',NULL,'0'),
('50600','2','2','Onyxia\'s Lair','1','1','0','0','51102','0','0',NULL,'0'),
('50600','3','2','Blackwing Lair','1','1','0','0','51103','0','0',NULL,'0'),
('50600','4','2','Zul\'Gurub','1','1','0','0','51104','0','0',NULL,'0'),
('50600','5','2','Ruins of Ahn\'Qiraj','1','1','0','0','51105','0','0',NULL,'0'),
('50600','6','2','Temple of Ahn\'Qiraj','1','1','0','0','51106','0','0',NULL,'0'),
('50600','7','2','Naxxramas','1','1','0','0','51107','0','0',NULL,'0'),
('50600','8','4','Return to Main Menu','1','1','51000','0','0','0','0',NULL,'0');
-- Teleport Scripts For Gossip
DELETE FROM dbscripts_on_gossip WHERE id BETWEEN 51000 AND 51041;
DELETE FROM dbscripts_on_gossip WHERE id BETWEEN 51100 AND 51115;
DELETE FROM dbscripts_on_gossip WHERE id IN (51200,51201);
insert into `dbscripts_on_gossip` (`id`, `delay`, `command`, `datalong`, `datalong2`, `buddy_entry`, `search_radius`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) values
-- Dungeons (Classic)
('51000','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51000','1000','6','1','0','0','0','0','0','0','0','0','-3528.903','1125.048','161.02308','3.1416','Portal: Dire Maul'),
('51001','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51001','1000','6','329','0','0','0','0','0','0','0','0','3395.09','-3380.25','142.702','0.1','Portal: Stratholme'),
('51002','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51002','1000','6','289','0','0','0','0','0','0','0','0','199.4204','123.858','134.9103','4.76032','Portal: Scholomance'),
('51018','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51018','1000','6','229','0','0','0','0','0','0','0','0','78.8333','-238.0234','54.6281','4.745','Portal: Lower Blackrock Spire'),
('51003','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51003','1000','6','230','0','0','0','0','0','0','0','0','458.32','26.52','-70.67346','4.95','Portal: Blackrock Depths'),
('51004','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51004','1000','6','109','0','0','0','0','0','0','0','0','-319.24','99.9','-131.8501','3.19','Portal: Sunken Temple'),
('51005','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51005','1000','6','209','0','0','0','0','0','0','0','0','1222.613','841.325','9.01058','6.2','Portal: Zul\'Farrak'),
('51006','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51006','1000','6','349','0','0','0','0','0','0','0','0','751.79','-602.024','-33.2435','6.25698','Portal: Maraudon'),
('51007','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51007','1000','6','70','0','0','0','0','0','0','0','0','-227.188','58.49','-46.0383','1.49839','Portal: Uldaman'),
('51008','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51008','1000','6','129','0','0','0','0','0','0','0','0','2592.711','1094.69','52.64732','4.81304','Portal: Razorfen Downs'),
('51009','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51009','1000','6','0','0','0','0','0','0','0','0','0','2844.341','-695.083','139.32993','5.06599','Portal: Scarlet Monastery'),
('51010','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51010','1000','6','90','0','0','0','0','0','0','0','0','-339.867','1.035','-152.8455','2.89488','Portal: Gnomeragen'),
('51011','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51011','1000','6','47','0','0','0','0','0','0','0','0','1944.7256','1552.7025','81.85492','1.24413','Portal: Razorfen Kraul'),
('51012','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51012','1000','6','47','0','0','0','0','0','0','0','0','57.215','0.691','-19.4861','6.26','Portal: The Stockades'),
('51013','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51013','1000','6','48','0','0','0','0','0','0','0','0','-155.268','91.362','-43.5681','4.27396','Portal: Blackfathom Deeps'),
('51014','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51014','1000','6','33','0','0','0','0','0','0','0','0','-222.864','2125.124','80.43445','1.41152','Portal: Shadowfang Keep'),
('51015','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51015','1000','6','36','0','0','0','0','0','0','0','0','-20.677','-377.139','60.83653','2.70823','Portal: The Deadmines'),
('51016','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51016','1000','6','43','0','0','0','0','0','0','0','0','-157.87','131.442','-74.3203','5.97608','Portal: Wailing Caverns'),
('51017','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51017','1000','6','389','0','0','0','0','0','0','0','0','-0.1478','-24.0','-20.5947','4.23292','Portal: Ragefire Chasm'),
-- Dungeons (TBC)
(51019, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51019, 1000, 6, 543, 0, 0, 0, 0, 0, 0, 0, 0, -1355.24, 1641.12, 68.2491, 1.12531, 'Portal: Hellfire Ramparts'),
(51020, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51020, 1000, 6, 542, 0, 0, 0, 0, 0, 0, 0, 0, -3.9967, 14.6363, -44.8009, 4.88748, 'Portal: Blood Furnace'),
(51021, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51021, 1000, 6, 540, 0, 0, 0, 0, 0, 0, 0, 0, -40.8716, -19.7538, -13.8065, 1.11133, 'Portal: Shattered Halls'),
(51022, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51022, 1000, 6, 547, 0, 0, 0, 0, 0, 0, 0, 0, 120.101, -131.957, -0.801547, 1.47574, 'Portal: Slave Pens'),
(51023, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51023, 1000, 6, 546, 0, 0, 0, 0, 0, 0, 0, 0, 9.71391, -16.2008, -2.75334, 5.57082, 'Portal: Underbog'),
(51024, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51024, 1000, 6, 545, 0, 0, 0, 0, 0, 0, 0, 0, -13.8425, 6.7542, -4.2586, 0, 'Portal: Steamvault'),
(51025, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51025, 1000, 6, 557, 0, 0, 0, 0, 0, 0, 0, 0, 0.0191, 0.9478, -0.9543, 3.03164, 'Portal: Mana Tombs'),
(51026, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51026, 1000, 6, 556, 0, 0, 0, 0, 0, 0, 0, 0, -4.6811, -0.0930796, 0.0062, 0.0353424, 'Portal: Sethekk Halls'),
(51027, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51027, 1000, 6, 558, 0, 0, 0, 0, 0, 0, 0, 0, -21.8975, 0.16, -0.1206, 0.0353412, 'Portal: Auchenai Crypts'),
(51028, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51028, 1000, 6, 555, 0, 0, 0, 0, 0, 0, 0, 0, 0.488033, -0.215935, -1.12788, 3.15888, 'Portal: Shadow Labyrinth'),
(51029, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51029, 1000, 6, 560, 0, 0, 0, 0, 0, 0, 0, 0, 2741.68, 1312.64, 14.0413, 2.79253, 'Portal: Old Hillsbrad Foothills'),
(51030, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51030, 1000, 6, 269, 0, 0, 0, 0, 0, 0, 0, 0, -1491.61, 7056.51, 32.1011, 1.74533, 'Portal: Black Morass'),
(51031, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51031, 1000, 6, 554, 0, 0, 0, 0, 0, 0, 0, 0, -28.906, 0.680314, -1.81282, 0.0345509, 'Portal: The Mechanar'),
(51032, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51032, 1000, 6, 553, 0, 0, 0, 0, 0, 0, 0, 0, 40.0395, -28.613, -1.1189, 2.35856, 'Portal: The Botanica'),
(51033, 0, 15, 26638, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast Teleport Visual'),
(51033, 1000, 6, 552, 0, 0, 0, 0, 0, 0, 0, 0, -1.23165, 0.0143459, -0.204293, 0.0157123, 'Portal: The Arcatraz'),
-- Cities
('51034','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51034','1000','6','0','0','0','0','0','0','0','0','0',-8852.23,639.835,96.3843,0.958539,'Portal: Stormwind'),
('51035','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51035','1000','6','0','0','0','0','0','0','0','0','0',-4895.91,-962.374,501.448,3.02565,'Portal: Ironforge'),
('51036','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51036','1000','6','1','0','0','0','0','0','0','0','0',9941.17,2500.68,1317.96,4.15784,'Portal: Darnassus'),
('51037','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51037','1000','6','530','0','0','0','0','0','0','0','0',-3905.68,-11610,-138.054,3.82175,'Portal: Exodar'),
('51038','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51038','1000','6','1','0','0','0','0','0','0','0','0',1588.4,-4394.55,6.46053,4.92048,'Portal: Orgrimmar'),
('51039','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51039','1000','6','0','0','0','0','0','0','0','0','0',1563.83,263.1,-43.1027,5.59063,'Portal: Undercity'),
('51040','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51040','1000','6','1','0','0','0','0','0','0','0','0',-1265.43,49.056,127.614,0.284943,'Portal: Thunder Bluff'),
('51041','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51041','1000','6','530','0','0','0','0','0','0','0','0',9513.37,-7300.74,14.4663,3.22001,'Portal: Silvermoon City'),
-- Raids (Classic)
('51100','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51100','1000','6','229','0','0','0','0','0','0','0','0','131.8227','-319.4949','70.95558','6.21762','Portal: Upper Blackrock Spire'),
('51101','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51101','1000','6','409','0','0','0','0','0','0','0','0','1069.607','-487.516','-108.41582','5.4747','Portal: Molten Core'),
('51102','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51102','1000','6','249','0','0','0','0','0','0','0','0','29.598','-66.9944','-6.25016','4.74729','Portal: Onyxia Lair'),
('51103','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51103','1000','6','469','0','0','0','0','0','0','0','0','-7665.2319','-1101.9293','-399.67914','0.50152','Portal: Blackwing Lair'),
('51104','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51104','1000','6','309','0','0','0','0','0','0','0','0','-11916.952','-1240.7623','92.53341','4.59694','Portal: Zul\'Gurub'),
('51105','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51105','1000','6','509','0','0','0','0','0','0','0','0',-8436.53,1519.17,31.907,2.61799,'Portal: Ruins of Ahn\'Qiraj (AQ20)'),
('51106','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51106','1000','6','531','0','0','0','0','0','0','0','0',-8221.35,2014.34,129.071,0.872665,'Portal: Temple of Ahn\'Qiraj (AQ40)'),
('51107','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51107','1000','6','533','0','0','0','0','0','0','0','0',3005.87,-3435.01,293.882,0,'Portal: Naxxramas'),
-- Raids (TBC)
('51108','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51108','1000','6','532','0','0','0','0','0','0','0','0',-11101.8,-1998.31,49.8927,0.690367,'Portal: Karazhan'),
('51109','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51109','1000','6','565','0','0','0','0','0','0','0','0',62.7842,35.462,-3.9835,1.41844,'Portal: Gruul''s Lair'),
('51110','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51110','1000','6','544','0','0','0','0','0','0','0','0',187.843,35.9232,67.9252,4.79879,'Portal: Magtheridon''s Lair'),
('51111','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51111','1000','6','548','0','0','0','0','0','0','0','0',2.5343,-0.022318,821.727,0.004512,'Portal: Serpentshrine Cavern'),
('51112','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51112','1000','6','550','0','0','0','0','0','0','0','0',-10.8021,-1.15045,-2.42833,6.22821,'Portal: The Eye'),
('51113','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51113','1000','6','534','0','0','0','0','0','0','0','0',4252.72,-4226.16,868.222,2.35619,'Portal: Hyjal Summit'),
('51114','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51114','1000','6','564','0','0','0','0','0','0','0','0',96.4462,1002.35,-86.9984,6.15675,'Portal: Black Temple'),
('51115','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51115','1000','6','568','0','0','0','0','0','0','0','0',120.7,1776,43.455,4.7713,'Portal: Zul''Aman'),
-- PTR Base
('51200','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51200','1000','6','530','0','0','0','0','0','0','0','0','-1987.3786','5076.37','7.383377','1.179839','Portal: PTR Base'),
-- Dueling Area
('51201','0','15','26638','0','0','0','4','0','0','0','0','0','0','0','0','Cast Teleport Visual'),
('51201','1000','6','0','0','0','0','0','0','0','0','0','4271.622','-2778.375','5.554479','0.539123','Portal: Dueling Area');
DELETE FROM npc_text WHERE id IN (50407,50408,50409,50410,50411,50412,50413,50414);
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) VALUES
('50407','Greetings, $C.$B$BIs there anything I can assist you with?','','0','1','0','1','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50408','You''re too low level for me to help you much, $N. Talk to the Test Realm Overlord to get boosted.','','0','1','0','1','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50409','I have just what you need, $C. Which specialization should I equip you for?','','0','1','0','1','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50410','To view some statistics regarding your damage done, /wave to the dummy after you leave combat!','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50411','Choose the modifier for your PRIMARY gear. This includes slots:$B$BHead$BShoulders$BChest$BHands$BLegs','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50412','Choose the modifier for your SECONDARY gear. This includes slots:$B$BBack$BRings$BNeck$BWrist$BWaist$BBoots','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50413','Choose the modifier for your TERTIARY gear. This includes slots:$B$BWeapons$BRanged','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0'),
('50414','Hi there, $N. Make your choice...','','0','1','0','1','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0');
DELETE FROM conditions WHERE condition_entry IN (15034,15035,16000);
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `flags`) VALUES
('15034','-1','513','19','0'), -- Level 70 Warlock
('15035','2','21967','1','1'), -- Does not have 1 Magic Talent Switch Gemstone
(16000, 14, 0, 144, 0); -- Player ClassMask: 144 (Mage + Priest)
DELETE FROM gossip_menu WHERE entry IN (50404,50409,50411,50412,50413,50414);
INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES
-- Training Dummy Information
('50404','50410','0','0'),
-- Master Provisioner
('50409','50409','0','0'),
('50411','50411','0','0'),
('50412','50412','0','0'),
('50413','50413','0','0'),
-- Test Realm Overlord
('50414','50414','0','0');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment