Differences

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

--- servers:games:trinitycore_3.3.5_localhost [2024/03/06 20:53] – [Assemble] Sean Rhone
+++ servers:games:trinitycore_3.3.5_localhost [2024/03/09 17:43] (current) – [Content] Sean Rhone
@@ Line 6: / Line 6: @@
   * These notes provide a local singleplayer server; for a traditional dedicated server see [[servers:games:trinitycore_3.3.5|these notes]]
-  * TODO: Add to WoW desktop shortcut a launcher for TC servers
-  * 2024/03/03: WIP: Needs linked to WoW client notes for launching, and desktop launcher save backup, and something for restore [[games:wine:diablo_2#saved_games_data|like Diablo 2]]
 ===== Prerequisites =====
@@ Line 52: / Line 49: @@
 ====== 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 ======
+  * :!: WoW Clients from sources other than [[https://wowdl.net/files/clients#wrath-of-the-lich-king|wowdl.net]] or known-authentic sources could come modified in ways that fail with certain server emulator checks ((2022/09/22: [[https://www.warmane.com/download|Warmane's Wrath of the Lich King client]] fails ''StrictVersionCheck=1'' and shouldn't be used))
 ===== DBCs, Maps, and Cameras =====
@@ Line 84: / Line 83: @@
   * Expects [[games:wine:world_of_warcraft_3.3.5|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
@@ Line 151: / Line 151: @@
   cd ~/'Projects/trinity-335/run/bin' && ~/'Projects/trinity-335/run/bin/worldserver'
+====== Character Data ======
+===== Backup =====
+  * Dumps ''authserver'' and ''characters'' MariaDB databases as ''.sql'' in ''~/Downloads''
+==== Desktop Launcher ====
+  * See [[games:wine:world_of_warcraft_3.3.5#desktop_launcher|Desktop Launcher]]
+  * :!: Expects GNOME Terminal ((other Terminals and non-GNOME desktop environments untested))
+==== authserver ====
+****
+  cd ~/'Downloads' && sudo mariadb-dump --databases 'authserver' --result-file='localserver-authserver-database-'$(date +%Y-%m-%d-%s)'.sql' && sudo chown $USER:$USER ~/'Downloads/localserver-authserver-database-'*'.sql' && sync
+==== characters ====
+****
+  cd ~/'Downloads' && sudo mariadb-dump --databases 'characters' --result-file='localserver-characters-database-'$(date +%Y-%m-%d-%s)'.sql' && sudo chown $USER:$USER ~/'Downloads/localserver-characters-database-'*'.sql' && sync
+===== Restore =====
+  * :!: This deletes the existing ''authserver'' and ''characters'' databases before restoring from backup
+  * :!: Only have a single ''authserver'' and ''worldserver'' ''.sql'' in ''~/Downloads'' ((more than 1 makes ''mariadb'' throw ''ambiguous redirect'')) ((TODO: See if there's a way to select a newer file either via timestamp or filename as ''%s'' should always increase?))
+==== authserver ====
+****
+  ls ~/'Downloads/localserver-authserver-database-'*'.sql' && sudo mariadb --execute='DROP DATABASE authserver' && sudo mariadb --execute='CREATE DATABASE authserver' && sudo mariadb 'authserver' < ~/'Downloads/localserver-authserver-database-'*'.sql' && sync
+==== characters ====
+****
+  ls ~/'Downloads/localserver-characters-database-'*'.sql' && sudo mariadb --execute='DROP DATABASE characters' && sudo mariadb --execute='CREATE DATABASE characters' && sudo mariadb 'characters' < ~/'Downloads/localserver-characters-database-'*'.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