Both sides previous revisionPrevious revisionNext revision | Previous revision |
servers:windows:games:trinitycore_3.3.5_localhost [2025/06/15 03:55] – Sean Rhone | servers:windows:games:trinitycore_3.3.5_localhost [2025/06/28 00:04] (current) – [TDB] Sean Rhone |
---|
| |
* TrinityCore ((https://www.trinitycore.org)) | * TrinityCore ((https://www.trinitycore.org)) |
| * [[https://talk.trinitycore.org/t/singleplayer-scripts-and-desktop-start-launchers-on-windows-linux-freebsd/33293|TrinityCore Forums]] |
* These notes provide a local single-player server for World of Warcraft 3.3.5 | |
| |
===== Media ===== | ===== Media ===== |
===== Prerequisites ===== | ===== Prerequisites ===== |
| |
* [[windows;11_ltsc|Windows 11 (24H2)]] | * [[windows;10|Windows 10 (21H2)]] |
* [[programs;windows;git|Git]] | * [[programs;windows;git|Git]] |
* [[servers;windows;mariadb|MariaDB]] (Dev components required; no service/networking) | * [[servers;windows;mariadb|MariaDB]] (Dev components required; no service/networking) |
* [[games;windows;world_of_warcraft_3.3.5|World of Warcraft 3.3.5]] | * [[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 ====== | ====== Dependencies ====== |
* Windows 11 SDK (10.0.26100.3916) | * Windows 11 SDK (10.0.26100.3916) |
| |
"%PROGRAMFILES(X86)%\Microsoft Visual Studio\Installer\setup.exe" | "%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe" |
| |
===== Boost ===== | ===== Boost ===== |
| |
* https://cmake.org/download/ | * https://cmake.org/download/ |
* Last tested: ''cmake-4.0.3-windows-x86_64.msi'' | * Last tested: ''cmake-4.1.0-rc1-windows-x86_64.msi'' |
| |
* ''[ ]'' Add CMake to the PATH environment variable | * ''[ ]'' Add CMake to the PATH environment variable |
* https://github.com/TrinityCore/TrinityCore/commits/3.3.5 | * 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" | "%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 ====== | ====== Databases ====== |
===== Connect ===== | ===== Connect ===== |
| |
"%PROGRAMFILES%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%PROGRAMFILES%\MariaDB 12.0\data\my.ini" | "%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini" |
| |
"%PROGRAMFILES%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p | "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p |
| |
===== Databases ===== | ===== Databases ===== |
**** | **** |
| |
<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 12.0\include\mysql" -DMYSQL_LIBRARY="%PROGRAMFILES%\MariaDB 12.0\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 12.0\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 12.0\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="1"</code> |
| |
===== Compile ===== | ===== Compile ===== |
| |
**** | * 8 minutes i5-8400H |
| |
<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> | <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 ===== | ===== DLLs ===== |
| |
COPY /Y "%PROGRAMFILES%\MariaDB 12.0\lib\libmariadb.dll" "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release" | COPY /Y "%ProgramFiles%\MariaDB 12.0\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\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\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" | COPY /Y "%ProgramFiles%\OpenSSL-Win64\bin\libcrypto-3-x64.dll" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" |
| |
====== Content ====== | ====== Content ====== |
===== DBCs, Maps, and Cameras ===== | ===== DBCs, Maps, and Cameras ===== |
| |
COPY /Y "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\mapextractor.exe" "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5" | 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" | CD "%ProgramFiles(x86)%\World of Warcraft 3.3.5" && "%ProgramFiles(x86)%\World of Warcraft 3.3.5\mapextractor.exe" -f "0" |
| |
===== VMaps ===== | ===== VMaps ===== |
==== Extract ==== | ==== Extract ==== |
| |
COPY /Y "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\vmap4extractor.exe" "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5" | 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 | CD "%ProgramFiles(x86)%\World of Warcraft 3.3.5" && "%ProgramFiles(x86)%\World of Warcraft 3.3.5\vmap4extractor.exe" -l |
| |
==== Assemble ==== | ==== Assemble ==== |
| |
COPY /Y "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\vmap4assembler.exe" "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5" | 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" | CD "%ProgramFiles(x86)%\World of Warcraft 3.3.5" && "%ProgramFiles(x86)%\World of Warcraft 3.3.5\vmap4assembler.exe" "Buildings" "vmaps" |
| |
===== MMaps ===== | ===== MMaps ===== |
| |
* :!: Takes a while ((30-40 minutes i5-8400H, 2 hours i7-740QM)) | * :!: 30-40 minutes i5-8400H |
* Requires [[#assemble|assembled VMaps]] | * Requires [[#assemble|assembled VMaps]] |
* ''--threads 8'' | * ''--threads 8'' |
| |
COPY /Y "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release\mmaps_generator.exe" "%PROGRAMFILES(X86)%\World of Warcraft 3.3.5" | 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 "8" | CD "%ProgramFiles(x86)%\World of Warcraft 3.3.5" && "%ProgramFiles(x86)%\World of Warcraft 3.3.5\mmaps_generator.exe" --bigBaseUnit "true" --threads "8" |
| |
===== Move Files ===== | ===== Move Files ===== |
* Last tested: ''TDB_full_world_335.24111_2024_11_22.7z'' | * 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" | 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 ====== | ====== Settings ====== |
* [[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]]) | * [[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" | 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" | MKDIR "%UserProfile%\Projects\TrinityCore-335\conf\authserver" |
| |
"notepad.exe" "%USERPROFILE%\Projects\TrinityCore-335\conf\authserver\localhost.conf" | "notepad.exe" "%UserProfile%\Projects\TrinityCore-335\conf\authserver\localhost.conf" |
| |
<code> | <code> |
* [[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]]) | * [[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" | 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" | MKDIR "%UserProfile%\Projects\TrinityCore-335\conf\worldserver" |
| |
"notepad.exe" "%USERPROFILE%\Projects\TrinityCore-335\conf\worldserver\localhost.conf" | "notepad.exe" "%UserProfile%\Projects\TrinityCore-335\conf\worldserver\localhost.conf" |
| |
<code> | <code> |
===== Block ===== | ===== 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 (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="TrinityCore 3.3.5 localhost (worldserver)" dir="in" action="block" profile="any" program="%UserProfile%\Projects\TrinityCore-335\build\bin\Release\worldserver.exe" |
| |
===== Delete Rules ===== | ===== Delete Rules ===== |
**** | **** |
| |
MKDIR "%USERPROFILE%\Projects\TrinityCore-335\scripts" | MKDIR "%UserProfile%\Projects\TrinityCore-335\scripts" |
| |
===== Server Start ===== | ===== Server Start ===== |
| |
"notepad.exe" "%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-server-start.bat" | "notepad.exe" "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-start.bat" |
| |
<code> | <code> |
@echo off | @echo off |
| |
START "MariaDB Server" "%PROGRAMFILES%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%PROGRAMFILES%\MariaDB 12.0\data\my.ini" | START "MariaDB Server" "%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini" |
TIMEOUT /T "3" /NOBREAK | TIMEOUT /T "2" /NOBREAK |
| |
CD "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release" | 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 [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" | 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> | :: End</code> |
| |
"%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-server-start.bat" | "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-start.bat" |
| |
===== Server Update ===== | ===== Server Update ===== |
| |
"notepad.exe" "%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-server-update.bat" | "notepad.exe" "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-update.bat" |
| |
<code> | <code> |
@echo off | @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%\Git\bin\git.exe" -C "%USERPROFILE%\Projects\TrinityCore-335\src" reset --hard | "%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 12.0\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 12.0\lib\libmariadb.lib" -DWITHOUT_METRICS="1" -DTOOLS="1" |
"%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 12.0\include\mysql" -DMYSQL_LIBRARY="%PROGRAMFILES%\MariaDB 12.0\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" |
| |
"%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> | :: End</code> |
| |
"%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-server-update.bat" | "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-update.bat" |
| |
===== Database Back-up ===== | ===== Database Back-up ===== |
| |
"notepad.exe" "%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-database-backup.bat" | "notepad.exe" "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-database-backup.bat" |
| |
<code> | <code> |
@echo off | @echo off |
| |
TITLE WoW 3.3.5 localhost Save Back-up | START "MariaDB Server" "%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini" |
| TIMEOUT /T "2" /NOBREAK |
| |
START "MariaDB Server" "%PROGRAMFILES%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%PROGRAMFILES%\MariaDB 12.0\data\my.ini" | CD "%UserProfile%\Downloads" |
TIMEOUT /T "3" /NOBREAK | |
| |
CD "%USERPROFILE%\Downloads" | |
| |
ECHO Root MariaDB user password prompts: | ECHO Root MariaDB user password prompts: |
"%PROGRAMFILES%\MariaDB 12.0\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-authserver.sql" "authserver" | "%ProgramFiles%\MariaDB 12.0\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-authserver.sql" "authserver" |
"%PROGRAMFILES%\MariaDB 12.0\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-characters.sql" "characters" | "%ProgramFiles%\MariaDB 12.0\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-characters.sql" "characters" |
| |
:: End</code> | :: End</code> |
| |
"%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-database-backup.bat" | "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-database-backup.bat" |
| |
====== Launcher Shortcuts ====== | ====== Launcher Shortcuts ====== |
==== Server Start ==== | ==== Server Start ==== |
| |
"%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-server-start.bat" | "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-start.bat" |
| |
WoW 3.3.5 Server | WoW 3.3.5 Server |
==== Server Start ==== | ==== Server Start ==== |
| |
"%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-server-start.bat" | "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-start.bat" |
| |
Server Start | Server Start |
==== Update ==== | ==== Update ==== |
| |
"%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-server-update.bat" | "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-update.bat" |
| |
Server Updater | Server Updater |
==== Database Backup ==== | ==== Database Backup ==== |
| |
"%USERPROFILE%\Projects\TrinityCore-335\scripts\localhost-database-backup.bat" | "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-database-backup.bat" |
| |
Database Back-up | Database Back-up |
* Ctrl + C to exit | * Ctrl + C to exit |
| |
"%PROGRAMFILES%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%PROGRAMFILES%\MariaDB 12.0\data\my.ini" | "%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini" |
| |
CD "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release" && "authserver.exe" --config-dir "%USERPROFILE%\Projects\TrinityCore-335\conf\authserver" | CD "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && "authserver.exe" --config-dir "%UserProfile%\Projects\TrinityCore-335\conf\authserver" |
| |
===== Create GM Account ===== | ===== Create GM Account ===== |
* Change ''x'' to password | * Change ''x'' to password |
| |
CD "%USERPROFILE%\Projects\TrinityCore-335\build\bin\Release" && "worldserver.exe" --config-dir "%USERPROFILE%\Projects\TrinityCore-335\conf\worldserver" | CD "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && "worldserver.exe" --config-dir "%UserProfile%\Projects\TrinityCore-335\conf\worldserver" |
| |
account create Espionage724 x | account create Espionage724 x |
server shutdown 1 | server shutdown 1 |
| |
====== GM ====== | ====== Extras ====== |
| |
* Northshire Gift Voucher | ===== Items ===== |
| |
| * Northshire Gift Voucher (Diablo Stone) |
| |
.additem 14646 | .additem 14646 |
| |
| * Tyrael's Hilt |
| |
| .additem 39656 |
| |
====== Character Data ====== | ====== Character Data ====== |
===== Backup ===== | ===== Backup ===== |
| |
"%PROGRAMFILES%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%PROGRAMFILES%\MariaDB 12.0\data\my.ini" | "%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini" |
| |
CD "%USERPROFILE%\Downloads" && "%PROGRAMFILES%\MariaDB 12.0\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-authserver.sql" "authserver" | CD "%UserProfile%\Downloads" && "%ProgramFiles%\MariaDB 12.0\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-authserver.sql" "authserver" |
| |
CD "%USERPROFILE%\Downloads" && "%PROGRAMFILES%\MariaDB 12.0\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-characters.sql" "characters" | CD "%UserProfile%\Downloads" && "%ProgramFiles%\MariaDB 12.0\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-characters.sql" "characters" |
| |
===== Restore ===== | ===== Restore ===== |
* [[#databases|Initial set-up]] | * [[#databases|Initial set-up]] |
| |
"%PROGRAMFILES%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%PROGRAMFILES%\MariaDB 12.0\data\my.ini" | "%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini" |
| |
==== authserver ==== | ==== authserver ==== |
| |
"%PROGRAMFILES%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE authserver" | "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE authserver" |
| |
"%PROGRAMFILES%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p "authserver" < "%USERPROFILE%\Downloads\localhost-authserver.sql" | "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p "authserver" < "%UserProfile%\Downloads\localhost-authserver.sql" |
| |
==== characters ==== | ==== characters ==== |
| |
"%PROGRAMFILES%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE characters" | "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE characters" |
| |
"%PROGRAMFILES%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p "characters" < "%USERPROFILE%\Downloads\localhost-characters.sql" | "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p "characters" < "%UserProfile%\Downloads\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 12.0\include\mysql" -DMYSQL_LIBRARY="%PROGRAMFILES%\MariaDB 12.0\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 | |
| |