include("../inc.php"); session_start(); //MySQLに接続 if(!$conn = mysql_connect(_DB_SERVER,_DB_UID,_DB_PASS)){ die('MySQL接続失敗'); } //データベースの選択 if(!$sts = mysql_select_db(_DB_NAME,$conn)){ die('テーブル選択失敗'); } $rank = ""; $rank = $_GET['date']; if($rank==""){ $num=0; $Bdate = "R".date("Ym", mktime(0, 0, 0, date("m")+1, 0, date("Y"))); $BOdate = "R".date("Ym", mktime(0, 0, 0, date("m"), 0, date("Y"))); $sqllist=""; $sqllist.="select * from ranking where ( $Bdate - $BOdate ) > 0 and id != 'yoshia2528' and id != 'momoharu' and id != 'cute-airi' and id !='mahopuyo' and $BOdate > '0'"; $sqllist.="order by ( $Bdate - $BOdate ) desc limit 0,50"; $mqlist = mysql_query($sqllist,$conn); $T = "今月のアクセスランキングTOP50"; }elseif($rank=="old"){ $num=0; $Bdate = "R".date("Ym", mktime(0, 0, 0, date("m"), 0, date("Y"))); $BOdate = "R".date("Ym", mktime(0, 0, 0, date("m")-1, 0, date("Y"))); $sqllist=""; $sqllist.="select * from ranking where ( $Bdate - $BOdate ) > 0 and id != 'cute-airi' "; $sqllist.="order by ( $Bdate - $BOdate ) desc limit 0,50"; $mqlist = mysql_query($sqllist,$conn); $T = "先月のアクセスランキングTOP50"; }elseif($rank=="semiall"){ $num=0; $Bdate = "R".date("Ym", mktime(0, 0, 0, date("m")+1, 0, date("Y"))); $BOdate = "R201104"; //$Bdate = "R201203"; $sqllist=""; $sqllist.="select * from ranking where ( $Bdate - $BOdate ) > 0 and id != 'cute-airi'"; $sqllist.="order by ( $Bdate - $BOdate ) desc limit 0,50"; $mqlist = mysql_query($sqllist,$conn); $T = "2011年4月からの半期アクセスランキングTOP50"; }elseif($rank=="semiallsub"){ $num=0; $Bdate = "R201103"; $BOdate = "R201009"; $sqllist=""; $sqllist.="select * from ranking where ( $Bdate - $BOdate ) > 0 and id != 'cute-airi'"; $sqllist.="order by ( $Bdate - $BOdate ) desc limit 0,50"; $mqlist = mysql_query($sqllist,$conn); $T = "2010年10月から2011年3月までの半期アクセスランキングTOP50"; }elseif($rank=="yearall"){ $num=0; $Bdate = "R".date("Ym", mktime(0, 0, 0, date("m")+1, 0, date("Y"))); $BOdate = "R201103"; //$Bdate = "R201103"; $sqllist=""; $sqllist.="select * from ranking where ( $Bdate - $BOdate ) > 0 and id != 'cute-airi'"; $sqllist.="order by ( $Bdate - $BOdate ) desc limit 0,50"; $mqlist = mysql_query($sqllist,$conn); $T = "2011年4月からの年間アクセスランキングTOP50"; }else{ $num=0; $Bdate = "R".date("Ym", mktime(0, 0, 0, date("m")+1, 0, date("Y"))); $sqllist=""; $sqllist.="select * from ranking where $Bdate > 0 and id != 'cute-airi'"; $sqllist.="order by $Bdate desc limit 0,50"; $mqlist = mysql_query($sqllist,$conn); $T = "累計アクセスランキングTOP50"; } $Y = date(Y); $M = date(m); $Yo = date("Y", mktime(0, 0, 0, date("m"), 0, date("Y"))); $Mo = date("m", mktime(0, 0, 0, date("m"), 0, date("Y"))); $num=0; ?>
先月のランキング | 今月のランキング | 4月からの 半期ランキング | 4月からの 年間ランキング | 累計ランキング |
順位 | ブログ名 | アクセス数 | 順位 | ブログ名 | アクセス数 | ${Bbn} | ${ACpoint} | "; //echo "
${Bbn} | ${ACpoint} | ${Bbn} | ${ACpoint} | "; //echo "|||
${Bbn} | ${ACpoint} | ${Bbn} | ${ACpoint} | "; //echo "|||
${Bbn} | ${ACpoint} | ${Bbn} | ${ACpoint} | "; //echo "|||
${Bbn} | ${ACpoint} | ${Bbn} | ${ACpoint} | "; //echo "|||
${Bbn} | ${ACpoint} | ${Bnum} | ${Bbn} | ${ACpoint} | "; //echo "||
${Bnum} | ${Bbn} | ${ACpoint} | ${Bbn} | ${ACpoint} | "; //echo "||
${Bbn} | ${ACpoint} | ${Bbn} | ${ACpoint} | "; //echo "|||
${Bbn} | ${ACpoint} | ${Bbn} | ${ACpoint} | "; //echo "|||
${Bbn} | ${ACpoint} | ${Bbn} | ${ACpoint} | "; //echo "|||
${Bbn} | ${ACpoint} | ${Bbn} | ${ACpoint} | "; //echo "|||
${Bbn} | ${ACpoint} | ${Bnum} | ${Bbn} | ${ACpoint} | "; //echo "||
${BackNUM} | ${Bbn} | ${ACpoint} | "; } if(!$BBnum[$j]){ $BBnum[$j]=" | "; } echo " | ||