Changeset 3357

Timestamp:

05/25/07 21:37:23 (20 months ago)

Author:

inureyes

Message:

#237

• 트랙백 검색 기능 추가.
  
• 이후 여러 조건에 맞게 검색해주도록 통합 검색 모듈을 만들 필요가 있다.
  

Location:

sandbox

Files:

• blog/search/index.php (modified) (2 diffs)
• lib/blog.skin.php (modified) (1 diff)
• lib/model/blog.trackback.php (modified) (1 diff)
• lib/piece/blog/trackbackList.php (added)
• skin/tistory/skin.html (modified) (1 diff)
• skin/tistory/style.css (modified) (2 diffs)

sandbox/blog/search/index.php

@@ -17 +17 @@
     if ($suri['page'] === true || $suri['page'] === '1')
         $commentList = getCommentList($owner, $search);
+        $trackbackList = getTrackbackList($owner, $search);
     $paging = $listWithPaging[1];
 }
@@ -25 +26 @@
 require ROOT . '/lib/piece/blog/begin.php';
 require ROOT . '/lib/piece/blog/list.php';
-if ($suri['page'] === true || $suri['page'] === '1')
+if ($suri['page'] === true || $suri['page'] === '1'){
     require ROOT . '/lib/piece/blog/commentList.php';
+    require ROOT . '/lib/piece/blog/trackbackList.php';
+}
 require ROOT . '/lib/piece/blog/entries.php';
 require ROOT . '/lib/piece/blog/end.php';

sandbox/lib/blog.skin.php

@@ -165 +165 @@
         list($sval, $this->commentListItem) = $this->cutSkinTag($sval, 'rplist_rep');
         list($sval, $this->commentList) = $this->cutSkinTag($sval, 'rplist');
+        list($sval, $this->trackbackListItem) = $this->cutSkinTag($sval, 'tblist_rep');
+        list($sval, $this->trackbackList) = $this->cutSkinTag($sval, 'tblist');
         list($sval, $this->rss_rep) = $this->cutSkinTag($sval, 'rss_rep');
         list($sval, $this->rss_date) = $this->cutSkinTag($sval, 'rss_date');

sandbox/lib/model/blog.trackback.php

@@ -46 +46 @@
         array_push($trackbacks, $trackback);
     return $trackbacks;
+}
+
+function getTrackbackList($owner, $search) {
+    global $database;
+    $list = array('title' => "$search", 'items' => array());
+    $search = escapeMysqlSearchString($search);
+    $authorized = doesHaveOwnership() ? '' : ' AND (ct.visibility > 1 OR e.category = 0)';
+    if ($result = DBQuery::query("SELECT t.id, t.entry, t.url, t.site, t.subject, t.excerpt, t.written
+        FROM {$database['prefix']}Trackbacks t
+            LEFT JOIN {$database['prefix']}Entries e ON t.entry = e.id AND t.owner = e.owner
+            LEFT JOIN {$database['prefix']}Categories ct ON ct.id = e.category AND ct.owner = t.owner
+            WHERE t.entry > 0 AND t.owner = $owner $authorized and t.isFiltered = 0 and excerpt like '%$search%'")) {
+            while ($comment = mysql_fetch_array($result))
+                array_push($list['items'], $comment);
+    }   
+    return $list;
 }
 

sandbox/skin/tistory/skin.html

@@ -59 +59 @@
                 </div>
             </s_rplist>
+
+            <s_tblist>
+                <div class="searchTblist">
+                    <h3>'[##_tblist_conform_##]'에 해당되는 트랙백 [##_tblist_count_##]건</h3>
+                    <ol>
+                        <s_tblist_rep>
+                            <li>
+                                <span class="date">[##_tblist_rep_regdate_##]</span>
+                                <span class="name"><a href="[##_tblist_rep_link_##]">[##_tblist_rep_subject_##]</a></span>
+                                <div class="contents">[##_tblist_rep_body_##]</div>
+                            </li>
+                        </s_tblist_rep>
+                    </ol>
+                </div>
+            </s_tblist>
 
             <s_local>

sandbox/skin/tistory/style.css

@@ -157 +157 @@
 #content .guestbook, 
 #content .searchList, 
-#content .searchRplist      { padding:10px;}
+#content .searchRplist,
+#content .searchTblist      { padding:10px;}
 
 #content .localog h3, 
@@ -163 +164 @@
 #content .guestbook h3, 
 #content .searchList h3, 
-#content .searchRplist h3   { border-bottom:1px solid #ccc;  margin-bottom:10px;  color:#222;}
+#content .searchRplist h3,
+#content .searchTblist h3   { border-bottom:1px solid #ccc;  margin-bottom:10px;  color:#222;}
 
 .searchList ol, 
-.searchRplist ol            { list-style:none;  padding:5px;  margin:0;}
+.searchRplist ol,
+.searchTblist ol            { list-style:none;  padding:5px;  margin:0;}
 .searchList li, 
-.searchRplist li            { border-bottom:1px solid #eee;  padding-bottom:2px;  margin-bottom:4px;}
+.searchRplist li,
+.searchTblist li            { border-bottom:1px solid #eee;  padding-bottom:2px;  margin-bottom:4px;}
 .searchList .date, 
-.searchRplist .date         { font:0.95em Verdana, Helvetica, Arial, Gulim, sans-serif;  margin-right:10px; }
+.searchRplist .date,
+.searchTblist .date         { font:0.95em Verdana, Helvetica, Arial, Gulim, sans-serif;  margin-right:10px; }
 .searchList .cnt            { font:0.75em Verdana, Helvetica, Arial, Gulim, sans-serif;  color:#f60;} 
-.searchRplist .name         { font:0.95em Dotum, Arial, sans-serif;    color:#999;  padding-left:8px;}
+.searchRplist .name,
+.searchTblist .subject      { font:0.95em Dotum, Arial, sans-serif;    color:#999;  padding-left:8px;}
 
 .localog .spot              { background:url(images/iconIndentArrow_local.gif) 5px 0 no-repeat;  padding-left:20px;  margin-top:5px;}