• CMaNGOS ¹⁾
• TBC ²⁾
• tbc-db ³⁾

• These notes provide a local singleplayer server

• 2024/03/31: WIP

• Fedora Workstation
• MariaDB
• World of Warcraft (2.4.3)

sudo dnf install bzip2-devel gcc-c++ cmake git mariadb-devel boost boost-static boost-devel readline-devel

cd ~ && mkdir -p ~/'Projects' && rm -Rf ~/'Projects/cmangos-tbc/src' && git clone --branch 'master' --depth '1' --recurse-submodules 'https://github.com/cmangos/mangos-tbc.git' ~/'Projects/cmangos-tbc/src' && git clone --branch 'master' --depth '1' --recurse-submodules 'https://github.com/cmangos/tbc-db.git' ~/'Projects/cmangos-tbc/src/tbc-db' && sync

• This creates the mangos user for InstallFullDB.sh

sudo mariadb

CREATE USER 'mangos'@'localhost' IDENTIFIED BY 'x';

EXIT

rm -Rf ~/'Projects/cmangos-tbc/build' ~/'Projects/cmangos-tbc/run' && mkdir -p ~/'Projects/cmangos-tbc/build' ~/'Projects/cmangos-tbc/run' && cd ~/'Projects/cmangos-tbc/build' && cmake ~/'Projects/cmangos-tbc/src' -DCMAKE_INSTALL_PREFIX=~/'Projects/cmangos-tbc/run' -DBUILD_EXTRACTORS='1' && sync && make --jobs=$(nproc) install && sync

• WoW Clients from sources other than wowdl.net or known-authentic sources could come modified in ways that fail with certain server emulator checks

• Expects World of Warcraft 2.4.3
• 2024/03/31: Takes about 27 minutes on i5-8400H

cp --remove-destination ~/'Projects/cmangos-tbc/run/bin/tools/'* ~/'.wine/World of Warcraft 2.4.3/drive_c/Program Files/World of Warcraft 2.4.3.8606'*'/' && cd ~/'.wine/World of Warcraft 2.4.3/drive_c/Program Files/World of Warcraft 2.4.3.8606'*'/' && ~/'.wine/World of Warcraft 2.4.3/drive_c/Program Files/World of Warcraft 2.4.3.8606'*'/ExtractResources.sh'

cd ~/'.wine/World of Warcraft 2.4.3/drive_c/Program Files/World of Warcraft 2.4.3.8606'*'/' && mv --force 'maps' 'dbc' 'vmaps' 'mmaps' 'Cameras' ~/'Projects/cmangos-tbc/run/bin'

cd ~/'Projects/cmangos-tbc/src/tbc-db' && ~/'Projects/cmangos-tbc/src/tbc-db/InstallFullDB.sh'

nano ~/'Projects/cmangos-tbc/src/tbc-db/InstallFullDB.config'

• See authserver.conf

• See worldserver.conf

cd ~/cmangos/run/etc cp mangosd.conf.dist mangosd.conf cp realmd.conf.dist realmd.conf cp anticheat.conf.dist anticheat.conf

cp --force-destination ~/'Projects/cmangos-tbc/src/src/mangosd/mangosd.conf.dist.in'

• authserver needs started at least once to create the tables and to start worldserver for account creation
• Ctrl + C to exit

cd ~/'Projects/trinity-335/run/bin' && ~/'Projects/trinity-335/run/bin/authserver'

sudo mariadb --execute="UPDATE authserver.realmlist SET name = 'localhost', address = 'localhost' WHERE realmlist.id = 1"

• Change x to password

cd ~/'Projects/trinity-335/run/bin' && ~/'Projects/trinity-335/run/bin/worldserver'

account create Espionage724 x

account set gmlevel Espionage724 3 -1

server shutdown 1

• See Desktop Launcher
• Expects GNOME Terminal ⁴⁾

cd ~/'Projects/trinity-335/run/bin' && ~/'Projects/trinity-335/run/bin/authserver'

cd ~/'Projects/trinity-335/run/bin' && ~/'Projects/trinity-335/run/bin/worldserver'

• Dumps authserver and characters MariaDB databases as .sql in ~/Downloads

• See Desktop Launcher
• Expects GNOME Terminal ⁵⁾

cd ~/'Downloads' && sudo mariadb-dump --databases 'authserver' --result-file='localserver-authserver-database-'$(date +%Y-%m-%d-%s)'.sql' && sudo chown $USER:$USER ~/'Downloads/localserver-authserver-database-'*'.sql' && sync

cd ~/'Downloads' && sudo mariadb-dump --databases 'characters' --result-file='localserver-characters-database-'$(date +%Y-%m-%d-%s)'.sql' && sudo chown $USER:$USER ~/'Downloads/localserver-characters-database-'*'.sql' && sync

• This deletes the existing authserver and characters databases before restoring from backup
• Only have a single authserver and worldserver .sql in ~/Downloads ^{6) 7)}

ls ~/'Downloads/localserver-authserver-database-'*'.sql' && sudo mariadb --execute='DROP DATABASE authserver' && sudo mariadb --execute='CREATE DATABASE authserver' && sudo mariadb 'authserver' < ~/'Downloads/localserver-authserver-database-'*'.sql' && sync

ls ~/'Downloads/localserver-characters-database-'*'.sql' && sudo mariadb --execute='DROP DATABASE characters' && sudo mariadb --execute='CREATE DATABASE characters' && sudo mariadb 'characters' < ~/'Downloads/localserver-characters-database-'*'.sql' && sync

sudo mariadb

GRANT ALL PRIVILEGES ON authserver.* to 'authserver'@'localhost' IDENTIFIED BY 'x';

GRANT ALL PRIVILEGES ON characters.* to 'characters'@'localhost' IDENTIFIED BY 'x';

FLUSH PRIVILEGES;

EXIT