aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
AgeCommit message (Collapse)Author
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
2016-06-14Core/Commands: Implement .neargraveyard (find nearest graveyard from dbc). ↵xjose93
(#17301)
2016-05-11Merge branch '3.3.5-commandfixes' into 3.3.5 (PR #16335)treeston
2016-05-10Scripts/Commands: Small QoL adjustmentstreeston
- .debug hostil now shows spawn ID (DBGUID) in addition to current GUID (so you can .go creature to it) - .npc temp now takes an additional argument before the creature entry that determines whether the spawned creature instantly despawns upon death. Default is instant despawn (current behavior). - Add .npc evade command. - Add .pet level command. - .server shutdown and .server restart now fail with an error message if time is below a config var (GM.ForceShutdownThreshold, default 30s) as long as another player is connected. - New commands .server shutdown force and .server restart force bypass this limitation.
2016-04-16SQLs: Update to the /sql/updates organizationDDuarte
Update SQL files should now be in a sub-folder equal to the current branch name /sql/updates/auth/*.sql -> /sql/updates/auth/3.3.5/*.sql /sql/updates/characters/*.sql -> /sql/updates/characters/3.3.5/*.sql /sql/updates/world/*.sql -> /sql/updates/world/3.3.5/*.sql This facilitates merges between the version branches
2016-04-11TDB 335.61 - 2016/04/11TDB335.61DDuarte
2016-01-13Merge branch '3.3.5-bossboundary' into 3.3.5-base (PR #16089)treeston
2016-01-12Scripts/Instances: Complete rewrite of the boundary system.treeston
- Migrate boundary logic to Maps/AreaBoundary instead of having it sit in InstanceScript (to possibly allow use for other purposes). - Implement the first five boundary types in Maps/AreaBoundary.cpp. - Add boundary checks to Creature's update logic - Add boundary data for all Northrend raids - Add boundary initialization structures and methods to InstanceScript - Modify EnterEvadeMode signature. It now passes a value from the EvadeReason enum as parameter to allow special casing depending on evade reason - Remove previous (weird) boundary code that had them linked to GO spawns
2015-11-07TDB 335.60 - 2015/11/07TDB335.60Carbenium
2015-08-22DB/Misc: Typo fixAokromes
2015-08-21Script/Commands: Add new "debug loadcells" commandjackpoz
Closes #15292
2015-07-14TDB 335.59 - 2015/07/14TDB335.59DDuarte
2015-03-21TDB 335.58 - 2015/03/21TDB335.58Nayd
2015-03-21Core/Updates: Add an automatic database update system. Automatically detects ↵Naios
new and edited sql updates through file lists and hashing. Detects renames, deletes and is able to create and auto import full databases. * cleanups in main.cpp of world & bnetserver * refactoring in DatabaseWorkerPool.h & MySQLConnection.cpp Make sure you re-run cmake, because boost::iostreams was added as dependency. Maybe you need to install libboost-iostreams1.55-dev on unix as well. Import every update manual until (included) those INSERT IGNORE updates for each database. Thanks DDuarte and Shauren for your amazing ideas, help and advises. In hope that nobody gets a "Your database structure is not up to date..." anymore ,-) (cherry picked from commit 352012e53173372ebc82898e1b6854c983b01b25) (cherry picked from commit 1f7f9feafc3f5017d617634ae993d2cdf4430920) For 3.3.5: * Synchronized ConfigureBoost.cmake with 6.x, libboost-filesystem1.55-dev also added as dependency! Signed-off-by: Naios <naios-dev@live.de> Signed-off-by: Nayd <dnpd.dd@gmail.com>
2014-12-21Merge PR https://github.com/TrinityCore/TrinityCore/pull/13702 into 3.3.5jackpoz
Core/RBAC: Add two side trade to RBAC
2014-12-21Core/RBAC: Add two side trade to RBACmthsena
2014-12-10Core/RBAC: Allow setting different default security level roles to different ↵Nyeriah
realms
2014-11-11Scripts/Commands: mod xp commandHeihachi
Closes #13476
2014-11-10Core/Commands: implement .pvpstats commandShinDarth
Shows number of battleground victories in the last 7 days Closes #13460
2014-10-19TDB 335.57 - 2014/10/20TDB335.57DDuarte
2014-10-18Scripts/Commands: Implement mutehistory command for GM's with requested ↵Heihachi
improvements Closes #13350
2014-10-18Scripts/Commands: Implement commands to set and get boss states during run timeNyeriah
Closes #13186
2014-09-21TDB 335.56 - 2014/09/21TDB335.56Vincent-Michael
2014-08-28Scripts/Commands: Implement .guild info commandOdyssey
Displays a information summary about the selected player guild or a given guildId or Name Closes #12949 Signed-off-by: DDuarte <dnpd.dd@gmail.com>