diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/old/3.3.5a/2011_10_29_00_world_version.sql (renamed from sql/updates/world/2011_10_29_00_world_version.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_10_29_01_world_gameobject_template.sql (renamed from sql/updates/world/2011_10_29_01_world_gameobject_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_10_29_02_world_gameobject_template.sql (renamed from sql/updates/world/2011_10_29_02_world_gameobject_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_10_29_03_world_gameobject_template.sql (renamed from sql/updates/world/2011_10_29_03_world_gameobject_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_10_29_04_world_linked_respawn.sql (renamed from sql/updates/world/2011_10_29_04_world_linked_respawn.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_10_29_05_world_sai.sql (renamed from sql/updates/world/2011_10_29_05_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_10_29_06_world_misc.sql (renamed from sql/updates/world/2011_10_29_06_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_10_29_06_world_sai.sql (renamed from sql/updates/world/2011_10_29_06_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_10_29_07_world_gameobjects.sql (renamed from sql/updates/world/2011_10_29_07_world_gameobjects.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_10_30_00_world_misc.sql (renamed from sql/updates/world/2011_10_30_00_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_10_30_01_world_misc.sql (renamed from sql/updates/world/2011_10_30_01_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_10_30_02_world_creature_template.sql (renamed from sql/updates/world/2011_10_30_02_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_10_30_02_world_player_factionchange_achievement.sql (renamed from sql/updates/world/2011_10_30_02_world_player_factionchange_achievement.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_01_00_world_sai.sql (renamed from sql/updates/world/2011_11_01_00_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_07_00_world_player_factionchange_items.sql (renamed from sql/updates/world/2011_11_07_00_world_player_factionchange_items.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_07_01_world_areatrigger_teleport.sql (renamed from sql/updates/world/2011_11_07_01_world_areatrigger_teleport.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_07_02_world_misc.sql (renamed from sql/updates/world/2011_11_07_02_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_07_03_world_misc.sql (renamed from sql/updates/world/2011_11_07_03_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_11_00_world_spell_proc_event.sql (renamed from sql/updates/world/2011_11_11_00_world_spell_proc_event.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_11_01_world_misc.sql (renamed from sql/updates/world/2011_11_11_01_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_13_00_world_spell_proc_event.sql (renamed from sql/updates/world/2011_11_13_00_world_spell_proc_event.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_13_01_world_sai.sql (renamed from sql/updates/world/2011_11_13_01_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_13_02_world_pool_template.sql (renamed from sql/updates/world/2011_11_13_02_world_pool_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_13_03_world_npc_trainer.sql (renamed from sql/updates/world/2011_11_13_03_world_npc_trainer.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_13_04_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_04_world_creature_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_13_05_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_05_world_creature_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_13_06_world_reference_loot_template.sql (renamed from sql/updates/world/2011_11_13_06_world_reference_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_13_07_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_07_world_creature_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_13_08_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_08_world_creature_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_13_09_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_09_world_creature_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_13_10_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_10_world_creature_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_13_11_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_11_world_creature_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_13_12_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_12_world_creature_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_00_world_command.sql (renamed from sql/updates/world/2011_11_20_00_world_command.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_01_world_sai.sql (renamed from sql/updates/world/2011_11_20_01_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_02_world_sai.sql (renamed from sql/updates/world/2011_11_20_02_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_03_world_sai.sql (renamed from sql/updates/world/2011_11_20_03_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_04_world_sai.sql (renamed from sql/updates/world/2011_11_20_04_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_05_world_sai.sql (renamed from sql/updates/world/2011_11_20_05_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_06_world_sai.sql (renamed from sql/updates/world/2011_11_20_06_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_07_world_sai.sql (renamed from sql/updates/world/2011_11_20_07_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_08_world_achievement_criteria_data.sql (renamed from sql/updates/world/2011_11_20_08_world_achievement_criteria_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_09_world_sai.sql (renamed from sql/updates/world/2011_11_20_09_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_10_world_sai.sql (renamed from sql/updates/world/2011_11_20_10_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_11_world_sai.sql (renamed from sql/updates/world/2011_11_20_11_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_12_world_sai.sql (renamed from sql/updates/world/2011_11_20_12_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_13_world_sai.sql (renamed from sql/updates/world/2011_11_20_13_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_14_world_revert.sql (renamed from sql/updates/world/2011_11_20_14_world_revert.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_20_15_world_sai.sql (renamed from sql/updates/world/2011_11_20_15_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_21_00_world_db_errors.sql (renamed from sql/updates/world/2011_11_21_00_world_db_errors.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_21_01_pilgrim_achievement_reward.sql (renamed from sql/updates/world/2011_11_21_01_pilgrim_achievement_reward.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_21_02_pilgrim_achievement_criteria_data.sql (renamed from sql/updates/world/2011_11_21_02_pilgrim_achievement_criteria_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_21_03_pilgrim_misc.sql (renamed from sql/updates/world/2011_11_21_03_pilgrim_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_21_04_pilgrim_misc.sql (renamed from sql/updates/world/2011_11_21_04_pilgrim_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_21_05_pilgrim_tables.sql (renamed from sql/updates/world/2011_11_21_05_pilgrim_tables.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/world/2011_11_24_00_world_version.sql | 1 | ||||
| -rw-r--r-- | sql/updates/world/2011_11_25_00_world_quest_template.sql | 38 | ||||
| -rw-r--r-- | sql/updates/world/2011_11_25_01_world_quest_template.sql | 1 | ||||
| -rw-r--r-- | sql/updates/world/2011_11_25_02_world_creature.sql | 4 | ||||
| -rw-r--r-- | sql/updates/world/2011_11_26_00_world_quest_template.sql | 177 | ||||
| -rw-r--r-- | sql/updates/world/2011_11_26_01_world_quest_template.sql | 1 |
61 files changed, 222 insertions, 0 deletions
diff --git a/sql/updates/world/2011_10_29_00_world_version.sql b/sql/old/3.3.5a/2011_10_29_00_world_version.sql index 17a94041a33..17a94041a33 100644 --- a/sql/updates/world/2011_10_29_00_world_version.sql +++ b/sql/old/3.3.5a/2011_10_29_00_world_version.sql diff --git a/sql/updates/world/2011_10_29_01_world_gameobject_template.sql b/sql/old/3.3.5a/2011_10_29_01_world_gameobject_template.sql index 744a549eebd..744a549eebd 100644 --- a/sql/updates/world/2011_10_29_01_world_gameobject_template.sql +++ b/sql/old/3.3.5a/2011_10_29_01_world_gameobject_template.sql diff --git a/sql/updates/world/2011_10_29_02_world_gameobject_template.sql b/sql/old/3.3.5a/2011_10_29_02_world_gameobject_template.sql index 9134a66ee2b..9134a66ee2b 100644 --- a/sql/updates/world/2011_10_29_02_world_gameobject_template.sql +++ b/sql/old/3.3.5a/2011_10_29_02_world_gameobject_template.sql diff --git a/sql/updates/world/2011_10_29_03_world_gameobject_template.sql b/sql/old/3.3.5a/2011_10_29_03_world_gameobject_template.sql index 6b73da94441..6b73da94441 100644 --- a/sql/updates/world/2011_10_29_03_world_gameobject_template.sql +++ b/sql/old/3.3.5a/2011_10_29_03_world_gameobject_template.sql diff --git a/sql/updates/world/2011_10_29_04_world_linked_respawn.sql b/sql/old/3.3.5a/2011_10_29_04_world_linked_respawn.sql index 94d2c0d730d..94d2c0d730d 100644 --- a/sql/updates/world/2011_10_29_04_world_linked_respawn.sql +++ b/sql/old/3.3.5a/2011_10_29_04_world_linked_respawn.sql diff --git a/sql/updates/world/2011_10_29_05_world_sai.sql b/sql/old/3.3.5a/2011_10_29_05_world_sai.sql index fc17ca8a1a7..fc17ca8a1a7 100644 --- a/sql/updates/world/2011_10_29_05_world_sai.sql +++ b/sql/old/3.3.5a/2011_10_29_05_world_sai.sql diff --git a/sql/updates/world/2011_10_29_06_world_misc.sql b/sql/old/3.3.5a/2011_10_29_06_world_misc.sql index 7706777b32f..7706777b32f 100644 --- a/sql/updates/world/2011_10_29_06_world_misc.sql +++ b/sql/old/3.3.5a/2011_10_29_06_world_misc.sql diff --git a/sql/updates/world/2011_10_29_06_world_sai.sql b/sql/old/3.3.5a/2011_10_29_06_world_sai.sql index a3d1626a8f9..a3d1626a8f9 100644 --- a/sql/updates/world/2011_10_29_06_world_sai.sql +++ b/sql/old/3.3.5a/2011_10_29_06_world_sai.sql diff --git a/sql/updates/world/2011_10_29_07_world_gameobjects.sql b/sql/old/3.3.5a/2011_10_29_07_world_gameobjects.sql index 541cadd71a0..541cadd71a0 100644 --- a/sql/updates/world/2011_10_29_07_world_gameobjects.sql +++ b/sql/old/3.3.5a/2011_10_29_07_world_gameobjects.sql diff --git a/sql/updates/world/2011_10_30_00_world_misc.sql b/sql/old/3.3.5a/2011_10_30_00_world_misc.sql index 912f13f364c..912f13f364c 100644 --- a/sql/updates/world/2011_10_30_00_world_misc.sql +++ b/sql/old/3.3.5a/2011_10_30_00_world_misc.sql diff --git a/sql/updates/world/2011_10_30_01_world_misc.sql b/sql/old/3.3.5a/2011_10_30_01_world_misc.sql index 9c42045c821..9c42045c821 100644 --- a/sql/updates/world/2011_10_30_01_world_misc.sql +++ b/sql/old/3.3.5a/2011_10_30_01_world_misc.sql diff --git a/sql/updates/world/2011_10_30_02_world_creature_template.sql b/sql/old/3.3.5a/2011_10_30_02_world_creature_template.sql index 50fc50e9c14..50fc50e9c14 100644 --- a/sql/updates/world/2011_10_30_02_world_creature_template.sql +++ b/sql/old/3.3.5a/2011_10_30_02_world_creature_template.sql diff --git a/sql/updates/world/2011_10_30_02_world_player_factionchange_achievement.sql b/sql/old/3.3.5a/2011_10_30_02_world_player_factionchange_achievement.sql index 5f7c3bf46f6..5f7c3bf46f6 100644 --- a/sql/updates/world/2011_10_30_02_world_player_factionchange_achievement.sql +++ b/sql/old/3.3.5a/2011_10_30_02_world_player_factionchange_achievement.sql diff --git a/sql/updates/world/2011_11_01_00_world_sai.sql b/sql/old/3.3.5a/2011_11_01_00_world_sai.sql index f4e12082ea9..f4e12082ea9 100644 --- a/sql/updates/world/2011_11_01_00_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_01_00_world_sai.sql diff --git a/sql/updates/world/2011_11_07_00_world_player_factionchange_items.sql b/sql/old/3.3.5a/2011_11_07_00_world_player_factionchange_items.sql index 54a36473fb3..54a36473fb3 100644 --- a/sql/updates/world/2011_11_07_00_world_player_factionchange_items.sql +++ b/sql/old/3.3.5a/2011_11_07_00_world_player_factionchange_items.sql diff --git a/sql/updates/world/2011_11_07_01_world_areatrigger_teleport.sql b/sql/old/3.3.5a/2011_11_07_01_world_areatrigger_teleport.sql index 2164d24ef5f..2164d24ef5f 100644 --- a/sql/updates/world/2011_11_07_01_world_areatrigger_teleport.sql +++ b/sql/old/3.3.5a/2011_11_07_01_world_areatrigger_teleport.sql diff --git a/sql/updates/world/2011_11_07_02_world_misc.sql b/sql/old/3.3.5a/2011_11_07_02_world_misc.sql index b40ad4dc7bf..b40ad4dc7bf 100644 --- a/sql/updates/world/2011_11_07_02_world_misc.sql +++ b/sql/old/3.3.5a/2011_11_07_02_world_misc.sql diff --git a/sql/updates/world/2011_11_07_03_world_misc.sql b/sql/old/3.3.5a/2011_11_07_03_world_misc.sql index 97b538237bd..97b538237bd 100644 --- a/sql/updates/world/2011_11_07_03_world_misc.sql +++ b/sql/old/3.3.5a/2011_11_07_03_world_misc.sql diff --git a/sql/updates/world/2011_11_11_00_world_spell_proc_event.sql b/sql/old/3.3.5a/2011_11_11_00_world_spell_proc_event.sql index 997ede4a886..997ede4a886 100644 --- a/sql/updates/world/2011_11_11_00_world_spell_proc_event.sql +++ b/sql/old/3.3.5a/2011_11_11_00_world_spell_proc_event.sql diff --git a/sql/updates/world/2011_11_11_01_world_misc.sql b/sql/old/3.3.5a/2011_11_11_01_world_misc.sql index f48d3f8200e..f48d3f8200e 100644 --- a/sql/updates/world/2011_11_11_01_world_misc.sql +++ b/sql/old/3.3.5a/2011_11_11_01_world_misc.sql diff --git a/sql/updates/world/2011_11_13_00_world_spell_proc_event.sql b/sql/old/3.3.5a/2011_11_13_00_world_spell_proc_event.sql index 393282c229c..393282c229c 100644 --- a/sql/updates/world/2011_11_13_00_world_spell_proc_event.sql +++ b/sql/old/3.3.5a/2011_11_13_00_world_spell_proc_event.sql diff --git a/sql/updates/world/2011_11_13_01_world_sai.sql b/sql/old/3.3.5a/2011_11_13_01_world_sai.sql index 1a4ed5b29d9..1a4ed5b29d9 100644 --- a/sql/updates/world/2011_11_13_01_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_13_01_world_sai.sql diff --git a/sql/updates/world/2011_11_13_02_world_pool_template.sql b/sql/old/3.3.5a/2011_11_13_02_world_pool_template.sql index 257398d4457..257398d4457 100644 --- a/sql/updates/world/2011_11_13_02_world_pool_template.sql +++ b/sql/old/3.3.5a/2011_11_13_02_world_pool_template.sql diff --git a/sql/updates/world/2011_11_13_03_world_npc_trainer.sql b/sql/old/3.3.5a/2011_11_13_03_world_npc_trainer.sql index 0db753c008b..0db753c008b 100644 --- a/sql/updates/world/2011_11_13_03_world_npc_trainer.sql +++ b/sql/old/3.3.5a/2011_11_13_03_world_npc_trainer.sql diff --git a/sql/updates/world/2011_11_13_04_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_04_world_creature_loot_template.sql index b68d12a031d..b68d12a031d 100644 --- a/sql/updates/world/2011_11_13_04_world_creature_loot_template.sql +++ b/sql/old/3.3.5a/2011_11_13_04_world_creature_loot_template.sql diff --git a/sql/updates/world/2011_11_13_05_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_05_world_creature_loot_template.sql index 722027bd343..722027bd343 100644 --- a/sql/updates/world/2011_11_13_05_world_creature_loot_template.sql +++ b/sql/old/3.3.5a/2011_11_13_05_world_creature_loot_template.sql diff --git a/sql/updates/world/2011_11_13_06_world_reference_loot_template.sql b/sql/old/3.3.5a/2011_11_13_06_world_reference_loot_template.sql index efb2fec72f3..efb2fec72f3 100644 --- a/sql/updates/world/2011_11_13_06_world_reference_loot_template.sql +++ b/sql/old/3.3.5a/2011_11_13_06_world_reference_loot_template.sql diff --git a/sql/updates/world/2011_11_13_07_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_07_world_creature_loot_template.sql index 728ce731313..728ce731313 100644 --- a/sql/updates/world/2011_11_13_07_world_creature_loot_template.sql +++ b/sql/old/3.3.5a/2011_11_13_07_world_creature_loot_template.sql diff --git a/sql/updates/world/2011_11_13_08_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_08_world_creature_loot_template.sql index 55f58d4fbba..55f58d4fbba 100644 --- a/sql/updates/world/2011_11_13_08_world_creature_loot_template.sql +++ b/sql/old/3.3.5a/2011_11_13_08_world_creature_loot_template.sql diff --git a/sql/updates/world/2011_11_13_09_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_09_world_creature_loot_template.sql index 6356c93a9ba..6356c93a9ba 100644 --- a/sql/updates/world/2011_11_13_09_world_creature_loot_template.sql +++ b/sql/old/3.3.5a/2011_11_13_09_world_creature_loot_template.sql diff --git a/sql/updates/world/2011_11_13_10_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_10_world_creature_loot_template.sql index 3052ba96745..3052ba96745 100644 --- a/sql/updates/world/2011_11_13_10_world_creature_loot_template.sql +++ b/sql/old/3.3.5a/2011_11_13_10_world_creature_loot_template.sql diff --git a/sql/updates/world/2011_11_13_11_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_11_world_creature_loot_template.sql index 9f753577844..9f753577844 100644 --- a/sql/updates/world/2011_11_13_11_world_creature_loot_template.sql +++ b/sql/old/3.3.5a/2011_11_13_11_world_creature_loot_template.sql diff --git a/sql/updates/world/2011_11_13_12_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_12_world_creature_loot_template.sql index 7982910cee6..7982910cee6 100644 --- a/sql/updates/world/2011_11_13_12_world_creature_loot_template.sql +++ b/sql/old/3.3.5a/2011_11_13_12_world_creature_loot_template.sql diff --git a/sql/updates/world/2011_11_20_00_world_command.sql b/sql/old/3.3.5a/2011_11_20_00_world_command.sql index 73d52974766..73d52974766 100644 --- a/sql/updates/world/2011_11_20_00_world_command.sql +++ b/sql/old/3.3.5a/2011_11_20_00_world_command.sql diff --git a/sql/updates/world/2011_11_20_01_world_sai.sql b/sql/old/3.3.5a/2011_11_20_01_world_sai.sql index dbb4f39a499..dbb4f39a499 100644 --- a/sql/updates/world/2011_11_20_01_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_20_01_world_sai.sql diff --git a/sql/updates/world/2011_11_20_02_world_sai.sql b/sql/old/3.3.5a/2011_11_20_02_world_sai.sql index f064aa67f9f..f064aa67f9f 100644 --- a/sql/updates/world/2011_11_20_02_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_20_02_world_sai.sql diff --git a/sql/updates/world/2011_11_20_03_world_sai.sql b/sql/old/3.3.5a/2011_11_20_03_world_sai.sql index bd47430acd8..bd47430acd8 100644 --- a/sql/updates/world/2011_11_20_03_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_20_03_world_sai.sql diff --git a/sql/updates/world/2011_11_20_04_world_sai.sql b/sql/old/3.3.5a/2011_11_20_04_world_sai.sql index e362b0d0866..e362b0d0866 100644 --- a/sql/updates/world/2011_11_20_04_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_20_04_world_sai.sql diff --git a/sql/updates/world/2011_11_20_05_world_sai.sql b/sql/old/3.3.5a/2011_11_20_05_world_sai.sql index 464d0635bb8..464d0635bb8 100644 --- a/sql/updates/world/2011_11_20_05_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_20_05_world_sai.sql diff --git a/sql/updates/world/2011_11_20_06_world_sai.sql b/sql/old/3.3.5a/2011_11_20_06_world_sai.sql index 68bffade858..68bffade858 100644 --- a/sql/updates/world/2011_11_20_06_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_20_06_world_sai.sql diff --git a/sql/updates/world/2011_11_20_07_world_sai.sql b/sql/old/3.3.5a/2011_11_20_07_world_sai.sql index efb89f6ba5a..efb89f6ba5a 100644 --- a/sql/updates/world/2011_11_20_07_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_20_07_world_sai.sql diff --git a/sql/updates/world/2011_11_20_08_world_achievement_criteria_data.sql b/sql/old/3.3.5a/2011_11_20_08_world_achievement_criteria_data.sql index 6e121274acb..6e121274acb 100644 --- a/sql/updates/world/2011_11_20_08_world_achievement_criteria_data.sql +++ b/sql/old/3.3.5a/2011_11_20_08_world_achievement_criteria_data.sql diff --git a/sql/updates/world/2011_11_20_09_world_sai.sql b/sql/old/3.3.5a/2011_11_20_09_world_sai.sql index 8931a7084d9..8931a7084d9 100644 --- a/sql/updates/world/2011_11_20_09_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_20_09_world_sai.sql diff --git a/sql/updates/world/2011_11_20_10_world_sai.sql b/sql/old/3.3.5a/2011_11_20_10_world_sai.sql index b56fd826e95..b56fd826e95 100644 --- a/sql/updates/world/2011_11_20_10_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_20_10_world_sai.sql diff --git a/sql/updates/world/2011_11_20_11_world_sai.sql b/sql/old/3.3.5a/2011_11_20_11_world_sai.sql index a05b26e6831..a05b26e6831 100644 --- a/sql/updates/world/2011_11_20_11_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_20_11_world_sai.sql diff --git a/sql/updates/world/2011_11_20_12_world_sai.sql b/sql/old/3.3.5a/2011_11_20_12_world_sai.sql index 527db0e02e7..527db0e02e7 100644 --- a/sql/updates/world/2011_11_20_12_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_20_12_world_sai.sql diff --git a/sql/updates/world/2011_11_20_13_world_sai.sql b/sql/old/3.3.5a/2011_11_20_13_world_sai.sql index c4cd10912a3..c4cd10912a3 100644 --- a/sql/updates/world/2011_11_20_13_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_20_13_world_sai.sql diff --git a/sql/updates/world/2011_11_20_14_world_revert.sql b/sql/old/3.3.5a/2011_11_20_14_world_revert.sql index 067c750b694..067c750b694 100644 --- a/sql/updates/world/2011_11_20_14_world_revert.sql +++ b/sql/old/3.3.5a/2011_11_20_14_world_revert.sql diff --git a/sql/updates/world/2011_11_20_15_world_sai.sql b/sql/old/3.3.5a/2011_11_20_15_world_sai.sql index 8e0b4141379..8e0b4141379 100644 --- a/sql/updates/world/2011_11_20_15_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_20_15_world_sai.sql diff --git a/sql/updates/world/2011_11_21_00_world_db_errors.sql b/sql/old/3.3.5a/2011_11_21_00_world_db_errors.sql index d3ae6fb197b..d3ae6fb197b 100644 --- a/sql/updates/world/2011_11_21_00_world_db_errors.sql +++ b/sql/old/3.3.5a/2011_11_21_00_world_db_errors.sql diff --git a/sql/updates/world/2011_11_21_01_pilgrim_achievement_reward.sql b/sql/old/3.3.5a/2011_11_21_01_pilgrim_achievement_reward.sql index 7083107a8c2..7083107a8c2 100644 --- a/sql/updates/world/2011_11_21_01_pilgrim_achievement_reward.sql +++ b/sql/old/3.3.5a/2011_11_21_01_pilgrim_achievement_reward.sql diff --git a/sql/updates/world/2011_11_21_02_pilgrim_achievement_criteria_data.sql b/sql/old/3.3.5a/2011_11_21_02_pilgrim_achievement_criteria_data.sql index 589dbb0b2a4..589dbb0b2a4 100644 --- a/sql/updates/world/2011_11_21_02_pilgrim_achievement_criteria_data.sql +++ b/sql/old/3.3.5a/2011_11_21_02_pilgrim_achievement_criteria_data.sql diff --git a/sql/updates/world/2011_11_21_03_pilgrim_misc.sql b/sql/old/3.3.5a/2011_11_21_03_pilgrim_misc.sql index 6547fe9a53a..6547fe9a53a 100644 --- a/sql/updates/world/2011_11_21_03_pilgrim_misc.sql +++ b/sql/old/3.3.5a/2011_11_21_03_pilgrim_misc.sql diff --git a/sql/updates/world/2011_11_21_04_pilgrim_misc.sql b/sql/old/3.3.5a/2011_11_21_04_pilgrim_misc.sql index 194c084ebc5..194c084ebc5 100644 --- a/sql/updates/world/2011_11_21_04_pilgrim_misc.sql +++ b/sql/old/3.3.5a/2011_11_21_04_pilgrim_misc.sql diff --git a/sql/updates/world/2011_11_21_05_pilgrim_tables.sql b/sql/old/3.3.5a/2011_11_21_05_pilgrim_tables.sql index 18881e14eaf..18881e14eaf 100644 --- a/sql/updates/world/2011_11_21_05_pilgrim_tables.sql +++ b/sql/old/3.3.5a/2011_11_21_05_pilgrim_tables.sql diff --git a/sql/updates/world/2011_11_24_00_world_version.sql b/sql/updates/world/2011_11_24_00_world_version.sql new file mode 100644 index 00000000000..ad2396f29e1 --- /dev/null +++ b/sql/updates/world/2011_11_24_00_world_version.sql @@ -0,0 +1 @@ +UPDATE `version` SET `db_version`='TDB 335.11.44' LIMIT 1; diff --git a/sql/updates/world/2011_11_25_00_world_quest_template.sql b/sql/updates/world/2011_11_25_00_world_quest_template.sql new file mode 100644 index 00000000000..eee92a3761b --- /dev/null +++ b/sql/updates/world/2011_11_25_00_world_quest_template.sql @@ -0,0 +1,38 @@ +ALTER TABLE `quest_template` ADD COLUMN `RequiredClasses` smallint(5) unsigned NOT NULL default '0' AFTER `Type`; + +UPDATE `quest_template` + SET `RequiredClasses` = `RequiredClasses`| + CASE `SkillOrClassMask` + WHEN -1 THEN 1 -- warrior + WHEN -2 THEN 2 -- paladin + WHEN -3 THEN 4 -- hunter + WHEN -4 THEN 8 -- rogue + WHEN -5 THEN 16 -- priest + WHEN -6 THEN 32 -- dk + WHEN -7 THEN 64 -- shaman + WHEN -8 THEN 128 -- mage + WHEN -9 THEN 256 -- warlock + WHEN -11 THEN 1024 -- druid + ELSE 0 + END + WHERE `SkillOrClassMask` < 0; + +UPDATE `quest_template` + SET `RequiredClasses` = `RequiredClasses`| + CASE `ZoneOrSort` + WHEN -81 THEN 1 -- warrior + WHEN -141 THEN 2 -- paladin + WHEN -261 THEN 4 -- hunter + WHEN -162 THEN 8 -- rogue + WHEN -262 THEN 16 -- priest + WHEN -372 THEN 32 -- dk + WHEN -82 THEN 64 -- shaman + WHEN -161 THEN 128 -- mage + WHEN -61 THEN 256 -- warlock + WHEN -263 THEN 1024 -- druid + ELSE 0 + END + WHERE `ZoneOrSort` < 0; + +UPDATE `quest_template` SET `SkillOrClassMask`=0 WHERE `SkillOrClassMask`<0; +ALTER TABLE `quest_template` CHANGE COLUMN `SkillOrClassMask` `RequiredSkill` smallint(5) unsigned NOT NULL default '0' AFTER `RequiredRaces`; diff --git a/sql/updates/world/2011_11_25_01_world_quest_template.sql b/sql/updates/world/2011_11_25_01_world_quest_template.sql new file mode 100644 index 00000000000..f7e4555f093 --- /dev/null +++ b/sql/updates/world/2011_11_25_01_world_quest_template.sql @@ -0,0 +1 @@ +UPDATE `quest_template` SET `RequiredClasses`=0 WHERE `entry`=8249; -- Junkboxes Needed diff --git a/sql/updates/world/2011_11_25_02_world_creature.sql b/sql/updates/world/2011_11_25_02_world_creature.sql new file mode 100644 index 00000000000..0b26187f196 --- /dev/null +++ b/sql/updates/world/2011_11_25_02_world_creature.sql @@ -0,0 +1,4 @@ +-- re-guid +DELETE FROM `creature` WHERE `guid`=1022681 OR (`guid`=48191 AND `id`=18069); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES +(48191, 18069, 530, 1, 1, 0, 0, -714.823, 7931.65, 58.8672, 4.3693, 300, 0, 0, 60720, 29330, 0, 0, 0, 0); diff --git a/sql/updates/world/2011_11_26_00_world_quest_template.sql b/sql/updates/world/2011_11_26_00_world_quest_template.sql new file mode 100644 index 00000000000..6a7834e0a76 --- /dev/null +++ b/sql/updates/world/2011_11_26_00_world_quest_template.sql @@ -0,0 +1,177 @@ +-- Naming +ALTER TABLE `quest_template` + CHANGE `entry` `Id` mediumint(8) UNSIGNED NOT NULL default '0', + CHANGE `QuestLevel` `Level` smallint(3) NOT NULL DEFAULT '1', + CHANGE `RequiredSkill` `RequiredSkillId` smallint(5) UNSIGNED NOT NULL DEFAULT '0', + CHANGE `RequiredSkillValue` `RequiredSkillPoints` smallint(5) UNSIGNED NOT NULL DEFAULT '0', + CHANGE `RepObjectiveFaction` `RequiredFactionId1` smallint(5) UNSIGNED NOT NULL DEFAULT '0', + CHANGE `RepObjectiveFaction2` `RequiredFactionId2` smallint(5) UNSIGNED NOT NULL DEFAULT '0', + CHANGE `RepObjectiveValue` `RequiredFactionValue1` mediumint(9) default '0' NOT NULL, + CHANGE `RepObjectiveValue2` `RequiredFactionValue2` mediumint(9) default '0' NOT NULL, + CHANGE `QuestFlags` `Flags` int(10) UNSIGNED default '0' NOT NULL, + CHANGE `SpecialFlags` `SpecialFlags` tinyint(3) UNSIGNED default '0' NOT NULL, + CHANGE `CharTitleId` `RewardTitleId` tinyint(3) UNSIGNED default '0' NOT NULL, + CHANGE `PlayersSlain` `RequiredPlayerKills` tinyint(3) UNSIGNED default '0' NOT NULL, + CHANGE `BonusTalents` `RewardTalents` tinyint(3) UNSIGNED default '0' NOT NULL, + CHANGE `RewardArenaPoints` `RewardArenaPoints` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `NextQuestInChain` `NextQuestIdChain` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewXPId` `RewardXPId` tinyint(2) UNSIGNED default '0' NOT NULL, + CHANGE `SrcItemId` `SourceItemId` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `SrcItemCount` `SourceItemCount` tinyint(3) UNSIGNED default '0' NOT NULL, + CHANGE `SrcSpell` `SourceSpellId` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqItemId1` `RequiredItemId1` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqItemId2` `RequiredItemId2` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqItemId3` `RequiredItemId3` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqItemId4` `RequiredItemId4` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqItemId5` `RequiredItemId5` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqItemId6` `RequiredItemId6` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqItemCount1` `RequiredItemCount1` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqItemCount2` `RequiredItemCount2` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqItemCount3` `RequiredItemCount3` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqItemCount4` `RequiredItemCount4` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqItemCount5` `RequiredItemCount5` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqItemCount6` `RequiredItemCount6` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqSourceId1` `RequiredSourceItemId1` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqSourceId2` `RequiredSourceItemId2` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqSourceId3` `RequiredSourceItemId3` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqSourceId4` `RequiredSourceItemId4` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqSourceCount1` `RequiredSourceItemCount1` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqSourceCount2` `RequiredSourceItemCount2` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqSourceCount3` `RequiredSourceItemCount3` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqSourceCount4` `RequiredSourceItemCount4` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqCreatureOrGOId1` `RequiredNpcOrGo1` mediumint(9) default '0' NOT NULL, + CHANGE `ReqCreatureOrGOId2` `RequiredNpcOrGo2` mediumint(9) default '0' NOT NULL, + CHANGE `ReqCreatureOrGOId3` `RequiredNpcOrGo3` mediumint(9) default '0' NOT NULL, + CHANGE `ReqCreatureOrGOId4` `RequiredNpcOrGo4` mediumint(9) default '0' NOT NULL, + CHANGE `ReqCreatureOrGOCount1` `RequiredNpcOrGoCount1` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqCreatureOrGOCount2` `RequiredNpcOrGoCount2` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqCreatureOrGOCount3` `RequiredNpcOrGoCount3` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqCreatureOrGOCount4` `RequiredNpcOrGoCount4` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `ReqSpellCast1` `RequiredSpellCast1` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqSpellCast2` `RequiredSpellCast2` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqSpellCast3` `RequiredSpellCast3` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `ReqSpellCast4` `RequiredSpellCast4` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewChoiceItemId1` `RewardChoiceItemId1` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewChoiceItemId2` `RewardChoiceItemId2` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewChoiceItemId3` `RewardChoiceItemId3` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewChoiceItemId4` `RewardChoiceItemId4` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewChoiceItemId5` `RewardChoiceItemId5` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewChoiceItemId6` `RewardChoiceItemId6` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewChoiceItemCount1` `RewardChoiceItemCount1` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `RewChoiceItemCount2` `RewardChoiceItemCount2` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `RewChoiceItemCount3` `RewardChoiceItemCount3` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `RewChoiceItemCount4` `RewardChoiceItemCount4` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `RewChoiceItemCount5` `RewardChoiceItemCount5` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `RewChoiceItemCount6` `RewardChoiceItemCount6` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `RewItemId1` `RewardItemId1` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewItemId2` `RewardItemId2` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewItemId3` `RewardItemId3` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewItemId4` `RewardItemId4` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewItemCount1` `RewardItemCount1` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `RewItemCount2` `RewardItemCount2` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `RewItemCount3` `RewardItemCount3` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `RewItemCount4` `RewardItemCount4` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `RewRepFaction1` `RewardFactionId1` smallint(5) UNSIGNED default '0' NOT NULL comment 'faction id from Faction.dbc in this case', + CHANGE `RewRepFaction2` `RewardFactionId2` smallint(5) UNSIGNED default '0' NOT NULL comment 'faction id from Faction.dbc in this case', + CHANGE `RewRepFaction3` `RewardFactionId3` smallint(5) UNSIGNED default '0' NOT NULL comment 'faction id from Faction.dbc in this case', + CHANGE `RewRepFaction4` `RewardFactionId4` smallint(5) UNSIGNED default '0' NOT NULL comment 'faction id from Faction.dbc in this case', + CHANGE `RewRepFaction5` `RewardFactionId5` smallint(5) UNSIGNED default '0' NOT NULL comment 'faction id from Faction.dbc in this case', + CHANGE `RewRepValueId1` `RewardFactionValueId1` mediumint(6) default '0' NOT NULL, + CHANGE `RewRepValueId2` `RewardFactionValueId2` mediumint(6) default '0' NOT NULL, + CHANGE `RewRepValueId3` `RewardFactionValueId3` mediumint(6) default '0' NOT NULL, + CHANGE `RewRepValueId4` `RewardFactionValueId4` mediumint(6) default '0' NOT NULL, + CHANGE `RewRepValueId5` `RewardFactionValueId5` mediumint(6) default '0' NOT NULL, + CHANGE `RewRepValue1` `RewardFactionValueIdOverride1` mediumint(9) default '0' NOT NULL, + CHANGE `RewRepValue2` `RewardFactionValueIdOverride2` mediumint(9) default '0' NOT NULL, + CHANGE `RewRepValue3` `RewardFactionValueIdOverride3` mediumint(9) default '0' NOT NULL, + CHANGE `RewRepValue4` `RewardFactionValueIdOverride4` mediumint(9) default '0' NOT NULL, + CHANGE `RewRepValue5` `RewardFactionValueIdOverride5` mediumint(9) default '0' NOT NULL, + CHANGE `RewHonorAddition` `RewardHonor` int(10) default '0' NOT NULL, + CHANGE `RewHonorMultiplier` `RewardHonorMultiplier` float default '1' NOT NULL, + CHANGE `RewOrReqMoney` `RewardOrRequiredMoney` int(11) default '0' NOT NULL, + CHANGE `RewMoneyMaxLevel` `RewardMoneyMaxLevel` int(10) UNSIGNED default '0' NOT NULL, + CHANGE `RewSpell` `RewardSpell` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewSpellCast` `RewardSpellCast` int(11) default '0' NOT NULL, + CHANGE `RewMailTemplateId` `RewardMailTemplateId` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `RewMailDelaySecs` `RewardMailDelay` int(11) UNSIGNED default '0' NOT NULL, + CHANGE `PointOpt` `PointOption` mediumint(8) UNSIGNED default '0' NOT NULL, + CHANGE `DetailsEmote1` `DetailsEmote1` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `IncompleteEmote` `EmoteOnIncomplete` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `CompleteEmote` `EmoteOnComplete` smallint(5) UNSIGNED default '0' NOT NULL, + CHANGE `unk0` `Unknown0` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0'; + +-- Order +ALTER TABLE `quest_template` CHANGE COLUMN `Level` `Level` SMALLINT(3) NOT NULL DEFAULT '1' AFTER `Method`, + CHANGE COLUMN `ZoneOrSort` `ZoneOrSort` SMALLINT(6) NOT NULL DEFAULT '0' AFTER `MaxLevel`, + CHANGE COLUMN `SuggestedPlayers` `SuggestedPlayers` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `Type`, + CHANGE COLUMN `LimitTime` `LimitTime` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `SuggestedPlayers`, + CHANGE COLUMN `RequiredFactionId2` `RequiredFactionId2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredFactionId1`, + CHANGE COLUMN `RequiredMaxRepFaction` `RequiredMaxRepFaction` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredMinRepFaction`, + CHANGE COLUMN `RewardOrRequiredMoney` `RewardOrRequiredMoney` INT(11) NOT NULL DEFAULT '0' AFTER `RewardXPId`, + CHANGE COLUMN `RewardMoneyMaxLevel` `RewardMoneyMaxLevel` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardOrRequiredMoney`, + CHANGE COLUMN `RewardSpell` `RewardSpell` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardMoneyMaxLevel`, + CHANGE COLUMN `RewardSpellCast` `RewardSpellCast` INT(11) NOT NULL DEFAULT '0' AFTER `RewardSpell`, + CHANGE COLUMN `RewardHonor` `RewardHonor` INT(10) NOT NULL DEFAULT '0' AFTER `RewardSpellCast`, + CHANGE COLUMN `RewardHonorMultiplier` `RewardHonorMultiplier` FLOAT NOT NULL DEFAULT '1' AFTER `RewardHonor`, + CHANGE COLUMN `RewardMailTemplateId` `RewardMailTemplateId` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardHonorMultiplier`, + CHANGE COLUMN `RewardMailDelay` `RewardMailDelay` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardMailTemplateId`, + CHANGE COLUMN `Flags` `Flags` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `SourceSpellId`, + CHANGE COLUMN `SpecialFlags` `SpecialFlags` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `Flags`, + CHANGE COLUMN `RewardTitleId` `RewardTitleId` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `SpecialFlags`, + CHANGE COLUMN `RequiredPlayerKills` `RequiredPlayerKills` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardTitleId`, + CHANGE COLUMN `RewardTalents` `RewardTalents` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredPlayerKills`, + CHANGE COLUMN `RewardArenaPoints` `RewardArenaPoints` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardTalents`, + CHANGE COLUMN `RewardItemId1` `RewardItemId1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardArenaPoints`, + CHANGE COLUMN `RewardItemId2` `RewardItemId2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemId1`, + CHANGE COLUMN `RewardItemId3` `RewardItemId3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemId2`, + CHANGE COLUMN `RewardItemId4` `RewardItemId4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemId3`, + CHANGE COLUMN `RewardItemCount1` `RewardItemCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemId4`, + CHANGE COLUMN `RewardItemCount2` `RewardItemCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemCount1`, + CHANGE COLUMN `RewardItemCount3` `RewardItemCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemCount2`, + CHANGE COLUMN `RewardItemCount4` `RewardItemCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemCount3`, + CHANGE COLUMN `Title` `Title` TEXT NULL DEFAULT NULL AFTER `PointOption`, + CHANGE COLUMN `Objectives` `Objectives` TEXT NULL DEFAULT NULL AFTER `Title`, + CHANGE COLUMN `Details` `Details` TEXT NULL DEFAULT NULL AFTER `Objectives`, + CHANGE COLUMN `EndText` `EndText` TEXT NULL DEFAULT NULL AFTER `Details`, + CHANGE COLUMN `OfferRewardText` `OfferRewardText` TEXT NULL DEFAULT NULL AFTER `EndText`, + CHANGE COLUMN `RequestItemsText` `RequestItemsText` TEXT NULL DEFAULT NULL AFTER `OfferRewardText`, + CHANGE COLUMN `CompletedText` `CompletedText` TEXT NULL DEFAULT NULL AFTER `RequestItemsText`, + CHANGE COLUMN `RequiredNpcOrGo1` `RequiredNpcOrGo1` MEDIUMINT(9) NOT NULL DEFAULT '0' AFTER `CompletedText`, + CHANGE COLUMN `RequiredNpcOrGo2` `RequiredNpcOrGo2` MEDIUMINT(9) NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGo1`, + CHANGE COLUMN `RequiredNpcOrGo3` `RequiredNpcOrGo3` MEDIUMINT(9) NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGo2`, + CHANGE COLUMN `RequiredNpcOrGo4` `RequiredNpcOrGo4` MEDIUMINT(9) NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGo3`, + CHANGE COLUMN `RequiredNpcOrGoCount1` `RequiredNpcOrGoCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGo4`, + CHANGE COLUMN `RequiredNpcOrGoCount2` `RequiredNpcOrGoCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGoCount1`, + CHANGE COLUMN `RequiredNpcOrGoCount3` `RequiredNpcOrGoCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGoCount2`, + CHANGE COLUMN `RequiredNpcOrGoCount4` `RequiredNpcOrGoCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGoCount3`, + CHANGE COLUMN `RequiredSourceItemId1` `RequiredSourceItemId1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGoCount4`, + CHANGE COLUMN `RequiredSourceItemId2` `RequiredSourceItemId2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemId1`, + CHANGE COLUMN `RequiredSourceItemId3` `RequiredSourceItemId3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemId2`, + CHANGE COLUMN `RequiredSourceItemId4` `RequiredSourceItemId4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemId3`, + CHANGE COLUMN `RequiredSourceItemCount1` `RequiredSourceItemCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemId4`, + CHANGE COLUMN `RequiredSourceItemCount2` `RequiredSourceItemCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemCount1`, + CHANGE COLUMN `RequiredSourceItemCount3` `RequiredSourceItemCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemCount2`, + CHANGE COLUMN `RequiredSourceItemCount4` `RequiredSourceItemCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemCount3`, + CHANGE COLUMN `RequiredItemId1` `RequiredItemId1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemCount4`, + CHANGE COLUMN `RequiredItemId2` `RequiredItemId2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemId1`, + CHANGE COLUMN `RequiredItemId3` `RequiredItemId3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemId2`, + CHANGE COLUMN `RequiredItemId4` `RequiredItemId4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemId3`, + CHANGE COLUMN `RequiredItemId5` `RequiredItemId5` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemId4`, + CHANGE COLUMN `RequiredItemId6` `RequiredItemId6` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemId5`, + CHANGE COLUMN `RequiredItemCount1` `RequiredItemCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemId6`, + CHANGE COLUMN `RequiredItemCount2` `RequiredItemCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemCount1`, + CHANGE COLUMN `RequiredItemCount3` `RequiredItemCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemCount2`, + CHANGE COLUMN `RequiredItemCount4` `RequiredItemCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemCount3`, + CHANGE COLUMN `RequiredItemCount5` `RequiredItemCount5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemCount4`, + CHANGE COLUMN `RequiredItemCount6` `RequiredItemCount6` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemCount5`, + CHANGE COLUMN `RequiredSpellCast1` `RequiredSpellCast1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemCount6`, + CHANGE COLUMN `RequiredSpellCast2` `RequiredSpellCast2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSpellCast1`, + CHANGE COLUMN `RequiredSpellCast3` `RequiredSpellCast3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSpellCast2`, + CHANGE COLUMN `RequiredSpellCast4` `RequiredSpellCast4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSpellCast3`, + CHANGE COLUMN `Unknown0` `Unknown0` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSpellCast4`, + CHANGE COLUMN `ObjectiveText1` `ObjectiveText1` TEXT NULL DEFAULT NULL AFTER `Unknown0`, + CHANGE COLUMN `ObjectiveText2` `ObjectiveText2` TEXT NULL DEFAULT NULL AFTER `ObjectiveText1`, + CHANGE COLUMN `ObjectiveText3` `ObjectiveText3` TEXT NULL DEFAULT NULL AFTER `ObjectiveText2`, + CHANGE COLUMN `ObjectiveText4` `ObjectiveText4` TEXT NULL DEFAULT NULL AFTER `ObjectiveText3`; + +-- Note: These two ALTER could have been merged into one diff --git a/sql/updates/world/2011_11_26_01_world_quest_template.sql b/sql/updates/world/2011_11_26_01_world_quest_template.sql new file mode 100644 index 00000000000..44548ec9981 --- /dev/null +++ b/sql/updates/world/2011_11_26_01_world_quest_template.sql @@ -0,0 +1 @@ +UPDATE `quest_template` SET `RequiredRaces`=0 WHERE `entry`=14171; |
