DSP Wiki - User contributions [en]

How to Add TP Moves

2013-05-16T19:26:18Z

PrBlah:

A quick and dirty "how to" on making TP Moves. Understanding of the basics will be assumed.

==Mob Skill Table==
'''mob_skill_id''' -- The message to be displayed when the TP move is used. See /documentation/monster_tp_movies.txt for a list.

'''family_id''' -- The mob family you're adding the TP move to.

'''mob_anim_id''' -- The animation ID for the TP move.

'''mob_skill_aoe''' -- AoE characteristics. 0 = none, 1 = circular, 2 = circle around the target, 3 = ???, 4 = frontal cone

'''mob_skill_distance''' -- How far away can it hit? This is both range for single target, and how large the AoE is for AoE attacks.

'''mob_anim_time''' -- How long the animation will take to execute. 2000 = 2 seconds. Due to DSP limitations, values that are not multiples of 500 are kind of pointless. That being said, don't mess with other TP moves if you don't know why they're the way they are.

'''mob_prepare_time''' -- How long the mob "prepares" the TP move. 1000 is fairly standard, 0 is instant use.

'''mob_valid_targets''' -- What can be targeted? Likely uses the same values as spells, making 1 = self and 4 = enemy.

'''mob_skill_flag''' -- Certain TP moves like Fomor attacks are done a little differently, since they're actually weaponskills. Set this to 1 if that's the case.

==Script File Structure==

'''OnMobSkillCheck''' -- Used for logic on TP moves, such as "Spike Flail is only used if the target is behind the dragon." return 0 if all is okay, return 1 to block the TP move. Useful during testing to force your new move to be used by disabling anything else.

'''OnMobWeaponSkill''' -- Used to determine damage and effects. Typically you will want to route through one of the functions in /scripts/global/monstertpmoves.lua. Tear apart similar moves if you're not sure which functions to use. This is where you'll be tuning in the damage. For example:
<pre>
function OnMobWeaponSkill(target, mob, skill)
local numhits = 1;
local accmod = 1;
local dmgmod = 5;
typeEffect = EFFECT_AMNESIA;
local info = MobPhysicalMove(mob,target,skill,numhits,accmod,dmgmod,TP_NO_EFFECT);
local dmg = MobFinalAdjustments(info.dmg,mob,skill,target,MOBSKILL_RANGED,MOBPARAM_SLASH,info.hitslanded);

dmg = dmg * ((50 - mob:checkDistance(target)) / 50);

MobStatusEffectMove(mob, target, typeEffect, 1, 0, 120);

target:delHP(dmg);
return dmg;
end;
</pre>
Here you have a single-hit TP move doing Physical Damage and obeying all the standard damage adjustments and shadow behavior in MobFinalAdjustments. An additional line was added to change the damage based on range from the mob, and an Amnesia effect was added for the sake of the example. Also note info.hitslanded being used to remove 1 shadow per hit landed. dmgmod 5 will make the move quite potent, and values below 3 will be more common.

'''Always:'''
<pre>
require("/scripts/globals/settings");
require("/scripts/globals/status");
require("/scripts/globals/monstertpmoves");
</pre>

==Finding the Animation==

You'll need a GM account. Find the mob that should have the TP move, and engage it. Both your character and the mob need to be "in combat" for this to work, but you don't have to be hitting the mob. @godmode or a Judge's Ring might be useful, since you might be here a while. You'll be using a GM command:

@injectaction 11 ''animation_value''

'''animation_value''' is the value you'll need for '''mob_anim_id''' in the mob_skill table. The animations are in roughly the same order as the ones found in /documentation/monster_tp_movies.txt, but note that the values will ''not'' necessarily be the same. You'll also see TP move messages in your text log, but these do not represent the actual move for that animation ID.

You won't always be using "11" for the second value, but if you should be using something else, then you'll understand what it means.

If it's not clear, you're going to have to make a roughly educated guess on animation_value, and then work up and down from there based on what you find. There's a few notes in /documentation/monster_tp_animations.txt as well.

==Closing Tips==

- The moves will probably be in the same general range as their message/mob_skill_id value, but offset slightly.

- '''Always''' check which mobs belong to the family you'll be adding the move to. It's just plain good practice. There's nothing quite like giving Maat his 2hr and having Mammets pop Mighty Strikes. If you don't check, it will probably come back to bite you.

- YouTube is your friend for checking animations and getting some reliable damage numbers, but be prepared for bad video editing and terrible taste in music. While FFXIclopedia has damage estimates, these estimates are often only vaguely accurate.

- Unless it has been fixed, the breath damage formula will be hard to work with, and does not curve nearly the way you'd like it to. Accept it, or figure out a better one.

Main Page

2013-05-16T19:23:34Z

PrBlah:

'''Welcome to the Unofficial Dark Star Project Wiki'''

== Getting Started ==

[[Building the Server]]

[[Configuring Your Client]]

[[DarkStar Servers]]

[[Script Testing Server]]

== General Reference links ==
[[GM Commands]]

[[ID References]]

[[What Works]]

[[Database]]

== Developer Reference links ==
[[Quests]]

[[Missions]]

[[Core]]

[[Server Data Flow]]

== FAQs/Tutorials ==
[[Make My Character a GM]]

[[Troubleshooting Guide]]

[[Customizing Your Server]]

[[How to Make a Quest]]

[[How to Add an Item]]

[[How to Add TP Moves]]

== Things that need to be added ==

You can always look at the list of [[Special:WantedPages]] and see if you can clear some of those out by filling in the information

Reference tables (any table that might need to be referenced often)

Source Code documentation (mainly public function documentation and how to communicate between lua scripts and the server)

Checklists for things that are and are not implemented (Eventually I would like to create goal pages that use these checklists, so if you can categorize things in a logical manner, that would be very helpful)

Anything else you can think of that might be helpful for either casual users or developers interested in Dark Star Project.

== Other ==
[http://{{SERVERNAME}}:8765/bak/ Automatically generated wiki backups]

<pre style="display: none"><nowiki>[http://www.dracomiconia.com/proprietary.php?option=2 donotvisitthislinkoryouwillbeblocked]</nowiki></pre>

How to Add TP Moves

2013-05-16T19:22:54Z

PrBlah:

A quick and dirty "how to" on making TP Moves. Understanding of the basics will be assumed.

==Mob Skill Table==
'''mob_skill_id''' -- The message to be displayed when the TP move is used. See /documentation/monster_tp_movies.txt for a list.

'''family_id''' -- The mob family you're adding the TP move to.

'''mob_anim_id''' -- The animation ID for the TP move.

'''mob_skill_aoe''' -- AoE characteristics. 0 = none, 1 = circular, 2 = circle around the target, 3 = ???, 4 = frontal cone

'''mob_skill_distance''' -- How far away can it hit? This is both range for single target, and how large the AoE is for AoE attacks.

'''mob_anim_time''' -- How long the animation will take to execute. 2000 = 2 seconds. Due to DSP limitations, values that are not multiples of 500 are kind of pointless. That being said, don't mess with other TP moves if you don't know why they're the way they are.

'''mob_prepare_time''' -- How long the mob "prepares" the TP move. 1000 is fairly standard, 0 is instant use.

'''mob_valid_targets''' -- What can be targeted? Likely uses the same values as spells, making 1 = self and 4 = enemy.

'''mob_skill_flag''' -- Certain TP moves like Fomor attacks are done a little differently, since they're actually weaponskills. Set this to 1 if that's the case.

==Script File Structure==

'''OnMobSkillCheck''' -- Used for logic on TP moves, such as "Spike Flail is only used if the target is behind the dragon." return 0 if all is okay, return 1 to block the TP move. Useful during testing to force your new move to be used by disabling anything else.

'''OnMobWeaponSkill''' -- Used to determine damage and effects. Typically you will want to route through one of the functions in /scripts/global/monstertpmoves.lua. Tear apart similar moves if you're not sure which functions to use. This is where you'll be tuning in the damage. For example:
<pre>
function OnMobWeaponSkill(target, mob, skill)
local numhits = 1;
local accmod = 1;
local dmgmod = 5;
typeEffect = EFFECT_AMNESIA;
local info = MobPhysicalMove(mob,target,skill,numhits,accmod,dmgmod,TP_NO_EFFECT);
local dmg = MobFinalAdjustments(info.dmg,mob,skill,target,MOBSKILL_RANGED,MOBPARAM_SLASH,info.hitslanded);

dmg = dmg * ((50 - mob:checkDistance(target)) / 50);

MobStatusEffectMove(mob, target, typeEffect, 1, 0, 120);

target:delHP(dmg);
return dmg;
end;
</pre>
Here you have a single-hit TP move doing Physical Damage and obeying all the standard damage adjustments and shadow behavior in MobFinalAdjustments. An additional line was added to change the damage based on range from the mob, and an Amnesia effect was added for the sake of the example. Also note info.hitslanded being used to remove 1 shadow per hit landed. dmgmod 5 will make the move quite potent, and values below 3 will be more common.

'''Always:'''
<pre>
require("/scripts/globals/settings");
require("/scripts/globals/status");
require("/scripts/globals/monstertpmoves");
</pre>

==Finding the Animation==

You'll need a GM account. Find the mob that should have the TP move, and engage it. Both your character and the mob need to be "in combat" for this to work, but you don't have to be hitting the mob. @godmode or a Judge's Ring might be useful, since you might be here a while. You'll be using a GM command:

@injectaction 11 ''animation_value''

'''animation_value''' is the value you'll need for '''mob_anim_id''' in the mob_skill table. The animations are in roughly the same order as the ones found in /documentation/monster_tp_movies.txt, but note that the values will ''not'' necessarily be the same. You'll also see TP move messages in your text log, but these do not represent the actual move for that animation ID.

You won't always be using "11" for the second value, but if you should be using something else, then you'll understand what it means.

If it's not clear, you're going to have to make a roughly educated guess on animation_value, and then work up and down from there based on what you find. There's a few notes in /documentation/monster_tp_animations.txt as well.

==Closing Tips===

- The moves will probably be in the same general range as their message/mob_skill_id value, but offset slightly.

- '''Always''' check which mobs belong to the family you'll be adding the move to. It's just plain good practice. There's nothing quite like giving Maat his 2hr and having Mammets pop Mighty Strikes. If you don't check, it will probably come back to bite you.

- YouTube is your friend for checking animations and getting some reliable damage numbers, but be prepared for bad video editing and terrible taste in music. While FFXIclopedia has damage estimates, these estimates are often only vaguely accurate.

- Unless it has been fixed, the breath damage formula will be hard to work with, and does not curve nearly the way you'd like it to. Accept it, or figure out a better one.

How to Add TP Moves

2013-05-16T19:21:22Z

PrBlah:

A quick and dirty "how to" on making TP Moves. Understanding of the basics will be assumed.

==Mob Skill Table==
'''mob_skill_id''' -- The message to be displayed when the TP move is used. See /documentation/monster_tp_movies.txt for a list.

'''family_id''' -- The mob family you're adding the TP move to.

'''mob_anim_id''' -- The animation ID for the TP move.

'''mob_skill_aoe''' -- AoE characteristics. 0 = none, 1 = circular, 2 = circle around the target, 3 = ???, 4 = frontal cone

'''mob_skill_distance''' -- How far away can it hit? This is both range for single target, and how large the AoE is for AoE attacks.

'''mob_anim_time''' -- How long the animation will take to execute. 2000 = 2 seconds. Due to DSP limitations, values that are not multiples of 500 are kind of pointless. That being said, don't mess with other TP moves if you don't know why they're the way they are.

'''mob_prepare_time''' -- How long the mob "prepares" the TP move. 1000 is fairly standard, 0 is instant use.

'''mob_valid_targets''' -- What can be targeted? Likely uses the same values as spells, making 1 = self and 4 = enemy.

'''mob_skill_flag''' -- Certain TP moves like Fomor attacks are done a little differently, since they're actually weaponskills. Set this to 1 if that's the case.

==Script File Structure==

'''OnMobSkillCheck''' -- Used for logic on TP moves, such as "Spike Flail is only used if the target is behind the dragon." return 0 if all is okay, return 1 to block the TP move. Useful during testing to force your new move to be used by disabling anything else.

'''OnMobWeaponSkill''' -- Used to determine damage and effects. Typically you will want to route through one of the functions in /scripts/global/monstertpmoves.lua. Tear apart similar moves if you're not sure which functions to use. This is where you'll be tuning in the damage. For example:
<pre>
function OnMobWeaponSkill(target, mob, skill)
local numhits = 1;
local accmod = 1;
local dmgmod = 5;
typeEffect = EFFECT_AMNESIA;
local info = MobPhysicalMove(mob,target,skill,numhits,accmod,dmgmod,TP_NO_EFFECT);
local dmg = MobFinalAdjustments(info.dmg,mob,skill,target,MOBSKILL_RANGED,MOBPARAM_SLASH,info.hitslanded);

dmg = dmg * ((50 - mob:checkDistance(target)) / 50);

MobStatusEffectMove(mob, target, typeEffect, 1, 0, 120);

target:delHP(dmg);
return dmg;
end;
</pre>
Here you have a single-hit TP move doing Physical Damage and obeying all the standard damage adjustments and shadow behavior in MobFinalAdjustments. An additional line was added to change the damage based on range from the mob, and an Amnesia effect was added for the sake of the example. Also note info.hitslanded being used to remove 1 shadow per hit landed. dmgmod 5 will make the move quite potent, and values below 3 will be more common.

'''Always:'''
<pre>
require("/scripts/globals/settings");
require("/scripts/globals/status");
require("/scripts/globals/monstertpmoves");
</pre>

==Finding the Animation==

You'll need a GM account. Find the mob that should have the TP move, and engage it. Both your character and the mob need to be "in combat" for this to work, but you don't have to be hitting the mob. @godmode or a Judge's Ring might be useful, since you might be here a while. You'll be using a GM command:

@injectaction 11 ''animation_value''

'''animation_value''' is the value you'll need for '''mob_anim_id''' in the mob_skill table. The animations are in roughly the same order as the ones found in /documentation/monster_tp_movies.txt, but note that the values will ''not'' necessarily be the same. You'll also see TP move messages in your text log, but these do not represent the actual move for that animation ID.

If it's not clear, you're going to have to make a roughly educated guess on animation_value, and then work up and down from there based on what you find. There's a few notes in /documentation/monster_tp_animations.txt as well.

==Closing Tips===

- The moves will probably be in the same general range as their message/mob_skill_id value, but offset slightly.

- '''Always''' check which mobs belong to the family you'll be adding the move to. It's just plain good practice. There's nothing quite like giving Maat his 2hr and having Mammets pop Mighty Strikes. If you don't check, it will probably come back to bite you.

- YouTube is your friend for checking animations and getting some reliable damage numbers, but be prepared for bad video editing and terrible taste in music. While FFXIclopedia has damage estimates, these estimates are often only vaguely accurate.

- Unless it has been fixed, the breath damage formula will be hard to work with, and does not curve nearly the way you'd like it to. Accept it, or figure out a better one.

How to Add TP Moves

2013-05-16T19:19:40Z

PrBlah: Created page with "A quick and dirty "how to" on making TP Moves. Understanding of the basics will be assumed. ==Mob Skill Table== '''mob_skill_id''' -- The message to be displayed when the T..."

A quick and dirty "how to" on making TP Moves. Understanding of the basics will be assumed.

==Mob Skill Table==
'''mob_skill_id''' -- The message to be displayed when the TP move is used. See /documentation/monster_tp_movies.txt for a list.

'''family_id''' -- The mob family you're adding the TP move to.

'''mob_anim_id''' -- The animation ID for the TP move.

'''mob_skill_aoe''' -- AoE characteristics. 0 = none, 1 = circular, 2 = circle around the target, 3 = ???, 4 = frontal cone

'''mob_skill_distance''' -- How far away can it hit? This is both range for single target, and how large the AoE is for AoE attacks.

'''mob_anim_time''' -- How long the animation will take to execute. 2000 = 2 seconds. Due to DSP limitations, values that are not multiples of 500 are kind of pointless. That being said, don't mess with other TP moves if you don't know why they're the way they are.

'''mob_prepare_time''' -- How long the mob "prepares" the TP move. 1000 is fairly standard, 0 is instant use.

'''mob_valid_targets''' -- What can be targeted? Likely uses the same values as spells, making 1 = self and 4 = enemy.

'''mob_skill_flag''' -- Certain TP moves like Fomor attacks are done a little differently, since they're actually weaponskills. Set this to 1 if that's the case.

==Script File Structure==

'''OnMobSkillCheck''' -- Used to logic on TP moves, such as "Spike Flail is only used if the target is behind the dragon." return 0 if all is okay, return 1 to block the TP move. Useful during testing to force your new move to be used by disabling anything else.

'''OnMobWeaponSkill''' -- Used to determine damage and effects. Typically you will want to route through one of the functions in /scripts/global/monstertpmoves.lua. Tear apart similar moves if you're not sure which functions to use. This is where you'll be tuning in the damage. For example:
<pre>
function OnMobWeaponSkill(target, mob, skill)
local numhits = 1;
local accmod = 1;
local dmgmod = 5;
typeEffect = EFFECT_AMNESIA;
local info = MobPhysicalMove(mob,target,skill,numhits,accmod,dmgmod,TP_NO_EFFECT);
local dmg = MobFinalAdjustments(info.dmg,mob,skill,target,MOBSKILL_RANGED,MOBPARAM_SLASH,info.hitslanded);

dmg = dmg * ((50 - mob:checkDistance(target)) / 50);

MobStatusEffectMove(mob, target, typeEffect, 1, 0, 120);

target:delHP(dmg);
return dmg;
end;
</pre>
Here you have a single-hit TP move doing Physical Damage and obeying all the standard damage adjustments and shadow behavior in MobFinalAdjustments. An additional line was added to change the damage based on range from the mob, and an Amnesia effect was added for the sake of the example. Also note info.hitslanded being used to remove 1 shadow per hit landed. dmgmod 5 will make the move quite potent, and values below 3 will be more common.

'''Always:'''
<pre>
require("/scripts/globals/settings");
require("/scripts/globals/status");
require("/scripts/globals/monstertpmoves");
</pre>

==Finding the Animation==

You'll need a GM account. Find the mob that should have the TP move, and engage it. Both your character and the mob need to be "in combat" for this to work, but you don't have to be hitting the mob. @godmode or a Judge's Ring might be useful, since you might be here a while. You'll be using a GM command:

@injectaction 11 ''animation_value''

'''animation_value''' is the value you'll need for '''mob_anim_id''' in the mob_skill table. The animations are in roughly the same order as the ones found in /documentation/monster_tp_movies.txt, but note that the values will ''not'' necessarily be the same. You'll also see TP move messages in your text log, but these do not represent the actual move for that animation ID.

If it's not clear, you're going to have to make a roughly educated guess on animation_value, and then work up and down from there based on what you find. There's a few notes in /documentation/monster_tp_animations.txt as well.

==Closing Tips===

- The moves will probably be in the same general range as their message/mob_skill_id value, but offset slightly.

- '''Always''' check which mobs belong to the family you'll be adding the move to. It's just plain good practice. There's nothing quite like giving Maat his 2hr and having Mammets pop Mighty Strikes. If you don't check, it will probably come back to bite you.

- YouTube is your friend for checking animations and getting some reliable damage numbers, but be prepared for bad video editing and terrible taste in music. While FFXIclopedia has damage estimates, these estimates are often only vaguely accurate.

- Unless it has been fixed, the breath damage formula will be hard to work with, and does not curve nearly the way you'd like it to. Accept it, or figure out a better one.

What Works

2013-04-04T02:57:34Z

PrBlah:

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

Alexander

Diabolos

Odin

Note: Astral Flow is not implemented at all
----

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

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 sortable 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 flg: 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 

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

White Mage

Black Mage

Red Mage 

Thief

==== Advanced Jobs ====

Paladin
:* Rampart is not implemented

Dark Knight

Beastmaster
:* Charm Functions some what but there are still bugs.
:* Familiar does not.

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

Samurai

Ninja

Dragoon
:* Wyvern attacks on engage, Healing Breath does not heal allies, status removal breaths are not implemented

Blue Mage
:* Spell learning works as intended.
:* Can set spells - However it is possible to set multiple copies of the same spell.
:* Stat bonuses (i.e Wild Oats's CHR+1 and HP+10) doesn't apply to stats.
:* Spells does 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.
:* /BLU does not work.
:* Work in progress.

Puppetmaster

Corsair
:* Quest is available, rolls seem to work.

Dancer
:* Quest is not available.
:* Waltz's function, formulas may be off.
:* Sambas... sort of work.
:* Steps are non-functional
:* Animated Flourish works and requires no steps, the rest are bugged.

Scholar

----

=== Merits ===

"The code that loads them into your character is remarked out right now" - whasf

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.

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

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

Black Mage Group 1 and 2

Red Mage Group 1 and 2

Thief Group 1 and 2

Paladin Group 1 and 2

Dark Knight Group 1 and 2

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

Ninja Group 1 and 2

Dragoon Group 1 and 2

Blue Mage Group 1 and 2

Corsair Group 1 and 2

Puppetmaster Group 1 and 2

Corsair Group 1 and 2

Dancer Group 1 and 2

Scholar Group 1 and 2

----

=== 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
- Currently only works up to the Mission "Gate of the Gods", which is far enough for Sky access.

Chains of Promathia
- Works up to Promyvion - Vahzl

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 -- FFXI-Boot (and by extension) cannot smoothly log in the first time. When the client times out or gets stuck, wait a few minutes before trying again. It may take up to three or four tries for the first login. mXI does not suffer from this problem, but has trouble with excessive CPU usage over time. Ashita along with FFXI-Boot Mod 3 should correct this problem, and are recommended.

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

What Works

2013-04-04T02:56:23Z

PrBlah:

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

Alexander

Diabolos

Odin

Note: Astral Flow is not implemented at all
----

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

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 sortable 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
|-
|-
|First Lieutenant||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 flg: 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 

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

White Mage

Black Mage

Red Mage 

Thief

==== Advanced Jobs ====

Paladin
:* Rampart is not implemented

Dark Knight

Beastmaster
:* Charm Functions some what but there are still bugs.
:* Familiar does not.

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

Samurai

Ninja

Dragoon
:* Wyvern attacks on engage, Healing Breath does not heal allies, status removal breaths are not implemented

Blue Mage
:* Spell learning works as intended.
:* Can set spells - However it is possible to set multiple copies of the same spell.
:* Stat bonuses (i.e Wild Oats's CHR+1 and HP+10) doesn't apply to stats.
:* Spells does 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.
:* /BLU does not work.
:* Work in progress.

Puppetmaster

Corsair
:* Quest is available, rolls seem to work.

Dancer
:* Quest is not available.
:* Waltz's function, formulas may be off.
:* Sambas... sort of work.
:* Steps are non-functional
:* Animated Flourish works and requires no steps, the rest are bugged.

Scholar

----

=== Merits ===

"The code that loads them into your character is remarked out right now" - whasf

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.

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

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

Black Mage Group 1 and 2

Red Mage Group 1 and 2

Thief Group 1 and 2

Paladin Group 1 and 2

Dark Knight Group 1 and 2

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

Ninja Group 1 and 2

Dragoon Group 1 and 2

Blue Mage Group 1 and 2

Corsair Group 1 and 2

Puppetmaster Group 1 and 2

Corsair Group 1 and 2

Dancer Group 1 and 2

Scholar Group 1 and 2

----

=== 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
- Currently only works up to the Mission "Gate of the Gods", which is far enough for Sky access.

Chains of Promathia
- Works up to Promyvion - Vahzl

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 -- FFXI-Boot (and by extension) cannot smoothly log in the first time. When the client times out or gets stuck, wait a few minutes before trying again. It may take up to three or four tries for the first login. mXI does not suffer from this problem, but has trouble with excessive CPU usage over time. Ashita along with FFXI-Boot Mod 3 should correct this problem, and are recommended.

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

Items

2013-04-02T06:12:23Z

PrBlah:

==item_basic==

Stores basic item information that is common to all items. For an item to exist, it must have an entry in this table.

'''item_id''' should match what is found in POLUtils or on ffxiah.com

'''name''' is the long name of an item, such as flask_of_echo_drops. If you're scripting a file, this is the file name you should use.

'''sortname''' is the shortened name, such as echo_drops.

'''stackSize''' determines if an item should stack, and how many should stack. The client acts a bit odd if you stack items that aren't supposed to be stacked, but generally will let you stack things like Frozen Giant Skulls if you want to improve the Dynamis experience, for example.

'''flags''' needs to be investigated. Likely handles rare/ex and other behavior.

'''aH''' is the auction house category for the item.

'''NoSale''' determines if the item can be sold.

'''BaseSell''' is the value of the item when selling to an NPC, before fame modifier.

==item_armor==

Stores information regarding anything that can be worn; armor, accessory, and weapons, too.

'''itemId''' matches what is found in item_basic.

'''name''' needs to be investigated. Just for readability's sake?

'''level''' is what level the item can be equipped at.

'''jobs''' determines what jobs can equip the item, stored as a bitmask. Simply add the values together to set the jobs. WAR (1) + PLD (64) + DRK (128) = 193

{|class="wikitable sortable zebra"
!Value!!Job
|-
|1||warrior
|-
|-
|2||monk
|-
|-
|4||white mage
|-
|-
|8||black mage
|-
|-
|16||red mage
|-
|-
|32||thief
|-
|-
|64||paladin
|-
|-
|128||dark knight
|-
|-
|256||beastmaster
|-
|-
|512||bard
|-
|-
|1024||ranger
|-
|-
|2048||samurai
|-
|-
|4096||ninja
|-
|-
|8192||dragoon
|-
|-
|16384||summoner
|-
|-
|32768||blue mage
|-
|-
|65536||corsair
|-
|-
|131072||puppetmaster
|-
|-
|262144||dancer
|-
|-
|524288||scholar
|-
|-
|1048576||geomancer
|-
|-
|2097152||rune fencer
|-
|}

'''MId''' determines the appearance for the item. Also see [[How_to_Add_an_Item]].

'''shieldSize''' is only used by shields, and determines how much damage they block, and how much damage they'll deal with Shield Bash.

'''scriptType''' needs to be investigated.

'''slot''' determines which slot(s) the item can be worn in, in a bitmask. main hand (1) + off hand (2) = 3.

{|class="wikitable sortable zebra"
!Value!!Valid Slot
|-
|1||main hand
|-
|-
|2||offhand
|-
|-
|4||ranged
|-
|-
|8||ammo
|-
|-
|16||head
|-
|-
|32||body
|-
|-
|64||hands
|-
|-
|128||legs
|-
|-
|256||feet
|-
|-
|512||neck
|-
|-
|1024||belt
|-
|-
|2048||l earring
|-
|-
|4096||r earring
|-
|-
|8192||l ring
|-
|-
|16384||r ring
|-
|-
|32768||cape
|-
|}

'''rslot''' determines which single slot cannot be used while the item is equipped. For example, Vermillion Cloak would reserve the head slot, since head equipment cannot be used with it. This is '''not''' a bitmask, and only one value can be specified.
{|class="wikitable sortable zebra"
!Value!!Reserved Slot
|-
|1||offhand
|-
|-
|2||ranged
|-
|-
|3||ammo
|-
|-
|4||head
|-
|-
|5||body
|-
|-
|6||hands
|-
|-
|7||legs
|-
|-
|8||feet
|-
|-
|9||neck
|-
|-
|10||belt
|-
|-
|11||l earring
|-
|-
|12||r earring
|-
|-
|13||l ring
|-
|-
|14||r ring
|-
|-
|15||cape
|-
|-
|16||"SLOT_LINK" Linkshell?
|-
|}

==item_weapon==

Stores common information for all weapons.

'''itemId''' links the table to item_basic and item_armor, and should match those tables.

'''name''' is for readability's sake and the name of any script associated with the weapon.

'''skill''' determines which weapon proficiency should be used with the weapon. Note the distinction for guns and marksmanship
{|class="wikitable sortable zebra"
!Value!!Weapon Type
|-
|1||Hand-to-hand
|-
|-
|2||Dagger
|-
|-
|3||Sword
|-
|-
|4||Greatsword
|-
|-
|5||Axe
|-
|-
|6||Great Axe
|-
|-
|7||Scythe
|-
|-
|8||Polearm
|-
|-
|9||Katana
|-
|-
|10||Great Katana
|-
|-
|11||Club
|-
|-
|12||Staff
|-
|-
|24||Gun
|-
|-
|25||Archery
|-
|-
|26||Marksmanship
|-
|-
|27||Throwing
|-
|}

'''dmgType''' determines the type of damage dealt by the weapon. Note that only Hand-to-hand damage will use both hands for jobs such as Monk as of r3200.
{|class="wikitable sortable zebra"
!Value!!Damage Type
|-
|0||Damage type "none"
|-
|-
|1||Piercing
|-
|-
|2||Slashing
|-
|-
|3||Blunt
|-
|-
|4||Hand-to-hand
|-
|-
|5||Crossbow
|-
|-
|6||Gun
|-
|}
'''hit''' is only used for multihit weapons such as Joyeuse or Kraken Club, and represents the maximum number of hits per round.

'''delay''' determines the delay of the weapon. Ranged Weapons and Ammunition always have -240 their displayed delay. For example, Expunger (Delay 360) is stored as 120 delay in the database.

'''dmg''' is the DMG stat for the equipment. Hand-to-hand weapons are always stored with their DMG stat +3. For example, Lizard Cesti has 5 instead of 2.

'''unlock_index''' refers to the id of the weapon in item_weapon_unlocked.

==item_mods==

Stores uncommon information, from Defense to "Enhances Dual Wield Effect."

item_mods is an unindexed table. As such, always keep in mind that it's possible to have duplicate values, which darkstar will cheerfully use without questioning them.

'''itemId''' links the table back to the item via item_basic, and should always match.

'''modId''' is what is being modified. A list of these values can be found in /scripts/globals/status.lua (listed in hexadecimal,) or in /src/map/modifier.h (listed in hexadecimal.) Remember to convert them to decimal for use in this table.

'''value''' is how much of the modifier to grant, and can be positive or negative. It's best to research any modifier you're unsure of, as some are stored and applied in unexpected ways, such as Magic Damage Taken being stored as amount/256, while Physical Damage Taken is stored as amount%.

==item_furniture==

Stores information regarding moghouse furniture.

'''itemId''' links back to item_basic, and should always match.

'''name''' may just be for readability's sake, and is the long name for the item.

'''storage''' is how much storage to grant for each item placed. The core will cap the total at 80.

'''moghancement''' needs to be researched.

'''element''' is the elemental alignment of the furniture.

'''aura''' needs to be researched (strength of effect?)

==item_usable==

Stores information regarding items that can be used. An item cannot be used unless it is in this table.

'''itemid''' links this table back to item_basic, and should match.

'''subid''' seems to primarily be used with spell scrolls, and probably just stores the spellid to be unlocked.

'''name''' may just be for readability's sake.

'''validTargets''' is a bitmask storing what the item can be used on. Being a bitmask, the values should be added for each valid target type. Self (1) + party (2) = 3.
{|class="wikitable sortable zebra"
!Value!!Valid target
|-
|1||Self
|-
|-
|2||Player in user's party
|-
|-
|4||Enemy
|-
|-
|8||Player in user's alliance
|-
|-
|16||Players outside of user's party/alliance
|-
|-
|32||Dead players
|-
|-
|64||NPCs
|-
|}

'''activation''' needs to be researched

'''animation''' determines which animation should be used with the item.

'''animation time''' needs to be researched, but probably determines how long the player can't move for the item usage to succeed.

'''maxCharges''' is the maximum number of usages.

'''useDelay''' is likely how long the item must be equipped before it can be used.

'''reuseDelay''' is likely how long must pass between item uses.

'''aoe''' is a simple binary on whether the item is AoE or not (0 = false, 1 = true.)

==item_latents==

Stores information regarding latent effects on items.

'''itemId''' links back to item_basic, and should always match.

'''modId''' is the number that represents the stat boost when active

'''value''' is the value to add to the stat when active

'''latentId''' is the ID of the latent effect conditions (see src/latent_effect.h)

'''latentParam''' is an additional parameter depending on the latentId (see src/latent_effect.h)

==item_weapon_unlocked==

Stores information related to weaponskill broken weapons.

'''Id''' the ID of the weapon. This only corresponds with a BLOB in the chars table ('''unlocked weapons''') and the entries in the char_weapon_skill_points table.

'''itemId''' is the matching itemId of the weapon from item_basic.

'''name''' is the same name used in item_basic, only useful for reading what the weapon is (and the filename of the script if it has a script)

'''skill''' is the combat skill associated with the weapon (battleentity.h). Note that guns and cannons are different from crossbows.

'''dmgType''' is the type of damage the weapon inflicts (piercing, blunt, handtohand, slashing).

'''hit''' is the number of hits of the weapon.

'''point''' is the amount of weaponskill points needed to "break" the weapon and unlock its associated latent effects.

==item_puppet==

The itemId, name, slot, and "element" of each automaton piece. As PUP isn't in use, this table may change substantially in the future.

How to Add an Item

2013-03-29T19:50:47Z

PrBlah:

by PrBlahBlahtson

Okay, time for a very basic and probably ugly tutorial on making items and finding appearances. If someone wants to improve it for user friendliness and formatting, feel free.

==How do I make an item?==

Item id: Find it on ffxiah.com. The itemid is part of the URL.

Not all tables are required. Except item_basic. ''item_basic is always required.''

'''item_basic''' -- I'm guessing that flags handles rare/ex, and probably some other things.

'''item_usable''' -- If it's usable, it goes here. Think clusters, potions, and items that have charges.

'''item_armor''' -- The name is deceiving. If you want the item to be equipped, it must exist in this table, even if it's a weapon. Determines the level, jobs, appearance, slot(s) it can be equipped in, and what slots should be turned off in the case of 2hd weapons, or cloaks with hoods. I've never puzzled out what scriptType is for.

'''item_weapon''' -- For weapons, of course. Determines skill (h2h, sword, etc), damage type (slashing, blunt, etc), how many times it can hit (K Club, Joyeuse, etc,) the delay, and the dmg.

'''item_mods''' -- Stats go here. A list for modId can be found in /scripts/globals/status.lua.

I haven't done much with the other tables.

You can also view the [[Items]] page from the Database guide for a longer explanation of each field, and what the values mean.

One side note: if the item can be equipped and is usable, you may want to add a script to /scripts/globals/items, otherwise you're going to have an error message every time someone puts on or takes off that item. File name of the script should be item_basic.name, not sort_name.

==How do I find an appearance/mId?==

You need a GM account. If you haven't made one, make one. While a GM account is technically optional, you are wasting time without one. It's such a horrible waste of time that I won't even cover how to find them using just the database and constant server restarts.

To find an mId, you create an appearance packet (info below.) Then on a GM, you use the command ''@inject file name'' where file name is the name of the packet's file.

==So how do I make an appearance packet?==

You need a hex editor. I have Frhed left over from some project or another. It works and isn't obnoxious, but any hex editor should do. For hex editor novices, type on the left, not on the right. Unless you're entering a text string, then you type on the right. We're not entering text strings.

Make a file in darkstar's root directory (c:\dsp). I use things like "appearance.dat," but the file name is mostly irrelevant, as long as you remember it. You're going to be making an appearance packet. Here's how they're structured.

{|class="wikitable"
!Packet Type!!Packet Number!!Face!!Race!!Head!!Body!!Hands!!Legs!!Feet!!Main Hand!!Off Hand!!Ranged/Instrument!!?? Ammo?
|-
|51 0c||57 00||08||07||28 11||28 21||28 31||28 41||28 51||A1 61||00 70||00 80||00
|-
|}

The first four pairs ('''51 0c 57 00''') are pretty much irrelevant for what you're doing. Just use the ones supplied. Technically, they identify the packet type and the packet number, as far as "this is the tenth packet that has been sent."

The fifth pair ('''08''') is the face to use, while the sixth ('''07''') is race. Race may be important with armor, because MId isn't always the same when you're messing with things like swimsuits. Why? Because male and female tarutarus use the same armor models, just a different MId when gender matters.

Every two pairs after that is a slot, in the following order: head, body, hands, legs, feet, main hand, off hand, ranged/instrument. The order is reversed, and it will be necessary to convert between base-10 and base-16. Windows Calculator in Scientific Mode (Vista and earlier) or Programmer Mode (Windows 7) can be useful for doing this. Set the calculator to Hex and enter the values in the corrected order, then click Dec to get the Base-10 value.

'''28 11''' is actually 0x1128, except that first digit is just packet formatting, so you're left with 0x128, or 296 in base-10. This is the Summoner's Caller (Empyrean) set if you're working with armor.

For a second example, '''a1 61''' is 0x61a1, which you trim to 0x1a1 or 417 (Nirvana.)

At the moment, armor mIds seem to go up to around 0x151/337. Weapons go up to about 0x259 or 601. There are gaps by the way, just to keep things interesting.

==Simplifying the process==
So yeah, checking every single mId in a substantial range sucks. Been there, done that, fixed a few dozen pieces of armor that were invisible.

Use SQL queries to simplify life. For example:

SELECT itemid, name, mId FROM item_armor WHERE slot <= 3 AND mId != 0 GROUP BY mId ORDER BY mId ASC;

That query will show you every mId currently in use for main and offhand items. Why would you do this?

If the item you're trying to create looks like a different item, now you know the mId that item uses.

If it's completely unique, then you know the mId won't be in use elsewhere. Look in the gaps. For example, Zanbato is 151 and Mukademaru is 153. Nothing's using 152 right now. We change the packet to use 98 60, @inject appearance.dat and we find... it's just another Zanbato/Hagun. The colors might be slightly different, but yeah, that's a Hagun.

==Finding Monster/NPC appearances==
Wooo, you're in for some fun.

Normal humanoid NPCs will use look data that's very similar to the appearance packet above. Not even kidding. Want an example? Have an example. 0x0100'''0E031210752066306640'''0050006000700000. That's appearance 0e 03 12 10 75 20 66 30 66 40 and so on. The same rules apply. Decimal to hexadecimal, reverse the order of the pairs.

Humanoid NPCs with special appearances or animations (ex: Cid), as well as monsters will use something different. Bahamut is 0x0000'''C105'''00000000000000000000000000000000. 0x05C1 -> 1473. @costume 1473, poof, you're Bahamut. It's that simple. Note that some appearances will require a prefix in the first pair of 00s, such as 05 for the Fomor Thieves in CoP regions.

Quick warnings on @costume:

- @costume 0 to return to normal

- Some costumes require an animation to look right. What's interesting is that Empties in Promyvion seem to have 4 DATs for all 8 elements, so finding those animation IDs may be necessary later on. I haven't explored those yet. They may have their own appearances. (Ed: Turns out these are animationsubs)

- Due to the above, moving can sometimes show what you're costumed as, even if standing still leaves you invisible. Example: Iron Golem (heads)

- You can't use @animation on yourself while costumed :)

- Corollary: If you're already engaged when you use @costume, your appearance will be engaged.

- There are often multiple appearances for the "same" thing. For example, elementals have a set of appearances for wild elementals, and for Summoner pets. We're using the appearance for pets at the moment. Light elementals should have their orbiting spheres. There's probably three or more Carbuncles. Be aware this can happen.

- Some costumes have... interesting effects on your camera. Dualboxing or a partner is suggested. @wallhack and walking into an empty space can be useful as well, since sometimes you're in the floor/air.

- I've had some odd things happen with size after using @costume for extensive periods. We're talking an Elvaan so tall that a Mithra stood as tall as their hip. Either that or the Mithra was extremely short.

- I've found costumes all the way up to 0x94F / 2383, but I haven't really tried to find an end to it :)

- The groupings seem to be somewhat similar to AltanaViewer and Model_Viewer, although they're not necessarily identical. That may help you by finding something that's in the right neighborhood at least.

- Just to really twist the knife, some costumes will only display when you use @costume 0 to return to your normal appearance. An example of this is the Fomor costumes such as 1022. Those appearances have a prefix, which may be related.

Building the Server

2013-03-29T19:40:50Z

PrBlah: Correcting channel name.

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

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

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

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

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

Calculate the new form from the IP address.

The IP must be entered in different form, so first we must calculate the new form. Use the formula below or [http://www.allredroster.com/iptodec.htm This Handy Site] to calculate it. '''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

What Works

2013-02-28T23:28:43Z

PrBlah:

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

Alexander

Diabolos

Odin

Note: Astral Flow is not implemented for all avatars
----

=== Besieged ===

It is currently unknown as to whether this works or not, however when you check the Besieged status through "Region Info" they are in an almost constant state of attack, which leads me to believe that it does not work.

----

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

Dynamis - Xarcabard

Dynamis - Buburimu

Dynamis - Qufim

Dynamis - Valkurm

Dynamis - Tavnazia

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

Adamantoise

Aspidochelone

Behemoth

King Behemoth

Fafnir

Nidhogg

Vrtra

Absolute Virtue

Jormungand

Tiamat

==== Sky Gods ====

Byakko

Genbu

Seiryu
- Attacks with both "fists."

Suzaku

Kirin
- Kirin does not spawn mini gods (unconfirmed)

==== Jailers ====

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

Carbuncle working

Fenrir workign with bugs

Red writing = Not working

==== Assault ====

===== Private Second Class =====

Leujaoam Cleansing

Imperial Agent Rescue

Excavation Duty

Seagull Grounded

Golden Salvage

Nyzul Isle Investigation

===== Private First 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 ====

As far as I know most of these do not work, however I have been informed that there are a handful that DO work, no specifics as of yet.

===== 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 = 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 
3-BCNM / KSNM are not level capped at this time. 

====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 flg: 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 -- No level cap, animas do not work 

====Spire of Holla====

ENM: Simulant 
Mission: Ancient Flames Beckon -- No level cap, animas do not work 

====Spire of Mea====

ENM: Playing Host 
Mission: Ancient Flames Beckon -- No level cap, animas do not work 

====Spire of Vahzl====

ENM: Pulling the Plug 
Mission: Desires of Emptiness 

====Monarch Linn====

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

====The Shrouded Maw====

ENM: Test Your Mite 
Mission: Darkness Named -- No level cap, 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

White Mage

Black Mage

Red Mage 

Thief

==== Advanced Jobs ====

Paladin
:* Shield Bash does no damage
:* Most job abilities are not properly implemented

Dark Knight

Beastmaster
:* Charm Functions some what but there are still bugs.

Ranger

Bard

Summoner

Samurai

Ninja

Dragoon
:* Wyvern attacks on engage, Spirit Link does not work, Healing Breath does not heal allies, status removal breaths are not implemented

Blue Mage
:* Spell learning works as intended.
:* Can set spells - However it is possible to set multiple copies of the same spell.
:* Stat bonuses (i.e Wild Oats's CHR+1 and HP+10) doesn't apply to stats.
:* Spells does no damage currently, however it is possible to skill up the magic skill to have ready for when everything is working.
:* Abilities does not work.
:* Work in progress.

Puppetmaster

Corsair
:* Quest is available, but rolls do not work.

Dancer
:* Quest is not available.
:* Waltz's function, formulas may be off.
:* Sambas work correctly.
:* Steps are non-functional
:* Animated Flourish works, the rest are bugged.

Scholar

----

=== Merits ===

"The code that loads them into your character is remarked out right now" - whasf

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
:* Enmity Gain/Decrease doesn't work correctly as enmity in general is still W.I.P

Weapon Skills

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

Warrior Group 1, Group 2
:* Group 1 merits are working.

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

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

Black Mage Group 1 and 2

Red Mage Group 1 and 2

Thief Group 1 and 2

Paladin Group 1 and 2

Dark Knight Group 1 and 2

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

Ninja Group 1 and 2

Dragoon Group 1 and 2

Blue Mage Group 1 and 2

Corsair Group 1 and 2

Puppetmaster Group 1 and 2

Corsair Group 1 and 2

Dancer Group 1 and 2

Scholar Group 1 and 2

----

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

San d'Oria

Windurst

Rise of the Zilart
- Currently only works up to the Mission "Gate of the Gods", which is far enough for Sky access.

Chains of Promathia
- Works up to Promyvion - Vahzl

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
- Unreleased

----

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

Character Creation -- FFXI-Boot (and by extension, FFXI-Boot Mod and Ashita) cannot smoothly log in the first time. When the client times out or gets stuck, wait a few minutes before trying again. It may take up to three or four tries for the first login. mXI does not suffer from this problem, but has trouble with excessive CPU usage over time. A new FFXI-Boot Mod is in development to correct this trouble.

== 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-02-16T18:50:13Z

PrBlah:

This guide is NOT intended for people with buddypass, or illegally downloaded versions of FFXI. We have the bought and paid for the game, and will never recommend that you use anything different. If you somehow managed to get it to work using the buddypass or an illegal version of FFXI then keep it to yourself. Discussion of obtaining software through illegal means is not tolerated.

== Installing FFXI ==

'''In this section we will install and update Final Fantasy XI from Retail Discs.'''

You can download the retail Disks here [http://unblockedpiratebay.com/index.php?loadurl=/torrent/8012461/FINAL_FANTASY_XI_Ultimate_Collection_-_Abyssea_Edition Client Download]

For users on Windows Vista or newer, download the Vista PlayOnline client from the [http://www.playonline.com/ff11us/download/media/vista01.html PlayOnline Support Site] and install that instead of the version on the retail discs.

Install PlayOnline, Final Fantasy XI, and then ALL of the expansions up to and including Wings of the Goddess. You do not need to have the mini-addon packs installed.

Run PlayOnline and let it update.

Close PlayOnline viewer.

Download the following file: [http://kile.dyndns.info:8765/bak/PXI-FFXI-UpdatePatch.zip FFXI Patch]

Extract its contents to your PlayOnline/Squareenix/Final Fantasy XI directory.

Run PlayOnline again and choose For PlayOnline Members

At the Add Member page enter anything you like for the Member Name.

Enter ABCD1234 for the PlayOnline ID

Select Register, Yes, OK.

Select Check Files on the left of the screen.

=== Updating FFXI via the PlayOnline Viewer ===

This option is safer and is the one supported by Dark Star Project

Go back to your Check Files screen and select Final Fantasy XI from the drop-down menu.

After 7 hours or so of updating, FFXI should be up to date.

Close the PlayOnline Viewer.

=== Updating FFXI via manual patch download ===

This option isn't supported by Dark Star Project, but may be faster than updating through PlayOnline

If you don't have something that can extract RAR archives, download and install [http://www.7-zip.org/download.html 7zip].

Close the PlayOnline Viewer

Go to [http://tehkrizz.net/FFXI/downloads.php tehkrizz's FFXI Patch Download Page]

Download the MOV, ROM, and Sound archives.
Extract the files into your FFXI install folder. Usually C:\Program Files (x86)\PlayOnline\SquareEnix\FINAL FANTASY XI on 64-bit Windows or C:\Program Files\PlayOnline\SquareEnix\FINAL FANTASY XI on 32-bit Windows
Extract the contents of the FFXI Patch you downloaded earlier into the FFXI install folder again, overwriting all files. If you skip this step, your client probably will not update properly.

Run the PlayOnline Viewer

Select Check Files on the left of the screen.

Click on PlayOnline Viewer then select Final Fantasy XI from the drop down, then Check Files. If there have been any updates since the archives posted on tehkrizz's site, this may take an hour or more.

Close the PlayOnline Viewer

=== After updating ===

Copy the data folder at PlayOnline\SquareEnix\PlayOnlineViewer\data to the Final Fantasy XI directory at PlayOnline\SquareEnix\FINAL FANTASY XI.

Afterwards you should have the directory PlayOnline\SquareEnix\FINAL FANTASY XI\data.

== Setting up the Launcher ==

'''In this section you will configure FFXI to connect to a DarkStar Server'''

You can use Ashita, FFXI-Boot Mod, FFXI-Boot, or mXI to connect to a Dark Star server. Ashita and mXI have more features, but take longer to set up. FFXI-Boot/Mod usually work with minimal configuration. They can all co-exist on your system, so if in doubt, try several!

=== Ashita ===

This is the most maintained and feature-packed option.

----

Prerequisite: [http://www.microsoft.com/en-us/download/details.aspx?id=30679 MSVC 2012 Update 1 Runtimes] x86 version

This comes with the below FFXI-Boot. As such, '''IT WORKS PROPERLY WITH DNS NAMES''' out of the box.

Download [http://kile.dyndns.info:8765/bak/Ashita_Darkstar.zip Ashita - DarkStar Edition]

Create a folder in a convenient location and extract the archive into it.

Run Ashita.exe and click the "Updates" tab. Once the update list displays, hit "UPDATE ALL FILES".

If you don't have an account, skip to the next section for creation instructions.

If you already have an account, click on the "Launcher" tab and select the appropriate profile for the server you use.

Click "EDIT CONFIG". Inside, on the "Boot Command" line, edit the account and password to match your own.

Tweak any other options you want while in here, including resolution. You do not need to click on the "Test Server" check box. If you would prefer to be prompted for your password, take out the --pass parameter entirely.

'''If you need to be able to log into a public server hosted on your own computer or LAN, add the --hairpin option to the Boot Command!'''

The package contains profiles for the main test server and the classic server. See the [[DarkStar Servers]] page for additional servers you can use.

You can find a lot of additional plugins and help for Ashita at [http://www.ffevo.net]

=== FFXI-Boot Mod ===

This is the most maintained simple loader. It does not support plugins but it is used with the Ashita package above which does provide plugins.

----

A vc11 and vc10 build are both provided. You will need one of:

[http://www.microsoft.com/en-us/download/details.aspx?id=30679 MSVC 2012 Update 1 Runtimes] x86 version

or

[http://www.microsoft.com/en-us/download/details.aspx?id=5555 MSVC 2010 Runtimes] x86 version

This is a special version of the below FFXI-Boot. This version takes command-line options and was designed to work seamlessly with Ashita. It is also included in the Ashita package we provide. There is no INI file with this version. '''IT ALSO WORKS PROPERLY WITH DNS NAMES''' unlike the original ffxi-boot!

Download [http://kile.dyndns.info:8765/bak/ffxi-boot_mod_2b.zip FFXI-Boot Mod]

Extract the FFXI-Boot Mod's "pol.exe" somewhere convenient.

To play on a local server, just run pol.exe and you will be prompted for a username and password to login with.

To play on another server, open up a command prompt, navigate to the folder you extracted to, and type in:
<pre>pol.exe --server server-ip --user username --pass password</pre>

The username and password options are optional here and will be prompted for if not provided. See the Readme in the archive for more information.

'''If you need to be able to log into a public server hosted on your own computer or LAN, add the --hairpin option to the command!'''

See the [[DarkStar Servers]] page for servers you can use.

=== FFXI-Boot ===

This is the original FFXI-Boot, a simple loader without any bells or whistles. It uses an ini file instead of command-line options to work, and as such is not well-suited for use with several server configurations.

----

Prerequisite: [http://www.microsoft.com/en-us/download/details.aspx?id=5555 MSVC 2010 Runtimes] x86 version

This version does not handle DNS names properly and will cause searches and auctions to fail when using them. It also does not support hairpinning for accessing public servers hosted on the same system or your LAN.

Download [http://www.filedropper.com/ffxi-boot FFXI-Boot]

Extract the FFXI-Boot files (ffxi-boot.exe & ffxi-boot.ini) somewhere convenient.

Open ffxi-boot.ini in a text editor.

Change SERVIP to the IP address of the DarkStar server you wish to use. See the [[DarkStar Servers]] page for this info, or put in 127.0.0.1 if you are hosting your own server on the same system.

An example ffxi-boot.ini is below.
<pre>
SERVIP = 67.41.45.115
AUTOLOGIN = 1
USERNAME = username
PASSWORD = password
</pre>

=== mXI ===

This is the original Windower loader for private servers. It is no longer maintained, and the Windower crew hasn't shown us anything new in a long time, but it is still a valid option.

----

Prerequisite: [http://www.microsoft.com/en-us/download/details.aspx?id=5555 MSVC 2010 Runtimes] x86 version

This does not handle DNS names properly and will cause searches and auctions to fail when using them. It also does not support hairpinning for accessing public servers hosted on the same system or your LAN.

If you prefer the MXI FFXI Loader, this is compatible with DarkStar servers as well. mXI windower features (light luggage, distance, etc.) can potentially cause you problems while playing. If you have issues, this is the first thing to disable. Windower itself seams to work fine on Dark Star.

Download [http://46.38.63.32/downloads.php mXI 0.91_Darkstar version]

Extract the contents of the archive into the PlayOnline\SquareEnix\FINAL FANTASY XI directory.

Open Client.ini in a text editor.

Change SERVIP to the IP address of the DarkStar server you wish to use. See the [[DarkStar Servers]] page for this info, or put in 127.0.0.1 if you are hosting your own server on the same system.

You will also need to set X_RES and Y_RES to the resolution your game will be running at or it will look streteched or squashed.

'''If you plan to play on someone else's server, you MUST disable the Light Luggage plugin in scripts/init.txt or YOU WILL LIKELY BE BANNED. This plugin unnecessarily spams auto-sort on the server and can disrupt play for everyone.'''

If you have any problems, set WINDOWERMODE to 2, which will disable all of the windower plugins. If it works, try disabling all of your windower plugins in scripts/init.txt and then re-enable them one at a time to determine which one is causing a crash. It may also help to DISABLE windowed mode the the FFXI configuration utility and/or extract mXI to a directory other than the PlayOnline\SquareEnix\FINAL FANTASY XI directory and run it from that location instead.

An example Client.ini is below.
<pre>
[SERVER]
SERVIP = 67.41.45.115
AUTOLOGIN = 1
USERNAME = username
PASSWORD = password
[CLIENT]
LANGUAGE = 1
## VERSION can be NA,EU or JP. This needs to reflect the POL version you have.
VERSION = NA
## MODE 0 = no windower, 1 = normal windower, 2 = windower light
WINDOWERMODE = 1
X_RES = 1024
Y_RES = 768
</pre>

I would highly suggest updating the Windower hook.dll version and all of the plugins in this package. You can obtain the newest hook.dll here: [http://forums.windower.net/files/file/24-hookdll/]

You can find additional plugins on that site as well.

=== Create an Account and Login ===

==== FFXI-Boot Mod ====

For FFXI-Boot Mod, run it with the server parameter and fail a login once and you will be asked if you want to create an account.

The username should be between 3 and 15 alphanumeric characters and the password should be between 6 and 15 alphanumeric characters long.

After creating you account the window will close. Simply re-run with (or without) the new username and password options. If you didn't provide them, you will be prompted for them.

==== Ashita ====

For Ashita, start Ashita.exe, double-click on the server profile you want to use and fail a login once and you will be prompted to create an account.

The username should be between 3 and 15 alphanumeric characters and the password should be between 6 and 15 alphanumeric characters long.

After creating you account the window will close.

Start Ashita.exe again and click the appropriate profile and click "EDIT CONFIG"

Within, on the Boot Command line edit account and password to reflect the appropriate values.

Tweak your window size and other options as you like and hit "SAVE CONFIG". You do not need to check Test Server.

Double-click the profile you edited to launch from now on!

==== FFXI-Boot or mXI ====

Run ffxi-boot.exe or mXI.exe and choose option 2; Create a new account.

The username should be between 3 and 15 alphanumeric characters and the password should be between 6 and 15 alphanumeric characters long.

You can now save the username and password into the ffxi-boot.ini or Client.ini if you wish to use auto-login.

Choose option 1; Login using existing account

Login with username and password.

FFXI should load and be on the splash screen. Choose Accept.

Create a Character, Select a Country, then choose Yes to Register and begin play.

Select the newly created character then login.

It should login all the way to the Country you selected.

'''NOTE:''' It may take as many as three to four attempts to log in with a newly created character.

How to Add an Item

2013-02-06T03:47:54Z

PrBlah:

by PrBlahBlahtson

Okay, time for a very basic and probably ugly tutorial on making items and finding appearances. If someone wants to improve it for user friendliness and formatting, feel free.

==How do I make an item?==

Item id: Find it on ffxiah.com. The itemid is part of the URL.

Not all tables are required. Except item_basic. ''item_basic is always required.''

'''item_basic''' -- I'm guessing that flags handles rare/ex, and probably some other things.

'''item_usable''' -- If it's usable, it goes here. Think clusters, potions, and items that have charges.

'''item_armor''' -- The name is deceiving. If you want the item to be equipped, it must exist in this table, even if it's a weapon. Determines the level, jobs, appearance, slot(s) it can be equipped in, and what slots should be turned off in the case of 2hd weapons, or cloaks with hoods. I've never puzzled out what scriptType is for.

'''item_weapon''' -- For weapons, of course. Determines skill (h2h, sword, etc), damage type (slashing, blunt, etc), how many times it can hit (K Club, Joyeuse, etc,) the delay, and the dmg.

'''item_mods''' -- Stats go here. A list for modId can be found in /scripts/globals/status.lua.

I haven't done much with the other tables.

You can also view the [[Items]] page from the Database guide for a longer explanation of each field, and what the values mean.

One side note: if the item can be equipped and is usable, you may want to add a script to /scripts/globals/items, otherwise you're going to have an error message every time someone puts on or takes off that item. File name of the script should be item_basic.name, not sort_name.

==How do I find an appearance/mId?==

You need a GM account. If you haven't made one, make one. While a GM account is technically optional, you are wasting time without one. It's such a horrible waste of time that I won't even cover how to find them using just the database and constant server restarts.

To find an mId, you create an appearance packet (info below.) Then on a GM, you use the command ''@inject file name'' where file name is the name of the packet's file.

==So how do I make an appearance packet?==

You need a hex editor. I have Frhed left over from some project or another. It works and isn't obnoxious, but any hex editor should do. For hex editor novices, type on the left, not on the right. Unless you're entering a text string, then you type on the right. We're not entering text strings.

Make a file in darkstar's root directory (c:\dsp). I use things like "appearance.dat," but the file name is mostly irrelevant, as long as you remember it. You're going to be making an appearance packet. Here's how they're structured.

{|class="wikitable"
!Packet Type!!Packet Number!!Face!!Race!!Head!!Body!!Hands!!Legs!!Feet!!Main Hand!!Off Hand!!Ranged/Instrument!!?? Ammo?
|-
|51 0c||57 00||08||07||28 11||28 21||28 31||28 41||28 51||A1 61||00 70||00 80||00
|-
|}

The first four pairs ('''51 0c 57 00''') are pretty much irrelevant for what you're doing. Just use the ones supplied. Technically, they identify the packet type and the packet number, as far as "this is the tenth packet that has been sent."

The fifth pair ('''08''') is the face to use, while the sixth ('''07''') is race. Race may be important with armor, because MId isn't always the same when you're messing with things like swimsuits. Why? Because male and female tarutarus use the same armor models, just a different MId when gender matters.

Every two pairs after that is a slot, in the following order: head, body, hands, legs, feet, main hand, off hand, ranged/instrument. The order is reversed, and it will be necessary to convert between base-10 and base-16. Windows Calculator in Scientific Mode (Vista and earlier) or Programmer Mode (Windows 7) can be useful for doing this. Set the calculator to Hex and enter the values in the corrected order, then click Dec to get the Base-10 value.

'''28 11''' is actually 0x1128, except that first digit is just packet formatting, so you're left with 0x128, or 296 in base-10. This is the Summoner's Caller (Empyrean) set if you're working with armor.

For a second example, '''a1 61''' is 0x61a1, which you trim to 0x1a1 or 417 (Nirvana.)

At the moment, armor mIds seem to go up to around 0x151/337. Weapons go up to about 0x259 or 601. There are gaps by the way, just to keep things interesting.

==Simplifying the process==
So yeah, checking every single mId in a substantial range sucks. Been there, done that, fixed a few dozen pieces of armor that were invisible.

Use SQL queries to simplify life. For example:

SELECT itemid, name, mId FROM item_armor WHERE slot <= 3 AND mId != 0 GROUP BY mId ORDER BY mId ASC;

That query will show you every mId currently in use for main and offhand items. Why would you do this?

If the item you're trying to create looks like a different item, now you know the mId that item uses.

If it's completely unique, then you know the mId won't be in use elsewhere. Look in the gaps. For example, Zanbato is 151 and Mukademaru is 153. Nothing's using 152 right now. We change the packet to use 98 60, @inject appearance.dat and we find... it's just another Zanbato/Hagun. The colors might be slightly different, but yeah, that's a Hagun.

==Finding Monster/NPC appearances==
Wooo, you're in for some fun.

Normal humanoid NPCs will use look data that's very similar to the appearance packet above. Not even kidding. Want an example? Have an example. 0x0100'''0E031210752066306640'''0050006000700000. That's appearance 0e 03 12 10 75 20 66 30 66 40 and so on. The same rules apply. Decimal to hexadecimal, reverse the order of the pairs.

Humanoid NPCs with special appearances or animations (ex: Cid), as well as monsters will use something different. Bahamut is 0x0000'''C105'''00000000000000000000000000000000. 0x05C1 -> 1473. @costume 1473, poof, you're Bahamut. It's that simple. Note that some appearances will require a prefix in the first pair of 00s, such as 05 for the Fomor Thieves in CoP regions.

Quick warnings on @costume:

- @costume 0 to return to normal

- Some costumes require an animation to look right. What's interesting is that Empties in Promyvion seem to have 4 DATs for all 8 elements, so finding those animation IDs may be necessary later on. I haven't explored those yet. They may have their own appearances.

- Due to the above, moving can sometimes show what you're costumed as, even if standing still leaves you invisible. Example: Iron Golem (heads)

- You can't use @animation on yourself while costumed :)

- There are often multiple appearances for the "same" thing. For example, elementals have a set of appearances for wild elementals, and for Summoner pets. We're using the appearance for pets at the moment. Light elementals should have their orbiting spheres. There's probably three or more Carbuncles. Be aware this can happen.

- Some costumes have... interesting effects on your camera. Dualboxing or a partner is suggested. @wallhack and walking into an empty space can be useful as well, since sometimes you're in the floor/air.

- I've had some odd things happen with size after using @costume for extensive periods. We're talking an Elvaan so tall that a Mithra stood as tall as their hip. Either that or the Mithra was extremely short.

- I've found costumes all the way up to 0x94F / 2383, but I haven't really tried to find an end to it :)

- The groupings seem to be somewhat similar to AltanaViewer and Model_Viewer, although they're not necessarily identical. That may help you by finding something that's in the right neighborhood at least.

- Just to really twist the knife, some costumes will only display when you use @costume 0 to return to your normal appearance. An example of this is the Fomor costumes such as 1022. Those appearances have a prefix, which may be related.

How to Add an Item

2013-02-06T03:42:25Z

PrBlah:

by PrBlahBlahtson

Okay, time for a very basic and probably ugly tutorial on making items and finding appearances. If someone wants to improve it for user friendliness and formatting, feel free.

==How do I make an item?==

Item id: Find it on ffxiah.com. The itemid is part of the URL.

Not all tables are required. Except item_basic. ''item_basic is always required.''

'''item_basic''' -- I'm guessing that flags handles rare/ex, and probably some other things.

'''item_usable''' -- If it's usable, it goes here. Think clusters, potions, and items that have charges.

'''item_armor''' -- The name is deceiving. If you want the item to be equipped, it must exist in this table, even if it's a weapon. Determines the level, jobs, appearance, slot(s) it can be equipped in, and what slots should be turned off in the case of 2hd weapons, or cloaks with hoods. I've never puzzled out what scriptType is for.

'''item_weapon''' -- For weapons, of course. Determines skill (h2h, sword, etc), damage type (slashing, blunt, etc), how many times it can hit (K Club, Joyeuse, etc,) the delay, and the dmg.

'''item_mods''' -- Stats go here. A list for modId can be found in /scripts/globals/status.lua.

I haven't done much with the other tables.

You can also view the [[Items]] page from the Database guide for a longer explanation of each field, and what the values mean.

One side note: if the item can be equipped and is usable, you may want to add a script to /scripts/globals/items, otherwise you're going to have an error message every time someone puts on or takes off that item. File name of the script should be item_basic.name, not sort_name.

==How do I find an appearance/mId?==

You need a GM account. If you haven't made one, make one. While a GM account is technically optional, you are wasting time without one. It's such a horrible waste of time that I won't even cover how to find them using just the database and constant server restarts.

To find an mId, you create an appearance packet (info below.) Then on a GM, you use the command ''@inject file name'' where file name is the name of the packet's file.

==So how do I make an appearance packet?==

You need a hex editor. I have Frhed left over from some project or another. It works and isn't obnoxious, but any hex editor should do. For hex editor novices, type on the left, not on the right. Unless you're entering a text string, then you type on the right. We're not entering text strings.

Make a file in darkstar's root directory (c:\dsp). I use things like "appearance.dat," but the file name is mostly irrelevant, as long as you remember it. You're going to be making an appearance packet. Here's how they're structured.

{|class="wikitable"
!Packet Type!!Packet Number!!Face!!Race!!Head!!Body!!Hands!!Legs!!Feet!!Main Hand!!Off Hand!!Ranged/Instrument!!?? Ammo?
|-
|51 0c||57 00||08||07||28 11||28 21||28 31||28 41||28 51||A1 61||00 70||00 80||00
|-
|}

The first four pairs (51 0c 57 00) are pretty much irrelevant for what you're doing. Just use the ones supplied. Technically, they identify the packet type and the packet number, as far as "this is the tenth packet that has been sent."

The fifth pair (08) is the face to use, while the sixth (07) is race. Race may be important with armor, because MId isn't always the same when you're messing with things like swimsuits. Why? Because male and female tarutarus use the same armor models, just a different MId when gender matters.

Every two pairs after that is a slot, in the following order: head, body, hands, legs, feet, main hand, off hand, ranged/instrument. The order is reversed, and it will be necessary to convert between base-10 and base-16. Windows Calculator in Scientific Mode (Vista and earlier) or Programmer Mode (Windows 7) can be useful for doing this. Set the calculator to Hex and enter the values in the corrected order, then click Dec to get the Base-10 value.

28 11 is actually 0x1128, except that first digit is just packet formatting, so you're left with 0x128, or 296 in base-10. This is the Summoner's Caller (Empyrean) set if you're working with armor.

For a second example, a1 61 is 0x61a1, which you trim to 0x1a1 or 417 (Nirvana.)

At the moment, armor mIds seem to go up to around 0x151/337. Weapons go up to about 0x259 or 601. There are gaps by the way, just to keep things interesting.

==Simplifying the process==
So yeah, checking every single mId in a substantial range sucks. Been there, done that, fixed a few dozen pieces of armor that were invisible.

Use SQL queries to simplify life. For example:

SELECT itemid, name, mId FROM item_armor WHERE slot <= 3 AND mId != 0 GROUP BY mId ORDER BY mId ASC;

That query will show you every mId currently in use for main and offhand items. Why would you do this?

If the item you're trying to create looks like a different item, now you know the mId that item uses.

If it's completely unique, then you know the mId won't be in use elsewhere. Look in the gaps. For example, Zanbato is 151 and Mukademaru is 153. Nothing's using 152 right now. We change the packet to use 98 60, @inject appearance.dat and we find... it's just another Zanbato/Hagun. The colors might be slightly different, but yeah, that's a Hagun.

==Finding Monster/NPC appearances==
Wooo, you're in for some fun.

Normal humanoid NPCs will use look data that's very similar to the appearance packet above. Not even kidding. Want an example? Have an example. 0x0100'''0E031210752066306640'''0050006000700000. That's appearance 0e 03 12 10 75 20 66 30 66 40 and so on. The same rules apply. Decimal to hexadecimal, reverse the order of the pairs.

Humanoid NPCs with special appearances or animations (ex: Cid), as well as monsters will use something different. Bahamut is 0x0000'''C105'''00000000000000000000000000000000. 0x05C1 -> 1473. @costume 1473, poof, you're Bahamut. It's that simple. Note that some appearances will require a prefix in the first pair of 00s, such as 05 for the Fomor Thieves in CoP regions.

Quick warnings on @costume:

- @costume 0 to return to normal

- Some costumes require an animation to look right. What's interesting is that Empties in Promyvion seem to have 4 DATs for all 8 elements, so finding those animation IDs may be necessary later on. I haven't explored those yet. They may have their own appearances.

- Due to the above, moving can sometimes show what you're costumed as, even if standing still leaves you invisible. Example: Iron Golem (heads)

- You can't use @animation on yourself while costumed :)

- There are often multiple appearances for the "same" thing. For example, elementals have a set of appearances for wild elementals, and for Summoner pets. We're using the appearance for pets at the moment. Light elementals should have their orbiting spheres. There's probably three or more Carbuncles. Be aware this can happen.

- Some costumes have... interesting effects on your camera. Dualboxing or a partner is suggested. @wallhack and walking into an empty space can be useful as well, since sometimes you're in the floor/air.

- I've had some odd things happen with size after using @costume for extensive periods. We're talking an Elvaan so tall that a Mithra stood as tall as their hip. Either that or the Mithra was extremely short.

- I've found costumes all the way up to 0x94F / 2383, but I haven't really tried to find an end to it :)

- The groupings seem to be somewhat similar to AltanaViewer and Model_Viewer, although they're not necessarily identical. That may help you by finding something that's in the right neighborhood at least.

- Just to really twist the knife, some costumes will only display when you use @costume 0 to return to your normal appearance. An example of this is the Fomor costumes such as 1022. Those appearances have a prefix, which may be related.

What Works

2013-02-06T03:19:30Z

PrBlah:

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

Alexander

Diabolos

Odin

Note: Astral Flow is not implemented for all avatars
----

=== Besieged ===

It is currently unknown as to whether this works or not, however when you check the Besieged status through "Region Info" they are in an almost constant state of attack, which leads me to believe that it does not work.

----

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

Dynamis - Xarcabard

Dynamis - Buburimu

Dynamis - Qufim

Dynamis - Valkurm

Dynamis - Tavnazia

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

Adamantoise

Aspidochelone

Behemoth

King Behemoth

Fafnir

Nidhogg

Vrtra

Absolute Virtue

Jormungand

Tiamat

==== Sky Gods ====

Byakko

Genbu

Seiryu
- Attacks with both "fists."

Suzaku

Kirin
- Kirin does not spawn mini gods (unconfirmed)

==== Jailers ====

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

Carbuncle working

Fenrir workign with bugs

Red writing = Not working

==== Assault ====

===== Private Second Class =====

Leujaoam Cleansing

Imperial Agent Rescue

Excavation Duty

Seagull Grounded

Golden Salvage

Nyzul Isle Investigation

===== Private First 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 ====

As far as I know most of these do not work, however I have been informed that there are a handful that DO work, no specifics as of yet.

===== 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 = 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 
3-BCNM / KSNM are not level capped at this time. 

====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 flg: 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 -- No level cap, animas do not work 

====Spire of Holla====

ENM: Simulant 
Mission: Ancient Flames Beckon -- No level cap, animas do not work 

====Spire of Mea====

ENM: Playing Host 
Mission: Ancient Flames Beckon -- No level cap, animas do not work 

====Spire of Vahzl====

ENM: Pulling the Plug 
Mission: Desires of Emptiness 

====Monarch Linn====

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

====The Shrouded Maw====

ENM: Test Your Mite 
Mission: Darkness Named -- No level cap, 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

White Mage

Black Mage

Red Mage 

Thief

==== Advanced Jobs ====

Paladin
:* Shield Bash does no damage
:* Most job abilities are not properly implemented

Dark Knight

Beastmaster
:* Charm Functions some what but there are still bugs.

Ranger

Bard

Summoner

Samurai

Ninja

Dragoon
:* Wyvern attacks on engage, Spirit Link does not work, Healing Breath does not heal allies, status removal breaths are not implemented

Blue Mage
:* Can learn spells, most do not work, very early work in progress.

Puppetmaster

Corsair
:* Quest is available, but rolls do not work.

Dancer
:* Quest is not available, some features work, some work incorrectly.

Scholar

----

=== Merits ===

"The code that loads them into your character is remarked out right now" - whasf

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 and 2

Monk Group 1 and 2

White Mage Group 1 and 2

Black Mage Group 1 and 2

Red Mage Group 1 and 2

Thief Group 1 and 2

Paladin Group 1 and 2

Dark Knight Group 1 and 2

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

Ninja Group 1 and 2

Dragoon Group 1 and 2

Blue Mage Group 1 and 2

Corsair Group 1 and 2

Puppetmaster Group 1 and 2

Corsair Group 1 and 2

Dancer Group 1 and 2

Scholar Group 1 and 2

----

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

San d'Oria

Windurst

Rise of the Zilart
- Currently only works up to the Mission "Gate of the Gods", which is far enough for Sky access.

Chains of Promathia
- Works up to Promyvion - Vahzl

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
- Unreleased

----

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

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

What Works

2013-02-06T03:15:05Z

PrBlah:

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

Alexander

Diabolos

Odin

Note: Astral Flow is not implemented for all avatars
----

=== Besieged ===

It is currently unknown as to whether this works or not, however when you check the Besieged status through "Region Info" they are in an almost constant state of attack, which leads me to believe that it does not work.

----

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

Dynamis - Xarcabard

Dynamis - Buburimu

Dynamis - Qufim

Dynamis - Valkurm

Dynamis - Tavnazia

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

Adamantoise

Aspidochelone

Behemoth

King Behemoth

Fafnir

Nidhogg

Vrtra

Absolute Virtue

Jormungand

Tiamat

==== Sky Gods ====

Byakko

Genbu

Seiryu
- Attacks with both "fists."

Suzaku

Kirin
- Kirin does not spawn mini gods (unconfirmed)

==== Jailers ====

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

Carbuncle working

Fenrir workign with bugs

Red writing = Not working

==== Assault ====

===== Private Second Class =====

Leujaoam Cleansing

Imperial Agent Rescue

Excavation Duty

Seagull Grounded

Golden Salvage

Nyzul Isle Investigation

===== Private First 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 ====

As far as I know most of these do not work, however I have been informed that there are a handful that DO work, no specifics as of yet.

===== 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 = 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 
3-BCNM / KSNM are not level capped at this time. 

====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 flg: 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 -- No level cap, animas do not work

====Spire of Holla====

ENM: Simulant 
Mission: Ancient Flames Beckon -- No level cap, animas do not work

====Spire of Mea====

ENM: Playing Host 
Mission: Ancient Flames Beckon -- No level cap, animas do not work

====Spire of Vahzl====

ENM: Pulling the Plug 
Mission: Desires of Emptiness 

====Monarch Linn====

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

====The Shrouded Maw====

ENM: Test Your Mite 
Mission: Darkness Named -- No level cap, 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

White Mage

Black Mage

Red Mage 

Thief

==== Advanced Jobs ====

Paladin
:* Shield Bash does no damage
:* Most job abilities are not properly implemented

Dark Knight

Beastmaster
:* Charm Functions some what but there are still bugs.

Ranger

Bard

Summoner

Samurai

Ninja

Dragoon
:* Wyvern attacks on engage, Spirit Link does not work, Healing Breath does not heal allies, status removal breaths are not implemented

Blue Mage
:* Can learn spells, most do not work, very early work in progress.

Puppetmaster

Corsair
:* Quest is available, but rolls do not work.

Dancer
:* Quest is not available, some features work, some work incorrectly.

Scholar

----

=== Merits ===

"The code that loads them into your character is remarked out right now" - whasf

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 and 2

Monk Group 1 and 2

White Mage Group 1 and 2

Black Mage Group 1 and 2

Red Mage Group 1 and 2

Thief Group 1 and 2

Paladin Group 1 and 2

Dark Knight Group 1 and 2

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

Ninja Group 1 and 2

Dragoon Group 1 and 2

Blue Mage Group 1 and 2

Corsair Group 1 and 2

Puppetmaster Group 1 and 2

Corsair Group 1 and 2

Dancer Group 1 and 2

Scholar Group 1 and 2

----

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

San d'Oria

Windurst

Rise of the Zilart
- Currently only works up to the Mission "Gate of the Gods", which is far enough for Sky access.

Chains of Promathia
- Works up to Promyvion - Vahzl

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
- Unreleased

----

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

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

Database

2013-02-04T03:35:36Z

PrBlah:

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

bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, elevators, exp_base, exp_table, fishing_fish, fishing_lure, fishing_rod, fishing_zone, 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.

Basic database primer

2013-02-04T01:54:54Z

PrBlah:

This page is meant to sort of explain the ropes of navigating a database, and kind of give a rough primer for SQL novices so that they can learn to crawl, then walk, and then maybe even dance a little. I'm going to assume you're using Navicat, since you're not familiar with a database and that's what Bluekirby0's guides recommend.

==Lesson One: Backups, backups, backups==

First off, a sort of warning with SQL. There's no "undo" function. If you change something, it's changed. If you don't remember what it used to be, there's not really a way to get that back. If you're doing something risky like editing character tables, click on "Tables" in the tree on the left side, and select the accounts and char tables. Right click and select "Dump Tables." This will let you make an SQL file that has a copy of your database, in case you make a mistake. Using this file is similar to updating your database normally, except you'll have to manually drop (delete) the tables before you can put the old data back into them.

Secondly, there's two types of tables: indexed and unindexed. Indexed tables will have one value that must always be unique. In the case of Darkstar, this will be things like itemId, npcid, and mobid. Unindexed tables can have duplicate values, and are also slower to query, although the speed difference may not be noticeable. Some examples of unindexed tables are item_mods, char_titles, and char_vars. These tables have their uses, but generally if you can store data in one or the other, and the data is going to be persistent and frequent like which outpost warps a character has unlocked, you should use indexed tables.

Thirdly, you can save queries. I have a "Customizations" query saved that changes a number of things so that I can quickly rechange any tables that get updated. This way, the inventory clutter in dynamis will go back to stacking, I'll have Sekkanoki at L40, and I can use Judge's Cap and Judge's Belt to do haste tests.

Fourthly, a lot of people forget about triggers.sql. That particular file made some changes to the chars table (among others) so that if a character is deleted, their entries in all the other character related tables are cleared out. Just remember that this can and will happen if you delete anything from chars.

Fifthly, comments. You can use these when necessary to keep track of what something means, or just as little post it notes. A comment has to be prefixed by two dashes, and may need a space before and after the dash, depending on usage. Here's an example of comments in use:

-- Missing mIDs

-- Certain

UPDATE `item_armor` SET mID = '327' WHERE itemId IN (10452,10502,10602,10878,11971); -- Rubeus

-- Confident

UPDATE `item_armor` SET mID = '16' WHERE itemId = 11525; -- Maestria Mask

You can also use comments if you want to temporarily remove a line from usage, but you don't want to delete the line from your query permanently.

==Lesson Two: The SELECT Query==

Next, an introduction to building queries.

The most basic query, and the one you'll use the most, is a SELECT query. A SELECT query fetches data from a data source, and lists it out for you. A good rule of thumb is to use a SELECT query to see what you'll be changing or deleting before you do it. It's also a safe way to introduce yourself to SQL, since nothing is being changed. The syntax is:

SELECT '''columns''' FROM '''data source''' WHERE '''conditions''';

The capitalization isn't necessary for the query to work, but it can make queries easier to read, once you're used to them. The semi-colon at the end is required, however. You can use a grave (above tab and next to the number 1, often called the "tilde key") instead of quotes in some places, and also around table_names. However, you can't always use single quotes and double quotes in those situations.

'''columns''' is a list of the columns you want to see. Alternatively, you can just use an asterisk (*) to view all columns.

'''data source''' is a table, or multiple tables, that you want to get data from.

'''conditions''' are things that help you narrow down your search. There's actually quite a few of these that you can use, which I'll go into.

... WHERE column = "value";

This is the most basic of conditionals. An example would be WHERE itemId = 17440; to bring up the Kraken Club. You could also use WHERE mobname = "Serket"; Note that numbers do not require quotation marks, but words will require either single or double quotes.

... WHERE column LIKE "%value%";

The percentage sign acts as a wild card, so "Kraken_%", "12%", or "%Behemo%" would all be the sort of thing you could use.

... WHERE column IN (value1, value2, value3...);

This lets you specify multiple values that can be matched. For example, WHERE itemId IN (15270, 15543); would return the Walahra Turban and Rajas Ring.

... WHERE column BETWEEN value1 AND value2;

Here you can specify a range of values. WHERE npcid BETWEEN 1000 AND 3000; would return all NPCs with an ID between 1000 and 3000.

You can also do a complex query, such as WHERE mobname LIKE "Goblin_%" AND zoneid = 154; to specify any mobname starting with "Goblin_" in zone 154 (Dragon's Aery.)

So, let's put that all together. Here's a query I used to find armor that was missing the appearance information:

SELECT * FROM item_armor WHERE MId = 0 AND slot NOT IN (1,2,3,4,8,512,1024,6144,24576,32768) ORDER BY level ASC;

The MId is the appearance for a piece of armor. 0 will have no appearance at all. Also notice the "NOT" used to negate the second query. That means to return results that DON'T match what you're specifying. Finally, you haven't seen ORDER BY yet. You can use this to sort your results by a column, either ASCending or DESCending. In this case, I'm sorting by level from 1 to 99.

==Lesson Three: Complex Selects==

Now to introduce you to queries that use multiple tables. You might have wondered why we use itemId in pretty much every table that has items in it. This makes it easy to get matching information from multiple tables. Here's an example I've been using pretty often lately:

SELECT npcid, npc_list.name, zone_settings.name, zone_settings.zoneid, pos_x, pos_y, pos_z, animation, hex(look) FROM npc_list, zone_settings WHERE npc_list.zoneid = zone_settings.zoneid AND npc_list.zoneid = 14;

You'll notice this query is a lot longer than what you've seen so far. This query fetches a few columns from the npc_list table, along with the name of the zone for convenience. That's literally the only reason I included zone_settings, in this case.

The second thing you may have noticed is that I didn't use * this time. npc_list has a lot of columns, and some of them I didn't care about, and * would have brought in all of them, along with all of zone_settings. This also lets me control the order of the columns. As part of this, I used npc_list.name to specify I wanted the name column in the npc_list table, since zone_settings also has a name column.

The third thing you should see is that I used multiple tables after "FROM." That's how the whole thing works, and you can really use as many tables as you can logically connect here.

Speaking of logically connected, the fourth thing to see is "WHERE npc_list.zoneid = zone_settings.zoneid." When you're querying multiple tables, you need a way to logically connect the two so that the data can all be retrieved. In this case, that part of the query tells Navicat that npc_list's zoneid should match zone_setting's zoneid. And there's why we use itemId on so many tables; we can connect them that way.

The bonus, fifth thing to learn here is hex(look). This is just telling Navicat that the data in the "look" column should be displayed as hexadecimal. Since that's what it's stored in anyway, that actually makes it visible to you, instead of a mostly blank column.

Just how complex can this get?

SELECT mobname, mob_droplist.dropid, mob_droplist.itemid, item_basic.name, type, rate, zoneid, pos_x, pos_y, pos_z FROM mob_spawn_points, mob_groups, mob_droplist, item_basic WHERE mob_spawn_points.groupid = mob_groups.groupid AND mob_groups.dropid = mob_droplist.dropid AND mob_droplist.itemid = item_basic.itemid AND mob_droplist.itemid = 1044;

This particular query will return all mobs that drop item 1044 (oztroja_coffer_key).

==Lesson Four: Advanced SELECT Concepts==

What if we SELECTed results... from results of another SELECT? You can totally do that, and I'm terrible at it. So if you want to play around, here's a query to spend some time fiddling with.

SELECT mobname, mob_droplist.dropid, item_basic.name, mob_droplist.itemid, type, rate, zoneid, pos_x, pos_y, pos_z
FROM (SELECT mobname, zoneid, pos_x, pos_y, pos_z, dropid
FROM mob_groups, mob_spawn_points
WHERE mob_spawn_points.groupid = mob_groups.groupid AND mobname = "thunder_elemental"
GROUP BY mob_groups.groupid)
AS groups, mob_droplist, item_basic WHERE groups.dropid = mob_droplist.dropid AND mob_droplist.itemid = item_basic.itemid;

This query will retrieve the drops for any sets of the mob Thunder_Elemental. What I mean by that is that you'll only get one Thunder_Elemental for Sanctuary of Zi'Tah, although you'll get multiple rows because that mob has multiple drops.

I can only offer you two points here. First, the "AS unique_name" is necessary whenever you do this trick. Second, the GROUP BY near the end. This will return only one row for each result in the specified column(s).

==Lesson Five: INSERT==

INSERT queries put new data into a table. If the table is indexed and you try to use a duplicate index, the query will fail. There's two ways to INSERT: one at a time, or in bulk. One at a time looks like this:

INSERT INTO `npc_list` VALUES ('17277171', '_3e0', '0', '184.516', '-7.146', '14.297', '1', '40', '40', '9', '0', '0', '0', '4099', 0x0200000000000000000000000000000000000000, '0', '122');

INSERT INTO `npc_list` VALUES ('17277172', '_3e1', '0', '-184.516', '-7.146', '14.298', '1', '40', '40', '9', '0', '0', '0', '4099', 0x0200000000000000000000000000000000000000, '0', '122');

Because no columns are specified, it just starts inserting the data into each column, in order. If you come up short, then the columns are filled with their default value (if applicable.) If you have too many, your INSERT fails.

INSERT INTO `item_mods` (itemId, modId, value) VALUES (1,1,1), (2,2,2), (3,3,3), ... (1000,1000,1000);

I used an ellipsis to shorten things, but this query would insert 1000 rows into the item_mods table... or fail. These queries can actually be quite a bit faster than single inserts.

==Lesson Six: UPDATE and DELETE==

UPDATEs and DELETEs are easier to understand once you've got a grasp on SELECT. They do pretty much the same thing, except instead of listing results, they actually change or delete rows. Here's an example of each:

UPDATE weapon_skills SET skilllevel = 276 WHERE name IN ("ascetics_fury","atonement","kings_justice","insurgency","drakesbane","tachi_rana");

DELETE FROM item_mods WHERE itemid IN (13215, 13606) AND modid = 167;

There's only two things to keep in mind here. The first is that there's no "are you sure?" prompt. The second is that if you don't specify a condition, the query runs against everything. UPDATE item_basic SET name = 'kraken_club'; will rename everything to kraken_club. DELETE FROM chars; just deleted all of your characters, and thanks to the triggers on chars, it took out your inventory, levels, and more.

==Lesson Seven: Abusing Defaults to Customize Your Server==

Short lesson. Most values have default values, and sometimes they have these values for a reason. For example, char_points.windurst_supply has a default value of 0. That particular column stores which conquest teleports have been unlocked. And there's no reason you can't use Design Table to change that default to 12582880, which unlocks all Outpost Warps :)

Another example would be char_jobs.genkai, with a default of 50. This sets every new player's level cap to 50, until they've done quests with Maat. If you change that default to 75, then no new players will have to deal with Maat.

The only thing to consider in this situation is that some players might not want those enhancements. By placing them on an NPC, the player gets a choice between those spoils of war, and vanilla gameplay. However, it's your server, so make the choices you think are right.

Basic database primer

2013-02-03T09:44:12Z

PrBlah: Created page with "This page is meant to sort of explain the ropes of navigating a database, and kind of give a rough primer for SQL novices so that they can learn to crawl, then walk, and then ..."

This page is meant to sort of explain the ropes of navigating a database, and kind of give a rough primer for SQL novices so that they can learn to crawl, then walk, and then maybe even dance a little. I'm going to assume you're using Navicat, since you're not familiar with a database and that's what Bluekirby0's guides recommend.

==Lesson One: Backups, backups, backups==

First off, a sort of warning with SQL. There's no "undo" function. If you change something, it's changed. If you don't remember what it used to be, there's not really a way to get that back. If you're doing something risky like editing character tables, click on "Tables" in the tree on the left side, and select the accounts and char tables. Right click and select "Dump Tables." This will let you make an SQL file that has a copy of your database, in case you make a mistake. Using this file is similar to updating your database normally, except you'll have to manually drop (delete) the tables before you can put the old data back into them.

Secondly, there's two types of tables: indexed and unindexed. Indexed tables will have one value that must always be unique. In the case of Darkstar, this will be things like itemId, npcid, and mobid. Unindexed tables can have duplicate values, and are also slower to query, although the speed difference may not be noticeable. Some examples of unindexed tables are item_mods, char_titles, and char_vars. These tables have their uses, but generally if you can store data in one or the other, and the data is going to be persistent and frequent like which outpost warps a character has unlocked, you should use indexed tables.

Thirdly, you can save queries. I have a "Customizations" query saved that changes a number of things so that I can quickly rechange any tables that get updated. This way, the inventory clutter in dynamis will go back to stacking, I'll have Sekkanoki at L40, and I can use Judge's Cap and Judge's Belt to do haste tests.

Fourthly, a lot of people forget about triggers.sql. That particular file made some changes to the chars table (among others) so that if a character is deleted, their entries in all the other character related tables are cleared out. Just remember that this can and will happen if you delete anything from chars.

Fifthly, comments. You can use these when necessary to keep track of what something means, or just as little post it notes. A comment has to be prefixed by two dashes, and may need a space before and after the dash, depending on usage. Here's an example of comments in use:

-- Missing mIDs

-- Certain

UPDATE `item_armor` SET mID = '327' WHERE itemId IN (10452,10502,10602,10878,11971); -- Rubeus

-- Confident

UPDATE `item_armor` SET mID = '16' WHERE itemId = 11525; -- Maestria Mask

You can also use comments if you want to temporarily remove a line from usage, but you don't want to delete the line from your query permanently.

==Lesson Two: The SELECT Query==

Next, an introduction to building queries.

The most basic query, and the one you'll use the most, is a SELECT query. A SELECT query fetches data from a data source, and lists it out for you. A good rule of thumb is to use a SELECT query to see what you'll be changing or deleting before you do it. It's also a safe way to introduce yourself to SQL, since nothing is being changed. The syntax is:

SELECT '''columns''' FROM '''data source''' WHERE '''conditions''';

The capitalization isn't necessary for the query to work, but it can make queries easier to read, once you're used to them. The semi-colon at the end is required, however. You can use a grave (above tab and next to the number 1, often called the "tilde key") instead of quotes in some places, and also around table_names. However, you can't always use single quotes and double quotes in those situations.

'''columns''' is a list of the columns you want to see. Alternatively, you can just use an asterisk (*) to view all columns.

'''data source''' is a table, or multiple tables, that you want to get data from.

'''conditions''' are things that help you narrow down your search. There's actually quite a few of these that you can use, which I'll go into.

... WHERE column = "value";

This is the most basic of conditionals. An example would be WHERE itemId = 17440; to bring up the Kraken Club. You could also use WHERE mobname = "Serket"; Note that numbers do not require quotation marks, but words will require either single or double quotes.

... WHERE column LIKE "%value%";

The percentage sign acts as a wild card, so "Kraken_%", "12%", or "%Behemo%" would all be the sort of thing you could use.

... WHERE column IN (value1, value2, value3...);

This lets you specify multiple values that can be matched. For example, WHERE itemId IN (15270, 15543); would return the Walahra Turban and Rajas Ring.

... WHERE column BETWEEN value1 AND value2;

Here you can specify a range of values. WHERE npcid BETWEEN 1000 AND 3000; would return all NPCs with an ID between 1000 and 3000.

You can also do a complex query, such as WHERE mobname LIKE "Goblin_%" AND zoneid = 154; to specify any mobname starting with "Goblin_" in zone 154 (Dragon's Aery.)

So, let's put that all together. Here's a query I used to find armor that was missing the appearance information:

SELECT * FROM item_armor WHERE MId = 0 AND slot NOT IN (1,2,3,4,8,512,1024,6144,24576,32768) ORDER BY level ASC;

The MId is the appearance for a piece of armor. 0 will have no appearance at all. Also notice the "NOT" used to negate the second query. That means to return results that DON'T match what you're specifying. Finally, you haven't seen ORDER BY yet. You can use this to sort your results by a column, either ASCending or DESCending. In this case, I'm sorting by level from 1 to 99.

==Lesson Three: Complex Selects==

Now to introduce you to queries that use multiple tables. You might have wondered why we use itemId in pretty much every table that has items in it. This makes it easy to get matching information from multiple tables. Here's an example I've been using pretty often lately:

SELECT npcid, npc_list.name, zone_settings.name, zone_settings.zoneid, pos_x, pos_y, pos_z, animation, hex(look) FROM npc_list, zone_settings WHERE npc_list.zoneid = zone_settings.zoneid AND npc_list.zoneid = 14;

You'll notice this query is a lot longer than what you've seen so far. This query fetches a few columns from the npc_list table, along with the name of the zone for convenience. That's literally the only reason I included zone_settings, in this case.

The second thing you may have noticed is that I didn't use * this time. npc_list has a lot of columns, and some of them I didn't care about, and * would have brought in all of them, along with all of zone_settings. This also lets me control the order of the columns. As part of this, I used npc_list.name to specify I wanted the name column in the npc_list table, since zone_settings also has a name column.

The third thing you should see is that I used multiple tables after "FROM." That's how the whole thing works, and you can really use as many tables as you can logically connect here.

Speaking of logically connected, the fourth thing to see is "WHERE npc_list.zoneid = zone_settings.zoneid." When you're querying multiple tables, you need a way to logically connect the two so that the data can all be retrieved. In this case, that part of the query tells Navicat that npc_list's zoneid should match zone_setting's zoneid. And there's why we use itemId on so many tables; we can connect them that way.

The bonus, fifth thing to learn here is hex(look). This is just telling Navicat that the data in the "look" column should be displayed as hexadecimal. Since that's what it's stored in anyway, that actually makes it visible to you, instead of a mostly blank column. Another trick like this you may find useful is unique(column_name). This will tell Navicat to only return the first row it finds for that column. For example, in mob_spawn_points, unique(mobname) will only return one row for each type of mob. You'll only get one Goblin_Reaper and one Goblin_Mugger, even if the zone has 15 of each.

Just how complex can this get?

SELECT mobname, mob_droplist.dropid, mob_droplist.itemid, item_basic.name, type, rate, zoneid, pos_x, pos_y, pos_z FROM mob_spawn_points, mob_groups, mob_droplist, item_basic WHERE mob_spawn_points.groupid = mob_groups.groupid AND mob_groups.dropid = mob_droplist.dropid AND mob_droplist.itemid = item_basic.itemid AND mob_droplist.itemid = 1044;

This particular query will return all mobs that drop item 1044 (oztroja_coffer_key).

==Lesson Four: Advanced SELECT Concepts==

What if we SELECTed results... from results of another SELECT? You can totally do that, and I'm terrible at it. So if you want to play around, here's a query to spend some time fiddling with.

SELECT mobname, mob_droplist.dropid, item_basic.name, mob_droplist.itemid, type, rate, zoneid, pos_x, pos_y, pos_z
FROM (SELECT mobname, zoneid, pos_x, pos_y, pos_z, dropid
FROM mob_groups, mob_spawn_points
WHERE mob_spawn_points.groupid = mob_groups.groupid AND mobname = "thunder_elemental"
GROUP BY mob_groups.groupid)
AS groups, mob_droplist, item_basic WHERE groups.dropid = mob_droplist.dropid AND mob_droplist.itemid = item_basic.itemid;

This query will retrieve the drops for any sets of the mob Thunder_Elemental. What I mean by that is that you'll only get one Thunder_Elemental for Sanctuary of Zi'Tah, although you'll get multiple rows because that mob has multiple drops.

I can only offer you two points here. First, the "AS unique_name" is necessary whenever you do this trick. Second, the GROUP BY near the end. This operates as a bit of an "ORDER BY" along with a UNIQUE().

==Lesson Five: INSERT==

INSERT queries put new data into a table. If the table is indexed and you try to use a duplicate index, the query will fail. There's two ways to INSERT: one at a time, or in bulk. One at a time looks like this:

INSERT INTO `npc_list` VALUES ('17277171', '_3e0', '0', '184.516', '-7.146', '14.297', '1', '40', '40', '9', '0', '0', '0', '4099', 0x0200000000000000000000000000000000000000, '0', '122');

INSERT INTO `npc_list` VALUES ('17277172', '_3e1', '0', '-184.516', '-7.146', '14.298', '1', '40', '40', '9', '0', '0', '0', '4099', 0x0200000000000000000000000000000000000000, '0', '122');

Because no columns are specified, it just starts inserting the data into each column, in order. If you come up short, then the columns are filled with their default value (if applicable.) If you have too many, your INSERT fails.

INSERT INTO `item_mods` (itemId, modId, value) VALUES (1,1,1), (2,2,2), (3,3,3), ... (1000,1000,1000);

I used an ellipsis to shorten things, but this query would insert 1000 rows into the item_mods table... or fail. These queries can actually be quite a bit faster than single inserts.

==Lesson Six: UPDATE and DELETE==

UPDATEs and DELETEs are easier to understand once you've got a grasp on SELECT. They do pretty much the same thing, except instead of listing results, they actually change or delete rows. Here's an example of each:

UPDATE weapon_skills SET skilllevel = 276 WHERE name IN ("ascetics_fury","atonement","kings_justice","insurgency","drakesbane","tachi_rana");

DELETE FROM item_mods WHERE itemid IN (13215, 13606) AND modid = 167;

There's only two things to keep in mind here. The first is that there's no "are you sure?" prompt. The second is that if you don't specify a condition, the query runs against everything. UPDATE item_basic SET name = 'kraken_club'; will rename everything to kraken_club. DELETE FROM chars; just deleted all of your characters, and thanks to the triggers on chars, it took out your inventory, levels, and more.

==Lesson Seven: Abusing Defaults to Customize Your Server==

Short lesson. Most values have default values, and sometimes they have these values for a reason. For example, char_points.windurst_supply has a default value of 0. That particular column stores which conquest teleports have been unlocked. And there's no reason you can't use Design Table to change that default to 12582880, which unlocks all Outpost Warps :)

Another example would be char_jobs.genkai, with a default of 50. This sets every new player's level cap to 50, until they've done quests with Maat. If you change that default to 75, then no new players will have to deal with Maat.

The only thing to consider in this situation is that some players might not want those enhancements. By placing them on an NPC, the player gets a choice between those spoils of war, and vanilla gameplay. However, it's your server, so make the choices you think are right.

How to Add an Item

2013-02-02T22:04:20Z

PrBlah:

by PrBlahBlahtson

Okay, time for a very basic and probably ugly tutorial on making items and finding appearances. If someone wants to improve it for user friendliness and formatting, feel free.

==How do I make an item?==

Item id: Find it on ffxiah.com. The itemid is part of the URL.

Not all tables are required. Except item_basic. ''item_basic is always required.''

'''item_basic''' -- I'm guessing that flags handles rare/ex, and probably some other things.

'''item_usable''' -- If it's usable, it goes here. Think clusters, potions, and items that have charges.

'''item_armor''' -- The name is deceiving. If you want the item to be equipped, it must exist in this table, even if it's a weapon. Determines the level, jobs, appearance, slot(s) it can be equipped in, and what slots should be turned off in the case of 2hd weapons, or cloaks with hoods. I've never puzzled out what scriptType is for.

'''item_weapon''' -- For weapons, of course. Determines skill (h2h, sword, etc), damage type (slashing, blunt, etc), how many times it can hit (K Club, Joyeuse, etc,) the delay, and the dmg.

'''item_mods''' -- Stats go here. A list for modId can be found in /scripts/globals/status.lua.

I haven't done much with the other tables.

You can also view the [[Items]] page from the Database guide for a longer explanation of each field, and what the values mean.

One side note: if the item can be equipped and is usable, you may want to add a script to /scripts/globals/items, otherwise you're going to have an error message every time someone puts on or takes off that item. File name of the script should be item_basic.name, not sort_name.

==How do I find an appearance/mId?==

You need a GM account. If you haven't made one, make one. While a GM account is technically optional, you are wasting time without one. It's such a horrible waste of time that I won't even cover how to find them using just the database and constant server restarts.

To find an mId, you create an appearance packet (info below.) Then on a GM, you use the command ''@inject file name'' where file name is the name of the packet's file.

==So how do I make an appearance packet?==

You need a hex editor. I have Frhed left over from some project or another. It works and isn't obnoxious, but any hex editor should do. For hex editor novices, type on the left, not on the right. Unless you're entering a text string, then you type on the right. We're not entering text strings.

Make a file in darkstar's root directory (c:\dsp). I use things like "appearance.dat," but the file name is mostly irrelevant, as long as you remember it. You're going to be making an appearance packet. Here's how they're structured.

51 0c 57 00 08 07 28 11 28 21 28 31 28 41 28 51 a1 61 00 70 80 00

The first four pairs (51 0c 57 00) are pretty much irrelevant for what you're doing. Just use the ones supplied. Technically, they identify the packet type and the packet number, as far as "this is the tenth packet that has been sent."

The fifth pair (08) is the face to use, while the sixth (07) is race. Race may be important with armor, because modId isn't always the same when you're messing with things like swimsuits. Why? Because male and female tarutarus use the same armor models, just a different modId when gender matters.

Every two pairs after that is a slot, in the following order: head, body, hands, legs, feet, main hand, off hand, ranged/instrument. The order is reversed, and it will be necessary to convert between base 10 and base 16.

28 11 is actually 0x1128, except that first digit is just packet formatting, so you're left with 0x128, or 296 in base 10. This is the Summoner's "Caller" set if you're working with armor.

For a second example, a1 61 is 0x61a1, which you trim to 0x1a1 or 417 (Nirvana.)

At the moment, armor mIds seem to go up to around 0x151/337. Weapons go up to about 0x259 or 601. There are gaps by the way, just to keep things interesting.

==Simplifying the process==
So yeah, checking every single mId in a substantial range sucks. Been there, done that, fixed a few dozen pieces of armor that were invisible.

Use SQL queries to simplify life. For example:

SELECT itemid, name, mId FROM item_armor WHERE slot <= 3 AND mId != 0 GROUP BY mId ORDER BY mId ASC;

That query will show you every mId currently in use for main and offhand items. Why would you do this?

If the item you're trying to create looks like a different item, now you know the mId that item uses.

If it's completely unique, then you know the mId won't be in use elsewhere. Look in the gaps. For example, Zanbato is 151 and Mukademaru is 153. Nothing's using 152 right now. We change the packet to use 98 60, @inject appearance.dat and we find... it's just another Zanbato/Hagun. The colors might be slightly different, but yeah, that's a Hagun.

==Finding Monster/NPC appearances==
Wooo, you're in for some fun.

Normal humanoid NPCs will use look data that's very similar to the appearance packet above. Not even kidding. Want an example? Have an example. 0x0100'''0E031210752066306640'''0050006000700000. That's appearance 0e 03 12 10 75 20 66 30 66 40 and so on. The same rules apply. Decimal to hexadecimal, reverse the order of the pairs.

Humanoid NPCs with special appearances or animations (ex: Cid), as well as monsters will use something different. Bahamut is 0x0000'''C105'''00000000000000000000000000000000. 0x05C1 -> 1473. @costume 1473, poof, you're Bahamut. It's that simple. Note that some appearances will require a prefix in the first pair of 00s, such as 05 for the Fomor Thieves in CoP regions.

Quick warnings on @costume:

- @costume 0 to return to normal

- Some costumes require an animation to look right. What's interesting is that Empties in Promyvion seem to have 4 DATs for all 8 elements, so finding those animation IDs may be necessary later on. I haven't explored those yet. They may have their own appearances.

- Due to the above, moving can sometimes show what you're costumed as, even if standing still leaves you invisible. Example: Iron Golem (heads)

- You can't use @animation on yourself while costumed :)

- There are often multiple appearances for the "same" thing. For example, elementals have a set of appearances for wild elementals, and for Summoner pets. We're using the appearance for pets at the moment. Light elementals should have their orbiting spheres. There's probably three or more Carbuncles. Be aware this can happen.

- Some costumes have... interesting effects on your camera. Dualboxing or a partner is suggested. @wallhack and walking into an empty space can be useful as well, since sometimes you're in the floor/air.

- I've had some odd things happen with size after using @costume for extensive periods. We're talking an Elvaan so tall that a Mithra stood as tall as their hip. Either that or the Mithra was extremely short.

- I've found costumes all the way up to 0x94F / 2383, but I haven't really tried to find an end to it :)

- The groupings seem to be somewhat similar to AltanaViewer and Model_Viewer, although they're not necessarily identical. That may help you by finding something that's in the right neighborhood at least.

- Just to really twist the knife, some costumes will only display when you use @costume 0 to return to your normal appearance. An example of this is the Fomor costumes such as 1022. Those appearances have a prefix, which may be related.

Main Page

2013-02-02T21:59:24Z

PrBlah:

'''Welcome to the Unofficial Dark Star Project Wiki'''

== Getting Started ==

[[Building the Server]]

[[Configuring Your Client]]

[[DarkStar Servers]]

[[Script Testing Server]]

== General Reference links ==
[[GM Commands]]

[[ID References]]

[[What Works]]

[[Database]]

== Developer Reference links ==
[[Quests]]

[[Missions]]

[[Core]]

[[Server Data Flow]]

== FAQs/Tutorials ==
[[Make My Character a GM]]

[[Troubleshooting Guide]]

[[Customizing Your Server]]

[[How to Make a Quest]]

[[How to Add an Item]]

== Things that need to be added ==

You can always look at the list of [[Special:WantedPages]] and see if you can clear some of those out by filling in the information

Reference tables (any table that might need to be referenced often)

Source Code documentation (mainly public function documentation and how to communicate between lua scripts and the server)

Checklists for things that are and are not implemented (Eventually I would like to create goal pages that use these checklists, so if you can categorize things in a logical manner, that would be very helpful)

Anything else you can think of that might be helpful for either casual users or developers interested in Dark Star Project.

== Other ==
[http://{{SERVERNAME}}:8765/bak/ Automatically generated wiki backups]

<pre style="display: none"><nowiki>[http://www.dracomiconia.com/proprietary.php?option=2 donotvisitthislinkoryouwillbeblocked]</nowiki></pre>

How to Add an Item

2013-02-02T21:59:01Z

PrBlah: Created page with "by PrBlahBlahtson Okay, time for a very basic and probably ugly tutorial on making items and finding appearances, both for you and anyone else that comes along. If someone w..."

by PrBlahBlahtson

Okay, time for a very basic and probably ugly tutorial on making items and finding appearances, both for you and anyone else that comes along. If someone wants to improve it for user friendliness and formatting, feel free.

==How do I make an item?==

Item id: Find it on ffxiah.com. The itemid is part of the URL.

Not all tables are required. Except item_basic. [i]item_basic is always required.[/i]

'''item_basic''' -- I'm guessing that flags handles rare/ex, and probably some other things.

'''item_usable''' -- If it's usable, it goes here. Think clusters, potions, and items that have charges.

'''item_armor''' -- The name is deceiving. If you want the item to be equipped, it must exist in this table, even if it's a weapon. Determines the level, jobs, appearance, slot(s) it can be equipped in, and what slots should be turned off in the case of 2hd weapons, or cloaks with hoods. I've never puzzled out what scriptType is for.

'''item_weapon''' -- For weapons, of course. Determines skill (h2h, sword, etc), damage type (slashing, blunt, etc), how many times it can hit (K Club, Joyeuse, etc,) the delay, and the dmg.

'''item_mods''' -- Stats go here. A list for modId can be found in /scripts/globals/status.lua.

I haven't done much with the other tables.

You can also view the [[Items]] page from the Database guide for a longer explanation of each field, and what the values mean.

One side note: if the item can be equipped and is usable, you may want to add a script to /scripts/globals/items, otherwise you're going to have an error message every time someone puts on or takes off that item. File name of the script should be item_basic.name, not sort_name.

==How do I find an appearance/mId?==

You need a GM account. If you haven't made one, make one. While a GM account is technically optional, you are wasting time without one. It's such a horrible waste of time that I won't even cover how to find them using just the database and constant server restarts.

To find an mId, you create an appearance packet (info below.) Then on a GM, you use the command ''@inject file name'' where file name is the name of the packet's file.

==So how do I make an appearance packet?==

You need a hex editor. I have Frhed left over from some project or another. It works and isn't obnoxious, but any hex editor should do. For hex editor novices, type on the left, not on the right. Unless you're entering a text string, then you type on the right. We're not entering text strings.

Make a file in darkstar's root directory (c:\dsp). I use things like "appearance.dat," but the file name is mostly irrelevant, as long as you remember it. You're going to be making an appearance packet. Here's how they're structured.

51 0c 57 00 08 07 28 11 28 21 28 31 28 41 28 51 a1 61 00 70 80 00

The first four pairs (51 0c 57 00) are pretty much irrelevant for what you're doing. Just use the ones supplied. Technically, they identify the packet type and the packet number, as far as "this is the tenth packet that has been sent."

The fifth pair (08) is the face to use, while the sixth (07) is race. Race may be important with armor, because modId isn't always the same when you're messing with things like swimsuits. Why? Because male and female tarutarus use the same armor models, just a different modId when gender matters.

Every two pairs after that is a slot, in the following order: head, body, hands, legs, feet, main hand, off hand, ranged/instrument. The order is reversed, and it will be necessary to convert between base 10 and base 16.

28 11 is actually 0x1128, except that first digit is just packet formatting, so you're left with 0x128, or 296 in base 10. This is the Summoner's "Caller" set if you're working with armor.

For a second example, a1 61 is 0x61a1, which you trim to 0x1a1 or 417 (Nirvana.)

At the moment, armor mIds seem to go up to around 0x151/337. Weapons go up to about 0x259 or 601. There are gaps by the way, just to keep things interesting.

==Simplifying the process==
So yeah, checking every single mId in a substantial range sucks. Been there, done that, fixed a few dozen pieces of armor that were invisible.

Use SQL queries to simplify life. For example:

SELECT itemid, name, mId FROM item_armor WHERE slot <= 3 AND mId != 0 GROUP BY mId ORDER BY mId ASC;

That query will show you every mId currently in use for main and offhand items. Why would you do this?

If the item you're trying to create looks like a different item, now you know the mId that item uses.

If it's completely unique, then you know the mId won't be in use elsewhere. Look in the gaps. For example, Zanbato is 151 and Mukademaru is 153. Nothing's using 152 right now. We change the packet to use 98 60, @inject appearance.dat and we find... it's just another Zanbato/Hagun. The colors might be slightly different, but yeah, that's a Hagun.

==Finding Monster/NPC appearances==
Wooo, you're in for some fun.

Normal humanoid NPCs will use look data that's very similar to the appearance packet above. Not even kidding. Want an example? Have an example. 0x0100'''0E031210752066306640'''0050006000700000. That's appearance 0e 03 12 10 75 20 66 30 66 40 and so on. The same rules apply. Decimal to hexadecimal, reverse the order of the pairs.

Humanoid NPCs with special appearances or animations (ex: Cid), as well as monsters will use something different. Bahamut is 0x0000'''C105'''00000000000000000000000000000000. 0x05C1 -> 1473. @costume 1473, poof, you're Bahamut. It's that simple. Note that some appearances will require a prefix in the first pair of 00s, such as 05 for the Fomor Thieves in CoP regions.

Quick warnings on @costume:

- @costume 0 to return to normal

- Some costumes require an animation to look right. What's interesting is that Empties in Promyvion seem to have 4 DATs for all 8 elements, so finding those animation IDs may be necessary later on. I haven't explored those yet. They may have their own appearances.

- Due to the above, moving can sometimes show what you're costumed as, even if standing still leaves you invisible. Example: Iron Golem (heads)

- You can't use @animation on yourself while costumed :)

- There are often multiple appearances for the "same" thing. For example, elementals have a set of appearances for wild elementals, and for Summoner pets. We're using the appearance for pets at the moment. Light elementals should have their orbiting spheres. There's probably three or more Carbuncles. Be aware this can happen.

- Some costumes have... interesting effects on your camera. Dualboxing or a partner is suggested. @wallhack and walking into an empty space can be useful as well, since sometimes you're in the floor/air.

- I've had some odd things happen with size after using @costume for extensive periods. We're talking an Elvaan so tall that a Mithra stood as tall as their hip. Either that or the Mithra was extremely short.

- I've found costumes all the way up to 0x94F / 2383, but I haven't really tried to find an end to it :)

- The groupings seem to be somewhat similar to AltanaViewer and Model_Viewer, although they're not necessarily identical. That may help you by finding something that's in the right neighborhood at least.

- Just to really twist the knife, some costumes will only display when you use @costume 0 to return to your normal appearance. An example of this is the Fomor costumes such as 1022. Those appearances have a prefix, which may be related.

Customizing Your Server

2013-02-02T21:43:37Z

PrBlah:

'''Once you know how to build and configure your server correctly, the next thing you may want to know is how to tweak it to your liking'''

== What can I change? ==

Since the project is open-source, the answer to that is: Absolutely anything, as long as you do not violate the terms of the [http://www.gnu.org/licenses/gpl-2.0.html GPLv2] or [http://www.gnu.org/licenses/gpl.html newer].

== Where do I change things? ==

=== Common Options ===
A lot of the options can be found in scripts/globals/settings.lua including Initial level cap, maximum level allowed on the server, starting gil, starting inventory, unlocking subjobs by default, unlocking advanced jobs by default, and a plethora of other settings to tweak your server. See the file itself for details.

=== Adjusting Experience ===
Experience rate can be found in conf/map_darkstar.conf. Change exp_rate: to whatever multiplier you want. If you set it to 2.0 it will give you double experience for all monsters as per the experience tables.

If you prefer to modify the experience granted directly, you can find those values in the exp_table mysql table. To change the amount of experience required to progress to the next level, modify the exp_base mysql table.

=== Default Character Speed ===
To adjust the default character run speed, edit src/map/baseentity.cpp and look for a line that says

<pre>speed = 40;</pre>

and modify it accordingly. Maximum effective value is 255, and the official test server uses 60.

=== Starting Jobs and Levels ===
If you want to change the default starting level for any/all jobs, in the char_jobs table, you need to set the default value for each 3-letter job code to what you want to be the starting level for that job.

You can also change the jobs you have unlocked by default here, but it is easier to use settings.lua if you want to unlock all jobs at the start. Nevertheless, if you wish to tweak exactly what jobs are unlocked, you can adjust the 'unlocked' field by adding together the values of all the jobs you desire below.

{|class="wikitable sortable zebra"
!Job Name!!Value
|-
|Subjob||1
|-
|Warrior||2
|-
|Monk||4
|-
|White Mage||8
|-
|Black Mage||16
|-
|Red Mage||32
|-
|Thief||64
|-
|Paladin||128
|-
|Dark Night||256
|-
|Beastmaster||512
|-
|Bard||1024
|-
|Ranger||2048
|-
|Samurai||4096
|-
|Ninja||8192
|-
|Dragoon||16384
|-
|Summoner||32768
|-
|Blue Mage||65536
|-
|Corsair||131072
|-
|Puppetmaster||262144
|-
|Dancer||524288
|-
|Scholar||1048576
|-
|}

=== Adjust Healing while Resting ===
In scripts/globals/effects/healing.lua find the lines:

<code>target:addHP(10+(3*math.floor(target:getMainLvl()/10))+(healtime-2+(1+math.floor(target:getMaxHP()/300)))+(target:getMod(MOD_HPHEAL)));</code>

<code>target:addHP(10+(healtime-2)+(target:getMod(MOD_HPHEAL)));</code>

<code>target:addMP(12+(healtime-2)+(target:getMod(MOD_MPHEAL))+(target:getMod(MOD_CLEAR_MIND)*(healtime-2)));</code>

and adjust the 10, 10, and 12 appropriately to change the base healing amounts.

=== Miscellaneous Changes ===
To change the name your server provides when people log in, replace all instances (currently 2) of DarkStar in src/login/lobby.cpp with whatever you want.

=== Player Bonuses NPC ===
To make an NPC that adds things like maps, jobs, and spells will require a basic understanding of LUA scripting and logic. Refer to [[How to Make a Quest]] for a good primer. If all else fails, find an NPC that does what you want and read their code.

First, select the NPC you'd like to modify. The method used on Whasf's server is the "Adventurer's Coupon" turn in, but it's really up to you. Their logic can be located in /dsp/scripts/zones/zone_name/npcs/npc_name.lua. If the file doesn't exist, you can create it from a text document; just make sure it follows the npc_name.lua convention, and not .txt.

Second, decide what has to be done to trigger the bonuses. Just talk to the NPC? Trade an item? Meet specific conditions, such as being Rank 2, or under level 20? Code your conditions accordingly.

Third, program your unlocks. Refer to [[ID References]] for full details on key items, maps, spells, and items. The following code samples cover a few basic rewards:

<pre>
-- Adds all maps
player:addKeyItem(385);
player:addKeyItem(386);
player:addKeyItem(387);
player:addKeyItem(388);
-- ITEMS 389 to 447
z = 389;
while z <= 447 do
player:addKeyItem(z);
z = z + 1;
end
-- KEY ITEMS 1856 to 1893
z = 1856;
while z <= 1893 do
player:addKeyItem(z);
z = z + 1;
end
-- Adds all 3 starting nation rings
player:addItem(13495);
player:addItem(13496);
player:addItem(13497);
-- Unlocks subjob
player:unlockJob(0);
-- Grants gil and gives the appropriate message
player:addGil(500000);
player:messageSpecial(GIL_OBTAINED,500000);
-- Grants a small amount of fame
player:addFame(BASTOK, BAS_FAME*10);
player:addFame(SANDORIA,SAN_FAME*10);
player:addFame(WINDURST,WIN_FAME*10);
player:addFame(NORG, NORG_FAME*10);
-- Unlocks Dark Knight
player:unlockJob(8);
</pre>

Finally, test your NPC for bugs. If anything is wrong, you'll see error messages in the DSGame-server window of your server. Make sure you haven't missed a semi-colon, left a parenthesis open, or missed an "end" after an "if."

Items

2013-02-02T21:37:26Z

PrBlah:

==item_basic==

Stores basic item information that is common to all items. For an item to exist, it must have an entry in this table.

'''item_id''' should match what is found in POLUtils or on ffxiah.com

'''name''' is the long name of an item, such as flask_of_echo_drops. If you're scripting a file, this is the filename you should use.

'''sortname''' is the shortened name, such as echo_drops.

'''stackSize''' determines if an item should stack, and how many should stack. The client acts a bit odd if you stack items that aren't supposed to be stacked, but generally will let you stack things like Frozen Giant Skulls if you want to improve the Dynamis experience, for example.

'''flags''' needs to be investigated

'''aH''' is the auction house category for the item.

'''NoSale''' determines if the item can be sold.

'''BaseSell''' is the value of the item when selling to an NPC, before fame modifier.

==item_armor==

Stores information regarding anything that can be worn; armor, accessory, and weapons, too.

'''itemId''' matches what is found in item_basic.

'''name''' needs to be investigated. Just for readability's sake?

'''level''' is what level the item can be equipped at.

'''jobs''' determines what jobs can equip the item, stored as a bitmask. Simply add the values together to set the jobs. WAR (1) + PLD (64) + DRK (128) = 193

{|class="wikitable sortable zebra"
!Value!!Job
|-
|1||warrior
|-
|-
|2||monk
|-
|-
|4||white mage
|-
|-
|8||black mage
|-
|-
|16||red mage
|-
|-
|32||thief
|-
|-
|64||paladin
|-
|-
|128||dark knight
|-
|-
|256||beastmaster
|-
|-
|512||bard
|-
|-
|1024||ranger
|-
|-
|2048||samurai
|-
|-
|4096||ninja
|-
|-
|8192||dragoon
|-
|-
|16384||summoner
|-
|-
|32768||blue mage
|-
|-
|65536||corsair
|-
|-
|131072||puppetmaster
|-
|-
|262144||dancer
|-
|-
|524288||scholar
|-
|}

'''MId''' determines the appearance for the item. A guide for finding these is pending.

'''shieldSize''' is only used by shields, and determines how much damage they block, and how much damage they'll deal with Shield Bash.

'''scriptType''' needs to be investigated.

'''slot''' determines which slot(s) the item can be worn in, in a bitmask. main hand (1) + off hand (2) = 3.

{|class="wikitable sortable zebra"
!Value!!Valid Slot
|-
|1||main hand
|-
|-
|2||offhand
|-
|-
|4||ranged
|-
|-
|8||ammo
|-
|-
|16||head
|-
|-
|32||body
|-
|-
|64||hands
|-
|-
|128||legs
|-
|-
|256||feet
|-
|-
|512||neck
|-
|-
|1024||belt
|-
|-
|2048||l earring
|-
|-
|4096||r earring
|-
|-
|8192||l ring
|-
|-
|16384||r ring
|-
|-
|32768||cape
|-
|}

'''rslot''' determines which single slot cannot be used while the item is equipped. For example, Vermillion Cloak would reserve the head slot, since head equipment cannot be used with it. This is '''not''' a bitmask, and only one value can be specified.
{|class="wikitable sortable zebra"
!Value!!Reserved Slot
|-
|0||none
|-
|-
|1||main hand
|-
|-
|2||offhand
|-
|-
|3||ranged
|-
|-
|4||ammo
|-
|-
|5||head
|-
|-
|6||body
|-
|-
|7||hands
|-
|-
|8||legs
|-
|-
|9||feet
|-
|-
|10||neck
|-
|-
|11||belt
|-
|-
|12||l earring
|-
|-
|13||r earring
|-
|-
|14||l ring
|-
|-
|15||r ring
|-
|-
|16||cape
|-
|-
|17||"SLOT_LINK" Linkshell?
|-
|}

==item_weapon==

Stores common information for all weapons.

'''itemId''' links the table to item_basic and item_armor, and should match those tables.

'''name''' may just be for readability's sake.

'''skill''' determines which weapon proficiency should be used with the weapon.
{|class="wikitable sortable zebra"
!Value!!Weapon Type
|-
|1||Hand-to-hand
|-
|-
|2||Dagger
|-
|-
|3||Sword
|-
|-
|4||Greatsword
|-
|-
|5||Axe
|-
|-
|6||Great Axe
|-
|-
|7||Scythe
|-
|-
|8||Polearm
|-
|-
|9||Katana
|-
|-
|10||Great Katana
|-
|-
|11||Club
|-
|-
|12||Staff
|-
|-
|24||Gun
|-
|-
|25||Archery
|-
|-
|26||Marksmanship
|-
|-
|27||Throwing
|-
|}

'''dmgType''' determines the type of damage dealt by the weapon. Note that only Hand-to-hand damage will use both hands for jobs such as Monk as of r2491.
{|class="wikitable sortable zebra"
!Value!!Damage Type
|-
|0||Damage type "none"
|-
|-
|1||Piercing
|-
|-
|2||Slashing
|-
|-
|3||Blunt
|-
|-
|4||Hand-to-hand
|-
|-
|5||Crossbow
|-
|-
|6||Gun
|-
|}
'''hit''' is only used for multihit weapons such as Joyeuse or Kraken Club.

'''delay''' determines the delay of the weapon. Ranged Weapons and Ammunition always have -240 their stated delay. For example, Expunger (Delay 360) is stored as 120 delay in the database.

'''dmg''' is the DMG stat for the equipment. Hand-to-hand weapons are always stored with their DMG stat +3. For example, Lizard Cesti has 5 instead of 2.

'''unlock_index''' probably refers to the in-progress weapon unlock system.

==item_mods==

Stores uncommon information, from Defense to "Enhances Dual Wield Effect."

item_mods is an unindexed table. As such, always keep in mind that it's possible to have duplicate values, which darkstar will cheerfully use without questioning them.

'''itemId''' links the table back to the item via item_basic, and should always match.

'''modId''' is what is being modified. A list of these values can be found in /scripts/globals/status.lua (listed in hexadecimal,) or in /src/map/modifier.h (listed in hexadecimal.) Remember to convert them to decimal for use in this table.

'''value''' is how much of the modifier to grant, and can be positive or negative. It's best to research any modifier you're unsure of, as some are stored and applied in unexpected ways, such as Magic Damage Taken being stored as amount/256, while Physical Damage Taken is stored as amount%.

==item_furniture==

Stores information regarding moghouse furniture.

'''itemId''' links back to item_basic, and should always match.

'''name''' may just be for readability's sake, and is the long name for the item.

'''storage''' is how much storage to grant for each item placed. The core will cap the total at 80.

'''moghancement''' needs to be researched.

'''element''' is the elemental alignment of the furniture.

'''aura''' needs to be researched (strength of effect?)

==item_usable==

Stores information regarding items that can be used. An item cannot be used unless it is in this table.

'''itemid''' links this table back to item_basic, and should match.

'''subid''' seems to primarily be used with spell scrolls, and probably just stores the spellid to be unlocked.

'''name''' may just be for readability's sake.

'''validTargets''' is a bitmask storing what the item can be used on. Being a bitmask, the values should be added for each valid target type.
{|class="wikitable sortable zebra"
!Value!!Valid target
|-
|1||Self
|-
|-
|2||Player in user's party
|-
|-
|4||Enemy
|-
|-
|8||Player in user's alliance
|-
|-
|16||Players outside of user's party/alliance
|-
|-
|32||Dead players
|-
|-
|64||NPCs
|-
|}

'''activation''' needs to be researched

'''animation''' determines which animation should be used with the item.

'''animation time''' needs to be researched, but probably determines how long the player can't move for the item usage to succeed.

'''maxCharges''' is the maximum number of usages.

'''useDelay''' is likely how long the item must be equipped before it can be used.

'''reuseDelay''' is likely how long must pass between item uses.

'''aoe''' is a simple binary on whether the item is AoE or not (0 = false, 1 = true.)

==item_latents==

Need to research this table.

==item_weapon_unlock==

Need to research this table. Looks like a mixture of item_weapon, and how many weapon skill "points" are required to unlock it.

==item_puppet==

The itemId, name, slot, and "element" of each automaton piece. As PUP isn't in use, this table may change substantially in the future.

Items

2013-02-02T21:31:17Z

PrBlah:

==item_basic==

Stores basic item information that is common to all items. For an item to exist, it must have an entry in this table.

'''item_id''' should match what is found in POLUtils or on ffxiah.com

'''name''' is the long name of an item, such as flask_of_echo_drops. If you're scripting a file, this is the filename you should use.

'''sortname''' is the shortened name, such as echo_drops.

'''stackSize''' determines if an item should stack, and how many should stack. The client acts a bit odd if you stack items that aren't supposed to be stacked, but generally will let you stack dynamis money drops, for example.

'''flags''' needs to be investigated

'''aH''' is the auction house category for the item.

'''NoSale''' determines if the item can be sold.

'''BaseSell''' is the value of the item when selling to an NPC, before fame modifier.

==item_armor==

Stores information regarding anything that can be worn; armor, accessory, and weapons, too.

'''itemId''' matches what is found in item_basic.

'''name''' needs to be investigated. Just for readability's sake?

'''level''' is what level the item can be equipped at.

'''jobs''' determines what jobs can equip the item, stored as a bitmask. Simply add the values together to set the jobs. WAR (1) + PLD (64) + DRK (128) = 193

{|class="wikitable sortable zebra"
!Value!!Job
|-
|1||warrior
|-
|-
|2||monk
|-
|-
|4||white mage
|-
|-
|8||black mage
|-
|-
|16||red mage
|-
|-
|32||thief
|-
|-
|64||paladin
|-
|-
|128||dark knight
|-
|-
|256||beastmaster
|-
|-
|512||bard
|-
|-
|1024||ranger
|-
|-
|2048||samurai
|-
|-
|4096||ninja
|-
|-
|8192||dragoon
|-
|-
|16384||summoner
|-
|-
|32768||blue mage
|-
|-
|65536||corsair
|-
|-
|131072||puppetmaster
|-
|-
|262144||dancer
|-
|-
|524288||scholar
|-
|}

'''MId''' determines the appearance for the item. A guide for finding these is pending.

'''shieldSize''' is only used by shields, and determines how much damage they block, and how much damage they'll deal with Shield Bash.

'''scriptType''' needs to be investigated.

'''slot''' determines which slot(s) the item can be worn in, in a bitmask. main hand (1) + off hand (2) = 3.

{|class="wikitable sortable zebra"
!Value!!Valid Slot
|-
|1||main hand
|-
|-
|2||offhand
|-
|-
|4||ranged
|-
|-
|8||ammo
|-
|-
|16||head
|-
|-
|32||body
|-
|-
|64||hands
|-
|-
|128||legs
|-
|-
|256||feet
|-
|-
|512||neck
|-
|-
|1024||belt
|-
|-
|2048||l earring
|-
|-
|4096||r earring
|-
|-
|8192||l ring
|-
|-
|16384||r ring
|-
|-
|32768||cape
|-
|}

'''rslot''' determines which single slot cannot be used while the item is equipped. For example, Vermillion Cloak would reserve the head slot, since head equipment cannot be used with it. This is '''not''' a bitmask, and only one value can be specified.
{|class="wikitable sortable zebra"
!Value!!Reserved Slot
|-
|0||none
|-
|-
|1||main hand
|-
|-
|2||offhand
|-
|-
|3||ranged
|-
|-
|4||ammo
|-
|-
|5||head
|-
|-
|6||body
|-
|-
|7||hands
|-
|-
|8||legs
|-
|-
|9||feet
|-
|-
|10||neck
|-
|-
|11||belt
|-
|-
|12||l earring
|-
|-
|13||r earring
|-
|-
|14||l ring
|-
|-
|15||r ring
|-
|-
|16||cape
|-
|-
|17||"SLOT_LINK" Linkshell?
|-
|}

==item_weapon==

Stores common information for all weapons.

'''itemId''' links the table to item_basic and item_armor, and should match those tables.

'''name''' may just be for readability's sake.

'''skill''' determines which weapon proficiency should be used with the weapon.
{|class="wikitable sortable zebra"
!Value!!Weapon Type
|-
|1||Hand-to-hand
|-
|-
|2||Dagger
|-
|-
|3||Sword
|-
|-
|4||Greatsword
|-
|-
|5||Axe
|-
|-
|6||Great Axe
|-
|-
|7||Scythe
|-
|-
|8||Polearm
|-
|-
|9||Katana
|-
|-
|10||Great Katana
|-
|-
|11||Club
|-
|-
|12||Staff
|-
|-
|24||Gun
|-
|-
|25||Archery
|-
|-
|26||Marksmanship
|-
|-
|27||Throwing
|-
|}

'''dmgType''' determines the type of damage dealt by the weapon. Note that only Hand-to-hand damage will use both hands for jobs such as Monk as of r2491.
{|class="wikitable sortable zebra"
!Value!!Damage Type
|-
|0||Damage type "none"
|-
|-
|1||Piercing
|-
|-
|2||Slashing
|-
|-
|3||Blunt
|-
|-
|4||Hand-to-hand
|-
|-
|5||Crossbow
|-
|-
|6||Gun
|-
|}
'''hit''' is only used for multihit weapons such as Joyeuse or Kraken Club.

'''delay''' determines the delay of the weapon. Ranged Weapons and Ammunition always have -240 their stated delay. For example, Expunger (Delay 360) is stored as 120 delay in the database.

'''dmg''' is the DMG stat for the equipment. Hand-to-hand weapons are always stored with their DMG stat +3. For example, Lizard Cesti has 5 instead of 2.

'''unlock_index''' probably refers to the in-progress weapon unlock system.

==item_mods==

Stores uncommon information, from Defense to "Enhances Dual Wield Effect."

item_mods is an unindexed table. As such, always keep in mind that it's possible to have duplicate values, which darkstar will cheerfully use without questioning them.

'''itemId''' links the table back to the item via item_basic, and should always match.

'''modId''' is what is being modified. A list of these values can be found in /scripts/globals/status.lua (listed in hexadecimal,) or in /src/map/modifier.h (listed in hexadecimal.) Remember to convert them to decimal for use in this table.

'''value''' is how much of the modifier to grant, and can be positive or negative. It's best to research any modifier you're unsure of, as some are stored and applied in unexpected ways, such as Magic Damage Taken being stored as amount/256, while Physical Damage Taken is stored as amount%.

==item_furniture==

Stores information regarding moghouse furniture.

'''itemId''' links back to item_basic, and should always match.

'''name''' may just be for readability's sake, and is the long name for the item.

'''storage''' is how much storage to grant for each item placed. The core will cap the total at 80.

'''moghancement''' needs to be researched.

'''element''' is the elemental alignment of the furniture.

'''aura''' needs to be researched (strength of effect?)

==item_usable==

Stores information regarding items that can be used. An item cannot be used unless it is in this table.

'''itemid''' links this table back to item_basic, and should match.

'''subid''' seems to primarily be used with spell scrolls, and probably just stores the spellid to be unlocked.

'''name''' may just be for readability's sake.

'''validTargets''' is a bitmask storing what the item can be used on. Being a bitmask, the values should be added for each valid target type.
{|class="wikitable sortable zebra"
!Value!!Valid target
|-
|1||Self
|-
|-
|2||Player in user's party
|-
|-
|4||Enemy
|-
|-
|8||Player in user's alliance
|-
|-
|16||Players outside of user's party/alliance
|-
|-
|32||Dead players
|-
|-
|64||NPCs
|-
|}

'''activation''' needs to be researched

'''animation''' determines which animation should be used with the item.

'''animation time''' needs to be researched, but probably determines how long the player can't move for the item usage to succeed.

'''maxCharges''' is the maximum number of usages.

'''useDelay''' is likely how long the item must be equipped before it can be used.

'''reuseDelay''' is likely how long must pass between item uses.

'''aoe''' is a simple binary on whether the item is AoE or not (0 = false, 1 = true.)

==item_latents==

Need to research this table.

==item_weapon_unlock==

Need to research this table. Looks like a mixture of item_weapon, and how many weapon skill "points" are required to unlock it.

==item_puppet==

The itemId, name, slot, and "element" of each automaton piece. As PUP isn't in use, this table may change substantially in the future.

Items

2013-02-02T21:27:22Z

PrBlah:

==item_basic==

Stores basic item information that is common to all items. For an item to exist, it must have an entry in this table.

'''item_id''' should match what is found in POLUtils or on ffxiah.com

'''name''' is the long name of an item, such as flask_of_echo_drops. If you're scripting a file, this is the filename you should use.

'''sortname''' is the shortened name, such as echo_drops.

'''stackSize''' determines if an item should stack, and how many should stack. The client acts a bit odd if you stack items that aren't supposed to be stacked, but generally will let you stack dynamis money drops, for example.

'''flags''' needs to be investigated

'''aH''' is the auction house category for the item.

'''NoSale''' determines if the item can be sold.

'''BaseSell''' is the value of the item when selling to an NPC, before fame modifier.

==item_armor==

Stores information regarding anything that can be worn; armor, accessory, and weapons, too.

'''itemId''' matches what is found in item_basic.

'''name''' needs to be investigated. Just for readability's sake?

'''level''' is what level the item can be equipped at.

'''jobs''' determines what jobs can equip the item, stored as a bitmask. Simply add the values together to set the jobs. WAR (1) + PLD (64) + DRK (128) = 193

{|class="wikitable sortable zebra"
!Value!!Job
|-
|1||warrior
|-
|-
|2||monk
|-
|-
|4||white mage
|-
|-
|8||black mage
|-
|-
|16||red mage
|-
|-
|32||thief
|-
|-
|64||paladin
|-
|-
|128||dark knight
|-
|-
|256||beastmaster
|-
|-
|512||bard
|-
|-
|1024||ranger
|-
|-
|2048||samurai
|-
|-
|4096||ninja
|-
|-
|8192||dragoon
|-
|-
|16384||summoner
|-
|-
|32768||blue mage
|-
|-
|65536||corsair
|-
|-
|131072||puppetmaster
|-
|-
|262144||dancer
|-
|-
|524288||scholar
|-
|}

'''MId''' determines the appearance for the item. A guide for finding these is pending.

'''shieldSize''' is only used by shields, and determines how much damage they block, and how much damage they'll deal with Shield Bash.

'''scriptType''' needs to be investigated.

'''slot''' determines which slot(s) the item can be worn in, in a bitmask. main hand (1) + off hand (2) = 3.

{|class="wikitable sortable zebra"
!Value!!Valid Slot
|-
|1||main hand
|-
|-
|2||offhand
|-
|-
|4||ranged
|-
|-
|8||ammo
|-
|-
|16||head
|-
|-
|32||body
|-
|-
|64||hands
|-
|-
|128||legs
|-
|-
|256||feet
|-
|-
|512||neck
|-
|-
|1024||belt
|-
|-
|2048||l earring
|-
|-
|4096||r earring
|-
|-
|8192||l ring
|-
|-
|16384||r ring
|-
|-
|32768||cape
|-
|}

'''rslot''' determines which single slot cannot be used while the item is equipped. For example, Vermillion Cloak would reserve the head slot, since head equipment cannot be used with it. This is '''not''' a bitmask, and only one value can be specified.
{|class="wikitable sortable zebra"
!Value!!Reserved Slot
|-
|0||none
|-
|-
|1||main hand
|-
|-
|2||offhand
|-
|-
|3||ranged
|-
|-
|4||ammo
|-
|-
|5||head
|-
|-
|6||body
|-
|-
|7||hands
|-
|-
|8||legs
|-
|-
|9||feet
|-
|-
|10||neck
|-
|-
|11||belt
|-
|-
|12||l earring
|-
|-
|13||r earring
|-
|-
|14||l ring
|-
|-
|15||r ring
|-
|-
|16||cape
|-
|-
|17||"SLOT_LINK" Linkshell?
|-
|}

==item_weapon==

Stores common information for all weapons.

'''itemId''' links the table to item_basic and item_armor, and should match those tables.

'''name''' may just be for readability's sake.

'''skill''' determines which weapon proficiency should be used with the weapon.
{|class="wikitable sortable zebra"
!Value!!Weapon Type
|-
|1||Hand-to-hand
|-
|-
|2||Dagger
|-
|-
|3||Sword
|-
|-
|4||Greatsword
|-
|-
|5||Axe
|-
|-
|6||Great Axe
|-
|-
|7||Scythe
|-
|-
|8||Polearm
|-
|-
|9||Katana
|-
|-
|10||Great Katana
|-
|-
|11||Club
|-
|-
|12||Staff
|-
|-
|24||Gun
|-
|-
|25||Archery
|-
|-
|26||Marksmanship
|-
|-
|27||Throwing
|-
|}

'''dmgType''' determines the type of damage dealt by the weapon. Note that only Hand-to-hand damage will use both hands for jobs such as Monk as of r2491.
{|class="wikitable sortable zebra"
!Value!!Damage Type
|-
|0||Damage type "none"
|-
|-
|1||Piercing
|-
|-
|2||Slashing
|-
|-
|3||Blunt
|-
|-
|4||Hand-to-hand
|-
|-
|5||Crossbow
|-
|-
|6||Gun
|-
|}
'''hit''' is only used for multihit weapons such as Joyeuse or Kraken Club.

'''delay''' determines the delay of the weapon. Ranged Weapons and Ammunition always have -240 their stated delay.

'''dmg''' is the DMG stat for the equipment. Hand-to-hand weapons are always stored with their DMG stat +3 (I.E. Lizard Cesti has 5 instead of 2).

'''unlock_index''' probably refers to the in-progress weapon unlock system.

==item_mods==

Stores uncommon information, from Defense to "Enhances Dual Wield Effect."

item_mods is an unindexed table. As such, always keep in mind that it's possible to have duplicate values, which darkstar will cheerfully use without questioning them.

'''itemId''' links the table back to the item via item_basic, and should always match.

'''modId''' is what is being modified. A list of these values can be found in /scripts/globals/status.lua (listed in hexadecimal,) or in /src/map/modifier.h (listed in hexadecimal.) Remember to convert them to decimal for use in this table.

'''value''' is how much of the modifier to grant, and can be positive or negative. It's best to research any modifier you're unsure of, as some are stored and applied in unexpected ways, such as Magic Damage Taken being stored as amount/256, while Physical Damage Taken is stored as amount%.

==item_furniture==

Stores information regarding moghouse furniture.

'''itemId''' links back to item_basic, and should always match.

'''name''' may just be for readability's sake, and is the long name for the item.

'''storage''' is how much storage to grant for each item placed. The core will cap the total at 80.

'''moghancement''' needs to be researched.

'''element''' is the elemental alignment of the furniture.

'''aura''' needs to be researched (strength of effect?)

==item_usable==

Stores information regarding items that can be used. An item cannot be used unless it is in this table.

'''itemid''' links this table back to item_basic, and should match.

'''subid''' seems to primarily be used with spell scrolls, and probably just stores the spellid to be unlocked.

'''name''' may just be for readability's sake.

'''validTargets''' is a bitmask storing what the item can be used on. Being a bitmask, the values should be added for each valid target type.
{|class="wikitable sortable zebra"
!Value!!Valid target
|-
|1||Self
|-
|-
|2||Player in user's party
|-
|-
|4||Enemy
|-
|-
|8||Player in user's alliance
|-
|-
|16||Players outside of user's party/alliance
|-
|-
|32||Dead players
|-
|-
|64||NPCs
|-
|}

'''activation''' needs to be researched

'''animation''' determines which animation should be used with the item.

'''animation time''' needs to be researched, but probably determines how long the player can't move for the item usage to succeed.

'''maxCharges''' is the maximum number of usages.

'''useDelay''' is likely how long the item must be equipped before it can be used.

'''reuseDelay''' is likely how long must pass between item uses.

'''aoe''' is a simple binary on whether the item is AoE or not (0 = false, 1 = true.)

==item_latents==

Need to research this table.

==item_weapon_unlock==

Need to research this table. Looks like a mixture of item_weapon, and how many weapon skill "points" are required to unlock it.

==item_puppet==

The itemId, name, slot, and "element" of each automaton piece. As PUP isn't in use, this table may change substantially in the future.

Items

2013-02-02T21:25:52Z

PrBlah:

==item_basic==

Stores basic item information that is common to all items. For an item to exist, it must have an entry in this table.

'''item_id''' should match what is found in POLUtils or on ffxiah.com

'''name''' is the long name of an item, such as flask_of_echo_drops. If you're scripting a file, this is the filename you should use.

'''sortname''' is the shortened name, such as echo_drops.

'''stackSize''' determines if an item should stack, and how many should stack. The client acts a bit odd if you stack items that aren't supposed to be stacked, but generally will let you stack dynamis money drops, for example.

'''flags''' needs to be investigated

'''aH''' is the auction house category for the item.

'''NoSale''' determines if the item can be sold.

'''BaseSell''' is the value of the item when selling to an NPC, before fame modifier.

==item_armor==

Stores information regarding anything that can be worn; armor, accessory, and weapons, too.

'''itemId''' matches what is found in item_basic.

'''name''' needs to be investigated. Just for readability's sake?

'''level''' is what level the item can be equipped at.

'''jobs''' determines what jobs can equip the item, stored as a bitmask. Simply add the values together to set the jobs. WAR (1) + PLD (64) + DRK (128) = 193

{|class="wikitable sortable zebra"
!Value!!Job
|-
|1||warrior
|-
|-
|2||monk
|-
|-
|4||white mage
|-
|-
|8||black mage
|-
|-
|16||red mage
|-
|-
|32||thief
|-
|-
|64||paladin
|-
|-
|128||dark knight
|-
|-
|256||beastmaster
|-
|-
|512||bard
|-
|-
|1024||ranger
|-
|-
|2048||samurai
|-
|-
|4096||ninja
|-
|-
|8192||dragoon
|-
|-
|16384||summoner
|-
|-
|32768||blue mage
|-
|-
|65536||corsair
|-
|-
|131072||puppetmaster
|-
|-
|262144||dancer
|-
|-
|524288||scholar
|-
|}

'''shieldSize''' is only used by shields, and determines how much damage they block, and how much damage they'll deal with Shield Bash.

'''scriptType''' needs to be investigated.

'''slot''' determines which slot(s) the item can be worn in, in a bitmask. main hand (1) + off hand (2) = 3.

{|class="wikitable sortable zebra"
!Value!!Valid Slot
|-
|1||main hand
|-
|-
|2||offhand
|-
|-
|4||ranged
|-
|-
|8||ammo
|-
|-
|16||head
|-
|-
|32||body
|-
|-
|64||hands
|-
|-
|128||legs
|-
|-
|256||feet
|-
|-
|512||neck
|-
|-
|1024||belt
|-
|-
|2048||l earring
|-
|-
|4096||r earring
|-
|-
|8192||l ring
|-
|-
|16384||r ring
|-
|-
|32768||cape
|-
|}

'''rslot''' determines which single slot cannot be used while the item is equipped. For example, Vermillion Cloak would reserve the head slot, since head equipment cannot be used with it. This is '''not''' a bitmask, and only one value can be specified.
{|class="wikitable sortable zebra"
!Value!!Reserved Slot
|-
|0||none
|-
|-
|1||main hand
|-
|-
|2||offhand
|-
|-
|3||ranged
|-
|-
|4||ammo
|-
|-
|5||head
|-
|-
|6||body
|-
|-
|7||hands
|-
|-
|8||legs
|-
|-
|9||feet
|-
|-
|10||neck
|-
|-
|11||belt
|-
|-
|12||l earring
|-
|-
|13||r earring
|-
|-
|14||l ring
|-
|-
|15||r ring
|-
|-
|16||cape
|-
|-
|17||"SLOT_LINK" Linkshell?
|-
|}

==item_weapon==

Stores common information for all weapons.

'''itemId''' links the table to item_basic and item_armor, and should match those tables.

'''name''' may just be for readability's sake.

'''skill''' determines which weapon proficiency should be used with the weapon.
{|class="wikitable sortable zebra"
!Value!!Weapon Type
|-
|1||Hand-to-hand
|-
|-
|2||Dagger
|-
|-
|3||Sword
|-
|-
|4||Greatsword
|-
|-
|5||Axe
|-
|-
|6||Great Axe
|-
|-
|7||Scythe
|-
|-
|8||Polearm
|-
|-
|9||Katana
|-
|-
|10||Great Katana
|-
|-
|11||Club
|-
|-
|12||Staff
|-
|-
|24||Gun
|-
|-
|25||Archery
|-
|-
|26||Marksmanship
|-
|-
|27||Throwing
|-
|}

'''dmgType''' determines the type of damage dealt by the weapon. Note that only Hand-to-hand damage will use both hands for jobs such as Monk as of r2491.
{|class="wikitable sortable zebra"
!Value!!Damage Type
|-
|0||Damage type "none"
|-
|-
|1||Piercing
|-
|-
|2||Slashing
|-
|-
|3||Blunt
|-
|-
|4||Hand-to-hand
|-
|-
|5||Crossbow
|-
|-
|6||Gun
|-
|}
'''hit''' is only used for multihit weapons such as Joyeuse or Kraken Club.

'''delay''' determines the delay of the weapon. Ranged Weapons and Ammunition always have -240 their stated delay.

'''dmg''' is the DMG stat for the equipment. Hand-to-hand weapons are always stored with their DMG stat +3 (I.E. Lizard Cesti has 5 instead of 2).

'''unlock_index''' probably refers to the in-progress weapon unlock system.

==item_mods==

Stores uncommon information, from Defense to "Enhances Dual Wield Effect."

item_mods is an unindexed table. As such, always keep in mind that it's possible to have duplicate values, which darkstar will cheerfully use without questioning them.

'''itemId''' links the table back to the item via item_basic, and should always match.

'''modId''' is what is being modified. A list of these values can be found in /scripts/globals/status.lua (listed in hexadecimal,) or in /src/map/modifier.h (listed in hexadecimal.) Remember to convert them to decimal for use in this table.

'''value''' is how much of the modifier to grant, and can be positive or negative. It's best to research any modifier you're unsure of, as some are stored and applied in unexpected ways, such as Magic Damage Taken being stored as amount/256, while Physical Damage Taken is stored as amount%.

==item_furniture==

Stores information regarding moghouse furniture.

'''itemId''' links back to item_basic, and should always match.

'''name''' may just be for readability's sake, and is the long name for the item.

'''storage''' is how much storage to grant for each item placed. The core will cap the total at 80.

'''moghancement''' needs to be researched.

'''element''' is the elemental alignment of the furniture.

'''aura''' needs to be researched (strength of effect?)

==item_usable==

Stores information regarding items that can be used. An item cannot be used unless it is in this table.

'''itemid''' links this table back to item_basic, and should match.

'''subid''' seems to primarily be used with spell scrolls, and probably just stores the spellid to be unlocked.

'''name''' may just be for readability's sake.

'''validTargets''' is a bitmask storing what the item can be used on. Being a bitmask, the values should be added for each valid target type.
{|class="wikitable sortable zebra"
!Value!!Valid target
|-
|1||Self
|-
|-
|2||Player in user's party
|-
|-
|4||Enemy
|-
|-
|8||Player in user's alliance
|-
|-
|16||Players outside of user's party/alliance
|-
|-
|32||Dead players
|-
|-
|64||NPCs
|-
|}

'''activation''' needs to be researched

'''animation''' determines which animation should be used with the item.

'''animation time''' needs to be researched, but probably determines how long the player can't move for the item usage to succeed.

'''maxCharges''' is the maximum number of usages.

'''useDelay''' is likely how long the item must be equipped before it can be used.

'''reuseDelay''' is likely how long must pass between item uses.

'''aoe''' is a simple binary on whether the item is AoE or not (0 = false, 1 = true.)

==item_latents==

Need to research this table.

==item_weapon_unlock==

Need to research this table. Looks like a mixture of item_weapon, and how many weapon skill "points" are required to unlock it.

==item_puppet==

The itemId, name, slot, and "element" of each automaton piece. As PUP isn't in use, this table may change substantially in the future.

Items

2013-02-02T21:16:33Z

PrBlah:

===item_basic===

Stores basic item information that is common to all items. For an item to exist, it must have an entry in this table.

'''item_id''' should match what is found in POLUtils or on ffxiah.com

'''name''' is the long name of an item, such as flask_of_echo_drops. If you're scripting a file, this is the filename you should use.

'''sortname''' is the shortened name, such as echo_drops.

'''stackSize''' determines if an item should stack, and how many should stack. The client acts a bit odd if you stack items that aren't supposed to be stacked, but generally will let you stack dynamis money drops, for example.

'''flags''' needs to be investigated

'''aH''' is the auction house category for the item.

'''NoSale''' determines if the item can be sold.

'''BaseSell''' is the value of the item when selling to an NPC, before fame modifier.

===item_armor===

Stores information regarding anything that can be worn; armor, accessory, and weapons, too.

'''itemId''' matches what is found in item_basic.

'''name''' needs to be investigated. Just for readability's sake?

'''level''' is what level the item can be equipped at.

'''jobs''' determines what jobs can equip the item, stored as a bitmask. Simply add the values together to set the jobs. WAR (1) + PLD (64) + DRK (128) = 193

{|class="wikitable sortable zebra"
!Item ID!!Item Name
|-
|1||warrior
|-
|-
|2||monk
|-
|-
|4||white mage
|-
|-
|8||black mage
|-
|-
|16||red mage
|-
|-
|32||thief
|-
|-
|64||paladin
|-
|-
|128||dark knight
|-
|-
|256||beastmaster
|-
|-
|512||bard
|-
|-
|1024||ranger
|-
|-
|2048||samurai
|-
|-
|4096||ninja
|-
|-
|8192||dragoon
|-
|-
|16384||summoner
|-
|-
|32768||blue mage
|-
|-
|65536||corsair
|-
|-
|131072||puppetmaster
|-
|-
|262144||dancer
|-
|-
|524288||scholar
|-
|}

'''shieldSize''' is only used by shields, and determines how much damage they block, and how much damage they'll deal with Shield Bash.

'''scriptType''' needs to be investigated.

'''slot''' determines which slot(s) the item can be worn in, in a bitmask. main hand (1) + off hand (2) = 3.

{|class="wikitable sortable zebra"
!Item ID!!Item Name
|-
|1||main hand
|-
|-
|2||offhand
|-
|-
|4||ranged
|-
|-
|8||ammo
|-
|-
|16||head
|-
|-
|32||body
|-
|-
|64||hands
|-
|-
|128||legs
|-
|-
|256||feet
|-
|-
|512||neck
|-
|-
|1024||belt
|-
|-
|2048||l earring
|-
|-
|4096||r earring
|-
|-
|8192||l ring
|-
|-
|16384||r ring
|-
|-
|32768||cape
|-
|}

'''rslot''' determines which single slot cannot be used while the item is equipped. For example, Vermillion Cloak would reserve the head slot, since head equipment cannot be used with it. This is '''not''' a bitmask, and only one value can be specified.
{|class="wikitable sortable zebra"
!Item ID!!Item Name
|-
|0||none
|-
|-
|1||main hand
|-
|-
|2||offhand
|-
|-
|3||ranged
|-
|-
|4||ammo
|-
|-
|5||head
|-
|-
|6||body
|-
|-
|7||hands
|-
|-
|8||legs
|-
|-
|9||feet
|-
|-
|10||neck
|-
|-
|11||belt
|-
|-
|12||l earring
|-
|-
|13||r earring
|-
|-
|14||l ring
|-
|-
|15||r ring
|-
|-
|16||cape
|-
|-
|17||"SLOT_LINK" Linkshell?
|-
|}

===item_weapon===

Stores common information for all weapons.

'''itemId''' links the table to item_basic and item_armor, and should match those tables.

'''name''' may just be for readability's sake.

'''skill''' determines which weapon proficiency should be used with the weapon.

A table is needed here.

'''dmgType''' determines the type of damage dealt by the weapon. Note that only Hand-to-hand damage will use both hands for jobs such as Monk as of r2491.
{|class="wikitable sortable zebra"
!Item ID!!Item Name
|-
|0||Damage type "none"
|-
|-
|1||Piercing
|-
|-
|2||Slashing
|-
|-
|3||Blunt
|-
|-
|4||Hand-to-hand
|-
|}
'''hit''' is only used for multihit weapons such as Joyeuse or Kraken Club.

'''delay''' determines the delay of the weapon. Ranged Weapons and Ammunition always have -240 their stated delay.

'''dmg''' is the DMG stat for the equipment. Hand-to-hand weapons are always stored with their DMG stat +3 (I.E. Lizard Cesti has 5 instead of 2).

'''unlock_index''' probably refers to the in-progress weapon unlock system.

===item_mods===

Stores uncommon information, from Defense to "Enhances Dual Wield Effect."

item_mods is an unindexed table. As such, always keep in mind that it's possible to have duplicate values, which darkstar will cheerfully use without questioning them.

'''itemId''' links the table back to the item via item_basic, and should always match.

'''modId''' is what is being modified. A list of these values can be found in /scripts/globals/status.lua (listed in hexadecimal,) or in /src/map/modifier.h (listed in hexadecimal.) Remember to convert them to decimal for use in this table.

'''value''' is how much of the modifier to grant, and can be positive or negative. It's best to research any modifier you're unsure of, as some are stored and applied in unexpected ways, such as Magic Damage Taken being stored as amount/256, while Physical Damage Taken is stored as amount%.

===item_furniture===

Stores information regarding moghouse furniture.

'''itemId''' links back to item_basic, and should always match.

'''name''' may just be for readability's sake, and is the long name for the item.

'''storage''' is how much storage to grant for each item placed. The core will cap the total at 80.

'''moghancement''' needs to be researched.

'''element''' is the elemental alignment of the furniture.

'''aura''' needs to be researched (strength of effect?)

===item_usable===

Stores information regarding items that can be used. An item cannot be used unless it is in this table.

'''itemid''' links this table back to item_basic, and should match.

'''subid''' seems to primarily be used with spell scrolls, and probably just stores the spellid to be unlocked.

'''name''' may just be for readability's sake.

'''validTargets''' is a bitmask storing what the item can be used on. Being a bitmask, the values should be added for each valid target type.
{|class="wikitable sortable zebra"
!Item ID!!Item Name
|-
|1||Self
|-
|-
|2||Player in user's party
|-
|-
|4||Enemy
|-
|-
|8||Player in user's alliance
|-
|-
|16||Players outside of user's party/alliance
|-
|-
|32||Dead players
|-
|-
|64||NPCs
|-
|}

'''activation''' needs to be researched

'''animation''' determines which animation should be used with the item.

'''animation time''' needs to be researched, but probably determines how long the player can't move for the item usage to succeed.

'''maxCharges''' is the maximum number of usages.

'''useDelay''' is likely how long the item must be equipped before it can be used.

'''reuseDelay''' is likely how long must pass between item uses.

'''aoe''' is a simple binary on whether the item is AoE or not (0 = false, 1 = true.)

===item_latents===

Need to research this table.

===item_weapon_unlock===

Need to research this table. Looks like a mixture of item_weapon, and how many weapon skill "points" are required to unlock it.

===item_puppet===

The itemId, name, slot, and "element" of each automaton piece. As PUP isn't in use, this table may change substantially in the future.

Database

2013-02-02T20:11:21Z

PrBlah:

Main Page

2013-02-02T20:01:12Z

PrBlah:

'''Welcome to the Unofficial Dark Star Project Wiki'''

== Getting Started ==

[[Building the Server]]

[[Configuring Your Client]]

[[DarkStar Servers]]

[[Script Testing Server]]

== General Reference links ==
[[GM Commands]]

[[ID References]]

[[What Works]]

[[Database]]

== Developer Reference links ==
[[Quests]]

[[Missions]]

[[Core]]

[[Server Data Flow]]

== FAQs/Tutorials ==
[[Make My Character a GM]]

[[Troubleshooting Guide]]

[[Customizing Your Server]]

[[How to Make a Quest]]

== Things that need to be added ==

You can always look at the list of [[Special:WantedPages]] and see if you can clear some of those out by filling in the information

Reference tables (any table that might need to be referenced often)

Source Code documentation (mainly public function documentation and how to communicate between lua scripts and the server)

Checklists for things that are and are not implemented (Eventually I would like to create goal pages that use these checklists, so if you can categorize things in a logical manner, that would be very helpful)

Anything else you can think of that might be helpful for either casual users or developers interested in Dark Star Project.

== Other ==
[http://{{SERVERNAME}}:8765/bak/ Automatically generated wiki backups]

<pre style="display: none"><nowiki>[http://www.dracomiconia.com/proprietary.php?option=2 donotvisitthislinkoryouwillbeblocked]</nowiki></pre>

Items

2013-02-02T19:59:34Z

PrBlah:

===item_basic===

'''item_id''' should match what is found in POLUtils or on ffxiah.com

'''name''' is the long name of an item, such as flask_of_echo_drops. If you're scripting a file, this is the filename you should use.

'''sortname''' is the shortened name, such as echo_drops.

'''stackSize''' determines if an item should stack, and how many should stack. The client acts a bit odd if you stack items that aren't supposed to be stacked, but generally will let you stack dynamis money drops, for example.

'''flags''' needs to be investigated

'''aH''' is the auction house category for the item.

'''NoSale''' determines if the item can be sold.

'''BaseSell''' is the value of the item when selling to an NPC, before fame modifier.

===item_armor===

'''itemId''' matches what is found in item_basic.

'''name''' needs to be investigated. Just for readability's sake?

'''level''' is what level the item can be equipped at.

'''jobs''' determines what jobs can equip the item, stored as a bitmask. Simply add the values together to set the jobs. WAR (1) + PLD (64) + DRK (128) = 193

{|class="wikitable sortable zebra"
!Item ID!!Item Name
|-
|1||warrior
|-
|-
|2||monk
|-
|-
|4||white mage
|-
|-
|8||black mage
|-
|-
|16||red mage
|-
|-
|32||thief
|-
|-
|64||paladin
|-
|-
|128||dark knight
|-
|-
|256||beastmaster
|-
|-
|512||bard
|-
|-
|1024||ranger
|-
|-
|2048||samurai
|-
|-
|4096||ninja
|-
|-
|8192||dragoon
|-
|-
|16384||summoner
|-
|-
|32768||blue mage
|-
|-
|65536||corsair
|-
|-
|131072||puppetmaster
|-
|-
|262144||dancer
|-
|-
|524288||scholar
|-
|}

'''shieldSize''' is only used by shields, and determines how much damage they block, and how much damage they'll deal with Shield Bash.

'''scriptType''' needs to be investigated.

'''slot''' determines which slot(s) the item can be worn in, in a bitmask. main hand (1) + off hand (2) = 3.

{|class="wikitable sortable zebra"
!Item ID!!Item Name
|-
|1||main hand
|-
|-
|2||offhand
|-
|-
|4||ranged
|-
|-
|8||ammo
|-
|-
|16||head
|-
|-
|32||body
|-
|-
|64||hands
|-
|-
|128||legs
|-
|-
|256||feet
|-
|-
|512||neck
|-
|-
|1024||belt
|-
|-
|2048||l earring
|-
|-
|4096||r earring
|-
|-
|8192||l ring
|-
|-
|16384||r ring
|-
|-
|32768||cape
|-
|}

'''rslot''' determines which single slot cannot be used while the item is equipped. For example, Vermillion Cloak would reserve the head slot, since head equipment cannot be used with it. This is '''not''' a bitmask, and only one value can be specified.
{|class="wikitable sortable zebra"
!Item ID!!Item Name
|-
|0||none
|-
|-
|1||main hand
|-
|-
|2||offhand
|-
|-
|3||ranged
|-
|-
|4||ammo
|-
|-
|5||head
|-
|-
|6||body
|-
|-
|7||hands
|-
|-
|8||legs
|-
|-
|9||feet
|-
|-
|10||neck
|-
|-
|11||belt
|-
|-
|12||l earring
|-
|-
|13||r earring
|-
|-
|14||l ring
|-
|-
|15||r ring
|-
|-
|16||cape
|-
|-
|17||"SLOT_LINK" Linkshell?
|-
|}

Items

2013-02-02T19:46:28Z

PrBlah: Created page with "===item_basic=== '''item_id''' should match what is found in POLUtils or on ffxiah.com '''name''' is the long name of an item, such as flash_of_echo_drops. If you're script..."

===item_basic===

'''item_id''' should match what is found in POLUtils or on ffxiah.com

'''name''' is the long name of an item, such as flash_of_echo_drops. If you're scripting a file, this is the filename you should use.

'''sortname''' is the shortened name, such as echo_drops.

'''stackSize''' determines if an item should stack, and how many should stack. The client acts a bit odd if you stack items that aren't supposed to be stacked, but generally will let you stack dynamis money drops, for example.

'''flags''' needs to be investigated

'''aH''' is the auction house category for the item.

'''NoSale''' determines if the item can be sold.

'''BaseSell''' is the value of the item when selling to an NPC, before fame modifier.

===item_armor===

'''itemId''' matches what is found in item_basic.

'''name''' needs to be investigated. Just for readability's sake?

'''level''' is what level the item can be equipped at.

'''jobs''' determines what jobs can equip the item, stored as a bitmask. Simply add the values together to set the jobs. WAR (1) + PLD (64) + DRK (128) = 193

{|class="wikitable sortable zebra"
!Item ID!!Item Name
|-
|1||warrior
|-
|-
|2||monk
|-
|-
|4||white mage
|-
|-
|8||black mage
|-
|-
|16||red mage
|-
|-
|32||thief
|-
|-
|64||paladin
|-
|-
|128||dark knight
|-
|-
|256||beastmaster
|-
|-
|512||bard
|-
|-
|1024||ranger
|-
|-
|2048||samurai
|-
|-
|4096||ninja
|-
|-
|8192||dragoon
|-
|-
|16384||summoner
|-
|-
|32768||blue mage
|-
|-
|65536||corsair
|-
|-
|131072||puppetmaster
|-
|-
|262144||dancer
|-
|-
|524288||scholar
|-
|}

'''shieldSize''' is only used by shields, and determines how much damage they block, and how much damage they'll deal with Shield Bash.

'''scriptType''' needs to be investigated.

'''slot''' determines which slot(s) the item can be worn in.

'''rslot''' determines which single slot cannot be used while the item is equipped. For example, Vermillion Cloak would reserve the head slot, since head equipment cannot be used with it.

Database

2013-02-02T19:24:52Z

PrBlah:

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

===[[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."
Mandatory for all items. This table defines the basic existence of an item.

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

auction_house, bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, delivery_box, elevators, exp_base, exp_table, fishing_fish, fishing_lure, fishing_rod, fishing_zone, guild_shops, linkshells, mob_change_skin, npc_list, pet_list, server_variables, skill_caps, skill_ranks, skillchain_damage_modifiers, status_effects, synth_recipes, transport, zone_settings, zone_weather, zonelines

Database

2013-02-02T19:24:13Z

PrBlah: Created page with "A break down of the database tables and what the fields mean. == Player Related == '''These tables directly affect characters and player accounts''' ===Accounts=== Inc..."

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

== Player Related ==

'''These tables directly affect characters and player accounts'''

===[[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."
Mandatory for all items. This table defines the basic existence of an item.

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

auction_house, bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, delivery_box, elevators, exp_base, exp_table, fishing_fish, fishing_lure, fishing_rod, fishing_zone, guild_shops, linkshells, mob_change_skin, npc_list, pet_list, server_variables, skill_caps, skill_ranks, skillchain_damage_modifiers, status_effects, synth_recipes, transport, zone_settings, zone_weather, zonelines