[Guide]Setup a Ascent Server By Scratch

[Pedregon]

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.
TortoiseSVN - You will use this to download the Ascent source code.
Visual C++ 2008 Express Edition - This is for compiling the source code.

MySQL - You will use this for your server database (do not install it right now)

Navicat - 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)
http://hynt.ascentemu.ru
Revision 16: /

Whydb
WhyDB • Index page
Revision 146: /

Ascent Blizzlike DB
ascentblizzlike.com
Revision 290: /

Yellydb
http://mmoforge.org/svn/yelly/
Yelly database - Index


Legendary Database

http://www.mmowned.com/forums/emulat...tml#post867926

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 http://svn2.assembla.com/svn/WhyDB/ 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.

set user=root
set pass=ascent
set wdb=wdb
set cdb=cdb
set ldb=ldb

To

to

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 -

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 this if your WoW client is enUS, or this 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 this DBC extractor 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

<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.

<LogonServer DisablePings = "0"
             RemotePassword = "pw">

Open logonserver.config and find

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

Now you need to change the Min and Maxbuild to the latest patch which is 2.4.2 (827

<Client MinBuild = "6128"
        MaxBuild = "7278">

to

<Client MinBuild = "8278"
        MaxBuild = "8278">

15. Now start the file "Logonserver" and "ascent.world".

16. Now go to your World Of Warcraft folder and open "realmlist.wtf" with notepad or any word program and change it to look like this -

 set realmlist 127.0.0.1
set patchlist us.version.worldofwarcraft.com

Then save it. Start WoW and play with the game account you made earlier

To go back to Blizzard WoW change it back to "Set realmlist us.logon.worldofwarcraft.com".

Note - for those who want the DBC folder follow step 13.

[Pedregon]

Anyone wanna say somthing for my hard work?lol

[kesden]

Thanks for this, im going to try it out tomorrow, so ill try to remember to post back on how i got on

[Wolverine77]

was looking for a guide to learn all this thank you, ill post back...

[Wolverine77]

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 http://mmoforge.org/svn/ncdb/ 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

[kesden]

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.

[Pedregon]

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.

Which DB did you get?

[Wolverine77]

Legendary Database

[**Sweeny**]

Setting up an Ascent server from scratch - AC Web
looks pretty simular.

[Pedregon]

lol it does

[Ickybad]

Pictures really help people who aren't good at reading.

[Pedregon]

Legendary DB doesn't have a "Tool.bat" file,you'll have to create a "world" database and execute it.

[zeke156]

Legendary DB doesn't have a "Tool.bat" file,you'll have to create a "world" database and execute it.

How do i make a ''world'' database?? plz help :wave:

[kevn93x]

He meant in navicat under your connect. right click "add database"
name it world. right click the database execute batch file. select db.

&& can i make this go public, make an account created page, use navicat for accounts, and make customs.

trying it atm.

+rep if i helped others.

[kevn93x]

Got to the final part & bam. possible invalid format in file DBC spell.dbc us:211 them:213

[edit: redoing the dbc, will edit results]

[edit: same error, installing BC to be 100% sure, user support would be nice]

[edit: not its a buffer overload. spellitemenchantment or something.]