CraftedRO

Results 400 comments of CraftedRO

I can't believe I spent two hours for a flag :) ```sql -- Peon Gakra UPDATE `creature_template` SET `npcflag`=`npcflag`|65665 WHERE `entry`=29944; ```

not sure if we shoud add this zone as tavern or whatever is called

It might be client bug ? Check second 33 - https://youtu.be/F2GGBy8deiE?t=33 https://www.wowhead.com/wotlk/npc=27950/demestrasz#comments ![sqsq](https://user-images.githubusercontent.com/24683355/211673347-d6ddf63f-6e10-4925-9541-4b09b21e1ab8.PNG) Well not even this help but I guess shoud be added too idk ```sql DELETE FROM `areatrigger_tavern`...

This issue is really annoying and must be resolved , if kvipka pr is valid maybe we can push it.

Reference: [source cmangos](https://github.com/cmangos/classic-db/blob/008d36f09fdb7e25ba58db34b8da47a8fa05e660/Updates/4244_TDB-0637_Ras_Frostwhisper_random_yells.sql) convert to c++ and add proper coditions for loot

tested ingame seems fine: ```sql -- Fix credit cmangos UPDATE `quest_template_addon` SET `ExclusiveGroup`=0, `NextQuestId`=0 WHERE `ID`=12008; ```

just in case a wotlk classic ptr video of how it shoud work (also inferno pet is NOT despawned): https://github.com/TrinityCore/TrinityCore/assets/24683355/57d143a4-78d9-405d-9a64-7855df125b24

https://github.com/TrinityCore/TrinityCore/issues/22829 this might be related

71b7cc6361d6 Just tested this and seems fine it does fix the above mentioned issue: https://user-images.githubusercontent.com/24683355/233100618-4570ab2d-dfad-48f7-b64a-72541c8c3d9d.mp4

would be impressive to see this merged into 3.3.5