From 11d7acc99a1ea5dae116fce5a221f07b1a5b0b18 Mon Sep 17 00:00:00 2001 From: zxbiohazardzx Date: Tue, 3 Jan 2012 16:44:42 +0100 Subject: DB/creatures: Summoned creatures that come with the portal guardian in violet hold should not reward XP --- .../world/2012_01_02_02_world_creature_template.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 sql/updates/world/2012_01_02_02_world_creature_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_01_02_02_world_creature_template.sql b/sql/updates/world/2012_01_02_02_world_creature_template.sql new file mode 100644 index 00000000000..1f87f418dec --- /dev/null +++ b/sql/updates/world/2012_01_02_02_world_creature_template.sql @@ -0,0 +1,21 @@ +-- Kill xp exploit, mobs spawned by portal keepers don't gives xp on retail. (ie mobs 30662, 30664) +UPDATE `creature_template` SET `flags_extra`= `flags_extra`|64 WHERE `entry` IN ( +-- NORMAL +30661, -- CREATURE_AZURE_INVADER_1 +30961, -- CREATURE_AZURE_INVADER_2 +30662, -- CREATURE_AZURE_SPELLBREAKER_1 +30962, -- CREATURE_AZURE_SPELLBREAKER_2 +30663, -- CREATURE_AZURE_BINDER_1 +30918, -- CREATURE_AZURE_BINDER_2 +30664, -- CREATURE_AZURE_MAGE_SLAYER_1 +30963, -- CREATURE_AZURE_MAGE_SLAYER_2 +-- HEROIC: +31487, -- Azure Invader +31494, -- Azure Spellbreaker +31483, -- Azure Binder +31497, -- Azure Mage Slayer +31484, -- Azure Binder +31488, -- Azure Invader +31495, -- Azure Spellbreaker +31498, -- Azure Mage Slayer +); -- cgit v1.2.3