====== Information ======

  * TrinityCore ((https://www.trinitycore.org))

  * 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 =====

  * [[windows:10|Windows 10 (21H2)]]
  * [[games;windows;world_of_warcraft_3.3.5|World of Warcraft 3.3.5]]

===== Resources =====

  * [[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 ======

  * https://trinitycore.info/en/install/requirements/windows

===== Git =====

  * https://git-scm.com/downloads/win
  * Last tested: ''Git-2.49.0-64-bit.exe''

===== Visual Studio 2022 =====

  * VS2022 [[https://visualstudio.microsoft.com/thank-you-downloading-visual-studio/?sku=Community&channel=Release&version=VS2022|VisualStudioSetup.exe]]

  * Pause installer to prevent initial auto-download of unnecessary components

==== Required Components ====

  * Desktop development with C++ (C++ core desktop features)
  * MSVC v143 - VS 2022 C++ x64/x86 build tools (Latest)
  * Windows 11 SDK (10.0.26100.3916)

  "%PROGRAMFILES(X86)%\Microsoft Visual Studio\Installer\setup.exe"

===== MariaDB Server =====

  * https://mariadb.org/download/
  * Last tested: ''mariadb-11.8.1-winx64.msi''

  * ''[x]'' MariaDB Server
  * ''[x]'' Development Components
  * ''[ ]'' Third party tools

  * ''[ ]'' 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_88_0-msvc-14.3-64.exe''

===== CMake =====

  * https://cmake.org/download/
  * Last tested: ''cmake-4.0.2-windows-x86_64.msi''

===== OpenSSL =====

  * https://slproweb.com/products/Win32OpenSSL.html (:!: not Light)
  * Last tested: ''Win64OpenSSL-3_5_0.msi''

  * Copy OpenSSL DLLs to:
    * ''[x]'' The OpenSSL binaries (/bin) directory

====== Download Source ======

  * https://github.com/TrinityCore/TrinityCore/commits/3.3.5

  "%PROGRAMFILES%\Git\bin\git.exe" clone --branch "3.3.5" --depth "1" --recurse-submodules "https://github.com/TrinityCore/TrinityCore.git" "%USERPROFILE%\Projects\TrinityCore-335\src"

====== Databases ======

===== Connect =====

  "%PROGRAMFILES%\MariaDB 11.8\bin\mariadbd.exe" --defaults-file="%PROGRAMFILES%\MariaDB 11.8\data\my.ini"

  "%PROGRAMFILES%\MariaDB 11.8\bin\mariadb.exe" -u "root" -p

===== Databases =====

  CREATE DATABASE authserver;

  CREATE DATABASE characters;

  CREATE DATABASE worldserver;

===== Users =====

  CREATE USER 'authserver'@'localhost' IDENTIFIED BY 'x';

  CREATE USER 'characters'@'localhost' IDENTIFIED BY 'x';

  CREATE USER 'worldserver'@'localhost' IDENTIFIED BY 'x';

===== Permissions =====

  GRANT ALL PRIVILEGES ON authserver.* to 'authserver'@'localhost';

  GRANT ALL PRIVILEGES ON characters.* to 'characters'@'localhost';

  GRANT ALL PRIVILEGES ON worldserver.* to 'worldserver'@'localhost';

  FLUSH PRIVILEGES;

  EXIT

====== Initial Compile ======

  * https://trinitycore.info/en/install/Core-Installation/windows-core-installation

===== CMake =====

****

<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.8\include\mysql" -DMYSQL_LIBRARY="%PROGRAMFILES%\MariaDB 11.8\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="1"</code>

===== Compile =====

****

<code>"%PROGRAMFILES%\Microsoft Visual Studio\2022\Community\MSBuild\Current\Bin\amd64\MSBuild.exe" "%USERPROFILE%\Projects\TrinityCore-335\build\ALL_BUILD.vcxproj" -target:"Rebuild" -property:"Configuration=Release"</code>

===== DLLs =====

  COPY /Y "%PROGRAMFILES%\MariaDB 11.8\lib\libmariadb.dll" "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release"

  COPY /Y "%PROGRAMFILES%\OpenSSL-Win64\bin\legacy.dll" "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release"

  COPY /Y "%PROGRAMFILES%\OpenSSL-Win64\bin\libssl-3-x64.dll" "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release"

  COPY /Y "%PROGRAMFILES%\OpenSSL-Win64\bin\libcrypto-3-x64.dll" "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release"

====== Content ======

  * Expects [[games;windows;world_of_warcraft_3.3.5#world_of_warcraft|World of Warcraft 3.3.5]]

===== DBCs, Maps, and Cameras =====

  COPY /Y "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\mapextractor.exe" "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5"

  CD "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5" && "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5\mapextractor.exe" -f "0"

===== VMaps =====

==== Extract ====

  COPY /Y "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\vmap4extractor.exe" "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5"

  CD "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5" && "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5\vmap4extractor.exe" -l

==== Assemble ====

  COPY /Y "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\vmap4assembler.exe" "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5"

  CD "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5" && "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5\vmap4assembler.exe" "Buildings" "vmaps"

===== MMaps =====

  * :!: Takes a while ((30-40 minutes on i5-8400H, 2 hours i7-740QM))
  * Requires [[#assemble|assembled VMaps]]
  * ''--threads 4''

  COPY /Y "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\mmaps_generator.exe" "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5"

  CD "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5" && "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5\mmaps_generator.exe" --bigBaseUnit "true" --threads "4"

===== Move Files =====

****

  MOVE /Y "%ProgramFiles(X86)%\World of Warcraft 3.3.5\Cameras" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && MOVE /Y "%ProgramFiles(X86)%\World of Warcraft 3.3.5\dbc" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && MOVE /Y "%ProgramFiles(X86)%\World of Warcraft 3.3.5\maps" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && MOVE /Y "%ProgramFiles(X86)%\World of Warcraft 3.3.5\mmaps" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && MOVE /Y "%ProgramFiles(X86)%\World of Warcraft 3.3.5\vmaps" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release"

===== Clean-up =====

****

  RMDIR /S /Q "%ProgramFiles(X86)%\World of Warcraft 3.3.5\Buildings" && DEL /Q "%ProgramFiles(X86)%\World of Warcraft 3.3.5\mapextractor.exe" "%ProgramFiles(X86)%\World of Warcraft 3.3.5\mmaps_generator.exe" "%ProgramFiles(X86)%\World of Warcraft 3.3.5\vmap4assembler.exe" "%ProgramFiles(X86)%\World of Warcraft 3.3.5\vmap4extractor.exe"

===== World Database =====

==== TDB ====

  * https://github.com/TrinityCore/TrinityCore/releases
  * Last tested: ''TDB_full_world_335.24111_2024_11_22.7z''

  DEL /Q "%UserProfile%\Projects\TrinityCore-335\build\bin\Release\TDB_full_world_335."*".sql" && "%ProgramFiles%\7-Zip\7z.exe" x "%UserProfile%\Downloads\TDB_full_world_335."*".7z" -o"%UserProfile%\Projects\TrinityCore-335\build\bin\Release"

====== Settings ======

===== authserver =====

  * Last commit: [[https://github.com/TrinityCore/TrinityCore/commit/68bf7e6d12e1689d688db32c05066b8832922c67|Jul 28, 2021]] ''68bf7e6''
  * [[https://github.com/TrinityCore/TrinityCore/commits/3.3.5/src/server/authserver/authserver.conf.dist|New commits check]]
  * [[https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/authserver/authserver.conf.dist|Upstream authserver.conf.dist]] ([[https://raw.githubusercontent.com/TrinityCore/TrinityCore/3.3.5/src/server/authserver/authserver.conf.dist|raw]])

  COPY /Y "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\authserver.conf.dist" "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\authserver.conf"

  MKDIR "%USERPROFILE%\Projects\TrinityCore-335\conf\authserver"

  "notepad.exe" "%USERPROFILE%\Projects\TrinityCore-335\conf\authserver\localhost.conf"

<code>
[authserver]

# Connection
BindIP = "127.0.0.1"
MySQLExecutable = "C:\Program Files\MariaDB 11.8\bin\mariadb.exe"
LoginDatabaseInfo = ".;3306;authserver;x;authserver"
AllowLoggingIPAddressesInDatabase = 0

# Etc
RealmsStateUpdateDelay = 0
Updates.EnableDatabases = 1
Updates.CleanDeadRefMaxCount = -1

# End</code>

===== worldserver =====

  * Last commit: [[https://github.com/TrinityCore/TrinityCore/commit/7b0d1f09135999958e850dd67ed9c5b1eaf16536|May 8th, 2025]] ''7b0d1f0''
  * [[https://github.com/TrinityCore/TrinityCore/commits/3.3.5/src/server/worldserver/worldserver.conf.dist|New commits check]]
  * [[https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/worldserver/worldserver.conf.dist|Upstream worldserver.conf.dist]] ([[https://raw.githubusercontent.com/TrinityCore/TrinityCore/3.3.5/src/server/worldserver/worldserver.conf.dist|raw]])

  COPY /Y "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\worldserver.conf.dist" "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\worldserver.conf"

  MKDIR "%USERPROFILE%\Projects\TrinityCore-335\conf\worldserver"

  "notepad.exe" "%USERPROFILE%\Projects\TrinityCore-335\conf\worldserver\localhost.conf"

<code>
[worldserver]

# Connection
BindIP = "127.0.0.1"
MySQLExecutable = "C:\Program Files\MariaDB 11.8\bin\mariadb.exe"
LoginDatabaseInfo = ".;3306;authserver;x;authserver"
WorldDatabaseInfo = ".;3306;worldserver;x;worldserver"
CharacterDatabaseInfo = ".;3306;characters;x;characters"
AllowLoggingIPAddressesInDatabase = 0

# Server
Updates.CleanDeadRefMaxCount = -1
FlashAtStart = 0
Server.LoginInfo = 1
Motd = "Welcome to your localhost server!"
AllowTickets = 0
CharDelete.Method = 1
CharDelete.KeepDays = 0
HotSwap.Enabled = 0
HotSwap.EnableReCompiler = 0

# Quests
Quests.LowLevelHideDiff = -1
Quests.HighLevelHideDiff = -1

# Character
GM.LoginState = 0

# Protections
MaxOverspeedPings = 0
PacketSpoof.Policy = 0
ChatFakeMessagePreventing = 0
ChatFlood.MessageCount = 0

# End</code>

====== Firewall ======

===== Block =====

  "netsh.exe" advfirewall firewall add rule name="TrinityCore 3.3.5 localhost (authserver)" dir="in" action="block" profile="any" program="%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\authserver.exe"

  "netsh.exe" advfirewall firewall add rule name="TrinityCore 3.3.5 localhost (worldserver)" dir="in" action="block" profile="any" program="%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\worldserver.exe"

  "netsh.exe" advfirewall firewall add rule name="MariaDB Server" dir="in" action="block" profile="any" program="%PROGRAMFILES%\MariaDB 11.8\bin\mariadbd.exe"

===== Delete Rules =====

  "netsh.exe" advfirewall firewall delete rule name="TrinityCore 3.3.5 localhost (authserver)"

  "netsh.exe" advfirewall firewall delete rule name="TrinityCore 3.3.5 localhost (worldserver)"

  "netsh.exe" advfirewall firewall delete rule name="MariaDB Server"

====== Scripts ======

****

  MKDIR "%USERPROFILE%\Projects\TrinityCore-335\scripts"

===== Server Start =====

  "notepad.exe" "%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-server-start.bat"

<code>
@echo off

START "MariaDB Server" "%PROGRAMFILES%\MariaDB 11.8\bin\mariadbd.exe" --defaults-file="%PROGRAMFILES%\MariaDB 11.8\data\my.ini"
TIMEOUT /T "3" /NOBREAK

CD "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release"
START "WoW 3.3.5 [auth]" "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\authserver.exe" --config-dir "%USERPROFILE%\Projects\TrinityCore-335\conf\authserver"
START "WoW 3.3.5 [world]" "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\worldserver.exe" --config-dir "%USERPROFILE%\Projects\TrinityCore-335\conf\worldserver"

:: End</code>

  "%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-server-start.bat"

===== Server Update =====

  "notepad.exe" "%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-server-update.bat"

<code>
@echo off

TITLE WoW 3.3.5 Server Updater

"%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.8\include\mysql" -DMYSQL_LIBRARY="%PROGRAMFILES%\MariaDB 11.8\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 =====

  "notepad.exe" "%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-database-backup.bat"

<code>
@echo off

TITLE WoW 3.3.5 localhost Save Back-up

START "MariaDB Server" "%PROGRAMFILES%\MariaDB 11.8\bin\mariadbd.exe" --defaults-file="%PROGRAMFILES%\MariaDB 11.8\data\my.ini"
TIMEOUT /T "3" /NOBREAK

CD "%USERPROFILE%\Downloads"

ECHO Root MariaDB user password prompts:
"%PROGRAMFILES%\MariaDB 11.8\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-authserver.sql" "authserver"
"%PROGRAMFILES%\MariaDB 11.8\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-characters.sql" "characters"

::COPY /Y "%UserProfile%\Downloads\localhost-authserver.sql" "\\Alira\NAS\Games\Saves\WoW"
::COPY /Y "%UserProfile%\Downloads\localhost-characters.sql" "\\Alira\NAS\Games\Saves\WoW"

:: End</code>

  "%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-database-backup.bat"

====== Launcher Shortcuts ======

===== Desktop =====

==== Server Start ====

  "%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-server-start.bat"

  WoW 3.3.5 Server

===== Start Menu =====

  MKDIR "%AppData%\Microsoft\Windows\Start Menu\Programs\World of Warcraft 3.3.5"

  "explorer.exe" "%AppData%\Microsoft\Windows\Start Menu\Programs\World of Warcraft 3.3.5"

==== Server Start ====

  "%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-server-start.bat"

  Server Start

==== Update ====

  "%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-server-update.bat"

  Server Updater

==== Database Backup ====

  "%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-database-backup.bat"

  Database Back-up

==== Install Notes ====

  "https://wiki.realmofespionage.xyz/servers;windows;games;trinitycore_3.3.5_localhost"

  Install Notes (Server)

====== Realm ======

===== authserver =====

  * ''authserver'' needs started at least once to create the tables and to start ''worldserver'' for account creation
  * Ctrl + C to exit

  "%PROGRAMFILES%\MariaDB 11.8\bin\mariadbd.exe" --defaults-file="%PROGRAMFILES%\MariaDB 11.8\data\my.ini"

  CD "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release" && "authserver.exe" --config-dir "%USERPROFILE%\Projects\TrinityCore-335\conf\authserver"

===== Create GM Account =====

  * Change ''x'' to password

  "%PROGRAMFILES%\MariaDB 11.8\bin\mariadbd.exe" --defaults-file="%PROGRAMFILES%\MariaDB 11.8\data\my.ini"

  CD "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release" && "worldserver.exe" --config-dir "%USERPROFILE%\Projects\TrinityCore-335\conf\worldserver"

  account create Espionage724 x

  account set gmlevel Espionage724 3 -1

  server shutdown 1

====== Character Data ======

===== Backup =====

  "%PROGRAMFILES%\MariaDB 11.8\bin\mariadbd.exe" --defaults-file="%PROGRAMFILES%\MariaDB 11.8\data\my.ini"

  CD "%USERPROFILE%\Downloads"

  "%PROGRAMFILES%\MariaDB 11.8\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-authserver.sql" "authserver"

  "%PROGRAMFILES%\MariaDB 11.8\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-characters.sql" "characters"

===== Restore =====

  * [[#databases|Initial set-up]]

  "%PROGRAMFILES%\MariaDB 11.8\bin\mariadbd.exe" --defaults-file="%PROGRAMFILES%\MariaDB 11.8\data\my.ini"

==== authserver ====

  "%PROGRAMFILES%\MariaDB 11.8\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE authserver"

  "%PROGRAMFILES%\MariaDB 11.8\bin\mariadb.exe" -u "root" -p "authserver" < "%USERPROFILE%\Downloads\localhost-authserver.sql"

  "%ProgramFiles%\MariaDB 11.8\bin\mariadb.exe" -u "root" -p "authserver" < "\\Alira\NAS\Games\Saves\WoW\localhost-authserver.sql"

==== characters ====

  "%PROGRAMFILES%\MariaDB 11.8\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE characters"

  "%PROGRAMFILES%\MariaDB 11.8\bin\mariadb.exe" -u "root" -p "characters" < "%USERPROFILE%\Downloads\localhost-characters.sql"

  "%ProgramFiles%\MariaDB 11.8\bin\mariadb.exe" -u "root" -p "characters" < "\\Alira\NAS\Games\Saves\WoW\localhost-characters.sql"

====== Quick Commands ======

===== Update =====

****

<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.8\include\mysql" -DMYSQL_LIBRARY="%PROGRAMFILES%\MariaDB 11.8\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>

===== Bookmarks =====

  * https://github.com/TrinityCore/TrinityCore/commits/3.3.5