servers:games:trinitycore_3.3.5_localhost
This is an old revision of the document!
Table of Contents
Information
- These notes provide a local singleplayer server; for a traditional dedicated server see these notes
- 2024/03/03: WIP: Needs linked to WoW client notes for launching, and desktop launcher save backup, and something for restore like Diablo 2
Prerequisites
Dependencies
sudo dnf install bzip2-devel gcc-c++ cmake git mariadb-devel boost boost-devel readline-devel
Download Source
cd ~ && mkdir -p ~/'Projects' && rm -Rf ~/'Projects/trinity-335/src' && git clone --branch '3.3.5' --depth '1' --recurse-submodules 'https://github.com/TrinityCore/TrinityCore.git' ~/'Projects/trinity-335/src' && sync
Databases
- This creates the
authserver
,characters
, andworldserver
databases
sudo mariadb
CREATE DATABASE authserver;
GRANT ALL PRIVILEGES ON authserver.* to 'authserver'@'localhost' IDENTIFIED BY 'x';
CREATE DATABASE characters;
GRANT ALL PRIVILEGES ON characters.* to 'characters'@'localhost' IDENTIFIED BY 'x';
CREATE DATABASE worldserver;
GRANT ALL PRIVILEGES ON worldserver.* to 'worldserver'@'localhost' IDENTIFIED BY 'x';
FLUSH PRIVILEGES;
EXIT
Compile
- This compiles with GCC and not Clang
rm -Rf ~/'Projects/trinity-335/build' ~/'Projects/trinity-335/run' && mkdir -p ~/'Projects/trinity-335/build' ~/'Projects/trinity-335/run' && cd ~/'Projects/trinity-335/build' && cmake ~/'Projects/trinity-335/src' -DCMAKE_INSTALL_PREFIX=~/'Projects/trinity-335/run' -DTOOLS='1' && sync && make --jobs=$(nproc) install && sync
Content
DBCs, Maps, and Cameras
- Expects World of Warcraft 3.3.5
- 2024/03/06: Takes about 30 seconds on i5-8400H
ln --symbolic --force ~/'Projects/trinity-335/run/bin/mapextractor' ~/'.wine/World of Warcraft 3.3.5/drive_c/Program Files/World of Warcraft 3.3.5a.12340'*'/' && cd ~/'.wine/World of Warcraft 3.3.5/drive_c/Program Files/World of Warcraft 3.3.5a.12340'*'/' && rm -Rf 'dbc' 'maps' 'Cameras' && ./'mapextractor' -f '0' && ln --symbolic --relative --force 'dbc' 'maps' 'Cameras' ~/'Projects/trinity-335/run/bin' && rm -f 'mapextractor' && cd ~ && sync
VMaps
Extract
- Expects World of Warcraft 3.3.5
- 2024/03/06: Takes about 45 seconds on i5-8400H
ln --symbolic --force ~/'Projects/trinity-335/run/bin/vmap4extractor' ~/'.wine/World of Warcraft 3.3.5/drive_c/Program Files/World of Warcraft 3.3.5a.12340'*'/' && cd ~/'.wine/World of Warcraft 3.3.5/drive_c/Program Files/World of Warcraft 3.3.5a.12340'*'/' && rm -Rf 'Buildings' && ./'vmap4extractor' -l && rm -f 'vmap4extractor' && cd ~ && sync
Assemble
- Expects World of Warcraft 3.3.5
- 2024/03/06: Takes about 11 seconds on i5-8400H
ln --symbolic --force ~/'Projects/trinity-335/run/bin/vmap4assembler' ~/'.wine/World of Warcraft 3.3.5/drive_c/Program Files/World of Warcraft 3.3.5a.12340'*'/' && cd ~/'.wine/World of Warcraft 3.3.5/drive_c/Program Files/World of Warcraft 3.3.5a.12340'*'/' && rm -Rf 'vmaps' && mkdir -p 'vmaps' && ./'vmap4assembler' 'Buildings' 'vmaps' && ln --symbolic --relative --force 'vmaps' ~/'Projects/trinity-335/run/bin' && rm -Rf 'Buildings' 'vmap4assembler' && cd ~ && sync
MMaps
- Expects World of Warcraft 3.3.5
- 2024/03/06: Takes about 43 minutes on i5-8400H
ln --symbolic --force ~/'Projects/trinity-335/run/bin/mmaps_generator' ~/'.wine/World of Warcraft 3.3.5/drive_c/Program Files/World of Warcraft 3.3.5a.12340'*'/' && cd ~/'.wine/World of Warcraft 3.3.5/drive_c/Program Files/World of Warcraft 3.3.5a.12340'*'/' && rm -Rf 'mmaps' && mkdir -p 'mmaps' && ./'mmaps_generator' --bigBaseUnit 'true' --threads $(nproc) && ln --symbolic --relative --force 'mmaps' ~/'Projects/trinity-335/run/bin' && rm -f 'mmaps_generator' && cd ~ && sync
TDB
- Check https://github.com/TrinityCore/TrinityCore/releases for updates and update the URL as-needed
- Make certain the database is
335
, and not927
or etc
rm -Rf '/tmp/TDB' '/tmp/TDB/TDB335.7z' && mkdir -p '/tmp/TDB' && cd ~ && wget -O '/tmp/TDB/TDB335.7z' 'https://github.com/TrinityCore/TrinityCore/releases/download/TDB335.24011/TDB_full_world_335.24011_2024_01_21.7z' && 7za x '/tmp/TDB/TDB335.7z' -o'/tmp/TDB' && mv '/tmp/TDB/TDB_full_world_335'*'.sql' ~/'Projects/trinity-335/run/bin' && rm -Rf '/tmp/TDB' && sync
Settings
authserver.conf
- See authserver.conf
worldserver.conf
- See worldserver.conf
Realm
authserver
authserver
needs started at least once to create the tables and to startworldserver
for account creation- Ctrl + C to exit
cd ~/'Projects/trinity-335/run/bin' && ~/'Projects/trinity-335/run/bin/authserver'
Realm
sudo mariadb --execute="UPDATE authserver.realmlist SET name = 'localhost', address = 'localhost' WHERE realmlist.id = 1"
Create GM Account
- 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
Launch
Desktop Launcher
- See Desktop Launcher
- Expects GNOME Terminal 3)
Commands
authserver
cd ~/'Projects/trinity-335/run/bin' && ~/'Projects/trinity-335/run/bin/authserver'
worldserver
cd ~/'Projects/trinity-335/run/bin' && ~/'Projects/trinity-335/run/bin/worldserver'
Character Data
Backup
- Dumps
authserver
andcharacters
MariaDB databases as.sql
in~/Downloads
Desktop Launcher
- See Desktop Launcher
authserver
cd ~/'Downloads' && sudo mariadb-dump --databases 'authserver' --result-file='localserver-authserver-databases-'$(date +%Y-%m-%d-%s)'.sql' && sudo chown $USER:$USER ~/'Downloads/localserver-authserver-databases-'*'.sql' && sync
characters
cd ~/'Downloads' && sudo mariadb-dump --databases 'characters' --result-file='localserver-characters-databases-'$(date +%Y-%m-%d-%s)'.sql' && sudo chown $USER:$USER ~/'Downloads/localserver-characters-databases-'*'.sql' && sync
Restore
- This deletes the existing
authserver
andcharacters
databases before restoring from backup
authserver
ls ~/'Downloads/localserver-authserver-databases-'*'.sql' && sudo mariadb --execute='DROP DATABASE authserver' && sudo mariadb --execute='CREATE DATABASE authserver' && sudo mariadb 'authserver' < ~/'Downloads/localserver-authserver-databases-'*'.sql' && sync
characters
ls ~/'Downloads/localserver-characters-databases-'*'.sql' && sudo mariadb --execute='DROP DATABASE characters' && sudo mariadb --execute='CREATE DATABASE characters' && sudo mariadb 'characters' < ~/'Downloads/localserver-characters-databases-'*'.sql' && sync
Reapply Permissions
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
3)
other Terminals and non-GNOME desktop environments untested
/var/www/wiki/data/attic/servers/games/trinitycore_3.3.5_localhost.1709783077.txt.gz · Last modified: 2024/03/06 22:44 by Sean Rhone