How to Install NCDB

[SectorSeven]

Hey guys, there has been ALOT of trouble installing the latest NCDB, as they use a web installer. It may be troublesome, but at least it works and provides a global structure so that all the emulation communities can work together on a global database. Its not hard at all trust me, and you will find this guide pretty simple.


I will be adding a video [HERE] after I finish editing it, which should be tonight, so just follow the text guide for now.


Step 1: Installing a Web Package
To get started, you need to install a web package. I recommend you download WAMP. You can use any web package you like, but it cannot contain PHP 6. It must be a version or subversion of PHP 5. Xampp and AppServer are also acceptable packages.


Step 2: Checkout NCDB
You need to have Tortoise SVN installed, or another Subversion downloader client. Make a folder on your Desktop called "NCDB". Right click it, and then click on "Checkout". In the "URL of repository" blank put the address "Revision 18: /" and click ok. It should start downloading the files. After it is done, click ok or exit out.

Step 3: Configuration
This step is all about preparing for adding the actual content to the database. We will add some things to our database during this step, however, it is only structural aspects, not actual data. You must have a MySQL database program like Navicat, HeidiSQL, or SQLyog. For this tutorial, I will be using Navicat Lite.

Open up Navicat Lite. Click the green connection button in the top-left corner. Set the connection name to anything you wish, I will use "Ascent". Now skip ahead to the username and password fields. Put your MySQL information in each of these fields. Click ok. Double click the connection name, then right click it and click "New Database...". For the database name, put "base". Click ok. Repeat this step of adding another database and this time name it "world". Close out of Navicat. Your about 1/2 through the entire process at this point.


Open up your NCDB folder, and browse to the \trunk\web installer\sql directory. Right click "win-install.bat" and click edit. Change your user to your MySQL username. Change the pass to your MySQL password. Finally, change the wdb to "world". Save and close out. Browse to \trunk\sql and right click "win-install.bat". Enter your MySQL username and password and change the wdb to "base". Save and close out.

Now browse to the \trunk\web installer\include directory. Right click "config.inc" and click Edit. Fill out the dbuname and dbupass with your MySQL information. Do this for the sections under //Base and //Destination. Now for the field "$dbname" put "base". For the "$dbname_destination" put "world". Save the file and close out.


Step 3: Final Preparations
Browse to \trunk\web installer\sql and double click "win-install.bat". Type "a" for ArcEmu/Ascent and "m" for MaNGOS and hit enter. When it is finished close out. Now browse to trunk\sql and double click "win-install.bat". Enter the letter "i" and hit enter. When it is finished close out. Now move the folder "web installer" to your "www" folder of your web package. For example, mine is C:/Program Files/WAMP/www.


Step 4: Adding Data
This is the easy step. Make sure your WAMP/web package server is running first. Open up "http://127.0.0.1/web%20installer/" and click "Newest OpenAscent" or whatever emulator your trying to install it for. Then click start converting. It will run for a while. Close out when you see the message "We code for beer and hookers".


If you go into your database, and go to world, you see that it is Ascent's structure and that all the tables are filled. You did it! Go you!


Information:
NCDB Website: Next Chapter Community
NCDB Wiki: Main Page - Next Chapter
NCDB SVN: Revision 18: /
NCDB IRC: irc.quakenet.org #NCDB


Thanks for reading!


-SectorSeven

[JoeThePlumber]

Thanks just what I needed

[xxx]

sector seven pwns

[SectorSeven]

No problem, sorry for still not having a video >.>

I've been really busy lately...

[Fujosej]

thx its work, but why table spellfixes , spell disable trainer and others is not filed??
but anyway thx ) you are the best.

[igud2]

i get this error when i try to install it Q200708031723 Table 'base.parse_vars' doesn't existselect value from parse_vars where name like 'ascent_stepcount'

[EvilNomed]

For me the guide has been working great up until i use the win-install in the SQL folder.

Whenever i run it, the file gives me an error saying "The system cannot find the file specified" any insight on what might be the problem ?

[rampage]

Thanks for the guide. Took me a while to get it going but i finally did.....

Will upload latest Rev When I Can........



Will Rep when I Can

Regards

[Ömen]

I get the error when uploading database.sql " Mysql Server has gone away "

[pheonixia]

sorry if you didn't want questions S7, but, i'm having trouble with step 4, with Open up "http://127.0.0.1/web%20installer/" i open it up and it says 404 not found.

[SectorSeven]

You either didn't move the web installer folder to web package or don't have web package running.

[xxguitardud3]

For me the guide has been working great up until i use the win-install in the SQL folder.

Whenever i run it, the file gives me an error saying "The system cannot find the file specified" any insight on what might be the problem ?

Im having the same problem... S7 can you help me out?

[Kirksite170]

I just fixed my "The sytem cannot find the file specified" error ... simply extract the database in your NCDB\trunk\sql folder. Then run as normally.

[Tropem]

Awesome! +rep!! tyvm this was good for a noob like me xD

EDIT
Don't it got account table??

[jay08]

Found this very usefull, again thanks alot.