Index: /temp/trunk/html/rss/index.php
===================================================================
--- /temp/trunk/html/rss/index.php	(revision 6475)
+++ /temp/trunk/html/rss/index.php	(revision 6478)
@@ -39,10 +39,4 @@
 $objPage->email = $arrNews[0]['email'];
 
-//DESCRIPTION¤ò¥»¥Ã¥È
-$objPage->description = $objPage->description;
-
-//XML¥Õ¥¡¥¤¥ë¤Î¥¨¥ó¥³¡¼¥É¤ò¥»¥Ã¥È
-$objPage->encode = $objPage->encode;
-
 //¥»¥Ã¥È¤·¤¿¥Ç¡¼¥¿¤ò¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë¤Ë½ÐÎÏ
 $objView->assignobj($objPage);
@@ -51,11 +45,11 @@
 $objView->display($objPage->tpl_mainpage, true);
 
-//******************************************************************************************/
-/*
+//---------------------------------------------------------------------------------------------------------------------
+/***************************************************************************************************************
  * ´Ø¿ôÌ¾:lfGetNews
  * ÀâÌÀ¡¡:¿·Ãå¾ðÊó¤ò¼èÆÀ¤¹¤ë
  * °ú¿ô£±:$objQuery		DBÁàºî¥¯¥é¥¹
  * Ìá¤êÃÍ:$arrNews		¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
- */
+ ***************************************************************************************************************/
 function lfGetNews($objQuery){
 	$col = "";
Index: /temp/trunk/html/rss/product.php
===================================================================
--- /temp/trunk/html/rss/product.php	(revision 6475)
+++ /temp/trunk/html/rss/product.php	(revision 6478)
@@ -11,5 +11,5 @@
 class LC_Page{
 	function LC_Page(){
-		$this->tpl_mainpage = "rss/index.tpl";
+		$this->tpl_mainpage = "rss/product.tpl";
 		$this->encode = "UTF-8";
 		$this->description = "¿·Ãå¾ðÊó";
@@ -20,7 +20,11 @@
 $objPage = new LC_Page();
 $objView = new SC_SiteView();
+$objSiteInfo = new SC_SiteInfo();
+
+sfprintr($objSiteInfo);
+exit();
 
 //¿·Ãå¾ðÊó¤ò¼èÆÀ
-$arrNews = lfGetNews($objQuery);
+$arrProduct = lfGetProductsDetail($objQuery, 1);
 
 //¥­¥ã¥Ã¥·¥å¤·¤Ê¤¤(Ç°¤Î¤¿¤á)
@@ -30,18 +34,12 @@
 header("Content-type: application/xml");
 
-//¿·Ãå¾ðÊó¤ò¥»¥Ã¥È
-$objPage->arrNews = $arrNews;
+//¾¦ÉÊ¾ðÊó¤ò¥»¥Ã¥È
+$objPage->$arrProduct = $arrProduct;
 
 //Å¹Ì¾¤ò¥»¥Ã¥È
-$objPage->site_title = $arrNews[0]['shop_name'];
+$objPage->site_title = $arrProduct[0]['shop_name'];
 
 //ÂåÉ½Email¥¢¥É¥ì¥¹¤ò¥»¥Ã¥È
-$objPage->email = $arrNews[0]['email'];
-
-//DESCRIPTION¤ò¥»¥Ã¥È
-$objPage->description = $objPage->description;
-
-//XML¥Õ¥¡¥¤¥ë¤Î¥¨¥ó¥³¡¼¥É¤ò¥»¥Ã¥È
-$objPage->encode = $objPage->encode;
+$objPage->email = $arrProduct[0]['email'];
 
 //¥»¥Ã¥È¤·¤¿¥Ç¡¼¥¿¤ò¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë¤Ë½ÐÎÏ
@@ -51,12 +49,45 @@
 $objView->display($objPage->tpl_mainpage, true);
 
-//******************************************************************************************/
-/*
+//---------------------------------------------------------------------------------------------------------------------
+/**************************************************************************************************************
  * ´Ø¿ôÌ¾:lfGetProducts
  * ÀâÌÀ¡¡:¾¦ÉÊ¾ðÊó¤ò¼èÆÀ¤¹¤ë
  * °ú¿ô£±:$objQuery		DBÁàºî¥¯¥é¥¹
- * Ìá¤êÃÍ:$arrProduct		¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
- */
-function lfGetProducts($objQuery, $product_id){
+ * °ú¿ô£²:$product_id	¾¦ÉÊID
+ * Ìá¤êÃÍ:$arrProduct	¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
+ ***************************************************************************************************************/
+function lfGetProductsDetail($objQuery, $product_id){
+	$sql = "";
+	$sql .= "SELECT 
+				prod.product_id
+				,prod.name
+				,prod.category_id
+				,prod.point_rate
+				,prod.comment3
+				,prod.main_list_comment
+				,prod.main_list_image
+				,prod.main_comment
+				,prod.main_image
+				,prod.main_large_image
+				,cls.price01
+				,cls.price02
+				,(SELECT name FROM dtb_classcategory AS clscat WHERE clscat.classcategory_id = cls.classcategory_id1) AS classcategory_name1
+				,(SELECT name FROM dtb_classcategory AS clscat WHERE clscat.classcategory_id = cls.classcategory_id2) AS classcategory_name2
+				,(SELECT category_name FROM dtb_category AS cat WHERE cat.category_id = prod.category_id) AS category_name
+			FROM dtb_products AS prod, dtb_products_class AS cls
+			WHERE prod.product_id = cls.product_id AND prod.del_flg = 0 AND prod.status = 1 AND prod.product_id = ?
+			ORDER BY prod.product_id, cls.classcategory_id1, cls.classcategory_id2
+			";
+	$arrProduct = $objQuery->getall($sql, array($product_id));
+	return $arrProduct;
+}
+
+/***************************************************************************************************************
+ * ´Ø¿ôÌ¾:lfGetNews
+ * ÀâÌÀ¡¡:¿·Ãå¾ðÊó¤ò¼èÆÀ¤¹¤ë
+ * °ú¿ô£±:$objQuery		DBÁàºî¥¯¥é¥¹
+ * Ìá¤êÃÍ:$arrNews		¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
+ ***************************************************************************************************************/
+function lfGetShopData($objQuery){
 	$col = "";
 	$col .= "     news_id ";								//¿·Ãå¾ðÊóID
@@ -73,11 +104,12 @@
 	$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_produts";
+	$from = "dtb_news";
 	$where = "del_flg = '0'";
 	$order = "rank DESC";
 	$objQuery->setorder($order);
-	$arrProduct = $objQuery->select($col,$from,$where);
-	return $arrProduct;
+	$arrNews = $objQuery->select($col,$from,$where);
+	return $arrNews;
 }
 
+
 ?>
