supesite7.5首页调用uchome2.0会员和动态教程
会员调用:
查询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
- <ul>
- <!--{loop $_SBLOCK['block2'] $value}-->
- <li>
- <a href="http://bzzdzy.com/hi/space.php?uid=$value[uid]" title="{$_SN[$value[uid]]}" target="_blank"><!--{avatar($value[uid],small)}--></a>
- <p><a href="http://bzzdzy.com/hi/space.php?uid=$value[uid]" target=_blank>$value[username]</a></p>
- </li>
- <!--{/loop}-->
- </ul>
查询SQL语句(显示会员所有动态)
- SELECT * FROM uchome_feed ORDER BY dateline DESC
- <!--{eval $feed_list = array();}-->
- <!--{loop $_SBLOCK['block1'] $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)}-->



