信息排行

=".time()."-".($day*24*3600); } if($field=='plnum') { $word='评论数'; } elseif($field=='totaldown') { $word='下载数'; } elseif($field=='onclick') { $word='点击数'; } $query.=" order by ".$field." desc limit ".$topnum; echo""; $sql=$empire->query($query); while($r=$empire->fetch($sql)) { $classurl=sys_ReturnBqClassname($r,9); $titleurl=sys_ReturnBqTitleLink($r); echo""; } echo"

标题	$word
[".$class_r[$r[classid]][classname]."] ".stripSlashes($r[title])."	".$r[$field]."

"; } $where=''; //数据表 $tbname=RepPostVar($_GET['tbname']); if(empty($tbname)) { $tbname=$public_r['tbname']; } $htb=0; $tbsql=$empire->query("select tbname,tname from {$dbtbpre}enewstable order by tid"); while($tbr=$empire->fetch($tbsql)) { $select=""; if($tbr[tbname]==$tbname) { $htb=1; $select=" selected"; } $tbs.=""; } if($htb==0) { printerror('ErrorUrl',''); } //栏目 $classid=(int)$_GET['classid']; if($classid) { $and=$where?' and ':' where '; if($class_r[$classid][islast]) { $where.=$and."classid='$classid'"; } else { $where.=$and."(".ReturnClass($class_r[$classid][sonclass]).")"; } } //标题分类 $ttid=(int)$_GET['ttid']; if($ttid) { $and=$where?' and ':' where '; $where.=$and." ttid='$ttid'"; } $ttclass=""; $tt_sql=$empire->query("select typeid,tname from {$dbtbpre}enewsinfotype order by typeid"); while($tt_r=$empire->fetch($tt_sql)) { $selected=''; if($tt_r[typeid]==$ttid) { $selected=" selected"; } $ttclass.=""; } //字段 $myorder=(int)$_GET['myorder']; if($myorder==1) { $field='plnum'; } elseif($myorder==2) { $field='totaldown'; } else { $field='onclick'; } //搜索 if($_GET['keyboard']) { $and=$where?' and ':' where '; $keyboard=RepPostVar2($_GET['keyboard']); $show=RepPostStr($_GET['show'],1); if($show==0)//搜索标题 { $where.=$and."title like '%$keyboard%'"; } else//搜索作者 { $where.=$and."username like '%$keyboard%'"; } } //显示条数 $topnum=(int)$_GET['topnum']; if($topnum<1||$topnum>100) { $topnum=10; } $query="select id,title,classid,newstime,isurl,titleurl,".$field." from {$dbtbpre}ecms_".$tbname.$where; ?> 信息排行

位置：信息排行

数据表，栏目，标题分类，排行，显示，关键字