diff options
| author | QAston <qaston@gmail.com> | 2011-09-03 16:26:49 +0200 |
|---|---|---|
| committer | QAston <qaston@gmail.com> | 2011-09-03 16:26:49 +0200 |
| commit | 0ba79e0078b786676d20c69b5e21bd2249ba4e4d (patch) | |
| tree | 1753a842aeebfc22a01263b7ce1956f30c3a54e4 /sql | |
| parent | 663e00dc1e4859a066ec54f73948907c0c8fdc1d (diff) | |
| parent | 0d1f945c0fa93cdc0aa64776d59823eec1db755c (diff) | |
Merge pull request: The Val'kyr Twins Clean up and Implements from 'Drethek/master'
Diffstat (limited to 'sql')
3 files changed, 35 insertions, 0 deletions
diff --git a/sql/updates/world/2011_09_01_02_spell_script_names.sql b/sql/updates/world/2011_09_01_02_spell_script_names.sql new file mode 100644 index 00000000000..b7b6907b7f1 --- /dev/null +++ b/sql/updates/world/2011_09_01_02_spell_script_names.sql @@ -0,0 +1,10 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (65879,65916,67244,67245,67246,67248,67249,67250); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(65879, 'spell_power_of_the_twins'), +(65916, 'spell_power_of_the_twins'), +(67244, 'spell_power_of_the_twins'), +(67245, 'spell_power_of_the_twins'), +(67246, 'spell_power_of_the_twins'), +(67248, 'spell_power_of_the_twins'), +(67249, 'spell_power_of_the_twins'), +(67250, 'spell_power_of_the_twins'); diff --git a/sql/updates/world/2011_09_03_00_world_spell_script_names.sql b/sql/updates/world/2011_09_03_00_world_spell_script_names.sql new file mode 100644 index 00000000000..6cec12b63fd --- /dev/null +++ b/sql/updates/world/2011_09_03_00_world_spell_script_names.sql @@ -0,0 +1,15 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (67590,67602,67603,67604,65684,67176,67177,67178,65686,67222,67223,67224); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) +VALUES +(67590, 'spell_powering_up'), +(67602, 'spell_powering_up'), +(67603, 'spell_powering_up'), +(67604, 'spell_powering_up'), +(65684, 'spell_valkyr_essences'), +(67176, 'spell_valkyr_essences'), +(67177, 'spell_valkyr_essences'), +(67178, 'spell_valkyr_essences'), +(67222, 'spell_valkyr_essences'), +(65686, 'spell_valkyr_essences'), +(67223, 'spell_valkyr_essences'), +(67224, 'spell_valkyr_essences');
\ No newline at end of file diff --git a/sql/updates/world/2011_09_03_01_world_conditions.sql b/sql/updates/world/2011_09_03_01_world_conditions.sql new file mode 100644 index 00000000000..c830d3ad18e --- /dev/null +++ b/sql/updates/world/2011_09_03_01_world_conditions.sql @@ -0,0 +1,10 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `ConditionTypeOrReference` = 18 AND `SourceEntry` IN (65875,67303,67304,67305,65876,67306,67307,67308) ; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 0, 65875, 0, 18, 1, 34497, 2, 0, '', 'Twins Pact - Dark'), +(13, 0, 67303, 0, 18, 1, 34497, 2, 0, '', 'Twins Pact - Dark'), +(13, 0, 67304, 0, 18, 1, 34497, 2, 0, '', 'Twins Pact - Dark'), +(13, 0, 67305, 0, 18, 1, 34497, 2, 0, '', 'Twins Pact - Dark'), +(13, 0, 65876, 0, 18, 1, 34496, 2, 0, '', 'Twins Pact - Light'), +(13, 0, 67306, 0, 18, 1, 34496, 2, 0, '', 'Twins Pact - Light'), +(13, 0, 67307, 0, 18, 1, 34496, 2, 0, '', 'Twins Pact - Light'), +(13, 0, 67308, 0, 18, 1, 34496, 2, 0, '', 'Twins Pact - Light'); |