Differences

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

--- servers:bsd:games:trinitycore_3.3.5_localhost [2024/12/01 14:49] – [Script] 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 =====
@@ 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 151: / Line 160: @@
 ===== worldserver =====
+==== Initial Defaults Copy ====
 ****
@@ Line 177: / 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 185: / 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 194: / Line 204: @@
 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>
-  ~/'Projects/TrinityCore-335/scripts/tc-335-server-start.sh'
+  ~/'Projects/TrinityCore-335/scripts/localhost-server-start.sh'
 ====== Create GM Account ======
@@ Line 226: / 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 240: / Line 250: @@
 # End</code>
+  ~/'Projects/TrinityCore-335/scripts/localhost-databases-backup.sh'
 ===== Restore =====
@@ Line 246: / 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 260: / 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 274: / 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;