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"]];
$m_follow = $monster["follow"] == "" ? "不明" : $data->data_link(nl2br($monster["follow"]));
$m_link = $monster["link"] == "" ? "不明" : $data->data_link(nl2br($monster["link"]));
$m_level = monster_level($monster["maxlevel"], $monster["minlevel"]);
$m_repop = $monster["repop"] == "" ? "不明" : $data->data_link(nl2br($monster["repop"]));
$m_skill = $monster["skill"] == "" ? "不明" : $data->data_link(nl2br($monster["skill"]));
$m_dropitem = $monster["dropitem"] == "" ? "" : monster_drop($data->data_link($monster["dropitem"]));
$m_soul = monster_item($data, $monster["soul"]);
$m_steal = monster_item($data, $monster["steal"]);
$m_note = $monster["note"] == "" ? "特になし" : $data->data_link(nl2br($monster["note"]));
$m_event = $monster["event"];
$m_updated = $monster["updated"];
$m_count = $data->access_count("monster", $_GET['id'], $monster["count"]);
} else {
toppage();
}
$title = "モンスターデータ {$m_name}";
$r_id = $repop["zone"] * 10000 + $repop["id"];
$r_name = $repop["nm"] ? "<span class=\"nm\">" . $repop["name"] . "</span>" : $repop["name"];
$i_use[] = "<a href=\"/db/monster/data/?id={$r_id}\">{$r_name}@{$repop["nameS"]}</a>の出現";
}
}
//クエスト
$data->select_column_a("id,name", "quest", "note LIKE '%##use##i{$id}##%' AND id > 90000");
if ($data->rows()) {
while ($quest = $data->fetch()) {
$q_id = $chest["id"];
$q_name = $chest["name"];
$i_use[] = "<a href=\"/db/quest/data/?id={$q_id}\">{$q_name}</a>";
}
}
}
$i_use = isset($i_use) ? $data->data_link(implode("<br />\n", array_unique($i_use))) : "特になし";
/* 入手 */
$i = 0;
//購入
$data->select_column_a("id,name,note", "quest", "note LIKE '%##get##i{$id}##%' AND id BETWEEN 10000 AND 20000");
if ($data->rows()) {
$i_get[$i]["label"] = "購入";
while ($buy = $data->fetch()) {
$b_id = $buy["id"];
$b_name = $buy["name"];
$b_price = preg_match("/##get##i{$id}##pri([0-9]+)##/", $buy["note"], $match) ? "({$match[1]} B)" : "";
$b_link[] = "<a href=\"/db/quest/data/?id={$b_id}\">{$b_name}</a>{$b_price}";
}
$i_get[$i]["data"] = implode("<br />\n", $b_link);
$i++;
}
if ($data->is_added("skill", $id)) {
$data->select_id("skill", $id);
$skill = $data->fetch();
$s_name = $skill["name"];
$categories = simplexml_load_file($xml);
foreach ($categories->category as $category) {
foreach ($category->group as $group) {
if ($skill["category"] == $group["id"]) {
$category_id = $category["id"];
$category_name = $category["name"];
$group_id = $group["id"];
$group_name = $group["name"];
}
}
}
$s_learning = $data->data_link(nl2br($skill["learning"]));
$s_learning = preg_replace("/##group##/", $group_name, $s_learning);
if (!strlen($s_learning)) {
$s_learning .= "準備中";
}
$s_cost = $skill["cost"];
$s_recast = skill_recast($skill["recast"]);
$s_cast = skill_cast($skill["cast"]);
$s_text = nl2br(str_replace(" ", " ", $skill["text"]));
if (!strlen($s_text)) {
$s_text .= "準備中";
}
$s_note = $data->data_link(nl2br($skill["note"]));
if (!strlen($s_note)) {
$s_note .= "準備中";
}
} else {
die("接続設定の読み込みに失敗しました");
}
$data = new GuestData($userName, $password, $database);
if (mysqli_connect_error()) {
die("データベースの接続に失敗しました");
}
$q_name = "";
if ($data->is_added("quest", $id)) {
$data->select_id("quest", $id);
$quest = $data->fetch();
$q_name = $quest["name"];
$category = quest_category_array();
$category_id = quest_category_id($category, $id);
$category_name = $category[$category_id];
$q_note = $data->data_link(nl2br($quest["note"]));
if (!strlen($q_note)) {
$q_note .= "準備中";
}
$q_updated = $quest["updated"];
$q_count = $data->access_count("quest", $id, $quest["count"]);
} else {
toppage();
}
$title = "クエストデータ {$q_name}";
?>
<html>
<head>
<?php
echo pagehead($title);
?>
}
$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("データベースの接続に失敗しました");
}
if ($data->select_id("updinfo", $id)) {
$updinfo = $data->fetch();
$detail = $data->data_link(nl2br($updinfo["detail"]));
if (!strlen($detail)) {
$detail .= "準備中";
}
$count = $data->access_count("updinfo", $id, $updinfo["count"]);
} else {
toppage();
}
$title = "アプリ更新情報 {$id}";
?>
<html>
<head>
<?php
echo pagehead($title);
?>
</head>
