aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
2014-12-21SQL: Sync auth databaseVincent-Michael
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-30SQL: Update /dev/world_database.sqlDDuarte
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-10-18Core/Quest: implement Quest TrackerShinDarth
2014-09-21SQL: Sync world_database after tdb 335.56 releaseVincent-Michael
2014-09-19Revert "SQL: Update dev/world_database.sql"DDuarte
This reverts commit 09f9f3b6b12545e603cca4ef9c50b5415dca9d9a. I forgot that world_database.sql should only get updated in TDB releases.
2014-09-19SQL: Update dev/world_database.sqlDDuarte
2014-09-16Merge branch 'ObjectGuid' of https://github.com/TrinityCore/TrinityCoreShauren
Conflicts: src/server/game/Entities/Player/Player.cpp src/server/game/Entities/Player/Player.h src/server/game/Scripting/MapScripts.cpp src/server/scripts/Northrend/Naxxramas/instance_naxxramas.cpp src/server/scripts/Northrend/Nexus/EyeOfEternity/instance_eye_of_eternity.cpp src/server/scripts/Northrend/Nexus/Nexus/boss_anomalus.cpp src/server/scripts/Northrend/Nexus/Nexus/boss_magus_telestra.cpp src/server/scripts/Northrend/Nexus/Oculus/boss_varos.cpp src/server/scripts/Northrend/Ulduar/HallsOfStone/halls_of_stone.cpp src/server/scripts/Northrend/Ulduar/Ulduar/boss_auriaya.cpp src/server/scripts/Northrend/Ulduar/Ulduar/boss_freya.cpp src/server/scripts/Northrend/Ulduar/Ulduar/boss_hodir.cpp src/server/scripts/Northrend/Ulduar/Ulduar/boss_ignis.cpp src/server/scripts/Northrend/Ulduar/Ulduar/boss_razorscale.cpp src/server/scripts/Northrend/UtgardeKeep/UtgardePinnacle/boss_skadi.cpp src/server/scripts/Northrend/UtgardeKeep/UtgardePinnacle/boss_svala.cpp src/server/scripts/Northrend/UtgardeKeep/UtgardePinnacle/boss_ymiron.cpp
2014-09-14Core/Entities: Use ObjectGuid class in game projectShauren
2014-09-13SQL: Update /dev/world_database.sqlDDuarte
Forgotten change of 27479cf571cf65c9e1657e9c465974449173dc3f
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-28SQL: Sync auth_databaseVincent-Michael
2014-08-28Core/BattleGrounds: store data about BGs victoriesShinDarth
Enable in worldserver.conf Closes #12944 Signed-off-by: DDuarte <dnpd.dd@gmail.com>
2014-08-27SQLs: Update /dev/world_database.sqlDDuarte
Again, do NOT import this file.
2014-08-04SQLs: Move world_database.sql to dev folderDDuarte
Simply because people can't read instruction guides...
2014-07-28CI/Travis: Add steps to create databases and import SQLsDDuarte
This way the automated build with error if sqls contain errors. Do NOT import world_database.sql, keep using TDB releases.
2014-07-13Merge branch `master` into `boost`Subv
Conflicts: BattlegroundMgr.h
2014-06-25SQL: Sync auth_databaseVincent-Michael
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-28SQL: Update old .sql files to keep consistency with auth_database.sqlVincent-Michael
Also update characters_database.sql (generated by mysqldump)
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-16Core/Loot: Implement round robin for under threshold items in case of master ↵Dehravor
loot Thanks @Shauren for pointing out
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-19Core/RBAC: Fix difference problems with 4.3.4Vincent_Michael
2014-01-19Merge pull request #11299 from Carbenium/MailboxCmdDiscover-
Core/Command: Add mailbox command
2014-01-12DB/Guild: Fix incorrect input length limitsDehravor
There is one incorrect field length related to guilds in the database, which can be used to cause an overflow client-side, by sending CMSG_GUILD_INFO_TEXT with long strings. The guild information has the same 500 characters client-side limit as the guild bank tab information, but on server-side it can be 65k characters long. A lengthy guild info makes the whole Guild panel unusable. Length of the other fields match the client's limits in the database: guild bank tab name (16), public note (31), officer note (31), motd (128), guild bank tab info (500). Closes #11395 Signed-off-by: DDuarte <dnpd.dd@gmail.com>
2013-12-06Add mailbox commandCarbenium
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-17SQL: Update auth baseVincent-Michael
2013-09-30Core/RBAC: Fix errors in RBAC sql related to ea2fe0217dSpp
2013-09-29Fix compile under linux and update auth db with latest changesSpp
2013-09-10SQL: Update sql/base/auth_database.sqlNay
2013-09-01Core/Account: Make account password change security variable and various changesAscathor
Settings within worldserver.conf: Three settings for secruity level: 0 - None - No change to current system 1 - Email - Always requires the email entered on registration for confirming. 2 - RBAC - Groups applied with the RBAC role always require the email entered on registration for confirming. RBAC default to every group. Changed some logs to make it more clear what is going on at all. Emails may now no longer exceed 64 chars. Current email is used as regmail. On account creation, two emails are saved. Registration email and normal email. Normal email is relevant afterwards. Registration email can be changed by console ONLY. Includes new commands and changes to existing ones: .account fulfills several new functions: * Still prints GM Level. * If account has permission, it displays the current email. This is not defaulted to any group. * Security level is displayed. Also displays if user has RBAC perm if RBAC security mode is selected .account email allows user to change email with sufficient confirmation .account set sec email allows higher sec with higher sec than account to change the normal email. Registrationemail remains untouched here. .account set sec regmail allows console to change registration email. .pinfo now displays the registration and normal mail. Also fixes .learn all crafts. Closes #10558
2013-08-25Core/Auth: Implement time-based token for user login as described in RFC 6238.raczman
New column in account table is a base32 of token key bytes, coincidentally it is the same format Google's Authenticator Android app uses. If you want that to work, set system time on server correctly and use ntpd. Closes #10527 Signed-off-by: Nay <dnpd.dd@gmail.com>
2013-07-19Core/Misc: Change creatures and gameobject phasemask from 16 to 32 bitsVlad
Signed-off-by: Nay <dnpd.dd@gmail.com>
2013-06-02Merge pull request #9854 from Ascathor/masterSubv
Core/Command: Optimized .pinfo more
2013-06-02DB/Autobroadcast: Update correct db struktur and auth basejoschiwald
2013-05-26Core/Command: Optimized .pinfo moreAscathor
* Moved some checks around * Added RBAC Permission for Email, last login and last ip (group 3 and 4) -- If missing RBAC permission, then it displays "Unauthorized (RBAC)" * Changed totalmail output from uint64 to uint32 * Level either puts Max level, or a list of information necessary * Only queries guild if the current xp query also detects guild membership * Incorporated recent changes into code * Commander requires higher than target to get sensitive data beside RBAC permission.
2013-04-26Update auth_database.sql due the added ip2nation tables.Bezo
2013-04-22[Ip2nationLock] Implement the ip2nation lock country.Bezo
2013-04-05Core/PacketIO: Implemented possibility to ban client addons serversideShauren
2013-03-09SQL: Update sql/base/auth_database.sqlNay
2013-03-04Core/Players: Implemented converting quests on faction change (keeping old ↵Shauren
faction quests in disabled state - not loaded during login) and restoring them if changing back to original faction Closes #890 Closes #9248
2013-02-26Core&SQL: Fix typos (RBAC and equips related)Nay
2013-02-26sql typo fixesSpp
2013-02-26Core/RBAC: Correction to last sqls and update base/auth_database.sqlSpp