0
core.index-member
blog
categories
1
0
6
1
blog
1
blog.rss_title_1
blog.rss_description_1
blog
1
1
database()->select('bt.text_parsed, b.blog_id, u.user_name, u.full_name')
->from(Phpfox::getT('blog'), 'b')
->join(Phpfox::getT('user'), 'u', 'u.user_id = b.blog_id')
->join(Phpfox::getT('blog_text'), 'bt','bt.blog_id = b.blog_id')
->where('b.is_approved = 1 AND b.privacy = 1 AND b.post_status = 1')
->limit(Phpfox::getParam('rss.total_rss_display'))
->order('b.blog_id DESC')
->execute('getSlaveRows');
$iCnt = count($aRows);
foreach ($aRows as $iKey => $aRow)
{
$aRows[$iKey]['description'] = $aRow['text'];
$aRows[$iKey]['link'] = Phpfox::permaLink('blog', $aRow['blog_id'], $aRow['title']);
$aRows[$iKey]['creator'] = $aRow['full_name'];
}
]]>
blog
1
blog.rss_title_2
blog.rss_description_2
blog.category.{TITLE_URL}
1
0
database()->select('category_id, name')
->from(Phpfox::getT('blog_category'))
->where('user_id = 0')
->execute('getSlaveRows');
if (count($aCategories))
{
foreach ($aCategories as $aCategory)
{
$aRow['child'][Phpfox::getLib('phpfox.url')->makeUrl('rss', array('id' => $aRow['feed_id'], 'category' => $aCategory['category_id']))] = $aCategory['name'];
}
}]]>
getBlogsByCategory(Phpfox::getLib('phpfox.request')->get('category'), 0, array('AND blog.is_approved = 1 AND blog.privacy = 1 AND blog.post_status = 1'), 'blog.time_stamp DESC', 0, Phpfox::getParam('rss.total_rss_display'));
foreach ($aRows as $iKey => $aRow)
{
$aRows[$iKey]['description'] = $aRow['text'];
$aRows[$iKey]['link'] = Phpfox::itemUrl('blog', $aRow['title_url'], $aRow['user_name']);
$aRows[$iKey]['creator'] = $aRow['full_name'];
}
if (isset($aRows[0]))
{
$aFeed['feed_link'] = str_replace('{TITLE_URL}', $aRows[0]['category_name_url'], $aFeed['feed_link']);
$sDescription = str_replace('{CATEGORY}', $aRows[0]['category_name'], $sDescription);
}]]>