Gecko [ tsuru-no-tsurugi.tokyo ]

Name	Size	Permission	Date
.git	[ DIR ]	drwxr-xr-x	2024-08-29 23:28
MARKDOWN	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
admin	[ DIR ]	drwxr-xr-x	2025-05-29 22:05
auth	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
error	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
img	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
README.md	75 B	-rwxr-xr-x	2024-08-27 23:20
battle_description.html	3.46 KB	-rw-r--r--	2024-08-29 23:28
css.css	6.53 KB	-rwxr-xr-x	2024-08-27 23:20
index.php	3.77 KB	-rwxr-xr-x	2024-08-29 23:28
pop_up_css.css	848 B	-rwxr-xr-x	2024-08-27 23:20
quiz_detail.php	5.16 KB	-rw-r--r--	2024-08-29 23:28
quiz_list.php	6.36 KB	-rw-r--r--	2024-08-29 23:28
rank.php	6.07 KB	-rwxr-xr-x	2024-08-29 23:28
rank_detail.php	8.87 KB	-rwxr-xr-x	2024-08-29 23:28

Rename

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

$pdo = getPdo();

$sql = "SELECT * FROM quiz.battle WHERE buttle_id = :buttle_id";
$stmt = $pdo->prepare($sql);
$stmt->bindValue("buttle_id", $_GET['battle_id'], PDO::PARAM_INT);
$stmt->execute();

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

//print_r($res);

$battle_type_list_marked = ["monx" => "`m\mathbf{O}n\mathbf{X}`", "attack_25" => "アタック25", "attack_survival" => "アタックサバイバル"];

if ($res['status'] == 1)
    $status_class = "gaming_gradation";
else
    $status_class = "";

$basic_info_table = "<table class='table_design' width='100%'><tr><th width=\"50%\">バトルの種類</th><th width=\"30%\">状況</th><th width=\"20%\">備考</th></tr>";
$basic_info_table .= "<tr><td style=\"text-align: center;\"><a href=\"/battle_description.html?battle_type={$res['buttle_type']}\">{$battle_type_list_marked[$res['buttle_type']]}</a></td>
                        <td style=\"text-align: center;\" class=\"{$status_class}\">{$battle_status_list[$res['status']]}</td>
                        <td style=\"text-align: center;\">{$res['remarks']}</td><tr></table>";

$team_info = "<table class='table_design' width='100%'><tr><th width='20%'>順位</th><th width='50%'>チーム名</th><th width='30%'>得点</th></tr>";

$team_json = $res['teams'];
$team_arr = json_decode($team_json, true);

$point_json = $res['points'];
$point_arr = json_decode($point_json, true);

if ($res['buttle_type'] == "monx") {
    $team_point = [];
    foreach ($team_arr as $key => $value) {
        $team_point += [$value[key($value)][0] => [$point_arr[$value[key($value)][0]][0], $point_arr[$value[key($value)][0]][1]]];
    }
    uasort($team_point, 'cmp');
    $cur_rank = 0;
    foreach ($team_point as $key => $value) {
        $cur_rank++;
        if ($value[1] >= 3) {
            $team_info .= "<tr><td>{$cur_rank}</td><td><strong>{$key}</strong></td><td class=\"dead_team\">&#x2b55; : <strong>{$value[0]}</strong><br>&#x274c; : <strong>{$value[1]}</strong></td></tr>";
        } else if ($value[0] >= 7) {
            $team_info .= "<tr><td>{$cur_rank}</td><td><strong>{$key}</strong></td><td class=\"up_team\">&#x2b55; : <strong>{$value[0]}</strong><br>&#x274c; : <strong>{$value[1]}</strong></td></tr>";
        } else {
            $team_info .= "<tr><td>{$cur_rank}</td><td><strong>{$key}</strong></td><td>&#x2b55; : <strong>{$value[0]}</strong><br>&#x274c; : <strong>{$value[1]}</strong></td></tr>";
        }
    }
} else if ($res['buttle_type'] == "attack_survival") {
    $team_point = [];
    foreach ($team_arr as $key => $value) {
        $team_point += [$value[key($value)][0] => $point_arr[$value[key($value)][0]]];
    }
    uasort($team_point, 'cmp2');
    $cur_rank = 0;
    foreach ($team_point as $key => $value) {
        $cur_rank++;
        if ($value <= 0) {
            $team_info .= "<tr><td>{$cur_rank}</td><td><strong>{$key}</strong></td><td class=\"dead_team\"><strong>{$value}</strong></td></tr>";
        } else {
            $team_info .= "<tr><td>{$cur_rank}</td><td><strong>{$key}</strong></td><td><strong>{$value}</strong></td></tr>";
        }
    }
} else {
    $team_point = [];
    foreach ($team_arr as $key => $value) {
        $team_point += [$value[key($value)][0] => $point_arr[$value[key($value)][0]]];
    }
    uasort($team_point, 'cmp2');
    $cur_rank = 0;
    foreach ($team_point as $key => $value) {
        $cur_rank++;
        $team_info .= "<tr><td>{$cur_rank}</td><td><strong>{$key}</strong></td><td><strong>{$value}</strong></td></tr>";
    }
}

$team_info .= "</table>";

$answered_json = $res['answered'];
$answered_arr = json_decode($answered_json, true);

//print_r($answered_arr);

$quiz_info = "<table class='table_design' width='100%'><tr><th width=\"50%\">チーム名</th><th width=\"50%\">回答したクイズ</th></tr>";

foreach ($answered_arr as $key => $value) {
    $quiz_info .= "<tr><td>{$key}</td><td>";
    foreach ($value as $index => $quiz_id) {
        $quiz_info .= "<a href=\"/quiz_detail.php?id={$quiz_id}\">{$quiz_id}</a><br>";
    }
    $quiz_info .= "</td></tr>";
}

$quiz_info .= "</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>
    <link rel="stylesheet" href="https://kougakubu.tsuru-no-tsurugi.tokyo/prism.css">
    <script src="https://kougakubu.tsuru-no-tsurugi.tokyo/prism.js"></script>
    <script>
        MathJax = {
            loader: { load: ['input/asciimath', 'output/chtml', 'ui/menu'] },
        };
    </script>
    <script type="text/javascript" id="MathJax-script" async
        src="https://cdn.jsdelivr.net/npm/mathjax@3/es5/startup.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>
    <input type="checkbox" id="reload" name="reload" value="" checked onchange="" />
    <label for="coding">20秒で更新する</label>
    <div id="content" style="margin: inherit;"></div>
    <?php
    echo $basic_info_table;
    echo "<br>";
    echo $team_info;
    echo "<br>";
    echo $quiz_info;
    ?>
    <br>
    <footer>
        <p>© 静岡高校工学部 2024</p>
    </footer>
</body>
<script>
    async function set_file() {
        const response = await fetch('/MARKDOWN/rank_detail.md'); // TODO
        const text = await response.text();
        document.getElementById('content').innerHTML = marked.parse(text);
    }
    const fetched_text = set_file();
    const is_reloadable = true;
    function checkbx_onChange() {
        is_reloadable = false;
    }

setTimeout(() => {
        if (is_reloadable) {
            location.reload();
        }
    }, 20000);
</script>

</html>