0) { $Stitle .= " 以下を集計"; } else { $Stitle .= " のみ集計"; } } else { $kt_sql = "&".$_GET['kt']."&"; } } else { $Stitle .= " 全体"; } //xoops2 タイトル設定 global $xoopsModule,$xoopsTpl; if (is_object($xoopsTpl)) { $xoops_pagetitle = $xoopsModule->name(); $xoops_pagetitle = "$Stitle-$xoops_pagetitle"; $xoopsTpl->assign("xoops_pagetitle",$xoops_pagetitle); } $Eref=urlencode($_SERVER['HTTP_REFERER']); //$i=1;$rank_z=1;$rank=1; $log_lines=array(); $pre_pt = 0; //$pre_rank = 1; //$Clog = $_GET['cl']; $Clog = 0; $pre_rank=$pre_rank_z = ($_GET['page']-1)*$EST['hyouji']+1; $end_no=$EST['hyouji']; $str_no=$_GET['page']*$EST['hyouji']-$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); } } #ナビゲーションバーを表示 $navi = ""; $kt=explode("_",$_GET['kt']); array_pop($kt); $temp_kt = ""; foreach ($kt as $tmp){ $temp_kt .= $tmp; $navi .= "$ganes[$temp_kt] > "; $temp_kt .="_"; } ?>
=$Stitle?> |
このカテゴリのサイトはランクインしていません