diff options
4 files changed, 16 insertions, 4 deletions
diff --git a/sql/updates/2.4.3_updates/1073_world_scripts.sql b/sql/updates/2.4.3_updates/1073_world_scripts.sql index 038f5f79466..5b75c1efad5 100644 --- a/sql/updates/2.4.3_updates/1073_world_scripts.sql +++ b/sql/updates/2.4.3_updates/1073_world_scripts.sql @@ -1,2 +1 @@ -update creature_template set scriptname = 'npc_plains_vision' where entry = 2983; - +UPDATE `creature_template` SET `ScriptName`='npc_plains_vision' WHERE `entry`='2983';
\ No newline at end of file diff --git a/sql/updates/2.4.3_updates/1074_world_scripts.sql b/sql/updates/2.4.3_updates/1074_world_scripts.sql index 4ed882ffea5..2863a1fb6aa 100644 --- a/sql/updates/2.4.3_updates/1074_world_scripts.sql +++ b/sql/updates/2.4.3_updates/1074_world_scripts.sql @@ -1,2 +1 @@ -update creature_template set scriptname = 'npc_plucky' where entry in (6626); - +UPDATE `creature_template` SET `ScriptName` = 'npc_plucky' WHERE `entry` = '6626';
\ No newline at end of file diff --git a/sql/updates/875_mangos_7047_01_characters_character_spell.sql b/sql/updates/875_mangos_7047_01_characters_character_spell.sql new file mode 100644 index 00000000000..b74900cfdba --- /dev/null +++ b/sql/updates/875_mangos_7047_01_characters_character_spell.sql @@ -0,0 +1,10 @@ +/*ALTER TABLE character_db_version CHANGE COLUMN required_6976_02_characters_character_db_version required_7047_01_characters_character_spell bit;*/ + +DELETE FROM `character_spell` WHERE `spell` IN ('28880', 59542, 59543, 59544, 59545, 59547, 59548); +INSERT INTO character_spell SELECT characters.guid as guid, 28880, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 1; +INSERT INTO character_spell SELECT characters.guid as guid, 59542, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 2; +INSERT INTO character_spell SELECT characters.guid as guid, 59543, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 3; +INSERT INTO character_spell SELECT characters.guid as guid, 59544, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 5; +INSERT INTO character_spell SELECT characters.guid as guid, 59545, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 6; +INSERT INTO character_spell SELECT characters.guid as guid, 59547, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 7; +INSERT INTO character_spell SELECT characters.guid as guid, 59548, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 8;
\ No newline at end of file diff --git a/sql/updates/875_mangos_7059_01_characters_pet_spell.sql b/sql/updates/875_mangos_7059_01_characters_pet_spell.sql new file mode 100644 index 00000000000..11f1063ebc3 --- /dev/null +++ b/sql/updates/875_mangos_7059_01_characters_pet_spell.sql @@ -0,0 +1,4 @@ +/*ALTER TABLE character_db_version CHANGE COLUMN required_7059_01_characters_character_spell required_7059_02_characters_pet_spell bit;*/ + +ALTER TABLE pet_spell + DROP slot;
\ No newline at end of file |