Welcome to My Guide on How to Add a Database and Hosting it!
[How To] Add a Database!
Ok Start up SQLyog,HediSQL,Navicat what ever one you prefer ,
Now Right Click Your Connection ex " Root@127.0.0.1 "
And Click Create Database or Click " Ctrl + D " To add a Database and Name it " Ascent "
Now Right click your Database " Ascent " *mine is ascent0 because i don't wanna start it all over :P * " Restore From SQL Dump "
Then Find your Databases SQL File and then click open
Next hit Execute and Wait Away
Congrats you Made a Ascent Database!
Now here is a [How To] Guide on " Hosting You're Server! "
Hamachi Guide
Step 1:: Download Hamachi
Hamachi - [Only registered and activated users can see links. ]
Step 2 :: Installing Hamachi
1. Ok when you have Hamachi downloaded, install it to your computer.
2. Then it should look like a grey window with three buttons at the bottom, which should be Power, Create or Join Networks and Configure Hamachi.
3. Click on power (if it's not on yet),then click on Create a new Network. Remember username and password are CaSe SeNsAtIVe.
4. When you made a network make friends connect to that network,and make friends change there realmlist.wtf to your hamachi IP address which should be on top of your hamachi window.
Example - set realmlist 5.163.218.240
Step 3 :: Configuring Ascent
1. Ok what you do is open your logonserver.conf
scroll down until you see this:
Code:
# Host Directive
#
# This is the address that the realmlist will listen on.
# To listen on all addresses, set it to 0.0.0.0
# Default: 127.0.0.1 (localhost)
#
# Note: ISHost is the interserver communication listener.
#
<Listen Host = "0.0.0.0" << all you have to do is change this
ISHost = "0.0.0.0" << and this to you hamachi IP address
RealmListPort = "3724"
ServerPort = "8093">
save and close.
2. Open up your logonserver.conf
Go down till you see this:
Code:
<LogonServer Address = "127.0.0.1" << Change this to your hamachi IP
Port = "8093"
Name = "Default Logon"
RealmCount = "1">
3. Scroll further down until you see:
Code:
<Realm1 Name = "test realm"
Address = "127.0.0.1:8129" << Change the 127.0.0.1 ONLY to your hamachi ip address
Icon = "PVP"
Colour = "1"
Population = "1.0"
TimeZone = "1">
save and close
4. Finally Open up your Ascent.Conf
Now look for something like this:
Code:
<Listen Host = "127.0.0.1"<<<Change this to your Hamachi IP Address
WorldServerPort = "8129"
Non-Hamachi Guide
Step 1.
1. Visit DynDNS.Com and Create an account.
2. Log in and click "Services" on the menu.
3. Under DNS Services there will be an option called Dynamic DNS. Click it.
4. Click on "Create Host."
5. Fill out the required fields, don't forget to check the box "Enable Wildcard."
6. Click "Add Host" and your done with this portion of the guide.
Step 2.
1. Open C:\Windows\System32\Drivers\Etc\
And Open " Hosts " With Notepad
2. Put this at the Bottom of the " Hosts " Thing
Code:
127.0.0.1 (Dynamic DNS)
Dynamic DNS = The DNS you just created at DynDNS.Com
Step 3.
1. Open your Realms.conf file in your server files folder.
2. Change at the bottom of your realms.conf to look like this.
3. Save and exit. You are now done with this part of the guide.
Step 4.
1. Connect to your router. This can normally be done by typing in 192.168.0.1. If your not sure what it is, then go to Start- Run- Type cmd- Type ipconfig. You should see the ip address like above, change the last sequence in it to a 1 and it should work. If you are still having issues consult your routers website on how to login to your router.
2. Now, It's time to forward the ports. Go into your port forwarding section under your router and forward;
3. If you have a Firewall disable it if you don't know how to set exceptions with it.
Step 5.
>This next part is for how you connect.<
1. Go into your World of Warcraft game directory.
2. Open realmlist.WTF in Notepad.
3. Replace everything in it with "set realmlist 127.0.0.1"
Note: I suggest you make a copy of the realmlist before changing the info so you can still connect to the Live WoW servers.
Step 6.
>Getting a friend to connect.<
1. Follow the above steps, except when in realmlist. WTF have them change it to "set realmlist (Dynamic DNS)"
If everything is done correctly you should have a public server with out Hamachi, and you and your friends can have all the fun you want. If you are confused or need help please feel free to post your confusion. Also, Please let us know how well this tutorial works out for you, so we can improve it.
------------------------------------------------------------------
Credits Go to Me for " Adding a Database "
Credits To JulianX for " Hosting You're Server"-
( I was to Lazy and tired to type it :P )
------------------------------------------------------------------
You speak of justice? Of cowardice? I will show you the justice of the grave and the true meaning of fear.
[How To] Add a Database + Hosting You're Server[Pictures]
cant wait for you repack :P +rep 
