您现在的位置是:首页 > 教程 > dedecms教程dedecms教程

dede:memberlist按照空间点击数homecount排序并加上序号的办法

怀蕊2023-09-16 13:43:38dedecms教程已有人查阅

导读修改全部在/include/taglib/memberlist.lib.php 这个文件中:找到:$sql = "SELECT mb.*,ms.space

修改全部在/include/taglib/memberlist.lib.php 这个文件中: 找到:
$sql = "SELECT mb.*,ms.spacename,ms.sign FROM `dede_member` mb
        LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid
        $wheresql order by mb.{$orderby} DESC LIMIT 0,$row ";
修改为:
if($orderby=='homecount')
	{
    $sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb
        LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid left join  `dede_member_tj` ht ON ht.mid = mb.mid
        $wheresql order by ht.homecount DESC LIMIT 0,$row ";
	}
	else
	{
		$sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb
        LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid left join  `dede_member_tj` ht ON ht.mid = mb.mid
        $wheresql order by mb.{$orderby} DESC LIMIT 0,$row ";
	}
按照autoindex排序的办法,找到:
while($row = $dsql->GetArray('mb'))
在这段的前面加入:
$GLOBALS['autoindex']='1';
找到如下代码:
$revalue .= $ctp->GetResult();
在下面加入:
$GLOBALS['autoindex']++; 
调用办法:
 {dede:memberlist row='15' orderby='homecount'}
        <li> <a href="../user/index.php?uid=[field:userid/]"> <span class="member_name">[field:global.autoindex/]、[field:uname/]</span> </a> </li>
  	  {/dede:memberlist}

本文标签:

很赞哦! ()

留言与评论 (共有 条评论)
验证码:

本栏推荐

相关标签