Can someone code me an example item?
 

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

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.

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

Is all that extra junk necessary?
 

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?

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..