542 Commits

Author SHA1 Message Date
Shauren
5134622a75 Core/DataStores: Load QuestLineXQuest.db2 2021-06-06 20:57:09 +02:00
Shauren
8d5356cdea Core/DataStores: Load PvpTier.db2 2021-06-06 19:06:08 +02:00
Shauren
b607bb0a93 Core/DataStores: Load ItemModifiedAppearanceExtra.db2 2021-06-06 17:56:11 +02:00
Shauren
c2751f9195 Core/Players: Add PlayerExtraFlags for tracking race change, level boost, and raf level grant usage 2021-06-06 14:19:28 +02:00
Shauren
b01fba4bd9 Core/Reputation: Implemented paragon reputation 2021-06-06 00:11:06 +02:00
Shauren
e1f3f1254c Core/Spells: Load spell label data for future use 2021-06-04 21:18:29 +02:00
Shauren
80a6347b7a Core/Reputation: Implemented "friendship reputation" 2021-06-04 19:27:26 +02:00
Shauren
ad683a356a Core/DataStores: Load Achievement_Category.db2 2021-06-03 21:42:12 +02:00
kelno
1206e815cd Core/Creature: improve DB linked_respawn handling (#21172)
* Fixed SetCreatureLinkedRespawn function possible erasing/replacing a GameObject link (instead of a creature one)

(cherry picked from commit 70eb18d0e5)
2021-05-16 21:56:06 +02:00
Shauren
d9d242bea4 Core/Quests: Set quest accept time updatefield 2021-05-11 15:47:58 +02:00
Shauren
3ad389efee Core/Quests: Un-deprecate QUEST_SPECIAL_FLAGS_EXPLORATION_OR_EVENT 2021-05-11 00:38:08 +02:00
Matan Shukry
cd8edc6895 Core/DataStores: Load LanguageWords.db2 and Languages.db2 for future use 2021-04-29 21:18:08 +02:00
Wyreth
ed3b34e33f Core/Creature: implement school immunity for creatures in creature_template (#20709)
(cherry picked from commit ae878e18ef)
2021-04-15 05:53:27 +02:00
Shauren
34a8baba85 Core/DataStores: Updated db2 structures to 9.0.5 2021-04-09 23:48:59 +02:00
Matan Shukry
1c852af7f2 Core/Spells: Implement SPELL_EFFECT_TELEPORT_TO_RETURN_POINT (#26217) 2021-03-28 00:22:34 +01:00
Shauren
08e017b351 Core/AdventureMap: Handle CMSG_ADVENTURE_MAP_START_QUEST 2021-03-14 14:46:07 +01:00
Shauren
d0246e5835 Core/AdventureJournal: Check if player can access adventure journal with ChrClassUIDisplay.db2 2021-03-14 13:07:29 +01:00
Shauren
c15cf8b424 Core/AdventureJournal: Fix broken hotfix database structure from 3addbe7dd4 2021-03-14 01:05:32 +01:00
Osleyder85
3addbe7dd4 Core/AdventureJournal: Handle CMSG_ADVENTURE_JOURNAL_OPEN_QUEST and CMSG_ADVENTURE_JOURNAL_UPDATE_SUGGESTIONS
Merges #26000
2021-03-14 00:21:31 +01:00
Shauren
cb47605235 Core/Players: Implemented secondary stat diminishing 2021-02-07 19:19:06 +01:00
Shauren
3afed1788a Core/Instances: Use level requirements from MapDifficultyXCondition.db2 instead of access_requirement db table 2021-01-02 17:55:43 +01:00
Shauren
49f8b1dbb4 Core/Corpses: Fixed crash during loading corpses
Closes #25748
Closes #25744
2020-12-22 16:11:34 +01:00
Shauren
93f2affbf2 Core/Corpses: Fixed client crashes with player corpses
Closes #25714
2020-12-13 18:38:31 +01:00
Shauren
5f3a2d2abf Core/Quests: Fixed questgiver icons
Closes #25702
2020-12-11 22:19:19 +01:00
Shauren
b82a3a557a Core/DataStores: Updated db2 structures to 9.0.2
* Includes support for new character customization
2020-12-08 18:16:47 +01:00
Shauren
4ca29f3cb0 Core/Misc: First set of required db changes for 9.0 2020-12-08 18:16:46 +01:00
Shauren
b231903932 Core/Misc: Port all the refactors sneaked in master to 3.3.5 include cleanup port 2020-09-04 13:38:24 +02:00
r00ty-tc
03b125e6d1 Dynamic Creature/Go spawning:
- 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.

(cherry picked from commit 59db2eeea0)
2020-08-22 12:59:57 +02:00
Shauren
1c52d5fff7 Core/Misc: Replace NULL with nullptr 2020-08-14 17:06:03 +02:00
Treeston
22bad09c01 Core/DB: Split accounts.session_key into session_key_auth (3.3.5) and session_key_bnet (master), so the branches will no longer break each other's realm switching.
(cherry picked from commit 38de6d3307)
2020-08-03 22:49:31 +02:00
Treeston
73922d2a85 Core/Authserver: Re-organize the accounts table (PR #25135)
- no longer use sha_pass_hash for anything else core-side (.account, SOAP, RA)
- salt/verifier/session_key are now binary
- old s/v/sha_pass_hash fields kept around for backwards compatibility
- sha_pass_hash is still updated (for now), s/v are not
- sha_pass_hash is only read if s/v have been manually changed
- SRP6 b now uses the full 32 bytes of randomness (instead of randomly only using 19)

(cherry picked from commit 3164b58c7d)
2020-08-03 22:37:47 +02:00
Treeston
77380f032b Core/Authserver: Split SRP6 into its own file (PR #25131)
(cherry picked from commit 7f7fa8b23d)
2020-08-03 21:16:30 +02:00
Treeston
e9392ad287 Core/Authserver: Authserver cleanup (PR#25093)
- Fix a handful of 1/256 bugs with most significant byte zero in BigNumber
- Get rid of (most of) the C-style arrays in authserver
- CryptoRandom as a unified source for cryptographic randomness
- Bring our other crypto APIs into 2020
- BigNumber usability improvements
- Authserver is now actually readable as a result of all of the above

(cherry picked from commit 210176fd91)
2020-08-03 19:39:00 +02:00
Shauren
2ff1fd0e95 Core/DataStores: Replace harcoded prepared statement offsets with named constants 2020-07-13 21:30:33 +02:00
Shauren
59f1f60a83 Core/DBLayer: Optimize string based query results by eliminating unneeded buffer copies 2020-07-05 12:17:47 +02:00
Peter Keresztes Schmidt
bab5fd87a3 Core/Misc: Replace Trinity::make_unique with std (#24869) 2020-06-23 08:54:12 +02:00
ForesterDev
01d098830a DB/Account: update account_access table (#24788)
* DB/Account: update account_access table:

- rename fields id -> AccountID, gmlevel -> SecurityLevel
- add Comment field
- rename command .acc set gmlevel to .acc set seclevel

* Update auth database

* Fix primary key

* Temporary restore old command account set gmlevel with same handler as account set seclevel

Use Optional  for realmID - if not set, use -1 (for all realms)

* Rename 2020_XX_XX_00_auth.sql to 2020_06_20_00_auth.sql

* Update auth_database.sql

* Rename 2020_XX_XX_00_world.sql to 2020_06_20_06_world.sql

Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com>
(cherry picked from commit 8e0365d8a6)
2020-06-22 11:03:31 +02:00
Shauren
6533de3100 Core/Items: Implemented corruption and corruption resistance stats 2020-06-13 00:30:32 +02:00
Shauren
c7306439e7 Core/Spells: Implement using different difficulty data from all spell related db2s, not just SpellEffect and SpellPower 2020-06-12 01:29:18 +02:00
Shauren
b47c19d506 Core/DataStores: Allow custom hotfixes (VerifiedBuild <= 0, has loading priority) to coexist with sniffed data (VerifiedBuild > 0) 2020-06-06 23:40:53 +02:00
Shauren
df0a027444 Core/Misc: Ensure that query used for .reload creature_template command always matches the one used for loading during startup 2020-06-04 00:13:05 +02:00
Shauren
4d69cc1c56 Core/Misc: GCC build and warning fixes 2020-05-21 22:15:58 +02:00
Shauren
82b4ca3b7c Core/Creatures: Fixed level 240 guards and updated scaling level calculation 2020-05-02 22:37:32 +02:00
ariel-
7dcc185a15 Core/Instance: stop updating the instance resettimes based on creature respawns
- 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

(cherry picked from commit 4c593f12ca)
2020-04-27 12:25:52 +02:00
xinef1
090fd8304a Core/Loot: implement Loot Item Storage (#19018)
* 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

(cherry picked from commit 9dc3de10f0)
2020-04-27 12:25:52 +02:00
Shauren
af76dc6b88 Core/DataStores: Speedup loading hotfix database and change hotfix database character set to utf8mb4 2020-04-25 17:01:26 +02:00
Shauren
d6d67a9766 Core/DBLayer: Fix build using TRINITY_DEBUG 2020-04-25 00:15:26 +02:00
Shauren
aced88b09b Core/AuctionHouse: After taking a break at the start of patch 8.3 auction house is now back in business. 2020-04-20 20:36:24 +02:00
Shauren
0f0ca3a919 Core/DBLayer: Implement async transaction completion callbacks 2020-04-14 16:23:44 +02:00
Shauren
0969e93d15 Core/DataStore: Load ItemNameDescription 2020-03-26 20:09:40 +01:00