Discuz主题信息列表

<?php
define('APPTYPEID', 102);
define('CURSCRIPT', 'sitemap');
require '../source/class/class_core.php';
$discuz = & discuz_core::instance();
$discuz->cachelist = $cachelist;
$discuz->init();
$navtitle='我逸网sitemap';
$metakeywords='我逸,网站地图,sitemap';
$metadescription='我逸网站地图sitemap';
echo '
<style type="text/css">
.newtid{box-sizing:border-box; width:100%; background:#fff; float:left; margin:10px 0; padding:10px 0; line-height:28px; font-size:14px;}
.newtid li{float:left; width:33.333333%; box-sizing:border-box; padding-left:10px;}
.newtit strong a{position: absolute;bottom: 98765px;}
.newtid h2{font-size: 16px;line-height: 45px;}
</style>
<ul class="newtid">';
$site_num = DB::result(DB::query("SELECT COUNT(`tid`) FROM ".DB::table('forum_thread')." as a inner join ".DB::table('forum_forum')." as b on a.fid=b.fid ORDER BY a.tid DESC"));

$site_num = $site_num ? $site_num :0;
echo $site_num;

$site_listnum = 1500;

$site_page = intval($_G['gp_page']) ? intval($_G['gp_page']) : 1;
$site_max = 0;

$site_max2 = 800;

//$querys = DB::query("SELECT a.tid,a.subject,a.fid,b.name FROM ".DB::table('forum_thread')." as a inner join ".DB::table('forum_forum')." as b on a.fid=b.fid ORDER BY a.tid DESC LIMIT ".$site_max.",".$site_max2);


$querys = DB::query("SELECT a.tid,a.subject,a.fid,b.name FROM ".DB::table('forum_thread')." as a inner join ".DB::table('forum_forum')." as b on a.fid=b.fid ORDER BY a.tid LIMIT ".$site_max.",".$site_max2);

$i=1;
while($threadfid = DB::fetch($querys)){

  echo '<li>['.$i.'/'.$threadfid['tid'].'] <a href="../thread-'.$threadfid['tid'].'-1-1.html" target="_blank">'.$threadfid['subject'].'</a></li>';
  $i++;
}
echo '</ul>';
echo ' ';
?>