Differences

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

--- servers:windows:games:mangos_one_tbc_localhost [2025/10/08 17:30] – Sean Rhone
+++ servers:windows:games:mangos_one_tbc_localhost [2025/10/08 18:04] (current) – [TODOs] Sean Rhone
@@ Line 5: / Line 5: @@
   * :!: 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 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 628: / Line 622: @@
 ===== Block =====
-  * Only ''localhost'' allowed
+  * Only ''localhost'' client connections allowed
   "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"
@@ Line 720: / 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 728: / 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 750: / 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 758: / 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 792: / 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 813: / 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 823: / 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 853: / 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