diff options
Diffstat (limited to 'sql/old/3.3.5a')
8 files changed, 13 insertions, 26 deletions
diff --git a/sql/old/3.3.5a/2011_12_13_02_creature_template_addon.sql b/sql/old/3.3.5a/2011_12_13_02_creature_template_addon.sql new file mode 100644 index 00000000000..2e7280927bf --- /dev/null +++ b/sql/old/3.3.5a/2011_12_13_02_creature_template_addon.sql @@ -0,0 +1,2 @@ +-- Fix speed of oculus drakes +UPDATE `creature_template_addon` SET `auras`='50325' WHERE `entry` IN (27755,27692,27756);
\ No newline at end of file diff --git a/sql/old/3.3.5a/2011_12_14_01_gameobject_template.sql b/sql/old/3.3.5a/2011_12_14_01_gameobject_template.sql new file mode 100644 index 00000000000..12729afd6b8 --- /dev/null +++ b/sql/old/3.3.5a/2011_12_14_01_gameobject_template.sql @@ -0,0 +1 @@ +UPDATE `gameobject_template` SET `scriptName` = 'go_ethereal_teleport_pad' WHERE `entry` = 184073; -- Update Ethereal Teleport Pad scriptname
\ No newline at end of file diff --git a/sql/old/3.3.5a/TDB44_to_TDB45_updates/world/2011_12_13_00_world_misc.sql b/sql/old/3.3.5a/TDB44_to_TDB45_updates/world/2011_12_13_00_world_misc.sql index 13958e75761..48848c368f1 100644 --- a/sql/old/3.3.5a/TDB44_to_TDB45_updates/world/2011_12_13_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB44_to_TDB45_updates/world/2011_12_13_00_world_misc.sql @@ -3,4 +3,4 @@ INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`pr (28012,0,0,'The trickster Mage-Lord Urom protects the third ring. He will appear alone and defenseless, but do not be fooled by appearences! Urom is a powerful conjurer who commands a menagerie of Phantasmal creatures. Seek him out above.',12,0,0,0,0,0,''), (28012,1,1,'Your greatest challenge lies ahead. Ley-Guardian Eregos is a Blue dragon of immense power. You will find him flying above the uppermost ring.',12,0,0,0,0,0,''); -UPDATE `creature_template` SET `ScriptName`='npc_image_belgaristrasz' WHERE `entry`=28012; +UPDATE `creature_template` SET `ScriptName`='npc_image_belgaristrasz' WHERE `entry`=28012;
\ No newline at end of file diff --git a/sql/old/3.3.5a/TDB44_to_TDB45_updates/world/2011_12_16_00_world_creature_template.sql b/sql/old/3.3.5a/TDB44_to_TDB45_updates/world/2011_12_16_00_world_creature_template.sql index 3ff9d630c54..156fd431359 100644 --- a/sql/old/3.3.5a/TDB44_to_TDB45_updates/world/2011_12_16_00_world_creature_template.sql +++ b/sql/old/3.3.5a/TDB44_to_TDB45_updates/world/2011_12_16_00_world_creature_template.sql @@ -1,4 +1,4 @@ -- Greater Fire Elemental script UPDATE `creature_template` SET `ScriptName`='npc_fire_elemental' WHERE `entry`=15438; -- Greater Earth Elemental script -UPDATE `creature_template` SET `ScriptName`='npc_earth_elemental' WHERE `entry`=15352; +UPDATE `creature_template` SET `ScriptName`='npc_earth_elemental' WHERE `entry`=15352;
\ No newline at end of file diff --git a/sql/old/3.3.5a/TDB44_to_TDB45_updates/world/2011_12_16_00_world_spell_bonus_data.sql b/sql/old/3.3.5a/TDB44_to_TDB45_updates/world/2011_12_16_00_world_spell_bonus_data.sql index 5864b9ac042..3250bda4fdb 100644 --- a/sql/old/3.3.5a/TDB44_to_TDB45_updates/world/2011_12_16_00_world_spell_bonus_data.sql +++ b/sql/old/3.3.5a/TDB44_to_TDB45_updates/world/2011_12_16_00_world_spell_bonus_data.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_bonus_data` WHERE `entry` IN (13376,57984); INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`,`ap_bonus`, `ap_dot_bonus`, `comments`) VALUES (13376,0.032,-1,-1,-1,'Greater Fire Elemental - Fire Shield'), -(57984,0.4289,-1,-1,-1,'Greater Fire Elemental - Fire Blast'); +(57984,0.4289,-1,-1,-1,'Greater Fire Elemental - Fire Blast');
\ No newline at end of file diff --git a/sql/old/3.3.5a/TDB48_to_TDB49_updates/world/2012_09_09_02_world_spell_script_names.sql b/sql/old/3.3.5a/TDB48_to_TDB49_updates/world/2012_09_09_02_world_spell_script_names.sql index 36e5b08c36d..a4304663d9c 100644 --- a/sql/old/3.3.5a/TDB48_to_TDB49_updates/world/2012_09_09_02_world_spell_script_names.sql +++ b/sql/old/3.3.5a/TDB48_to_TDB49_updates/world/2012_09_09_02_world_spell_script_names.sql @@ -1,10 +1,4 @@ --- Gift of the Naaru -DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_gift_of_naaru'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(28880,'spell_gen_gift_of_naaru'), -- SPELLFAMILY_WARRIOR -(59542,'spell_gen_gift_of_naaru'), -- SPELLFAMILY_PALADIN -(59543,'spell_gen_gift_of_naaru'), -- SPELLFAMILY_HUNTER -(59544,'spell_gen_gift_of_naaru'), -- SPELLFAMILY_PRIEST -(59545,'spell_gen_gift_of_naaru'), -- SPELLFAMILY_DEATHKNIGHT -(59547,'spell_gen_gift_of_naaru'), -- SPELLFAMILY_SHAMAN -(59548,'spell_gen_gift_of_naaru'); -- SPELLFAMILY_MAGE +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_warl_banish','spell_warl_create_healthstone','spell_warl_ritual_of_doom_effect'); +INSERT INTO `spell_script_names`(`spell_id`,`ScriptName`) VALUES +(710,'spell_warl_banish'), +(6201,'spell_warl_create_healthstone'); diff --git a/sql/old/3.3.5a/TDB49_to_TDB50_updates/characters/2012_12_18_00_characters_worldstates.sql b/sql/old/3.3.5a/TDB49_to_TDB50_updates/characters/2012_12_18_00_characters_worldstates.sql index 98fabde6776..c6fc15e60b7 100644 --- a/sql/old/3.3.5a/TDB49_to_TDB50_updates/characters/2012_12_18_00_characters_worldstates.sql +++ b/sql/old/3.3.5a/TDB49_to_TDB50_updates/characters/2012_12_18_00_characters_worldstates.sql @@ -1,4 +1,5 @@ -DELETE FROM `worldstates` WHERE `entry` IN (20004,20007); +DELETE FROM `worldstates` WHERE `entry` IN (20004,20007,20050); INSERT INTO `worldstates` (`entry`, `value`, `comment`) VALUES (20004,0,'CleaningFlags'), -(20007,0,'NextMonthlyQuestResetTime'); +(20007,0,'NextMonthlyQuestResetTime'), +(20050,0,'NextWeeklyGuildResetTime'); diff --git a/sql/old/3.3.5a/TDB52_to_TDB53_updates/world/2013_07_24_00_world_spell_script_names.sql b/sql/old/3.3.5a/TDB52_to_TDB53_updates/world/2013_07_24_00_world_spell_script_names.sql deleted file mode 100644 index 8c156fb2e57..00000000000 --- a/sql/old/3.3.5a/TDB52_to_TDB53_updates/world/2013_07_24_00_world_spell_script_names.sql +++ /dev/null @@ -1,11 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id` IN (63310,50421,23780,33896,37594,37705,23551,23552,23572); -INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES -(63310,'spell_warl_glyph_of_shadowflame'), -(50421,'spell_dk_scent_of_blood'), -(23780,'spell_item_aegis_of_preservation'), -(33896,'spell_item_desperate_defense'), -(37594,'spell_pri_item_greater_heal_refund'), -(37705,'spell_pal_item_healing_discount'), -(23551,'spell_sha_item_lightning_shield'), -(23552,'spell_sha_item_lightning_shield_trigger'), -(23572,'spell_sha_item_mana_surge'); |