DSP Wiki - User contributions [en]

Building the Server

2012-04-16T09:54:58Z

JonLimitless: /* MySql */

== Installing & Setting up the DS Server on Windows ==

=== Prerequisites ===

In this section we will download every program/tool we will need to setup and maintain the servers. Do not install these yet.

[http://dev.mysql.com/downloads/mysql/ MySQL Community Server]

[http://70.226.47.159/downloads.php Navicat Lite]

[http://www.microsoft.com/visualstudio/en-us/products/2010-editions/visual-cpp-express Visual Studio 2010 (Full or Express)]

[http://tortoisesvn.net/downloads.html Tortoise SVN]

[http://www.microsoft.com/download/en/details.aspx?id=5555 Visual C++ Redistributable Runtimes 2010]

[http://www.microsoft.com/download/en/details.aspx?id=21 .Net 3.5 Runtime] (already comes with Win 7)

[http://www.microsoft.com/download/en/details.aspx?id=22 .Net 3.5sp1 Runtime] (already comes with Win 7)

[http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17851 .Net 4 Runtime]

[http://code.google.com/p/onetimexi/downloads/detail?name=MySQL.rar&can=2&q= SQL Developer Package]

=== Installation ===

==== MySql ====

Choose Typical Installation

After the main installation, select Launch the MySQL Instance Configuration Wizard

Select Detailed Configuration

Select Developer Machine

Select Multifunctional Database

Standard Installation Directory

Select Manual Setting and 1000 Concurrent connections

Select Enable TCP/IP Networking, Port Number 3306, and Enable Strict Mode

Select Best Support for Multilingualism

Select Install as Windows Service, Launch the MySQL Server automatically, and Include Bin Directory in Windows PATH.

Select Modify Security Settings, and enter a new password twice. Write down the MySQL password.
(DO NOT LEAVE BLANK.)

Select Next, Execute, then Finish

==== Navicat Lite ====

Use default installation options.

==== Visual Studio 2010 ====

Use default installation options. You may be forced to restart (sometimes twice) during the installation.

==== Tortoise SVN ====

Use default installation options. You can skip the step to reboot since we'll reboot once everything else is installed.

==== Visual C++ Redistributable Runtime 2010 ====

Use default installation options.

==== .Net 3.5, 3.5 SP1, and 4.0 ====

Use default installation options.

==== SQL Developer Package ====

Don't lose it, as we'll come back to it later.

At this point everything should be installed that needs to be and you can restart your PC to finalize them.

=== Downloading the Server Source Code ===

'''In this section we will use Tortoise SVN to download the latest SVN source code for the server.'''

Open Windows Explorer (right click the start button and choose Windows Explorer)

Right click on any folder select SVN Checkout

In the "URL of repository" put in the following url:

<code><nowiki>http://onetimexi.googlecode.com/svn/trunk/</nowiki></code>

Set the "Checkout directory" to

<code><nowiki>C:\dsp.</nowiki></code>

Click OK.

Wait for the download to finish.

Click OK to close Tortoise SVN.

Close windows explorer

At this point you have downloaded all of the source code for the latest version.

=== Setting up the Database ===

'''In this section we will use the data that you downloaded to build a database in MySQL.'''

==== Using a command script ====

If you follow this step, you may skip the next one.

Paste the following into notepad and save it as DSP_Import.cmd in your dsp\sql folder:

<pre>
@ECHO OFF
REM =============================================================================
REM ====== THis script will drop the DB specificed, then create the DB =========
REM ====== specified, and then load the DS tables into the DB. This =========
REM ====== file needs to be run from within the \dsp\sql folder (same =========
REM ====== folder with all the .sql files. Please edit as needed. By =========
REM ====== default it WILL DROP the standard dspdb DB, loosing all =========
REM ====== accounts and characters. If this is not desired, then update =========
REM ====== the file to load the new DB into a new DB name. =========
REM =============================================================================
REM =============================================================================
REM ====== =========
REM ====== by Thrydwolf 11/5/2011 =========
REM ====== Updated with status on the last step by bluekirby0 3/30/2012 =========
REM ====== =========
REM =============================================================================
REM =============================================================================

ECHO Creating Database dspdb
REM ================================================
REM ====== Update "-p" with MySQL password =========
REM ====== Update dspdb with MySQL Databse =========
REM ================================================
mysqladmin -h localhost -u root -proot DROP dspdb

ECHO Creating Database dspdb
REM ================================================
REM ====== Update "-p" with MySQL password =========
REM ====== Update dspdb with MySQL Databse =========
REM ================================================
mysqladmin -h localhost -u root -proot CREATE dspdb

ECHO Loading dspdb with tables
REM ================================================
REM ====== Update "-p" with MySQL password =========
REM ====== Update dspdb with MySQL Databse =========
REM ================================================
FOR %%X IN (*.sql) DO ECHO Importing %%X & mysql dspdb -h localhost -u root -proot < %%X

ECHO Finished!
</pre>

At a minimum you will need to change -proot in the script to where root is your mysql root password. If your password is 'foo' then you would use -pfoo instead.

You can use this script any time the svn is updated, but it will drop the table and thus delete all your player data. You may want to make manual changes instead unless you are using it purely as a test server.

==== Using Navicat ====

This is the more hands-on approach, and being comfortable doing it this way may make it easier to update individual tables later without having to learn the mysql command-line interface.

Open Navicat

Click Connection (or File, New Connection)

Connection name: DarkStar

Host Name/IP: localhost

Port: 3306

User Name: root

Password: Enter the password you wrote down during the mySQL installation.

Check Save Password

Click OK

In the connections pane double click DarkStar

Right click on DarkStar and select New Database...

Name it dspdb

Use the Default character set

Select OK.

Double click dspdb

Right click on dspdb and select Execute SQL File...

Browse to C:\dsp\sql and select abilities.sql

Click Start

Continue this process for each file in the folder.

If you have an issue with the triggers.sql file then follow this step. If not, proceed to the next step (IP address for the map server):

In Navicat Open accounts table

Click File, Design Table

Click the Triggers tab

There should a line already listed with account_delete in the Name field

If not:

click Add Trigger

Name column should be account_delete

Fires column should be Before

Check the box in the Delete column

In the definition box below add the following code:

<pre>
BEGIN
DELETE FROM `accounts_banned` WHERE `accid` = OLD.id;
DELETE FROM `chars` WHERE `accid` = OLD.id;
END
</pre>

Select Save and then close the table.

Open the chars table

Click File, Design Table

Click the Triggers tab

There should already be a line listed with char_delete in the name field.

If not:

click Add Trigger

Name column should be char_delete

Fires column should be Before

Check the box in the Delete column

In the definition box below add the following code:

<pre>
BEGIN
DELETE FROM `char_exp` WHERE `charid` = OLD.charid;
DELETE FROM `char_jobs` WHERE `charid` = OLD.charid;
DELETE FROM `char_equip` WHERE `charid` = OLD.charid;
DELETE FROM `char_effects` WHERE `charid` = OLD.charid;
DELETE FROM `char_look` WHERE `charid` = OLD.charid;
DELETE FROM `char_stats` WHERE `charid` = OLD.charid;
DELETE FROM `char_skills` WHERE `charid` = OLD.charid;
DELETE FROM `char_titles` WHERE `charid` = OLD.charid;
DELETE FROM `char_inventory` WHERE `charid` = OLD.charid;
DELETE FROM `char_vars` WHERE `charid` = OLD.charid;
DELETE FROM `char_bazaar_msg` WHERE `charid` = OLD.charid;
END
</pre>

Select Save and then close the table.

Note: Leave Navicat open for the next section.

==== Configure the ZoneIP for the Map Server ====

Now you need to determine what IP address that will be used for the Map Server, then update MySQL with it.

Most devs & enthusiasts will not have a separate map server, but will run both map server and login server on the same PC.

Determine what IP address will be used for the map server.

If the server will be public, then use your external IP in the next step.

If the server will be internal and you want it available on other PCs in your internal network, use the internal network IP (192.168.x.x) in the next step.

If you only plan to run the client and the server on the same PC, you can use the localhost address (127.0.0.1) in the next step.

Calculate the new form from the IP address.

The IP must be entered in different form, so first we must calculate the new form. Use the formula below or [http://www.allredroster.com/iptodec.htm This Handy Site] to calculate it.

Formula = 1st Octet + 2nd Octet * 256 + 3rd Octet *256 (squared) + 4th Octet * 256 (cubed)

Example: 127.0.0.1 = 127 + 0 + 0 + 1*256(cubed) = 16777343

Example: 192.168.1.102 = 192 + 168*256 + 1*256(squared) + 102*256(cubed) = 1711384768

Example: 67.41.45.115 = 67 + 41*256 + 45*256(squared) + 115*256(cubed) = 1932339523

In Navicat double click on the table dspdb and expand

Click on Query

Right click and select New Query

Add the following code into the empty space, inserting the value calculated above. The value in the code below (16777343) would be used if only running the client from the same PC as the server.

<pre>
BEGIN
UPDATE zone_settings SET zoneip = '16777343';
END
</pre>

Select Run. "256 queries should be successful!" should be the result.

I recommend you save the Query in case you need to run it again later after updating the server.

Close Navicat.

=== Building the Servers ===

'''In this section we will be building the Dark Star servers.'''

Dark Star uses 3 separate servers. A Login server, a Map/Game server, and an optional Search/Auction House server. Using the ZoneIP mentioned earlier, every map could run on its own server at a different IP address. If you have 4 computers each computer could run different areas, as long as they were all connected to the same MySQL database server.

==== Installing the MySQL Development Files ====

Extract the MySQL development package we downloaded earlier.

Copy the MySQL folder that was extracted. There should be a "mysql" folder inside with many files.

Paste that MySQL into either

32bit windows: C:\Program Files\Microsoft SDKs\Windows\v7.0A\Include

64bit windows: C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Include

Afterwords the folder structure should be ...Microsoft SDKs\Windows\v7.0A\Include\MySQL

==== Build the Login Server ====

Open Visual Studio

Click File, Open, Project/Solution (or Ctrl+Shift+O)

Navigate to C:\dsp\win32\DSConnect-Server

Select DSConnect-server.sln (usually the first one)

It may take a few minutes to load files.

Click Debug then Build Server (or F7, or Ctrl+Shift+B)

Building will take a few minutes.

Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:

<pre>========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========</pre>

If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.

If there is a #include error, change that #include to say #include <mysql/mysql.h>

==== Build the Map Server ====

Click File, Open, Project/Solution (or Ctrl+Shift+O)

Navigate to C:\dsp\win32\DSGame-Server

Select DSGame-server.sln (usually the first one)

It may take a few minutes to load files.

Click Debug then Build Server (or F7, or Ctrl+Shift+B)

Building will take a few minutes.

Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:

<pre>========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========</pre>

If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.

If there is a #include error, change that #include to say #include <mysql/mysql.h>

==== Building the Optional Search Server ====

Navigate to C:\dsp\win32\DSSearch-server

Select DSSearch-server.sln (usually the first one)

It may take a few minutes to load files.

Click Debug then Build Server (or F7, or Ctrl+Shift+B)

Building will take a few minutes.

Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:

<pre>========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========</pre>

If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.

If there is a #include error, change that #include to say #include <mysql/mysql.h>

==== When all of the Servers are built ====

Verify in the C:\dsp directory that the servers you built are there:

DSConnect-server.exe for the Login Server

DSGame-server.exe for the Map Server

DSSearch-server.exe for the Search Server

=== Configuring the Servers ===

'''Now you will configure the Login Server and Map Server to connect to the MySQL database.'''

Do not mess with any other settings in these files unless you know what they are for and what they do.

==== Login Server Settings ====

In windows explorer navigate to c:\dsp\conf

Open login_darkstar.conf in a text editer (notepad)

Scroll down to the bottom and validate/update the following lines:

<pre>
mysql_host: 127.0.0.1
mysql_port: 3306
mysql_login: root
mysql_password: root <-- change this to your password you wrote down during the MySQL install
mysql_database: dspdb
</pre>

==== Map Server Settings ====

In windows explorer navigate to c:\dsp\conf

Open map_darkstar.conf in a text editer (notepad)

Scroll down to the bottom and validate/update the following lines:

<pre>
mysql_host: 127.0.0.1
mysql_port: 3306
mysql_login: root
mysql_password: root <-- change this to your password you wrote down during the MySQL install
mysql_database: dspdb
</pre>

==== Search Server Settings ====

In windows explorer navigate to c:\dsp\conf

Open search_server.conf in a text editer (notepad)

Scroll down to the bottom and validate/update the following lines:

<pre>
mysql_host: 127.0.0.1
mysql_port: 3306
mysql_login: root
mysql_password: root <-- change this to your password you wrote down during the MySQL install
mysql_database: dspdb
</pre>

At this point we have configured the servers to connect to the SQL database.

=== Starting the Servers ===

'''In this section we will launch our new servers.'''

Navigate to c:\dsp

Run DSConnect-server.exe as Admin

Run DSGame-server.exe as Admin

(Optional) Run DSSearch-server.exe as Admin

At this point if your servers fail to load, you probably missed a step. Go back through the steps and try to find out what you missed. It may also be helpful to look at the log files located in c:\dsp\log.

=== Forward Ports to Allow Others to Join (& Firewall) ===

'''In this section we will provide the port numbers that need to be forwarded to the server. This is only needed to allow people outside your local intranet to join your server.'''

In your router and firewall the following ports need to be opened/forwarded to your server:

<pre>
54230
54231
54001
</pre>

If still having trouble, disable any firewall software completely for testing. This includes the Windows firewall that comes on all modern Windows systems, which can be found in the Control Panel.

== Installing & Setting up the DS Server on Linux ==

To be filled in as I find a reliable way of building newer revisions on linux systems.

== Credits ==
The original windows guide was written by thrydwolf, and has been formatted for the wiki and updated by bluekirby0

Building the Server

2012-04-16T09:54:45Z

JonLimitless: /* MySql */

== Installing & Setting up the DS Server on Windows ==

=== Prerequisites ===

In this section we will download every program/tool we will need to setup and maintain the servers. Do not install these yet.

[http://dev.mysql.com/downloads/mysql/ MySQL Community Server]

[http://70.226.47.159/downloads.php Navicat Lite]

[http://www.microsoft.com/visualstudio/en-us/products/2010-editions/visual-cpp-express Visual Studio 2010 (Full or Express)]

[http://tortoisesvn.net/downloads.html Tortoise SVN]

[http://www.microsoft.com/download/en/details.aspx?id=5555 Visual C++ Redistributable Runtimes 2010]

[http://www.microsoft.com/download/en/details.aspx?id=21 .Net 3.5 Runtime] (already comes with Win 7)

[http://www.microsoft.com/download/en/details.aspx?id=22 .Net 3.5sp1 Runtime] (already comes with Win 7)

[http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17851 .Net 4 Runtime]

[http://code.google.com/p/onetimexi/downloads/detail?name=MySQL.rar&can=2&q= SQL Developer Package]

=== Installation ===

==== MySql ====

Choose Typical Installation

After the main installation, select Launch the MySQL Instance Configuration Wizard

Select Detailed Configuration

Select Developer Machine

Select Multifunctional Database

Standard Installation Directory

Select Manual Setting and 1000 Concurrent connections

Select Enable TCP/IP Networking, Port Number 3306, and Enable Strict Mode

Select Best Support for Multilingualism

Select Install as Windows Service, Launch the MySQL Server automatically, and Include Bin Directory in Windows PATH.

Select Modify Security Settings, and enter a new password twice. Write down the MySQL password.
(Make sure to make a password and DO NOT LEAVE BLANK.)

Select Next, Execute, then Finish

==== Navicat Lite ====

Use default installation options.

==== Visual Studio 2010 ====

Use default installation options. You may be forced to restart (sometimes twice) during the installation.

==== Tortoise SVN ====

Use default installation options. You can skip the step to reboot since we'll reboot once everything else is installed.

==== Visual C++ Redistributable Runtime 2010 ====

Use default installation options.

==== .Net 3.5, 3.5 SP1, and 4.0 ====

Use default installation options.

==== SQL Developer Package ====

Don't lose it, as we'll come back to it later.

At this point everything should be installed that needs to be and you can restart your PC to finalize them.

=== Downloading the Server Source Code ===

'''In this section we will use Tortoise SVN to download the latest SVN source code for the server.'''

Open Windows Explorer (right click the start button and choose Windows Explorer)

Right click on any folder select SVN Checkout

In the "URL of repository" put in the following url:

<code><nowiki>http://onetimexi.googlecode.com/svn/trunk/</nowiki></code>

Set the "Checkout directory" to

<code><nowiki>C:\dsp.</nowiki></code>

Click OK.

Wait for the download to finish.

Click OK to close Tortoise SVN.

Close windows explorer

At this point you have downloaded all of the source code for the latest version.

=== Setting up the Database ===

'''In this section we will use the data that you downloaded to build a database in MySQL.'''

==== Using a command script ====

If you follow this step, you may skip the next one.

Paste the following into notepad and save it as DSP_Import.cmd in your dsp\sql folder:

<pre>
@ECHO OFF
REM =============================================================================
REM ====== THis script will drop the DB specificed, then create the DB =========
REM ====== specified, and then load the DS tables into the DB. This =========
REM ====== file needs to be run from within the \dsp\sql folder (same =========
REM ====== folder with all the .sql files. Please edit as needed. By =========
REM ====== default it WILL DROP the standard dspdb DB, loosing all =========
REM ====== accounts and characters. If this is not desired, then update =========
REM ====== the file to load the new DB into a new DB name. =========
REM =============================================================================
REM =============================================================================
REM ====== =========
REM ====== by Thrydwolf 11/5/2011 =========
REM ====== Updated with status on the last step by bluekirby0 3/30/2012 =========
REM ====== =========
REM =============================================================================
REM =============================================================================

ECHO Creating Database dspdb
REM ================================================
REM ====== Update "-p" with MySQL password =========
REM ====== Update dspdb with MySQL Databse =========
REM ================================================
mysqladmin -h localhost -u root -proot DROP dspdb

ECHO Creating Database dspdb
REM ================================================
REM ====== Update "-p" with MySQL password =========
REM ====== Update dspdb with MySQL Databse =========
REM ================================================
mysqladmin -h localhost -u root -proot CREATE dspdb

ECHO Loading dspdb with tables
REM ================================================
REM ====== Update "-p" with MySQL password =========
REM ====== Update dspdb with MySQL Databse =========
REM ================================================
FOR %%X IN (*.sql) DO ECHO Importing %%X & mysql dspdb -h localhost -u root -proot < %%X

ECHO Finished!
</pre>

At a minimum you will need to change -proot in the script to where root is your mysql root password. If your password is 'foo' then you would use -pfoo instead.

You can use this script any time the svn is updated, but it will drop the table and thus delete all your player data. You may want to make manual changes instead unless you are using it purely as a test server.

==== Using Navicat ====

This is the more hands-on approach, and being comfortable doing it this way may make it easier to update individual tables later without having to learn the mysql command-line interface.

Open Navicat

Click Connection (or File, New Connection)

Connection name: DarkStar

Host Name/IP: localhost

Port: 3306

User Name: root

Password: Enter the password you wrote down during the mySQL installation.

Check Save Password

Click OK

In the connections pane double click DarkStar

Right click on DarkStar and select New Database...

Name it dspdb

Use the Default character set

Select OK.

Double click dspdb

Right click on dspdb and select Execute SQL File...

Browse to C:\dsp\sql and select abilities.sql

Click Start

Continue this process for each file in the folder.

If you have an issue with the triggers.sql file then follow this step. If not, proceed to the next step (IP address for the map server):

In Navicat Open accounts table

Click File, Design Table

Click the Triggers tab

There should a line already listed with account_delete in the Name field

If not:

click Add Trigger

Name column should be account_delete

Fires column should be Before

Check the box in the Delete column

In the definition box below add the following code:

<pre>
BEGIN
DELETE FROM `accounts_banned` WHERE `accid` = OLD.id;
DELETE FROM `chars` WHERE `accid` = OLD.id;
END
</pre>

Select Save and then close the table.

Open the chars table

Click File, Design Table

Click the Triggers tab

There should already be a line listed with char_delete in the name field.

If not:

click Add Trigger

Name column should be char_delete

Fires column should be Before

Check the box in the Delete column

In the definition box below add the following code:

<pre>
BEGIN
DELETE FROM `char_exp` WHERE `charid` = OLD.charid;
DELETE FROM `char_jobs` WHERE `charid` = OLD.charid;
DELETE FROM `char_equip` WHERE `charid` = OLD.charid;
DELETE FROM `char_effects` WHERE `charid` = OLD.charid;
DELETE FROM `char_look` WHERE `charid` = OLD.charid;
DELETE FROM `char_stats` WHERE `charid` = OLD.charid;
DELETE FROM `char_skills` WHERE `charid` = OLD.charid;
DELETE FROM `char_titles` WHERE `charid` = OLD.charid;
DELETE FROM `char_inventory` WHERE `charid` = OLD.charid;
DELETE FROM `char_vars` WHERE `charid` = OLD.charid;
DELETE FROM `char_bazaar_msg` WHERE `charid` = OLD.charid;
END
</pre>

Select Save and then close the table.

Note: Leave Navicat open for the next section.

==== Configure the ZoneIP for the Map Server ====

Now you need to determine what IP address that will be used for the Map Server, then update MySQL with it.

Most devs & enthusiasts will not have a separate map server, but will run both map server and login server on the same PC.

Determine what IP address will be used for the map server.

If the server will be public, then use your external IP in the next step.

If the server will be internal and you want it available on other PCs in your internal network, use the internal network IP (192.168.x.x) in the next step.

If you only plan to run the client and the server on the same PC, you can use the localhost address (127.0.0.1) in the next step.

Calculate the new form from the IP address.

The IP must be entered in different form, so first we must calculate the new form. Use the formula below or [http://www.allredroster.com/iptodec.htm This Handy Site] to calculate it.

Formula = 1st Octet + 2nd Octet * 256 + 3rd Octet *256 (squared) + 4th Octet * 256 (cubed)

Example: 127.0.0.1 = 127 + 0 + 0 + 1*256(cubed) = 16777343

Example: 192.168.1.102 = 192 + 168*256 + 1*256(squared) + 102*256(cubed) = 1711384768

Example: 67.41.45.115 = 67 + 41*256 + 45*256(squared) + 115*256(cubed) = 1932339523

In Navicat double click on the table dspdb and expand

Click on Query

Right click and select New Query

Add the following code into the empty space, inserting the value calculated above. The value in the code below (16777343) would be used if only running the client from the same PC as the server.

<pre>
BEGIN
UPDATE zone_settings SET zoneip = '16777343';
END
</pre>

Select Run. "256 queries should be successful!" should be the result.

I recommend you save the Query in case you need to run it again later after updating the server.

Close Navicat.

=== Building the Servers ===

'''In this section we will be building the Dark Star servers.'''

Dark Star uses 3 separate servers. A Login server, a Map/Game server, and an optional Search/Auction House server. Using the ZoneIP mentioned earlier, every map could run on its own server at a different IP address. If you have 4 computers each computer could run different areas, as long as they were all connected to the same MySQL database server.

==== Installing the MySQL Development Files ====

Extract the MySQL development package we downloaded earlier.

Copy the MySQL folder that was extracted. There should be a "mysql" folder inside with many files.

Paste that MySQL into either

32bit windows: C:\Program Files\Microsoft SDKs\Windows\v7.0A\Include

64bit windows: C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Include

Afterwords the folder structure should be ...Microsoft SDKs\Windows\v7.0A\Include\MySQL

==== Build the Login Server ====

Open Visual Studio

Click File, Open, Project/Solution (or Ctrl+Shift+O)

Navigate to C:\dsp\win32\DSConnect-Server

Select DSConnect-server.sln (usually the first one)

It may take a few minutes to load files.

Click Debug then Build Server (or F7, or Ctrl+Shift+B)

Building will take a few minutes.

Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:

<pre>========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========</pre>

If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.

If there is a #include error, change that #include to say #include <mysql/mysql.h>

==== Build the Map Server ====

Click File, Open, Project/Solution (or Ctrl+Shift+O)

Navigate to C:\dsp\win32\DSGame-Server

Select DSGame-server.sln (usually the first one)

It may take a few minutes to load files.

Click Debug then Build Server (or F7, or Ctrl+Shift+B)

Building will take a few minutes.

Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:

<pre>========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========</pre>

If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.

If there is a #include error, change that #include to say #include <mysql/mysql.h>

==== Building the Optional Search Server ====

Navigate to C:\dsp\win32\DSSearch-server

Select DSSearch-server.sln (usually the first one)

It may take a few minutes to load files.

Click Debug then Build Server (or F7, or Ctrl+Shift+B)

Building will take a few minutes.

Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:

<pre>========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========</pre>

If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.

If there is a #include error, change that #include to say #include <mysql/mysql.h>

==== When all of the Servers are built ====

Verify in the C:\dsp directory that the servers you built are there:

DSConnect-server.exe for the Login Server

DSGame-server.exe for the Map Server

DSSearch-server.exe for the Search Server

=== Configuring the Servers ===

'''Now you will configure the Login Server and Map Server to connect to the MySQL database.'''

Do not mess with any other settings in these files unless you know what they are for and what they do.

==== Login Server Settings ====

In windows explorer navigate to c:\dsp\conf

Open login_darkstar.conf in a text editer (notepad)

Scroll down to the bottom and validate/update the following lines:

<pre>
mysql_host: 127.0.0.1
mysql_port: 3306
mysql_login: root
mysql_password: root <-- change this to your password you wrote down during the MySQL install
mysql_database: dspdb
</pre>

==== Map Server Settings ====

In windows explorer navigate to c:\dsp\conf

Open map_darkstar.conf in a text editer (notepad)

Scroll down to the bottom and validate/update the following lines:

<pre>
mysql_host: 127.0.0.1
mysql_port: 3306
mysql_login: root
mysql_password: root <-- change this to your password you wrote down during the MySQL install
mysql_database: dspdb
</pre>

==== Search Server Settings ====

In windows explorer navigate to c:\dsp\conf

Open search_server.conf in a text editer (notepad)

Scroll down to the bottom and validate/update the following lines:

<pre>
mysql_host: 127.0.0.1
mysql_port: 3306
mysql_login: root
mysql_password: root <-- change this to your password you wrote down during the MySQL install
mysql_database: dspdb
</pre>

At this point we have configured the servers to connect to the SQL database.

=== Starting the Servers ===

'''In this section we will launch our new servers.'''

Navigate to c:\dsp

Run DSConnect-server.exe as Admin

Run DSGame-server.exe as Admin

(Optional) Run DSSearch-server.exe as Admin

At this point if your servers fail to load, you probably missed a step. Go back through the steps and try to find out what you missed. It may also be helpful to look at the log files located in c:\dsp\log.

=== Forward Ports to Allow Others to Join (& Firewall) ===

'''In this section we will provide the port numbers that need to be forwarded to the server. This is only needed to allow people outside your local intranet to join your server.'''

In your router and firewall the following ports need to be opened/forwarded to your server:

<pre>
54230
54231
54001
</pre>

If still having trouble, disable any firewall software completely for testing. This includes the Windows firewall that comes on all modern Windows systems, which can be found in the Control Panel.

== Installing & Setting up the DS Server on Linux ==

To be filled in as I find a reliable way of building newer revisions on linux systems.

== Credits ==
The original windows guide was written by thrydwolf, and has been formatted for the wiki and updated by bluekirby0

Building the Server

2012-04-16T09:54:35Z

JonLimitless: /* MySql */

== Installing & Setting up the DS Server on Windows ==

=== Prerequisites ===

In this section we will download every program/tool we will need to setup and maintain the servers. Do not install these yet.

[http://dev.mysql.com/downloads/mysql/ MySQL Community Server]

[http://70.226.47.159/downloads.php Navicat Lite]

[http://www.microsoft.com/visualstudio/en-us/products/2010-editions/visual-cpp-express Visual Studio 2010 (Full or Express)]

[http://tortoisesvn.net/downloads.html Tortoise SVN]

[http://www.microsoft.com/download/en/details.aspx?id=5555 Visual C++ Redistributable Runtimes 2010]

[http://www.microsoft.com/download/en/details.aspx?id=21 .Net 3.5 Runtime] (already comes with Win 7)

[http://www.microsoft.com/download/en/details.aspx?id=22 .Net 3.5sp1 Runtime] (already comes with Win 7)

[http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17851 .Net 4 Runtime]

[http://code.google.com/p/onetimexi/downloads/detail?name=MySQL.rar&can=2&q= SQL Developer Package]

=== Installation ===

==== MySql ====

Choose Typical Installation

After the main installation, select Launch the MySQL Instance Configuration Wizard

Select Detailed Configuration

Select Developer Machine

Select Multifunctional Database

Standard Installation Directory

Select Manual Setting and 1000 Concurrent connections

Select Enable TCP/IP Networking, Port Number 3306, and Enable Strict Mode

Select Best Support for Multilingualism

Select Install as Windows Service, Launch the MySQL Server automatically, and Include Bin Directory in Windows PATH.

Select Modify Security Settings, and enter a new password twice. Write down the MySQL password.
(Make sure to make a password and DO NOT LEAVE BLANK.)
Select Next, Execute, then Finish

==== Navicat Lite ====

Use default installation options.

==== Visual Studio 2010 ====

Use default installation options. You may be forced to restart (sometimes twice) during the installation.

==== Tortoise SVN ====

Use default installation options. You can skip the step to reboot since we'll reboot once everything else is installed.

==== Visual C++ Redistributable Runtime 2010 ====

Use default installation options.

==== .Net 3.5, 3.5 SP1, and 4.0 ====

Use default installation options.

==== SQL Developer Package ====

Don't lose it, as we'll come back to it later.

At this point everything should be installed that needs to be and you can restart your PC to finalize them.

=== Downloading the Server Source Code ===

'''In this section we will use Tortoise SVN to download the latest SVN source code for the server.'''

Open Windows Explorer (right click the start button and choose Windows Explorer)

Right click on any folder select SVN Checkout

In the "URL of repository" put in the following url:

<code><nowiki>http://onetimexi.googlecode.com/svn/trunk/</nowiki></code>

Set the "Checkout directory" to

<code><nowiki>C:\dsp.</nowiki></code>

Click OK.

Wait for the download to finish.

Click OK to close Tortoise SVN.

Close windows explorer

At this point you have downloaded all of the source code for the latest version.

=== Setting up the Database ===

'''In this section we will use the data that you downloaded to build a database in MySQL.'''

==== Using a command script ====

If you follow this step, you may skip the next one.

Paste the following into notepad and save it as DSP_Import.cmd in your dsp\sql folder:

<pre>
@ECHO OFF
REM =============================================================================
REM ====== THis script will drop the DB specificed, then create the DB =========
REM ====== specified, and then load the DS tables into the DB. This =========
REM ====== file needs to be run from within the \dsp\sql folder (same =========
REM ====== folder with all the .sql files. Please edit as needed. By =========
REM ====== default it WILL DROP the standard dspdb DB, loosing all =========
REM ====== accounts and characters. If this is not desired, then update =========
REM ====== the file to load the new DB into a new DB name. =========
REM =============================================================================
REM =============================================================================
REM ====== =========
REM ====== by Thrydwolf 11/5/2011 =========
REM ====== Updated with status on the last step by bluekirby0 3/30/2012 =========
REM ====== =========
REM =============================================================================
REM =============================================================================

ECHO Creating Database dspdb
REM ================================================
REM ====== Update "-p" with MySQL password =========
REM ====== Update dspdb with MySQL Databse =========
REM ================================================
mysqladmin -h localhost -u root -proot DROP dspdb

ECHO Creating Database dspdb
REM ================================================
REM ====== Update "-p" with MySQL password =========
REM ====== Update dspdb with MySQL Databse =========
REM ================================================
mysqladmin -h localhost -u root -proot CREATE dspdb

ECHO Loading dspdb with tables
REM ================================================
REM ====== Update "-p" with MySQL password =========
REM ====== Update dspdb with MySQL Databse =========
REM ================================================
FOR %%X IN (*.sql) DO ECHO Importing %%X & mysql dspdb -h localhost -u root -proot < %%X

ECHO Finished!
</pre>

At a minimum you will need to change -proot in the script to where root is your mysql root password. If your password is 'foo' then you would use -pfoo instead.

You can use this script any time the svn is updated, but it will drop the table and thus delete all your player data. You may want to make manual changes instead unless you are using it purely as a test server.

==== Using Navicat ====

This is the more hands-on approach, and being comfortable doing it this way may make it easier to update individual tables later without having to learn the mysql command-line interface.

Open Navicat

Click Connection (or File, New Connection)

Connection name: DarkStar

Host Name/IP: localhost

Port: 3306

User Name: root

Password: Enter the password you wrote down during the mySQL installation.

Check Save Password

Click OK

In the connections pane double click DarkStar

Right click on DarkStar and select New Database...

Name it dspdb

Use the Default character set

Select OK.

Double click dspdb

Right click on dspdb and select Execute SQL File...

Browse to C:\dsp\sql and select abilities.sql

Click Start

Continue this process for each file in the folder.

If you have an issue with the triggers.sql file then follow this step. If not, proceed to the next step (IP address for the map server):

In Navicat Open accounts table

Click File, Design Table

Click the Triggers tab

There should a line already listed with account_delete in the Name field

If not:

click Add Trigger

Name column should be account_delete

Fires column should be Before

Check the box in the Delete column

In the definition box below add the following code:

<pre>
BEGIN
DELETE FROM `accounts_banned` WHERE `accid` = OLD.id;
DELETE FROM `chars` WHERE `accid` = OLD.id;
END
</pre>

Select Save and then close the table.

Open the chars table

Click File, Design Table

Click the Triggers tab

There should already be a line listed with char_delete in the name field.

If not:

click Add Trigger

Name column should be char_delete

Fires column should be Before

Check the box in the Delete column

In the definition box below add the following code:

<pre>
BEGIN
DELETE FROM `char_exp` WHERE `charid` = OLD.charid;
DELETE FROM `char_jobs` WHERE `charid` = OLD.charid;
DELETE FROM `char_equip` WHERE `charid` = OLD.charid;
DELETE FROM `char_effects` WHERE `charid` = OLD.charid;
DELETE FROM `char_look` WHERE `charid` = OLD.charid;
DELETE FROM `char_stats` WHERE `charid` = OLD.charid;
DELETE FROM `char_skills` WHERE `charid` = OLD.charid;
DELETE FROM `char_titles` WHERE `charid` = OLD.charid;
DELETE FROM `char_inventory` WHERE `charid` = OLD.charid;
DELETE FROM `char_vars` WHERE `charid` = OLD.charid;
DELETE FROM `char_bazaar_msg` WHERE `charid` = OLD.charid;
END
</pre>

Select Save and then close the table.

Note: Leave Navicat open for the next section.

==== Configure the ZoneIP for the Map Server ====

Now you need to determine what IP address that will be used for the Map Server, then update MySQL with it.

Most devs & enthusiasts will not have a separate map server, but will run both map server and login server on the same PC.

Determine what IP address will be used for the map server.

If the server will be public, then use your external IP in the next step.

If the server will be internal and you want it available on other PCs in your internal network, use the internal network IP (192.168.x.x) in the next step.

If you only plan to run the client and the server on the same PC, you can use the localhost address (127.0.0.1) in the next step.

Calculate the new form from the IP address.

The IP must be entered in different form, so first we must calculate the new form. Use the formula below or [http://www.allredroster.com/iptodec.htm This Handy Site] to calculate it.

Formula = 1st Octet + 2nd Octet * 256 + 3rd Octet *256 (squared) + 4th Octet * 256 (cubed)

Example: 127.0.0.1 = 127 + 0 + 0 + 1*256(cubed) = 16777343

Example: 192.168.1.102 = 192 + 168*256 + 1*256(squared) + 102*256(cubed) = 1711384768

Example: 67.41.45.115 = 67 + 41*256 + 45*256(squared) + 115*256(cubed) = 1932339523

In Navicat double click on the table dspdb and expand

Click on Query

Right click and select New Query

Add the following code into the empty space, inserting the value calculated above. The value in the code below (16777343) would be used if only running the client from the same PC as the server.

<pre>
BEGIN
UPDATE zone_settings SET zoneip = '16777343';
END
</pre>

Select Run. "256 queries should be successful!" should be the result.

I recommend you save the Query in case you need to run it again later after updating the server.

Close Navicat.

=== Building the Servers ===

'''In this section we will be building the Dark Star servers.'''

Dark Star uses 3 separate servers. A Login server, a Map/Game server, and an optional Search/Auction House server. Using the ZoneIP mentioned earlier, every map could run on its own server at a different IP address. If you have 4 computers each computer could run different areas, as long as they were all connected to the same MySQL database server.

==== Installing the MySQL Development Files ====

Extract the MySQL development package we downloaded earlier.

Copy the MySQL folder that was extracted. There should be a "mysql" folder inside with many files.

Paste that MySQL into either

32bit windows: C:\Program Files\Microsoft SDKs\Windows\v7.0A\Include

64bit windows: C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Include

Afterwords the folder structure should be ...Microsoft SDKs\Windows\v7.0A\Include\MySQL

==== Build the Login Server ====

Open Visual Studio

Click File, Open, Project/Solution (or Ctrl+Shift+O)

Navigate to C:\dsp\win32\DSConnect-Server

Select DSConnect-server.sln (usually the first one)

It may take a few minutes to load files.

Click Debug then Build Server (or F7, or Ctrl+Shift+B)

Building will take a few minutes.

Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:

<pre>========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========</pre>

If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.

If there is a #include error, change that #include to say #include <mysql/mysql.h>

==== Build the Map Server ====

Click File, Open, Project/Solution (or Ctrl+Shift+O)

Navigate to C:\dsp\win32\DSGame-Server

Select DSGame-server.sln (usually the first one)

It may take a few minutes to load files.

Click Debug then Build Server (or F7, or Ctrl+Shift+B)

Building will take a few minutes.

Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:

<pre>========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========</pre>

If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.

If there is a #include error, change that #include to say #include <mysql/mysql.h>

==== Building the Optional Search Server ====

Navigate to C:\dsp\win32\DSSearch-server

Select DSSearch-server.sln (usually the first one)

It may take a few minutes to load files.

Click Debug then Build Server (or F7, or Ctrl+Shift+B)

Building will take a few minutes.

Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:

<pre>========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========</pre>

If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.

If there is a #include error, change that #include to say #include <mysql/mysql.h>

==== When all of the Servers are built ====

Verify in the C:\dsp directory that the servers you built are there:

DSConnect-server.exe for the Login Server

DSGame-server.exe for the Map Server

DSSearch-server.exe for the Search Server

=== Configuring the Servers ===

'''Now you will configure the Login Server and Map Server to connect to the MySQL database.'''

Do not mess with any other settings in these files unless you know what they are for and what they do.

==== Login Server Settings ====

In windows explorer navigate to c:\dsp\conf

Open login_darkstar.conf in a text editer (notepad)

Scroll down to the bottom and validate/update the following lines:

<pre>
mysql_host: 127.0.0.1
mysql_port: 3306
mysql_login: root
mysql_password: root <-- change this to your password you wrote down during the MySQL install
mysql_database: dspdb
</pre>

==== Map Server Settings ====

In windows explorer navigate to c:\dsp\conf

Open map_darkstar.conf in a text editer (notepad)

Scroll down to the bottom and validate/update the following lines:

<pre>
mysql_host: 127.0.0.1
mysql_port: 3306
mysql_login: root
mysql_password: root <-- change this to your password you wrote down during the MySQL install
mysql_database: dspdb
</pre>

==== Search Server Settings ====

In windows explorer navigate to c:\dsp\conf

Open search_server.conf in a text editer (notepad)

Scroll down to the bottom and validate/update the following lines:

<pre>
mysql_host: 127.0.0.1
mysql_port: 3306
mysql_login: root
mysql_password: root <-- change this to your password you wrote down during the MySQL install
mysql_database: dspdb
</pre>

At this point we have configured the servers to connect to the SQL database.

=== Starting the Servers ===

'''In this section we will launch our new servers.'''

Navigate to c:\dsp

Run DSConnect-server.exe as Admin

Run DSGame-server.exe as Admin

(Optional) Run DSSearch-server.exe as Admin

At this point if your servers fail to load, you probably missed a step. Go back through the steps and try to find out what you missed. It may also be helpful to look at the log files located in c:\dsp\log.

=== Forward Ports to Allow Others to Join (& Firewall) ===

'''In this section we will provide the port numbers that need to be forwarded to the server. This is only needed to allow people outside your local intranet to join your server.'''

In your router and firewall the following ports need to be opened/forwarded to your server:

<pre>
54230
54231
54001
</pre>

If still having trouble, disable any firewall software completely for testing. This includes the Windows firewall that comes on all modern Windows systems, which can be found in the Control Panel.

== Installing & Setting up the DS Server on Linux ==

To be filled in as I find a reliable way of building newer revisions on linux systems.

== Credits ==
The original windows guide was written by thrydwolf, and has been formatted for the wiki and updated by bluekirby0

Troubleshooting Guide

2012-04-16T08:55:14Z

JonLimitless: /* FFXI-3322 error/ffxi-boot or mXI error 10093 */

== Problems with the Server ==
=== Why can I not connect to my own server? ===

First, check and see if you can connect on the same machine using SERVIP = 127.0.0.1

If you can connect using that, but not using your LAN or Internet IP address, you probably need to forward ports on your router. The ports you need to open are TCP: 54230 54231 54001 54002 UDP 54230

=== "Client cannot receive packet or Key is invalid" in DSGame-server ===

Make certain that your zoneip is set correctly in the database. See [[Building the Server#Configure the ZoneIP for the Map Server]] for more information on how to set this properly.

=== Cannot find msvc100.dll error ===

This missing file may be solved by downloading and installing one of the appropriate links below

[http://www.microsoft.com/download/en/details.aspx?id=5555 Microsoft Visual C++ 2010 Redistributable Package (x86)]

[http://www.microsoft.com/download/en/details.aspx?id=14632 Microsoft Visual C++ 2010 Redistributable Package (x64)]

== Problems with the Client ==

=== Any time I attack a monster or cast a spell, the game crashes! ===

The March 26th 2012 patch broke compatibility with Darkstar servers until revision 940. If your server is revision 940 or higher, you will need to update your client using the PlayOnline Viewer's File Repair option. If you updated, but your play server is not using revision 940 or higher, encourage the maintainer to update whenever possible.

=== PlayOnline Viewer crashes on Windows Vista/7 ===

You need to install the Vista compatible PlayOnline viewer from [http://www.playonline.com/ff11us/download/media/vista01.html The PlayOnline Site] and not from the discs. You will still install the game and expansions as normal using the discs.

=== POL-1160 Error when trying to update/repair ===

Check that PlayOnline viewer is allowed through your firewall and router. If you have PeerGuardian, PeerBlock, or similar programs, you may want to check and see if those are blocking responses from the PlayOnline servers.

=== FFXI-3322 error/ffxi-boot or mXI error 10093 ===
This is known as a 'anything can be wrong' error. Note: If the first solution does not fix this, it could be anything on your computer causing this error.

Make certain that you have copied the data folder at PlayOnline\SquareEnix\PlayOnlineViewer\data to the Final Fantasy XI directory at PlayOnline\SquareEnix\FINAL FANTASY XI.
Afterwards you should have the directory PlayOnline\SquareEnix\FINAL FANTASY XI\data

If that is not your problem and your still getting the Accept Fail 10093 error. Make sure your drivers are installed and updated. Check through all of the other solutions on this page such as the distribution packages are downloaded.

After all these fixes and its still not working. You may need to reinstall FFXI on your computer to help solve your problem.

Troubleshooting Guide

2012-04-16T08:49:25Z

JonLimitless: /* FFXI-3322 error/ffxi-boot or mXI error 10093 */

== Problems with the Server ==
=== Why can I not connect to my own server? ===

First, check and see if you can connect on the same machine using SERVIP = 127.0.0.1

If you can connect using that, but not using your LAN or Internet IP address, you probably need to forward ports on your router. The ports you need to open are TCP: 54230 54231 54001 54002 UDP 54230

=== "Client cannot receive packet or Key is invalid" in DSGame-server ===

Make certain that your zoneip is set correctly in the database. See [[Building the Server#Configure the ZoneIP for the Map Server]] for more information on how to set this properly.

=== Cannot find msvc100.dll error ===

This missing file may be solved by downloading and installing one of the appropriate links below

[http://www.microsoft.com/download/en/details.aspx?id=5555 Microsoft Visual C++ 2010 Redistributable Package (x86)]

[http://www.microsoft.com/download/en/details.aspx?id=14632 Microsoft Visual C++ 2010 Redistributable Package (x64)]

== Problems with the Client ==

=== Any time I attack a monster or cast a spell, the game crashes! ===

The March 26th 2012 patch broke compatibility with Darkstar servers until revision 940. If your server is revision 940 or higher, you will need to update your client using the PlayOnline Viewer's File Repair option. If you updated, but your play server is not using revision 940 or higher, encourage the maintainer to update whenever possible.

=== PlayOnline Viewer crashes on Windows Vista/7 ===

You need to install the Vista compatible PlayOnline viewer from [http://www.playonline.com/ff11us/download/media/vista01.html The PlayOnline Site] and not from the discs. You will still install the game and expansions as normal using the discs.

=== POL-1160 Error when trying to update/repair ===

Check that PlayOnline viewer is allowed through your firewall and router. If you have PeerGuardian, PeerBlock, or similar programs, you may want to check and see if those are blocking responses from the PlayOnline servers.

=== FFXI-3322 error/ffxi-boot or mXI error 10093 ===
This is known as a 'anything can be wrong' error. Note: If the first solution does not fix this, it could be anything on your computer causing this error.

Make certain that you have copied the data folder at PlayOnline\SquareEnix\PlayOnlineViewer\data to the Final Fantasy XI directory at PlayOnline\SquareEnix\FINAL FANTASY XI.
Afterwards you should have the directory PlayOnline\SquareEnix\FINAL FANTASY XI\data

If that is not your problem and your still getting the Accept Fail 10093 error. Make sure your drivers are installed and updated. Check through all of the other solutions on this page such as the distribution packages are downloaded. Try using a dll or driver search/fix that will scan your computer for missing files.

After all these fixes and its still not working. You may need to reinstall FFXI on your computer to help solve your problem.

Troubleshooting Guide

2012-04-16T08:48:58Z

JonLimitless: /* FFXI-3322 error/ffxi-boot or mXI error 10093 */

== Problems with the Server ==
=== Why can I not connect to my own server? ===

First, check and see if you can connect on the same machine using SERVIP = 127.0.0.1

If you can connect using that, but not using your LAN or Internet IP address, you probably need to forward ports on your router. The ports you need to open are TCP: 54230 54231 54001 54002 UDP 54230

=== "Client cannot receive packet or Key is invalid" in DSGame-server ===

Make certain that your zoneip is set correctly in the database. See [[Building the Server#Configure the ZoneIP for the Map Server]] for more information on how to set this properly.

=== Cannot find msvc100.dll error ===

This missing file may be solved by downloading and installing one of the appropriate links below

[http://www.microsoft.com/download/en/details.aspx?id=5555 Microsoft Visual C++ 2010 Redistributable Package (x86)]

[http://www.microsoft.com/download/en/details.aspx?id=14632 Microsoft Visual C++ 2010 Redistributable Package (x64)]

== Problems with the Client ==

=== Any time I attack a monster or cast a spell, the game crashes! ===

The March 26th 2012 patch broke compatibility with Darkstar servers until revision 940. If your server is revision 940 or higher, you will need to update your client using the PlayOnline Viewer's File Repair option. If you updated, but your play server is not using revision 940 or higher, encourage the maintainer to update whenever possible.

=== PlayOnline Viewer crashes on Windows Vista/7 ===

You need to install the Vista compatible PlayOnline viewer from [http://www.playonline.com/ff11us/download/media/vista01.html The PlayOnline Site] and not from the discs. You will still install the game and expansions as normal using the discs.

=== POL-1160 Error when trying to update/repair ===

Check that PlayOnline viewer is allowed through your firewall and router. If you have PeerGuardian, PeerBlock, or similar programs, you may want to check and see if those are blocking responses from the PlayOnline servers.

=== FFXI-3322 error/ffxi-boot or mXI error 10093 ===
This is known as a 'anything can be wrong' error. Note: If the first solution does not fix this, it could be anything on your computer causing this error.

1. Make certain that you have copied the data folder at PlayOnline\SquareEnix\PlayOnlineViewer\data to the Final Fantasy XI directory at PlayOnline\SquareEnix\FINAL FANTASY XI.
Afterwards you should have the directory PlayOnline\SquareEnix\FINAL FANTASY XI\data
2. If that is not your problem and your still getting the Accept Fail 10093 error. Make sure your drivers are installed and updated. Check through all of the other solutions on this page such as the distribution packages are downloaded. Try using a dll or driver search/fix that will scan your computer for missing files.
3. After all these fixes and its still not working. You may need to reinstall FFXI on your computer to help solve your problem.