aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2013_01_06_02_world_misc.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/2013_01_06_02_world_misc.sql b/sql/updates/world/2013_01_06_02_world_misc.sql
new file mode 100644
index 00000000000..8c24975754a
--- /dev/null
+++ b/sql/updates/world/2013_01_06_02_world_misc.sql
@@ -0,0 +1,12 @@
+-- Small fix to pathing for Harrison Jones
+UPDATE `waypoint_data` SET `position_y`=1642.853 WHERE `id`=861770 AND `point`=1;
+
+-- Text for Amani'shi Guardian from sniff
+DELETE FROM `creature_text` WHERE `entry` IN (23597);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(23597,0,0, 'More intruders! Sound da alarm!',14,0,100,25,0,12104, 'Amani''shi Guardian - Gong Event Say');
+
+-- Spell condition for Cosmetic - Spear Throw
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=43647;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13,1,43647,0,0,31,0,3,24358,0,0,0,0, '', 'Cosmetic - Spear Throw - Harrison Jones');