From ddd530edd24109e65206842c02a69d8fbde3a907 Mon Sep 17 00:00:00 2001 From: TCKiper Date: Wed, 18 May 2011 15:56:24 +0100 Subject: DB/Achievements: Fix criterias for Not In My House and for Take a Chill Pill --- sql/updates/world/2011_05_18_04_world_achievements.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/world/2011_05_18_04_world_achievements.sql (limited to 'sql') diff --git a/sql/updates/world/2011_05_18_04_world_achievements.sql b/sql/updates/world/2011_05_18_04_world_achievements.sql new file mode 100644 index 00000000000..82e04bc1f93 --- /dev/null +++ b/sql/updates/world/2011_05_18_04_world_achievements.sql @@ -0,0 +1,18 @@ +-- Fix achievement criteria for Not In My House +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=7021; +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=7021; +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(7021,6,4572,0, ''), -- check if player is in Warsong Flag Room +(7021,7,23333,0, ''); -- check if victim has a Horde Flag buff +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=7020; +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=7020; +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(7020,6,4571,0, ''), -- check if player is in Silverwing Flag Room +(7020,7,23335,0, ''); -- check if victim has a Alliance Flag buff + +-- Fix achievement criteria for Take a Chill Pill +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=3879; +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=3879; +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(3879,6,3820,0, ''), -- check if player is in Eye of the Storm +(3879,7,23505,0, ''); -- check if victim has a Berserking buff -- cgit v1.2.3