New Tool Idea

[nosfentora]

Have an idea for a new tool that I'm willing to work on.
I've been looking at different sites w/ item info ie raidloot, allakhazam, etc and have been wanting to add some items that i've found.

rather than go in by hand and add them, i was thinking that a tool that uses text copied from the site to disseminate the info and add the item(s) to the database.

Any thoughts/requests for something like this? Does anyone see any problems with making/using a tool like this?

[sesmar]

I have classes already written (using C# and MySql.Net Connector) to read and write items from the database if you want to save some time. I would also suggest using Regex to parse out the HTML retrieved from the web page and populate the class object. If you are interested in what I already have let me know and I will send you the source.

[nosfentora]

For read/writing from the db i'm good - i've got a class that i've written for use with VB.NET & MySQL, or SQL (changing 1 or 2 lines of code) - however if you have something that specifically deals with the items table, that I can use (it'll save me time working through the myriad of columns it has!), that would be greatly appreciated!

Also any code working with regex & html would be appreciated too!

I was thinking of a drag & drop style - either dragging text directly from the web page or via the page source. Alot of pages that use PHP or ASP don't always pass the parameters in the web address, so copying and pasting a link is pretty useless if the page it gets isn't what you were looking at.

[sesmar]

Originally Posted by nosfentora

however if you have something that specifically deals with the items table, that I can use (it'll save me time working through the myriad of columns it has!), that would be greatly appreciated!

That is what I was referring to, sorry if I was not clear on that. I have sat down and wrote out a class for all of the fields in the item table (250+) and I know how much time it took to map everything out and I just figured I could help save you sometime. I will package up what I have as it is part of a DBI I have been playing with and let you have the source.

[nosfentora]

How up-to-date is Lucy? I honestly haven't looked, I started playing with Raidloot and the idea came to me.
I figured this way we could add live-like items for folks that want to have a more broad base of items, or create a custom items db.

As far as your source Sesmar, that would be HUGELY appreciated!!
My DBI is pretty generic to be able to work with any MySQL or SQL database.

[sesmar]

Well, here is a link to the code that I have for reading and writing items in the database. I have not yet completely tested it as I do not have access to my database right now; however, I know that reading items from the database works and since all of the SQL statements are generated in the same manner the insert and updates should work without any problems. If you run into an issue let me know as I will be updating my personal source as well to reflect the changes I made in this version and fixing any bugs.

I know this seems like a lot of code just for updating one table in the database but as I said earlier it is part of a much larger DBI and project that I am working on. Also, to correct my mistake from earlier there are not 250+ fields on the items tables there are actually only 131.

Well, let me know if this is of any use at all. Thanks.

[nosfentora]

Awesome - Thanks Sesmar. I'll let you know as soon as I try it out.

[spider661]

how about just reading the data from a site like lucy that has pritty much everything you need to pt the items in anyways.

if you look at the raw data that is
Rough Defiant Cloth Robe raw page

then all you would have to do is make the program go download the info for you.. you put in a search and it loads the page searches and extracts all done with you just typing in item name and hitting search.

that would be pretty cool.. hard to do probably but cool all the same