aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/2.4.3_updates
diff options
context:
space:
mode:
authorDrahy <none@none>2009-02-19 01:38:54 +0100
committerDrahy <none@none>2009-02-19 01:38:54 +0100
commitbd9c2fefa8d2268b233cc0c15038ec1c9342db8c (patch)
tree7226c1c5b8fe9bf2f38f009b288de3851e8e65d9 /sql/updates/2.4.3_updates
parent13fd0ed366d250c59b46825628e0507e6dc21489 (diff)
* Moved sqls to proper directories again
--HG-- branch : trunk
Diffstat (limited to 'sql/updates/2.4.3_updates')
-rw-r--r--sql/updates/2.4.3_updates/1069_world_scripts.sql12
-rw-r--r--sql/updates/2.4.3_updates/1073_world_scripts.sql2
-rw-r--r--sql/updates/2.4.3_updates/1074_world_scripts.sql2
-rw-r--r--sql/updates/2.4.3_updates/CMakeLists.txt3
4 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/2.4.3_updates/1069_world_scripts.sql b/sql/updates/2.4.3_updates/1069_world_scripts.sql
new file mode 100644
index 00000000000..0fafabf63f1
--- /dev/null
+++ b/sql/updates/2.4.3_updates/1069_world_scripts.sql
@@ -0,0 +1,12 @@
+DELETE FROM `spell_script_target` WHERE `entry` IN ('44807', '32307', '32314');
+INSERT INTO `spell_script_target` (`entry`,`type`,`targetEntry`) VALUES
+('44807', '1', '24850'),
+('44807', '1', '24892'),
+('32307', '2', '17146'),
+('32307', '2', '17147'),
+('32307', '2', '17148'),
+('32307', '2', '18658'),
+('32314', '2', '17138'),
+('32314', '2', '18037'),
+('32314', '2', '18064'),
+('32314', '2', '18065'); \ No newline at end of file
diff --git a/sql/updates/2.4.3_updates/1073_world_scripts.sql b/sql/updates/2.4.3_updates/1073_world_scripts.sql
new file mode 100644
index 00000000000..038f5f79466
--- /dev/null
+++ b/sql/updates/2.4.3_updates/1073_world_scripts.sql
@@ -0,0 +1,2 @@
+update creature_template set scriptname = 'npc_plains_vision' where entry = 2983;
+
diff --git a/sql/updates/2.4.3_updates/1074_world_scripts.sql b/sql/updates/2.4.3_updates/1074_world_scripts.sql
new file mode 100644
index 00000000000..4ed882ffea5
--- /dev/null
+++ b/sql/updates/2.4.3_updates/1074_world_scripts.sql
@@ -0,0 +1,2 @@
+update creature_template set scriptname = 'npc_plucky' where entry in (6626);
+
diff --git a/sql/updates/2.4.3_updates/CMakeLists.txt b/sql/updates/2.4.3_updates/CMakeLists.txt
index bb2090d80b2..85f240ead8c 100644
--- a/sql/updates/2.4.3_updates/CMakeLists.txt
+++ b/sql/updates/2.4.3_updates/CMakeLists.txt
@@ -165,4 +165,7 @@ INSTALL(FILES
1018_world.sql
1026_world.sql
1028_world_scripts.sql
+1069_world_scripts.sql
+1073_world_scripts.sql
+1074_world_scripts.sql
DESTINATION share/trinity/sql/updates/2.4.3_updates)