Advanced Item Database Search

[Gergall]

An advanced item search would put bg-wiki way ahead of the evil wiki in the eyes of a lot of players.

I have noticed a lot of players clamoring for a searchable item database. Somepage has a feature like this, but many people will never want to go there again due to the recent exploit. Besides, that site does not seem to be updated anymore so it won't include new items.

I was wondering if there is already work being done on this. If so, I would like to know if I could assist. If not, I would like to offer my services in creating a database to store highly detailed, categorized item information, as well as a simple PHP page that could be used for data entry. This is not a complicated project.

[Elesirdur]

FFXI AH has a feature like this. Don't know how that might help our attempts at integration, but the service is there nonetheless. (For auctionable items anyways.)

[Maxxthepenguin]

Unfortunately, due to the nature of wikis and how you edit articles and not raw data, this sort of thing would be very, very hard to implement.

[Lampoon]

MIF

[Gergall]

Unfortunately, due to the nature of wikis and how you edit articles and not raw data, this sort of thing would be very, very hard to implement.

My database of items will include all of the different obvious properties of the items (such as DEF, Rare, Ex, Jobs, Level) as well as some other useful information including the address of the item's web page on bg-wiki.

Let me paint a picture for you. You go to BG-Wiki. You click on a link on the home page that says Advanced Item Search. This takes you to a custom page where you can choose from dozens upon dozens of search options - this will make somepage and ffxiah look pathetic, as I will be categorizing every conceivable item property including special characteristics (like each individual "killer" effect) and minute details (such as the elemental properties of furnishings).

After performing the search, you will naturally see a list of items. Each item is a clickable link that will take you to the item's page on BG Wiki. This will be possible because the BG Wiki page links will be stored for each item in the item database.

(I'm a career web developer and database administrator.)

The most difficult tasks are determining every single item property, and of course entering the data. I was thinking of doing all of the weapons first, put something out there that will hopefully generate a lot of interest, and then get some help entering the rest.

[Gergall]

MIF

No clue what this means

[Julian]

This sounds interesting.

[Sonomaa]

Unfortunately, due to the nature of wikis and how you edit articles and not raw data, this sort of thing would be very, very hard to implement.

My database of items will include all of the different obvious properties of the items (such as DEF, Rare, Ex, Jobs, Level) as well as some other useful information including the address of the item's web page on bg-wiki.

Let me paint a picture for you. You go to BG-Wiki. You click on a link on the home page that says Advanced Item Search. This takes you to a custom page where you can choose from dozens upon dozens of search options - this will make somepage and ffxiah look pathetic, as I will be categorizing every conceivable item property including special characteristics (like each individual "killer" effect) and minute details (such as the elemental properties of furnishings).

After performing the search, you will naturally see a list of items. Each item is a clickable link that will take you to the item's page on BG Wiki. This will be possible because the BG Wiki page links will be stored for each item in the item database.

(I'm a career web developer and database administrator.)

The most difficult tasks are determining every single item property, and of course entering the data. I was thinking of doing all of the weapons first, put something out there that will hopefully generate a lot of interest, and then get some help entering the rest.

that sounds very sexy :nikkei:

[Gergall]

Thanks. I have realized that even just trying to enter all the weapons myself will be a huge undertaking, and am gonna narrow that down further to doing all of the daggers.

I was hoping to make some big leaps this weekend but some real (ie, cash money) side work came my way so I am of course gonna be doing that instead. Still, this is a very real project that I'll be working on if nobody else is planning anything.

[frdrizzt]

Show some sample pages so others can imitate that for other items. I understand the idea, but not how you specifically planned on implementing this. But I felt the same that I loved that feature on somepage, but I stopped going since it was out-of-date (and then had exploits).