[Guide]Setup a Ascent Server By Scratch -
06-11-2008
This is a turotrial on how to setup a Ascent server by scratch.
I would recommend keeping this server for the future because it would be more stable then repacks.
Downloads -
There are two programs you will need to download for this section. [Only registered and activated users can see links. ] - You will use this to download the Ascent source code. [Only registered and activated users can see links. ] - This is for compiling the source code.
[Only registered and activated users can see links. ] - You will use this for your server database (do not install it right now)
[Only registered and activated users can see links. ] - Use will use this to edit your database or add one.
For Ascent Setup :
1. First create a new folder called SVN. Then create another folder called Ascent inside that. Go into the folder and right click, then go to SVN Checkout.
2. Now put "http://mmoforge.org/svn/ascent/" in the "URL of repository".
3. Now click "OK" and leave it to download.It will ask you for a password. Put your username as anonymous and password blank. The folder "branches" contains stable revisions of Ascent which are guaranteed to work. But the folder "trunk" contains the latest revisions of Ascent, that are not guaranteed to work.
4. You can compile Ascent from the trunk or branches.So now go open "Ascent/branches/3_8_stable/win/" and open "ascentVC90.sln".
5. Change where it says "Debug" to "Release" then click on "Build" then click on "solution"
If it says "0 failed" then everything went ok,if the number is higher then somthing went wrong.
6. Now go to "branches/3_8_stable/src/scripts/" and open "scripts2008.sln". Now compile it like you did before.
Now go to "branches/3_8_stable/bin/release/", your ascent files will be in there.
7. Copy the ".conf" files from "branches/3_8_stable/src/" into this folder, and also the ".dll" files from "branches/3_8_stable/dep/lib32". Now the "release" folder contains your Ascent server, just copy it to a new place like C:\ or your desktop or your choice and rename it to whatever you want.
8. Now install MySQL and select a Typical install. At the end of the install, you will get an option to "Configure the MySQL Server now", make sure this box is checked and continue.Keep clicking next,once it asks you for a password make it whatever you want.But in this turtorial we'll make it "ascent".
9. Now for a database you can choose any database you wish.But some recommended databases are
HyntDB (RusDB) [Only registered and activated users can see links. ] [Only registered and activated users can see links. ]
Whydb [Only registered and activated users can see links. ] [Only registered and activated users can see links. ]
Ascent Blizzlike DB [Only registered and activated users can see links. ] [Only registered and activated users can see links. ]
Yellydb [Only registered and activated users can see links. ] [Only registered and activated users can see links. ]
Legendary Database
[Only registered and activated users can see links. ]
If you chose a database from the list above you will need to follow this method.
10. Go to your SVN folder that you made before and create a new folder called "WhyDB" or whicher DB you chose. Go into the WhyDB folder and go to SVN Checkout Set the URL of repository to [Only registered and activated users can see links. ] click OK and the username will be anonymous, the password will beblank. Now open Tool.bat with notepad and edit it the config like this.
Code:
set user=root
set pass=ascent
set wdb=wdb
set cdb=cdb
set ldb=ldb
To
to
Code:
set user=root
set pass=ascent
set wdb=world
set cdb=logon
set ldb=logon
Pass - The pass you made while installing mysql
wdb - The world database
cdb - Is the charecter database
ldb - Is the logon database for accounts
And now import the database by double click on the "Tool.bat" file.
Then go open Navicat and create a new database called "logon" whatever you want and choose /Ascent/branches/3_8_stable/sql/ and select the logon_structure.sql then click execute and do the same for character_structure.sql in the same folder.
11. Now create a file using notepad,copy and paste the following in there -
Code:
insert into `accounts`(`acct`,`login`,`password`,`gm`,`banned`,`lastlogin`,`lastip`,`email`,`flags`,`forceLanguage`) values (1,'Your username','Your Password','az',0,'0000-00-00 00:00:00','','',8,'enUS');
Remove the "8" for non BC
Save it with your info and right click on your "logon" database , and click on execute.(This will be your WoW account)
12. We will use a map extractor to extract the maps. Use [Only registered and activated users can see links. ] if your WoW client is enUS, or [Only registered and activated users can see links. ] if your client is enGB. Place ad.exe into your World Of Warcraft directory, and make a folder in your World Of Warcraft directory called "maps". Then run ad.exe and it will extract the maps. When its done drag the "maps" into your server folder.
13. Download [Only registered and activated users can see links. ] and follow the instructions in the readme. Then move the DBC folder to your Server.
14. Now we need to edit the configuration files.
Edit them to make them look like these -
Open ascent.world.config,and find
Code:
<WorldDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "accounts" Port = "3306" Type = "1">
Find the "die" messages and delete them on lines 199 and 600.
Finally look for the remote password. (Ctril+F) Change pw to ascent or whicherever you put while
installing mysql.
10. Go to your SVN folder that you made before and create a new folder called "NCDB" or whicher DB you chose. Go into the NCDB folder and go to SVN Checkout Set the URL of repository to [Only registered and activated users can see links. ] click OK and the username will be anonymous, the password will beblank. Now open Tool.bat with notepad and edit it the config like this.
using Checkout does nothing, and direct link in browser seems a bad link now
Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep)
Rep Power: 2
Reputation: 2
Posts: 26
Join Date: May 2007
06-14-2008
Okay i now have the same problem as the guy above me.
Ive tried getting DIFFRENT databases, and dont know where the "tools.bat" is located. Something really simple, but i cant find it in any database files.
Okay i now have the same problem as the guy above me.
Ive tried getting DIFFRENT databases, and dont know where the "tools.bat" is located. Something really simple, but i cant find it in any database files.