diff options
Diffstat (limited to 'sql/old/3.3.5a')
9 files changed, 13 insertions, 21 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_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 diff --git a/sql/old/3.3.5a/2012_08_06_00_world_command.sql b/sql/old/3.3.5a/2012_08_06_00_world_command.sql deleted file mode 100644 index 50628aaa589..00000000000 --- a/sql/old/3.3.5a/2012_08_06_00_world_command.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `command` WHERE `name` IN ('server togglequerylog', 'server set loglevel'); - -INSERT INTO `command` (`name`,`security`,`help`) VALUES -('server set loglevel',4,'Syntax: .server set loglevel $facility $name $loglevel. $facility can take the values: appender (a) or logger (l). $loglevel can take the values: disabled (0), trace (1), debug (2), info (3), warn (4), error (5) or fatal (6)'); diff --git a/sql/old/3.3.5a/2012_08_07_00_characters_characters.sql b/sql/old/3.3.5a/2012_08_07_00_characters_characters.sql deleted file mode 100644 index e9bea82ad4b..00000000000 --- a/sql/old/3.3.5a/2012_08_07_00_characters_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE characters SET drunk = (drunk / 256) & 0xFF; -ALTER TABLE characters CHANGE drunk drunk tinyint(3) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/old/3.3.5a/2012_09_09_02_world_spell_script_names.sql b/sql/old/3.3.5a/2012_09_09_02_world_spell_script_names.sql index 36e5b08c36d..a4304663d9c 100644 --- a/sql/old/3.3.5a/2012_09_09_02_world_spell_script_names.sql +++ b/sql/old/3.3.5a/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/2012_12_18_00_character_worldstates.sql b/sql/old/3.3.5a/2012_12_18_00_character_worldstates.sql index 98fabde6776..c6fc15e60b7 100644 --- a/sql/old/3.3.5a/2012_12_18_00_character_worldstates.sql +++ b/sql/old/3.3.5a/2012_12_18_00_character_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'); |