Changeset 11959

Timestamp:

2007/03/23 14:59:42 (17 years ago)

Author:

inoue

Message:

トラックバックのフロント部分

File:

• branches/dev/html/products/detail.php (modified) (2 diffs)

branches/dev/html/products/detail.php

@@ -172 +172 @@
 //¥ì¥Ó¥å¡¼¾ðÊó¤Î¼èÆÀ
 $objPage->arrReview = lfGetReviewData($tmp_id);
+// ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¾ðÊó¤Î¼èÆÀ
+$objPage->arrTrackback = lfGetTrackbackData($tmp_id);
+$objPage->trackback_url = TRACKBACK_TO_URL . $tmp_id;
 // ¥¿¥¤¥È¥ë¤Ë¾¦ÉÊ̾¤òÆþ¤ì¤ë
 $objPage->tpl_title = "¾¦Éʾܺ٠". $objPage->arrProduct["name"];
@@ -427 +430 @@
 }
 
+/*
+ * ¾¦Éʤ´¤È¤Î¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¾ðÊó¤ò¼èÆÀ¤¹¤ë
+ * 
+ * @param $product_id
+ * @return $arrTrackback
+ */
+function lfGetTrackbackData($product_id) {
+
+    $arrTrackback = array();
+
+    // ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯µ¡Ç½¤Î²ÔƯ¾õ¶·¥Á¥§¥Ã¥¯
+    if (sfGetSiteControlFlg(SITE_CONTROL_TRACKBACK) != 1) {
+        return $arrTrackback;
+    }   
+
+    $objQuery = new SC_Query;
+    //¾¦Éʤ´¤È¤Î¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¾ðÊó¤ò¼èÆÀ¤¹¤ë
+    $col = "blog_name, url, title, excerpt, title, create_date";
+    $from = "dtb_trackback";
+    $where = "del_flg = 0 AND status = 1 AND product_id = ? ORDER BY create_date DESC LIMIT " . TRACKBACK_VIEW_MAX;
+    $arrval[] = $product_id;
+    $arrTrackback = $objQuery->select($col, $from, $where, $arrval);
+    return $arrTrackback; 
+}
+
 //»ÙʧÊýË¡¤Î¼èÆÀ
 //payment_id    1:¥¯¥ì¥¸¥Ã¥È¡¡2:¥·¥ç¥Ã¥Ô¥ó¥°¥í¡¼¥ó