Retriman

SELECT * FROM `creature` WHERE `id` IN (37221,37223);
SELECT * FROM `gameobject` WHERE `id` IN ( 201385, 201885, 202396, 500001, 201596, 201709, 500002, 202211, 500003, 202079, 202212, 201710, 202337, 202336 );
SELECT * FROM `gameobject` WHERE `id` IN (201709, 500002, 202211, 500003);
SELECT * FROM `gameobject_template` WHERE `entry` IN (201709, 500002, 202211, 500003);
SELECT * FROM `gameobject_template` WHERE `entry` IN (201385,201885,202396,500001,201596);
SELECT * FROM `creature_template` WHERE `entry` =36955; -- Lady Proudmoore part 1

Retriman

insert into `` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) 
values
('133973','37215','673','0','0','15','1','31044','0','3.8386','0.183334','24.1005','0','604800','0','0','1','0','0','0','0','0','0'),
('133934','37540','672','0','0','15','1','31043','0','-13.1429','-0.36969','12.8909','0','604800','0','0','1','0','0','0','0','0','0');

Retriman

178746 - Smokywood Pastures
178666 - Gypsy Wagon
178671 - Greatfather Winter's Chair
178649 - Wreath scale 0.75
178437 - Wreath scale 1.00
178556 - Wreath scale 1.20
178647 - Christmas Tree (Medium)
178557 - Christmas Tree (Medium)
178426 - Christmas Tree (Large) (Horde)

Retriman

@@ -298,10 +298,13 @@ void BattlefieldWG::OnBattleStart()
     SendWarningToAllInZone(BATTLEFIELD_WG_TEXT_START);
 }
 
 void BattlefieldWG::UpdateCounterVehicle(bool init)
 {
+    if (!IsWarTime())
+        return;
+
     if (init)

Retriman

@@ -395,6 +395,31 @@ void BattlefieldWG::OnBattleEnd(bool endByTimer)
         {
             player->CastSpell(player, SPELL_ESSENCE_OF_WINTERGRASP, true);
             player->CastSpell(player, SPELL_VICTORY_REWARD, true);
+            if (m_Data32[BATTLEFIELD_WG_DATA_DAMAGED_TOWER_DEF])
+            {
+                player->CastSpell(player, SPELL_DAMAGED_BUILDING, true);
+            }
+            else
+            {

Retriman

@@ -2683,34 +2683,34 @@ void SpellMgr::LoadSpellCustomAttr()
                 case SPELL_AURA_MOD_FEAR:
                 case SPELL_AURA_MOD_STUN:
                     spellInfo->AttributesCu |= SPELL_ATTR0_CU_AURA_CC;
                     break;
                 case SPELL_AURA_PERIODIC_HEAL:
+                case SPELL_AURA_PERIODIC_DAMAGE:
                 case SPELL_AURA_PERIODIC_DAMAGE_PERCENT:
                 case SPELL_AURA_PERIODIC_LEECH:
+                case SPELL_AURA_PERIODIC_TRIGGER_SPELL:

Retriman

--- a/src/server/scripts/Northrend/icecrown.cpp
+++ b/src/server/scripts/Northrend/icecrown.cpp
@@ -493,6 +493,353 @@ class npc_tournament_training_dummy : public CreatureScript
 
 };
 
+
+/*######
+## npc_faction_valiant_champion
+######*/

Retriman

@@ -491,14 +491,362 @@ class npc_tournament_training_dummy : public CreatureScript
             return new npc_tournament_training_dummyAI(creature);
         }
 
 };
 
+
+/*######
+## npc_faction_valiant_champion
+######*/

Retriman

@@ -3474,11 +3474,11 @@ void Unit::_UnapplyAura(AuraApplicationMap::iterator &i, AuraRemoveMode removeMo
 
     // all effect mustn't be applied
     ASSERT(!aurApp->GetEffectMask());
 
     // Remove totem at next update if totem loses its aura
-    if (aurApp->GetRemoveMode() == AURA_REMOVE_BY_EXPIRE && GetTypeId() == TYPEID_UNIT && ToCreature()->isTotem()&& ToTotem()->GetSummonerGUID() == aura->GetCasterGUID())
+    if (aurApp->GetRemoveMode() == AURA_REMOVE_BY_EXPIRE && GetTypeId() == TYPEID_UNIT && ToCreature()->isTotem())
     {
         if (ToTotem()->GetSpell() == aura->GetId() && ToTotem()->GetTotemType() == TOTEM_PASSIVE)

Retriman

@@ -23,65 +23,74 @@ enum Yells
 {
     SAY_AGGRO       = 0,
     SAY_SLAY        = 1,
     SAY_DEATH       = 2,
     SAY_EGG_SAC     = 3,
-    EMOTE_HATCHES   = 4
+    EMOTE_HATCHES   = 4 
 };