Hosting Behind A Router
1. Access your MySQL database
2. Open your "realmd" database
3. Access the "realmlist" table
Edit the serverlist to have 2 servernames, one with your routers IP address and the other one with your LAN address
ID Name Address Port Icon Color Timezone
1 W*W1 Public IP (Router) 8085 1 1 1
2 W*W2 Local IP (LAN) 8085 1 1 1
Every pc located IN your lan changes his realmlist.wtf file to the servers LAN address (for example 10.0.0.2)
Every pc located OUTSIDE your lan changes his realmlist.wtf file to the servers ROUTER IP address (for example 66.82.93.34)
Open the game client using "wow.exe", not "launcher.exe" since this little launcher likes to "fix" the clients realmlist.wtf file.
This should show "WoW1" offline only to Local computers and they can connect only to WoW2.
Internet users see WoW2 as offline and they can connect only to WoW1
Even though you set up 2 "realms" with different names, they still point to the same realm. Its so people on Lan can connect, and people outside your Lan can connect.
In the sql tbl realmd->realmlist.address set that to 192.168.0.1
Default ports are 3724 and 8085 for port forwarding. You do not need to use port forwarding if you are only playing on Lan.
Note: This has been tested, and seems to no longer work, having the two realms in the realmlist pointing to one server, one will always show offline (Only allowing either people in LAN or people externally to join depending on which one is first).
To get around this, use something like dyndns(example: test.homeip.net) and update it to the routers IP and make all the LAN computers point "test.homeip.net" to the servers LAN ip (e.g 192.168.0.2). Change the database realmlist to test.homeip.net (Or whatever you called it).
What Is My IP?
Internal IP
1. Press Windows + R (Or go to Start > Run)
2. Type "cmd" (Without quotes)
3. In the command prompt that appears, type "ipconfig" (Again, without quotes)
4. Look for the line that says "IP Address. . . . . . . . . . . . :<Here is your IP Address>
5. Note that down and give it to the people inside your LAN.
External IP
1. Open your web browser.
2. Navigate here
3. Note down the IP that appears on the screen.
4. Check to make sure ports 3724 and 8085 are open.
i hope you enjoyed my guide and hope it helped out . if anyone has anything to add please feel free to do so.....thank you and i await to here from you all :wave: