MyTable::addHtmlrow PHP Code Examples

Example #1

0

Show file

File: itemvisibility.php Project: sigmaroot/GuildBankManager

            $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"] . "\">&auml;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"] . "\">&auml;ndern</a>"));
    }
    $tb_table->addExtraKey(array($inventar[$a]["rare"]));
}
// TABELLE SORT AND PRINT
$tb_table->sortTable();
$tb_table->printTable();
?>
</table>
</div>
</div>

Example #2

0

Show file

File: gbphistoryadmin.php Project: sigmaroot/GuildBankManager

$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"] . "\">&auml;ndern</a>"));
}
@mysql_free_result($result);
// TABELLE SORT AND PRINT
$tb_table->sortTable();
$tb_table->printTable();
?>
</table>
</div>
</div>

Example #3

0

Show file

File: itemnotes.php Project: sigmaroot/GuildBankManager

            $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"] . "\">&auml;ndern</a>"));
    $tb_table->addExtraKey(array($inventar[$a]["rare"]));
}
// TABELLE SORT AND PRINT
$tb_table->sortTable();
$tb_table->printTable();
?>
</table>
</div>
</div>

Example #4

0

Show file

File: members.php Project: sigmaroot/GuildBankManager

$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>

Example #5

0

Show file

File: guildbank.php Project: sigmaroot/GuildBankManager

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];
                }
            }
            if ($notetext != "") {
                $tb_table->addHtmlrow(array($inventar[$a]["count"], "<div class=\"rare" . $inventar[$a]["rare"] . "\"><a href=\"http://datenbank.welli-it.de/?item=" . $inventar[$a]["id"] . "\" target=\"_BLANK\">" . $inventar[$a]["name"] . "</a><br>Notiz: " . $notetext . "</div>", $invstring, $inventar[$a]["punkte"]));
            } else {
                $tb_table->addHtmlrow(array($inventar[$a]["count"], "<div class=\"rare" . $inventar[$a]["rare"] . "\"><a href=\"http://datenbank.welli-it.de/?item=" . $inventar[$a]["id"] . "\" target=\"_BLANK\">" . $inventar[$a]["name"] . "</a></div>", $invstring, $inventar[$a]["punkte"]));
            }
        } else {
            $tb_table->addHtmlrow(array($inventar[$a]["count"], "<div class=\"rare" . $inventar[$a]["rare"] . "\"><a href=\"http://datenbank.welli-it.de/?item=" . $inventar[$a]["id"] . "\" target=\"_BLANK\">" . $inventar[$a]["name"] . "</a></div>", $invstring, $inventar[$a]["punkte"]));

Example #6

0

Show file

File: gbphistory.php Project: sigmaroot/GuildBankManager

$tb_header->setTitle(array("Zeit", "Name", "Typ", "Punkte", "Bemerkung"));
$tb_header->setCenter(array(false, false, false, true));
$tb_header->setWidth(array(150, 150, 100, 100, 300));
$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"]));
    $tb_table->addHtmlrow(array(mysqlDate($row["timestamp"]), "<a href=\"?page=gbphistory&name=" . $row["name"] . "\">" . $row["name"] . "</a>", $types[$row["type"]], $row["points"], $row["info"]));
}
@mysql_free_result($result);
// TABELLE SORT AND PRINT
$tb_table->sortTable();
$tb_table->printTable();
?>
</table>
</div>
</div>

PHP MyTable::addHtmlrow Examples