Changeset 3321

Timestamp:

05/24/07 16:21:52 (18 months ago)

Author:

inureyes

Message:

#413

• 페이징 출력하도록 함.
  
• 관련한 쿼리들이 비만이라서 다이어트좀 시켰음.
  

#408

• 목록에서의 팀블로그 유저 이름을 list_rep_name 으로 변경.
  
• 관련하여 수정 예제 올릴 예정.
  

Location:

sandbox

Files:

• blog/search/index.php (modified) (1 diff)
• lib/model/blog.entry.php (modified) (4 diffs)
• lib/piece/blog/end.php (modified) (1 diff)
• lib/piece/blog/list.php (modified) (2 diffs)

sandbox/blog/search/index.php

@@ -17 +17 @@
     if ($suri['page'] === true || $suri['page'] === '1')
         $commentList = getCommentList($owner, $search);
+    $paging = $listWithPaging[1];
 }
 

sandbox/lib/model/blog.entry.php

@@ -100 +100 @@
     $tag = mysql_tt_escape_string($tag);
     $visibility = doesHaveOwnership() ? '' : 'AND e.visibility > 0 AND (c.visibility > 1 OR e.category = 0)';
-    $sql = "SELECT e.* 
+    $sql = "SELECT e.owner, e.id, e.title, e.comments, e.slogan, e.published
         FROM {$database['prefix']}Entries e 
         LEFT JOIN {$database['prefix']}TagRelations t ON e.id = t.entry AND e.owner = t.owner 
@@ -113 +113 @@
     $cond = "AND e.published >= " . getTimeFromPeriod($period) . " AND e.published < " . getTimeFromPeriod(addPeriod($period));
     $visibility = doesHaveOwnership() ? '' : 'AND e.visibility > 0 AND (c.visibility > 1 OR e.category = 0)';
-    $sql = "SELECT e.* 
+    $sql = "SELECT e.owner, e.id, e.title, e.comments, e.slogan, e.published
         FROM {$database['prefix']}Entries e
         LEFT JOIN {$database['prefix']}Categories c ON e.category = c.id AND e.owner = c.owner 
@@ -126 +126 @@
     $cond = empty($search) ? '' : "AND (title LIKE '%$search%' OR content LIKE '%$search%')";
     $visibility = doesHaveOwnership() ? '' : 'AND e.visibility > 1 AND (c.visibility > 1 OR e.category = 0)';
-    $sql = "SELECT e.* 
+    $sql = "SELECT e.owner, e.id, e.title, e.comments, e.slogan, e.published
         FROM {$database['prefix']}Entries e
         LEFT JOIN {$database['prefix']}Categories c ON e.category = c.id AND e.owner = c.owner 
@@ -182 +182 @@
 }
 
-function getEntriesWithPagingByNotice($owner, $page, $count) {
+function getEntriesWithPagingByNotice($owner, $page, $count, $countItem = null) {
     global $database, $folderURL, $suri;
     $visibility = doesHaveOwnership() ? '' : 'AND visibility = 2';
-    $sql = "SELECT *, '" . _text('공지') . "' categoryLabel FROM {$database['prefix']}Entries WHERE owner = $owner $visibility AND category = -2 ORDER BY published DESC";
-    return fetchWithPaging($sql, $page, $count, "$folderURL/{$suri['value']}");
+    $sql = "SELECT * 
+        FROM {$database['prefix']}Entries 
+        WHERE owner = $owner $visibility AND category = -2 
+        ORDER BY published DESC";
+    return fetchWithPaging($sql, $page, $count, "$folderURL/{$suri['value']}","?page=", $countItem);
 }
 

sandbox/lib/piece/blog/end.php

@@ -56 +56 @@
 dress('textcube_name', TEXTCUBE_NAME, $view);
 dress('textcube_version', TEXTCUBE_VERSION, $view);
+dress('tattertools_name', TEXTCUBE_NAME, $view);
+dress('tattertools_version', TEXTCUBE_VERSION, $view);
 if (isset($paging))
     dress('paging', getPagingView($paging, $skin->paging, $skin->pagingItem), $view);

sandbox/lib/piece/blog/list.php

@@ -10 +10 @@
         $teamblog_name = DBQuery::queryCell("SELECT b.name 
             FROM {$database['prefix']}TeamEntryRelations a, {$database['prefix']}Users b  
-            WHERE a.Owner=".$item['owner']." AND a.Id=".$item['id']." AND a.Team=b.userid");
+            WHERE a.owner=".$item['owner']." AND a.id=".$item['id']." AND a.team=b.userid");
         $itemsView .= str_replace(
             array(
                 '[##_list_rep_regdate_##]',
+                '[##_list_rep_name_##]',
                 '[##_list_rep_link_##]',
                 '[##_list_rep_title_##]',
@@ -20 +21 @@
             array(
                 fireEvent('ViewListDate', Timestamp::format3($item['published'])),
+                fireEvent('ViewListName', htmlspecialchars($teamblog_name)),
                 "$blogURL/" . ($blog['useSlogan'] ? 'entry/' . encodeURL($item['slogan']) : $item['id']),
-                htmlspecialchars('['.$teamblog_name.'] '. fireEvent('ViewListTitle', $item['title'])),
+                fireEvent('ViewListTitle', $item['title']),
                 ($item['comments'] > 0) ? "({$item['comments']})" : ''
             ),