API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2017
66
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 30.09 KB | None | 0 0
raw download clone embed print report
  1. /* ======================= */
  2. /* ===== Soulreaver ====== */
  3. /* ======================= */
  4.  
  5. DELETE FROM gameobject_template WHERE entry IN (900002, 900003);
  6. INSERT INTO gameobject_template
  7.     (entry, type, displayId, name, IconName, castBarCaption, unk1, faction, flags, size, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, data0, data1, data2, data3, data4, data5, data6, data7, data8, data9, data10, data11, data12, data13, data14, data15, data16, data17, data18, data19, data20, data21, data22, data23, ScriptName, WDBVerified)
  8. VALUES
  9.     (900002, 33, 8387, 'Pfad der Ewigkeit', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 8387, 0, -1, 0, 0, 0, 8386, 1, 0, 0, 0, 0, 0, 0, 50, 0, 0, 0, 0, 1, '', 12340),
  10.     (900003, 0, 8550, 'Der ewige Kosmos', '', '', '', 1375, 32, 1, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 12340);
  11.  
  12. DELETE FROM gameobject WHERE id IN (900002, 900003);
  13. INSERT INTO gameobject
  14.     (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state)
  15. VALUES
  16.     (1478930, 900003, 37, 1, 1, 123.631, 71.0359, 1098.48, 5.10653, 0, 0, 0.554972, -0.831869, 300, 0, 1),
  17.     (1478929, 900002, 37, 1, 1, 124.329, 71.1292, 1088.55, 5.11831, 0, 0, 0.55006, -0.835125, 300, 255, 1);
  18.  
  19. DELETE FROM game_event_gameobject WHERE event = 1000;
  20. INSERT INTO game_event_gameobject
  21.     (guid, event)
  22. VALUES
  23.     (1478929, 1000),
  24.     (1478930, 1000),
  25.     (1478954, 1000);
  26.  
  27. DELETE FROM game_event_creature WHERE event = 1001;
  28. INSERT INTO game_event_creature
  29.     (guid, event)
  30. VALUES
  31.     (212694, 1001),
  32.     (212734, 1001),
  33.     (212741, 1001),
  34.     (212765, 1001);
  35.  
  36. DELETE FROM creature WHERE id IN (900011, 900012, 900013, 900014, 900015);
  37. INSERT INTO creature
  38.     (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
  39. VALUES
  40.     (212734, 900011, 37, 1, 1, 0, 0, 130.789, 53.9256, 1098.48, 1.96102, 300, 0, 0, 27814512, 0, 0, 0),
  41.     (212741, 900012, 37, 1, 1, 0, 0, 144.791, 63.5579, 1098.48, 2.74641, 300, 0, 0, 24718848, 0, 0, 0),
  42.     (212765, 900013, 37, 1, 1, 0, 0, 114.651, 49.8039, 1098.48, 1.10782, 300, 0, 0, 21814848, 0, 0, 0),
  43.     (212694, 900014, 37, 1, 1, 0, 0, 136.67, 39.906, 1099.54, 1.95315, 300, 0, 0, 7277424, 0, 0, 0),
  44.     (213068, 900015, 0, 1, 1, 0, 0, -13250.5, 214.778, 30.829, 4.65141, 300, 0, 0, 8955936, 0, 0, 0);
  45.  
  46. DELETE FROM creature_template WHERE entry IN (900008, 900009, 900010, 900011, 900012, 900013, 900014, 900015);
  47. INSERT INTO creature_template
  48.     (entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName, WDBVerified)
  49. VALUES
  50.     (900008, 0, 0, 0, 0, 0, 31005, 0, 0, 0, 'Mucopyocele', NULL, NULL, 0, 83, 83, 0, 14, 14, 0, 1, 1.14286, 1, 3, 44850, 65200, 0, 805, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 8750, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 617299967, 0, '', 1),
  51.     (900009, 0, 0, 0, 0, 0, 30790, 0, 0, 0, 'Doomguard Bloodvein', NULL, NULL, 0, 83, 83, 0, 14, 14, 0, 1, 1.14286, 1, 3, 54200, 78633, 0, 805, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 7263, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 10136, 617299967, 0, '', 1),
  52.     (900010, 0, 0, 0, 0, 0, 18239, 0, 0, 0, 'High Sorceress Devilia', NULL, NULL, 0, 83, 83, 0, 14, 14, 0, 1, 1.14286, 1, 3, 29300, 37896, 0, 805, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 7936, 485, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 617299967, 0, '', 1),
  53.     (900011, 0, 0, 0, 0, 0, 21483, 0, 0, 0, 'Essence of Suffering', NULL, NULL, 0, 83, 83, 0, 14, 14, 0, 1, 1.14286, 1, 3, 45698, 69852, 0, 805, 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, 3, 4789, 452, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 617299967, 0, '', 1),
  54.     (900012, 0, 0, 0, 0, 0, 21485, 0, 0, 0, 'Essence of Desire', NULL, NULL, 0, 83, 83, 0, 14, 14, 0, 1, 1.14286, 1, 3, 45698, 69852, 0, 805, 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, 3, 4256, 452, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 617299967, 0, '', 1),
  55.     (900013, 0, 0, 0, 0, 0, 21484, 0, 0, 0, 'Essence of Anger', NULL, NULL, 0, 83, 83, 0, 14, 14, 0, 1, 1.14286, 1, 3, 45698, 69852, 0, 805, 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, 3, 3756, 452, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 617299967, 0, '', 1),
  56.     (900014, 0, 0, 0, 0, 0, 21146, 0, 0, 0, 'Reliquary of the Lost', NULL, NULL, 0, 83, 83, 0, 14, 14, 0, 1, 1.14286, 1, 1, 12500, 21630, 0, 0, 1, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1253, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 617299967, 0, '', 1),
  57.     (900015, 0, 0, 0, 0, 0, 14560, 0, 0, 0, 'Shard of the Lost', NULL, NULL, 0, 83, 83, 0, 35, 35, 2, 1, 1.14286, 1, 3, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1542, 1542, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 1);
  58.    
  59. DELETE FROM quest_template WHERE entry = 900009;
  60. INSERT INTO quest_template
  61.     (entry, Method, ZoneOrSort, SkillOrClassMask, MinLevel, MaxLevel, QuestLevel, Type, RequiredRaces, RequiredSkillValue, RepObjectiveFaction, RepObjectiveValue, RepObjectiveFaction2, RepObjectiveValue2, RequiredMinRepFaction, RequiredMinRepValue, RequiredMaxRepFaction, RequiredMaxRepValue, SuggestedPlayers, LimitTime, QuestFlags, SpecialFlags, CharTitleId, PlayersSlain, BonusTalents, RewardArenaPoints, PrevQuestId, NextQuestId, ExclusiveGroup, NextQuestInChain, RewXPId, SrcItemId, SrcItemCount, SrcSpell, Title, Details, Objectives, OfferRewardText, RequestItemsText, EndText, CompletedText, ObjectiveText1, ObjectiveText2, ObjectiveText3, ObjectiveText4, ReqItemId1, ReqItemId2, ReqItemId3, ReqItemId4, ReqItemId5, ReqItemId6, ReqItemCount1, ReqItemCount2, ReqItemCount3, ReqItemCount4, ReqItemCount5, ReqItemCount6, ReqSourceId1, ReqSourceId2, ReqSourceId3, ReqSourceId4, ReqSourceCount1, ReqSourceCount2, ReqSourceCount3, ReqSourceCount4, ReqCreatureOrGOId1, ReqCreatureOrGOId2, ReqCreatureOrGOId3, ReqCreatureOrGOId4, ReqCreatureOrGOCount1, ReqCreatureOrGOCount2, ReqCreatureOrGOCount3, ReqCreatureOrGOCount4, ReqSpellCast1, ReqSpellCast2, ReqSpellCast3, ReqSpellCast4, RewChoiceItemId1, RewChoiceItemId2, RewChoiceItemId3, RewChoiceItemId4, RewChoiceItemId5, RewChoiceItemId6, RewChoiceItemCount1, RewChoiceItemCount2, RewChoiceItemCount3, RewChoiceItemCount4, RewChoiceItemCount5, RewChoiceItemCount6, RewItemId1, RewItemId2, RewItemId3, RewItemId4, RewItemCount1, RewItemCount2, RewItemCount3, RewItemCount4, RewRepFaction1, RewRepFaction2, RewRepFaction3, RewRepFaction4, RewRepFaction5, RewRepValueId1, RewRepValueId2, RewRepValueId3, RewRepValueId4, RewRepValueId5, RewRepValue1, RewRepValue2, RewRepValue3, RewRepValue4, RewRepValue5, RewHonorAddition, RewHonorMultiplier, unk0, RewOrReqMoney, RewMoneyMaxLevel, RewSpell, RewSpellCast, RewMailTemplateId, RewMailDelaySecs, PointMapId, PointX, PointY, PointOpt, DetailsEmote1, DetailsEmote2, DetailsEmote3, DetailsEmote4, DetailsEmoteDelay1, DetailsEmoteDelay2, DetailsEmoteDelay3, DetailsEmoteDelay4, IncompleteEmote, CompleteEmote, OfferRewardEmote1, OfferRewardEmote2, OfferRewardEmote3, OfferRewardEmote4, OfferRewardEmoteDelay1, OfferRewardEmoteDelay2, OfferRewardEmoteDelay3, OfferRewardEmoteDelay4, StartScript, CompleteScript, WDBVerified)
  62. VALUES
  63.     (900009, 2, 0, 0, 80, 80, 80, 82, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, 0, 4096, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Soulreaver', '<A cold whisper sorrounds you>', 'Release the Reliquary of the Lost from their never ending misery', NULL, NULL, NULL, 'I\'m released! ', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 900011, 900012, 900013, 900014, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 54811, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 1);
  64.  
  65. DELETE FROM creature_questrelation WHERE id = 900015;
  66. INSERT INTO creature_questrelation
  67.     (id, quest)
  68. VALUES
  69.     (900015, 900009);
  70.  
  71. DELETE FROM creature_involvedrelation WHERE id = 900015;
  72. INSERT INTO creature_involvedrelation
  73.     (id, quest)
  74. VALUES
  75.     (900015, 900009);
  76.  
  77. DELETE FROM game_event WHERE entry IN (1000, 1001);
  78. INSERT INTO game_event
  79.     (entry, start_time, end_time, occurence, length, holiday, description, world_event)
  80. VALUES
  81.     (1000, '0000-0-0 00:00:00', '0000-0-0 00:00:00', 5184000, 2592000, 0, 'Pfad der Ewigkeit', 0),
  82.     (1001, '0000-0-0 00:00:00', '0000-0-0 00:00:00', 5184000, 2592000, 0, 'Der Ewige Kosmos (Boss)', 0);
  83.  
  84. /* EventAI scripts */
  85. DELETE FROM creature_ai_scripts WHERE creature_id IN (900008,900009,900010,900011,900012,900013,900014);
  86. INSERT INTO creature_ai_scripts
  87.    (id, creature_id, event_type, event_inverse_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4,
  88.     action1_type, action1_param1, action1_param2, action1_param3,
  89.     action2_type, action2_param1, action2_param2, action2_param3,
  90.     action3_type, action3_param1, action3_param2, action3_param3,
  91.     comment)
  92. VALUES
  93.    (9000081, 900008, 0, 0, 100, 7, 12000, 12000, 12000, 12000,
  94.     11, 69674, 4, 0,
  95.     0, 0, 0, 0,
  96.     0, 0, 0, 0,
  97.     'Slime Boss - Cast Mutated Infection'),
  98.    (9000082, 900008, 0, 0, 100, 6, 1000, 1000, 0, 0,
  99.     11, 69776, 0, 0,
  100.     0, 0, 0, 0,
  101.     0, 0, 0, 0,
  102.     'Slime Boss - Cast Sticky Ooze'),
  103.    (9000083, 900008, 0, 0, 100, 7, 30000, 30000, 30000, 30000,
  104.     11, 45855, 0, 0,
  105.     1, -20009, 0, 0,
  106.     0, 0, 0, 0,
  107.     'Slime Boss - Cast Gas Nova'),
  108.    (9000084, 900008, 0, 0, 100, 7, 17000, 17000, 17000, 17000,
  109.     11, 69508, 0, 0,
  110.     0, 0, 0, 0,
  111.     0, 0, 0, 0,
  112.     'Slime Boss - Cast Slime Spray'),
  113.    (9000085, 900008, 0, 0, 100, 7, 60000, 60000, 60000, 60000,
  114.     1, -20010, 0, 0,
  115.     0, 0, 0, 0,
  116.     0, 0, 0, 0,
  117.     'Slime Boss - Yell'),
  118.  
  119.    (9000091, 900009, 0, 0, 100, 7, 35000, 35000, 35000, 35000,
  120.     11, 55948, 0, 0,
  121.     1, -20011, 0, 0,
  122.     0, 0, 0, 0,
  123.     'Event Boss - Growth'),
  124.    (9000092, 900009, 0, 0, 100, 7, 46000, 46000, 46000, 46000,
  125.     11, 72769, 0, 0,
  126.     1, -20012, 0, 0,
  127.     0, 0, 0, 0,
  128.     'Event Boss - Bloodsmell'),
  129.    (9000093, 900009, 0, 0, 100, 7, 20000, 20000, 20000, 20000,
  130.     11, 42005, 0, 0,
  131.     0, 0, 0, 0,
  132.     0, 0, 0, 0,
  133.     'Event Boss - Bloodboil'),
  134.    (9000094, 900009, 0, 0, 100, 7, 30000, 30000, 30000, 30000,
  135.     11, 31347, 5, 0,
  136.     1, -20013, 0, 0,
  137.     0, 0, 0, 0,
  138.     'Event Boss - Doom'),
  139.    (9000095, 900009, 0, 0, 100, 7, 60000, 60000, 60000, 60000,
  140.     11, 40823, 0, 0,
  141.     0, 0, 0, 0,
  142.     0, 0, 0, 0,
  143.     'Event Boss - Yell cast'),
  144.    (9000096, 900009, 0, 0, 100, 6, 480000, 480000, 0, 0,
  145.     11, 48017, 0, 0,
  146.     0, 0, 0, 0,
  147.     0, 0, 0, 0,
  148.     'Event Boss - Enrage'),
  149.    (9000097, 900009, 0, 0, 100, 7, 50000, 50000, 50000, 50000,
  150.     11, 72737, 0, 0,
  151.     0, 0, 0, 0,
  152.     0, 0, 0, 0,
  153.     'Event Boss - Frenzy'),
  154.  
  155.    (9000101, 900010, 0, 0, 100, 7, 11000, 11000, 11000, 11000,
  156.     11, 57459, 0, 0,
  157.     0, 0, 0, 0,
  158.     0, 0, 0, 0,
  159.     'Event Boss - Arcane Storm'),
  160.    (9000102, 900010, 0, 0, 100, 7, 61000, 61000, 61000, 61000,
  161.     11, 56505, 4, 0,
  162.     1, -20014, 0, 0,
  163.     0, 0, 0, 0,
  164.     'Event Boss - Surge of Power'),
  165.    (9000103, 900010, 0, 0, 100, 7, 10000, 10000, 10000, 10000,
  166.     11, 38280, 4, 0,
  167.     0, 0, 0, 0,
  168.     0, 0, 0, 0,
  169.     'Event Boss - Static Charge'),
  170.    (9000104, 900010, 0, 0, 100, 7, 30000, 30000, 30000, 30000,
  171.     11, 38592, 0, 0,
  172.     1, -20015, 0, 0,
  173.     0, 0, 0, 0,
  174.     'Event Boss - Spellreflection'),
  175.    (9000105, 900010, 2, 0, 100, 6, 10, 1, 0, 0,
  176.     11, 61887, 0, 0,
  177.     1, -20016, 0, 0,
  178.     0, 0, 0, 0,
  179.     'Event Boss - Lightning'),
  180.    (9000106, 900010, 0, 0, 100, 7, 18000, 18000, 18000, 18000,
  181.     11, 22356, 4, 0,
  182.     0, 0, 0, 0,
  183.     0, 0, 0, 0,
  184.     'Event Boss - Slow'),
  185.    (9000107, 900010, 0, 0, 100, 6, 600000, 600000, 0, 0,
  186.     11, 48017, 0, 0,
  187.     0, 0, 0, 0,
  188.     0, 0, 0, 0,
  189.     'Event Boss - Enrage'),
  190.    (9000108, 900010, 2, 0, 100, 7, 10, 0, 1, 1,
  191.     11, 70127, 0, 0,
  192.     0, 0, 0, 0,
  193.     0, 0, 0, 0,
  194.     'Event Boss - Mytic buffet'),
  195.  
  196.    (9000111, 900011, 0, 0, 100, 7, 30000, 30000, 30000, 30000,
  197.     11, 41305, 0, 0,
  198.     0, 0, 0, 0,
  199.     0, 0, 0, 0,
  200.     'Event Essence of Suffering - Frenzy'),
  201.    (9000112, 900011, 0, 0, 100, 6, 1000, 1000, 0, 0,
  202.     11, 41292, 0, 0,
  203.     0, 0, 0, 0,
  204.     0, 0, 0, 0,
  205.     'Event Essence of Suffering - Aura of Despair'),
  206.    (9000113, 900011, 0, 0, 100, 7, 60000, 60000, 60000, 60000,
  207.     11, 41303, 0, 0,
  208.     0, 0, 0, 0,
  209.     0, 0, 0, 0,
  210.     'Event Essence of Suffering - Drain Soul'),
  211.    (9000114, 900011, 0, 0, 100, 7, 30000, 30000, 30000, 30000,
  212.     1, -20017, 0, 0,
  213.     0, 0, 0, 0,
  214.     0, 0, 0, 0,
  215.     'Event Essence of Suffering - Yell'),
  216.  
  217.    (9000121, 900012, 0, 0, 100, 7, 20000, 20000, 20000, 20000,
  218.     11, 41410, 1, 0,
  219.     0, 0, 0, 0,
  220.     0, 0, 0, 0,
  221.     'Event Essence of Desire - Deaden'),
  222.    (9000122, 900012, 0, 0, 100, 7, 15000, 15000, 15000, 15000,
  223.     11, 41426, 4, 0,
  224.     0, 0, 0, 0,
  225.     0, 0, 0, 0,
  226.     'Event Essence of Desire - Spirit Shock'),
  227.    (9000123, 900012, 0, 0, 100, 7, 30000, 30000, 30000, 30000,
  228.     11, 41431, 0, 0,
  229.     0, 0, 0, 0,
  230.     0, 0, 0, 0,
  231.     'Event Essence of Desire - Rune Shield'),
  232.    (9000124, 900012, 0, 0, 100, 7, 30000, 30000, 30000, 30000,
  233.     11, 45996, 4, 0,
  234.     0, 0, 0, 0,
  235.     0, 0, 0, 0,
  236.     'Event Essence of Desire - Darkness'),
  237.    (9000125, 900012, 0, 0, 100, 7, 45000, 45000, 45000, 45000,
  238.     1, -20018, 0, 0,
  239.     0, 0, 0, 0,
  240.     0, 0, 0, 0,
  241.     'Event Essence of Desire - Spirit Shock'),
  242.  
  243.    (9000131, 900013, 0, 0, 100, 6, 1000, 1000, 0, 0,
  244.     11, 41337, 0, 0,
  245.     0, 0, 0, 0,
  246.     0, 0, 0, 0,
  247.     'Event Essence of Anger - Aura of Anger'),
  248.    (9000132, 900013, 0, 0, 100, 7, 20000, 20000, 20000, 20000,
  249.     11, 41364, 0, 0,
  250.     0, 0, 0, 0,
  251.     0, 0, 0, 0,
  252.     'Event Essence of Anger - Boil'),
  253.    (9000133, 900013, 0, 0, 100, 7, 30000, 30000, 30000, 30000,
  254.     11, 41376, 0, 0,
  255.     0, 0, 0, 0,
  256.     0, 0, 0, 0,
  257.     'Event Essence of Anger - Evil'),
  258.    (9000134, 900013, 0, 0, 100, 7, 60000, 60000, 60000, 60000,
  259.     1, -20019, 0, 0,
  260.     0, 0, 0, 0,
  261.     0, 0, 0, 0,
  262.     'Event Essence of Anger - Yell'),
  263.         (9000141, 900014, 0, 0, 100, 7, 5000, 5000, 5000, 5000,
  264.     11, 72133, 4, 0,
  265.     0, 0, 0, 0,
  266.     0, 0, 0, 0,
  267.     'Event Boss - Pain and Suffering');
  268.  
  269. DELETE FROM creature_ai_texts WHERE entry BETWEEN -20019 AND -20009;
  270. INSERT INTO creature_ai_texts
  271.     (entry, content_default, content_loc3, type, comment)
  272. VALUES
  273.     (-20009, 'I think I did an angry poo. It\'s gonna explode!', '', 1, 'Event Boss Yell'),
  274.     (-20010, 'Good news everyone. The slime is flowing again!', '', 1, 'Event Boss Yell'),
  275.     (-20011, 'Scoop your own tomb, mortals!', '', 1, 'Event Boss Yell'),
  276.     (-20012, 'Feel the power that the Lich King conferred me!', '', 1, 'Event Boss Yell'),
  277.     (-20013, 'Doom will come upon you!', '', 1, 'Event Boss Yell'),
  278.     (-20014, 'Your own magic will betray you!', '', 1, 'Event Boss Yell'),
  279.     (-20015, 'Fell what I feel!', '', 1, 'Event Boss Yell'),
  280.     (-20016, 'It\'s time to maximize the output. DIE!', '', 1, 'Event Boss Yell'),
  281.     (-20017, 'Please, stop! Why are you still fighting?', '', 1, 'Event Boss Yell'),
  282.     (-20018, 'What a pleasure!', '', 1, 'Event Boss Yell'),
  283.     (-20019, 'I will tear you up!', '', 1, 'Event Boss Yell');
  284.  
  285.  
  286. /* ======================= */
  287. /* === Goblin Treasure === */
  288. /* ======================= */
  289.  
  290. DELETE FROM gameobject_template WHERE entry = 900001;
  291. INSERT INTO gameobject_template
  292.     (entry, type, displayId, name, IconName, castBarCaption, unk1, faction, flags, size, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, data0, data1, data2, data3, data4, data5, data6, data7, data8, data9, data10, data11, data12, data13, data14, data15, data16, data17, data18, data19, data20, data21, data22, data23, ScriptName, WDBVerified)
  293. VALUES
  294.     (900001, 3, 259, 'Lost Goblinchest', '', '', '', 0, 0, 1.5, 0, 0, 0, 0, 0, 0, 1634, 900001, 604800, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', 11723);
  295.  
  296. DELETE FROM gameobject_loot_template WHERE entry = 900001;
  297. INSERT INTO gameobject_loot_template
  298.     (entry, item, ChanceOrQuestChance, lootmode, groupid, mincountOrRef, maxcount)
  299. VALUES
  300.     (900001, 18258, 21, 1, 2, 1, 1),
  301.     (900001, 32566, 11, 1, 2, 1, 1),
  302.     (900001, 33079, 8, 1, 2, 1, 1),
  303.     (900001, 33223, 21, 1, 2, 1, 1),
  304.     (900001, 37254, 8, 1, 2, 1, 1),
  305.     (900001, 43599, 5, 1, 2, 1, 1),
  306.     (900001, 44819, 19, 1, 2, 1, 1),
  307.     (900001, 45063, 33, 1, 2, 1, 1),
  308.     (900001, 47241, 100, 1, 1, 1, 1),
  309.     (900001, 49110, 11, 1, 2, 1, 1),
  310.     (900001, 49290, 5, 1, 2, 1, 1),
  311.     (900001, 51809, 8, 1, 2, 1, 1),
  312.     (900001, 56806, 11, 1, 2, 1, 1);
  313.  
  314.  
  315. /* ======================= */
  316. /* = Invader of Darkness = */
  317. /* ======================= */
  318.  
  319. DELETE FROM quest_template WHERE entry = 900008;
  320. INSERT INTO quest_template
  321.     (entry, Method, ZoneOrSort, SkillOrClassMask, MinLevel, MaxLevel, QuestLevel, Type, RequiredRaces, RequiredSkillValue, RepObjectiveFaction, RepObjectiveValue, RepObjectiveFaction2, RepObjectiveValue2, RequiredMinRepFaction, RequiredMinRepValue, RequiredMaxRepFaction, RequiredMaxRepValue, SuggestedPlayers, LimitTime, QuestFlags, SpecialFlags, CharTitleId, PlayersSlain, BonusTalents, RewardArenaPoints, PrevQuestId, NextQuestId, ExclusiveGroup, NextQuestInChain, RewXPId, SrcItemId, SrcItemCount, SrcSpell, Title, Details, Objectives, OfferRewardText, RequestItemsText, EndText, CompletedText, ObjectiveText1, ObjectiveText2, ObjectiveText3, ObjectiveText4, ReqItemId1, ReqItemId2, ReqItemId3, ReqItemId4, ReqItemId5, ReqItemId6, ReqItemCount1, ReqItemCount2, ReqItemCount3, ReqItemCount4, ReqItemCount5, ReqItemCount6, ReqSourceId1, ReqSourceId2, ReqSourceId3, ReqSourceId4, ReqSourceCount1, ReqSourceCount2, ReqSourceCount3, ReqSourceCount4, ReqCreatureOrGOId1, ReqCreatureOrGOId2, ReqCreatureOrGOId3, ReqCreatureOrGOId4, ReqCreatureOrGOCount1, ReqCreatureOrGOCount2, ReqCreatureOrGOCount3, ReqCreatureOrGOCount4, ReqSpellCast1, ReqSpellCast2, ReqSpellCast3, ReqSpellCast4, RewChoiceItemId1, RewChoiceItemId2, RewChoiceItemId3, RewChoiceItemId4, RewChoiceItemId5, RewChoiceItemId6, RewChoiceItemCount1, RewChoiceItemCount2, RewChoiceItemCount3, RewChoiceItemCount4, RewChoiceItemCount5, RewChoiceItemCount6, RewItemId1, RewItemId2, RewItemId3, RewItemId4, RewItemCount1, RewItemCount2, RewItemCount3, RewItemCount4, RewRepFaction1, RewRepFaction2, RewRepFaction3, RewRepFaction4, RewRepFaction5, RewRepValueId1, RewRepValueId2, RewRepValueId3, RewRepValueId4, RewRepValueId5, RewRepValue1, RewRepValue2, RewRepValue3, RewRepValue4, RewRepValue5, RewHonorAddition, RewHonorMultiplier, unk0, RewOrReqMoney, RewMoneyMaxLevel, RewSpell, RewSpellCast, RewMailTemplateId, RewMailDelaySecs, PointMapId, PointX, PointY, PointOpt, DetailsEmote1, DetailsEmote2, DetailsEmote3, DetailsEmote4, DetailsEmoteDelay1, DetailsEmoteDelay2, DetailsEmoteDelay3, DetailsEmoteDelay4, IncompleteEmote, CompleteEmote, OfferRewardEmote1, OfferRewardEmote2, OfferRewardEmote3, OfferRewardEmote4, OfferRewardEmoteDelay1, OfferRewardEmoteDelay2, OfferRewardEmoteDelay3, OfferRewardEmoteDelay4, StartScript, CompleteScript, WDBVerified)
  322. VALUES
  323.     (900008, 2, 0, 0, 80, 80, 80, 82, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40, 1800, 4096, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Red Light in my Eyes', 'The time has come, heroes. The most feared servent of Arthas has arrived!', 'Kill Scourge Commdant Redlight before he escape.', NULL, NULL, NULL, 'You did it, heroes.', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 900002, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 47241, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 1);
  324.  
  325. DELETE FROM creature_questrelation WHERE id = 900007;
  326. INSERT INTO creature_questrelation
  327.     (id, quest)
  328. VALUES
  329.     (900007, 900008);
  330.  
  331. DELETE FROM creature_involvedrelation WHERE id = 900007;
  332. INSERT INTO creature_involvedrelation
  333.     (id, quest)
  334. VALUES
  335.     (900007, 900008);
  336.  
  337. DELETE FROM creature_equip_template WHERE entry = 900002;
  338. INSERT INTO creature_equip_template
  339.     (entry, equipentry1, equipentry2, equipentry3)
  340. VALUES
  341.     (900002, 49623, 49623, 0);
  342.  
  343.  
  344. DELETE FROM creature WHERE id IN (900002, 900003, 900005, 900007);
  345. INSERT INTO creature
  346.     (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)
  347. VALUES
  348.     (207078, 900002, 1, 1, 1, 0, 10136, 1506.46, -4414.28, 20.4401, 6.26099, 300, 0, 0, 117548112, 0, 0, 0),
  349.     (207757, 900002, 0, 1, 1, 0, 10136, -8882.58, 577.858, 92.9952, 0.612171, 300, 0, 0, 117548112, 0, 0, 0),
  350.     (206141, 900003, 1, 1, 1, 0, 99994, 1533.78, -4412.62, 11.867, 3.18945, 300, 0, 0, 4646400, 0, 0, 0),
  351.     (207759, 900005, 0, 1, 1, 0, 0, -8859.82, 595.471, 92.0729, 3.80492, 300, 0, 0, 4646400, 0, 0, 0),
  352.     (208694, 900007, 0, 1, 1, 0, 0, -8828.81, 646.509, 94.5438, 5.10318, 300, 0, 0, 2414584, 0, 0, 0),
  353.     (209045, 900007, 1, 1, 1, 0, 0, 1610.76, -4389.66, 10.4693, 3.66226, 300, 0, 0, 2414584, 0, 0, 0);
  354.  
  355. DELETE FROM gameobject_template WHERE entry = 90004;
  356. INSERT INTO gameobject_template VALUES (90004, 0, 9239, 'Gate of the Scourge', '', '', '', 0, 4, 1, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1);
  357.  
  358. DELETE FROM gameobject WHERE id = 90004;
  359. INSERT INTO gameobject
  360.     (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state)
  361. VALUES
  362.     (1478850, 90004, 1, 1, 1, 1480.03, -4417.49, 25.4626, 3.31397, 0, 0, 0.996288, -0.0860829, 300, 0, 1),
  363.     (1478853, 90004, 1, 1, 1, 1729.65, -4403.47, 35.1392, 5.36544, 0, 0, 0.442937, -0.896553, 300, 0, 1),
  364.     (1478877, 90004, 0, 1, 1, -8890.4, 571.822, 92.5043, 3.80167, 0, 0, 0.946029, -0.324082, 300, 0, 1);
  365.  
  366. DELETE FROM game_event_gameobject WHERE event IN (998, 999);
  367. INSERT INTO game_event_gameobject
  368.     (guid, event)
  369. VALUES
  370.     (1478850, 998), -- Horde
  371.     (1478853, 998),
  372.     (1478877, 999); -- Alliance
  373.  
  374. DELETE FROM game_event_creature WHERE event IN (998, 999);
  375. INSERT INTO game_event_creature
  376.     (guid, event)
  377. VALUES
  378.     (207078, 998), -- Horde
  379.     (206141, 998),
  380.     (209045, 998),
  381.     (207757, 999), -- Alliance
  382.     (207759, 999),
  383.     (208694, 999);
  384.  
  385. DELETE FROM creature_template WHERE entry IN (900002, 900003, 900005, 900006, 900007);
  386. INSERT INTO creature_template
  387.     (entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName, WDBVerified)
  388. VALUES
  389.     (900002, 0, 0, 0, 0, 0, 30869, 30869, 30869, 0, 'Scourge Commander Redlight', 'The Soulreaver', NULL, 0, 83, 83, 0, 14, 14, 0, 1, 1.5, 3, 3, 509, 683, 5, 805, 75, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 14807.16, 156, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 900002, 617299967, 0, '', 1),
  390.     (900003, 0, 0, 0, 0, 0, 4527, 0, 0, 0, 'Thrall', 'Warchief', NULL, 0, 83, 83, 0, 85, 85, 0, 1, 1.14286, 2, 3, 8400, 15200, 0, 200, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 800, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 99994, 617299967, 0, '', 1),
  391.     (900005, 0, 0, 0, 0, 0, 28127, 0, 0, 0, 'King Varian Wrynn', 'King of Stormwind', NULL, 0, 83, 83, 0, 11, 11, 0, 1, 1.14286, 2, 3, 8400, 15200, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 800, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 900005, 617299967, 0, '', 1),
  392.     (900006, 0, 0, 0, 0, 0, 25297, 0, 0, 0, 'Shambling Horror', 'Redlight\'s Minion', NULL, 0, 83, 83, 0, 14, 14, 0, 1, 1.14286, 1, 3, 24530, 49630, 0, 805, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 658, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 617299967, 0, '', 1),
  393.     (900007, 0, 0, 0, 0, 0, 22209, 0, 0, 0, 'Highlord Tirion Fordring', NULL, NULL, 0, 80, 80, 0, 35, 35, 2, 1, 1.14286, 1, 3, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 452, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 1);
  394.  
  395.  
  396. DELETE FROM game_event WHERE entry IN (998, 999);
  397. INSERT INTO game_event
  398.     (entry, start_time, end_time, occurence, length, holiday, description, world_event)
  399. VALUES
  400.     (998, '0000-0-0 00:00:00', '0000-0-0 00:00:00', 0, 30, 0, 'Invader of Darkness (Horde)', 0),
  401.     (999, '0000-0-0 00:00:00', '0000-0-0 00:00:00', 5184000, 30, 0, 'Invader of Darkness (Alliance)', 0);
  402.  
  403. /* EventAI scripts */
  404. DELETE FROM creature_ai_scripts WHERE creature_id IN (900002, 900003, 900005, 900006);
  405. INSERT INTO creature_ai_scripts
  406.    (id, creature_id, event_type, event_inverse_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4,
  407.     action1_type, action1_param1, action1_param2, action1_param3,
  408.     action2_type, action2_param1, action2_param2, action2_param3,
  409.     action3_type, action3_param1, action3_param2, action3_param3,
  410.     comment)
  411. VALUES
  412.    (9000021, 900002, 0, 0, 100, 7, 6000, 7000, 6000, 7000,
  413.     11, 40827, 1, 0,
  414.     0, 0, 0, 0,
  415.     0, 0, 0, 0,
  416.     'Scourge Commander Redlight - Cast Sinful Beam'),
  417.    (9000022, 900002, 0, 0, 100, 7, 15000, 15000, 15000, 15000,
  418.     11, 59352, 4, 0,
  419.     1, -20004, 0, 0,
  420.     0, 0, 0, 0,
  421.     'Scourge Commander Redlight - Cast Mark of Darkness'),
  422.    (9000023, 900002, 0, 0, 100, 7, 25000, 25000, 30000, 30000,
  423.     11, 31306, 1, 0,
  424.     0, 0, 0, 0,
  425.     0, 0, 0, 0,
  426.     'Scourge Commander Redlight - Cast Carrion Swarm'),
  427.    (9000024, 900002, 0, 0, 100, 7, 30000, 30000, 30000, 30000,
  428.     11, 71022, 0, 0,
  429.     0, 0, 0, 0,
  430.     0, 0, 0, 0,
  431.     'Scourge Commander Redlight - Cast Disrupting Shout'),
  432.    (9000025, 900002, 0, 0, 100, 7, 60000, 60000, 90000, 120000,
  433.     12, 900006, 5, 0,
  434.     0, 0, 0, 0,
  435.     0, 0, 0, 0,
  436.     'Scourge Commander Redlight - Summon Add'),
  437.    (9000026, 900002, 0, 0, 100, 7, 61000, 62000, 61000, 62000,
  438.     1, -20005, 0, 0,
  439.     0, 0, 0, 0,
  440.     0, 0, 0, 0,
  441.     'Scourge Commander Redlight - Yell'),
  442.    (9000027, 900002, 2, 0, 100, 6, 10, 1, 0, 0,
  443.     11, 68872, 1, 3,
  444.     1, -20006, 0, 0,
  445.     0, 0, 0, 0,
  446.     'Scourge Commander Redlight - 10%'),
  447.    (9000028, 900002, 6, 0, 100, 6, 0, 0, 0, 0,
  448.     26, 900008, 0, 0,
  449.     0, 0, 0, 0,
  450.     0, 0, 0, 0,
  451.     'Scourge Commander Redlight - Questcredit on death'),
  452.    (9000061, 900006, 0, 0, 100, 7, 120000, 120000, 120000, 120000,
  453.     11, 58841, 0, 0,
  454.     0, 0, 0, 0,
  455.     0, 0, 0, 0,
  456.     'Scourge Commander Add - Cast Frenzy'),
  457.    (9000062, 900006, 0, 0, 100, 7, 15000, 16000, 15000, 16000,
  458.     11, 75418, 1, 0,
  459.     0, 0, 0, 0,
  460.     0, 0, 0, 0,
  461.     'Scourge Commander Add - Cast Shockwave'),
  462.    (9000063, 900006, 0, 0, 100, 7, 56000, 57000, 56000, 57000,
  463.     11, 45855, 1, 0,
  464.     0, 0, 0, 0,
  465.     0, 0, 0, 0,
  466.     'Scourge Commander Add - Cast Gas Nova'),
  467.    (9000031, 900003, 0, 0, 100, 7, 60000, 60000, 60000, 60000,
  468.     1, -20007, 0, 0,
  469.     0, 0, 0, 0,
  470.     0, 0, 0, 0,
  471.     'Event Thrall - Yell'),
  472.    (9000051, 900005, 0, 0, 100, 7, 60000, 60000, 60000, 60000,
  473.     1, -20008, 0, 0,
  474.     0, 0, 0, 0,
  475.     0, 0, 0, 0,
  476.     'Event King Varian Wrynn - Yell');
  477.  
  478. DELETE FROM creature_ai_texts WHERE entry BETWEEN -20008 AND -20004;
  479. INSERT INTO creature_ai_texts
  480.     (entry, content_default, content_loc3, type, comment)
  481. VALUES
  482.     (-20004, 'You are marked for death!', '', 1, 'Event Boss Yell'),
  483.     (-20005, 'Soon you will join your friends, mortals!', '', 1, 'Event Boss Yell'),
  484.     (-20006, 'Enough! Feel my blood-red Scythe! I will deprive your Souls!', '', 1, 'Event Boss Yell'),
  485.     (-20007, 'You don\'t know what it takes to face the Horde, Redlight!', '', 1, 'Event Boss Yell'),
  486.     (-20008, 'Never underestimate the might of the Alliance, Redlight!', '', 1, 'Event Boss Yell');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!