diff options
| author | Nay <dnpd.dd@gmail.com> | 2011-11-28 17:22:21 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-11-28 17:22:21 +0000 |
| commit | 1a1cf8d263b62dd3bd3e241c6e79bfe8bad6f021 (patch) | |
| tree | 4920b954cc5d908dbe358241d7ce0d38e37059c5 /sql | |
| parent | aa96a4ca9ce849191567873bcc3d595bf42281a4 (diff) | |
Core/GOs: Update `gameobject_template` and SMSG_GAMEOBJECT_QUERY_RESPONSE
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/4.x/2011_11_27_00_world_spell_script.sql | 6 | ||||
| -rw-r--r-- | sql/updates/world/4.x/2011_11_28_00_world_gameobject_template.sql | 9 |
2 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/4.x/2011_11_27_00_world_spell_script.sql b/sql/updates/world/4.x/2011_11_27_00_world_spell_script.sql new file mode 100644 index 00000000000..5411d660c2b --- /dev/null +++ b/sql/updates/world/4.x/2011_11_27_00_world_spell_script.sql @@ -0,0 +1,6 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_damage_reduction_aura'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(20911,'spell_gen_damage_reduction_aura'), -- Blessing of Sanctuary +(25899,'spell_gen_damage_reduction_aura'), -- Greater Blessing of Sanctuary +(63944,'spell_gen_damage_reduction_aura'), -- Renewed Hope +(50720,'spell_gen_damage_reduction_aura'); -- Vigilance diff --git a/sql/updates/world/4.x/2011_11_28_00_world_gameobject_template.sql b/sql/updates/world/4.x/2011_11_28_00_world_gameobject_template.sql new file mode 100644 index 00000000000..236f6acc6ae --- /dev/null +++ b/sql/updates/world/4.x/2011_11_28_00_world_gameobject_template.sql @@ -0,0 +1,9 @@ +ALTER TABLE `gameobject_template` ADD `data24` INT(10) NOT NULL DEFAULT '0' AFTER `data23`; +ALTER TABLE `gameobject_template` ADD `data25` INT(10) NOT NULL DEFAULT '0' AFTER `data24`; +ALTER TABLE `gameobject_template` ADD `data26` INT(10) NOT NULL DEFAULT '0' AFTER `data25`; +ALTER TABLE `gameobject_template` ADD `data27` INT(10) NOT NULL DEFAULT '0' AFTER `data26`; +ALTER TABLE `gameobject_template` ADD `data28` INT(10) NOT NULL DEFAULT '0' AFTER `data27`; +ALTER TABLE `gameobject_template` ADD `data29` INT(10) NOT NULL DEFAULT '0' AFTER `data28`; +ALTER TABLE `gameobject_template` ADD `data30` INT(10) NOT NULL DEFAULT '0' AFTER `data29`; +ALTER TABLE `gameobject_template` ADD `data31` INT(10) NOT NULL DEFAULT '0' AFTER `data30`; +ALTER TABLE `gameobject_template` ADD `unkInt32` INT(10) NOT NULL DEFAULT '0' AFTER `data31`; -- Unk size |