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();

$pdo = getPdo();

$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);
}

$get_length = intval($_GET['length']);
$get_pages = intval($_GET['pages']);
if ($get_length == 0 || !isset($_GET['length'])) {
    //exit("The param `length` is zero. Please rewrite it > 0. (int, zero divided error.) or The param `length` is not set.");
    $get_length = 5; // set as default
}
if ($get_pages < 0 || !isset($_GET['pages'])) {
    //exit("The param `pages` is not a positive number or not set.");
    $get_pages = 0; // set as default
}

// 注意: this sql is mainly created for small scal SQL db;
$sql_cnt = "SELECT COUNT(*) AS cnt FROM quiz.quiz;"; // count num of all data;
$stmt_cnt = $pdo->prepare($sql_cnt);
$stmt_cnt->execute();
$quiz_num = $stmt_cnt->fetch(PDO::FETCH_ASSOC);

$pages = ceil($quiz_num['cnt'] / $get_length);

if ($pages < $get_pages) {
    exit("The param `pages` is set as the value more than a total size of db. (This db has `{$pages}` pages.)");
}

$sql = "SELECT * FROM quiz.quiz LIMIT :start, :length;";
$stmt = $pdo->prepare($sql);
$stmt->bindValue("start", $get_pages * $get_length, PDO::PARAM_INT);
$stmt->bindValue("length", $get_length, PDO::PARAM_INT);
$stmt->execute();

$res = $stmt->fetchAll(PDO::FETCH_ASSOC);

$table = "<table class='table_design' width='100%'><tr><th width=\"10%\">クイズID</th><th width=\"10%\">正答者ID</th><th width=\"10%\">得点</th><th width=\"30%\">読み札</th><th width=\"20%\">正答</th><th width=\"10%\">公開</th><th width=\"10%\">更新</th></tr>";

foreach ($res as $key => $value) {
    $table .= "<tr><td><a href=\"/admin/quiz_detail.php?id={$value['id']}\">{$value['id']}</a></td><td>{$value['winner_id']}</td><td>{$value['point']}</td><td style='text-align: left'>{$value['quiz_sentence']}</td><td style='text-align: left'>{$value['quiz_answer']}</td><td style='text-align: left'>{$value['public']}</td><td>{$value['updatelog']}</td></tr>";
}

$table .= "</table>";

<!DOCTYPE html>
<html>

<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>
    <br>
    <div class="page_selection">
        <?php
        for ($i = 0; $i < $pages; $i++) {
            printf("<a href='?pages=%d&length=%d' class=''>%dページへ</a>", $i, $get_length, $i + 1);
        }
        ?>
        <div class="length_selection">
            <a href='?pages=0&length=5' class=''>5</a>
            <a href='?pages=0&length=10' class=''>10</a>
            <a href='?pages=0&length=20' class=''>20</a>
            <a href='?pages=0&length=50' class=''>50</a>
        </div>
    </div>
    <?php
    print ($table);
    $cur_page = $get_pages + 1;
    echo "{$cur_page}/{$pages}ページ目を表示";
    ?>
    <br>
    <p>管理者以外には公開されていません。</p>
    <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/quiz_regist.md'); // TODO
        const text = await response.text();
        document.getElementById('content').innerHTML = marked.parse(text);
    }
    //const fetched_text = set_file();
</script>

</html>