From b11de3eac08a3c315372005f504152b01224ed88 Mon Sep 17 00:00:00 2001 From: Kandera Date: Thu, 23 Aug 2012 13:29:54 -0400 Subject: Scripts/Wintergrasp: enable script and add it to spell_script_names --- .../world/2012_08_23_00_world_wintergrasp_spell_script_names.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/world/2012_08_23_00_world_wintergrasp_spell_script_names.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_08_23_00_world_wintergrasp_spell_script_names.sql b/sql/updates/world/2012_08_23_00_world_wintergrasp_spell_script_names.sql new file mode 100644 index 00000000000..a3dbf81d425 --- /dev/null +++ b/sql/updates/world/2012_08_23_00_world_wintergrasp_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` = 54640; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(54640, 'spell_wintergrasp_defender_teleport'); -- cgit v1.2.3 From 6bcc994a5e1b92c2037c7042621acfe6f53cc5f8 Mon Sep 17 00:00:00 2001 From: Kandera Date: Thu, 23 Aug 2012 15:18:20 -0400 Subject: DB/Gameobjects: fix double spawns of wintergrasp keep gameobjects --- sql/updates/world/2012_08_23_01_world_wintergrasp_gameobject.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2012_08_23_01_world_wintergrasp_gameobject.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_08_23_01_world_wintergrasp_gameobject.sql b/sql/updates/world/2012_08_23_01_world_wintergrasp_gameobject.sql new file mode 100644 index 00000000000..27f7b4027f1 --- /dev/null +++ b/sql/updates/world/2012_08_23_01_world_wintergrasp_gameobject.sql @@ -0,0 +1 @@ +DELETE FROM `gameobject` WHERE `guid` IN (67259,67135,60476,66674,66675,67127,67128,66728,66731,67125,66730,66732,67126,67256,67132,67133,66733,67134,67251,67255,67129,67130,67131,67253,67258,67259,67260,75975,75976,76021,76022,66729,66718,66719,66720,66721,66722,66723,66724,66725,66726); -- cgit v1.2.3 From c61ce54f0355c4b3178a2dab7ffb480656ff92b9 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sat, 25 Aug 2012 01:29:03 +0200 Subject: Misc/Battlefield: * Fix faction for Wintergrasp Siege Turret * Add missing magic number --- .../2012_08_25_00_world_creature_template.sql | 3 +++ src/server/game/Battlefield/Zones/BattlefieldWG.h | 28 +++++++++++----------- 2 files changed, 17 insertions(+), 14 deletions(-) create mode 100644 sql/updates/world/2012_08_25_00_world_creature_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_08_25_00_world_creature_template.sql b/sql/updates/world/2012_08_25_00_world_creature_template.sql new file mode 100644 index 00000000000..f7ec4c87fb9 --- /dev/null +++ b/sql/updates/world/2012_08_25_00_world_creature_template.sql @@ -0,0 +1,3 @@ +-- Wintergrasp Siege Turret +UPDATE `creature_template` SET `faction_A`=1732,`faction_H`=1732 WHERE `entry`=28319; -- Alliance +UPDATE `creature_template` SET `faction_A`=1735,`faction_H`=1735 WHERE `entry`=32629; -- Horde diff --git a/src/server/game/Battlefield/Zones/BattlefieldWG.h b/src/server/game/Battlefield/Zones/BattlefieldWG.h index 7ef7e61b63c..3327ebe4dff 100644 --- a/src/server/game/Battlefield/Zones/BattlefieldWG.h +++ b/src/server/game/Battlefield/Zones/BattlefieldWG.h @@ -1473,17 +1473,17 @@ struct BfWGGameObjectBuilding switch (m_Build->GetEntry()) { - case 190221: - case 190373: - case 190377: - case 190378: + case GO_WINTERGRASP_FORTRESS_TOWER_1: + case GO_WINTERGRASP_FORTRESS_TOWER_2: + case GO_WINTERGRASP_FORTRESS_TOWER_3: + case GO_WINTERGRASP_FORTRESS_TOWER_4: { creature->setFaction(WintergraspFaction[m_WG->GetDefenderTeam()]); break; } - case 190356: - case 190357: - case 190358: + case GO_WINTERGRASP_SHADOWSIGHT_TOWER: + case GO_WINTERGRASP_WINTER_S_EDGE_TOWER: + case GO_WINTERGRASP_FLAMEWATCH_TOWER: { creature->setFaction(WintergraspFaction[m_WG->GetAttackerTeam()]); break; @@ -1509,17 +1509,17 @@ struct BfWGGameObjectBuilding switch (m_Build->GetEntry()) { - case 190221: - case 190373: - case 190377: - case 190378: + case GO_WINTERGRASP_FORTRESS_TOWER_1: + case GO_WINTERGRASP_FORTRESS_TOWER_2: + case GO_WINTERGRASP_FORTRESS_TOWER_3: + case GO_WINTERGRASP_FORTRESS_TOWER_4: { creature->setFaction(WintergraspFaction[m_WG->GetDefenderTeam()]); break; } - case 190356: - case 190357: - case 190358: + case GO_WINTERGRASP_SHADOWSIGHT_TOWER: + case GO_WINTERGRASP_WINTER_S_EDGE_TOWER: + case GO_WINTERGRASP_FLAMEWATCH_TOWER: { creature->setFaction(WintergraspFaction[m_WG->GetAttackerTeam()]); break; -- cgit v1.2.3 From fd3ab841adba57b902edb1970f72e0d71fa733ec Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sat, 25 Aug 2012 03:16:18 +0200 Subject: DB/Creature: Fix Twilight Whelp faction from sniff --- sql/updates/world/2012_08_25_01_world_creature_template.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2012_08_25_01_world_creature_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_08_25_01_world_creature_template.sql b/sql/updates/world/2012_08_25_01_world_creature_template.sql new file mode 100644 index 00000000000..ef8e5bdd8fc --- /dev/null +++ b/sql/updates/world/2012_08_25_01_world_creature_template.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `faction_A`=103,`faction_H`=103 WHERE `entry` IN (30890,31540); -- Twilight Whelp -- cgit v1.2.3