Clean up in sql\updates move all 3.0.9 sqls to the 3.0.9_old directory, add 3.1.3_old for all sqls before 5270, since this is the next update needed after applying TDB 0.0.5

--HG-- branch : trunk rename : sql/updates/3008_1437_TC1_world_scripts.sql => sql/updates/3.0.9_old/3008_1437_TC1_world_scripts.sql rename : sql/updates/3018_spell_linked_spell.sql => sql/updates/3.0.9_old/3018_spell_linked_spell.sql rename : sql/updates/3030_world_scripts.sql => sql/updates/3.0.9_old/3030_world_scripts.sql rename : sql/updates/3039_world_spell_linked_spell.sql => sql/updates/3.0.9_old/3039_world_spell_linked_spell.sql rename : sql/updates/3070_TC1_1463_world_scripts.sql => sql/updates/3.0.9_old/3070_TC1_1463_world_scripts.sql rename : sql/updates/3070_world_spell_proc_event.sql => sql/updates/3.0.9_old/3070_world_spell_proc_event.sql rename : sql/updates/3075_TC1_1465_world_scripts.sql => sql/updates/3.0.9_old/3075_TC1_1465_world_scripts.sql rename : sql/updates/3089_world_trinity_string.sql => sql/updates/3.0.9_old/3089_world_trinity_string.sql rename : sql/updates/3121_world_scripts.sql => sql/updates/3.0.9_old/3121_world_scripts.sql rename : sql/updates/3148_mangos_7776_01_world_npc_spellclick_spells.sql => sql/updates/3.0.9_old/3148_mangos_7776_01_world_npc_spellclick_spells.sql rename : sql/updates/3178_mangos_7777_01_world_spell_proc_event.sql => sql/updates/3.0.9_old/3178_mangos_7777_01_world_spell_proc_event.sql rename : sql/updates/3204_mangos_7796_01_world_command.sql => sql/updates/3.0.9_old/3204_mangos_7796_01_world_command.sql rename : sql/updates/3204_mangos_7796_02_world_trinity_string.sql => sql/updates/3.0.9_old/3204_mangos_7796_02_world_trinity_string.sql rename : sql/updates/3210_mangos_7802_01_characters_character_achievement.sql => sql/updates/3.0.9_old/3210_mangos_7802_01_characters_character_achievement.sql rename : sql/updates/3210_mangos_7802_02_characters_character_achievement_progress.sql => sql/updates/3.0.9_old/3210_mangos_7802_02_characters_character_achievement_progress.sql rename : sql/updates/3233_world_scripts_naxx.sql => sql/updates/3.0.9_old/3233_world_scripts_naxx.sql rename : sql/updates/3235_characters.sql => sql/updates/3.0.9_old/3235_characters.sql rename : sql/updates/3235_world.sql => sql/updates/3.0.9_old/3235_world.sql rename : sql/updates/3257_world_waypoint_data_converter.sql => sql/updates/3.0.9_old/3257_world_waypoint_data_converter.sql rename : sql/updates/3258_world_creature_addon_(waypoint).sql => sql/updates/3.0.9_old/3258_world_creature_addon_(waypoint).sql rename : sql/updates/3263_world_scripts_missing_in_full.sql => sql/updates/3.0.9_old/3263_world_scripts_missing_in_full.sql rename : sql/updates/3314_mangos_7823_01_world_item_template.sql => sql/updates/3.0.9_old/3314_mangos_7823_01_world_item_template.sql rename : sql/updates/3320_worldspell_enchant_proc_data.sql => sql/updates/3.0.9_old/3320_worldspell_enchant_proc_data.sql rename : sql/updates/3323_world_spell_proc_event.sql => sql/updates/3.0.9_old/3323_world_spell_proc_event.sql rename : sql/updates/3331_world_spell.sql => sql/updates/3.0.9_old/3331_world_spell.sql rename : sql/updates/3358_world_spell_bonus_data.sql => sql/updates/3.0.9_old/3358_world_spell_bonus_data.sql rename : sql/updates/3359_world_spell_linked_spell.sql => sql/updates/3.0.9_old/3359_world_spell_linked_spell.sql rename : sql/updates/3363_characters_characters.sql => sql/updates/3.0.9_old/3363_characters_characters.sql rename : sql/updates/3373_world_spell.sql => sql/updates/3.0.9_old/3373_world_spell.sql rename : sql/updates/3375_mangos_7839_01_world_trinity_string.sql => sql/updates/3.0.9_old/3375_mangos_7839_01_world_trinity_string.sql rename : sql/updates/3375_mangos_7839_02_world_command.sql => sql/updates/3.0.9_old/3375_mangos_7839_02_world_command.sql rename : sql/updates/3392_world_spell_proc_event.sql => sql/updates/3.0.9_old/3392_world_spell_proc_event.sql rename : sql/updates/3393_world_spell_proc_event.sql => sql/updates/3.0.9_old/3393_world_spell_proc_event.sql rename : sql/updates/3394_world_spell_bonus_data.sql => sql/updates/3.0.9_old/3394_world_spell_bonus_data.sql rename : sql/updates/3409_world_spell_proc_event.sql => sql/updates/3.0.9_old/3409_world_spell_proc_event.sql rename : sql/updates/3410_world_SD2_scripts.sql => sql/updates/3.0.9_old/3410_world_SD2_scripts.sql rename : sql/updates/3414_mangos_7850_01_world_command.sql => sql/updates/3.0.9_old/3414_mangos_7850_01_world_command.sql rename : sql/updates/3416_mangos_7855_01_world_pools.sql => sql/updates/3.0.9_old/3416_mangos_7855_01_world_pools.sql rename : sql/updates/3419_world_SD2_scripts.sql => sql/updates/3.0.9_old/3419_world_SD2_scripts.sql rename : sql/updates/3421_world_scripts.sql => sql/updates/3.0.9_old/3421_world_scripts.sql rename : sql/updates/3422_world_scripts.sql => sql/updates/3.0.9_old/3422_world_scripts.sql rename : sql/updates/3423_world_scripts.sql => sql/updates/3.0.9_old/3423_world_scripts.sql rename : sql/updates/3424_world_scripts.sql => sql/updates/3.0.9_old/3424_world_scripts.sql rename : sql/updates/3427_world_scripts_naxx.sql => sql/updates/3.0.9_old/3427_world_scripts_naxx.sql rename : sql/updates/3433_world.sql => sql/updates/3.0.9_old/3433_world.sql rename : sql/updates/3451_world_spell_proc_event.sql => sql/updates/3.0.9_old/3451_world_spell_proc_event.sql rename : sql/updates/3466_world_scripts_wintergrasp.sql => sql/updates/3.0.9_old/3466_world_scripts_wintergrasp.sql rename : sql/updates/3467_world_spellclick_dk.sql => sql/updates/3.0.9_old/3467_world_spellclick_dk.sql rename : sql/updates/3498_world_scripts.sql => sql/updates/3.0.9_old/3498_world_scripts.sql rename : sql/updates/3500_mangos_7879_01_world_spell_proc_event.sql => sql/updates/3.0.9_old/3500_mangos_7879_01_world_spell_proc_event.sql rename : sql/updates/3508_mangos_7886_01_world_petcreateinfo_spell.sql => sql/updates/3.0.9_old/3508_mangos_7886_01_world_petcreateinfo_spell.sql rename : sql/updates/3508_mangos_7887_01_characters_character_pet.sql => sql/updates/3.0.9_old/3508_mangos_7887_01_characters_character_pet.sql rename : sql/updates/3535_TC1_1509_world_scripts.sql => sql/updates/3.0.9_old/3535_TC1_1509_world_scripts.sql rename : sql/updates/3576_world_spell_script_target.sql => sql/updates/3.0.9_old/3576_world_spell_script_target.sql rename : sql/updates/3577_world_spell_target_position.sql => sql/updates/3.0.9_old/3577_world_spell_target_position.sql rename : sql/updates/3587_mangos_7893_01_world_command.sql => sql/updates/3.0.9_old/3587_mangos_7893_01_world_command.sql rename : sql/updates/3592_world_spell_dk.sql => sql/updates/3.0.9_old/3592_world_spell_dk.sql rename : sql/updates/3593_world_spellclick_dk.sql => sql/updates/3.0.9_old/3593_world_spellclick_dk.sql rename : sql/updates/3596_world_scripts.sql => sql/updates/3.0.9_old/3596_world_scripts.sql rename : sql/updates/3601_world.sql => sql/updates/3.0.9_old/3601_world.sql rename : sql/updates/3603_mangos_7896_01_world_creature_template.sql => sql/updates/3.0.9_old/3603_mangos_7896_01_world_creature_template.sql rename : sql/updates/3609_mangos_7902_01_world_pool_creature.sql => sql/updates/3.0.9_old/3609_mangos_7902_01_world_pool_creature.sql rename : sql/updates/3609_mangos_7902_02_world_pool_gameobject.sql => sql/updates/3.0.9_old/3609_mangos_7902_02_world_pool_gameobject.sql rename : sql/updates/3612_world_spell_dk.sql => sql/updates/3.0.9_old/3612_world_spell_dk.sql rename : sql/updates/3618_mangos_7903_01_characters_character_pet.sql => sql/updates/3.0.9_old/3618_mangos_7903_01_characters_character_pet.sql rename : sql/updates/3619_mangos_7904_01_world_creature_template.sql => sql/updates/3.0.9_old/3619_mangos_7904_01_world_creature_template.sql rename : sql/updates/3632_mangos_7908_world_creature_template.sql => sql/updates/3.0.9_old/3632_mangos_7908_world_creature_template.sql rename : sql/updates/3637_world_spell.sql => sql/updates/3.0.9_old/3637_world_spell.sql rename : sql/updates/3643_world_wintergrasp.sql => sql/updates/3.0.9_old/3643_world_wintergrasp.sql rename : sql/updates/3648_world_trinity_string_full.sql => sql/updates/3.0.9_old/3648_world_trinity_string_full.sql rename : sql/updates/3649_world.sql => sql/updates/3.0.9_old/3649_world.sql rename : sql/updates/3689_TC1_1534_world.sql => sql/updates/3.0.9_old/3689_TC1_1534_world.sql rename : sql/updates/3691_TC1_919_world.sql => sql/updates/3.0.9_old/3691_TC1_919_world.sql rename : sql/updates/3715_mangos_7932_01_characters_character_pet.sql => sql/updates/3.0.9_old/3715_mangos_7932_01_characters_character_pet.sql rename : sql/updates/3724_world.sql => sql/updates/3.0.9_old/3724_world.sql rename : sql/updates/3729_mangos_7938_01_realmd_account.sql => sql/updates/3.0.9_old/3729_mangos_7938_01_realmd_account.sql rename : sql/updates/3736_world_spell_dk.sql => sql/updates/3.0.9_old/3736_world_spell_dk.sql rename : sql/updates/3747_mangos_7945_01_quest_template.sql => sql/updates/3.0.9_old/3747_mangos_7945_01_quest_template.sql rename : sql/updates/3791_characters_ahbot.sql => sql/updates/3.0.9_old/3791_characters_ahbot.sql rename : sql/updates/3801_world_spell.sql => sql/updates/3.0.9_old/3801_world_spell.sql rename : sql/updates/3808_world.sql => sql/updates/3.0.9_old/3808_world.sql rename : sql/updates/3810_world_spell_bonus_data.sql => sql/updates/3.0.9_old/3810_world_spell_bonus_data.sql rename : sql/updates/3813_world_spell_dk.sql => sql/updates/3.0.9_old/3813_world_spell_dk.sql rename : sql/updates/3851_characters_aura.sql => sql/updates/3.0.9_old/3851_characters_aura.sql rename : sql/updates/3851_world_spell.sql => sql/updates/3.0.9_old/3851_world_spell.sql rename : sql/updates/3856_world_spell_naxx.sql => sql/updates/3.0.9_old/3856_world_spell_naxx.sql rename : sql/updates/3869_world_access_requirement.sql => sql/updates/3.0.9_old/3869_world_access_requirement.sql rename : sql/updates/3870_mangos_7980_01_world_item_required_target.sql => sql/updates/3.0.9_old/3870_mangos_7980_01_world_item_required_target.sql rename : sql/updates/3873_world_spell_dk.sql => sql/updates/3.0.9_old/3873_world_spell_dk.sql rename : sql/updates/3877_world_spell_script_target.sql => sql/updates/3.0.9_old/3877_world_spell_script_target.sql rename : sql/updates/3886_world_script_nexus.sql => sql/updates/3.0.9_old/3886_world_script_nexus.sql rename : sql/updates/3899_world_spell_proc_event.sql => sql/updates/3.0.9_old/3899_world_spell_proc_event.sql rename : sql/updates/3903_world_spell_proc_event.sql => sql/updates/3.0.9_old/3903_world_spell_proc_event.sql rename : sql/updates/3910_world.sql => sql/updates/3.0.9_old/3910_world.sql rename : sql/updates/3920_characters_309-313_converter.sql => sql/updates/3.1.3_old/3920_characters_309-313_converter.sql rename : sql/updates/3920_world_309-313_converter.sql => sql/updates/3.1.3_old/3920_world_309-313_converter.sql rename : sql/updates/3927_world_spell_proc_event.sql => sql/updates/3.1.3_old/3927_world_spell_proc_event.sql rename : sql/updates/3943_world_spell_proc_event.sql => sql/updates/3.1.3_old/3943_world_spell_proc_event.sql rename : sql/updates/3947_world_spell_proc_event.sql => sql/updates/3.1.3_old/3947_world_spell_proc_event.sql rename : sql/updates/3951_world_spell_proc_event.sql => sql/updates/3.1.3_old/3951_world_spell_proc_event.sql rename : sql/updates/3952_world_spell_pet_auras.sql => sql/updates/3.1.3_old/3952_world_spell_pet_auras.sql rename : sql/updates/3954_world_spell_bonus_data.sql => sql/updates/3.1.3_old/3954_world_spell_bonus_data.sql rename : sql/updates/3956_world_spell_proc_event.sql => sql/updates/3.1.3_old/3956_world_spell_proc_event.sql rename : sql/updates/3969_world_spell_proc_event.sql => sql/updates/3.1.3_old/3969_world_spell_proc_event.sql rename : sql/updates/3991_world_spell_proc_event.sql => sql/updates/3.1.3_old/3991_world_spell_proc_event.sql rename : sql/updates/3998_sd2.sql => sql/updates/3.1.3_old/3998_sd2.sql rename : sql/updates/3999_sd2.sql => sql/updates/3.1.3_old/3999_sd2.sql rename : sql/updates/4002_world_spell_proc_event.sql => sql/updates/3.1.3_old/4002_world_spell_proc_event.sql rename : sql/updates/4003_world_script_waypoint.sql => sql/updates/3.1.3_old/4003_world_script_waypoint.sql rename : sql/updates/4006_sd2.sql => sql/updates/3.1.3_old/4006_sd2.sql rename : sql/updates/4016_world_spell_dk.sql => sql/updates/3.1.3_old/4016_world_spell_dk.sql rename : sql/updates/4023_world_spell_proc_event.sql => sql/updates/3.1.3_old/4023_world_spell_proc_event.sql rename : sql/updates/4030_world.sql => sql/updates/3.1.3_old/4030_world.sql rename : sql/updates/4031_world_spell_proc_event.sql => sql/updates/3.1.3_old/4031_world_spell_proc_event.sql rename : sql/updates/4032_world_spell_proc_event.sql => sql/updates/3.1.3_old/4032_world_spell_proc_event.sql rename : sql/updates/4043_world_npc_spellclick_spells.sql => sql/updates/3.1.3_old/4043_world_npc_spellclick_spells.sql rename : sql/updates/4045_world_spell_proc_event.sql => sql/updates/3.1.3_old/4045_world_spell_proc_event.sql rename : sql/updates/4063_TC1_1569_world_scripts.sql => sql/updates/3.1.3_old/4063_TC1_1569_world_scripts.sql rename : sql/updates/4066_world_spell_proc_event.sql => sql/updates/3.1.3_old/4066_world_spell_proc_event.sql rename : sql/updates/4081_world.sql => sql/updates/3.1.3_old/4081_world.sql rename : sql/updates/4105_8030_01_characters_character_spell.sql => sql/updates/3.1.3_old/4105_8030_01_characters_character_spell.sql rename : sql/updates/4105_8030_02_characters_character_action.sql => sql/updates/3.1.3_old/4105_8030_02_characters_character_action.sql rename : sql/updates/4105_8030_03_mangos_npc_trainer.sql => sql/updates/3.1.3_old/4105_8030_03_mangos_npc_trainer.sql rename : sql/updates/4115_world_sd2.sql => sql/updates/3.1.3_old/4115_world_sd2.sql rename : sql/updates/4154_world_script.sql => sql/updates/3.1.3_old/4154_world_script.sql rename : sql/updates/4159_world.sql => sql/updates/3.1.3_old/4159_world.sql rename : sql/updates/4174_world_script.sql => sql/updates/3.1.3_old/4174_world_script.sql rename : sql/updates/4176_world.sql => sql/updates/3.1.3_old/4176_world.sql rename : sql/updates/4209_characters_TDB.sql => sql/updates/3.1.3_old/4209_characters_TDB.sql rename : sql/updates/4209_world_TDB.sql => sql/updates/3.1.3_old/4209_world_TDB.sql rename : sql/updates/4211_world.sql => sql/updates/3.1.3_old/4211_world.sql rename : sql/updates/4216_world.sql => sql/updates/3.1.3_old/4216_world.sql rename : sql/updates/4217_world_spell_proc_event.sql => sql/updates/3.1.3_old/4217_world_spell_proc_event.sql rename : sql/updates/4222_world.sql => sql/updates/3.1.3_old/4222_world.sql rename : sql/updates/4225_world.sql => sql/updates/3.1.3_old/4225_world.sql rename : sql/updates/4233_world_spell_proc_event.sql => sql/updates/3.1.3_old/4233_world_spell_proc_event.sql rename : sql/updates/4234_world_spell_bonus_data_TDB.sql => sql/updates/3.1.3_old/4234_world_spell_bonus_data_TDB.sql rename : sql/updates/4246_world_script.sql => sql/updates/3.1.3_old/4246_world_script.sql rename : sql/updates/4258_world_TDB.sql => sql/updates/3.1.3_old/4258_world_TDB.sql rename : sql/updates/4276_world_TDB.sql => sql/updates/3.1.3_old/4276_world_TDB.sql rename : sql/updates/4283_world_TDB.sql => sql/updates/3.1.3_old/4283_world_TDB.sql rename : sql/updates/4292_8072_01_characters_characters.sql => sql/updates/3.1.3_old/4292_8072_01_characters_characters.sql rename : sql/updates/4292_8072_02_characters_characters.sql => sql/updates/3.1.3_old/4292_8072_02_characters_characters.sql rename : sql/updates/4307_world_TDB.sql => sql/updates/3.1.3_old/4307_world_TDB.sql rename : sql/updates/4308_world_TDB.sql => sql/updates/3.1.3_old/4308_world_TDB.sql rename : sql/updates/4320_world_.sql => sql/updates/3.1.3_old/4320_world_.sql rename : sql/updates/4321_world.sql => sql/updates/3.1.3_old/4321_world.sql rename : sql/updates/4346_8098_characters.sql => sql/updates/3.1.3_old/4346_8098_characters.sql rename : sql/updates/4346_8098_world.sql => sql/updates/3.1.3_old/4346_8098_world.sql rename : sql/updates/4351_8104_01_characters.sql => sql/updates/3.1.3_old/4351_8104_01_characters.sql rename : sql/updates/4352_spell_bonus_data_full.sql => sql/updates/3.1.3_old/4352_spell_bonus_data_full.sql rename : sql/updates/4356_world_spell_proc_event.sql => sql/updates/3.1.3_old/4356_world_spell_proc_event.sql rename : sql/updates/4360_world_spell_proc_event.sql => sql/updates/3.1.3_old/4360_world_spell_proc_event.sql rename : sql/updates/4363_world_trinity_string.sql => sql/updates/3.1.3_old/4363_world_trinity_string.sql rename : sql/updates/4367_world_spell_proc_event.sql => sql/updates/3.1.3_old/4367_world_spell_proc_event.sql rename : sql/updates/4371_world_spell_linked_spell.sql => sql/updates/3.1.3_old/4371_world_spell_linked_spell.sql rename : sql/updates/4377_world_spell_proc_event.sql => sql/updates/3.1.3_old/4377_world_spell_proc_event.sql rename : sql/updates/4382_8115_world_playercreateinfo_action.sql => sql/updates/3.1.3_old/4382_8115_world_playercreateinfo_action.sql rename : sql/updates/4392_world.sql => sql/updates/3.1.3_old/4392_world.sql rename : sql/updates/4393_world_spell_proc_event.sql => sql/updates/3.1.3_old/4393_world_spell_proc_event.sql rename : sql/updates/4394_world_spell_proc_event.sql => sql/updates/3.1.3_old/4394_world_spell_proc_event.sql rename : sql/updates/4397_world_playercreateinfo_spell_TDB.sql => sql/updates/3.1.3_old/4397_world_playercreateinfo_spell_TDB.sql rename : sql/updates/4401_world_spell_proc_event.sql => sql/updates/3.1.3_old/4401_world_spell_proc_event.sql rename : sql/updates/4408_world_spell_proc_event.sql => sql/updates/3.1.3_old/4408_world_spell_proc_event.sql rename : sql/updates/4409_world_spell_proc_event.sql => sql/updates/3.1.3_old/4409_world_spell_proc_event.sql rename : sql/updates/4411_world_spell_bonus_data_TDB.sql => sql/updates/3.1.3_old/4411_world_spell_bonus_data_TDB.sql rename : sql/updates/4422_world_script.sql => sql/updates/3.1.3_old/4422_world_script.sql rename : sql/updates/4423_world.sql => sql/updates/3.1.3_old/4423_world.sql rename : sql/updates/4426_world.sql => sql/updates/3.1.3_old/4426_world.sql rename : sql/updates/4428_world_spell_proc_event.sql => sql/updates/3.1.3_old/4428_world_spell_proc_event.sql rename : sql/updates/4429_world_spell_proc_event.sql => sql/updates/3.1.3_old/4429_world_spell_proc_event.sql rename : sql/updates/4431_world_trinity_string.sql => sql/updates/3.1.3_old/4431_world_trinity_string.sql rename : sql/updates/4432_world.sql => sql/updates/3.1.3_old/4432_world.sql rename : sql/updates/4445_8158_world_playercreateinfo_action.sql => sql/updates/3.1.3_old/4445_8158_world_playercreateinfo_action.sql rename : sql/updates/4451_world_tmp.sql => sql/updates/3.1.3_old/4451_world_tmp.sql rename : sql/updates/4464_world_spell_bonus_data_TDB.sql => sql/updates/3.1.3_old/4464_world_spell_bonus_data_TDB.sql rename : sql/updates/4481_world_script.sql => sql/updates/3.1.3_old/4481_world_script.sql rename : sql/updates/4490_world_spell_proc_event.sql => sql/updates/3.1.3_old/4490_world_spell_proc_event.sql rename : sql/updates/4495_world_script.sql => sql/updates/3.1.3_old/4495_world_script.sql rename : sql/updates/4498_characters_channels.sql => sql/updates/3.1.3_old/4498_characters_channels.sql rename : sql/updates/4500_world_spell_bonus_data.sql => sql/updates/3.1.3_old/4500_world_spell_bonus_data.sql rename : sql/updates/4501_world_spell_bonus_data.sql => sql/updates/3.1.3_old/4501_world_spell_bonus_data.sql rename : sql/updates/4509_world_spell_linked_spell.sql => sql/updates/3.1.3_old/4509_world_spell_linked_spell.sql rename : sql/updates/4510_world_spell_linked_spell.sql => sql/updates/3.1.3_old/4510_world_spell_linked_spell.sql rename : sql/updates/4520_8190_world_creature_template.sql => sql/updates/3.1.3_old/4520_8190_world_creature_template.sql rename : sql/updates/4524_world_spell_elixir.sql => sql/updates/3.1.3_old/4524_world_spell_elixir.sql rename : sql/updates/4530_world_spell_script_target.sql => sql/updates/3.1.3_old/4530_world_spell_script_target.sql rename : sql/updates/4536_world_spell_proc_event.sql => sql/updates/3.1.3_old/4536_world_spell_proc_event.sql rename : sql/updates/4539_world_spell_linked_spell.sql => sql/updates/3.1.3_old/4539_world_spell_linked_spell.sql rename : sql/updates/4542_8191_world_spell_affect.sql => sql/updates/3.1.3_old/4542_8191_world_spell_affect.sql rename : sql/updates/4544_world.sql => sql/updates/3.1.3_old/4544_world.sql rename : sql/updates/4547_world_scripts.sql => sql/updates/3.1.3_old/4547_world_scripts.sql rename : sql/updates/4549_world_script.sql => sql/updates/3.1.3_old/4549_world_script.sql rename : sql/updates/4572_script_texts.sql => sql/updates/3.1.3_old/4572_script_texts.sql rename : sql/updates/4572_world_script.sql => sql/updates/3.1.3_old/4572_world_script.sql rename : sql/updates/4577_world_scripts.sql => sql/updates/3.1.3_old/4577_world_scripts.sql rename : sql/updates/4583_world_command.sql => sql/updates/3.1.3_old/4583_world_command.sql rename : sql/updates/4594_world_scripts.sql => sql/updates/3.1.3_old/4594_world_scripts.sql rename : sql/updates/4597_world_command.sql => sql/updates/3.1.3_old/4597_world_command.sql rename : sql/updates/4598_world_spell_bonus_data.sql => sql/updates/3.1.3_old/4598_world_spell_bonus_data.sql rename : sql/updates/4601_world_spell_proc_event.sql => sql/updates/3.1.3_old/4601_world_spell_proc_event.sql rename : sql/updates/4602_world_spell_bonus_data.sql => sql/updates/3.1.3_old/4602_world_spell_bonus_data.sql rename : sql/updates/4603_world_tmp.sql => sql/updates/3.1.3_old/4603_world_tmp.sql rename : sql/updates/4610_world.sql => sql/updates/3.1.3_old/4610_world.sql rename : sql/updates/4610_world_scripts.sql => sql/updates/3.1.3_old/4610_world_scripts.sql rename : sql/updates/4615_world.sql => sql/updates/3.1.3_old/4615_world.sql rename : sql/updates/4643_world_8237_creature_template.sql => sql/updates/3.1.3_old/4643_world_8237_creature_template.sql rename : sql/updates/4649_world_8250_spell_threat.sql => sql/updates/3.1.3_old/4649_world_8250_spell_threat.sql rename : sql/updates/4663_world.sql => sql/updates/3.1.3_old/4663_world.sql rename : sql/updates/4696_world_spell_proc_event.sql => sql/updates/3.1.3_old/4696_world_spell_proc_event.sql rename : sql/updates/4697_world_spell_proc_event.sql => sql/updates/3.1.3_old/4697_world_spell_proc_event.sql rename : sql/updates/4705_world_trinity_string.sql => sql/updates/3.1.3_old/4705_world_trinity_string.sql rename : sql/updates/4725_world_scripts.sql => sql/updates/3.1.3_old/4725_world_scripts.sql rename : sql/updates/4737_world_TDB.sql => sql/updates/3.1.3_old/4737_world_TDB.sql rename : sql/updates/4738_world_spell_proc_event.sql => sql/updates/3.1.3_old/4738_world_spell_proc_event.sql rename : sql/updates/4741_world.sql => sql/updates/3.1.3_old/4741_world.sql rename : sql/updates/4742_world_spell_bonus_data.sql => sql/updates/3.1.3_old/4742_world_spell_bonus_data.sql rename : sql/updates/4742_world_spell_proc_event.sql => sql/updates/3.1.3_old/4742_world_spell_proc_event.sql rename : sql/updates/4745_world_access_requirement.sql => sql/updates/3.1.3_old/4745_world_access_requirement.sql rename : sql/updates/4748_world.sql => sql/updates/3.1.3_old/4748_world.sql rename : sql/updates/4751_world_scripts.sql => sql/updates/3.1.3_old/4751_world_scripts.sql rename : sql/updates/4753_world.sql => sql/updates/3.1.3_old/4753_world.sql rename : sql/updates/4755_world_scripts.sql => sql/updates/3.1.3_old/4755_world_scripts.sql rename : sql/updates/4756_world.sql => sql/updates/3.1.3_old/4756_world.sql rename : sql/updates/4759_world.sql => sql/updates/3.1.3_old/4759_world.sql rename : sql/updates/4761_world.sql => sql/updates/3.1.3_old/4761_world.sql rename : sql/updates/4762_8294_01_mangos_playercreateinfo_action.sql => sql/updates/3.1.3_old/4762_8294_01_mangos_playercreateinfo_action.sql rename : sql/updates/4783_world_scripts.sql => sql/updates/3.1.3_old/4783_world_scripts.sql rename : sql/updates/4787_script_texts.sql => sql/updates/3.1.3_old/4787_script_texts.sql rename : sql/updates/4793_world_scripts.sql => sql/updates/3.1.3_old/4793_world_scripts.sql rename : sql/updates/4795_world_scripts_converter.sql => sql/updates/3.1.3_old/4795_world_scripts_converter.sql rename : sql/updates/4803_script_texts.sql => sql/updates/3.1.3_old/4803_script_texts.sql rename : sql/updates/4806_script_texts.sql => sql/updates/3.1.3_old/4806_script_texts.sql rename : sql/updates/4807_script_texts.sql => sql/updates/3.1.3_old/4807_script_texts.sql rename : sql/updates/4831_script_texts.sql => sql/updates/3.1.3_old/4831_script_texts.sql rename : sql/updates/4836_world_announce.sql => sql/updates/3.1.3_old/4836_world_announce.sql rename : sql/updates/4841_world_scripts.sql => sql/updates/3.1.3_old/4841_world_scripts.sql rename : sql/updates/4854_world_scripts.sql => sql/updates/3.1.3_old/4854_world_scripts.sql rename : sql/updates/4859_8332_01_realmd_realmcharacters.sql => sql/updates/3.1.3_old/4859_8332_01_realmd_realmcharacters.sql rename : sql/updates/4862_world_linked_spell.sql => sql/updates/3.1.3_old/4862_world_linked_spell.sql rename : sql/updates/4868_world_scripts.sql => sql/updates/3.1.3_old/4868_world_scripts.sql rename : sql/updates/4869_world_command.sql => sql/updates/3.1.3_old/4869_world_command.sql rename : sql/updates/4872_world_scripts.sql => sql/updates/3.1.3_old/4872_world_scripts.sql rename : sql/updates/4875_world_scripts.sql => sql/updates/3.1.3_old/4875_world_scripts.sql rename : sql/updates/4877_world_scripts.sql => sql/updates/3.1.3_old/4877_world_scripts.sql rename : sql/updates/4879_world_script_texts.sql => sql/updates/3.1.3_old/4879_world_script_texts.sql rename : sql/updates/4882_world_scripts.sql => sql/updates/3.1.3_old/4882_world_scripts.sql rename : sql/updates/4888_world_scripts.sql => sql/updates/3.1.3_old/4888_world_scripts.sql rename : sql/updates/4892_world_script.sql => sql/updates/3.1.3_old/4892_world_script.sql rename : sql/updates/4906_world_scripts.sql => sql/updates/3.1.3_old/4906_world_scripts.sql rename : sql/updates/4911_world_scripts.sql => sql/updates/3.1.3_old/4911_world_scripts.sql rename : sql/updates/4923_world_scripts.sql => sql/updates/3.1.3_old/4923_world_scripts.sql rename : sql/updates/4927_world_scripts_naxx.sql => sql/updates/3.1.3_old/4927_world_scripts_naxx.sql rename : sql/updates/4938_world.sql => sql/updates/3.1.3_old/4938_world.sql rename : sql/updates/4939_world_scripts.sql => sql/updates/3.1.3_old/4939_world_scripts.sql rename : sql/updates/4944_world.sql => sql/updates/3.1.3_old/4944_world.sql rename : sql/updates/4945_mangos_8339_characters.sql => sql/updates/3.1.3_old/4945_mangos_8339_characters.sql rename : sql/updates/4959_world.sql => sql/updates/3.1.3_old/4959_world.sql rename : sql/updates/4968_world_8361_spell_bonus_data.sql => sql/updates/3.1.3_old/4968_world_8361_spell_bonus_data.sql rename : sql/updates/4972_world_scripts.sql => sql/updates/3.1.3_old/4972_world_scripts.sql rename : sql/updates/4982_world_spell_area.sql => sql/updates/3.1.3_old/4982_world_spell_area.sql rename : sql/updates/4994_world_script.sql => sql/updates/3.1.3_old/4994_world_script.sql rename : sql/updates/4996_script_texts.sql => sql/updates/3.1.3_old/4996_script_texts.sql rename : sql/updates/4999_world_scripts.sql => sql/updates/3.1.3_old/4999_world_scripts.sql rename : sql/updates/5001_world_scripts.sql => sql/updates/3.1.3_old/5001_world_scripts.sql rename : sql/updates/5006_world.sql => sql/updates/3.1.3_old/5006_world.sql rename : sql/updates/5009_world.sql => sql/updates/3.1.3_old/5009_world.sql rename : sql/updates/5009_world_TDB.sql => sql/updates/3.1.3_old/5009_world_TDB.sql rename : sql/updates/5009_world_scripts.sql => sql/updates/3.1.3_old/5009_world_scripts.sql rename : sql/updates/5012_world_scripts.sql => sql/updates/3.1.3_old/5012_world_scripts.sql rename : sql/updates/5015_world_scripts.sql => sql/updates/3.1.3_old/5015_world_scripts.sql rename : sql/updates/5016_world_scripts.sql => sql/updates/3.1.3_old/5016_world_scripts.sql rename : sql/updates/5020_world_scripts.sql => sql/updates/3.1.3_old/5020_world_scripts.sql rename : sql/updates/5021_8364_world_db_version.sql => sql/updates/3.1.3_old/5021_8364_world_db_version.sql rename : sql/updates/5023_world_scripts.sql => sql/updates/3.1.3_old/5023_world_scripts.sql rename : sql/updates/5029_world_trinity_string.sql => sql/updates/3.1.3_old/5029_world_trinity_string.sql rename : sql/updates/5031_world_scripts_netherspite.sql => sql/updates/3.1.3_old/5031_world_scripts_netherspite.sql rename : sql/updates/5036_character_updates_dual_spec.sql => sql/updates/3.1.3_old/5036_character_updates_dual_spec.sql rename : sql/updates/5036_world_updates_dual_spec.sql => sql/updates/3.1.3_old/5036_world_updates_dual_spec.sql rename : sql/updates/5071_world_scripts.sql => sql/updates/3.1.3_old/5071_world_scripts.sql rename : sql/updates/5083_world_scripts_dk.sql => sql/updates/3.1.3_old/5083_world_scripts_dk.sql rename : sql/updates/5092_world_scripts.sql => sql/updates/3.1.3_old/5092_world_scripts.sql rename : sql/updates/5093_world_spell_proc_event.sql => sql/updates/3.1.3_old/5093_world_spell_proc_event.sql rename : sql/updates/5096_world_scripts.sql => sql/updates/3.1.3_old/5096_world_scripts.sql rename : sql/updates/5097_character_updates_dual_spec.sql => sql/updates/3.1.3_old/5097_character_updates_dual_spec.sql rename : sql/updates/5097_world_scripts.sql => sql/updates/3.1.3_old/5097_world_scripts.sql rename : sql/updates/5105_world_scripts.sql => sql/updates/3.1.3_old/5105_world_scripts.sql rename : sql/updates/5111_world_scripts.sql => sql/updates/3.1.3_old/5111_world_scripts.sql rename : sql/updates/5117_world_npc_option.sql => sql/updates/3.1.3_old/5117_world_npc_option.sql rename : sql/updates/5118_world_scripts.sql => sql/updates/3.1.3_old/5118_world_scripts.sql rename : sql/updates/5119_world.sql => sql/updates/3.1.3_old/5119_world.sql rename : sql/updates/5126_world_spell_proc_event.sql => sql/updates/3.1.3_old/5126_world_spell_proc_event.sql rename : sql/updates/5131_world_scripts_dk.sql => sql/updates/3.1.3_old/5131_world_scripts_dk.sql rename : sql/updates/5136_world_scripts_dk.sql => sql/updates/3.1.3_old/5136_world_scripts_dk.sql rename : sql/updates/5144_world_TDB.sql => sql/updates/3.1.3_old/5144_world_TDB.sql rename : sql/updates/5152_world_scripts_dk.sql => sql/updates/3.1.3_old/5152_world_scripts_dk.sql rename : sql/updates/5153_world_spell_proc_event.sql => sql/updates/3.1.3_old/5153_world_spell_proc_event.sql rename : sql/updates/5155_world_scripts_dk.sql => sql/updates/3.1.3_old/5155_world_scripts_dk.sql rename : sql/updates/5159_characters_channels.sql => sql/updates/3.1.3_old/5159_characters_channels.sql rename : sql/updates/5169_world_spell_linked_spell.sql => sql/updates/3.1.3_old/5169_world_spell_linked_spell.sql rename : sql/updates/5175_world_scripts_dk.sql => sql/updates/3.1.3_old/5175_world_scripts_dk.sql rename : sql/updates/5177_characters.sql => sql/updates/3.1.3_old/5177_characters.sql rename : sql/updates/5185_world_scripts_dk.sql => sql/updates/3.1.3_old/5185_world_scripts_dk.sql rename : sql/updates/5188_world_scripts.sql => sql/updates/3.1.3_old/5188_world_scripts.sql rename : sql/updates/5189_character_updates_dual_spec.sql => sql/updates/3.1.3_old/5189_character_updates_dual_spec.sql rename : sql/updates/5216_world_scripts.sql => sql/updates/3.1.3_old/5216_world_scripts.sql rename : sql/updates/5217_world_scripts.sql => sql/updates/3.1.3_old/5217_world_scripts.sql rename : sql/updates/5230_world_TDB.sql => sql/updates/3.1.3_old/5230_world_TDB.sql rename : sql/updates/5230_world_scripts.sql => sql/updates/3.1.3_old/5230_world_scripts.sql rename : sql/updates/5234_world_scripts.sql => sql/updates/3.1.3_old/5234_world_scripts.sql rename : sql/updates/5237_world_scripts.sql => sql/updates/3.1.3_old/5237_world_scripts.sql rename : sql/updates/5246_world_scripts.sql => sql/updates/3.1.3_old/5246_world_scripts.sql rename : sql/updates/5254_world_scripts.sql => sql/updates/3.1.3_old/5254_world_scripts.sql
author: Chaz Brown <iamparadox@netscape.net> 2009-09-03 09:21:28 -0400
committer: Chaz Brown <iamparadox@netscape.net> 2009-09-03 09:21:28 -0400
commit: f205d9734af2185efad536fa8c4fdb7faa0bb41e (patch)
tree: 4f6d8728e10488d112399f14a3824b22857fb888 /sql/updates/3.0.9_old
parent: 587f6377f26bd7a0515848632cd8882c456c358f (diff)
94 files changed, 1920 insertions, 0 deletions
diff --git a/sql/updates/3.0.9_old/3008_1437_TC1_world_scripts.sql b/sql/updates/3.0.9_old/3008_1437_TC1_world_scripts.sql
new file mode 100644
index 00000000000..0eacd5240ee
--- /dev/null
+++ b/sql/updates/3.0.9_old/3008_1437_TC1_world_scripts.sql
@@ -0,0 +1 @@
+UPDATE `gameobject_template` SET `ScriptName`='go_ethereum_prison' WHERE `entry` IN (184418,184419,184420,184421,184422,184423,184424,184425,184426,184427,184428,184429,184430,184431);
diff --git a/sql/updates/3.0.9_old/3018_spell_linked_spell.sql b/sql/updates/3.0.9_old/3018_spell_linked_spell.sql
new file mode 100644
index 00000000000..f1d928192bc
--- /dev/null
+++ b/sql/updates/3.0.9_old/3018_spell_linked_spell.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 38528;
+
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+( 38528,-31984, 2, 'Protection of Elune - Finger of Death'),
+( 38528,-32111, 2, 'Protection of Elune - Finger of Death');
diff --git a/sql/updates/3.0.9_old/3030_world_scripts.sql b/sql/updates/3.0.9_old/3030_world_scripts.sql
new file mode 100644
index 00000000000..a0a4d9a5775
--- /dev/null
+++ b/sql/updates/3.0.9_old/3030_world_scripts.sql
@@ -0,0 +1,3 @@
+UPDATE `creature_template` SET `ScriptName`='npc_unworthy_initiate' WHERE `entry` IN (29519,29520,29565,29566,29567);
+UPDATE `creature_template` SET `ScriptName`='npc_unworthy_initiate_anchor' WHERE `entry`=29521;
+UPDATE `gameobject_template` SET `ScriptName`='go_acherus_soul_prison' WHERE `entry` IN (191577,191580,191581,191582,191583,191584,191585,191586,191587,191588,191589,191590);
diff --git a/sql/updates/3.0.9_old/3039_world_spell_linked_spell.sql b/sql/updates/3.0.9_old/3039_world_spell_linked_spell.sql
new file mode 100644
index 00000000000..1cf6cf51afe
--- /dev/null
+++ b/sql/updates/3.0.9_old/3039_world_spell_linked_spell.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 38528 AND `spell_effect` = -32124;
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+(38528, -32124, 2, 'Protection of Elune - Denouement Wisp');
diff --git a/sql/updates/3.0.9_old/3070_TC1_1463_world_scripts.sql b/sql/updates/3.0.9_old/3070_TC1_1463_world_scripts.sql
new file mode 100644
index 00000000000..de973cc5023
--- /dev/null
+++ b/sql/updates/3.0.9_old/3070_TC1_1463_world_scripts.sql
@@ -0,0 +1,10 @@
+UPDATE `instance_template` SET `script` = 'instance_blackrock_depths' WHERE `map` = 230;
+UPDATE `creature_template` SET `ScriptName` = 'mob_voidtraveler' WHERE `entry` = 19226;
+UPDATE `creature_template` SET `ScriptName` = 'mob_shadowy_construct' WHERE `entry` = 23111;
+UPDATE `creature_template` SET `ScriptName` = 'mob_phalanx' WHERE `entry` = 9502;
+UPDATE `creature_template` SET `ScriptName` = 'npc_draenei_survivor' WHERE `entry` = 16483;
+UPDATE `creature_template` SET `ScriptName` = 'mob_inner_demon' WHERE entry = 21857;
+UPDATE `creature_template` SET `ScriptName` = 'mob_webwrap' WHERE `entry` = 16486;
+UPDATE `creature_template` SET `ScriptName` = 'mob_dragonmaw_peon' WHERE `entry` = 22252;
+UPDATE `creature_template` SET `ScriptName` = 'npc_karynaku' WHERE `entry` = 22112;
+UPDATE `creature_template` SET `ScriptName` = 'mob_ohgan' WHERE `entry` = 14988;
diff --git a/sql/updates/3.0.9_old/3070_world_spell_proc_event.sql b/sql/updates/3.0.9_old/3070_world_spell_proc_event.sql
new file mode 100644
index 00000000000..c382b00429c
--- /dev/null
+++ b/sql/updates/3.0.9_old/3070_world_spell_proc_event.sql
@@ -0,0 +1,15 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (20166, 32385, 32392, 32387, 32393, 32394,
+ 13046, 13045, 12317, 13048, 13047, -- Enrage
+ 29724, 29725, 29723); -- Sudden Death
+ 
+-- Seal of wisdom
+INSERT INTO `spell_proc_event` VALUES
+(20166, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 12.000000, 0.000000, 0);
+
+-- Shadow embrace
+INSERT INTO `spell_proc_event` VALUES
+(32385, 0x00, 5, 0x00000001, 0x00040000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0),
+(32387, 0x00, 5, 0x00000001, 0x00040000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0),
+(32392, 0x00, 5, 0x00000001, 0x00040000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0),
+(32393, 0x00, 5, 0x00000001, 0x00040000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0),
+(32394, 0x00, 5, 0x00000001, 0x00040000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);
diff --git a/sql/updates/3.0.9_old/3075_TC1_1465_world_scripts.sql b/sql/updates/3.0.9_old/3075_TC1_1465_world_scripts.sql
new file mode 100644
index 00000000000..ca1d88f5b5c
--- /dev/null
+++ b/sql/updates/3.0.9_old/3075_TC1_1465_world_scripts.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `ScriptName` = 'mob_fiendish_imp' WHERE `entry` = 17267;
diff --git a/sql/updates/3.0.9_old/3089_world_trinity_string.sql b/sql/updates/3.0.9_old/3089_world_trinity_string.sql
new file mode 100644
index 00000000000..7c9862edee0
--- /dev/null
+++ b/sql/updates/3.0.9_old/3089_world_trinity_string.sql
@@ -0,0 +1,3 @@
+DELETE FROM `trinity_string` WHERE `entry` IN (101);
+INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES
+(101, 'Map: %u (%s) Zone: %u (%s) Area: %u (%s) Phase: %u\nX: %f Y: %f Z: %f Orientation: %f\ngrid[%u,%u]cell[%u,%u] InstanceID: %u\n ZoneX: %f ZoneY: %f\nGroundZ: %f FloorZ: %f Have height data (Map: %u VMap: %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
diff --git a/sql/updates/3.0.9_old/3121_world_scripts.sql b/sql/updates/3.0.9_old/3121_world_scripts.sql
new file mode 100644
index 00000000000..23e5adaf191
--- /dev/null
+++ b/sql/updates/3.0.9_old/3121_world_scripts.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `ScriptName`='npc_dragonflayer_forge_master' WHERE `entry` =24079;
diff --git a/sql/updates/3.0.9_old/3148_mangos_7776_01_world_npc_spellclick_spells.sql b/sql/updates/3.0.9_old/3148_mangos_7776_01_world_npc_spellclick_spells.sql
new file mode 100644
index 00000000000..eff8fd57901
--- /dev/null
+++ b/sql/updates/3.0.9_old/3148_mangos_7776_01_world_npc_spellclick_spells.sql
@@ -0,0 +1,8 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7720_01_mangos_mangos_string required_7776_01_mangos_npc_spellclick_spells bit;*/
+
+CREATE TABLE `npc_spellclick_spells` (
+    `npc_entry` INT UNSIGNED NOT NULL COMMENT 'reference to creature_template',
+    `spell_id` INT UNSIGNED NOT NULL COMMENT 'spell which should be casted ',
+    `quest_id` INT UNSIGNED NOT NULL COMMENT 'reference to quest_template',
+    `cast_flags` TINYINT UNSIGNED NOT NULL COMMENT 'first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit'
+) ENGINE = MYISAM DEFAULT CHARSET=utf8;
diff --git a/sql/updates/3.0.9_old/3178_mangos_7777_01_world_spell_proc_event.sql b/sql/updates/3.0.9_old/3178_mangos_7777_01_world_spell_proc_event.sql
new file mode 100644
index 00000000000..9c689d996f2
--- /dev/null
+++ b/sql/updates/3.0.9_old/3178_mangos_7777_01_world_spell_proc_event.sql
@@ -0,0 +1,6 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7776_01_mangos_npc_spellclick_spells required_7777_01_mangos_spell_proc_event bit;*/
+
+DELETE FROM spell_proc_event WHERE entry IN (30299,30301,30302);
+INSERT INTO spell_proc_event VALUES (30299, 0x0000007E,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000,  0);
+INSERT INTO spell_proc_event VALUES (30301, 0x0000007E,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000,  0);
+INSERT INTO spell_proc_event VALUES (30302, 0x0000007E,  0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000,  0);
diff --git a/sql/updates/3.0.9_old/3204_mangos_7796_01_world_command.sql b/sql/updates/3.0.9_old/3204_mangos_7796_01_world_command.sql
new file mode 100644
index 00000000000..4d87bf0ba3d
--- /dev/null
+++ b/sql/updates/3.0.9_old/3204_mangos_7796_01_world_command.sql
@@ -0,0 +1,6 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7782_01_mangos_spell_proc_event required_7796_01_mangos_command bit;*/
+
+DELETE FROM `command` WHERE `name` IN ('go taxinode','lookup taxinode');
+INSERT INTO `command` VALUES
+('go taxinode',1,'Syntax: .go taxinode #taxinode\r\n\r\nTeleport player to taxinode coordinates. You can look up zone using .lookup taxinode $namepart'),
+('lookup taxinode',3,'Syntax: .lookup taxinode $substring\r\n\r\nSearch and output all taxinodes with provide $substring in name.');
diff --git a/sql/updates/3.0.9_old/3204_mangos_7796_02_world_trinity_string.sql b/sql/updates/3.0.9_old/3204_mangos_7796_02_world_trinity_string.sql
new file mode 100644
index 00000000000..a1c0e3218a2
--- /dev/null
+++ b/sql/updates/3.0.9_old/3204_mangos_7796_02_world_trinity_string.sql
@@ -0,0 +1,8 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7796_01_mangos_command required_7796_02_mangos_mangos_string bit;*/
+
+DELETE FROM trinity_string WHERE entry IN(347,466,1128,1129);
+INSERT INTO trinity_string VALUES
+(347,'TaxiNode ID %u not found!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(466,'No taxinodes found!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(1128,'%d - |cffffffff|Htaxinode:%u|h[%s %s]|h|r (Map:%u X:%f Y:%f Z:%f)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(1129,'%d - %s %s (Map:%u X:%f Y:%f Z:%f)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
diff --git a/sql/updates/3.0.9_old/3210_mangos_7802_01_characters_character_achievement.sql b/sql/updates/3.0.9_old/3210_mangos_7802_01_characters_character_achievement.sql
new file mode 100644
index 00000000000..4039b5a9703
--- /dev/null
+++ b/sql/updates/3.0.9_old/3210_mangos_7802_01_characters_character_achievement.sql
@@ -0,0 +1,6 @@
+/*ALTER TABLE character_db_version CHANGE COLUMN required_7644_01_characters_character_pet required_7802_01_characters_character_achievement bit;*/
+
+ALTER TABLE character_achievement
+  CHANGE COLUMN guid guid int(11) unsigned NOT NULL,
+  CHANGE COLUMN achievement achievement int(11) unsigned NOT NULL,
+  CHANGE COLUMN date date bigint(11) unsigned NOT NULL default '0';
diff --git a/sql/updates/3.0.9_old/3210_mangos_7802_02_characters_character_achievement_progress.sql b/sql/updates/3.0.9_old/3210_mangos_7802_02_characters_character_achievement_progress.sql
new file mode 100644
index 00000000000..6e525f83317
--- /dev/null
+++ b/sql/updates/3.0.9_old/3210_mangos_7802_02_characters_character_achievement_progress.sql
@@ -0,0 +1,7 @@
+/*ALTER TABLE character_db_version CHANGE COLUMN required_7802_01_characters_character_achievement required_7802_02_characters_character_achievement_progress bit;*/
+
+ALTER TABLE character_achievement_progress
+  CHANGE COLUMN guid guid int(11) unsigned NOT NULL,
+  CHANGE COLUMN criteria criteria int(11) unsigned NOT NULL,
+  CHANGE COLUMN counter counter int(11) unsigned NOT NULL,
+  CHANGE COLUMN date date bigint(11) unsigned NOT NULL default '0';
diff --git a/sql/updates/3.0.9_old/3233_world_scripts_naxx.sql b/sql/updates/3.0.9_old/3233_world_scripts_naxx.sql
new file mode 100644
index 00000000000..ddb18bd3c14
--- /dev/null
+++ b/sql/updates/3.0.9_old/3233_world_scripts_naxx.sql
@@ -0,0 +1,113 @@
+UPDATE `creature_template` SET `ScriptName`='mob_webwrap' WHERE `entry`=16486;
+UPDATE `creature_template` SET `ScriptName`='boss_grobbulus' WHERE entry = 15931;
+UPDATE `creature_template` SET `ScriptName`='mob_gothik_minion' WHERE entry IN (16124,16125,16126,16127,16148,16149,16150);
+UPDATE `creature_template` SET `ScriptName`='boss_four_horsemen' WHERE `entry` IN (16063,16064,16065,30549);
+
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN
+(28732,54097,-29865,-55053,-28169,28059,39088,-28059,-39088,28062,39090,28084,
+39091,-28084,-39091,28085,39093);
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+( 28732,-28798,  1, 'Widow\'s Embrace - Frenzy'),
+( 54097,-54100,  1, 'Widow\'s Embrace - Frenzy (H)'),
+(-29865, 55594,  0, 'Deathbloom'),
+(-55053, 55601,  0, 'Deathbloom (H)'),
+(-28169, 28206,  0, 'Mutating Injection - Mutagen Explosion'),
+(-28169, 28240,  0, 'Mutating Injection - Poison Cloud'),
+( 28059,-28084,  1, 'Positive Charge - Negative Charge'),
+(-28059,-29659,  0, 'Positive Charge'),
+# ( 28062,-29659,  0, 'Positive Charge'),
+( 28084,-28059,  1, 'Negative Charge - Positive Charge'),
+(-28084,-29660,  0, 'Negative Charge'),
+# ( 28085,-29660,  0, 'Negative Charge'),
+( 39088,-39091,  1, 'Positive Charge - Negative Charge'),
+(-39088,-29659,  0, 'Positive Charge'),
+# ( 39090,-29659,  0, 'Positive Charge'),
+( 39091,-39088,  1, 'Negative Charge - Positive Charge'),
+(-39091,-39092,  0, 'Negative Charge');
+# ( 39093,-39092,  0, 'Negative Charge');
+
+INSERT INTO creature_template (entry, spell1, flags_extra, scriptname) VALUES
+(16363, 28158, 128, ''), # Grobbulus Cloud
+(29379, 54362, 128, ''), # Grobbulus Cloud (H)
+(16697, 28158, 128, ''), # Void Zone
+(29379, 54362, 128, '')  # Void Zone (H)
+ON DUPLICATE KEY UPDATE
+spell1 = VALUES(spell1),
+flags_extra = VALUES(flags_extra),
+scriptname = VALUES(scriptname);
+
+INSERT INTO creature_template (entry, baseattacktime, spell1, flags_extra, scriptname) VALUES
+(16474, 1000, 28547, 128, 'trigger_periodic'), # Blizzard (Sapphiron)
+(30000, 1000, 55699, 128, 'trigger_periodic'), # Blizzard (Sapphiron) (H)
+(16697, 1000, 28865, 128, 'trigger_periodic') # Void Zone (Lady Blaumeux)
+ON DUPLICATE KEY UPDATE
+baseattacktime = VALUES(baseattacktime),
+spell1 = VALUES(spell1),
+flags_extra = VALUES(flags_extra),
+scriptname = VALUES(scriptname);
+
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (29912);
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `cast_flags`) VALUES
+(29912, 55479, 0, 1); # Obedience Crystal - Force Obedience
+
+DELETE FROM `spell_script_target` WHERE `entry` IN
+(28732,54097,55479,
+27892,27893,27928,27929,27935,27936);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(28732, 1, 15953), # Widow's Embrace
+(54097, 1, 15953), # Widow's Embrace
+(55479, 1, 16803), # Force Obedience - Death Knight Understudy
+# (29105, 1, 16803), # Hopeless - Death Knight Understudy
+(27892, 1, 16060), # To Anchor 1 - Gothik
+(27893, 1, 16060), # To Anchor 2 - Gothik
+(27928, 1, 16060), # To Anchor 1 - Gothik
+(27929, 1, 16060), # To Anchor 2 - Gothik
+(27935, 1, 16060), # To Anchor 1 - Gothik
+(27936, 1, 16060); # To Anchor 2 - Gothik
+
+INSERT INTO creature_template (entry, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8) VALUES
+(16573, 15284, 28991, 28969, 34970, 0, 0, 0, 28864), # Crypt Guard
+(29256, 15284, 28991, 56098, 34970, 0, 0, 0, 28864), # Crypt Guard (H)
+(16506, 54095, 0, 0, 0, 0, 0, 0, 28732), # Naxxramas Worshipper
+(29274, 54096, 0, 0, 0, 0, 0, 0, 54097), # Naxxramas Worshipper (H)
+(17055, 54121, 0, 0, 0, 0, 0, 0, 0), # Maexxna Spiderling
+(29279, 28776, 0, 0, 0, 0, 0, 0, 0), # Maexxna Spiderling (H)
+(16486, 28622, 0, 0, 0, 0, 0, 0, 0), # Web Wrap
+(30183, 28622, 0, 0, 0, 0, 0, 0, 0), # Web Wrap (H)
+(16984, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior
+(29632, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior (H)
+(16983, 32736, 30138, 0, 0, 0, 0, 0, 0), # Plagued Champion
+(29632, 32736, 54889, 0, 0, 0, 0, 0, 0), # Plagued Champion (H)
+(16981, 15496, 54890, 0, 0, 0, 0, 0, 0), # Plagued Guardian
+(29632, 15496, 54891, 0, 0, 0, 0, 0, 0), # Plagued Guardian (H)
+(16286, 0, 0, 0, 0, 0, 0, 0, 29232), # Spore
+(30068, 0, 0, 0, 0, 0, 0, 0, 29232), # Spore (H)
+(16290, 28156, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime
+(29388, 54367, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime (H)
+(16360, 29307, 0, 0, 0, 0, 0, 0, 0), # Zombie Chow
+(30303, 29307, 0, 0, 0, 0, 0, 0, 0), # Zombie Chow (H)
+(16803, 0, 0, 0, 61696, 29060, 29061, 0, 0), # Death Knight Understudy
+(29941, 0, 0, 0, 61696, 29060, 29061, 0, 0), # Death Knight Understudy (H)
+(16124, 55604, 0, 0, 0, 0, 0, 0, 27892), # Unrelenting Trainee
+(16125, 27825, 0, 0, 0, 0, 0, 0, 27928), # Unrelenting Death Knight
+(16126, 27831, 55606, 0, 0, 0, 0, 0, 27935), # Unrelenting Rider
+(16127, 27989, 0, 0, 0, 0, 0, 0, 0), # Spectral Trainee
+(16148, 56408, 0, 0, 0, 0, 0, 0, 0), # Spectral Death Knight
+(16150, 27994, 55648, 55606, 0, 0, 0, 0, 0), # Spectral Rider
+(16149, 27993, 0, 0, 0, 0, 0, 0, 0), # Spectral Horse
+(29985, 55645, 0, 0, 0, 0, 0, 0, 27892), # Unrelenting Trainee (H)
+(29986, 27825, 0, 0, 0, 0, 0, 0, 27928), # Unrelenting Death Knight (H)
+(29987, 55638, 55608, 0, 0, 0, 0, 0, 27935), # Unrelenting Rider (H)
+(30264, 56407, 0, 0, 0, 0, 0, 0, 0), # Spectral Trainee (H)
+(29990, 56408, 0, 0, 0, 0, 0, 0, 0), # Spectral Death Knight (H)
+(29988, 55646, 27995, 55608, 0, 0, 0, 0, 0), # Spectral Rider (H)
+(29989, 27993, 0, 0, 0, 0, 0, 0, 0) # Spectral Horse (H)
+ON DUPLICATE KEY UPDATE
+spell1 = VALUES(spell1),
+spell2 = VALUES(spell2),
+spell3 = VALUES(spell3),
+spell4 = VALUES(spell4),
+spell5 = VALUES(spell5),
+spell6 = VALUES(spell6),
+spell7 = VALUES(spell7),
+spell8 = VALUES(spell8);
diff --git a/sql/updates/3.0.9_old/3235_characters.sql b/sql/updates/3.0.9_old/3235_characters.sql
new file mode 100644
index 00000000000..814b2dda67c
--- /dev/null
+++ b/sql/updates/3.0.9_old/3235_characters.sql
@@ -0,0 +1,4 @@
+DELETE FROM `character_action` WHERE `type` = 0 AND `action` = 28734;
+DELETE FROM `character_aura` WHERE `spell` = 28734;
+DELETE FROM `character_spell` WHERE `spell` = 28734;
+DELETE FROM `character_spell_cooldown` WHERE `spell` = 28734;
diff --git a/sql/updates/3.0.9_old/3235_world.sql b/sql/updates/3.0.9_old/3235_world.sql
new file mode 100644
index 00000000000..fea9efee912
--- /dev/null
+++ b/sql/updates/3.0.9_old/3235_world.sql
@@ -0,0 +1,5 @@
+DELETE FROM `playercreateinfo_action` WHERE `type` = 0 AND `action` = 28734;
+DELETE FROM `playercreateinfo_spell` WHERE `spell` = 28734;
+DELETE FROM `playercreateinfo_spell_custom` WHERE `spell` = 28734;
+UPDATE `playercreateinfo_action` SET `button` = 3 WHERE `race` = 10 AND `class` IN (2, 3, 5, 8, 9) AND `action` = 28730 AND `type` = 0;
+UPDATE `playercreateinfo_action` SET `button` = 4 WHERE `race` = 10 AND `class` = 4 AND `action` = 25046 AND `type` = 0;
diff --git a/sql/updates/3.0.9_old/3257_world_waypoint_data_converter.sql b/sql/updates/3.0.9_old/3257_world_waypoint_data_converter.sql
new file mode 100644
index 00000000000..7da23dcd962
--- /dev/null
+++ b/sql/updates/3.0.9_old/3257_world_waypoint_data_converter.sql
@@ -0,0 +1,15 @@
+ALTER TABLE creature_addon ADD INDEX ( `path_id` );
+ALTER TABLE waypoint_data ADD INDEX ( `id` );
+ 
+ALTER TABLE waypoint_data ADD COLUMN id_old int(10) unsigned NOT NULL default '0' COMMENT 'Creature GUID' AFTER wpguid;
+
+UPDATE waypoint_data SET id_old=id;
+ALTER TABLE waypoint_data ADD INDEX ( `id_old` );
+
+UPDATE waypoint_data,creature_addon SET waypoint_data.id=creature_addon.guid*10 WHERE creature_addon.path_id > 0 AND creature_addon.path_id=waypoint_data.id_old;
+UPDATE waypoint_data SET id = 1343801 WHERE id_old = 2084;
+UPDATE waypoint_scripts SET datalong = 1343801 WHERE id = 515;
+
+ALTER TABLE waypoint_data DROP COLUMN id_old;
+ALTER TABLE `creature_addon` DROP INDEX `path_id` ;
+ALTER TABLE waypoint_data DROP INDEX `id`;
diff --git a/sql/updates/3.0.9_old/3258_world_creature_addon_(waypoint).sql b/sql/updates/3.0.9_old/3258_world_creature_addon_(waypoint).sql
new file mode 100644
index 00000000000..69937b22430
--- /dev/null
+++ b/sql/updates/3.0.9_old/3258_world_creature_addon_(waypoint).sql
@@ -0,0 +1,2 @@
+ALTER TABLE creature_template_addon DROP COLUMN path_id;
+ALTER TABLE creature_addon DROP COLUMN path_id;
diff --git a/sql/updates/3.0.9_old/3263_world_scripts_missing_in_full.sql b/sql/updates/3.0.9_old/3263_world_scripts_missing_in_full.sql
new file mode 100644
index 00000000000..aab3dea7080
--- /dev/null
+++ b/sql/updates/3.0.9_old/3263_world_scripts_missing_in_full.sql
@@ -0,0 +1,14 @@
+UPDATE creature_template SET ScriptName='npc_kingdom_of_dalaran_quests' WHERE entry IN (29169,23729,26673,27158,29158,29161,26471,29155,29159,29160,29162);
+UPDATE `creature_template` SET `ScriptName` = 'boss_elder_nadox' WHERE `entry` = 29309;
+UPDATE `creature_template` SET `ScriptName` = 'mob_ahnkahar_nerubian' WHERE `entry` in (30176,30178);
+UPDATE `instance_template` SET `script`= 'instance_ahnkahet' WHERE `map` = 619;
+update creature_template set scriptname = 'mob_parasitic_shadowfiend' where entry = 23498;
+UPDATE `creature_template` SET `ScriptName`='npc_aeranas' WHERE `entry`=17085;
+UPDATE `gameobject_template` SET `ScriptName`='go_haaleshi_altar' WHERE `entry`=181606;
+UPDATE `creature_template` SET `ScriptName`='npc_commander_dawnforge' WHERE `entry`=19831;
+UPDATE creature_template SET scriptname = 'boss_kalecgos' WHERE entry = 24850;
+UPDATE creature_template SET scriptname = 'boss_sathrovarr' WHERE entry = 24892;
+UPDATE creature_template SET scriptname = 'boss_kalec' WHERE entry = 24891;
+UPDATE creature_template SET scriptname = 'npc_blackhole' WHERE entry = 25855;
+UPDATE creature_template SET scriptname = 'boss_archavon' WHERE entry = 31125;
+UPDATE creature_template SET scriptname = 'mob_archavon_warder' WHERE entry = 32353;
diff --git a/sql/updates/3.0.9_old/3314_mangos_7823_01_world_item_template.sql b/sql/updates/3.0.9_old/3314_mangos_7823_01_world_item_template.sql
new file mode 100644
index 00000000000..eb2b40adf7b
--- /dev/null
+++ b/sql/updates/3.0.9_old/3314_mangos_7823_01_world_item_template.sql
@@ -0,0 +1,4 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7796_02_mangos_mangos_string required_7823_01_mangos_item_template bit;*/
+
+ALTER TABLE item_template
+CHANGE COLUMN ScalingStatValue ScalingStatValue int(6) unsigned NOT NULL default '0';
diff --git a/sql/updates/3.0.9_old/3320_worldspell_enchant_proc_data.sql b/sql/updates/3.0.9_old/3320_worldspell_enchant_proc_data.sql
new file mode 100644
index 00000000000..7f5df5edf14
--- /dev/null
+++ b/sql/updates/3.0.9_old/3320_worldspell_enchant_proc_data.sql
@@ -0,0 +1,17 @@
+CREATE TABLE `spell_enchant_proc_data` (
+  `entry` INT(10) UNSIGNED NOT NULL,
+  `customChance` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `PPMChance` FLOAT UNSIGNED NOT NULL DEFAULT '0', 
+  `procEx` FLOAT UNSIGNED NOT NULL DEFAULT '0'
+) ENGINE=MYISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant proc data';
+
+-- Frostbrand Weapon
+INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (2, 0, 8.8,0);
+INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (12, 0, 8.8,0);
+INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (524, 0, 8.8,0);
+INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (1667, 0, 8.8,0);
+INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (1668, 0, 8.8,0);
+INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (2635, 0, 8.8,0);
+INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3782, 0, 8.8,0);
+INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3783, 0, 8.8,0);
+INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3784, 0, 8.8,0);
diff --git a/sql/updates/3.0.9_old/3323_world_spell_proc_event.sql b/sql/updates/3.0.9_old/3323_world_spell_proc_event.sql
new file mode 100644
index 00000000000..e1ed1649994
--- /dev/null
+++ b/sql/updates/3.0.9_old/3323_world_spell_proc_event.sql
@@ -0,0 +1,4 @@
+-- Glyph of Ice Block --
+DELETE FROM `spell_proc_event` WHERE `entry` = 56372;
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+(56372, 0x00, 3, 0x00000000, 0x00000080, 0x00000000, 0x00004000, 0x00000000, 0.000000, 0.000000, 0);
diff --git a/sql/updates/3.0.9_old/3331_world_spell.sql b/sql/updates/3.0.9_old/3331_world_spell.sql
new file mode 100644
index 00000000000..bbad1797eb0
--- /dev/null
+++ b/sql/updates/3.0.9_old/3331_world_spell.sql
@@ -0,0 +1,6 @@
+DELETE FROM spell_script_target WHERE targetentry IN (8313,38968,21934);
+DELETE FROM spell_proc_event WHERE entry in (19615);
+
+UPDATE creature_template SET spell2 = 0 WHERE entry IN (16474,30000);
+UPDATE gameobject_template SET scriptname = 'go_najentus_spine' WHERE entry = 185584;
+UPDATE gameobject_template SET scriptname = 'go_bridge_console' WHERE entry = 184568;
diff --git a/sql/updates/3.0.9_old/3358_world_spell_bonus_data.sql b/sql/updates/3.0.9_old/3358_world_spell_bonus_data.sql
new file mode 100644
index 00000000000..e2cb0aa706b
--- /dev/null
+++ b/sql/updates/3.0.9_old/3358_world_spell_bonus_data.sql
@@ -0,0 +1 @@
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.6453' WHERE `spell_bonus_data`.`entry` =33763;
diff --git a/sql/updates/3.0.9_old/3359_world_spell_linked_spell.sql b/sql/updates/3.0.9_old/3359_world_spell_linked_spell.sql
new file mode 100644
index 00000000000..284320a7943
--- /dev/null
+++ b/sql/updates/3.0.9_old/3359_world_spell_linked_spell.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_linked_spell` WHERE spell_trigger = 33206;
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+( 33206, 44416, 2, 'Pain Suppression (threat)');
diff --git a/sql/updates/3.0.9_old/3363_characters_characters.sql b/sql/updates/3.0.9_old/3363_characters_characters.sql
new file mode 100644
index 00000000000..121e5347c3f
--- /dev/null
+++ b/sql/updates/3.0.9_old/3363_characters_characters.sql
@@ -0,0 +1 @@
+ALTER TABLE `characters` ADD COLUMN `instance_id` int(11) unsigned NOT NULL default '0' AFTER `map`;
diff --git a/sql/updates/3.0.9_old/3373_world_spell.sql b/sql/updates/3.0.9_old/3373_world_spell.sql
new file mode 100644
index 00000000000..23fe9bac842
--- /dev/null
+++ b/sql/updates/3.0.9_old/3373_world_spell.sql
@@ -0,0 +1,2 @@
+DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (38528);
+DELETE FROM spell_proc_event WHERE `entry` IN (31785, 33776);
diff --git a/sql/updates/3.0.9_old/3375_mangos_7839_01_world_trinity_string.sql b/sql/updates/3.0.9_old/3375_mangos_7839_01_world_trinity_string.sql
new file mode 100644
index 00000000000..6c7c9b44ed1
--- /dev/null
+++ b/sql/updates/3.0.9_old/3375_mangos_7839_01_world_trinity_string.sql
@@ -0,0 +1,4 @@
+DELETE FROM `trinity_string` WHERE `entry` IN (283,171,5011);
+INSERT INTO `trinity_string` VALUES
+(171,'You can\'t teleport self to self!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(5011,'You can\'t teleport self to self!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
diff --git a/sql/updates/3.0.9_old/3375_mangos_7839_02_world_command.sql b/sql/updates/3.0.9_old/3375_mangos_7839_02_world_command.sql
new file mode 100644
index 00000000000..f8c09af2e19
--- /dev/null
+++ b/sql/updates/3.0.9_old/3375_mangos_7839_02_world_command.sql
@@ -0,0 +1,22 @@
+/* ALTER TABLE db_version CHANGE COLUMN required_7839_01_mangos_mangos_string required_7839_02_mangos_command bit;*/
+
+DELETE FROM `command` WHERE `name` IN (
+   'baninfo account','baninfo character','baninfo ip','goname','groupgo',
+   'guild create','guild invite','guild rank','guild uninvite','mute',
+   'namego','tele name','unmute'
+);
+
+INSERT INTO `command` VALUES
+('baninfo account',3,'Syntax: .baninfo account $accountid\r\nWatch full information about a specific ban.'),
+('baninfo character',3,'Syntax: .baninfo character $charactername \r\nWatch full information about a specific ban.'),
+('baninfo ip',3,'Syntax: .baninfo ip $ip\r\nWatch full information about a specific ban.'),
+('goname',1,'Syntax: .goname [$charactername]\r\n\r\nTeleport to the given character. Either specify the character name or click on the character\'s portrait, e.g. when you are in a group. Character can be offline.'),
+('groupgo',1,'Syntax: .groupgo [$charactername]\r\n\r\nTeleport the given character and his group to you. Teleported only online characters but original selected group member can be offline.'),
+('guild create',2,'Syntax: .guild create [$GuildLeaderName] $GuildName\r\n\r\nCreate a guild named $GuildName with the player $GuildLeaderName (or selected) as leader.'),
+('guild invite',2,'Syntax: .guild invite [$CharacterName] $GuildName\r\n\r\nAdd player $CharacterName (or selected) into a guild $GuildName.'),
+('guild rank',2,'Syntax: .guild rank [$CharacterName] #Rank\r\n\r\nSet for player $CharacterName (or selected) rank #Rank in a guild.'),
+('guild uninvite',2,'Syntax: .guild uninvite [$CharacterName]\r\n\r\nRemove player $CharacterName (or selected) from a guild.'),
+('mute',1,'Syntax: .mute [$playerName] $timeInMinutes\r\n\r\nDisible chat messaging for any character from account of character $playerName (or currently selected) at $timeInMinutes minutes. Player can be offline.'),
+('namego',1,'Syntax: .namego [$charactername]\r\n\r\nTeleport the given character to you. Character can be offline.'),
+('tele name',1,'Syntax: .tele name [#playername] #location\r\n\r\nTeleport the given character to a given location. Character can be offline.'),
+('unmute',1,'Syntax: .unmute [$playerName]\r\n\r\nRestore chat messaging for any character from account of character $playerName (or selected). Character can be ofline.');
diff --git a/sql/updates/3.0.9_old/3392_world_spell_proc_event.sql b/sql/updates/3.0.9_old/3392_world_spell_proc_event.sql
new file mode 100644
index 00000000000..d0965c1a7ab
--- /dev/null
+++ b/sql/updates/3.0.9_old/3392_world_spell_proc_event.sql
@@ -0,0 +1,20 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN 
+(27521, 55381, 62459, 60176, 60529, 60717, 62147, 57907, 51528, 51529, 51530, 51531, 51532);
+INSERT INTO `spell_proc_event` 
+(`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`)
+VALUES
+-- malestorm weapon
+(51528, 0, 0, 0, 0, 0, 0, 0, 2.5, 0, 0),
+(51529, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0),
+(51530, 0, 0, 0, 0, 0, 0, 0, 7.5, 0, 0),
+(51531, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0),
+(51532, 0, 0, 0, 0, 0, 0, 0, 12.5, 0, 0),
+
+(27521, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0.000000, 0.000000, 15),
+(55381, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0.000000, 0.000000, 15),
+(62459, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0),
+(60176, 0x00, 4, 0x00000020, 0x00000010, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0),
+(60529, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 45),
+(60717, 0x00, 7, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 100.000000, 0),
+(62147, 0x00, 15, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0),
+(57907, 0x00, 7, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);
diff --git a/sql/updates/3.0.9_old/3393_world_spell_proc_event.sql b/sql/updates/3.0.9_old/3393_world_spell_proc_event.sql
new file mode 100644
index 00000000000..7593080a248
--- /dev/null
+++ b/sql/updates/3.0.9_old/3393_world_spell_proc_event.sql
@@ -0,0 +1 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (53651);
diff --git a/sql/updates/3.0.9_old/3394_world_spell_bonus_data.sql b/sql/updates/3.0.9_old/3394_world_spell_bonus_data.sql
new file mode 100644
index 00000000000..d960ae5ca06
--- /dev/null
+++ b/sql/updates/3.0.9_old/3394_world_spell_bonus_data.sql
@@ -0,0 +1,10 @@
+DELETE FROM `spell_bonus_data` WHERE `entry` IN (48505,50288,50294,53191,53188,53194,53189,53195,53190);
+INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES
+(50288, 0.05, 0, 0, 'Druid - Starfall rank 1'),
+(50294, 0.012, 0, 0, 'Druid - Starfall AOE rank 1'),
+(53191, 0.05, 0, 0, 'Druid - Starfall rank 2'),
+(53188, 0.012, 0, 0, 'Druid - Starfall AOE rank 2'),
+(53194, 0.05, 0, 0, 'Druid - Starfall rank 3'),
+(53189, 0.012, 0, 0, 'Druid - Starfall AOE rank 3'),
+(53195, 0.05, 0, 0, 'Druid - Starfall rank 4'),
+(53190, 0.012, 0, 0, 'Druid - Starfall AOE rank 4');
diff --git a/sql/updates/3.0.9_old/3409_world_spell_proc_event.sql b/sql/updates/3.0.9_old/3409_world_spell_proc_event.sql
new file mode 100644
index 00000000000..da24f66a7a4
--- /dev/null
+++ b/sql/updates/3.0.9_old/3409_world_spell_proc_event.sql
@@ -0,0 +1,8 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (31878, 31877, 31876, 46913, 46914, 46915);
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+(31876, 0, 10, 8388608, 0, 0, 0, 0, 0, 0, 0),
+(31877, 0, 10, 8388608, 0, 0, 0, 0, 0, 0, 0),
+(31878, 0, 10, 8388608, 0, 0, 0, 0, 0, 0, 0),
+(46913, 0, 4, 0, 1024, 0, 0, 0, 0, 0, 0),
+(46914, 0, 4, 0, 1024, 0, 0, 0, 0, 0, 0),
+(46915, 0, 4, 0, 1024, 0, 0, 0, 0, 0, 0);
diff --git a/sql/updates/3.0.9_old/3410_world_SD2_scripts.sql b/sql/updates/3.0.9_old/3410_world_SD2_scripts.sql
new file mode 100644
index 00000000000..9a54cea49db
--- /dev/null
+++ b/sql/updates/3.0.9_old/3410_world_SD2_scripts.sql
@@ -0,0 +1,31 @@
+UPDATE `creature_template` SET `ScriptName` = 'npc_daphne_stilwell' WHERE `entry` = 6182;
+
+DELETE FROM `script_waypoint` WHERE `entry` = 6182;
+INSERT INTO `script_waypoint` VALUES
+(6182, 0, -11480.684570, 1545.091187, 49.898571, 0, ''),
+(6182, 1, -11466.825195, 1530.151733, 50.263611, 0, ''),
+(6182, 2, -11465.213867, 1528.343750, 50.954369, 0, 'entrance hut'),
+(6182, 3, -11462.990234, 1525.235596, 50.937702, 0, ''),
+(6182, 4, -11461.000000, 1526.614014, 50.937702, 5000, 'pick up rifle'),
+(6182, 5, -11462.990234, 1525.235596, 50.937702, 0, ''),
+(6182, 6, -11465.213867, 1528.343750, 50.954369, 0, ''),
+(6182, 7, -11468.353516, 1535.075562, 50.400948, 15000, 'hold, prepare for wave1'),
+(6182, 8, -11468.353516, 1535.075562, 50.400948, 15000, 'hold, prepare for wave2'),
+(6182, 9, -11468.353516, 1535.075562, 50.400948, 10000, 'hold, prepare for wave3'),
+(6182, 10, -11467.898438, 1532.459595, 50.348885, 0, 'we are done'),
+(6182, 11, -11466.064453, 1529.855225, 50.209351, 0, ''),
+(6182, 12, -11462.990234, 1525.235596, 50.937702, 0, ''),
+(6182, 13, -11461.000000, 1526.614014, 50.937702, 5000, 'deliver rifle'),
+(6182, 14, -11462.990234, 1525.235596, 50.937702, 0, ''),
+(6182, 15, -11465.213867, 1528.343750, 50.954369, 0, ''),
+(6182, 16, -11470.260742, 1537.276733, 50.378487, 0, ''),
+(6182, 17, -11475.581055, 1548.678833, 50.184380, 0, 'complete quest'),
+(6182, 18, -11482.299805, 1557.410034, 48.624519, 0, '');
+
+DELETE FROM `script_texts` WHERE `entry` BETWEEN -1000406 AND -1000402;
+INSERT INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
+(-1000402, 'To the house! Stay close to me, no matter what! I have my gun and ammo there!', 0, 0, 7, 0, 'stilwell SAY_DS_START'),
+(-1000403, 'We showed that one!', 0, 0, 7, 0, 'stilwell SAY_DS_DOWN_1'),
+(-1000404, 'One more down!', 0, 0, 7, 0, 'stilwell SAY_DS_DOWN_2'),
+(-1000405, 'We\'ve done it! We won!', 0, 0, 7, 0, 'stilwell SAY_DS_DOWN_3'),
+(-1000406, 'Meet me down by the orchard--I just need to put my gun away.', 0, 0, 7, 0, 'stilwell SAY_DS_PROLOGUE');
diff --git a/sql/updates/3.0.9_old/3414_mangos_7850_01_world_command.sql b/sql/updates/3.0.9_old/3414_mangos_7850_01_world_command.sql
new file mode 100644
index 00000000000..4a985433f1b
--- /dev/null
+++ b/sql/updates/3.0.9_old/3414_mangos_7850_01_world_command.sql
@@ -0,0 +1,6 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7839_02_mangos_command required_7850_01_mangos_command bit;*/
+
+DELETE FROM `command` WHERE `name` IN ('character reputation','pinfo');
+INSERT INTO `command` VALUES
+('pinfo',2,'Syntax: .pinfo [$player_name]\r\n\r\nOutput account information for selected player or player find by $player_name.'),
+('character reputation',2,'Syntax: .character reputation [$player_name]\r\n\r\nShow reputation information for selected player or player find by $player_name.');
diff --git a/sql/updates/3.0.9_old/3416_mangos_7855_01_world_pools.sql b/sql/updates/3.0.9_old/3416_mangos_7855_01_world_pools.sql
new file mode 100644
index 00000000000..b692233aaad
--- /dev/null
+++ b/sql/updates/3.0.9_old/3416_mangos_7855_01_world_pools.sql
@@ -0,0 +1,13 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7850_01_mangos_command required_7855_01_mangos_pools bit;*/
+
+ALTER TABLE pool_creature
+  ADD COLUMN description varchar(255) NOT NULL AFTER chance;
+
+ALTER TABLE pool_gameobject
+  ADD COLUMN description varchar(255) NOT NULL AFTER chance;
+
+ALTER TABLE pool_pool
+  ADD COLUMN description varchar(255) NOT NULL AFTER chance;
+
+ALTER TABLE pool_template
+  ADD COLUMN description varchar(255) NOT NULL AFTER max_limit;
diff --git a/sql/updates/3.0.9_old/3419_world_SD2_scripts.sql b/sql/updates/3.0.9_old/3419_world_SD2_scripts.sql
new file mode 100644
index 00000000000..103def19441
--- /dev/null
+++ b/sql/updates/3.0.9_old/3419_world_SD2_scripts.sql
@@ -0,0 +1,51 @@
+UPDATE `creature_template` SET `ScriptName` = 'npc_oox22fe' WHERE `entry` = 7807;
+
+DELETE FROM `script_waypoint` WHERE `entry` = 7807;
+INSERT INTO `script_waypoint` VALUES
+(7807, 0, -4943.74, 1715.74, 62.74, 0, 'SAY_START'),
+(7807, 1, -4944.93, 1706.66, 63.16, 0, ''),
+(7807, 2, -4942.82, 1690.22, 64.25, 0, ''),
+(7807, 3, -4946.47, 1669.62, 63.84, 0, ''),
+(7807, 4, -4955.93, 1651.88, 63.00, 0, ''),
+(7807, 5, -4967.58, 1643.86, 64.31, 0, ''),
+(7807, 6, -4978.12, 1607.90, 64.30, 0, ''),
+(7807, 7, -4975.38, 1596.16, 64.70, 0, ''),
+(7807, 8, -4972.82, 1581.89, 61.75, 0, ''),
+(7807, 9, -4958.65, 1581.05, 61.81, 0, ''),
+(7807, 10, -4936.72, 1594.89, 65.96, 0, ''),
+(7807, 11, -4885.69, 1598.10, 67.45, 4000, 'first ambush SAY_AMBUSH'),
+(7807, 12, -4874.20, 1601.73, 68.54, 0, ''),
+(7807, 13, -4816.64, 1594.47, 78.20, 0, ''),
+(7807, 14, -4802.20, 1571.92, 87.01, 0, ''),
+(7807, 15, -4746.40, 1576.11, 84.59, 0, ''),
+(7807, 16, -4739.72, 1707.16, 94.04, 0, ''),
+(7807, 17, -4674.03, 1840.44, 89.17, 0, ''),
+(7807, 18, -4667.94, 1864.11, 85.18, 0, ''),
+(7807, 19, -4668.08, 1886.39, 81.14, 0, ''),
+(7807, 20, -4679.43, 1932.32, 73.76, 0, ''),
+(7807, 21, -4674.17, 1946.66, 70.83, 5000, 'second ambush SAY_AMBUSH'),
+(7807, 22, -4643.94, 1967.45, 65.27, 0, ''),
+(7807, 23, -4595.60, 2010.75, 52.10, 0, ''),
+(7807, 24, -4562.65, 2029.28, 45.41, 0, ''),
+(7807, 25, -4538.56, 2032.65, 45.28, 0, ''),
+(7807, 26, -4531.96, 2034.15, 48.34, 0, ''),
+(7807, 27, -4507.75, 2039.32, 51.57, 0, ''),
+(7807, 28, -4482.74, 2045.67, 48.15, 0, ''),
+(7807, 29, -4460.87, 2051.54, 45.55, 0, ''),
+(7807, 30, -4449.97, 2060.03, 45.51, 10000, 'third ambush SAY_AMBUSH'),
+(7807, 31, -4448.99, 2079.05, 44.64, 0, ''),
+(7807, 32, -4436.64, 2134.48, 28.83, 0, ''),
+(7807, 33, -4429.25, 2170.20, 15.44, 0, ''),
+(7807, 34, -4424.83, 2186.11, 11.48, 0, ''),
+(7807, 35, -4416.71, 2209.76, 7.36, 0, ''),
+(7807, 36, -4405.25, 2231.77, 5.94, 0, ''),
+(7807, 37, -4377.61, 2265.45, 06.71, 15000, 'complete quest SAY_END');
+
+DELETE FROM `script_texts` WHERE `entry` BETWEEN -1060005 AND -1060000;
+INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
+(-1060005, 'Cloaking systems online! CLUCK! Engaging cloak for transport to Booty Bay!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'oox17 SAY_END'),
+(-1060004, 'No one challenges the wastevander nomads -- not even robotic chickens! ATTACK!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'oox17 SAY_AMBUSH_REPLY'),
+(-1060003, 'CLUCK! Sensors detect spatial anomaly -- danger imminent! CLUCK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'oox17 SAY_AMBUSH'),
+(-1060002, 'Threat analyzed! Activating combat plan beta! CLUCK!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'oox17 SAY_AGGRO2'),
+(-1060001, 'Physical threat detected! Evasive action! CLUCK!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'oox17 SAY_AGGRO1'),
+(-1060000, 'Emergency power activated! Initializing ambulatory motor! CLUCK!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'oox17 SAY_START');
diff --git a/sql/updates/3.0.9_old/3421_world_scripts.sql b/sql/updates/3.0.9_old/3421_world_scripts.sql
new file mode 100644
index 00000000000..b1f9f3e6f2e
--- /dev/null
+++ b/sql/updates/3.0.9_old/3421_world_scripts.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `ScriptName`='npc_taxi' WHERE `entry` IN (17435, 23413, 18725, 19401, 19409, 20235, 25059, 25236, 20903, 20162, 29154, 23415);
diff --git a/sql/updates/3.0.9_old/3422_world_scripts.sql b/sql/updates/3.0.9_old/3422_world_scripts.sql
new file mode 100644
index 00000000000..7854f5d1313
--- /dev/null
+++ b/sql/updates/3.0.9_old/3422_world_scripts.sql
@@ -0,0 +1 @@
+UPDATE creature_template SET ScriptName='npc_karynaku' WHERE entry=22112;
diff --git a/sql/updates/3.0.9_old/3423_world_scripts.sql b/sql/updates/3.0.9_old/3423_world_scripts.sql
new file mode 100644
index 00000000000..16b07bd57a3
--- /dev/null
+++ b/sql/updates/3.0.9_old/3423_world_scripts.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `ScriptName`='npc_taxi' WHERE `entry` IN (27575, 26443, 26949);
diff --git a/sql/updates/3.0.9_old/3424_world_scripts.sql b/sql/updates/3.0.9_old/3424_world_scripts.sql
new file mode 100644
index 00000000000..bd15ac0b299
--- /dev/null
+++ b/sql/updates/3.0.9_old/3424_world_scripts.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `ScriptName`='npc_taxi' WHERE `entry`=23816;
diff --git a/sql/updates/3.0.9_old/3427_world_scripts_naxx.sql b/sql/updates/3.0.9_old/3427_world_scripts_naxx.sql
new file mode 100644
index 00000000000..ddb18bd3c14
--- /dev/null
+++ b/sql/updates/3.0.9_old/3427_world_scripts_naxx.sql
@@ -0,0 +1,113 @@
+UPDATE `creature_template` SET `ScriptName`='mob_webwrap' WHERE `entry`=16486;
+UPDATE `creature_template` SET `ScriptName`='boss_grobbulus' WHERE entry = 15931;
+UPDATE `creature_template` SET `ScriptName`='mob_gothik_minion' WHERE entry IN (16124,16125,16126,16127,16148,16149,16150);
+UPDATE `creature_template` SET `ScriptName`='boss_four_horsemen' WHERE `entry` IN (16063,16064,16065,30549);
+
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN
+(28732,54097,-29865,-55053,-28169,28059,39088,-28059,-39088,28062,39090,28084,
+39091,-28084,-39091,28085,39093);
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+( 28732,-28798,  1, 'Widow\'s Embrace - Frenzy'),
+( 54097,-54100,  1, 'Widow\'s Embrace - Frenzy (H)'),
+(-29865, 55594,  0, 'Deathbloom'),
+(-55053, 55601,  0, 'Deathbloom (H)'),
+(-28169, 28206,  0, 'Mutating Injection - Mutagen Explosion'),
+(-28169, 28240,  0, 'Mutating Injection - Poison Cloud'),
+( 28059,-28084,  1, 'Positive Charge - Negative Charge'),
+(-28059,-29659,  0, 'Positive Charge'),
+# ( 28062,-29659,  0, 'Positive Charge'),
+( 28084,-28059,  1, 'Negative Charge - Positive Charge'),
+(-28084,-29660,  0, 'Negative Charge'),
+# ( 28085,-29660,  0, 'Negative Charge'),
+( 39088,-39091,  1, 'Positive Charge - Negative Charge'),
+(-39088,-29659,  0, 'Positive Charge'),
+# ( 39090,-29659,  0, 'Positive Charge'),
+( 39091,-39088,  1, 'Negative Charge - Positive Charge'),
+(-39091,-39092,  0, 'Negative Charge');
+# ( 39093,-39092,  0, 'Negative Charge');
+
+INSERT INTO creature_template (entry, spell1, flags_extra, scriptname) VALUES
+(16363, 28158, 128, ''), # Grobbulus Cloud
+(29379, 54362, 128, ''), # Grobbulus Cloud (H)
+(16697, 28158, 128, ''), # Void Zone
+(29379, 54362, 128, '')  # Void Zone (H)
+ON DUPLICATE KEY UPDATE
+spell1 = VALUES(spell1),
+flags_extra = VALUES(flags_extra),
+scriptname = VALUES(scriptname);
+
+INSERT INTO creature_template (entry, baseattacktime, spell1, flags_extra, scriptname) VALUES
+(16474, 1000, 28547, 128, 'trigger_periodic'), # Blizzard (Sapphiron)
+(30000, 1000, 55699, 128, 'trigger_periodic'), # Blizzard (Sapphiron) (H)
+(16697, 1000, 28865, 128, 'trigger_periodic') # Void Zone (Lady Blaumeux)
+ON DUPLICATE KEY UPDATE
+baseattacktime = VALUES(baseattacktime),
+spell1 = VALUES(spell1),
+flags_extra = VALUES(flags_extra),
+scriptname = VALUES(scriptname);
+
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (29912);
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `cast_flags`) VALUES
+(29912, 55479, 0, 1); # Obedience Crystal - Force Obedience
+
+DELETE FROM `spell_script_target` WHERE `entry` IN
+(28732,54097,55479,
+27892,27893,27928,27929,27935,27936);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(28732, 1, 15953), # Widow's Embrace
+(54097, 1, 15953), # Widow's Embrace
+(55479, 1, 16803), # Force Obedience - Death Knight Understudy
+# (29105, 1, 16803), # Hopeless - Death Knight Understudy
+(27892, 1, 16060), # To Anchor 1 - Gothik
+(27893, 1, 16060), # To Anchor 2 - Gothik
+(27928, 1, 16060), # To Anchor 1 - Gothik
+(27929, 1, 16060), # To Anchor 2 - Gothik
+(27935, 1, 16060), # To Anchor 1 - Gothik
+(27936, 1, 16060); # To Anchor 2 - Gothik
+
+INSERT INTO creature_template (entry, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8) VALUES
+(16573, 15284, 28991, 28969, 34970, 0, 0, 0, 28864), # Crypt Guard
+(29256, 15284, 28991, 56098, 34970, 0, 0, 0, 28864), # Crypt Guard (H)
+(16506, 54095, 0, 0, 0, 0, 0, 0, 28732), # Naxxramas Worshipper
+(29274, 54096, 0, 0, 0, 0, 0, 0, 54097), # Naxxramas Worshipper (H)
+(17055, 54121, 0, 0, 0, 0, 0, 0, 0), # Maexxna Spiderling
+(29279, 28776, 0, 0, 0, 0, 0, 0, 0), # Maexxna Spiderling (H)
+(16486, 28622, 0, 0, 0, 0, 0, 0, 0), # Web Wrap
+(30183, 28622, 0, 0, 0, 0, 0, 0, 0), # Web Wrap (H)
+(16984, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior
+(29632, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior (H)
+(16983, 32736, 30138, 0, 0, 0, 0, 0, 0), # Plagued Champion
+(29632, 32736, 54889, 0, 0, 0, 0, 0, 0), # Plagued Champion (H)
+(16981, 15496, 54890, 0, 0, 0, 0, 0, 0), # Plagued Guardian
+(29632, 15496, 54891, 0, 0, 0, 0, 0, 0), # Plagued Guardian (H)
+(16286, 0, 0, 0, 0, 0, 0, 0, 29232), # Spore
+(30068, 0, 0, 0, 0, 0, 0, 0, 29232), # Spore (H)
+(16290, 28156, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime
+(29388, 54367, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime (H)
+(16360, 29307, 0, 0, 0, 0, 0, 0, 0), # Zombie Chow
+(30303, 29307, 0, 0, 0, 0, 0, 0, 0), # Zombie Chow (H)
+(16803, 0, 0, 0, 61696, 29060, 29061, 0, 0), # Death Knight Understudy
+(29941, 0, 0, 0, 61696, 29060, 29061, 0, 0), # Death Knight Understudy (H)
+(16124, 55604, 0, 0, 0, 0, 0, 0, 27892), # Unrelenting Trainee
+(16125, 27825, 0, 0, 0, 0, 0, 0, 27928), # Unrelenting Death Knight
+(16126, 27831, 55606, 0, 0, 0, 0, 0, 27935), # Unrelenting Rider
+(16127, 27989, 0, 0, 0, 0, 0, 0, 0), # Spectral Trainee
+(16148, 56408, 0, 0, 0, 0, 0, 0, 0), # Spectral Death Knight
+(16150, 27994, 55648, 55606, 0, 0, 0, 0, 0), # Spectral Rider
+(16149, 27993, 0, 0, 0, 0, 0, 0, 0), # Spectral Horse
+(29985, 55645, 0, 0, 0, 0, 0, 0, 27892), # Unrelenting Trainee (H)
+(29986, 27825, 0, 0, 0, 0, 0, 0, 27928), # Unrelenting Death Knight (H)
+(29987, 55638, 55608, 0, 0, 0, 0, 0, 27935), # Unrelenting Rider (H)
+(30264, 56407, 0, 0, 0, 0, 0, 0, 0), # Spectral Trainee (H)
+(29990, 56408, 0, 0, 0, 0, 0, 0, 0), # Spectral Death Knight (H)
+(29988, 55646, 27995, 55608, 0, 0, 0, 0, 0), # Spectral Rider (H)
+(29989, 27993, 0, 0, 0, 0, 0, 0, 0) # Spectral Horse (H)
+ON DUPLICATE KEY UPDATE
+spell1 = VALUES(spell1),
+spell2 = VALUES(spell2),
+spell3 = VALUES(spell3),
+spell4 = VALUES(spell4),
+spell5 = VALUES(spell5),
+spell6 = VALUES(spell6),
+spell7 = VALUES(spell7),
+spell8 = VALUES(spell8);
diff --git a/sql/updates/3.0.9_old/3433_world.sql b/sql/updates/3.0.9_old/3433_world.sql
new file mode 100644
index 00000000000..0d5b0eeda61
--- /dev/null
+++ b/sql/updates/3.0.9_old/3433_world.sql
@@ -0,0 +1,10 @@
+UPDATE `instance_template` SET `script` = 'instance_ramparts' WHERE `map` = 543;
+
+UPDATE `creature_template` SET `ScriptName` = 'npc_alexstrasza_wr_gate' WHERE `entry` = 31333;
+
+UPDATE `creature_template` SET `ScriptName` = 'npc_mist' WHERE `entry` = 3568;
+
+DELETE FROM `script_texts` WHERE `entry` IN (-1000411, -1000412);
+INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
+(-1000411, 'Mist! I feared I would never see you again! Yes, I am well, do not worry for me. You must rest and recover your health.', 0, 0, 7, 0, 'mist SAY_AT_HOME'),
+(-1000412, 'growls in acknowledgement before straightening and making her way off into the forest.', 0, 2, 0, 0, 'mist EMOTE_AT_HOME');
diff --git a/sql/updates/3.0.9_old/3451_world_spell_proc_event.sql b/sql/updates/3.0.9_old/3451_world_spell_proc_event.sql
new file mode 100644
index 00000000000..480fcf425c1
--- /dev/null
+++ b/sql/updates/3.0.9_old/3451_world_spell_proc_event.sql
@@ -0,0 +1,11 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (20177, 20179, 20181, 20180, 20182);
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+(20177, 0, 0, 0, 0, 0, 0, 67, 0, 0, 0),
+(20179, 0, 0, 0, 0, 0, 0, 67, 0, 0, 0),
+(20181, 0, 0, 0, 0, 0, 0, 67, 0, 0, 0),
+(20180, 0, 0, 0, 0, 0, 0, 67, 0, 0, 0),
+(20182, 0, 0, 0, 0, 0, 0, 67, 0, 0, 0);
+
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (50720);
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+( 50720, 59665, 0, 'Vigilance (redirect threat)');
diff --git a/sql/updates/3.0.9_old/3466_world_scripts_wintergrasp.sql b/sql/updates/3.0.9_old/3466_world_scripts_wintergrasp.sql
new file mode 100644
index 00000000000..b514fb3aea9
--- /dev/null
+++ b/sql/updates/3.0.9_old/3466_world_scripts_wintergrasp.sql
@@ -0,0 +1,19 @@
+DELETE FROM `spell_script_target` WHERE entry IN
+(56575,56661,56663,56665,56667,56669,61408);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(56575, 1, 27852),
+(56661, 1, 27852),
+(56663, 1, 27852),
+(56665, 1, 27852),
+(56667, 1, 27852),
+(56669, 1, 27852),
+(61408, 1, 27852);
+
+
+update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110 where entry = 28670;
+update creature_template set maxhealth = 30000, minhealth = 30000, speed = 2, spell1=50025, spell2=50989, VehicleId = 36 where entry = 27881;
+update creature_template set maxhealth = 50000, minhealth = 50000, speed = 1.6, spell1=50896, spell2=50652, VehicleId = 106 where entry = 28094;
+update creature_template set maxhealth = 75000, minhealth = 75000, speed = 1, spell1=51678, VehicleId = 117 where entry IN (28312,32627);
+update creature_template set maxhealth = 50000, minhealth = 50000, spell1=51362, VehicleId = 116 where entry IN (28319,32629);
+
+update creature_template set scriptname = "npc_demolisher_engineerer" where entry in (30400,30499);
diff --git a/sql/updates/3.0.9_old/3467_world_spellclick_dk.sql b/sql/updates/3.0.9_old/3467_world_spellclick_dk.sql
new file mode 100644
index 00000000000..a3f3ac90b4b
--- /dev/null
+++ b/sql/updates/3.0.9_old/3467_world_spellclick_dk.sql
@@ -0,0 +1,7 @@
+ALTER TABLE `npc_spellclick_spells`
+  ADD COLUMN `quest_status` int(11) UNSIGNED NOT NULL DEFAULT 3 COMMENT 'Quest status: 3 incompleted, 1 completed/rewarded' AFTER `quest_id`;
+
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN ('29501', '29488');
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES
+('29488', '54568', '12670', '1', '3'),
+('29501', '54575', '12670', '1', '3');
diff --git a/sql/updates/3.0.9_old/3498_world_scripts.sql b/sql/updates/3.0.9_old/3498_world_scripts.sql
new file mode 100644
index 00000000000..2a39f2b29b9
--- /dev/null
+++ b/sql/updates/3.0.9_old/3498_world_scripts.sql
@@ -0,0 +1,12 @@
+UPDATE creature_template SET VehicleId = 312 WHERE entry IN (31857,31858,31861,31862,32212,32213,32633,32640);
+UPDATE creature_template SET VehicleId = 174 WHERE entry IN (31125,31722);
+
+DELETE FROM `spell_linked_spell` WHERE spell_trigger IN (58666,60882);
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+( 58666, 58672, 1, 'Impale (Archavon)'),
+( 60882, 58672, 1, 'Impale (Archavon)');
+
+DELETE FROM `spell_script_target` WHERE entry IN
+(58672);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(58672, 1, 31125);
diff --git a/sql/updates/3.0.9_old/3500_mangos_7879_01_world_spell_proc_event.sql b/sql/updates/3.0.9_old/3500_mangos_7879_01_world_spell_proc_event.sql
new file mode 100644
index 00000000000..9a216e3488a
--- /dev/null
+++ b/sql/updates/3.0.9_old/3500_mangos_7879_01_world_spell_proc_event.sql
@@ -0,0 +1,6 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7855_01_mangos_pools required_7879_01_mangos_spell_proc_event bit;*/
+
+DELETE FROM spell_proc_event WHERE entry IN (31571, 31572);
+INSERT INTO spell_proc_event VALUES
+(31571, 0x00, 3, 0x00000000, 0x00000022, 0x00000000, 0x00004000, 0x00000000, 0.000000, 0.000000, 0),
+(31572, 0x00, 3, 0x00000000, 0x00000022, 0x00000000, 0x00004000, 0x00000000, 0.000000, 0.000000, 0);
diff --git a/sql/updates/3.0.9_old/3508_mangos_7886_01_world_petcreateinfo_spell.sql b/sql/updates/3.0.9_old/3508_mangos_7886_01_world_petcreateinfo_spell.sql
new file mode 100644
index 00000000000..6adcc12a39e
--- /dev/null
+++ b/sql/updates/3.0.9_old/3508_mangos_7886_01_world_petcreateinfo_spell.sql
@@ -0,0 +1,3 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7884_02_mangos_playercreateinfo_action required_7886_01_mangos_petcreateinfo_spell bit;*/
+
+DROP TABLE IF EXISTS `petcreateinfo_spell`;
diff --git a/sql/updates/3.0.9_old/3508_mangos_7887_01_characters_character_pet.sql b/sql/updates/3.0.9_old/3508_mangos_7887_01_characters_character_pet.sql
new file mode 100644
index 00000000000..4b0052cbed9
--- /dev/null
+++ b/sql/updates/3.0.9_old/3508_mangos_7887_01_characters_character_pet.sql
@@ -0,0 +1,4 @@
+/*ALTER TABLE character_db_version CHANGE COLUMN required_7884_05_characters_character_action required_7887_01_characters_character_pet bit;*/
+
+ALTER TABLE `character_pet`
+  DROP TeachSpelldata;
diff --git a/sql/updates/3.0.9_old/3535_TC1_1509_world_scripts.sql b/sql/updates/3.0.9_old/3535_TC1_1509_world_scripts.sql
new file mode 100644
index 00000000000..1dcf1500f5f
--- /dev/null
+++ b/sql/updates/3.0.9_old/3535_TC1_1509_world_scripts.sql
@@ -0,0 +1,2 @@
+UPDATE `gameobject_template` SET `ScriptName` = 'kalecgos_teleporter' WHERE `entry`=187055;
+UPDATE `creature_template` SET `ScriptName` = 'boss_kalecgos_kj' WHERE `entry`=25319;
diff --git a/sql/updates/3.0.9_old/3576_world_spell_script_target.sql b/sql/updates/3.0.9_old/3576_world_spell_script_target.sql
new file mode 100644
index 00000000000..37d786bc129
--- /dev/null
+++ b/sql/updates/3.0.9_old/3576_world_spell_script_target.sql
@@ -0,0 +1,8 @@
+-- Teleports in dk starting area
+DELETE FROM `spell_script_target` WHERE entry IN
+(54699,54725,54744,54746);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(54699,1,0),
+(54725,1,0),
+(54744,1,0),
+(54746,1,0);
diff --git a/sql/updates/3.0.9_old/3577_world_spell_target_position.sql b/sql/updates/3.0.9_old/3577_world_spell_target_position.sql
new file mode 100644
index 00000000000..35190cdaca0
--- /dev/null
+++ b/sql/updates/3.0.9_old/3577_world_spell_target_position.sql
@@ -0,0 +1,5 @@
+-- positions for teleports in acherus
+DELETE FROM `spell_target_position` WHERE `id` IN (54744,54746);
+INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
+(54744, 0, 2418.67, -5621.41, 420.644, 3.89597),
+(54746, 0, 2402.15, -5633.74, 377.021, 3.65249);
diff --git a/sql/updates/3.0.9_old/3587_mangos_7893_01_world_command.sql b/sql/updates/3.0.9_old/3587_mangos_7893_01_world_command.sql
new file mode 100644
index 00000000000..8212b0743b2
--- /dev/null
+++ b/sql/updates/3.0.9_old/3587_mangos_7893_01_world_command.sql
@@ -0,0 +1,7 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7886_01_mangos_petcreateinfo_spell required_7893_01_mangos_command bit;*/
+
+DELETE FROM `command` WHERE `name` IN ('guild create','guild delete','guild invite');
+INSERT INTO `command` VALUES
+('guild create',2,'Syntax: .guild create [$GuildLeaderName] "$GuildName"\r\n\r\nCreate a guild named $GuildName with the player $GuildLeaderName (or selected) as leader.  Guild name must in quotes.'),
+('guild invite',2,'Syntax: .guild invite [$CharacterName] "$GuildName"\r\n\r\nAdd player $CharacterName (or selected) into a guild $GuildName. Guild name must in quotes.'),
+('guild delete',2,'Syntax: .guild delete "$GuildName"\r\n\r\nDelete guild $GuildName. Guild name must in quotes.');
diff --git a/sql/updates/3.0.9_old/3592_world_spell_dk.sql b/sql/updates/3.0.9_old/3592_world_spell_dk.sql
new file mode 100644
index 00000000000..70893090598
--- /dev/null
+++ b/sql/updates/3.0.9_old/3592_world_spell_dk.sql
@@ -0,0 +1,8 @@
+DELETE FROM `spell_script_target` WHERE entry IN (51859);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(51859, 1, 28525), -- siphon of archerus
+(51859, 1, 28542),
+(51859, 1, 28543),
+(51859, 1, 28544);
+UPDATE `creature_template` SET `spell5`=51890 WHERE `entry`=28511; -- Eye of Acherus flight
+UPDATE `creature_template` SET `minlevel`=50,`maxlevel`=52,`minhealth`=2215,`maxhealth`=2317,`faction_A`=2084,`faction_H`=2084,`mindmg`=50,`maxdmg`=50 WHERE `entry`=28528; -- ghoul
diff --git a/sql/updates/3.0.9_old/3593_world_spellclick_dk.sql b/sql/updates/3.0.9_old/3593_world_spellclick_dk.sql
new file mode 100644
index 00000000000..d8baab52f26
--- /dev/null
+++ b/sql/updates/3.0.9_old/3593_world_spellclick_dk.sql
@@ -0,0 +1,4 @@
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN ('29501', '29488');
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES
+('29488', '54568', '12670', '1', '3'),
+('29501', '54575', '12670', '1', '3');
diff --git a/sql/updates/3.0.9_old/3596_world_scripts.sql b/sql/updates/3.0.9_old/3596_world_scripts.sql
new file mode 100644
index 00000000000..14eafdb22db
--- /dev/null
+++ b/sql/updates/3.0.9_old/3596_world_scripts.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `ScriptName`='npc_death_knight_initiate' WHERE `entry`=28406;
diff --git a/sql/updates/3.0.9_old/3601_world.sql b/sql/updates/3.0.9_old/3601_world.sql
new file mode 100644
index 00000000000..1b1eab149cb
--- /dev/null
+++ b/sql/updates/3.0.9_old/3601_world.sql
@@ -0,0 +1,8 @@
+UPDATE `creature_template` SET `VehicleId`=200 WHERE `entry` IN (28605,28606,28607);
+UPDATE `creature_template` SET `ScriptName`='npc_salanar_the_horseman' WHERE `entry`=28653;
+
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (28605,28606,28607);
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES
+(28605, 52263, 12680, 3, 1),
+(28606, 52263, 12680, 3, 1),
+(28607, 52263, 12680, 3, 1);
diff --git a/sql/updates/3.0.9_old/3603_mangos_7896_01_world_creature_template.sql b/sql/updates/3.0.9_old/3603_mangos_7896_01_world_creature_template.sql
new file mode 100644
index 00000000000..22342e85057
--- /dev/null
+++ b/sql/updates/3.0.9_old/3603_mangos_7896_01_world_creature_template.sql
@@ -0,0 +1,4 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7893_01_mangos_command required_7896_01_mangos_creature_template bit;*/
+
+ALTER TABLE creature_template CHANGE COLUMN class trainer_class tinyint(3) unsigned NOT NULL default '0';
+ALTER TABLE creature_template CHANGE COLUMN race trainer_race tinyint(3) unsigned NOT NULL default '0';
diff --git a/sql/updates/3.0.9_old/3609_mangos_7902_01_world_pool_creature.sql b/sql/updates/3.0.9_old/3609_mangos_7902_01_world_pool_creature.sql
new file mode 100644
index 00000000000..ec1d63a48b0
--- /dev/null
+++ b/sql/updates/3.0.9_old/3609_mangos_7902_01_world_pool_creature.sql
@@ -0,0 +1,4 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7896_01_mangos_creature_template required_7902_01_mangos_pool_creature bit;*/
+
+ALTER TABLE `pool_creature` 
+   ADD INDEX `idx_guid`(`guid`);
diff --git a/sql/updates/3.0.9_old/3609_mangos_7902_02_world_pool_gameobject.sql b/sql/updates/3.0.9_old/3609_mangos_7902_02_world_pool_gameobject.sql
new file mode 100644
index 00000000000..3935a14bc23
--- /dev/null
+++ b/sql/updates/3.0.9_old/3609_mangos_7902_02_world_pool_gameobject.sql
@@ -0,0 +1,4 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7902_01_mangos_pool_creature required_7902_02_mangos_pool_gameobject bit;*/
+
+ALTER TABLE `pool_gameobject` 
+   ADD INDEX `idx_guid`(`guid`);
diff --git a/sql/updates/3.0.9_old/3612_world_spell_dk.sql b/sql/updates/3.0.9_old/3612_world_spell_dk.sql
new file mode 100644
index 00000000000..80d7e240afb
--- /dev/null
+++ b/sql/updates/3.0.9_old/3612_world_spell_dk.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_script_target` WHERE entry IN (52124);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(52124, 1, 28655);
+UPDATE `creature_template` SET spell1=52372,spell2=52373,spell3=52374,spell4=52375 WHERE `entry`=28406;
diff --git a/sql/updates/3.0.9_old/3618_mangos_7903_01_characters_character_pet.sql b/sql/updates/3.0.9_old/3618_mangos_7903_01_characters_character_pet.sql
new file mode 100644
index 00000000000..952ec786d84
--- /dev/null
+++ b/sql/updates/3.0.9_old/3618_mangos_7903_01_characters_character_pet.sql
@@ -0,0 +1,4 @@
+/*ALTER TABLE character_db_version CHANGE COLUMN required_7887_01_characters_character_pet required_7903_01_characters_character_pet bit;*/
+
+ALTER TABLE `character_pet`
+  DROP `talentpoints`;
diff --git a/sql/updates/3.0.9_old/3619_mangos_7904_01_world_creature_template.sql b/sql/updates/3.0.9_old/3619_mangos_7904_01_world_creature_template.sql
new file mode 100644
index 00000000000..dd66056155f
--- /dev/null
+++ b/sql/updates/3.0.9_old/3619_mangos_7904_01_world_creature_template.sql
@@ -0,0 +1,9 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7902_02_mangos_pool_gameobject required_7904_01_mangos_creature_template bit;*/
+
+ALTER TABLE creature_template
+  ADD COLUMN dmg_multiplier float NOT NULL default '1' AFTER attackpower;
+
+UPDATE creature_template SET mindmg      = round(mindmg + attackpower / 14);
+UPDATE creature_template SET maxdmg      = round(maxdmg + attackpower / 14);
+UPDATE creature_template SET attackpower = round((maxdmg + mindmg) * 0.3);
+UPDATE creature_template SET mindmg      = round(mindmg * 0.7), maxdmg = round(maxdmg * 0.7);
diff --git a/sql/updates/3.0.9_old/3632_mangos_7908_world_creature_template.sql b/sql/updates/3.0.9_old/3632_mangos_7908_world_creature_template.sql
new file mode 100644
index 00000000000..8d540290954
--- /dev/null
+++ b/sql/updates/3.0.9_old/3632_mangos_7908_world_creature_template.sql
@@ -0,0 +1,21 @@
+ALTER TABLE creature_template ADD COLUMN unit_class tinyint(3) unsigned NOT NULL default '0' AFTER rangeattacktime;
+
+UPDATE creature_template ct
+JOIN creature c ON ct.entry=c.id
+JOIN creature_addon ad ON c.guid=ad.guid
+SET ct.unit_class=(ad.bytes0 & 0x0000FF00) >> 8
+WHERE ct.entry=c.id AND ct.unit_class=0;
+
+UPDATE creature_template ct
+JOIN creature_template_addon ad ON ct.entry=ad.entry
+SET ct.unit_class=(ad.bytes0 & 0x0000FF00) >> 8
+WHERE ct.entry=ad.entry AND ct.unit_class=0;
+
+UPDATE creature_template a1, creature_template a2 SET a1.unit_class=a2.unit_class WHERE a1.unit_class=0 AND a2.unit_class!=0 AND a1.entry=a2.heroic_entry;
+UPDATE creature_template a1, creature_template a2 SET a1.unit_class=a2.unit_class WHERE a1.unit_class=0 AND a2.unit_class!=0 AND a2.entry=a1.heroic_entry;
+
+ALTER TABLE creature_addon
+  DROP COLUMN bytes0;
+
+ALTER TABLE creature_template_addon
+  DROP COLUMN bytes0;
diff --git a/sql/updates/3.0.9_old/3637_world_spell.sql b/sql/updates/3.0.9_old/3637_world_spell.sql
new file mode 100644
index 00000000000..c2fe66a5df1
--- /dev/null
+++ b/sql/updates/3.0.9_old/3637_world_spell.sql
@@ -0,0 +1,7 @@
+DELETE FROM `playercreateinfo_spell` WHERE Spell = 56816;
+INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
+(0, 6, 56816, 'Rune Strike');
+
+DELETE FROM `spell_proc_event` WHERE `entry`=56816;
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+(56816,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00000000,	0x00000030,	0,	0,	0); -- Rune Strike
diff --git a/sql/updates/3.0.9_old/3643_world_wintergrasp.sql b/sql/updates/3.0.9_old/3643_world_wintergrasp.sql
new file mode 100644
index 00000000000..e5c365d175e
--- /dev/null
+++ b/sql/updates/3.0.9_old/3643_world_wintergrasp.sql
@@ -0,0 +1,12 @@
+DELETE FROM `spell_script_target` WHERE entry IN (54643);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(54643,1,23472);
+
+DELETE FROM `game_event` WHERE `entry` IN (50,51);
+INSERT INTO `game_event` (`entry`, `description`, `world_event`) VALUES
+(50, 'Wintergrasp Alliance Defence', 5),
+(51, 'Wintergrasp Horde Defence', 5);
+
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (54643);
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+( 54643,-54643, 2, 'Wintergrasp Defender Teleport');
diff --git a/sql/updates/3.0.9_old/3648_world_trinity_string_full.sql b/sql/updates/3.0.9_old/3648_world_trinity_string_full.sql
new file mode 100644
index 00000000000..00b14ab46be
--- /dev/null
+++ b/sql/updates/3.0.9_old/3648_world_trinity_string_full.sql
@@ -0,0 +1,801 @@
+DROP TABLE IF EXISTS `trinity_string`;
+CREATE TABLE `trinity_string` (
+  `entry` mediumint(8) unsigned NOT NULL default '0',
+  `content_default` text NOT NULL,
+  `content_loc1` text,
+  `content_loc2` text,
+  `content_loc3` text,
+  `content_loc4` text,
+  `content_loc5` text,
+  `content_loc6` text,
+  `content_loc7` text,
+  `content_loc8` text,
+  PRIMARY KEY  (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES
+(1, 'You should select a character or a creature.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(2, 'You should select a creature.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(3, '|cffff0000[System Message]: %s|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(4, '|cffff0000[Event Message]: %s|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(5, 'There is no help for that command', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6, 'There is no such command', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(7, 'There is no such subcommand', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(8, 'Command %s have subcommands:%s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(9, 'Commands available to you:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10, 'Incorrect syntax.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(11, 'Your account level is: %i', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(12, 'Online players: %u (max: %u) Queued players: %u (max: %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(13, 'Server uptime: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(14, 'Player saved.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(15, 'All players saved.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(16, 'There are the following active GMs on this server:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(17, 'There are no GMs currently logged in on this server.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(18, 'Cannot do that while flying.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(19, 'Cannot do that in Battlegrounds.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(20, 'Target is flying you can''t do that.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(21, '%s is flying command failed.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(22, 'You are not mounted so you can''t dismount.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(23, 'Cannot do that while fighting.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(24, 'You used it recently.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(25, 'Password not changed (unknown error)!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(26, 'The password was changed', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(27, 'The new passwords do not match or the old password is wrong', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(28, 'Your account is now locked.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(29, 'Your account is now unlocked.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(30, ', rank ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(31, ' [known]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(32, ' [learn]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(33, ' [passive]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(34, ' [talent]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(35, ' [active]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(36, ' [complete]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(37, ' (offline)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(38, 'on', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(39, 'off', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(40, 'You are: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(41, 'visible', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(42, 'invisible', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(43, 'done', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(44, 'You', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(45, ' <unknown> ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(46, '<error>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(47, '<non-existing character>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(48, 'UNKNOWN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(49, 'You must be at least level %u to enter.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(50, 'You must be at least level %u and have item %s to enter.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(51, 'Hello! Ready for some training?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(52, 'Invaid item count (%u) for item %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(53, 'Mail can''t have more %u item stacks', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(54, 'The new passwords do not match', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(55, 'Your password can''t be longer than 16 characters (client limit), password not changed!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(56, 'Current Message of the day: \r\n%s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(57, 'Using World DB: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(58, 'Using script library: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(100, 'Global notify: ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(101, 'Map: %u (%s) Zone: %u (%s) Area: %u (%s) Phase: %u\nX: %f Y: %f Z: %f Orientation: %f\ngrid[%u,%u]cell[%u,%u] InstanceID: %u\n ZoneX: %f ZoneY: %f\nGroundZ: %f FloorZ: %f Have height data (Map: %u VMap: %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(102, '%s is already being teleported.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(103, 'You can summon a player to your instance only if he is in your party with you as leader.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(104, 'You cannot go to the player''s instance because you are in a party now.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(105, 'You can go to the player''s instance while not being in his party only if your GM mode is on.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(106, 'You can not go to player %s from instance to instance.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(107, 'You can not summon player %s from instance to instance.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(108, 'You are summoning %s%s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(109, 'You are being summoned by %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(110, 'You are teleporting %s%s to %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(111, 'You are being teleported by %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(112, 'Player (%s) does not exist.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(113, 'Appearing at %s''s location.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(114, '%s is appearing to your location.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(115, 'Incorrect values.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(116, 'No character selected.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(117, '%s is not in a group.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(118, 'You changed HP of %s to %i/%i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(119, '%s changed your HP to %i/%i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(120, 'You changed MANA of %s to %i/%i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(121, '%s changed your MANA to %i/%i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(122, 'You changed ENERGY of %s to %i/%i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(123, '%s changed your ENERGY to %i/%i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(124, 'Current energy: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(125, 'You changed rage of %s to %i/%i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(126, '%s changed your rage to %i/%i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(127, 'You changed level of %s to %i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(128, 'GUID %i, faction is %i, flags is %i, npcflag is %i, DY flag is %i', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(129, 'Wrong faction: %u (not found in factiontemplate.dbc).', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(130, 'You changed GUID=%i ''s Faction to %i, flags to %i, npcflag to %i, dyflag to %i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(131, 'You changed the spellflatid=%i, val= %i, mark =%i to %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(132, '%s changed your spellflatid=%i, val= %i, mark =%i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(133, '%s has access to all taxi nodes now (until logout).', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(134, '%s has no more access to all taxi nodes now (only visited accessible).', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(135, '%s has given you access to all taxi nodes (until logout).', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(136, '%s has removed access to all taxi nodes (only visited still accessible).', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(137, 'You set all speeds to %2.2f from normal of %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(138, '%s set all your speeds to %2.2f from normal.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(139, 'You set the speed to %2.2f from normal of %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(140, '%s set your speed to %2.2f from normal.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(141, 'You set the swim speed to %2.2f from normal of %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(142, '%s set your swim speed to %2.2f from normal.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(143, 'You set the backwards run speed to %2.2f from normal of %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(144, '%s set your backwards run speed to %2.2f from normal.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(145, 'You set the fly speed to %2.2f from normal of %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(146, '%s set your fly speed to %2.2f from normal.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(147, 'You set the size %2.2f of %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(148, '%s set your size to %2.2f.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(149, 'There is no such mount.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(150, 'You give a mount to %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(151, '%s gave you a mount.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(152, 'USER1: %i, ADD: %i, DIF: %i\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(153, 'You take all copper of %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(154, '%s took you all of your copper.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(155, 'You take %i copper from %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(156, '%s took %i copper from you.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(157, 'You give %i copper to %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(158, '%s gave you %i copper.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(159, 'You hear sound %u.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(160, 'USER2: %i, ADD: %i, RESULT: %i\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(161, 'Removed bit %i in field %i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(162, 'Set bit %i in field %i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(163, 'Teleport location table is empty!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(164, 'Teleport location not found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(165, 'Requires search parameter.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(166, 'There are no teleport locations matching your request.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(168, 'Locations found are:\n%s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(169, 'Mail sent to %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(170, 'You try to hear sound %u but it doesn''t exist.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(172, 'server console command', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(173, 'You changed runic power of %s to %i/%i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(174, '%s changed your runic power to %i/%i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(200, 'No selection.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(201, 'Object GUID is: lowpart %u highpart %X', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(202, 'The name was too long by %i characters.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(203, 'Error, name can only contain characters A-Z and a-z.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(204, 'The subname was too long by %i characters.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(205, 'Not yet implemented', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(206, 'Item ''%i'' ''%s'' added to list with maxcount ''%i'' and incrtime ''%i'' and extendedcost ''%i''', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(207, 'Item ''%i'' not found in database.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(208, 'Item ''%i'' ''%s'' deleted from vendor list', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(209, 'Item ''%i'' not found in vendor list.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(210, 'Item ''%i'' already in vendor list.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(211, 'Spells of %s reset.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(212, 'Spells of %s will reset at next login.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(213, 'Talents of %s reset.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(214, 'Talents of %s will reset at next login.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(215, 'Your spells have been reset.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(216, 'Your talents have been reset.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(217, 'Unknown case ''%s'' for .resetall command. Type full correct case name.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(218, 'Spells will reset for all players at login. Strongly recommend re-login!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(219, 'Talents will reset for all players at login. Strongly recommend re-login!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(220, 'Creature (GUID: %u) No waypoint found.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(221, 'Creature (GUID: %u) Last waypoint not found.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(222, 'Creature (GUID: %u) No waypoint found - used ''wpguid''. Now trying to find it by its position...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(223, 'Creature (GUID: %u) No waypoints found - This is a MaNGOS db problem (single float).', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(224, 'Selected creature is ignored - provided GUID is used', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(225, 'Creature (GUID: %u) not found', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(226, 'You must select a visual waypoint.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(227, 'No visual waypoints found', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(228, 'Could not create visual waypoint with creatureID: %d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(229, 'All visual waypoints removed', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(230, 'Could not create waypoint-creature with ID: %d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(231, 'No GUID provided.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(232, 'No waypoint number provided.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(233, 'Argument required for ''%s''.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(234, 'Waypoint %i added to GUID: %d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(235, 'Waypoint %d added.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(236, 'Waypoint changed.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(237, 'Waypoint %s modified.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(238, 'WP export successfull.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(239, 'No waypoints found inside the database.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(240, 'File imported.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(241, 'Waypoint removed.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(242, 'Warning: Could not delete WP from the world with ID: %d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(243, 'This happens if the waypoint is too far away from your char.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(244, 'The WP is deleted from the database, but not from the world here.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(245, 'They will disappear after a server restart.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(246, 'Waypoint %d: Info for creature: %s, GUID: %d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(247, 'Waittime: %d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(248, 'Model %d: %d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(249, 'Emote: %d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(250, 'Spell: %d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(251, 'Text%d (ID: %i): %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(252, 'AIScript: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(253, 'Forced rename for player %s will be requested at next login.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(254, 'Forced rename for player %s (GUID #%u) will be requested at next login.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(255, 'Waypoint-Creature (GUID: %u) Not found', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(256, 'Could not find NPC...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(257, 'Creature movement type set to ''%s'', waypoints removed (if any).', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(258, 'Creature movement type set to ''%s'', waypoints were not removed.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(259, 'Incorrect value, use on or off', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(260, 'Value saved.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(261, 'Value saved, you may need to rejoin or clean your client cache.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(262, 'Areatrigger ID %u not found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(263, 'Target map or coordinates is invalid (X: %f Y: %f MapId: %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(264, 'Zone coordinates is invalid (X: %f Y: %f AreaId: %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(265, 'Zone %u (%s) is part of instanceable map %u (%s)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(266, 'Nothing found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(267, 'Object not found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(268, 'Creature not found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(269, 'Warning: Mob found more than once - you will be teleported to the first one found in DB.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(270, 'Creature Removed', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(271, 'Creature moved.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(272, 'Creature (GUID:%u) must be on the same map as player!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(273, 'Game Object (GUID: %u) not found', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(274, 'Game Object (GUID: %u) has references in not found creature %u GO list, can''t be deleted.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(275, 'Game Object (GUID: %u) removed', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(277, 'Game Object |cffffffff|Hgameobject:%d|h[%s]|h|r (GUID: %u) moved', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(278, 'You must select a vendor', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(279, 'You must send id for item', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(280, 'Vendor has too many items (max 128)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(281, 'You can''t kick self, logout instead', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(282, 'Player %s kicked.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(5011, 'You can''t teleport self to self!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(284, 'Accepting Whisper: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(285, 'Accepting Whisper: ON', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(286, 'Accepting Whisper: OFF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(287, 'Creature (GUID: %u) not found', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(288, 'Tickets count: %i show new tickets: %s\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(289, 'New ticket from %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(290, 'Ticket of %s (Last updated: %s):\n%s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(291, 'New ticket show: ON', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(292, 'New ticket show: OFF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(293, 'Ticket %i doesn''t exist', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(294, 'All tickets deleted.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(295, 'Character %s ticket deleted.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(296, 'Ticket deleted.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(297, 'Spawn distance changed to: %f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(298, 'Spawn time changed to: %i', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(299, 'The honor of %s was set to %u!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(300, 'Your chat has been disabled for %u minutes.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(301, 'You have disabled %s''s chat for %u minutes.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(302, 'Player''s chat is already enabled.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(303, 'Your chat has been enabled.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(304, 'You have enabled %s''s chat.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(305, 'Faction %s (%u) reputation of %s was set to %5d!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(306, 'The arena points of %s was set to %u!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(307, 'No faction found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(308, 'Faction %i unknown!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(309, 'Invalid parameter %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(310, 'delta must be between 0 and %d (inclusive)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(311, '%d - |cffffffff|Hfaction:%d|h[%s]|h|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(312, ' [visible]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(313, ' [at war]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(314, ' [peace forced]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(315, ' [hidden]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(316, ' [invisible forced]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(317, ' [inactive]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(318, 'Hated', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(319, 'Hostile', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(320, 'Unfriendly', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(321, 'Neutral', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(322, 'Friendly', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(323, 'Honored', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(324, 'Revered', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(325, 'Exalted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(326, 'Faction %s (%u) can''not have reputation.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(327, ' [no reputation]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(328, 'Characters at account %s (Id: %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(329, '  %s (GUID %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(330, 'No players found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(331, 'Extended item cost %u not exist', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(332, 'GM mode is ON', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(333, 'GM mode is OFF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(334, 'GM Chat Badge is ON', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(335, 'GM Chat Badge is OFF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(336, 'You repair all %s''s items.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(337, 'All your items repaired by %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(338, 'You set waterwalk mode %s for %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(339, 'Your waterwalk mode %s by %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(340, '%s is now following you.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(341, '%s is not following you.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(342, '%s is now not following you.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(343, 'Creature (Entry: %u) cannot be tamed.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(344, 'You already have pet.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(345, 'Forced customize for player %s will be requested at next login.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(346, 'Forced customize for player %s (GUID #%u) will be requested at next login.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(400, '|cffff0000[System Message]:|rScripts reloaded', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(401, 'You change security level of account %s to %i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(402, '%s changed your security level to %i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(403, 'You have low security level for this.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(404, 'Creature movement disabled.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(405, 'Creature movement enabled.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(406, 'Weather can''t be changed for this zone.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(407, 'Weather system disabled at server.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(408, '%s is banned for %s. Reason: %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(409, '%s is banned permanently for %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(410, '%s %s not found', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(411, '%s unbanned.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(412, 'There was an error removing the ban on %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(413, 'Account not exist: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(414, 'There is no such character.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(415, 'There is no such IP in banlist.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(416, 'Account %s has never been banned', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(417, 'Ban history for account %s:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(418, 'Ban Date: %s Bantime: %s Still active: %s  Reason: %s Set by: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(419, 'Inf.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(420, 'Never', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(421, 'Yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(422, 'No', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(423, 'IP: %s\nBan Date: %s\nUnban Date: %s\nRemaining: %s\nReason: %s\nSet by: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(424, 'There is no matching IPban.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(425, 'There is no matching account.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(426, 'There is no banned account owning a character matching this part.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(427, 'The following IPs match your pattern:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(428, 'The following accounts match your query:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(429, 'You learned many spells/skills.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(430, 'You learned all spells for class.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(431, 'You learned all talents for class.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(432, 'You learned all languages.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(433, 'You learned all craft skills and recipes.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(434, 'Could not find ''%s''', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(435, 'Invalid item id: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(436, 'No items found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(437, 'Invalid gameobject id: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(438, 'Found items %u: %u ( inventory %u mail %u auction %u guild %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(439, 'Found gameobjects %u: %u ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(440, 'Invalid creature id: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(441, 'Found creatures %u: %u ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(442, 'No area found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(443, 'No item sets found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(444, 'No skills found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(445, 'No spells found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(446, 'No quests found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(447, 'No creatures found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(448, 'No gameobjects found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(449, 'Graveyard #%u doesn''t exist.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(450, 'Graveyard #%u already linked to zone #%u (current).', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(451, 'Graveyard #%u linked to zone #%u (current).', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(452, 'Graveyard #%u can''t be linked to subzone or not existed zone #%u (internal error).', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(454, 'No faction in Graveyard with id= #%u , fix your DB', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(455, 'invalid team, please fix database', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(456, 'any', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(457, 'alliance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(458, 'horde', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(459, 'Graveyard #%u (faction: %s) is nearest from linked to zone #%u.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(460, 'Zone #%u doesn''t have linked graveyards.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(461, 'Zone #%u doesn''t have linked graveyards for faction: %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(462, 'Teleport location already exists!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(463, 'Teleport location added.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(464, 'Teleport location NOT added: database error.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(465, 'Teleport location deleted.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(467, 'Target unit has %d auras:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(468, 'id: %d effmask: %d charges: %d stack: %d slot %d duration: %d maxduration: %d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(469, 'Target unit has %d auras of type %d:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(470, 'id: %d eff: %d amount: %d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(471, 'Quest %u not found.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(472, 'Quest %u started from item. For correct work, please, add item to inventory and start quest in normal way: .additem %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(473, 'Quest removed.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(474, ' [rewarded]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(475, ' [complete]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(476, ' [active]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(477, '%s''s Fly Mode %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(478, 'Opcode %u sent to %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(479, 'Character loaded successfully!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(480, 'Failed to load the character!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(481, 'Character dumped successfully!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(482, 'Character dump failed!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(483, 'Spell %u broken and not allowed to cast or learn!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(484, 'Skill %u (%s) for player %s set to %u and current maximum set to %u (without permanent (talent) bonuses).', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(485, 'Player %s must have skill %u (%s) before using this command.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(486, 'Invalid skill id (%u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(487, 'You learned default GM spells/skills.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(488, 'You already know that spell.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(489, 'Target(%s) already know that spell.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(490, '%s doesn''t know that spell.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(491, 'You already forgot that spell.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(492, 'All spell cooldowns removed for %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(493, 'Spell %u cooldown removed for %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(494, 'Command : Additem, itemId = %i, amount = %i', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(495, 'Command : Additemset, itemsetId = %i', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(496, 'Removed itemID = %i, amount = %i from %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(497, 'Cannot create item ''%i'' (amount: %i)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(498, 'You need to provide a guild name!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(499, 'Player not found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(500, 'Player already has a guild!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(501, 'Guild not created! (already exists?)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(502, 'No items from itemset ''%u'' found.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(503, 'The distance is: (3D) %f (2D) %f yards.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(504, 'Item ''%i'' ''%s'' Item Slot %i', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(505, 'Item ''%i'' doesn''t exist.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(506, 'Item ''%i'' ''%s'' Added to Slot %i', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(507, 'Item save failed!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(508, '%d - owner: %s (guid: %u account: %u ) %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(509, '%d - sender: %s (guid: %u account: %u ) receiver: %s (guid: %u account: %u ) %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(510, '%d - owner: %s (guid: %u account: %u ) %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(511, 'Wrong link type!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(512, '%d - |cffffffff|Hitem:%d:0:0:0:0:0:0:0|h[%s]|h|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(513, '%d - |cffffffff|Hquest:%d|h[%s]|h|r %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(514, '%d - |cffffffff|Hcreature_entry:%d|h[%s]|h|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(515, '%d - |cffffffff|Hcreature:%d|h[%s X:%f Y:%f Z:%f MapId:%d]|h|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(516, '%d - |cffffffff|Hgameobject_entry:%d|h[%s]|h|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(517, '%d - |cffffffff|Hgameobject:%d|h[%s X:%f Y:%f Z:%f MapId:%d]|h|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(518, '%d - |cffffffff|Hitemset:%d|h[%s %s]|h|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(519, '|cffffffff|Htele:%s|h[%s]|h|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(520, '%d - |cffffffff|Hspell:%d|h[%s]|h|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(521, '%d - |cffffffff|Hskill:%d|h[%s %s]|h|r %s %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(522, 'Game Object (GUID: %u) not found', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(523, '>> Game Object %s (GUID: %u) at %f %f %f. Orientation %f.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(276, 'Game Object |cffffffff|Hgameobject:%d|h[%s]|h|r (GUID: %u) turned', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(525, '>> Add Game Object ''%i'' (%s) (GUID: %i) added at ''%f %f %f''.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(526, '%s (lowguid: %u) movement generators stack:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(527, '   Idle', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(528, '   Random', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(529, '   Waypoint', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(530, '   Animal random', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(531, '   Confused', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(532, '   Targeted to player %s (lowguid %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(533, '   Targeted to creature %s (lowguid %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(534, '   Targeted to <NULL>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(535, '   Home movement to (X:%f Y:%f Z:%f)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(536, '   Home movement used for player?!?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(537, '   Taxi flight', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(538, '   Unknown movement generator (%u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(539, 'Player selected NPC\nGUID: %u.\nFaction: %u.\nnpcFlags: %u.\nEntry: %u.\nDisplayID: %u (Native: %u).', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(540, 'Level: %u.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(541, 'Health (base): %u. (max): %u. (current): %u.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(542, 'Field Flags: %u.\nDynamic Flags: %u.\nFaction Template: %u.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(543, 'Loot: %u Pickpocket: %u Skinning: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(544, 'Position: %f %f %f.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(545, '*** Is a vendor!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(546, '*** Is a trainer!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(547, 'InstanceID: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(548, 'Player%s %s (guid: %u) Account: %s (id: %u) GMLevel: %u Last IP: %s Last login: %s Latency: %ums', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(549, 'Played time: %s Level: %u Money: %ug%us%uc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(550, 'Command .pinfo doesn''t support ''rep'' option for offline players.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(551, '%s has explored all zones now.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(552, '%s has no more explored zones.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(553, '%s has explored all zones for you.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(554, '%s has hidden all zones from you.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(555, 'Hover enabled', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(556, 'Hover disabled', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(559, '%s reset your level progress.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(558, '%s level down you to (%i)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(560, 'The area has been set as explored.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(561, 'The area has been set as not explored.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(562, 'GUID=%i ''s updateIndex: %i, value:  %i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(563, 'You change GUID=%i ''s UpdateIndex: %i value to %i.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(564, 'The value index %u is too big to %u(count: %u).', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(565, 'Set %u uint32 Value:[OPCODE]:%u [VALUE]:%u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(566, 'You Set %u Field:%u to uint32 Value: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(567, 'Set %u float Value:[OPCODE]:%u [VALUE]:%f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(568, 'You Set %u Field:%i to float Value: %f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(569, 'Get %u uint32 Value:[OPCODE]:%u [VALUE]:%u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(570, 'The uint32 value of %u in %u is: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(571, 'Get %u float Value:[OPCODE]:%u [VALUE]:%f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(572, 'The float of %u value in %u is: %f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(573, '.Set32Bit:[OPCODE]:%u [VALUE]:%u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(574, 'You set Bit of Field:%u to Value: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(575, '.Mod32Value:[OPCODE]:%u [VALUE]:%i', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(576, 'You modified the value of Field:%u to Value: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(577, 'You are now invisible.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(578, 'You are now visible.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(579, 'Selected player or creature not have victim.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(580, 'Player %s learned all default spells for race/class and completed quests rewarded spells.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(581, 'Found near gameobjects (distance %f): %u ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(582, 'SpawnTime: Full:%s Remain:%s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(583, '%d - |cffffffff|Hgameevent:%d|h[%s]|h|r%s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(584, 'No event found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(585, 'Event not exist!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(586, 'Event %u: %s%s\nStart: %s End: %s Occurence: %s Length: %s\nNext state change: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(587, 'Event %u already active!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(588, 'Event %u not active!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(589, '   Point movement to (X:%f Y:%f Z:%f)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(590, '   Fear movement', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(591, '   Distract movement', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(592, 'You have learned all spells in craft: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(593, 'Currently Banned Accounts:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(594, '|    Account    |   BanDate    |   UnbanDate  |  Banned By    |   Ban Reason  |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(595, 'Currently Banned IPs:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(596, '|      IP       |   BanDate    |   UnbanDate  |  Banned By    |   Ban Reason  |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(597, 'Current gamemasters:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(598, '|    Account    |  GM  |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(599, 'No gamemasters.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(600, 'The Alliance wins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(601, 'The Horde wins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(602, 'The battle for Warsong Gulch begins in 1 minute.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(603, 'The battle for Warsong Gulch begins in 30 seconds. Prepare yourselves!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(604, 'Let the battle for Warsong Gulch begin!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(605, '$n captured the Horde flag!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(606, '$n captured the Alliance flag!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(607, 'The Horde flag was dropped by $n!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(608, 'The Alliance Flag was dropped by $n!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(609, 'The Alliance Flag was returned to its base by $n!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(610, 'The Horde flag was returned to its base by $n!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(611, 'The Horde flag was picked up by $n!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(612, 'The Alliance Flag was picked up by $n!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(613, 'The flags are now placed at their bases.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(680, 'The Horde has lost control of the Blood Elf Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(636, 'The Battle for Eye of the Storm begins in 1 minute.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(637, 'The Battle for Eye of the Storm begins in 30 seconds.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(638, 'The Battle for Eye of the Storm has begun!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(650, 'Alliance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(651, 'Horde', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(652, 'stables', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(653, 'blacksmith', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(654, 'farm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(655, 'lumber mill', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(656, 'mine', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(657, 'The %s has taken the %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(658, '$n has defended the %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(659, '$n has assaulted the %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(660, '$n claims the %s! If left unchallenged, the %s will control it in 1 minute!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(661, 'The Battle for Arathi Basin begins in 1 minute.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(662, 'The Battle for Arathi Basin begins in 30 seconds. Prepare yourselves!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(663, 'The Battle for Arathi Basin has begun!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(664, 'The Alliance has gathered $1776W resources, and is near victory!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(665, 'The Horde has gathered $1777W resources, and is near victory!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(666, 'After your recent battle in %s our best attempts to award you a Mark of Honor failed. Enclosed you will find the Mark of Honor we were not able to deliver to you at the time. Thanks for fighting in %s!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(679, 'The Alliance has lost control of the Blood Elf Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(678, 'The Horde has lost control of the Draenei Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(677, 'The Alliance has lost control of the Draenei Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(676, 'The Horde has lost control of the Mage Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(675, 'The Alliance has lost control of the Mage Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(674, 'The Horde has taken control of the Fel Reaver Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(673, 'The Alliance has taken control of the Fel Reaver Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(672, 'The Horde has taken control of the Blood Elf Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(671, 'The Alliance has taken control of the Blood Elf Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(670, 'The Horde has taken control of the Draenei Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(669, 'The Alliance has taken control of the Draenei Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(668, 'The Horde has taken control of the Mage Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(667, 'The Alliance has taken control of the Mage Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(615, 'The Horde flag is now placed at its base.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(614, 'The Alliance flag is now placed at its base.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(700, 'You must be level %u to form an arena team', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(701, 'One minute until the Arena battle begins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(702, 'Thirty seconds until the Arena battle begins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(703, 'Fifteen seconds until the Arena battle begins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(704, 'The Arena battle has begun!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(705, 'You must wait %s before speaking again.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(706, 'This item(s) have problems with equipping/storing in inventory.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(707, '%s wishes to not be disturbed and cannot receive whisper messages: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(708, '%s is Away from Keyboard: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(709, 'Do not Disturb', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(710, 'Away from Keyboard', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(711, 'Queue status for %s (Lvl: %u to %u)\nQueued alliances: %u (Need at least %u more)\nQueued hordes: %u (Need at least %u more)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(712, '|cffff0000[BG Queue Announcer]:|r %s -- [%u-%u] A: %u/%u, H: %u/%u|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(713, 'You must be level %u to join an arena team!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(715, 'You don''t meet Battleground level requirements', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(717, '|cffff0000[BG Queue Announcer]:|r %s -- [%u-%u] Started!|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(718, '|cffff0000[Arena Queue Announcer]:|r %s -- Joined : %ux%u : %u|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(719, '|cffff0000[Arena Queue Announcer]:|r %s -- Exited : %ux%u : %u|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES
+(720, 'Your group is too large for this battleground. Please regroup to join.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(721, 'Your group is too large for this arena. Please regroup to join.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(722, 'Your group has members not in your arena team. Please regroup to join.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(723, 'Your group does not have enough players to join this match.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(724, 'The Gold Team wins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(725, 'The Green Team wins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(726, 'There aren''t enough players in this battleground. It will end soon unless some more players join to balance the fight.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(727, 'Your group has an offline member. Please remove him before joining.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(728, 'Your group has players from the opposing faction. You can''t join the battleground as a group.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(729, 'Your group has players from different battleground brakets. You can''t join as group.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(730, 'Someone in your party is already in this battleground queue. (S)he must leave it before joining as group.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(731, 'Someone in your party is Deserter. You can''t join as group.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(732, 'Someone in your party is already in three battleground queues. You cannot join as group.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(733, 'You cannot teleport to a battleground or arena map.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(734, 'You cannot summon players to a battleground or arena map.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(735, 'You must be in GM mode to teleport to a player in a battleground.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(736, 'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(737, 'Arenas are set to 1v1 for debugging. So, don''t join as group.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(738, 'Arenas are set to normal playercount.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(739, 'Battlegrounds are set to 1v0 for debugging.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(740, 'Battlegrounds are set to normal playercount.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(741, 'Flushing Arena points based on team ratings, this may take a few minutes. Please stand by...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(742, 'Distributing arena points to players...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(743, 'Finished setting arena points for online players.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(744, 'Modifying played count, arena points etc. for loaded arena teams, sending updated stats to online players...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(745, 'Modification done.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(746, 'Done flushing Arena points.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(785, 'Arena testing turned %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(786, '|cffff0000[Automatic]:|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(787, '|cffffff00[|c1f40af20Announce by|r |cffff0000%s|cffffff00]:|r %s|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(800, 'Invalid name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(801, 'You do not have enough gold', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(802, 'You do not have enough free slots', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(803, 'Your partner does not have enough free bag slots', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(804, 'You do not have permission to perform that function', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(805, 'Unknown language', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(806, 'You don''t know that language', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(807, 'Please provide character name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(808, 'Player %s not found or offline', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(809, 'Account for character %s not found', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1000, 'Exiting daemon...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1001, 'Account deleted: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1002, 'Account %s NOT deleted (probably sql file format was updated)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1003, 'Account %s NOT deleted (unknown error)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1004, 'Account created: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1005, 'Account name can''t be longer than 16 characters (client limit), account not created!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1006, 'Account with this name already exist!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1007, 'Account %s NOT created (probably sql file format was updated)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1008, 'Account %s NOT created (unknown error)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1009, 'Player %s (Guid: %u) Account %s (Id: %u) deleted.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1010, '|    Account    |       Character      |       IP        | GM | Expansion |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1100, 'Account %s (Id: %u) have up to %u expansion allowed now.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1101, 'Message of the day changed to:\r\n%s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1102, 'Message sent to %s: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1103, '%d - %s %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1104, '%d - %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1105, '%d - %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1106, '%d - %s %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1107, '%d - %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1108, '%d - %s %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1109, '%d - %s %s %s %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1110, '%d - %s X:%f Y:%f Z:%f MapId:%d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1111, '%d - %s X:%f Y:%f Z:%f MapId:%d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1112, 'Failed to open file: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1113, 'Account %s (%u) have max amount allowed characters (client limit)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1114, 'Dump file have broken data!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1115, 'Invalid character name!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1116, 'Invalid character guid!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1117, 'Character guid %u in use!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1118, '%d - guild: %s (guid: %u) %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1119, 'You must use male or female as gender.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1120, 'You change gender of %s to %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1121, 'Your gender changed to %s by %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1122, '(%u/%u +perm %u +temp %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1326, 'The Battle for Alterac Valley begins in 1 minute.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1325, 'Frostwolf Relief Hut', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1308, 'The %s has taken the %s! Its supplies will now be used for reinforcements!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1309, 'Irondeep Mine', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1310, 'Coldtooth Mine', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1311, 'Stormpike Aid Station', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1312, 'Dun Baldar South Bunker', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1313, 'Dun Baldar North Bunker', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1314, 'Stormpike Graveyard', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1315, 'Icewing Bunker', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1316, 'Stonehearth Graveyard', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1317, 'Stonehearth Bunker', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1318, 'Snowfall Graveyard', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1319, 'Iceblood Tower', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1320, 'Iceblood Graveyard', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1321, 'Tower Point', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1322, 'Frostwolf Graveyard', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1323, 'East Frostwolf Tower', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1324, 'West Frostwolf Tower', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(2000, '|cff00ff00New ticket from|r|cffff00ff %s.|r |cff00ff00Ticket entry:|r|cffff00ff %d.|r', '', '', '', '', '', '', '', ''),
+(2001, '|cff00ff00Character|r|cffff00ff %s |r|cff00ff00edited his/her ticket:|r|cffff00ff %d.|r', '', '', '', '', '', '', '', ''),
+(2002, '|cff00ff00Character|r|cffff00ff %s |r|cff00ff00abandoned ticket entry:|r|cffff00ff %d.|r', '', '', '', '', '', '', '', ''),
+(2003, '|cff00ff00Closed by|r:|cff00ccff %s|r ', '', '', '', '', '', '', '', ''),
+(2004, '|cff00ff00Deleted by|r:|cff00ccff %s|r ', '', '', '', '', '', '', '', ''),
+(2005, 'Ticket not found.', '', '', '', '', '', '', '', ''),
+(2006, 'Please close ticket before deleting it permanently.', '', '', '', '', '', '', '', ''),
+(2007, 'Ticket %d is already assigned.', '', '', '', '', '', '', '', ''),
+(2008, '%u Tickets succesfully reloaded from the database.', '', '', '', '', '', '', '', ''),
+(2009, 'Showing list of open tickets.', '', '', '', '', '', '', '', ''),
+(2010, 'Showing list of open tickets whose creator is online.', '', '', '', '', '', '', '', ''),
+(2011, 'Showing list of closed tickets.', '', '', '', '', '', '', '', ''),
+(2012, 'Invalid name specified. Name should be that of an online Gamemaster.', '', '', '', '', '', '', '', ''),
+(2013, 'This ticket is already assigned to yourself. To unassign use .ticket unassign %d and then reassign.', '', '', '', '', '', '', '', ''),
+(2014, 'Ticket %d is not assigned, you cannot unassign it.', '', '', '', '', '', '', '', ''),
+(2015, 'You cannot unassign tickets from staffmembers with a higher security level than yourself.', '', '', '', '', '', '', '', ''),
+(2016, 'Cannot close ticket %d, it is assigned to another GM.', '', '', '', '', '', '', '', ''),
+(2017, '|cff00ff00Ticket|r:|cff00ccff %d.|r ', '', '', '', '', '', '', '', ''),
+(2018, '|cff00ff00Created by|r:|cff00ccff %s|r ', '', '', '', '', '', '', '', ''),
+(2019, '|cff00ff00Last change|r:|cff00ccff %s ago|r ', '', '', '', '', '', '', '', ''),
+(2020, '|cff00ff00Assigned to|r:|cff00ccff %s|r ', '', '', '', '', '', '', '', ''),
+(2021, '|cff00ff00Unassigned by|r:|cff00ccff %s|r ', '', '', '', '', '', '', '', ''),
+(2022, '\n|cff00ff00Message|r: "%s"|r ', '', '', '', '', '', '', '', ''),
+(2023, '\n|cff00ff00Comment|r: "%s"|r ', '', '', '', '', '', '', '', ''),
+(2024, '\n|cff00ccff%s|r |cff00ff00Added comment|r: "%s"|r ', '', '', '', '', '', '', '', ''),
+(5000, 'You froze player %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(5001, 'It might be amusing but no... you cant freeze yourself!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(5002, 'Invalid input check the name of target.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(5003, 'You unfroze player %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(5004, 'There are no frozen players.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(5005, 'Following players are frozen on the server:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(5006, '- %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(5009, 'Sound %u Played to server', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6613, '|cfff00000[GM Announcement]: %s|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6614, 'Notification to GM''s - ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6615, '|cffffff00[|c1f40af20GM Announce by|r |cffff0000%s|cffffff00]:|r %s|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10001, 'The Horde has taken The Overlook!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10002, 'The Alliance has taken The Overlook!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10003, 'The Horde has taken The Stadium!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10004, 'The Alliance has taken The Stadium!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10005, 'The Horde has taken Broken Hill!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10006, 'The Alliance has taken Broken Hill!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10007, 'The Horde lost The Overlook!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10008, 'The Alliance lost The Overlook!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10009, 'The Horde lost The Stadium!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10010, 'The Alliance lost The Stadium!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10011, 'The Horde lost Broken Hill!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10012, 'The Alliance lost Broken Hill!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10013, 'The Horde has taken the West Beacon!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10014, 'The Alliance has taken the West Beacon!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10015, 'The Horde has taken the East Beacon!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10016, 'The Alliance has taken the East Beacon!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10017, 'The Horde has captured the Twin Spire Graveyard!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10018, 'The Alliance has captured the Twin Spire Graveyard!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10019, 'The Horde lost the West Beacon!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10020, 'The Alliance lost the West Beacon!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10021, 'The Horde lost the East Beacon!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10022, 'The Alliance lost the East Beacon!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10023, 'The Horde lost the Twin Spire Graveyard!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10024, 'The Alliance lost the Twin Spire Graveyard!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10025, 'The Horde has captured Halaa!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10026, 'The Alliance has captured Halaa!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10027, 'The Horde lost Halaa!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10028, 'The Alliance lost Halaa!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10029, 'The Horde has taken a Spirit Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10030, 'The Alliance has taken a Spirit Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10031, 'The Horde lost a Spirit Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10032, 'The Alliance lost a Spirit Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10033, 'The Horde has taken the Northpass Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10034, 'The Alliance has taken the Northpass Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10035, 'The Horde has taken the Eastwall Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10036, 'The Alliance has taken the Eastwall Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10037, 'The Horde has taken the Crown Guard Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10038, 'The Alliance has taken the Crown Guard Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10039, 'The Horde has taken the Plaguewood Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10040, 'The Alliance has taken the Plaguewood Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10041, 'The Horde lost the Northpass Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10042, 'The Alliance lost the Northpass Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10043, 'The Horde lost the Eastwall Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10044, 'The Alliance lost the Eastwall Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10045, 'The Horde lost the Crown Guard Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10046, 'The Alliance lost the Crown Guard Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10047, 'The Horde lost the Plaguewood Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10048, 'The Alliance lost the Plaguewood Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10049, 'The Horde has collected 200 silithyst!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10050, 'The Alliance has collected 200 silithyst!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10051, 'Take me to Northpass Tower.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10052, 'Take me to Eastwall Tower.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10053, 'Take me to Crown Guard Tower.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10054, 'Give me the flag, I''ll take it to the central beacon for the glory of the Alliance!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(10055, 'Give me the flag, I''ll take it to the central beacon for the glory of the Horde!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(681, 'The Alliance has lost control of the Fel Reaver Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(810, '|Hplayer:$N|h[$N]|h has earned the achievement $a!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(750, 'Not enough players. This game will close in %u mins.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(751, 'Not enough players. This game will close in %u seconds.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(753, 'The battle for Warsong Gulch begins in 2 minutes.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(754, 'The battle for Arathi Basin begins in 2 minutes.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(755, 'The battle for Eye of the Storm begins in 2 minutes.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(811, 'Guild Master', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(812, 'Officer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(813, 'Veteran', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(814, 'Member', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(815, 'Initiate', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(175, 'Liquid level: %f, ground: %f, type: %d, status: %d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(682, 'The Horde has lost control of the Fel Reaver Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(683, '%s has taken the flag!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(684, 'The Alliance have captured the flag!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(685, 'The Horde have captured the flag!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(686, 'The flag has been dropped.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(687, 'The flag has been reset.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(524, 'Selected object:\n|cffffffff|Hgameobject:%d|h[%s]|h|r GUID: %u ID: %u\nX: %f Y: %f Z: %f MapId: %u\nOrientation: %f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(7523, 'WORLD: Denying connections.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(7524, 'WORLD: Accepting connections.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1123, 'Not pet found', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1124, 'Wrong pet type', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1125, 'Your pet learned all talents', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1126, 'Your pet talents have been reset.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1127, 'Talents of %s''s pet reset.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1011, '|<Error>        | %20s |<Error>          |<Er>| <Error>   |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1012, '===========================================================================', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1013, '|%15s| %20s | %15s |%4d| %9d |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1014, 'No online players.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(5007, 'You must be in a raid group to enter this instance.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(59, 'Using creature EventAI: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(2025, '|cff00ff00Created|r:|cff00ccff %s ago|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6616, 'Pet spells will reset for all players at login. Strongly recommend re-login!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1307, 'The %s is under attack! If left unchecked, the %s will capture it!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1305, 'The %s was taken by the %s!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1306, 'The %s was taken by the %s!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1304, 'The %s was taken by the %s!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1303, 'The %s is under attack! If left unchecked, the %s will destroy it!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1302, '%s was destroyed by the %s!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1301, 'Horde', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1300, 'Alliance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(5010, 'linkGUID: %u, Entry: %u (%s)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(466, 'No taxinodes found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1128, '%d - |cffffffff|Htaxinode:%u|h[%s %s]|h|r (Map:%u X:%f Y:%f Z:%f)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1129, '%d - %s %s (Map:%u X:%f Y:%f Z:%f)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(557, '%s level up you to (%i)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1327, 'The Battle for Alterac Valley begins in 30 seconds. Prepare yourselves!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1328, 'The Battle for Alterac Valley has begun!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1329, 'The Alliance Team is running out of reinforcements!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1330, 'The Horde Team is running out of reinforcements!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1331, 'The Frostwolf General is Dead!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1332, 'The Stormpike General is Dead!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1201, 'You try to view movie %u but it doesn''t exist.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(347, 'TaxiNode ID %u not found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(171, 'You can''t teleport self to self!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1200, 'You try to view cinemitic %u but it doesn''t exist.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
diff --git a/sql/updates/3.0.9_old/3649_world.sql b/sql/updates/3.0.9_old/3649_world.sql
new file mode 100644
index 00000000000..c50d778ae4a
--- /dev/null
+++ b/sql/updates/3.0.9_old/3649_world.sql
@@ -0,0 +1,5 @@
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` BETWEEN 184418 AND 184431;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_stasis' WHERE `entry` BETWEEN 185465 AND 185467;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_stasis' WHERE `entry` = 184595;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_stasis' WHERE `entry` BETWEEN 185461 AND 185464;
+UPDATE `creature_template` SET `ScriptName` = 'npc_engineering_tele_trinket' WHERE `entry` IN (14742, 14743, 21493, 21494);
diff --git a/sql/updates/3.0.9_old/3689_TC1_1534_world.sql b/sql/updates/3.0.9_old/3689_TC1_1534_world.sql
new file mode 100644
index 00000000000..cde0c50bf3b
--- /dev/null
+++ b/sql/updates/3.0.9_old/3689_TC1_1534_world.sql
@@ -0,0 +1,2 @@
+UPDATE `creature_template` SET `ScriptName` = 'mob_ethereal_apprentice' WHERE `entry` = 18430;
+DELETE FROM `creature` WHERE `id` = 18431;
diff --git a/sql/updates/3.0.9_old/3691_TC1_919_world.sql b/sql/updates/3.0.9_old/3691_TC1_919_world.sql
new file mode 100644
index 00000000000..644daa2776a
--- /dev/null
+++ b/sql/updates/3.0.9_old/3691_TC1_919_world.sql
@@ -0,0 +1,2 @@
+ALTER TABLE version
+   ADD `core_revision` varchar(120) AFTER `core_version`;
diff --git a/sql/updates/3.0.9_old/3715_mangos_7932_01_characters_character_pet.sql b/sql/updates/3.0.9_old/3715_mangos_7932_01_characters_character_pet.sql
new file mode 100644
index 00000000000..c141dca37ce
--- /dev/null
+++ b/sql/updates/3.0.9_old/3715_mangos_7932_01_characters_character_pet.sql
@@ -0,0 +1,9 @@
+/*ALTER TABLE character_db_version CHANGE COLUMN required_7903_01_characters_character_pet required_7932_01_characters_character_pet bit;*/
+
+UPDATE character_pet
+  SET abdata = CONCAT(REPLACE(TRIM(abdata),'  ',' '),' ');
+
+UPDATE character_pet
+  SET abdata = SUBSTRING_INDEX(SUBSTRING_INDEX(abdata,' ',(10-3)*2),' ',-(10-3-3)*2)
+  WHERE length(SUBSTRING_INDEX(abdata, ' ', 20)) < length(abdata) and length(SUBSTRING_INDEX(abdata, ' ', 21)) >= length(abdata);
+  
+\ No newline at end of file
diff --git a/sql/updates/3.0.9_old/3724_world.sql b/sql/updates/3.0.9_old/3724_world.sql
new file mode 100644
index 00000000000..1269925e0ee
--- /dev/null
+++ b/sql/updates/3.0.9_old/3724_world.sql
@@ -0,0 +1,10 @@
+-- Vehicle and summon spell(summon npc 28788) for Acherus Deathcharger
+UPDATE creature_template SET `spell1`=52362, `VehicleId`=200 WHERE `entry`=28782;
+
+-- ScriptName for dark rider
+UPDATE creature_template SET `ScriptName`='npc_ros_dark_rider' WHERE `entry`=28768;
+
+-- Spellclick spell to mount deathcharger
+DELETE FROM npc_spellclick_spells WHERE `npc_entry`=28782;
+INSERT INTO npc_spellclick_spells (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES
+(28782, 52280, 12687, 3, 1);
diff --git a/sql/updates/3.0.9_old/3729_mangos_7938_01_realmd_account.sql b/sql/updates/3.0.9_old/3729_mangos_7938_01_realmd_account.sql
new file mode 100644
index 00000000000..05fde4e7eb7
--- /dev/null
+++ b/sql/updates/3.0.9_old/3729_mangos_7938_01_realmd_account.sql
@@ -0,0 +1,4 @@
+/*ALTER TABLE realmd_db_version CHANGE COLUMN required_7867_01_realmd_account required_7938_01_realmd_account bit;*/
+
+ALTER TABLE account
+  CHANGE id id int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier';
diff --git a/sql/updates/3.0.9_old/3736_world_spell_dk.sql b/sql/updates/3.0.9_old/3736_world_spell_dk.sql
new file mode 100644
index 00000000000..c4097fef37e
--- /dev/null
+++ b/sql/updates/3.0.9_old/3736_world_spell_dk.sql
@@ -0,0 +1,3 @@
+DELETE FROM spell_area WHERE spell = 52693;
+INSERT INTO spell_area (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES
+(52693, 4298, 12687, 1, 12687, 0, 0, 0, 1);
diff --git a/sql/updates/3.0.9_old/3747_mangos_7945_01_quest_template.sql b/sql/updates/3.0.9_old/3747_mangos_7945_01_quest_template.sql
new file mode 100644
index 00000000000..ab28ccd50f3
--- /dev/null
+++ b/sql/updates/3.0.9_old/3747_mangos_7945_01_quest_template.sql
@@ -0,0 +1,9 @@
+ALTER TABLE quest_template
+  ADD COLUMN `DetailsEmoteDelay1` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmote4`,
+  ADD COLUMN `DetailsEmoteDelay2` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmoteDelay1`,
+  ADD COLUMN `DetailsEmoteDelay3` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmoteDelay2`,
+  ADD COLUMN `DetailsEmoteDelay4` int(11) unsigned NOT NULL default '0' AFTER `DetailsEmoteDelay3`,
+  ADD COLUMN `OfferRewardEmoteDelay1` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmote4`,
+  ADD COLUMN `OfferRewardEmoteDelay2` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay1`,
+  ADD COLUMN `OfferRewardEmoteDelay3` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay2`,
+  ADD COLUMN `OfferRewardEmoteDelay4` int(11) unsigned NOT NULL default '0' AFTER `OfferRewardEmoteDelay3`;
diff --git a/sql/updates/3.0.9_old/3791_characters_ahbot.sql b/sql/updates/3.0.9_old/3791_characters_ahbot.sql
new file mode 100644
index 00000000000..ead144c84a8
--- /dev/null
+++ b/sql/updates/3.0.9_old/3791_characters_ahbot.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `auctionhousebot`
+ DROP COLUMN `minTime`,
+ DROP COLUMN `maxTime`;
+ 
+\ No newline at end of file
diff --git a/sql/updates/3.0.9_old/3801_world_spell.sql b/sql/updates/3.0.9_old/3801_world_spell.sql
new file mode 100644
index 00000000000..8fabcad1c58
--- /dev/null
+++ b/sql/updates/3.0.9_old/3801_world_spell.sql
@@ -0,0 +1,7 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (44544, 60503, 36032);
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+(36032,	0x00,	3,	0x00000800,	0x00008000,	0x00000000,	0x00000000,	0x00000000,	0,	0,	0); -- Arcane Blast
+
+DELETE FROM `spell_affect` WHERE `entry` IN (44544);
+INSERT INTO `spell_affect` (`entry`, `effectId`, `SpellClassMask0`, `SpellClassMask1`, `SpellClassMask2`) VALUES
+(44544,0,685904631,1151048,0); -- Fingers of frost
diff --git a/sql/updates/3.0.9_old/3808_world.sql b/sql/updates/3.0.9_old/3808_world.sql
new file mode 100644
index 00000000000..24ce276bd1e
--- /dev/null
+++ b/sql/updates/3.0.9_old/3808_world.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `ScriptName` = 'npc_salanar_the_horseman' WHERE `entry` = 28788;
diff --git a/sql/updates/3.0.9_old/3810_world_spell_bonus_data.sql b/sql/updates/3.0.9_old/3810_world_spell_bonus_data.sql
new file mode 100644
index 00000000000..1803687d6a4
--- /dev/null
+++ b/sql/updates/3.0.9_old/3810_world_spell_bonus_data.sql
@@ -0,0 +1,94 @@
+-- by Drahy
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.6453' WHERE `entry`=33763;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.67305' WHERE `entry`=50464;
+UPDATE `spell_bonus_data` SET `dot_bonus` = '0.2' WHERE `entry`=5570;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7143' WHERE `entry`=44425;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1936' WHERE `entry`=11113;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1936' WHERE `entry`=31661;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.214' WHERE `entry`=120;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '1' WHERE `entry`=19750;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '1.66' WHERE `entry`=635;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.4280' WHERE `entry`=8092;
+UPDATE `spell_bonus_data` SET `dot_bonus` = '0.2' WHERE `entry`=172;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.2129' WHERE `entry`=27243;
+UPDATE `spell_bonus_data` SET `dot_bonus` = '0.2' WHERE `entry`=30108;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0' WHERE `entry`=17962;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.2140' WHERE `entry`=6789;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.4793' WHERE `entry`=48181;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7139' WHERE `entry`=29722;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.4293' WHERE `entry`=5676;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.8569' WHERE `entry`=686;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.4293' WHERE `entry`=17877;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1932' WHERE `entry`=30283;
+UPDATE `spell_bonus_data` SET `dot_bonus` = '0.143' WHERE `entry`=689;
+UPDATE `spell_bonus_data` SET `dot_bonus` = '0.429' WHERE `entry`=1120;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1427' WHERE `entry`=5857;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1427' WHERE `entry`=11681;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1427' WHERE `entry`=11682;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1427' WHERE `entry`=27214;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1427' WHERE `entry`=47822;
+UPDATE `spell_bonus_data` SET `dot_bonus` = '0.0949' WHERE `entry`=1949;
+UPDATE `spell_bonus_data` SET `ap_bonus` = '0.025' WHERE `entry`=31803;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42208; 
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42209; 
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42210; 
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42211; 
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42212; 
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42213; 
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42198; 
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42937; 
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42938;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.2861' WHERE `entry` =49821;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.2861' WHERE `entry` =53022;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=42223;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=42224;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=42225;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=42226;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=42218;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=47817;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=47818;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.4762' WHERE `entry`=379;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=25914;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=25913;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=25903;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=27175;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=33074;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=48821;
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.6453' WHERE `entry`=33763;
+DELETE FROM `spell_bonus_data` WHERE `entry` IN (53742,61391,47897,50796,50590,58597,974,47757,52986,52987,52988);
+INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES 
+('53742', '0.013', '0', '0.025', 'Paladin - Blood Corruption'),
+('61391', '0.193', '0', '0', 'Druid - Typhoon'),
+('47897', '0.1064', '0.0667', '0', 'Warlock - Shadowflame'),
+('50796', '0.7139', '0', '0', 'Warlock - Chaos Bolt'),
+('50590', '0', '0.1622', '0', 'Warlock - Immolation Aura'),
+('58597', '0.75', '0', '0', 'Paladin - Sacred Shield'),
+('47757', '1.6135', '0', '0', 'Priest - Penance (Rank 1'),
+('52986', '1.6135', '0', '0', 'Priest - Penance (Rank 2'),
+('52987', '1.6135', '0', '0', 'Priest - Penance (Rank 3'),
+('52988', '1.6135', '0', '0', 'Priest - Penance (Rank 4');
+DELETE FROM `spell_bonus_data` WHERE `entry` IN (48505,50288,50294,53191,53188,53194,53189,53195,53190);
+INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES
+(50288, 0.05, 0, 0, 'Druid - Starfall rank 1'),
+(50294, 0.012, 0, 0, 'Druid - Starfall AOE rank 1'),
+(53191, 0.05, 0, 0, 'Druid - Starfall rank 2'),
+(53188, 0.012, 0, 0, 'Druid - Starfall AOE rank 2'),
+(53194, 0.05, 0, 0, 'Druid - Starfall rank 3'),
+(53189, 0.012, 0, 0, 'Druid - Starfall AOE rank 3'),
+(53195, 0.05, 0, 0, 'Druid - Starfall rank 4'),
+(53190, 0.012, 0, 0, 'Druid - Starfall AOE rank 4');
+
+-- by nesocip
+DELETE FROM `spell_bonus_data` WHERE `entry` IN (48721, 55078, 52212, 47632, 55095, 49184, 45477, 50536, 51373, 51374, 51375);
+INSERT INTO spell_bonus_data( entry, ap_bonus, comments ) VALUES 
+('48721', '0.04', 'DK - Blood Boil'),
+('55078', '0.055', 'DK - Blood Plague'),
+('52212', '0.0475', 'DK - Death and Decay'),
+('47632', '0.15', 'DK - Death Coil'),
+('55095', '0.055', 'DK - Frost Fever'),
+('49184', '0.1', 'DK - Howling Blast'),
+('45477', '0.1', 'DK - Icy Touch'),
+('50536', '0.013', 'DK - Unholy Blight (Rank1)'),
+('51373', '0.013', 'DK - Unholy Blight (Rank2)'),
+('51374', '0.013', 'DK - Unholy Blight (Rank3)'),
+('51375', '0.013', 'DK - Unholy Blight (Rank4)');
diff --git a/sql/updates/3.0.9_old/3813_world_spell_dk.sql b/sql/updates/3.0.9_old/3813_world_spell_dk.sql
new file mode 100644
index 00000000000..2b438883157
--- /dev/null
+++ b/sql/updates/3.0.9_old/3813_world_spell_dk.sql
@@ -0,0 +1,8 @@
+UPDATE `creature_template` SET maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110, VehicleId = 156 where entry = 28670;
+UPDATE `creature_template` SET `ScriptName`='npc_dkc1_gothik' WHERE `entry`=28658;
+
+-- gift of harvester
+DELETE FROM `spell_script_target` WHERE entry IN (52479);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(52479,1,28819),
+(52479,1,28822);
diff --git a/sql/updates/3.0.9_old/3851_characters_aura.sql b/sql/updates/3.0.9_old/3851_characters_aura.sql
new file mode 100644
index 00000000000..762f8b795b3
--- /dev/null
+++ b/sql/updates/3.0.9_old/3851_characters_aura.sql
@@ -0,0 +1 @@
+DELETE FROM `character_aura` WHERE `spell` IN (48714,57806);
diff --git a/sql/updates/3.0.9_old/3851_world_spell.sql b/sql/updates/3.0.9_old/3851_world_spell.sql
new file mode 100644
index 00000000000..ed10e84808c
--- /dev/null
+++ b/sql/updates/3.0.9_old/3851_world_spell.sql
@@ -0,0 +1,8 @@
+UPDATE `spell_bonus_data` SET `direct_bonus` = '0.6453' WHERE `entry`=33763;
+DELETE FROM `spell_script_target` WHERE `entry` IN (48714,57806);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES 
+('48714', '2', '27237'),
+('48714', '2', '27235'),
+('48714', '2', '27234'),
+('48714', '2', '27236'),
+('57806', '2', '31043');
diff --git a/sql/updates/3.0.9_old/3856_world_spell_naxx.sql b/sql/updates/3.0.9_old/3856_world_spell_naxx.sql
new file mode 100644
index 00000000000..3b3895b3c4d
--- /dev/null
+++ b/sql/updates/3.0.9_old/3856_world_spell_naxx.sql
@@ -0,0 +1,9 @@
+UPDATE `creature_template` SET `minlevel`='80',`maxlevel`='80',`faction_A`='21',`faction_H`='21' WHERE entry IN (16286,30068);
+
+INSERT INTO creature_template (entry, baseattacktime, spell1, flags_extra, scriptname) VALUES
+(16129, 10000, 27812, 128, 'trigger_periodic') # Shadow Fissure (Kel'thezad)
+ON DUPLICATE KEY UPDATE
+baseattacktime = VALUES(baseattacktime),
+spell1 = VALUES(spell1),
+flags_extra = VALUES(flags_extra),
+scriptname = VALUES(scriptname);
diff --git a/sql/updates/3.0.9_old/3869_world_access_requirement.sql b/sql/updates/3.0.9_old/3869_world_access_requirement.sql
new file mode 100644
index 00000000000..d6ccad3e197
--- /dev/null
+++ b/sql/updates/3.0.9_old/3869_world_access_requirement.sql
@@ -0,0 +1 @@
+ALTER TABLE `access_requirement` ADD COLUMN `heroic_level_min` tinyint(3) unsigned NOT NULL default '0' AFTER `level_min`;
diff --git a/sql/updates/3.0.9_old/3870_mangos_7980_01_world_item_required_target.sql b/sql/updates/3.0.9_old/3870_mangos_7980_01_world_item_required_target.sql
new file mode 100644
index 00000000000..7853e496a2d
--- /dev/null
+++ b/sql/updates/3.0.9_old/3870_mangos_7980_01_world_item_required_target.sql
@@ -0,0 +1,9 @@
+-- ALTER TABLE db_version CHANGE COLUMN required_7945_01_mangos_quest_template required_7980_01_mangos_item_required_target bit;
+
+DROP TABLE IF EXISTS `item_required_target`;
+CREATE TABLE `item_required_target` (
+  `entry` mediumint(8) unsigned NOT NULL,
+  `type` tinyint(3) unsigned NOT NULL default '0',
+  `targetEntry` mediumint(8) unsigned NOT NULL default '0',
+  UNIQUE KEY `entry_type_target` (`entry`,`type`,`targetEntry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
diff --git a/sql/updates/3.0.9_old/3873_world_spell_dk.sql b/sql/updates/3.0.9_old/3873_world_spell_dk.sql
new file mode 100644
index 00000000000..142ec203ff2
--- /dev/null
+++ b/sql/updates/3.0.9_old/3873_world_spell_dk.sql
@@ -0,0 +1,28 @@
+DELETE FROM `creature_questrelation` WHERE `quest`=12701;
+INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28377, 12701);
+DELETE FROM `creature_involvedrelation` WHERE `quest`=12701;
+INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28377, 12701);
+DELETE FROM `creature_involvedrelation` WHERE `quest`=12723;
+INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12723);
+DELETE FROM `creature_questrelation` WHERE `quest`=12724;
+INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12724);
+DELETE FROM `creature_involvedrelation` WHERE `quest`=12724;
+INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12724);
+DELETE FROM `creature_questrelation` WHERE `quest`=12725;
+INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28913, 12725);
+DELETE FROM `creature_involvedrelation` WHERE `quest`=12725;
+INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28912, 12725);
+DELETE FROM `creature_questrelation` WHERE `quest`=12727;
+INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28912, 12727);
+DELETE FROM `creature_involvedrelation` WHERE `quest`=12727;
+INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28913, 12727);
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (28833,28887);
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES
+(28833, 52447, 12701, 3, 3),
+(28887, 52447, 12701, 3, 3);
+UPDATE creature_template SET spell1=52435,spell2=52576,spell5=52588,VehicleId=68,speed=0 WHERE entry IN (28833,28887);
+UPDATE creature_template SET spell1=52211 WHERE entry=28864;
+DELETE FROM `spell_script_target` WHERE entry IN (52576);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(52576,1,28834),
+(52576,1,28886);
diff --git a/sql/updates/3.0.9_old/3877_world_spell_script_target.sql b/sql/updates/3.0.9_old/3877_world_spell_script_target.sql
new file mode 100644
index 00000000000..57392c547d3
--- /dev/null
+++ b/sql/updates/3.0.9_old/3877_world_spell_script_target.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_target` WHERE `entry` IN (48743);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES 
+('48743', '1', '26125');
diff --git a/sql/updates/3.0.9_old/3886_world_script_nexus.sql b/sql/updates/3.0.9_old/3886_world_script_nexus.sql
new file mode 100644
index 00000000000..eba67418eef
--- /dev/null
+++ b/sql/updates/3.0.9_old/3886_world_script_nexus.sql
@@ -0,0 +1,82 @@
+-- Grand Magus Telestra
+UPDATE `creature_template` SET `ScriptName`='boss_magus_telestra' WHERE `entry`=26731;
+
+-- Anomalus
+UPDATE `creature_template` SET `ScriptName`='boss_anomalus' WHERE `entry`=26763;
+UPDATE `creature_template` SET `ScriptName`='mob_chaotic_rift' WHERE `entry`=26918;
+
+-- Ormorok the Tree-Shaper
+UPDATE `creature_template` SET `ScriptName`='boss_ormorok' WHERE `entry`=26794;
+UPDATE `creature_template` SET `ScriptName`='mob_crystal_spike' WHERE `entry`=27099;
+UPDATE `creature_template` SET `ScriptName`='mob_crystalline_tangler' WHERE `entry`=32665;
+
+-- Keristrasza
+UPDATE `creature_template` SET `ScriptName`='boss_keristrasza' WHERE `entry`=26723;
+
+-- Instance script
+UPDATE `instance_template` SET `script`='instance_nexus' WHERE `map`=576;
+
+UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE entry IN  (26796, 26798, 26929, 26928, 26930);
+DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (26796, 26798, 26929, 26928, 26930);
+INSERT INTO `creature_ai_scripts` VALUES 
+-- Commander Stoutbeard
+( 2679600, 26796, 4, 0, 100, 4, 0, 0, 0, 0, 28, 0, 47543, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - crystal prison remove'),
+( 2679601, 26796, 4, 0, 100, 4, 0, 0, 0, 0, 11, 31403, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - cast battle shout'),
+( 2679602, 26796, 0, 0, 100, 5, 3000, 3000, 11000, 15000, 11, 60067, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - cast charge'),
+( 2679603, 26796, 0, 0, 100, 5, 6000, 8000, 19500, 25000, 11, 38618, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - cast whirlwind'),
+( 2679604, 26796, 0, 0, 100, 5, 13000, 13000, 45000, 55000, 11, 19134, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - cast Frightening Shout'),
+-- Commander Kolurg
+( 2679800, 26798, 4, 0, 100, 4, 0, 0, 0, 0, 28, 0, 47543, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - crystal prison remove'),
+( 2679801, 26798, 4, 0, 100, 4, 0, 0, 0, 0, 11, 31403, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - cast battle shout'),
+( 2679802, 26798, 0, 0, 100, 5, 3000, 3000, 11000, 15000, 11, 60067, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - cast charge'),
+( 2679803, 26798, 0, 0, 100, 5, 6000, 8000, 19500, 25000, 11, 38618, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - cast whirlwind'),
+( 2679804, 26798, 0, 0, 100, 5, 13000, 13000, 45000, 55000, 11, 19134, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - cast Frightening Shout'),
+-- Grand Magus Telestra Clone (Arcane)
+( 2692901, 26929, 0, 0, 100, 7, 6000, 8000, 10000, 12000, 11, 47731, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra arcane - cast pollymorph critter'),
+( 2692902, 26929, 0, 0, 100, 7, 15000, 16000, 15000, 16000, 11, 47736, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra arcane - cast time stop'),
+-- Grand Magus Telestra Clone (Fire)
+( 2692801, 26928, 0, 0, 100, 3, 3000, 3000, 8000, 9000, 11, 47721, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand magus Telestra fire - cast fire blast N'),
+( 2692802, 26928, 0, 0, 100, 5, 3000, 3000, 8000, 9000, 11, 56939, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand magus Telestra fire - cast fire blast H'),
+( 2692803, 26928, 0, 0, 100, 3, 9000, 9000, 9500, 11500, 11, 47723, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand magus Telestra fire - cast scorge N'),
+( 2692804, 26928, 0, 0, 100, 5, 9000, 9000, 9500, 11500, 11, 56938, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand magus Telestra fire - cast scorge H'),
+-- Grand Magus Telestra Clone (Frost)
+( 2693001, 26930, 0, 0, 100, 3, 3000, 3000, 8000, 9000, 11, 47729, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra frost - cast ice bard N'),
+( 2693002, 26930, 0, 0, 100, 5, 3000, 3000, 8000, 9000, 11, 56937, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra frost - cast ice bard H'),
+( 2693003, 26930, 0, 0, 100, 3, 9000, 9000, 15000, 16000, 11, 47727, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra frost - cast blizzard N'),
+( 2693004, 26930, 0, 0, 100, 5, 9000, 9000, 15000, 16000, 11, 56936, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra frost - cast blizzard H');
+
+-- Grand Magus Telestra
+DELETE FROM `script_texts` WHERE `entry` BETWEEN -1576005 AND -1576000;
+INSERT INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
+(-1576000,'You know what they say about curiosity.',13319,1,0,0,'grand magus telestra SAY_AGGRO'),
+(-1576001,'Death becomes you!',13324,1,0,0,'grand magus telestra SAY_KILL'),
+(-1576002,'Damn the... luck.',13320,1,0,0,'grand magus telestra SAY_DEATH'),
+(-1576003,'Now to finish the job!',13323,1,0,0,'grand magus telestra SAY_MERGE'),
+(-1576004,'There\'s plenty of me to go around.',13321,1,0,0,'grand magus telestra SAY_SPLIT_1'),
+(-1576005,'I\'ll give you more than you can handle.',13322,1,0,0,'grand magus telestra SAY_SPLIT_2');
+
+-- Anomalus
+DELETE FROM `script_texts` WHERE `entry` BETWEEN -1576013 AND -1576010;
+INSERT INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
+(-1576010,'Chaos beckons.',13186,1,0,0,'anomalus SAY_AGGRO'),
+(-1576011,'Of course.',13187,1,0,0,'anomalus SAY_DEATH'),
+(-1576012,'Reality... unwoven.',13188,1,0,0,'anomalus SAY_RIFT'),
+(-1576013,'Indestructible.',13189,1,0,0,'anomalus SAY_SHIELD');
+
+-- Ormorok the Tree-Shaper
+DELETE FROM `script_texts` WHERE `entry` BETWEEN -1576024 AND -1576020;
+INSERT INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
+(-1576020,'Noo!',13328,1,0,0,'ormorok SAY_AGGRO'),
+(-1576021,'Aaggh!',13330,1,0,0,'ormorok SAY_DEATH'),
+(-1576022,'Back!',13331,1,0,0,'ormorok SAY_REFLECT'),
+(-1576023,'Bleed!',13332,1,0,0,'ormorok SAY_CRYSTAL_SPIKES'),
+(-1576024,'Aaggh! Kill!',13329,1,0,0,'ormorok SAY_KILL');
+
+-- Keristrasza
+DELETE FROM `script_texts` WHERE `entry` BETWEEN -1576044 AND -1576040;
+INSERT INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
+(-1576040,'Preserve? Why? There\'s no truth in it. No no no... only in the taking! I see that now!',13450,1,0,0,'keristrasza SAY_AGGRO'),
+(-1576041,'Now we\'ve come to the truth!',13453,1,0,0,'keristrasza SAY_SLAY'),
+(-1576042,'Finish it! FINISH IT! Kill me, or I swear by the Dragonqueen you\'ll never see daylight again!',13452,1,0,0,'keristrasza SAY_ENRAGE'),
+(-1576043,'Dragonqueen... Life-Binder... preserve... me.',13454,1,0,0,'keristrasza SAY_DEATH'),
+(-1576044,'Stay. Enjoy your final moments.',13451,1,0,0,'keristrasza SAY_CRYSTAL_NOVA');
diff --git a/sql/updates/3.0.9_old/3899_world_spell_proc_event.sql b/sql/updates/3.0.9_old/3899_world_spell_proc_event.sql
new file mode 100644
index 00000000000..bc8b159bd9a
--- /dev/null
+++ b/sql/updates/3.0.9_old/3899_world_spell_proc_event.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (18096, 18073);
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+(18096,	0x00,	5,	0x00000060,	0x00800080,	0x00000000,	0x00000000,	0x00000000,	0,	0,	0), -- Pyroclasm (Rank 1)
+(18073,	0x00,	5,	0x00000060,	0x00800080,	0x00000000,	0x00000000,	0x00000000,	0,	0,	0); -- Pyroclasm (Rank 2)
diff --git a/sql/updates/3.0.9_old/3903_world_spell_proc_event.sql b/sql/updates/3.0.9_old/3903_world_spell_proc_event.sql
new file mode 100644
index 00000000000..ab534ece0a8
--- /dev/null
+++ b/sql/updates/3.0.9_old/3903_world_spell_proc_event.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (56249);
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+(56249,	0x00,	5,	0x00000000,	0x00000000,	0x00000400,	0x00000000,	0x00000000,	0,	0,	0); -- Glyph of Felhunter
diff --git a/sql/updates/3.0.9_old/3910_world.sql b/sql/updates/3.0.9_old/3910_world.sql
new file mode 100644
index 00000000000..2e0d54fc545
--- /dev/null
+++ b/sql/updates/3.0.9_old/3910_world.sql
@@ -0,0 +1,72 @@
+UPDATE `creature_template` SET `ScriptName` = 'npc_threshwackonator' WHERE `entry` = 6669;
+
+DELETE FROM `script_texts` WHERE `entry` IN (-1000414, -1000413);
+INSERT INTO script_texts (entry, content_default, sound, type, language, emote, comment) VALUES
+(-1000413, 'Threshwackonator First Mate unit prepared to follow', 0, 2, 0, 0, 'threshwackonator EMOTE_START'),
+(-1000414, 'YARRR! Swabie, what have ye done?! He\'s gone mad! Baton him down the hatches! Hoist the mast! ARRRR! Every man for hi\'self!', 0, 0, 7, 0, 'threshwackonator SAY_AT_CLOSE');
+
+UPDATE `creature_template` SET `ScriptName` = 'npc_prospector_remtravel' WHERE `entry` = 2917;
+
+DELETE FROM `script_texts` WHERE `entry` BETWEEN -1000427 AND -1000415;
+INSERT INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
+(-1000415, 'Ok, $n, let\'s go find where I left that mysterious fossil. Follow me!', 0, 0, 7, 0, 'remtravel SAY_REM_START'),
+(-1000416, 'Now where did I put that mysterious fossil? Ah, maybe up there...', 0, 0, 7, 0, 'remtravel SAY_REM_RAMP1_1'),
+(-1000417, 'Hrm, nothing up here.', 0, 0, 7, 0, 'remtravel SAY_REM_RAMP1_2'),
+(-1000418, 'No mysterious fossil here... Ah, but my copy of Green Hills of Stranglethorn. What a good book!', 0, 0, 7, 0, 'remtravel SAY_REM_BOOK'),
+(-1000419, 'I bet you I left it in the tent!', 0, 0, 7, 0, 'remtravel SAY_REM_TENT1_1'),
+(-1000420, 'Oh wait, that\'s Hollee\'s tent... and it\'s empty.', 0, 0, 7, 0, 'remtravel SAY_REM_TENT1_2'),
+(-1000421, 'Interesting... I hadn\'t noticed this earlier...', 0, 0, 7, 0, 'remtravel SAY_REM_MOSS'),
+(-1000422, '%s inspects the ancient, mossy stone.', 0, 2, 7, 0, 'remtravel EMOTE_REM_MOSS'),
+(-1000423, 'Oh wait! I\'m supposed to be looking for that mysterious fossil!', 0, 0, 7, 0, 'remtravel SAY_REM_MOSS_PROGRESS'),
+(-1000424, 'Nope. didn\'t leave the fossil back here!', 0, 0, 7, 0, 'remtravel SAY_REM_PROGRESS'),
+(-1000425, 'Ah. I remember now! I gave the mysterious fossil to Hollee! Check with her.', 0, 0, 7, 0, 'remtravel SAY_REM_REMEMBER'),
+(-1000426, '%s goes back to work, oblivious to everything around him.', 0, 2, 7, 0, 'remtravel EMOTE_REM_END'),
+(-1000427, 'Something tells me this $r wants the mysterious fossil too. Help!', 0, 0, 7, 0, 'remtravel SAY_REM_AGGRO');
+
+DELETE FROM `script_waypoint` WHERE `entry` = 2917;
+INSERT INTO `script_waypoint` VALUES
+(2917, 0, 4675.812500, 598.614563, 17.645658, 0, 'SAY_REM_START'),
+(2917, 1, 4672.844238, 599.325378, 16.417622, 0, ''),
+(2917, 2, 4663.449707, 607.430176, 10.494752, 0, ''),
+(2917, 3, 4655.969238, 613.761353, 8.523270, 0, ''),
+(2917, 4, 4640.804688, 623.999329, 8.377054, 0, ''),
+(2917, 5, 4631.678711, 630.801086, 6.414999, 5000, 'SAY_REM_RAMP1_1'),
+(2917, 6, 4633.533203, 632.476440, 6.509831, 0, 'ambush'),
+(2917, 7, 4639.413574, 637.120789, 13.338119, 0, ''),
+(2917, 8, 4642.352051, 637.668152, 13.437444, 0, ''),
+(2917, 9, 4645.082031, 634.463989, 13.437208, 5000, 'SAY_REM_RAMP1_2'),
+(2917, 10, 4642.345215, 637.584839, 13.435211, 0, ''),
+(2917, 11, 4639.630859, 637.233765, 13.339752, 0, ''),
+(2917, 12, 4633.363281, 632.462280, 6.488438, 0, ''),
+(2917, 13, 4624.714844, 631.723511, 6.264030, 0, ''),
+(2917, 14, 4623.525879, 629.718506, 6.201339, 5000, 'SAY_REM_BOOK'),
+(2917, 15, 4623.452148, 630.369629, 6.218942, 0, 'SAY_REM_TENT1_1'),
+(2917, 16, 4622.622070, 637.221558, 6.312845, 0, 'ambush'),
+(2917, 17, 4619.755371, 637.386230, 6.312050, 5000, 'SAY_REM_TENT1_2'),
+(2917, 18, 4620.027832, 637.367676, 6.312050, 0, ''),
+(2917, 19, 4624.154785, 637.560303, 6.313898, 0, ''),
+(2917, 20, 4622.967773, 634.016479, 6.294979, 0, ''),
+(2917, 21, 4616.926758, 630.303284, 6.239193, 0, ''),
+(2917, 22, 4614.546387, 616.983337, 5.687642, 0, ''),
+(2917, 23, 4610.279297, 610.029419, 5.442539, 0, ''),
+(2917, 24, 4601.149902, 604.111694, 2.054856, 0, ''),
+(2917, 25, 4589.618164, 597.685730, 1.057147, 0, ''),
+(2917, 26, 4577.588379, 592.145813, 1.120190, 0, 'SAY_REM_MOSS (?)'),
+(2917, 27, 4569.848145, 592.177490, 1.260874, 5000, 'EMOTE_REM_MOSS (?)'),
+(2917, 28, 4568.791992, 590.870911, 1.211338, 3000, 'SAY_REM_MOSS_PROGRESS (?)'),
+(2917, 29, 4566.722656, 564.077881, 1.343084, 0, 'ambush'),
+(2917, 30, 4568.269531, 551.958435, 5.004200, 0, ''),
+(2917, 31, 4566.731934, 551.557861, 5.426314, 5000, 'SAY_REM_PROGRESS'),
+(2917, 32, 4566.741699, 560.767639, 1.703257, 0, ''),
+(2917, 33, 4573.916016, 582.566101, 0.749801, 0, ''),
+(2917, 34, 4594.206055, 598.533020, 1.034056, 0, ''),
+(2917, 35, 4601.194824, 604.283081, 2.060146, 0, ''),
+(2917, 36, 4609.539551, 610.844727, 5.402220, 0, ''),
+(2917, 37, 4624.800293, 618.076477, 5.851541, 0, ''),
+(2917, 38, 4632.414063, 623.778442, 7.286243, 0, ''),
+(2917, 39, 4645.915039, 621.983765, 8.579967, 0, ''),
+(2917, 40, 4658.669922, 611.092651, 8.891747, 0, ''),
+(2917, 41, 4671.924316, 599.752197, 16.01242, 5000, 'SAY_REM_REMEMBER'),
+(2917, 42, 4676.976074, 600.649780, 17.82566, 5000, 'EMOTE_REM_END');
+
+UPDATE `creature_template` SET `ScriptName` = 'npc_myranda_the_hag' WHERE `entry` = 11872;
author	Chaz Brown <iamparadox@netscape.net>	2009-09-03 09:21:28 -0400
committer	Chaz Brown <iamparadox@netscape.net>	2009-09-03 09:21:28 -0400
commit	f205d9734af2185efad536fa8c4fdb7faa0bb41e (patch)
tree	4f6d8728e10488d112399f14a3824b22857fb888 /sql/updates/3.0.9_old
parent	587f6377f26bd7a0515848632cd8882c456c358f (diff)