How to get your private server Public(the way i help someone)

[aznboy]

Hello my name is Aznboy and this fourm will teach you how to make your very own private server. I know that there is alot of guide that is out right now and i have been using some of them but some of them didnt really work. So i decided to make my own guide that helped me to make my very own server to work.
Dont forget to check out my other fourm:
A way for you to get your website for your server host free
How To make a private server

Requirement
(For Installer first)
Mysql
Mysqldump
World Installer
Character Installer
(Database)
Mysql
Ad.exe(for map)
Winrar
Any Repack also any Database loader and Complie(Ascent w/e)

Guide
1) Download Winrar and Mysql with Ad.exe
2) Make sure that you have the Repack and the Database loader in.
3) After this download the Installer with the two Mysql.
4) Install the Mysql.(Not going to go in detail sorry.)
5) Install the Database loader.
How to Log into Heldisql or Navicat or Sysql:

Host name: 127.0.0.1
Username: Root
Password: Whatever you put into the Mysql
Done and connect

Setting up your installer
This is how you will have to set your up to look like:

set user=root
set pass=password goes here
set wdb=Your Database (world)	
set cdb=Your Database (Character)

And after you do this. Mkae a new folder name it whatever you want. Drag the two installer in there. Create a new folder and name it Database. And get a mysql and mysqldump. And drop that in the Databse. And now drag your sql file into the database also. And when you do name the World databse to World.sql And character will be Character.sql and you will all be set and ready to go. Go into world Installer and push w to install the world. Go to character and push c to install the Character.If you want me to. I will be gladly to make you any installer like donation or any other type.

Setting up account:
Go into Heldisql or your loading database area. Go into account. Creat a new one and the first block will say login. Don't add any in there. That is for you account number. Go to the second one and Type in your username. Third type in your password. Fourth Type az for admin a for GM and vp for vip and 0 for normal. Now go to the second to last box and enter 8 to enable TBC.

Setting up your Ascent conf.

Logon.conf

<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "***"
Name = "Accounts"
Port = "3306"
Type = "1">

Ascent.conf

<WorldDatabase Hostname = "localhost" Username = "root" Password = "***" Name = "Ascent" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "***" Name = "Accounts" Port = "3306" Type = "1">

Making your server public
Make and account at DynDNS.com
Choose a Dyndns host and Add a host:

Your Server ip name (space) blah.com (anything)
Wildcard enable
IP host
Click the blue one for you ip automatic 
Done click okay

Now run:
C:\WINDOWS\system32\drivers\etc\hosts
Then you will see something like this:

# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
#      102.54.94.97     rhino.acme.com          # source server
#       38.25.63.10     x.acme.com              # x client host

127.0.0.1 Serverhost IP
[Internal IP] Serverhost IP
[External IP] Serverhost IP

Now you do the ports:
If you dont know how look at portforward.com and they will teach you but you will have to open these ports:

3724 - 3724
80 - 80
3306 - 3306
8129 - 8129
8093 -8093
6112 - 6112
6881-6999
3036 - 3036
8050 -8050

After this go into your realm.conf

Also there is one on the top where it will say 127.0.0.1
Change that into your realm ip from dyndns.com

<Realm1 Name = "picoswowserver"
Address = "127.0.0.1:8129"
Icon = "PVP"
Colour = "1"
Population = "0"
TimeZone = "1">

Change that into you IP from dyndns.com

Now go to your realmlist.wtf and change it to your dyndns.com host

How to make a restarter: (Credit:Ballwinkle To give him +rep)
Download:
Uploading now

Logon:

@ECHO OFF
CLS
ECHO Server Started %time:~0,5% %date:~1%
:SERVERLOOP
cd WS
logonserver.exe
ECHO Server Restarted %time:~0,5% %date:~1%
ECHO.
GOTO SERVERLOOP
:END

Ascent:

@ECHO OFF
CLS
ECHO Server Started %time:~0,5% %date:~1%
:SERVERLOOP
cd WS
ascent.exe
ECHO Server Restarted %time:~0,5% %date:~1%
ECHO.
GOTO SERVERLOOP
:END

Save them in notepad and put save as.
Logon.bat and go to bottom and save them as all file. Same go for ascent but the name is going to be ascent.bat
And you have you account now Enjoy.

[tripleblade3]

Great Post, even though my server is already public, i had a lot of trouble finding out how to do it and your guide is pretty much perfect.

[aznboy]

Hehe thanks... +Rep for being my first post and reader ^_^

[aznboy]

So this didnt help anyone get their server public?? If you have anything wrong just post it here and i will try to help you

[Saedusii]

Already have my server up, but this is a good, simple guide to setting up your server and getting a launcher up and running.

Edit: Added reputation to you.

[aznboy]

Thanks.. +Rep back and one more rep til you become a non leacher anymore

[Saedusii]

Oh, hehe, thanks.

Being a lazy leeching lowbie isn't very fun.

[aznboy]

Updated on how to make a private server. Tell me if i miss anything up there

[Saedusii]

Hmmm... You should put in some info on accounts (GM accounts: az, a, etc.), include an Ascent Restarter program, and tell them to run Ascent.exe/Logonserver.exe.

PS: Nice update.

[aznboy]

Edit it to where to make account and also a restarter

[Saedusii]

Nice, and I am out of the Lazy Leeching Lowbie group now.

[aznboy]

Congratz fellow happy your not a leacher anymore ?

[Darkfighter]

It is much more easy with hamachi

[aznboy]

Yeah well this is to make a private server public without hamachi and if your a noob at making it public then go to hamachi which is easier

[Varanes]

hehe nice guide

GOD +rep YOU!