} 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