aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
AgeCommit message (Collapse)Author
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>
2014-08-28Merge branch 'Rochet2/ahbot' into masterjackpoz
Close pull request #12917
2014-08-25Core/AHBot: Implemented AHBot based on MaNGOS codeBlipi
Warning: CMake must be rerun Apply if you have crashes Rewrite Seller prices, add random properties and implement some suggestions on price calculations Core/AHBot: Update to latest suggestions Fix SQLs after merge, split the AH bot to spearate headers and cpps, fix the config default values Remove case 8 from GetBuyModifier. It was not correct Fix Gray Grey GRAY typos Change message config name Fix non pch build Fix switch ident, also earlier removed whitespace. Add missing include for non pch build Fix possible crash: if (forplayer || GetOwnerGUID()) changed to if (forplayer) Apply Nayd.diff - Code style fixes Fix leftovers from nayd Correct SQL transaction and change one SQL query to C++ instead Make loot items distinct
2014-08-24TDB 335.55 - 2014/08/24TDB335.55Vincent-Michael
2014-07-13Merge branch `master` into `boost`Subv
Conflicts: BattlegroundMgr.h
2014-07-05TDB 335.54 - 2014/07/05TDB335.54Vincent-Michael
2014-06-25SQL: Renamed updates to follow naming conventionShauren
2014-06-24Update 2014_06_23_00_action_ip_logger.sqlAokromes
2014-06-24SQL: Rename sql after merge prVincent-Michael
2014-06-23Merge pull request #11976 from Ascathor/masterAokromes
Core/Misc: New ability to log account IP access history
2014-06-14SQL: Renamed files to match the naming rulesShauren
2014-06-13Core/Misc:Ascathor
* Fix some codestyle, fix some typos * Change CMakeLists for: Custom (can be uncommented), Events, World ** Custom is theoretically unchanged. You can, however, uncomment the glob_recurse that initializes every file within. This might be easier for beginners. * Introducing the IP Based Action Log System: ** On several different actions, e.g. Login, Character Login, etc., a new entry is added ** Can be logged on and off in worldserver config *** Disabled by default to prevent increased log db size for unknowing users. * Add a new row to account table called 'last_attempt_ip' ** Lists the last ip trying to connect to the account * Add a new type of HookScripts: AccountScript ** Includes: OnAccountLogin, OnFailedAccountLogin, OnEmailChange, OnFailedChange, OnPasswordChange, OnFailedPasswordChange * Added new Hook to PlayerScripts: OnFailedPlayerDelete * Added new variables to PlayerScripts: OnPlayerDelete
2014-04-28DB/RBAC: Fix rbac_permissions orderVincent-Michael
2014-04-25Core/Texts:Vincent-Michael
* Enable some BroadcastTexts stuff (is not finish) * Added reload command for broadcast_text table ToDo: - Enable: Sound/Emote stuff, etc. - Auth base need refresh
2014-03-29TDB 335.53 - 2014/03/29TDB335.53Duarte Duarte
2014-01-31SQL: Update old .sql files to keep consistency with auth_database.sqlDuarte Duarte
Also update characters_database.sql (generated by mysqldump)
2014-01-19Missing changes in 313b294d6b7b248738e30f8164ee4624a66ac5b5Vincent_Michael
2014-01-19Core/RBAC: Fix difference problems with 4.3.4Vincent_Michael
2014-01-19Misc/SQL: Rename SQL from fa2616fe4efa4651d48710c7458cd2d479e9338bDiscover-
2013-12-06Add mailbox commandCarbenium
2013-12-01Update 2013_12_01_00_auth_rbac_permissions.sqlAokromes
2013-12-01Core/Misc: Removed more unused eventAI stuffVincent_Michael
2013-12-01Core/AI: Good bye, Good bye my beloved EventAI system :(Vincent_Michael
2013-11-11Core/Logging: Minor changesSpp
- Select stderr when writing ERROR and FATAL messages - Simplify function defines - Fix `logs` table structure with latest logging changes
2013-10-16Fixed sql files for ce55647c415b710c6b440d96c2f26ebbc06c1d6eShauren
2013-10-16Core/TransportsShauren
* Rewritten path generation, now uses splines - timers are a lot more accurate now * Implemented stopping transports * Implemented spawning transports in instances * Implemented spawning gameobjects as transport passengers * Transport passengers are now stored in creature/gameobject table using gameobject_template.data6 from transport's template as map id
2013-09-29Fix compile under linux and update auth db with latest changesSpp
2013-09-29Core/RBAC: Simplify RBAC implementationSpp
- Drop groups (roles than can have inherited roles) and roles (set of permissions) - Permissions can now have inherited permissions (those act as roles) RBAC DB structure is now limited to four tables - rbac_permissions: Contains permissions and roles - rbac_linked_permissions: Contains the relation between permissions and linked permissions (those permissions that have linked permissions are called roles) - rbac_default_permissions: Contains the list of permissions to be granted to each security level [Added to maintain compatibility in an easy way] - rbac_account_permissions: Contains the list of permissions granted or denied for a particular account. NOTE: IF YOU ARE USING CUSTOM PERMISSIONS, ROLES OR GROUPS CHECK THE SQL BEFORE APPLYING...