[ASCENT-GUIDE] How to make a Server

[1337Equillbrium]

Note; please read the whole guide and specialy
the edit at the botom before you start downloading
and installing, also note that this guide is only for
windows users and wow version 2.3.x!

This is just a simple guide on how to setup a ascent private server, what we will be using today is MySQL to host our database in and a simple repack by Mafiaboy from wowps. It is very important that you download the files you do not already have from under the "Download" tab, if you do don't you will not be able to complete this install.





Download Winrar
Download SQLyog
Download MySQL
Download Repack
Download Norwegian Elite Database





MySQL
Now we are going to install MySQL, extract the MySQL.rar on to your desktop or some place else you think its better, double click "mysql-essential 5.0.51" click "go" on the popup then click Next> make sure Complete is marked then click Next> then click Install. When the installation is done click Next> Next> make sure "Configure the MySQL Server now" is marked then click Finish. Now there should pop up a new window, click Next> make sure "Standard Configuration" is marked then click Next> make sure "Install As Windows Service" is marked then rename Service Name from MySQL to root and make sure "Launch the MySQL Server automatically" is marked then click Next> Now make sure you have "Modify Security Settings" marked then chose a password for yourself and you have to remember that password because you will need it later, if you are planning to log into your database from several computers then make sure to mark "Enable root access from remote machines" if you do not plan to access your database from other computers then it would be safest to leave it off to prevent hacking and such. Now click Next> then click Execute when it's done click Finish. You have now installed MySQL successfully!

SQLyog
[LEFT]Now we are going to install SQLyog which is a administration tool for MySQL so that you can modify and access your database more easily. Extract the SQLyog.rar to your desktop or any other place you find it handy, double click SQLyog616 and press ok on any popup, now click Next> mark "I agree" and click Next> I only mark "Desktop Shortcut" but you can do as you want, click Next> you can chose a different path than the default one but i recommend installing it in C:\Program Files\SQLyog Community which usually is default, now click Install when it's done click Next> then mark "Run SQLyog Community 6.16 and click Finish, now click "Continue..." click on "New" in the top left corner and write in any name you want write localhost in the host address, write root in the Username tab, write the password you chose when you installed MySQL in the Password tab and make sure to have "Save Password" marked, make sure the port is 3306 and database(s) is blank now click "Connect" Ok, SQLyog is now Installed and ready for use!





Alright now we're going to import the databases and configure them a bit, begin with making two new databases by right clicking on "root@localhost" and clicking "Create Database" The database name can be anything but I recommend using Character and World for this one, now name this first one World and leave the tabs below to default then click Create, ok that's one now do the same thing again just name this one Character. Ok now we're going to import the databases from the repack, extract "Repack by Mafiaboy.rar" to C:/Program Files or some where else you can easily get to it, when it's done open up SQLyog again and right click on the database "Character" and click "Restore from SQL Dump" find the map you extracted and go into "DATABASES" then chose the file named "Character.sql" and click Open, now click Execute when that us done click Cancel and go to the other database you created, world, do the exact same thing to this one but execute the Ascent.sql instead. NOTE: This can take a while depending on your computer. When you're done click Cancel, now update the databases by clicking the little update sign to the left of where the drop down menu is. Now you'll see you have a lot of tables in each database. Click on the character database so it drops down then click on the table named "accounts" then click "3 Table Data" in the big square, you'll see 10 tabs in that window now, this is where all the accounts on your server will be stored and saved, to create an account you simply write account name under the tab "Login" and the password under the tab "Password" now you might wane rank this account up a bit, 1 = GM rank 1. 2 = GM rank 2. 3 = GM rank 3 and AZ = Admin account, then under the tab "Flags" is the account type, 0 = Regular wow and 8 = Burning Crusade so if you have Burning Crusade installed you wane write 8 under the tab Flags, now when you've made your account you have to save it by clicking the little disk second from the left in the tool tab right above where the tab "acct" is. Now you've made your account and you're done with SQLyog for now.





Go into the map you extracted last time (Mafiaboys Repack) then open the map named ad.exe find the ad for your version of wow, now open up your wow folder which normally located in C:/Program Files/World of Warcraft then drag or copy the ad for your version of wow over to your World of Warcraft directory, just place it in there, now create a new map in there as well and name it "Maps" now start the ad.exe you placed in the wow folder earlier. It should now start extracting files from wow and into the map you made, this may take a while depending on your computer. When it's done extracting drag the Maps folder you made over to the repack folder, just place it in the main folder.


Config

Now we're going to configure the config files, hehe. Open Ascent.conf in notepad, find this:

<WorldDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "ascent" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "ascentlogon" Port = "3306" Type = "1">

Change where it says Password = "Ascent" change Ascent to your password, now change where it says Name = "ascent" to "World" and Name = "ascentlogon" to "Character" change the password to the password you chose when you installed MySQL.

Now open up the Logonserver.conf in notepad and find this:

<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "ascent"
Name = "ascentlogon"
Port = "3306"
Type = "1">

Change ascent to the password you chose when you installed MySQL and change "ascentlogon" to "Character" now open up Realms.conf and scroll to the bottom, here you can change the name of the realm on your server:

<Realm1 Name = "wowmafia.org"
Address = "127.0.0.1:8129"
Icon = "PVP"
Colour = "1"
Population = "1.0"
TimeZone = "1">

Change the red field to whatever you want, this will be the name of your realm. Then save and close the file.





[B][COLOR=magenta]Start Logonserver.exe then Ascent.exe you can use Ecko Tools to start your server and it will automatically restart the server if it crashes. Now go into your wow directory and open the file named Realmlist.wtf in notepad, I recommend making a backup of the file, now delete everything that is in the file and change it to this: set realmlist 127.0.0.1 launch wow with wow.exe and NOT the launcher.exe that

[MentaL]