aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/9026_world_script_texts.sql12
-rw-r--r--sql/updates/9026_world_scriptname.sql2
-rw-r--r--sql/updates/9043_world_spell_script_names.sql8
-rw-r--r--sql/updates/9058_world_spell_script_names.sql12
-rw-r--r--sql/updates/9059_world_spell_script_names.sql8
5 files changed, 21 insertions, 21 deletions
diff --git a/sql/updates/9026_world_script_texts.sql b/sql/updates/9026_world_script_texts.sql
index 6af2939dfbe..a71cd6aaee8 100644
--- a/sql/updates/9026_world_script_texts.sql
+++ b/sql/updates/9026_world_script_texts.sql
@@ -1,7 +1,7 @@
-- script texts
-delete from script_texts where npc_entry in (7607,7604);
-insert into `script_texts` (`npc_entry`, `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
-('7607','-1209000','Oh no! Here they come!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','1','0','Weegli Blastfuse SAY_WEEGLI_OHNO'),
-('7607','-1209001','OK. Here I go.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','1','0','Weegli Blastfuse SAY_WEEGLI_OK_I_GO'),
-('7604','-1209002','Placeholder 1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','1','0','Sergeant Bly SAY_1'),
-('7604','-1209003','Placeholder 2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','1','0','Sergeant Bly SAY_2');
+DELETE FROM `script_texts` WHERE `npc_entry` IN (7607,7604);
+INSERT INTO `script_texts` (`npc_entry`,`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
+(7607,-1209000,'Oh no! Here they come!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,0,'Weegli Blastfuse SAY_WEEGLI_OHNO'),
+(7607,-1209001,'OK. Here I go.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,0,'Weegli Blastfuse SAY_WEEGLI_OK_I_GO'),
+(7604,-1209002,'Placeholder 1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,0,'Sergeant Bly SAY_1'),
+(7604,-1209003,'Placeholder 2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,0,'Sergeant Bly SAY_2');
diff --git a/sql/updates/9026_world_scriptname.sql b/sql/updates/9026_world_scriptname.sql
index 4f3e516dadc..3318444b77b 100644
--- a/sql/updates/9026_world_scriptname.sql
+++ b/sql/updates/9026_world_scriptname.sql
@@ -1,2 +1,2 @@
-- script names
-update gameobject_template set scriptName = 'go_troll_cage' where entry >= 141070 and entry < 141075;
+UPDATE `gameobject_template` SET `scriptName`='go_troll_cage' WHERE `entry`>=141070 AND `entry`<141075;
diff --git a/sql/updates/9043_world_spell_script_names.sql b/sql/updates/9043_world_spell_script_names.sql
index b18e3b9935c..d3664d02652 100644
--- a/sql/updates/9043_world_spell_script_names.sql
+++ b/sql/updates/9043_world_spell_script_names.sql
@@ -1,7 +1,7 @@
-DELETE FROM spell_script_names WHERE spell_id=19958 AND ScriptName='spell_mage_cold_snap';
-DELETE FROM spell_script_names WHERE spell_id=32826 AND ScriptName='spell_mage_polymorph_visual';
-DELETE FROM spell_script_names WHERE spell_id=31687 AND ScriptName='spell_mage_summon_water_elemental';
-INSERT INTO spell_script_names (spell_id, ScriptName) VALUES
+DELETE FROM `spell_script_names` WHERE `spell_id`=11958 AND `ScriptName`='spell_mage_cold_snap';
+DELETE FROM `spell_script_names` WHERE `spell_id`=32826 AND `ScriptName`='spell_mage_polymorph_visual';
+DELETE FROM `spell_script_names` WHERE `spell_id`=31687 AND `ScriptName`='spell_mage_summon_water_elemental';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
(11958,'spell_mage_cold_snap'),
(32826,'spell_mage_polymorph_visual'),
(31687,'spell_mage_summon_water_elemental');
diff --git a/sql/updates/9058_world_spell_script_names.sql b/sql/updates/9058_world_spell_script_names.sql
index 1b2d54c967e..eac047212b7 100644
--- a/sql/updates/9058_world_spell_script_names.sql
+++ b/sql/updates/9058_world_spell_script_names.sql
@@ -1,9 +1,9 @@
-DELETE FROM spell_script_names WHERE spell_id=-47540 AND ScriptName='spell_pri_penance';
-DELETE FROM spell_script_names WHERE spell_id=31231 AND ScriptName='spell_rog_cheat_death';
-DELETE FROM spell_script_names WHERE spell_id=51662 AND ScriptName='spell_rog_hunger_for_blood';
-DELETE FROM spell_script_names WHERE spell_id=14185 AND ScriptName='spell_rog_preparation';
-DELETE FROM spell_script_names WHERE spell_id=5938 AND ScriptName='spell_rog_shiv';
-INSERT INTO spell_script_names (spell_id, ScriptName) VALUES
+DELETE FROM `spell_script_names` WHERE `spell_id`=-47540 AND `ScriptName`='spell_pri_penance';
+DELETE FROM `spell_script_names` WHERE `spell_id`=31231 AND `ScriptName`='spell_rog_cheat_death';
+DELETE FROM `spell_script_names` WHERE `spell_id`=51662 AND `ScriptName`='spell_rog_hunger_for_blood';
+DELETE FROM `spell_script_names` WHERE `spell_id`=14185 AND `ScriptName`='spell_rog_preparation';
+DELETE FROM `spell_script_names` WHERE `spell_id`=5938 AND `ScriptName`='spell_rog_shiv';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
(-47540,'spell_pri_penance'),
(31231,'spell_rog_cheat_death'),
(51662,'spell_rog_hunger_for_blood'),
diff --git a/sql/updates/9059_world_spell_script_names.sql b/sql/updates/9059_world_spell_script_names.sql
index 9ba3981e15f..1bbc34cc6aa 100644
--- a/sql/updates/9059_world_spell_script_names.sql
+++ b/sql/updates/9059_world_spell_script_names.sql
@@ -1,7 +1,7 @@
-DELETE FROM spell_script_names WHERE spell_id=53271 AND ScriptName='spell_hun_masters_call';
-DELETE FROM spell_script_names WHERE spell_id=53478 AND ScriptName='spell_hun_last_stand_pet';
-DELETE FROM spell_script_names WHERE spell_id=23989 AND ScriptName='spell_hun_readiness';
-INSERT INTO spell_script_names (spell_id, ScriptName) VALUES
+DELETE FROM `spell_script_names` WHERE `spell_id`=53271 AND `ScriptName`='spell_hun_masters_call';
+DELETE FROM `spell_script_names` WHERE `spell_id`=53478 AND `ScriptName`='spell_hun_last_stand_pet';
+DELETE FROM `spell_script_names` WHERE `spell_id`=23989 AND `ScriptName`='spell_hun_readiness';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
(53271,'spell_hun_masters_call'),
(53478,'spell_hun_last_stand_pet'),
(23989,'spell_hun_readiness');