Osleyder Gonzalez Acosta

DB/Event: Events calendar update

20

### Description Update of the calendar of events, in addition other events that were missing were added. ### SQL fix ```sql ALTER TABLE `game_event` CHANGE `eventEntry` `eventEntry` smallint unsigned NOT...

**Changes proposed:** Allows the player to see available questlines on the map. - Implement CMSG_UI_MAP_QUEST_LINES_REQUEST - Load QuestPOIBlob.db2 - Load QuestPOIPoint.db2 **Issues addressed:** Closes #28033 **Tests performed:** - Does it...

### Description The QuestLines available to the player are not displayed on the UiMap. ### Expected behaviour It should display the available QuestLines. Example:  ### Steps to reproduce the...

Character set 'utf8mb3' is not supported by .Net Framework - MySQL 8.0.29.0

9

TrinityCore - WowPacketParser Detected build: V9_2_0_43345 Detected locale: enUS Targeted database: Shadowlands Parsing date: 05/26/2022 13:35:21 Using SSL version: OpenSSL 1.1.1o 3 May 2022 (library: OpenSSL 1.1.1o 3 May 2022)...

TrinityCore - WowPacketParser Detected build: V9_0_2_36839 Detected locale: enUS Targeted database: Shadowlands Parsing date: 01/03/2021 19:47:23 ``` Loading module WowPacketParserModule.V8_0_1_27101.dll (fallback) Loading module WowPacketParserModule.V7_0_3_22248.dll (fallback) Loading module WowPacketParserModule.V6_0_2_19033.dll (fallback) Loading...

TrinityCore - WowPacketParser Detected build: V8_0_1_27404 Detected locale: enUS Targeted database: BattleForAzeroth Parsing date: 10/19/2020 20:45:31 ``` 47/70 - Error: Failed writing CreatureTemplateNonWDB WowPacketParser Error: 0 : System.NullReferenceException: Object reference...

TrinityCore - WowPacketParser Detected build: V8_0_1_27404 Detected locale: enUS Targeted database: BattleForAzeroth Parsing date: 10/19/2020 20:45:31 ``` FactionFlag has undefined flags: Unk80 QuestFlagsEx has undefined flags: Unk2000000, Unk4000000 ChannelFlag has...

Problem with creature_template

3

You are creating separate data for the same creature_template, which causes the previous data to be deleted. Example: ``` DELETE FROM `creature_template` WHERE `entry` IN (149290 /*Outland Adventurer*/, 141652 /*Dark...

Double updates in `areatrigger_template`.

1

Detected build: 7.0.3.22522 Targeted database: Legion ``` UPDATE `areatrigger_template` SET `VerifiedBuild`=22522 WHERE `Id`=6669; UPDATE `areatrigger_template` SET `VerifiedBuild`=22522 WHERE `Id`=6669; UPDATE `areatrigger_template` SET `VerifiedBuild`=22522 WHERE `Id`=6669; UPDATE `areatrigger_template` SET `VerifiedBuild`=22522 WHERE...

Detected build: V8_0_1_27377 Targeted database: BattleForAzeroth 45/62 - Write CreatureTemplateNonWDB You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the...