sirikfoll

-- Add missing spawns,misc changes gameobjects/creatures related to Midsummer event
SET @CGUID = xxxxxx; -- 168 Required
SET @OGUID = xxxxxx; -- 419 Required

UPDATE `gameobject` SET `position_x`=-7596.67, `position_y`=-2079.81, `position_z`=125.968, `orientation`=3.20786, `rotation2`=0.999451, `rotation3`=-0.0331301 WHERE `guid`=52517 AND `id`=188021;
UPDATE `gameobject` SET `position_x`=-7591.5, `position_y`=-2080.49, `position_z`=126.518 WHERE `guid`=50934 AND `id`=181307;
UPDATE `creature` SET `orientation`=3.14884 WHERE `guid`=202758;
UPDATE `creature` SET `modelid`=21085 WHERE `guid`=202746;
UPDATE `creature` SET `modelid`=21086 WHERE `guid`=202749;
UPDATE `creature` SET `modelid`=16436 WHERE `guid`=202748;

sirikfoll

SET @CCGUID := xxxxxx; -- 15 required
SET @OOGUID := xxxxxx; -- 15 required
SET @CGUID := xxxxxx; -- 168 Required
SET @OGUID := xxxxxx; -- 419 Required

-- Set Earthen Ring Elder ID: 26221 friendly to both factions
UPDATE `creature_template` SET `faction`=35 WHERE `entry`=26221;
UPDATE `quest_template` SET `Method`=2, `MaxLevel`=28,`PrevQuestId`=12012 WHERE `Id`=11917; -- Striking Back
UPDATE `quest_template` SET `Method`=2, `MaxLevel`=38,`PrevQuestId`=12012 WHERE `Id`=11947; -- -//-
UPDATE `quest_template` SET `Method`=2, `MaxLevel`=48,`PrevQuestId`=12012 WHERE `Id`=11948; -- -//-

sirikfoll

UPDATE `creature_template` SET  `minlevel`=82,`maxlevel`=82, `ScriptName`='boss_ahune' WHERE `entry`=25740;-- Ahune
UPDATE `creature_template` SET  `minlevel`=80,`maxlevel`=80, `AIName`='SmartAI' WHERE `entry`=25755;-- Ahunite Hailstone
UPDATE `creature_template` SET  `minlevel`=80,`maxlevel`=80, `AIName`='SmartAI' WHERE `entry`=25756;-- Ahunite Coldwave
UPDATE `creature_template` SET  `minlevel`=80,`maxlevel`=80, `AIName`='SmartAI' WHERE `entry`=25757;-- Ahunite Frostwind
UPDATE `creature_template` SET  `minlevel`=80,`maxlevel`=80, `ScriptName`='npc_frozen_core' WHERE `entry`=25865;-- Frozen Core
UPDATE `creature_template` SET `ScriptName`='npc_ahune_bunny' WHERE `entry`=25745;
UPDATE `creature_template` SET `ScriptName`='npc_ice_spear_bunny' WHERE `entry`=25985;
UPDATE `creature_template` SET  `DamageModifier`=10,`HealthModifier`=13, `AIName`='SmartAI' WHERE `entry`=40446;
UPDATE `gameobject_template` SET `ScriptName`='go_ahune_ice_stone' WHERE `entry`=187882;

sirikfoll

-- Add support for Torch Tossing and More Torch Tossing quests
SET @CGUID := xxxxxx; -- 43 required
SET @TTrigger := -(@CGUID+35);
SET @OTrigger := -(@CGUID+36);
SET @UTrigger := -(@CGUID+37);
SET @STrigger := -(@CGUID+38);
SET @SWTrigger := -(@CGUID+39);
SET @ITrigger := -(@CGUID+40);
SET @DTrigger := -(@CGUID+41);
SET @ETrigger := -(@CGUID+42);

sirikfoll

enum TorchSpells
{
    SPELL_TORCH_TOSSING_TRAINING = 45716,
    SPELL_TORCH_TOSSING_PRACTICE = 46630,
    SPELL_TORCH_TOSSING_TRAINING_SUCCESS_ALLIANCE = 45719,
    SPELL_TORCH_TOSSING_TRAINING_SUCCESS_HORDE = 46651,
    SPELL_BRAZIERS_HIT = 45724
};
 
// 45724 - Braziers Hit!

sirikfoll

diff --git a/src/server/scripts/World/go_scripts.cpp b/src/server/scripts/World/go_scripts.cpp
index f3accdf..9aad8c3 100644
--- a/src/server/scripts/World/go_scripts.cpp
+++ b/src/server/scripts/World/go_scripts.cpp
@@ -50,6 +50,7 @@ EndContentData */
 #include "Spell.h"
 #include "Player.h"
 #include "WorldSession.h"
+#include "AchievementMgr.h"
 

sirikfoll

diff --git a/src/server/scripts/Spells/spell_holiday.cpp b/src/server/scripts/Spells/spell_holiday.cpp
index 93e1366..25dc112 100644
--- a/src/server/scripts/Spells/spell_holiday.cpp
+++ b/src/server/scripts/Spells/spell_holiday.cpp
@@ -824,6 +824,224 @@ class spell_brewfest_barker_bunny : public SpellScriptLoader
         }
 };
 
+enum TorchSpells
+{

sirikfoll

SET @CGUID := xxxx; -- 21 Guids de Creature
SET @OGUID := xxxx; -- 76 Guids de Objeto

-- Quest Striking Back
DELETE FROM `gameobject_template` WHERE `entry` IN (188134,188135,188139,188145,188146,188147);
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `data1`, `data2`, `data3`, `data6`) VALUES
(188134, 2, 7666, 'Ice Stone', 0, 3, 9258, 0), -- /Ice stone/ this is a proven missing gameobject and the data is as of 11723 same model one taken from
(188135, 2, 7666, 'Ice Stone', 0, 3, 9259, 0), -- /Ice stone/ this is a proven missing gameobject and the data is as of 11723 same model one taken from
(188139, 2, 7666, 'Ice Stone', 0, 3, 9260, 0), -- /Ice stone/ this is a proven missing gameobject and the data is as of 11723 same model one taken from
(188145, 2, 7666, 'Ice Stone', 0, 3, 9266, 0), -- /Ice stone/ this is a proven missing gameobject and the data is as of 11723 same model one taken from

sirikfoll

enum ErisHavenfireSays
{
    SAY_DEATH       = 0,
    SAY_SPAWN       = 1,
    SAY_SAVED       = 2,
    SAY_EMPOWER     = 0,
    SAY_COMPLETE    = 1,
    SAY_FAILED1     = 2,
    SAY_FAILED2     = 3
};

sirikfoll

# TrinityCore - WowPacketParser
# File name: Kilohertz2.pkt
# Detected build: V6_2_4_21463
# Detected locale: ptBR
# Targeted database: WrathOfTheLichKing
# Parsing date: 03/04/2019 00:39:07

-- .go xyz 7641 2061 600 571
-- Spawn Alliance Infragreen airbase