New Tool Idea

[sesmar]

Well, here is a link to the code that I have for reading and writing items in the database. I have not yet completely tested it as I do not have access to my database right now; however, I know that reading items from the database works and since all of the SQL statements are generated in the same manner the insert and updates should work without any problems. If you run into an issue let me know as I will be updating my personal source as well to reflect the changes I made in this version and fixing any bugs.

I know this seems like a lot of code just for updating one table in the database but as I said earlier it is part of a much larger DBI and project that I am working on. Also, to correct my mistake from earlier there are not 250+ fields on the items tables there are actually only 131.

Well, let me know if this is of any use at all. Thanks.

[nosfentora]

Awesome - Thanks Sesmar. I'll let you know as soon as I try it out.

[spider661]

far as i know lucy is ran with allakhazam's database so it would be as up to date as they are.. worth a look at lest.

[nosfentora]

I'll give it a looksie then. Wasn't sure if it only had stuff that was already in the db, or had live(ish) items too.

[nosfentora]

I'm finally getting to work on this tool, but need a little help.

Using www.raidloot.com as a base for info, i found this item:
Prismatic War-Bishop's Helm Armor ID: 102150
Magic Lore No Trade Infusible
Slot: Head
Purity: 75
AC: 129 HP: 800 + 4/tick MANA: 815 ATK: 25
STA: 31 + 6 STR: 11 WIS: 30 + 13 INT: 15 + 7 DEX: 30 AGI: 45 CHA: 29 +4
SV FIRE: 24 SV COLD: 46 SV MAGIC: 65 SV POISON: 38 SV DISEASE: 57
Shielding: 3%
DoT Shielding: 3%
Stun Resist: 3%
Avoidance: 7
Heal Amount: 10
Spell Dmg: 5
Focus Effect: Magic Damage 75

[nosfentora]

grrr for some reason it won't let me post my full post, or edit.

What does the "STA: 31 + 6" mean?

Should i import the item as having 31 STA or 37?

it's a required level of 80 item - but there are a bunch of items like this, with more than one stat like this.

[AndMetal]

It has something to do with heroic stats. Easiest way to see this is in the raw details in the EQItems (13th Floor) database.

Simply put, just put in the 31 since the Titanium client doesn't support the +6.