From fa11595a282e1c2bce34e8b6d7a5f0c7810febb8 Mon Sep 17 00:00:00 2001 From: Furion89 Date: Sun, 19 Jun 2011 14:59:52 +0200 Subject: DB/Achievements: Fix Criteria for Supreme Defender and Stormtrooper --- .../2011_06_19_01_world_achievement_criteria_data.txt | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/updates/world/2011_06_19_01_world_achievement_criteria_data.txt (limited to 'sql') diff --git a/sql/updates/world/2011_06_19_01_world_achievement_criteria_data.txt b/sql/updates/world/2011_06_19_01_world_achievement_criteria_data.txt new file mode 100644 index 00000000000..d46e343864c --- /dev/null +++ b/sql/updates/world/2011_06_19_01_world_achievement_criteria_data.txt @@ -0,0 +1,19 @@ +-- Fix achievement criteria for Supreme Defender +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=3698; +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=3698; +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(3698,6,3277,0, ''), -- check if player is in Warsong Gulch +(3698,7,23333,0, ''); -- check if victim has a Horde Flag buff + +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=3699; +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=3699; +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(3699,6,3277,0, ''), -- check if player is in Warsong Gulch +(3699,7,23335,0, ''); -- check if victim has a Alliance Flag buff + +-- Fix achievement criteria for Stormtrooper +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=3685; +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=3685; +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(3685,6,3820,0, ''), -- check if player is in EOTS +(3685,7,34976,0, ''); -- check if victim has a Netherstorm Flag buff -- cgit v1.2.3