Differences

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

--- servers:windows:games:trinitycore_3.3.5_localhost [2025/04/12 17:22] – [Prerequisites] Sean Rhone
+++ servers:windows:games:trinitycore_3.3.5_localhost [2025/04/20 21:30] (current) – Sean Rhone
@@ Line 4: / Line 4: @@
   * These notes provide a local single-player server for World of Warcraft 3.3.5
-  * Last tested commit: [[https://github.com/TrinityCore/TrinityCore/commit/d0292ee5cf163b77378efca80af4b7bc0e83a002|~d0292ee]]
+  * Last tested commit: [[https://github.com/TrinityCore/TrinityCore/commit/a1814cf13d24e7bb5142417a6f8f0dfd08db72e1|a1814cf]]
 ===== Media =====
@@ Line 42: / Line 42: @@
   * VS2022 [[https://visualstudio.microsoft.com/thank-you-downloading-visual-studio/?sku=Community&channel=Release&version=VS2022|VisualStudioSetup.exe]]
-  * :!: Pause installer to close it ASAP ((avoid initial auto-download of unnecessary components))
+  * Pause installer to prevent initial auto-download of unnecessary components
 ==== Required Components ====
@@ Line 57: / Line 57: @@
   * Last tested: ''mariadb-11.7.2-winx64.msi''
-  * [x] MariaDB Server (Entire feature)
+  * ''[x]'' MariaDB Server
-  * [x] Development components (Entire feature)
+  * ''[x]'' Development Components
-  * Third party tools not required
+  * ''[ ]'' Third party tools
-  * Use UTF8 as default server's character set
-  * **Uncheck** Install as service and Enable networking
+  * ''[ ]'' Enable access from remote machines for 'root' user
+  * ''[x]'' Use UTF8 as default server's character set
+  * ''[ ]'' Install as service
+  * ''[ ]'' Enable networking
 ===== Boost =====
   * https://sourceforge.net/projects/boost/files/boost-binaries/
-  * Last tested: ''boost_1_86_0-msvc-14.3-64.exe'' ([[https://sourceforge.net/projects/boost/files/boost-binaries/1.86.0/boost_1_86_0-msvc-14.3-64.exe/download|link]])
+  * Last tested: ''boost_1_88_0-msvc-14.3-64.exe''
-  * :!: 2025/01/14: ''1_87_0'' had build failures
 ===== CMake =====
@@ Line 74: / Line 77: @@
   * Last tested: ''cmake-4.0.1-windows-x86_64.msi''
-  * CMake to PATH env not required
+  * ''[ ]'' Add CMake to the PATH environment variable
 ===== OpenSSL =====
@@ Line 81: / Line 84: @@
   * Last tested: ''Win64OpenSSL-3_5_0.msi''
-  * :!: Copy OpenSSL DLLs to: The OpenSSL binaries (/bin) directory
+  * Copy OpenSSL DLLs to:
+    * ''[x]'' The OpenSSL binaries (/bin) directory
 ====== Download Source ======
@@ Line 90: / Line 94: @@
 ====== Databases ======
+===== Connect =====
   "%ProgramFiles%\MariaDB 11.7\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 11.7\data\my.ini"
   "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p
+===== Databases =====
   CREATE DATABASE authserver;
@@ Line 100: / Line 108: @@
   CREATE DATABASE worldserver;
+===== Users =====
   CREATE USER 'authserver'@'localhost' IDENTIFIED BY 'x';
@@ Line 106: / Line 116: @@
   CREATE USER 'worldserver'@'localhost' IDENTIFIED BY 'x';
+===== Permissions =====
   GRANT ALL PRIVILEGES ON authserver.* to 'authserver'@'localhost';
@@ Line 125: / Line 137: @@
 ****
-<code>"%ProgramFiles%\CMake\bin\cmake.exe" -S "%UserProfile%\Projects\TrinityCore-335\src" -B "%UserProfile%\Projects\TrinityCore-335\build" -G "Visual Studio 17 2022" --fresh -Wno-dev -DBoost_INCLUDE_DIR="%SystemDrive%/local/boost_1_86_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 11.7\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 11.7\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="1"</code>
+<code>"%ProgramFiles%\CMake\bin\cmake.exe" -S "%UserProfile%\Projects\TrinityCore-335\src" -B "%UserProfile%\Projects\TrinityCore-335\build" -G "Visual Studio 17 2022" --fresh -Wno-dev -DBOOST_ROOT="%SystemDrive%/local/boost_1_88_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 11.7\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 11.7\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="1"</code>
 ===== Compile =====
@@ Line 147: / Line 159: @@
 ****
-<code>"%ProgramFiles%\Git\bin\git.exe" -C "%UserProfile%\Projects\TrinityCore-335\src" reset --hard && "%ProgramFiles%\Git\bin\git.exe" -C "%UserProfile%\Projects\TrinityCore-335\src" pull origin "3.3.5" --rebase && "%ProgramFiles%\CMake\bin\cmake.exe" -S "%UserProfile%\Projects\TrinityCore-335\src" -B "%UserProfile%\Projects\TrinityCore-335\build" -G "Visual Studio 17 2022" --fresh -Wno-dev -DBoost_INCLUDE_DIR="%SystemDrive%/local/boost_1_86_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 11.7\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 11.7\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="1" && "%ProgramFiles%\Microsoft Visual Studio\2022\Community\MSBuild\Current\Bin\amd64\MSBuild.exe" "%UserProfile%\Projects\TrinityCore-335\build\ALL_BUILD.vcxproj" -target:"Build" -property:"Configuration=Release"</code>
+<code>"%ProgramFiles%\Git\bin\git.exe" -C "%UserProfile%\Projects\TrinityCore-335\src" reset --hard && "%ProgramFiles%\Git\bin\git.exe" -C "%UserProfile%\Projects\TrinityCore-335\src" pull origin "3.3.5" --rebase && "%ProgramFiles%\CMake\bin\cmake.exe" -S "%UserProfile%\Projects\TrinityCore-335\src" -B "%UserProfile%\Projects\TrinityCore-335\build" -G "Visual Studio 17 2022" --fresh -Wno-dev -DBOOST_ROOT="%SystemDrive%/local/boost_1_88_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 11.7\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 11.7\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="1" && "%ProgramFiles%\Microsoft Visual Studio\2022\Community\MSBuild\Current\Bin\amd64\MSBuild.exe" "%UserProfile%\Projects\TrinityCore-335\build\ALL_BUILD.vcxproj" -target:"Build" -property:"Configuration=Release"</code>
 ====== Content ======
@@ Line 205: / Line 217: @@
   "explorer.exe" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release"
+  DIR "%UserProfile%\Projects\TrinityCore-335\build\bin\Release\"*".sql"
 ====== Settings ======
@@ Line 324: / Line 338: @@
 :: End</code>
+  "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-start.bat"
 ===== Server Update =====
@@ Line 335: / Line 351: @@
 "%ProgramFiles%\Git\bin\git.exe" -C "%UserProfile%\Projects\TrinityCore-335\src" pull origin "3.3.5" --rebase
-"%ProgramFiles%\CMake\bin\cmake.exe" -S "%UserProfile%\Projects\TrinityCore-335\src" -B "%UserProfile%\Projects\TrinityCore-335\build" -G "Visual Studio 17 2022" --fresh -Wno-dev -DBoost_INCLUDE_DIR="%SystemDrive%/local/boost_1_86_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 11.7\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 11.7\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="1"
+"%ProgramFiles%\CMake\bin\cmake.exe" -S "%UserProfile%\Projects\TrinityCore-335\src" -B "%UserProfile%\Projects\TrinityCore-335\build" -G "Visual Studio 17 2022" --fresh -Wno-dev -DBOOST_ROOT="%SystemDrive%/local/boost_1_88_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 11.7\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 11.7\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="1"
 "%ProgramFiles%\Microsoft Visual Studio\2022\Community\MSBuild\Current\Bin\amd64\MSBuild.exe" "%UserProfile%\Projects\TrinityCore-335\build\ALL_BUILD.vcxproj" -target:"Build" -property:"Configuration=Release"
 :: End</code>
+  "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-update.bat"
 ===== Database Back-up =====
@@ Line 358: / Line 376: @@
 :: End</code>
+  "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-database-backup.bat"
 ====== Launcher Shortcuts ======
@@ Line 409: / Line 429: @@
   * ''authserver'' needs started at least once to create the tables and to start ''worldserver'' for account creation
   * Ctrl + C to exit
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 11.7\data\my.ini"
   CD "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && "authserver.exe" --config-dir "%UserProfile%\Projects\TrinityCore-335\conf\authserver"
@@ Line 415: / Line 437: @@
   * Change ''x'' to password
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 11.7\data\my.ini"
   CD "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && "worldserver.exe" --config-dir "%UserProfile%\Projects\TrinityCore-335\conf\worldserver"
@@ Line 427: / Line 451: @@
 ===== Backup =====
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 11.7\data\my.ini"
   CD "%UserProfile%\Downloads"
@@ Line 437: / Line 463: @@
   * [[#databases|Initial set-up]]
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 11.7\data\my.ini"
 ==== authserver ====