Differences

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

--- servers:bsd:games:trinitycore_3.3.5_localhost [2024/12/01 16:09] – [Script] Sean Rhone
+++ servers:bsd:games:trinitycore_3.3.5_localhost [2025/08/27 00:32] (current) – [MMaps] 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 21: / Line 28: @@
   su -
-  pkg install git readline boost-all mariadb114-client cmake bzip2 libressl
+  pkg install git readline boost-all mariadb118-client cmake bzip2 libressl
 ====== Download Source ======
@@ Line 93: / Line 100: @@
 ===== MMaps =====
-  * :!: Takes about 30 minutes on i5-8400H
+  * :!: ~30 minutes i5-8400H ((''Finished. MMAPS were built in 27 Minutes 42 Seconds.'' at ''--threads 4''))
+  * Requires [[#assemble|assembled VMaps]]
+  * ''--threads 8''
   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 135: @@
   * 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'
@@ Line 229: / Line 238: @@
 ==== 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'
@@ Line 243: / Line 252: @@
 # End</code>
+  ~/'Projects/TrinityCore-335/scripts/localhost-databases-backup.sh'
 ===== Restore =====
@@ Line 249: / Line 260: @@
   * ''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 266: @@
   * ''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 272: @@
   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;