collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: !items database  (Read 10091 times)

0 Members and 1 Guest are viewing this topic.

Offline Zeephonz

  • BeBot User
  • **
  • Posts: 43
  • Karma: +0/-0
!items database
« 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

Offline Slacklin

  • BeBot User
  • **
  • Posts: 52
  • Karma: +0/-0
  • My spoon is too big!
    • United Org Site
Re: !items database
« 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.

Offline Zeephonz

  • BeBot User
  • **
  • Posts: 43
  • Karma: +0/-0
Re: !items database
« 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  ;)

Offline Zeephonz

  • BeBot User
  • **
  • Posts: 43
  • Karma: +0/-0
Re: !items database
« 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?

 ;D

Offline Sorekill

  • BeBot Rookie
  • *
  • Posts: 11
  • Karma: +0/-0
Re: !items database
« Reply #4 on: September 25, 2008, 02:22:04 pm »
bump for db update!

Offline Nytridr

  • BeBot Expert
  • ****
  • Posts: 262
  • Karma: +0/-0
    • Rising Sun
Re: !items database
« 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?
Co-Prez of Rising Sun RK1 (1st & only org I will ever belong to)

Offline cthulhu

  • BeBot Rookie
  • *
  • Posts: 9
  • Karma: +0/-0
Re: !items database
« 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
That is not dead which can eternal lie.
And with strange aeons even death may die.

Offline cthulhu

  • BeBot Rookie
  • *
  • Posts: 9
  • Karma: +0/-0
Re: !items database
« 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
That is not dead which can eternal lie.
And with strange aeons even death may die.

Offline cthulhu

  • BeBot Rookie
  • *
  • Posts: 9
  • Karma: +0/-0
Re: !items database
« 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
That is not dead which can eternal lie.
And with strange aeons even death may die.

Offline Hyde

  • BeBot Apprentice
  • ***
  • Posts: 92
  • Karma: +0/-0
Re: !items database
« 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.
Doctorhyde/Jexyll/Goraud@RK2

Offline cthulhu

  • BeBot Rookie
  • *
  • Posts: 9
  • Karma: +0/-0
Re: !items database
« 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
That is not dead which can eternal lie.
And with strange aeons even death may die.

Offline Nogoal

  • BeBot Apprentice
  • ***
  • Posts: 77
  • Karma: +0/-0
Re: !items database
« 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.
« Last Edit: October 09, 2008, 01:42:03 pm by Nogoal »

Offline cthulhu

  • BeBot Rookie
  • *
  • Posts: 9
  • Karma: +0/-0
Re: !items database
« 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
That is not dead which can eternal lie.
And with strange aeons even death may die.

Offline cthulhu

  • BeBot Rookie
  • *
  • Posts: 9
  • Karma: +0/-0
Re: !items database
« 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
That is not dead which can eternal lie.
And with strange aeons even death may die.

Offline Zeephonz

  • BeBot User
  • **
  • Posts: 43
  • Karma: +0/-0
Re: !items database
« 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?

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 470
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal