aboutsummaryrefslogtreecommitdiff
path: root/sql/base
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-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-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/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: Spell script for spells 62524,62525,62521 (Freya encounter)Lopin
Signed-off-by: Machiavelli <machiavelli.trinity@gmail.com>
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-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-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-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-25Scripts/Spells: Added support for Red Rider Air Rifle (item 46725)Shauren
--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-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-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
2010-12-20Core/Spells: Fix Improved Spirit Tap proc from Mind Flay crits.Machiavelli
Author: Dr.Tenma Fixes issue #2786 --HG-- branch : trunk
2010-12-17DB/Commands: Add some missing entries to commands table.;Machiavelli
Author: svetilo12 Closes issue #5015 --HG-- branch : trunk
2010-12-15DB Schema/Characters: removed columns auctionhouse.item_template, ↵azazel
character_inventory.item_template, guild_bank_item.item_entry and mail_items.item_template and created item_instance.itemEntry column instead of them. As a side effect moved related queries to prepared statements. As one more side effect fixed not shown and lost mail items in returned expired mail (patch by Quriq14). --HG-- branch : trunk
2010-12-11Core/Spells: Fix mage talent Frost Warding (and a little cleanup on ↵click
CalcAbsorbResist) - patch by DrTenma Fixes issue 2715. Closes issue 3770. --HG-- branch : trunk
2010-12-10Scripts/Quest: implement dummy effects for spells 43882, 50133 and aura ↵azazel
43874 for quests 11396/11399 Bring Down Those Shields (based on code by NoFantasy) --HG-- branch : trunk
2010-12-06SQL error corrections.leak
Fixes issue 5021 --HG-- branch : trunk
2010-12-04Core/Disables: Add flags SPELL_DISABLE_MAP and SPELL_DISABLE_AREA for ↵Machiavelli
sourceType DISABLE_TYPE_SPELL. This will allow you to disable spells on certain maps/areas. Note that you must have at least flag SPELL_DISABLE_PLAYER or SPELL_DISABLE_CREATURE or SPELL_DISABLE_PET set too, as they take preference. The parameters for mapIds and areaIds are defined in new columns params_0 and params_1 respectively, in a comma-seperated string. Example: INSERT INTO disables VALUES(0, 8921, (1+16+32), "571,1", "1519", "Moonfire Example"); This will disable spell moonfire for players in maps 571,1 and area 1519. --HG-- branch : trunk
2010-12-03Scripts/Icecrown Citadel: Added script for Blood Queen Lana'ThelShauren
Scripts/Icecrown Citadel: Fixed Invocation of Blood announcement emote for Blood Prince Council Scripts/Icecrown Citadel: Fixed intro for Lady Deathwhisper Scripts/Icecrown Citadel: Fixed Bone Spike for Lord Marrowgar --HG-- branch : trunk
2010-12-03Core/SQL: Added missing scriptnames to full sql, fixed typos and corrected ↵Shauren
delete statement in 10418_world_spell_script_names.sql (no need to reapply) --HG-- branch : trunk
2010-12-02Core/Chat: Configure automatic owner declaration for custom chat channels ↵click
(patch by leak) Closes issue 4974. --HG-- branch : trunk
2010-12-01Core/Database: Adjust character database fields to have an existing default ↵click
value (group_member) - fixes a transactionerror --HG-- branch : trunk
2010-11-19Core/DBLayer: Move tables reserved_name, gameobject_respawn and ↵click
creature_respawn from WORLD database to CHARACTER database as it's content is realm-specific and should be preserved (thanks to leak for the cleanup) *** TO PRESERVE (COPY) THE DATA CONTAINED IN THE OLD TABLES, YOU MUST FOLLOW THE FOLLOWING SQL-RECIPE (REPLACE DATABASENAMES WHERE NEEDED!) *** -- Move creature_respawn from world to characters db INSERT INTO `characters`.`creature_respawn` (`guid`, `respawntime`, `instance`) SELECT `guid, `respawntime` `instance` * FROM `world`.`creature_respawn`; -- Remove creature_respawn table from world db DROP TABLE `world`.`creature_respawn`; -- Move gameobject_respawn from world to characters db INSERT INTO `characters`.`gameobject_respawn` (`guid`, `respawntime`, `instance`) SELECT `guid`, `respawntime`, `instance` FROM `world`.`gameobject_respawn`; -- Remove creature_respawn table from world db DROP TABLE `world`.`gameobject_respawn`; -- Move reserved names from world to characters db INSERT INTO `characters`.`reserved_name` (`name`) SELECT `name` FROM `world`.`reserved_name`; -- Remove reserved_names table from world db DROP TABLE `world`.`reserved_name`; *** THE ABOVE MUST BE DONE, OR EXISTING INSTANCES WILL BE FULLY RESPAWNED - YOU HAVE BEEN WARNED *** Closes issue 4842. Closes issue 4849. --HG-- branch : trunk
2010-11-19Core/Commands: Enable SQL query logging by config and command )patch by leak)click
Closes issue 4853. --HG-- branch : trunk
2010-11-18Scripts/Icecrown Citadel: Changed spell timers for Lord Marrowgar, taken ↵Shauren
from sniffs Scripts/Icecrown Citadel: Converted texts to new TextMgr Scripts/Icecrown Citadel: General cleanup & coding style consistency Scripts/Icecrown Citadel: Added missing spell script names --HG-- branch : trunk
2010-11-17Core/Script: Add spellscript for Earthbind totem spell (patch by Socolin)click
--HG-- branch : trunk
2010-11-16Core/Scripts: Convert more commands over to CommandScripts (moves gobject, ↵click
honor, quest, reload, titles and wp commands to scripts) - Patch by Paradox (Also fixes a minor visual error on GM-listings (gm ingame/gm list) when the respective user had an R in his/her name). Closes issue 4792. --HG-- branch : trunk
2010-11-14Core: Allow toggling ticketsystem on/off by config-setting (patch by leak)click
Closes issue 4744. --HG-- branch : trunk
2010-11-12Core/Scripts: Reinstate commandscripts, now with extra bling and working ↵click
commands (and yes, we did test it thoroughly this time) Thanks to Paradox for sorting the commandscripts and chanhandlers out to work as they were intentionally ment to be like. --HG-- branch : trunk
2010-11-10Scripts/Spells: Added script for Animal Blood pool spawning (fixes fishing ↵Shauren
daily quest "Blood is Thicker") --HG-- branch : trunk
2010-11-10Core: Partial revert of rcb3188281e, rc85b35f076, r97f9a0fa3e due to missing ↵click
loader implementation. (files disabled but kept in repo, and will be fully reinstated once everything is sorted out) Note: SQL-update-data is NOT supplied for 're-converting' to old help-system - this is after all considered a workrepo untill we tag a commit as stable! --HG-- branch : trunk
2010-11-09Core/Scripts Part 1 of moving all commands to commandscriptsParadox
closes issue 4669 (first 5 patches rolled into 1) Patch by Paradox --HG-- branch : trunk
2010-11-09Core/Spells: Fix Sword Specialization (warrior) proc on abilitiesMachiavelli
Author: Dr.Tenma Fixes issue #4032 --HG-- branch : trunk
2010-11-09Core/Spells: Fix Shield of Righteousness damageMachiavelli
Author: Dr.Tenma Fixes issue #4174 --HG-- branch : trunk