Changeset 5610 for trunk/lib/model/blog.comment.php

Timestamp:

03/20/08 22:33:32 (10 months ago)

Author:

inureyes

Message:

#891

• 방명록 리스팅 추가
  
• 관련 메세지 추가
  
• 댓글/방명록/댓글알리미/받은 트랙백/보낸 트랙백 인터페이스 통합
  
• 새 컴 기념
  

Files:

• trunk/lib/model/blog.comment.php (modified) (2 diffs)

trunk/lib/model/blog.comment.php

@@ -49 +49 @@
 }
 
-function getCommentsWithPagingForOwner($blogid, $category, $name, $ip, $search, $page, $count) {
+function getCommentsWithPagingForOwner($blogid, $category, $name, $ip, $search, $page, $count, $isGuestbook = false) {
     global $database;
     
@@ -66 +66 @@
     } else
         $sql .= ' AND e.category >= 0';
+    if (!empty($name)) {
+        $sql .= ' AND c.name = \'' . POD::escapeString($name) . '\'';
+        $postfix .= '&name=' . rawurlencode($name);
+    }
+    if (!empty($ip)) {
+        $sql .= ' AND c.ip = \'' . POD::escapeString($ip) . '\'';
+        $postfix .= '&ip=' . rawurlencode($ip);
+    }
+    if (!empty($search)) {
+        $search = escapeSearchString($search);
+        $sql .= " AND (c.name LIKE '%$search%' OR c.homepage LIKE '%$search%' OR c.comment LIKE '%$search%')";
+        $postfix .= '&search=' . rawurlencode($search);
+    }
+    
+    $sql .= ' ORDER BY c.written DESC';
+    list($comments, $paging) = fetchWithPaging($sql, $page, $count);
+    if (strlen($postfix) > 0) {
+        $postfix .= '&withSearch=on';
+        $paging['postfix'] .= $postfix;
+    }
+
+    return array($comments, $paging);
+}
+
+function getGuestbookWithPagingForOwner($blogid, $name, $ip, $search, $page, $count) {
+    global $database;
+    
+    $postfix = '';
+    
+    $sql = "SELECT c.*, c2.name parentName 
+        FROM {$database['prefix']}Comments c 
+        LEFT JOIN {$database['prefix']}Comments c2 ON c.parent = c2.id AND c.blogid = c2.blogid 
+        WHERE c.blogid = $blogid AND c.entry = 0 AND c.isFiltered = 0";
     if (!empty($name)) {
         $sql .= ' AND c.name = \'' . POD::escapeString($name) . '\'';