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

[tbigg]

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]

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]

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]

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]

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]

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]

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]

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]

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.php?id=MTAzMzE5Ljc1MTE2ODk= 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.php?id=MTQyMjQyLjMyNDA5NjAy 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]

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.php?id=NzM4NjAuOTIwMTU1NTc= 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]

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.

[Edgar1898]

I agree, I'll work on adding a quick display of the item so you can quickly see the stats like the client displays them.

[ric0h]

I agree, I'll work on adding a quick display of the item so you can quickly see the stats like the client displays them.

got that ready

have a look at http://195.250.64.152/~vahan/myeq/showitem.php?id=40346

[Edgar1898]

Page doesnt load

[ric0h]

Page doesnt load

try again it's over a very slow link in eastern europe

[a_Guest03]

Man, that's slow! It looks good, though.

[Edgar1898]

I got mine working, Ill update it when I get some proper graphic files. I'll have to wait until this weekend tho.

this is what is looks like now:
http://www.everquestserver.com/item.php?id=ODc4NzguMDYyODY3ODQ=

[flyrken]

nice I want! It loaded after a few hours err minutes. Care to share the display code? :) I love open source. I open source, cry, you fix and support. I take the credit <J/K>

good job

EOF

[Merth]

Lethal, the page looks great! Nice job, must've been a ton of work