Item Lists

[Havoc3D]

ok, I just started in this stuff this weekend. i won't be opening a server (dial-up) but my friend may be, and i may help. I'm just wondering, the db contains all the items i'm assuming .(i haven't gotten into getting the server software or anything yet, just getting a jump start) i'm just wondering if you can add your own custom items to your db, or if that causes problems. anyway, thanks alot, hope that makes sence...

-Havoc3D

oh, if you're looking for me online, i'm usualy hanging out on the "adult oriented" server, just ooc for havoc3d 8o)

[Elemental]

Not all items are in the database. There's a ton of them though.

And yes, you can create your own items.

[Havoc3D]

mooossstttt Excelent *tents his fingers and grins evily*

very nice to know, didn't think i'd ever heard of "Jenniy's Multi-Colored Breast Plate, 60AC, etc, etc, or the Multi-Hued Sheild i have. thought maybe i was just loosing my knowledge of EQ items...8o)

Thanks much for info, think my friend and i will have some fun

[Jorgon]

Oh yes, this will be fun.... BTW Havoc, i have the server software, probably end up doing a minilogin and localhosting it for a while to get the hang of it. Also, im looking at editing some of the source to fix a couple of things (like the insane eating rate that everyone seems to have)

[Elemental]

As funny as it is, Jenniy's Two-tone Cuirass is an actual item in EQ. Drops off of Grieg himself in Grieg's end. Friend of mine submitted the item. :P

[Havoc3D]

lol! no crap? well, i'll be...that's funny. Figured the guy who hosts the server had a friend named jenny or something...go figure...never ever heard of this item in game, don't remember seeing it on eqprices either, have to look again tho, spiffy anywho :eek:

[Wayne1511]

Yeah, well, incase your thinking of adding in your own items, take a look at the db.sql file, it has the items, but they are pretty weird. could you guys maybe add in a "how to" on adding items, maybe its easy and im just stupid, but i cant figure it out. Ive looked through files, and have seen the item word files. Maybe you guys did add one in, and i just cant find it. Anyway, could someone maybe post something, or tell me where the file is in the directory(if there is one).

-kevin

[Lurker_005]

Do a search on creating items or adding items.

But basically use the eqadmin tool from the files section on the main web page.

[Ztaar]

Yes, the current DB has a lot of items in it (and Jenniy's Two-tone Cuirass is a rather nice BP, rare drop, but that might be because Grieg Veneficius is doable with 2 groups of people).
It would be nice if someone made a script to extract all items from Magelo and Allakhazam to make the DB even more complete

Edit : The thing about editing items directly into the sql file is a bit tricky, since items in the mysql database consist of an ID field and a BLOB that stores all other information. So what you basically need to do is figure out how the struct in the BLOB is organized and then set the parameters, but as Lurker says, use the eqadmin tool. It's much easier that way (or write your own tool, but that requires info about the struct aswell). Info on the struct can be found in one of the files in the source though.

Ztaar
-- Nunc ille est magicus --

[Lurker_005]

If someone makes a script to create items, please do something like put "!Created!" in the lore field. Just so there is an easy way to filter created items from loged items from the game. As has been pointed out, there are still sections in the BLOB that we can't be absolutly sure about.

[Warthog]

Originally Posted by Ztaar

Yes, the current DB has a lot of items in it (and Jenniy's Two-tone Cuirass is a rather nice BP, rare drop, but that might be because Grieg Veneficius is doable with 2 groups of people).
It would be nice if someone made a script to extract all items from Magelo and Allakhazam to make the DB even more complete

That is a DAMN good idea. There has to be a basic free codebase for a web scraping program out there some where.. But on the more picky political side, any potential problems scraping all their pages? I don't see any, after all it's not their content we want, it's the information that mirrors the EQ files we purchased.

[jackfrostint]

Jenny's Two-tone Cuirass.. if you look at the stats on that item, the numbers read "8675309" .. y'know.. that song.. "Jenny 867-5309"

-j

[Trumpcard]

Makes sense... The name of the band was Tommy Twotone..

It wouldnt be too hard to write a java crawler that can take a root URL then crawl through the pages and create item data from the data it grabs.. Just need to spider your way through the pages, then parse out all the fields it finds with item stats.. If they do it in a standard text format, it wouldnt be bad at all.. I was looking at one of the magelo created sites (nightwatchers).. seems you have to right click on the character profiles to get the item stats, which then come out in a very nice name: value format . Write a spider that can look for the items pages, then do a left click on every item and gather all the resulting html and build it into an SQL string, and you've got a web gathering system...

If it was just flat html, it would be alot easier, with the interface being the way it is, im not 100% sure. I might see if i can make a simple one next week that can go through the eqmaps database (since its just php with a database field id appended in the URL, it wouldnt be hard to do a ++ loop until end of content to hit suck down all of those items. THe problem is of course that there are alot of bogus items in EQMaps. Im not even sure how good Ala. is with validating before they post. I do know that since Magelo is a packet sniffer, all of his data is completely factual..

[Hmm]

problem would be missing stats like casting time on procs or proc type even.

[Drawde]

It'd be really nice to have the race-specific smithed armour in the DB, those would be good items to add to merchants for each city to add more variety (not to mention being able to smith them, when I or someone else makes a tradeskill recipe list for the DB!)