Differences

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

--- servers:windows:games:mangos_one_tbc_localhost [2025/10/08 17:01] – Sean Rhone
+++ servers:windows:games:mangos_one_tbc_localhost [2025/10/08 18:04] (current) – [TODOs] Sean Rhone
@@ Line 4: / Line 4: @@
   * MaNGOS One ((https://github.com/mangosone))
-  * :!: 2025/10/08: WIP
+  * :!: 2025/10/08: WIP ((everything up to [[#scripts|Scripts]] is good-to-go))
-===== TODOs =====
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"
-  CLS && SET "OPENSSL_MODULES=%ProgramFiles%\OpenSSL-Win64\bin" && CD "%UserProfile%\Projects\MaNGOS-One-TBC\server" && "%UserProfile%\Projects\MaNGOS-One-TBC\server\realmd.exe" -c "%UserProfile%\Projects\MaNGOS-One-TBC\conf\realmd-localhost.conf"
-  CLS && SET "OPENSSL_MODULES=%ProgramFiles%\OpenSSL-Win64\bin" && CD "%UserProfile%\Projects\MaNGOS-One-TBC\server" && "%UserProfile%\Projects\MaNGOS-One-TBC\server\mangosd.exe" -c "%UserProfile%\Projects\MaNGOS-One-TBC\conf\mangosd-localhost.conf"
 ===== Prerequisites =====
@@ Line 33: / Line 25: @@
   * Desktop development with C++ (C++ core desktop features)
   * MSVC v143 - VS 2022 C++ x64/x86 build tools (Latest)
-  * Windows 11 SDK (10.0.26100.4654+)
+  * Windows 11 SDK (10.0.26100.4654)
   "%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe"
@@ Line 177: / Line 169: @@
 ==== Initial Updates ====
+  * https://github.com/mangosone/database/commits/master/World/Updates
   * https://github.com/mangosone/database/tree/master/World/Updates/Rel22
@@ Line 191: / Line 184: @@
 ====== Settings ======
-  * Conf URLs need updating to MaNGOS
+  * [[#default_conf_refs|Default conf references]]
+  * TODO: Conf URLs need updating to MaNGOS
 ===== realmd=====
@@ Line 395: / Line 389: @@
 PetUnsummonAtMount = 0
 Event.Announce = 0
-BeepAtStart = 0
+BeepAtStart = 1
 ShowProgressBars = 1
 WaitAtStartupError = 0
@@ Line 465: / Line 459: @@
 GM.TicketListSize = 30
 GM.TicketOfflineClosing  = 1
-GM.Chat = 1
+GM.Chat = 0
 GM.WhisperingTo = 1
 GM.InGMList.Level = 3
@@ Line 626: / Line 620: @@
 ====== Firewall ======
-===== LAN =====
+===== Block =====
-  "netsh.exe" advfirewall firewall add rule name="MaNGOS One localhost (realmd)" dir="in" action="allow" profile="any" program="%UserProfile%\Projects\MaNGOS-One-TBC\server\realmd.exe" protocol="tcp" localport="3724" remoteip="localsubnet"
+  * Only ''localhost'' client connections allowed
-  "netsh.exe" advfirewall firewall add rule name="MaNGOS One localhost (mangosd)" dir="in" action="allow" profile="any" program="%UserProfile%\Projects\MaNGOS-One-TBC\server\mangosd.exe" protocol="tcp" localport="8085" remoteip="localsubnet"
+  "netsh.exe" advfirewall firewall add rule name="MaNGOS One localhost (realmd)" dir="in" action="block" profile="any" program="%UserProfile%\Projects\MaNGOS-One-TBC\server\realmd.exe" protocol="tcp" localport="3724" & "netsh.exe" advfirewall firewall add rule name="MaNGOS One localhost (mangosd)" dir="in" action="block" profile="any" program="%UserProfile%\Projects\MaNGOS-One-TBC\server\mangosd.exe" protocol="tcp" localport="8085"
-==== Delete Rules ====
+===== Delete Rules =====
 ****
@@ Line 638: / Line 632: @@
   "netsh.exe" advfirewall firewall delete rule name="MaNGOS One localhost (realmd)" & "netsh.exe" advfirewall firewall delete rule name="MaNGOS One localhost (mangosd)"
-===== Block =====
+===== Allow LAN =====
 ****
-  "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="MaNGOS One localhost (realmd)" dir="in" action="allow" profile="any" program="%UserProfile%\Projects\MaNGOS-One-TBC\server\realmd.exe" protocol="tcp" localport="3724" remoteip="localsubnet" & "netsh.exe" advfirewall firewall add rule name="MaNGOS One localhost (mangosd)" dir="in" action="allow" profile="any" program="%UserProfile%\Projects\MaNGOS-One-TBC\server\mangosd.exe" protocol="tcp" localport="8085" remoteip="localsubnet"
-===== 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)"
 ====== Scripts ======
@@ Line 654: / Line 642: @@
 ===== Server Start =====
-  * Shutdown order: ''worldserver'' -> ''authserver'' -> MariaDB
+  * Shutdown order: ''mangosd'' -> ''realmd'' -> MariaDB
-  MKDIR "%UserProfile%\Projects\TrinityCore-335\scripts" & "notepad.exe" "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-start.bat"
+  MKDIR "%UserProfile%\Projects\MaNGOS-One-TBC\scripts" & "notepad.exe" "%UserProfile%\Projects\MaNGOS-One-TBC\scripts\localhost-server-start.bat"
 <code>
 @echo off
-TITLE TrinityCore 335 Launcher
+TITLE MaNGOS One Launcher
 START "MariaDB Server" "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"
 TIMEOUT /T "2" /NOBREAK
-CD "%UserProfile%\Projects\TrinityCore-335\build\bin\Release"
+SET "OPENSSL_MODULES=%ProgramFiles%\OpenSSL-Win64\bin"
-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"
+CD "%UserProfile%\Projects\MaNGOS-One-TBC\server"
+START "WoW 2.4.3 [realmd]" "%UserProfile%\Projects\MaNGOS-One-TBC\server\realmd.exe" -c "%UserProfile%\Projects\MaNGOS-One-TBC\conf\realmd-localhost.conf"
+START "WoW 2.4.3 [mangosd]" "%UserProfile%\Projects\MaNGOS-One-TBC\server\mangosd.exe" -c "%UserProfile%\Projects\MaNGOS-One-TBC\conf\mangosd-localhost.conf"
 :: End</code>
-  "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-start.bat"
+  "%UserProfile%\Projects\MaNGOS-One-TBC\scripts\localhost-server-start.bat"
 ===== Server Update =====
@@ Line 724: / Line 714: @@
 ==== Server Start ====
-  "%UserProfile%\Projects\TrinityCore-335\scripts\localhost-server-start.bat"
+  "%UserProfile%\Projects\MaNGOS-One-TBC\scripts\localhost-server-start.bat"
-  WoW 3.3.5 Server
+  WoW 2.4.3 Server
 ===== Start Menu =====
@@ Line 732: / Line 722: @@
 ****
-  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"
+  MKDIR "%AppData%\Microsoft\Windows\Start Menu\Programs\World of Warcraft 2.4.3" & "explorer.exe" "%AppData%\Microsoft\Windows\Start Menu\Programs\World of Warcraft 2.4.3"
 ==== Server Start ====
@@ Line 754: / Line 744: @@
 ==== Install Notes ====
-  "https://wiki.realmofespionage.xyz/servers;windows;games;trinitycore_3.3.5_localhost"
+  "https://wiki.realmofespionage.xyz/servers;windows;games;mangos_one_tbc_localhost"
   Install Notes (Server)
@@ Line 762: / Line 752: @@
 ===== Servers =====
-  * TODO: Needs ''libcrypto-3-x64.dll'' and ''libmariadb.dll''
+  * 3 Command Prompt windows
   "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"
-  SET "OPENSSL_MODULES=%ProgramFiles%\OpenSSL-Win64\bin"
+  CLS && SET "OPENSSL_MODULES=%ProgramFiles%\OpenSSL-Win64\bin" && CD "%UserProfile%\Projects\MaNGOS-One-TBC\server" && "%UserProfile%\Projects\MaNGOS-One-TBC\server\realmd.exe" -c "%UserProfile%\Projects\MaNGOS-One-TBC\conf\realmd-localhost.conf"
-  CD "%UserProfile%\Projects\MaNGOS-One-TBC\server" && "%UserProfile%\Projects\MaNGOS-One-TBC\build\src\realmd\Release\realmd.exe" -c "%UserProfile%\Projects\MaNGOS-One-TBC\conf\realmd-localhost.conf"
+  CLS && SET "OPENSSL_MODULES=%ProgramFiles%\OpenSSL-Win64\bin" && CD "%UserProfile%\Projects\MaNGOS-One-TBC\server" && "%UserProfile%\Projects\MaNGOS-One-TBC\server\mangosd.exe" -c "%UserProfile%\Projects\MaNGOS-One-TBC\conf\mangosd-localhost.conf"
-  CD "%UserProfile%\Projects\MaNGOS-One-TBC\server" && "%UserProfile%\Projects\MaNGOS-One-TBC\build\src\mangosd\Release\mangosd.exe" -c "%UserProfile%\Projects\MaNGOS-One-TBC\conf\mangosd-localhost.conf"
 ===== Create Account =====
   * https://www.getmangos.eu/wiki/referenceinfo/otherfiles/mangos-default-accounts-r40006/
-  * https://github.com/cmangos/issues/wiki/Installation-Instructions#creating-first-account
+  * Run in ''mangosd'' console window
   * :!: Change ''x'' to password ((can be a single character for easy log-in))
-  * ''1'' at the end of ''account create'' = TBC ([[https://github.com/cmangos/issues/wiki/Installation-Instructions#enabling-expansions-for-a-user|info]])
   account create Espionage724 x 1
@@ Line 796: / Line 784: @@
   * https://www.getmangos.eu/wiki/referenceinfo/dbinfo/realmdb/realmlist-r13/
+  * Only ''localhost'' client connections allowed
   "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p --execute="INSERT INTO `realmd`.`realmlist` (`id`, `name`, `icon`, `timezone`, `realmbuilds`) VALUES ('1', 'localhost', '6', '8', '8086');"
@@ Line 817: / Line 806: @@
   "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"
-  CD "%UserProfile%\Downloads" && "%ProgramFiles%\MariaDB 12.1\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-authserver.sql" "authserver"
+  CD "%UserProfile%\Downloads" && "%ProgramFiles%\MariaDB 12.1\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-realmd.sql" "realmd"
-  CD "%UserProfile%\Downloads" && "%ProgramFiles%\MariaDB 12.1\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-characters.sql" "characters"
+  CD "%UserProfile%\Downloads" && "%ProgramFiles%\MariaDB 12.1\bin\mariadb-dump.exe" -u "root" -p --opt -r "localhost-character1.sql" "character1"
 ===== Restore =====
@@ Line 827: / Line 816: @@
   "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"
-==== authserver ====
+==== realmd ====
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE authserver"
+  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE realmd"
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p "authserver" < "%UserProfile%\Downloads\localhost-authserver.sql"
+  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p "realmd" < "%UserProfile%\Downloads\localhost-realmd.sql"
-==== characters ====
+==== character1 ====
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE characters"
+  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE character1"
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p "characters" < "%UserProfile%\Downloads\localhost-characters.sql"
+  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p "character1" < "%UserProfile%\Downloads\localhost-character1.sql"
 ====== Quick Commands ======
@@ Line 857: / Line 846: @@
   * :?: "Rabbit Day" ([[https://www.getmangos.eu/forums/topic/11121-what-is-rabbit-day/|post]])
   * 2025/10/08: Sometimes first-login from client is an instant-disconnect ((not game/realm type, not loopback/127.0.0.1))
+  * Figure out if Eluna LUA scripts provide scripts to expand/fix existing content (like ScriptDev), or only for custom/new scripts