From 25cc9310a74d8594cd2a528bf6468336efb47c83 Mon Sep 17 00:00:00 2001 From: Exodius Date: Sun, 30 Jun 2013 17:53:56 +0200 Subject: DB/Player: add Wooly Mammoth & Armored Brown Bear to factionchange Closes #10098 --- sql/updates/world/2013_06_30_07_world_creature_loot_template.sql | 3 +++ .../world/2013_06_30_08_world_player_factionchange_spells.sql | 5 +++++ sql/updates/world/2013_06_30_world_creature_loot_template.sql | 3 --- 3 files changed, 8 insertions(+), 3 deletions(-) create mode 100644 sql/updates/world/2013_06_30_07_world_creature_loot_template.sql create mode 100644 sql/updates/world/2013_06_30_08_world_player_factionchange_spells.sql delete mode 100644 sql/updates/world/2013_06_30_world_creature_loot_template.sql (limited to 'sql') diff --git a/sql/updates/world/2013_06_30_07_world_creature_loot_template.sql b/sql/updates/world/2013_06_30_07_world_creature_loot_template.sql new file mode 100644 index 00000000000..402e00d685e --- /dev/null +++ b/sql/updates/world/2013_06_30_07_world_creature_loot_template.sql @@ -0,0 +1,3 @@ +-- Gnomish Grenades have Very High drop chance +-- http://eu.battle.net/wow/en/item/34772 +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-90 WHERE `entry`=25449 and `item`=34772; diff --git a/sql/updates/world/2013_06_30_08_world_player_factionchange_spells.sql b/sql/updates/world/2013_06_30_08_world_player_factionchange_spells.sql new file mode 100644 index 00000000000..1d3da3eb33b --- /dev/null +++ b/sql/updates/world/2013_06_30_08_world_player_factionchange_spells.sql @@ -0,0 +1,5 @@ +DELETE FROM `player_factionchange_spells` WHERE `alliance_id`=59791 AND `horde_id`=59793; +DELETE FROM `player_factionchange_spells` WHERE `alliance_id`=60114 AND `horde_id`=60116; +INSERT INTO `player_factionchange_spells` (`alliance_id`,`horde_id`) VALUES +(59791, 59793), -- Wooly Mammoth +(60114, 60116); -- Armored Brown Bear diff --git a/sql/updates/world/2013_06_30_world_creature_loot_template.sql b/sql/updates/world/2013_06_30_world_creature_loot_template.sql deleted file mode 100644 index 402e00d685e..00000000000 --- a/sql/updates/world/2013_06_30_world_creature_loot_template.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Gnomish Grenades have Very High drop chance --- http://eu.battle.net/wow/en/item/34772 -UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-90 WHERE `entry`=25449 and `item`=34772; -- cgit v1.2.3