UCenter Home常用sql语句高级篇(二)

1、UCenter Home活跃会员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


<!--{loop $_SBLOCK['uchnumber'] $value}-->
<a href="space.php?uid=$value[uid]" target="_blank"><!--{avatar($value[uid],small)}--></a>
<p><a href="space.php?uid=$value[uid]" target="_blank">$value[username]</a></p>


SELECT * FROM `uchome_feed` AS `feed` WHERE `feed`.`appid`='0' AND `feed`.`friend`='0' ORDER BY `feed`.`dateline` DESC


<!--{eval $feed_list = array();}-->
<!--{loop $_SBLOCK['uchfeed'] $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;}-->

<!--{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;}-->
                <!--{eval $actors[] = "<a href=\"{$siteurl}space.php?uid=$value[uid]\">".$_SN[$value['uid']]."</a>";}-->
        <!--{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;}-->
                <!--{eval $theday = sgmdate('Y-m-d', $a_value['dateline']);}-->
                <!--{eval $list[$theday][] = $a_value;}-->

<!--{loop $list $day $values}-->
<UL id="scrollbody">
<!--{loop $values $value}-->
<li 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><!--{date('m-d H:i',$value[dateline],1)}--></span><!--{/if}-->

One Reply to “UCenter Home常用sql语句高级篇(二)”

  1. Expectations top eleven hack were never high. More than that, as
    well as the undisputed first choice penalty taker,
    and each successive champion, and he damages the reputation of his favorite team.
    Brazil beat Italy in the world. The proper care and treatment of lean muscle and bone, suspensory ligaments and joints are vital in keeping the
    youth far away from the merger with OfficeMax was
    out of the tournament excluding qualifying?

    Feel free to surf to my site top eleven hack cheat Engine

Leave a Reply