diff options
Diffstat (limited to 'sql/old')
23 files changed, 97 insertions, 0 deletions
diff --git a/sql/old/3.3.5a/auth/19081_2019_09_15/2019_08_16_00_auth.sql b/sql/old/3.3.5a/auth/19081_2019_09_15/2019_08_16_00_auth.sql new file mode 100644 index 00000000000..6544c316449 --- /dev/null +++ b/sql/old/3.3.5a/auth/19081_2019_09_15/2019_08_16_00_auth.sql @@ -0,0 +1,2 @@ +-- TDB 335.19081 auth +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/characters/19081_2019_09_15/2019_08_16_00_characters.sql b/sql/old/3.3.5a/characters/19081_2019_09_15/2019_08_16_00_characters.sql new file mode 100644 index 00000000000..5d9a26ec653 --- /dev/null +++ b/sql/old/3.3.5a/characters/19081_2019_09_15/2019_08_16_00_characters.sql @@ -0,0 +1,2 @@ +-- TDB 335.19081 characters +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_16_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_16_00_world.sql new file mode 100644 index 00000000000..7cb4c1c9abb --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_16_00_world.sql @@ -0,0 +1,3 @@ +-- TDB 335.19081 world +UPDATE `version` SET `db_version`='TDB 335.19081', `cache_id`=19081 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_00_world.sql new file mode 100644 index 00000000000..860c830e416 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_00_world.sql @@ -0,0 +1,6 @@ +-- Burn with fire spell_linked_spell hack +DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (-19386, -24132, -24133, -27068, -49011, -49012); + +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_hun_wyvern_sting'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(-19386,'spell_hun_wyvern_sting'); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_01_world.sql new file mode 100644 index 00000000000..f9239dd8a2e --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_01_world.sql @@ -0,0 +1,4 @@ +ALTER TABLE `spell_proc` ADD `DisableEffectsMask` int(10) unsigned NOT NULL DEFAULT '0' AFTER `AttributesMask`; + +UPDATE `spell_proc` SET `DisableEffectsMask`=((`AttributesMask` >> 4) & 0x7); +UPDATE `spell_proc` SET `AttributesMask`=(`AttributesMask` & 0xF); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_02_world.sql new file mode 100644 index 00000000000..fa322bbb391 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_02_world.sql @@ -0,0 +1,3 @@ +-- +UPDATE `waypoint_data` SET `position_z`= 154.61 WHERE `id`= 1287390; +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|536870912 WHERE `entry` = 29047; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_18_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_18_00_world.sql new file mode 100644 index 00000000000..bc781184e28 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_18_00_world.sql @@ -0,0 +1,4 @@ +-- Missing 5 man normal spellid +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gal_darah_stampede_charge' AND `spell_id`=55220; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(55220,'spell_gal_darah_stampede_charge'); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_22_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_22_00_world.sql new file mode 100644 index 00000000000..d5b8414eaa8 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_22_00_world.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gal_darah_clear_puncture'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(60022,'spell_gal_darah_clear_puncture'); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_30_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_30_00_world.sql new file mode 100644 index 00000000000..7f0e90367a7 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_30_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `unit_flags`=33554688, `speed_walk`=1.2, `speed_run`=1.71429 WHERE `entry` IN (36678,38431,38585,38586); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_00_world.sql new file mode 100644 index 00000000000..4b5eb530785 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_00_world.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `disables` WHERE `sourceType`=1 AND `entry`=13381; +DELETE FROM `quest_template_addon` WHERE `ID` IN (13404, 13382); +INSERT INTO `quest_template_addon` (`ID`, `PrevQuestID`, `SpecialFlags`) VALUES +(13404, 13380,1), +(13382, 13381,1); +UPDATE `quest_template_addon` SET `PrevQuestID`=13374 WHERE `id`=13376; +DELETE FROM `player_factionchange_quests` WHERE `alliance_id`=13404; +INSERT INTO `player_factionchange_quests` (`alliance_id`, `horde_id`) VALUES +(13404, 13406); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_01_world.sql new file mode 100644 index 00000000000..f47fcb7d056 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_01_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `smart_scripts` SET `action_param1`=83 WHERE `entryorguid` IN (-32379,-32378,-32380, 12858) AND `source_type`=0 AND `id`=0; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_02_world.sql new file mode 100644 index 00000000000..3b100cd4b75 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_02_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `quest_offer_reward` SET `RewardText`="They're being driven insane? Voices in their heads?$B$BVoices in your head?!$B$BI want you to clear your mind of the taint that has crept into that place, $g boy : girl;.$B$BWe'll try to get the remainder of them out of there again tomorrow when you've had a chance to rest." WHERE `ID`=13302; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_03_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_03_world.sql new file mode 100644 index 00000000000..cc2285867f9 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_03_world.sql @@ -0,0 +1,14 @@ +-- +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id`=23; +UPDATE `smart_scripts` SET `event_type`=38, `event_param1`=15, `event_param2`=15 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id`=27; +UPDATE `creature_text` SET `Type`=14 WHERE `CreatureID` IN (18471) AND `GroupID`=12; +DELETE FROM `creature_text` WHERE `CreatureID` IN (18471) AND `GroupID`=13; +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(18471,13,0,"For the first time in the Ring of Blood's history, Mogor has chosen to exercise his right of battle! On this wartorn ground, $n will face Mogor, hero of the Warmaul!",14,0,100,0,0,0,15481,0,'Gurgthock'); +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid` IN (18069) AND `source_type`=0 AND `id`=9; +UPDATE `smart_scripts` SET `event_type`=40, `event_param1`=3, `event_param2`=18069, `action_type`=45, `action_param1`=1, `action_param2`=6, `target_type`=19, `target_param1`=18471 WHERE `entryorguid` IN (18069) AND `source_type`=0 AND `id`=10; +DELETE FROM `smart_scripts` WHERE `entryorguid`=18471 AND `source_type`=0 AND `id` IN (29,30); +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 +(18471, 0, 29, 0, 38, 0, 100, 0, 1, 6, 0, 0, 1, 13, 2000, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, "Gurgthock - On Data Set 1 13 - Say Line 13"), +(18471, 0, 30, 0, 52, 0, 100, 0, 13, 18471, 0, 0, 1, 3, 0, 0, 0, 0, 0, 19, 18069, 0, 0, 0, 0, 0, 0, "Gurgthock - On text over - Say Line 3"); +UPDATE `smart_scripts` SET `target_type`=7, `target_param1`=0 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id` IN (4,10,0,6,8); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_04_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_04_world.sql new file mode 100644 index 00000000000..e465b964d02 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_04_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `smart_scripts` SET `target_type`=7, `target_param1`=0 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id`=2; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_00_world.sql new file mode 100644 index 00000000000..613583dbd6b --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `quest_request_items` SET `CompletionText`="Finally, you've arrived... and discretely also. Good.$b$bOur world is full of fools, $N. Even the mighty Thrall has greater flaws than most can see. He turns his back on the power needed to make this land ours completely! We're not the same people who were manipulated and used by creatures from the Nether. We are our own people. We are proud... and we are strong." WHERE `ID`=3090; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_01_world.sql new file mode 100644 index 00000000000..852c6588cb8 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_01_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `quest_request_items` SET `CompletionText`="Our spells of Fortify are very powerful, $N. They allow our companions to take further injury from all types of attacks and survive in situations where they would normally fall. But this is nothing when compared to our abilities to heal. There are no greater healers than a priest--do well to remember that. Your power alone can turn the tides of battle easily." WHERE `ID`=5621; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_00_world.sql new file mode 100644 index 00000000000..68eb8bdd2c0 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_00_world.sql @@ -0,0 +1,2 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=7725; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_01_world_335.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_01_world_335.sql new file mode 100644 index 00000000000..7fd1fa416d6 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_01_world_335.sql @@ -0,0 +1,5 @@ +-- +DELETE FROM `gameobject_template` WHERE `entry` IN (183278,183282); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `AIName`, `ScriptName`, `VerifiedBuild`) VALUES +(183282, 6, 0, "Infernaling Summoner Damage Trap", 1, 0, 1, 4, 29115, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", -18019), +(183278, 6, 5752, "Infernaling Summoner", 2.5, 0, 0, 0, 33533, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", -18019); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_02_world.sql new file mode 100644 index 00000000000..595175a2f40 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_02_world.sql @@ -0,0 +1,18 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (19067,19210) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (1906700,1921000) AND `source_type`=9; +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 +(19067, 0, 0, 0, 8, 0, 100, 0, 33531, 0, 0, 0, 80, 1906700, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - On spell hit - Action list"), +(1906700, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 2.210368, "Fel Cannon: Hate - Action list - set orientation"), +(1906700, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 33535, 0, 0, 0, 0, 0, 19, 19212, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - cast spell"), +(1906700, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 33, 19067, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - Credit quest"), +(1906700, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 92, 0, 33535, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - Interrupt spell"), +(1906700, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 42346, 0, 0, 0, 0, 0, 19, 19212, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - Self cast spell"), +(1906700, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - set orientation"), +(19210, 0, 0, 0, 8, 0, 100, 0, 33532, 0, 0, 0, 80, 1921000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - On spell hit - Action list"), +(1921000, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 2.737549, "Fel Cannon: Fear - Action list - set orientation"), +(1921000, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 33535, 0, 0, 0, 0, 0, 19, 19211, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - cast spell"), +(1921000, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 33, 19210, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - Credit quest"), +(1921000, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 92, 0, 33535, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - Interrupt spell"), +(1921000, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 42346, 0, 0, 0, 0, 0, 19, 19211, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - Self cast spell"), +(1921000, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - set orientation"); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_10_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_10_00_world.sql new file mode 100644 index 00000000000..7afa08f854e --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_10_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `flags_extra` = `flags_extra`|128 WHERE `entry` =21321; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_01_world.sql new file mode 100644 index 00000000000..e492c6cdb5a --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_01_world.sql @@ -0,0 +1,2 @@ +-- O'Mally's Instrument Bunny (entry: 22021) +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry`=22021; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_02_world.sql new file mode 100644 index 00000000000..805033401e7 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_02_world.sql @@ -0,0 +1,3 @@ +-- +UPDATE `creature_template` SET `unit_flags`=320 WHERE `entry` IN (37591,37606); +UPDATE `creature_template` SET `gossip_menu_id`=10923 WHERE `entry` IN (37607); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_03_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_03_world.sql new file mode 100644 index 00000000000..033a7471c56 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_03_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `unit_flags`=32832, `dynamicflags`=0 WHERE `entry` IN (37604 ,37809, 37779); |