Item excel

[Delaide]

So, like the title says, this is just a simple excel. Good for looking things up, filtering things out, and figuring out what all is messed up.
Anyways, I will try to update it as I can. Hopefully someone else will find some use from it.

Sorry, it is pretty big, since it has pretty much every item database as well as the synthesis database.

Last update: 6/24/2019

FFXI Items database.xlsx

(8.1 MiB) Downloaded 1460 times

Here is a new file I have been working on (Thanks to Windower for their items.lua file, which this was generated from).
This file has lots of good information pulled about all the existing items from polutils (Well, I hope Windower generates it using this, otherwise, it would be incredibly stupid...).
I will use this to run some comparisons with the current database. This will allow me to see if any of the entries are wrong.

items.xlsx

(1.42 MiB) Downloaded 1392 times

[Delaide]

Please note, I have updated the excel sheet with some recent pulls, as well as my own additions (item_basic and item_puppet for PUP automations)

[Delaide]

Updated the spreadsheet.
I am also working on a separate spreadsheet that will show every item from 1-65535, so we can see which items SE has not included yet.
I still have a long way to go, since my database directly checks ffxiah, and keeps hitting a request limit (so I can only check once every 24 or so hours), so I have only gotten to item#19237. I am attaching in case someone is interested in it, but as it is not yet completed, not sure how useful it is. Later, I will combine with the master item db.

Late update: 7/30/2018
Status: Complete (Unless SE adds more items)

[Delaide]

Okay, updated both the item database and the item exists database.

[NekoNinja]

These are awesome! thanks for sharing!

[Delaide]

Updated both 7/24/2018

[Delaide]

Finished the Item Exists spreadsheet. Unless SE adds more items, this should not change. Going to use it for comparison with the database to see which items DSP is currently missing.

[whitevamp]

nice thx for the work put in to these files.
and thx for sharing.

[Delaide]

I updated the file. I think there are a few things to check into that may have been added (example, Item ID 10370, item is shedir_crackows, has modId 126, which shows as #N/A in my table because I don't have this modId listed. So, need to see if it was added, and check for other inconsistencies)

[Delaide]

Question, if anyone knows:
I have issues with the following modIDs:

153 - From what I see, since this is only found in item 21373, the sihirik, and has a -2 value, I assume, based on the item information:

Code: Select all

[Ammo] All Races
MP+15 Magic damage taken -2%
LV 99 WAR MNK WHM BLM THF DRK BST BRD RNG NIN DRG SMN

That this is "Magic damage taken". However, I notice this is not in the "modifier.h" file. Is this even in the project yet? (From what I see, someone assigned a modId to it in SQL, but that there is no such effect created yet, not even reserved in the modifiers)

266 - This is listed in the level 90 Kikoku, and only the level 90 Kikoku (by item id 18659). None of the other Kikoku versions have this item id.
When I checked the value, I see a value of 9.
Nothing I see in the level 90 Kikoku has this value:

Code: Select all

Kikoku
[Main] All Races
DPS: 1600 DMG:56 Delay:210 Attack+35 "Blade: Metsu" Additional effect: Paralysis
LV 90 NIN

The only thing even remotely close to it I can find is the following from bg:

Code: Select all

Paralysis procs about 10% of the time and does not overwrite itself.

But, I think this is covered by modId 431, ADDITIONAL_EFFECT, set at 1.

So I cannot figure out the purpose of this mod, and it is not listed in modifier.h.

273 - This is on itemId 18434, Kosetsusamonji, and since it has a value of 2, I assume it is storeTP+.
STORETP is 73, so, I assume someone just made a mistake in the item_latents.sql table?