Gecko [ tsuru-no-tsurugi.tokyo ]

Name	Size	Permission	Date
rank_load.php	5.14 KB	-rwxr-xr-x	2024-08-28 00:19
rank_load_admin.php	5.14 KB	-rwxr-xr-x	2024-08-28 00:19
rank_load_admin2.php	5.16 KB	-rwxr-xr-x	2024-08-28 00:19
submit_load.php	13.64 KB	-rwxr-xr-x	2024-08-29 23:28
submit_load_admin.php	13.61 KB	-rwxr-xr-x	2024-08-29 23:28
submit_load_admin2.php	13.63 KB	-rwxr-xr-x	2024-08-29 23:28

Rename

<?php

/* session_start();  */

/* SQL TABLE: TABLE NAME = rank
+--------------+--------------+------+-----+--------------------------------------+-------+
| Field        | Type         | Null | Key | Default                              | Extra |
+--------------+--------------+------+-----+--------------------------------------+-------+
| user_name    | varchar(80)  | NO   |     | NULL                                 |       |
| user_id      | varchar(80)  | NO   |     | NULL                                 |       |
| point        | int(11)      | YES  |     | NULL                                 |       |
| time         | int(11)      | YES  |     | NULL                                 |       |
| pena         | int(11)      | YES  |     | NULL                                 |       |
| pena_problem | varchar(100) | YES  |     | 000000000000000000000000000000000000 |       |
| AC_status    | varchar(15)  | YES  |     | 00000000000                          |       |
+--------------+--------------+------+-----+--------------------------------------+-------+
*/

//問題数を指定

function char_int($S){
    return ord($S) - 48;
}

// A=65 0=48
function pena_str_int($S){
    $problem_num = 11;
    $res = [
        'A'=>0,
        'B'=>0,
        'C'=>0,
        'D'=>0,
        'E'=>0,
        'F'=>0,
        'G'=>0,
        'H'=>0,
        'I'=>0,
        'J'=>0,
        'K'=>0
    ];
    $key=65;
    for($i = 0;$i<$problem_num;$i++){
        $sum_pena = char_int($S[$i*3])*100+char_int($S[$i*3+1])*10+char_int($S[$i*3+2]);
        if($sum_pena!=0){
            $res[chr($key)]=char_int($S[$i*3])*100+char_int($S[$i*3+1])*10+char_int($S[$i*3+2]);
        }
        else{
            $res[chr($key)]=NULL;
        }
        $key++;
    }
    return $res;
}

function Manko2(){
	require_once '/var/www/html/kougakubu/htdocs/auth/database.php';
	$pdo = getPdo();

$comment = '<table border="1px" width="100%" style="text-align: center;"><tr><th>順位</th><th>ユーザー名</th><th>点数</th><th>タイム</th><th>ペナルティ</th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th></tr>';

// user_name,point,time,pena,pena_problem,AC_status を取得。 LIMIT: 表示制限
	$sql = "SELECT user_name,point,time,pena,pena_problem,AC_status FROM akisai.rank ORDER BY point DESC, time ASC;";
	$stmt = $pdo -> query($sql);
	$result = $stmt->fetchAll(PDO::FETCH_BOTH);

for($i=0;$i<count($result);$i++){
	    $pena_problem = pena_str_int($result[$i]['pena_problem']);
	    $comment = $comment . "<tr><td>".($i+1)."</td><td>".$result[$i]['user_name']."</td><td>".$result[$i]['point']."</td><td>".$result[$i]['time']."</td><td>".$result[$i]['pena'];
	    $comment = $comment . "</td><td>".$result[$i]['AC_status'][0]." / ".$pena_problem['A']."</td><td>" . $result[$i]['AC_status'][1]." / ".$pena_problem['B']."</td><td>".$result[$i]['AC_status'][2]." / ".$pena_problem['C']."</td><td>" .$result[$i]['AC_status'][3]." / ".$pena_problem['D']."</td><td>" .$result[$i]['AC_status'][4]." / ".$pena_problem['E'] . "</td><td>".$result[$i]['AC_status'][5]." / ".$pena_problem['F']."</td><td>".$result[$i]['AC_status'][6]." / ".$pena_problem['G']. "</td><td>".$result[$i]['AC_status'][7]." / ".$pena_problem['H']."</td><td>".$result[$i]['AC_status'][8]." / ".$pena_problem['I']. "</td><td>".$result[$i]['AC_status'][9]." / ".$pena_problem['J']. "</td>";
	}

return $comment."</table>";
	// ログインユーザーは自分の成績を表示。
}
function Chinko2(){
	require_once '/var/www/html/kougakubu/htdocs/auth/database.php';
	$pdo = getPdo();
	
	$comment2='<table border="1px" width="100%" style="text-align: center;"><tr><th>順位</th><th>ユーザー名</th><th>点数</th><th>タイム</th><th>ペナルティ</th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th></tr>';
	//print_r($_SESSION);
	if($_SESSION['loggedin']=='1'){
	    // idで検索。
	    $sql2 = "SELECT user_name,point,time,pena,pena_problem,AC_status,RANK() OVER(ORDER BY point DESC,time ASC) AS rank_result from akisai.rank where user_name = :user_name";
	    $stmt2 = $pdo -> prepare($sql2);
	    $stmt2->bindValue(':user_name',$_SESSION['name'],PDO::PARAM_STR);
	    $stmt2->execute();

foreach ($stmt2 as $row){
	        $data = $row;
	    }

$pena_problem = pena_str_int($data['pena_problem']);
	    $comment2 = $comment2 . "<tr><td>".($data['rank_result'])."</td><td>".$data['user_name']."</td><td>".$data['point']."</td><td>".$data['time']."</td><td>".$data['pena'];
	    $comment2 = $comment2 . "</td><td>".$data['AC_status'][0]." / ".$pena_problem['A']."</td><td>" . $data['AC_status'][1]." / ".$pena_problem['B']."</td><td>".$data['AC_status'][2]." / ".$pena_problem['C']."</td><td>" .$data['AC_status'][3]." / ".$pena_problem['D']."</td><td>" .$data['AC_status'][4]." / ".$pena_problem['E'] . "</td><td>".$data['AC_status'][5]." / ".$pena_problem['F']."</td><td>".$data['AC_status'][6]." / ".$pena_problem['G']. "</td><td>".$data['AC_status'][7]." / ".$pena_problem['H']."</td><td>".$data['AC_status'][8]." / ".$pena_problem['I']. "</td><td>".$data['AC_status'][9]." / ".$pena_problem['J']. "</td>";
	}
	return $comment2."</table>";
}
?>