} else {
$data = new GuestData($userName, $password, $database);
}
if (mysqli_connect_error()) {
die("データベースの接続に失敗しました");
}
if (isset($_GET["page"])) {
if (preg_match("/[^0-9]/", $_GET["page"])) {
$page = 0;
} else {
$page = $_GET["page"];
}
} else {
$page = 0;
}
$rows = $data->select_column_p("zone,monster.id,monster.name,nm,nameS,monster.updated", "zone,monster", "zone.id=zone", $page * $LIMIT, $LIMIT, "monster.updated desc,zone,monster.id");
if ($page > 0 && $rows > 0) {
$pagelink = "<a href=\"./updinfo.php?page=" . ($page - 1) . "\"" . mbi_ack("*") . ">" . mbi("*.") . "前のページ</a> | ";
} else {
$pagelink = mbi("*.") . "前のページ | ";
}
if (($page + 1) * 50 < $rows) {
$pagelink .= "<a href=\"./updinfo.php?page=" . ($page + 1) . "\"" . mbi_ack("#") . ">" . mbi("#.") . "次のページ</a>";
} else {
$pagelink .= mbi("#.") . "次のページ";
}
?>
<html>
<head>
<?php
echo pagehead($title);
</h2>
<?php
} else {
?>
<h2>イベントモンスター</h2>
<?php
}
?>
<ul id="linklist">
<?php
$flag = 0;
//検索出力
foreach ($categories as $category) {
$column = array("category", "event");
$value = array($category, $i);
$data->select_column_p("zone,monster.id,monster.name,nm,nameS", "zone,monster", "category={$category} and monster.event={$i} and zone.id=zone", 0, 0, "zone,monster.id");
while ($row = $data->fetch()) {
$flag = 1;
$id = $row["zone"] . str_pad($row["id"], 4, "0", STR_PAD_LEFT);
$name = $row["name"];
$id_f = isset($data->is_admin) ? sprintf("%07d:", $id) : "";
if ($row["nm"]) {
$name = '<span class="nm">' . $name . '</span>';
}
?>
<li><?php
echo $id_f;
?>
<a href="/db/monster/data/?id=<?php
echo $id;
?>
if (mysqli_connect_error()) {
die("データベースの接続に失敗しました");
}
if (isset($_GET["page"])) {
if (preg_match("/[^0-9]/", $_GET["page"])) {
$page = 0;
} else {
$page = $_GET["page"];
}
} else {
$page = 0;
}
if (isset($data->is_admin)) {
$rows = $data->select_all_l("id,name,updated,hidden", "items", $page * $LIMIT, $LIMIT, "updated desc, id");
} else {
$rows = $data->select_column_p("id,name,updated,hidden", "items", "hidden=0", $page * $LIMIT, $LIMIT, "updated desc, id");
}
if ($page > 0 && $rows > 0) {
$pagelink = "<a href=\"./updinfo.php?page=" . ($page - 1) . "\"" . mbi_ack("*") . ">" . mbi("*.") . "前のページ</a> | ";
} else {
$pagelink = mbi("*.") . "前のページ | ";
}
if (($page + 1) * 50 < $rows) {
$pagelink .= "<a href=\"./updinfo.php?page=" . ($page + 1) . "\"" . mbi_ack("#") . ">" . mbi("#.") . "次のページ</a>";
} else {
$pagelink .= mbi("#.") . "次のページ";
}
?>
<html>
<head>
<?php
