From 23e4dfd8e868e347cf5b00622cc65a41582a2232 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Sat, 5 Jul 2014 19:41:33 +0200 Subject: DB/SAI: Fix db startup errros --- .../world/2014_07_05_01_world_smart_scripts.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 sql/updates/world/2014_07_05_01_world_smart_scripts.sql (limited to 'sql') diff --git a/sql/updates/world/2014_07_05_01_world_smart_scripts.sql b/sql/updates/world/2014_07_05_01_world_smart_scripts.sql new file mode 100644 index 00000000000..9c29ce8b253 --- /dev/null +++ b/sql/updates/world/2014_07_05_01_world_smart_scripts.sql @@ -0,0 +1,20 @@ +UPDATE `smart_scripts` SET + `action_type`=11, `action_param1`=37903, `action_param2`=1, `comment`='Razaani Light Orb - Between 0-30% Health - Cast Trapping the Light: Kill Credit (No Repeat)' WHERE + `entryorguid`=20635 AND `source_type`=0 AND `id`=3 AND `link`=4; + +UPDATE `smart_scripts` SET + `action_type`=11, `action_param1`=37903, `action_param2`=1, `comment`='Razaani Light Orb - Mini - On Reached Point 1 - Cast Trapping the Light: Kill Credit (No Repeat)' WHERE + `entryorguid`=20771 AND `source_type`=0 AND `id`=3 AND `link`=4; + +UPDATE `smart_scripts` SET + `action_type`=11, `action_param1`=37903, `action_param2`=1, `comment`='Multi-Spectrum Light Trap Bunny - On Data Set 1 1 - Cast Trapping the Light: Kill Credit ' WHERE + `entryorguid`=21926 AND `source_type`=0 AND `id`=4 AND `link`=5; + +UPDATE `smart_scripts` SET + `action_type`=85, `action_param1`=37829, `action_param2`=1, `comment`='Scalewing Serpent - On Spellhit - Cast Ride the Lightning: Kill Credit' WHERE + `entryorguid`=20749 AND `source_type`=0 AND `id`=1 AND `link`=0; + +UPDATE `smart_scripts` SET + `action_type`=85, `action_param1`=43174, `action_param2`=1, `comment`='Proto-Drake - On Death - Cast Draconis Gastritis: Kill Credit' WHERE + `entryorguid`=23689 AND `source_type`=0 AND `id`=7 AND `link`=0; + \ No newline at end of file -- cgit v1.2.3 From 63784fee2a2ed2f1baa20696df3eceeb90bfde07 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sat, 5 Jul 2014 19:44:31 +0200 Subject: SQL: Fix end of file --- sql/updates/world/2014_07_05_01_world_smart_scripts.sql | 1 - 1 file changed, 1 deletion(-) (limited to 'sql') diff --git a/sql/updates/world/2014_07_05_01_world_smart_scripts.sql b/sql/updates/world/2014_07_05_01_world_smart_scripts.sql index 9c29ce8b253..ddd158c83a8 100644 --- a/sql/updates/world/2014_07_05_01_world_smart_scripts.sql +++ b/sql/updates/world/2014_07_05_01_world_smart_scripts.sql @@ -17,4 +17,3 @@ UPDATE `smart_scripts` SET UPDATE `smart_scripts` SET `action_type`=85, `action_param1`=43174, `action_param2`=1, `comment`='Proto-Drake - On Death - Cast Draconis Gastritis: Kill Credit' WHERE `entryorguid`=23689 AND `source_type`=0 AND `id`=7 AND `link`=0; - \ No newline at end of file -- cgit v1.2.3