Demonid

From b86040a5b96460748af8c3949ffd1ad18a9a6bc2 Mon Sep 17 00:00:00 2001
From: walkline <walkline.ua@gmail.com>
Date: Sun, 3 Jun 2012 15:29:04 +0300
Subject: [PATCH] Implemented Arena Spectator.


diff --git a/sql/updates/fc_updates_world/arena_spectator.sql b/sql/updates/fc_updates_world/arena_spectator.sql
new file mode 100644
index 0000000..280de81
--- /dev/null

Demonid

From 64ec1da49d233ab40c04b6b13698d038cf6729f5 Mon Sep 17 00:00:00 2001
From: irancore <amir.cinderella@gmail.com>
Date: Fri, 7 Jul 2017 20:43:23 +0430
Subject: [PATCH] Crossfaction Complete Fixed

---
 src/server/database/Database/MySQLConnection.cpp   |   4 +-
 src/server/game/Battlegrounds/Arena.cpp            |   4 +-
 src/server/game/Battlegrounds/Battleground.cpp     |  53 ++--
 src/server/game/Battlegrounds/Battleground.h       |   2 +-

Demonid

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname

Demonid

diff --git a/src/server/scripts/Northrend/ChamberOfAspects/RubySanctum/boss_halion.cpp b/src/server/scripts/Northrend/ChamberOfAspects/RubySanctum/boss_halion.cpp
index c02d617..fd5f654 100644
--- a/src/server/scripts/Northrend/ChamberOfAspects/RubySanctum/boss_halion.cpp
+++ b/src/server/scripts/Northrend/ChamberOfAspects/RubySanctum/boss_halion.cpp
@@ -25,6 +25,7 @@
 #include "ScriptedCreature.h"
 #include "ruby_sanctum.h"
 #include "Player.h"
+#include "MoveSplineInit.h"
 

Demonid

diff --git a/sql/updates/world/DontLookUp.sql b/sql/updates/world/DontLookUp.sql
new file mode 100644
index 0000000..824655e
--- /dev/null
+++ b/sql/updates/world/DontLookUp.sql
@@ -0,0 +1,10 @@
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=12994 AND `type`=18;
+UPDATE `creature_template` SET `ScriptName`='npc_pit_of_saron_icicle' WHERE `entry`=32780;
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_pos_ice_shards';
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES

Demonid

diff --git a/src/server/game/Maps/Map.h b/src/server/game/Maps/Map.h
index 5f13461..8f745d7 100644
--- a/src/server/game/Maps/Map.h
+++ b/src/server/game/Maps/Map.h
@@ -419,6 +419,7 @@ class TC_GAME_API Map : public GridRefManager<NGridType>
 
         bool HavePlayers() const { return !m_mapRefManager.isEmpty(); }
         uint32 GetPlayersCountExceptGMs() const;
+        uint32 GetAlivePlayersCountExceptGMs() const;
         bool ActiveObjectsNearGrid(NGridType const& ngrid) const;

Demonid

diff --git a/src/server/game/Entities/Creature/Creature.cpp b/src/server/game/Entities/Creature/Creature.cpp
index 5d62b74..8ee326a 100644
--- a/src/server/game/Entities/Creature/Creature.cpp
+++ b/src/server/game/Entities/Creature/Creature.cpp
@@ -183,7 +183,8 @@ m_lootRecipient(), m_lootRecipientGroup(0), _skinner(), _pickpocketLootRestore(0
 m_respawnDelay(300), m_corpseDelay(60), m_respawnradius(0.0f), m_boundaryCheckTime(2500), m_combatPulseTime(0), m_combatPulseDelay(0), m_reactState(REACT_AGGRESSIVE),
 m_defaultMovementType(IDLE_MOTION_TYPE), m_spawnId(0), m_equipmentId(0), m_originalEquipmentId(0), m_AlreadyCallAssistance(false),
 m_AlreadySearchedAssistance(false), m_regenHealth(true), m_AI_locked(false), m_meleeDamageSchoolMask(SPELL_SCHOOL_MASK_NORMAL),
-m_originalEntry(0), m_homePosition(), m_transportHomePosition(), m_creatureInfo(NULL), m_creatureData(NULL), m_waypointID(0), m_path_id(0), m_formation(NULL)
+m_originalEntry(0), m_homePosition(), m_transportHomePosition(), m_creatureInfo(NULL), m_

Demonid

-- 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;

Demonid

@@ -5525,7 +5534,7 @@ bool Player::CanJoinConstantChannelInZone(ChatChannelsEntry const* channel, Area
     if (channel->flags & CHANNEL_DBC_FLAG_ZONE_DEP && zone->flags & AREA_FLAG_ARENA_INSTANCE)
         return false;
 
-    if ((channel->flags & CHANNEL_DBC_FLAG_CITY_ONLY) && (!(zone->flags & AREA_FLAG_SLAVE_CAPITAL)))
+    if ((channel->flags & CHANNEL_DBC_FLAG_CITY_ONLY) && (!(zone->mapid == 0 || zone->mapid == 1 || zone->mapid == 571 || zone->mapid == 530)))
         return false;
 
     if ((channel->flags & CHANNEL_DBC_FLAG_GUILD_REQ) && GetGuildId())

Demonid

From 546767d3ccdeed0fd4f851201bd6e4c4c8fb86c4 Mon Sep 17 00:00:00 2001
From: PaulHellCore <pashka2030@bk.ru>
Date: Wed, 8 Jul 2015 15:33:53 +0300
Subject: [PATCH] Core/Spells: Full hp for dismount pet's

---
 src/server/game/Entities/Pet/Pet.cpp | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

diff --git a/src/server/game/Entities/Pet/Pet.cpp b/src/server/game/Entities/Pet/Pet.cpp