$inventar[$counter]["name"] = "ID: " . $row["use_itemid"]; } else { $inventar[$counter]["name"] = $row["itemname"]; } if ($row["itemrare"] == NULL) { $inventar[$counter]["rare"] = 0; } else { $inventar[$counter]["rare"] = $row["itemrare"]; } $counter = $counter + 1; } } @mysql_free_result($result); for ($a = 0; $a < count($inventar); $a++) { if ($inventar[$a]["hidden"]) { $tb_table->addRow(array($inventar[$a]["name"], "Nein", "[link]")); $tb_table->addHtmlrow(array("<div class=\"rare" . $inventar[$a]["rare"] . "\"><a href=\"http://datenbank.welli-it.de/?item=" . $inventar[$a]["id"] . "\" target=\"_BLANK\">" . $inventar[$a]["name"] . "</a></div>", "Nein", "<a href=\"index.php?page=scripts/editvisibility&id=" . $inventar[$a]["id"] . "\">ändern</a>")); } else { $tb_table->addRow(array($inventar[$a]["name"], "Ja", "[link]")); $tb_table->addHtmlrow(array("<div class=\"rare" . $inventar[$a]["rare"] . "\"><a href=\"http://datenbank.welli-it.de/?item=" . $inventar[$a]["id"] . "\" target=\"_BLANK\">" . $inventar[$a]["name"] . "</a></div>", "Ja", "<a href=\"index.php?page=scripts/editvisibility&id=" . $inventar[$a]["id"] . "\">ändern</a>")); } $tb_table->addExtraKey(array($inventar[$a]["rare"])); } // TABELLE SORT AND PRINT $tb_table->sortTable(); $tb_table->printTable(); ?> </table> </div> </div>
$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"; while ($row = @mysql_fetch_assoc($result)) { $tb_table->addRow(array($row["timestamp"], $row["name"], $row["type"], $row["points"], $row["info"], "[link]")); $tb_table->addHtmlrow(array(mysqlDate($row["timestamp"]), "<a href=\"?page=gbphistoryadmin&name=" . $row["name"] . "\">" . $row["name"] . "</a>", $types[$row["type"]], $row["points"], $row["info"], "<a href=\"index.php?page=editgbpentry&id=" . $row["historyid"] . "\">ändern</a>")); } @mysql_free_result($result); // TABELLE SORT AND PRINT $tb_table->sortTable(); $tb_table->printTable(); ?> </table> </div> </div>
$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 { $weekpoints[$row["name"]] = $weekpoints[$row["name"]] + $row["points"]; } } @mysql_free_result($result); // MITGLIEDER $result = mysql_query("SELECT * FROM " . $databasename . "." . $tableprefix . "member ORDER BY gbp DESC"); $counter = 1; $symbols = getClassIcons(); while ($row = @mysql_fetch_assoc($result)) { if (!array_key_exists($row["name"], $weekpoints)) { $weekpoints[$row["name"]] = 0; } $tb_table->addRow(array($counter, $row["name"], $row["level"], $row["class"], $row["gbp"], $weekpoints[$row["name"]])); $tb_table->addHtmlrow(array($counter, "<a href=\"?page=gbphistory&name=" . $row["name"] . "\">" . $row["name"] . "</a>", $row["level"], "<img src=\"./images/classes/" . $symbols[$row["class"]] . "\" alt=\"" . $row["class"] . "\" title=\"" . $row["class"] . "\"> " . $row["class"], "<a href=\"?page=gbphistory&name=" . $row["name"] . "\">" . $row["gbp"] . "</a>", "<a href=\"?page=gbphistory&name=" . $row["name"] . "\">" . $weekpoints[$row["name"]] . "</a>")); $counter++; } @mysql_free_result($result); // TABELLE SORT AND PRINT $tb_table->sortTable(); $tb_table->printTable(); ?> </div> </div>
$inventar[$counter]["name"] = "ID: " . $row["use_itemid"]; } else { $inventar[$counter]["name"] = $row["itemname"]; } if ($row["itemrare"] == NULL) { $inventar[$counter]["rare"] = 0; } else { $inventar[$counter]["rare"] = $row["itemrare"]; } if ($row["itemnote"] == NULL) { $inventar[$counter]["notiz"] = ''; } else { $inventar[$counter]["notiz"] = $row["itemnote"]; } $counter = $counter + 1; } } @mysql_free_result($result); for ($a = 0; $a < count($inventar); $a++) { $tb_table->addRow(array($inventar[$a]["name"], $inventar[$a]["notiz"], "[link]")); $tb_table->addHtmlrow(array("<div class=\"rare" . $inventar[$a]["rare"] . "\"><a href=\"http://datenbank.welli-it.de/?item=" . $inventar[$a]["id"] . "\" target=\"_BLANK\">" . $inventar[$a]["name"] . "</a></div>", $inventar[$a]["notiz"], "<a href=\"index.php?page=edititemnote&id=" . $inventar[$a]["id"] . "\">ändern</a>")); $tb_table->addExtraKey(array($inventar[$a]["rare"])); } // TABELLE SORT AND PRINT $tb_table->sortTable(); $tb_table->printTable(); ?> </table> </div> </div>
} else { $inventar[$counter]["punkte"] = $row["points"]; } $counter = $counter + 1; } } @mysql_free_result($result); for ($a = 0; $a < count($inventar); $a++) { $invstring = ""; $invstringbr = ""; $keys = array_keys($inventar[$a]["bank"]); foreach ($keys as $key) { $invstring = $invstring . $invstringbr . $inventar[$a]["bank"][$key]; $invstringbr = "<br>"; } $tb_table->addRow(array($inventar[$a]["count"], $inventar[$a]["name"], $invstring, $inventar[$a]["punkte"])); if ($inventar[$a]["id"] == 999999) { $rest = $inventar[$a]["count"]; $gold = floor($rest / 10000); $rest = $rest - $gold * 10000; $silber = floor($rest / 100); $kupfer = $rest - $silber * 100; $tb_table->addHtmlrow(array("1", "<div class=\"rare" . $inventar[$a]["rare"] . "\">" . $gold . " <img src=\"images/money_gold.gif\" alt=\"Gold\" title=\"Gold\"> " . $silber . " <img src=\"images/money_silver.gif\" alt=\"Silber\" title=\"Silber\"> " . $kupfer . " <img src=\"images/money_copper.gif\" alt=\"Kupfer\" title=\"Kupfer\"></div>", $invstring, $inventar[$a]["punkte"])); } else { if (in_array($inventar[$a]["id"], $itemnotes)) { $notetext = ""; for ($n = 0; $n < count($itemnotes); $n++) { if ($itemnotes[$n] == $inventar[$a]["id"]) { $notetext = $itemnotes_text[$n]; } }