} $sortorder = toSaferValue(@$_GET["sortorder"]); if ($sortorder == "") { $sortorder = SORT_ASC; } else { if ($sortorder == "desc") { $sortorder = SORT_DESC; } else { $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;
} $sortorder = toSaferValue(@$_GET["sortorder"]); if ($sortorder == "") { $sortorder = SORT_ASC; } else { if ($sortorder == "desc") { $sortorder = SORT_DESC; } else { $sortorder = SORT_ASC; } } // TABELLE HEADER $tb_header = new MyTableHeader(); $tb_header->setTitle(array("Platz", "Name", "Level", "Klasse", "Gildenbank-Konto", "Diese Woche (KW)")); $tb_header->setCenter(array(true, false, true, false, true, true)); $tb_header->setWidth(array(50, 150, 100, 200, 150, 150)); $tb_header->setSortindex($sortindex); $tb_header->setSortorder($sortorder); // TABELLE DATA $tb_table = new MyTable(); $tb_table->setHeader($tb_header); $tb_table->setTemppage(toSaferValue(@$_GET["page"])); // WOCHEN-PUNKTE $monday = strtotime('last monday', strtotime('tomorrow')); $sqlstring = date("Y-m-d H:i:s", $monday); $weekpoints = array(); $result = mysql_query("SELECT * FROM " . $databasename . "." . $tableprefix . "gbphistory WHERE type = 1 AND timestamp >= '" . $sqlstring . "'"); while ($row = @mysql_fetch_assoc($result)) { if (!array_key_exists($row["name"], $weekpoints)) { $weekpoints[$row["name"]] = $row["points"]; } else {
} $sortorder = toSaferValue(@$_GET["sortorder"]); if ($sortorder == "") { $sortorder = SORT_DESC; } else { if ($sortorder == "desc") { $sortorder = SORT_DESC; } else { $sortorder = SORT_ASC; } } // TABELLE HEADER $tb_header = new MyTableHeader(); $tb_header->setTitle(array("Zeit", "Name", "Typ", "Punkte", "Bemerkung", "ADMIN")); $tb_header->setCenter(array(false, false, false, true, false)); $tb_header->setWidth(array(150, 150, 100, 100, 300, 100)); $tb_header->setSortindex($sortindex); $tb_header->setSortorder($sortorder); // TABELLE DATA $tb_table = new MyTable(); $tb_table->setHeader($tb_header); $tb_table->setTemppage(toSaferValue(@$_GET["page"]) . "&name=" . toSaferValue(@$_GET["name"])); // HISTORY if ($name == "") { $result = mysql_query("SELECT * FROM " . $databasename . "." . $tableprefix . "gbphistory ORDER BY timestamp DESC LIMIT 50"); } else { $result = mysql_query("SELECT * FROM " . $databasename . "." . $tableprefix . "gbphistory WHERE name = '" . $name . "' ORDER BY timestamp DESC"); } $types = array(); $types[1] = "<img src=\"./images/list_add.png\" alt=\"Einlagern\" title=\"Einlagern\"> Einlagern"; $types[-1] = "<img src=\"./images/list_remove.png\" alt=\"Auslagern\" title=\"Auslagern\"> Auslagern";
$sortorder = SORT_DESC; } else { $sortorder = SORT_ASC; } } // FILTER $onlychar = toSaferValue(@$_GET["filter"]); $onlycharwhere = ""; if ($onlychar != "") { $onlycharwhere = " WHERE bankchar = '" . $onlychar . "'"; } // TABELLE HEADER $tb_header = new MyTableHeader(); $tb_header->setTitle(array("Menge", "Itemname", "Bankchar", "Punkte*")); $tb_header->setCenter(array(true, false, false, true)); $tb_header->setWidth(array(100, 400, 200, 100)); $tb_header->setSortindex($sortindex); $tb_header->setSortorder($sortorder); $tb_header->setExtrasort(true, 1); $tb_header->setFilter($onlychar); // TABELLE DATA $tb_table = new MyTable(); $tb_table->setHeader($tb_header); $tb_table->setTemppage(toSaferValue(@$_GET["page"])); $tb_table->setExtrasort(true, 1); // HIDDEN ITEMS $result = mysql_query("SELECT *FROM " . $databasename . "." . $tableprefix . "hiddenitems"); $counter = 0; $hiddenitems = array(); while ($row = @mysql_fetch_assoc($result)) { $hiddenitems[$counter] = $row["itemid"];