*** NEW ITEM DB *** 01-19-2003
 

There has been alot of items added And ton of Item changes to this release. I want to thanks Lurker and FFShadow for thier help.



http://nctimes.net/~threeofus/Items011903.rar



1) Copy the new items011903.sql to the C:\mysql\bin directory
2) Open a DOS command window (if you dont know how to do this, there are instructions out there)
3) cd c:\mysql\bin
4) type 'mysql' This opens the mysql interface.
5) use eq;
6) drop table items;
7) source items011903.sql;


If you have items you would like to add to the Item DB please contact me. We are doing what we can to make the DB better daily and more complete.

:D Cool :worship:

yay divide! wtg! lots of hard work i know! i think i speek for most of the eqemu users when i say


THANKS!

:juggle:

*dance* <-- FFShadow hehe

I added in Elemental quest armors, and some weapons. Completing the sets of armor as it's discovered.

Edit: added more items and fixed some items from Divide's sql. You can get the new one here:
http://ffshadowff.virtualave.net/items011903b.rar

here is the link to FFShadows

http://ffshadowff.virtualave.net/items011903b.rar

RAR?
 

what is an rar file? i can't tar, unzip, or uncompress it? what am i supposed to do with this?

kabalah

rar format
 

ok, i found out what a rar file is, but can you also post it as a zip file so i can use it on linux? :)

thanks
kabalah

www.rarsoft.com

i cant believe i'm having to tell this to a linux user...

What a world, what a world...

Zip????

Any linux user worth their grain would be asking for a gzip... AWAY WITH YOU!

well
 

i was trying to make it easy on the windows users... i did find a rar.rpm on rpmfind.net so never mind...
kabalah

Either way for windows I just use win ace for all the compression formats.

I figure I can throw my hat into the ring and/or throw an idea into how this whole process is being updated.

I have built and maintained a spreadsheet of Beastlord gear (the class I have played for the last year) and keep it pretty well updated. The only thing my current listing really fails to address is the NO DROP, NO RENT, LORE tags, but otherwise is a pretty comprehensive listing of gear for the class. I tend to check LUCY, Magelo, and Allakhazam's to make sure I am catching all items (with the occasional info from EQTraders.) Anyway, I can offer up any information for Beastlord gear, just say the word. Here is my existing spreadsheet.

http://www.saymu.com/beastlord/AllBeastlord.xls

Here's an item update for the elemental armor and various pop items that had incorrect item numbers. Pulled this info from lucy and magelo.

Our DB is not ran off Lucys, the Items #s maynot match that really doesnt matter. What does is that we cet it into a open slot that the item does not over Right one that is allready there, Some items may seem like dupes or worthless but none the less they are real EQ items. My qoal has been to Bring real EQ items to EQEMu. Unless we get Lucys FULL Database thier Item #s dont really matter. I will take a look at your items and get them in.

K np, was just thinking you guys wanted it to be as accurate as possible and the numbers were an oversight. If I can contribute to getting new items in any way, just let me know. :)

Your help is welcomed. Just would hate for anyone to lose items by us moving items around. It would be kinda cool if our DB #s matched but they dont (,

Now if only we could get a full Item DB dump from Magelo or Lucy that would own!

The guy at eqcps is willing to share his item database with us, magelo isnt though...

Actually our item DB is bigger than magelo's and the new items that they have since PoP I have collected from magelo (about 500)

As for eqcps, I know they switched to a different item numbering scheme then EQEmu uses. Also it was originally based on an older version of the same source EQEmu's current items are generated from, namely EQCollector. The big question I have regarding eqcps, are they getting new items from the magelo data collection client and submitting it to eqcps? Or do they pull item info from magelo's web pages?

I thought he wrote his own PC..

I took a look at his item database...a lot of the numbers are way off from EQlive. I think the highest item number he had was in the 13000 range.

4.1 addon has good magelo items, all updated. still dupe spawns though :x

Yes eqcps has his own PC. So does Belg. Belg is great he has shared lot of Information with me - Us. Im greatful to him. Hopefully he will be sharing more in the future.

Lurker can you send me the cleanest DB from Magelo, I would like to keep it as sonething to work off. Maybe i will take the time to look up every item on Magelo and then Merge the 2 DBs to make 1 that has all the right #s. The only thing i see being a posable issue is that we have a few items they dont. Real EQlive items.

I am just wondering but are our numbers the same as eqlive or are we just basing the numbering after magelo?

EQEmu, EQ Live, and Magelo all use the same item numbers

Packet collected items have the right numbers, cause the item number is in the data itself.

Divide, I don't collect any item data from Magelo that we already have data for. Any duplicate data in the magelo.sql (4.1 DB Addon) is because I got more packetcollected items since collecting the magelo stuff. And since magelo data isn't complete, I use it as a filler. It has the right item number, stats, mostly usable, but not a lot of the info that is hidden from the client.

So your saying as of the 4.1 release the EQlive, EQMu and Magelo item #s match? I want to make sure casue if so this will save me alot of time. But i notice that 4.1 is not Pure magelo cause there is some items i made for FA GMs in there, like Shiled of tranquil Honor. But none the less i was going to go thru it with the Full Magelo and move then PoP items we moved over to it with the right # IDs