• Add general command .xp This command shows the other commands
• Add subcommand "view". Allows to view the actual xp rate with .xp view
• Add subcommand "set". .xp set 5 set your rate to 5
• Add subcommand "default". .xp default set your rate to the original server rate
• Add subcommand "disable". .xp disable set your rate to 0 (disable xp gain but reenable it with set or default)

https://pastebin.com/7Rd3gv7S

OS Debian 10

Linux clients-pools 4.19.0-16-amd64 #1 SMP Debian 4.19.181-1 (2021-03-19) x86_64 GNU/Linux

This is a general issue for all our old modules:

Upgrade the module following https://github.com/azerothcore/skeleton-module/ (missing files, description etc)

@wizzymore this is in the wrong place either redo this statement or remove it and the } at the same time to fix travis and build warning, thats all i did

and comment victim

/home/travis/build/azerothcore/azerothcore-wotlk/modules/mod-individual-xp/src/Individual_XP.cpp:85:52: fatal error: unused parameter 'victim' [-Wunused-parameter]
    void OnGiveXP(Player* p, uint32& amount, Unit* victim) override
                                                     ^
1 error generated.

azerothcore/azerothcore-wotlk@b0b9fec

df37085

/root/azerothcore/modules/mod-individual-xp/src/Individual_XP.cpp:70:48: fatal error: no member named 'PQuery' in 'DatabaseWorkerPool<CharacterDatabaseConnection>'; did you mean 'Query'?
        QueryResult result = CharacterDatabase.PQuery("SELECT `XPRate` FROM `individualxp` WHERE `CharacterGUID` = %u", p->GetGUID().GetCounter());
                                               ^~~~~~
                                               Query
/root/azerothcore/src/server/database/Database/DatabaseWorkerPool.h:119:17: note: 'Query' declared here
    QueryResult Query(std::string_view sql, Args&&... args)
                ^
1 error generated.
make[2]: *** [modules/CMakeFiles/modules.dir/build.make:862: modules/CMakeFiles/modules.dir/mod-individual-xp/src/Individual_XP.cpp.o] Error 1
make[2]: *** Waiting for unfinished jobs....
make[1]: *** [CMakeFiles/Makefile2:1235: modules/CMakeFiles/modules.dir/all] Error 2
make: *** [Makefile:149: all] Error 2

if the XP rate was selected by npc talk and with item exchange or money cost. it should be more funny

I'm not sure if this is the right place but on my server I find it useful to be able to set xp rate to 0, for example for level 60 characters who want to explore level 60 content before moving on to the burning crusade content.

I've made that change to my version of this module by simply changing line 83 from "if (rate == 0 || rate > MaxRate)" to "if (rate > MaxRate)" and thought I'd make the suggestion here in case other people would want the same way to individually turn off xp.

I know this is out of mod-individual xp but adding other configurable "rates" such as honor rate, arena rate, loot rate, reputation rate...

(sorry I use a translator)

hello

last rev azerothcore

Running Induvidual-xp on mysql server version 8.0.27.0
gives you the following error in the worldserver

[1064] You have an error in your SQL syntax; check the manual that corresponds to your 
MySQL server version for the right syntax to use near '%u' at line 1 Error while parsing SQL. 
Core fix required.

To allow things like a halved XP rate or counteracting a double XP weekend, for instance.