aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2011-01-22Core/SQL: Add unique table key for (guid, bag, slot) in character_inventory ↵Machiavelli
to prevent storing different item entities in the same slot. NOTE: If you get import errors it's YOUR OWN RESPONSIBILITY to fix current data inconsistencies your database might have.
2011-01-22Scripts/Spells: Moved all special target filtering cases to scriptsShauren
2011-01-20Core/Scripts/Oculus: Implemented AI for boss Varos Cloudstrider <Azure-Lord ↵Manuel
of the Blue Dragonflight>. Signed-off-by: Manuel <manue.l@live.com.ar>
2011-01-20SQL: Characters db storage type cleanup No. 7 (final) - Note:leak
- It is _strongly_ recommended to extensively test the recent changes before applying them to live data - To fully resync the character db layout with TC releases it is recommended to dump the characters table with mysqldump --no-data characters > characters_database_livedata.sql and use a diff tool to compare it against sql/base/characters_database.sql
2011-01-20SQL: Characters db storage type cleanup No. 6leak
2011-01-20SQL: Characters db storage type cleanup No. 5leak
2011-01-19SQL: Characters db storage type cleanup No. 4leak
2011-01-19SQL: Characters db storage type cleanup No. 3 - Note:leak
There is a chance that you will be getting importing errors / data truncation warnings because of ancient invalid pet names. SELECT * FROM character_pet WHERE CHAR_LENGTH(`name`) > 21;
2011-01-19SQL: Characters db storage type cleanup No. 2leak
2011-01-19SQL: Characters db storage type cleanup #1 - Note:leak
- MySQL numeric types can NOT be altered in value range or or storage size at all, so things like INT(32) are entirely pointless. As TC currently doesn't use the display width of numeric types, use the default width to avoid confusion. (see MySQL numeric types docs) - Timestamps can be stored as INT(10) UNSIGNED. As the max value of this type is 4294967295 which translates into year 2106 using it as timestamp we are NOT affected by the year 2038 bug. If the timestamp needs to be negative in some cases, i.e. for displaying infinity using -1, use BIGINT(20) instead. - Do NOT set ROW_FORMAT for InnoDB tables unless you specifically want COMPRESSED tables (which we don't for performance reasons). MySQL will chose the appropriate ROW_FORMAT by itself depending on the innodb_file_format setting of the server. (FIXED is only available for MyISAM) - Even though VARCHAR does require less storage space than CHAR for values with variable length, the length still needs to be chosen wisely as this doesn't apply to memory consumption.
2011-01-19SQL: Resync characters db base SQL with rollups and redump with recent ↵leak
mysqldump version in preparation for char db storage type cleanup
2011-01-16SQL: Removed unused spell script name.Shauren
Scripts/Icecrown Citadel: Fixed Professor Putricide adds chasing different targets than selected. Scripts/Icecrown Citadel: Fixed Coldflame ticking twice because of too close spawning. Scripts/Icecrown Citadel: Fixed Coldflame affecting spiked targets.
2011-01-16Core/SQL: Fix SQL rollup file name. (Usually gets lost when batch applying ↵leak
with with *characters*.sql file mask)
2011-01-11Core/SQL: Fix up a few missing tables from base world_database import schema ↵click
and a few typos Thanks to Aokromes for the heads up ref the typos, and Oinquer on the missing tables.
2011-01-10Core/Spells: Fixed Spirit Walk ability of shaman's Feral Spirit summonsShauren
Closes #115 Signed-off-by: Shauren <shauren.dev@gmail.com>
2011-01-09Core/SQL: Assigned script npc_four_car_garage to creature 35273.Manuel
2011-01-09Core/SQL: Fix world_scripts_full.sql importMachiavelli
2011-01-09Core/SQL: Fixed typo in sql file name. Thanks to laly.Manuel
2011-01-09Core/Battleground: Implemented blizzlike script for Isle of Conquest, ↵Manuel
written by gyullo and me, based on Socolin's and Josh's patch -BIG THANKS TO THEM- Anyway the map is not yet playable, there are issues not related with the script. I also want to thanks to QAston, linencloth, Shauren and Machiavelli to be so patient with my questions.
2011-01-08Core/SQL: Move spell_script_names from world_database.sql to ↵Machiavelli
world_scripts_full.sql (they're called scripts for a reason)
2011-01-08Scripts/Ulduar: Some work on Kologarn:Machiavelli
- Get rid of UNIT_FLAG_STUNNED hack - Use proper spells instead of vehicle hacks - AI scripts for both arms instead of everything being defined in Kologarn's AI script - Proper support for detecting when to release players (Right Arm) Still todo: - Eyebeams - Rubbles - Achievements - Post-encounter doors/GO's toggling
2011-01-08Scripts/Ulduar: Spell script for spells 62524,62525,62521 (Freya encounter)Lopin
Signed-off-by: Machiavelli <machiavelli.trinity@gmail.com>
2011-01-08SQL: This table is handled by db teamShauren
2011-01-08Core/Spells: Fixed targeting for spell 49305 (missing unit target)McBitter
Signed-off-by: Shauren <shauren.dev@gmail.com>
2011-01-08Core/SQL: Fix a small typo in world_script_texts.sql messing up imports.click
Closes issue #63
2011-01-07SQL: Added missing sql from revision 855e910298691d5050a8Shauren
2011-01-06Scripts/Sholazar Basin: Fix quest 12645sarjuuk
Signed-off-by: Machiavelli <machiavelli.trinity@gmail.com>
2011-01-06Scripts/Northrend: Creature script for npc 29639, related to quest 12856sarjuuk
Signed-off-by: Machiavelli <machiavelli.trinity@gmail.com>
2011-01-04Core: Fix a ypo in world_script_texts.sql - thansk to fuchs for noticingclick
closes #38
2011-01-02Core/Spells: Cleaned up Shaman 4P Enhancement and Paladin 2P Retribution set ↵Shauren
bonus code SQL: Added missing sql for that revision, thx cyberbrest Closes #12
2011-01-02Restore sql patch numberingleak
2011-01-01Scripts/Pit of Saron: Rewrite Pit of Saron instanceDark0r
Signed-off-by: Shauren <krzysiek.7.5.4@gmail.com>
2010-12-31Scripts/Trial of the Crusader:John Holiver
1) Fix Leeching Swarm damage and create spell difficulty links to code. Closes issue #4909 . 2) Fix Valkyr's Touch. Closes issue #4553 . 3) Fix Permafrost aura difficulty check. 4) Reduce Slime Pool damage range. 5) Avoid Shaman Champion Heroism spam using 5 minutes (CD) as timer. 6) Fix many spell target selection to only select players (no more totens or pets). 7) Fix Anub'arak Spike being able to receibe the permafrost aura in order to cast spike fail, hopefully.
2010-12-30Core/ScriptSystem: Add OnEffectManaShield and AfterEffectManaShield hooks to ↵QAston
AuraScript class. Usage of these is the same as similar Absorb hooks. Scripts: Move Incanter's Absorbtion script from Unit::CalcAbsorbResist to AuraScript.
2010-12-30Core/Unit: Move spell specific code from Unit::CalcAbsorbResist to AuraScripts.QAston
2010-12-29Scripts: Correct function registration of ↵Machiavelli
spell_dru_moonkin_form_passive_AuraScript, fix intendation in world_database.sql Author: QAston
2010-12-28Core/DB:Machiavelli
- Only use configured PersistentFlags for character database cleaner to determine data saving behaviour during runtime, instead of all original flags set in worldstates. - Remove the forced deletion of abandoned quest entries in 10828_characters_character_queststatus.sql for those who do not want to lose that data. If you want to purge that data then run the core with CleanupFlags & 0x10. If you want to both purge the data now and prevent it from being saved in the future, run the core with CleanupFlags & 0x10 AND PersistentCleanupFlags & 0x10 --HG-- branch : trunk
2010-12-27Core/Unit: Big cleanup in Unit::CalcAbsorbResistQAston
Core/AuraScript: Fix compile time check for AuraScript functions Remove AuraApplication from hook functions parameter list, use GetTarget() and GetTargetApplication() instead Add OnEffectAbsorb hook Scripts: move handlers of Spell Deflection, Savage Defense, Primal Tenacity, Nerves of Steel, Astral shift from core to scripts. --HG-- branch : trunk
2010-12-26Scripts/Ulduar: Implement script for General Vezax encounter.Machiavelli
Based on original patch by Lopin -- thank you! --HG-- branch : trunk
2010-12-26SQL: Added missing update for previous revisionShauren
--HG-- branch : trunk
2010-12-26Core/QuestStatus:linencloth
- Separate rewarded quests from active quests, and store them in a new table to reduce database size - Drop the no longer needed `rewarded` column from character_queststatus for smaller table size - Prevent filling the database with dropped quests - Delete useless records - Implement queststatus save "queues" instead of states - Minor optimizations WARNING: Backup your database! --HG-- branch : trunk
2010-12-25SQL: Move old SQL updates in preperation for UP36runningnak3d
--HG-- branch : trunk rename : sql/updates/10383_world_version.sql => sql/updates/3.3.5a_old/10383_world_version.sql rename : sql/updates/10392_world_spell_bonus_data.sql => sql/updates/3.3.5a_old/10392_world_spell_bonus_data.sql rename : sql/updates/10393_world_spell_proc_event.sql => sql/updates/3.3.5a_old/10393_world_spell_proc_event.sql rename : sql/updates/10397_world_command.sql => sql/updates/3.3.5a_old/10397_world_command.sql rename : sql/updates/10402_world_spell_script_names.sql => sql/updates/3.3.5a_old/10402_world_spell_script_names.sql rename : sql/updates/10418_world_spell_script_names.sql => sql/updates/3.3.5a_old/10418_world_spell_script_names.sql rename : sql/updates/10419_world_spell_linked_spell.sql => sql/updates/3.3.5a_old/10419_world_spell_linked_spell.sql rename : sql/updates/10431_world_trinity_string.sql => sql/updates/3.3.5a_old/10431_world_trinity_string.sql rename : sql/updates/10436_world_script_texts.sql => sql/updates/3.3.5a_old/10436_world_script_texts.sql rename : sql/updates/10436_world_scriptname.sql => sql/updates/3.3.5a_old/10436_world_scriptname.sql rename : sql/updates/10453_world_creature_template.sql => sql/updates/3.3.5a_old/10453_world_creature_template.sql rename : sql/updates/10453_world_script_text.sql => sql/updates/3.3.5a_old/10453_world_script_text.sql rename : sql/updates/10460_world_command.sql => sql/updates/3.3.5a_old/10460_world_command.sql rename : sql/updates/10462_world_spell_script_names.sql => sql/updates/3.3.5a_old/10462_world_spell_script_names.sql rename : sql/updates/10468_world_script_texts.sql => sql/updates/3.3.5a_old/10468_world_script_texts.sql rename : sql/updates/10468_world_spell_script_names.sql => sql/updates/3.3.5a_old/10468_world_spell_script_names.sql rename : sql/updates/10470_world_command.sql => sql/updates/3.3.5a_old/10470_world_command.sql rename : sql/updates/10470_world_trinity_string.sql => sql/updates/3.3.5a_old/10470_world_trinity_string.sql rename : sql/updates/10475_characters_character_banned.sql => sql/updates/3.3.5a_old/10475_characters_character_banned.sql rename : sql/updates/10475_characters_creature_respawn.sql => sql/updates/3.3.5a_old/10475_characters_creature_respawn.sql rename : sql/updates/10475_characters_gameobject_respawn.sql => sql/updates/3.3.5a_old/10475_characters_gameobject_respawn.sql rename : sql/updates/10475_characters_reserved_name.sql => sql/updates/3.3.5a_old/10475_characters_reserved_name.sql rename : sql/updates/10490_world_scriptname.sql => sql/updates/3.3.5a_old/10490_world_scriptname.sql rename : sql/updates/10543_characters_group_member.sql => sql/updates/3.3.5a_old/10543_characters_group_member.sql rename : sql/updates/10545_world_script_texts.sql => sql/updates/3.3.5a_old/10545_world_script_texts.sql rename : sql/updates/10545_world_scriptname.sql => sql/updates/3.3.5a_old/10545_world_scriptname.sql rename : sql/updates/10548_characters_channel.sql => sql/updates/3.3.5a_old/10548_characters_channel.sql rename : sql/updates/10548_world_command.sql => sql/updates/3.3.5a_old/10548_world_command.sql rename : sql/updates/10548_world_trinity_string.sql => sql/updates/3.3.5a_old/10548_world_trinity_string.sql rename : sql/updates/10561_world_achievement_criteria_data.sql => sql/updates/3.3.5a_old/10561_world_achievement_criteria_data.sql rename : sql/updates/10561_world_scriptname.sql => sql/updates/3.3.5a_old/10561_world_scriptname.sql rename : sql/updates/10561_world_spell_linked_spell.sql => sql/updates/3.3.5a_old/10561_world_spell_linked_spell.sql rename : sql/updates/10561_world_spell_script_names.sql => sql/updates/3.3.5a_old/10561_world_spell_script_names.sql rename : sql/updates/10563_world_scriptname.sql => sql/updates/3.3.5a_old/10563_world_scriptname.sql rename : sql/updates/10570_world_disables.sql => sql/updates/3.3.5a_old/10570_world_disables.sql rename : sql/updates/10619_world_spell_script_names.sql => sql/updates/3.3.5a_old/10619_world_spell_script_names.sql rename : sql/updates/10623_world_spell_bonus_data.sql => sql/updates/3.3.5a_old/10623_world_spell_bonus_data.sql rename : sql/updates/10646_world_scriptname.sql => sql/updates/3.3.5a_old/10646_world_scriptname.sql rename : sql/updates/10654_characters_item_instance.sql => sql/updates/3.3.5a_old/10654_characters_item_instance.sql rename : sql/updates/10681_world_command.sql => sql/updates/3.3.5a_old/10681_world_command.sql rename : sql/updates/10733_world_spell_proc_event.sql => sql/updates/3.3.5a_old/10733_world_spell_proc_event.sql rename : sql/updates/10736_world_scriptname.sql => sql/updates/3.3.5a_old/10736_world_scriptname.sql rename : sql/updates/10741_characters_character_aura.sql => sql/updates/3.3.5a_old/10741_characters_character_aura.sql rename : sql/updates/10765_world_scriptname.sql => sql/updates/3.3.5a_old/10765_world_scriptname.sql rename : sql/updates/10765_world_spell_dbc.sql => sql/updates/3.3.5a_old/10765_world_spell_dbc.sql rename : sql/updates/10777_characters_creature_respawn.sql => sql/updates/3.3.5a_old/10777_characters_creature_respawn.sql rename : sql/updates/10777_characters_gameobject_respawn.sql => sql/updates/3.3.5a_old/10777_characters_gameobject_respawn.sql rename : sql/updates/10801_world_creature_linked_respawn.sql => sql/updates/3.3.5a_old/10801_world_creature_linked_respawn.sql rename : sql/updates/10806_world_scriptname.sql => sql/updates/3.3.5a_old/10806_world_scriptname.sql rename : sql/updates/10815_world_spell_script_names.sql => sql/updates/3.3.5a_old/10815_world_spell_script_names.sql
2010-12-25Scripts/Spells: Added support for Red Rider Air Rifle (item 46725)Shauren
--HG-- branch : trunk
2010-12-24Scripts/Orgrimmar: Remove a not finished quest script. Proper quest support ↵Machiavelli
will be included in a future TDB release. Author: Nay --HG-- branch : trunk
2010-12-24Core/Entities:Machiavelli
- Rename creature_linked_respawn to linked_respawn - Update functionality: add field ´linkType´. ** 0 = creature respawn dependant on creature (default) ** 1 = creature respawn dependant on gameobject ** 2 = gameobject respawn dependant on gameobject ** 3 = gameobject respawn dependant on creature --HG-- branch : trunk
2010-12-24Buildsystem: Stop the retarded recursive hunting for CMakeLists.txt when ↵click
copying SQL-files nad use the proper method for direct copying. Closes issue 5240 --HG-- branch : trunk
2010-12-23Core: Fixed occasional wrong order of async operations at respawn time ↵Xanadu
saving. Closes issue #5239. DB schema: Sorted out a discrepancy in respawn time column format. --HG-- branch : trunk
2010-12-22Missing DELETE statement in 10765_world_spell_dbc.sqlMachiavelli
--HG-- branch : trunk
2010-12-22Scripts/Ulduar:Machiavelli
- Fix Rune of Summoning + use correct spell for Lightning Elemental passive + fix a crash - Fix Rune of Power - thanks to Shauren for spell target help (see DB data) ** Note: Aura system bug causes Rune of Power aura to be reapplied every 0.5 second - Prevent engaging bosses one by one - Respawn bosses if encounter failed - Fix supercharge appliance and stacking - Add a few missing changes to instance data saving fix from a85e26e211 - Cleanup --HG-- branch : trunk
2010-12-20Core/Auras: Save cast item guids for auras to dbShauren
--HG-- branch : trunk