diff options
| -rw-r--r-- | sql/updates/world/master/2022_10_01_00_world.sql | 425 | ||||
| -rw-r--r-- | src/server/scripts/EasternKingdoms/zone_silverpine_forest.cpp | 458 |
2 files changed, 883 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_10_01_00_world.sql b/sql/updates/world/master/2022_10_01_00_world.sql new file mode 100644 index 00000000000..690ffe21e7f --- /dev/null +++ b/sql/updates/world/master/2022_10_01_00_world.sql @@ -0,0 +1,425 @@ + -- + -- + -- Silverpine Forest + +SET @CGUID := 395633; + + -- Iterating Upon Success +UPDATE `quest_template_addon` SET `NextQuestID`= 0 WHERE `ID` = 26998; + + -- + -- Forsaken High Command + + -- Detect: Quest Invis Zone 1 +DELETE FROM `spell_area` WHERE `spell`=83232 AND `area`=5369 AND `quest_start`=26965 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `flags`, `quest_start_status`, `quest_end_status`) VALUES +(83232, 5369, 26965, 27098, 0, 0, 2, 3, 64, 1); + + -- Detect: Quest Invis Zone 3 +DELETE FROM `spell_area` WHERE `spell`=83989 AND `area`=5369 AND `quest_start`=26965 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `flags`, `quest_start_status`, `quest_end_status`) VALUES +(83989, 5369, 26965, 27097, 0, 0, 2, 3, 64, 1); + +DELETE FROM `spell_area` WHERE `spell`=83989 AND `area`=5369 AND `quest_start`=27099 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `flags`, `quest_start_status`, `quest_end_status`) VALUES +(83989, 5369, 27099, 27098, 0, 0, 2, 3, 64, 1); + + -- Detect: Quest Invis Zone 20 (Ambermill Shield) +DELETE FROM `spell_area` WHERE `spell`=85406 AND `area`=130 AND `quest_start`=0 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `flags`, `quest_start_status`, `quest_end_status`) VALUES +(85406, 130, 0, 27518, 0, 0, 2, 3, 0, 8); + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+39; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES +(@CGUID+0, 44592, 0, 130, 5369, '0', 169, 0, 0, 0, 1378.1600341796875, 1031.7099609375, 51.37173080444335937, 0.767944872379302978, 1, 0, 0, 1604, 0, 0, 0, 0, 0, '', 45338), -- Fallen Human (Area: Forsaken High Command - Difficulty: 0) (Auras: 80636 - Feigned) +(@CGUID+1, 44593, 0, 130, 5369, '0', 169, 0, 0, 0, 1376, 1029.6099853515625, 50.93743133544921875, 0.890117883682250976, 1, 0, 0, 1604, 0, 0, 0, 0, 0, '', 45338), -- Fallen Human (Area: Forsaken High Command - Difficulty: 0) (Auras: 80636 - Feigned) +(@CGUID+2, 44592, 0, 130, 5369, '0', 169, 0, 0, 0, 1377.300048828125, 1035.9300537109375, 51.09613037109375, 3.141592741012573242, 1, 0, 0, 1604, 0, 0, 0, 0, 0, '', 45338), -- Fallen Human (Area: Forsaken High Command - Difficulty: 0) (Auras: 80636 - Feigned) +(@CGUID+3, 44593, 0, 130, 5369, '0', 169, 0, 0, 0, 1375.4200439453125, 1033.81005859375, 50.65223312377929687, 0.890117883682250976, 1, 0, 0, 1604, 0, 0, 0, 0, 0, '', 45338), -- Fallen Human (Area: Forsaken High Command - Difficulty: 0) (Auras: 80636 - Feigned) +(@CGUID+4, 44365, 0, 130, 5369, '0', 169, 0, 0, 1, 1381.3499755859375, 1040.72998046875, 54.40043258666992187, 3.909537553787231445, 120, 0, 0, 641600, 17040, 0, 3, 0, 0, 'npc_silverpine_sylvanas_windrunner_high_command', 45338), -- Lady Sylvanas Windrunner (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+5, 44610, 0, 130, 5369, '0', 169, 0, 0, 0, 1360.81005859375, 1030.5699462890625, 55.87403106689453125, 0.645771801471710205, 120, 0, 0, 48120, 17040, 0, 0, 0, 0, '', 45338), -- Arthura (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+6, 44609, 0, 130, 5369, '0', 169, 0, 0, 0, 1365.72998046875, 1024.97998046875, 56.02443313598632812, 1.029744267463684082, 120, 0, 0, 48120, 17040, 0, 0, 0, 0, '', 45338), -- Daschla (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+7, 44825, 0, 130, 5369, '0', 169, 0, 0, 1, 1422.9305419921875, 1017.77081298828125, 52.64933395385742187, 2.862339973449707031, 120, 0, 0, 11791, 0, 0, 0, 0, 0, '', 45338), -- Bat Handler Maggotbreath (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+8, 44632, 0, 130, 5369, '0', 169, 0, 0, 1, 1438.05, 1068.76, 60.7803, 5.5573577880859375, 120, 10, 0, 3208, 0, 2, 0, 0, 0, '', 45338), -- Dark Ranger (Area: Forsaken High Command - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+9, 44632, 0, 130, 5369, '0', 169, 0, 0, 1, 1400.9300537109375, 1003.3800048828125, 53.03673171997070312, 2.094395160675048828, 120, 0, 0, 3208, 0, 0, 0, 0, 0, '', 45338), -- Dark Ranger (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+10, 44632, 0, 130, 5369, '0', 169, 0, 0, 1, 1389.5400390625, 1047.81005859375, 53.04053115844726562, 3.577924966812133789, 120, 0, 0, 3208, 0, 0, 0, 0, 0, '', 45338), -- Dark Ranger (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+11, 44632, 0, 130, 5369, '0', 169, 0, 0, 1, 1430.030029296875, 1022.59002685546875, 52.49113082885742187, 3.281219005584716796, 120, 0, 0, 3208, 0, 0, 0, 0, 0, '', 45338), -- Dark Ranger (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+12, 44640, 0, 130, 5369, '0', 169, 0, 0, 1, 1354.036, 1035.0999, 52.81333, 0.205820217728614807, 120, 0, 0, 8020, 0, 2, 0, 0, 0, '', 45338), -- High Warlord Cromush (Area: Forsaken High Command - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+13, 44789, 0, 130, 5369, '0', 169, 0, 0, 1, 1415.22998046875, 1010.1500244140625, 52.80423355102539062, 2.286381244659423828, 120, 0, 0, 8020, 100, 0, 0, 0, 0, '', 45338), -- Deathstalker Commander Belmont (Area: Forsaken High Command - Difficulty: 0) (Auras: 83231 - Apply Quest Invis Zone 1) +(@CGUID+14, 44790, 0, 130, 5369, '0', 169, 0, 0, 1, 1417.18994140625, 1009.780029296875, 52.70093154907226562, 2.268928050994873046, 120, 0, 0, 1604, 100, 0, 0, 0, 0, '', 45338), -- Deathstalker (Area: Forsaken High Command - Difficulty: 0) (Auras: 83231 - Apply Quest Invis Zone 1) +(@CGUID+15, 44790, 0, 130, 5369, '0', 169, 0, 0, 1, 1412.6300048828125, 1011.4000244140625, 52.9539337158203125, 5.777040004730224609, 120, 0, 0, 1604, 100, 0, 0, 0, 0, '', 45338), -- Deathstalker (Area: Forsaken High Command - Difficulty: 0) (Auras: 83231 - Apply Quest Invis Zone 1) +(@CGUID+16, 44790, 0, 130, 5369, '0', 169, 0, 0, 1, 1415.5, 1012.989990234375, 52.88033294677734375, 4.468042850494384765, 120, 0, 0, 1604, 100, 0, 0, 0, 0, '', 45338), -- Deathstalker (Area: Forsaken High Command - Difficulty: 0) (Auras: 83231 - Apply Quest Invis Zone 1) +(@CGUID+17, 44790, 0, 130, 5369, '0', 169, 0, 0, 1, 1415.050048828125, 1008.16998291015625, 52.752532958984375, 2.146754980087280273, 120, 0, 0, 1604, 100, 0, 0, 0, 0, '', 45338), -- Deathstalker (Area: Forsaken High Command - Difficulty: 0) (Auras: 83231 - Apply Quest Invis Zone 1) +(@CGUID+18, 44778, 0, 130, 5369, '0', 169, 0, 0, 1, 1409.3299560546875, 1065.8599853515625, 60.56173324584960937, 0.226892799139022827, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Witherbloom (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+19, 45489, 0, 130, 5369, '0', 169, 0, 0, 1, 1413.719970703125, 1104.02001953125, 60.56173324584960937, 2.757620096206665039, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Chase (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+20, 45490, 0, 130, 5369, '0', 169, 0, 0, 1, 1422.5699462890625, 1097.31005859375, 60.56173324584960937, 4.485496044158935546, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Marry (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+21, 45491, 0, 130, 5369, '0', 169, 0, 0, 1, 1445.27001953125, 1072.9000244140625, 60.54363250732421875, 1.2042771577835083, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Harrington (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+22, 44784, 0, 130, 5369, '0', 169, 0, 0, 1, 1431.47998046875, 1086.8599853515625, 60.56173324584960937, 3.752457857131958007, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- High Apothecary Shana T'veen (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+23, 43359, 0, 130, 5369, '0', 169, 0, 0, 0, 2298.788330078125, 280.118072509765625, 76.27024078369140625, 0, 120, 0, 0, 11791, 0, 0, 0, 0, 0, '', 45338), -- ELM General Purpose Bunny Infinite Hide Body (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+24, 44786, 0, 130, 5369, '0', 169, 0, 0, 0, 1425.0799560546875, 1083.22998046875, 60.56173324584960937, 0.855211317539215087, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Initiate (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+25, 44786, 0, 130, 5369, '0', 169, 0, 0, 0, 1429.3299560546875, 1081.72998046875, 60.56173324584960937, 0.855211317539215087, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Initiate (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+26, 44786, 0, 130, 5369, '0', 169, 0, 0, 0, 1423.3399658203125, 1085.75, 60.56173324584960937, 0.855211317539215087, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Initiate (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+27, 44786, 0, 130, 5369, '0', 169, 0, 0, 0, 1426.300048828125, 1085.5, 60.56173324584960937, 0.855211317539215087, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Initiate (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+28, 44786, 0, 130, 5369, '0', 169, 0, 0, 0, 1420.8399658203125, 1066.1700439453125, 60.56173324584960937, 5.288347721099853515, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Initiate (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+29, 44786, 0, 130, 5369, '0', 169, 0, 0, 0, 1426.77001953125, 1081.06005859375, 60.56173324584960937, 0.855211317539215087, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Initiate (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+30, 44786, 0, 130, 5369, '0', 169, 0, 0, 0, 1424.3399658203125, 1080.8599853515625, 60.56173324584960937, 0.855211317539215087, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Initiate (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+31, 44786, 0, 130, 5369, '0', 169, 0, 0, 0, 1410.6300048828125, 1102.3299560546875, 60.56173324584960937, 1.500983119010925292, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Initiate (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+32, 44786, 0, 130, 5369, '0', 169, 0, 0, 0, 1426.199951171875, 1078.5400390625, 60.56173324584960937, 0.855211317539215087, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Initiate (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+33, 44786, 0, 130, 5369, '0', 169, 0, 0, 0, 1428.8599853515625, 1079.0899658203125, 60.56173324584960937, 0.855211317539215087, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Initiate (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+34, 44786, 0, 130, 5369, '0', 169, 0, 0, 0, 1443.9200439453125, 1079.1199951171875, 60.56133270263671875, 0.92502450942993164, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Initiate (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+35, 44786, 0, 130, 5369, '0', 169, 0, 0, 0, 1422.5899658203125, 1083.0699462890625, 60.56173324584960937, 0.855211317539215087, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Initiate (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+36, 44786, 0, 130, 5369, '0', 169, 0, 0, 0, 1427.6300048828125, 1083.510009765625, 60.56173324584960937, 0.855211317539215087, 120, 0, 0, 1604, 1704, 0, 0, 0, 0, '', 45338), -- Apothecary Initiate (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+37, 1412, 0, 130, 5369, '0', 169, 0, 0, 0, 1408.0518798828125, 954.0006103515625, 51.056793212890625, 0.975751638412475585, 120, 0, 0, 5, 0, 0, 0, 0, 0, '', 45338), -- Squirrel (Area: Forsaken High Command - Difficulty: 0) +(@CGUID+38, 61890, 0, 130, 5369, '0', 169, 0, 0, 0, 1348.890625, 1084.1163330078125, 52.849273681640625, 5.410439968109130859, 120, 10, 0, 5, 0, 1, 0, 0, 0, '', 45338), -- Blighted Squirrel (Area: Forsaken High Command - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+39, 44911, 0, 130, 130, '0', 169, 0, 0, 1, 1492.83, 637.973, 46.429, 5.14269, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 45338); -- Deathguard (Area: Silverpine Forest - Difficulty: 0) + +-- Lady Sylvanas Windrunner +UPDATE `creature_template` SET `gossip_menu_id`=11823 WHERE `entry`=44365; -- Lady Sylvanas Windrunner + +DELETE FROM `creature_addon` WHERE `guid`=@CGUID+4; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+4, 0, 0, 0, 0, 1, 0, 0, 0, 0, 3, '83231'); + +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` =44365); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(44365, 0, 0, 0, 7, 45338); + +DELETE FROM `gossip_menu` WHERE `MenuID`=11823 AND `TextID`=16575; +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(11823, 16575, 45338); + +-- Forsaken Warhorse +UPDATE `creature_template` SET `VehicleId`=1077 WHERE `entry`=73595; + +DELETE FROM `creature_template_addon` WHERE `entry` =73595; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(73595, 0, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''); + +DELETE FROM `serverside_spell` WHERE `Id`=148164 AND `DifficultyID`=0; +INSERT INTO `serverside_spell` (`Id`, `DifficultyID`, `CategoryId`, `Dispel`, `Mechanic`, `Attributes`, `AttributesEx`, `AttributesEx2`, `AttributesEx3`, `AttributesEx4`, `AttributesEx5`, `AttributesEx6`, `AttributesEx7`, `AttributesEx8`, `AttributesEx9`, `AttributesEx10`, `AttributesEx11`, `AttributesEx12`, `AttributesEx13`, `AttributesEx14`, `Stances`, `StancesNot`, `Targets`, `TargetCreatureType`, `RequiresSpellFocus`, `FacingCasterFlags`, `CasterAuraState`, `TargetAuraState`, `ExcludeCasterAuraState`, `ExcludeTargetAuraState`, `CasterAuraSpell`, `TargetAuraSpell`, `ExcludeCasterAuraSpell`, `ExcludeTargetAuraSpell`, `CastingTimeIndex`, `RecoveryTime`, `CategoryRecoveryTime`, `StartRecoveryCategory`, `StartRecoveryTime`, `InterruptFlags`, `AuraInterruptFlags1`, `AuraInterruptFlags2`, `ChannelInterruptFlags1`, `ChannelInterruptFlags2`, `ProcFlags`, `ProcFlags2`, `ProcChance`, `ProcCharges`, `ProcCooldown`, `ProcBasePPM`, `MaxLevel`, `BaseLevel`, `SpellLevel`, `DurationIndex`, `RangeIndex`, `Speed`, `LaunchDelay`, `StackAmount`, `EquippedItemClass`, `EquippedItemSubClassMask`, `EquippedItemInventoryTypeMask`, `ContentTuningId`, `SpellName`, `ConeAngle`, `ConeWidth`, `MaxTargetLevel`, `MaxAffectedTargets`, `SpellFamilyName`, `SpellFamilyFlags1`, `SpellFamilyFlags2`, `SpellFamilyFlags3`, `SpellFamilyFlags4`, `DmgClass`, `PreventionType`, `AreaGroupId`, `SchoolMask`, `ChargeCategoryId`) VALUES +(148164, 0, 0, 0, 0, 142606592, 268697600, 1, 1048576, 4160, 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, 0, 21, 1, 0, 0, 0, -1, 0, 0, 0, '(Serverside/Non-DB2) Summon Forsaken Warhorse', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); + +DELETE FROM `serverside_spell_effect` WHERE `SpellID`=147066 AND `EffectIndex`=0 AND `DifficultyID`=0; +INSERT INTO `serverside_spell_effect` (`SpellID`, `EffectIndex`, `DifficultyID`, `Effect`, `EffectAura`, `EffectAmplitude`, `EffectAttributes`, `EffectAuraPeriod`, `EffectBonusCoefficient`, `EffectChainAmplitude`, `EffectChainTargets`, `EffectItemType`, `EffectMechanic`, `EffectPointsPerResource`, `EffectPosFacing`, `EffectRealPointsPerLevel`, `EffectTriggerSpell`, `BonusCoefficientFromAP`, `PvpMultiplier`, `Coefficient`, `Variance`, `ResourceCoefficient`, `GroupSizeBasePointsCoefficient`, `EffectBasePoints`, `EffectMiscValue1`, `EffectMiscValue2`, `EffectRadiusIndex1`, `EffectRadiusIndex2`, `EffectSpellClassMask1`, `EffectSpellClassMask2`, `EffectSpellClassMask3`, `EffectSpellClassMask4`, `ImplicitTarget1`, `ImplicitTarget2`) VALUES +(147066, 0, 0, 6, 226, 0, 0, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); + +-- Agatha +UPDATE `creature` SET `position_x`=1364.0200195312, `position_y`=1028.5400390625, `position_z`=55.99143218994140625, `orientation`=0.855211317539215087 WHERE `guid`=322163; + +DELETE FROM `creature_addon` WHERE `guid`=322163; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(322163, 0, 0, 0, 50397184, 1, 0, 0, 0, 0, 3, '83988'); + +-- Arthura +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` =44610); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(44610, 0, 0, 0, 7, 45338); + +DELETE FROM `creature_addon` WHERE `guid`=@CGUID+5; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+5, 0, 0, 0, 50397184, 1, 0, 0, 0, 0, 3, '83231'); + +-- Daschla +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` =44609); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(44609, 0, 0, 0, 7, 45338); + +DELETE FROM `creature_addon` WHERE `guid`=@CGUID+6; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+6, 0, 0, 0, 50397184, 1, 0, 0, 0, 0, 3, '83231'); + +-- High Warlord Cromush +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30, `unit_flags2`=2099200 WHERE `entry`=44640; -- High Warlord Cromush + +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` =44640); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(44640, 0, 0, 0, 7, 45338); + +SET @PATH := (@CGUID+12) * 10; +DELETE FROM `waypoint_data` WHERE `id` = @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 1, 1354.036, 1035.0999, 52.81333, NULL, 0, 0, 0, 0, 0), +(@PATH, 2, 1359.1589, 1022.6127, 52.732635, NULL, 0, 0, 0, 0, 0), +(@PATH, 3, 1366.1589, 1019.3627, 52.982635, NULL, 0, 0, 0, 0, 0), +(@PATH, 4, 1372.1357, 1016.7146, 53.057182, NULL, 0, 0, 0, 0, 0), +(@PATH, 5, 1376.1357, 1017.4646, 53.307182, NULL, 0, 0, 0, 0, 0), +(@PATH, 6, 1385.0673, 1019.3989, 53.502197, NULL, 0, 0, 0, 0, 0), +(@PATH, 7, 1389.9948, 1033.2056, 53.689217, NULL, 0, 0, 0, 0, 0), +(@PATH, 8, 1388.9948, 1035.9556, 53.689217, NULL, 0, 0, 0, 0, 0), +(@PATH, 9, 1388.2448, 1037.7056, 53.939217, NULL, 0, 0, 0, 0, 0), +(@PATH, 10, 1387.4948, 1039.4556, 54.189217, NULL, 0, 0, 0, 0, 0), +(@PATH, 11, 1386.3665, 1042.5286, 54.28894, NULL, 0, 0, 0, 0, 0), +(@PATH, 12, 1384.6165, 1043.5286, 54.53894, NULL, 0, 0, 0, 0, 0), +(@PATH, 13, 1382.3665, 1045.0286, 54.28894, NULL, 0, 0, 0, 0, 0), +(@PATH, 14, 1380.8665, 1046.2786, 54.03894, NULL, 0, 0, 0, 0, 0), +(@PATH, 15, 1378.9524, 1047.5721, 53.823082, NULL, 0, 0, 0, 0, 0), +(@PATH, 16, 1377.7024, 1048.3221, 53.823082, NULL, 0, 0, 0, 0, 0), +(@PATH, 17, 1368.2705, 1049.8816, 53.36094, NULL, 0, 0, 0, 0, 0), +(@PATH, 18, 1360.7705, 1049.1316, 53.11094, NULL, 0, 0, 0, 0, 0), +(@PATH, 19, 1356.5281, 1048.5553, 53.031837, NULL, 0, 0, 0, 0, 0), +(@PATH, 20, 1355.2781, 1042.5553, 52.781837, NULL, 0, 0, 0, 0, 0); + +DELETE FROM `creature_addon` WHERE `guid` = @CGUID+12; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+12, @PATH, 0, 0, 65536, 1, 0, 0, 0, 0, 3, '83231'); + +-- Dark Ranger +UPDATE `creature` SET `MovementType`=2 WHERE `guid`=322179; + +DELETE FROM `creature_addon` WHERE `guid`=322179; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(322179, 3956090, 0, 0, 0, 258, 0, 0, 0, 0, 0, ''); + +DELETE FROM `creature_addon` WHERE `guid`=@CGUID+8; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+8, 3956320, 0, 0, 0, 258, 0, 0, 0, 0, 0, ''); + +-- Worgen Renegade +UPDATE `creature` SET `MovementType`= 1, `wander_distance`= 5 WHERE `id` = 44793; + +UPDATE `creature_template` SET `ScriptName` = 'npc_silverpine_worgen_renegade' WHERE `entry` = 44793; + +DELETE FROM `spell_script_names` WHERE `spell_id` = 80365 AND `ScriptName` = 'spell_silverpine_flurry_of_claws'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(80365, 'spell_silverpine_flurry_of_claws'); + +-- Forsaken Trooper +UPDATE `creature_template` SET `ScriptName` = 'npc_silverpine_forsaken_trooper' WHERE `entry` = 44791; + +DELETE FROM `creature_text` WHERE `CreatureID`= 44791; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(44791, 0, 0, 'Thank you, hero!', 12, 1, 100, 71, 0, 0, 44839, 0, ''), +(44791, 0, 1, 'Thanks. That beast was a handful!', 12, 1, 100, 1, 0, 0, 44835, 0, ''), +(44791, 0, 2, 'That beast came from nowhere!', 12, 1, 100, 5, 0, 0, 44836, 0, ''), +(44791, 0, 3, 'They won\'t take our land without a fight!', 12, 1, 100, 15, 0, 0, 44838, 0, ''), +(44791, 0, 4, 'Worgen filth! I spit on your corpse!', 12, 1, 100, 14, 0, 0, 44837, 0, ''); + +-- Worg +UPDATE `creature` SET `MovementType`= 1, `wander_distance`= 10 WHERE `id` = 1765; + +DELETE FROM `creature_loot_template` WHERE `Entry` = 1765 AND `Item` = 60742; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(1765, 60742, 0, 40, 1, 1, 0, 1, 1, 'Item for questId 26995'); + + -- Ferocious Grizzled Bear +UPDATE `creature` SET `MovementType`= 1, `wander_distance`= 10 WHERE `id` = 1778; + +DELETE FROM `creature_loot_template` WHERE `Entry` = 1778 AND `Item` = 60742; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(1778, 60742, 0, 49, 1, 1, 0, 1, 1, 'Item for questId 26995'); + + -- Giant Rabid Bear +UPDATE `creature` SET `MovementType` = 1, `wander_distance` = 10 WHERE `id` = 1797; + +DELETE FROM `creature_loot_template` WHERE `Entry` = 1797 AND `Item` = 60793; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(1797, 60793, 0, 40, 1, 1, 0, 1, 1, 'Item for questId 26995'); + + -- Rabid Dog +UPDATE `creature` SET `MovementType`= 1, `wander_distance`= 10 WHERE `id` = 1766; + +DELETE FROM `creature_loot_template` WHERE `Entry` = 1766 AND `Item` = 60793; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(1766, 60793, 0, 40, 1, 1, 0, 1, 1, 'Item for questId 26995'); + +-- Bat Handler Maggotbreath +UPDATE `creature_template` SET `gossip_menu_id`=11892, `AIName` = '', `ScriptName` = 'npc_silverpine_bat_handler_maggotbreath' WHERE `entry`=44825; -- Bat Handler Maggotbreath + +DELETE FROM `gossip_menu` WHERE `MenuID`=11892 AND `TextID`=16683; +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(11892, 16683, 45338); + +DELETE FROM `gossip_menu_option` WHERE `MenuID`=11892 AND `OptionID` IN (0, 1); +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextID`, `OptionNpcFlag`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(11892, 0, 0, 'I need to take a bat to the Dawning Isles.', 44905, 0, 0, 0, 0, 0, 0, NULL, 0, 45338), +(11892, 1, 0, 'Show me where I can fly.', 12271, 0, 0, 0, 0, 0, 0, NULL, 0, 45338); + +DELETE FROM `creature_text` WHERE `CreatureID`=44825 AND `GroupID`=0 AND `ID`=0; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `SoundPlayType`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(44825, 0, 0, 'You better bring that bat back in one piece, $n!', 12, 0, 100, 25, 0, 0, 0, 44906, 5, ''); + + -- Forsaken Bat +UPDATE `creature_template` SET `VehicleId` = 1051, `ScriptName` = 'npc_silverpine_forsaken_bat' WHERE `entry` = 44821; + +DELETE FROM `creature_template_movement` WHERE `CreatureId` = 44821; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Random`, `InteractionPauseTimer`) VALUES +(44821, 1, 0, 1, 0, 0, NULL); + +DELETE FROM `creature_text` WHERE `CreatureID` = 44821; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `SoundPlayType`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(44821, 0, 0, 'Eliminate all murlocs by using the Blight Concoction!$B$B|r|TInterface\\\\Icons\\\\INV_ALCHEMY_POTION_05.BLP:24|t', 42, 1, 100, 0, 0, 0, 0, 44902, 5, 'Forsaken Bat to Player'), +(44821, 1, 0, 'Returning to Forsaken High Command!$B$B|r|TInterface\\\\Icons\\\\ACHIEVEMENT_ZONE_SILVERPINE_01.BLP:24|t', 42, 1, 100, 0, 0, 0, 0, 44903, 5, 'Forsaken Bat to Player'); + +DELETE FROM `waypoint_data` WHERE `id` = 448210; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(448210, 1, 1374.36, 1029.12, 67.8815, NULL, 0, 2, 0, 0, 0), +(448210, 2, 1289.08, 1013.22, 67.8815, NULL, 0, 2, 0, 0, 0), +(448210, 3, 1224, 997.236, 59.9371, NULL, 0, 2, 0, 0, 0), +(448210, 4, 1178.72, 957.238, 47.2426, NULL, 0, 2, 0, 0, 0), +(448210, 5, 1156.5, 852.318, 42.7704, NULL, 0, 2, 0, 0, 0), +(448210, 6, 1158.1, 725.983, 42.7704, NULL, 0, 2, 0, 0, 0), +(448210, 7, 1187.67, 575.212, 46.7704, NULL, 0, 2, 0, 0, 0), +(448210, 8, 1202.33, 472.97, 65.4648, NULL, 0, 2, 0, 0, 0); + +DELETE FROM `waypoint_data` WHERE `id` = 448211; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(448211, 1, 1214.8, 414.792, 61.0968, NULL, 0, 2, 0, 0, 0), +(448211, 2, 1221.35, 323.231, 61.0968, NULL, 0, 2, 0, 0, 0), +(448211, 3, 1189.93, 281.372, 61.0968, NULL, 0, 2, 0, 0, 0), +(448211, 4, 1100.24, 212.868, 61.0968, NULL, 0, 2, 0, 0, 0), +(448211, 5, 1015.84, 188.21, 63.0412, NULL, 0, 2, 0, 0, 0), +(448211, 6, 939.417, 163.743, 61.0968, NULL, 0, 2, 0, 0, 0), +(448211, 7, 874.302, 114.092, 61.0968, NULL, 0, 2, 0, 0, 0), +(448211, 8, 831.491, 59.3177, 56.5968, NULL, 0, 2, 0, 0, 0), +(448211, 9, 770.872, 70.7726, 56.5968, NULL, 0, 2, 0, 0, 0), +(448211, 10, 759.814, 109.738, 56.5968, NULL, 0, 2, 0, 0, 0), +(448211, 11, 803.745, 181.882, 56.5968, NULL, 0, 2, 0, 0, 0), +(448211, 12, 840.674, 202.097, 56.5968, NULL, 0, 2, 0, 0, 0), +(448211, 13, 846.651, 232.344, 56.5968, NULL, 0, 2, 0, 0, 0), +(448211, 14, 805.031, 261.606, 59.9579, NULL, 0, 2, 0, 0, 0), +(448211, 15, 759.528, 265.283, 59.9579, NULL, 0, 2, 0, 0, 0), +(448211, 16, 693.755, 282.512, 59.9579, NULL, 0, 2, 0, 0, 0), +(448211, 17, 658.036, 357.233, 59.9579, NULL, 0, 2, 0, 0, 0), +(448211, 18, 639.776, 433.974, 59.9579, NULL, 0, 2, 0, 0, 0), +(448211, 19, 676.128, 470.752, 59.9579, NULL, 0, 2, 0, 0, 0), +(448211, 20, 706.495, 454.023, 59.9579, NULL, 0, 2, 0, 0, 0), +(448211, 21, 713.505, 380.88, 59.9579, NULL, 0, 2, 0, 0, 0), +(448211, 22, 726.146, 352.188, 59.9579, NULL, 0, 2, 0, 0, 0), +(448211, 23, 758.299, 321.101, 59.9579, NULL, 0, 2, 0, 0, 0), +(448211, 24, 797.684, 295.753, 58.1801, NULL, 0, 2, 0, 0, 0), +(448211, 25, 882.036, 252.597, 52.1245, NULL, 0, 2, 0, 0, 0), +(448211, 26, 929.667, 225.609, 52.1245, NULL, 0, 2, 0, 0, 0), +(448211, 27, 987.259, 219.582, 52.1245, NULL, 0, 2, 0, 0, 0), +(448211, 28, 1030.56, 276.193, 52.1245, NULL, 0, 2, 0, 0, 0), +(448211, 29, 1058.35, 308.229, 49.3745, NULL, 0, 2, 0, 0, 0), +(448211, 30, 1121.81, 372.755, 56.4579, NULL, 0, 2, 0, 0, 0), +(448211, 31, 1167.09, 438.865, 58.4857, NULL, 0, 2, 0, 0, 0), +(448211, 32, 1197.37, 451.757, 64.569, NULL, 0, 2, 0, 0, 0); + +DELETE FROM `waypoint_data` WHERE `id` = 448212; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(448212, 1, 931.068, 352.101, 81.027, NULL, 0, 2, 0, 0, 0), +(448212, 2, 952.535, 571.493, 108.303, NULL, 0, 2, 0, 0, 0), +(448212, 3, 970.028, 664.392, 110.83, NULL, 0, 2, 0, 0, 0), +(448212, 4, 1031.97, 754.155, 111.441, NULL, 0, 2, 0, 0, 0), +(448212, 5, 1234.44, 880.16, 97.9414, NULL, 0, 2, 0, 0, 0), +(448212, 6, 1345.66, 970.281, 75.1914, NULL, 0, 2, 0, 0, 0), +(448212, 7, 1415.9, 1018.08, 55.3025, NULL, 0, 2, 0, 0, 0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=83575 AND `SourceId`=0 AND `ElseGroup`=1 AND `ConditionTypeOrReference`=31 AND `ConditionTarget`=0 AND `ConditionValue1`=3 AND `ConditionValue2`=1908 AND `ConditionValue3`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 83575, 0, 1, 31, 0, 3, 1908, 0, 0, 0, 0, '', 'Blight Concoction - Target Vile Fin Oracle'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=83575 AND `SourceId`=0 AND `ElseGroup`=2 AND `ConditionTypeOrReference`=31 AND `ConditionTarget`=0 AND `ConditionValue1`=3 AND `ConditionValue2`=1768 AND `ConditionValue3`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 83575, 0, 2, 31, 0, 3, 1768, 0, 0, 0, 0, '', 'Blight Concoction - Target Vile Fin Tidehunter'); + +-- Lake Frenzy + UPDATE `creature` SET `MovementType` = 1, `wander_distance` = 10 WHERE `id` = 6033; + +-- Vile Fin Oracle +UPDATE `creature` SET `MovementType` = 1, `wander_distance` = 10 WHERE `id` = 1908; + +DELETE FROM `creature_template_movement` WHERE `CreatureId` = 1908; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Random`, `InteractionPauseTimer`) VALUES +(1908, 1, 1, 0, 0, 2, NULL); + +-- Vile Fin Tidehunter +UPDATE `creature` SET `MovementType` = 1, `wander_distance` = 10 WHERE `id` = 1768; + +DELETE FROM `creature_template_movement` WHERE `CreatureId` = 1768; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Random`, `InteractionPauseTimer`) VALUES +(1768, 1, 1, 0, 0, 2, NULL); + +-- Deathstalker Commander Belmont +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30, `ScriptName`='npc_silverpine_deathstalker' WHERE `entry`=44789; -- Deathstalker Commander Belmont + +DELETE FROM `creature_template_addon` WHERE `entry` =44789; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(44789, 0, 0, 0, 65544, 1, 0, 0, 0, 0, 0, '83231'); + +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` =44789); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(44789, 0, 0, 0, 7, 45338); + +-- Deathstalker +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30, `ScriptName`='npc_silverpine_deathstalker' WHERE `entry`=44790; -- Deathstalker + +DELETE FROM `creature_template_addon` WHERE `entry` =44790; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(44790, 0, 0, 0, 65544, 1, 0, 0, 0, 0, 0, '83231'); + +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` =44790); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(44790, 0, 0, 0, 7, 45338); + +-- Apothecary Witherbloom +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=44778; -- Apothecary Witherbloom + +DELETE FROM `creature_template_addon` WHERE `entry` =44778; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(44778, 0, 0, 0, 257, 133, 0, 0, 0, 0, ''); -- 44778 (Apothecary Witherbloom) + +-- Apothecary Chase +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=45489; -- Apothecary Chase + +DELETE FROM `creature_template_addon` WHERE `entry` =45489; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(45489, 0, 0, 0, 257, 133, 0, 0, 0, 0, ''); -- 45489 (Apothecary Chase) + +-- Apothecary Marry +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=45490; -- Apothecary Marry + +DELETE FROM `creature_template_addon` WHERE `entry` =45490; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(45490, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''); -- 45490 (Apothecary Marry) + +DELETE FROM `npc_vendor` WHERE (`entry`=45489 AND `item`=183950 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45489 AND `item`=3371 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=20815 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=39354 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=2324 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=2604 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=6260 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=2605 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=6530 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=6529 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=4289 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=2880 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=2678 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=2321 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=2320 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=3371 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=6217 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=6256 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=39505 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=5956 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=85663 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=45490 AND `item`=7005 AND `ExtendedCost`=0 AND `type`=1); +INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES +(45489, 2, 183950, 0, 0, 1, 0, 0, 45338), -- Distilled Death Extract +(45489, 1, 3371, 0, 0, 1, 0, 0, 45338), -- Crystal Vial +(45490, 21, 20815, 0, 0, 1, 0, 0, 45338), -- Jeweler's Kit +(45490, 20, 39354, 0, 0, 1, 0, 0, 45338), -- Light Parchment +(45490, 19, 2324, 0, 0, 1, 0, 0, 45338), -- Bleach +(45490, 18, 2604, 0, 0, 1, 0, 0, 45338), -- Red Dye +(45490, 17, 6260, 0, 0, 1, 0, 0, 45338), -- Blue Dye +(45490, 16, 2605, 0, 0, 1, 0, 0, 45338), -- Green Dye +(45490, 15, 6530, 0, 0, 1, 0, 0, 45338), -- Nightcrawlers +(45490, 14, 6529, 0, 0, 1, 0, 0, 45338), -- Shiny Bauble +(45490, 13, 4289, 0, 0, 1, 0, 0, 45338), -- Salt +(45490, 12, 2880, 0, 0, 1, 0, 0, 45338), -- Weak Flux +(45490, 11, 2678, 0, 0, 1, 0, 0, 45338), -- Mild Spices +(45490, 10, 2321, 0, 0, 1, 0, 0, 45338), -- Fine Thread +(45490, 9, 2320, 0, 0, 1, 0, 0, 45338), -- Coarse Thread +(45490, 8, 3371, 0, 0, 1, 0, 0, 45338), -- Crystal Vial +(45490, 7, 6217, 0, 0, 1, 0, 0, 45338), -- Copper Rod +(45490, 6, 6256, 0, 0, 1, 0, 0, 45338), -- Fishing Pole +(45490, 5, 39505, 0, 0, 1, 0, 0, 45338), -- Virtuoso Inking Set +(45490, 4, 5956, 0, 0, 1, 0, 0, 45338), -- Blacksmith Hammer +(45490, 3, 2901, 0, 0, 1, 0, 0, 45338), -- Mining Pick +(45490, 2, 85663, 0, 0, 1, 0, 0, 45338), -- Herbalist's Spade +(45490, 1, 7005, 0, 0, 1, 0, 0, 45338); -- Skinning Knife + +-- Apothecary Harrington +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=45491; -- Apothecary Harrington + +DELETE FROM `creature_template_addon` WHERE `entry` =45491; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(45491, 0, 0, 0, 257, 133, 0, 0, 0, 0, ''); -- 45491 (Apothecary Harrington) + +-- High Apothecary Shana T'veen +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=44784; -- High Apothecary Shana T'veen + +DELETE FROM `creature_template_addon` WHERE `entry` =44784; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(44784, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''); + +-- Apothecary Initiate +DELETE FROM `creature_template_addon` WHERE `entry` =44786; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(44786, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''); -- 44786 (Apothecary Initiate) + +DELETE FROM `creature_addon` WHERE `guid` IN (@CGUID+28, @CGUID+31, @CGUID+34); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+28, 0, 0, 0, 0, 257, 133, 0, 0, 0, 0, ''), +(@CGUID+31, 0, 0, 0, 0, 257, 133, 0, 0, 0, 0, ''), +(@CGUID+34, 0, 0, 0, 0, 257, 133, 0, 0, 0, 0, ''); diff --git a/src/server/scripts/EasternKingdoms/zone_silverpine_forest.cpp b/src/server/scripts/EasternKingdoms/zone_silverpine_forest.cpp index 34510d86bff..c68d3abeb6b 100644 --- a/src/server/scripts/EasternKingdoms/zone_silverpine_forest.cpp +++ b/src/server/scripts/EasternKingdoms/zone_silverpine_forest.cpp @@ -38,6 +38,7 @@ #include "TemporarySummon.h" #include "Unit.h" #include "Vehicle.h" +#include "WorldSession.h" Position const OrgrimmarPortalPos[3] = { @@ -902,6 +903,7 @@ class spell_silverpine_forsaken_trooper_masterscript_high_command : public Spell caster->RemoveAura(SPELL_FEIGNED); uint32 spellId = SPELL_FORSAKEN_TROOPER_MALE_01_HC; + switch (caster->GetDisplayId()) { case DISPLAY_MALE_01_HC: @@ -931,6 +933,7 @@ class spell_silverpine_forsaken_trooper_masterscript_high_command : public Spell default: break; } + caster->CastSpell(caster, spellId, true); } } @@ -941,10 +944,465 @@ class spell_silverpine_forsaken_trooper_masterscript_high_command : public Spell } }; +enum SylvanasForsakenHighCommand +{ + NPC_FORSAKEN_WARHORSE = 73595, + + SPELL_SUMMON_FORSAKEN_WARHORSE = 148164, + SPELL_APPLY_INVIS_ZONE_1 = 83231, + SPELL_APPLY_INVIS_ZONE_4 = 84183 +}; + +// Lady Sylvanas Windrunner (Forsaken High Command) - 44365 +struct npc_silverpine_sylvanas_windrunner_high_command : public ScriptedAI +{ + npc_silverpine_sylvanas_windrunner_high_command(Creature* creature) : ScriptedAI(creature) { } + + void JustAppeared() override + { + DoCastSelf(SPELL_SUMMON_FORSAKEN_WARHORSE); + + // Note: the Forsaken Horse must be set in the same visibility mask that Sylvanas is in. + if (Creature* forsakenWarhorse = me->FindNearestCreature(NPC_FORSAKEN_WARHORSE, 5.0f, true)) + forsakenWarhorse->CastSpell(forsakenWarhorse, me->HasAura(SPELL_APPLY_INVIS_ZONE_1) ? SPELL_APPLY_INVIS_ZONE_1 : SPELL_APPLY_INVIS_ZONE_4, true); + } +}; + +// Deathstalker and Deathstalker Commander Belmont - 44789, 44790 +struct npc_silverpine_deathstalker : public ScriptedAI +{ + npc_silverpine_deathstalker(Creature* creature) : ScriptedAI(creature) { } + + void JustAppeared() override + { + // @TODO: figure out some common thing why powertype energy is used here + me->SetPowerType(POWER_ENERGY); + me->SetMaxPower(POWER_ENERGY, 100); + me->SetPower(POWER_ENERGY, 100, true); + } +}; + +enum WorgenRenegade +{ + SPELL_HEARTSTRIKE = 84182, + SPELL_KILL_ME_AURA = 84181, + SPELL_FLURRY_OF_CLAWS = 80365, + + EVENT_FLURRY_OF_CLAWS = 1 +}; + +// Worgen Renegade - 44793 +struct npc_silverpine_worgen_renegade : public ScriptedAI +{ + npc_silverpine_worgen_renegade(Creature* creature) : ScriptedAI(creature) { } + + void Reset() override + { + _events.Reset(); + + // Note: this is for a later usage during Lordaeron (questId 27098). + if (me->IsSummon()) + DoCastSelf(SPELL_KILL_ME_AURA); + + me->SetReactState(REACT_AGGRESSIVE); + } + + void DamageTaken(Unit* attacker, uint32& damage, DamageEffectType /*damageType*/, SpellInfo const* /*spellInfo = nullptr*/) override + { + // HACKFIX: sparring system is not implemented yet. + if (!attacker->IsPlayer() && me->HealthBelowPctDamaged(80.0f, damage)) + damage = 0; + } + + void JustEngagedWith(Unit* /*who*/) override + { + _events.ScheduleEvent(EVENT_FLURRY_OF_CLAWS, 3s); + } + + void UpdateAI(uint32 diff) override + { + if (!UpdateVictim()) + return; + + _events.Update(diff); + + while (uint32 eventId = _events.ExecuteEvent()) + { + switch (eventId) + { + case EVENT_FLURRY_OF_CLAWS: + DoCastVictim(SPELL_FLURRY_OF_CLAWS); + _events.Repeat(15s, 18s); + break; + + default: + break; + } + } + + DoMeleeAttackIfReady(); + } + +private: + EventMap _events; +}; + +// Flurry of Claws - 80365 +class spell_silverpine_flurry_of_claws : public AuraScript +{ + PrepareAuraScript(spell_silverpine_flurry_of_claws); + + bool Validate(SpellInfo const* spellInfo) override + { + return ValidateSpellInfo({ spellInfo->GetEffect(EFFECT_0).TriggerSpell }); + } + + void HandlePeriodic(AuraEffect const* /*aurEff*/) + { + GetTarget()->CastSpell(nullptr, GetSpellInfo()->GetEffect(EFFECT_0).TriggerSpell, true); + } + + void Register() override + { + OnEffectPeriodic += AuraEffectPeriodicFn(spell_silverpine_flurry_of_claws::HandlePeriodic, EFFECT_0, SPELL_AURA_PERIODIC_DUMMY); + } +}; + +enum ForsakenTrooper +{ + NPC_WORGEN_RENEGADE = 44793, + + SPELL_CLEAVE = 19983, + + EVENT_CLEAVE = 1, + + TALK_TROOPER_RESET = 0 +}; + +// Forsaken Trooper - 44791, 44792 +struct npc_silverpine_forsaken_trooper : public ScriptedAI +{ + npc_silverpine_forsaken_trooper(Creature* creature) : ScriptedAI(creature) { } + + void Reset() override + { + _events.Reset(); + + // Note: these texts are not sent by summoned creatures from Lordaeron (questId 27098). + if (!me->IsSummon()) + { + if (urand(0, 1)) + Talk(TALK_TROOPER_RESET); + } + } + + void DamageTaken(Unit* attacker, uint32& damage, DamageEffectType /*damageType*/, SpellInfo const* /*spellInfo = nullptr*/) override + { + // HACKFIX: sparring system is not implemented yet. + if (!attacker->IsPlayer() && me->HealthBelowPctDamaged(80.0f, damage)) + damage = 0; + } + + void JustEngagedWith(Unit* /*who*/) override + { + _events.ScheduleEvent(EVENT_CLEAVE, 5s, 8s); + } + + void UpdateAI(uint32 diff) override + { + if (!UpdateVictim()) + return; + + _events.Update(diff); + + while (uint32 eventId = _events.ExecuteEvent()) + { + switch (eventId) + { + case EVENT_CLEAVE: + DoCastVictim(SPELL_CLEAVE); + _events.Repeat(5s, 8s); + break; + + default: + break; + } + } + + DoMeleeAttackIfReady(); + } + +private: + EventMap _events; +}; + +enum BatHandlerMaggothbreath +{ + QUEST_ITERATING_UPON_SUCCESS = 26998, + + SPELL_SUMMON_FORSAKEN_BAT = 83584, + + TALK_MAGGOTHBREATH_ITERATING_UPON_SUCCESS = 0, + + DATA_GOSSIP_MENU_MAGGOT = 11892 +}; + +// Bat Handler Maggotbreath - 44825 +struct npc_silverpine_bat_handler_maggotbreath : public ScriptedAI +{ + npc_silverpine_bat_handler_maggotbreath(Creature* creature) : ScriptedAI(creature) { } + + bool OnGossipHello(Player* player) override + { + if (player->GetQuestStatus(QUEST_ITERATING_UPON_SUCCESS) == QUEST_STATUS_INCOMPLETE) + AddGossipItemFor(player, DATA_GOSSIP_MENU_MAGGOT, 0, GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF); + + if (me->IsTaxi()) + AddGossipItemFor(player, DATA_GOSSIP_MENU_MAGGOT, 1, GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF + 1); + + SendGossipMenuFor(player, player->GetGossipTextId(me), me->GetGUID()); + return true; + } + + bool OnGossipSelect(Player* player, uint32 /*menuId*/, uint32 gossipListId) override + { + switch (player->PlayerTalkClass->GetGossipOptionAction(gossipListId)) + { + case GOSSIP_ACTION_INFO_DEF: + Talk(TALK_MAGGOTHBREATH_ITERATING_UPON_SUCCESS, player); + player->CastSpell(player, SPELL_SUMMON_FORSAKEN_BAT, true); + break; + + // Note: Blizzard messed up this OptionNpc. It sends GossipOptionNpc::None rather than GossipOptionNpc::TaxiNode, + // making it useless. To keep it blizzlike, we're just sending TaxiMenu forcefully as well. + case GOSSIP_ACTION_INFO_DEF + 1: + player->GetSession()->SendTaxiMenu(me); + break; + + default: + break; + } + + CloseGossipMenuFor(player); + return true; + } +}; + +enum ForsakenBat +{ + NPC_VILE_FIN_ORACLE = 1908, + NPC_BAT_HANDLER_MAGGOTBREATH = 44825, + NPC_FORSAKEN_BAT = 44821, + + SPELL_BLIGHT_CONCOCTION = 83573, + SPELL_GO_HOME = 83594, + + EVENT_CHECK_FINISH_ITERATING = 1, + EVENT_START_MOVEMENT_ITERATING = 2, + EVENT_GO_HOME_ITERATING = 3, + + ACTION_GO_HOME = 1, + + TALK_BAT_ARRIVED_TO_ISLE = 0, + TALK_BAT_GOING_HOME = 1, + + PATH_BAT_TO_LAKE = 448210, + PATH_BAT_AROUND_LAKE = 448211, + PATH_BAT_TO_HOME = 448212, + + WAYPOINT_LAST_POINT_TO_LAKE = 8, + WAYPOINT_LAST_POINT_AROUND_LAKE = 32, + WAYPOINT_LAST_POINT_TO_HOME = 7, + + DATA_ITERATING_UPON_SUCCESS_QUEST_REQ = 50 +}; + +// Forsaken Bat - 44821 +struct npc_silverpine_forsaken_bat : public VehicleAI +{ + npc_silverpine_forsaken_bat(Creature* creature) : VehicleAI(creature) + { + Initialize(); + } + + void Initialize() + { + SetInitialActionBar(); + } + + void IsSummonedBy(WorldObject* summoner) override + { + if (Player* player = summoner->ToPlayer()) + _playerGUID = player->GetGUID(); + + me->SetDisableGravity(true); + } + + void PassengerBoarded(Unit* passenger, int8 /*seatId*/, bool apply) override + { + if (apply) + { + if (Player* player = passenger->ToPlayer()) + { + if (player->GetQuestStatus(QUEST_ITERATING_UPON_SUCCESS) == QUEST_STATUS_INCOMPLETE) + { + player->KilledMonsterCredit(NPC_BAT_HANDLER_MAGGOTBREATH); + + me->SetUnitFlag(UNIT_FLAG_UNINTERACTIBLE); + + me->SetSpeed(UnitMoveType::MOVE_RUN, 17.794235f); + me->GetMotionMaster()->MovePath(PATH_BAT_TO_LAKE, false); + + _events.ScheduleEvent(EVENT_CHECK_FINISH_ITERATING, 500ms); + } + } + } + } + + void WaypointReached(uint32 waypointId, uint32 pathId) override + { + switch (pathId) + { + case PATH_BAT_TO_LAKE: + { + if (waypointId == WAYPOINT_LAST_POINT_TO_LAKE) + { + me->SetSpeed(UnitMoveType::MOVE_RUN, 17.982668f); + me->GetMotionMaster()->MovePath(PATH_BAT_AROUND_LAKE, false); + + SetCircularActionBar(); + + if (Player* player = ObjectAccessor::GetPlayer(*me, _playerGUID)) + { + Talk(TALK_BAT_ARRIVED_TO_ISLE, player); + + player->VehicleSpellInitialize(); + } + } + break; + } + + case PATH_BAT_AROUND_LAKE: + { + if (waypointId == WAYPOINT_LAST_POINT_AROUND_LAKE) + { + if (Player* player = ObjectAccessor::GetPlayer(*me, _playerGUID)) + { + if (player->GetQuestStatus(QUEST_ITERATING_UPON_SUCCESS) == QUEST_STATUS_INCOMPLETE) + me->GetMotionMaster()->MovePath(PATH_BAT_AROUND_LAKE, false); + } + } + break; + } + + case PATH_BAT_TO_HOME: + { + if (waypointId == WAYPOINT_LAST_POINT_TO_HOME) + { + me->GetVehicleKit()->RemoveAllPassengers(); + me->DespawnOrUnsummon(); + } + break; + } + + default: + break; + } + } + + void SpellHit(WorldObject* /*caster*/, SpellInfo const* spellInfo) override + { + if (spellInfo->Id == SPELL_GO_HOME) + DoAction(ACTION_GO_HOME); + } + + void DoAction(int32 param) override + { + switch (param) + { + case ACTION_GO_HOME: + { + if (Player* player = ObjectAccessor::GetPlayer(*me, _playerGUID)) + { + me->PauseMovement(); + me->GetMotionMaster()->Clear(); + me->SetSpeed(UnitMoveType::MOVE_RUN, 35.78791f); + me->GetMotionMaster()->MovePath(PATH_BAT_TO_HOME, false); + + SetFinishActionBar(); + + player->VehicleSpellInitialize(); + + Talk(TALK_BAT_GOING_HOME, player); + } + break; + } + + default: + break; + } + } + + void UpdateAI(uint32 diff) override + { + _events.Update(diff); + + while (uint32 eventId = _events.ExecuteEvent()) + { + switch (eventId) + { + case EVENT_CHECK_FINISH_ITERATING: + { + if (Player* player = ObjectAccessor::GetPlayer(*me, _playerGUID)) + { + if (player->GetReqKillOrCastCurrentCount(QUEST_ITERATING_UPON_SUCCESS, NPC_VILE_FIN_ORACLE) == DATA_ITERATING_UPON_SUCCESS_QUEST_REQ) + player->CastSpell(me, SPELL_GO_HOME, true); + else + _events.ScheduleEvent(EVENT_CHECK_FINISH_ITERATING, 500ms); + } + break; + } + + default: + break; + } + } + } + + void SetInitialActionBar() + { + me->m_spells[0] = SPELL_BLIGHT_CONCOCTION; + me->m_spells[1] = 0; + } + + void SetCircularActionBar() + { + me->m_spells[0] = SPELL_BLIGHT_CONCOCTION; + me->m_spells[1] = SPELL_GO_HOME; + } + + void SetFinishActionBar() + { + me->m_spells[0] = 0; + me->m_spells[1] = 0; + } + +private: + EventMap _events; + ObjectGuid _playerGUID; +}; + void AddSC_silverpine_forest() { RegisterCreatureAI(npc_silverpine_grand_executor_mortuus); RegisterSpellScript(spell_silverpine_raise_forsaken_83173); RegisterCreatureAI(npc_silverpine_fallen_human); RegisterSpellScript(spell_silverpine_forsaken_trooper_masterscript_high_command); + RegisterCreatureAI(npc_silverpine_sylvanas_windrunner_high_command); + RegisterCreatureAI(npc_silverpine_deathstalker); + RegisterCreatureAI(npc_silverpine_worgen_renegade); + RegisterSpellScript(spell_silverpine_flurry_of_claws); + RegisterCreatureAI(npc_silverpine_forsaken_trooper); + RegisterCreatureAI(npc_silverpine_bat_handler_maggotbreath); + RegisterCreatureAI(npc_silverpine_forsaken_bat); } |