织梦列表页获取热搜排行榜文章

//列表页获取网友热搜 24小时
function GetHotSearch($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 .= '<li><span class="right"><time class="'.$class.'">'.date('Y-m-d',$arr['pubdate']).'</time></span><a rel="nofollow" target="_blank" href="go.php?url='.$arcurl.'" title="'.$arr['shorttitle'].'">'.$arr['shorttitle'].'</a></li>';
}
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 .= '<li><span class="right"><time class="'.$class.'">'.date('Y-m-d',$arr['pubdate']).'</time></span><a rel="nofollow" target="_blank" href="go.php?url='.$arcurl.'" title="'.$arr['shorttitle'].'">'.$arr['shorttitle'].'</a></li>';
}
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 .= '<li><span class="right"><time class="'.$class.'">'.date('Y-m-d',$arr['pubdate']).'</time></span><a rel="nofollow" target="_blank" href="go.php?url='.$arcurl.'" title="'.$arr['shorttitle'].'">'.$arr['shorttitle'].'</a></li>';
}
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 .= '<li><span class="right"><time class="'.$class.'">'.date('Y-m-d',$arr['pubdate']).'</time></span><a rel="nofollow" target="_blank" href="go.php?url='.$arcurl.'" title="'.$arr['shorttitle'].'">'.$arr['shorttitle'].'</a></li>';
}
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 .= '<a rel="nofollow" target="_blank" href="go.php?url='.$arcurl.'" title="'.$arr['shorttitle'].'">'.$arr['shorttitle'].'</a>';
}
return $li;
}

{dede:field.id function=GetHotSearch(@me)/}