From 1a1cf8d263b62dd3bd3e241c6e79bfe8bad6f021 Mon Sep 17 00:00:00 2001 From: Nay Date: Mon, 28 Nov 2011 17:22:21 +0000 Subject: Core/GOs: Update `gameobject_template` and SMSG_GAMEOBJECT_QUERY_RESPONSE --- sql/updates/world/4.x/2011_11_27_00_world_spell_script.sql | 6 ++++++ .../world/4.x/2011_11_28_00_world_gameobject_template.sql | 9 +++++++++ 2 files changed, 15 insertions(+) create mode 100644 sql/updates/world/4.x/2011_11_27_00_world_spell_script.sql create mode 100644 sql/updates/world/4.x/2011_11_28_00_world_gameobject_template.sql (limited to 'sql') 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 -- cgit v1.2.3