aboutsummaryrefslogtreecommitdiff
path: root/sql/world.sql
AgeCommit message (Collapse)Author
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
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