Can someone code me an example item?

[xxxjustinxxx]

Can any of you incredibly overworked, abused, helpful, intelligent, attractive devs out there possibly code me an example item with stats and effects, even if the proc isn't implemented yet.

I would like to see if there's anyway to balance items a little more.

thanks in advance,
j

[lacidar]

There are a lot of 'examples' to choose from in the database.

You can use the eqadmin tool to edit the item properties. I haven't checked, but I think it's up to date on known item properties.

[Lyenu X`Arie]

Here is a sample of what 1 entry looks like...

INSERT INTO items (id, raw_data) VALUES (1001, 'Cloth Cap\0;.JS;.JSE;.WSF;.WSH\0PROCECloth Cap\0TECTURE=x86\0PROCESSOR_IDENTIFIER=x86 Family 6 ModeIT63\0R_1\0ing 3, GenuineIntel\0P

[theCoder]

IOW, does the EMU just read up to the null terminator, or is it encoding something in the rest of the BLOB? I looks like junk, but I guess the EMU may need to know the processor architecture of the person who originally put in the item...

It seems like

INSERT INTO items (id, raw_data) VALUES (1001, 'Cloth Cap\0');

would work, but I don't know for sure. If all it needs is the name, though, why not just use a varchar?

[Lyenu X`Arie]

I don't know about that architecture crap... but that variable contains the stats of the items.. the effect.. everything about a item is kept in it. It's a Packed variable with a null terminator on the end of each bit of information we use in it... it can be read using a simple pack/unpack feature and a function to remove the null terminator... search for raw data and hogie put some of his code up for PHP on how to do it..