Version 3, last updated by Lordcorm at March 29, 2008 00:55 UTC

Here we go, the final part to getting a working server that you can log into and have some fun! (Just make sure to bring a couple of freinds along :) ).

Setting up the Database:

Ok, for the sake of simplicity of this guide, i will use Navicat.

1. Open Navicat.

2. Press the "Connection" Button.

3. Name your connection. This can be anything you want. (localhost is most ideal)

4. Keep "Host name/IP address:" at localhost.

5. Keep "Port" at 3306.

6. Keep "Username" at root.

7. Put the password you used at setup for MySQL.

8. Press "Test Connection" to make sure all information inputed was correct.

9. Press ok.

 

Now that we have a connection setup, double click the name of your connection in the left box. Make sure the icon goes green, as that will tell you that you have connected to the database. Now we will setup the accual database.

1. Right Click on your connection name in the left box.

2. Click on "New Database".

3. Name this what ever you like.

4. Press "OK".

5. Double Click the name of your database in the left box.

6. Make sure the icon goes green.

7. Right Click the database name.

8. Press "Execute Batch File.."

9. Navigate to the folder where the source code is installed.

10. Double Click on the folder that is named "dbScript".

11. Double Click on the file "account".

12. Repeat setps 9 - 11 untill all the files in the folder "dbScript" are executed.

KEEP NAVICAT OPEN FOR THE NEXT SECTION

 

Setting up a galaxy:

Before we launch the server, we want to setup a galaxy.

1. Double Click on the database you made.

2. In the right box, double click the galaxy table.

3. There should already be a default galaxy there for you, first name it what you like.

4. (Optional) goto www.whatismyip.com and copy your ip address. Then paste it into the ip cell of the galaxy.

 

Opening and Configuring the Server:

Now, we are going to open the server and configure it. Im going to show you the best way to do so, in debug mode.

1. Open up the SWGPreCU project solution in Microsoft Visual C++.

2. In the left box, right click the "Zone Server" project.

3. Click on properties.

4. In the left box, select "Debugging".

5. In Command Arguments, put "8" (This is the planet ID of Tatooine, for the current point in time of the server, we have setup a default spawn point in tatooine untill we get travel in, and get starting position database driven. When that happens, this guide will most certainly change. But for the current point in time, we will just use one planet. This will later be explained in another section of my Ultimate Guide, and i will show you how to setup multiple planets, and how to change the starting position).

6. Press Apply.

7. Press Ok.

 

Now we need to tell Microsoft Visual C++ to launch every exe for us.

1. In the left box, right click on "Solution 'SWGPreCU'".

2. Click on properties.

3. Check the Multiple Startup Projects radio.

4. Set all Projects to "Start".

 

Now we can launch the server! Press F5.

Configuring the Server:

We are almost done! Now we need to configure the server.

You may have noticed that when you started the server, it started asking you for configuration options, well, im going to take you through these options (They are the same for each server that needs configuration).

1. First thing its going to ask you for is the login server port, sence this guide is based on default options, keep it at default by pressing enter.

2. Keep Character Server port at default (Press Enter).

3. Keep Tutorial Server port at default (Press Enter).

4. Keep DB Server Address or URL at default (Press Enter).

5. Keep DB Port at default (Press Enter).

6. Keep DB User Name at default (Press Enter).

7. Now, enter your MySQL Password then press enter.

8. Now, enter the name of the database you created, and press enter.

9. Press Enter through the rest of the options, as they are advanced options.

10. Repeat this for every server that needs it.

 

Concluding:

If you have done everything correctly, you should now be able to connect to the server, and zone in :).

NOTE: IT IS A GOOD IDEA TO TELL ANYONE LOGIN INTO THE SERVER, THAT THE TUTORIAL SERVER IS NOT ANYWHERE NEAR COMPLETION, SO UNCHECK THE ENTER TUTORIAL BOX WHEN CREATING A CHARACTER!!!!