八一中文网

八一中文网是广大书友最值得收藏的网络小说阅读网,54中文网收录了当前最火热的网络小说,五四中文网免费提供高质量的小说最新章节,是广大网络小说爱好者必备的小说阅读网。

本站统计:八一中文网【http://www.54zww.com】

'.$cfg_tui_name.'

    '; $cfg_tui=trim(str_replace(',',',',$cfg_tui)); $andsql=($cfg_tui=='0' || $cfg_tui=='') ? "order by bookclick desc limit 0,7":"and a.id in($cfg_tui)"; $query = "SELECT a.id,a.typename,a.typedir,a.bookclick,a.zuozhe,a.typeimg,a.overdate,c.typename as retypename FROM dede_arctype a left join dede_arctype c on(c.id=a.reid) WHERE a.reid<>45 and a.reid<>0 ".$andsql.""; $dsql->SetQuery($query); $dsql->Execute(); while($row=$dsql->GetArray()){ $overdate=($row['overdate']=="0"||empty($row['overdate']))?"连载":"完本"; $s.='
  • '.$row['typename'].'

    '.$row['typename'].'

    -'.$overdate.'
  • '; } $s.='

作家作品集

    '; $dsql->safeCheck = false; $cfg_zzid=trim(str_replace(',',',',$cfg_zzid)); $andsql2=""; if($cfg_zztype=='1') { $query = "SELECT a.zuozhe AS zuozhe,b.typeimg,b.typedir,SUM(a.bookclick) AS bookclick FROM dede_arctype b JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM `dede_arctype` WHERE reid=45)-(SELECT MIN(id) FROM `dede_arctype` WHERE reid=45)-$cfg_zznom)+(SELECT MIN(id) FROM `dede_arctype` WHERE reid=45)) AS id) AS t2 LEFT JOIN dede_arctype a ON(a.zuozhe=b.typename) WHERE b.reid=45 and b.typename<>'' AND b.id>t2.id GROUP BY b.typename order by bookclick desc limit $cfg_zznom"; } elseif($cfg_zztype=='2' || $cfg_zzid=="") { $query = "SELECT a.zuozhe AS zuozhe,b.typeimg,b.typedir,SUM(a.bookclick) AS bookclick FROM dede_arctype b LEFT JOIN dede_arctype a ON(a.zuozhe=b.typename) WHERE b.reid=45 and b.typename<>'' GROUP BY b.typename order by bookclick desc limit $cfg_zznom"; } elseif($cfg_zztype=='3' && $cfg_zzid!="") { $andsql=" and a.id in($cfg_tui)"; $andsql2=" and a.id not in($cfg_tui)"; $query = "SELECT a.zuozhe AS zuozhe,b.typeimg,b.typedir,SUM(a.bookclick) AS bookclick FROM dede_arctype b LEFT JOIN dede_arctype a ON(a.zuozhe=b.typename) WHERE b.reid=45 and b.typename<>''".$andsql." GROUP BY b.typename order by bookclick desc"; } $n=0; $dsql->SetQuery($query); $dsql->Execute(); while($row=$dsql->GetArray()) { $s.="
  • ".$row["zuozhe"]."作品集

  • "; $n++; } if($n<$cfg_zznom && $andsql2!="") { $lm=$cfg_zznom-$n; $query = "SELECT a.zuozhe AS zuozhe,b.typeimg,b.typedir,SUM(a.bookclick) AS bookclick FROM dede_arctype b LEFT JOIN dede_arctype a ON(a.zuozhe=b.typename) WHERE b.reid=45".$andsql2." GROUP BY b.typename order by bookclick desc limit $lm"; $dsql->SetQuery($query); $dsql->Execute(); while($row=$dsql->GetArray()) { $s.="
  • ".$row["zuozhe"]."作品集

  • "; } } echo $s; {/dede:php}

最新小说推荐

小说排行榜

最近更新列表