aboutsummaryrefslogtreecommitdiff
path: root/sql/world.sql
AgeCommit message (Collapse)Author
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
2009-12-20* Added support for RepObjectiveFaction2 / RepObjectiveValue2 (oppositeBrian
* faction) IE: need to LOSE reputation with that faction. * Original patch by Brian / Ported to latest rev. by Kudlaty -- THANKS! --HG-- branch : trunk
2009-12-20Properly updated world.sql to current rev.teacher
world_spell_full.sql and world_trinity_string_full.sql files removed. From now on Devs will update world.sql only, whther it is matter of structure changes or data content for the tables which must be handled by core devs. All the other tables will be handled by DB projects. --HG-- branch : trunk
2009-12-20* Added support for GO type 6 (TRAP) to have a negative value in data6Brian
* This will allow proper data to be used --HG-- branch : trunk
2009-12-20Merge MaNGOS, Gossip System. Autor NoFantasy.win32
* DB support required * Closes #859 --HG-- branch : trunk
2009-12-20* Add support for the use of Gameobject type 10 (GOOBER) use when not on questBrian
* if data1=-1 --HG-- branch : trunk
2009-12-18Missing Changesn0n4m3
--HG-- branch : trunk
2009-12-18Added missing sql updatesn0n4m3
--HG-- branch : trunk
2009-12-17Added sql updates 3.1.3-3.2.2an0n4m3
--HG-- branch : trunk
2009-12-16MaNGOS merge: Mail System.win32
* Store loot in mail_loot_template indexed by mail template ids. * Implement proper creating mail text copy item from mail template based mail. * Move send functions to new MailDraft class from WorldSession. * Implement mails sending at player levelup. * Autor VladimirMangos, converted by me. --HG-- branch : trunk
2009-12-11* Change AllowableClass and AllowableRace fields to SIGNED INT to allow forBrian
* the larger values that are coming from WDB. * Thanks to Malcrom --HG-- branch : trunk
2009-11-26* Added support for questItem5 and questItem6 in creature and gameobjectBrian
* templates. * * Thanks to Malcrom for doing the research. --HG-- branch : trunk
2009-11-13QuestLevel can be -1. Quest with this level are allways show yellow ? above ↵Kudlaty
quest giver --HG-- branch : trunk
2009-11-01*Cleanup, fix many cases of unoptimized loops, potential crashes, ↵maximius
excessively large data types, unnecessary or wrong casts, non-standardized function calls, and so on.. *Proper Maexxna Web Spray locations (old locations sent players flying into the air) --HG-- branch : trunk
2009-09-21Reapply patch about changing modelid_a/h(2) values to modelid1..4, display ↵Kudlaty
ids are no longer incorrectly chosen based on player faction. --HG-- branch : trunk
2009-09-11*[8462] Fix database table to allow emote id bigger than 255 Author: Athormaximius
--HG-- branch : trunk