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>