aboutsummaryrefslogtreecommitdiff
path: root/src/server/database
AgeCommit message (Collapse)Author
2018-11-09Core/Auras: Fixed saving auras with same spell id but different item sourceShauren
2018-09-21Core/SAI: Add a 4th target parameter to SAIjackpoz
2018-09-16Core/Guild: Implement character gender and send in packet. (#22436)Kittnz
Closes #22433 Credit xvwyh
2018-07-09Core/Players: Fixed saving quest item progressShauren
2018-06-23Typo fix contry -> country (#22075)Gooyeth
2018-06-23Common: Replace ip2nation by ip2location. (#21957)Gooyeth
Replace ip2nation by ip2location. Download: https://lite.ip2location.com/database/ip-country
2018-05-20Core/DBLayer: Escape more keywordsShauren
2018-05-20Core/DBLayer: Escape new mysql 8 keywordsShauren
2018-04-27Core/Player: Skip the cinematic of the first login if the character is ↵Gooyeth
teleported before. (#21776)
2018-04-01Core/Database: Add columns on *_banned (#21748)Gooyeth
* Add columns on ban character query * Add columns on ban account query
2018-03-14Buildsystem: Separate strict database type checks from ↵Shauren
TRINITY_DEBUG/WITH_COREDEBUG option
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-02-24Core/DBUpdater: Code cleanupjackpoz
2018-02-24Core/DBUpdater: Fix error messagejackpoz
Fix error message when trying to populate the database showing free'd memory data instead of the sql file name
2018-02-18Core/DBUpdater: Improve message when base SQL file is missingDDuarte
(cherry picked from commit 844755aa07b4a7f9f2f0c49f351a817198c9a56a) GCC build fix (cherry picked from commit a15985edc620d2ecbd9a44f13f6fec15e13b338d)
2018-02-11Whitespace cleanup in Transaction.cppJildor
Removing white space after commit 54b0b8f5ead41f936b12e97d1b4fbacd9b89ab53
2018-02-10Shared/Database: Improve dead-lock error handlingjackpoz
Improve dead-lock error handling in async transactions by retrying the transaction for up to 60 seconds instead of just 5 times
2018-01-13Core/Auras: removed caster dependency from coreariel-
- Decoupled Unit logic: split of spell critical chance into done (caster bonuses) and taken (target bonuses), this allows to precalculate caster bonuses on aura apply and then check victim's auras on damage/healing calc - Made static a bunch of methods (they no longer have this pointer because they are now called from periodic handlers which may or may not have an active caster in world) - Simplified all AuraEffect bonuses into AuraEffect::_amount, no more duplicated code - Critical chance and whether or not caster is player owned unit (for resilience calcs) is now saved one level upper, on Aura itself (it's impossible as of 3.3.5 to have different effects with different critical chances) - Minor cleanup of SPELL_DAMAGE_CLASS_NONE and Arcane Potency (#18813) crit handling Closes #19876
2018-01-12Core/SAI: Add a 5th parameter to SAI eventsjackpoz
2018-01-08Core/Creature: improve DB linked_respawn handling (#21172)kelno
* Fixed SetCreatureLinkedRespawn function possible erasing/replacing a GameObject link (instead of a creature one)
2018-01-01Update copyright note for 2018tkrokli
Best wishes for the new year.
2017-12-21Build: Inherit the features and warning flags privatelyNaios
(cherry picked from commit 12853475186569b2f47f1d69f817cbef8e590d83)
2017-12-17Build: Use the cotire library for precompiled header handlingNaios
* Required for handling flags inherited by linked projects correctly in the corresponding precompiled header. * Reduces the maintenance effort for precompiled headers
2017-12-17Core/Creature: implement school immunity for creatures in creature_template ↵Wyreth
(#20709)
2017-12-13Buildsystem: Fixed windows pch build with ninjaShauren
(cherry picked from commit a6e46c1c2ef491cd4cce39be47445e9da194e84e)
2017-11-27[3.3.5] Core/AuctionHouse: Auction bidders (#18328)iridinite
* Save more auction bidders than the highest bidder only
2017-11-25Misc: More cleanupAokromes
2017-07-31Dynamic Creature/Go spawning:r00ty-tc
- True blizzlike creature spawn/respawn behavior - new creature = new object - Toggleable spawn groups (with C++/SAI/command options to use them) - Custom feature: dynamic spawn rate scaling. Accelerates respawn rate based on players in the zone. - Backward compatibility mode (set via group and for summons) to support creatures/gos that currently don't work well with this (this should be removed once the exceptions are fixed) Fixes and closes #2858 Tags #8661 as fixable. Fixes and closes #13787 Fixes #15222.
2017-06-22Buildsystem: Minor PCH building changesShauren
* *PCH.cpp are now only compiled with MSVC, other compilers use custom helper commands to generate the precompiled header * Don't call the linker for pch helpertargets (cherry picked from commit 137f5e78877ef1b81f4dca68dd43268e325aeeed)
2017-06-19Core: ported headers cleanup from master branchariel-
2017-05-04Core/Misc: Update locales_creature_text to simple systemChazy Chaz
2017-04-25Core/Misc: Fix static analysis issuesjackpoz
2017-04-12Core/Instance: stop updating the instance resettimes based on creature respawnsariel-
- Rather update normal instance reset time to 2 hours after last creature kill - This fixes yet another integer overflow due to the possibility of having time_t max showing up - Also change respawntime and resettime fields to bigint on respawn/instance related tables - Start using prepared statements on the InstanceSaveMgr
2017-04-11Core/Loot: implement Loot Item Storage (#19018)xinef1
* Created Item Loot Storage, no more synchronous DB selects * Fixed buyback case, where stored loot was not removed from db * Added Primary key, and changed field types to be unsigned for table item_loot_money
2017-03-01Core/Database: Prepared statement parameter preallocation (#18999)ariel-
- Pass prepared statement size to the helper class to prevent runtime resizing. - Rename CheckValidIndex -> AssertValidIndex - Cached prepared size on the worker pool as it's shared among all connections - Cached query data only for each connection, done lookup in map instead of possibly creating a new element - Kill the prepared statement map, and store raw sql string on the MySQLPreparedStatement class (This info is only used for logging, and there is no need of keeping a second container just for it)
2017-01-30Fixed clang segmentation fault in nopch modeShauren
(cherry picked from commit 787adc24b2d1a7a3c03ecfed57de27631359ef65)
2017-01-29Core/Server: fix duplicated inserts into tutorials table for newly created ↵ariel-
characters
2017-01-28Few small optimizations here and there (#18684)xinef1
Changes list: - Added CharacterGuidByNameContainer which contains name -> guid unordered map (updated along CharacterInfo) - Extended CharacterInfo structure with GuildId - Extended CharacterInfo structure with ArenaTeamId[3], for all possible teams (2v2, 3v3, 5v5) - Removed CHAR_SEL_GUID_BY_NAME and CHAR_SEL_CHAR_GUID_BY_NAME synchronous queries, name -> guid can be now retrieved in World::GetCharacterGuidByName - Removed CHAR_SEL_GUID_RACE_ACC_BY_NAME synchronous query, guid can be retrieved by name and rest of the data can be retrieved by guid - Removed CHAR_SEL_CHAR_LEVEL synchronous query, level can be retrieved by guid - Changed CHAR_SEL_CHARACTER_ACTIONS_SPEC to asynchronous query, action bars are now loaded asynchronously - Removed CHAR_SEL_CHARACTER_NAME_CLASS synchronous query, guid can be retrieved by name and rest of the data can be retrieved by guid - Removed CHAR_SEL_PLAYER_ARENA_TEAMS and CHAR_SEL_ARENA_TEAM_ID_BY_PLAYER_GUID synchronous queries, arena teams are now stored in CharacterInfo - Replaced synchronous db calls with CharacterInfo lookups - Removed ObjectMgr::GetPlayerGUIDByName, as it used db query - Replaced some unnecessary UpdateObjectVisibility() calls because they were either duplicated (called few lines above in other function) or it is enough to call DestroyForNearbyPlayers because object is being removed or should be invisible and DestroyForNearbyPlayers is faster - Corrected typo in Player::DestroyForPlayer, only items in slots 0 to EQUIPMENT_SLOT_END are sent to other players - Renamed Player::GetGuildIdFromDB to Player::GetGuildIdFromCharacterInfo and changed the function to use CharacterInfo structure - Renamed Player::GetArenaTeamIdFromDB to Player::GetArenaTeamIdFromCharacterInfo and changed the function to use CharacterInfo structure - Renamed Player::GetLevelFromDB to Player::GetLevelFromCharacterInfo and changed the function to use CharacterInfo structure - Removed GameEventMgr::_questToEventLinks and associated functions, eventId is now stored in Quest class under _eventIdForQuest variable - Changed some functions checking quest status to use other functions for quest status check instead of duplicating code - Removed callback from add friend, because we can get the guid from appropriate storage, no need to make db query - Removed callback from add ignore, because we can get the guid from appropriate storage, no need to make db query - Added callback to unwrap wrapped items asynchronously - Removed synchronous select in tutorials to check if we have any entries in db, if any entry exists in db, m_TutorialsChanged variable will have TUTORIALS_FLAG_LOADED_FROM_DB flag added and it is no longer necessary to query database
2017-01-25Removed debug leftoversShauren
(cherry picked from commit e8273b7b37c86afe42f962f17a5e523e70d97f7d)
2017-01-25Build fixShauren
(cherry picked from commit 0314abc26a8d17cb630c658634b5ad292ece8a88)
2017-01-25Core/DBLayer: Convert async queries to new query callbacks and remove old ↵Shauren
callback handling (cherry picked from commit 8e2634b2b49eb814b8cc425a060b2f160dbb49b7) Conflicts: src/server/bnetserver/Server/Session.cpp src/server/bnetserver/Server/Session.h src/server/database/Database/QueryCallback.cpp src/server/game/Handlers/CharacterHandler.cpp src/server/game/Handlers/SocialHandler.cpp src/server/game/Server/WorldSession.cpp src/server/game/Server/WorldSession.h src/server/game/Server/WorldSocket.cpp src/server/game/Server/WorldSocket.h src/server/game/World/World.cpp src/server/game/World/World.h
2017-01-25Core/DBLayer: Refine new query callback for chainingShauren
(cherry picked from commit 73e61fa652d1233bfff1db91fa2bca8c317c8caf)
2017-01-25Core/DBLayer: Added new async query callback apiShauren
(cherry picked from commit fcabeed7544285f3244465ccfc5337c59e63c6b0)
2017-01-25Core/Packets: updated some contactlist packetsjoschiwald
(cherry picked from commit e01bb918875f88ede211fc13ff3908e30249de33) Conflicts: src/server/game/Entities/Player/Player.cpp src/server/game/Entities/Player/Player.h src/server/game/Entities/Player/SocialMgr.cpp src/server/game/Entities/Player/SocialMgr.h src/server/game/Handlers/MiscHandler.cpp src/server/game/Server/Packets/MiscPackets.cpp src/server/game/Server/Protocol/Opcodes.cpp src/server/game/Server/Protocol/Opcodes.h src/server/game/Server/WorldSession.cpp src/server/game/Server/WorldSession.h src/server/shared/Database/Implementation/CharacterDatabase.cpp src/server/shared/Database/Implementation/CharacterDatabase.h
2017-01-15Core/Updater: Better log for fresh installationsAokromes
2017-01-06Core/Scripts: added command to move characters across accountsariel-
2017-01-02Update Copyright notice for 2017tkrokli
Happy new year!
2016-12-15Core/Pets: Use prepared statements in Pet::SavePetToDBmyran2
Very partial cherry pick (cherry picked from commit bc1a81747ae032bc2ae3681d99f5f6058d20caff)
2016-10-30Core/Auras: don't save auras casted by itemsariel-
- Drop useless field from DB (itemGuid was being saved, but never used, see Prepared Statements) - This type of auras (like Water Bucket, Precious Ribbon, etc) will be recasted on login anyways. This reverts commit 16cfd59f5b368fd1d05eeeab3afbacfccf0a6870
2016-10-07Core/Channel: revamp channel system (#17980)ariel-
* Core/Channel: change the way channels are stored and sent to client. - Fixes multiple channels per zone when using different locales - Connected clients will receive locally the name of the channel for their apropiate locale (if available) - In other cases default locale name will be sent, so as to prevent breaking channel chat for those players Closes #8411