Both sides previous revisionPrevious revisionNext revision | Previous revision |
servers:bsd:games:trinitycore_3.3.5_localhost [2024/12/01 16:00] – Sean Rhone | servers:bsd:games:trinitycore_3.3.5_localhost [2025/01/17 16:04] (current) – Sean Rhone |
---|
| |
* TrinityCore ((https://www.trinitycore.org)) | * TrinityCore ((https://www.trinitycore.org)) |
* 3.3.5 ((https://github.com/TrinityCore/TrinityCore/tree/3.3.5)) | |
| |
* These notes provide a local singleplayer server for World of Warcraft 3.3.5 on FreeBSD | * These notes provide a local single-player server for World of Warcraft 3.3.5 |
| |
| ===== Media ===== |
| |
| * [[https://media.realmofespionage.xyz/index/category/6|Progress Pics]] |
| |
===== Prerequisites ===== | ===== Prerequisites ===== |
* [[https://trinitycore.org/|TrinityCore]] | * [[https://trinitycore.org/|TrinityCore]] |
* [[https://trinitycore.info/|TrinityCore MMo Project Wiki]] | * [[https://trinitycore.info/|TrinityCore MMo Project Wiki]] |
| |
| ==== Web ==== |
| |
| * [[https://talk.trinitycore.org/t/singleplayer-scripts-and-desktop-start-launchers-on-windows-linux-freebsd/33293|TrinityCore Forums]] |
| |
====== Dependencies ====== | ====== Dependencies ====== |
* Download the latest ''TDB 335'' ''.7z'' with a web browser | * Download the latest ''TDB 335'' ''.7z'' with a web browser |
| |
* Expects something like ''TDB_full_world_335.24081_2024_08_17.7z'' in ''~/Downloads'' | * Expects something like ''TDB_full_world_335.24111_2024_11_22.7z'' in ''~/Downloads'' |
| |
rm -Rf ~/'Projects/TrinityCore-335/run/bin/TDB_full_world_335.'*'.sql' && cd ~/'Projects/TrinityCore-335/run/bin' && 7zz x ~/'Downloads/TDB_full_world_335.'*'.7z' && cd ~ && ls ~/'Projects/TrinityCore-335/run/bin/TDB_full_world_335.'*'.sql' | rm -Rf ~/'Projects/TrinityCore-335/run/bin/TDB_full_world_335.'*'.sql' && cd ~/'Projects/TrinityCore-335/run/bin' && 7zz x ~/'Downloads/TDB_full_world_335.'*'.7z' && cd ~ && ls ~/'Projects/TrinityCore-335/run/bin/TDB_full_world_335.'*'.sql' |
===== Script ===== | ===== Script ===== |
| |
* This is attached to the [[games;bsd;wine;world_of_warcraft_3.3.5#desktop_launcher|WoW 3.3.5 desktop launcher]] Server action | * [[games:bsd:wine:world_of_warcraft_3.3.5#desktop_launcher|WoW 3.3.5 Desktop Action Server]] |
| |
mkdir -p ~/'Projects/TrinityCore-335/scripts' && ee ~/'Projects/TrinityCore-335/scripts/localhost-server-start.sh' && chmod +x ~/'Projects/TrinityCore-335/scripts/localhost-server-start.sh' | mkdir -p ~/'Projects/TrinityCore-335/scripts' && ee ~/'Projects/TrinityCore-335/scripts/localhost-server-start.sh' && chmod +x ~/'Projects/TrinityCore-335/scripts/localhost-server-start.sh' |
cd ~/'Projects/TrinityCore-335/run/bin' | cd ~/'Projects/TrinityCore-335/run/bin' |
| |
xfce4-terminal -T 'WoW 3.3.5 localhost — authserver' -I ~/'.local/share/icons/hicolor/48x48/apps/WBE5_Wow.0.png' -e "./'authserver' --config-dir ../../'authserver.conf.d'" & | xfce4-terminal -T 'WoW — authserver' -I ~/'.local/share/icons/hicolor/48x48/apps/WBE5_Wow.0.png' -e "./'authserver' --config-dir ../../'authserver.conf.d'" & |
xfce4-terminal -T 'WoW 3.3.5 localhost — worldserver' -I ~/'.local/share/icons/hicolor/48x48/apps/WBE5_Wow.0.png' -e "./'worldserver' --config-dir ../../'worldserver.conf.d'" | xfce4-terminal -T 'WoW — worldserver' -I ~/'.local/share/icons/hicolor/48x48/apps/WBE5_Wow.0.png' -e "./'worldserver' --config-dir ../../'worldserver.conf.d'" |
| |
# End</code> | # End</code> |
| |
~/'Projects/TrinityCore-335/scripts/tc-335-server-start.sh' | ~/'Projects/TrinityCore-335/scripts/localhost-server-start.sh' |
| |
====== Create GM Account ====== | ====== Create GM Account ====== |
==== Script ==== | ==== Script ==== |
| |
* This is attached to the [[games:bsd:wine:world_of_warcraft_3.3.5#desktop_launcher|WoW 3.3.5 desktop launcher]] Saves action | * [[games:bsd:wine:world_of_warcraft_3.3.5#desktop_launcher|WoW 3.3.5 Desktop Action Saves]] |
| |
mkdir -p ~/'Projects/TrinityCore-335/scripts' && ee ~/'Projects/TrinityCore-335/scripts/localhost-databases-backup.sh' && chmod +x ~/'Projects/TrinityCore-335/scripts/localhost-databases-backup.sh' | mkdir -p ~/'Projects/TrinityCore-335/scripts' && ee ~/'Projects/TrinityCore-335/scripts/localhost-databases-backup.sh' && chmod +x ~/'Projects/TrinityCore-335/scripts/localhost-databases-backup.sh' |
| |
# End</code> | # End</code> |
| |
| ~/'Projects/TrinityCore-335/scripts/localhost-databases-backup.sh' |
| |
===== Restore ===== | ===== Restore ===== |
| |
* ''x'' is path to ''localserver-authserver-database-*.sql'' | * ''x'' is path to ''localserver-authserver-database-*.sql'' |
| |
mariadb -u 'root' -p | |
| |
DROP DATABASE authserver; | |
| |
CREATE DATABASE authserver; | |
| |
EXIT | |
| |
mariadb -u 'root' -p -f 'authserver' < x | mariadb -u 'root' -p -f 'authserver' < x |
| |
* ''x'' is path to ''localserver-characters-database-*.sql'' | * ''x'' is path to ''localserver-characters-database-*.sql'' |
| |
mariadb -u 'root' -p | |
| |
DROP DATABASE characters; | |
| |
CREATE DATABASE characters; | |
| |
EXIT | |
| |
mariadb -u 'root' -p -f 'characters' < x | mariadb -u 'root' -p -f 'characters' < x |
| |
mariadb -u 'root' -p | mariadb -u 'root' -p |
| |
CREATE USER 'authserver'@'localhost' IDENTIFIED BY 'x'; | |
| |
CREATE USER 'characters'@'localhost' IDENTIFIED BY 'x'; | |
| |
GRANT ALL PRIVILEGES ON authserver.* to authserver@localhost; | GRANT ALL PRIVILEGES ON authserver.* to authserver@localhost; |