From 4b98c72039ea380e1a95331063881ed1572b9276 Mon Sep 17 00:00:00 2001 From: teacher Date: Fri, 16 Apr 2010 18:00:08 +0200 Subject: Moved sql update files to 3.3.3a_old dir. p.s. The previous commit proves we are a crAAAzy community! --HG-- branch : trunk --- .../3.3.3a_old/7834_characters_characters.sql | 22 ++++++++++++++ sql/updates/3.3.3a_old/7845_characters_mail.sql | 5 ++++ sql/updates/3.3.3a_old/7846_world_spell_dbc.sql | 6 ++++ sql/updates/3.3.3a_old/7849_realmd_realmlist.sql | 1 + sql/updates/3.3.3a_old/7854_world_spell_goup.sql | 1 + .../3.3.3a_old/7854_world_spell_proc_event.sql | 1 + sql/updates/3.3.3a_old/7854_world_spell_ranks.sql | 1 + sql/updates/3.3.3a_old/7857_realmd_realmlist.sql | 1 + sql/updates/3.3.3a_old/7873_world_scriptname.sql | 1 + .../3.3.3a_old/7881_world_spell_linked_spell.sql | 1 + sql/updates/3.3.3a_old/7884_world_spell_dbc.sql | 11 +++++++ .../3.3.3a_old/7884_world_spelldifficulty_dbc.sql | 1 + .../3.3.3a_old/7893_characters_characters.sql | 10 +++++++ .../3.3.3a_old/7904_characters_item_instance.sql | 1 + .../3.3.3a_old/7904_characters_item_text.sql | 1 + .../7905_characters_character_equipmentsets.sql | 1 + sql/updates/3.3.3a_old/7905_characters_corpse.sql | 2 ++ .../3.3.3a_old/7905_characters_group_member.sql | 1 + sql/updates/3.3.3a_old/7905_characters_guild.sql | 7 +++++ .../3.3.3a_old/7905_characters_petition.sql | 2 ++ .../3.3.3a_old/7906_characters_character_stats.sql | 34 ++++++++++++++++++++++ sql/updates/3.3.3a_old/7909_world_scriptname.sql | 1 + ...914_characters_character_queststatus_weekly.sql | 7 +++++ .../3.3.3a_old/7914_characters_worldstates.sql | 1 + .../3.3.3a_old/7915_characters_worldstates.sql | 2 ++ .../3.3.3a_old/7919_characters_worldstates.sql | 4 +++ .../3.3.3a_old/7921_characters_worldstates.sql | 1 + .../3.3.3a_old/7922_world_spell_proc_event.sql | 5 ++++ .../3.3.3a_old/7923_characters_characters.sql | 2 ++ sql/updates/3.3.3a_old/CMakeLists.txt | 5 ++++ sql/updates/7834_characters_characters.sql | 22 -------------- sql/updates/7845_characters_mail.sql | 5 ---- sql/updates/7846_world_spell_dbc.sql | 6 ---- sql/updates/7849_realmd_realmlist.sql | 1 - sql/updates/7854_world_spell_goup.sql | 1 - sql/updates/7854_world_spell_proc_event.sql | 1 - sql/updates/7854_world_spell_ranks.sql | 1 - sql/updates/7857_realmd_realmlist.sql | 1 - sql/updates/7873_world_scriptname.sql | 1 - sql/updates/7881_world_spell_linked_spell.sql | 1 - sql/updates/7884_world_spell_dbc.sql | 11 ------- sql/updates/7884_world_spelldifficulty_dbc.sql | 1 - sql/updates/7893_characters_characters.sql | 10 ------- sql/updates/7904_characters_item_instance.sql | 1 - sql/updates/7904_characters_item_text.sql | 1 - .../7905_characters_character_equipmentsets.sql | 1 - sql/updates/7905_characters_corpse.sql | 2 -- sql/updates/7905_characters_group_member.sql | 1 - sql/updates/7905_characters_guild.sql | 7 ----- sql/updates/7905_characters_petition.sql | 2 -- sql/updates/7906_characters_character_stats.sql | 34 ---------------------- sql/updates/7909_world_scriptname.sql | 1 - ...914_characters_character_queststatus_weekly.sql | 7 ----- sql/updates/7914_characters_worldstates.sql | 1 - sql/updates/7915_characters_worldstates.sql | 2 -- sql/updates/7919_characters_worldstates.sql | 4 --- sql/updates/7921_characters_worldstates.sql | 1 - sql/updates/7922_world_spell_proc_event.sql | 5 ---- sql/updates/7923_characters_characters.sql | 2 -- sql/updates/CMakeLists.txt | 1 + 60 files changed, 140 insertions(+), 134 deletions(-) create mode 100644 sql/updates/3.3.3a_old/7834_characters_characters.sql create mode 100644 sql/updates/3.3.3a_old/7845_characters_mail.sql create mode 100644 sql/updates/3.3.3a_old/7846_world_spell_dbc.sql create mode 100644 sql/updates/3.3.3a_old/7849_realmd_realmlist.sql create mode 100644 sql/updates/3.3.3a_old/7854_world_spell_goup.sql create mode 100644 sql/updates/3.3.3a_old/7854_world_spell_proc_event.sql create mode 100644 sql/updates/3.3.3a_old/7854_world_spell_ranks.sql create mode 100644 sql/updates/3.3.3a_old/7857_realmd_realmlist.sql create mode 100644 sql/updates/3.3.3a_old/7873_world_scriptname.sql create mode 100644 sql/updates/3.3.3a_old/7881_world_spell_linked_spell.sql create mode 100644 sql/updates/3.3.3a_old/7884_world_spell_dbc.sql create mode 100644 sql/updates/3.3.3a_old/7884_world_spelldifficulty_dbc.sql create mode 100644 sql/updates/3.3.3a_old/7893_characters_characters.sql create mode 100644 sql/updates/3.3.3a_old/7904_characters_item_instance.sql create mode 100644 sql/updates/3.3.3a_old/7904_characters_item_text.sql create mode 100644 sql/updates/3.3.3a_old/7905_characters_character_equipmentsets.sql create mode 100644 sql/updates/3.3.3a_old/7905_characters_corpse.sql create mode 100644 sql/updates/3.3.3a_old/7905_characters_group_member.sql create mode 100644 sql/updates/3.3.3a_old/7905_characters_guild.sql create mode 100644 sql/updates/3.3.3a_old/7905_characters_petition.sql create mode 100644 sql/updates/3.3.3a_old/7906_characters_character_stats.sql create mode 100644 sql/updates/3.3.3a_old/7909_world_scriptname.sql create mode 100644 sql/updates/3.3.3a_old/7914_characters_character_queststatus_weekly.sql create mode 100644 sql/updates/3.3.3a_old/7914_characters_worldstates.sql create mode 100644 sql/updates/3.3.3a_old/7915_characters_worldstates.sql create mode 100644 sql/updates/3.3.3a_old/7919_characters_worldstates.sql create mode 100644 sql/updates/3.3.3a_old/7921_characters_worldstates.sql create mode 100644 sql/updates/3.3.3a_old/7922_world_spell_proc_event.sql create mode 100644 sql/updates/3.3.3a_old/7923_characters_characters.sql create mode 100644 sql/updates/3.3.3a_old/CMakeLists.txt delete mode 100644 sql/updates/7834_characters_characters.sql delete mode 100644 sql/updates/7845_characters_mail.sql delete mode 100644 sql/updates/7846_world_spell_dbc.sql delete mode 100644 sql/updates/7849_realmd_realmlist.sql delete mode 100644 sql/updates/7854_world_spell_goup.sql delete mode 100644 sql/updates/7854_world_spell_proc_event.sql delete mode 100644 sql/updates/7854_world_spell_ranks.sql delete mode 100644 sql/updates/7857_realmd_realmlist.sql delete mode 100644 sql/updates/7873_world_scriptname.sql delete mode 100644 sql/updates/7881_world_spell_linked_spell.sql delete mode 100644 sql/updates/7884_world_spell_dbc.sql delete mode 100644 sql/updates/7884_world_spelldifficulty_dbc.sql delete mode 100644 sql/updates/7893_characters_characters.sql delete mode 100644 sql/updates/7904_characters_item_instance.sql delete mode 100644 sql/updates/7904_characters_item_text.sql delete mode 100644 sql/updates/7905_characters_character_equipmentsets.sql delete mode 100644 sql/updates/7905_characters_corpse.sql delete mode 100644 sql/updates/7905_characters_group_member.sql delete mode 100644 sql/updates/7905_characters_guild.sql delete mode 100644 sql/updates/7905_characters_petition.sql delete mode 100644 sql/updates/7906_characters_character_stats.sql delete mode 100644 sql/updates/7909_world_scriptname.sql delete mode 100644 sql/updates/7914_characters_character_queststatus_weekly.sql delete mode 100644 sql/updates/7914_characters_worldstates.sql delete mode 100644 sql/updates/7915_characters_worldstates.sql delete mode 100644 sql/updates/7919_characters_worldstates.sql delete mode 100644 sql/updates/7921_characters_worldstates.sql delete mode 100644 sql/updates/7922_world_spell_proc_event.sql delete mode 100644 sql/updates/7923_characters_characters.sql (limited to 'sql') diff --git a/sql/updates/3.3.3a_old/7834_characters_characters.sql b/sql/updates/3.3.3a_old/7834_characters_characters.sql new file mode 100644 index 00000000000..694010bcb42 --- /dev/null +++ b/sql/updates/3.3.3a_old/7834_characters_characters.sql @@ -0,0 +1,22 @@ +ALTER TABLE characters + ADD COLUMN `exploredZones` longtext AFTER activeSpec, + ADD COLUMN `equipmentCache` longtext AFTER exploredZones, + ADD COLUMN `ammoId` int(10) UNSIGNED NOT NULL default '0' AFTER equipmentCache, + ADD COLUMN `knownTitles` longtext AFTER ammoId; + +UPDATE characters SET +exploredZones = SUBSTRING(data, +length(SUBSTRING_INDEX(data, ' ', 1041))+2, +length(SUBSTRING_INDEX(data, ' ', 1168+1))- length(SUBSTRING_INDEX(data, ' ', 1041)) - 1), +equipmentCache = SUBSTRING(data, +length(SUBSTRING_INDEX(data, ' ', 283))+2, +length(SUBSTRING_INDEX(data, ' ', 320+1))- length(SUBSTRING_INDEX(data, ' ', 283)) - 1), +ammoId = SUBSTRING(data, +length(SUBSTRING_INDEX(data, ' ', 1198))+2, +length(SUBSTRING_INDEX(data, ' ', 1198+1))- length(SUBSTRING_INDEX(data, ' ', 1198)) - 1), +knownTitles = SUBSTRING(data, +length(SUBSTRING_INDEX(data, ' ', 626))+2, +length(SUBSTRING_INDEX(data, ' ', 631+1))- length(SUBSTRING_INDEX(data, ' ', 626)) - 1); + +ALTER TABLE characters + DROP COLUMN data; diff --git a/sql/updates/3.3.3a_old/7845_characters_mail.sql b/sql/updates/3.3.3a_old/7845_characters_mail.sql new file mode 100644 index 00000000000..124322380c5 --- /dev/null +++ b/sql/updates/3.3.3a_old/7845_characters_mail.sql @@ -0,0 +1,5 @@ +ALTER TABLE `mail` ADD COLUMN `body` longtext CHARSET utf8 COLLATE utf8_general_ci NULL after `subject`; + +UPDATE `mail` LEFT JOIN `item_text` ON `mail`.`itemtextid` = `item_text`.`id` SET `mail`.`body`=`item_text`.`text`; +DELETE item_text FROM mail, item_text WHERE mail.itemtextid = item_text.id; +ALTER TABLE `mail` DROP COLUMN `itemtextid`; diff --git a/sql/updates/3.3.3a_old/7846_world_spell_dbc.sql b/sql/updates/3.3.3a_old/7846_world_spell_dbc.sql new file mode 100644 index 00000000000..0173fb01c53 --- /dev/null +++ b/sql/updates/3.3.3a_old/7846_world_spell_dbc.sql @@ -0,0 +1,6 @@ +ALTER TABLE spell_dbc DROP EffectBaseDice1; +ALTER TABLE spell_dbc DROP EffectBaseDice2; +ALTER TABLE spell_dbc DROP EffectBaseDice3; +ALTER TABLE spell_dbc DROP EffectDicePerLevel1; +ALTER TABLE spell_dbc DROP EffectDicePerLevel2; +ALTER TABLE spell_dbc DROP EffectDicePerLevel3; diff --git a/sql/updates/3.3.3a_old/7849_realmd_realmlist.sql b/sql/updates/3.3.3a_old/7849_realmd_realmlist.sql new file mode 100644 index 00000000000..da0fa6740d6 --- /dev/null +++ b/sql/updates/3.3.3a_old/7849_realmd_realmlist.sql @@ -0,0 +1 @@ +UPDATE `realmlist` SET `gamebuild`=11723 WHERE `id`=1; diff --git a/sql/updates/3.3.3a_old/7854_world_spell_goup.sql b/sql/updates/3.3.3a_old/7854_world_spell_goup.sql new file mode 100644 index 00000000000..5d663eff11e --- /dev/null +++ b/sql/updates/3.3.3a_old/7854_world_spell_goup.sql @@ -0,0 +1 @@ +DELETE FROM `spell_group` WHERE `spell_id` IN (61417, 61418); diff --git a/sql/updates/3.3.3a_old/7854_world_spell_proc_event.sql b/sql/updates/3.3.3a_old/7854_world_spell_proc_event.sql new file mode 100644 index 00000000000..b50127bd540 --- /dev/null +++ b/sql/updates/3.3.3a_old/7854_world_spell_proc_event.sql @@ -0,0 +1 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (58642, 58676, 61433, 61434, 33174, 33182, 51470, 44396, 29801, 30802, 30803, 30804, 30805, 30808, 30809, 49137, 49657, 51466, 53137, 53138, 44394, 44395, 44396, 34457); diff --git a/sql/updates/3.3.3a_old/7854_world_spell_ranks.sql b/sql/updates/3.3.3a_old/7854_world_spell_ranks.sql new file mode 100644 index 00000000000..eb9be8cc979 --- /dev/null +++ b/sql/updates/3.3.3a_old/7854_world_spell_ranks.sql @@ -0,0 +1 @@ +DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (30803, 33174, 61417, 9736, 15742); diff --git a/sql/updates/3.3.3a_old/7857_realmd_realmlist.sql b/sql/updates/3.3.3a_old/7857_realmd_realmlist.sql new file mode 100644 index 00000000000..c71c29989d0 --- /dev/null +++ b/sql/updates/3.3.3a_old/7857_realmd_realmlist.sql @@ -0,0 +1 @@ +ALTER TABLE `realmlist` CHANGE COLUMN `gamebuild` `gamebuild` int(11) unsigned NOT NULL default '11723'; diff --git a/sql/updates/3.3.3a_old/7873_world_scriptname.sql b/sql/updates/3.3.3a_old/7873_world_scriptname.sql new file mode 100644 index 00000000000..8ae09707aed --- /dev/null +++ b/sql/updates/3.3.3a_old/7873_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `gameobject_template` SET `ScriptName`='go_stillpine_cage' WHERE `entry`=181714; diff --git a/sql/updates/3.3.3a_old/7881_world_spell_linked_spell.sql b/sql/updates/3.3.3a_old/7881_world_spell_linked_spell.sql new file mode 100644 index 00000000000..af419be42e0 --- /dev/null +++ b/sql/updates/3.3.3a_old/7881_world_spell_linked_spell.sql @@ -0,0 +1 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_effect` IN (24395,24396,24397,26592,61417,61418); diff --git a/sql/updates/3.3.3a_old/7884_world_spell_dbc.sql b/sql/updates/3.3.3a_old/7884_world_spell_dbc.sql new file mode 100644 index 00000000000..0fde674da64 --- /dev/null +++ b/sql/updates/3.3.3a_old/7884_world_spell_dbc.sql @@ -0,0 +1,11 @@ +-- Add serverside spells place holders for future development +DELETE FROM `spell_dbc` WHERE `Id` IN (71356,71803,72111,72125,70816,72233,72234,72235); +INSERT INTO `spell_dbc` (`Id`,`Dispel`,`Mechanic`,`Attributes`,`AttributesEx`,`AttributesEx2`,`AttributesEx3`,`AttributesEx4`,`AttributesEx5`,`Targets`,`CastingTimeIndex`,`AuraInterruptFlags`,`ProcFlags`,`ProcChance`,`ProcCharges`,`MaxLevel`,`BaseLevel`,`SpellLevel`,`DurationIndex`,`RangeIndex`,`StackAmount`,`EquippedItemClass`,`EquippedItemSubClassMask`,`EquippedItemInventoryTypeMask`,`Effect1`,`Effect2`,`Effect3`,`EffectDieSides1`,`EffectDieSides2`,`EffectDieSides3`,`EffectRealPointsPerLevel1`,`EffectRealPointsPerLevel2`,`EffectRealPointsPerLevel3`,`EffectBasePoints1`,`EffectBasePoints2`,`EffectBasePoints3`,`EffectMechanic1`,`EffectMechanic2`,`EffectMechanic3`,`EffectImplicitTargetA1`,`EffectImplicitTargetA2`,`EffectImplicitTargetA3`,`EffectImplicitTargetB1`,`EffectImplicitTargetB2`,`EffectImplicitTargetB3`,`EffectRadiusIndex1`,`EffectRadiusIndex2`,`EffectRadiusIndex3`,`EffectApplyAuraName1`,`EffectApplyAuraName2`,`EffectApplyAuraName3`,`EffectAmplitude1`,`EffectAmplitude2`,`EffectAmplitude3`,`EffectMultipleValue1`,`EffectMultipleValue2`,`EffectMultipleValue3`,`EffectMiscValue1`,`EffectMiscValue2`,`EffectMiscValue3`,`EffectMiscValueB1`,`EffectMiscValueB2`,`EffectMiscValueB3`,`EffectTriggerSpell1`,`EffectTriggerSpell2`,`EffectTriggerSpell3`,`EffectSpellClassMaskA1`,`EffectSpellClassMaskA2`,`EffectSpellClassMaskA3`,`EffectSpellClassMaskB1`,`EffectSpellClassMaskB2`,`EffectSpellClassMaskB3`,`EffectSpellClassMaskC1`,`EffectSpellClassMaskC2`,`EffectSpellClassMaskC3`,`MaxTargetLevel`,`SpellFamilyName`,`SpellFamilyFlags1`,`SpellFamilyFlags2`,`SpellFamilyFlags3`,`MaxAffectedTargets`,`DmgClass`,`PreventionType`,`DmgMultiplier1`,`DmgMultiplier2`,`DmgMultiplier3`,`AreaGroupId`,`SchoolMask`,`Comment`) VALUES +(71356, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2108 spellid0 serverside spell'), +(71803, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2108 spellid1 serverside spell'), +(72111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2136 spellid0 serverside spell'), +(72125, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2136 spellid1 serverside spell'), +(70816, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2146 spellid0 serverside spell'), +(72233, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2146 spellid1 serverside spell'), +(72234, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2146 spellid2 serverside spell'), +(72235, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2146 spellid3 serverside spell'); diff --git a/sql/updates/3.3.3a_old/7884_world_spelldifficulty_dbc.sql b/sql/updates/3.3.3a_old/7884_world_spelldifficulty_dbc.sql new file mode 100644 index 00000000000..1cbbadf3c2e --- /dev/null +++ b/sql/updates/3.3.3a_old/7884_world_spelldifficulty_dbc.sql @@ -0,0 +1 @@ +UPDATE `spelldifficulty_dbc` SET `spellid1`=58827 WHERE `id`=3014; diff --git a/sql/updates/3.3.3a_old/7893_characters_characters.sql b/sql/updates/3.3.3a_old/7893_characters_characters.sql new file mode 100644 index 00000000000..3dea7f98e27 --- /dev/null +++ b/sql/updates/3.3.3a_old/7893_characters_characters.sql @@ -0,0 +1,10 @@ +UPDATE item_instance SET data = REPLACE(data,' ',' '); +UPDATE item_instance SET data = CONCAT(TRIM(data),' '); + +UPDATE `item_instance` SET `data` = CONCAT( + SUBSTRING_INDEX(`data`, ' ', 59 + 1), ' ', + SUBSTRING_INDEX(`data`, ' ', -3 -1), '0 ') +WHERE length(SUBSTRING_INDEX(data, ' ', 64)) < length(data) and length(SUBSTRING_INDEX(data, ' ', 64+1)) >= length(data); + +UPDATE item_instance SET data = REPLACE(data,' ',' '); +UPDATE item_instance SET data = CONCAT(TRIM(data),' '); diff --git a/sql/updates/3.3.3a_old/7904_characters_item_instance.sql b/sql/updates/3.3.3a_old/7904_characters_item_instance.sql new file mode 100644 index 00000000000..95cd7bca248 --- /dev/null +++ b/sql/updates/3.3.3a_old/7904_characters_item_instance.sql @@ -0,0 +1 @@ +ALTER TABLE `item_instance` ADD COLUMN `text` longtext AFTER `data`; diff --git a/sql/updates/3.3.3a_old/7904_characters_item_text.sql b/sql/updates/3.3.3a_old/7904_characters_item_text.sql new file mode 100644 index 00000000000..517a4a04026 --- /dev/null +++ b/sql/updates/3.3.3a_old/7904_characters_item_text.sql @@ -0,0 +1 @@ +DROP TABLE IF EXISTS `item_text`; diff --git a/sql/updates/3.3.3a_old/7905_characters_character_equipmentsets.sql b/sql/updates/3.3.3a_old/7905_characters_character_equipmentsets.sql new file mode 100644 index 00000000000..1617c61f1ee --- /dev/null +++ b/sql/updates/3.3.3a_old/7905_characters_character_equipmentsets.sql @@ -0,0 +1 @@ +ALTER TABLE `character_equipmentsets` ADD INDEX `Idx_setindex` (`setindex`); diff --git a/sql/updates/3.3.3a_old/7905_characters_corpse.sql b/sql/updates/3.3.3a_old/7905_characters_corpse.sql new file mode 100644 index 00000000000..061c90e9bfc --- /dev/null +++ b/sql/updates/3.3.3a_old/7905_characters_corpse.sql @@ -0,0 +1,2 @@ +ALTER TABLE `corpse` ADD INDEX `Idx_player`(`player`); +ALTER TABLE `corpse` ADD INDEX `Idx_time`(`time`); diff --git a/sql/updates/3.3.3a_old/7905_characters_group_member.sql b/sql/updates/3.3.3a_old/7905_characters_group_member.sql new file mode 100644 index 00000000000..7c7c3eace14 --- /dev/null +++ b/sql/updates/3.3.3a_old/7905_characters_group_member.sql @@ -0,0 +1 @@ +ALTER TABLE `group_member` ADD INDEX `Idx_memberGuid`(`memberGuid`); diff --git a/sql/updates/3.3.3a_old/7905_characters_guild.sql b/sql/updates/3.3.3a_old/7905_characters_guild.sql new file mode 100644 index 00000000000..451df6671db --- /dev/null +++ b/sql/updates/3.3.3a_old/7905_characters_guild.sql @@ -0,0 +1,7 @@ +ALTER TABLE `guild_eventlog` ADD INDEX `Idx_PlayerGuid1`(`PlayerGuid1`); +ALTER TABLE `guild_eventlog` ADD INDEX `Idx_PlayerGuid2`(`PlayerGuid2`); +ALTER TABLE `guild_eventlog` ADD INDEX `Idx_LogGuid`(`LogGuid`); +ALTER TABLE `guild_bank_eventlog` ADD INDEX `Idx_PlayerGuid`(`PlayerGuid`); +ALTER TABLE `guild_bank_eventlog` ADD INDEX `Idx_LogGuid`(`LogGuid`); +ALTER TABLE `guild_bank_item` ADD INDEX `Idx_item_guid`(`item_guid`); +ALTER TABLE `guild_rank` ADD INDEX `Idx_rid`(`rid`); diff --git a/sql/updates/3.3.3a_old/7905_characters_petition.sql b/sql/updates/3.3.3a_old/7905_characters_petition.sql new file mode 100644 index 00000000000..844f2d0d89f --- /dev/null +++ b/sql/updates/3.3.3a_old/7905_characters_petition.sql @@ -0,0 +1,2 @@ +ALTER TABLE `petition_sign` ADD INDEX `Idx_playerguid`(`playerguid`); +ALTER TABLE `petition_sign` ADD INDEX `Idx_ownerguid`(`ownerguid`); diff --git a/sql/updates/3.3.3a_old/7906_characters_character_stats.sql b/sql/updates/3.3.3a_old/7906_characters_character_stats.sql new file mode 100644 index 00000000000..82aebbbaf51 --- /dev/null +++ b/sql/updates/3.3.3a_old/7906_characters_character_stats.sql @@ -0,0 +1,34 @@ +DROP TABLE IF EXISTS `character_stats`; +CREATE TABLE `character_stats` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part', + `maxhealth` int(10) UNSIGNED NOT NULL default '0', + `maxpower1` int(10) UNSIGNED NOT NULL default '0', + `maxpower2` int(10) UNSIGNED NOT NULL default '0', + `maxpower3` int(10) UNSIGNED NOT NULL default '0', + `maxpower4` int(10) UNSIGNED NOT NULL default '0', + `maxpower5` int(10) UNSIGNED NOT NULL default '0', + `maxpower6` int(10) UNSIGNED NOT NULL default '0', + `maxpower7` int(10) UNSIGNED NOT NULL default '0', + `strength` int(10) UNSIGNED NOT NULL default '0', + `agility` int(10) UNSIGNED NOT NULL default '0', + `stamina` int(10) UNSIGNED NOT NULL default '0', + `intellect` int(10) UNSIGNED NOT NULL default '0', + `spirit` int(10) UNSIGNED NOT NULL default '0', + `armor` int(10) UNSIGNED NOT NULL default '0', + `resHoly` int(10) UNSIGNED NOT NULL default '0', + `resFire` int(10) UNSIGNED NOT NULL default '0', + `resNature` int(10) UNSIGNED NOT NULL default '0', + `resFrost` int(10) UNSIGNED NOT NULL default '0', + `resShadow` int(10) UNSIGNED NOT NULL default '0', + `resArcane` int(10) UNSIGNED NOT NULL default '0', + `blockPct` float UNSIGNED NOT NULL default '0', + `dodgePct` float UNSIGNED NOT NULL default '0', + `parryPct` float UNSIGNED NOT NULL default '0', + `critPct` float UNSIGNED NOT NULL default '0', + `rangedCritPct` float UNSIGNED NOT NULL default '0', + `spellCritPct` float UNSIGNED NOT NULL default '0', + `attackPower` int(10) UNSIGNED NOT NULL default '0', + `rangedAttackPower` int(10) UNSIGNED NOT NULL default '0', + `spellPower` int(10) UNSIGNED NOT NULL default '0', + PRIMARY KEY (`guid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/updates/3.3.3a_old/7909_world_scriptname.sql b/sql/updates/3.3.3a_old/7909_world_scriptname.sql new file mode 100644 index 00000000000..824c090800e --- /dev/null +++ b/sql/updates/3.3.3a_old/7909_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='npc_pet_trainer' WHERE `entry` IN (10090,3698,17484,4320,3545,16712,3622,16675,3620,10086,2879,3306,543,2878,3688,10089,16271,10088,3624); diff --git a/sql/updates/3.3.3a_old/7914_characters_character_queststatus_weekly.sql b/sql/updates/3.3.3a_old/7914_characters_character_queststatus_weekly.sql new file mode 100644 index 00000000000..1bced542b9f --- /dev/null +++ b/sql/updates/3.3.3a_old/7914_characters_character_queststatus_weekly.sql @@ -0,0 +1,7 @@ +DROP TABLE IF EXISTS `character_queststatus_weekly`; +CREATE TABLE `character_queststatus_weekly` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', + PRIMARY KEY (`guid`,`quest`), + KEY `idx_guid` (`guid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; diff --git a/sql/updates/3.3.3a_old/7914_characters_worldstates.sql b/sql/updates/3.3.3a_old/7914_characters_worldstates.sql new file mode 100644 index 00000000000..5b150518e87 --- /dev/null +++ b/sql/updates/3.3.3a_old/7914_characters_worldstates.sql @@ -0,0 +1 @@ +ALTER TABLE `worldstates` ADD COLUMN `NextWeeklyQuestResetTime` bigint(40) unsigned NOT NULL default '0' AFTER `value`; diff --git a/sql/updates/3.3.3a_old/7915_characters_worldstates.sql b/sql/updates/3.3.3a_old/7915_characters_worldstates.sql new file mode 100644 index 00000000000..ffa573b6433 --- /dev/null +++ b/sql/updates/3.3.3a_old/7915_characters_worldstates.sql @@ -0,0 +1,2 @@ +ALTER TABLE `worldstates` DROP COLUMN `NextWeeklyQuestResetTime`; +INSERT INTO `worldstates` (`entry`,`value`, `comment`) VALUES (20002, 0, 'NextWeeklyQuestResetTime'); diff --git a/sql/updates/3.3.3a_old/7919_characters_worldstates.sql b/sql/updates/3.3.3a_old/7919_characters_worldstates.sql new file mode 100644 index 00000000000..b265aebb92e --- /dev/null +++ b/sql/updates/3.3.3a_old/7919_characters_worldstates.sql @@ -0,0 +1,4 @@ +DELETE FROM `worldstates` WHERE `entry` IN (20001,20002); +INSERT INTO `worldstates` (`entry`,`value`, `comment`) VALUES +(20001, 0, 'NextArenaPointDistributionTime'), +(20002, 0, 'NextWeeklyQuestResetTime'); diff --git a/sql/updates/3.3.3a_old/7921_characters_worldstates.sql b/sql/updates/3.3.3a_old/7921_characters_worldstates.sql new file mode 100644 index 00000000000..f2e08626b8c --- /dev/null +++ b/sql/updates/3.3.3a_old/7921_characters_worldstates.sql @@ -0,0 +1 @@ +ALTER TABLE `worldstates` CHANGE COLUMN `comment` `comment` text; diff --git a/sql/updates/3.3.3a_old/7922_world_spell_proc_event.sql b/sql/updates/3.3.3a_old/7922_world_spell_proc_event.sql new file mode 100644 index 00000000000..d7ab91f9045 --- /dev/null +++ b/sql/updates/3.3.3a_old/7922_world_spell_proc_event.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (66191,66192); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(66191, 0x00, 15, 0x00400010, 0x20020004, 0x00000000, 0x00000010, 0x00000000, 0, 100, 0), -- Threat of Thassarian (Rank 2) +(66192, 0x00, 15, 0x00400010, 0x20020004, 0x00000000, 0x00000010, 0x00000000, 0, 100, 0); -- Threat of Thassarian (Rank 3) + diff --git a/sql/updates/3.3.3a_old/7923_characters_characters.sql b/sql/updates/3.3.3a_old/7923_characters_characters.sql new file mode 100644 index 00000000000..a9fe4880731 --- /dev/null +++ b/sql/updates/3.3.3a_old/7923_characters_characters.sql @@ -0,0 +1,2 @@ +ALTER TABLE characters + ADD COLUMN `actionBars` tinyint(3) UNSIGNED NOT NULL default '0' AFTER knownTitles; diff --git a/sql/updates/3.3.3a_old/CMakeLists.txt b/sql/updates/3.3.3a_old/CMakeLists.txt new file mode 100644 index 00000000000..94143fe1e5b --- /dev/null +++ b/sql/updates/3.3.3a_old/CMakeLists.txt @@ -0,0 +1,5 @@ +FILE(GLOB _SQL_333 *.sql) + +INSTALL(FILES +${_SQL_333} +DESTINATION share/trinity/sql/updates/3.3.3a_old) \ No newline at end of file diff --git a/sql/updates/7834_characters_characters.sql b/sql/updates/7834_characters_characters.sql deleted file mode 100644 index 694010bcb42..00000000000 --- a/sql/updates/7834_characters_characters.sql +++ /dev/null @@ -1,22 +0,0 @@ -ALTER TABLE characters - ADD COLUMN `exploredZones` longtext AFTER activeSpec, - ADD COLUMN `equipmentCache` longtext AFTER exploredZones, - ADD COLUMN `ammoId` int(10) UNSIGNED NOT NULL default '0' AFTER equipmentCache, - ADD COLUMN `knownTitles` longtext AFTER ammoId; - -UPDATE characters SET -exploredZones = SUBSTRING(data, -length(SUBSTRING_INDEX(data, ' ', 1041))+2, -length(SUBSTRING_INDEX(data, ' ', 1168+1))- length(SUBSTRING_INDEX(data, ' ', 1041)) - 1), -equipmentCache = SUBSTRING(data, -length(SUBSTRING_INDEX(data, ' ', 283))+2, -length(SUBSTRING_INDEX(data, ' ', 320+1))- length(SUBSTRING_INDEX(data, ' ', 283)) - 1), -ammoId = SUBSTRING(data, -length(SUBSTRING_INDEX(data, ' ', 1198))+2, -length(SUBSTRING_INDEX(data, ' ', 1198+1))- length(SUBSTRING_INDEX(data, ' ', 1198)) - 1), -knownTitles = SUBSTRING(data, -length(SUBSTRING_INDEX(data, ' ', 626))+2, -length(SUBSTRING_INDEX(data, ' ', 631+1))- length(SUBSTRING_INDEX(data, ' ', 626)) - 1); - -ALTER TABLE characters - DROP COLUMN data; diff --git a/sql/updates/7845_characters_mail.sql b/sql/updates/7845_characters_mail.sql deleted file mode 100644 index 124322380c5..00000000000 --- a/sql/updates/7845_characters_mail.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE `mail` ADD COLUMN `body` longtext CHARSET utf8 COLLATE utf8_general_ci NULL after `subject`; - -UPDATE `mail` LEFT JOIN `item_text` ON `mail`.`itemtextid` = `item_text`.`id` SET `mail`.`body`=`item_text`.`text`; -DELETE item_text FROM mail, item_text WHERE mail.itemtextid = item_text.id; -ALTER TABLE `mail` DROP COLUMN `itemtextid`; diff --git a/sql/updates/7846_world_spell_dbc.sql b/sql/updates/7846_world_spell_dbc.sql deleted file mode 100644 index 0173fb01c53..00000000000 --- a/sql/updates/7846_world_spell_dbc.sql +++ /dev/null @@ -1,6 +0,0 @@ -ALTER TABLE spell_dbc DROP EffectBaseDice1; -ALTER TABLE spell_dbc DROP EffectBaseDice2; -ALTER TABLE spell_dbc DROP EffectBaseDice3; -ALTER TABLE spell_dbc DROP EffectDicePerLevel1; -ALTER TABLE spell_dbc DROP EffectDicePerLevel2; -ALTER TABLE spell_dbc DROP EffectDicePerLevel3; diff --git a/sql/updates/7849_realmd_realmlist.sql b/sql/updates/7849_realmd_realmlist.sql deleted file mode 100644 index da0fa6740d6..00000000000 --- a/sql/updates/7849_realmd_realmlist.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `realmlist` SET `gamebuild`=11723 WHERE `id`=1; diff --git a/sql/updates/7854_world_spell_goup.sql b/sql/updates/7854_world_spell_goup.sql deleted file mode 100644 index 5d663eff11e..00000000000 --- a/sql/updates/7854_world_spell_goup.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE FROM `spell_group` WHERE `spell_id` IN (61417, 61418); diff --git a/sql/updates/7854_world_spell_proc_event.sql b/sql/updates/7854_world_spell_proc_event.sql deleted file mode 100644 index b50127bd540..00000000000 --- a/sql/updates/7854_world_spell_proc_event.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN (58642, 58676, 61433, 61434, 33174, 33182, 51470, 44396, 29801, 30802, 30803, 30804, 30805, 30808, 30809, 49137, 49657, 51466, 53137, 53138, 44394, 44395, 44396, 34457); diff --git a/sql/updates/7854_world_spell_ranks.sql b/sql/updates/7854_world_spell_ranks.sql deleted file mode 100644 index eb9be8cc979..00000000000 --- a/sql/updates/7854_world_spell_ranks.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (30803, 33174, 61417, 9736, 15742); diff --git a/sql/updates/7857_realmd_realmlist.sql b/sql/updates/7857_realmd_realmlist.sql deleted file mode 100644 index c71c29989d0..00000000000 --- a/sql/updates/7857_realmd_realmlist.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `realmlist` CHANGE COLUMN `gamebuild` `gamebuild` int(11) unsigned NOT NULL default '11723'; diff --git a/sql/updates/7873_world_scriptname.sql b/sql/updates/7873_world_scriptname.sql deleted file mode 100644 index 8ae09707aed..00000000000 --- a/sql/updates/7873_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `gameobject_template` SET `ScriptName`='go_stillpine_cage' WHERE `entry`=181714; diff --git a/sql/updates/7881_world_spell_linked_spell.sql b/sql/updates/7881_world_spell_linked_spell.sql deleted file mode 100644 index af419be42e0..00000000000 --- a/sql/updates/7881_world_spell_linked_spell.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE FROM `spell_linked_spell` WHERE `spell_effect` IN (24395,24396,24397,26592,61417,61418); diff --git a/sql/updates/7884_world_spell_dbc.sql b/sql/updates/7884_world_spell_dbc.sql deleted file mode 100644 index 0fde674da64..00000000000 --- a/sql/updates/7884_world_spell_dbc.sql +++ /dev/null @@ -1,11 +0,0 @@ --- Add serverside spells place holders for future development -DELETE FROM `spell_dbc` WHERE `Id` IN (71356,71803,72111,72125,70816,72233,72234,72235); -INSERT INTO `spell_dbc` (`Id`,`Dispel`,`Mechanic`,`Attributes`,`AttributesEx`,`AttributesEx2`,`AttributesEx3`,`AttributesEx4`,`AttributesEx5`,`Targets`,`CastingTimeIndex`,`AuraInterruptFlags`,`ProcFlags`,`ProcChance`,`ProcCharges`,`MaxLevel`,`BaseLevel`,`SpellLevel`,`DurationIndex`,`RangeIndex`,`StackAmount`,`EquippedItemClass`,`EquippedItemSubClassMask`,`EquippedItemInventoryTypeMask`,`Effect1`,`Effect2`,`Effect3`,`EffectDieSides1`,`EffectDieSides2`,`EffectDieSides3`,`EffectRealPointsPerLevel1`,`EffectRealPointsPerLevel2`,`EffectRealPointsPerLevel3`,`EffectBasePoints1`,`EffectBasePoints2`,`EffectBasePoints3`,`EffectMechanic1`,`EffectMechanic2`,`EffectMechanic3`,`EffectImplicitTargetA1`,`EffectImplicitTargetA2`,`EffectImplicitTargetA3`,`EffectImplicitTargetB1`,`EffectImplicitTargetB2`,`EffectImplicitTargetB3`,`EffectRadiusIndex1`,`EffectRadiusIndex2`,`EffectRadiusIndex3`,`EffectApplyAuraName1`,`EffectApplyAuraName2`,`EffectApplyAuraName3`,`EffectAmplitude1`,`EffectAmplitude2`,`EffectAmplitude3`,`EffectMultipleValue1`,`EffectMultipleValue2`,`EffectMultipleValue3`,`EffectMiscValue1`,`EffectMiscValue2`,`EffectMiscValue3`,`EffectMiscValueB1`,`EffectMiscValueB2`,`EffectMiscValueB3`,`EffectTriggerSpell1`,`EffectTriggerSpell2`,`EffectTriggerSpell3`,`EffectSpellClassMaskA1`,`EffectSpellClassMaskA2`,`EffectSpellClassMaskA3`,`EffectSpellClassMaskB1`,`EffectSpellClassMaskB2`,`EffectSpellClassMaskB3`,`EffectSpellClassMaskC1`,`EffectSpellClassMaskC2`,`EffectSpellClassMaskC3`,`MaxTargetLevel`,`SpellFamilyName`,`SpellFamilyFlags1`,`SpellFamilyFlags2`,`SpellFamilyFlags3`,`MaxAffectedTargets`,`DmgClass`,`PreventionType`,`DmgMultiplier1`,`DmgMultiplier2`,`DmgMultiplier3`,`AreaGroupId`,`SchoolMask`,`Comment`) VALUES -(71356, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2108 spellid0 serverside spell'), -(71803, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2108 spellid1 serverside spell'), -(72111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2136 spellid0 serverside spell'), -(72125, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2136 spellid1 serverside spell'), -(70816, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2146 spellid0 serverside spell'), -(72233, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2146 spellid1 serverside spell'), -(72234, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2146 spellid2 serverside spell'), -(72235, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2146 spellid3 serverside spell'); diff --git a/sql/updates/7884_world_spelldifficulty_dbc.sql b/sql/updates/7884_world_spelldifficulty_dbc.sql deleted file mode 100644 index 1cbbadf3c2e..00000000000 --- a/sql/updates/7884_world_spelldifficulty_dbc.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `spelldifficulty_dbc` SET `spellid1`=58827 WHERE `id`=3014; diff --git a/sql/updates/7893_characters_characters.sql b/sql/updates/7893_characters_characters.sql deleted file mode 100644 index 3dea7f98e27..00000000000 --- a/sql/updates/7893_characters_characters.sql +++ /dev/null @@ -1,10 +0,0 @@ -UPDATE item_instance SET data = REPLACE(data,' ',' '); -UPDATE item_instance SET data = CONCAT(TRIM(data),' '); - -UPDATE `item_instance` SET `data` = CONCAT( - SUBSTRING_INDEX(`data`, ' ', 59 + 1), ' ', - SUBSTRING_INDEX(`data`, ' ', -3 -1), '0 ') -WHERE length(SUBSTRING_INDEX(data, ' ', 64)) < length(data) and length(SUBSTRING_INDEX(data, ' ', 64+1)) >= length(data); - -UPDATE item_instance SET data = REPLACE(data,' ',' '); -UPDATE item_instance SET data = CONCAT(TRIM(data),' '); diff --git a/sql/updates/7904_characters_item_instance.sql b/sql/updates/7904_characters_item_instance.sql deleted file mode 100644 index 95cd7bca248..00000000000 --- a/sql/updates/7904_characters_item_instance.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `item_instance` ADD COLUMN `text` longtext AFTER `data`; diff --git a/sql/updates/7904_characters_item_text.sql b/sql/updates/7904_characters_item_text.sql deleted file mode 100644 index 517a4a04026..00000000000 --- a/sql/updates/7904_characters_item_text.sql +++ /dev/null @@ -1 +0,0 @@ -DROP TABLE IF EXISTS `item_text`; diff --git a/sql/updates/7905_characters_character_equipmentsets.sql b/sql/updates/7905_characters_character_equipmentsets.sql deleted file mode 100644 index 1617c61f1ee..00000000000 --- a/sql/updates/7905_characters_character_equipmentsets.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `character_equipmentsets` ADD INDEX `Idx_setindex` (`setindex`); diff --git a/sql/updates/7905_characters_corpse.sql b/sql/updates/7905_characters_corpse.sql deleted file mode 100644 index 061c90e9bfc..00000000000 --- a/sql/updates/7905_characters_corpse.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `corpse` ADD INDEX `Idx_player`(`player`); -ALTER TABLE `corpse` ADD INDEX `Idx_time`(`time`); diff --git a/sql/updates/7905_characters_group_member.sql b/sql/updates/7905_characters_group_member.sql deleted file mode 100644 index 7c7c3eace14..00000000000 --- a/sql/updates/7905_characters_group_member.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `group_member` ADD INDEX `Idx_memberGuid`(`memberGuid`); diff --git a/sql/updates/7905_characters_guild.sql b/sql/updates/7905_characters_guild.sql deleted file mode 100644 index 451df6671db..00000000000 --- a/sql/updates/7905_characters_guild.sql +++ /dev/null @@ -1,7 +0,0 @@ -ALTER TABLE `guild_eventlog` ADD INDEX `Idx_PlayerGuid1`(`PlayerGuid1`); -ALTER TABLE `guild_eventlog` ADD INDEX `Idx_PlayerGuid2`(`PlayerGuid2`); -ALTER TABLE `guild_eventlog` ADD INDEX `Idx_LogGuid`(`LogGuid`); -ALTER TABLE `guild_bank_eventlog` ADD INDEX `Idx_PlayerGuid`(`PlayerGuid`); -ALTER TABLE `guild_bank_eventlog` ADD INDEX `Idx_LogGuid`(`LogGuid`); -ALTER TABLE `guild_bank_item` ADD INDEX `Idx_item_guid`(`item_guid`); -ALTER TABLE `guild_rank` ADD INDEX `Idx_rid`(`rid`); diff --git a/sql/updates/7905_characters_petition.sql b/sql/updates/7905_characters_petition.sql deleted file mode 100644 index 844f2d0d89f..00000000000 --- a/sql/updates/7905_characters_petition.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `petition_sign` ADD INDEX `Idx_playerguid`(`playerguid`); -ALTER TABLE `petition_sign` ADD INDEX `Idx_ownerguid`(`ownerguid`); diff --git a/sql/updates/7906_characters_character_stats.sql b/sql/updates/7906_characters_character_stats.sql deleted file mode 100644 index 82aebbbaf51..00000000000 --- a/sql/updates/7906_characters_character_stats.sql +++ /dev/null @@ -1,34 +0,0 @@ -DROP TABLE IF EXISTS `character_stats`; -CREATE TABLE `character_stats` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part', - `maxhealth` int(10) UNSIGNED NOT NULL default '0', - `maxpower1` int(10) UNSIGNED NOT NULL default '0', - `maxpower2` int(10) UNSIGNED NOT NULL default '0', - `maxpower3` int(10) UNSIGNED NOT NULL default '0', - `maxpower4` int(10) UNSIGNED NOT NULL default '0', - `maxpower5` int(10) UNSIGNED NOT NULL default '0', - `maxpower6` int(10) UNSIGNED NOT NULL default '0', - `maxpower7` int(10) UNSIGNED NOT NULL default '0', - `strength` int(10) UNSIGNED NOT NULL default '0', - `agility` int(10) UNSIGNED NOT NULL default '0', - `stamina` int(10) UNSIGNED NOT NULL default '0', - `intellect` int(10) UNSIGNED NOT NULL default '0', - `spirit` int(10) UNSIGNED NOT NULL default '0', - `armor` int(10) UNSIGNED NOT NULL default '0', - `resHoly` int(10) UNSIGNED NOT NULL default '0', - `resFire` int(10) UNSIGNED NOT NULL default '0', - `resNature` int(10) UNSIGNED NOT NULL default '0', - `resFrost` int(10) UNSIGNED NOT NULL default '0', - `resShadow` int(10) UNSIGNED NOT NULL default '0', - `resArcane` int(10) UNSIGNED NOT NULL default '0', - `blockPct` float UNSIGNED NOT NULL default '0', - `dodgePct` float UNSIGNED NOT NULL default '0', - `parryPct` float UNSIGNED NOT NULL default '0', - `critPct` float UNSIGNED NOT NULL default '0', - `rangedCritPct` float UNSIGNED NOT NULL default '0', - `spellCritPct` float UNSIGNED NOT NULL default '0', - `attackPower` int(10) UNSIGNED NOT NULL default '0', - `rangedAttackPower` int(10) UNSIGNED NOT NULL default '0', - `spellPower` int(10) UNSIGNED NOT NULL default '0', - PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/updates/7909_world_scriptname.sql b/sql/updates/7909_world_scriptname.sql deleted file mode 100644 index 824c090800e..00000000000 --- a/sql/updates/7909_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_pet_trainer' WHERE `entry` IN (10090,3698,17484,4320,3545,16712,3622,16675,3620,10086,2879,3306,543,2878,3688,10089,16271,10088,3624); diff --git a/sql/updates/7914_characters_character_queststatus_weekly.sql b/sql/updates/7914_characters_character_queststatus_weekly.sql deleted file mode 100644 index 1bced542b9f..00000000000 --- a/sql/updates/7914_characters_character_queststatus_weekly.sql +++ /dev/null @@ -1,7 +0,0 @@ -DROP TABLE IF EXISTS `character_queststatus_weekly`; -CREATE TABLE `character_queststatus_weekly` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', - PRIMARY KEY (`guid`,`quest`), - KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; diff --git a/sql/updates/7914_characters_worldstates.sql b/sql/updates/7914_characters_worldstates.sql deleted file mode 100644 index 5b150518e87..00000000000 --- a/sql/updates/7914_characters_worldstates.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `worldstates` ADD COLUMN `NextWeeklyQuestResetTime` bigint(40) unsigned NOT NULL default '0' AFTER `value`; diff --git a/sql/updates/7915_characters_worldstates.sql b/sql/updates/7915_characters_worldstates.sql deleted file mode 100644 index ffa573b6433..00000000000 --- a/sql/updates/7915_characters_worldstates.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `worldstates` DROP COLUMN `NextWeeklyQuestResetTime`; -INSERT INTO `worldstates` (`entry`,`value`, `comment`) VALUES (20002, 0, 'NextWeeklyQuestResetTime'); diff --git a/sql/updates/7919_characters_worldstates.sql b/sql/updates/7919_characters_worldstates.sql deleted file mode 100644 index b265aebb92e..00000000000 --- a/sql/updates/7919_characters_worldstates.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `worldstates` WHERE `entry` IN (20001,20002); -INSERT INTO `worldstates` (`entry`,`value`, `comment`) VALUES -(20001, 0, 'NextArenaPointDistributionTime'), -(20002, 0, 'NextWeeklyQuestResetTime'); diff --git a/sql/updates/7921_characters_worldstates.sql b/sql/updates/7921_characters_worldstates.sql deleted file mode 100644 index f2e08626b8c..00000000000 --- a/sql/updates/7921_characters_worldstates.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `worldstates` CHANGE COLUMN `comment` `comment` text; diff --git a/sql/updates/7922_world_spell_proc_event.sql b/sql/updates/7922_world_spell_proc_event.sql deleted file mode 100644 index d7ab91f9045..00000000000 --- a/sql/updates/7922_world_spell_proc_event.sql +++ /dev/null @@ -1,5 +0,0 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN (66191,66192); -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(66191, 0x00, 15, 0x00400010, 0x20020004, 0x00000000, 0x00000010, 0x00000000, 0, 100, 0), -- Threat of Thassarian (Rank 2) -(66192, 0x00, 15, 0x00400010, 0x20020004, 0x00000000, 0x00000010, 0x00000000, 0, 100, 0); -- Threat of Thassarian (Rank 3) - diff --git a/sql/updates/7923_characters_characters.sql b/sql/updates/7923_characters_characters.sql deleted file mode 100644 index a9fe4880731..00000000000 --- a/sql/updates/7923_characters_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE characters - ADD COLUMN `actionBars` tinyint(3) UNSIGNED NOT NULL default '0' AFTER knownTitles; diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt index 1c93b666976..68639a4b265 100644 --- a/sql/updates/CMakeLists.txt +++ b/sql/updates/CMakeLists.txt @@ -3,6 +3,7 @@ add_subdirectory(3.0.9_old) add_subdirectory(3.1.3_old) add_subdirectory(3.2.2a_old) add_subdirectory(3.3.2_old) +add_subdirectory(3.3.3a_old) FILE(GLOB _SQL_UPDATES *.sql) -- cgit v1.2.3