Information

TrinityCore ¹⁾

These notes provide a local single-player server for World of Warcraft 3.3.5

Media

Progress Pics

Prerequisites

Resources

Web

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

"%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"

Compile

"%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"

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 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 ²⁾
Requires 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

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"

[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

worldserver

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"

[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

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"

@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

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

Server Update

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

@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

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

Database Back-up

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

@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

"%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

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

"%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"

Bookmarks

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

¹⁾

https://www.trinitycore.org

²⁾

30-40 minutes on i5-8400H, 2 hours i7-740QM

Table of Contents

Information

Media

Prerequisites

Resources

Web

Dependencies

Git

Visual Studio 2022

Required Components

MariaDB Server

Boost

CMake

OpenSSL

Download Source

Databases

Connect

Databases

Users

Permissions

Initial Compile

CMake

Compile

DLLs

Content

DBCs, Maps, and Cameras

VMaps

Extract

Assemble

MMaps

Move Files

Clean-up

World Database

TDB

Settings

authserver

worldserver

Firewall

Block

Delete Rules

Scripts

Server Start

Server Update

Database Back-up

Launcher Shortcuts

Desktop

Server Start

Start Menu

Server Start

Update

Database Backup

Install Notes

Realm

authserver

Create GM Account

Character Data

Backup

Restore

authserver

characters

Quick Commands

Update

Bookmarks