Items inefficiency

[spellcaster]

Hmm.

I was doing something and in the bit where it loads the database stuff, I put in a comment to show why it wasnt loading items - of course answer was - item length is invalid - where theres a // to do bit. So, I watched as streams upon streams of invalid entries went past, not once as you might expect, but so many I couldnt count them - this would suggest that while its loading everything its doing it multiple times (bear in mind here, no spawns just ME in the db)

Same as I noticed that so many times it spammed me right out the ItemSearch routine is running on item ID 65535 (max ID is around say 32xxx) ... so, this also strikes me as unnecessary load on the db..

(OH MAN DO I GO ON!)

Will investigate if I can this weekend

[Lyenu X`Arie]

What you need to do is run thison your old EQ DB.

delete from items;

If you want items that are true to EQ then you should use this DB:

http://lyenu.servehttp.com/items.sql (remember this is only an items DB)

Anyways source that in and you'll be set.

[spellcaster]

Thank you - this looks exceptionally different to the items which come with eqemu, and after being shoved through the 33-34 converter.

Eg

NSERT INTO items 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^B^A\0i^C^?^B\0\0^D\0\0\0H\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0.6\0\0\0\0\0\0\0\0\ 0
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0^B\0\0\0\0\0\0\n^L\ 0\0mR\0\0\0\0\0\0^?\0\0^?3\0\0\0\0\0\0}\0\0T M\0\0.?\0\0\0\0\0\0\0\0\0
\0\0\0\0\0\0\0\0\0\0\0\0U\0\0\0\0\0\0\0=\0\0\0\0\0 \0\0t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0WI\0\0\0\0');

It has all sorts about processors and junk. I think the script must have picked up some random junk somewhere and pasted it all in, hence it didnt work.

[Lurker_005]

Actually all that extra junk in there was from the itemcolelctor / packetcollector data. Check your old eq33 items table. The items with the eqemu 34 release were ones I converted from the HQ items database.

Lyenu, are those newly collected items?

[spellcaster]

Those items rock, I finally have clothes and weapons.. Shame there are tons missing, but, hey, I GOT STUFF!! WOOT!!

Thanks guys.

All I need now is something to fight!

(OK, Im still stupidly new, I really need everything helped out now, but I promise, once I have the hang of it, life will be easier, I'll be making stuff for you guys.)