diff options
| -rw-r--r-- | sql/updates/9026_world_script_texts.sql | 12 | ||||
| -rw-r--r-- | sql/updates/9026_world_scriptname.sql | 2 | ||||
| -rw-r--r-- | sql/updates/9043_world_spell_script_names.sql | 8 | ||||
| -rw-r--r-- | sql/updates/9058_world_spell_script_names.sql | 12 | ||||
| -rw-r--r-- | sql/updates/9059_world_spell_script_names.sql | 8 |
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'); |
