aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
AgeCommit message (Collapse)Author
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-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-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
2010-12-20Scripts/HoL:azazel
* fix Volkhan script: after losing 20% HP Volkhan is supposed to run back to his Anvil and smack it with his hammer. 3 Golems are supposed to fly out of it and spawn (by LethalInjectionX) Closes issue #3895 * fix instance doors to remain open after use (by msholto) Closes issue #4773 Both fixes tested and approved by Aokromes. NOTE: Do not forget the DB part of the commit! --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-14Scripts/Icecrown Citadel: Minor adjustments and compile warning fixesShauren
--HG-- branch : trunk
2010-12-12Fixed line endings in 10623_world_spell_bonus_dataShauren
Scripts/Naxxramas: Fixed a possible crash in instance script --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-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-03Core/Scripts: Implemented core script for quest "Stunning Defeat at the ↵_manuel_
Ring" (11300), original code from ScriptDev2 thanks to kiper for porting, also for a full functionality for this quest you need the DB scripts made by him. --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-03Core/Scripts: Adjust SQL-update for 10462 to include a delete-query for the ↵click
affected spell (prevents a possible reinsert-error during import) Thanks to leak for noticing. --HG-- branch : trunk
2010-12-02Core/Chat: Fix issues introduced in 177d6f86caclick
+ Wrong update-query for the channels-table (SQL from 10548 sorted properly) + Add a small correction on Channel.cpp say handling (thanks to Lazzalf/Leak) --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/Scripts: Implemented script for quest The hunt is on (11794)._manuel_
--HG-- branch : trunk
2010-12-01Core/Database: Rename update-file for previous commit, it's for characters, ↵click
not for world ... danged old habbits... --HG-- branch : trunk rename : sql/updates/10543_world_group_member.sql => sql/updates/10543_characters_group_member.sql
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-27DB/Data: Correction on script_texts for quest Discrediting the Deserters ↵click
(11133) when not using default (english) language- thanks to Dark0r for noticing REIMPORT THE FIXED SQL. --HG-- branch : trunk
2010-11-21Core/Scripts: Add support for questID 25444 (Da Perfect Spies)click
--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-19Fixed line endingsShauren
--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-16Scripts: Fix quests "...Or Maybe We Don't" and "Smoke 'Em Out"Spp
Author: Lopin Closes issue 4741 --HG-- branch : trunk
2010-11-14Misc: Some engrish fixes, thanks to ZxBiohazardZx, closes issue 4740Shocker
--HG-- branch : trunk