$sortindex = toSaferValue(@$_GET["sortindex"]);
if ($sortindex == "") {
$sortindex = 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("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();
$sortindex = toSaferValue(@$_GET["sortindex"]);
if ($sortindex == "") {
$sortindex = 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)) {
$sortindex = toSaferValue(@$_GET["sortindex"]);
if ($sortindex == "") {
$sortindex = 0;
}
$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");
}
$sortorder = SORT_ASC;
} else {
if ($sortorder == "desc") {
$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;
