From 1e8bf1aad18088c0e5cde8918d653bc00b0187a4 Mon Sep 17 00:00:00 2001 From: w1sht0l1v3 Date: Mon, 4 Feb 2013 23:39:04 +0200 Subject: DB/Misc: Fix achievement Flirt With Disaster. --- ...2013_02_04_07_world_achievement_criteria_data.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 sql/updates/world/2013_02_04_07_world_achievement_criteria_data.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2013_02_04_07_world_achievement_criteria_data.sql b/sql/updates/world/2013_02_04_07_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..dc873a02dfd --- /dev/null +++ b/sql/updates/world/2013_02_04_07_world_achievement_criteria_data.sql @@ -0,0 +1,20 @@ +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3931,12859,4227,3929); +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES +-- aliance +-- Kissed Sraaz +(3931,1,9099,0,''), +(3931,11,0,0,'achievement_flirt_with_disaster_perf_check'), +(3931,15,3,0,''), +-- Handful of Rose Petals on Sraaz +(12859,1,9099,0,''), +(12859,11,0,0,'achievement_flirt_with_disaster_perf_check'), +(12859,15,3,0,''), +-- horde +-- Kissed Jeremiah Payson +(3929,1,8403,0,''), +(3929,11,0,0,'achievement_flirt_with_disaster_perf_check'), +(3929,15,3,0,''), +-- Handful of Rose Petals on Jeremiah Payson +(4227,1,8403,0,''), +(4227,11,0,0,'achievement_flirt_with_disaster_perf_check'), +(4227,15,3,0,''); -- cgit v1.2.3 From 630ad4b0b58c329b0b1e72da8a804a505c7927d1 Mon Sep 17 00:00:00 2001 From: Kinzcool Date: Mon, 4 Feb 2013 20:03:04 -0500 Subject: DB/Creature: Updated Unseen template --- sql/updates/world/2013_02_04_08_world_creature_template.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2013_02_04_08_world_creature_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2013_02_04_08_world_creature_template.sql b/sql/updates/world/2013_02_04_08_world_creature_template.sql new file mode 100644 index 00000000000..3dd365366b6 --- /dev/null +++ b/sql/updates/world/2013_02_04_08_world_creature_template.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `faction_A`=15, `faction_H`=15, `speed_walk`=1.111112, `baseattacktime`=2000, `rangeattacktime`=2000, `dynamicflags`=0 WHERE `entry`=3094; -- Unseen -- cgit v1.2.3