General Discussion

Hi!

i am working on a bebot plug in for an org inventory where users can store twinkage/giveaway items.

I am planning to add a "!org search" funtion to query the org inventory, but not only by name such as "!org search shades lucubration", but by modifiers, too (such as "!org searchmod int+psy" returns the shades of lucubration as well.

I wanted to store the modifiers on the database, so when adding an item ("!org add shades of lucubration") i want to query a items database to get the modifiers from the added items and store them in the local database.

Is it planned to extend the XML output to give all attributes of an item? Or am i really forced to access auno's db and hack the HTML answer apart?

Any suggestions are appreciated! (PM me ingame - Krisplin or Zzzzzzwap on RK2) ot mail/pm me...

thanks
Krisplin/Zzzzzzwap

There's currently no plans on providing a full xml output based on a single item/id as input.
The DB functions as a searchable DB assuming the receiver only needs a little bit of info to display the results.
Another reason would be the inefficiency of a method like that and the load it creates on the server on doing lookups on every single item.

Hi Vhab,

aye, expected those arguments.

That leaves me with two possibilities:
Accessing the web based item-databases and hack the html output to get what i want
==> which causes the same load to the servers, its only a bit harder to implement the HTML hack'n'slay.

setting up a local items database
==> might be the best choice (in terms of speed/load/bandwith issues), but renders centralized services merely obsolete

Perhaps someone can gimme a hint regarding the second issue? i have a mysql up and runnig, how do i get the items database/tables extracted properly? must have been done a thousand times...

thanks for help!

I first extract to xml using Jayde's thingy (download on aodb site)
Then I use derro's AODBC (somewhere on budabot site) to generate relations between the high-id and the low-id. (you probebly don't need this step though depending on what info you're looking for).
To generate the sql output of each item (doesn't contain all info, just basic stuff like type/slot/etc) i use Angels' Afterstep, not entirely sure where I downloaded that, but I probebly linked it on aodevs.
Also using a bunch of custom scripts to filter and complete certain data, but you won't need that for your purposes.

Hi!

thanks for the info... already started with jayde's extractor. Failed miserably due to application exception (NOT .NET dependent...). I was Using 0.9.7.0 BETA, latest available. Possibly i will update this post with the results of my work...
regards