aboutsummaryrefslogtreecommitdiff
path: root/sql/world.sql
AgeCommit message (Collapse)Author
2009-08-17*Implement aura type SPELL_AURA_MOD_XP_QUEST_PCT (291) and fix ↵QAston
SPELL_AURA_MOD_XP_PCT(200) handler. *Correct structure stored in world.sql for npc_spellclick_spells and fix world_script_text application. --HG-- branch : trunk
2009-08-17*Add spell_bonus_data for lightwell - by ElronQAston
*Add aura_required, aura_forbidden, user_type columns to npc_spellclick_spells table for additional requirement checks *Remove workarounds from lightwell code and use new npc_spellclick_spells fields instead. --HG-- branch : trunk
2009-08-08*Cleaned up SQL, updated FULLsmaximius
--HG-- branch : trunk
2009-07-31*Remove data from world.sql - it exists now only for structure documentation.QAston
*Remove debug spell_check command - such things shouldn't belong to core. --HG-- branch : trunk
2009-07-26Fix build on windows.Kudlaty
Fix command ticket viewname - thx Deadlyskunk for point this fix setlink command group, add missing commands to db - patch by XTElite1 --HG-- branch : trunk
2009-07-25*Drop command reload spell_affect from DB. Its already dropped from core.Anubisss
--HG-- branch : trunk
2009-07-21*Add table spell_elixir to world_spell_full.sqlAnubisss
--HG-- branch : trunk
2009-07-18*Add new column to spell_bonus_data table to store ap bonus for periodic auras.QAston
*Use -1 to mark entries, for which default spell bonus calculation should be used. *Move periodic auras ap bonuses from core to db. *Add coefficient for Black Arrow. --HG-- branch : trunk
2009-07-12*Show online players numbers in command server info.Anubisss
--HG-- branch : trunk
2009-07-07* Updated world.sqlDrahy
* Fixed last import errors --HG-- branch : trunk
2009-07-06* Fixed typo in world.sqlDrahy
--HG-- branch : trunk
2009-07-05*Print the account's email in command pinfo. Based on Charlie's patch.Anubisss
--HG-- branch : trunk
2009-06-29* Used finally after long time trinity sql coding styleDrahy
* Missing data are now in 4321_world - just import this * Updated all FULL sqls to 4321 --HG-- branch : trunk
2009-06-25*Fix Conflagrate damage calculation formulatlexii
--HG-- branch : trunk
2009-06-23[8071] Restore work .modify tp command. Allow apply it to selectedQAston
character's pet. Author: VladimirMangos. --HG-- branch : trunk
2009-06-23[8056] Move SMSG_CLEAR_COOLDOWN into function and use it. Other cleanups. ↵QAston
Author:XTZGZoReX [8060] Store spell_pet_auras for auraeffects instead of by whole aura Author:hunuza. --HG-- branch : trunk
2009-06-23[8052] Fixed typo in error log output. Author: The_Game_MasterQAston
[8049] Added energize effect after last heal tick for 33763 and ranks. Author: bobaz [8053] At character talents reset using chat command also reset talents for all character pets. Author: VladimirMangos --HG-- branch : trunk
2009-06-19*Better reset time format in command .lookup mapAnubisss
--HG-- branch : trunk
2009-06-19*Implement command .lookup mapAnubisss
--HG-- branch : trunk
2009-06-16"*Fix Kindred Spirits.QAston
*Fix typo causing auras SPELL_AURA_MOD_ATTACK_POWER_OF_ARMOR to modify ap with too big amount. --HG-- branch : trunk
2009-06-15*Some cleanup in full sqls.QAston
--HG-- branch : trunk
2009-06-13Add changes to world.sql for last few revisionsChaz Brown
--HG-- branch : trunk
2009-06-13*Fix Improved Succubus.QAston
--HG-- branch : trunk
2009-06-12Fix more world.sql typosChaz Brown
--HG-- branch : trunk
2009-06-12Fix a typo in world.sqlChaz Brown
--HG-- branch : trunk
2009-06-12Fix a couple of errors in world.sqlChaz Brown
--HG-- branch : trunk
2009-06-12Completely new dump of world.sql with a ton of hand editing, can't test that ↵Chaz Brown
there are no errors now, but, since this is really just for DB makers to base their work off of, it shouldn't mess anything up for regular users. Let me know if you do find any glaring errors, though. --HG-- branch : trunk
2009-06-06*Remove Arcane Blast on Arcane Missiles and Arcane Barrage castQAston
*Spell_affect entry for Fingers of frost - by Larva *use spellaffect entries in every affect check *Allow spell_affect table to modify affect data for any spell --HG-- branch : trunk
2009-05-28Fix wrong data type for core_revision in DB, againParadox
--HG-- branch : trunk
2009-05-10*Remove Mana Tap from players and Drop Mana Tap's code. This spell not ↵Anubisss
needed in 3.0.2+ --HG-- branch : trunk
2009-03-22* Merged ScriptDev2 928Muhaha
--HG-- branch : trunk
2009-03-21* Implement ".server set closed on/off" command to allow/deny new ↵XTZGZoReX
connections to the world. --HG-- branch : trunk
2009-03-12*Merge.megamage
--HG-- branch : trunk
2009-03-12*Fix typos - by EIFELBlaymoira
--HG-- branch : trunk
2009-03-06*Merge.megamage
--HG-- branch : trunk
2009-03-05*Implement access_requirement table - by IskanderBlaymoira
- now check the requirements on teleport not only on areatrigger use - moved some columns from instance_template and areatrigger_teleport to access_requirement table --HG-- branch : trunk
2009-02-23*Merge.megamage
--HG-- branch : trunk
2009-02-23*Fix a typoBlaymoira
--HG-- branch : trunk
2009-02-23*Cleanup in world.sqlBlaymoira
--HG-- branch : trunk
2009-02-18*Merge.megamage
--HG-- branch : trunk
2009-02-17Newline added to bottom of all files.KingPin
--HG-- branch : trunk
2008-12-24*SQL clean up.megamage
--HG-- branch : trunk
2008-12-13*Fix a typo in world.sql thx for pointing TransatlanticBlaymoira
*Added Brewfest and Winter Reveler script --HG-- branch : trunk
2008-12-09*Merge to solve EOL issue.megamage
--HG-- branch : trunk
2008-12-10Featuring a rewritten waypoint movement with more options, optimised code ↵MeanMachine@MeanMachine-PC
and revamped ingame waypoint control. To convert entries from the old tables manually, please use the PHP script provided at http://www.trinitycore.org/forum/project.php?issueid=830 --HG-- branch : trunk
2008-10-27[svn] * fixed world.sql LOCK/UNLOCK for script_texts tableslg
--HG-- branch : trunk
2008-10-25[svn] Update trinityscript to SD2 rev 700. Source: scriptdev2. Patch ↵megamage
provided by SLG. --HG-- branch : trunk
2008-10-22[svn] Add missing SQL changes from prev. commit, also fix mistakenly ↵w12x
commented out line. Patch provided by Visagalis. --HG-- branch : trunk
2008-10-21[svn] Implement a new table (spell_disabled) to allow disabling some spells ↵w12x
for players and / or creatures. To disable a spell for a players and pets, set 2^0 in the disable_mask, to disable for creatures, set 2^1. The comment field is optional. Original patch provided by Craker. --HG-- branch : trunk
2008-10-14[svn] * SQL cleanuprunningnak3d
* Removed unneeded revision SQL, since everyone will be starting off at a single revision. * Left the characters SQL in case someone needs to convert a MaNGOS characters DB * Final dumps of realmd / world / and characters DB schemas --HG-- branch : trunk