aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
2018-03-15typo fixAokromes
2018-03-14Scripts/Commands: implemented command .server debugAokromes
- Shows detailed information about server setup, useful when reporting a bug: * rev. hash * versions of mysql, openssl, boost, cmake * info about autoupdater * info about ports (realmlist and current) * vmap/map/mmap status and folder sizes * available DBC locales * TDB version cherry pick of d18f8b94b0cb5182ef450bec5cafd3c5d74fd00a Running this command when reporting bugs is MANDATORY (you can censor paths)
2018-03-04Core/Player: Implement PvP Talents (#19962)Jeremy
* SPELL_AURA_119 -> SPELL_AURA_PVP_TALENTS * Learn Honorable Medallion when pvp rules are enabled
2018-02-28Core: Updated allowed build to 7.3.5.26124Shauren
2018-02-19TDB 735.00 - 2018/02/19TDB735.00DDuarte
2018-02-18Core: Updated allowed build to 7.3.5.25996Shauren
2018-02-18Core/PacketIO: Updated opcodes and packet structures to 7.3.5Shauren
2018-02-18Core/Entities: Update updatefields to 7.3.5.25928Shauren
2018-02-11Update characters_database.sqlAokromes
2018-02-03SQL: Fixed hash of 2017_10_29_00_characters.sqlShauren
2018-01-02DB: Made timestamp columns, those can have no date, nullable instead of ↵joschiwald
saving invalid date '0000-00-00 00:00:00' * This makes our tables mysql strict mode conform Ref #21113
2017-12-31Core/Quests: Implemented player choice rewardsShauren
2017-12-31SQL: Fixed typojoschiwald
2017-12-30Core/RBAC: Fixed permissions conflict with 3.3.5 branchjoschiwald
2017-12-30Fix base sqlShauren
2017-12-30Core: Updated allowed build to 7.3.2.25549Shauren
2017-12-30Core/PacketIO: Update opcodes to 7.3.2Shauren
2017-12-17DB/Misc: Make base files more read-ableAokromes
for future mysql dumps run this after dump before push: sed -i 's/),(/),\n(/g' auth_database.sql sed -i 's/),(/),\n(/g' characters_database.sql
2017-11-11Core/Commands: Added .modify power command allowing to change any power as ↵Shauren
long as player class can use it * Power names are taken from PowerType.db2 (lowercase, using _ is optional) Closes #20833
2017-10-30Make travis happyAokromes
2017-09-22Core/Bnet: Moved loading account info from rest service to sessionShauren
* This improves concurrency by removes thread synchronization when checking login tickets * Also allows users to use external (web based) login systems
2017-08-20Core/Players: Several gold handling improvementsroc13x
* Update gold limit to 10 million * Updated auction house gold handling to 64-bit * Fixed some vendor checks for when BuyCount > 1 * Tweaked some checks for available gold space * Updated guild bank gold handling to 64-bit and fix withdraw limits * Enforce gold limit on guild bank * Check correct rank right when withdrawing from bank * Other small changes to update money to 64-bit Closes #19195 Closes #20152
2017-08-20Core/Quests: Implemented criteria tree quest objective typeRoger Stebler
Closes #20161
2017-08-13Core/Spells: Implementation of QAston proc system (#20131)joschiwald
* Core/Spells: Implementation of QAston proc system - Move checks from Unit::IsTriggeredAtSpellProcEvent (old system) to Aura::IsProcTriggeredOnEvent (new system) - killed charge counter from SpellModifier and Player system for handling charges... no point in having 3 different systems doing the same thing - Automatically add default entries to spellProcMap, based on spellinfo (else auras won't proc without an entry) Based on old Unit::ProcDamageAndSpellFor - Old Unit::ProcDamageAndSpellFor renamed to Unit::ProcSkillsAndReactives and made private, will no longer handle auras. - Start making use of HealInfo::AbsorbHeal in unit calculations, add effective healing info to HealInfo struct - Changes in spell reflection system, emulates old behaviour, delaying aura drop - Removed old charge count hacks in SpellMgr::LoadSpellInfoCorrections - Removed bogus error log when procChance is 0: Some auras have initial 0 procChance but modified by SPELLMOD_CHANCE_OF_SUCCESS - Fixed TriggerAurasProcOnEvent logic that tried to trigger twice from actor. - Allow non damaging spells with DamageClass Melee or Ranged to proc character enchants. Ref issue #17034: * http://web.archive.org/web/20110309092008/http://elitistjerks.com/f47/t49865-paladin_retribution_pve/ * When an auto-attack lands (does not dodge/parry/miss) that can proc a seal the of the following things happen independently of each other (see 2 roll system). * 1) A "hidden strike" which uses melee combat mechanics occurs. If it lands it refreshes/stacks SoV DoT. Only white swings can trigger a refresh or stack. (This hidden strike mechanic can also proc things like berserking..) * 2) A weapon damage based proc will occur if you used a special (CS/DS/judge) or if you have a 5 stack (from auto attacks). This attack can not be avoided. * Holy Vengeance is the "hidden strike" it has an apply aura effect and damage class melee. - Fixed Blood Tap interaction with Death Runes (btw, don't know what was going on with those MiscValueB, spell 45529 doesn't have any MiscValueB in SPELL_EFFECT_ACTIVATE_RUNE) - Ported some AuraEffect checks from old Unit.cpp function. added new AuraScript hook to check procs of an specific effect - Allow only AuraEffects that passed the check to proc, this won't block whole aura from proccing (and lose charges) if at least one of the effects procs, though - Changes in spell mod system (for SPELLMOD_CASTING_TIME). fixes #17558. - Added an exception for SPELLMOD_CRITICAL_CHANCE too, fixes #15193 (cherry picked from commit e641d0c7d71bdb21e443bf52bf508b1581e07839) # Conflicts: # sql/base/auth_database.sql # src/server/game/Entities/Player/Player.cpp # src/server/game/Entities/Player/Player.h # src/server/game/Entities/Unit/Unit.cpp # src/server/game/Entities/Unit/Unit.h # src/server/game/Spells/Auras/SpellAuraEffects.cpp # src/server/game/Spells/Auras/SpellAuras.cpp # src/server/game/Spells/Auras/SpellAuras.h # src/server/game/Spells/Spell.cpp # src/server/game/Spells/SpellEffects.cpp # src/server/game/Spells/SpellInfo.cpp # src/server/game/Spells/SpellMgr.cpp # src/server/game/Spells/SpellMgr.h # src/server/game/Spells/SpellScript.cpp
2017-08-04Core: Updated allowed build to 7.2.5.24742Shauren
2017-06-30Core: Updated allowed build to 7.2.5.24461vincent-michael
2017-06-28Core: Updated allowed build to 7.2.5.24430vincent-michael
2017-06-25Core: Updated allowed build to 7.2.5.24415vincent-michael
2017-06-18Core: Updated to 7.2.5.24367Shauren
2017-06-15Core: Updated to 7.2.5.24330Shauren
2017-06-04Core/Players: Implement basics for the honor systemGolrag
Closes #18480 Closes #19277
2017-05-24Core/Player: Implemented saving PLAYER_FLAGS_EX in databaseTisk
2017-05-14Core/Guilds: Remove old Guild.UndeletableLevel configDDuarte
Send guild achievement points in SMSG_GUILD_INVITE instead of level Remove old references to guild levels Player still have PLAYER_GUILDLEVEL field which is always 25
2017-05-14Core/Entities : Basic Conversation Implementation (#18010)Traesh
2017-05-08Core/Items: Set and save item context fieldShauren
2017-04-28Update auth_database.sqlAokromes
2017-04-28Core: Updated allowed build to 7.2.0.24015vincent-michael
2017-04-22Core: Change allowed build to 7.2.0.23937Shauren
2017-04-19TDB 720.00 - 2016/04/18TDB720.00DDuarte
2017-04-17Core: Updated GameTables to 7.2.0Shauren
Tools/Extractors: Updated to 7.2.0 Tools/ConnectionPatcher: Updated patterns to 7.2.0 Supported version is now 7.2.0.23911
2017-04-15Core/PacketIO: Updated server packet structures to 7.2.0Shauren
2017-03-17Core/Players: Rename "heroic character" to "death knight"Chazy Chaz
Closes #19286
2017-03-11* Scripts/Commands: Fix guid usage and enhance commandsRochet2
- Fix targeting gameobjects and creatures for .dist and .gps. The old code used DB guid to search from core generated guid lists. - Fix some error messages saying 'no player found' even if creatures and gameobjects and players were searched - Change atoi to atoul when receiving lowguids as string or other uint32 values - Use ObjectGuid::LowType instead of uint32 for lowguid type - Allow .gob info to take in gameobject guid link as well as entry link in addition to gameobject entry and update the documentation of the command - Change .gob delete to post the spawnid (dbguid) instead of the ingame generated guid (which is basically never seen or used by the player in any other commands that I see) - Allow spawntimesecs to be negative when spawning a gameobject - Disable searching by ingame spawn id in commands. (it makes little sense for a user to provide a number which is then attempted to be used as DB guid and non DB guid when both could have a match) - Update .gob turn documentation to tell about possibility to provide orientation in command - Correct the types in .gob add command result trinity_string - Correct the creature search for .npc del - Change .event to .event info - Add .go offset command - Remove the .go command for empty string (no subcommand given) because it just used .go xyz - Extend .gob info to show size, faction, flags and model dimensions - Remove some unnecessary casts - Document .wp show better (first and last were not documented) - Insert spawnid to .wp show info error message - Fix spawntime printing for .gobject target - Fix guid targetting for .npc set movetype - Fix query by spawnid for .wp show info - Fix deleting of existing waypoints when twice doing the command .wp show on - Fix deleting of existing waypoints when doing the command .wp show off - Change wpguid column in DB and in core to uint32, which is what the spawnid type is in core and db. Closes #18978
2017-02-26Fixed characters_database.sqljoschiwald
2017-02-26Core/Fishing: implement retail-like fishing skill-up functionality (#17528)SnapperRy
Follow-up to 6f1e823. Forgot to update base characters database. Sorry.
2017-02-04Core/Misc: Clarify the use of world_database.sqlAokromes
(cherry picked from commit 4cef7fe72bceac0f7bc44681b6f7952f435f2cb5)
2017-01-29Core/Player: Moved character_template from character to world dbjoschiwald
2017-01-29Core/Entities: Basic AreaTrigger System (#18035)Traesh
* Implemented AreaTrigger Templates * Implemented AreaTrigger Splines * Implemented SPELL_AURA_AREA_TRIGGER * and many more
2017-01-26Core: Change allowed build to 7.1.5.23420Shauren
2017-01-22Core/Players: Fixed accidentally deleting Talentsjoschiwald
Note: If you want to delete deprecated Talents from DB, enable the CharacterDatabaseCleaner