aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
AgeCommit message (Collapse)Author
2010-01-23* Fix CRLF.XTZGZoReX
--HG-- branch : trunk
2010-01-23table create for previous committhenecromancer
--HG-- branch : trunk
2010-01-22* Fixed a typo in 7147_world_creature_template.sql that prevented importBrian
--HG-- branch : trunk
2010-01-21* SQL need to restore the *structure* of the DB after the backoutBrian
* from the previous commit --HG-- branch : trunk
2010-01-21* Backed out changeset c7c6faf26cbdBrian
* A different solution to damage will be implemented * You will need data from your DB provider if you don't have a backup --HG-- branch : trunk
2010-01-21* Add support for basedmg and baserangeddmg values in creature_classlevelstats.win32
* Remove mindmg, maxdmg, attackpower and ranged field in creature_template and add Dmg_Mod, Rangeddmg_Mod field. --HG-- branch : trunk
2010-01-21update sql in prev commit to trinity formatwin32
--HG-- branch : trunk
2010-01-21Implement new commands for add/remove/lookup titles.win32
Autor Vladimir. --HG-- branch : trunk
2010-01-20* Wintergrasp removal -- part 4: "How deep does the cancer run?"Brian
--HG-- branch : trunk
2010-01-20* Add basic AddonMgr.XTZGZoReX
* All this really does at the moment is save addon names + CRCs to DB for use for.. whatever, later. --HG-- branch : trunk
2010-01-20* Wintergrasp removal part 3 (should be *FINAL*)Brian
--HG-- branch : trunk
2010-01-20* Wintergrasp removal part 2Brian
--HG-- branch : trunk
2010-01-18Fix Script Naxxramas/GothikTrazom62
- fix spell of adds - fix wave schedule to use correct entry --HG-- branch : trunk
2010-01-18Implemented script for item Petrov's Cluster Bombs, code from ScriptDev2._manuel_
--HG-- branch : trunk
2010-01-18FIx sql naming and some small sql cosmetics.teacher
--HG-- branch : trunk
2010-01-17Fix Script Naxxramas/Gothik with help of scarymovie87Trazom62
Fixes issue #80. - Implement support for "merging" life and dead side after ~2 minutes, if group is not splitted - Implement support for opening central gate at 30% boss health - Implement Gothik teleport between side when above 30% boss health - Fix dead-side mobs spawn in 25-Man difficulty - Fix waves setup. - Fix some timers (this may still need some tuning). - Fix sporadic combat reset when Gothic teleport to ground. --HG-- branch : trunk
2010-01-16Added update file for previous commit.teacher
--HG-- branch : trunk
2010-01-16Add Argent Tournament Target Dummies by kaelima.teacher
--HG-- branch : trunk
2010-01-16Add Trigger teleport to acherus (for quest 12757) by denyde.teacher
Added missing data to world.sql. --HG-- branch : trunk
2010-01-16Fixed typo._manuel_
--HG-- branch : trunk
2010-01-16Dustwallow Marsh: Implemented basic support for quest "Cleansing Witch Hill" ↵_manuel_
(11183). --HG-- branch : trunk
2010-01-15Dustwallow Marsh: Implemented improvements in scripts to make quest "What's ↵_manuel_
Haunting Witch Hill?" more blizzlike. --HG-- branch : trunk
2010-01-14Fix for Relic of the Earthen Ring quest (spell Totem of the Earthen Ring ↵teacher
must be casted). Thank you Nayre for the fix. --HG-- branch : trunk
2010-01-14* Add support for waypoint wisp's level to show the point of the waypointBrian
* Author Kaelima * Thanks Malcrom for the idea --HG-- branch : trunk
2010-01-14Gnomeregan: Implemented Blastmaster Emi Shortfuse Event._manuel_
--HG-- branch : trunk
2010-01-13* Added GO script for Inconspicuous Landmark (142189) needed for quest 2882Brian
* Thanks manuel for the help! * Needs additional DB data for quest to work. --HG-- branch : trunk
2010-01-12* Renamed 3.2.2.a_old to 3.2.2a_old (proper format)Brian
* Fixes cmake complaining :) --HG-- branch : trunk rename : sql/updates/3.2.2.a_old/6589_characters_bugreport.sql => sql/updates/3.2.2a_old/6589_characters_bugreport.sql rename : sql/updates/3.2.2.a_old/6589_characters_character_action.sql => sql/updates/3.2.2a_old/6589_characters_character_action.sql rename : sql/updates/3.2.2.a_old/6589_characters_character_aura.sql => sql/updates/3.2.2a_old/6589_characters_character_aura.sql rename : sql/updates/3.2.2.a_old/6589_characters_character_spell_cooldown.sql => sql/updates/3.2.2a_old/6589_characters_character_spell_cooldown.sql rename : sql/updates/3.2.2.a_old/6589_characters_characters.sql => sql/updates/3.2.2a_old/6589_characters_characters.sql rename : sql/updates/3.2.2.a_old/6589_characters_groups.sql => sql/updates/3.2.2a_old/6589_characters_groups.sql rename : sql/updates/3.2.2.a_old/6589_characters_instance_reset.sql => sql/updates/3.2.2a_old/6589_characters_instance_reset.sql rename : sql/updates/3.2.2.a_old/6589_characters_spell.sql => sql/updates/3.2.2a_old/6589_characters_spell.sql rename : sql/updates/3.2.2.a_old/6589_realmd_realmlist.sql => sql/updates/3.2.2a_old/6589_realmd_realmlist.sql rename : sql/updates/3.2.2.a_old/6589_world_battleground_template.sql => sql/updates/3.2.2a_old/6589_world_battleground_template.sql rename : sql/updates/3.2.2.a_old/6589_world_creature_template.sql => sql/updates/3.2.2a_old/6589_world_creature_template.sql rename : sql/updates/3.2.2.a_old/6589_world_instance_template.sql => sql/updates/3.2.2a_old/6589_world_instance_template.sql rename : sql/updates/3.2.2.a_old/6589_world_item_template.sql => sql/updates/3.2.2a_old/6589_world_item_template.sql rename : sql/updates/3.2.2.a_old/6589_world_player_classlevelstats.sql => sql/updates/3.2.2a_old/6589_world_player_classlevelstats.sql rename : sql/updates/3.2.2.a_old/6589_world_playercreateinfo_action.sql => sql/updates/3.2.2a_old/6589_world_playercreateinfo_action.sql rename : sql/updates/3.2.2.a_old/6589_world_playercreateinfo_spell.sql => sql/updates/3.2.2a_old/6589_world_playercreateinfo_spell.sql rename : sql/updates/3.2.2.a_old/6589_world_quest_template.sql => sql/updates/3.2.2a_old/6589_world_quest_template.sql rename : sql/updates/3.2.2.a_old/6589_world_spell_bonus_data.sql => sql/updates/3.2.2a_old/6589_world_spell_bonus_data.sql rename : sql/updates/3.2.2.a_old/6589_world_spell_elixir.sql => sql/updates/3.2.2a_old/6589_world_spell_elixir.sql rename : sql/updates/3.2.2.a_old/6589_world_spell_proc_event.sql => sql/updates/3.2.2a_old/6589_world_spell_proc_event.sql rename : sql/updates/3.2.2.a_old/6597_world_spell_proc_event.sql => sql/updates/3.2.2a_old/6597_world_spell_proc_event.sql rename : sql/updates/3.2.2.a_old/6643_world_gameobject_template.sql => sql/updates/3.2.2a_old/6643_world_gameobject_template.sql rename : sql/updates/3.2.2.a_old/6644_world_creature_template.sql => sql/updates/3.2.2a_old/6644_world_creature_template.sql rename : sql/updates/3.2.2.a_old/6644_world_gossip_menu.sql => sql/updates/3.2.2a_old/6644_world_gossip_menu.sql rename : sql/updates/3.2.2.a_old/6644_world_gossip_menu_option.sql => sql/updates/3.2.2a_old/6644_world_gossip_menu_option.sql rename : sql/updates/3.2.2.a_old/6644_world_gossip_scripts.sql => sql/updates/3.2.2a_old/6644_world_gossip_scripts.sql rename : sql/updates/3.2.2.a_old/6644_world_locales_npc_option.sql => sql/updates/3.2.2a_old/6644_world_locales_npc_option.sql rename : sql/updates/3.2.2.a_old/6644_world_npc_gossip_textid.sql => sql/updates/3.2.2a_old/6644_world_npc_gossip_textid.sql rename : sql/updates/3.2.2.a_old/6644_world_npc_option.sql => sql/updates/3.2.2a_old/6644_world_npc_option.sql rename : sql/updates/3.2.2.a_old/6644_world_scriptname.sql => sql/updates/3.2.2a_old/6644_world_scriptname.sql rename : sql/updates/3.2.2.a_old/6645_world_gameobject_template.sql => sql/updates/3.2.2a_old/6645_world_gameobject_template.sql rename : sql/updates/3.2.2.a_old/6649_world_scriptname.sql => sql/updates/3.2.2a_old/6649_world_scriptname.sql rename : sql/updates/3.2.2.a_old/6655_world_spell_bonus_data.sql => sql/updates/3.2.2a_old/6655_world_spell_bonus_data.sql rename : sql/updates/3.2.2.a_old/6657_world_spell_proc_event.sql => sql/updates/3.2.2a_old/6657_world_spell_proc_event.sql rename : sql/updates/3.2.2.a_old/6664_world_quest_template.sql => sql/updates/3.2.2a_old/6664_world_quest_template.sql rename : sql/updates/3.2.2.a_old/6665_world_creature_classlevelstats.sql => sql/updates/3.2.2a_old/6665_world_creature_classlevelstats.sql rename : sql/updates/3.2.2.a_old/6665_world_creature_template.sql => sql/updates/3.2.2a_old/6665_world_creature_template.sql rename : sql/updates/3.2.2.a_old/6669_world_creature_template.sql => sql/updates/3.2.2a_old/6669_world_creature_template.sql rename : sql/updates/3.2.2.a_old/6675_world_spell_linked_spell.sql => sql/updates/3.2.2a_old/6675_world_spell_linked_spell.sql rename : sql/updates/3.2.2.a_old/6676_world_script_texts.sql => sql/updates/3.2.2a_old/6676_world_script_texts.sql rename : sql/updates/3.2.2.a_old/6678_world_creature_classlevelstats.sql => sql/updates/3.2.2a_old/6678_world_creature_classlevelstats.sql rename : sql/updates/3.2.2.a_old/6686_world_scriptname.sql => sql/updates/3.2.2a_old/6686_world_scriptname.sql rename : sql/updates/3.2.2.a_old/6691_world_spell_proc_event.sql => sql/updates/3.2.2a_old/6691_world_spell_proc_event.sql rename : sql/updates/3.2.2.a_old/6694_world_item_template.sql => sql/updates/3.2.2a_old/6694_world_item_template.sql rename : sql/updates/3.2.2.a_old/6710_realmd_account_access.sql => sql/updates/3.2.2a_old/6710_realmd_account_access.sql rename : sql/updates/3.2.2.a_old/6710_world_command.sql => sql/updates/3.2.2a_old/6710_world_command.sql rename : sql/updates/3.2.2.a_old/6710_world_trinity_string.sql => sql/updates/3.2.2a_old/6710_world_trinity_string.sql rename : sql/updates/3.2.2.a_old/6711_world_creature_classlevelstats.sql => sql/updates/3.2.2a_old/6711_world_creature_classlevelstats.sql rename : sql/updates/3.2.2.a_old/6712_realmd_account_access.sql => sql/updates/3.2.2a_old/6712_realmd_account_access.sql rename : sql/updates/3.2.2.a_old/6739_world_script_waypoints.sql => sql/updates/3.2.2a_old/6739_world_script_waypoints.sql rename : sql/updates/3.2.2.a_old/6742_world_script_texts.sql => sql/updates/3.2.2a_old/6742_world_script_texts.sql rename : sql/updates/3.2.2.a_old/6742_world_script_waypoints.sql => sql/updates/3.2.2a_old/6742_world_script_waypoints.sql rename : sql/updates/3.2.2.a_old/6742_world_scriptname.sql => sql/updates/3.2.2a_old/6742_world_scriptname.sql rename : sql/updates/3.2.2.a_old/6748_world_command.sql => sql/updates/3.2.2a_old/6748_world_command.sql rename : sql/updates/3.2.2.a_old/6751_world_creature_classlevelstats.sql => sql/updates/3.2.2a_old/6751_world_creature_classlevelstats.sql
2010-01-13Fixed typo in previous commit. I misunderstood the fix.teacher
Thank you Aokromes for being there! --HG-- branch : trunk
2010-01-13Added long forgotten sql update for Rev6693 (Add support for ↵teacher
RewSpellCast=-1. If -1 remove all auras applied to player at quest start). Thank you Warhead. --HG-- branch : trunk
2010-01-12Fix stats table to update 2 missing health values by Malcrom._manuel_
--HG-- branch : trunk
2010-01-12Sholazar Basin: Core support for quest Crocolisk Mastery: The Ambush ._manuel_
--HG-- branch : trunk
2010-01-13world.sql finally updated to current rev.teacher
Finished renaming single sql update files. --HG-- branch : trunk
2010-01-13Second part of sql files renaming not following Trinity standard.teacher
Update world.sql too. Final part later today to complete the work. --HG-- branch : trunk
2010-01-12First part of renaming sql update files which did not respect Trinity standard.teacher
Moved old sql update files to sql\updates\3.2.2a_old folder. --HG-- branch : trunk
2010-01-11Fixes Issue #153. Earth Shield should not proc from positive spells. So flag ↵Astellar
PROC_FLAG_TAKEN_POSITIVE_MAGIC_SPELL is removed. --HG-- branch : trunk
2010-01-10* Add support for .gobj target to output phaseMaskBrian
* Thanks to Aokromes for the original idea of adding it to .npc info output. --HG-- branch : trunk
2010-01-10* Aaaaand, the SQL for the last commit. All done by Malcrom <3.XTZGZoReX
--HG-- branch : trunk
2010-01-10* Fix a typo in spell id number - thanks to Visagalis for pointing this out.QAston
--HG-- branch : trunk rename : sql/updates/6959_characters_character_aura.sql => sql/updates/6962_characters_character_aura.sql rename : sql/updates/6959_characters_pet_aura.sql => sql/updates/6962_characters_pet_aura.sql
2010-01-10* Fix a mistake in boss_satharion script which gave players very usefull ↵QAston
auras... --HG-- branch : trunk
2010-01-10Removed unnecessary sentence._manuel_
--HG-- branch : trunk
2010-01-10* add armor output in .npc infoBrian
--HG-- branch : trunk
2010-01-10All sql updates MUST have at least one newline at the end.Paradox
--HG-- branch : trunk
2010-01-10Fixed quest 11881 by Kudlaty._manuel_
--HG-- branch : trunk
2010-01-10*spell_linked_spell entry for Deterrance. Resolves #237.QAston
--HG-- branch : trunk
2010-01-10*MergeQAston
--HG-- branch : trunk
2010-01-10Update aura system:QAston
* Change system logic - unify Auras, AreaAuras and PersistentAreaAuras: * Aura has now its owner - which is the WorldObject, which applies aura (creates AuraApplication object) dependant on aura radius, and effect type * Owner can be Dynobj (DynObjAura class) for PersistentAreaAuras, or Unit (UnitAura class) for Area and nonArea auras * Aura data is shared for all units which have AuraApplication of the Aura * Because of that AuraEffect handlers , and periodic tick functions can't modify AuraEffect object (they are const now) * Remove spell source and AreaAuraEffect classes * Add AuraEffect::UpdatePeriodic function, to allow periodic aura object modification (target independant) * Add AuraEffect::CalculateAmount and AuraEffect::CalculateSpellMod function, to allow non-default amount calculation * AreaAura updates are done in owner _UpdateSpells cycle * Since now you don't need to wait an aura update cycle to get area aura applied on it's correct target list * And you can access area aura target list * Add basic support for aura amount recalculation * Save recalculation state and base amount of auras to db * Add AuraEffect::CalculatePeriodic function to determine if aura is periodic, and to set correct tick number after aura is loaded from db * Add ChangeAmount function in addition to SetAmount function, to allow easy reapplication of AuraEffect handlers on all targets * Sort aura effect handlers in SpellAuras.cpp and .h by their use * Add check for already existing aura of that type to some AuraEffect handlers, to prevent incorrect effect removal * SPELL_AURA_CONVERT_RUNE and MOD_POWER_REGEN and MOD_REGEN hacky handlers are now implemented correctly * Send aura application client update only once per unit update - prevent unnecesary packet spam * Fix ByteBuffer::appendPackGUID function - it added additionall 0s at the end of the packet * Fix memory leak at player creation (not deleted auras) * Updated some naming conventions (too many to mention) * Added Unit::GetAuraOfRankedSpell() function * Remove procflags on aura remove, use Aura::HandleAuraSpecificMods instead * Added functions to maintain owned auras (GetOwnedAuras, GetOwnedAura, RemoveOwnedAura, etc) * Implement AURA_INTERRUPT_FLAG_LANDING * Implement EffectPlayerNotification (thanks to Spp) * Remove wrong aura 304 handler * Add better handler for death runes * Remove unnecesary variables from DynamicObject class, and cleanup related code, link dynobj duration with aura * Add GetAuraEffectTriggerTarget function in CreatureAi for special target selection for periodic trigger auras used in a script * Add many assert() procection from idiots using some functions in wrong way * I am to lazy to write here anything more Thanks to Visagalis for testing this patch PS: Do not make patches like this, please --HG-- branch : trunk
2010-01-09Add missing scripts to world_scripts_full script ↵Paradox
instance_trial_of_the_champion will still throw an error, until someone adds an instance template for it (map 530), and assigns the scriptname again. --HG-- branch : trunk
2010-01-07* Added support for outputting phasemask in .npc infoBrian
--HG-- branch : trunk
2010-01-07Deadmines: Implemented Mr.Smite chest event._manuel_
--HG-- branch : trunk
2010-01-07Fixes issue 152. Now Improved Water Shield works as intended.Astellar
1. Removed hardcoded proc chance for Lesser Healing Wave (all ranks had equal proc chance). 2. Added proc chance for Chain Heal (patch 3.2). 3. Fixed bug with Lesser Healing Wave and Chain Heal rolled default spell proc chance at first and then correct chance in dummy proc. So they have never ever proced for low ranks of the talent. 4. Removed consumption of charges (patch 3.2). --HG-- branch : trunk