New Items Dump

[Edgar1898]

I have begun the processing of the item data that is being collected by the new packetcollector. Thanks to everyone that contributed to this database. Without your help the database would be far smaller than it is today. While still smaller than the item database we have used for months, this new database contains almost 15,000 items. Once this new database has been verified, I will be switching the item dump over to this new database and deleting those old items (half of which are corrupt). Although we will lose a few items, it will be better to have items that are known to be correct. This (like the old dump) will be done every 8 hours and can be downloaded here:
http://www.eqemulator.net/newdumpeditems.sql.gz

Please continue to help by collecting items for the community, the more people that contribute, the better it will be for everyone. It's simple, all you have to do is:
1. Install network capture dll (if its not installed already) from http://winpcap.polito.it/install/default.htm
2. Download PacketCollector from http://www.eqemulator.net/PacketCollector.zip
3. Run it from the command line like this:
PacketCollector (your ip address here) -items -name (Whatever nickname you want here)
4. Login to EQ or zone, and then upload the items by Control U or Control C.

If you see any problems with the new database let me know. (More than likely just a simple error on my part if there is).

[Edgar1898]

Oops, I didnt have it gzipping the file like it should have been every 8 hours. Its been fixed now.

[mangoo]

Began working on Item Editor 2.0 and it will utilize this new item structure. I plan on having a working beta this week. It won't have all the features you're all used to, trying to get it out with basic features so the item editing can continue . After that expect a solid release!

[Raven201]

Ok did some searching but came up blank, I saw another person with the same problenm but no one answered so Ill fire it off here.

I go to source newdumpeditems.sql and it starts then I get :

ERROR 1136: Column count doesn't match value count at row 1

did I compile sometjhing wrong when I did my setup or is the source got a bug?

Thanks

[rizzen04]

I go to source newdumpeditems.sql and it starts then I get :

ERROR 1136: Column count doesn't match value count at row 1

did I compile sometjhing wrong when I did my setup or is the source got a bug?

sourcing stuff into the sql database would have nothing to do with the source code for eqemu. Although I dont know why your getting that error, I can say its not due to the EQEMU code.

[Raven201]

ok, I went and started from scratch and I still haev the same problem.

[mangoo]

If you're only get this error once and at the end of the sourcing, then it is related to the variable line. This line was a request by myself that LE was kind enough to include. Basically it allows Item Editor to check the item database version to make sure the user is using a proper item database structure. Anyways.... this line in the SQL file only has 2 columns in it, whereas the variables structure has 4.

[Xabob]

Hey LE should that be my intenal Ip or external?