Hosting Behind A Router

From MangosWiki

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 3247 and 8085 for port forwarding. You do not need to use port forwarding if you are only playing on Lan.

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 3247 and 8085 are open.

Info completed. Zayfox 02:46, 5 July 2009 (UTC)