$sortorder = SORT_ASC; } } // TABELLE HEADER $tb_header = new MyTableHeader(); $tb_header->setTitle(array("Itemname", "Sichtbar", "ADMIN")); $tb_header->setCenter(array(false, true, true)); $tb_header->setWidth(array(400, 100, 100)); $tb_header->setSortindex($sortindex); $tb_header->setSortorder($sortorder); $tb_header->setExtrasort(true, 0); // TABELLE DATA $tb_table = new MyTable(); $tb_table->setHeader($tb_header); $tb_table->setTemppage(toSaferValue(@$_GET["page"])); $tb_table->setExtrasort(true, 0); // HIDDEN ITEMS $result = mysql_query("SELECT *FROM " . $databasename . "." . $tableprefix . "hiddenitems"); $counter = 0; $hiddenitems = array(); while ($row = @mysql_fetch_assoc($result)) { $hiddenitems[$counter] = $row["itemid"]; $counter = $counter + 1; } // INVENTAR $result = mysql_query("SELECT *, " . $databasename . "." . $tableprefix . "guildbank.itemid AS use_itemid FROM " . $databasename . "." . $tableprefix . "guildbank LEFT JOIN " . $databasename . "." . $tableprefix . "itempoints ON " . $databasename . "." . $tableprefix . "guildbank.itemid = " . $databasename . "." . $tableprefix . "itempoints.itemid UNION SELECT *, " . $databasename . "." . $tableprefix . "itempoints.itemid AS use_itemid FROM " . $databasename . "." . $tableprefix . "guildbank RIGHT JOIN " . $databasename . "." . $tableprefix . "itempoints ON " . $databasename . "." . $tableprefix . "guildbank.itemid = " . $databasename . "." . $tableprefix . "itempoints.itemid WHERE " . $databasename . "." . $tableprefix . "guildbank.itemid IS NULL"); $counter = 0; $inventar = array(); while ($row = @mysql_fetch_assoc($result)) { $foundinv = false; for ($a = 0; $a < count($inventar); $a++) {