0) { $Stitle .= " 以下を集計"; } else { $Stitle .= " のみ集計"; } } else { $kt_sql = "&".$_GET[kt]."&"; $Stitle .= " のみ集計"; } $Eref=urlencode($_SERVER[HTTP_REFERER]); //$i=1;$rank_z=1;$rank=1; if (!$_GET[page]) $_GET[page]=1; $log_lines=array(); $pre_pt = 0; //$pre_rank = 1; $Clog = $_GET[cl]; $pre_rank=$pre_rank_z = ($_GET[page]-1)*$EST[hyouji]+1; $end_no=$_GET[page]*$EST[hyouji]; $str_no=$end_no-$EST[hyouji]; $time=time(); if($_GET[mode] == "rank"){ $start=$time-$EST[rank_kikan]*86400; $end=$time; $last_mod=date("Y/m/d H:i", $start)." - ".date("Y/m/d H:i", $end); } elseif($_GET[mode] == "rank_bf"){ $start=$time-$EST[rank_kikan]*172800; $end=$time-$EST[rank_kikan]*86400+1; $last_mod=date("Y/m/d H:i", $start)." - ".date("Y/m/d H:i", $end); } else { $start=0; $end=$time; $last_mod=" - ".date("Y/m/d H:i", $end); } if ($_GET[kt]){ $query="SELECT r.id, COUNT(r.id) AS pt, l.category, l.id FROM $EST[sqltb]rank r, $EST[sqltb]log l WHERE l.id = r.id and r.time BETWEEN $start AND $end and l.category LIKE '%$kt_sql%' GROUP BY r.id ORDER BY pt DESC"; } else { $query="SELECT id,COUNT(*) AS pt FROM $EST[sqltb]rank WHERE time BETWEEN $start AND $end GROUP BY id ORDER BY pt DESC"; } if (!$Clog) { $result = $xoopsDB->query($query." LIMIT ".$EST['rank_best']) or die("Query failed rank109 $query"); $Clog = mysql_num_rows($result); } $query .= " LIMIT $str_no , $end_no"; $result = $xoopsDB->query($query) or die("Query failed rank109 $query"); while($Rank = mysql_fetch_assoc($result)){ $query="SELECT * FROM $EST[sqltb]log WHERE id='$Rank[id]' LIMIT 1"; $result2 = $xoopsDB->query($query) or die("Query failed rank120 $query"); $Slog = mysql_fetch_row($result2); if($Slog[0]){ $Slog['pt'] = $Rank['pt']; array_push($log_lines,$Slog); } } ?>
=$Stitle?> |
[他のカテゴリ] [サイトマップ] | [ヘルプ] [修正・削除] |
このカテゴリのサイトはランクインしていません