Differences

This shows you the differences between two versions of the page.

--- servers:bsd:games:trinitycore_3.3.5_localhost [2024/12/01 14:31] – Sean Rhone
+++ servers:bsd:games:trinitycore_3.3.5_localhost [2025/01/17 16:04] (current) – Sean Rhone
@@ Line 2: / Line 2: @@
   * 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 =====
-  * [[bsd;freebsd_14.1_xfce|FreeBSD 14.1 (Xfce)]]
+  * [[bsd;freebsd_14.2_xfce|FreeBSD 14.2 (Xfce)]]
   * [[servers:bsd:mariadb|MariaDB]]
   * [[games;bsd;wine;world_of_warcraft_3.3.5|World of Warcraft 3.3.5]]
@@ Line 16: / Line 19: @@
   * [[https://trinitycore.org/|TrinityCore]]
   * [[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 ======
@@ Line 93: / Line 100: @@
 ===== MMaps =====
-****
+  * :!: Takes about 30 minutes on i5-8400H
   cp -f ~/'Projects/TrinityCore-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 8 && sync
@@ Line 126: / Line 133: @@
   * 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 ~
+  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'
 ====== Settings ======
 ===== authserver =====
+==== Initial Defaults Copy ====
 ****
@@ Line 143: / Line 152: @@
   * [[https://github.com/TrinityCore/TrinityCore/commits/3.3.5/src/server/authserver/authserver.conf.dist|New commits check]]
   * [[https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/authserver/authserver.conf.dist|Upstream authserver.conf.dist]] ([[https://raw.githubusercontent.com/TrinityCore/TrinityCore/3.3.5/src/server/authserver/authserver.conf.dist|raw]])
-  * Last updated: 2024/09/17
   mkdir -p ~/'Projects/TrinityCore-335/authserver.conf.d' && ee ~/'Projects/TrinityCore-335/authserver.conf.d/localhost-authserver.conf'
@@ Line 152: / Line 160: @@
 ===== worldserver =====
+==== Initial Defaults Copy ====
 ****
@@ Line 159: / Line 169: @@
 ==== localhost ====
-  * Last commit: [[https://github.com/TrinityCore/TrinityCore/commit/e11613eeb5dcad16f5908c9c7dd8109baabe9272|Feb 16, 2023]] ''e11613e''
+  * Last commit: [[https://github.com/TrinityCore/TrinityCore/commit/65e2474ff264e40f579ce2aa29921e9d72c75c6f|Nov 29, 2024]] ''65e2474''
   * [[https://github.com/TrinityCore/TrinityCore/commits/3.3.5/src/server/worldserver/worldserver.conf.dist|New commits check]]
   * [[https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/worldserver/worldserver.conf.dist|Upstream worldserver.conf.dist]] ([[https://raw.githubusercontent.com/TrinityCore/TrinityCore/3.3.5/src/server/worldserver/worldserver.conf.dist|raw]])
-  * Last updated: 2024/09/17
   mkdir -p ~/'Projects/TrinityCore-335/worldserver.conf.d' && ee ~/'Projects/TrinityCore-335/worldserver.conf.d/localhost-worldserver.conf'
@@ Line 179: / Line 188: @@
   * Two separate Terminal windows for ''authserver'' and ''worldserver''
-  * Ctrl + C to exit
   cd ~/'Projects/TrinityCore-335/run/bin' && ~/'Projects/TrinityCore-335/run/bin/authserver' --config-dir ~/'Projects/TrinityCore-335/authserver.conf.d'
@@ Line 187: / Line 195: @@
 ===== 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/tc-335-server-start.sh' && chmod +x ~/'Projects/TrinityCore-335/scripts/tc-335-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'
 <code>
@@ Line 196: / Line 204: @@
 cd ~/'Projects/TrinityCore-335/run/bin'
-xfce4-terminal --title='WoW 3.3.5 localhost authserver' -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 --title='WoW 3.3.5 localhost worldserver' -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>
-  ~/'Projects/TrinityCore-335/scripts/tc-335-server-start.sh'
+  ~/'Projects/TrinityCore-335/scripts/localhost-server-start.sh'
 ====== Create GM Account ======
@@ Line 228: / Line 236: @@
 ==== 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/tc-335-save-backup.sh' && chmod +x ~/'Projects/TrinityCore-335/scripts/tc-335-save-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'
 <code>
@@ Line 239: / Line 247: @@
 mariadb-dump -u 'root' -p --opt -r 'localserver-characters-database-'$(date +%Y-%m-%d-%s)'.sql' 'characters'
 sync
-notify-send 'WoW localhost databases have been backed-up to Downloads.'
+notify-send -i ~/'.local/share/icons/hicolor/48x48/apps/WBE5_Wow.0.png' 'WoW 3.3.5 Databases Backed-up Successfully to Downloads'
-gio open ~/'Downloads'
 # End</code>
+  ~/'Projects/TrinityCore-335/scripts/localhost-databases-backup.sh'
 ===== Restore =====
@@ Line 249: / Line 258: @@
   * ''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
@@ Line 263: / Line 264: @@
   * ''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
@@ Line 277: / Line 270: @@
   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;