This one maybe.
http://dl.aosource.de/tools/AODBXMLparser/AODBXMLparser_2.6.tar.gz

Latest Update here: 16.1.2

Important notes:
This is an experimental update. BACKUP your database before usage.

Thanks to Angels for parsing!

ok well uhm err....

was this one meant to be used in place of the 15.9.2 DB, or in addition to?

There are a lot of things missing from the 16.1.2 posted, such as a lot of nanos or inability to request certain alien weapon QLs (205 kyr sword type 112 or so)

So... I combined the 2 of them, and removed the old symbiant links from the 15.9.2 database.  and like before, use this at your own risk

new 16.1.2

I also separated a lot of it into multiple insert statements, as mysql was giving me some large packet errors when adding too many things at once.

for the most part I haven't seen anything really missing now, and seems to run great.  I think totals around 50k entries for the items DB (not at the PC) and seems fairly comprehensive now with what I think most people look for.

What things were giving errors?

This is the original script used to make the database. I never intended to release this but this might help you in your development. (Please note: its NOT inteded to be used by someone who doesn't really know what they're doing. )

It uses Auno's XML file as an input.

The main reason I never inteded to release it is that its probably one of my worst pieces of work and was thrown together quickly in a few minutes. It lets MySQL do most of the work which is definatly not a good thing. Because MySQL does most of the work you should definatly run this script on the same machine as the MySQL server, you should also not run this on an oldish machine as it would take to long and you should not run it on a machine that you need for the next 30 mins or so. This script will cause your MySQL server to swallow 99% of your CPU load for 30mins or so (depending on your CPU). Its crappy, it sucks but it does the job. I think you now get the point - I hate myself for not recoding it!

I'm releasing this so that you can have a look at it in the hopes that it helps you improve your script for parsing the XML. Once its run you might wanna add a few cases so that it groups the NCU Memories, the ELLTS and other special items properly (those two are the only ones I can think of at the moment that it doesn't group due to the low and high name beeing different and not following any pattern).

Here we go at your own risk: (Added a few extra comments to make it more readable)
<?
  $time_now = time();
 
  require_once("MySQL.php");

  $db = new MySQL();

  $db->query("CREATE TABLE items
        (lowid INT NOT NULL,
        highid INT NOT NULL,
        lowql INT,
        highql INT,
        name VARCHAR(150))");

  $db->query("CREATE TABLE items_tmp
        (id INT NOT NULL,
        ql INT,
        name VARCHAR(150))");
       
  $handle = fopen("150804.xml", "r");

  // start reading XML line for line
  while($line = fgets($handle, 1000))
  {
    // Check if this is the start-tag of an item we want to extract
    if (preg_match("/item aoid=\"([0-9]+)\" patch=\"([0-9]+)\" metatype=\"(w|i)\">/", $line, $id))
    {
      // Read the wanted item line for line and extract needed info
      while($line = fgets($handle, 1000))
      {
        // Looking for the name first
        if (preg_match("/<name>(.+)<\/name>/", $line, $name))
        {
          // Ignore implants and clusters - who needs them in the items DB?!
          if (preg_match("/ Implant: /", $name[1]) || preg_match("/ Cluster - /", $name[1]))
            break;
          // Now that we have a name and its not an implant/cluster we contine searching line by line
          while($line = fgets($handle, 1000))
          {
            // We got the name so we need its QL
            if (preg_match("/<ql>([0-9]+)<\/ql>/", $line, $ql))
            {
              $id = $id[1];
              // Remove some unneeded prefixes so that it groups properly.
              $name = str_replace("'", "", $name[1]);
              $name = preg_replace("/^High-Quality /i", "", $name);
              $name = preg_replace("/^Augmented /i", "", $name);
              $name = preg_replace("/^Basic /i", "", $name);
              $name = preg_replace("/^Worn /i", "", $name);
              $name = preg_replace("/^Inferior /i", "", $name);
              $name = preg_replace("/^Flawless /i", "", $name);
              $name = preg_replace("/^Low Light /i", "Extreme Low Light ", $name);
              $ql = $ql[1];

              // Slows it down a bit, but makes sure there're no duplicates
              $result = $db -> select("SELECT id FROM items_tmp WHERE name = '$name' AND ql = $ql");
              // Insert item into temp table if its not already there.
              if (empty($result))
                $db -> query ("INSERT INTO items_tmp (id, name, ql) VALUES ($id, '$name', $ql)");
              break;
            }
          }
          // We got all info we need on this item so lets continue search for the next one.
          break;
        }
      }
    }
  }
  fclose($handle);
 
  echo "Done reading XML file, now grouping items...\n";

  $result = 1;
  while (!empty($result))
  {
    // Let MySQL do the grouping - I'm lazzy today and want to get this done. (doing this 300 groups at a time cause I feel like it)
    $result = $db -> select("SELECT name FROM items_tmp GROUP BY name ORDER BY id ASC LIMIT 0, 300");
    if (!empty($result))
    foreach ($result as $run)
    {
      $name = $run[0];
      // Select all belonging to this group, arrange highid/lowid stuff and insert them into items table
      $res = $db -> select("SELECT id, ql FROM items_tmp WHERE name = '$name' ORDER BY ql ASC");
      for ($i = 0; $i < count($res); $i += 2)
      {
        if ($i < (count($res) - 1))
        {
          $lowid = $res[$i][0];
          $highid = $res[($i + 1)][0];
          $lowql = $res[$i][1];
          $highql = $res[($i + 1)][1];
        }
        else
        {
          $lowid = $res[$i][0];
          $highid = $res[$i][0];
          $lowql = $res[$i][1];
          $highql = $res[$i][1];
        }
        $db -> query("INSERT INTO items (lowid, highid, lowql, highql, name) VALUES ($lowid, $highid, $lowql, $highql, '$name')");
      }
      // Delete the group from temp table since we're done with it
      $db -> query("DELETE FROM items_tmp WHERE name = '$name'");
    }
  }
 
  echo "Operation took " . (((int)((time() - $time_now) / 6)) / 10) . " minutes.\n";
?>
As you might see it uses the MySQL.php, but a different version, one which loads the mysql.conf itself... (as I said - only to be used by people who know what they're doing).
You need to set it up on a database with an empty or none-existant "items" table. Once it filled up the items table I used a dump of that as the items.sql file.
Hope it helps you, good luck and sorry for not beeing any more help!

- Blondengy

For some reason this dump missing nano "ranged energy mastery", have id/algorithm/pppe, but not nano. Like 15.9

Examined this base more closely.
Very buggy.

Lot's of double items.
Kyr weaps with and without \'
Some weapons and armors doubled.
Weapons have wrong ranges. (search for MTI B-94, got full blob, including ql152-11)