aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDr-J <daniel.jarrott0@gmail.com>2015-03-24 12:47:14 +0000
committerDr-J <daniel.jarrott0@gmail.com>2015-03-24 12:47:14 +0000
commit5594dad4d8e392a723b14fd2b1eee41b2187b1f0 (patch)
treeae3ca43bc3c53895ba836ab33223f2f13a0898fe
parent4201ca021ba20349cb4ebe87582f1ad035dd7a85 (diff)
DB/Misc: More error fixes
-rw-r--r--sql/updates/world/2015_03_24_02_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2015_03_24_02_world.sql b/sql/updates/world/2015_03_24_02_world.sql
new file mode 100644
index 00000000000..b9a49dcc9ba
--- /dev/null
+++ b/sql/updates/world/2015_03_24_02_world.sql
@@ -0,0 +1,6 @@
+UPDATE `creature_template` SET `AIName`='' WHERE `entry`=21669;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=21699;
+DELETE FROM `smart_scripts` WHERE `entryorguid` In(21669,21699) and `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(21669, 0, 0, 0, 1, 0, 100, 0, 0, 300000, 300000, 900000, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Maiev Shadowsong - OOC - Say Line 0');
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 and `SourceEntry`=35997;