aboutsummaryrefslogtreecommitdiff
path: root/sql/world.sql
AgeCommit message (Collapse)Author
2010-03-26A visually better way to handle Avenger Wrath blocking of immunity shields.Xanadu
--HG-- branch : trunk
2010-03-25MergeXanadu
--HG-- branch : trunk
2010-03-25Fixed Forbearance. Also self-cast LoH will now correctly prevent Avenging ↵Xanadu
Wrath for 30 s. Closes issue #1270. Thanks to _manuel_ for research. --HG-- branch : trunk
2010-03-24* Missed SQL from previous commitBrian
--HG-- branch : trunk
2010-03-25Changed default value for WDBVerified field for better future handling.teacher
--HG-- branch : trunk
2010-03-24Added spells to Wintergarde Gryphon (by Malcrom).teacher
Added place holders for server-side spells. Import errors fixes in world.sql. --HG-- branch : trunk
2010-03-23Added support for maximum allowed player level for quests. By Gyullo.Xanadu
--HG-- branch : trunk
2010-03-21Added missing sql file for rev 7656 (by Machiavelli).teacher
Removed DB content data from previous commit. --HG-- branch : trunk
2010-03-21Add additional field for storage of speed_run rate of creature_manuel_
This allow independent rate of walk vs run speed. Existing field renamed to explicit speed_walk. Note that default database rate for run is a result of the most common value seen, 8.0/7.0 Author: NoFantasy. --HG-- branch : trunk
2010-03-18*fix Merciless Totem of the Third Wind procRat
*fix in world.sql --HG-- branch : trunk
2010-03-17Fixed Drain Soul increased damage for targets below 25% HP. Closes issue ↵Xanadu
#394. Closes issue #748. Closes issue #938. Rejoice, new era of server-side spells has begun! --HG-- branch : trunk
2010-03-15Moved sql update files to 3.3.2_old directory.teacher
Fixed my typo in world.sql. --HG-- branch : trunk
2010-03-15Remove Hack detecting spell 61988 in HasAura()thenecromancer
Correctly cast 61988/61987 after casting Avenging Wrath/Divine Shield respectively (This will correctly show both spells disabled state) Don't allow casting Lay on Hands on self when aura 61988 is present (ie. after using Avenging Wrath) --HG-- branch : trunk
2010-03-13Random sql cleanup.teacher
--HG-- branch : trunk
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