diff options
| author | Furion89 <furion89@trinitycore.contributor> | 2011-06-19 14:59:52 +0200 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-06-19 14:59:52 +0200 |
| commit | fa11595a282e1c2bce34e8b6d7a5f0c7810febb8 (patch) | |
| tree | 5c06e33cf1d6751f917ba2dd376db595c51e131b | |
| parent | ec82cc2e78ad48e96aace40d876161d3983b93f2 (diff) | |
DB/Achievements: Fix Criteria for Supreme Defender and Stormtrooper
| -rw-r--r-- | sql/updates/world/2011_06_19_01_world_achievement_criteria_data.txt | 19 |
1 files changed, 19 insertions, 0 deletions
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 |