Supgee's Official DOL HOWTO [Added to Wiki]

[Supgee]

As there is no "set in stone" walkthrough, I will attempt too provide one for the people.
This tutorial will explain everything from downloading the programs needed, exporting the source, compiling the source, setting up an MySQL server, and populating the databases.
------------
1. First of all, you will need to download a few programs too be successful in DOL.
A) Microsoft Visual C# Express Edition, available here.
This is a free IDE(Interactive Development Environment) provided by Microsoft.
B) You will need Tortoise SVN, available here.
Tortoise SVN is a way of obtaining the latest Dawn of Light source.
C) You will need MySQL server 4.1, available here.
MySQL 4.1 is the foundation for the MySQL databases.
D) You will need Navicat, available here.
Navicat is an MySQL GUI that allows you too edit MySQL easily.
-------------------------------------------------------------------


Using the Downloaded Programs effectively:
A) Microsoft Visual C# --> The C# Ide will automatically set itself as the c# default IDE. Once opened the Microsoft Visual C# interface is completely self explanatory.
B) Tortoise SVN --> Tortoise SVN is a shell extension, which means it is useable at all times. Too obtain the latest 1.8 source from Tortoise SVN, create a new folder. Right click inside that folder can do "SVN Checkout".
For the SVN URL, put: https://dolserver.svn.sourceforge.net/s ... harp/trunk
This will automatically download the latest 1.8 Revision into this folder.
C) MySQL 4.1 --> This is the framework for all MySQL. Once downloaded, you will need to configure your MySQL settings(username and password).
D) Navicat --> Navicat is the way you edit your databases.


--------------------------------------------------------------------
After you have obtained the latest 1.8 source, open up the Microsoft Visual C# IDE.
1) Go to file, and click browse. Find the folder you created and exported the 1.8 source into, and open the file labeled Dawn Of Light.
2) Let the file load completely, and when it is finished go too the top toolbar menu and click "Build". Then click "Build Solution".
3) Your 1.8 source will compile into a fully working Dawn of Light server.
After it has finished compiling you will see a compiled folder called "Release". You should all be familiar with this folder, so I will not go any further in this topic.

--------------------------------------------------------------------
Hooking up the MySQL Databases:
1) Open up your Navicat GUI and click "Connection", "New Connection".
2) Put in server as "localhost". Enter your username and password(the ones you entered when you configured your MySQL Server 4.1
3) Press Enter. You will have successfully entered into your MySQL server.
4) You will now see a tab called "localhost". Click on it, and it will become green. Expand the arrow, and you will see 3 databases.
5) Right click on "localhost" and create a new database named "DOL" or "dol" the capital do not mean anything.
6) This will be your database for MySQL.
---------------------------------------------------------------------

Linking, and Establishing your MySQL tables.
*update*
1) Run your DOLServer.
2) Follow the DOLConfig application that appears on screen.
3) Voila, you are done!
----------------------------------------------------------------------
Downloading and Importing your MySQL Databases:
1) Too download the official keep(Includes: Keep, KeepComponent, KeepHookpoint, KeepPosition, Relic) releases, click here.
2) Too download the official content package(Includes: Ability, ClassXRealmAbility, SpecXAbility, Specialisation, Style, Style Substitute, StyleXSpell, Spell, SpellLine, LineXSpell) releases, click here.
3) Too download the official World package(Includes: World Object, Zone Point, Area, Bind Point, Door) releases, click here.
4) Once you have downloaded all theese databases, extract them all into a folder you can easily remember.
5) Open up your Navicat MySQL GUI.
6) Open up your localhost connection, and right click on the database "dol" that you created.
7) Click execute batch file, and locate the folder you extracted all the databases into.
Click each database one by one, and they will be added to your MySQL database.
9) You now have an MySQL Database
10) You will now be able to run your fully compiled, fully functional DOL server, with a successful MySQL Database.
------------------------------------------------------------------------
I hope this tutorial provides useful, and I hope that people use it.

Cheers,
Supgee.

[LinkDead]

Thanks for the guide!

[Overdriven]

Nice call moving it here Supgee.


PS: Sorry for being a cunt towards you recently.

[Supgee]

I actually got Etaew too move it and sticky it.


PS: No problem

[Batlas]

It would look better in the wiki

[Cisien]

there's already a halfassed one in the wiki, if you dont mind, supgee, you should update the wiki one

[Supgee]

Sure thing!

[LifeFlight]

Great Guide!!!
Helped me out.

[Roozzz]

When browsing through different language forums i came across two other how-to guides in german and Italian respectively.

Maybe somebody could also sticky them? I think it could be very usefull for people to have a guide in their mothertongue...

[Etaew]

Would only sticky them in the respective other language forums, but since I don't understand the languages, or visit the forums often, I'd have to be pointed towards them.

[Roozzz]

Would only sticky them in the respective other language forums, but since I don't understand the languages, or visit the forums often, I'd have to be pointed towards them.

Thats why I figured to post here, I noticed the Italian one is stickied this morning by Lightbringer.

And this is the topic in the german forum: http://www.dolserver.net/viewtopic.php?t=6228

[Supgee]

Updated too reflect latest SVN url.

[samandhi]

Linking, and Establishing your MySQL tables.
1) Locate too your "release" folder, and open up the folder config.
2) Find the XML document called serverconfig.xml, and open it up.
3) Find the line --> <DBConnectionString>C:/whatever/xml_db</DBConnectionString>
4) Replace that line with this --> <DBConnectionString>Server=localhost; Database=DOL; User ID=YOURUSERNAME; Password=YOURPASSWORD</DBConnectionString> (Note: Your username and password are the same from what you configured with your MySQL Server 4.1
5) Find the line --> <DBType>XML</DBType>
6) Replace that line with --> <DBType>MySQL</DBType>
7) Save the file, and run your DOL server.
You will experience some errors, while the DOL server creates the empty MySQL Databases

Hi. I love this guide, however I have followed it to a "T", and this section is stumping me. After compiling the sources as you suggested, I can find the config folder, but there are only two .xml files in there :

• regions
  zones

has something changed or am I missing something?

[Overdriven]

SQL databases arn't kept in the DOL directory at all, once they've been converted you need to use a SQL GUI to find/use the databases.

The two XML files are right

[samandhi]

Thank you for replying so fast. I am not sure I understand, though. I have downloaded the DB's listed in the tut... I was having a problem establishing the link between the server and MySQL because I cant find the file listed in the tutorial to change.