aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/817_world_scripts.sql8
-rw-r--r--sql/updates/822_world_scripts.sql6
-rw-r--r--sql/updates/826_world_scripts.sql2
3 files changed, 8 insertions, 8 deletions
diff --git a/sql/updates/817_world_scripts.sql b/sql/updates/817_world_scripts.sql
index 07750f338b8..8cf97f7145a 100644
--- a/sql/updates/817_world_scripts.sql
+++ b/sql/updates/817_world_scripts.sql
@@ -1,5 +1,7 @@
+UPDATE `creature_template` SET `ScriptName`='npc_ame' WHERE `entry`=9623;
+
DELETE FROM `script_texts` WHERE `entry` BETWEEN -1000205 AND -1000200;
-INSERT INTO script_texts
+INSERT INTO `script_texts`
(`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`)
VALUES
(-1000200, 'A-Me good.Good A-me.Follow...A-ME follow.Home.A-ME go home.', NULL, NULL, 'A-ME gut.Gut A-Me.Folgen...Heim.A-ME geht heim.', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL),
@@ -8,6 +10,4 @@ VALUES
(-1000203, 'A-Me home.A-ME go home!Tar Lord dont disturb A-ME.', NULL, NULL, 'A-ME daheim.A-ME geht heim!Teerfürst A-ME nicht aufhalten.', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL),
(-1000204, 'Tar Lord A-ME no hurt.A-ME good.', NULL, NULL, 'Teerfürst A-ME nicht wehtun.A-ME gut.', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL),
(-1000205, 'A-ME at home!A-ME good!Good A-ME.At home.Home.Home', NULL, NULL, 'A-ME daheim!A-ME gut!Gute A-ME.Daheim.Daheim.Daheim', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL);
-UPDATE `quest_template` SET `QuestFlags` = 2, `SpecialFlags` = 2 WHERE `entry` = 4245;
-
-UPDATE `creature_template` SET `ScriptName` = 'npc_ame' WHERE `entry` = 9623; \ No newline at end of file
+UPDATE `quest_template` SET `QuestFlags` = 2, `SpecialFlags` = 2 WHERE `entry` = 4245; \ No newline at end of file
diff --git a/sql/updates/822_world_scripts.sql b/sql/updates/822_world_scripts.sql
index f7a7016dcf7..942971f8d71 100644
--- a/sql/updates/822_world_scripts.sql
+++ b/sql/updates/822_world_scripts.sql
@@ -1,3 +1,3 @@
-update creature_template set scriptname='npc_kayra_longmane' where entry=17969;
-delete from creature_template_addon where entry=17969;
-update quest_template set specialflags=2 where entry=9752; \ No newline at end of file
+UPDATE `creature_template` SET `ScriptName`='npc_kayra_longmane' WHERE `entry`=17969;
+DELETE FROM `creature_template_addon` WHERE `entry`=17969;
+UPDATE `quest_template` SET specialflags=2 WHERE `entry`=9752; \ No newline at end of file
diff --git a/sql/updates/826_world_scripts.sql b/sql/updates/826_world_scripts.sql
index b125225744f..487971d092c 100644
--- a/sql/updates/826_world_scripts.sql
+++ b/sql/updates/826_world_scripts.sql
@@ -1 +1 @@
-UPDATE `creature_template` SET `ScriptName` = 'npc_ruul_snowhoof' WHERE `entry` = 12818; \ No newline at end of file
+UPDATE `creature_template` SET `ScriptName`='npc_ruul_snowhoof' WHERE `entry`=12818; \ No newline at end of file