{"id":7383,"date":"2014-08-30T14:40:05","date_gmt":"2014-08-30T05:40:05","guid":{"rendered":"http:\/\/pokopan.hajihaji-lemon.com\/?page_id=7383"},"modified":"2016-06-14T12:01:27","modified_gmt":"2016-06-14T03:01:27","slug":"page-7383","status":"publish","type":"page","link":"https:\/\/pokopan.hajihaji-lemon.com\/?page_id=7383","title":{"rendered":"\u30c1\u30fc\u30e0\u5225\u30dd\u30a4\u30f3\u30c8\u7372\u5f97\u5c65\u6b74"},"content":{"rendered":"

= ‘2014-11-30’ order by update_date DESC”;
\n $result = mysql_query($sql, $link) or die(“\u30af\u30a8\u30ea\u306e\u9001\u4fe1\u306b\u5931\u6557\u3057\u307e\u3057\u305f\u3002
SQL:”.$sql);<\/p>\n

\/\/\u7dcf\u5408\u30dd\u30a4\u30f3\u30c8
\n $total_rank_point = 0;
\n $total_bonus_point = 0;<\/p>\n

echo ‘<\/p>\n

‘ . $_GET[‘group_japanese_name’] . ‘<\/font><\/b>
‘;
\n echo ‘<\/p>\n

‘;
\n echo ‘<\/p>\n‘;
\n echo ‘<\/p>\n‘;
\n echo ‘<\/p>\n‘ . ereg_replace(“rank”,”rank1b”,$td_str) . date(‘m\/d H:i’, strtotime($row[‘update_date’])) . ‘<\/font><\/td>\n

‘ ;
\n\t echo ereg_replace(“rank”,”rank2b”,$num_str);
\n\t echo ereg_replace(“rank”,”rank3″,$td_str) . ‘‘ . $name_str . ‘<\/a><\/font><\/td>\n

‘;
\n echo ereg_replace(“rank”,”rank4″, ereg_replace(“valign=”,” align=’right’ valign=”,$td_str)) . $row[‘rank_point’] . ‘<\/font><\/td>\n

‘;
\n echo ereg_replace(“rank”,”rank5″, ereg_replace(“valign=”,” align=’right’ valign=”,$td_str)) . $row[‘bonus_point’] . ‘<\/font><\/td>\n

‘;
\n\t echo ‘<\/tr>\n

‘;
\n\t }
\n\t }
\n\t echo ‘<\/p>\n

\n
\u66f4\u65b0\u65e5\u6642<\/font><\/td>\n

‘;
\n echo ‘<\/p>\n

\u9806\u4f4d<\/font><\/td>\n

‘;
\n echo ‘<\/p>\n

\u30d7\u30ec\u30a4\u30e4\u30fc\u540d<\/font><\/td>\n

‘;
\n echo ‘<\/p>\n

\u30dd\u30a4\u30f3\u30c8<\/font><\/td>\n

‘;
\n echo ‘<\/p>\n

\u30dc\u30fc\u30ca\u30b9<\/font><\/td>\n

‘;
\n echo ‘<\/tr>\n

‘;
\n while ($row = mysql_fetch_assoc($result)) {
\n \/\/\u672c\u65e5\u66f4\u65b0\u30d5\u30e9\u30b0\u3092\u521d\u671f\u5316
\n $today_update_flag=false;<\/p>\n

if($row[‘group_name’] == $group_name_str) {
\n $total_rank_point = $total_rank_point + $row[‘rank_point’];
\n $total_bonus_point = $total_bonus_point + $row[‘bonus_point’];<\/p>\n

\/\/\u672c\u65e5\u66f4\u65b0\u306e\u30d7\u30ec\u30a4\u30e4\u30fc\u306e\u65e5\u4ed8\u30bb\u30eb\u306e\u80cc\u666f\u306f\u8d64\u8272\u306b\u3059\u308b\u3002
\n\t\t if (strtotime(date(‘Y-m-d’,strtotime(‘+9 hour’))) == strtotime(date(substr($row[‘update_date’],0,10)))){
\n $today_update_flag=true;
\n\t\t } <\/p>\n

\t \/\/\u80cc\u666f\u8272\u3092\u30c1\u30fc\u30e0\u3054\u3068\u306b\u5206\u3051\u308b
\n\t if($today_update_flag == true) {
\n\t $td_str = “<\/p>\n

“;
\n\t $num_str = ‘<\/p>\n		‘ . $row[‘rank’] . ‘<\/font><\/td>\n

‘;
\n\t } else if($row[‘rank’] == 1) {
\n\t $td_str = “<\/p>\n

“;
\n\t $num_str = ‘<\/p>\n		‘. $row[‘rank’] . ‘<\/td>\n

‘;
\n } else if($row[‘rank’] == 2) {
\n\t $td_str = “<\/p>\n

“;
\n\t $num_str = ‘<\/p>\n		‘. $row[‘rank’] . ‘<\/td>\n

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

“;
\n\t $num_str = ‘<\/p>\n		‘. $row[‘rank’] . ‘<\/td>\n

‘;
\n } else if($row[‘group_name’] == “pokota”){
\n\t $td_str = “<\/p>\n

“;
\n\t $num_str = ‘<\/p>\n		‘. $row[‘rank’] . ‘<\/td>\n

‘;
\n\t } else if($row[‘group_name’] == “kirikirin”){
\n\t $td_str = “<\/p>\n

“;
\n\t $num_str = ‘<\/p>\n		‘. $row[‘rank’] . ‘<\/td>\n

‘;
\n\t } else if($row[‘group_name’] == “berun”){
\n\t $td_str = “<\/p>\n

“;
\n\t $num_str = ‘<\/p>\n		‘. $row[‘rank’] . ‘<\/td>\n

‘;
\n\t } else if($row[‘group_name’] == “rudai”){
\n\t $td_str = “<\/p>\n

“;
\n\t $num_str = ‘<\/p>\n		‘. $row[‘rank’] . ‘<\/td>\n

‘;
\n\t } else if($row[‘group_name’] == “nikorasu”){
\n\t $td_str = “<\/p>\n

“;
\n\t $num_str = ‘<\/p>\n		‘. $row[‘rank’] . ‘<\/td>\n

‘;
\n\t } else if($row[‘group_name’] == “brown”){
\n\t $td_str = “<\/p>\n

“;
\n\t $num_str = ‘<\/p>\n		‘. $row[‘rank’] . ‘<\/td>\n

‘;
\n\t } else if($row[‘group_name’] == “conny”){
\n\t $td_str = “<\/p>\n

“;
\n\t $num_str = ‘<\/p>\n		‘. $row[‘rank’] . ‘<\/td>\n

‘;
\n\t } else {
\n\t $td_str = “<\/p>\n

“;
\n\t $num_str = ‘<\/p>\n		‘. $row[‘rank’] . ‘<\/td>\n

‘;
\n\t }<\/p>\n

\t $name_str = ‘‘;
\n\t if($today_update_flag == true) {
\n\t\t $name_str = $name_str . ‘‘ . $row[‘japanese_name’] . ‘<\/u><\/font>‘;
\n } else {
\n\t\t $name_str = $name_str . ‘‘ . $row[‘japanese_name’] . ‘<\/u>‘;
\n\t\t\t }<\/p>\n

\t $score_str = $row[‘score’];
\n\t $scusho_str = ‘\u52d5\u7269’;
\n\t $date_str = date(‘n\/j’, strtotime($row[‘update_date’]));<\/p>\n

\t echo ‘<\/p>\n

\u5408\u8a08<\/td>\n

‘;
\n\t echo ‘<\/p>\n

‘ . $total_rank_point . ‘<\/td>\n

‘;
\n\t echo ‘<\/p>\n

‘ . $total_bonus_point . ‘<\/td>\n<\/tr>\n

‘;<\/p>\n

\t echo ‘<\/table>\n

‘;<\/p>\n

?><\/p>\n

 <\/p>\n

SQL:”.$sql);
\n $count = 1;<\/p>\n

echo ‘<\/p>\n

\u30e1\u30f3\u30d0\u30fc<\/font><\/b><\/p>\n

‘;
\n echo ‘<\/p>\n‘;
\n echo ‘<\/p>\n‘;
\n echo ‘<\/p>\n‘;
\n\t\t echo ereg_replace(“rank”,”rank1″,$num_str);
\n\t\t echo ereg_replace(“rank”,”rank2″,$td_str) . ‘‘ . $name_str . ‘<\/a><\/font><\/td>\n

‘;
\n\t\t echo ereg_replace(“rank”,”rank3″, ereg_replace(“valign=”,” align=’center’ valign=”,$td_str)) . $row[‘score’] . ‘<\/td>\n

‘;
\n\t\t echo ereg_replace(“rank”,”rank4″, ereg_replace(“valign=”,” align=’center’ valign=”,$td_str)) . “” . $update_count . ‘<\/font><\/td>\n

‘;
\n\t\t echo ‘<\/tr>\n

‘;
\n }
\n\t $count = $count + 1;
\n\t }
\n\t echo ‘<\/p>\n

\n
\u9806\u4f4d<\/font><\/td>\n

‘;
\n echo ‘<\/p>\n

\u30d7\u30ec\u30a4\u30e4\u30fc\u540d<\/font><\/td>\n

‘;
\n echo ‘<\/p>\n

\u73fe\u5728\u30b9\u30b3\u30a2<\/font><\/td>\n

‘;
\n echo ‘<\/p>\n

\u66f4\u65b0\u56de\u6570<\/font><\/td>\n

‘;
\n echo ‘<\/tr>\n

‘;<\/p>\n

$total_update_count = 0;
\n while ($row = mysql_fetch_assoc($result)) {
\n if($row[‘group_name’] == $group_name_str) {<\/p>\n

\/\/\u66f4\u65b0\u56de\u6570
\n $update_count = 0;
\n $update_count_sql = “SELECT * from pokopan_pokogachi_ranking where rank_point > 0 and name='” . $row[‘name’] . “‘”;
\n $update_count_result = mysql_query($update_count_sql, $link) or die(“\u30af\u30a8\u30ea\u306e\u9001\u4fe1\u306b\u5931\u6557\u3057\u307e\u3057\u305f\u3002
SQL:”.$update_count_sql);
\n $update_count = mysql_num_rows($update_count_result);
\n $total_update_count = $total_update_count + $update_count;<\/p>\n

\t\t \/\/\u80cc\u666f\u8272\u3092\u30c1\u30fc\u30e0\u3054\u3068\u306b\u5206\u3051\u308b
\n\t\t if($count == 1) {
\n\t\t $td_str = “<\/p>\n

“;
\n\t\t $num_str = ‘<\/p>\n		‘. $count . ‘<\/td>\n

‘;
\n\t\t } else if($count == 2) {
\n\t\t $td_str = “<\/p>\n

“;
\n\t\t $num_str = ‘<\/p>\n		‘. $count . ‘<\/td>\n

‘;
\n\t\t } else if($count >= 3 && $count <= 8) {\n\t\t $td_str = \"\n\n

“;
\n\t\t $num_str = ‘<\/p>\n		‘. $count . ‘<\/td>\n

‘;
\n\t\t } else if($row[‘group_name’] == “pokota”){
\n\t\t $td_str = “<\/p>\n

“;
\n\t\t $num_str = ‘<\/p>\n		‘. $count . ‘<\/td>\n

‘;
\n\t\t } else if($row[‘group_name’] == “kirikirin”){
\n\t\t $td_str = “<\/p>\n

“;
\n\t\t $num_str = ‘<\/p>\n		‘. $count . ‘<\/td>\n

‘;
\n\t\t } else if($row[‘group_name’] == “berun”){
\n\t\t $td_str = “<\/p>\n

“;
\n\t\t $num_str = ‘<\/p>\n		‘. $count . ‘<\/td>\n

‘;
\n\t\t } else if($row[‘group_name’] == “rudai”){
\n\t\t $td_str = “<\/p>\n

“;
\n\t\t $num_str = ‘<\/p>\n		‘. $count . ‘<\/td>\n

‘;
\n\t\t } else if($row[‘group_name’] == “nikorasu”){
\n\t\t $td_str = “<\/p>\n

“;
\n\t\t $num_str = ‘<\/p>\n		‘. $count . ‘<\/td>\n

‘;
\n\t\t } else if($row[‘group_name’] == “brown”){
\n\t\t $td_str = “<\/p>\n

“;
\n\t\t $num_str = ‘<\/p>\n		‘. $count . ‘<\/td>\n

‘;
\n\t\t } else if($row[‘group_name’] == “conny”){
\n\t\t $td_str = “<\/p>\n

“;
\n\t\t $num_str = ‘<\/p>\n		‘. $count . ‘<\/td>\n

‘;
\n\t\t } else {
\n\t\t $td_str = “<\/p>\n

“;
\n\t\t $num_str = ‘<\/p>\n		‘. $count . ‘<\/td>\n

‘;
\n\t\t }<\/p>\n

\t\t\t $name_str = ‘‘;
\n\t\t\t $name_str = $name_str . ‘‘ . $row[‘japanese_name’] . ‘<\/u>‘;<\/p>\n

\t\t echo ‘<\/p>\n

\u66f4\u65b0\u56de\u6570\u5408\u8a08<\/td>\n

‘;
\n\t echo ‘<\/p>\n

‘ . $total_update_count . ‘<\/font><\/td>\n<\/tr>\n

‘;<\/p>\n

\t echo ‘<\/table>\n

‘;
\n}<\/p>\n

?><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/pokopan.hajihaji-lemon.com\/index.php?rest_route=\/wp\/v2\/pages\/7383"}],"collection":[{"href":"https:\/\/pokopan.hajihaji-lemon.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pokopan.hajihaji-lemon.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pokopan.hajihaji-lemon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pokopan.hajihaji-lemon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7383"}],"version-history":[{"count":0,"href":"https:\/\/pokopan.hajihaji-lemon.com\/index.php?rest_route=\/wp\/v2\/pages\/7383\/revisions"}],"wp:attachment":[{"href":"https:\/\/pokopan.hajihaji-lemon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}