New and updated items appearing in DB: is this a good sign?

tbigg · #1 10-17-2003, 02:55 PM

I noticed that there are some new and updated items appearing on the site. Is this a good sign that progress is being made with the packet collector fixes, or is this old data that someone finally got around to uploading?

Just curious.

devn00b · #2 10-17-2003, 03:24 PM

Every time somone runs the packetcollector it gathers items it gets from links (if you click) traders in the bazaar ect. it gets updated (weekly?) to the sourceforge page and released to you.

kathgar · #3 10-17-2003, 09:33 PM

I think he was referring to the public release of the PC. Those submission are us testing it out and making sure it works before we release.

ric0h · #4 10-20-2003, 08:45 PM

Have you noticed that extra damage fields are missing from the table format? e.g. items with separate Fire DMG are out, though Bane DMG is there. Also, are we missing stackable bit or it's hidden somewhere in other fields?

ksmith · #5 10-21-2003, 01:11 AM

Quote:

Originally Posted by ric0h

Have you noticed that extra damage fields are missing from the table format? e.g. items with separate Fire DMG are out, though Bane DMG is there. Also, are we missing stackable bit or it's hidden somewhere in other fields?

Elemental damage is in there. That's what elemdmgamt and elemdmgtype are.

Also: stackable = (spellid == -1 && charges == 1)

Merth · #6 10-21-2003, 01:30 AM

Quote:

Have you noticed that extra damage fields are missing from the table format? e.g. items with separate Fire DMG are out, though Bane DMG is there.

Not all of the items in our db are complete. Items with an updated timestamp of sept 12, 2003 are the ones that are missing some data.

ric0h · #7 10-21-2003, 02:58 AM

Thanks for the info, it really sorts the things out.

By the way, the latest item dump contains new fields artifactflag and summonedflag that obviously should be used for ARTIFACTs and SUMMONED items, but aren't. The lore field still has * for the lore items and # for artifacts. Am I right? Is the current PC inserting proper artifactflag and summonedflag?

ric0h · #8 10-21-2003, 03:14 AM

Quote:

Originally Posted by ksmith

Elemental damage is in there. That's what elemdmgamt and elemdmgtype are.

By the way, you need to exchange this two fields, elemdmgamt holds element type and elemdmgtype holds the amount as of latest item dump (Oct 17).

ksmith · #9 10-21-2003, 04:50 AM

Quote:

Originally Posted by ric0h

By the way, the latest item dump contains new fields artifactflag and summonedflag that obviously should be used for ARTIFACTs and SUMMONED items, but aren't. The lore field still has * for the lore items and # for artifacts. Am I right? Is the current PC inserting proper artifactflag and summonedflag?

Look at http://www.everquestserver.com/item....E5Ljc1MTE2ODk= the updated date is 2003-09-12 , this is from before the data structure change that added those four new flags. Now look at http://www.everquestserver.com/item....QyLjMyNDA5NjAy that is from after the data structure change.

The new flags are only going to be set in items that were collected after the change.

ksmith · #10 10-21-2003, 04:54 AM

Quote:

Originally Posted by ric0h

By the way, you need to exchange this two fields, elemdmgamt holds element type and elemdmgtype holds the amount as of latest item dump (Oct 17).

Sure looks like it . See http://www.everquestserver.com/item....AuOTIwMTU1NTc= for an example. The real item is

Sparkling Shortsword
MAGIC ITEM LORE ITEM NO DROP
Slot: PRIMARY SECONDARY
Skill: 1H Slashing Atk Delay: 18
DMG: 14 AC: 15
Magic DMG: 4
DEX: +12 CHA: +12 WIS: +12 INT: +12 AGI: +12 HP: +75 MANA: +75
SV COLD: +15
Recommended level of 62.
WT: 2.0 Size: MEDIUM
Class: WAR RNG BRD ROG
Race: ALL
Slot 1, type 4: empty

ric0h · #11 10-21-2003, 05:20 AM

Well then what about creating a magicflag, nodropflag, norentflag and expendableflag (augmentation is detected by itemtype==54) instead of old nodrop=255?

I think the table format needs to be made clearer.