aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/10241_characters_guilds.sql
AgeCommit message (Collapse)Author
2010-11-07Core/SQL: Move some SQL-files around (you all know what this means...)click
--HG-- branch : trunk rename : sql/updates/09859_characters_group_member.sql => sql/updates/3.3.5a_old/09859_characters_group_member.sql rename : sql/updates/09900_world_spell_proc_event.sql => sql/updates/3.3.5a_old/09900_world_spell_proc_event.sql rename : sql/updates/09911_characters_guild_bank_eventlog.sql => sql/updates/3.3.5a_old/09911_characters_guild_bank_eventlog.sql rename : sql/updates/09912_world_spell_bonus_data.sql => sql/updates/3.3.5a_old/09912_world_spell_bonus_data.sql rename : sql/updates/09920_characters_pool_quest_save.sql => sql/updates/3.3.5a_old/09920_characters_pool_quest_save.sql rename : sql/updates/09920_world_pool_quest.sql => sql/updates/3.3.5a_old/09920_world_pool_quest.sql rename : sql/updates/09948_world_script_name.sql => sql/updates/3.3.5a_old/09948_world_script_name.sql rename : sql/updates/09948_world_script_texts.sql => sql/updates/3.3.5a_old/09948_world_script_texts.sql rename : sql/updates/09948_world_spell_script_names.sql => sql/updates/3.3.5a_old/09948_world_spell_script_names.sql rename : sql/updates/09958_world_quest_poi_points.sql => sql/updates/3.3.5a_old/09958_world_quest_poi_points.sql rename : sql/updates/09963_world_spell_script_names.sql => sql/updates/3.3.5a_old/09963_world_spell_script_names.sql rename : sql/updates/09977_world_spell_script_names.sql => sql/updates/3.3.5a_old/09977_world_spell_script_names.sql rename : sql/updates/09988_world_spell_script_names.sql => sql/updates/3.3.5a_old/09988_world_spell_script_names.sql rename : sql/updates/10000_characters_character_banned.sql => sql/updates/3.3.5a_old/10000_characters_character_banned.sql rename : sql/updates/10000_world_command.sql => sql/updates/3.3.5a_old/10000_world_command.sql rename : sql/updates/10000_world_trinity_string.sql => sql/updates/3.3.5a_old/10000_world_trinity_string.sql rename : sql/updates/10023_world_command.sql => sql/updates/3.3.5a_old/10023_world_command.sql rename : sql/updates/10029_world_spell_script_names.sql => sql/updates/3.3.5a_old/10029_world_spell_script_names.sql rename : sql/updates/10030_characters_item_soulbound_trade_data.sql => sql/updates/3.3.5a_old/10030_characters_item_soulbound_trade_data.sql rename : sql/updates/10060_world_creature_text.sql => sql/updates/3.3.5a_old/10060_world_creature_text.sql rename : sql/updates/10076_world_command.sql => sql/updates/3.3.5a_old/10076_world_command.sql rename : sql/updates/10078_world_spell_proc_event.sql => sql/updates/3.3.5a_old/10078_world_spell_proc_event.sql rename : sql/updates/10083_world_trinity_string.sql => sql/updates/3.3.5a_old/10083_world_trinity_string.sql rename : sql/updates/10084_characters_character_queststatus.sql => sql/updates/3.3.5a_old/10084_characters_character_queststatus.sql rename : sql/updates/10091_world_spell_proc_event.sql => sql/updates/3.3.5a_old/10091_world_spell_proc_event.sql rename : sql/updates/10099_world_spell_script_names.sql => sql/updates/3.3.5a_old/10099_world_spell_script_names.sql rename : sql/updates/10105_world_spell_proc_event.sql => sql/updates/3.3.5a_old/10105_world_spell_proc_event.sql rename : sql/updates/10105_world_spell_script_names.sql => sql/updates/3.3.5a_old/10105_world_spell_script_names.sql rename : sql/updates/10113_world_spell_proc_event.sql => sql/updates/3.3.5a_old/10113_world_spell_proc_event.sql rename : sql/updates/10132_world_command.sql => sql/updates/3.3.5a_old/10132_world_command.sql rename : sql/updates/10132_world_trinity_string.sql => sql/updates/3.3.5a_old/10132_world_trinity_string.sql rename : sql/updates/10171_world_script_texts.sql => sql/updates/3.3.5a_old/10171_world_script_texts.sql rename : sql/updates/10181_world_script_name.sql => sql/updates/3.3.5a_old/10181_world_script_name.sql rename : sql/updates/10182_world_script_texts.sql => sql/updates/3.3.5a_old/10182_world_script_texts.sql rename : sql/updates/10183_world_spell_script_names.sql => sql/updates/3.3.5a_old/10183_world_spell_script_names.sql rename : sql/updates/10189_world_script_texts.sql => sql/updates/3.3.5a_old/10189_world_script_texts.sql rename : sql/updates/10189_world_scriptname.sql => sql/updates/3.3.5a_old/10189_world_scriptname.sql rename : sql/updates/10189_world_spell_linked_spell.sql => sql/updates/3.3.5a_old/10189_world_spell_linked_spell.sql rename : sql/updates/10189_world_spell_script_names.sql => sql/updates/3.3.5a_old/10189_world_spell_script_names.sql rename : sql/updates/10192_world_creature.sql => sql/updates/3.3.5a_old/10192_world_creature.sql rename : sql/updates/10195_world_script_texts.sql => sql/updates/3.3.5a_old/10195_world_script_texts.sql rename : sql/updates/10206_world_creature_classlevelstats.sql => sql/updates/3.3.5a_old/10206_world_creature_classlevelstats.sql rename : sql/updates/10208_world_script_name.sql => sql/updates/3.3.5a_old/10208_world_script_name.sql rename : sql/updates/10208_world_script_texts.sql => sql/updates/3.3.5a_old/10208_world_script_texts.sql rename : sql/updates/10213_world_script_texts.sql => sql/updates/3.3.5a_old/10213_world_script_texts.sql rename : sql/updates/10215_world_spell_script_names.sql => sql/updates/3.3.5a_old/10215_world_spell_script_names.sql rename : sql/updates/10219_world_spelldifficulty_dbc.sql => sql/updates/3.3.5a_old/10219_world_spelldifficulty_dbc.sql rename : sql/updates/10223_world_spell_proc_event.sql => sql/updates/3.3.5a_old/10223_world_spell_proc_event.sql rename : sql/updates/10228_world_trinity_string.sql => sql/updates/3.3.5a_old/10228_world_trinity_string.sql rename : sql/updates/10230_world_script_texts.sql => sql/updates/3.3.5a_old/10230_world_script_texts.sql rename : sql/updates/10230_world_scriptname.sql => sql/updates/3.3.5a_old/10230_world_scriptname.sql rename : sql/updates/10230_world_spell_proc_event.sql => sql/updates/3.3.5a_old/10230_world_spell_proc_event.sql rename : sql/updates/10230_world_spell_script_names.sql => sql/updates/3.3.5a_old/10230_world_spell_script_names.sql rename : sql/updates/10241_characters_guilds.sql => sql/updates/3.3.5a_old/10241_characters_guilds.sql rename : sql/updates/10246_world_spell_linked_spell.sql => sql/updates/3.3.5a_old/10246_world_spell_linked_spell.sql rename : sql/updates/10246_world_spell_script_names.sql => sql/updates/3.3.5a_old/10246_world_spell_script_names.sql rename : sql/updates/10269_world_scriptname.sql => sql/updates/3.3.5a_old/10269_world_scriptname.sql rename : sql/updates/10281_world_gameobject_template.sql => sql/updates/3.3.5a_old/10281_world_gameobject_template.sql rename : sql/updates/10282_world_script_texts.sql => sql/updates/3.3.5a_old/10282_world_script_texts.sql rename : sql/updates/10284_world_script_texts.sql => sql/updates/3.3.5a_old/10284_world_script_texts.sql rename : sql/updates/10284_world_scriptname.sql => sql/updates/3.3.5a_old/10284_world_scriptname.sql rename : sql/updates/10284_world_spell_script_names.sql => sql/updates/3.3.5a_old/10284_world_spell_script_names.sql rename : sql/updates/10300_world_spell_script_names.sql => sql/updates/3.3.5a_old/10300_world_spell_script_names.sql rename : sql/updates/10307_world_spell_bonus_data.sql => sql/updates/3.3.5a_old/10307_world_spell_bonus_data.sql rename : sql/updates/10320_world_smart_scripts.sql => sql/updates/3.3.5a_old/10320_world_smart_scripts.sql rename : sql/updates/10320_world_waypoints.sql => sql/updates/3.3.5a_old/10320_world_waypoints.sql rename : sql/updates/10325_world_scriptname.sql => sql/updates/3.3.5a_old/10325_world_scriptname.sql rename : sql/updates/10327_world_spell_bonus_data.sql => sql/updates/3.3.5a_old/10327_world_spell_bonus_data.sql rename : sql/updates/10349_world_script_texts.sql => sql/updates/3.3.5a_old/10349_world_script_texts.sql
2010-10-17Core/Guilds: guild code was completely refactored and rewritten.azazel
* OOP desing and implementation; * all the queries are moved to prepared statements; * guild loading is optimized; * all the possible interaction with guild's data is done inside the guild class; * added more hooks to GuildScript class; WARNING: Make sure you backup your characters database before applying this change (just in case). Known problems with guilds: * when new member is added to the guild, MOTD is not displayed for him in guild tab of social window; * if you add item with random property to guild bank visual representation of item below it becomes wrong (it displays wrong stack number); * packets order differs from official: currently guild bank packet traffic is twice as more than on offy. --HG-- branch : trunk