aboutsummaryrefslogtreecommitdiff
path: root/sql/world.sql
AgeCommit message (Collapse)Author
2010-03-13Allow Battlegrounds and arenas to be disabled by DB.Spp
wtlk arenas disabled by default. - Player will continue to see all bgs using UI, but won't be able to join disabled bg's - Gossip menu not shown for disabled Bgs/arenas - Id 6 disabled = all arenas disabled. - Only id 6 arena enabled = Gossip shown but unable to join any arena --HG-- branch : trunk
2010-03-12Some Ticket text formating changes to help addons to parse dataSpp
Linked issue 466 --HG-- branch : trunk
2010-03-12Add map and zone to account onlinelist command.Spp
Closes issue 466 --HG-- branch : trunk
2010-03-12Move vehicle accesories to DB.Spp
Credit to Malcrom and Manuel for the idea and original patch --HG-- branch : trunk
2010-03-09Typo in server shutdown command.Spp
Original author VladimirMangos Closes issue #57 --HG-- branch : trunk
2010-03-09Add level restrictions to some commands:Spp
say, yell, emote, whisper, channel use, trade, auction, mail, tickets By azazel. Closes issue #598 --HG-- branch : trunk
2010-03-02* Add support for sending quest completion textBrian
* Original patch by NoFantasy - thank you * Ported to Trinity by seirgy - thank you * Closes issue #873 --HG-- branch : trunk
2010-03-02Fixed import errors on recent sql update files...teacher
Added forgotten updates to world.sql... Added missing lines at the end of some sql files... Better format by adding DELETE FROM before any INSERT INTO update... --HG-- branch : trunk
2010-03-01Add command similar to pinfo but for gameobjects.p0wer
Displays Entry, Type, DisplayId, and Name. Created in response to issue #768. --HG-- branch : trunk
2010-02-25Add new flagged column to access_requirement to set instances opened/closed.Tartalo
This way is possible to open a raid on 10man mode while the rest of modes are closed (for example). Ingame commands to open/close instances coming soon ;) --HG-- branch : trunk
2010-02-24Add command for administrators to change channel publicity ingame rather ↵p0wer
than having to manually manipulate the database. --HG-- branch : trunk
2010-02-23Missed changes from last commit. Sorry bout that.p0wer
--HG-- branch : trunk
2010-02-23*Battle shout and Commanding Shout can stack with each other when cast by ↵QAston
different casters. --HG-- branch : trunk
2010-02-22Added recent sql updates to world.sql and full files...teacher
--HG-- branch : trunk
2010-02-15*Backout some WTF fixes. Do things correctly, or do not touch them at all...QAston
*Really fix windows build. --HG-- branch : trunk
2010-02-15Add missing changes in world.sql rev 39b34751a7n0n4m3
--HG-- branch : trunk
2010-02-14* Core switch to client 3.3.2 (11403)Brian
* Credits (in no particular order) to: * n0n4m3, raczman, manuel, Spp, Malcrom, Teacher, QAston, Tartalo, * thenecromancer, Xanadu, Trazom, Zor, kiper * Additional credits to: * TOM_RUS and NoFantasy from MaNGOS * Thanks for testing Aokromes and XTElite1 * SoTA still needs some work, but is very playable (huge thanks to raczman and * kiper) * To upgrade, you need to apply all SQL from sql/updates/3.2.2a_old from the * last rev you are on * and then apply all SQL from sql/updates/3.3.2_old to char / realmd / world * DBs * Known problem with guild banks. --HG-- branch : trunk
2010-02-06Removed script_waypoints data form world.sql. They should not be there.teacher
Removed obsolete readme file for fulls. Fulls are now just for testing purposes. --HG-- branch : trunk
2010-02-06Modify world.sql, too...thx to _manuel_for reminding me. Also thx to ↵Xanadu
Aokromes for testing revs 7299 & 7300. --HG-- branch : trunk
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