aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorManuel Carrasco <manue.l@live.com.ar>2012-01-23 23:15:57 -0300
committerManuel Carrasco <manue.l@live.com.ar>2012-01-23 23:15:57 -0300
commit78ede251b05c4e9a4fa6c21dfd0bc65892d3788a (patch)
treebcc373ff3ff2660119323e2cf44cf60269cb960b /sql
parente6d5b21778762fec1ae21d3ce093102373cc8ec5 (diff)
Scripts/UK: Improvements to my last commit. Thanks to Vincent-Michael
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2012_01_23_06_world_achievement_criteria_data.sql3
-rw-r--r--sql/updates/world/2012_01_23_07_world_creature_text.sql5
2 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/2012_01_23_06_world_achievement_criteria_data.sql b/sql/updates/world/2012_01_23_06_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..33899c3f512
--- /dev/null
+++ b/sql/updates/world/2012_01_23_06_world_achievement_criteria_data.sql
@@ -0,0 +1,3 @@
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=7231 AND `type`=12;
+INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES
+(7231,12,1,0,'');
diff --git a/sql/updates/world/2012_01_23_07_world_creature_text.sql b/sql/updates/world/2012_01_23_07_world_creature_text.sql
new file mode 100644
index 00000000000..90ac11e363c
--- /dev/null
+++ b/sql/updates/world/2012_01_23_07_world_creature_text.sql
@@ -0,0 +1,5 @@
+UPDATE `creature_text` SET `comment`='Prince Keleseth - SAY_DEATH' WHERE `groupid`=5 AND `entry`=23953;
+UPDATE `creature_text` SET `comment`='Prince Keleseth - SAY_FROST_TOMB_EMOTE' WHERE `groupid`=4 AND `entry`=23953;
+UPDATE `creature_text` SET `comment`='Prince Keleseth - SAY_FROST_TOMB' WHERE `groupid`=3 AND `entry`=23953;
+UPDATE `creature_text` SET `comment`='Prince Keleseth - SAY_SUMMON_SKELETONS' WHERE `groupid`=2 AND `entry`=23953;
+UPDATE `creature_text` SET `comment`='Prince Keleseth - SAY_START_COMBAT' WHERE `groupid`=1 AND `entry`=23953;