<hr class="normal"> <ul id="footlink"> <?php } else { //グループ表示 ?> <h1>クエストデータ</h1> <hr class="normal"> <h2><?php echo $category[$id]; ?> </h2> <ul id="linklist"> <?php $end = quest_category_end($category, $id); $data->select_column("id,name", $table, "id", "BETWEEN {$id} AND {$end}"); while ($row = $data->fetch()) { $q_id = $row["id"]; $q_name = $row["name"]; $id_f = isset($data->is_admin) ? sprintf("%5d:", $q_id) : ""; ?> <li><?php echo $id_f; ?> <a href="./data/?id=<?php echo $q_id; ?> "><?php echo $q_name; ?> </a></li>
<?php if (isset($name)) { //グループ表示 ?> <h1>スキルデータ</h1> <hr class="normal"> <h2><?php echo $name["category"]; ?> <?php echo $name["group"]; ?> </h2> <ul id="linklist"> <?php $data->select_column("id,name", "skill", "category", $id); while ($row = $data->fetch()) { $id = $row["id"]; $name = $row["name"]; $id_f = isset($data->is_admin) ? sprintf("%04d:", $id) : ""; ?> <li><?php echo $id_f; ?> <a href="./data/?id=<?php echo $id; ?> "><?php echo $name; ?> </a></li>
$user_file = "/etc/mysql-user/user5000.ini"; if ($fp_user = fopen($user_file, "r")) { $userName = rtrim(fgets($fp_user)); $password = rtrim(fgets($fp_user)); $database = rtrim(fgets($fp_user)); } else { die("接続設定の読み込みに失敗しました"); } $data = new GuestData($userName, $password, $database); if (mysqli_connect_error()) { die("データベースの接続に失敗しました"); } $m_name = ""; $column = array("zone", "id"); $value = array($zone, $id); $data->select_column("*", "monster", $column, $value); if ($data->rows()) { $monster = $data->fetch(); $m_name = $monster["name"]; $m_nm = $monster["nm"] ? " class=\"nm\"" : ""; $data->select_id("zone", $zone); $zoneData = $data->fetch(); $zoneName = $zoneData["name"]; $m_categoryId = $monster["category"]; $m_categoryName = $category[$m_categoryId] ?: "不明"; $data->select_column("id", "monster", "category", $m_categoryId); $link_id = $data->rows() < 5 ? 900 : $m_categoryId; $m_image = file_exists("/var/www/img/monster/" . sprintf("%03d", $monster["image"]) . ".gif") ? sprintf("%5d", $monster["image"]) : "00000"; $m_walkspeed = $walkspeed[$monster["walkspeed"]]; $m_delay = monster_delay($monster["delay"]); $m_search = $search[$monster["search"]];
<?php if (item_group($id) != -1) { //グループ表示 ?> <h1>アイテムデータ</h1> <hr class="normal"> <h2><?php echo item_category(item_category_id($id)); ?> <?php echo item_group($id); ?> </h2> <ul id="linklist"> <?php $data->select_column("id,name", "items", array("id", "hidden"), array("BETWEEN " . ($id + 1) . " AND " . item_group_end($id), "0")); while ($row = $data->fetch()) { $i_id = $row["id"]; $i_name = $row["name"]; $id_f = isset($data->is_admin) ? sprintf("%d:", $i_id) : ""; ?> <li><?php echo $id_f; ?> <a href="/db/item/data/?id=<?php echo $i_id; ?> "><?php echo $i_name; ?> </a></li>
die("接続設定の読み込みに失敗しました"); } if (isset($_SESSION["user"]) && isset($_SESSION["pass"])) { $data = new AdminData($_SESSION["user"], $_SESSION["pass"], "ezdata"); if (!$data->is_admin) { session_destroy(); die("データベースの接続に失敗しました"); } } else { $data = new GuestData($userName, $password, $database); } if (mysqli_connect_error()) { die("データベースの接続に失敗しました"); } //種族個体数チェック $data->select_column("id", "monster", "category", $id); if ($data->rows() < 5 && $id != 900) { $id = -1; } if ($id != -1) { $title = "モンスターデータ " . $cname[$id]; $PAGE_ID = 50000 + $id * 10; } else { $title = "モンスターデータ"; $PAGE_ID = 50000; } ?> <html> <head> <?php echo pagehead($title);
<body> <div id="all"> <h1>クラスデータ</h1> <hr class="normal"> <?php if (isset($class)) { if ($id > 200) { $classtype = "元クラス"; $classid = (int) (($id - 1) / 2) + 1; $data->select_id("class", $classid); $c0 = $data->fetch(); $classlist = "<a href=\"./?id=" . $classid . "\">" . $c0["name"] . "</a>"; } else { $classtype = "上級クラス"; $classid = $id * 2; $data->select_column("id,name", "class", "id", "BETWEEN " . ($classid - 1) . " AND {$classid}"); $c1 = $data->fetch(); $c2 = $data->fetch(); $classlist = "<a href=\"./?id=" . $c1["id"] . "\">" . $c1["name"] . "</a><br />\n<a href=\"./?id=" . $c2["id"] . "\">" . $c2["name"] . "</a>"; } } ?> <div class="cnt"> <table border="1" id="class"> <tr><th colspan="4"><?php echo $name; ?> (<?php echo $nameE; ?> )</th></tr>
<?php if ($id == 0) { //一覧表示 ?> <h1>ゾーンデータ</h1> <hr class="normal"> <?php for ($i = 0; $i < 2; $i++) { $flag = true; if ($i == 1) { echo "<h2>イベント</h2>\n"; } ?> <ul id="linklist"> <?php $data->select_column("id,name,enabled", "zone", array("event", "enabled"), array($i, 1)); while ($row = $data->fetch()) { $z_id = $row["id"]; $z_name = $row["name"]; $id_f = isset($data->is_admin) ? sprintf("%03d:", $z_id) : ""; if ($flag && $z_id > 200) { $flag = false; echo "<br />\n"; } ?> <li><?php echo $id_f; ?> <a href="./?id=<?php echo $z_id; ?>