aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2010-08-07Remove useless hack for Leeeeeeeeeeeeeroy! achievementShauren
--HG-- branch : trunk
2010-08-07Use proper WHERE query in 9240_world_achievement_criteria_data.sqlShauren
--HG-- branch : trunk
2010-08-07Implemented ACHIEVEMENT_CRITERIA_TYPE_BG_OBJECTIVE_CAPTUREShauren
Added support for "in single battleground" and "without dying" requirement to battleground achievements Add examples of scripting achievement (School of Hard Knocks, Storm Glory) --HG-- branch : trunk
2010-08-07* Some cleanups in world_scripts_full.sql.XTZGZoReX
* SQL updates for `battleground_template`.`Comment` (by Click), and `outdoorpvp_template` content. --HG-- branch : trunk
2010-08-07Added support for scripting achievement criteria checks using ↵Shauren
ACHIEVEMENT_CRITERIA_DATA_TYPE_SCRIPT (11) --HG-- branch : trunk
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