<? 
//コラム：２
//新着：１
include("feedcreator.class.php");
require("./admin/config.php" );


$rss = new UniversalFeedCreator();
$rss->useCached();
$rss->title = "*STANDARD CALIFORNIA* TOPICS";
$rss->language=ja;
$rss->description = "カリフォルニアの陽気とスピードを明るい店内でゆっくり選んでいただける古着屋 『STANDARDCALIFORNIA』です。お取り扱いVINTAGE,ORIGINAL,HTC,コラボ,Another Heaven,SHOESのトピックスを紹介します。";
$rss->link = "http://standardcalifornia.com/";
$rss->syndicationURL = "http://standardcalifornia.com".$PHP_SELF;

$image = new FeedImage();
$image->title = "standardcalifornia logo";
$image->url = "http://standardcalifornia.com/online/images/standardcalifornia.gif";
$image->link = "http://standardcalifornia.com/";
$image->description = "*STANDARD CALIFORNIA*";
$rss->image = $image;

// get your news items from somewhere, e.g. your database:

$sql = "SET NAMES ujis";
$con=mysql_connect(_DB_HOST,_DB_UID,_DB_PASS);
//print"$con";
mysql_select_db(_DB_NAME,$con);
$result=mysql_query($sql,$con);

$sql = "SELECT DATE_FORMAT(date,'%Y-%m-%d'),title,category_id,id,comment1
FROM `posts`
WHERE
category_id < 3
ORDER BY date desc,id desc
LIMIT 0, 15 ";

$result=mysql_query($sql,$con);
$result_numrows=mysql_num_rows($result);


$item = new FeedItem();

for ( $i = 0 ; $i <= $result_numrows-1 ; $i++ ) 
{
	$news_date=mysql_result($result,$i,0);
	$news_title=mysql_result($result,$i,1);
	$category_id=mysql_result($result,$i,2);
	$report_no=mysql_result($result,$i,3);
	$description=mysql_result($result,$i,4);
	//カテゴリIDでリンク先を変更する。

	switch($category_id)
	{
		case 1:
			$url="arrival.php?pageNo=0&report_no=$report_no";
			$cat_img="arv.gif";
			$subject=arrival;
			break;
		case 2:
			$url="column.php?pageNo=0&report_no=$report_no";
			$cat_img="clm.gif";
			$subject=column;
			break;
		case 3:
			$url="press.php";
			break;
	}
	
	//print"$category_id:$url";
	$news_title=mb_substr($news_title,0,15);
	$news_link=$url;
	$item->title = $news_title;
	$item->subject = $subject;
	$item->link = "http://standardcalifornia.com/".$news_link;
	$item->description = stripslashes($description);
	$item->date = $news_date."T00:00:00";
	$item->source = "http://standardcalifornia.com/";
	$item->author = "STANDARD CALIFORNIA";
	
	$rss->addItem($item);

}

$rss->saveFeed("RSS1.0", "news/feed.xml");
?>