[Andreas]

PHP Code:

$item_results = $DB_site->query_first("
        SELECT id, swordname, money FROM swords
        ORDER BY id DESC
    ");
    while ($item = $DB_site->fetch_array($item_results))
    $item['swordname'] = $item_results[swordname];
    $item['money'] = intval ($item_results[money]);
    $item['id'] = intval ($item_results[id]);
    } 


What the hell are you doing here?
$item_results is an associative array (with keys id, swordname and money). You can't use this as a parameter for fetch_array(), which expects a mySQL result resource (eg. a handle which basically is an integer).

I can only guess that what you want to do is smth. like tis:

PHP Code:

// What Sword User has Now
$thread_sword = $bbuserinfo['sword'];
// All Items
$item_results = $DB_site->query("SELECT id, swordname, money
                                 FROM " . TABLE_PREFIX . "swords
                                 ORDER BY id DESC
                                ");
while ($item = $DB_site->fetch_array($item_results)) {
  echo "Fetched row is id: $item[id], swordname: $item[swordname], money: $item[money]<br />";
}