首页“活跃会员,您可能认识他们!”这部分的UCHOME后台调用参数和SQL语句能否提供下,谢谢了
tgjy1 发表于 2009-3-10 20:44
最热会员
查询SQL语句
SELECT * FROM `uchome_space` AS `space` LEFT JOIN `uchome_spacefield` AS `spacefield` on `space`.`uid`=`spacefield`.`uid` WHERE `space`.`avatar`='1' ORDER BY `space`.`credit` DESC
数据显示HTML代码
<ul>
<!--{loop $_SBLOCK['block8'] $value}-->
<li>
<a href="http://home.pinghu.net/space.php?uid=$value[uid]" target=_blank><img src="<!--{avatar($value[uid],small)}-->" alt="{$_SN[$value[uid]]}" /></a>
<p><a href="http://home.pinghu.net/space.php?uid=$value[uid]" target=_blank>$value[username]</a></p>
</li>
<!--{/loop}-->
</ul>
动态
查询SQL语句
SELECT * FROM `uchome_feed` AS `feed` WHERE `feed`.`appid`='0' AND `feed`.`friend`='0' ORDER BY `feed`.`dateline` DESC
数据显示HTML代码
<!--{eval $feed_list = array();}-->
<!--{loop $_SBLOCK['block7'] $value}-->
<!--{if empty($feed_list[$value['hash_data']][$value['uid']])}-->
<!--{eval realname_set($value['uid'], $value['username']);}-->
<!--{eval $feed_list[$value['hash_data']][$value['uid']] = $value;}-->
<!--{/if}-->
<!--{/loop}-->
<!--{eval $list = array();}-->
<!--{loop $feed_list $values}-->
<!--{eval $actors = array();}-->
<!--{eval $a_value = array();}-->
<!--{loop $values $value}-->
<!--{if empty($a_value)}-->
<!--{eval $a_value = $value;}-->
<!--{/if}-->
<!--{eval $actors[] = "<a href=\"{$siteurl}space.php?uid=$value[uid]\">".$_SN[$value['uid']]."</a>";}-->
<!--{/loop}-->
<!--{eval $a_value = mkfeed($a_value, $actors);}-->
<!--{if $a_value['dateline']>=$_SGLOBAL['today']}-->
<!--{eval $list['today'][] = $a_value;}-->
<!--{elseif $a_value['dateline']>=$_SGLOBAL['today']-3600*24}-->
<!--{eval $list['yesterday'][] = $a_value;}-->
<!--{else}-->
<!--{eval $theday = sgmdate('Y-m-d', $a_value['dateline']);}-->
<!--{eval $list[$theday][] = $a_value;}-->
<!--{/if}-->
<!--{/loop}-->
<!--{loop $list $day $values}-->
<UL class=line_list id=scrollbody style="OVERFLOW: hidden; HEIGHT: 250px">
<!--{loop $values $value}-->
<li class="type_$value[icon]" id="feed_$value[feedid]_li">
<!--{eval echo str_replace('src="attachment', 'src="'.$siteurl.'attachment', str_replace('ref="space', 'ref="'.$siteurl.'space', $value[title_template]));}-->
<!--{if empty($notime)}--> <span class="time"><!--{date('m-d H:i',$value[dateline],1)}--></span><!--{/if}-->
</li>
<!--{/loop}-->
</ul>
<!--{/loop}--> |