Index: /temp/trunk/html/rss/index.php
===================================================================
--- /temp/trunk/html/rss/index.php	(revision 6473)
+++ /temp/trunk/html/rss/index.php	(revision 6474)
@@ -80,4 +80,33 @@
 	return $arrNews;
 }
-    
+
+/*
+ * ´Ø¿ô̾:lfGetProducts
+ * ÀâÌÀ¡¡:¾¦ÉʾðÊó¤ò¼èÆÀ¤¹¤ë
+ * °ú¿ô£±:$objQuery		DBÁàºî¥¯¥é¥¹
+ * Ìá¤êÃÍ:$arrNews		¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
+ */
+function lfGetProducts($objQuery, $product_id){
+	$col = "";
+	$col .= "     news_id ";								//¿·Ãå¾ðÊóID
+	$col .= "     ,news_title ";							//¿·Ãå¾ðÊ󥿥¤¥È¥ë
+	$col .= "     ,news_comment ";							//¿·Ãå¾ðÊóËÜʸ
+	$col .= "     ,to_char(news_date, 'YYYY') AS YEAR ";	//ÆüÉÕ(ǯ)
+	$col .= "     ,to_char(news_date, 'MM') AS MONTH ";		//ÆüÉÕ(·î)
+	$col .= "     ,to_char(news_date, 'DD') AS DAY ";		//ÆüÉÕ(Æü)
+	$col .= "     ,to_char(news_date, 'HH24') AS HOUR ";	//ÆüÉÕ(»þ´Ö)
+	$col .= "     ,to_char(news_date, 'MI') AS MINUTE ";	//ÆüÉÕ(ʬ)
+	$col .= "     ,to_char(news_date, 'SS') AS SECOND ";	//ÆüÉÕ(ÉÃ)
+	$col .= "     ,news_url ";								//¿·Ãå¾ðÊóURL
+	$col .= "     ,news_select ";							//¿·Ãå¾ðÊó¤Î¶èʬ(1:URL¡¢2:ËÜʸ)
+	$col .= "     ,(SELECT shop_name FROM dtb_baseinfo limit 1) AS shop_name  ";	//Ź̾
+	$col .= "     ,(SELECT email04 FROM dtb_baseinfo limit 1) AS email ";			//ÂåɽEmail¥¢¥É¥ì¥¹
+	$from = "dtb_news";
+	$where = "del_flg = '0'";
+	$order = "rank DESC";
+	$objQuery->setorder($order);
+	$arrNews = $objQuery->select($col,$from,$where);
+	return $arrNews;
+}
+
 ?>
Index: /temp/trunk/html/rss/product.php
===================================================================
--- /temp/trunk/html/rss/product.php	(revision 6474)
+++ /temp/trunk/html/rss/product.php	(revision 6474)
@@ -0,0 +1,112 @@
+<?php
+/*
+ * Copyright(c) 2000-2006 LOCKON CO.,LTD. All Rights Reserved.
+ *
+ * http://www.lockon.co.jp/
+ */
+
+//¶¦ÄÌÉôÉʤÎÆɤ߹þ¤ß
+require_once("../require.php");
+
+class LC_Page{
+	function LC_Page(){
+		$this->tpl_mainpage = "rss/index.tpl";
+		$this->encode = "UTF-8";
+		$this->description = "¿·Ãå¾ðÊó";
+	}
+}
+
+$objQuery = new SC_Query();
+$objPage = new LC_Page();
+$objView = new SC_SiteView();
+
+//¿·Ãå¾ðÊó¤ò¼èÆÀ
+$arrNews = lfGetNews($objQuery);
+
+//¥­¥ã¥Ã¥·¥å¤·¤Ê¤¤(Ç°¤Î¤¿¤á)
+header("Paragrama: no-cache");
+
+//XML¥Æ¥­¥¹¥È(¤³¤ì¤¬¤Ê¤¤¤ÈÀµ¾ï¤ËRSS¤È¤·¤Æǧ¼±¤·¤Æ¤¯¤ì¤Ê¤¤¥Ä¡¼¥ë¤¬¤¢¤ë¤¿¤á)
+header("Content-type: application/xml");
+
+//¿·Ãå¾ðÊó¤ò¥»¥Ã¥È
+$objPage->arrNews = $arrNews;
+
+//Ź̾¤ò¥»¥Ã¥È
+$objPage->site_title = $arrNews[0]['shop_name'];
+
+//ÂåɽEmail¥¢¥É¥ì¥¹¤ò¥»¥Ã¥È
+$objPage->email = $arrNews[0]['email'];
+
+//DESCRIPTION¤ò¥»¥Ã¥È
+$objPage->description = $objPage->description;
+
+//XML¥Õ¥¡¥¤¥ë¤Î¥¨¥ó¥³¡¼¥É¤ò¥»¥Ã¥È
+$objPage->encode = $objPage->encode;
+
+//¥»¥Ã¥È¤·¤¿¥Ç¡¼¥¿¤ò¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë¤Ë½ÐÎÏ
+$objView->assignobj($objPage);
+
+//²èÌÌɽ¼¨
+$objView->display($objPage->tpl_mainpage, true);
+
+//******************************************************************************************/
+/*
+ * ´Ø¿ô̾:lfGetNews
+ * ÀâÌÀ¡¡:¿·Ãå¾ðÊó¤ò¼èÆÀ¤¹¤ë
+ * °ú¿ô£±:$objQuery		DBÁàºî¥¯¥é¥¹
+ * Ìá¤êÃÍ:$arrNews		¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
+ */
+function lfGetNews($objQuery){
+	$col = "";
+	$col .= "     news_id ";								//¿·Ãå¾ðÊóID
+	$col .= "     ,news_title ";							//¿·Ãå¾ðÊ󥿥¤¥È¥ë
+	$col .= "     ,news_comment ";							//¿·Ãå¾ðÊóËÜʸ
+	$col .= "     ,to_char(news_date, 'YYYY') AS YEAR ";	//ÆüÉÕ(ǯ)
+	$col .= "     ,to_char(news_date, 'MM') AS MONTH ";		//ÆüÉÕ(·î)
+	$col .= "     ,to_char(news_date, 'DD') AS DAY ";		//ÆüÉÕ(Æü)
+	$col .= "     ,to_char(news_date, 'HH24') AS HOUR ";	//ÆüÉÕ(»þ´Ö)
+	$col .= "     ,to_char(news_date, 'MI') AS MINUTE ";	//ÆüÉÕ(ʬ)
+	$col .= "     ,to_char(news_date, 'SS') AS SECOND ";	//ÆüÉÕ(ÉÃ)
+	$col .= "     ,news_url ";								//¿·Ãå¾ðÊóURL
+	$col .= "     ,news_select ";							//¿·Ãå¾ðÊó¤Î¶èʬ(1:URL¡¢2:ËÜʸ)
+	$col .= "     ,(SELECT shop_name FROM dtb_baseinfo limit 1) AS shop_name  ";	//Ź̾
+	$col .= "     ,(SELECT email04 FROM dtb_baseinfo limit 1) AS email ";			//ÂåɽEmail¥¢¥É¥ì¥¹
+	$from = "dtb_news";
+	$where = "del_flg = '0'";
+	$order = "rank DESC";
+	$objQuery->setorder($order);
+	$arrNews = $objQuery->select($col,$from,$where);
+	return $arrNews;
+}
+
+/*
+ * ´Ø¿ô̾:lfGetProducts
+ * ÀâÌÀ¡¡:¾¦ÉʾðÊó¤ò¼èÆÀ¤¹¤ë
+ * °ú¿ô£±:$objQuery		DBÁàºî¥¯¥é¥¹
+ * Ìá¤êÃÍ:$arrNews		¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
+ */
+function lfGetProducts($objQuery, $product_id){
+	$col = "";
+	$col .= "     news_id ";								//¿·Ãå¾ðÊóID
+	$col .= "     ,news_title ";							//¿·Ãå¾ðÊ󥿥¤¥È¥ë
+	$col .= "     ,news_comment ";							//¿·Ãå¾ðÊóËÜʸ
+	$col .= "     ,to_char(news_date, 'YYYY') AS YEAR ";	//ÆüÉÕ(ǯ)
+	$col .= "     ,to_char(news_date, 'MM') AS MONTH ";		//ÆüÉÕ(·î)
+	$col .= "     ,to_char(news_date, 'DD') AS DAY ";		//ÆüÉÕ(Æü)
+	$col .= "     ,to_char(news_date, 'HH24') AS HOUR ";	//ÆüÉÕ(»þ´Ö)
+	$col .= "     ,to_char(news_date, 'MI') AS MINUTE ";	//ÆüÉÕ(ʬ)
+	$col .= "     ,to_char(news_date, 'SS') AS SECOND ";	//ÆüÉÕ(ÉÃ)
+	$col .= "     ,news_url ";								//¿·Ãå¾ðÊóURL
+	$col .= "     ,news_select ";							//¿·Ãå¾ðÊó¤Î¶èʬ(1:URL¡¢2:ËÜʸ)
+	$col .= "     ,(SELECT shop_name FROM dtb_baseinfo limit 1) AS shop_name  ";	//Ź̾
+	$col .= "     ,(SELECT email04 FROM dtb_baseinfo limit 1) AS email ";			//ÂåɽEmail¥¢¥É¥ì¥¹
+	$from = "dtb_news";
+	$where = "del_flg = '0'";
+	$order = "rank DESC";
+	$objQuery->setorder($order);
+	$arrNews = $objQuery->select($col,$from,$where);
+	return $arrNews;
+}
+
+?>