www.gusucode.com > ecShop PHP网上商城系统 粉丝修复版 v2.7.3源码程序 > ecshop_xf_v2.7.3/feed.php
<?php
/**
* ECSHOP RSS Feed 生成程序
* ============================================================================
* * 版权所有 2005-2012 上海商派网络科技有限公司，并保留所有权利。
* 网站地址: http://www.ecshop.com；
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用；不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* $Author: liubo $
* $Id: feed.php 17217 2011-01-19 06:29:08Z liubo $
*/
define('IN_ECS', true);
define('INIT_NO_USERS', true);
define('INIT_NO_SMARTY', true);
require(dirname(__FILE__) . '/includes/init.php');
require(ROOT_PATH . 'includes/cls_rss.php');
header('Content-Type: application/xml; charset=' . EC_CHARSET);
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Fri, 14 Mar 1980 20:53:00 GMT');
header('Last-Modified: ' . date('r'));
header('Pragma: no-cache');
$ver = isset($_REQUEST['ver']) ? $_REQUEST['ver'] : '2.00';
$cat = isset($_REQUEST['cat']) ? ' AND ' . get_children(intval($_REQUEST['cat'])) : '';
$brd = isset($_REQUEST['brand']) ? ' AND g.brand_id=' . intval($_REQUEST['brand']) . ' ' : '';
$uri = $ecs->url();
$rss = new RSSBuilder(EC_CHARSET, $uri, htmlspecialchars($_CFG['shop_name']), htmlspecialchars($_CFG['shop_desc']), $uri . 'animated_favicon.gif');
$rss->addDCdata('', 'http://www.ecshop.com', date('r'));
if (isset($_REQUEST['type']))
{
if($_REQUEST['type'] == 'group_buy')
{
$now = gmtime();
$sql = 'SELECT act_id, act_name, act_desc, start_time ' .
"FROM " . $GLOBALS['ecs']->table('goods_activity') .
"WHERE act_type = '" . GAT_GROUP_BUY . "' " .
"AND start_time <= '$now' AND is_finished < 3 ORDER BY start_time DESC";
$res = $db->query($sql);
if ($res !== false)
{
while ($row = $db->fetchRow($res))
{
$item_url = build_uri('group_buy', array('gbid' => $row['act_id']), $row['act_name']);
$separator = (strpos($item_url, '?') === false)? '?' : '&';
$about = $uri . $item_url;
$title = htmlspecialchars($row['act_name']);
$link = $uri . $item_url . $separator . 'from=rss';
$desc = htmlspecialchars($row['act_desc']);
$subject = $_LANG['group_buy'];
$date = local_date('r', $row['start_time']);
$rss->addItem($about, $title, $link, $desc, $subject, $date);
}
$rss->outputRSS($ver);
}
}
elseif($_REQUEST['type'] == 'snatch')
{
$now = gmtime();
$sql = 'SELECT act_id, act_name, act_desc, start_time ' .
"FROM " . $GLOBALS['ecs']->table('goods_activity') .
"WHERE act_type = '" . GAT_SNATCH . "' " .
"AND start_time <= '$now' AND is_finished < 3 ORDER BY start_time DESC";
$res = $db->query($sql);
if ($res !== false)
{
while ($row = $db->fetchRow($res))
{
$item_url = build_uri('snatch', array('sid' => $row['act_id']), $row['act_name']);
$separator = (strpos($item_url, '?') === false)? '?' : '&';
$about = $uri . $item_url;
$title = htmlspecialchars($row['act_name']);
$link = $uri . $item_url . $separator . 'from=rss';
$desc = htmlspecialchars($row['act_desc']);
$subject = $_LANG['snatch'];
$date = local_date('r', $row['start_time']);
$rss->addItem($about, $title, $link, $desc, $subject, $date);
}
$rss->outputRSS($ver);
}
}
elseif($_REQUEST['type'] == 'auction')
{
$now = gmtime();
$sql = 'SELECT act_id, act_name, act_desc, start_time ' .
"FROM " . $GLOBALS['ecs']->table('goods_activity') .
"WHERE act_type = '" . GAT_AUCTION . "' " .
"AND start_time <= '$now' AND is_finished < 3 ORDER BY start_time DESC";
$res = $db->query($sql);
if ($res !== false)
{
while ($row = $db->fetchRow($res))
{
$item_url = build_uri('auction', array('auid' => $row['act_id']), $row['act_name']);
$separator = (strpos($item_url, '?') === false)? '?' : '&';
$about = $uri . $item_url;
$title = htmlspecialchars($row['act_name']);
$link = $uri . $item_url . $separator . 'from=rss';
$desc = htmlspecialchars($row['act_desc']);
$subject = $_LANG['auction'];
$date = local_date('r', $row['start_time']);
$rss->addItem($about, $title, $link, $desc, $subject, $date);
}
$rss->outputRSS($ver);
}
}
elseif($_REQUEST['type'] == 'exchange')
{
$sql = 'SELECT g.goods_id, g.goods_name, g.goods_brief, g.last_update ' .
"FROM " . $GLOBALS['ecs']->table('exchange_goods') . " AS eg, " .
$GLOBALS['ecs']->table('goods') . " AS g " .
"WHERE eg.goods_id = g.goods_id";
$res = $db->query($sql);
if ($res !== false)
{
while ($row = $db->fetchRow($res))
{
$item_url = build_uri('exchange_goods', array('gid' => $row['goods_id']), $row['goods_name']);
$separator = (strpos($item_url, '?') === false)? '?' : '&';
$about = $uri . $item_url;
$title = htmlspecialchars($row['goods_name']);
$link = $uri . $item_url . $separator . 'from=rss';
$desc = htmlspecialchars($row['goods_brief']);
$subject = $_LANG['exchange'];
$date = local_date('r', $row['last_update']);
$rss->addItem($about, $title, $link, $desc, $subject, $date);
}
$rss->outputRSS($ver);
}
}
elseif($_REQUEST['type'] == 'activity')
{
$now = gmtime();
$sql = 'SELECT act_id, act_name, start_time ' .
"FROM " . $GLOBALS['ecs']->table('favourable_activity') .
" WHERE start_time <= '$now' AND end_time >= '$now'";
$res = $db->query($sql);
if ($res !== false)
{
while ($row = $db->fetchRow($res))
{
$item_url = 'activity.php';
$separator = (strpos($item_url, '?') === false)? '?' : '&';
$about = $uri . $item_url;
$title = htmlspecialchars($row['act_name']);
$link = $uri . $item_url . $separator . 'from=rss';
$desc = '';
$subject = $_LANG['favourable'];
$date = local_date('r', $row['start_time']);
$rss->addItem($about, $title, $link, $desc, $subject, $date);
}
$rss->outputRSS($ver);
}
}
elseif($_REQUEST['type'] == 'package')
{
$now = gmtime();
$sql = 'SELECT act_id, act_name, act_desc, start_time ' .
"FROM " . $GLOBALS['ecs']->table('goods_activity') .
"WHERE act_type = '" . GAT_PACKAGE . "' " .
"AND start_time <= '$now' AND is_finished < 3 ORDER BY start_time DESC";
$res = $db->query($sql);
if ($res !== false)
{
while ($row = $db->fetchRow($res))
{
$item_url = 'package.php';
$separator = (strpos($item_url, '?') === false)? '?' : '&';
$about = $uri . $item_url;
$title = htmlspecialchars($row['act_name']);
$link = $uri . $item_url . $separator . 'from=rss';
$desc = htmlspecialchars($row['act_desc']);
$subject = $_LANG['remark_package'];
$date = local_date('r', $row['start_time']);
$rss->addItem($about, $title, $link, $desc, $subject, $date);
}
$rss->outputRSS($ver);
}
}
elseif(substr($_REQUEST['type'], 0, 11) == 'article_cat')
{
$sql = 'SELECT article_id, title, author, add_time' .
' FROM ' .$GLOBALS['ecs']->table('article') .
' WHERE is_open = 1 AND ' . get_article_children(substr($_REQUEST['type'], 11)) .
' ORDER BY add_time DESC LIMIT ' . $_CFG['article_page_size'];
$res = $db->query($sql);
if ($res !== false)
{
while ($row = $db->fetchRow($res))
{
$item_url = build_uri('article', array('aid' => $row['article_id']), $row['title']);
$separator = (strpos($item_url, '?') === false)? '?' : '&';
$about = $uri . $item_url;
$title = htmlspecialchars($row['title']);
$link = $uri . $item_url . $separator . 'from=rss';
$desc = '';
$subject = htmlspecialchars($row['author']);
$date = local_date('r', $row['add_time']);
$rss->addItem($about, $title, $link, $desc, $subject, $date);
}
$rss->outputRSS($ver);
}
}
}
else
{
$in_cat = $cat > 0 ? ' AND ' . get_children($cat) : '';
$sql = 'SELECT c.cat_name, g.goods_id, g.goods_name, g.goods_brief, g.last_update ' .
'FROM ' . $ecs->table('category') . ' AS c, ' . $ecs->table('goods') . ' AS g ' .
'WHERE c.cat_id = g.cat_id AND g.is_delete = 0 AND g.is_alone_sale = 1 ' . $brd . $cat .
'ORDER BY g.last_update DESC';
$res = $db->query($sql);
if ($res !== false)
{
while ($row = $db->fetchRow($res))
{
$item_url = build_uri('goods', array('gid' => $row['goods_id']), $row['goods_name']);
$separator = (strpos($item_url, '?') === false)? '?' : '&';
$about = $uri . $item_url;
$title = htmlspecialchars($row['goods_name']);
$link = $uri . $item_url . $separator . 'from=rss';
$desc = htmlspecialchars($row['goods_brief']);
$subject = htmlspecialchars($row['cat_name']);
$date = local_date('r', $row['last_update']);
$rss->addItem($about, $title, $link, $desc, $subject, $date);
}
$rss->outputRSS($ver);
}
}
?>