Item excel

Delaide
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

Item excel

Post by Delaide » Mon Jun 04, 2018 3:15 am

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 811 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 787 times
Last edited by Delaide on Mon Jun 24, 2019 3:15 am, edited 10 times in total.

Delaide
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

Re: Item excel

Post by Delaide » Tue Jun 12, 2018 8:19 pm

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
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

Re: Item excel

Post by Delaide » Thu Jun 21, 2018 12:55 am

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)
Attachments
FFXI AH Item exists check.xlsx
(2.95 MiB) Downloaded 800 times
Last edited by Delaide on Mon Jul 30, 2018 2:51 am, edited 2 times in total.

Delaide
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

Re: Item excel

Post by Delaide » Fri Jun 29, 2018 4:44 am

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

NekoNinja
Posts: 30
Joined: Thu Jun 01, 2017 10:20 am

Re: Item excel

Post by NekoNinja » Wed Jul 04, 2018 3:05 pm

These are awesome! thanks for sharing!

Delaide
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

Re: Item excel

Post by Delaide » Mon Jul 23, 2018 10:16 pm

Updated both 7/24/2018

Delaide
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

Re: Item excel

Post by Delaide » Mon Jul 30, 2018 2:52 am

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
Posts: 52
Joined: Sun Dec 09, 2012 12:19 pm

Re: Item excel

Post by whitevamp » Mon Jul 30, 2018 2:10 pm

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

Delaide
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

Re: Item excel

Post by Delaide » Tue Apr 16, 2019 10:52 pm

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
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

Re: Item excel

Post by Delaide » Wed Apr 17, 2019 12:23 am

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?

Post Reply