<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;
?>
