BeBot - An Anarchy Online and Age Of Conan chat automaton
Archive => Anarchy Online Archive => BeBot 0.4 support => Topic started by: 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?
;D
-
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.
-
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 ;)
-
Bump for an update on this?
We're many versions of the DB behind now, without resolution... or am I missing something here?
;D
-
bump for db update!
-
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?
-
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
-
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
-
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
-
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.
-
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
-
Didn't try it but you can find AODBC on budabot's page (http://budabot.aodevs.com/index.php?page=14). 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.
-
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
-
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
-
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?
-
It should. Just stuff like the new nanos don't got crystals with the same name, so you can't check their stats. The items to upload the nanos should show up.
-
bebot has nothing to do with what gets show or not for Items, if items arnt showing them its a issue with vhad site :D