(100-$limit)){
$offset = 0;
$pageNum = 0;
}
}else{
$offset = 0;
$pageNum = 0;
}
//日付指定
if($_GET[‘baseD’]==””){
$day = 0;
}else{
$day = $_GET[‘baseD’];
}
$date = date(‘Y-m-d’, strtotime(“$day day”));//当日
$nday = $day+1;//翌日
$ndate = date(‘Y-m-d’, strtotime(“$nday day”));
$nnday = $day-1;//前日
$nndate = date(‘Y-m-d’, strtotime(“$nnday day”));
?>
= ‘$date'”;
$resultd = $mysqli->query($sqld);
$rowd = $resultd->fetch_assoc();
if($rowd[‘count(id)’]==0){
$day = $nnday;//当日
$date = date(‘Y-m-d’, strtotime(“$day day”));//当日
$nday = $day+1;//翌日
$ndate = date(‘Y-m-d’, strtotime(“$nday day”));
$nnday = $day-1;//前日
$nndate = date(‘Y-m-d’, strtotime(“$nnday day”));
}
?>
のLINEスタンプランキング:毎日17時に更新!
; ?>/img/title/blogTitleBar.jpg” /></div>
</p></div>
<p><!-- end topTopixTitle --></p>
<p> <center><br />
<?php
$ii = floor(100/$limit);
for($i=0;$i<$ii;$i++){
$firstRank = $i*$limit+1;
$lastRank = $firstRank+$limit-1;
echo '|| <a href=)
‘.$firstRank.’~’.$lastRank.’位 ‘;
}
echo ‘||’;
?>
||のランキング || &baseD=“>のランキング
|
= ‘$date’ and `date` < '$ndate' and ";
$sqls .= $catSql[$i];
$sqls .= " order by $order desc limit $offset,$limit";
//echo $sql;
//echo $sqls;
$results = $mysqli->query($sqls);
$rank = 0+$pageNum*$limit;
while($rows = $results->fetch_assoc()){
$num = $rows[‘num’];
$sql = “SELECT * from `stampZukanDB` where `num` = ‘$num'”;
$result = $mysqli->query($sql);
$row = $result->fetch_assoc();
$cat = $row[‘category’];
$addDate = $row[‘addDate’];
if($cat==2){
$year = date(‘Y’, strtotime($addDate));
$month = date(‘m’, strtotime($addDate));
$d = “../stampDict/img/{$catArray[$cat]}/{$year}/{$month}/{$num}”;
}else{
$d = “../stampDict/img/{$catArray[$cat]}/{$num}”;
}
$rank++;
?>
位
= ‘$nndate’ and `date` < '$date' and ";
$sqll .= $catSql[$i];
$resultl = $mysqli->query($sqll);
$rowl = $resultl->fetch_assoc();
if($rows[‘point’]>$rowl[‘point’]){
echo ‘ ‘;
}else if($rows[‘point’]==$rowl[‘point’]){
echo ‘ ‘;
}else{
echo ‘ ‘;
}
?>
|
query($q);
if(!$r) echo mysql_error();
while($rowr = $r->fetch_assoc())
{
$v=$rowr[‘total_votes’];
$tv=$rowr[‘total_value’];
if($v==0){
$rat=0.0;
}else{
$rat=$tv/$v;
}
}
echo’
‘.@number_format($rat,1).’/5 (‘.$v. ‘ 票)
‘;
echo ‘
‘;
for($k=1;$k<6;$k++){
if($rat+0.5>$k)$class=”star_”.$k.” ratings_stars_summary ratings_vote_summary”;
else $class=”star_”.$k.” ratings_stars_summary”;
echo ‘
‘;
}
echo ‘
‘; ?>
|
‘.$firstRank.’~’.$lastRank.’位 ‘;
}
echo ‘||’;
?>
||のランキング || &baseD=“>のランキング