チーム別ポイント獲得履歴

2016年6月14日

= '2014-11-30’ order by update_date DESC";
$result = mysql_query($sql, $link) or die(“クエリの送信に失敗しました。
SQL:".$sql);

//総合ポイント
$total_rank_point = 0;
$total_bonus_point = 0;

echo '

' . $_GET['group_japanese_name’] . '
';
echo '

';
echo '

';
echo '

';
echo '

';
echo '

';
echo '

';
echo '

';
echo '

';
echo '

';
while ($row = mysql_fetch_assoc($result)) {
//本日更新フラグを初期化
$today_update_flag=false;

if($row['group_name’] == $group_name_str) {
$total_rank_point = $total_rank_point + $row['rank_point’];
$total_bonus_point = $total_bonus_point + $row['bonus_point’];

//本日更新のプレイヤーの日付セルの背景は赤色にする。
if (strtotime(date('Y-m-d’,strtotime('+9 hour’))) == strtotime(date(substr($row['update_date’],0,10)))){
$today_update_flag=true;
}

//背景色をチームごとに分ける
if($today_update_flag == true) {
$td_str = “

';
} else if($row['rank’] == 1) {
$td_str = “

';
} else if($row['rank’] == 2) {
$td_str = “

';
} else if($row['rank’] >= 3 && $row['rank’] <= 8) { $td_str = "

';
} else if($row['group_name’] == “pokota"){
$td_str = “

';
} else if($row['group_name’] == “kirikirin"){
$td_str = “

';
} else if($row['group_name’] == “berun"){
$td_str = “

';
} else if($row['group_name’] == “rudai"){
$td_str = “

';
} else if($row['group_name’] == “nikorasu"){
$td_str = “

';
} else if($row['group_name’] == “brown"){
$td_str = “

';
} else if($row['group_name’] == “conny"){
$td_str = “

';
} else {
$td_str = “

';
}

$name_str = '';
if($today_update_flag == true) {
$name_str = $name_str . '' . $row['japanese_name’] . '';
} else {
$name_str = $name_str . '' . $row['japanese_name’] . '';
}

$score_str = $row['score’];
$scusho_str = '動物’;
$date_str = date('n/j’, strtotime($row['update_date’]));

echo '

' . ereg_replace(“rank","rank1b",$td_str) . date('m/d H:i’, strtotime($row['update_date’])) . '

' ;
echo ereg_replace(“rank","rank2b",$num_str);
echo ereg_replace(“rank","rank3″,$td_str) . '' . $name_str . '

';
echo ereg_replace(“rank","rank4″, ereg_replace(“valign="," align=’right’ valign=",$td_str)) . $row['rank_point’] . '

';
echo ereg_replace(“rank","rank5″, ereg_replace(“valign="," align=’right’ valign=",$td_str)) . $row['bonus_point’] . '

';
echo '

';
}
}
echo '

';
echo '

';
echo '

';

echo '

更新日時 順位 プレイヤー名 ポイント ボーナス
“;
$num_str = '

' . $row['rank’] . ' “;
$num_str = '

'. $row['rank’] . ' “;
$num_str = '

'. $row['rank’] . ' “;
$num_str = '

'. $row['rank’] . ' “;
$num_str = '

'. $row['rank’] . ' “;
$num_str = '

'. $row['rank’] . ' “;
$num_str = '

'. $row['rank’] . ' “;
$num_str = '

'. $row['rank’] . ' “;
$num_str = '

'. $row['rank’] . ' “;
$num_str = '

'. $row['rank’] . ' “;
$num_str = '

'. $row['rank’] . ' “;
$num_str = '

'. $row['rank’] . '
合計 ' . $total_rank_point . ' ' . $total_bonus_point . '

';

?>

 

SQL:".$sql);
$count = 1;

echo '

メンバー

';
echo '

';
echo '

';
echo '

';
echo '

';
echo '

';
echo '

';
echo '

';

$total_update_count = 0;
while ($row = mysql_fetch_assoc($result)) {
if($row['group_name’] == $group_name_str) {

//更新回数
$update_count = 0;
$update_count_sql = “SELECT * from pokopan_pokogachi_ranking where rank_point > 0 and name='" . $row['name’] . “'";
$update_count_result = mysql_query($update_count_sql, $link) or die(“クエリの送信に失敗しました。
SQL:".$update_count_sql);
$update_count = mysql_num_rows($update_count_result);
$total_update_count = $total_update_count + $update_count;

//背景色をチームごとに分ける
if($count == 1) {
$td_str = “

';
} else if($count == 2) {
$td_str = “

';
} else if($count >= 3 && $count <= 8) { $td_str = "

';
} else if($row['group_name’] == “pokota"){
$td_str = “

';
} else if($row['group_name’] == “kirikirin"){
$td_str = “

';
} else if($row['group_name’] == “berun"){
$td_str = “

';
} else if($row['group_name’] == “rudai"){
$td_str = “

';
} else if($row['group_name’] == “nikorasu"){
$td_str = “

';
} else if($row['group_name’] == “brown"){
$td_str = “

';
} else if($row['group_name’] == “conny"){
$td_str = “

';
} else {
$td_str = “

';
}

$name_str = '';
$name_str = $name_str . '' . $row['japanese_name’] . '';

echo '

';
echo ereg_replace(“rank","rank1″,$num_str);
echo ereg_replace(“rank","rank2″,$td_str) . '' . $name_str . '

';
echo ereg_replace(“rank","rank3″, ereg_replace(“valign="," align=’center’ valign=",$td_str)) . $row['score’] . '

';
echo ereg_replace(“rank","rank4″, ereg_replace(“valign="," align=’center’ valign=",$td_str)) . “" . $update_count . '

';
echo '

';
}
$count = $count + 1;
}
echo '

';
echo '

';

echo '

順位 プレイヤー名 現在スコア 更新回数
“;
$num_str = '

'. $count . ' “;
$num_str = '

'. $count . ' “;
$num_str = '

'. $count . ' “;
$num_str = '

'. $count . ' “;
$num_str = '

'. $count . ' “;
$num_str = '

'. $count . ' “;
$num_str = '

'. $count . ' “;
$num_str = '

'. $count . ' “;
$num_str = '

'. $count . ' “;
$num_str = '

'. $count . ' “;
$num_str = '

'. $count . '
更新回数合計 ' . $total_update_count . '

';
}

?>