mirror of
https://github.com/araxiaonline/mod-worgoblin.git
synced 2026-06-13 11:12:29 -04:00
53 lines
11 KiB
SQL
53 lines
11 KiB
SQL
DELETE FROM `quest_template` WHERE `ID` IN (28649, 28650);
|
|
INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestLevel`, `MinLevel`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RequiredFactionId1`, `RequiredFactionId2`, `RequiredFactionValue1`, `RequiredFactionValue2`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardMoney`, `RewardMoneyDifficulty`, `RewardBonusMoney`, `RewardDisplaySpell`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `Flags`, `RequiredPlayerKills`, `RewardItem1`, `RewardAmount1`, `RewardItem2`, `RewardAmount2`, `RewardItem3`, `RewardAmount3`, `RewardItem4`, `RewardAmount4`, `ItemDrop1`, `ItemDropQuantity1`, `ItemDrop2`, `ItemDropQuantity2`, `ItemDrop3`, `ItemDropQuantity3`, `ItemDrop4`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemQuantity1`, `RewardChoiceItemID2`, `RewardChoiceItemQuantity2`, `RewardChoiceItemID3`, `RewardChoiceItemQuantity3`, `RewardChoiceItemID4`, `RewardChoiceItemQuantity4`, `RewardChoiceItemID5`, `RewardChoiceItemQuantity5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardTalents`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionValue1`, `RewardFactionOverride1`, `RewardFactionID2`, `RewardFactionValue2`, `RewardFactionOverride2`, `RewardFactionID3`, `RewardFactionValue3`, `RewardFactionOverride3`, `RewardFactionID4`, `RewardFactionValue4`, `RewardFactionOverride4`, `RewardFactionID5`, `RewardFactionValue5`, `RewardFactionOverride5`, `TimeAllowed`, `AllowableRaces`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RequiredNpcOrGo1`, `RequiredNpcOrGo2`, `RequiredNpcOrGo3`, `RequiredNpcOrGo4`, `RequiredNpcOrGoCount1`, `RequiredNpcOrGoCount2`, `RequiredNpcOrGoCount3`, `RequiredNpcOrGoCount4`, `RequiredItemId1`, `RequiredItemId2`, `RequiredItemId3`, `RequiredItemId4`, `RequiredItemId5`, `RequiredItemId6`, `RequiredItemCount1`, `RequiredItemCount2`, `RequiredItemCount3`, `RequiredItemCount4`, `RequiredItemCount5`, `RequiredItemCount6`, `Unknown0`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `VerifiedBuild`) VALUES
|
|
(28649, 2, 55, 55, -372, 0, 0, 0, 0, 0, 0, 12751, 7, 8500, 0, 7500, 0, 0, 0, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2048, 'A Special Surprise', 'Knight Commander Plaguefist at the Chapel of the Crimson Flame has ordered you to execute Lord Harford, an Argent Dawn prisoner inside the nearby prison house.', 'We got here, tore the place apart, and headed toward the prison house. We weren\'t expecting what we found in there, $N. Seems the Crusade\'s been real busy. That whole thing is full of Argent Dawn prisoners. Most of them were already dead by the time we arrived, but a few were still breathing.$B$BI was about to go in there and execute the rest of them, but I think you should have the honors. In particular, there\'s a real feisty worgen in there that I think you\'ll take great pleasure in executing.', '', 'Return to Knight Commander Plaguefist at the Chapel of the Crimson Flame in Plaguelands: The Scarlet Enclave.', 49355, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 0),
|
|
(28650, 2, 55, 55, -372, 0, 0, 0, 0, 0, 0, 12751, 7, 8500, 0, 7500, 0, 0, 0, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 'A Special Surprise', 'Knight Commander Plaguefist at the Chapel of the Crimson Flame has ordered you to execute Gally Lumpstain, an Argent Dawn prisoner inside the nearby prison house.', 'We got here, tore the place apart, and headed toward the prison house. We weren\'t expecting what we found in there, $N. Seems the Crusade\'s been real busy. That whole thing is full of Argent Dawn prisoners. Most of them were already dead by the time we arrived, but a few were still breathing.$B$BI was about to go in there and execute the rest of them, but I think you should have the honors. In particular, there\'s a real feisty goblin in there that I think you\'ll take great pleasure in executing.', '', 'Return to Knight Commander Plaguefist at the Chapel of the Crimson Flame in Plaguelands: The Scarlet Enclave.', 49356, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 0);
|
|
|
|
DELETE FROM `creature_questender` WHERE `quest` IN (28649, 28650);
|
|
INSERT INTO `creature_questender` (`id`, `quest`) VALUES
|
|
(29053, 28649),
|
|
(29053, 28650);
|
|
|
|
DELETE FROM `creature_queststarter` WHERE `quest` IN (28649, 28650);
|
|
INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
|
|
(29053, 28649),
|
|
(29053, 28650);
|
|
|
|
DELETE FROM `creature_template` WHERE `entry` IN (49355, 49356);
|
|
INSERT INTO `creature_template` (`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`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_flight`, `detection_range`, `scale`, `rank`, `dmgschool`, `DamageModifier`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `spell_school_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
|
|
(49355, 0, 0, 0, 0, 0, 36445, 0, 0, 0, 'Lord Harford', '', '', 0, 53, 54, 0, 7, 0, 1, 1.14286, 1, 1, 18, 1, 0, 0, 1, 2000, 2000, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0.004, 1, 1, 1, 0, 0, 1, 0, 0, 8192, 'npc_a_special_surprise', 15595),
|
|
(49356, 0, 0, 0, 0, 0, 36446, 0, 0, 0, 'Gally Lumpstain', '', '', 0, 53, 54, 0, 7, 0, 1, 1.14286, 1, 1, 18, 1, 0, 0, 1, 2000, 2000, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0.004, 1, 1, 1, 0, 0, 1, 0, 0, 8192, 'npc_a_special_surprise', 15595);
|
|
|
|
DELETE FROM `creature` WHERE `id1` IN (49355, 49356);
|
|
INSERT INTO `creature` (`guid`, `id1`, `id2`, `id3`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES
|
|
(493550, 49355, 0, 0, 609, 0, 0, 1, 4, 0, 1332.07, -5760.21, 137.736, 3.08923, 360, 0, 0, 10, 0, 0, 0, 0, 0, '', 0),
|
|
(493551, 49356, 0, 0, 609, 0, 0, 1, 4, 0, 1321.47, -5759.29, 137.717, 0.15708, 360, 0, 0, 10, 0, 0, 0, 0, 0, '', 0);
|
|
|
|
DELETE FROM `creature_addon` WHERE `guid` IN (493550, 493551);
|
|
INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
|
|
(493550, 0, 0, 65544, 1, 0, 0, NULL),
|
|
(493551, 0, 0, 65544, 1, 0, 0, NULL);
|
|
|
|
DELETE FROM `creature_text` WHERE `CreatureID` IN (49355, 49356);
|
|
INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
|
|
(49355, 0, 0, "He's sent one of his cowards in to kill me, has he?", 12, 0, 100, 0, 0, 0, 49368, 0, 'Lord Harford - SAY_EXEC_START'),
|
|
(49355, 1, 0, "Do it while I'm standing...", 12, 0, 100, 0, 0, 0, 49369, 0, 'Lord Harford - SAY_EXEC_PROG'),
|
|
(49355, 2, 0, "$n?", 12, 0, 100, 0, 0, 0, 49370, 0, 'Lord Harford - SAY_EXEC_NAME'),
|
|
(49355, 3, 0, "$n, I'd recognize that face anywhere... What... What have they done to you, $n?", 12, 0, 100, 0, 0, 0, 49371, 0, 'Lord Harford - SAY_EXEC_RECOG'),
|
|
(49355, 4, 0, "You don't remember me? We were both servants of Arugal back in Silverpine Forest. We put up with his merciless torture for ages. It was you who saved me on that fateful night when we escaped Shadowfang Keep. Without you I would have died. YOU! The most noble worgen I ever knew. What have they done to you, $n? How could this have happened?", 12, 0, 100, 0, 0, 0, 49372, 0, 'Lord Harford - SAY_EXEC_NOREM'),
|
|
(49355, 5, 0, "Remember the worgen that you once were, $g brother:sister;! You were our savior! Fight this!", 12, 0, 100, 0, 0, 0, 49374, 0, 'Lord Harford - SAY_EXEC_THINK'),
|
|
(49355, 6, 0, "Listen to me, $n. You must fight against the Lich King's control. He is a monster that wants to see this world - our world - in ruin. Don't let him use you to accomplish his goals. You were once a hero and you can be again. Fight, damn you! Fight his control!", 12, 0, 100, 0, 0, 0, 49375, 0, 'Lord Harford - SAY_EXEC_LISTEN'),
|
|
(49355, 7, 0, "There... There's no more time for me. I'm done for. Finish me off, $n. Do it or they'll kill us both. $n... Remember Gilneas, our beloved home. This world is worth saving.", 12, 0, 100, 0, 0, 0, 49376, 0, 'Lord Harford - SAY_EXEC_TIME'),
|
|
(49355, 8, 0, "Do it, $n! Put me out of my misery!", 12, 0, 100, 0, 0, 0, 49377, 0, 'Lord Harford - SAY_EXEC_WAITING'),
|
|
(49355, 9, 0, "%s dies from his injuries.", 16, 0, 100, 0, 0, 0, 49378, 0, 'Lord Harford - EMOTE_DIES'),
|
|
(49356, 0, 0, "C... can't we work this out somehow?", 12, 0, 100, 0, 0, 0, 49380, 0, 'Gally Lumpstain - SAY_EXEC_START'),
|
|
(49356, 1, 0, "Alright, j... just let me... let me st... stand up.", 12, 0, 100, 0, 0, 0, 49381, 0, 'Gally Lumpstain - SAY_EXEC_PROG'),
|
|
(49356, 2, 0, "$n?", 12, 0, 100, 0, 0, 0, 49382, 0, 'Gally Lumpstain - SAY_EXEC_NAME'),
|
|
(49356, 3, 0, "$n, I'd recognize that face anywhere... What... What have they done to you, $n?", 12, 0, 100, 0, 0, 0, 49383, 0, 'Gally Lumpstain - SAY_EXEC_RECOG'),
|
|
(49356, 4, 0, "You don't remember me, $n? I lost count of the number of jobs you and I ran back in the day on Kezan. Then I picked up a real bad Kaja'Cola habit and you saved me! It was you who took me to Kalimdor to join the Steamwheedle Cartel. You were the only good goblin I knew. That's how I ended up in the Argent Dawn, because I knew it was what you woulda done. How could this have happened to you?", 12, 0, 100, 0, 0, 0, 49384, 0, 'Gally Lumpstain - SAY_EXEC_NOREM'),
|
|
(49356, 5, 0, "Remember the goblin that you once were, $g brother:sister;! You were my best friend! Fight this!", 12, 0, 100, 0, 0, 0, 49385, 0, 'Gally Lumpstain - SAY_EXEC_THINK'),
|
|
(49356, 6, 0, "Listen to me, $n. You must fight against the Lich King's control. He is a monster that wants to see this world - our world - in ruin. Don't let him use you to accomplish his goals. You were once a hero and you can be again. Fight, damn you! Fight his control!", 12, 0, 100, 0, 0, 0, 49386, 0, 'Gally Lumpstain - SAY_EXEC_LISTEN'),
|
|
(49356, 7, 0, "There... There's no more time for me. I'm done for. Finish me off, $n. Do it or they'll kill us both. $n... Remember Kezan, our beloved home. This world is worth saving.", 12, 0, 100, 0, 0, 0, 49387, 0, 'Gally Lumpstain - SAY_EXEC_TIME'),
|
|
(49356, 8, 0, "Do it, $n! Put me out of my misery!", 12, 0, 100, 0, 0, 0, 49388, 0, 'Gally Lumpstain - SAY_EXEC_WAITING'),
|
|
(49356, 9, 0, "%s dies from his injuries.", 16, 0, 100, 0, 0, 0, 49389, 0, 'Gally Lumpstain - EMOTE_DIES');
|