aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
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-28Fixed spellpower coef for Lifebloom final healShauren
--HG-- branch : trunk
2010-07-26* Implement reputation spillover via the databaseBrian
* Remove the nasty hack that we had to handle Vanguard Alliance / Horde * Expedition, and city spillover. * Needs DB data * Original patch by NoFantasy --HG-- branch : trunk
2010-07-26* Implement reputation reward rate for quest / creaturesBrian
* Need DB data for this to work * Original patch by NoFantasy --HG-- branch : trunk
2010-07-24*Add base scripting interfce for spells - thanks to Brian for help in making ↵QAston
it compile with GCC. *Add hook for handling spell effects in new scripting system. --HG-- branch : trunk
2010-07-24Modified spell_scripts table, it is now possible to add different scripts ↵Shauren
for each spell effect Allow SPELL_EFFECT_DUMMY spells to use spell_scripts --HG-- branch : trunk
2010-07-24* Add lootid output to .gobj info commandBrian
* Patch by Visagalis --HG-- branch : trunk
2010-07-24Fixed trauma/mangle stacking. Fixes issue #1460.Xanadu
--HG-- branch : trunk
2009-07-23Added missing data to world_database.sql forgotten in commit 9000._manuel_
--HG-- branch : trunk
2010-07-23* Proper Trinity SQL standards for recent orientation fileBrian
* Update world_database.sql with that data --HG-- branch : trunk
2010-07-22* Add the ability to set player orientation for new characters.Brian
* Requires DB data to actully do anything, however not needed for working * server * Original patch by Vladimir --HG-- branch : trunk
2010-07-22* Implemented DB cleaning on startupBrian
* Must be enabled in conf AND set in worldstates for what you want to clean * CLEANING_FLAG_ACHIEVEMENT_PROGRESS = 0x1, * CLEANING_FLAG_SKILLS = 0x2, * CLEANING_FLAG_SPELLS = 0x4, * CLEANING_FLAG_TALENTS = 0x8 * Set to 0xF to clean all 4 * Patch by hunuza --HG-- branch : trunk
2010-07-22Added placeholder for serverside spell for future development.teacher
--HG-- branch : trunk
2010-07-22Fixes import errors (updated insert statements to new table structures) to ↵teacher
world_database.sql. Some random Trinity standards in sql syntax. --HG-- branch : trunk
2010-07-21* Implement the ability to delete characters without them being removed fromBrian
* the DB, so they can be unerased * Original patch by DasBlub * Ported to Trinty by Az@zel --HG-- branch : trunk
2010-07-21Added forgotten changes to world_database.sql for disable system.teacher
--HG-- branch : trunk
2010-07-21Added global disable system and moved all disable fields/tables/configs into itShauren
NOTE: instance disables were not converted for new system! if you had some then you need to fix that using new system --HG-- branch : trunk
2010-07-19*Correct typo in CastSpeedSlow spellgroup - by tassader1000, thanks ↵QAston
azazel_kon for sql *Fix a compile typo in prev commit. --HG-- branch : trunk
2010-07-19Proper aura values for previous spell place holder (thank you QAston for the ↵teacher
little lesson). --HG-- branch : trunk
2010-07-19Added trigger effect for Blood Oath Aura for Quest "Truce?" (by Svannon)teacher
Added serverside spell place holder for future development. Better syntax for a recent sql update (no need to re-import it). --HG-- branch : trunk
2010-07-19Clean up level0.cpp and return proper errormessages (fix by ogeraisi)click
Closes issue #286 --HG-- branch : trunk
2010-07-17Added recent changes forgotten in world_database.sql.teacher
--HG-- branch : trunk
2010-07-16*Update spell_proc_event entry for Everlastin Affliction - by francesco.buldo.QAston
*Manually add corruption to list of spells affected by Everlasting Affliction. --HG-- branch : trunk
2010-07-14Fixed base points for Heart of the Wild however this does not fix its ↵Shauren
incorrect amount as the issue is somewhere else Add forgotten Stances and StancesNot fields to data insert in world sql --HG-- branch : trunk
2010-07-13Add Stances and StancesNot fields to spell_dbc tableShauren
--HG-- branch : trunk
2010-07-12Renamed "realmd" to "auth" in config files.teacher
Renamed "character_database.sql" to "characters_database.sql". (yeah I know, you're gonna hate me, but I'm pedantic!) --HG-- branch : trunk
2010-07-09* Proper naming for auth SQL fileBrian
* Update base SQL file for new installs --HG-- branch : trunk rename : sql/updates/3.3.5a_old/8861_realmd_realmlist.sql => sql/updates/3.3.5a_old/8861_auth_realmlist.sql
2010-07-06Fix to make the Argent Defender trigger the visuals (by amki).teacher
--HG-- branch : trunk
2010-07-04Added serverside spell place holder for future development.teacher
Added missing data to world_database.sql. Corrected a couple of typos in world_script_texts.sql. --HG-- branch : trunk
2010-06-29Make table names more consistent (item_set_names and locale)Shauren
--HG-- branch : trunk
2010-06-22* Remove table from database that is no longer needed after previous commitBrian
--HG-- branch : trunk
2010-06-21Added forgotten spell_linked_spell values in previous commit (thank you ↵teacher
Gyullo for spotting it). Added place holder for serverside spell. --HG-- branch : trunk
2010-06-21Drop cond3 fields in gossip_menu_option table (the sql update was forgotten ↵teacher
when condition table was implemented) and finally update world_database.sql accordingly. Removed all vehicle and gossip data from world_database.sql. DB projects must now handle such data. One file renamed (cosmetic) (thx Aokromes for spotting it). --HG-- branch : trunk
2010-06-21Added missed sql update file for Rev 8613.teacher
Removed hackish non-TrinityCore related 8640_world_creature_template.sql. Proper fix can be found on forum (Accepted Fixes). Don't worry if you used it, it was a harmless hotfix and it will not cause any issue when using proper fix from forum. Added to world_database missed changes updates. Minor sql standards cleanup. --HG-- branch : trunk
2010-06-18Changed PKs in world_database.sql...which I forgot to do in 8625.Xanadu
--HG-- branch : trunk
2010-06-15Drop Flag on Nitro Boost usage for WSG and EoS.John Holiver
By Gyullo. Fixes issue 2166. --HG-- branch : trunk
2010-06-14Removed useless comment columns from the pool system DB tables.Xanadu
--HG-- branch : trunk
2010-06-14Added support for removing blizz items from character creation info by ↵Shauren
adding entry to playercreateinfo_item with count -1 Added support for all class/all race in playercreateinfo_item by setting class/race to 0 (like currently playercreateinfo_spell) --HG-- branch : trunk
2010-06-14Fix Nature's Guardian ICD (5->30).John Holiver
--HG-- branch : trunk
2010-06-12Added forgotten field to `item_set_names` since this data come from WDBShauren
--HG-- branch : trunk
2010-06-11Added support for item set names in case where item does not exist in ↵Shauren
item_template (like gladiator gear) --HG-- branch : trunk
2010-06-09Forgot to push the mod on world.sql from r67325b1a0aJohn Holiver
--HG-- branch : trunk
2010-06-09Fixed [T10] Paladin 4P Protection bonusShauren
Closes issue #2519. --HG-- branch : trunk
2010-06-09* Renamed some directories in sql/ to more accurately reflect their purposeBrian
--HG-- branch : trunk rename : sql/auth_database.sql => sql/base/auth_database.sql rename : sql/character_database.sql => sql/base/character_database.sql rename : sql/world_database.sql => sql/base/world_database.sql rename : sql/tools/CMakeLists.txt => sql/create/CMakeLists.txt rename : sql/tools/create_mysql.sql => sql/create/create_mysql.sql rename : sql/tools/drop_mysql.sql => sql/create/drop_mysql.sql rename : sql/full/CMakeLists.txt => sql/scripts/CMakeLists.txt rename : sql/full/world_script_texts.sql => sql/scripts/world_script_texts.sql rename : sql/full/world_script_waypoints.sql => sql/scripts/world_script_waypoints.sql rename : sql/full/world_scripts_full.sql => sql/scripts/world_scripts_full.sql