新进会员
注册日期: 01月01日
来自
帖子: 3
所属群组: 注册会员
|
我发现wfsection并没有这功能 $sql = "SELECT articleid, title, published, expired, counter, groupid, articleimg, url, summary
FROM " . $xoopsDB->prefix( WFS_ARTICLE_DB ) . "
WHERE published < " . time() . "
AND published > 0
AND (expired = 0 OR expired > " . time() . ")
AND noshowart = 0
AND offline = 0 ".
$id_criteria.
$od_criteria;
$result = $xoopsDB->query( $sql, $options[1], 0 );
while ( $myrow = $xoopsDB->fetchArray( $result ) )
{
$wfs = array();
$title = $myts->htmlSpecialChars( stripslashes( $myrow["title"] ) );
if ( $xoopsModuleConfig['shortartlen'] > 0)
{
$title = xoops_substr( $title, 0, ( $xoopsModuleConfig['shortartlen'] -1 ) );
}
$wfs['title'] = ( $myrow['url'] ) ?
"<a href='" . formatURL( $myrow['url'] ) . "' target='_blank'>" . $title . "</a>" :
"<a href='" . WFS_ROOT_URL . "/article.php?articleid=" . $myrow['articleid'] . "'>" . $title . "</a>" ;
$wfs['new'] = ( $options[0] == "published" ) ? formatTimestamp( $myrow['published'], "s" ) : $myrow['counter'];
里头并无$myrow["category"] 请问要如何新增并抓取数据库的数值
|