User Tools

Site Tools


servers:windows:games:trinitycore_3.3.5_localhost

This is an old revision of the document!


Information

Media

Resources

Crowdfunding

Prerequisites

Dependencies

Visual Studio 2022

DEL /Q "%UserProfile%\Downloads\vs_community.exe" & "%SystemRoot%\System32\curl.exe" --output "%UserProfile%\Downloads\vs_community.exe" --location "https://aka.ms/vs/17/release/vs_community.exe" --progress-bar && "%UserProfile%\Downloads\vs_community.exe"

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.7705)
  • MSBuild support for LLVM (clang-cl) toolset
"%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe"

LLVM

  • [x] Do not add LLVM to the system PATH
  • [ ] Create LLVM Desktop Icon
  • [x] Do not create shortcuts

Boost

CMake

  • [ ] Add CMake to the PATH environment variable
  • [ ] Add CMake shortcut to the Desktop
windows-x86_64.msi

OpenSSL

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

Download Source

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

Settings

RMDIR /S /Q "%UserProfile%\Projects\TrinityCore-335\mariadb\database" & MKDIR "%UserProfile%\Projects\TrinityCore-335\mariadb\database" & "%SystemRoot%\System32\notepad.exe" "%UserProfile%\Projects\TrinityCore-335\mariadb\custom.cnf"
[client]
default-character-set = 'utf8mb4'

[mariadb-client]
default-character-set = 'utf8mb4'

[mariadbd]
character-set-client-handshake = 'FALSE'
character-set-server = 'utf8mb4'
collation-server = 'utf8mb4_unicode_ci'
init-connect='SET NAMES utf8mb4'
expire_logs_days = '7'
max_binlog_size = '100M'
skip-networking = 'On'
table_definition_cache = '1400'

# End

Initialize

"%ProgramFiles%\MariaDB 12.3\bin\mariadb-install-db.exe" --skip-networking --datadir="%UserProfile%\Projects\TrinityCore-335\mariadb\database" --config="%UserProfile%\Projects\TrinityCore-335\mariadb\custom.cnf"

Connect

"%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"
"%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"

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

CMake

CXX_FLAGS Info

Clang

DIR /B "%ProgramFiles%\LLVM\lib\clang"
SET "LLVMInstallDir=%ProgramFiles%\LLVM"
SET "LLVMToolsVersion=22"
"%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_90_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 12.3\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 12.3\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="1" -T "ClangCL" -DBoost_COMPILER="-vc143" -DCMAKE_CXX_FLAGS="/EHs /arch:AVX2 /favor:INTEL64 /Gz /Oy /GS- /guard:cf- /W0 -Wno-everything"

MSVC

"%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_90_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 12.3\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 12.3\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="1" -DCMAKE_CXX_FLAGS="/EHs /arch:AVX2 /favor:INTEL64 /Gz /Oy /GS- /guard:cf- /W0"

Compile

  • ~5 minutes i5-8400H 3)
"%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" -maxCpuCount -nodeReuse:"False" -terminalLogger:"off" -binaryLogger:"output.binlog;ProjectImports=None"
SET "LLVMInstallDir="
SET "LLVMToolsVersion="

DLLs

COPY /Y "%ProgramFiles%\MariaDB 12.3\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

DIR "%ProgramFiles(x86)%\World of Warcraft 3.3.5\Wow.exe" | "%SystemRoot%\System32\find.exe" "7,704,216 Wow.exe"

DBCs, Maps, and Cameras

"%UserProfile%\Projects\TrinityCore-335\build\bin\Release\mapextractor.exe" -i "%ProgramFiles(x86)%\World of Warcraft 3.3.5" -o "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" -f "0"

VMaps

Extract

CD "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && "%UserProfile%\Projects\TrinityCore-335\build\bin\Release\vmap4extractor.exe" -d "%ProgramFiles(x86)%\World of Warcraft 3.3.5" -l

Assemble

"%UserProfile%\Projects\TrinityCore-335\build\bin\Release\vmap4assembler.exe" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release\Buildings" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release\vmaps"

MMaps

  • :!: 30-40 minutes i5-8400H 4)
  • --threads %NUMBER_OF_PROCESSORS%
CD "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && "%UserProfile%\Projects\TrinityCore-335\build\bin\Release\mmaps_generator.exe" --silent --skipJunkMaps "true" --debugOutput "false" --bigBaseUnit "true" --threads %NUMBER_OF_PROCESSORS%

Check Files

  • TrinityCore-335\build\bin\Release needs Cameras, dbc, maps, mmaps, and vmaps folders
DIR /AD /B "%UserProfile%\Projects\TrinityCore-335\build\bin\Release"
"%SystemRoot%\explorer.exe" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release"

Clean-up

RMDIR /S /Q "%UserProfile%\Projects\TrinityCore-335\build\bin\Release\Buildings" & DEL /Q "%UserProfile%\Projects\TrinityCore-335\build\bin\Release\mapextractor.exe" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release\mmaps_generator.exe" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release\vmap4assembler.exe" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release\vmap4extractor.exe"

World Database

TDB

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"
DEL /Q "%UserProfile%\Downloads\TDB_full_world_335."*".7z"

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" & "%SystemRoot%\System32\notepad.exe" "%UserProfile%\Projects\TrinityCore-335\conf\authserver\localhost.conf"
[authserver]

# Connection
BindIP = "127.0.0.1"
MySQLExecutable = "C:\Program Files\MariaDB 12.3\bin\mariadb.exe"
AllowLoggingIPAddressesInDatabase = 0

LoginDatabaseInfo = ".;3306;authserver;x;authserver"

# Etc
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" & "%SystemRoot%\System32\notepad.exe" "%UserProfile%\Projects\TrinityCore-335\conf\worldserver\localhost.conf"
[worldserver]

# Connection
BindIP = "127.0.0.1"
MySQLExecutable = "C:\Program Files\MariaDB 12.3\bin\mariadb.exe"
AllowLoggingIPAddressesInDatabase = 0

LoginDatabaseInfo = ".;3306;authserver;x;authserver"
CharacterDatabaseInfo = ".;3306;characters;x;characters"
WorldDatabaseInfo = ".;3306;worldserver;x;worldserver"

# Server
Updates.CleanDeadRefMaxCount = -1
FlashAtStart = 0
Server.LoginInfo = 1
Motd = "Welcome to your localhost server!"
AllowTickets = 0
CharDelete.Method = 1
CharDelete.KeepDays = 0
WhoList.Update.Interval = 300
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

"%SystemRoot%\System32\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" & "%SystemRoot%\System32\netsh.exe" advfirewall firewall add rule name="TrinityCore 3.3.5 localhost (authserver)" dir="out" action="block" profile="any" program="%UserProfile%\Projects\TrinityCore-335\build\bin\Release\authserver.exe" & "%SystemRoot%\System32\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" & "%SystemRoot%\System32\netsh.exe" advfirewall firewall add rule name="TrinityCore 3.3.5 localhost (worldserver)" dir="out" action="block" profile="any" program="%UserProfile%\Projects\TrinityCore-335\build\bin\Release\worldserver.exe"

Delete Rules

"%SystemRoot%\System32\netsh.exe" advfirewall firewall delete rule name="TrinityCore 3.3.5 localhost (authserver)" & "%SystemRoot%\System32\netsh.exe" advfirewall firewall delete rule name="TrinityCore 3.3.5 localhost (worldserver)"

Scripts

MKDIR "%UserProfile%\Projects\TrinityCore-335\scripts"
"%SystemRoot%\explorer.exe" "%UserProfile%\Projects\TrinityCore-335\scripts"

Server Start

  • Shutdown order: worldserverauthserver → MariaDB
"%SystemRoot%\System32\notepad.exe" "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-start.bat"
@echo off

TITLE TrinityCore 335 Launcher
CD "%Temp%"

START "MariaDB Server" /MIN "%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini"
"%SystemRoot%\System32\timeout.exe" /T "2" /NOBREAK

CD "%UserProfile%\Projects\TrinityCore-335\build\bin\Release"
START "WoW 3.3.5 [auth]" /MIN "%UserProfile%\Projects\TrinityCore-335\build\bin\Release\authserver.exe" --config-dir "%UserProfile%\Projects\TrinityCore-335\conf\authserver"
START "WoW 3.3.5 [world]" /MIN "%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

"%SystemRoot%\System32\notepad.exe" "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-update.bat"
@echo off

TITLE TrinityCore 335 Updater
CD "%Temp%"

"%ProgramFiles%\Git\bin\git.exe" -C "%UserProfile%\Projects\TrinityCore-335\src" reset --hard "origin/3.3.5"
"%ProgramFiles%\Git\bin\git.exe" -C "%UserProfile%\Projects\TrinityCore-335\src" pull origin "3.3.5" --rebase

:: Clang
SET "LLVMInstallDir=%ProgramFiles%\LLVM"
SET "LLVMToolsVersion=22"
"%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_90_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 12.3\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 12.3\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="0" -T "ClangCL" -DBoost_COMPILER="-vc143" -DCMAKE_CXX_FLAGS="/EHs /arch:AVX2 /favor:INTEL64 /Gz /Oy /GS- /guard:cf- /W0 -Wno-everything"

:: MSVC
::"%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_90_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 12.3\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 12.3\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="0" -DCMAKE_CXX_FLAGS="/EHs /arch:AVX2 /favor:INTEL64 /Gz /Oy /GS- /guard:cf- /W0"

"%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" -maxCpuCount -nodeReuse:"False" -terminalLogger:"off" -binaryLogger:"output.binlog;ProjectImports=None"

SET "LLVMInstallDir="
SET "LLVMToolsVersion="

"%SystemRoot%\System32\msg.exe" %USERNAME% /TIME:"2" "WoW 3.3.5 localhost server update complete"

:: End
"%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-update.bat"

Server Update (Full)

"%SystemRoot%\System32\notepad.exe" "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-update-full.bat"
@echo off

TITLE TrinityCore 335 Updater (Full)
CD "%Temp%"

"%ProgramFiles%\Git\bin\git.exe" -C "%UserProfile%\Projects\TrinityCore-335\src" reset --hard "origin/3.3.5"
"%ProgramFiles%\Git\bin\git.exe" -C "%UserProfile%\Projects\TrinityCore-335\src" pull origin "3.3.5" --rebase

"%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe" update --channelId "VisualStudio.17.Release" --channelURI "https://aka.ms/vs/17/release/channel" --productId "Microsoft.VisualStudio.Product.Community" --nocache --norestart --quiet

:: Clang
SET "LLVMInstallDir=%ProgramFiles%\LLVM"
SET "LLVMToolsVersion=22"
"%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_90_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 12.3\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 12.3\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="0" -T "ClangCL" -DBoost_COMPILER="-vc143" -DCMAKE_CXX_FLAGS="/EHs /arch:AVX2 /favor:INTEL64 /Gz /Oy /GS- /guard:cf- /W0 -Wno-everything"

:: MSVC
::"%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_90_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 12.3\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 12.3\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="0" -DCMAKE_CXX_FLAGS="/EHs /arch:AVX2 /favor:INTEL64 /Gz /Oy /GS- /guard:cf- /W0"

"%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" -maxCpuCount -nodeReuse:"False" -terminalLogger:"off" -binaryLogger:"output.binlog;ProjectImports=None"

SET "LLVMInstallDir="
SET "LLVMToolsVersion="

"%SystemRoot%\System32\msg.exe" %USERNAME% /TIME:"2" "WoW 3.3.5 localhost server update complete"

:: End
"%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-update-full.bat"

Database Back-up

"%SystemRoot%\System32\notepad.exe" "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-database-backup.bat"
@echo off

TITLE WoW 3.3.5 Database Back-up
CD "%Temp%"

START "MariaDB Server" /MIN "%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"
"%SystemRoot%\System32\timeout.exe" /T "2" /NOBREAK

"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --opt -r "%UserProfile%\Downloads\%RANDOM%-localhost-authserver.sql" "authserver"
"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --opt -r "%UserProfile%\Downloads\%RANDOM%-localhost-characters.sql" "characters"

"%ProgramFiles%\MariaDB 12.3\bin\mariadb-admin.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "shutdown"

"%SystemRoot%\System32\msg.exe" %USERNAME% /TIME:"2" "WoW 3.3.5 Databases Backed-up Successfully to Downloads"

:: End
"%UserProfile%\Projects\TrinityCore-335\scripts\localhost-database-backup.bat"

Database Maintenance

"%SystemRoot%\System32\notepad.exe" "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-database-maintenance.bat"
@echo off

TITLE WoW 3.3.5 Database Maintenance
CD "%Temp%"

START "MariaDB Server" /MIN "%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"
"%SystemRoot%\System32\timeout.exe" /T "2" /NOBREAK

"%ProgramFiles%\MariaDB 12.3\bin\mariadb-check.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --optimize --all-databases --force --extended --auto-repair

"%ProgramFiles%\MariaDB 12.3\bin\mariadb-admin.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "shutdown"

"%SystemRoot%\System32\msg.exe" %USERNAME% /TIME:"2" "WoW 3.3.5 Database Maintenance Complete"

:: End
"%UserProfile%\Projects\TrinityCore-335\scripts\localhost-database-maintenance.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" & "%SystemRoot%\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

Update (Full)

"%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-update-full.bat"
Server Updater (Rebuild)

Database Backup

"%UserProfile%\Projects\TrinityCore-335\scripts\localhost-database-backup.bat"
Database Back-up

Database Maintenance

"%UserProfile%\Projects\TrinityCore-335\scripts\localhost-database-maintenance.bat"
Database Maintenance

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 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini"
CD "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && "authserver.exe" --config-dir "%UserProfile%\Projects\TrinityCore-335\conf\authserver"

Create GM Account

  • Requires authserver running
  • Change x to password
CD "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && "worldserver.exe" --config-dir "%UserProfile%\Projects\TrinityCore-335\conf\worldserver"
account create Espionage724 x
account set password Espionage724 x x
account set gmlevel Espionage724 3 -1
server shutdown 1

Extras

Items

Northshire Gift Voucher

Tyrael's Hilt

.additem 39656

Character Data

Backup

"%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"
"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --opt -r "%UserProfile%\Downloads\localhost-authserver.sql" "authserver"
"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --opt -r "%UserProfile%\Downloads\localhost-characters.sql" "characters"

Restore

"%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"

authserver

"%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --execute="CREATE DATABASE authserver"
"%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "authserver" < x

characters

"%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --execute="CREATE DATABASE characters"
"%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "characters" < x

TODOs

"%ProgramFiles%\MariaDB 12.3\bin\mariadb-admin.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" variables
"%ProgramFiles%\MariaDB 12.3\bin\mariadb-admin.exe" -u "root" --socket="MySQL" variables
"%ProgramFiles%\MariaDB 12.3\bin\mariadb-admin.exe" -u "root" --socket="MySQL" variables  | FIND "socket"
character deleted old 1
3)
2026/03/03: Clang 00:04:36.64
4)
2025/12/13: 28 Minutes 26 Seconds at --threads 8
/usr/local/www/wiki/data/attic/servers/windows/games/trinitycore_3.3.5_localhost.1772569942.txt.gz · Last modified: by Sean Rhone