This module allows to do this and this.
Do this and that.

My_new_module requires:
1) Simply `git clone` the module under the `modules` directory of your AzerothCore source or copy paste it manually. 2) Import the SQL manually to the right Database (auth, world or characters) or with the `db_assembler.sh` (if `include.sh` provided). 3) Re-run cmake and launch a clean build of AzerothCore.
If you need to change the module configuration, go to your server configuration directory (where your worldserver or worldserver.exe is), copy my_module.conf.dist to my_module.conf and edit that new file.