Skip to content

Files

Latest commit

UndergarunUndergarun
Merge remote branch 'remotes/mangosR2.mangos/master'
Mar 27, 2012
e4346f0 · Mar 27, 2012

History

History
This branch is 48 commits ahead of, 2323 commits behind mangosR2/mangos:master.

sql_mr

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
U06_mangos_mangos_string.sql
U06_mangos_mangos_string.sql
Feb 7, 2012
U13_realm_rolerealms.sql
U13_realm_rolerealms.sql
Feb 7, 2012
U14_characters_ticket_state.sql
U14_characters_ticket_state.sql
Feb 7, 2012
U14_mangos_ticket_state.sql
U14_mangos_ticket_state.sql
Feb 7, 2012
custom_characters_tables.sql
custom_characters_tables.sql
Mar 20, 2012
custom_mangos_tables.sql
custom_mangos_tables.sql
Mar 20, 2012
custom_realmd_tables.sql
custom_realmd_tables.sql
Dec 16, 2011
custom_rerun_every_mangos_DB_update.sql
custom_rerun_every_mangos_DB_update.sql
Aug 2, 2011
innormative_words.txt
innormative_words.txt
Jul 3, 2011
letter_analogs.txt
letter_analogs.txt
May 6, 2011
mr00017_mangos_anticheat.sql
mr00017_mangos_anticheat.sql
Aug 2, 2011
mr00017_mangos_arena_announcer.sql
mr00017_mangos_arena_announcer.sql
Aug 2, 2011
mr00017_mangos_autobroadcast.sql
mr00017_mangos_autobroadcast.sql
Aug 2, 2011
mr00017_mangos_lightwell.sql
mr00017_mangos_lightwell.sql
May 11, 2011
mr00017_mangos_pandora_trader.sql
mr00017_mangos_pandora_trader.sql
May 11, 2011
mr00017_mangos_playercreateinfo_spell.sql
mr00017_mangos_playercreateinfo_spell.sql
May 11, 2011
mr00017_mangos_raise_ally.sql
mr00017_mangos_raise_ally.sql
May 11, 2011
mr00019_mangos_creature_template.sql
mr00019_mangos_creature_template.sql
May 11, 2011
mr00019_mangos_item_convert.sql
mr00019_mangos_item_convert.sql
May 11, 2011
mr00019_mangos_refer_a_friend.sql
mr00019_mangos_refer_a_friend.sql
Aug 2, 2011
mr00020_mangos_dungeon_encounters.sql
mr00020_mangos_dungeon_encounters.sql
May 14, 2011
mr00020_mangos_dungeon_rewards_lfg.sql
mr00020_mangos_dungeon_rewards_lfg.sql
May 11, 2011
mr00022_mangos_playerbot.sql
mr00022_mangos_playerbot.sql
May 12, 2011
mr00055_characters_pet_dualspec.sql
mr00055_characters_pet_dualspec.sql
Oct 9, 2011
mr00084_mangos_vehicle_scaling.sql
mr00084_mangos_vehicle_scaling.sql
Aug 2, 2011
mr00107_mangos_reset_pet_talents.sql
mr00107_mangos_reset_pet_talents.sql
Feb 7, 2012
mr00118_characters_anticheat_config.sql
mr00118_characters_anticheat_config.sql
Feb 4, 2012
mr00118_realmd_warden.sql
mr00118_realmd_warden.sql
Oct 9, 2011
mr00146_mangos_creature_spell.sql
mr00146_mangos_creature_spell.sql
Feb 7, 2012
mr00176_characters_pet_cleanup.sql
mr00176_characters_pet_cleanup.sql
Feb 7, 2012
mr00194_realmd_warden_update.sql
mr00194_realmd_warden_update.sql
Oct 9, 2011
mr00242_mangos_creature_onkill_reputation.sql
mr00242_mangos_creature_onkill_reputation.sql
Feb 7, 2012
mr00299_mangos_mangos_string.sql
mr00299_mangos_mangos_string.sql
Aug 2, 2011
mr00303_characters_hidden_rating.sql
mr00303_characters_hidden_rating.sql
Feb 7, 2012
mr00319_characters_Advance_chars_stats.sql
mr00319_characters_Advance_chars_stats.sql
Oct 9, 2011
mr00480_mangos_shaman_overload.sql
mr00480_mangos_shaman_overload.sql
Aug 2, 2011
mr00528_mangos_lfg_quests.sql
mr00528_mangos_lfg_quests.sql
Feb 7, 2012
mr00558_mangos_spell_dbc_extend.sql
mr00558_mangos_spell_dbc_extend.sql
Oct 9, 2011
mr00760_mangos_pet_spell_auras.sql
mr00760_mangos_pet_spell_auras.sql
Aug 3, 2011
mr00767_mangos_creature_table_fix.sql
mr00767_mangos_creature_table_fix.sql
Aug 11, 2011
mr00777_mangos_spell_dbc_extend.sql
mr00777_mangos_spell_dbc_extend.sql
Oct 9, 2011
mr00786_mangos_area_auras_cleanup.sql
mr00786_mangos_area_auras_cleanup.sql
Aug 7, 2011
mr00849_mangos_faction_change_spells.sql
mr00849_mangos_faction_change_spells.sql
Sep 4, 2011
mr00974_mangos_pet_spells.sql
mr00974_mangos_pet_spells.sql
Sep 6, 2011
mr00992_mangos_creature_template.sql
mr00992_mangos_creature_template.sql
Feb 7, 2012
mr01004_mangos_spell_dbc.sql
mr01004_mangos_spell_dbc.sql
Dec 20, 2011
mr01019_mangos_spell_dbc_extend.sql
mr01019_mangos_spell_dbc_extend.sql
Oct 9, 2011
mr01120_characters_anticheat_extend.sql
mr01120_characters_anticheat_extend.sql
Oct 12, 2011
mr01129_mangos_typos_in_commands.sql
mr01129_mangos_typos_in_commands.sql
Oct 13, 2011
mr01138_mangos_creature_linking.sql
mr01138_mangos_creature_linking.sql
Oct 17, 2011
mr01157_mangos_faction_change_reputations.sql
mr01157_mangos_faction_change_reputations.sql
Oct 22, 2011
mr01164_mangos_faction_change_achievements.sql
mr01164_mangos_faction_change_achievements.sql
Oct 24, 2011
mr01164_mangos_faction_change_items.sql
mr01164_mangos_faction_change_items.sql
Oct 24, 2011
mr01204_mangos_pet_scaling.sql
mr01204_mangos_pet_scaling.sql
Nov 4, 2011
mr01208_mangos_pet_levelstats.sql
mr01208_mangos_pet_levelstats.sql
Nov 5, 2011
mr01212_mangos_area_spells.sql
mr01212_mangos_area_spells.sql
Nov 5, 2011
mr01280_mangos_spell_proc_event_hacks.sql
mr01280_mangos_spell_proc_event_hacks.sql
Nov 23, 2011
mr01299_mangos_battleground_template.sql
mr01299_mangos_battleground_template.sql
Nov 27, 2011
mr01330_mangos_creature.sql
mr01330_mangos_creature.sql
Nov 29, 2011
mr01330_mangos_gameobject.sql
mr01330_mangos_gameobject.sql
Nov 29, 2011
mr01337_mangos_server_spells.sql
mr01337_mangos_server_spells.sql
Nov 29, 2011
mr01342_mangos_vehicle_accessory.sql
mr01342_mangos_vehicle_accessory.sql
Dec 21, 2011
mr01350_mangos_areatrigger_data.sql
mr01350_mangos_areatrigger_data.sql
Dec 2, 2011
mr01350_mangos_areatrigger_template.sql
mr01350_mangos_areatrigger_template.sql
Dec 2, 2011
mr01384_mangos_spell_bonus_data.sql
mr01384_mangos_spell_bonus_data.sql
Dec 7, 2011
mr01393_realmd_account_forcepermission.sql
mr01393_realmd_account_forcepermission.sql
Dec 14, 2011
mr01416_mangos_creature_template_addon.sql
mr01416_mangos_creature_template_addon.sql
Dec 16, 2011
mr01425_mangos_spell_dbc_extend.sql
mr01425_mangos_spell_dbc_extend.sql
Dec 15, 2011
mr01448_mangos_spell_dbc_extend.sql
mr01448_mangos_spell_dbc_extend.sql
Dec 19, 2011
mr01462_mangos_accessory_extend.sql
mr01462_mangos_accessory_extend.sql
Dec 21, 2011
mr01467_mangos_spell_chain.sql
mr01467_mangos_spell_chain.sql
Dec 21, 2011
mr01485_spell_59390_mangos.sql
mr01485_spell_59390_mangos.sql
Dec 26, 2011
mr01515_mangos_the_ring_of_valor.sql
mr01515_mangos_the_ring_of_valor.sql
Jan 16, 2012
mr01602_mangos_Isle_of_Conquest.sql
mr01602_mangos_Isle_of_Conquest.sql
Jan 23, 2012
mr01610_mangos_opvp_capture_points.sql
mr01610_mangos_opvp_capture_points.sql
Jan 24, 2012
mr01612_mangos_dalaran_arena.sql
mr01612_mangos_dalaran_arena.sql
Jan 24, 2012
mr01615_mangos_language_opvp.sql
mr01615_mangos_language_opvp.sql
Jan 24, 2012
mr01640_mangos_name_announce.sql
mr01640_mangos_name_announce.sql
Feb 7, 2012
mr01648_mangos_Strand_of_the_Ancients.sql
mr01648_mangos_Strand_of_the_Ancients.sql
Jan 29, 2012
mr01662_mangos_areatrigger_teleport.sql
mr01662_mangos_areatrigger_teleport.sql
Feb 7, 2012
mr01669_mangos_achievements_fixes.sql
mr01669_mangos_achievements_fixes.sql
Feb 9, 2012
mr01678_mangos_custom_areatriggers.sql
mr01678_mangos_custom_areatriggers.sql
Feb 4, 2012
mr01688_mangos_vehicle_data.sql
mr01688_mangos_vehicle_data.sql
Feb 6, 2012
mr01703_mangos_spell_proc_event.sql
mr01703_mangos_spell_proc_event.sql
Feb 7, 2012
mr01736_characters_pet_extend.sql
mr01736_characters_pet_extend.sql
Feb 16, 2012
mr01743_mangos_spell_hacks.sql
mr01743_mangos_spell_hacks.sql
Feb 19, 2012
mr01744_mangos_spell_script_target_addition.sql
mr01744_mangos_spell_script_target_addition.sql
Feb 19, 2012
mr01765_realmd_warden_data.sql
mr01765_realmd_warden_data.sql
Feb 26, 2012
mr01792_mangos_spell_linked.sql
mr01792_mangos_spell_linked.sql
Mar 11, 2012
mr01793_mangos_string_statemgr.sql
mr01793_mangos_string_statemgr.sql
Mar 12, 2012
mr01811_characters_worldstate.sql
mr01811_characters_worldstate.sql
Mar 20, 2012
mr01811_mangos_worldstate.sql
mr01811_mangos_worldstate.sql
Mar 20, 2012
mr01811_mangos_worldstate_templates.sql
mr01811_mangos_worldstate_templates.sql
Mar 20, 2012
mr01817_mangos_Honorable_Defender.sql
mr01817_mangos_Honorable_Defender.sql
Mar 25, 2012
mr01824_mangos_npc_gossip.sql
mr01824_mangos_npc_gossip.sql
Mar 27, 2012
readme.txt
readme.txt
Dec 9, 2011
static_guids_policy.txt
static_guids_policy.txt
Jan 16, 2012

readme.txt

You should install these files if you want to fully functionality

Instructions for CLEAN DBs:
1. Apply custom_characters_tables.sql (no need to run single sqls for fresh install)
2. Apply custom_realmd_tables.sql (no need to run single sqls for fresh install)
3. Apply custom_mangos_tables.sql
4. Apply custom_rerun_every_YTDB_update.sql
5. Apply mr*mangos*.sql

Instructions for EXISTING DBs:
1. Apply mr*characters*.sql
2. Apply mr*realmd*.sql
3. Apply mr*mangos*sql

Instructions for Every Official DBs Update:
1. Apply custom_rerun_every_YTDB_update.sql

Guids :
Name                            Creature                   GameObject
The Ring of valor               0                          222001 - 222016
Dalaran Arena                   0                          222020 - 222025
Strand of the Ancients          200001 - 200036            200008 - 200185
Isle of Conquest                300000 - 300068            300000 - 300138