aboutsummaryrefslogtreecommitdiff
path: root/sql/world.sql
AgeCommit message (Collapse)Author
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
2009-09-10Add forgotten change to world.sql and update script for scarlet ghouls ↵Chaz Brown
(quest 12698) so they are in defensive mode. Also make it so, if you abandon the quest, you don't get to keep your minions... Still need some official info on these, if anyone can help. --HG-- branch : trunk
2009-08-27*Fix Crypt Fever and Ebon Plague disease damage mod.QAston
--HG-- branch : trunk
2009-08-27*Add `spell_dbc` table to store dbc entries not present in clientQAston
*Remove workaround from Demonic Circle code and use the sql table instead. --HG-- branch : trunk
2009-08-27*Delete table spell_affect's structure from world.sqlAnubisss
*If you didnt drop it just run: 4542_8191_world_spell_affect.sql from sql's updates. --HG-- branch : trunk
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