dede模板中调用UCHome会员日志相册话题游戏等信息的方法

{dede:sql sql="SELECT * FROM `uchome_space` WHERE `avatar` =1 LIMIT 0 , 6"}
<li>
<a href="uchome地址/space.php?uid=[field:uid/]" target="_blank"><img src="ucenter地址/avatar.php?uid=[field:uid/]&size=[field:small/]" border="0" /></a>
<a style="link:text-decoration: none; color: #0088bb;" href="uchome地址/space.php?uid=[field:uid/]">[field:username/]</a& gt;
<a href="uchome地址/space.php?uid=[field:uid/]&do=blog&id=[field:blogid/]" target="_blank">» 查看日志</a>
<a href="uchome地址/space.php?uid=[field:uid/]&do=album&id=[field:albumid/]" target="_blank">» 查看相册</a>
</li>
{/dede:sql}

{dede:sql sql="SELECT * FROM `uchome_blog` AS `blog` WHERE `blog`.`friend`=’0′ ORDER BY `blog`.`dateline` DESC limit 0,6"}
<li><a href="uchome地址/space.php?uid=[field:uid/]&do=blog&id= [field:blogid/]" target="_blank">[field:subject function="cn_substr('@me',52)" /]</a> – <a style="link:text-decoration: none; color: #999;" href="uchome地址/space.php?uid=[field:uid/]" target="_blank">[field:username/]</a>
  <a style="link:text-decoration: none; color: #999;" href="uchome地址/space.php?uid=[field:uid/]&do=blog&id= [field:blogid/]" target="_blank">浏览：[field:viewnum function="cn_substr('@me',42)" /]</a>
</li>
{/dede:sql}

{dede:sql sql="SELECT * FROM `uchome_thread` AS `thread` ORDER BY `thread`.`dateline` DESC limit 0,1"}
<li><a href="uchome地址/space.php?uid=[field:uid/]&do=thread&id= [field:tid/]" target="_blank">[field:subject function="cn_substr('@me',40)" /]</a></li>
{/dede:sql}

{dede:sql sql="SELECT * FROM uchome_album FORCE INDEX(updatetime) ORDER BY dateline DESC LIMIT 0,6"}
<li>
<a href="uchome地址/space.php?uid=[field:uid/]&do=album&id= [field:albumid/]" target="_blank"><img src="uchome地址/attachment/[field:pic]"/]" imgwidth="124" imgheight="94"></a>
<a style="link:text-decoration: none; color: #0088bb;" href="uchome地址/space.php?uid=[field:uid/]&do=album&id= [field:albumid/]" target="_blank">[field:username/][field:title_template function='str_replace("{actor}","",@me)'/]</a>
<a href="uchome地址/space.php?uid=[field:uid/]&do=album&id= [field:albumid/]" target="_blank">[field:albumname/][field:title_template function='str_replace("{actor}","",@me)'/]</a>
<a style="link:text-decoration: none; color: #999;" href="uchome地址/space.php?uid=[field:uid/]&do=album&id= [field:albumid/]" target="_blank">（[field:picnum/]幅）</a>
</li>
{/dede:sql}

{dede:sql sql="SELECT * FROM `uchome_userapp` LIMIT 0,6"}
<li>
<a href="uchome地址/cp.php?id=[field:appid/]" target="_blank"><img src="http://appicon.manyou.com/logos/[field:appid/]" alt="[field:appname/]" /></a>
<a href="uchome地址/cp.php?id=[field:appid/]" target="_blank">[field:appname/]</a>
</li>
{/dede:sql}

style="link:text-decoration: none; color: #0088bb;"