The fields in dumpeditems.sql and what they mean

[DeletedUser]

Originally Posted by kalipsh

unknown108 - Only augments have a value other than 0 here, but not all augments do. Values range from 2 to 4, and 37 items have values set here. Only one item has 4 set - Bloodied Shard of Kel`Novar.

Lucy calls this "augres", for aug restriction. I suggest renaming it to match.

Values i know so far:
1 = Armor Only
2 = Weapons Only
3 = 1h Weapons Only
4 = 2h Weapons Only
5 = 1h Slash Weapons Only

Also on effecttype, 5 = Clickable anywhere, but with class/race/deity checks.
My Original note from eq_packet_structs.h on this field:
// 0=combat, 1=click anywhere w/o class check, 2=latent/worn, 3=click anywhere EXPENDABLE, 4=click worn, 5=click anywhere w/ class check, -1=no effect
Also found an itemtype that flags expendable, so not sure how reliable the note on #3 is.