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");
require_once ("/var/www/html/quiz/auth/functions2.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 quiz list
//$battle_id = $_GET['battle_id'];
$sql_quiz_list = "SELECT AUTO_INCREMENT FROM information_schema.tables WHERE TABLE_SCHEMA = 'quiz' AND TABLE_NAME = 'quiz';";
$stmt_quiz_list = $pdo->prepare($sql_quiz_list);
//$stmt_quiz_list->bindValue('quiz', $battle_id, PDO::PARAM_INT);
$stmt_quiz_list->execute();

$quiz_id_occ = intval($stmt_quiz_list->fetch(PDO::FETCH_ASSOC)['AUTO_INCREMENT']) - 1;

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

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

$team_compete_json = json_decode($res['teams'], true);
$team_poits_json = json_decode($res['points'], true);

$team_compete = [];
$team_compete_id = [];
foreach ($team_compete_json as $key => $value) {
    $team_compete_name_key = array_key_first($value);
    $team_compete += array($team_compete_name_key => $value[$team_compete_name_key][0]);    // ID to name
    $team_compete_id += array($value[$team_compete_name_key][0] => $team_compete_name_key); // name to ID
}

$team_poits = [];
foreach ($team_poits_json as $key => $value) {
    $team_poits += array($key => $value);
}

if (isset($_POST['save'])) {
    // get current situation
    $sql_get = "SELECT points, answered FROM quiz.battle WHERE buttle_id = :buttle_id";
    $stmt_get = $pdo->prepare($sql_get);
    $stmt_get->bindValue('buttle_id', $_GET['battle_id'], PDO::PARAM_INT);
    $stmt_get->execute();
    $res_get = $stmt_get->fetch(); // fetch once;

$current_points_json = $res_get['points']; // is raw data
    // convert from raw json data to PHP array
    $current_points = json_decode($current_points_json, true);

$current_answered_json = $res_get['answered'];
    $current_answered = json_decode($current_answered_json, true);

/*print_r($current_points);
    exit();*/

// regist
    $sql = "UPDATE quiz.battle SET points = :points, answered = :answered WHERE buttle_id = :buttle_id";
    $posted_battle_type = $_POST['battle_type'];
    $posted_team_id = $_POST['team_id'];

$if_added_answered = false; // manage bool value

// regist `answred`
    //array_push($current_answered[$team_compete[$posted_team_id]], $_POST["ans_{$posted_team_id}"]);
    if ($posted_battle_type == "monx") {
        $posted_o_num = intval($_POST["o_{$posted_team_id}"]);
        $posted_x_num = intval($_POST["x_{$posted_team_id}"]);
        $points = $current_points;
        $points[$team_compete[$posted_team_id]] = [$posted_o_num, $posted_x_num];

// push answered quiz information if o point raises up.
        if ($current_points[$team_compete[$posted_team_id]][0] < $posted_o_num) {
            array_push($current_answered[$team_compete[$posted_team_id]], $_POST["ans_{$posted_team_id}"]);
            $if_added_answered = true;
        }

//$points = array($team_compete[$posted_team_id] => [$posted_o_num, $posted_x_num]);
        $points_json_encode = json_encode($points);
        $answered_json_encode = json_encode($current_answered);

$stmt_update = $pdo->prepare($sql);
        $stmt_update->bindValue('points', $points_json_encode, PDO::PARAM_STR);
        $stmt_update->bindValue('answered', $answered_json_encode, PDO::PARAM_STR);
        $stmt_update->bindValue('buttle_id', $_GET['battle_id'], PDO::PARAM_INT);
        $stmt_update->execute();
        $stmt_update->closeCursor();
    } else if ($posted_battle_type == "attack_25") {
        $posted_o_num = intval($_POST["o_{$posted_team_id}"]);
        $points = $current_points;
        $points[$team_compete[$posted_team_id]] = $posted_o_num;

// push answered quiz information if o point raises up.
        if ($current_points[$team_compete[$posted_team_id]] < $posted_o_num) {
            array_push($current_answered[$team_compete[$posted_team_id]], $_POST["ans_{$posted_team_id}"]);
            $if_added_answered = true;
        }

$points_json_encode = json_encode($points);
        $answered_json_encode = json_encode($current_answered);

if ($_POST['change_type'] == "AC") { // decrease others points
            foreach ($points as $key => $value) { // key <- name, value <- points values
                if ($posted_team_id != $team_compete_id[$key]) {
                    $points[$key] -= $attack_survival_decrease_scale;
                }
            }
            // push answered quiz information if point raises up.
            array_push($current_answered[$team_compete[$posted_team_id]], $_POST["ans_{$posted_team_id}"]);
            $if_added_answered = true;
        } else if ($_POST['change_type'] == "WA") { // decrease posted team's points
            $points[$team_compete[$posted_team_id]] -= $attack_survival_decrease_scale;
        }

$points_json_encode = json_encode($points);
        $answered_json_encode = json_encode($current_answered);

if ($if_added_answered==true) {
        $sql_ans = "UPDATE quiz.quiz SET public = 'Yes', winner_id = :winner_id WHERE id = :id";
        $answered_quiz_id = intval($_POST["ans_{$posted_team_id}"]);

$stmt_ans = $pdo->prepare($sql_ans);
        $stmt_ans->bindValue("id", $answered_quiz_id, PDO::PARAM_INT);
        $stmt_ans->bindValue("winner_id", $team_compete[$posted_team_id], PDO::PARAM_STR);
        $stmt_ans->execute();
        $stmt_ans->closeCursor();
    }

header("Refresh:0");
}

if ($res['buttle_type'] == 'monx') { // 3*3 table
    $table = "<table class='table_design' width='100%' style=\"table-layout: fixed;\">";
    $script = "<script>";
    $pop_ups = "";
    for ($i = 0; $i < 3; $i++) {
        $table .= "<tr>";
        for ($j = 0; $j < 3; $j++) {
            if (is_null($team_compete[$i * 3 + $j + 1])) {
                $table .= "<td class=\"empty_table\">
                        <p>チーム名: </p>
                        <p>得点: O: / X: </p>";
                $table .= "</td>";
            } else {
                if ($team_poits[$team_compete[$i * 3 + $j + 1]][1] >= 3) {
                    $table .= "<td class=\"dead_td\">
                    <p>チーム名: {$team_compete[$i * 3 + $j + 1]}</p>
                    <p>得点: O:{$team_poits[$team_compete[$i * 3 + $j + 1]][0]} / X:{$team_poits[$team_compete[$i * 3 + $j + 1]][1]}</p>";
                } else if ($team_poits[$team_compete[$i * 3 + $j + 1]][0] >= 7) {
                    $table .= "<td class=\"up_td\">
                    <p>チーム名: {$team_compete[$i * 3 + $j + 1]}</p>
                    <p>得点: O:{$team_poits[$team_compete[$i * 3 + $j + 1]][0]} / X:{$team_poits[$team_compete[$i * 3 + $j + 1]][1]}</p>";
                } else {
                    $table .= "<td>
                    <p>チーム名: {$team_compete[$i * 3 + $j + 1]}</p>
                    <p>得点: O:{$team_poits[$team_compete[$i * 3 + $j + 1]][0]} / X:{$team_poits[$team_compete[$i * 3 + $j + 1]][1]}</p>";
                }
                $current_team_id = $team_compete_id[$team_compete[$i * 3 + $j + 1]];
                $table .= "<button id=\"click_edit_{$current_team_id}\" style=\"display: block;margin: 0px auto;background-color: black;color: white;border: 0;padding: 6px 10px;\">編集</button>
                        </td>";
                $script .=
                    "
                const clickBtn_{$current_team_id} = document.getElementById('click_edit_{$current_team_id}');
                const popupWrapper_{$current_team_id} = document.getElementById('popup_wrapper_{$current_team_id}');
                const close_{$current_team_id} = document.getElementById('close_{$current_team_id}');
                
                clickBtn_{$current_team_id}.addEventListener('click', () => {
                    popupWrapper_{$current_team_id}.style.display = \"block\";
                });

popupWrapper_{$current_team_id}.addEventListener('click', e => {
                if (e.target.id === popupWrapper_{$current_team_id}.id || e.target.id === close_{$current_team_id}.id) {
                    popupWrapper_{$current_team_id}.style.display = 'none';
                  }
                });

const check_value_o_{$current_team_id} = document.getElementById('check_value_o_{$current_team_id}');
                const check_value_x_{$current_team_id} = document.getElementById('check_value_x_{$current_team_id}');
                const check_value_quiz_{$current_team_id} = document.getElementById('check_value_quiz_{$current_team_id}');
                
                function inputChange_{$current_team_id}(){
                    check_value_o_{$current_team_id}.value = document.getElementById('o_{$current_team_id}').value;
                    check_value_x_{$current_team_id}.value = document.getElementById('x_{$current_team_id}').value;
                    check_value_quiz_{$current_team_id}.value = document.getElementById('ans_{$current_team_id}').value;
                }
                ";

$pop_ups .=
                    "<div id=\"popup_wrapper_{$current_team_id}\" class=\"popup-wrapper\">
                        <div id=\"popup-inside\" class=\"popup-inside\">
                            <div id=\"close_{$current_team_id}\" class=\"close\">x</div>
                                <div id=\"message\">
                                    <h3>{$team_compete[$i * 3 + $j + 1]}</h3>
                                    <form action=\"\" method=\"POST\">
                                    <table width='100%' class=\"table_design\">
                                    <tr><th width='20%'>O</th><td width='40%'><input type=\"number\" min=\"0\" max=\"100\" name=\"o_{$current_team_id}\" id=\"o_{$current_team_id}\" value=\"{$team_poits[$team_compete[$i * 3 + $j + 1]][0]}\" class=\"num_input\" onchange=\"inputChange_{$current_team_id}()\" \></a></td><td><input id=\"check_value_o_{$current_team_id}\" class=\"num_input_check\" value=\"{$team_poits[$team_compete[$i * 3 + $j + 1]][0]}\" readonly></td></tr>
                                    <tr><th>X</th><td><input type=\"number\" min=\"0\" max=\"100\" name=\"x_{$current_team_id}\" id=\"x_{$current_team_id}\" value=\"{$team_poits[$team_compete[$i * 3 + $j + 1]][1]}\" class=\"num_input\" onchange=\"inputChange_{$current_team_id}()\" \></a></td><td><input id=\"check_value_x_{$current_team_id}\" class=\"num_input_check\" value=\"{$team_poits[$team_compete[$i * 3 + $j + 1]][1]}\" readonly></td></tr>
                                    <tr><th>回答したクイズ</th><td><input type=\"number\" min=\"0\" max=\"{$quiz_id_occ}\" name=\"ans_{$current_team_id}\" id=\"ans_{$current_team_id}\" value=\"{$quiz_id_occ}\" class=\"num_input\" onchange=\"inputChange_{$current_team_id}()\" \></a><br><a>正答の場合のみ登録されます。</a></td><td><input id=\"check_value_quiz_{$current_team_id}\" class=\"num_input_check\" value=\"{$quiz_id_occ}\" readonly></td></tr>
                                    </table>
                                    <br>                                    
                                    <input type=\"number\" hidden name=\"team_id\" value=\"$current_team_id\">
                                    <input type=\"text\" hidden name=\"battle_type\" value=\"monx\">
                                    <input type=\"submit\" style=\"background: red;color; blue;font-weight: bold;font-size: larger;\" name=\"save\" value=\"送信\">
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>";
            }
        }
        $table .= "<tr>";
    }
    $table .= "</table>";
    $script .= "</script>";
} else if ($res['buttle_type'] == 'attack_25') { // 2*2 table
    $table = "<table class='table_design' width='100%' style=\"table-layout: fixed;\">";
    $script = "<script>";
    $pop_ups = "";
    for ($i = 0; $i < 2; $i++) {
        $table .= "<tr>";
        for ($j = 0; $j < 2; $j++) {
            if (is_null($team_compete[$i * 2 + $j + 1])) {
                $table .= "<td class=\"empty_table\">
                        <p>チーム名: </p>
                        <p>得点: 獲得タイル数:</p>";
                $table .= "</td>";
            } else {
                $table .= "<td>
                <p>チーム名: {$team_compete[$i * 2 + $j + 1]}</p>
                <p>得点: 獲得タイル数:{$team_poits[$team_compete[$i * 2 + $j + 1]]}</p>";
                $current_team_id = $team_compete_id[$team_compete[$i * 2 + $j + 1]];
                $table .= "<button id=\"click_edit_{$current_team_id}\" style=\"display: block;margin: 0px auto;background-color: black;color: white;border: 0;padding: 6px 10px;\">編集</button>
                        </td>";
                $script .=
                    "
                const clickBtn_{$current_team_id} = document.getElementById('click_edit_{$current_team_id}');
                const popupWrapper_{$current_team_id} = document.getElementById('popup_wrapper_{$current_team_id}');
                const close_{$current_team_id} = document.getElementById('close_{$current_team_id}');
                
                clickBtn_{$current_team_id}.addEventListener('click', () => {
                    popupWrapper_{$current_team_id}.style.display = \"block\";
                });

const check_value_o_{$current_team_id} = document.getElementById('check_value_o_{$current_team_id}');
                const check_value_quiz_{$current_team_id} = document.getElementById('check_value_quiz_{$current_team_id}');
                
                function inputChange_{$current_team_id}(){
                    check_value_o_{$current_team_id}.value = document.getElementById('o_{$current_team_id}').value;
                    check_value_quiz_{$current_team_id}.value = document.getElementById('ans_{$current_team_id}').value;
                }
                ";

$pop_ups .=
                    "<div id=\"popup_wrapper_{$current_team_id}\" class=\"popup-wrapper\">
                        <div id=\"popup-inside\" class=\"popup-inside\">
                            <div id=\"close_{$current_team_id}\" class=\"close\">x</div>
                                <div id=\"message\">
                                    <h3>{$team_compete[$i * 2 + $j + 1]}</h3>
                                    <form action=\"\" method=\"POST\">
                                    <table width='100%' class=\"table_design\">
                                    <tr><th width='20%'>獲得タイル数:</th><td width='40%'><input type=\"number\" min=\"0\" max=\"100\" name=\"o_{$current_team_id}\" id=\"o_{$current_team_id}\" value=\"{$team_poits[$team_compete[$i * 2 + $j + 1]]}\" class=\"num_input\" onchange=\"inputChange_{$current_team_id}()\" \></a></td><td><input id=\"check_value_o_{$current_team_id}\" class=\"num_input_check\" value=\"{$team_poits[$team_compete[$i * 2 + $j + 1]]}\" readonly></td></tr>
                                    <tr><th>回答したクイズ</th><td><input type=\"number\" min=\"0\" max=\"{$quiz_id_occ}\" name=\"ans_{$current_team_id}\" id=\"ans_{$current_team_id}\" value=\"{$quiz_id_occ}\" class=\"num_input\" onchange=\"inputChange_{$current_team_id}()\" \></a><br><a>正答の場合のみ登録されます。</a></td><td><input id=\"check_value_quiz_{$current_team_id}\" class=\"num_input_check\" value=\"{$quiz_id_occ}\" readonly></td></tr>
                                    </table>
                                    <br>
                                    <input type=\"number\" hidden name=\"team_id\" value=\"$current_team_id\">
                                    <input type=\"text\" hidden name=\"battle_type\" value=\"attack_25\">
                                    <input type=\"submit\" style=\"background: red;color; blue;font-weight: bold;font-size: larger;\" name=\"save\" value=\"送信\" onchange=\"inputChange_{$current_team_id}()\" \>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>";
            }
        }
        $table .= "<tr>";
    }
    $table .= "</table>";
    $script .= "</script>";
} else if ($res['buttle_type'] == 'attack_survival') { // 3*3 table
    $table = "<table class='table_design' width='100%' style=\"table-layout: fixed;\">";
    $script = "<script>";
    $pop_ups = "";
    for ($i = 0; $i < 3; $i++) {
        $table .= "<tr>";
        for ($j = 0; $j < 3; $j++) {
            if (is_null($team_compete[$i * 3 + $j + 1])) {
                $table .= "<td class=\"empty_table\">
                        <p>チーム名: </p>
                        <p>得点: O: </p>";
                $table .= "</td>";
            } else {
                if ($team_poits[$team_compete[$i * 3 + $j + 1]] <= 0) {
                    $table .= "<td class=\"dead_td\">
                        <p>チーム名: {$team_compete[$i * 3 + $j + 1]}</p>
                        <p>得点: O:{$team_poits[$team_compete[$i * 3 + $j + 1]]}</p>";
                } else {
                    $table .= "<td>
                    <p>チーム名: {$team_compete[$i * 3 + $j + 1]}</p>
                    <p>得点: O:{$team_poits[$team_compete[$i * 3 + $j + 1]]}</p>";
                }
                $current_team_id = $team_compete_id[$team_compete[$i * 3 + $j + 1]];
                $table .= "<button id=\"click_edit_{$current_team_id}\" style=\"display: block;margin: 0px auto;background-color: black;color: white;border: 0;padding: 6px 10px;\">編集</button>
                        </td>";
                $script .=
                    "
                const clickBtn_{$current_team_id} = document.getElementById('click_edit_{$current_team_id}');
                const popupWrapper_{$current_team_id} = document.getElementById('popup_wrapper_{$current_team_id}');
                const close_{$current_team_id} = document.getElementById('close_{$current_team_id}');
                
                clickBtn_{$current_team_id}.addEventListener('click', () => {
                    popupWrapper_{$current_team_id}.style.display = \"block\";
                });

const check_value_quiz_{$current_team_id} = document.getElementById('check_value_quiz_{$current_team_id}');
                
                function inputChange_{$current_team_id}(){
                    check_value_quiz_{$current_team_id}.value = document.getElementById('ans_{$current_team_id}').value;
                }
                ";

<!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">
    <link rel="stylesheet" type="text/css" href="/pop_up_css.css">
    <script src="https://cdn.jsdelivr.net/npm/marked/marked.min.js"></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>
    <a style="font-weight: bold;">Battle ID: <?php echo $res['buttle_type'] ?>_<?php echo $res['buttle_id'] ?></a><br>
    <a style="font-weight: bold;">Battle Status: <?php echo $battle_status_list[$res['status']] ?></a>
    <?php
    echo $table;
    echo $pop_ups;
    echo $script;
    ?>
    <br>
    <a>バトル開始・終了は</a><a href="/admin/quiz_start.php?battle_id=<?php echo $battle_id ?>">ここから</a><br>
    <a>バトルの詳細ページ(一般公開用)は</a><a href="/rank_detail.php?battle_id=<?php echo $battle_id ?>">ここから</a>
    <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>