DSP Wiki - User contributions [en]

Building the Server

2016-01-09T03:58:55Z

Lautan: /* Install on Ubuntu */

== 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] (flag)
-Or-
[http://dev.mysql.com/downloads/installer/5.6.html/ MySQL Community Server 5.6 (Updated)] (flag)
-Or-
[https://downloads.mariadb.org/ MariaDB]

[http://dev.mysql.com/downloads/workbench/ MySQL Workbench]

[http://www.visualstudio.com/en-us/downloads/download-visual-studio-vs.aspx Visual Studio 2013 or higher (Full or Express)]

[https://code.google.com/p/msysgit/downloads/list?q=full+installer+official+git/ Git For Windows]

[https://code.google.com/p/tortoisegit/ TortoiseGit]

[http://www.microsoft.com/en-us/download/details.aspx?id=40784 Visual C++ Redistributable Runtimes 2013]

[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]

=== Installation ===

==== MySql ====
(flag)

Choose Typical Installation

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

Select Detailed Configuration

Select Developer Machine

Select Multi-functional 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

==== MySQL 5.6 '''(Updated)'''====
Note: Server is x86, but will install 32-bit and 64-bit binaries.

Accept License Terms

Skip Check for updates

Select Developer Default

Check requirements and click Execute - will launch installers for anything you're missing

Default Installation - ~5min

Default Configuration - Check box for "Show Advance Options" - Click Next

Enter MySQL Root Password, twice. Remember it! - Click Next

It will show windows service details, leave as default and Click Next

It will show Logging options, leave as default and Click Next

Configuration will complete, Click Next

Samples and examples will configure - ~5min - Click Next

Click Finish

==== MySQL Workbench ====

Use default installation options.

==== Visual Studio 2015 ====

Any edition works. Community is free.

Make sure you install C++! At the time of this writing, it is NOT in the default options (use custom to select it under Languages).

==== Git for Windows ====

Use default installation options.

==== TortoiseGit ====

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

==== Visual C++ Redistributable Runtime 2013 and 2015 ====

Use default installation options.

==== .Net 4.6 ====

Use default installation options. It probably comes with Visual Studio 2015

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 TortoiseGit to download the latest git source code for the server.'''

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

Right click on any folder select Git Clone

In the "URL" field put in the following url:

<code><nowiki>http://github.com/DarkstarProject/darkstar.git</nowiki></code>

Set the "Directory" to your choice (blank will default to current location /darkstar

Click OK.

Wait for the download to finish.

Click OK to close TortoiseGit.

Close windows explorer

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

If you are not planning on doing any development, it's advised to use the stable branch instead of master. Right click on your darkstar folder, and go to TortoiseGit -> Switch/Checkout.
Change the branch dropdown to remotes/origin/stable and hit OK.

=== Setting up the Database ===

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

==== Using a bat script ====

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

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

<pre>
@ECHO OFF
REM =============================================================================
REM =============================================================================
REM ====== =========
REM ====== THis script will drop the DB specificed, then create the DB =========
REM ====== specified, and then load all .sql tables from its run dir to =========
REM ====== the the DB. =========
REM ====== =========
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 ====== Update -p with MySQL password. If you password is 'foo', =========
REM ====== then change '-pMYSQLPASS' to '-pfoo' (3 places). =========
REM ====== =========
REM ====== If you want to use a different database name, change 'dspdb' =========
REM ====== with a database name of your choosing. =========
REM ====== =========
REM =============================================================================
REM =============================================================================
REM ====== =========
REM ====== by Thrydwolf 9/8/2012 =========
REM ====== Updated with status by bluekirby0 3/30/2012 =========
REM ====== Updated by Thrydwolf 9/18/2012 =========
REM ====== =========
REM =============================================================================
REM =============================================================================

ECHO Creating Database dspdb
"c:\program files\mysql\mysql server 5.6\bin\mysqladmin"-h localhost -u root -pMYSQLPASS DROP dspdb

ECHO Creating Database dspdb
"c:\program files\mysql\mysql server 5.6\bin\mysqladmin"-h localhost -u root -pMYSQLPASS CREATE dspdb

ECHO Loading dspdb tables into the database
cd c:\darkstar\sql
FOR %%X IN (*.sql) DO ECHO Importing %%X & "c:\program files\mysql\mysql server 5.6\bin\mysql" dspdb -h localhost -u root -pMYSQLPASS < %%X

ECHO Finished!
</pre>

At a minimum you will need to change -pMYSQLPASS in the script to where root is your mysql root password. If your password is 'foo' then you would use '-pfoo' instead. You may also have to change the path of your mysql installation as well (for example, if you installed a different version of mysql)

You can use this script any time the repository 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.

After you've done your initial load, you can use the following script that will preserve character data
<pre>
cd c:\darkstar\sql
del auction_house.sql
del chars.sql
del accounts.sql
del accounts_banned.sql
del char_effects.sql
del char_equip.sql
del char_exp.sql
del char_inventory.sql
del char_jobs.sql
del char_look.sql
del char_pet.sql
del char_pet_name.sql
del char_points.sql
del char_profile.sql
del char_skills.sql
del char_stats.sql
del char_storage.sql
del char_vars.sql
del char_weapon_skill_points.sql
del chars.sql
del conquest_system.sql
del delivery_box.sql
del linkshells.sql
FOR %%X IN (*.sql) DO ECHO Importing %%X & "c:\program files\mysql\mysql server 5.6\bin\mysql" dspdb -h localhost -u root -pMYSQLPASS < %%X
</pre>

==== Using Navicat ====
(flag)

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>
DELETE FROM `accounts_banned` WHERE `accid` = OLD.id;
DELETE FROM `chars` WHERE `accid` = OLD.id;
</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>
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;
</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.

1. 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. (Looks really random like 173.194.43.104)

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.

2. Update the zone_settings table with the ip
(flag)
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 (127.0.0.1) would be used if only running the client from the same PC as the server.

<pre>
UPDATE zone_settings SET zoneip = '127.0.0.1';
</pre>

Select Run. You should get a message stating that many (280+) records were changed.

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.

==== Build the Server ====

Open Visual Studio

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

Navigate to C:\dsp\win32

Select darkstar.sln

It may take a few minutes to load files.

Optional: if your cpu can handle it, enable multi-core compiling like so http://i.imgur.com/GCjdsdG.png (do this for all 3, or just DSGameServer since that's where most the compile time goes).

Click Debug then Build Server (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: 3 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 (flag)
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 (flag)
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 (flag)
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>
TCP Ports:
54230
54231
54001
54002

UDP Port:
54230
</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 ==

The server is known to build in recent [http://www.ubuntu.com/ Ubuntu] versions (14.04), and is tested regularly against it.

Generic build instructions for most POSIX (GNU/Linux, and possibly FreeBSD, NetBSD, UNIX or even OSX with some additional work) systems follow. Some knowledge of how to compile software on your distribution is assumed. You may find it helpful to reference the Windows guide above if something is unclear.

=== Prerequisites: ===

==== Install on Ubuntu ====

sudo apt-get install git mysql-server libmysqlclient-dev libluajit-5.1-dev libzmq3-dev autoconf pkg-config

'''Ubuntu 14.04 needs gcc 5'''.

sudo su -
apt-get install build-essential
add-apt-repository ppa:ubuntu-toolchain-r/test
apt-get update
apt-get install g++-5

cd /usr/bin
rm gcc g++ cpp
ln -s gcc-5 gcc
ln -s g++-5 g++
ln -s cpp-5 cpp

==== Other Distros ====

A compiler with C++11/14 support. Currently tested with GCC and G++, and requires a minimum version of 4.9

Git to retrieve the source code.

Autotools (automake autoconf m4sh) and pkg-config to generate the configure script and Makefile

mysql server

mysql client library (select the developer version if your distro has on)

luajit library version 5.1 or higher (select the developer version if your distro has one)

libzmq (select the developer version if your distro has one)

If you plan to run from a console, you may also wish to install "screen" as there is no daemon mode for the servers yet.

=== Preparing the Source Code ===

Once you have everything mentioned above installed, grab the latest source from the repository via the command:
<nowiki>git clone http://github.com/DarkstarProject/darkstar.git/</nowiki>

If you are not planning on doing development, it's advised to checkout the stable branch:
<nowiki>git checkout stable</nowiki>

=== Compiling ===

Next is a typical autotools build. Run the autogen script, followed by configure, and then make (GNU make: if your cpu has multiple cores and you wish to utilise them to speed up the build, use '''make -j#CoresMultipliedBy1.5''' e.g. '''make -j4''' if it has 3 cores instead of just '''make''' in the step below):
sh autogen.sh
./configure --enable-debug=gdb
make

You can choose not to configure with debug enabled, but there is very little potential gain in this and it prevents many useful break statements from triggering. The Makefile also has separate targets to build each server named "dsconnect" "dsgame" and "dssearch" but will build all 3 if none are specified.

=== Setting Up the Database ===

If you do not know your mysql root password, the default on most systems is blank. It is a good idea to change this for security reasons, as your mysql root user has full permissions on all databases. The first time you run the mysql client, you should be prompted to change the password. After doing so, you will want to create a user specifically for dealing with the darkstar server database. Run mysql as follows:
mysql -u root -p

Enter your root password at the prompt. Next, create a new user as follows:
CREATE USER 'darkstar'@'localhost' IDENTIFIED BY 'password';

Substitute "password" with a password of your choice. Next, we want to create a database, and set up our new user with permissions to work with it.
CREATE DATABASE dspdb;
USE dspdb;
GRANT ALL PRIVILEGES ON dspdb.* TO 'darkstar'@'localhost';
exit

This will make it to where your new user can do anything necessary, but can only connect from localhost, so even if your password is compromised, it will be difficult to mess with the database remotely. If you need to be able to access the database remotely (like if the database is stored on a separate machine from the server), change the configuration according to the host that will be accessing the database.

Now, you need to populate the database.
cd sql
for f in *.sql
do
echo -n "Importing $f into the database..."
mysql dspdb -u darkstar -ppassword < $f && echo "Success"
done
cd ..

To set up your ZoneIP, see the related windows section [[Building_the_Server#Configure_the_ZoneIP_for_the_Map_Server]] above for how to calculate it, and then run:
mysql -u darkstar -ppassword
USE dspdb;
UPDATE zone_settings SET zoneip = '127.0.0.1';
exit

replacing "127.0.0.1" with the value you determined in your calculation. You should see a message that at least 256 changes have occured after the update command.

=== Configuring the Server ===
Before running your new servers, you will need to update the configuration files to tell it how to talk to the database. You will need to update the files in the conf/ sub-folder named "login_darkstar.conf" "map_darkstar.conf" and "search_server.conf" at a minimum. Find the mysql settings in each and change as appropriate, using the new user, password and database you created earlier.

You may also wish to browse through the various configuration files for any settings that might be of interest to you, but more details on server customization can be found at [[Customizing Your Server]].

=== Starting the Servers ===
You may now start your new servers. If you are using a desktop environment, you may wish to open 3 separate terminals and run each server in a separate one to monitor them efficiently. Otherwise, you will want to run them in screen sessions as follows:
screen -d -m -S dsconnect ./dsconnect
screen -d -m -S dsgame ./dsgame
screen -d -m -S dssearch ./dssearch

This will start and auto-detach all three servers, assigning them meaningful names to make it easy to reattach later by using the commands:
screen -r dsconnect

or
screen -r dsgame

or
screen -r dssearch

to monitor a given server. Once you've attached to a screen, you can detach by first pressing "ctrl+a" and then "d". There are many other useful ways to use screen, so do whatever suits yoru preference.

Your server is now up-and-running, and a client should be able to connect as long as there are no obvious errors on any of the server screens. If the search server is having issues, it is not vital for basic game functionality, but you will be unable to use search functions or the auction house. If you have run into any major issues, contact bluekirby0 (the current maintainer of the linux port as of the time of this writing) on IRC #darkstarproject@irc.rizon.net or in the [http://forums.dspt.info forums].

== Automatic Server Restarts & Crash Logs ==

If your server goes down, no one can connect. If it goes down when you're not looking, it can be down for an extended period of time. To fix this, you probably want to have a way to have your server auto-restart. In addition, it's good to know when the server crashed.
===Getting the software===
First, you'll want to download Knas Restarter here: [http://www.knas.se/Applications/Restarter.aspx].
===Creating the Logging files===
In the dsp directory where your game, connect, and search server reside, create a 'tools' folder. In the folder create 4 new text files by right clicking, and going to New > Text Document

Make sure you have file extension view turned on so that you can see the .txt at the end.

Rename the 4 files to the following:

connect_crash.bat <Change the file type to bat file, deleting .txt

connect_crash_log.txt

game_crash.bat <Change the file type to bat file, deleting .txt

game_crash_log.txt

Right click on connect_crash.bat and click 'edit'
Place the following inside:
echo %date% %time% >> connect_crash_log.txt
Save and close

Right click on game_crash.bat and click 'edit'
Place the following inside:
echo %date% %time% >> game_crash_log.txt
Save and close

===Connect Server Restart===
Launch Knas Restarter
Find DSConnect-server.exe and click on it
Click "Select"
Change itnerval to 10 seconds
Under "Restart Paramters";
Check Keep restarter minimized
in "Working Directory" enter the directory where dsp is installed
Under Actions;
Check "External Script" and browse to your tools folder and select connect_crash.bat
Click "Create Shortcut" and save to your desktop

===Game Server Restart===
Launch Knas Restarter
Find DSGame-server.exe and click on it
Click "Select"
Change itnerval to 10 seconds
Under "Restart Paramters";
Check Keep restarter minimized
in "Working Directory" enter the directory where dsp is installed
Under Actions;
Check "External Script" and browse to your tools folder and select game_crash.bat
Click "Create Shortcut" and save to your desktop

===Launching===
Open the shortcuts you created on your desktop, and open the search server as you normally would.

Crash logs will be found in the text files you created in the tools directory showing the date and time the crash occurred.
===Problems===
In some Windows opperating systems, a window will pop up saying the program has crashed, leaving the crashed program up and preventing an auto-restart. This can be avoided by disabling the user interface for critical errors. To do this follow these steps:

Start > Run gpedit.msc

Computer Configuration > Administrative Templates > Windows Components > Windows Error Reporting
Set Prevent Display of the user interface for critical errors" to Enabled

== Common Errors ==

=== Getting Errors on Load / In Game ===

You have to run all changed sql files! Be careful you keep zoneip correct in zone_settings.sql.

=== Can't Connect to Game Server ===

Make sure your zoneip in zone_settings table is correct. Also make sure packets can reach the 53445 port.

Restart server after changing zoneip.

=== Packet or key is invalid: ===

Restart login server, game server and game client.

=== make: *** No rule to make target ===

Delete .deps

<pre>
source autogen.sh
./configure
make
</pre>

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

Useful Queries

2015-11-12T03:04:42Z

Lautan:

== Find All Mobs Without Pets ==

<pre>
select mobid, mobname, mob_pets.pet_offset
from mob_spawn_points
inner join mob_groups on mob_spawn_points.groupid = mob_groups.groupid
inner join mob_pools on mob_groups.poolid = mob_pools.poolid
left join mob_pets on mob_pets.mob_mobid = mob_spawn_points.mobid
where mob_pools.mJob IN (9, 14, 15, 18) and mob_pets.pet_offset IS NULL;
</pre>

== Find All Pets Without a Master ==

<pre>
select mobid, mobname from mob_spawn_points where mobname LIKE '%\_s\_%' and NOT EXISTS (select * from mob_pets where mob_mobid + pet_offset = mobid limit 1);
</pre>

2013-07-31T15:22:53Z

Lautan: /* Modifying Drop Lists */

A break down of the database tables and what the fields mean.

===[[Basic database primer]]===

A simple explanation of how a database works, some hurdles and "gotchas" that might crop up, and why things are done the way they are.

===[[Accounts]]===

Includes "accounts," "accounts_banned," and "accounts_sessions."

===[[Characters]]===

Includes "chars," "char_effects," "char_equip," "char_exp," "char_look," "char_points," "char_profile," "char_skills," "char_stats," "char_storage," "char_titles," "char_vars," and "char_weapon_skill_points."

===[[Items]]===

Includes "item_armor," "item_basic," "item_furnishing," "item_latents," "item_mods," "item_puppet," "item_usable," "item_weapon," and "item_weapon_unlocked."

===[[Actions]]===

Includes "abilities," "blue_spell_list," "blue_spell_mods," "merits," "skill_caps," "skill_ranks," "spell_list," "traits," and "weapon_skills."

===[[Mobs]]===

Includes "mob_spawn_points," "mob_groups," "mob_pools," "mob_droplist," "mob_family_system," "mob_skill," and "nm_spawn_points."

===[[Economy]]===

Includes "auction_house," "delivery_box," "guild_shops," and "synth_recipes."

===[[Fishing]]===

Includes "fishing_fish," "fishing_lure," "fishing_rod,' "fishing_zone."

bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, elevators, exp_base, exp_table, linkshells, mob_change_skin, npc_list, pet_list, server_variables, skill_caps, skillchain_damage_modifiers, status_effects, transport, zone_settings, zone_weather, zonelines

Temporary:

Dumping this here for now. Setting npc_list.status to 2 will make the NPC untargetable.

=== Modifying Drop Lists ===

Find the mob you want to modify from the sql/mob_pools.sql table.

With the poolid find the mob in sql/mob_groups.sql.

Get the dropid then find the table in sql/mob_droplist.sql.

You can also search for the itemid directly in droplist if its unique enough.

If there is no droplist you can easily create a new one but make sure the dropid is unique.

Database

2013-07-31T15:22:36Z

Lautan: Modifying droplists

A break down of the database tables and what the fields mean.

===[[Basic database primer]]===

A simple explanation of how a database works, some hurdles and "gotchas" that might crop up, and why things are done the way they are.

===[[Accounts]]===

Includes "accounts," "accounts_banned," and "accounts_sessions."

===[[Characters]]===

Includes "chars," "char_effects," "char_equip," "char_exp," "char_look," "char_points," "char_profile," "char_skills," "char_stats," "char_storage," "char_titles," "char_vars," and "char_weapon_skill_points."

===[[Items]]===

Includes "item_armor," "item_basic," "item_furnishing," "item_latents," "item_mods," "item_puppet," "item_usable," "item_weapon," and "item_weapon_unlocked."

===[[Actions]]===

Includes "abilities," "blue_spell_list," "blue_spell_mods," "merits," "skill_caps," "skill_ranks," "spell_list," "traits," and "weapon_skills."

===[[Mobs]]===

Includes "mob_spawn_points," "mob_groups," "mob_pools," "mob_droplist," "mob_family_system," "mob_skill," and "nm_spawn_points."

===[[Economy]]===

Includes "auction_house," "delivery_box," "guild_shops," and "synth_recipes."

===[[Fishing]]===

Includes "fishing_fish," "fishing_lure," "fishing_rod,' "fishing_zone."

bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, elevators, exp_base, exp_table, linkshells, mob_change_skin, npc_list, pet_list, server_variables, skill_caps, skillchain_damage_modifiers, status_effects, transport, zone_settings, zone_weather, zonelines

Temporary:

Dumping this here for now. Setting npc_list.status to 2 will make the NPC untargetable.

=== Modifying Drop Lists ===

Find the mob you want to modify from the sql/mob_pools.sql table.
With the poolid find the mob in sql/mob_groups.sql.
Get the dropid then find the table in sql/mob_droplist.sql.

You can also search for the itemid directly in droplist if its unique enough.

If there is no droplist you can easily create a new one but make sure the dropid is unique.

Building the Server

2013-07-30T19:49:26Z

Lautan:

== 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] (flag)
-Or-
[http://dev.mysql.com/downloads/installer/5.6.html/ MySQL Community Server 5.6 (Updated)] (flag)

[http://70.226.47.159/downloads.php Navicat Lite] (flag)

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

[http://www.microsoft.com/en-us/download/details.aspx?id=23691 Visual Studio Service Pack 1]

[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]

=== Installation ===

==== MySql ====
(flag)

Choose Typical Installation

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

Select Detailed Configuration

Select Developer Machine

Select Multi-functional 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

==== MySQL 5.6 '''(Updated)'''====
Note: Server is x86, but will install 32-bit and 64-bit binaries.

Accept License Terms

Skip Check for updates

Select Developer Default

Check requirements and click Execute - will launch installers for anything you're missing

Default Installation - ~5min

Default Configuration - Check box for "Show Advance Options" - Click Next

Enter MySQL Root Password, twice. Remember it! - Click Next

It will show windows service details, leave as default and Click Next

It will show Logging options, leave as default and Click Next

Configuration will complete, Click Next

Samples and examples will configure - ~5min - Click Next

Uncheck "launch MySQL Workbench, Click Finish

==== Navicat Lite ====
(flag)

Use default installation options.

==== Visual Studio 2010 ====

Use the default installation options. You may be forced to restart (sometimes twice) during the installation.
You should have Visual Studio Service Pack 1 (requiring another restart). It depends on your OS.

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

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 bat script ====

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

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

<pre>
@ECHO OFF
REM =============================================================================
REM =============================================================================
REM ====== =========
REM ====== THis script will drop the DB specificed, then create the DB =========
REM ====== specified, and then load all .sql tables from its run dir to =========
REM ====== the the DB. =========
REM ====== =========
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 ====== Update -p with MySQL password. If you password is 'foo', =========
REM ====== then change '-pMYSQLPASS' to '-pfoo' (3 places). =========
REM ====== =========
REM ====== If you want to use a different database name, change 'dspdb' =========
REM ====== with a database name of your choosing. =========
REM ====== =========
REM =============================================================================
REM =============================================================================
REM ====== =========
REM ====== by Thrydwolf 9/8/2012 =========
REM ====== Updated with status by bluekirby0 3/30/2012 =========
REM ====== Updated by Thrydwolf 9/18/2012 =========
REM ====== =========
REM =============================================================================
REM =============================================================================

ECHO Creating Database dspdb
mysqladmin -h localhost -u root -pMYSQLPASS DROP dspdb

ECHO Creating Database dspdb
mysqladmin -h localhost -u root -pMYSQLPASS CREATE dspdb

ECHO Loading dspdb with tables
REM FOR %%X IN (*.sql) DO mysql dspdb -h localhost -u root -pMYSQLPASS < %%X
FOR %%X IN (*.sql) DO ECHO Importing %%X & mysql dspdb -h localhost -u root -pMYSQLPASS < %%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 ====
(flag)

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>
DELETE FROM `accounts_banned` WHERE `accid` = OLD.id;
DELETE FROM `chars` WHERE `accid` = OLD.id;
</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>
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;
</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.

1. 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. (Looks really random 173.194.43.104)

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.

2. 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. '''If you use the site you must put the IP in reverse order''' to get the required value (i.e. instead of 127.0.0.1 which gives 2130706433 put in 1.0.0.127 to get 16777343).

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

(flag)
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>
UPDATE zone_settings SET zoneip = '16777343';
</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.

==== 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 (flag)
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 (flag)
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 (flag)
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>
TCP Ports:
54230
54231
54001
54002

UDP Port:
54230
</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 ==

The server is known to build in recent [http://www.debian.org/ Debian] GNU/Linux, [http://www.ubuntu.com/ Ubuntu], and [http://fedoraproject.org/ Fedora] versions, and is tested regularly against all three platforms. It is also known to build on [http://www.gentoo.org/ Gentoo].

Fedora-specific instructions may be found on the page: [[Fedora Linux Setup]]

Generic build instructions for most POSIX (GNU/Linux, and possibly FreeBSD, NetBSD, UNIX or even OSX with some additional work) systems follow. Some knowledge of how to compile software on your distribution is assumed. You may find it helpful to reference the Windows guide above if something is unclear.

=== Prerequisites: ===
A compiler with C++11 support. Currently tested with GCC and G++, and requires a minimum version of 4.6

Subversion to retrieve the source code.

patch to apply the search server patch (should be installed with subversion if your system lacks it)

Autotools (automake autoconf m4sh) and pkg-config to generate the configure script and Makefile

mysql server

mysql client library (select the developer version if your distro has one)

lua library version 5.1 or higher (select the developer version if your distro has one)

If you plan to run from a console, you may also wish to install "screen" as there is no daemon mode for the servers yet.

=== Preparing the Source Code ===

Once you have everything mentioned above installed, grab the latest source from the repository via the command:
<nowiki>svn co http://onetimexi.googlecode.com/svn/trunk/ dsp/</nowiki>

Now, find the latest version of the search server patch at [http://forums.dspt.info/viewtopic.php?f=11&t=38 The Darkstar Project Forums]. Extract the diff file into the dsp folder and apply it using the command:
patch -p0 -i dssearchv6.diff

=== Compiling ===

Next is a typical autotools build. Run the autogen script, followed by configure, and then make:
sh autogen.sh
./configure --enable-debug
make

You can choose not to configure with debug enabled, but there is very little potential gain in this and it prevents many useful break statements from triggering. The Makefile also has separate targets to build each server named "dsconnect" "dsgame" and "dssearch" but will build all 3 if none are specified.

=== Compiling on 64-bit ===
These steps were done on Ubuntu 12.04.
First you need to install the relevant packages:
sudo apt-get install libc-dev-i386
sudo apt-get install g++-multilib
sudo apt-get install libmysqlclient-dev:i386
sudo apt-get install liblua5.1-dev:i386

You'll note that these are 32-bit packages which are needed to build in 32-bit mode.
If you already have the 64-bit mysql client libraries already installed, you have to uninstall them. Sadly the 32-bit version and 64-bit version can not coexist. NOTE: This is not advised if you have applications relying on the sql libraries!
In order to get rid of it you can do:
sudo apt-get remove --purge libmysqlclient-dev

At this point you should be all set up but there is one more thing that needs to be addressed. The source is looking for a liblua.so library which didn't exist from the liblua5.1 installation. To manually set it up do:
cd /usr/lib/i386-linux-gnu/
sudo ln -s liblua5.1.so liblua.so

Now the environment is set up so you can run the configure script. We have to force it into 32-bit mode using CPPFLAGS and CXXFLAGS:
CPPFLAGS=-m32 CXXFLAGS=-m32 ./configure
make

At this point it should complete the build and you can continue on to the next section.

=== Setting Up the Database ===

If you do not know your mysql root password, the default on most systems is blank. It is a good idea to change this for security reasons, as your mysql root user has full permissions on all databases. The first time you run the mysql client, you should be prompted to change the password. After doing so, you will want to create a user specifically for dealing with the darkstar server database. Run mysql as follows:
mysql -u root -p

Enter your root password at the prompt. Next, create a new user as follows:
CREATE USER 'darkstar'@'localhost' IDENTIFIED BY 'password';

Substitute "password" with a password of your choice. Next, we want to create a database, and set up our new user with permissions to work with it.
CREATE DATABASE dspdb;
USE dspdb;
GRANT ALL PRIVILEGES ON dspdb.* TO 'darkstar'@'localhost';
exit

This will make it to where your new user can do anything necessary, but can only connect from localhost, so even if your password is compromised, it will be difficult to mess with the database remotely. If you need to be able to access the database remotely (like if the database is stored on a separate machine from the server), change the configuration according to the host that will be accessing the database.

Now, you need to populate the database.
cd sql
for f in *.sql
do
echo -n "Importing $f into the database..."
mysql dspdb -u darkstar -ppassword < $f && echo "Success"
done
cd ..

To set up your ZoneIP, see the related windows section [[Building_the_Server#Configure_the_ZoneIP_for_the_Map_Server]] above for how to calculate it, and then run:
mysql -u darkstar -ppassword
USE dspdb;
UPDATE zone_settings SET zoneip = '16777343';
exit

replacing "16777343" with the value you determined in your calculation. You should see a message that 256 changes have occured after the update command.

=== Configuring the Server ===
Before running your new servers, you will need to update the configuration files to tell it how to talk to the database. You will need to update the files in the conf/ sub-folder named "login_darkstar.conf" "map_darkstar.conf" and "search_server.conf" at a minimum. Find the mysql settings in each and change as appropriate, using the new user, password and database you created earlier.

You may also wish to browse through the various configuration files for any settings that might be of interest to you, but more details on server customization can be found at [[Customizing Your Server]].

=== Starting the Servers ===
You may now start your new servers. If you are using a desktop environment, you may wish to open 3 separate terminals and run each server in a separate one to monitor them efficiently. Otherwise, you will want to run them in screen sessions as follows:
screen -d -m -S dsconnect ./dsconnect
screen -d -m -S dsgame ./dsgame
screen -d -m -S dssearch ./dssearch

This will start and auto-detach all three servers, assigning them meaningful names to make it easy to reattach later by using the commands:
screen -r dsconnect

or
screen -r dsgame

or
screen -r dssearch

to monitor a given server. Once you've attached to a screen, you can detach by first pressing "ctrl+a" and then "d". There are many other useful ways to use screen, so do whatever suits yoru preference.

Your server is now up-and-running, and a client should be able to connect as long as there are no obvious errors on any of the server screens. If the search server is having issues, it is not vital for basic game functionality, but you will be unable to use search functions or the auction house. If you have run into any major issues, contact bluekirby0 (the current maintainer of the linux port as of the time of this writing) on IRC #darkstarproject@irc.rizon.net or in the [http://forums.dspt.info forums].

== Common Errors ==

=== Getting Errors on Load / In Game ===

You have to run all changed sql files! Be careful you keep zoneip correct in zone_settings.sql.

=== Can't Connect to Game Server ===

Make sure your zoneip in zone_settings table is correct. Also make sure packets can reach the 53445 port.

=== im getting build_100 every time i attack a mob ===

Update your client

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

Configuring Your Client

2013-07-30T14:26:00Z

Lautan:

Configuring Your Client

2013-07-30T14:24:25Z

Lautan:

What Works

2013-07-29T19:31:03Z

Lautan: /* Advanced Jobs */

== The Goal ==

The idea for this wiki page originally stemmed from my post on the forums ([http://forums.dspt.info/viewtopic.php?f=5&t=526 What do these servers have to offer?]) with the goal to create a list for everyone of what works and what doesn't. Throughout the thread it was brought to my attention that there are some things that do work but have major bugs in them that may prevent someone from wanting to even bother with it.

The goal? To put it simply, the goal of this page is to create a quick reference guide for those currently playing to know what works and what doesn't. For those who aren't playing it is meant as an informative page designed to showcase what features of the game currently do and do not work.

Just because something is listed here as not working does not mean it is never going to be implemented, all it means is that it is not currently implemented and could very well be in the works.

So without further ado, here is the list.

== What Works and What Doesn't ==

For reference when scrolling through under each category it will be listed by expansion.

ie. Under Events it will go original content > Zilart > Promathia > ToAU, etc.

'''Legend:'''
Green writing = Working

Orange writing = Working, with bugs

Red writing = Not working

Black writing = unconfirmed

----

=== Avatars ===

Carbuncle

Garuda

Ifrit

Leviathan

Ramuh

Shiva

Titan

Fenrir

Diabolos

Alexander

Odin

Note: Astral Flow and merit pacts are not implemented.
----

=== Besieged ===

Not implemented.

----

=== Events ===

For clarification, what is listed here is what would be classified as a Linkshell event in retail, or anything you may need a group to accomplish.

==== Dynamis ====
Timeless hourglasses are not required.

Dynamis - Bastok

Dynamis - San d'Oria

Dynamis - Windurst

Dynamis - Jeuno -- Megaboss issues may not be corrected yet, some mobs do not aggro/link.

Dynamis - Beaucedine -- Needs testing for confirmation.

Dynamis - Xarcabard -- Needs testing for confirmation.

Dynamis - Buburimu

Dynamis - Qufim

Dynamis - Valkurm

Dynamis - Tavnazia

Relic System -- Unequip and re-equip stage 4 relics for the WS to show up in Dynamis.

==== High Notorious Monsters (HNM) ====

Adamantoise

Aspidochelone

Behemoth

King Behemoth

Fafnir

Nidhogg

Vrtra

Absolute Virtue -- If by "works" you mean "spawnable and has some incorrect TP moves."

Jormungand

Tiamat

==== Sky Gods ====

Byakko

Genbu

Seiryu

Suzaku

Kirin

==== Jailers ====

Need testing

Jailer of Faith

Jailer of Prudence

Jailer of Temperance

Jailer of Hope

Jailer of Fortitude

Jailer of Justice

Jailer of Love

==== Limbus ====

===== Apollyon =====

NW Apollyon

SW Apollyon

NE Apollyon

SW Apollyon

CS Apollyon

Central Apollyon

===== Temenos =====

W Temenos

N Temenos

E Temenos

Central Temenos

Basement

1st Floor

2nd Floor

3rd Floor

4th Floor

Working

Working with Bugs

Not Working

==== Assault ====
{|class="wikitable zebra"
!Rank!!colspan = "6"|Assaults
|-
|Private Second Class||Leujaoam Cleansing||Imperial Agent Rescue||Excavation Duty||Seagull Grounded||Golden Salvage||Nyzul Isle Investigation
|-
|-
|Private Fist Class||Rank Up Quest||Orichalcum Survey||Preemptive Strike||Lebros Supplies||Requiem||Lamia No. 13
|-
|-
|Superior Private||Rank Up Quest||Escort Professor Chanoix||Sagelord Elimination||Troll Fugitives||Saving Private Ryaaf||Extermination
|-
|-
|Lance Corporal||Rank Up Quest||Shanarha Grass Conservation||Breaking Morale||Evade and Escape||Shooting Down the Baron||Demolition Duty
|-
|-
|Corporal||Rank Up Quest||Counting Sheep||The Double Agent||Siegemaster Assassination||Building Bridges||Searat Salvation
|-
|-
|Sergeant||Rank Up Quest||Supplies Recovery||Imperial Treasure Retrieval||Apkallu Breeding||Stop the Bloodshed||Apkallu Seizure
|-
|-
|Sergeant Major||Rank Up Quest||Azure Experiments||Blitzkrieg||Wamoura Farm Raid||Defuse the Threat||Lost and Found
|-
|-
|Chief Sergeant||Rank Up Quest||Imperial Code||Marids in the Mist||Egg Conservation||Operation: Snake Eyes||Deserter
|-
|-
|Second Lieutenant||Rank Up Quest||Red Versus Blue||Azure Ailments||Operation: Black Pearl||Wake the Puppet||Desperately Seeking Cephalopods
|-
|-
|First Lieutenant||Rank Up Quest||Bloody Rondo||The Susanoo Shuffle||Better Than One||The Price is Right||Bellerophon's Bliss
|-
|-
|Captain||Rank Up Quest
|-
|}

==== Salvage ====

Arrapago Remnants

Silver Sea Remnants

Zhayolm Remnants

Bhaflau Remnants

==== ZNM ====

Many can be spawned. Most do not have correct AI/spell lists, are completely missing their TP moves, or both.

===== Tier I =====

Chamrosh

Cheese Hoarder Gigiroon

Vulpangue

Brass Borer

Claret

Ob

Chigre

Lil' Apkallu

Velionis

===== Tier II =====

Iriri Samariri

Iriz Ima

Lividroot Amooshah

Anantaboga

Dextrose

Reacton

Verdelet

Wulgaru

Zareehkl the Jubilant

===== Tier III =====

Armed Gears

Dea

Gotoh Zah the Redolent

Achamoth

Khromasoul Bhurborlor

Nosferatu

Experimental Lamia

Mahjlaef the Paintorn

Nuhn

===== Tier IV =====

Tinnin

Sarameya

Tyger

===== Tier V =====

Pandemonium Warden

----

===BCNM / KSNM / ENM / ISNM===

BCNM 100% works = Green 
BCNM Working with Bugs or needs testing = Orange 
BCNM don't work (reason)= Red 
BCNM not implemented = Black 

Notes 
1-Many drop rates missing on ffxiclopedia 
2-We cannot yet see multiple battle choices for the same orb 

====Ghelsba Outpost====
BCNM: Wings of Fury 
BCNM: Petrifying Pair - works but no loot 
BCNM: Toadal Recall - No Loot, Will not show on battle list yet 
Mission: Save the Children 
DRG flag: The Holy Crest 
Fellow: Mirror, Mirror 

====Waughroon Shrine====
BCNM: Crustacean Conundrum 
BCNM: Birds of a Feather 
BCNM: Grove Guardians 
BCNM: Royal Jelly 
BCNM: The Worm's Turn 
BCNM: The Final Bout 
BCNM: 3, 2, 1... 
BCNM: Up in Arms 
BCNM: Grimshell Shocktroopers 
KSNM: Copycat 
KSNM: Operation Desert Swarm 
KSNM: Prehistoric Pigeons - works but no loot (missing drops rates on ffxiclopedia) 
KSNM: The Hills Are Alive 
Mission: Journey Abroad 
Mission: The Three Kingdoms 
Mission: On My Way 
SAMAF3:A Thief in Norg!? 
Limit: Shattering Stars (Beastmaster) 
Limit: Shattering Stars (Red Mage) 
Limit: Shattering Stars (Thief) 
Limit: Beyond Infinity 

====Horlais Peak====
BCNM: Shooting Fish 
BCNM: Carapace Combatants 
BCNM: Dropping Like Flies 
BCNM: Under Observation 
BCNM: Tails of Woe 
BCNM: Eye of the Tiger 
BCNM: Hostile Herbivores 
BCNM: Shots in the Dark 
BCNM: Dismemberment Brigade 
KSNM: Horns of War 
KSNM: Contaminated Colosseum 
KSNM: Double Dragonian 
BCNM: Today's Horoscope 
Mission: The Emissary 
Mission: The Three Kingdoms 
Mission: The Secret Weapon 
Limit: Shattering Stars (Black Mage) 
Limit: Shattering Stars (Ranger) 
Limit: Shattering Stars (Warrior) 
Limit: Beyond Infinity 

====Balga's Dais====
BCNM: Charming Trio 
BCNM: Creeping Doom 
BCNM: Harem Scarem 
BCNM: Royal Succession 
BCNM: Steamed Sprouts 
BCNM: Rapid Raptors 
BCNM: Treasure and Tribulations 
BCNM: Wild Wild Whiskers 
BCNM: Divine Punishers 
KSNM: Moa Constrictors 
KSNM: Royale Ramble 
KSNM: Seasons Greetings 
KSNM: Early Bird Catches the Wyrm 
Mission: Journey Abroad 
Mission: The Emissary 
Mission: Saintly Invitation 
Limit: Shattering Stars (Monk) 
Limit: Shattering Stars (Summoner) 
Limit: Shattering Stars (White Mage) 
Limit: Beyond Infinity 

====Qu'Bia Arena====
BCNM: Die by the Sword 
BCNM: Let Sleeping Dogs Die 
BCNM: Undying Promise 
BCNM: Factory Rejects 
BCNM: An Awful Autopsy 
BCNM: Idol Thoughts 
BCNM: Celery 
BCNM: Brothers D'Aurphe 
BCNM: Demolition Squad 
KSNM: Come Into My Parlor 
KSNM: E-vase-ive Action 
KSNM: Infernal Swarm 
Mission: Darkness Rising 
Mission: The Ruins of Fei'Yin 
Mission: The Final Seal 
Mission: The Heir to the Light 
Mission: Those Who Lurk in Shadows (III) 
Limit: Shattering Stars (Bard) 
Limit: Shattering Stars (Dark Knight) 
Limit: Shattering Stars (Paladin) 
Limit: A Furious Finale (Dancer) 
Limit: Beyond Infinity 
Fellow: Mirror Images 
Fellow: Clash of the Comrades 

====Talacca Cove====

ISNM: Call to Arms 
ISNM: Compliments to the Chef 
Mission: Legacy of the Lost 
PUPAF3: Puppetmaster Blues 
Limit: Breaking the Bonds of Fate (Corsair) 

====Navukgo Execution Chamber====

ISNM: Tough Nut to Crack 
ISNM: Happy Caster 
Mission: Shield of Diplomacy 
BLUAF2: Omens 
Limit: Achieving True Power (Puppetmaster) 

====Jade Sepulcher====

ISNM: Making a Mockery 
ISNM: Shadows of the Mind 
Mission: Puppet in Peril 
Quest: Moment of Truth 
Limit: The Beast Within (Blue Mage) 

====Spire of Dem====

ENM: You Are What You Eat 
Mission: Ancient Flames Beckon -- Animas do not work 

====Spire of Holla====

ENM: Simulant 
Mission: Ancient Flames Beckon -- Animas do not work 

====Spire of Mea====

ENM: Playing Host 
Mission: Ancient Flames Beckon -- Animas do not work 

====Spire of Vahzl====

ENM: Pulling the Plug 
Mission: Desires of Emptiness --No boss scripts 

====Monarch Linn====

ENM: Bad Seed 
ENM: Fire in the Sky 
ENM: Beloved of the Atlantes 
ENM: Bugard in the Clouds 
Mission: Ancient Vows -- No TP moves, damage and delay do not change 
Mission: The Savage -- Does not fly, does not surrender early. 
Quest: Uninvited Guests 

====The Shrouded Maw====

ENM: Test Your Mite 
Mission: Darkness Named -- Some floors look solid but are not. 
Avatar: Waking Dreams 

====Mine Shaft #2716====

ENM: Bionic Bug 
ENM: Automaton Assault 
ENM: Pulling the Strings 
Mission: A Century of Hardship 
Quest: Return to the Depths 

====Boneyard Gully====

ENM: Like the Wind 
ENM: Sheep in Antlion's Clothing 
ENM: Shell We Dance? 
ENM: Totentanz 
Mission: Head Wind 
Quest: Tango with a Tracker 
Quest: Requiem of Sin 

====Bearclaw Pinnacle====

ENM: Brothers 
ENM: Follow the White Rabbit 
ENM: Holy Cow 
ENM: When Hell Freezes Over 
Mission: Flames for the Dead 

=== Jobs ===

I will create a more extensive list on this at a later time, including what AF quests work and what do not however for now it will just be what jobs are functional and what are not.

==== Base Jobs ====

Warrior

Monk
:* Footwork needs some work
:* Weapon skills return incorrect TP

White Mage

Black Mage

Red Mage 

Thief

==== Advanced Jobs ====

Paladin
:* Rampart is not implemented
:* Cover is not implemented

Dark Knight

Beastmaster
:* Charm Functions some what but there are still bugs.
:* Pet enhancing gear does not work.
:* Issues with Heel and correct pet behavior.
:* Pets use incorrect TP moves.

Ranger

Bard
:* This job needs to be torn out at the roots and rebuilt from scratch.

Summoner
:* No Astral Flow
:* Pet enhancing gear doesn't work
:* No Elemental Siphon
:* No Avatar's Favor

Samurai

Ninja

Dragoon
:* Wyvern attacks on engage.
:* Healing Breath does not heal allies.
:* Status removal breaths are not implemented.
:* Most pet enhancing gear doesn't work (enhances wyvern breath gear works)
:* Super Jump not implemented.
:* Spirit Surge not implemented.

Blue Mage
:* Spell learning is a flat, 25% chance if your level is within 7 of the enemy's. Skill plays no factor.
:* Many spells do no damage currently, however it is possible to skill up the magic skill to have ready for when everything is working.
:* Abilities do not work.
:* Work in progress.

Puppetmaster

Corsair
:* No Random Deal, Wild Card, merit JAs

Dancer
:* Quest is available.
:* Waltzes function, formulas may be off/incorrectly lacking a cap.
:* Drain and Aspir Sambas... sort of work. Haste Samba is a wreck.

Scholar
:* Lacks Modus Veritas.
:* Light Arts/Dark Arts do not grant skill bonus, but they will increase the cap.
:* No Enlightenment, Altruism, Focalization, Tranquility, Equanamity yet

----

=== Weapon Skills ===

Most should work up to relic level, and the formulas in use match those accepted as correct by retail players. While there are reports of damage being low, no one finds issues with the formulas, so research is necessary to find out what's actually wrong.

WSNM quests are not implemented, and the weapon skills are automatically gained.

Exceptions:

:* Magic-based weapon skills currently use a physical formula, and will be calculated as physical damage

:* Monk WSs do not return TP correctly. The second hit should return a punch worth of TP when it lands, rather than 1.

:* Energy Steal and Energy Drain were never really finished. They do static damage, and may not restore MP.

:* Spirits Within may be using an older, incorrect formula.

----

=== Merits ===

As merits gain functionality this list will be updated with specifics as to which particular merits work and which do not.

==== General Merit Point Categories ====

HP/MP

Attributes

Combat Skills

Magic Skills

Others

Weapon Skills

==== Job-Specific Merit Point Categories ====

Warrior Group 1, Group 2
:* Group 1 merits are working.
:* Warrior's Charge is working.

Monk Group 1, Group 2
:* Group 1 merits are working.
:* Formless Strikes (Group 2) works.
:* Mantra is working.

White Mage Group 1 and 2
:* Divine Seal recast merits - Group 1

Black Mage Group 1 and 2

Red Mage Group 1 and 2
:* Convert recast merits work

Thief Group 1 and 2
:* Assassin's Charge works

Paladin Group 1 and 2

Dark Knight Group 1 and 2
:* Got some love from kjLotus, uncertain what was done.

Beastmaster Group 1 and 2

Bard Group 1 and 2

Ranger Group 1 and 2

Summoner Group 1 and 2

Samurai Group 1 and 2
:* Store TP merits work
:* Meditate recast down works
:* Overwhelm works

Ninja Group 1 and 2

Dragoon Group 1 and 2
:* Recast merits should be working. Deep Breathing has been added. Empathy will allow you to use Spirit Link at full wyvern HP, but will copy no status effects.

Blue Mage Group 1 and 2

Corsair Group 1 and 2

Puppetmaster Group 1 and 2

Dancer Group 1 and 2

Scholar Group 1 and 2
:* Enlightenment, Altruism, Focalization, Tranquility, Equanamity not yet functional

----

=== Missions ===

All nation missions currently work up to rank 6 and therefore will be marked as green, as it does not hinder any game play to not be able to go further than that.

Bastok -- Rank 7

San d'Oria -- Rank 8?

Windurst

Rise of the Zilart
- Implemented up through Ark Angels and The Sealed Shrine. The final BCNM (The Celestial Nexus) and the cutscenes afterward are all that remain.

Chains of Promathia
- Works up to Promyvion - Vahzl, but many behaviors need improvement.

Treasures of Aht Urhgan

Wings of the Goddess

A Crystalline Prophecy: Ode of Life Bestowing

A Moogle Kupo d'Etat: Evil in Small Doses

A Shantotto Ascension: The Legend Torn, Her Empire Born

Visions of Abyssea

Scars of Abyssea

Heroes of Abyssea

Seekers of Adoulin

----

=== Misc ===

Dual-boxing -- Works, but has issues with sessions. Characters can be switched between users on the same IP address when zoning, and players can become stuck. Also, the BCNM system will not allow two users with the same visible IP address to enter a BCNM.

Character Creation -- Recent versions of FFXI-Boot_mod3 (with Ashita) will create characters without issue.

== Conclusion ==

It was my pleasure to bring this list to the Darkstar Project community, and I thank everyone very much for the assistance and reports of functionality. I hope this list can make it to the eyes of numerous potential newcomers and also veteran players on the server.

As of right now this list is incomplete, any feedback on the change of functionality or any missing content please do let me know through the forums via [http://forums.dspt.info/ucp.php?i=pm&mode=compose&u=959 PM] or just go through my [http://forums.dspt.info/memberlist.php?mode=viewprofile&u=959 profile page]

Configuring Your Client

2013-07-28T17:43:16Z

Lautan:

Configuring Your Client

2013-07-28T17:19:46Z

Lautan:

Building the Server

2013-07-28T16:02:26Z

Lautan: /* Configure the ZoneIP for the Map Server */

== 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] (flag)

[http://70.226.47.159/downloads.php Navicat Lite] (flag)

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

[http://www.microsoft.com/en-us/download/details.aspx?id=23691 Visual Studio Service Pack 1]

[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]

=== Installation ===

==== MySql ====
(flag)

Choose Typical Installation

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

Select Detailed Configuration

Select Developer Machine

Select Multi-functional 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 ====
(flag)

Use default installation options.

==== Visual Studio 2010 ====

Use the default installation options. You may be forced to restart (sometimes twice) during the installation.
You should have Visual Studio Service Pack 1 (requiring another restart). It depends on your OS.

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

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 bat script ====

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

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

<pre>
@ECHO OFF
REM =============================================================================
REM =============================================================================
REM ====== =========
REM ====== THis script will drop the DB specificed, then create the DB =========
REM ====== specified, and then load all .sql tables from its run dir to =========
REM ====== the the DB. =========
REM ====== =========
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 ====== Update -p with MySQL password. If you password is 'foo', =========
REM ====== then change '-pMYSQLPASS' to '-pfoo' (3 places). =========
REM ====== =========
REM ====== If you want to use a different database name, change 'dspdb' =========
REM ====== with a database name of your choosing. =========
REM ====== =========
REM =============================================================================
REM =============================================================================
REM ====== =========
REM ====== by Thrydwolf 9/8/2012 =========
REM ====== Updated with status by bluekirby0 3/30/2012 =========
REM ====== Updated by Thrydwolf 9/18/2012 =========
REM ====== =========
REM =============================================================================
REM =============================================================================

ECHO Creating Database dspdb
mysqladmin -h localhost -u root -pMYSQLPASS DROP dspdb

ECHO Creating Database dspdb
mysqladmin -h localhost -u root -pMYSQLPASS CREATE dspdb

ECHO Loading dspdb with tables
REM FOR %%X IN (*.sql) DO mysql dspdb -h localhost -u root -pMYSQLPASS < %%X
FOR %%X IN (*.sql) DO ECHO Importing %%X & mysql dspdb -h localhost -u root -pMYSQLPASS < %%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 ====
(flag)

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>
DELETE FROM `accounts_banned` WHERE `accid` = OLD.id;
DELETE FROM `chars` WHERE `accid` = OLD.id;
</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>
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;
</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.

1. 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. (Looks really random 173.194.43.104)

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.

2. 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. '''If you use the site you must put the IP in reverse order''' to get the required value (i.e. instead of 127.0.0.1 which gives 2130706433 put in 1.0.0.127 to get 16777343).

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

(flag)
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>
UPDATE zone_settings SET zoneip = '16777343';
</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.

==== 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 (flag)
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 (flag)
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 (flag)
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>
TCP Ports:
54230
54231
54001
54002

UDP Port:
54230
</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 ==

The server is known to build in recent [http://www.debian.org/ Debian] GNU/Linux, [http://www.ubuntu.com/ Ubuntu], and [http://fedoraproject.org/ Fedora] versions, and is tested regularly against all three platforms. It is also known to build on [http://www.gentoo.org/ Gentoo].

Fedora-specific instructions may be found on the page: [[Fedora Linux Setup]]

Generic build instructions for most POSIX (GNU/Linux, and possibly FreeBSD, NetBSD, UNIX or even OSX with some additional work) systems follow. Some knowledge of how to compile software on your distribution is assumed. You may find it helpful to reference the Windows guide above if something is unclear.

=== Prerequisites: ===
A compiler with C++11 support. Currently tested with GCC and G++, and requires a minimum version of 4.6

Subversion to retrieve the source code.

patch to apply the search server patch (should be installed with subversion if your system lacks it)

Autotools (automake autoconf m4sh) and pkg-config to generate the configure script and Makefile

mysql server

mysql client library (select the developer version if your distro has one)

lua library version 5.1 or higher (select the developer version if your distro has one)

If you plan to run from a console, you may also wish to install "screen" as there is no daemon mode for the servers yet.

=== Preparing the Source Code ===

Once you have everything mentioned above installed, grab the latest source from the repository via the command:
<nowiki>svn co http://onetimexi.googlecode.com/svn/trunk/ dsp/</nowiki>

Now, find the latest version of the search server patch at [http://forums.dspt.info/viewtopic.php?f=11&t=38 The Darkstar Project Forums]. Extract the diff file into the dsp folder and apply it using the command:
patch -p0 -i dssearchv6.diff

=== Compiling ===

Next is a typical autotools build. Run the autogen script, followed by configure, and then make:
sh autogen.sh
./configure --enable-debug
make

You can choose not to configure with debug enabled, but there is very little potential gain in this and it prevents many useful break statements from triggering. The Makefile also has separate targets to build each server named "dsconnect" "dsgame" and "dssearch" but will build all 3 if none are specified.

=== Compiling on 64-bit ===
These steps were done on Ubuntu 12.04.
First you need to install the relevant packages:
sudo apt-get install libc-dev-i386
sudo apt-get install g++-multilib
sudo apt-get install libmysqlclient-dev:i386
sudo apt-get install liblua5.1-dev:i386

You'll note that these are 32-bit packages which are needed to build in 32-bit mode.
If you already have the 64-bit mysql client libraries already installed, you have to uninstall them. Sadly the 32-bit version and 64-bit version can not coexist. NOTE: This is not advised if you have applications relying on the sql libraries!
In order to get rid of it you can do:
sudo apt-get remove --purge libmysqlclient-dev

At this point you should be all set up but there is one more thing that needs to be addressed. The source is looking for a liblua.so library which didn't exist from the liblua5.1 installation. To manually set it up do:
cd /usr/lib/i386-linux-gnu/
sudo ln -s liblua5.1.so liblua.so

Now the environment is set up so you can run the configure script. We have to force it into 32-bit mode using CPPFLAGS and CXXFLAGS:
CPPFLAGS=-m32 CXXFLAGS=-m32 ./configure
make

At this point it should complete the build and you can continue on to the next section.

=== Setting Up the Database ===

If you do not know your mysql root password, the default on most systems is blank. It is a good idea to change this for security reasons, as your mysql root user has full permissions on all databases. The first time you run the mysql client, you should be prompted to change the password. After doing so, you will want to create a user specifically for dealing with the darkstar server database. Run mysql as follows:
mysql -u root -p

Enter your root password at the prompt. Next, create a new user as follows:
CREATE USER 'darkstar'@'localhost' IDENTIFIED BY 'password';

Substitute "password" with a password of your choice. Next, we want to create a database, and set up our new user with permissions to work with it.
CREATE DATABASE dspdb;
USE dspdb;
GRANT ALL PRIVILEGES ON dspdb.* TO 'darkstar'@'localhost';
exit

This will make it to where your new user can do anything necessary, but can only connect from localhost, so even if your password is compromised, it will be difficult to mess with the database remotely. If you need to be able to access the database remotely (like if the database is stored on a separate machine from the server), change the configuration according to the host that will be accessing the database.

Now, you need to populate the database.
cd sql
for f in *.sql
do
echo -n "Importing $f into the database..."
mysql dspdb -u darkstar -ppassword < $f && echo "Success"
done
cd ..

To set up your ZoneIP, see the related windows section [[Building_the_Server#Configure_the_ZoneIP_for_the_Map_Server]] above for how to calculate it, and then run:
mysql -u darkstar -ppassword
USE dspdb;
UPDATE zone_settings SET zoneip = '16777343';
exit

replacing "16777343" with the value you determined in your calculation. You should see a message that 256 changes have occured after the update command.

=== Configuring the Server ===
Before running your new servers, you will need to update the configuration files to tell it how to talk to the database. You will need to update the files in the conf/ sub-folder named "login_darkstar.conf" "map_darkstar.conf" and "search_server.conf" at a minimum. Find the mysql settings in each and change as appropriate, using the new user, password and database you created earlier.

You may also wish to browse through the various configuration files for any settings that might be of interest to you, but more details on server customization can be found at [[Customizing Your Server]].

=== Starting the Servers ===
You may now start your new servers. If you are using a desktop environment, you may wish to open 3 separate terminals and run each server in a separate one to monitor them efficiently. Otherwise, you will want to run them in screen sessions as follows:
screen -d -m -S dsconnect ./dsconnect
screen -d -m -S dsgame ./dsgame
screen -d -m -S dssearch ./dssearch

This will start and auto-detach all three servers, assigning them meaningful names to make it easy to reattach later by using the commands:
screen -r dsconnect

or
screen -r dsgame

or
screen -r dssearch

to monitor a given server. Once you've attached to a screen, you can detach by first pressing "ctrl+a" and then "d". There are many other useful ways to use screen, so do whatever suits yoru preference.

Your server is now up-and-running, and a client should be able to connect as long as there are no obvious errors on any of the server screens. If the search server is having issues, it is not vital for basic game functionality, but you will be unable to use search functions or the auction house. If you have run into any major issues, contact bluekirby0 (the current maintainer of the linux port as of the time of this writing) on IRC #darkstarproject@irc.rizon.net or in the [http://forums.dspt.info forums].

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