aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
2014-04-05Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent-Michael
Conflicts: sql/old/3.3.5a/TDB52_to_TDB53_updates/world/2013_07_24_00_world_spell_script_names.sql sql/updates/world/2013_07_24_00_world_spell_script_names.sql sql/updates/world/2013_07_24_00_world_spell_script_names_335.sql src/server/game/Achievements/AchievementMgr.cpp src/server/game/Achievements/AchievementMgr.h src/server/game/Battlegrounds/ArenaTeamMgr.cpp src/server/game/Chat/ChatLink.cpp src/server/game/DataStores/DBCStores.cpp src/server/game/DataStores/DBCStructure.h src/server/game/DataStores/DBCfmt.h src/server/game/Entities/DynamicObject/DynamicObject.h src/server/game/Entities/Object/Object.cpp src/server/game/Entities/Player/Player.cpp src/server/game/Entities/Unit/StatSystem.cpp src/server/game/Entities/Unit/Unit.cpp src/server/game/Entities/Unit/Unit.h src/server/game/Groups/Group.cpp src/server/game/Handlers/QuestHandler.cpp src/server/game/Miscellaneous/SharedDefines.h src/server/game/Spells/Auras/SpellAuraEffects.cpp src/server/game/Spells/Auras/SpellAuras.cpp src/server/game/World/World.h src/server/scripts/Commands/cs_character.cpp src/server/scripts/Commands/cs_lookup.cpp src/server/scripts/Commands/cs_titles.cpp src/server/scripts/EasternKingdoms/ZulAman/boss_halazzi.cpp src/server/scripts/EasternKingdoms/ZulAman/boss_zuljin.cpp src/server/scripts/EasternKingdoms/ZulGurub/boss_jeklik.cpp src/server/scripts/Kalimdor/zone_darkshore.cpp src/server/scripts/Kalimdor/zone_mulgore.cpp src/server/scripts/Kalimdor/zone_tanaris.cpp src/server/scripts/Northrend/IcecrownCitadel/boss_the_lich_king.cpp src/server/scripts/Spells/spell_dk.cpp src/server/scripts/Spells/spell_mage.cpp src/server/scripts/Spells/spell_rogue.cpp src/server/shared/Database/Implementation/CharacterDatabase.cpp src/server/shared/Database/Implementation/CharacterDatabase.h src/tools/vmap4_extractor/mpq_libmpq04.h
2014-03-16Core/Loot: Implement round robin for under threshold items in case of master ↵Dehravor
loot Thanks @Shauren for pointing out
2014-01-31Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
Conflicts: src/server/game/Entities/Player/Player.cpp src/server/game/Entities/Player/Player.h src/server/scripts/Spells/spell_dk.cpp
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-19Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
Conflicts: src/server/game/Accounts/RBAC.h src/server/game/Entities/Player/Player.cpp src/server/game/Entities/Unit/Unit.h src/server/game/Server/Protocol/Opcodes.cpp
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-13Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
Conflicts: src/server/game/Entities/Player/Player.cpp src/server/game/Spells/SpellMgr.cpp src/server/scripts/EasternKingdoms/ZulAman/boss_akilzon.cpp src/server/scripts/World/npcs_special.cpp src/server/worldserver/worldserver.conf.dist
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-08Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
Conflicts: src/server/game/AI/CoreAI/TotemAI.cpp src/server/game/Entities/Player/Player.cpp src/server/game/Entities/Unit/Unit.cpp src/server/game/Globals/ObjectMgr.cpp src/server/game/Guilds/Guild.cpp src/server/game/Guilds/Guild.h src/server/game/Movement/Spline/MoveSplineInit.cpp src/server/game/Movement/Spline/MovementPacketBuilder.cpp src/server/game/Movement/Spline/MovementPacketBuilder.h src/server/game/Spells/SpellMgr.cpp src/server/scripts/EasternKingdoms/BlackrockMountain/BlackwingLair/boss_nefarian.cpp src/server/scripts/EasternKingdoms/ZulAman/boss_akilzon.cpp src/server/scripts/EasternKingdoms/zone_silverpine_forest.cpp src/server/scripts/Kalimdor/zone_mulgore.cpp src/server/scripts/Kalimdor/zone_stonetalon_mountains.cpp src/server/shared/Database/Implementation/CharacterDatabase.cpp
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-26Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Shauren
2013-10-17SQL: Update auth baseVincent-Michael
2013-10-07Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Shauren
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-11Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent-Michael
Conflicts: src/server/game/Accounts/RBAC.h src/server/game/Battlegrounds/ArenaTeam.cpp
2013-09-10SQL: Update sql/base/auth_database.sqlNay
2013-09-02Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent-Michael
Conflicts: src/server/scripts/Commands/cs_debug.cpp src/server/worldserver/worldserver.conf.dist
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-25Merge remote-tracking branch 'origin/master' into 4.3.4Nay
Conflicts: src/server/game/Spells/SpellMgr.cpp src/server/scripts/Commands/cs_debug.cpp src/server/scripts/EasternKingdoms/zone_redridge_mountains.cpp src/tools/map_extractor/mpq_libmpq04.h
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-19Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent-Michael
Conflicts: src/server/game/Entities/Corpse/Corpse.cpp src/server/game/Globals/ObjectMgr.cpp
2013-07-19Core/Misc: Change creatures and gameobject phasemask from 16 to 32 bitsVlad
Signed-off-by: Nay <dnpd.dd@gmail.com>
2013-06-20Core/Achievements: Fixed field type in *_achievement_progress tablesShauren
2013-06-03Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent-Michael
Conflicts: src/server/shared/Database/Implementation/CharacterDatabase.cpp
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-05-21Merge branch 'master' into 4.3.4 [NOTE: There are parts of code marked as ↵Spp
"REVIEW - MERGE" That needs some review) Conflicts: src/server/game/DataStores/DBCStores.cpp src/server/game/DataStores/DBCStores.h src/server/game/DataStores/DBCfmt.h src/server/game/Entities/Unit/Unit.cpp src/server/game/Entities/Unit/Unit.h src/server/game/Handlers/AuctionHouseHandler.cpp src/server/game/Handlers/GroupHandler.cpp src/server/game/Movement/Spline/MovementTypedefs.h src/server/game/Spells/Auras/SpellAuraEffects.cpp src/server/game/Spells/SpellInfo.cpp src/server/scripts/EasternKingdoms/ScarletEnclave/chapter1.cpp src/server/scripts/Spells/spell_generic.cpp
2013-05-16DB/Characters: Remove guildId from characters table (characters_database.sql ↵Nay
only) This field was dropped long ago in 1a290f17f59943905bec7dd413c4879b4bbf6f8e Thanks to Aokromes for spotting the issue
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-10Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
Conflicts: src/server/game/AI/EventAI/CreatureEventAI.cpp src/server/game/AI/EventAI/CreatureEventAIMgr.h src/server/game/Entities/Creature/Creature.cpp src/server/game/Entities/Object/Object.cpp src/server/game/Entities/Player/Player.cpp src/server/game/Entities/Unit/Unit.cpp src/server/game/Entities/Unit/Unit.h src/server/game/Guilds/Guild.cpp src/server/game/Handlers/MailHandler.cpp src/server/game/Spells/Auras/SpellAuraEffects.cpp src/server/game/Spells/Auras/SpellAuras.cpp src/server/game/Spells/SpellEffects.cpp src/server/scripts/Commands/cs_misc.cpp src/server/scripts/Commands/cs_modify.cpp src/server/scripts/EasternKingdoms/ZulGurub/boss_venoxis.cpp src/server/scripts/Kalimdor/zone_azshara.cpp src/server/scripts/Kalimdor/zone_darkshore.cpp src/server/scripts/Kalimdor/zone_durotar.cpp src/server/scripts/Kalimdor/zone_orgrimmar.cpp src/server/scripts/Spells/spell_mage.cpp src/server/shared/Packets/ByteBuffer.h
2013-03-09SQL: Update sql/base/auth_database.sqlNay
2013-03-04Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
Conflicts: src/server/game/Entities/Creature/Creature.h 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/Globals/ObjectMgr.cpp src/server/game/Handlers/CharacterHandler.cpp
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-27Merge branch 'master' into 4.3.4Spp
Conflicts: src/server/game/Entities/Player/Player.h src/server/game/Quests/QuestDef.cpp src/server/game/Quests/QuestDef.h src/server/game/World/World.cpp src/server/game/World/World.h src/server/scripts/Commands/cs_reload.cpp
2013-02-26Core&SQL: Fix typos (RBAC and equips related)Nay
2013-02-26sql typo fixesSpp
2013-02-26Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
2013-02-26Core/RBAC: Correction to last sqls and update base/auth_database.sqlSpp
2013-02-08Core/Auth: Reverted part of fb43a92cc2aaffab42efebf025b6a12c01af8fde - ↵Shauren
session key is still needed after logging in to be able to switch realms
2013-02-07Core/Accounts: sessionkey field in account table is only a temporary storage ↵Shauren
to pass data from authserver to worldserver and should only be used as such. Clearing sessionkey from database after a successful login to prevent possible exploits.
2013-02-04Fix merge fail (fucking saving button -.-)Vincent_Michael
2013-02-04Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4Vincent_Michael
Conflicts: sql/base/auth_database.sql sql/base/characters_database.sql src/server/game/Entities/Player/Player.cpp src/server/game/Handlers/LFGHandler.cpp src/server/game/Server/WorldSession.cpp src/server/game/Server/WorldSession.h src/server/game/Server/WorldSocket.cpp src/server/game/World/World.cpp src/server/scripts/Spells/spell_generic.cpp
2013-02-04DB/Characters: Update sql/base/characters_database.sqlNay
2013-02-04DB/Auth: Update sql/base/auth_database.sqlNay