/home/ubuntu/azerothcore/modules/mod-random-enchants/src/RandomEnchants.cpp:134: 34: fatal error: no member named 'PQuery' in 'DatabaseWorkerPool'; did you mean 'Query'?
QueryResult qr = WorldDatabase.PQuery("SELECT enchantID FROM ite m_enchantment_random_tiers WHERE tier='%d' AND exclusiveSubClass=NULL AND class= '%s' OR exclusiveSubClass='%u' OR class='ANY' ORDER BY RAND() LIMIT 1", tier, Cl assQueryString.c_str(), item->GetTemplate()->SubClass);
^~~~~~
Query
/home/ubuntu/azerothcore/src/server/database/Database/DatabaseWorkerPool.h:119:1 7: note: 'Query' declared here
QueryResult Query(std::string_view sql, Args&&... args)
^
1 error generated.
make[2]: *** [modules/CMakeFiles/modules.dir/build.make:1532: modules/CMakeFiles /modules.dir/mod-random-enchants/src/RandomEnchants.cpp.o] Error 1
make[2]: *** Waiting for unfinished jobs....

1. .additem 21513 or .additem 8484

• https://www.wowhead.com/item=21513/ahnqiraj-war-effort-supplies
• https://www.wowhead.com/item=8484/gadgetzan-water-co-care-package (open item)

Crash

aea540181b38+worldserver.exe[20-10_21-45-24].txt

I want to get the Chinese name of the item, how should I change it?
I am using the Chinese client. I want to get the item name in Chinese, not the current English name. How should I modify it?

If the player is in a team state, the random enchantment of the equipment does not work

For more balanced pvp competition a feature that disables the random enchants on items while in bg or arena and re enables them after the bg or arena would be very good

it wont enchant when an item that is rolled for, you have to pass on it and pick it up, module needs updating to fix this

I have the following warning when trying to compile with the azerothcore commit ce8db43

RandomEnchants.cpp:37:20: fatal error: overlapping comparisons always evaluate to false [-Wtautological-overlap-compare] if ((Quality > 5 && Quality < 1)/*eliminates enchanting anything that isn't a recognized quality*/ || (Class != 2 && Class != 4)/*eliminates enchanting anything but weapons/armor*/) ~~~~~~~~~~~~^~~~~~~~~~~~~~

Here are some suggestions for huge improvements to the module -

All as optional / configs.

1. Enchantments are "tiered" in the database. Offer an option to enable/disable tiers. (E.g no lvl 80+ enchants on a server like ChromieCraft capped at lvl 19/29).

2. Functionality to enable/disable random enchants on items below a certain level. (E.g no lvl 1 gear with +60 fire damage)

3. Functionality to enable/disable random enchants on characters below a certain level. (E.g no lvl 1s with +60 fire damage)

4. Functionality to enable/disable random enchants on BOE or non-binding items. (E.g no mailing crazy enchants to others)

4b) Optional: Other modules achieve this by "binding" the item when it is enchanted. Problem with this is if you're deliberately farming for BOE blues/epics and it forcibly binds because of an enchant you didn't ask for.

5. Functionality to pair item tiers to levels. E.g Item levels 1-30 tier 1, item levels 31-60 tier 1+2, etc.

6. Functionality to limit random enchants on rarity. E.g no grey/white items with enchants.

7. Functionality to disable random enchants on slots. E.g no more tabard/shirts with enchants.

8. Functionality to "smart detect" the item and assign stats relevant to the item (like https://github.com/AnchyDev/StatBooster/tree/master )

9. Popup or sound alerts for enchanted items. Text chat is visible but not noticeable.

10. configurable notification(s) for the looted items

11. add new database columns so that random enchants aren't just using the gem slots which then get them overwritten by adding/removing gems to items

Some/many of these features were figured out by statbooster which was never finished, which in turn lacks many features (randomness/double ench/triple ench).

Both modules have strengths/weaknesses.