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:
Code:
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
Code:
<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "***"
Name = "Accounts"
Port = "3306"
Type = "1">
Ascent.conf
Code:
<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:
Code:
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:
Code:
# 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:
Code:
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
Code:
<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
@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
@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.