aboutsummaryrefslogtreecommitdiff
path: root/sql/world.sql
AgeCommit message (Collapse)Author
2010-02-04Fixed Ritual of Souls, implemented soulwell giving healthstones according to ↵Xanadu
warlock's Improved Healthstone talent points. --HG-- branch : trunk
2010-02-02*Drop spell_stack_masks tableQAston
*Add spell_group_stack_rules table (for more info see wiki) *The table is maintained by core team *Move some spell specific out of core to the new table --HG-- branch : trunk
2010-02-01*drop spell_elixir tableQAston
*add spell_group table for storage of groups of spell (kinda obvious, isn't it?) and populate the table with converted spell_elixir table data *the table is going to be maintained by core team *fix percentage display at spell_ranks table loading *add TARGET_UNIT_CASTER to allowed learn spell targets in npc_trainer table, thanks to Aokromes for noticing the issue. --HG-- branch : trunk
2010-02-01Updated world.sql and characters.sql.teacher
Removed commented code form realm.sql and set account.expansion field default value to 2 (wotlk) (thx Aokromes). Properly set default values for some world DB fields. Properly set some world DB fields to allow Database import in strict mode (by Brian). Updated world_script_full with recent committed npc script. Renamed a couple of files with proper revision number. Note: no DB data will changed nor harmed by this commit. --HG-- branch : trunk
2010-01-31* Backed out changeset af19f9ff6dd8Brian
* Spell ranks are handled by the (imagine this) spell_ranks table * Data already in spell_ranks for these spells * Thanks QAston --HG-- branch : trunk
2010-01-31* Add spell required data for Totem of Wrath ranks 2-4Brian
* Thanks Wladass --HG-- branch : trunk
2010-01-31*Drop no longer needed sql table.QAston
--HG-- branch : trunk
2010-01-30*Add error checks at spell_required table loadingQAston
*Allow spell_required table to store more than 1 spell learn requirement for a spell *spell_required table data is removed from world.sql and since this commit the data for it should be maintained by db project you're using. --HG-- branch : trunk
2010-01-30* Set auto increment values for creature and gameobject GUIDs outside of TDBBrian
ranges. * All custom content should have GUIDs > 250000 for `creature` and GUIDs > 200000 for `gameobject` --HG-- branch : trunk
2010-01-29* Changed the default security levels for some commandsBrian
* Deleted no longer used loadscripts command * Updated security levels in the command table to match defaults in the core --HG-- branch : trunk
2010-01-29*Typofix - Journeyman - rank 2 Apprentice - rank1QAston
--HG-- branch : trunk rename : sql/updates/7232_world_spell_ranks.sql => sql/updates/7233_world_spell_ranks.sql
2010-01-29*Move spell rank extractor out of core, use sql table instead for easier ↵QAston
maintaining of dependant database data. --HG-- branch : trunk
2010-01-27Fixed hunter trap procs - Entrapment and Lock and Load shall be henceforth ↵Xanadu
proced only by the correct traps. Closes issue #110. --HG-- branch : trunk
2010-01-26* Added a stupidity check into world.sql so it can not be importedBrian
* accidentally --HG-- branch : trunk
2010-01-24Some good old fashioned proper Trinity Standard sql renaming and formatting.nihal
Also added missing data to world.sql. --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* Wintergrasp removal part 2Brian
--HG-- branch : trunk
2010-01-16Update gossip_menu_option data by Maximius.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-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-13Missing updated file added for last commit.teacher
How about me saving the damn file before committing first... --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* add armor output in .npc infoBrian
--HG-- branch : trunk
2010-01-10*spell_linked_spell entry for Deterrance. Resolves #237.QAston
--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-07* Added support for outputting phasemask in .npc infoBrian
--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
2010-01-05DB update to have correct Windfury proc chance for already commited hack :)Astellar
--HG-- branch : trunk
2010-01-05Glyph of Blocking proc moved to DB.Astellar
--HG-- branch : trunk
2010-01-05SQL changes for previous commit.Astellar
--HG-- branch : trunk
2010-01-02Removed moveflags column from creature_addon and creature_template_addon. ↵_manuel_
Thanks to Zor and raczman. --HG-- branch : trunk
2010-01-02Fix Art of War to only proc off critical hits. Thanks Visagalisp0wer
--HG-- branch : trunk
2009-12-28Change ppm (max procs per minute) to be read from the dbc. Seal of Command ↵p0wer
will no longer be limited to 7 procs per minute, and will now be able to cast on every hit. --HG-- branch : trunk
2009-12-27Added explanation about Spell Linked Spell in world.sql, it is also in the wiki._manuel_
--HG-- branch : trunk
2009-12-27Fixed spell 66865 used by Boss Eadric the Pure._manuel_
--HG-- branch : trunk
2009-12-26Support for spell 66680 used by Boss Argent Confessor Paletress.maanuel
--HG-- branch : trunk
2009-12-26Fixed spell Reaping, thx Themris.n0n4m3
--HG-- branch : trunk
2009-12-23* More updates to creature_classlevelstats. By Malcrom.p0wer
--HG-- branch : trunk
2009-12-23* Delete now unused "reload npc_option" chat command.XTZGZoReX
--HG-- branch : trunk
2009-12-21* Add support for different gmlevel's for different realms.p0wer
* * Using the value -1 will add the same value for all realms. * Make sure to apply the updates. * Information regarding this patch will be posted on the database forums soon. * * Thanks to Sundark and the Ilixiuemu team(for original patch) --HG-- branch : trunk
2009-12-21Add spell proc for Glyph of Seal of Commandwin32
--HG-- branch : trunk
2009-12-20Support for spell Emerge Summon (54851) used by Drakkari Colossus. Please ↵maanuel
apply too the sql fix for commit 6674 on tdb forums. --HG-- branch : trunk
2009-12-20* Fixed SQL in commit 6666Brian
--HG-- branch : trunk
2009-12-20* Added support for using a lookup table for creature mana / healthBrian
* As long as creature level, class, and the proper expansion they are from are * set in creature_template, you will have 100% accurate health and mana. * Research and base stats table done by Malcrom -- THANK YOU! * Original patch by Kudlaty -- THANK YOU! * Updated and enhanced by Machiavelli - THANK YOU! * Optimizations by w12x, MrSmite, and XTZGZoReX -- THANK YOU! * Final code updating for current rev by XTZGZoReX -- THANK YOU! --HG-- branch : trunk