Differences

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

--- servers:bsd:games:trinitycore_3.3.5_localhost [2026/04/23 18:57] – [MMaps] Sean Rhone
+++ servers:bsd:games:trinitycore_3.3.5_localhost [2026/06/18 03:27] (current) – [Content] Sean Rhone
@@ Line 2: / Line 2: @@
   * TrinityCore
+  * ''3.3.5''
   * [[https://talk.trinitycore.org/t/singleplayer-scripts-and-desktop-start-launchers-on-windows-linux-freebsd/33293/7|TrinityCore Forums]]
-  * 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 29: / Line 24: @@
   * https://github.com/TrinityCore/TrinityCore/commits/3.3.5/
-  cd ~ && mkdir -p ~/'Projects' && rm -Rf ~/'Projects/TrinityCore-335/src' && git clone --branch '3.3.5' --depth '1' --recurse-submodules 'https://github.com/TrinityCore/TrinityCore.git' ~/'Projects/TrinityCore-335/src'
+  mkdir -p ~/'Projects' && rm -Rf ~/'Projects/TrinityCore-335/src' && git clone --branch '3.3.5' --depth '1' --recurse-submodules 'https://github.com/TrinityCore/TrinityCore.git' ~/'Projects/TrinityCore-335/src'
 ====== Database ======
@@ Line 120: / Line 115: @@
   * https://trinitycore.info/en/install/Server-Setup/Linux-Server-Setup
   * Expects [[games;bsd;wine;world_of_warcraft_3.3.5|World of Warcraft 3.3.5a]]
+  strings ~/'.wine/World of Warcraft 3.3.5/drive_c/Program Files/World of Warcraft/Wo'*'.exe' | grep 'Build'
 ===== DBCs, Maps, and Cameras =====
@@ Line 169: / Line 166: @@
   * https://github.com/TrinityCore/TrinityCore/releases
+  * ''worldserver'' imports on first-launch
   * Last tested: ''TDB_full_world_335.25101_2025_10_21.7z''
@@ Line 193: / Line 191: @@
 BindIP = "127.0.0.1"
 LoginDatabaseInfo = "127.0.0.1;../../mariadb.sock;authserver;x;authserver"
-AllowLoggingIPAddressesInDatabase = 0
 # Etc
+AllowLoggingIPAddressesInDatabase = 0
 Updates.EnableDatabases = 1
 Updates.CleanDeadRefMaxCount = -1
@@ Line 217: / Line 214: @@
 # Connection
 BindIP = "127.0.0.1"
-LoginDatabaseInfo     = "127.0.0.1;../../mariadb.sock;authserver;x;authserver"
+LoginDatabaseInfo = "127.0.0.1;../../mariadb.sock;authserver;x;authserver"
-WorldDatabaseInfo     = "127.0.0.1;../../mariadb.sock;worldserver;x;worldserver"
+WorldDatabaseInfo = "127.0.0.1;../../mariadb.sock;worldserver;x;worldserver"
 CharacterDatabaseInfo = "127.0.0.1;../../mariadb.sock;characters;x;characters"
@@ Line 317: / Line 314: @@
 cp -f ~/'Projects/TrinityCore-335/run/etc/authserver.conf.dist' ~/'Projects/TrinityCore-335/run/etc/authserver.conf'
 cp -f ~/'Projects/TrinityCore-335/run/etc/worldserver.conf.dist' ~/'Projects/TrinityCore-335/run/etc/worldserver.conf'
-sleep '2'
 notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '3000' 'WoW 3.3.5 localhost server update complete'
+read -p 'Done. Press Enter to exit.' 'x'
 # End</code>
@@ Line 332: / Line 328: @@
 <code>
 #!/bin/sh
+cd '/tmp'
+notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '2000' 'Backing-up WoW 3.3.5 Databases...'
 mariadbd-safe --no-watch --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
 sleep '2'
-mariadb-dump --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER --single-transaction --quick 'authserver' -r $HOME/'Downloads/'$(date +%Y-%m-%d-%s)'-WoW-335-localhost-authserver.sql'
+mariadb-dump --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER --single-transaction --quick 'authserver' -r $HOME/'Downloads/'$(date +%Y-%m-%d-%s)'-localhost-authserver.sql'
-mariadb-dump --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER --single-transaction --quick 'characters' -r $HOME/'Downloads/'$(date +%Y-%m-%d-%s)'-WoW-335-localhost-characters.sql'
+mariadb-dump --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER --single-transaction --quick 'characters' -r $HOME/'Downloads/'$(date +%Y-%m-%d-%s)'-localhost-characters.sql'
 mariadb-admin 'shutdown' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER
-notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '3000' 'WoW 3.3.5 Databases Backed-up Successfully to Downloads'
+notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '2000' 'WoW 3.3.5 Databases Backed-up Successfully to Downloads'
 # End</code>
   ~/'Projects/TrinityCore-335/scripts/localhost-databases-backup.sh'
+===== Database Maintenance =====
+  mkdir -p ~/'Projects/TrinityCore-335/scripts' && ee ~/'Projects/TrinityCore-335/scripts/localhost-database-maintenance.sh' && chmod +x ~/'Projects/TrinityCore-335/scripts/localhost-database-maintenance.sh'
+<code>
+#!/bin/sh
+cd '/tmp'
+notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '2000' 'Starting WoW 3.3.5 DB maintenance...'
+mariadbd-safe --no-watch --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
+sleep '2'
+mariadb-check --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER -o -A -f -e --auto-repair
+mariadb-admin 'shutdown' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER
+notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '2000' 'WoW 3.3.5 DB maintenance complete'
+# End</code>
+  ~/'Projects/TrinityCore-335/scripts/localhost-database-maintenance.sh'
 ===== Server Start =====
@@ Line 354: / Line 378: @@
 #!/bin/sh
-mariadbd-safe --no-watch --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
+cd '/tmp'
+xfce4-terminal --minimize -T 'WoW 3.3.5 [MariaDB]' -I ~/'.wine/Icons/WoW-335-256.png' -e ~/'Projects/TrinityCore-335/scripts/localhost-database-start.sh' &
 sleep '2'