Fandom

Final Fantasy Wiki

Final Fantasy Wiki:Final Fantasy XIV Database

21,181 pages on
this wiki
Add New Page
Talk0

The Final Fantasy Wiki maintains a database containing information datamined from Final Fantasy XIV for use on the wiki. The database can be accessed from any page and is updated with each new Patch that is released by Square Enix using FFXIV Explorer and software written by wiki staff, as well as by hand when neccessary. The purpose of the database is to allow the wiki to keep up with the huge amount of new content in each Patch (as of Patch 3.21, FFXIV contains over 13,000 items, and thousands of Quests, enemies, and crafting recipes).

ModulesEdit

Like most server-side scripts, the program for converting hard data into wiki-readable text is written in Lua, and stored at Module:FFXIV Data. Subpages of this contain the data itself, and are listed as follows, along with each argument a type of module takes. Note that many arguments require knowledge of the indices and IDs the game uses to describe certain properties of its content. It is also helpful to familiarize oneself with the syntax of Lua before attempting to edit a module.

In practice, whitespace is minimized in databases. The reason for this is that these databases are massive, and any amount of trimming that will help them fit into the 2MB maximum page length allowed by MediaWiki will be used!

ItemsEdit

return {
["Item Name"] = {
typ=Item UI Index,
job=ID of set of jobs that can equip,
gen=ID of gender that can equip,
race=ID of race that can equip,
ilv=Item level, 
lv=Level,
flv=Flavor text,
pdm=Physical damage,
mdm=Magical damage,
aad=Autoattack delay * 1000,
blks=Block strength,
blkr=Block rate,
pdf = Physical defense,
mdf = Magical defense,
cld=Cooldown,
pvp=PvP rank,
s={[Bonus Stat ID]=Bonus Stat Value},
hq={[Bonus HQ Stat ID]=Bonus HQ Stat Value,
gc=Grand Company,
ndis = Not disposable,
uniq=Unique,
untr=Untradable,
dye=Can be dyed,
crs=Crest-worthy,
rjob=Job to repair,
dmat=Dark Matter to repair,
note=Notes from FFWikians,
page=Parent page on FFWiki,
img=Image on FFWiki,},
};

OtherEdit

return {
["Achievement Name"] = {typ=Achievement category index,
pts=Points earned,
desc=Description of Achievement,
rwd=Reward,},
};
return {
itemPatch = Patch item database was most recently updated,
achvPatch = Patch Achievement database was most recently updated,
};
return {
[iconID] = Icon file,
}

Invoking a moduleEdit

A database can be invoked into a page using the following wikitext:

{{#invoke:FFXIV Data|Name of database|Data 1; Data 2; Data 3}}

Note that each piece of data one wishes to invoke is separated by semicolons. So to bring up High Allagan Grimoires of Casting and Healing (in the Arms database, one would type into a page:

{{#invoke:FFXIV Data|Arms|High Allagan Grimoire of Healing; High Allagan Grimoire of Casting}}

Which creates the following table:

NameStatsCrafting
High Allagan Grimoire of Healing
Icon-ffxiv-033473
Level 50 (Item Level 115)
Unique. Untradable. Deals blunt damage.
Arcanist's grimoire
Equipped by SCH
Physical Damage: 53
Autoattack Delay: 3.2
Critical Hit Rate +46
Accuracy +9
Piety +24
Magical Damage: 77
Autoattack Range: 3
Vitality +47
Mind +45
Repair: Alchemist Lv. 40
Dark Matter: Grade 5
High Allagan Grimoire of Casting
Icon-ffxiv-033472
Level 50 (Item Level 115)
Unique. Untradable. Deals blunt damage.
Arcanist's grimoire
Equipped by ACN SMN
Physical Damage: 53
Autoattack Delay: 3.2
Vitality +47
Intelligence +45
Magical Damage: 77
Autoattack Range: 3
Spell Speed +32
Critical Hit Rate +46
Repair: Alchemist Lv. 40
Dark Matter: Grade 5

If the data does not exist (say, one searched for a High Allagan Grimoire of Casthing), the following error message results:

NameStatsCrafting
High Allagan Grimoire of Healing
Icon-ffxiv-033473
Level 50 (Item Level 115)
Unique. Untradable. Deals blunt damage.
Arcanist's grimoire
Equipped by SCH
Physical Damage: 53
Autoattack Delay: 3.2
Critical Hit Rate +46
Accuracy +9
Piety +24
Magical Damage: 77
Autoattack Range: 3
Vitality +47
Mind +45
Repair: Alchemist Lv. 40
Dark Matter: Grade 5
ERROR: High Allagan Grimoire of Casthing does not exist in the Arms database.

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.