I know, I know, been a long time coming.
What with Vhab posting a remote version it kinda spurred me on to parse out a version that'll work with Bebot on a local level. I mean we have that speedy MySQL server sitting there why not use it eh?

Anyway, you'll need two files to see the Icons.
1.) The updated version on the Items database in this file bebot-items16.2.3.zip
2.) This updated Items.php
3.) (OPTIONAL) Clusters SQL File (Note: Must load main Items SQL script before loading this one)

16.3 UPDATE: 16.3.01 Items Update for Bebot is HERE! Just run the sql there against your bots database to update the Items table.

Some notes: Replace Items.php with the file above(make back up of original just incase) in the /modules folder
Use what ever method you're accustomed to update the items table with the SQL script file in that .zip. It will drop the current table before recreating it with the new data.

A special note about the Items database I have posted here:
 I'll say it bluntly. It was a PITFA to get it to parse correctly. A couple items may have their QL ranges off a bit but for the most part they are correct. I'm still perfecting my XML to SQL parsing script which is a very customized version of Angels AODBXMLparser v2.7

I tried to filter out as much of the crap items that players can't use, but I was getting rather tired browsing the unfiltered Items table looking for stuff to remove. For those wondering which got filtered, here's the SQL ran against the raw XML converted items table.
  $db -> query("delete from aodb_temp where ql = '' and icon = '';");
  $db -> query("delete from aodb_temp where name = ''
  or ql = ''
  or name regexp '\_001'
  or name regexp '\_300'
  or name regexp '\_400'
  or name regexp '.abiff'
  or name regexp 'abilityitem'
  or name regexp '\_boss'
  or name regexp 'dummy\_'
  or name regexp 'plc\_'
  or name regexp 'check\_'
  or name regexp 'Cluster -'
  or name regexp 'Implant:'
  or name regexp 'Equip\_'
  or name regexp 'Lootgiver'
  or name regexp 'RINGEVENT\_'
  or name regexp 'wearable'
  or name regexp 'NPC Pet Creation Item'
  or name regexp 'Construction Kit '
  ;");
  $db -> query("delete from aodb_temp where name = 'Combined Commando\'s Headwear' and icon = '0';");
  $db -> query("delete from aodb_temp where name like '%Kyr\'ozch%' and itemtype = 'Weapon' and icon < 90000");
Altogether those SQL statements removed approx 55kto 60k items.  Basically it halved what was there.
Attached a Pic of what a Multi-Item search will look like. Single item search returns places link in chat.

Sure, I can do one with and one without Clusters.

I'll hopefully have a better output of the SQL that correctly groups and sorts. I found a few nasty surprises in that version I have posted above. Nothing major but quite annoying really.

Hmmm, thats even a better idea. Make a fully filtered version as I have now, then a seperate Bebot-Clusters.sql or whatever I call it when finished. Gotta head out to work right now but I should have time tonight to hash out something.

Yeah, there is an error in the code for multiple results - it always shows the icon of the first result only.

$inside .= "<img src=rdb://" . $result[0][5] . ">"; 17 lines from the end needs to be $inside .= "<img src=rdb://" . $result[$i][5] . ">";

And as requested by Alreadythere

ftp://xen.afraid.org/bebot_files/bebot16.2.3clusters.sql

Using that SQL script assumes you already loaded an items table onto your bots database.

Was prehistoric symbs filtered in this database?
Would be nice.

Updated the main Items SQL again. I reparsed it using some better logic to sort low & high id's and ql's. Old one had a bunch were the low and high were reversed.

Was prehistoric symbs filtered in this database?
Would be nice.

Not too sure what you mean by prehistoric symbs. All the Symbiants in the database are included in this copy. Even the ones that don't drop.