aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
AgeCommit message (Collapse)Author
2020-03-16TDB 335.20031 - 2020/03/16TDB335.20031TDB Release
2020-02-15TDB 335.20021 - 2020/02/15TDB335.20021TDB Release
2020-01-15TDB 335.20011 - 2020/01/15TDB335.20011TDB Release
2019-12-15TDB 335.19121 - 2019/12/15TDB335.19121TDB Release
2019-12-07Core/Realms: Move build info (and auth seeds) to databaseShauren
(cherry picked from commit 61f2eed3531ebfd2585ab05add31ae9e97598233)
2019-11-16TDB 335.19111 - 2019/11/16TDB335.19111TDB Release
2019-10-18TDB 335.19101 - 2019/10/18TDB335.19101TDB Release
2019-09-15TDB 335.19091 - 2019/09/15TDB335.19091TDB Release
2019-08-16TDB 335.19081 - 2019/08/16TDB335.19081TDB Release
2019-08-10[3.3.5] Core/Authserver: TOTP rewrite: (PR #23633)Treeston
- Proper management commands (.account 2fa) - Secrets can now be encrypted (set TOTPTokenSecret in .conf) - Secret now stored in binary - Argon2 and AES primitives - Base32/64 support
2019-07-17Core/DB: Add RBAC for .debug poolstatus, because I need it for the pooling ↵Treeston
branch.
2019-07-16Scripts/Commands: Add .debug questreset to force daily/weekly/monthly quest ↵Treeston
reset.
2019-07-15TDB 335.19071 - 2019/07/15TDB335.19071TDB Release
2019-06-21Core/RBAC: add permission that prevents accounts from earning all ↵Wyrserth
achievements or only realm firsts (#23459) * Core/RBAC: add permission that prevents accounts from earning all achievements or only realm firsts. * Kill evil spaces. * Rename 9999_99_99_99_auth.sql to 2019_06_21_00_auth.sql * Update auth_database.sql
2019-06-16Core/Commands: implement commands to look up a map/item/quest name for a ↵Wyrserth
given id (#23416) * Core/Commands: implement commands to look up a map/item/quest name for a given id. * Add entry to updates table. * Rename 9999_99_99_99_auth.sql to 2019_06_16_00_auth.sql * Add missed change, thanks jackpoz! * Update auth_database.sql
2019-06-15TDB 335.19061 - 2019/06/15TDB335.19061TDB Release
2019-06-06DB: Add new view vw_log_history to show database logs in a better wayjackpoz
2019-05-15TDB 335.19051 - 2019/05/15TDB335.19051TDB Release
2019-04-27Scripts/Commands: Add .debug asan commandsjackpoz
Add ".debug asan memoryleak" and ".debug asan outofbounds" commands to trigger Address Sanitizer warnings at runtime (or other dynamic analysis tools)
2019-04-15TDB 335.19041 - 2019/04/15TDB335.19041TDB Release
2019-03-19TDB 335.19031 - 2019/03/19TDB335.19031TDB Release
2018-12-30Renamed SQL with proper dateShauren
2018-12-30Core/Creatures: Port trainer changes from masterGhaster
Closes #20493
2018-09-17Scripts/Commands: Add .debug dummy. It does nothing, which means you can ↵Treeston
make it do anything.
2018-09-06Core/RBAC: Simplification part 1. Nobody needs different permissions for ↵Treeston
each type of .go command.
2018-08-30Scripts/Commands: New command ".go instance". Goes to an instance.Treeston
2018-06-23Common: Replace ip2nation by ip2location. (#21957)Gooyeth
Replace ip2nation by ip2location. Download: https://lite.ip2location.com/database/ip-country
2018-03-08Core/Creatures: Reworked setting move types in databaseShauren
* Each move type has its own field instead of trying to combine everything in InhabitType * Allow overriding movement separately for each spawn
2018-03-06Scripts/Commands: implemented command .server debugariel-
- 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 Closes #19957
2018-02-18TDB 335.64 - 2018/02/18TDB335.64DDuarte
2018-01-24Scripts/Commands: new command '.debug instancespawn'Treeston
2018-01-09Scripts/Commands: New command: .debug threatinfoTreeston
2018-01-03DB: 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 (cherry picked from commit c2aead1da5b6cb9a3a69e276b3f12a2c76b9ab86)
2017-12-17Scripts/Commands: modify command .dismount to target any selected player ↵ForesterDev
(#19788) - change security lvl for command .dismount to 2 (gamemasters). For players there is /dismount command Closes #19788
2017-10-29Core/Quests: implement Quest Greeting (DB table quest_greeting)ForesterDev
* Core/Quests: implement Quest Greetings. Partial port https://github.com/TrinityCore/TrinityCore/commit/22e230ecec1c7ce4eb4daeb60adfa03098271f34
2017-10-13Core/WorldSession: Add RBAC permission for skipping idle connection check ↵Mikhail Redko
(#20595)
2017-08-01Scripts/Commands: New utility command: .list spawnpoints.Treeston
(I just needed it for dynspawn follow-up work, really.)
2017-06-28Combat/threat rewrite prep - merge RBAC/DB changes.treeston
2017-06-17Correct some missing auth DB changes from b59ca1c.treeston
2017-06-12Add new command 'npc showloot'. Does exactly what it says on the tin.treeston
2017-06-12Insert dynamic_spawning RBACs (already reserved in RBAC.h as of 55d8c2b) ↵treeston
into auth database to prevent constant base file conflicts on that branch.
2017-06-12- Add new commands .group set assistant, .group set maintank and .group set ↵treeston
mainassist to toggle raid member flags. - Fix 2017_05_29_00_auth.sql to be reapply safe.
2017-05-29Scripts/Command: implement .debug play music commandForesterDev
Closes #19809
2017-04-19TDB 335.63 - 2017/04/18TDB335.63DDuarte
2017-03-17Core/Players: Rename "heroic character" to "death knight"Chazy Chaz
Closes #19287
2017-02-06Core/RBAC: sync enum with masterariel-
2017-01-08Scripts/Commands: Fix guid usage and enhance commands (#18278)Rochet2
- 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.
2017-01-06Core/Scripts: added command to move characters across accountsariel-
2016-10-16TDB 335.62 - 2016/10/17TDB335.62DDuarte
2016-10-04Core/Spells: Implementation of QAston proc systemariel-
- Move checks from Unit::IsTriggeredAtSpellProcEvent (old system) to Aura::IsProcTriggeredOnEvent (new system) - Templatize SpellModOp param of Player::ApplySpellMod, also 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