User Tools

Site Tools


servers:bsd:games:trinitycore_3.3.5_localhost

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
servers:bsd:games:trinitycore_3.3.5_localhost [2024/12/01 16:04] – [Script] Sean Rhoneservers:bsd:games:trinitycore_3.3.5_localhost [2025/01/17 16:04] (current) Sean Rhone
Line 2: Line 2:
  
   * TrinityCore ((https://www.trinitycore.org))   * 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 ===== ===== Prerequisites =====
Line 16: Line 19:
   * [[https://trinitycore.org/|TrinityCore]]   * [[https://trinitycore.org/|TrinityCore]]
   * [[https://trinitycore.info/|TrinityCore MMo Project Wiki]]   * [[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 ====== ====== Dependencies ======
Line 126: Line 133:
   * Download the latest ''TDB 335'' ''.7z'' with a web browser   * 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'   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 188: Line 195:
 ===== Script ===== ===== 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/localhost-server-start.sh' && chmod +x ~/'Projects/TrinityCore-335/scripts/localhost-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'
Line 229: Line 236:
 ==== Script ==== ==== 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'   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 250:
  
 # End</code> # End</code>
 +
 +  ~/'Projects/TrinityCore-335/scripts/localhost-databases-backup.sh'
  
 ===== Restore ===== ===== Restore =====
Line 249: Line 258:
  
   * ''x'' is path to ''localserver-authserver-database-*.sql''   * ''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   mariadb -u 'root' -p -f 'authserver' < x
Line 263: Line 264:
  
   * ''x'' is path to ''localserver-characters-database-*.sql''   * ''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   mariadb -u 'root' -p -f 'characters' < x
Line 277: Line 270:
  
   mariadb -u 'root' -p   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;   GRANT ALL PRIVILEGES ON authserver.* to authserver@localhost;
/srv/www/wiki/data/attic/servers/bsd/games/trinitycore_3.3.5_localhost.1733087060.txt.gz · Last modified: by Sean Rhone