I am, but one of the modules requires local items database (Malosar's bossloot), besides a local database is, at least for me, faster than using Vhab's centralized DB

to be honest i rewrote a bit of the plugin, and i'm having no troubles with it... i'll include a copy here, i've changed it to read 'items2' so it can run in combination with the central database

items2.php for bebot 0.4.0
<?
  /*
   * Items.php - Searches the itemsdatabase.
   *
   * BeBot - An Anarchy Online Chat Automaton
   * Copyright (C) 2004 Jonas Jax
   *
   * Developed by Blondengy (RK1)
   * Special thanks goes out to Khalem (RK1) for his support.
   *
   * File last changed at $LastChangedDate: 2007-6-15 01:41:32 -0600 $
   * Revision: $Id: Items.php 8 2007-6-15 00:41:32Z parfet(rk2) $
   *
   * Revised for Icon display - By: Xenixa
   */


  /*
    Prepare MySQL database
  */
  $db -> query("CREATE TABLE IF NOT EXISTS items
               (lowid INT NOT NULL,
        highid INT NOT NULL,
        lowql INT,
        highql INT,
        name VARCHAR(150),
        icon INT)");


  $items2 = new Items2($bot);


  $commands["tell"]["items2"] = &$items2;
  $commands["pgmsg"]["items2"] = &$items2;
  $commands["gc"]["items2"] = &$items2;



  /*
    The Class itself...
  */
  class Items2
  {
    var $bot;



    /*
      Constructor:
        Hands over a referance to the "Bot" class.
    */
    function Items2 (&$bot)
    {
      $this -> bot = &$bot;
    }



    /*
      This gets called on a tell with the command
    */
    function tell($name, $msg)
    {
      //~ if (preg_match("/^" . $this -> bot -> commpre . "items2 make ([0-9]+) ([0-9]+) ([0-9]+) (.+)/i", $msg, $info))
        //~ $this -> bot -> send_tell($name, $this -> make_item($info[1], $info[2], $info[3], $info[4]));
      if (preg_match("/^" . $this -> bot -> commpre . "items2 ([0-9]+) (.+)/i", $msg, $info))
        $this -> bot -> send_tell($name, $this -> search_items($info[2], $info[1]));
      else if (preg_match("/^" . $this -> bot -> commpre . "items2 (.+)/i", $msg, $info))
        $this -> bot -> send_tell($name, $this -> search_items($info[1]));
    }



    /*
      This gets called on a msg in the privgroup with the command
    */
    function pgmsg($name, $msg)
    {
      if (preg_match("/^" . $this -> bot -> commpre . "items2 ([0-9]+) (.+)/i", $msg, $info))
        $this -> bot -> send_pgroup($this -> search_items($info[2], $info[1]));
      else if (preg_match("/^" . $this -> bot -> commpre . "items2 (.+)/i", $msg, $info))
        $this -> bot -> send_pgroup($this -> search_items($info[1]));
    }



    /*
      This gets called on a msg in the guildchat with the command
    */
    function gc($name, $msg)
    {
      if (preg_match("/^" . $this -> bot -> commpre . "items2 ([0-9]+) (.+)/i", $msg, $info))
        $this -> bot -> send_gc($this -> search_items($info[2], $info[1]));
      else if (preg_match("/^" . $this -> bot -> commpre . "items2 (.+)/i", $msg, $info))
        $this -> bot -> send_gc($this -> search_items($info[1]));
    }



    //~ /*
      //~ Returns an itemref...
    //~ */
    //~ function make_item($ql, $low, $high, $name)
    //~ {
      //~ return "QL ##Highlight##" . $ql . "##End## " . $this -> bot -> make_item($low, $high, $ql, $name);
    //~ }


    /*
      Searches for items
    */
    function search_items($name, $ql=0)
    {
     
if (preg_match("/<a href=\"itemref:\/\/([0-9]*)\/([0-9]*)\/([0-9]*)\">(.*)<\/a>/iU",$name, $link)) {
if (preg_match("/Instruction Disc (.*)/i", $link[4], $id)) {
$name = $id[1];
} else {
$name = $link[4];
}
}

 
  //$name = str_replace("'", "", $name);
      if ($ql != 0)
      {
        $addage = " AND lowql <= $ql AND highql >= $ql";
        $order = "name ASC, highql DESC";
        $addql = "QL ##Highlight##$ql##End##";
      }
      else
      {
        $addage = "";
        $order = "highql DESC, name ASC";
        $addql = "any QL";
      }

      $name2 = str_replace(" ", "%", $name);
  $name2 = addslashes($name2);

      $num = $this -> bot -> db -> select("SELECT count(*) FROM items WHERE name LIKE '%".$name2."%'" . $addage);
      $result = $this -> bot -> db -> select("SELECT lowid, highid, lowql, highql, name, icon FROM items WHERE name LIKE '%".
                            $name2 . "%'" . $addage . " ORDER BY " . $order . " LIMIT 0, 50");

      $outside = "Search for $addql \"##Highlight##$name##End##\" brought up " .
                  "##Highlight##" . $num[0][0] . "##End## results.";
      $inside = "<center>##Highlight##:::##End## ##Blob_Title##Search Results for \"##Highlight##$name##End##\"##End## ##Highlight##:::##End##</center>\n\n";

      if (!empty($result))
      {
      if ($num[0][0] == 1)
      {
          $outside .= "\nQL ##Highlight##" . (($ql == 0) ? $result[0][3] : $ql) . "##End## " .
          $this -> bot -> make_item($result[0][0], $result[0][1], (($ql == 0) ? $result[0][3] : $ql), $result[0][4]) .
                      " ##Blob_Text##[QL ##Highlight##" . $list[2] . "##End##-##Highlight##" . $list[3] . "##End##]##End##";
        }
        else
{
        foreach ($result as $list)
        {
        //~ $inside .= "<img src=rdb://" . $list[5] . ">\n";
            //$inside .= $this -> bot -> make_item($list[0][0], $list[0][1], (($ql == 0) ? $list[0][3] : $ql), $list[0][4]) .
        $inside .= "<a href=itemref://" . $list[0] . "/" . $list[1] . "/" . (($ql == 0) ? $list[3] : $ql) . ">"
. "<img src=rdb://" . $list[5] . ">\n" . $list[4] . "</a> ##Blob_Text##[QL ##Highlight##" . $list[2]
. "##End##-##Highlight##" . $list[3] . "##End##]##End##\n\n";
            }
        }
      }

      if ($num[0][0] > 1)
        $outside .= $this -> bot -> make_blob("\nClick to View", $inside) .
        " results ##Highlight##1##End## to ##Highlight##" .
                    (($num[0][0] > 50) ? "50" : $num[0][0]) . "##End##.";

      return $outside;
    }
  }
?>


actually the header is correct (optimized) but the info is kinda borked... i used that new experimental extractor located in the 'ctreestd.dll' thread on aodevs.com, and what's wrong is instead of listing those kinda items as (sql) lowid,highid,lowql,highql,etc it's listing lowid,lowid,lowql,lowql,etc and then highid,highid,highql,highql,etc... i didn't see that before, but that's what's screwing up the listings by ql... need the good aodbresourcetool fixed... current version crashes on each extract... i'll have to keep arguing with it

thanks so much!!!  Both of the bots I run are working beautifully!!!

~bOogY

bump, above link is now 17.5, updated & tested this time

woot for 4.x release of an updated plugin

one thing i'd like to see added to both these items listers, i've done so locally and my users that have used it like it

  function search_items($name, $ql=0)
    {
//~ Pulls strings from item references, to get Instruction Disc names,
//~ or sometimes different QL of the same item name
if (preg_match("/<a href=\"itemref:\/\/[0-9]*\/[0-9]*\/[0-9]*\">(.*)<\/a>/iU", $name, $link)) {
if (preg_match("/Instruction Disc (.*)/i", $link[1], $id)) {
$name = $id[1];
} else {
$name = $link[1];
}
}

at the top of the function, adds the primary ability to drop instruction disks to pull up the nano crystal it goes to, quite a time saver.

here we go again, 17.6.1 database, for those who use it