{"id":9213,"date":"2015-10-07T09:33:18","date_gmt":"2015-10-07T00:33:18","guid":{"rendered":"http:\/\/pokopan.hajihaji-lemon.com\/pokopoko\/?page_id=9213"},"modified":"2017-02-08T11:24:44","modified_gmt":"2017-02-08T02:24:44","slug":"page-9213","status":"publish","type":"page","link":"https:\/\/pokopan.hajihaji-lemon.com\/pokopoko\/?page_id=9213","title":{"rendered":"\u30c1\u30fc\u30e0\u5225\u66f4\u65b0\u5c65\u6b74"},"content":{"rendered":"

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

<\/div>\n

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

‘ . $_GET[‘group_japanese_name’] . ‘<\/font><\/div>\n

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

‘;<\/p>\n

\/\/\u30e1\u30f3\u30d0\u30fc\u4e00\u89a7\u3092\u8868\u793a
\n $sql = “SELECT username, japanese_name, sum(point) as point_sum,team,count(*) as touroku_count from pokopoko_ranking where yougan_flag=false and update_date > ‘2015-10-07 19:00:00’ and update_date < '2015-12-27 21:00:00' group by username,team order by sum(point) 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);
\n $count = 1;<\/p>\n

echo ‘<\/p>\n

\u30e1\u30f3\u30d0\u30fc\u4e00\u89a7<\/font>‘;<\/p>\n

if (is_mymobile()) {
\n echo ‘<\/p>\n‘;
\n } else {
\n echo ‘<\/p>\n
‘;
\n }
\n echo ‘<\/p>\n‘;
\n echo ‘<\/p>\n‘;
\n\t\t echo ereg_replace(“rank”,”rank4″, ereg_replace(“valign=”,” align=’right’ valign=”,$td_str)) . “” . $row[‘point_sum’] . ‘<\/font><\/td>\n

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

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

‘;<\/p>\n

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

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

\t echo ‘<\/table>\n

‘;<\/p>\n

\/\/\u5bfe\u8c61\u30c7\u30fc\u30bf\u3092\u53d6\u5f97<\/p>\n

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

echo ‘<\/p>\n

\u30e1\u30f3\u30d0\u30fc\u66f4\u65b0\u5c65\u6b74<\/font>‘;
\n if (is_mymobile()) {
\n echo ‘<\/p>\n

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

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

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

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

\u30d7\u30ec\u30a4\u30e4\u30fc&\u7372\u5f97\u30a2\u30a4\u30c6\u30e0<\/font><\/td>\n

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

‘;<\/p>\n

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

\/\/\u80cc\u666f\u8272\u8a2d\u5b9a
\n if($row[‘team’] == “pokota”) {
\n $group_color = $pokota_color;
\n } else if($row[‘team’] == “kirikirin”) {
\n $group_color = $kirikirin_color;
\n } else if($row[‘team’] == “berun”) {
\n $group_color = $berun_color;
\n } else if($row[‘team’] == “kumagorou”) {
\n $group_color = $kumagorou_color;
\n }<\/p>\n

$td_str = “<\/p>\n

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

‘;<\/p>\n

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

\/\/\u7206\u5f3e\u4e00\u89a7\u3092\u8868\u793a
\n $bakudan_sql = “SELECT * from pokopoko_ranking where username='” . $row[‘username’] . “‘ and (bonus = ‘rainbow_bakudan’ or bonus =’yazirushi_bakudan’) order by update_date asc”;
\n $bakudan_result = mysql_query($bakudan_sql, $link) or die(“\u30af\u30a8\u30ea\u306e\u9001\u4fe1\u306b\u5931\u6557\u3057\u307e\u3057\u305f\u3002
SQL:”.$bakudan_sql);
\n while ($bakudan_row = mysql_fetch_assoc($bakudan_result)) {
\n if($bakudan_row[‘bakudan_flag’] == false and date(“Y-m-d H:i:s”, strtotime($bakudan_row[‘expiration_date’])) != ‘0000-00-00 00:00:00’ and strtotime($bakudan_row[‘expiration_date’]) < strtotime(date(\"Y\/m\/d H:i:s\", strtotime(\"+ 9 hour\")))) {\n $name_str = $name_str . '
\u8150\u308b ‘ . date(‘n\u6708j\u65e5 H:i’, strtotime($bakudan_row[‘expiration_date’]));
\n } else if ($bakudan_row[‘bakudan_flag’] == false) {
\n $name_str = $name_str . ‘
\u4f7f\u7528\u671f\u9650 ‘ . date(‘n\u6708j\u65e5 H:i’, strtotime($bakudan_row[‘expiration_date’]));
\n } else {
\n $name_str = $name_str . ‘
\u4f7f\u7528\u6e08 ‘ . date(‘n\u6708j\u65e5 H:i’, strtotime($bakudan_row[‘bakudan_use_date’]));
\n }<\/p>\n

}<\/p>\n

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

‘;
\n } else {
\n echo ‘<\/p>\n
‘;
\n }
\n echo ‘<\/p>\n‘;
\n echo ‘<\/p>\n
\u767b\u9332\u65e5<\/font><\/td>\n

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

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

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

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

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

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

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

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

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

‘;<\/p>\n

\t echo ‘<\/table>\n

‘;<\/p>\n

echo ‘