discuz 首页调用帖子列表带分页
前面发了一篇门户首页调用文章列表,这里发下调用帖子列表的代码。
这个代码放到门户首页index.htm模板中
<!--{eval require './source/function/function_post.php';}-->
<!--{eval require './config/config_global.php';}-->
<!--{eval $prefix=$_config['db']['1']['tablepre'] }-->
<!--{eval $pagesize = 10;}-->
<!--{eval $amount=0;}-->
<!--{eval $res = mysql_query("SELECT COUNT(*) as count FROM ".$prefix."forum_thread t1 LEFT OUTER JOIN ".$prefix."forum_threadimage t3 ON t1.tid = t3.tid WHERE t1.displayorder >- 1 AND t3.attachment <> ''");}-->
<!--{eval while($re=mysql_fetch_array($res)) $amount=$re['count']}-->
<!--{eval $pagecount = $amount ? (($amount < $pagesize) ? 1 : (($amount % $pagesize) ? ((int)($amount / $pagesize) + 1) : ($amount / $pagesize))) : 0; }-->
<!--{eval $page = !empty($_G['gp_page']) ? max(1, intval($_G['gp_page'])) : 1;}-->
<!--{eval $page = $page > $pagecount ? 1 : $page;}-->
<!--{eval $startlimit = ($page - 1) * $pagesize;}-->
<!--{eval $multipage = multi($amount, $pagesize, $page, 'portal.php?', $pagecount);}-->
<!--{eval $res = mysql_query("SELECT t1.tid,t1.fid,t2.`name`,t1.author,t1.authorid,t1.`subject`,t4.message,t1.views,t1.replies,from_unixtime(t1.dateline) as dateline,t3.attachment FROM ".$prefix."forum_thread t1 LEFT OUTER JOIN ".$prefix."forum_forum t2 ON t1.fid = t2.fid LEFT OUTER JOIN ".$prefix."forum_threadimage t3 ON t1.tid = t3.tid LEFT OUTER JOIN ".$prefix."forum_post t4 ON t1.tid = t4.tid WHERE t1.displayorder >- 1 AND t3.attachment<> '' AND t4.`first` > 0 ORDER BY t1.dateline DESC LIMIT $startlimit, $pagesize");}-->
复制代码
以上就可以成功调用了。
说明:
以上代码调用的是含有图片附件的主题,如果想要调用所有,删掉第一步代码最后的 AND t3.attachment,可调用到无图片附件帖。
<!--{eval $pagesize = 10;}-->是每10条分页。
我这里测试的结果是共有8页,不知道怎么能改变调用总数。
----------------------------------------------------------------------
另一个代码,这个好像也没控制住总数,这是调用全部帖子:
<!--{eval require './source/function/function_post.php';}-->
<!--{eval $pagesize = 9;}-->
<!--{eval $amount=0;}-->
<!--{eval $res = mysql_query("select count(*) as count from pre_forum_post where fid in(select fid from pre_forum_forum where status=1 and type='forum') and bbcodeoff<>-1");}-->
<!--{eval while($re=mysql_fetch_array($res)) $amount=$re['count']}-->
<!--{eval $pagecount = $amount ? (($amount < $pagesize) ? 1 : (($amount % $pagesize) ? ((int)($amount / $pagesize) + 1) : ($amount / $pagesize))) : 0; }-->
<!--{eval $page = !empty($_G['gp_page']) ? max(1, intval($_G['gp_page'])) : 1;}-->
<!--{eval $page = $page > $pagecount ? 1 : $page;}-->
<!--{eval $startlimit = ($page - 1) * $pagesize;}-->
<!--{eval $multipage = multi($amount, $pagesize, $page, 'portal.php?', $pagecount);}-->
<!--{eval $res = mysql_query("select t1.tid,t1.views,t1.author,t1.subject,FROM_UNIXTIME(t1.dateline,'%Y') as year,FROM_UNIXTIME(t1.dateline,'%m') as month,FROM_UNIXTIME(t1.dateline,'%d') as day,t2.message,t3.attachment,t4.name,t4.fid from pre_forum_thread t1 left join pre_forum_post t2 on t1.tid=t2.tid left join pre_forum_threadimage t3 on t1.tid=t3.tid left join pre_forum_forum t4 on t1.fid=t4.fid where t1.displayorder<> -1 and t3.attachment<>' ' order by t1.dateline desc LIMIT $startlimit, $pagesize");}-->
<!--{eval $src=""}-->
<!--{eval while($re1=mysql_fetch_array($res)) {}-->
<div class="page-container">
<div class="postmetadata">
<span class="meta-date">
<a href="forum.php?mod=viewthread&&tid=$re1['tid']" title="$re1['subject']">
<span class="month">$re1['month']月</span>
<span class="day">$re1['day']</span>
<span class="year">$re1['year']</span>
</a>
</span>
<span class="meta-comments">
<a href="forum.php?mod=viewthread&&tid=$re1['tid']" title="$re1['subject']" class="comments-count">$re1['views']</a>
<a href="forum.php?mod=viewthread&&tid=$re1['tid']" title="$re1['subject']">Comment</a>
</span>
<span class="meta-author">
<span>by<br />$re1['author']</span>
</span>
</div>
<div class="post-contents">
<div class="thumbnail">
<a href="forum.php?mod=viewthread&&tid=$re1['tid']" title="$re1['subject']"><img src="data/attachment/forum/$re1['attachment']"/></a>
</div>
<h3 class="entry-title">
<a href="forum.php?mod=viewthread&&tid=$re1['tid']" title="$re1['subject']">$re1['subject']</a>
</h3>
<div class="post-category">来自于<a href="forum.php?mod=forumdisplay&fid=$re1['fid']">$re1['name']</a></div>
<div class="post-content">
<!--{eval $src=messagecutstr($re1['message'],300)}-->
<p>$src</p>
</div>
</div>
</div>
<!--{eval }}-->
<div class="pags c1"><div id="pag"> $multipage </div></div>
调用列表开始:
<!--{eval while($re1=mysql_fetch_array($res)) {}-->
<a href=http://www.ym97.com/discuz/"forum.php?mod=viewthread&tid=$re1[tid]"><!--帖子链接-->
<!--{if $re1[attachment]}--><!--如果图片附件存在-->
<img src=http://www.ym97.com/discuz/"$_G[setting][attachurl]forum/$re1[attachment]" width="120" height="auto"><!--本地存储图片附件路径-->
<!--{/if}-->
</a>
<h3><a href=http://www.ym97.com/discuz/"forum.php?mod=viewthread&tid=$re1[tid]" title="$article[title]">$re1[subject]</a></h3><!--帖子链接、标题-->
<p><!--{eval echo messagecutstr($re1['message'],150)}--></p><!--帖子摘要150字符-->
<a href=http://www.ym97.com/discuz/"forum.php?mod=forumdisplay&fid=$re1[fid]" class="article-info-cat z">$re1[name]</a><!--板块链接、板块名-->
<em class="sprit z">/</em>
<a href=http://www.ym97.com/discuz/"home.php?mod=space&uid=$re1[authorid]" class="z">$re1[author]</a><!--帖子作者链接、作者用户名-->
<em class="sprit z">/</em>
<span class="article-info-date z">$re1[dateline]</span><!--帖子发表时间-->
<span class="article-info-num y"><i></i>$re1[replies]</span><!--帖子评论数-->
<span class="article-info-view y"><i></i>$re1[views]</span><!--帖子点击数-->
<!--{eval }}-->
<div class="pages cl">$multipage</div><!--帖子列表分页-->
复制代码
本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供用于网络技术学习参考,学习中请遵循相关法律法规!
本文地址: https://www.juheyunku.com/jz/discuz/2335.shtml
相关文章
热门TAG
命令 权重 外链 企业网站 白帽 php 织梦教程 dedecms修改内容 javascript 织梦 功能 标签 调用 详解 服务器 网站流量 实例解析 Dedecms 织梦cms HTML tags标签 python jquery教程 jquery windows SEO优化 蜘蛛 搜索引擎 网站收录 JSP最新文章
-
Discuz x2.5 伪静态规则成功
时间:2020-12-29
-
discuz X2正式版forum首页的
时间:2020-12-27
-
Discuz伪静态 配置搜索引擎
时间:2020-12-26
-
Discuz登录后总是显示未登
时间:2020-12-23
-
怎么换云服务器? Discuz论坛
时间:2020-12-23
-
Discuz!7.0主题回收站功能详
时间:2020-12-23
-
discuz 修改创始人密码、管
时间:2020-12-23
-
discuz论坛用户通过邮件验
时间:2020-12-23
热门文章
-
去掉discuz列表页的最新公告_Discuz模板开发
时间:2020-12-13
-
修改discuz X3.2论坛标题80个字符的长度限制
时间:2020-12-14
-
discuz 修改创始人密码、管理员登录密码的
时间:2020-12-23
-
discuz主题内容页面的打印按钮代码
时间:2020-12-13
-
Discuz!7.0主题回收站功能详解
时间:2020-12-23
-
footer.htm底部文件$_G['setting']['icp']、{if $
时间:2020-12-13
-
discuz教程_discuz视频教程_discuz论坛模板制
时间:2020-12-14
-
$article['related']Discuz 门户文章内容页的相
时间:2020-12-13
-
discuz教程_discuz视频教程_discuz论坛模板制
时间:2020-12-14
-
Discuz教程:使用微信登陆出现“目前无法
时间:2020-12-15
