PHPCMS 栏目页及列表页分页修改

/*
文件：/include/global.func.php
函数：get
*/
/*
为 get 函数添加一个参数
ismaxpage 就是所添加的参数，用于判断是否启用“列表页最大页数”这个参数
而插入代码的部分是为了改变total的值，即记录集总数
*/
function get($sql, $rows = 0, $page = 0, $dbname = '', $dbsource = '', $urlrule = '', $distinct_field = '', $catid = 0, $ismaxpage = 0) {
...
if($dbname || $dbsource)
{
$r = $db->get_one("SELECT COUNT(*) AS `count` ".stristr($sql, 'from'));
$total = $r['count'];
}
elseif($distinct_field)
{
$total = cache_count("SELECT COUNT(distinct $distinct_field) AS `count` ".stristr($sql, 'from'));
}
else
{
$total = cache_count("SELECT COUNT(*) AS `count` ".stristr($sql, 'from'));
}
/* 插入以下代码 开始 */
global $PHPCMS;
if ($ismaxpage) {
$total = min($total, $PHPCMS['maxpage']*$rows);
}
/* 插入以上代码 结束 */
$pages = pages($total, $page, $rows, $urlrule, '', $catid);
...
}

/*
文件：/include/template.func.php
函数：get_parse
*/
/*
前台 get 标签最后是转换成 get 函数，以下是处理 get 标签的函数
因为 get 函数增加了一个参数 $ismaxpage，所以这里也需要做相应修改
以下是修改后的部分代码
*/
function get_parse($str)
{
...
extract($r);
if(!isset($dbsource)) $dbsource = '';
if(!isset($dbname)) $dbname = '';
if(!isset($sql)) $sql = '';
if(!isset($rows)) $rows = 0;
if(!isset($urlrule)) $urlrule = '';
if(!isset($catid)) $catid = 0;
if(!isset($distinctfield)) $distinctfield = '';
if(!isset($return) || !preg_match("/^\w+$/i", $return)) $return = 'r';
if(!isset($ismaxpage)) $ismaxpage = 0; /* 增加部分 */
if(isset($page))
{
/* 修改部分，增加了 $ismaxpage 这个参数，仔细看 */
$str = "<?php \$ARRAY = get(\"$sql\", $rows, $page, \"$dbname\", \"$dbsource\", \"$urlrule\",\"$distinctfield\",\"$catid\", $ismaxpage);\$DATA=\$ARRAY['data'];\$total=\$ARRAY['total'];\$count=\$ARRAY['count'];\$pages=\$ARRAY['pages'];unset(\$ARRAY);foreach(\$DATA AS \$n=>\${$return}){\$n++;?>";
}
...
}

/*
文件：/admin/html.inc.php
*/
/* 找到以下代码 */
if($CATEGORY[$catid]['child'])
{
$pages = 1;
$html->category($catid);
}
else
{
$offset = $pagesize*($page-1);
if($page == 1)
{
$contents = cache_count("SELECT COUNT(*) AS `count` FROM `".DB_PRE."content` WHERE catid=$catid AND status=99");
$total = ceil($contents/$PHPCMS['pagesize']);
$pages = ceil($total/$pagesize);
}
$max = min($offset+$pagesize, $total);
for($i=$offset; $i{
$html->category($catid, $i);
}
}
/* 然后把上面的代码替换成以下的代码 */
$offset = $pagesize*($page-1);
if($page == 1)
{
$condition=get_sql_catid($catid);
$contents = cache_count("SELECT COUNT(*) AS `count` FROM `".DB_PRE."content` WHERE status=99 $condition");
$total = ceil($contents/$PHPCMS['pagesize'])+1;
/* 以下这行代码确保了生成的栏目及列表页的数量是正确的，该生成多少页就是多少页 */
$total = $CATEGORY[$catid]['child'] ? min($total, $PHPCMS['maxpage']+1) : $total;
$pages = ceil($total/$pagesize);
}
$max = min($offset+$pagesize, $total);
for($i=$offset; $i{
$html->category($catid, $i);
}

<?php
$catids = str_replace('`catid`', 'a.`catid`', get_sql_catid($catid));
$sql = "
SELECT a.contentid, a.catid, a.title, a.keywords, a.thumb, a.userid, a.updatetime, a.inputtime, a.islink, a.url, a.style
FROM `phpcms_content` a
WHERE a.status=99 $catids ORDER BY a.contentid DESC";
/* 判断是否有子栏目，有的话就开启“列表页最大页数”这个参数，限制栏目页页数 */
if ($child) {
$ismaxpage = 1;
$page = min($page, $PHPCMS['maxpage']); /* 为了防止在地址栏输入页数，这里是要滴 */
}
?>

{get sql="$sql" rows="20" page="$page" catid="$catid" ismaxpage="$ismaxpage"}

• {$r[title]}

{/get}