01 |
$dsql->SetQuery("SELECT arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule, |
02 |
tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp |
03 |
on arc.typeid=tp. id WHERE |
04 |
FROM_UNIXTIME(arc.senddate, '%Y-%m-%d' ) = "." '".date(' Y-m-d ')."' "); |
06 |
while ($rows = $dsql->GetArray()) { |
07 |
$rows[ 'url' ] = GetFileUrl($rows[ 'id' ],$rows[ 'typeid' ],$rows[ 'senddate' ],$rows[ 'title' ],$rows[ 'ismake' ], |
08 |
$rows[ 'arcrank' ],$rows[ 'namerule' ],$rows[ 'typedir' ],$rows[ 'money' ],$rows[ 'filename' ],$rows[ 'moresite' ],$rows[ 'siteurl' ], |
|