diff options
Diffstat (limited to 'sql/old')
24 files changed, 968 insertions, 0 deletions
diff --git a/sql/old/4.3.4/2012_10_15_00_world_phase_definitions_434.sql b/sql/old/4.3.4/2012_10_15_00_world_phase_definitions_434.sql new file mode 100644 index 00000000000..b8e97278eb5 --- /dev/null +++ b/sql/old/4.3.4/2012_10_15_00_world_phase_definitions_434.sql @@ -0,0 +1,66 @@ +DROP TABLE IF EXISTS `phase_definitions`; +CREATE TABLE `phase_definitions` ( + `zoneId` mediumint(7) unsigned NOT NULL DEFAULT '0', + `entry` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `phasemask` bigint(20) unsigned NOT NULL DEFAULT '0', + `phaseId` tinyint(3) unsigned NOT NULL DEFAULT '0', + `terrainswapmap` smallint(5) unsigned NOT NULL DEFAULT '0', + `flags` tinyint(3) unsigned DEFAULT '0', + `comment` text, + PRIMARY KEY (`zoneId`, `entry`) +) +AUTO_INCREMENT=1 +ENGINE=MyISAM +COLLATE='utf8_general_ci'; + +INSERT INTO `phase_definitions` (`zoneId`, `entry`, `phasemask`, `phaseId`, `terrainswapmap`, `flags`, `comment`) VALUES +(1519, 1, 129, 0, 0, 0, 'Stormwind: [A] Heros Call: Vashj''ir'), +(1519, 2, 257, 0, 0, 0, 'Stormwind: [A] Heros Call: Hyjal'), +(1519, 3, 513, 0, 0, 0, 'Stormwind: [A] Heros Call: Deepholm'), +(1519, 4, 1025, 0, 0, 0, 'Stormwind: [A] Heros Call: Uldum'), +(1519, 5, 2049, 0, 0, 0, 'Stormwind: [A] Heros Call: Twilight Highlands'), +(1637, 1, 129, 0, 0, 0, 'Orgrimmar: [H] Warchiefs Command: Vashj''ir'), +(1637, 2, 257, 0, 0, 0, 'Orgrimmar: [H] Warchiefs Command: Hyjal'), +(1637, 3, 513, 0, 0, 0, 'Orgrimmar: [H] Warchiefs Command: Deepholm'), +(1637, 4, 1025, 0, 0, 0, 'Orgrimmar: [H] Warchiefs Command: Uldum'), +(1637, 5, 2049, 0, 0, 0, 'Orgrimmar: [H] Warchiefs Command: Twilight Highlands'), +(616 , 1, 0 , 165, 719, 0, 'Mount Hyjal: Default Terrainswap'); + +DROP TABLE IF EXISTS `spell_phase`; +CREATE TABLE `spell_phase` ( + `id` mediumint(7) unsigned NOT NULL DEFAULT '0', + `phasemask` bigint(20) unsigned NOT NULL DEFAULT '1', + `terrainswapmap` smallint(5) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) +AUTO_INCREMENT=1 +ENGINE=MyISAM +COLLATE='utf8_general_ci'; + +DELETE FROM `trinity_string` WHERE `entry` BETWEEN 176 AND 182; +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES +(176, '|cff0099FFPhaseMgr: Report for player: %s, zoneId: %u, level: %u, team: %u, phaseupdateflag: %u|r'), +(177, '|cff663399PhaseMgr: There are no definitions defined for zoneId %u.|r'), +(178, '|cff0066FFPhaseMgr: Success (entry: %u) - added %s %u to the players phase.|r'), +(179, '|cffFF0000PhaseMgr: Condition for phase %u (entry: %u, zoneId: %u) failed.|r'), +(180, '|cffFF0000PhaseMgr: Condition for phase %u (entry: %u, zoneId: %u) has last phasemask flag. Skipped other definitions.|r'), +(181, '|cff6699FFPhaseMgr: The player gets phasemask %u through definitions, %u through phasing auras, and phase %u through custom phase.|r'), +(182, '|cff0099FFPhaseMgr: The player has phasemask %u (real: %u).|r'); + +DELETE FROM `command` WHERE `name` IN('debug phase', 'debug send setphaseshift'); +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('debug phase', 1, 'Syntax: .debug phase\r\n\r\nSends a phase debug report of a player to you.'); + +/* +Conditions (SourceGroup -> ZoneId, SourceEntry -> Entry) + +If you visit the Gm Island as a alliance race you are automatically phased into phase 2. + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=23 AND `SourceGroup`=876 AND `SourceEntry`=1; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(23, 876, 1, 0, 0, 6, 0, 469, 0, 0, 0, 0, '', 'Phase Definitions Example: Phase is only visible for Alliance Members'); + +DELETE FROM `phase_definitions` WHERE `zoneId`=876 AND `entry`=1; +INSERT INTO `phase_definitions` (`zoneId`, `entry`, `phasemask`, `phaseId`, `terrainswapmap`, `flags`, `comment`) VALUES +(876, 1, 2, 0, 0, 0, '[Example] Gm Island'); +*/ diff --git a/sql/old/4.3.4/2012_10_15_01_world_spell_script_names_434.sql b/sql/old/4.3.4/2012_10_15_01_world_spell_script_names_434.sql new file mode 100644 index 00000000000..c3390573bc2 --- /dev/null +++ b/sql/old/4.3.4/2012_10_15_01_world_spell_script_names_434.sql @@ -0,0 +1,2 @@ +UPDATE `spell_script_names` SET `spell_id`=755 WHERE `spell_id`=-755; +UPDATE `spell_script_names` SET `spell_id`=1535 WHERE `spell_id`=-1535; diff --git a/sql/old/4.3.4/2012_10_15_02_world_spell_script_names_434.sql b/sql/old/4.3.4/2012_10_15_02_world_spell_script_names_434.sql new file mode 100644 index 00000000000..d0876fa3cc6 --- /dev/null +++ b/sql/old/4.3.4/2012_10_15_02_world_spell_script_names_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `scriptname`='spell_sha_astral_shift'; diff --git a/sql/old/4.3.4/2012_11_17_00_world_spell_script_names_434.sql b/sql/old/4.3.4/2012_11_17_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..13eac8b301e --- /dev/null +++ b/sql/old/4.3.4/2012_11_17_00_world_spell_script_names_434.sql @@ -0,0 +1,4 @@ +-- 120 Cone of Cold +DELETE FROM `spell_script_names` WHERE `spell_id` IN (120); +INSERT INTO `spell_script_names` VALUES +(120, "spell_mage_cone_of_cold"); diff --git a/sql/old/4.3.4/2012_11_20_00_world_misc_434.sql b/sql/old/4.3.4/2012_11_20_00_world_misc_434.sql new file mode 100644 index 00000000000..c0a95134b0a --- /dev/null +++ b/sql/old/4.3.4/2012_11_20_00_world_misc_434.sql @@ -0,0 +1,39 @@ +-- Mark of the Wild +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=1126; +DELETE FROM `spell_script_names` WHERE `spell_id`=1126 OR `ScriptName`='spell_dru_mark_of_the_wild'; +INSERT INTO `spell_script_names` VALUES +(1126,'spell_dru_mark_of_the_wild'); + +-- Arcane Brilliance +DELETE FROM `spell_script_names` WHERE `spell_id`=1459 OR `ScriptName`='spell_mage_arcane_brilliance'; +INSERT INTO `spell_script_names` VALUES +(1459,'spell_mage_arcane_brilliance'); + +-- Dalaran Brilliance +DELETE FROM `spell_script_names` WHERE `spell_id`=61316 OR `ScriptName`='spell_mage_dalaran_brilliance'; +INSERT INTO `spell_script_names` VALUES +(61316,'spell_mage_dalaran_brilliance'); + +-- Blessing of Kings +DELETE FROM `spell_script_names` WHERE `spell_id`=20217 OR `ScriptName`='spell_pal_blessing_of_kings'; +INSERT INTO `spell_script_names` VALUES +(20217,'spell_pal_blessing_of_kings'); + +-- Blessing of Might +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=19740; +DELETE FROM `spell_script_names` WHERE `spell_id`=19740 OR `ScriptName`='spell_pal_blessing_of_might'; +INSERT INTO `spell_script_names` VALUES +(19740,'spell_pal_blessing_of_might'); + +-- Power Word: Fortitude +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=21562; +DELETE FROM `spell_script_names` WHERE `spell_id`=21562 OR `ScriptName`='spell_pri_power_word_fortitude'; +INSERT INTO `spell_script_names` VALUES +(21562,'spell_pri_power_word_fortitude'); + +-- Shadow Protection +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=27683; +DELETE FROM `spell_scripts` WHERE `id`=27683; +DELETE FROM `spell_script_names` WHERE `spell_id`=27683 OR `ScriptName`='spell_pri_shadow_protection'; +INSERT INTO `spell_script_names` VALUES +(27683,'spell_pri_shadow_protection'); diff --git a/sql/old/4.3.4/2012_11_21_00_world_misc_434.sql b/sql/old/4.3.4/2012_11_21_00_world_misc_434.sql new file mode 100644 index 00000000000..131dd94585d --- /dev/null +++ b/sql/old/4.3.4/2012_11_21_00_world_misc_434.sql @@ -0,0 +1,3 @@ +-- -------- +DELETE FROM `command` WHERE `name`='flusharenapoints'; +DELETE FROM `trinity_string` WHERE `entry` IN ('741','742','743','744','745','746'); diff --git a/sql/old/4.3.4/2012_11_22_00_world_command_434.sql b/sql/old/4.3.4/2012_11_22_00_world_command_434.sql new file mode 100644 index 00000000000..41da2d208b7 --- /dev/null +++ b/sql/old/4.3.4/2012_11_22_00_world_command_434.sql @@ -0,0 +1,6 @@ +-- -------- +DELETE FROM `command` WHERE `name` = 'modify arenapoints'; + +DELETE FROM `command` WHERE `name` = 'modify currency'; +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('modify currency', 2, 'Syntax: .modify currency #id #value\nAdd $amount (without precision) of $currency to the selected player.'); diff --git a/sql/old/4.3.4/2012_11_25_02_world_spell_script_names_434.sql b/sql/old/4.3.4/2012_11_25_02_world_spell_script_names_434.sql new file mode 100644 index 00000000000..f0dd277cc96 --- /dev/null +++ b/sql/old/4.3.4/2012_11_25_02_world_spell_script_names_434.sql @@ -0,0 +1,9 @@ +DELETE FROM spell_linked_spell WHERE spell_trigger = 73325; +INSERT INTO spell_linked_spell (spell_trigger, spell_effect, type, comment) VALUES +(73325, 92833, 0, "Priest - Leap of Faith"); + +DELETE FROM spell_script_names WHERE spell_id = 92833; +DELETE FROM spell_script_names WHERE spell_id = -139; +INSERT INTO spell_script_names (spell_id, ScriptName) VALUES +(92833, "spell_pri_leap_of_faith_effect_trigger"), +(139, "spell_pri_renew"); -- Minus doesnt matter, theres no rank any more diff --git a/sql/old/4.3.4/2012_12_01_00_world_spell_script_names_434.sql b/sql/old/4.3.4/2012_12_01_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..bd13cb8ef9d --- /dev/null +++ b/sql/old/4.3.4/2012_12_01_00_world_spell_script_names_434.sql @@ -0,0 +1,16 @@ +-- Conjure Refreshment +DELETE FROM `spell_script_names` WHERE `spell_id`=42955; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(42955, 'spell_mage_conjure_refreshment'); + +-- Sacred Shield +DELETE FROM spell_proc_event WHERE entry=85285; +INSERT INTO spell_proc_event (entry, Cooldown) VALUES(85285, 60); +DELETE FROM spell_script_names WHERE spell_id=85285; +INSERT INTO spell_script_names (spell_id, ScriptName) VALUES +(85285, 'spell_pal_sacred_shield'); + +-- Recuperate +DELETE FROM spell_script_names WHERE spell_id=73651; +INSERT INTO spell_script_names (spell_id, ScriptName) VALUES +(73651, "spell_rog_recuperate"); diff --git a/sql/old/4.3.4/2012_12_02_00_world_spell_group_misc_434.sql b/sql/old/4.3.4/2012_12_02_00_world_spell_group_misc_434.sql new file mode 100644 index 00000000000..52e6a041f2e --- /dev/null +++ b/sql/old/4.3.4/2012_12_02_00_world_spell_group_misc_434.sql @@ -0,0 +1,22 @@ +SET @GROUP = 1121; +DELETE FROM `spell_group_stack_rules` WHERE `group_id`=@GROUP; +INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES +(@GROUP, 1); -- SPEL_GROUP_STACK_RULE_EXCLUSIVE + +DELETE FROM `spell_group` WHERE `id`=@GROUP; +INSERT INTO `spell_group` (`id`,`spell_id`) VALUES +(@GROUP, 73413), -- Inner will +(@GROUP, 588); -- Inner fire + +-- Adding missing proc event for Fingers of Frost (Rank 3) +DELETE FROM `spell_proc_event` WHERE `entry`=83074; +INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES +(83074, 0, 3, 1049120, 4096, 0, 65536, 0, 0, 20, 0); + +-- Updating spell_learn_spell's spell IDs range... +ALTER TABLE `spell_learn_spell` MODIFY `entry` MEDIUMINT(8) NOT NULL; +ALTER TABLE `spell_learn_spell` MODIFY `SpellID` MEDIUMINT(8) NOT NULL; +-- ...So we can have sinister strike's combo point enabler. +DELETE FROM `spell_learn_spell` WHERE `SpellID`=79327 AND `entry`=2098; +INSERT INTO `spell_learn_spell` (`entry`,`SpellID`,`Active`) VALUES +(2098, 79327, 0); diff --git a/sql/old/4.3.4/2012_12_24_00_world_spell_script_names_434.sql b/sql/old/4.3.4/2012_12_24_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..d95da8f3239 --- /dev/null +++ b/sql/old/4.3.4/2012_12_24_00_world_spell_script_names_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_damage_reduction_aura'; diff --git a/sql/old/4.3.4/2012_12_24_09_world_halls_of_origination_434.sql b/sql/old/4.3.4/2012_12_24_09_world_halls_of_origination_434.sql new file mode 100644 index 00000000000..940f3407f23 --- /dev/null +++ b/sql/old/4.3.4/2012_12_24_09_world_halls_of_origination_434.sql @@ -0,0 +1,50 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=76599; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 76599, 0, 0, 31, 0, 5, 207218, 0, 0, 0, 0, '', 'Activate Beacons - Beacon of Light'), +(13, 1, 76599, 0, 1, 31, 0, 5, 207219, 0, 0, 0, 0, '', 'Activate Beacons - Beacon of Light'), +(13, 1, 76599, 0, 2, 31, 0, 5, 203133, 0, 0, 0, 0, '', 'Activate Beacons - Beacon of Light'), +(13, 1, 76599, 0, 3, 31, 0, 5, 203136, 0, 0, 0, 0, '', 'Activate Beacons - Beacon of Light'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=75194; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 75194, 0, 0, 31, 0, 3, 40283, 0, 0, 0, 0, '', 'Burning Light - Searing Light'); + +UPDATE `creature_template` SET `ScriptName`='boss_temple_guardian_anhuur' WHERE `entry`=39425; +UPDATE `creature_template` SET `ScriptName`='',`unit_flags`=`unit_flags`|0x00000040|0x00008000 WHERE `entry`=40183; + +DELETE FROM `spell_target_position` WHERE `id`=74969; +INSERT INTO `spell_target_position` (`id`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`) VALUES +(74969, 644, -640.437, 335.306, 77.7573, 1.52073); + +UPDATE `instance_template` SET `script`='instance_halls_of_origination' WHERE `map`=644; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (76573,74930); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 2, 74930, 0, 0, 31, 0, 3, 40183, 0, 0, 0, 0, '', 'Shield of Light - Cave In Stalker'), +(13, 2, 76573, 0, 0, 31, 0, 3, 40183, 0, 0, 0, 0, '', 'Shield of Light - Cave In Stalker'); + +DELETE FROM `spell_script_names` WHERE `spell_id` IN (74930,76573,76599,76606,76608); +INSERT INTO `spell_script_names`(`spell_id`,`ScriptName`) VALUES +(74930, 'spell_anhuur_shield_of_light'), +(76573, 'spell_anhuur_shield_of_light'), +(76599, 'spell_anhuur_activate_beacons'), +(76606, 'spell_anhuur_disable_beacon_beams'), +(76608, 'spell_anhuur_disable_beacon_beams'), +(75592, 'spell_anhuur_divine_reckoning'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (76606,76608); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,76606,0,0,31,0,3,40183,0,0,0,'','Disable Beacon Beams L - Cave In Stalker'), +(13,1,76608,0,0,31,0,3,40183,0,0,0,'','Disable Beacon Beams R - Cave In Stalker'); + +DELETE FROM `creature_text` WHERE `entry`=39425; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES +(39425, 0, 0, 'Turn back, intruders! These halls must not be disturbed!', 14, 0, 100, 0, 0, 18580, 'Temple Guardian Anhuur - SAY_AGGRO'), +(39425, 1, 0, 'Beacons of light, bestow upon me your aegis!', 14, 0, 100, 0, 0, 18581, 'Temple Guardian Anhuur - SAY_SHIELD'), +(39425, 2, 0, '%s becomes protected by his defense beacons! Disable them by pulling the levers below!', 41, 0, 100, 0, 0, 0, 'Temple Guardian Anhuur - EMOTE_SHIELD'), +(39425, 3, 0, '%s is no longer protected by the beacons!', 41, 0, 100, 0, 0, 0, 'Temple Guardian Anhuur'), +(39425, 4, 0, 'I regret nothing.', 14, 0, 100, 0, 0, 18582, 'Temple Guardian Anhuur'), +(39425, 5, 0, 'What... have you... done?', 14, 0, 100, 0, 0, 18579, 'Temple Guardian Anhuur - SAY_DEATH'); + +-- Template updates for creature 40283 (Searing Light) +UPDATE `creature_template` SET `faction_A`=14,`faction_H`=14,`minlevel`=80,`maxlevel`=80,`baseattacktime`=2000,`unit_flags`=`unit_flags`|33555008 WHERE `entry`=40283; -- Searing Light diff --git a/sql/old/4.3.4/2012_12_25_01_world_halls_of_origination_434.sql b/sql/old/4.3.4/2012_12_25_01_world_halls_of_origination_434.sql new file mode 100644 index 00000000000..7b2cd1a7245 --- /dev/null +++ b/sql/old/4.3.4/2012_12_25_01_world_halls_of_origination_434.sql @@ -0,0 +1,55 @@ +DELETE FROM `creature_text` WHERE `entry`=39428; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES +(39428, 0, 0, 'More carrion for the swarm...', 14, 0, 100, 0, 0, 18906, 'Earthrager Ptah - SAY_AGGRO'), +(39428, 1, 0, 'Ptah... is... no more...', 14, 0, 100, 0, 0, 18905, 'Earthrager Ptah - SAY_DEATH'); + +DELETE FROM `spell_script_names` WHERE `spell_id` IN (75540,89881,94974,75519); +INSERT INTO `spell_script_names` VALUES +(75540,'spell_earthrager_ptah_flame_bolt'), +(89881,'spell_earthrager_ptah_flame_bolt'), +(75519 ,'spell_earthrager_ptah_explosion'), +(94974,'spell_earthrager_ptah_earth_spike'); + +UPDATE `creature_template` SET `ScriptName`='boss_earthrager_ptah' WHERE `Entry`=39428; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=89398; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 6, 89398, 0, 0, 31, 0, 3, 39443, 0, 0, 0, 0, '', 'Earth Spike - Camel'); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=39443; +INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`cast_flags`,`user_type`) VALUES +(39443,89397,1,0); + +-- Jeweled Scarab SAI +SET @ENTRY := 40458; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,1,54,0,100,0,0,0,0,0,91,9,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Jeweled Scarab - On just summoned - Remove field byte for submerged'), +(@ENTRY,0,1,0,61,0,100,0,0,0,0,0,11,65982,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Jeweled Scarab - Linked - Cast emerge'), +(@ENTRY,0,2,0,1,0,100,1,2500,2500,2500,2500,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0, 'Jeweled Scarab - OOC (one time) - Attack player in 100 yards'), +(@ENTRY,0,3,4,6,0,100,0,0,0,0,0,45,0,1,0,0,0,0,11,39428,100,0,0,0,0,0, 'Jeweled Scarab - On death - Set data 0 - 1'), +(@ENTRY,0,4,0,61,0,100,0,0,0,0,0,90,9,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Jeweled Scarab - Linked - Add again byte for submerged'); + +-- Dustbone Horror SAI +SET @ENTRY := 40450; +SET @SPELL := 75453; -- Smash +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,54,0,100,0,0,0,0,0,91,9,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Dustbone Horror - On just summoned - Remove field byte 1 for submerged'), +(@ENTRY,0,1,0,1,0,100,1,2500,2500,2500,2500,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0, 'Dustbone Horror - OOC (one time) - Attack player in 100 yards'), +(@ENTRY,0,2,0,0,0,100,0,10000,12000,10000,12000,11,@SPELL,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Dustbone Horror - Combat - Cast Smash'), +(@ENTRY,0,3,4,6,0,100,0,0,0,0,0,45,0,1,0,0,0,0,11,39428,100,0,0,0,0,0, 'Dustbone Horror - On death - Set data 0 - 1'), +(@ENTRY,0,4,0,61,0,100,0,0,0,0,0,90,9,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Dustbone Horror - Linked - Add again byte for submerged'); + +-- Add creature_addon data +DELETE FROM `creature_template_addon` WHERE `entry` IN (40458,40450); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(40458,0,0,9,1,0,NULL), +(40450,0,0,9,1,0,NULL); + +SET @QUICKSAND := 75548; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@QUICKSAND; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@QUICKSAND,0,0,0,54,0,100,0,0,0,0,0,11,40503,0,0,0,0,0,1,0,0,0,0,0,0,0,'Quicksand - On summoned (spawned) - Cast spell'); diff --git a/sql/old/4.3.4/2012_12_26_00_world_spell_script_names_434.sql b/sql/old/4.3.4/2012_12_26_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..c1c7a8db271 --- /dev/null +++ b/sql/old/4.3.4/2012_12_26_00_world_spell_script_names_434.sql @@ -0,0 +1,39 @@ +-- Blast Wave +DELETE FROM `spell_script_names` WHERE `spell_id`=11113 OR `ScriptName`='spell_mage_blast_wave'; +INSERT INTO `spell_script_names` VALUES +(11113,'spell_mage_blast_wave'); + +-- Blizzard +DELETE FROM `spell_script_names` WHERE `spell_id`=42208 OR `ScriptName`='spell_mage_blizzard'; +INSERT INTO `spell_script_names` VALUES +(42208,'spell_mage_blizzard'); + +-- Frostbolt +DELETE FROM `spell_script_names` WHERE `spell_id`=116 OR `ScriptName`='spell_mage_frostbolt'; +INSERT INTO `spell_script_names` VALUES +(116,'spell_mage_frostbolt'); + +-- Ice Barrier +DELETE FROM `spell_script_names` WHERE `spell_id`=11426 OR `ScriptName`='spell_mage_ice_barrier'; +INSERT INTO `spell_script_names` VALUES +(11426,'spell_mage_ice_barrier'); + +-- Mana Shield +DELETE FROM `spell_script_names` WHERE `spell_id`=1463 OR `ScriptName`='spell_mage_mana_shield' OR `ScriptName`='spell_mage_incanters_absorbtion_manashield'; +INSERT INTO `spell_script_names` VALUES +(1463,'spell_mage_mana_shield'); + +-- Mage Ward +DELETE FROM `spell_script_names` WHERE `spell_id`=543 OR `ScriptName`='spell_mage_mage_ward' OR `ScriptName`='spell_mage_incanters_absorbtion_absorb'; +INSERT INTO `spell_script_names` VALUES +(543,'spell_mage_mage_ward'); + +-- Replenish Mana (Mana Gem) +DELETE FROM `spell_script_names` WHERE `spell_id`=5405 OR `ScriptName`='spell_mage_replenish_mana'; +INSERT INTO `spell_script_names` VALUES +(5405,'spell_mage_replenish_mana'); + +-- Water Elemental's Freeze +DELETE FROM `spell_script_names` WHERE `spell_id`=33395 OR `ScriptName`='spell_mage_water_elemental_freeze'; +INSERT INTO `spell_script_names` VALUES +(33395,'spell_mage_water_elemental_freeze'); diff --git a/sql/old/4.3.4/2012_12_27_00_world_spelldifficulty_dbc_434.sql b/sql/old/4.3.4/2012_12_27_00_world_spelldifficulty_dbc_434.sql new file mode 100644 index 00000000000..569e6eb7178 --- /dev/null +++ b/sql/old/4.3.4/2012_12_27_00_world_spelldifficulty_dbc_434.sql @@ -0,0 +1 @@ +DELETE FROM `spelldifficulty_dbc` WHERE `id` IN(3000,3001,3002,3003,3004,3005,3006,3007,3008,3009,3010,3011,3012,3013,3014,3015,3016,3017,3018,3019,3020,3021,3022,3023,3024,3025,3026,3027,3028,3029,3030,3031,3032,3033,3034,3035,3036,3037,3038,3039,3040,3041,3042,3043,3044,3045,3046,3047,3049,3050,3051,3052,3053,3054,3062,3064,3065,3066,3067,3068,3069,3070,3071,3072,3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3108,3109,3111,3112,3113,3114,3115,3116,3117,3118,3120,3121,3122,3123,3124,3125,3126,3127,3128,3129,3130,3131,3133,3137,3138,3139,3140,3141,3142,3143,3144,3145,3146,3147,3148,3149,3150,3151,3152,3153,3154,3155,3156,3157,3158,3159,3160,3161,3162,3163,3164,3165,3166,3167,3168,3169,3170,3171,3172,3173,3174,3175,3176,3177,3178,3179,3180,3181,3182,3183,3184,3185,3186,3187,3188,3189,3190,3191,3192,3193,3194,3200,3201,3202,3203,3204,3205,3206,3240,3241,3242,3243,3244,3245,3246,3247,3248,3249,3250,3251,3252,3253,3254,3255,3256,3257,3258,3259,3260,3261,3262,3263,3264,3265,3266,3267,3268,3269,3270); diff --git a/sql/old/4.3.4/2012_12_27_01_world_achievement_dbc_434.sql b/sql/old/4.3.4/2012_12_27_01_world_achievement_dbc_434.sql new file mode 100644 index 00000000000..8229f489add --- /dev/null +++ b/sql/old/4.3.4/2012_12_27_01_world_achievement_dbc_434.sql @@ -0,0 +1,418 @@ +TRUNCATE TABLE `achievement_dbc`; +INSERT INTO `achievement_dbc` (`ID`, `flags`, `count`) VALUES +(3376,0x2,1), +(3377,0x2,1), +(3378,0x2,1), +(3379,0x2,1), +(3380,0x2,1), +(3381,0x2,1), +(3382,0x2,1), +(3383,0x2,1), +(3384,0x2,1), +(3385,0x2,1), +(3386,0x2,1), +(3387,0x2,1), +(3388,0x2,1), +(3390,0x2,1), +(3389,0x2,1), +(3391,0x2,1), +(3392,0x2,1), +(3393,0x2,1), +(3394,0x2,1), +(3396,0x2,1), +(3398,0x2,1), +(3395,0x2,1), +(3397,0x2,1), +(3399,0x2,1), +(3400,0x2,1), +(3401,0x2,1), +(3402,0x2,1), +(3403,0x2,1), +(3404,0x2,1), +(3405,0x2,1), +(3406,0x2,1), +(3407,0x2,1), +(3408,0x2,1), +(3409,0x2,1), +(3410,0x2,1), +(3411,0x2,1), +(3696,0x2,1), +(4056,0x2,1), +(4276,0x2,1), +(4277,0x2,1), +(4278,0x2,1), +(4279,0x2,1), +(4280,0x2,1), +(4281,0x2,1), +(4282,0x2,1), +(4283,0x2,1), +(4284,0x2,1), +(4285,0x2,1), +(4057,0x2,1), +(4058,0x2,1), +(4059,0x2,1), +(4060,0x2,1), +(4061,0x2,1), +(4063,0x2,1), +(4062,0x2,1), +(4064,0x2,1), +(4065,0x2,1), +(4066,0x2,1), +(4067,0x2,1), +(4068,0x2,1), +(4070,0x2,1), +(4069,0x2,1), +(4071,0x2,1), +(4072,0x2,1), +(4073,0x2,1), +(4076,0x2,1), +(4077,0x2,1), +(4376,0x2,1), +(4416,0x2,1), +(4417,0x2,1), +(4689,0x2,1), +(4690,0x2,1), +(4691,0x2,1), +(4692,0x2,1), +(4693,0x2,1), +(4694,0x2,1), +(4695,0x2,1), +(4696,0x2,1), +(4697,0x2,1), +(4698,0x2,1), +(4699,0x2,1), +(4700,0x2,1), +(4701,0x2,1), +(4702,0x2,1), +(4703,0x2,1), +(4704,0x2,1), +(4705,0x2,1), +(4706,0x2,1), +(4707,0x2,1), +(4708,0x2,1), +(4709,0x2,1), +(4712,0x2,1), +(4710,0x2,1), +(4711,0x2,1), +(4731,0x2,1), +(4732,0x2,1), +(4733,0x2,1), +(4734,0x2,1), +(4735,0x2,1), +(4736,0x2,1), +(4737,0x2,1), +(4738,0x2,1), +(4739,0x2,1), +(4740,0x2,1), +(4741,0x2,1), +(4742,0x2,1), +(4743,0x2,1), +(4744,0x2,1), +(4745,0x2,1), +(4746,0x2,1), +(4747,0x2,1), +(4748,0x2,1), +(4749,0x2,1), +(4750,0x2,1), +(4751,0x2,1), +(4752,0x2,1), +(4753,0x2,1), +(4754,0x2,1), +(4755,0x2,1), +(4756,0x2,1), +(4757,0x2,1), +(4758,0x2,1), +(4759,0x2,1), +(4760,0x2,1), +(4761,0x2,1), +(4762,0x2,1), +(4763,0x2,1), +(4764,0x2,1), +(4765,0x2,1), +(4766,0x2,1), +(4767,0x2,1), +(4768,0x2,1), +(4769,0x2,1), +(4770,0x2,1), +(4771,0x2,1), +(4772,0x2,1), +(4773,0x2,1), +(4774,0x2,1), +(4775,0x2,1), +(4776,0x2,1), +(4788,0x2,1), +(4789,0x2,1), +(4791,0x2,1), +(4792,0x2,1), +(4793,0x2,1), +(4794,0x2,1), +(4795,0x2,1), +(5544,0x2,1), +(5545,0x2,1), +(5579,0x2,1), +(5580,0x2,1), +(5581,0x2,1), +(5582,0x2,1), +(5583,0x2,1), +(5584,0x2,1), +(5585,0x2,1), +(5586,0x2,1), +(5587,0x2,1), +(5588,0x2,1), +(5589,0x2,1), +(5590,0x2,1), +(5591,0x2,1), +(5593,0x2,1), +(5592,0x2,1), +(5594,0x2,1), +(5595,0x2,1), +(5596,0x2,1), +(5597,0x2,1), +(5598,0x2,1), +(5599,0x2,1), +(5601,0x2,1), +(5600,0x2,1), +(5602,0x2,1), +(5603,0x2,1), +(5604,0x2,1), +(5605,0x2,1), +(5606,0x2,1), +(5607,0x2,1), +(5608,0x2,1), +(5609,0x2,1), +(5610,0x2,1), +(5611,0x2,1), +(5612,0x2,1), +(5613,0x2,1), +(5614,0x2,1), +(5615,0x2,1), +(5616,0x2,1), +(5618,0x2,1), +(5617,0x2,1), +(5619,0x2,1), +(5620,0x2,1), +(5621,0x2,1), +(5622,0x2,1), +(5623,0x2,1), +(5624,0x2,1), +(5625,0x2,1), +(5626,0x2,1), +(5627,0x2,1), +(5629,0x2,1), +(5628,0x2,1), +(5630,0x2,1), +(5651,0x2,1), +(5652,0x2,1), +(5653,0x2,1), +(5654,0x2,1), +(5655,0x2,1), +(5656,0x2,1), +(5657,0x2,1), +(5658,0x2,1), +(5659,0x2,1), +(5660,0x2,1), +(5661,0x2,1), +(5662,0x2,1), +(5663,0x2,1), +(5664,0x2,1), +(5665,0x2,1), +(5666,0x2,1), +(5667,0x2,1), +(5668,0x2,1), +(5669,0x2,1), +(5670,0x2,1), +(5671,0x2,1), +(5672,0x2,1), +(5673,0x2,1), +(5674,0x2,1), +(5675,0x2,1), +(5676,0x2,1), +(5677,0x2,1), +(5678,0x2,1), +(5679,0x2,1), +(5680,0x2,1), +(5681,0x2,1), +(5682,0x2,1), +(5683,0x2,1), +(5684,0x2,1), +(5685,0x2,1), +(5686,0x2,1), +(5687,0x2,1), +(5688,0x2,1), +(5689,0x2,1), +(5690,0x2,1), +(5691,0x2,1), +(5696,0x2,1), +(5697,0x2,1), +(5698,0x2,1), +(5699,0x2,1), +(5700,0x2,1), +(5701,0x2,1), +(5702,0x2,1), +(5703,0x2,1), +(5704,0x2,1), +(5705,0x2,1), +(5706,0x2,1), +(5707,0x2,1), +(5763,0x2,1), +(5775,0x2,1), +(5776,0x2,1), +(5777,0x2,1), +(5778,0x2,1), +(5792,0x2,1), +(5125,0x2,1), +(5825,0x2,1), +(5826,0x2,1), +(5831,0x2,1), +(5832,0x2,1), +(5893,0x2,1), +(5894,0x2,1), +(5895,0x2,1), +(5896,0x2,1), +(5897,0x2,1), +(5898,0x2,1), +(5899,0x2,1), +(5900,0x2,1), +(5909,0x2,1), +(5910,0x2,1), +(5911,0x2,1), +(5912,0x2,1), +(5913,0x2,1), +(5914,0x2,1), +(5915,0x2,1), +(5916,0x2,1), +(5917,0x2,1), +(5918,0x2,1), +(5919,0x2,1), +(5920,0x2,1), +(5921,0x2,1), +(5922,0x2,1), +(5923,0x2,1), +(5924,0x2,1), +(5925,0x2,1), +(5926,0x2,1), +(5927,0x2,1), +(5928,0x2,1), +(5929,0x2,1), +(5930,0x2,1), +(5931,0x2,1), +(5932,0x2,1), +(5933,0x2,1), +(5934,0x2,1), +(5935,0x2,1), +(5936,0x2,1), +(5937,0x2,1), +(5938,0x2,1), +(5939,0x2,1), +(5940,0x2,1), +(5941,0x2,1), +(5942,0x2,1), +(5943,0x2,1), +(5944,0x2,1), +(5945,0x2,1), +(5946,0x2,1), +(5947,0x2,1), +(5948,0x2,1), +(5949,0x2,1), +(5950,0x2,1), +(5951,0x2,1), +(5952,0x2,1), +(5953,0x2,1), +(5954,0x2,1), +(5955,0x2,1), +(5956,0x2,1), +(5957,0x2,1), +(5958,0x2,1), +(5959,0x2,1), +(5960,0x2,1), +(5961,0x2,1), +(5962,0x2,1), +(5963,0x2,1), +(5986,0x2,1), +(5987,0x2,1), +(6186,0x2,1), +(6187,0x2,1), +(6188,0x2,1), +(6189,0x2,1), +(6190,0x2,1), +(6191,0x2,1), +(6192,0x2,1), +(6195,0x2,1), +(6196,0x2,1), +(6197,0x2,1), +(6198,0x2,1), +(6194,0x2,1), +(6199,0x2,1), +(6200,0x2,1), +(6201,0x2,1), +(6202,0x2,1), +(6203,0x2,1), +(6204,0x2,1), +(6205,0x2,1), +(6206,0x2,1), +(6207,0x2,1), +(6208,0x2,1), +(6209,0x2,1), +(6210,0x2,1), +(6211,0x2,1), +(6212,0x2,1), +(6213,0x2,1), +(6214,0x2,1), +(6215,0x2,1), +(6220,0x2,1), +(6216,0x2,1), +(6217,0x2,1), +(6218,0x2,1), +(6219,0x2,1), +(6221,0x2,1), +(6222,0x2,1), +(6223,0x2,1), +(6224,0x2,1), +(6225,0x2,1), +(6226,0x2,1), +(6227,0x2,1), +(6228,0x2,1), +(6229,0x2,1), +(6230,0x2,1), +(6231,0x2,1), +(6232,0x2,1), +(6233,0x2,1), +(6234,0x2,1), +(6235,0x2,1), +(6236,0x2,1), +(6237,0x2,1), +(6238,0x2,1), +(6239,0x2,1), +(6240,0x2,1), +(6243,0x2,1), +(6241,0x2,1), +(6242,0x2,1), +(6244,0x2,1), +(6245,0x2,1), +(6246,0x2,1), +(6247,0x2,1), +(6248,0x2,1), +(6249,0x2,1), +(6250,0x2,1), +(6251,0x2,1), +(6252,0x2,1), +(6253,0x2,1), +(6254,0x2,1), +(6255,0x2,1), +(6256,0x2,1), +(6257,0x2,1), +(6258,0x2,1), +(6259,0x2,1), +(6260,0x2,1), +(6261,0x2,1), +(6262,0x2,1), +(6263,0x2,1), +(6264,0x2,1), +(6265,0x2,1), +(6266,0x2,1), +(6267,0x2,1), +(6268,0x2,1), +(6269,0x2,1), +(6270,0x2,1), +(6271,0x2,1), +(6313,0x2,1); diff --git a/sql/old/4.3.4/2012_12_30_00_world_zul_gurub_434.sql b/sql/old/4.3.4/2012_12_30_00_world_zul_gurub_434.sql new file mode 100644 index 00000000000..5b4e31636db --- /dev/null +++ b/sql/old/4.3.4/2012_12_30_00_world_zul_gurub_434.sql @@ -0,0 +1,26 @@ +UPDATE `creature_template` SET `ScriptName`='npc_chained_spirit' WHERE `entry`=52156; +UPDATE `creature_template` SET `ScriptName`='npc_ohgan' WHERE `entry`=52157; + +DELETE FROM `creature` WHERE `id`=52156; + +DELETE FROM `spell_script_names` WHERE `spell_id` IN (96682,96776,96761,96821,96721,96722,96724,96740,28471); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(96682,'spell_mandokir_decapitate'), +(96776,'spell_mandokir_bloodletting'), +(96761,'spell_mandokir_devastating_slam'), +(96821,'spell_mandokir_spirit_vengeance_cancel'), +(96721,'spell_mandokir_ohgan_orders'), +(96722,'spell_mandokir_ohgan_orders_trigger'), +(96724,'spell_mandokir_reanimate_ohgan'), +(96740,'spell_mandokir_devastating_slam_damage'), +(28471,'spell_clear_all'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`IN (96724,96721); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 3, 96724, 0, 0, 31, 0, 3, 52157, 0, 0, 0, 0, '', 'Earth Spike - Ohgan'), +(13, 1, 96721, 0, 0, 31, 0, 3, 52156, 0, 0, 0, 0, '', 'Ohgan''s Orders - Chained Spirit'); + +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=16848; +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(16848,11,0,0,'achievement_ohganot_so_fast'), +(16848,12,1,0,''); diff --git a/sql/old/4.3.4/2013_01_03_00_world_spell_area_434.sql b/sql/old/4.3.4/2013_01_03_00_world_spell_area_434.sql new file mode 100644 index 00000000000..207b51f9f7b --- /dev/null +++ b/sql/old/4.3.4/2013_01_03_00_world_spell_area_434.sql @@ -0,0 +1 @@ +DELETE FROM `spell_area` WHERE `spell`=58600; -- Restricted Flight Area (Dalaran) diff --git a/sql/old/4.3.4/2013_01_03_01_world_spell_area_434.sql b/sql/old/4.3.4/2013_01_03_01_world_spell_area_434.sql new file mode 100644 index 00000000000..2eb36926193 --- /dev/null +++ b/sql/old/4.3.4/2013_01_03_01_world_spell_area_434.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_area` WHERE `spell`=91604; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES +(91604, 4197, 0, 0, 0, 0, 2, 1, 64, 11), +(91604, 4538, 0, 0, 0, 0, 2, 1, 64, 11), +(91604, 4539, 0, 0, 0, 0, 2, 1, 64, 11), +(91604, 4575, 0, 0, 0, 0, 2, 1, 64, 11), +(91604, 4577, 0, 0, 0, 0, 2, 1, 64, 11), +(91604, 4581, 0, 0, 0, 0, 2, 1, 64, 11), +(91604, 4582, 0, 0, 0, 0, 2, 1, 64, 11), +(91604, 4583, 0, 0, 0, 0, 2, 1, 64, 11), +(91604, 4585, 0, 0, 0, 0, 2, 1, 64, 11), +(91604, 4589, 0, 0, 0, 0, 2, 1, 64, 11), +(91604, 4612, 0, 0, 0, 0, 2, 1, 64, 11); diff --git a/sql/old/4.3.4/2013_01_04_00_world_halls_of_origination_434.sql b/sql/old/4.3.4/2013_01_04_00_world_halls_of_origination_434.sql new file mode 100644 index 00000000000..36df0da72ca --- /dev/null +++ b/sql/old/4.3.4/2013_01_04_00_world_halls_of_origination_434.sql @@ -0,0 +1,51 @@ +UPDATE `creature_template` SET `ScriptName`="npc_brann_bronzebeard_anraphet" WHERE `entry`=39908; +DELETE FROM `creature_text` WHERE `entry`=39908; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES +(39908, 0, 0, 'Right, let''s go! Just need to input the final entry sequence into the door mechanism... and...', 12, 0, 100, 5, 0, 20897, 'Brann Bronzebeard'), +(39908, 1, 0, 'That did the trick! The control room should be right behind this... oh... wow...', 12, 0, 100, 5, 0, 20898, 'Brann Bronzebeard'), +(39908, 2, 0, 'What? This isn''t the control room! There''s another entire defense mechanism in place, and the blasted Rock Troggs broke into here somehow. Troggs. Why did it have to be Troggs!', 12, 0, 100, 5, 0, 20899, 'Brann Bronzebeard'), +(39908, 3, 0, 'Ok, let me think a moment.', 12, 0, 100, 1, 0, 20900, 'Brann Bronzebeard'), +(39908, 4, 0, 'Mirrors pointing all over the place.', 12, 0, 100, 25, 0, 20902, 'Brann Bronzebeard'), +(39908, 5, 0, 'Four platforms with huge elementals.', 12, 0, 100, 25, 0, 20901, 'Brann Bronzebeard'), +(39908, 6, 0, 'I got it! I saw a tablet that mentioned this chamber. This is the Vault of Lights! Ok, simple enough. I need you adventurers to take out each of the four elementals to trigger the opening sequence for the far door!', 12, 0, 100, 5, 0, 20903, 'Brann Bronzebeard'), +(39908, 7, 0, 'One down!', 14, 0, 100, 5, 0, 20904, 'Brann Bronzebeard'), +(39908, 8, 0, 'Another one down! Just look at those light beams! They seem to be connecting to the far door!', 14, 0, 100, 5, 0, 20905, 'Brann Bronzebeard'), +(39908, 9, 0, 'One more elemental to go! The door is almost open!', 14, 0, 100, 5, 0, 20906, 'Brann Bronzebeard'), +(39908, 10, 0, 'That''s it, you''ve done it! The vault door is opening! Now we can... oh, no!', 14, 0, 100, 5, 0, 20907, 'Brann Bronzebeard'), +(39908, 11, 0, 'We''ve done it! The control room is breached!', 14, 0, 100, 5, 0, 23709, 'Brann Bronzebeard'), +(39908, 12, 0, 'Here we go! Now this should only take a moment...', 14, 0, 100, 5, 0, 23710, 'Brann Bronzebeard'); + +UPDATE `creature_template` SET `ScriptName`="boss_anraphet" WHERE `entry`=39788; +DELETE FROM `creature_text` WHERE `entry`=39788; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES +(39788, 0, 0, 'This unit has been activated outside normal operating protocols. Downloading new operational parameters. Download complete. Full unit self defense routines are now active. Destruction of foreign units in the system shall now commence.', 14, 0, 100, 0, 0, 20857, 'Anraphet - SAY_INTRO'), +(39788, 1, 0, 'Purge of unauthorized entities commencing.', 14, 0, 100, 0, 0, 20862, 'Anraphet - SAY_AGGRO'), +(39788, 2, 0, 'Omega Stance activated. Annihilation of foreign unit is now imminent.', 14, 0, 100, 0, 0, 20861, 'Anraphet - SAY_OMEGA_STANCE'), +(39788, 3, 0, 'Purge Complete.', 14, 0, 100, 0, 0, 20859, 'Anraphet - SAY_PLAYER_KILL'), +(39788, 3, 1, 'Target Annihilated.', 14, 0, 100, 0, 0, 20858, 'Anraphet - SAY_PLAYER_KILL'), +(39788, 4, 0, 'Anraphet unit shutting down...', 14, 0, 100, 0, 0, 20856, 'Anraphet - SAY_DEATH'); + +DELETE FROM `spell_script_names` WHERE `spell_id` IN (76904,77106,77127); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(76904,'spell_anraphet_alpha_beams'), +(77106,'spell_anraphet_omega_stance_summon'), +(77127,'spell_omega_stance_spider_effect'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup` IN (11339,11348,12512); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=11339; +INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(14, 11339, 15794, 0, 0, 13, 1, 2, 3, 2, 1, 0, 0, '', 'Brann Bronzebeard gossip menu - Show only if DATA_VAULT_OF_LIGHTS is not done'), +(14, 11348, 15815, 0, 0, 13, 1, 18, 4, 0, 1, 0, 0, '', 'Brann Bronzebeard gossip menu - Show only if DATA_DEAD_ELEMENTALS is less than 4'), +(14, 12512, 17600, 0, 0, 13, 1, 18, 4, 0, 0, 0, 0, '', 'Brann Bronzebeard gossip menu - Show only if DATA_DEAD_ELEMENTALS is 4'), +(15, 11339, 0, 0, 0, 13, 1, 2, 3, 2, 1, 0, 0, '', 'Brann Bronzebeard gossip menu option - Show only if DATA_VAULT_OF_LIGHTS is not done'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=77437; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 6, 77437, 0, 0, 31, 0, 3, 39804, 0, 0, 0, 0, '', 'Destruction Protocol - Stone Trogg Pillager'), +(13, 6, 77437, 0, 1, 31, 0, 3, 40252, 0, 0, 0, 0, '', 'Destruction Protocol - Stone Trogg Rock Flinger'), +(13, 6, 77437, 0, 2, 31, 0, 3, 40251, 0, 0, 0, 0, '', 'Destruction Protocol - Stone Trogg Brute'); + +UPDATE `creature_template` SET `ScriptName`='npc_alpha_beam' WHERE `entry`=41144; +UPDATE `creature_template` SET `ScriptName`='npc_omega_stance' WHERE `entry`=41194; + +DELETE FROM `spell_script_names` WHERE `spell_id`=94974; diff --git a/sql/old/4.3.4/2013_01_05_00_world_firelands_434.sql b/sql/old/4.3.4/2013_01_05_00_world_firelands_434.sql new file mode 100644 index 00000000000..fa20d425209 --- /dev/null +++ b/sql/old/4.3.4/2013_01_05_00_world_firelands_434.sql @@ -0,0 +1,113 @@ +DELETE FROM `creature` WHERE `id` IN (53520,53375,53698,53693,53487,53691,52530,53369,53680,53734,53896,53900) AND `map`=720; +DELETE FROM `gameobject` WHERE `id` IN (209036,208966,201722,209035) AND `map`=720; + +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|0x80 WHERE `entry` IN (53723,53154,53789,53792,53787,53788); + +UPDATE `creature_template` SET `minlevel`=88,`maxlevel`=88,`exp`=3,`faction_A`=16,`faction_H`=16,`speed_walk`=3.2,`speed_run`=2,`baseattacktime`=2000,`rangeattacktime`=2000,`unit_class`=2,`unit_flags`=0x2008140,`unit_flags2`=0x8000800,`VehicleId`=1673,`HoverHeight`=14,`mana_mod_extra`=1.72414 WHERE `entry` IN (52530,54044,54045,54046); +UPDATE `creature_template` SET `minlevel`=87,`maxlevel`=87,`exp`=3,`faction_A`=16,`faction_H`=16,`speed_walk`=3.2,`speed_run`=2,`baseattacktime`=2000,`rangeattacktime`=2000,`unit_flags`=0x8000,`unit_flags2`=0x800,`VehicleId`=1695 WHERE `entry` IN (54056,54057); -- Blazing Monstrosity +UPDATE `creature_template` SET `minlevel`=87,`maxlevel`=87,`exp`=3,`faction_A`=16,`faction_H`=16,`speed_walk`=1,`speed_run`=1,`baseattacktime`=2000,`rangeattacktime`=2000,`unit_flags`=0x8000,`unit_flags2`=0x8800 WHERE `entry` IN (53795,54059); -- Egg Pile +UPDATE `creature_template` SET `spell1`=100076,`spell2`=100080,`spell3`=100078,`spell4`=100082 WHERE `entry`=53789; +UPDATE `creature_template` SET `spell1`=100090,`spell2`=100089,`spell3`=100091,`spell4`=100092 WHERE `entry`=53792; +UPDATE `creature_template` SET `minlevel`=85,`maxlevel`=85,`exp`=3,`faction_A`=14,`faction_H`=14,`speed_walk`=1.2,`speed_run`=0.428571,`unit_flags`=0x2000000,`unit_flags2`=0x2000800 WHERE `entry` IN (53787,53788); -- Molten Barrage +UPDATE `creature_template` SET `minlevel`=85,`maxlevel`=85,`exp`=3,`faction_A`=16,`faction_H`=16,`speed_walk`=3.2,`speed_run`=2,`unit_flags`=0x8000,`unit_flags2`=0x800,`baseattacktime`=2000,`rangeattacktime`=2000 WHERE `entry` IN (53794,54058); -- Smouldering Hatchling +UPDATE `creature_template` SET `minlevel`=86,`maxlevel`=86,`exp`=3,`faction_A`=16,`faction_H`=16,`speed_walk`=1,`speed_run`=1.14286,`unit_flags`=0,`unit_flags2`=0x800,`baseattacktime`=2000,`rangeattacktime`=2000,`unit_class`=8,`dynamicflags`=0 WHERE `entry` IN (53793,53973); -- Harbinger of Flame + +UPDATE `creature_template` SET `difficulty_entry_1`=54044,`difficulty_entry_2`=54045,`difficulty_entry_3`=54046 WHERE `entry`=52530; -- Alysrazor +UPDATE `creature_template` SET `difficulty_entry_1`=54056 WHERE `entry`=53786; -- Blazing Monstrosity +UPDATE `creature_template` SET `difficulty_entry_1`=54057 WHERE `entry`=53791; -- Blazing Monstrosity +UPDATE `creature_template` SET `difficulty_entry_1`=54059 WHERE `entry`=53795; -- Egg Pile +UPDATE `creature_template` SET `difficulty_entry_1`=54058 WHERE `entry`=53794; -- Smouldering Hatchling +UPDATE `creature_template` SET `difficulty_entry_1`=53973 WHERE `entry`=53793; -- Harbinger of Flame + +DELETE FROM `creature_template_addon` WHERE `entry` IN (53786,53791,54056,54057,53794,54058,54276,54019,53224,53102,52530,54044,54045,54046,53900,53680,53520,53693,53698); +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(53786, 0, 0x0, 0x1, '100712 99480'), -- Blazing Monstrosity - Fire Hawk Smoke Cosmetic, Sleep (Ultra-High Priority) +(53791, 0, 0x0, 0x1, '100712 99480'), -- Blazing Monstrosity - Fire Hawk Smoke Cosmetic, Sleep (Ultra-High Priority) +(54056, 0, 0x0, 0x1, '100712 99480'), -- Blazing Monstrosity - Fire Hawk Smoke Cosmetic, Sleep (Ultra-High Priority) +(54057, 0, 0x0, 0x1, '100712 99480'), -- Blazing Monstrosity - Fire Hawk Smoke Cosmetic, Sleep (Ultra-High Priority) +(53794, 0, 0x0, 0x1, '100712'), -- Smouldering Hatchling - Fire Hawk Smoke Cosmetic +(54058, 0, 0x0, 0x1, '100712'), -- Smouldering Hatchling - Fire Hawk Smoke Cosmetic +(54276, 0, 0x0, 0x1, '101112'), -- Cinderslither Snake - Cinderslither Aura +(54019, 0, 0x0, 0x1, '100556'), -- Captive Druid of the Talon - Smouldering Roots +(53224, 0, 0x0, 0x1, '100743'), -- Flamewaker Taskmaster - Aura of Indomitability +(53102, 0, 0x3000000, 0x1, '100712'), -- Inferno Hawk - Fire Hawk Smoke Cosmetic +(52530, 0, 0x0, 0x1, '100712'), -- Alysrazor - Fire Hawk Smoke Cosmetic +(54044, 0, 0x0, 0x1, '100712'), -- Alysrazor - Fire Hawk Smoke Cosmetic +(54045, 0, 0x0, 0x1, '100712'), -- Alysrazor - Fire Hawk Smoke Cosmetic +(54046, 0, 0x0, 0x1, '100712'), -- Alysrazor - Fire Hawk Smoke Cosmetic +(53900, 0, 0x3000000, 0x1, '100712'), -- Blazing Broodmother - Fire Hawk Smoke Cosmetic +(53680, 0, 0x3000000, 0x1, '100712'), -- Blazing Broodmother - Fire Hawk Smoke Cosmetic +(53520, 0, 0x0, 0x1, '99327'), -- Plump Lava Worm - Fire Worm Cosmetic +(53693, 0, 0x0, 0x1, '99793'), -- Fiery Vortex - Fiery Vortex +(53698, 0, 0x0, 0x1, '99817'); -- Fiery Tornado - Fiery Tornado + +DELETE FROM `vehicle_template_accessory` WHERE `entry` IN (53786,53791); +INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `minion`, `description`, `summontype`, `summontimer`) VALUES +(53786,53789,1,'Blazing Monstrosity',5,0), +(53791,53792,1,'Blazing Monstrosity',5,0); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (53786,53791,53789,53792); +INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`cast_flags`) VALUES +(53786,98509,1), +(53791,98509,1), +(53789,93970,1), +(53792,93970,1); + +DELETE FROM `creature_text` WHERE `entry`=53795; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES +(53795, 0, 0, 'The Molten Eggs begin to crack and splinter!', 41, 0, 100, 0, 0, 0, 'Molten Egg - EMOTE_CRACKING_EGGS'); + +-- ScriptNames and conditions +UPDATE `instance_template` SET `script`='instance_firelands' WHERE `map`=720; +UPDATE `creature_template` SET `ScriptName`='npc_harbinger_of_flame' WHERE `entry`=53793; +UPDATE `creature_template` SET `ScriptName`='npc_blazing_monstrosity' WHERE `entry` IN (53786,53791); +UPDATE `creature_template` SET `ScriptName`='npc_molten_barrage' WHERE `entry` IN (53787,53788); +UPDATE `creature_template` SET `ScriptName`='npc_egg_pile' WHERE `entry`=53795; + +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_alysrazor_cosmetic_egg_xplosion'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_alysrazor_turn_monstrosity'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_alysrazor_aggro_closest'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_alysrazor_fieroblast'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(100099,'spell_alysrazor_cosmetic_egg_xplosion'), +(100076,'spell_alysrazor_turn_monstrosity'), +(100078,'spell_alysrazor_turn_monstrosity'), +(100080,'spell_alysrazor_turn_monstrosity'), +(100082,'spell_alysrazor_turn_monstrosity'), +(100089,'spell_alysrazor_turn_monstrosity'), +(100090,'spell_alysrazor_turn_monstrosity'), +(100091,'spell_alysrazor_turn_monstrosity'), +(100092,'spell_alysrazor_turn_monstrosity'), +(100462,'spell_alysrazor_aggro_closest'), +(100094,'spell_alysrazor_fieroblast'), +(101223,'spell_alysrazor_fieroblast'), +(101294,'spell_alysrazor_fieroblast'), +(101295,'spell_alysrazor_fieroblast'), +(101296,'spell_alysrazor_fieroblast'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (100558,100071,100074,100070,100076,100078,100080,100082,100089,100090,100091,100092); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,3,100558,0,0,31,0,3,54019,0,0,0,0,'','Sacrifice to the Flame - Captive Druid of the Talon'), +(13,1,100071,0,0,31,0,3,53787,0,0,0,0,'','Molten Barrage'), +(13,1,100074,0,0,31,0,3,53788,0,0,0,0,'','Molten Barrage'), +(13,2,100070,0,0,31,0,3,53786,0,0,0,0,'','Molten Barrage - Blazing Monstrosity'), +(13,2,100070,0,1,31,0,3,53791,0,0,0,0,'','Molten Barrage - Blazing Monstrosity'), +(13,2,100070,0,2,31,0,3,53793,0,0,0,0,'','Molten Barrage - Harbinger of Flame'), +(13,2,100070,0,3,31,0,3,53795,0,0,0,0,'','Molten Barrage - Egg Pile'), +(13,2,100070,0,4,31,0,3,53794,0,0,0,0,'','Molten Barrage - Smouldering Hatchling'), +(13,1,100076,0,0,31,0,3,53787,0,0,0,0,'','Left-Side Smack - Molten Barrage'), +(13,2,100076,0,1,31,0,3,53786,0,0,0,0,'','Left-Side Smack - Blazing Monstrosity'), +(13,1,100078,0,0,31,0,3,53787,0,0,0,0,'','Right-Side Smack - Molten Barrage'), +(13,2,100078,0,1,31,0,3,53786,0,0,0,0,'','Right-Side Smack - Blazing Monstrosity'), +(13,1,100080,0,0,31,0,3,53787,0,0,0,0,'','Head Bonk - Molten Barrage'), +(13,2,100080,0,1,31,0,3,53786,0,0,0,0,'','Head Bonk - Blazing Monstrosity'), +(13,1,100082,0,0,31,0,3,53787,0,0,0,0,'','Tickle - Molten Barrage'), +(13,2,100082,0,1,31,0,3,53786,0,0,0,0,'','Tickle - Blazing Monstrosity'), +(13,1,100089,0,0,31,0,3,53788,0,0,0,0,'','Head Bonk - Molten Barrage'), +(13,2,100089,0,1,31,0,3,53791,0,0,0,0,'','Head Bonk - Blazing Monstrosity'), +(13,1,100090,0,0,31,0,3,53788,0,0,0,0,'','Left-Side Smack - Molten Barrage'), +(13,2,100090,0,1,31,0,3,53791,0,0,0,0,'','Left-Side Smack - Blazing Monstrosity'), +(13,1,100091,0,0,31,0,3,53788,0,0,0,0,'','Right-Side Smack - Molten Barrage'), +(13,2,100091,0,1,31,0,3,53791,0,0,0,0,'','Right-Side Smack - Blazing Monstrosity'), +(13,1,100092,0,0,31,0,3,53788,0,0,0,0,'','Tickle - Molten Barrage'), +(13,2,100092,0,1,31,0,3,53791,0,0,0,0,'','Tickle - Blazing Monstrosity'); diff --git a/sql/old/4.3.4/2013_01_21_00_world_misc_434.sql b/sql/old/4.3.4/2013_01_21_00_world_misc_434.sql new file mode 100644 index 00000000000..058a574ca93 --- /dev/null +++ b/sql/old/4.3.4/2013_01_21_00_world_misc_434.sql @@ -0,0 +1,22 @@ +-- Intro Areatrigger +DELETE FROM `areatrigger_scripts` WHERE `entry`=7246; +INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES +(7246, 'at_alizabal_intro'); + +UPDATE `creature_template` SET `scriptname` = 'boss_alizabal' WHERE `entry`=55869; + +-- Todo: Find the Rest of the Texts and their meanings +DELETE FROM `creature_text` WHERE `entry`=55869; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES +(55869, 1, 0, 'How I HATE this place. My captors may be long-dead, but don\'t think I won\'t take it all out on you miserable treasure-hunters.', 14, 0, 100, 0, 0, 25779, 'Alizabal - Intro'), +(55869, 2, 0, 'I hate adventurers.', 14, 0, 100, 0, 0, 25777, 'Alizabal - Aggro'), +(55869, 3, 0, 'I hate martyrs.', 14, 0, 100, 0, 0, 25786, 'Alizabal - Seething Hate'), +(55869, 4, 0, 'I hate armor.', 14, 0, 100, 0, 0, 25785, 'Alizabal - Skewer'), +(55869, 5, 0, 'Alizabal nailed $N firmly on the ground.', 41, 0, 100, 0, 0, 0, 'Alizabal - Skewer Announce'), +(55869, 6, 0, 'I hate standing still.', 14, 0, 100, 0, 0, 25791, 'Alizabal - Blade Dance'), +(55869, 7, 0, 'Feel my hatred!', 14, 0, 100, 0, 0, 25787, 'Alizabal - ???'), +(55869, 8, 0, 'My hate will consume you!', 14, 0, 100, 0, 0, 25789, 'Alizabal - ???'), +(55869, 9, 0, 'I hate you all.', 14, 0, 100, 0, 0, 25790, 'Alizabal - ???'), +(55869, 10, 0, 'I hate mercy.', 14, 0, 100, 0, 0, 25783, 'Alizabal - Slay 1'), +(55869, 11, 0, 'My hatred burns!', 14, 0, 100, 0, 0, 25788, 'Alizabal - ???'), +(55869, 12, 0, 'I hate... every one of you...', 14, 0, 100, 0, 0, 25778, 'Alizabal - Death'); diff --git a/sql/old/4.3.4/2013_01_21_01_world_misc_434.sql b/sql/old/4.3.4/2013_01_21_01_world_misc_434.sql new file mode 100644 index 00000000000..dcf058b44e0 --- /dev/null +++ b/sql/old/4.3.4/2013_01_21_01_world_misc_434.sql @@ -0,0 +1,4 @@ +-- NPC Hira Snowdawn no longer sells Tome of Cold Weather Flight +UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=31238; +DELETE FROM `gossip_menu_option` WHERE `menu_id`=10723 AND `id`=1; +DELETE FROM `npc_vendor` WHERE `entry`=31238 AND `item`=49177; diff --git a/sql/old/4.3.4/2013_01_22_00_world_spell_proc_event_434.sql b/sql/old/4.3.4/2013_01_22_00_world_spell_proc_event_434.sql new file mode 100644 index 00000000000..036864683ea --- /dev/null +++ b/sql/old/4.3.4/2013_01_22_00_world_spell_proc_event_434.sql @@ -0,0 +1,6 @@ +-- Malfurion's Gift +DELETE FROM `spell_proc_event` WHERE `entry` IN ('92363', '92364'); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) +VALUES +(92363, 0, 7, 0, 16, 0, 278528, 0, 0, 2, 0), +(92364, 0, 7, 0, 16, 0, 278528, 0, 0, 4, 0); |