aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2010-08-07* Move all movable spell effects from core to DB. Needs DB support.azazel
* Fix some compile errors made in previous commits. --HG-- branch : trunk
2010-08-06Implemented Dalaran no-fly zoneShauren
--HG-- branch : trunk
2010-08-06* Fixed some CRLF that magically made its way into this file...XTZGZoReX
--HG-- branch : trunk
2010-08-06Moved Pain and Suffering (47948) script effect to spell script.azazel
--HG-- branch : trunk
2010-08-06* Added outdoorpvp_template table (currently unused).XTZGZoReX
* Added DISABLE_TYPE_OUTDOORPVP (5) which can disable outdoorpvp_template entries. --HG-- branch : trunk
2010-08-06* Add ScriptName to conditions.XTZGZoReX
--HG-- branch : trunk
2010-08-06* Add ScriptName to game_weather.XTZGZoReX
--HG-- branch : trunk
2010-08-06Added ScriptName to battleground_template for script system rewriteShauren
--HG-- branch : trunk
2010-08-06Removed unused access_id from instance_template table (obsolete since ↵Shauren
access_requirement rewrite) Fixed build issues with my previous commit --HG-- branch : trunk
2010-08-06Added ScriptName to transports table for script system rewriteShauren
--HG-- branch : trunk
2010-08-06* Minor correction to world_database.sql.XTZGZoReX
--HG-- branch : trunk
2010-08-05Add forgotten proc flags in revision ed3790455dfd (9166)Shauren
--HG-- branch : trunk
2010-08-04Fixed pet talents: Guard Dog and SilverbackShauren
Removed pre-3.3.0 code for Improved Cower Closes issue #3198. --HG-- branch : trunk
2010-08-04Fixed Carrion Feeder pet talentShauren
Removed useless code for Wolverine Bite --HG-- branch : trunk
2010-08-04Cleaned up item flags: separated item proto flags and item field flagsShauren
Implemented use of: ITEM_PROTO_FLAG_PROSPECTABLE and ITEM_PROTO_FLAG_MILLABLE now checked instead of bag family mask ITEM_PROTO_FLAG_SMART_LOOT for profession recipes, player has to have skillline and not know the recipe ITEM_PROTO_FLAG_OPENABLE item has to have it set to use item_loot_template ITEM_PROTO_FLAG_NOT_USEABLE_IN_ARENA if this is set item can never be used in arena ITEM_FLAG_UNLOCKED marks unlocked items Simplified BoA check for mail sending Stackable items are no longer refundable Removed useless code that always set ITEM_FIELD_FLAGS equal to proto flags Unlocking items (lockpicking) is now blizzlike --HG-- branch : trunk
2010-08-03Fixed Heart of the Phoenix pet spellShauren
--HG-- branch : trunk
2010-08-03*Update spell_bonus_data for Garrote - by svetilo12.QAston
*Fix build. --HG-- branch : trunk
2010-08-02Move a couple of warrior spell dummy effect handlers to spell scripts.silinoron
--HG-- branch : trunk
2010-08-02Moved spell_script_names data from world_scripts_full.sql to ↵teacher
world_database.sql, it is to be kept here from now on. Added missing data to fulls. Some cosmetic fixes to a couple of sql update files. No need to re-apply any sql file for this commit. --HG-- branch : trunk
2010-08-02Updated .pdump commandsShauren
Deleted (but kept in db) characters cannot be dumped --HG-- branch : trunk
2010-08-02Add selection weights to BG and Arenas. Will determine the selected BG/Arena ↵Spp
chosen using random BG/Arenas from the enabled list. Closes issue 2843 --HG-- branch : trunk
2010-08-01* I'm a firm believer that if you told a computer to make a variable ↵XTZGZoReX
'unsigned unsigned' it would blow up. --HG-- branch : trunk
2010-08-01*Fix import of 9120_world_spell_proc_event.sql when using some weird tools - ↵QAston
by taliesin.tc. --HG-- branch : trunk
2010-08-01*Use spell_ranks table in spell scripts to not duplicate data.QAston
--HG-- branch : trunk
2010-08-01*Disable spellpower/ap bonus for flametongue - by Visagalis.QAston
--HG-- branch : trunk
2010-07-31*Update ppm chance for Unbridled Wrath - by insider42.QAston
--HG-- branch : trunk
2010-07-31*Add data from r4bf7778333 to world_database.sqlQAston
*Add 22 sec internal cooldown to Lock and Load - by servet. --HG-- branch : trunk
2010-07-31Move SPELLFAMILY_PALADIN dummy spell effects for Holy Shock, Blessing of ↵silinoron
Faith, and Judgement of Command to spell scripts. --HG-- branch : trunk
2010-07-31Forgot to add a DELETE query at the last revision. I just told devs to check ↵Liberate
their sql, and then I make a mistake of my own. Ah well, I'm just one of the lousy devs as well. --HG-- branch : trunk
2010-07-31*Fixes Necrosis and Blood-Caked Blade. They now only proc from melee ↵Liberate
auto-attacks. Fix by kerekeszoltan90. Fixes issue #3184 --HG-- branch : trunk
2010-07-31Fixes many sql errors in the sql/scripts/ directory. Please devs don't just ↵Liberate
copy-paste the sql from the updates directory into these sql files. This might cause errors. --HG-- branch : trunk
2010-07-31Fixed mysql syntax errors caused by using wrong delimiter, thanks BlackCat0110Shauren
--HG-- branch : trunk
2010-07-31Hopefully the last fix for revision 3849fdebbcc7 (9090) - use proper field ↵Shauren
to pull random properties --HG-- branch : trunk
2010-07-31Core/SQL: Fix character_database structure-creation - thanks to some ↵click
number-thingie@qq Closes issue 3181 --HG-- branch : trunk
2010-07-30Some forgotten changes.silinoron
--HG-- branch : trunk
2010-07-30Add basic support for NPCs on transports; DB data required.silinoron
Currently no support for combat while the transport is in motion. Based on a patch by Socolin. Fixes issue #168 --HG-- branch : trunk
2010-07-31Core/SQL: Add commentfield in battleground_templateclick
Support-data found on TDB : http://forum.trinitycore.org/forum/122-core-related-db-content/ --HG-- branch : trunk
2010-07-30Fixed naming of SQL filesShauren
--HG-- branch : trunk rename : sql/updates/9081_access_requirement.sql => sql/updates/9081_world_access_requirement.sql rename : sql/updates/9081_areatrigger_teleport.sql => sql/updates/9081_world_areatrigger_teleport.sql
2010-07-30This should fix mysql syntax errors some people were getting with ↵Shauren
9090_characters_item_instance.sql --HG-- branch : trunk
2010-07-30Killed the last blob field (corpse)Shauren
--HG-- branch : trunk
2010-07-30Typo in SQL nameShauren
--HG-- branch : trunk rename : sql/updates/9090_item_instance.sql => sql/updates/9090_characters_item_instance.sql
2010-07-30Deleted data blob in item_instanceShauren
Fixed issues with displaying sockets/enchants/durability on heroic items --HG-- branch : trunk
2010-07-29Remade access_requirement table, now each difficulty mode for each instance ↵Shauren
has its own entry (for future Dungeon Finder development) Added completed achievement as new requirement type Removed obsolete access_id from areatrigger_teleport table Implemented automatic downscaling of raid difficulty when requested mode does not exist Changed dungeon_difficulty in characters table to instance_mode_mask saving both dungeon and raid difficulty in form (dungeon diff | raid diff << 4) --HG-- branch : trunk
2010-07-29Modified announce command to be more blizzlikeShauren
--HG-- branch : trunk
2010-07-28Fix a typo in 9043_world_spell_scripts.sql and fix some horrible sql style ↵Shauren
in other files --HG-- branch : trunk
2010-07-28Implements Roxi Ramrocket, finally Engineers will be able to buy Choppers ↵John Holiver
materials. Credits to BroodWyrm. Fixes #2979. --HG-- branch : trunk
2010-07-28Fixed spellpower coef for Lifebloom final healShauren
--HG-- branch : trunk
2010-07-27Move dummy effect handlers for all SPELLFAMILY_HUNTER dummy effect handlers ↵silinoron
but Scatter Shot to spell scripts. --HG-- branch : trunk
2010-07-27Cleanup the mage spell scripts, and move SPELLFAMILY_PRIEST and ↵silinoron
SPELLFAMILY_ROGUE dummy effect handlers to spell scripts. --HG-- branch : trunk
2010-07-26Fix a typo in cmakelists and add spell_script_names to world_scripts_full.silinoron
--HG-- branch : trunk