Gecko [ tsuru-no-tsurugi.tokyo ]

Name	Size	Permission	Date
admin.php	4.43 KB	-rwxr-xr-x	2024-08-29 23:28
battle_list.php	5.75 KB	-rwxr-xr-x	2024-08-29 23:28
battle_regist.php	3.75 KB	-rwxr-xr-x	2025-05-29 21:51
edit_battle.php	10.09 KB	-rwxr-xr-x	2024-08-29 23:28
make_battle.php	9.28 KB	-rwxr-xr-x	2024-08-29 23:28
make_battle_pre.php	5.12 KB	-rwxr-xr-x	2024-08-29 23:28
quiz_battle.php	26.85 KB	-rwxr-xr-x	2025-05-29 21:56
quiz_detail.php	5.29 KB	-rw-r--r--	2024-08-29 23:28
quiz_list.php	6.61 KB	-rw-r--r--	2024-08-29 23:28
quiz_manager.php	1.02 KB	-rwxr-xr-x	2024-08-28 00:17
quiz_regist.php	5.39 KB	-rwxr-xr-x	2024-08-29 23:28
quiz_start.php	5.82 KB	-rwxr-xr-x	2024-08-29 23:28
team_edit_form.php	6.45 KB	-rwxr-xr-x	2024-08-29 23:28
team_editer.php	6.5 KB	-rwxr-xr-x	2024-08-29 23:28
team_editer_register.php	2.21 KB	-rwxr-xr-x	2024-08-28 00:17
team_regist_form.php	7.45 KB	-rwxr-xr-x	2024-08-29 23:28
team_register.php	2.66 KB	-rwxr-xr-x	2024-08-28 00:17

Rename

<?php
require_once ("/var/www/html/quiz/auth/database.php");
session_start();

$exit_message = "This page is an admin only page. Please login as an admin acount. <br><a href='/auth/login.php'>login</a>";

if (is_null($_SESSION["loggedin"]) || $_SESSION["loggedin"] != 1) {
    exit($exit_message);
} // ほとんどの場合はこれで落とされる。

$user_name = $_SESSION["name"];

// user valitation
$pdo = getPdo();

$sql = "SELECT name FROM quiz.users WHERE name = :name";

$stmt = $pdo->prepare($sql);
$stmt->bindValue('name', $user_name, PDO::PARAM_STR);
$stmt->execute();

$row = $stmt->fetch(PDO::FETCH_ASSOC);

if (count($row) == 0)
    exit($exit_message);

// POSTed type valitation
/*$battle_type_list = ["monx", "attack_survival", "attack_25"];
if (!in_array($_GET['type'], $battle_type_list)) {
    exit("This battle type is not supported.");
}*/

// Get a current number of battles;
$sql = "SELECT * FROM quiz.battle WHERE buttle_id = :buttle_id";
$stmt = $pdo->prepare($sql);
$stmt->bindValue('buttle_id', $_GET['battle_id']);
$stmt->execute();

$res = $stmt->fetch(PDO::FETCH_ASSOC); // one item

if (is_null($res) || count($res) == 0) {
    exit('This battle ID is not registered.');
}

$participant_team_pre = json_decode($res['teams'], true); // convert JSON obj to arr object;
$participant_team = [];
foreach ($participant_team_pre as $key => $value) {
    $participant_team += $value;
}

$cur_id = $_GET['battle_id'];

// Get a all team;
$sql = "SELECT id,name FROM quiz.team;";
$stmt = $pdo->prepare($sql);
$stmt->execute();

$res_team = $stmt->fetchAll();

$options = "<option value=\"-1\"> --- </option>";
foreach ($res_team as $key => $value) {
    $options .= "<option value=\"{$value['id']}\">{$value['id']} : {$value['name']}</option>";
}

$table = "";
$hidden_input = "";
// mOnX create new
if ($res['buttle_type'] == 'monx') {
    $table .= "<table class='table_design' width='100%'><tr><th width='50%'>カラム</th><th width='50%'>値</th></tr>";
    $table .= "<tr><td>バトル通しID</td><td>{$res['buttle_type']}_{$cur_id}</td></tr>";

for ($i = 1; $i <= 9; $i++) {
        $options = "<option value=\"-1\"> --- </option>";
        foreach ($res_team as $key => $value) {
            if ($participant_team[$i][0] == $value['name']) {
                $options .= "<option value=\"{$value['id']}\" selected >{$value['id']} : {$value['name']}</option>";
            } else {
                $options .= "<option value=\"{$value['id']}\">{$value['id']} : {$value['name']}</option>";
            }
        }
        $table .= "<tr><td>対決者{$i}</td><td><select name=\"encounters_{$i}\">{$options}</select></td></tr>";

if (!array_key_exists($i, $participant_team)) {
            $participant_team += array($i => '---');
        }
    }
    $table .= "<tr><td>備考</td><td><input type=\"text\"name=\"remarks\" value=\"{$res['remarks']}\"></td></tr>";
    $table .= "</table>";
    $hidden_input = "<input name=\"type\" hidden value=\"monx\"><input name=\"buttle_id\" hidden value=\"{$cur_id}\"><input name=\"update_type\" hidden value=\"edit\">";
}

if ($res['buttle_type'] == 'attack_survival') {
    $table .= "<table class='table_design' width='100%'><tr><th width='50%'>カラム</th><th width='50%'>値</th></tr>";
    $table .= "<tr><td>バトル通しID</td><td>{$res['buttle_type']}_{$cur_id}</td></tr>";

if (!array_key_exists($i, $participant_team)) {
            $participant_team += array($i => '---');
        }
    }
    $table .= "<tr><td>備考</td><td><input type=\"text\"name=\"remarks\" value=\"{$res['remarks']}\"></td></tr>";
    $table .= "</table>";
    $hidden_input = "<input name=\"type\" hidden value=\"attack_survival\"><input name=\"buttle_id\" hidden value=\"{$cur_id}\"><input name=\"update_type\" hidden value=\"edit\">";
}

if ($res['buttle_type'] == 'attack_25') {
    $table .= "<table class='table_design' width='100%'><tr><th width='50%'>カラム</th><th width='50%'>値</th></tr>";
    $table .= "<tr><td>バトル通しID</td><td>{$res['buttle_type']}_{$cur_id}</td></tr>";

for ($i = 1; $i <= 4; $i++) {
        $options = "<option value=\"-1\"> --- </option>";
        foreach ($res_team as $key => $value) {
            if ($participant_team[$i][0] == $value['name']) {
                $options .= "<option value=\"{$value['id']}\" selected >{$value['id']} : {$value['name']}</option>";
            } else {
                $options .= "<option value=\"{$value['id']}\">{$value['id']} : {$value['name']}</option>";
            }
        }
        $table .= "<tr><td>対決者{$i}</td><td><select name=\"encounters_{$i}\">{$options}</select></td></tr>";

if (!array_key_exists($i, $participant_team)) {
            $participant_team += array($i => '---');
        }
    }
    $table .= "<tr><td>備考</td><td><input type=\"text\"name=\"remarks\" value=\"{$res['remarks']}\"></td></tr>";
    $table .= "</table>";
    $hidden_input = "<input name=\"type\" hidden value=\"attack_25\"><input name=\"buttle_id\" hidden value=\"{$cur_id}\"><input name=\"update_type\" hidden value=\"edit\">";
}

<!DOCTYPE html>
<html>

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width,initial-scale=1.0">
    <title>静高生クイズ | 工学部 + クイズ研究会</title>
    <link rel="icon" type="image/png" href="https://kougakubu.tsuru-no-tsurugi.tokyo/icon.png">
    <link rel="stylesheet" type="text/css" href="/css.css">
    <script src="https://cdn.jsdelivr.net/npm/marked/marked.min.js"></script>
    <script>
    </script>
</head>

<body style="background-color: #f9f9f9;">
    <header class="header_pc">
        <a href="https://quiz.tsuru-no-tsurugi.tokyo/">
            <img src="https://kougakubu.tsuru-no-tsurugi.tokyo/icon.png" class="gaming" height="35px">
        </a>
        <a>&nbsp;&nbsp;&nbsp;&nbsp;</a>
        <a class="a-none-color" href="https://quiz.tsuru-no-tsurugi.tokyo/">静高生クイズ | 工学部 + クイズ研究会</a>
        <ul class="menu-group">
            <li class="menu-item"><a href="/index.php">ホーム</a></li>
            <li class="menu-item"><a href="/rank.php">順位</a></li>
            <li class="menu-item"><a href="/quiz_list.php">クイズ一覧</a></li>
            |
            <?php
            session_start();
            if ($_SESSION["loggedin"]) {
                echo "<li class='menu-item'><a href='/auth/logout.php'>ログアウト</a></li>";
                echo "<li class='menu-item'><a href='/admin/admin.php'>{$_SESSION['name']}</a></li>";
            } else {
                echo "<li class='menu-item'><a href='/auth/login.php'>ログイン</a></li>";
            }
            ?>
        </ul>
    </header>
    <header class="header">
        <div class="logo">
            <img src="https://kougakubu.tsuru-no-tsurugi.tokyo/icon.png" class="gaming" height="35px" style="float: left;">
            <a class="a-none-color" href="https://quiz.tsuru-no-tsurugi.tokyo/">静高生クイズ</a>
        </div>
        <div class="drawer">
            <input type="checkbox" id="drawer-check" class="drawer-hidden">
            <label for="drawer-check" class="drawer-open"><span></span></label>
            <nav class="drawer-content">
                <ul class="drawer-list" style="font-size: x-large">
                    <li class="drawer-item">
                        <a href="/index.php">ホーム</a>
                    </li>
                    <li class="drawer-item">
                        <a href="/rank.php">順位</a>
                    </li>
                    <li class="drawer-item">
                        <a href="/quiz_list.php">クイズ一覧</a>
                    </li>
                    <hr>
                    <?php
                    session_start();
                    if ($_SESSION["loggedin"]) {
                        echo "<li class='drawer-item'><a href='/auth/logout.php'>ログアウト</a></li>";
                        echo "<li class='drawer-item'><a href='/admin/admin.php'>{$_SESSION['name']}</a></li>";
                    } else {
                        echo "<li class='drawer-item'><a href='/auth/login.php'>ログイン</a></li>";
                    }
                    ?>
                </ul>
            </nav>
        </div>
    </header>
    <hr>
    <br><br>
    <p class="center" style="font-family:serif;font-size: 40px;text-shadow: #e23b44 2px 2px 3px;">静高生クイズ</p>
    <form action="/admin/battle_regist.php" method="POST">
        <?php
        echo $table;
        echo $hidden_input;
        ?>
        <br>
        <input type="submit" style="background: red;color; blue;font-weight: bold;font-size: larger;" value="送信">
        <input type="reset" style="background: blue;color: red;font-weight: bold;font-size: larger;" value="リセット">
    </form>
    <br>
    <hr>
    <form action="/admin/battle_regist.php" method="POST">
        <?php
        echo "<input name=\"buttle_id\" hidden value=\"{$cur_id}\">";
        echo "<input name=\"update_type\" hidden value=\"delete\">";
        ?>
        <input type="submit" style="background: blue;color: red;font-weight: bold;font-size: larger;" value="削除">
    </form>
    <div id="content" style="margin: inherit;"></div>
    <br>
    <footer>
        <p>© 静岡高校工学部 2024</p>
    </footer>
</body>
<script>
    async function set_file() {
        const response = await fetch('/MARKDOWN/admin/make_battle_pre.md'); // TODO
        const text = await response.text();
        document.getElementById('content').innerHTML = marked.parse(text);
    }
    //const fetched_text = set_file();
</script>

</html>