diff options
Diffstat (limited to 'sql/old')
6 files changed, 7 insertions, 4 deletions
diff --git a/sql/old/3.3.5a/2011_12_13_00_world_misc.sql b/sql/old/3.3.5a/2011_12_13_00_world_misc.sql index 13958e75761..48848c368f1 100644 --- a/sql/old/3.3.5a/2011_12_13_00_world_misc.sql +++ b/sql/old/3.3.5a/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/2011_12_13_01_world_achievement_criteria_data.sql b/sql/old/3.3.5a/2011_12_13_01_world_achievement_criteria_data.sql index 89bbfc7126d..9f3f22d7792 100644 --- a/sql/old/3.3.5a/2011_12_13_01_world_achievement_criteria_data.sql +++ b/sql/old/3.3.5a/2011_12_13_01_world_achievement_criteria_data.sql @@ -9,4 +9,4 @@ INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`, (7178,5,49346,1,''), -- Emerald Drake (7178,12,1,0, ''), -- hc mode only (7179,5,49464,1,''), -- Ruby Drake -(7179,12,1,0, ''); -- hc mode only +(7179,12,1,0, ''); -- hc mode only
\ No newline at end of file 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/2011_12_16_00_world_creature_template.sql b/sql/old/3.3.5a/2011_12_16_00_world_creature_template.sql index 3ff9d630c54..156fd431359 100644 --- a/sql/old/3.3.5a/2011_12_16_00_world_creature_template.sql +++ b/sql/old/3.3.5a/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/2011_12_16_00_world_spell_bonus_data.sql b/sql/old/3.3.5a/2011_12_16_00_world_spell_bonus_data.sql index 5864b9ac042..3250bda4fdb 100644 --- a/sql/old/3.3.5a/2011_12_16_00_world_spell_bonus_data.sql +++ b/sql/old/3.3.5a/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 |