Edited Files:

• 1_auth.sql
• 2_characters.sql
• 2022_01_24_world_fix_trainers.sql
• DBUpdater.h
• NGrid.h

Created Files

• 2022_03_22_00_Update_Characters.sql

Also edited: Master files for hotfix and world database (not included)

Hello, I report a concern about the spell of dh 197922 which damages the player after use. It seems to me that it shouldn't do any harm to its user. thank you

• Added quest texts in Elwynn Forest, Westfall and Redridge Mountains
• Removed duplicate quest 'Rest and Relaxation'
• Removed deprecated quest 'Calligraphed letter'

Quest text source: https://wowpedia.fandom.com/wiki/Category:Quests_by_zone

Easy errors could not be corrected! In a few hours I fixed 200kb of errors only in the database! there is still a lot of work to be done on the core! although the authors will sell their clumsy hotfixes than do something! During this time that their assembly lives, it was already possible to bring to mind at least the old content, not to mention Bfa

Building CXX object src/server/game/CMakeFiles/game.dir/cmake_pch.hxx.pch In file included from :1: In file included from /BfaCore/source/build/src/server/game/CMakeFiles/game.dir/cmake_pch.hxx:5: In file included from /BfaCore/source/src/server/game/PrecompiledHeaders/gamePCH.h:3: In file included from /BfaCore/source/src/server/game/Entities/Creature/Creature.h:27: In file included from /BfaCore/source/src/server/game/Maps/MapObject.h:22: In file included from /BfaCore/source/src/server/game/Grids/Cells/Cell.h:26: In file included from /BfaCore/source/src/server/game/Grids/GridDefines.h:22: /BfaCore/source/src/server/game/Grids/NGrid.h:92:58: fatal error: cannot assign to non-static data member within const member function 'SetGridId' void SetGridId(const uint32 id) const { i_gridId = id; } ~~~~~~~~ ^ /BfaCore/source/src/server/game/Grids/NGrid.h:92:14: note: member function 'NGrid::SetGridId' is declared const here void SetGridId(const uint32 id) const { i_gridId = id; } ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 1 error generated. make[2]: *** [src/server/game/CMakeFiles/game.dir/build.make:64: src/server/game/CMakeFiles/game.dir/cmake_pch.hxx.pch] Error 1 make[1]: *** [CMakeFiles/Makefile2:1103: src/server/game/CMakeFiles/game.dir/all] Error 2 make[1]: *** Waiting for unfinished jobs....

• Fixed 'Profession Trainer' in starting areas
• Fixed trainer_spell tables for corresponding trainerIds
• Fixed profession trainers in Stormwind and Elwynn Forest
• Updated ReqSkillLine: https://wowpedia.fandom.com/wiki/TradeSkillLineID

TrainerId for classic/cataclysm profession trainers 122 - Alchemy 991 - Blacksmithing 125 - Enchanting 993 - Engineering 424 - Herbalism 383 - Inscription 119 - Jewelcrafting 990 - Leatherworking 992 - Mining 989 - Skinning 163 - Tailoring

• Fixed 'profession trainer' in starting areas
• Fixed trainer_spell for herbalism and inscription
• Fixed trainers: Elise Brightletter, Alchemist Mallory, Reyna Stonebranch, Herbalist Pomeroy, Adele Fielder, Helen Peltskinner, Smith Argus, Tognus Flintfire

Tons of scripts added ( more than 18000+ creature's entryes scripted) Merged with your DB ( NOT REPLACED YOUR SCRIPTS, just added missed)

.......enjoy))...

disabled 2 lines of code that seem to do nothing but create bugs. tested with multiple characters and didn't find any downside of disabling this. The benefit is that spells are added to the action bar correctly when leveling up.

Blasted lands is phasing rapidly between phases I then picked up "The Dark Portal" and then went back to the blasted lands.... phase is now locked but Khadgar is not there.... I then set the quest complete via GM commands to see if it was just a missing the NPC nothing changed so i teleported to Frostwall (on bloodelf hunter) i managed to gm quest complete a couple quests to get a garrison but the next toon i took to the area a garrison was already built and unobtainable. walking in and out of the garrison had the proper name tag on it saying it was my outpost but adding a garrison hearth stone via gm commands the system told me i dont own a garrison on my second toon at this point my first toon started spazzing out and repeating the Swift Hand of Justice animation (Heirloom trinket) rapidly i had to alt+f4 the game client and was unable to log back in

i left the realm running over night and the Linux kernel killed the worldserver sometime over the night Image is from Monitorix system has 56Gb of RAM

also system load during that time period spiked and the system become unusable

Swap space was also maxed out during the time in question

As indicated on the screen below, the pnj offers all the quests at the same time while it seems to me it's one per week I believe if anyone has an idea for an sql query. Thanks

Id PNJ = 144383

hello all mounts with pnj on them are empty, if it would be possible to resolve the concern on mounts 122703; 120968; 44235; 44234; 84101; 163042 thank you

Hello after the worgen quest suite, I arrive at quest 14434 entitled Rut'theran which teleports me but at spawn I find myself in phase 184 instead of 0 (no pnj or boat or gm mode) Thank you