{dede:field.field1 runphp=yes}
global $dsql;
$sql = "select arc.,tp.typedir,tp.typename,tp.corank,tp.isdefault,
tp.defaultname,tp.namerule,tp.moresite,tp.siteurl,tp.sitepath
from `58pic_archives` arc left jo `58pic_arctype` tp on arc.typeid=tp.id where tp.id  (@me) LIMIT 10";
$dsql->SetQuery($sql);
$dsql->Execute('t');
$result = '';
while($row = $dsql->GetArray('t'))
{
	$arcurl=GetOneArchive($row['id']);
	$pubdate = MyDate('Y-m-d H:i:s',$row['pubdate']);
	$result .= "<li><span>{$pubdate}</span><a href=\"{$arcurl['arcurl']}\">{$row['title']}</a></li>";
}
@me = $result;
{/dede:field.field1}