Author Topic: !items database (Read 28009 times)

Zeephonz · « **on:** July 22, 2008, 09:51:45 pm »

Heyas all,

Is there any update with regards to someone else supporting the !items database? From what I've read, VHab is not doing it any more, and we now have an items database that's slipping further and further behind.

Does anyone have an option for manual extraction and inclusion?

Anyone? anyone? Beuller? Beuller?

Slacklin · « **Reply #1 on:** July 23, 2008, 12:34:47 am »

I unsuccessfully attempted to use the old DB module from version 0.2.0 but it fails to run. (I am pretty lazy with trying to update it) I do think it is time to get a new solution going but am torn between a flat file vs using the DB to store the information. If its a DB entry then the processing tends to be easier on the system, flat file though seems to be easier to update and get info for. Depends on who wants to write/update a module to work.

Zeephonz · « **Reply #2 on:** July 26, 2008, 11:45:32 pm »

Hello? Any update on this at all?

I know you're all busy on AoC stuff, but there are quite a few AO bot people still around

Zeephonz · « **Reply #3 on:** September 25, 2008, 04:19:05 am »

Bump for an update on this?

We're many versions of the DB behind now, without resolution... or am I missing something here?

Sorekill · « **Reply #4 on:** September 25, 2008, 02:22:04 pm »

bump for db update!

Nytridr · « **Reply #5 on:** September 26, 2008, 10:00:48 am »

bumps for this also.. can we have an alternative to use vhabs item db. it is behind. (no insult to you vhab) but we should be getting something were we can get it updated or be able to have the bot use its own DB.

I have tried to tools to make my own but it crashs on me to much. I can get it.. (or use to be able to) but need a module to access it.

Could someone look into this and see what they can do?

cthulhu · « **Reply #6 on:** October 01, 2008, 01:11:13 pm »

hey folks

it can be that hard can it?

Basicly we just need a db with name/ql/lowid/highid isn't it?

The rest will come from ao itself or am I mistaken there?

refering to the following:
<a href=\"itemref://" . $lowid . "/" . $highid . "/" . $ql . "\">" . $name . "</a>;

I'm working at a parser atm to generate sql out of the xml of Jaydes AODBResourceTool. Actually I wanted to get all items Attributes into a MySQL DB but ofc I could also make a table with just the data named above in it.

What I'll need ofc is also a little script to handle the requests. But yeah guess it is worth a try.

Not sure how fast I'm done with it as I'm pretty busy with work atm

and if I'm wrong somewhere in the ideas above... I would be glade if you could correct me there before I start

regards Cth

cthulhu · « **Reply #7 on:** October 05, 2008, 06:36:16 pm »

Hey Folks

I can offer you this:

http://items.vox-populi-guild.org/

for the moment.
It works together with the bebot module Items.php

All you have to do there is changing the $server var like this:
var $server = 'http://items.vox-populi-guild.org/';

I wont guarantee anything like 100% uptime always newest db etc but it is there for the moment.

Also things like max, output, icons and bot wont do aything atm. The limit will be 50 for the moment.

I tried to give back more or less the same as vhab did/does.

enjoy

regards cth

cthulhu · « **Reply #8 on:** October 08, 2008, 10:46:35 am »

nobody intrested in this any longer?

at least I can't see hits from any other client then my bots in the access.log....

regards cth

Hyde · « **Reply #9 on:** October 08, 2008, 04:13:11 pm »

I'm actually more interested in the process you used to create it. If you don't feel like sharing it, I understand. It is that after many years of constantly having !items break in some way due to lack of updates I would prefer to be able manage, populate and host my own items service.

cthulhu · « **Reply #10 on:** October 09, 2008, 12:10:32 am »

oh well ofc I can share the process.

First of all I used Jaydes tool to rip the DB. Actually I started my own parser for the ao db before but hell it was a damn stupid idea to write try it with php

anyway Jaydes tool can transform the db into a nice xml format which contains everything you need.

now there is an easy and a harder way...

you can write your own script/tool whatever that gets you the relevant data(what would be iconid, low-highid and the name - xpath is a pretty nice way to do that) out of the xml and bring it in the form of a sql insert statement so you can insert the data into your db.

but afaik there is already a tool that can do that... but I can remember the name. Guess aodevs could help you there.

Once you got that... all you have to do is to make something that gives the same output back as items.vhabot.net

that's all

regards
cth

Nogoal · « **Reply #11 on:** October 09, 2008, 01:38:30 pm »

Didn't try it but you can find AODBC on budabot's page. I guess it makes a sql from your AO folder.

I tried your url in my bots but even if it says that you have 17.10 db I couldn't find any new nano. Guess it's because they don't have nanocrystals.

cthulhu · « **Reply #12 on:** October 09, 2008, 02:44:25 pm »

yeah might be that

because http://items.vox-populi-guild.org/?search=Beta%20Box find the beta box which contains the nanos

would be an intresting question: how to get that data. Will have a look into it as soon as possible

and yeah right AODBC was the tool. But it can't extract the raw db. You still have to convert it with jaydes tool first.

regards cth

cthulhu · « **Reply #13 on:** October 09, 2008, 03:00:27 pm »

hmm guess the problem is that I'm just getting items out of the db and not nano effects.

Hopefully I find some time to look into it that weekend

Zeephonz · « **Reply #14 on:** December 03, 2008, 02:05:21 am »

Vhab indicated on the AO forums that he had updated the items database. Is there any particular reason why Bebot is not seeing the latest items on searching?

Author Topic: !items database (Read 28009 times)

Zeephonz

!items database

Slacklin

Re: !items database

Zeephonz

Re: !items database

Zeephonz

Re: !items database

Sorekill

Re: !items database

Nytridr

Re: !items database

cthulhu

Re: !items database

cthulhu

Re: !items database

cthulhu

Re: !items database

Hyde

Re: !items database

cthulhu

Re: !items database

Nogoal

Re: !items database

cthulhu

Re: !items database

cthulhu

Re: !items database

Zeephonz

Re: !items database