Esempio n. 1
0
if (isset($_GET['id']) && is_numeric($_GET['id'])) {
    $zone = floor($_GET['id'] / 10000);
    $id = $_GET['id'] % 10000;
} else {
    $zone = 0;
    $id = 0;
}
$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"];
Esempio n. 2
0
$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("接続設定の読み込みに失敗しました");
}
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("データベースの接続に失敗しました");
}
$i_name = "";
if ($data->is_added("items", $id)) {
    $data->select_id("items", $id);
    $item = $data->fetch();
    $i_name = $item["name"];
    $category = item_category_id($id);
    $categoryName = item_category($category);
    $group = item_group_id($id);
    $groupName = item_group($group);
    $i_text = nl2br(str_replace("  ", " ", $item["text"]));
    $i_rare = item_attribute($item["rare"]);
Esempio n. 3
0
    $userName = rtrim(fgets($fp_user));
    $password = rtrim(fgets($fp_user));
    $database = rtrim(fgets($fp_user));
} else {
    die("接続設定の読み込みに失敗しました");
}
if (isset($_GET["page"])) {
    if (preg_match("/[^0-9]/", $_GET["page"])) {
        $page = 0;
    } else {
        $page = $_GET["page"];
    }
} else {
    $page = 0;
}
$data = new GuestData($userName, $password, $database);
if (mysqli_connect_error()) {
    die("データベースの接続に失敗しました");
}
$rows = $data->select_all_l("*", "info", $page * $PAGESIZE, $PAGESIZE, "id desc");
if ($page > 0 && $rows > 0) {
    $pagelink = "<a href=\"./?page=" . ($page - 1) . "\"" . mbi_ack("*") . ">" . mbi("*.") . "前のページ</a> | ";
} else {
    $pagelink = mbi("*.") . "前のページ | ";
}
if (($page + 1) * $PAGESIZE < $rows) {
    $pagelink .= "<a href=\"./?page=" . ($page + 1) . "\"" . mbi_ack("#") . ">" . mbi("#.") . "次のページ</a>";
} else {
    $pagelink .= mbi("#.") . "次のページ";
}
?>
Esempio n. 4
0
require_once "/var/www/functions/quest.php";
$xml = "/var/www/functions/xml/quest_group.xml";
if (isset($_GET['id']) && is_numeric($_GET['id'])) {
    $id = $_GET['id'];
} else {
    $id = 0;
}
$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("データベースの接続に失敗しました");
}
$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 .= "準備中";
    }
Esempio n. 5
0
$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("接続設定の読み込みに失敗しました");
}
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("データベースの接続に失敗しました");
}
$sql = "SELECT * FROM `equip_class` ORDER BY `id`";
$data->query($sql);
while ($array = $data->fetch()) {
    $eqType["{$array["id"]}"] = $array["name"];
}
if (empty($eqType)) {
    die("データ読み込みに失敗しました\n");
}
$maxLv = 60;
$sql = "SELECT * FROM `parameter` ORDER BY `id`";
$data->query($sql);
Esempio n. 6
0
$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("接続設定の読み込みに失敗しました");
}
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("データベースの接続に失敗しました");
}
?>
<html>
<head>
<?php 
echo pagehead($title);
?>
</head>
<body>
<div id="all">
<?php 
if ($id == 0) {
Esempio n. 7
0
$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("接続設定の読み込みに失敗しました");
}
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("データベースの接続に失敗しました");
}
if (isset($_GET["mode"])) {
    if ($_GET["mode"] == "OR") {
        $mode = "OR";
    } else {
        $mode = "AND";
    }
} else {
    $mode = "AND";
}
if (isset($_GET["page"]) && !is_array($_GET["page"])) {
    if (preg_match("/[^0-9]/", $_GET["page"])) {
Esempio n. 8
0
$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("接続設定の読み込みに失敗しました");
}
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;
Esempio n. 9
0
require_once "/var/www/class/guestdata.php";
require_once "/var/www/functions/template.php";
if ($id = isset($_GET['id']) && preg_match("/^[0-9]{4}-[0-9]{2}-[0-9]{2}\$/", $_GET["id"])) {
    $id = $_GET['id'];
} else {
    toppage();
}
$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}";
?>
Esempio n. 10
0
require_once "/var/www/bbs/class/board.php";
require_once "/var/www/functions/template.php";
require_once "/var/www/functions/item.php";
$PAGE_ID = 10000;
$PAGESIZE = 10;
$title = "EZ5000テストサイト";
//$user_file = "../../../../etc/mysql-user/user5000.ini";
$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("データベースの接続に失敗しました");
}
$sql = "SELECT * FROM `board`";
$result = $data->query($sql);
$count = $data->top_count();
$rows = $data->select_all_l("*", "info", 0, $PAGESIZE, "id desc");
?>
<html>
<head>
<?php 
echo pagehead($title);
?>
<meta name="robots" content="index" />
<meta name="Keywords" content="オンラインRPG,MMORPG,エターナルゾーン,攻略情報,データベース,蛭注意,EZ5000,5分戦闘,五千" />
Esempio n. 11
0
$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("接続設定の読み込みに失敗しました");
}
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("データベースの接続に失敗しました");
}
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) {
Esempio n. 12
0
$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("接続設定の読み込みに失敗しました");
}
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("データベースの接続に失敗しました");
}
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");
Esempio n. 13
0
$MAX_Lv = 60;
if ($id = isset($_GET['id'])) {
    $id = $_GET['id'];
    if (!preg_match("/^[0-9]+\$/", $id)) {
        $id = 0;
    }
}
$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("データベースの接続に失敗しました");
}
$title = "クラスデータ ";
if ($data->is_added("class", $id)) {
    $data->select_id("class", $id);
    $class = $data->fetch();
    $name = $class["name"];
    $nameE = $class["nameE"];
    $nameS = $class["nameS"];
    $dagger = $class["dagger"];
    $sword = $class["sword"];
    $axe = $class["axe"];
    $hammer = $class["hammer"];
    $wand = $class["wand"];
Esempio n. 14
0
 function AdminData($userName, $password, $database)
 {
     parent::GuestData($userName, $password, $database);
     $this->is_admin = $userName == "admin" || $userName == "subb" || $userName == "subn";
 }
Esempio n. 15
0
//=====================================
require_once "../../class/mysql.php";
require_once "../../class/guestdata.php";
require_once "../../functions/template.php";
require_once "../../functions/class.php";
$PAGE_ID = 60000;
$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("データベースの接続に失敗しました");
}
?>
<html>
<head>
<?php 
echo pagehead($title);
?>
</head>
<body>
<div id="all">
<h1>クラスデータ</h1>
<hr class="normal">
<ul id="linklist">
Esempio n. 16
0
require_once "/var/www/functions/skill.php";
$xml = "/var/www/functions/xml/skill_group.xml";
if (isset($_GET['id']) && is_numeric($_GET['id'])) {
    $id = $_GET['id'];
} else {
    $id = 0;
}
$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("データベースの接続に失敗しました");
}
$s_name = "";
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"];
Esempio n. 17
0
require_once "/var/www/class/mysql.php";
require_once "/var/www/class/guestdata.php";
require_once "/var/www/functions/template.php";
require_once "/var/www/functions/item.php";
$PAGE_ID = 10100;
$title = "このサイトについて";
//$user_file = "../../../../etc/mysql-user/user5000.ini";
$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("データベースの接続に失敗しました");
}
?>
<html>
<head>
<?php 
echo pagehead($title);
?>
</head>
<body>
<div id="all">
<h1>このサイトについて</h1>
<hr class="normal">
<p>
Esempio n. 18
0
$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("接続設定の読み込みに失敗しました");
}
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("データベースの接続に失敗しました");
}
?>
<html>
<head>
<?php 
echo pagehead($title);
?>
</head>
<body>
<div id="all">
<?php 
if (item_group($id) != -1) {
Esempio n. 19
0
$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("接続設定の読み込みに失敗しました");
}
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("データベースの接続に失敗しました");
}
?>
<html>
<head>
<?php 
echo pagehead($title);
?>
</head>
<body>
<div id="all">
<?php 
if (isset($name)) {
Esempio n. 20
0
$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("接続設定の読み込みに失敗しました");
}
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("データベースの接続に失敗しました");
}
if ($id == 0) {
    $title = "ゾーンデータ";
    $PAGE_ID = 30000;
} else {
    if (!$data->select_id("zone", $id)) {
        toppage();
    }
    $row = $data->fetch();
    $name = $row["name"];
    $nameE = $row["nameE"];
    $event = $row["event"];