织梦DedeCMS列表页获取访客热搜排行榜文章的方法,方法比较简单只需要打开织梦/include/extend.func.php 最后加上以下代码:
//列表页获取网友热搜 24小时
function jjGetHotSearch($tid){
global $dsql;
$time = time() - 86400;
$sql = "select * from dede_archives where typeid = '$tid' and shorttitle '' group by shorttitle order by pubdate desc limit 10";
$dsql->Execute('me',$sql);
$li = '';
while($arr = $dsql->GetArray('me'))
{
if($arr['pubdate'] >$time ){
$class = 'new';
}else{
$class = '';
}
$barr = GetOneArchive($arr['id']);
$arcurl = $barr['arcurl'];
$li .= '
'.$arr['shorttitle'].'';
}
return $li;
}
//排行榜获取网友热搜 3天
function hot_3_GetHotSearch($tid){
global $dsql;
$time = time() - 86400;
$sql = "select * from dede_archives where pubdate > UNIX_TIMESTAMP( CURDATE( ) - INTERVAL 3 day) and typeid = '$tid' and shorttitle '' group by shorttitle order by click desc limit 10";
$dsql->Execute('me',$sql);
$li = '';
while($arr = $dsql->GetArray('me'))
{
if($arr['pubdate'] >$time ){
$class = 'new';
}else{
$class = '';
}
$barr = GetOneArchive($arr['id']);
$arcurl = $barr['arcurl'];
$li .= '
'.$arr['shorttitle'].'';
}
return $li;
}
//排行榜获取网友热搜 7天
function hot_7_GetHotSearch($tid){
global $dsql;
$time = time() - 86400;
$sql = "select * from dede_archives where pubdate > UNIX_TIMESTAMP( CURDATE( ) - INTERVAL 7 day) and typeid = '$tid' and shorttitle '' group by shorttitle order by click desc limit 10";
$dsql->Execute('me',$sql);
$li = '';
while($arr = $dsql->GetArray('me'))
{
if($arr['pubdate'] >$time ){
$class = 'new';
}else{
$class = '';
}
$barr = GetOneArchive($arr['id']);
$arcurl = $barr['arcurl'];
$li .= '
'.$arr['shorttitle'].'';
}
return $li;
}
//排行榜获取网友热搜 30天
function hot_30_GetHotSearch($tid){
global $dsql;
$time = time() - 86400;
$sql = "select * from dede_archives where pubdate > UNIX_TIMESTAMP( CURDATE( ) - INTERVAL 30 day) and typeid = '$tid' and shorttitle '' group by shorttitle order by click desc limit 10";
$dsql->Execute('me',$sql);
$li = '';
while($arr = $dsql->GetArray('me'))
{
if($arr['pubdate'] >$time ){
$class = 'new';
}else{
$class = '';
}
$barr = GetOneArchive($arr['id']);
$arcurl = $barr['arcurl'];
$li .= '
'.$arr['shorttitle'].'';
}
return $li;
}
//列表页获取栏目关注 30天 14条
function hotword_30_GetHotSearch($tid){
global $dsql;
$time = time() - 86400;
$sql = "select * from dede_archives where pubdate > UNIX_TIMESTAMP( CURDATE( ) - INTERVAL 90 day) and typeid = '$tid' and shorttitle '' group by shorttitle order by click desc limit 14";
$dsql->Execute('me',$sql);
$li = '';
while($arr = $dsql->GetArray('me'))
{
if($arr['pubdate'] >$time ){
$class = 'new';
}else{
$class = '';
}
$barr = GetOneArchive($arr['id']);
$arcurl = $barr['arcurl'];
$li .= '
'.$arr['shorttitle'].'';
}
return $li;
列表调用方法:{dede:field.id function=jjGetHotSearch(@me)/},其他函数调用方法也是一样的,自己修改下 jjGetHotSearch 名称就可以了 。
声明:本站所有文章,如无特殊说明或标注,均为本站原创发布。任何个人或组织,在未征得本站同意时,禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益,可联系我们进行处理。