| | 33 | $postfix .= '&search=' . rawurlencode($search); |
| | 34 | } |
| | 35 | $sql .= ' ORDER BY t.written DESC'; |
| | 36 | list($trackbacks, $paging) = fetchWithPaging($sql, $page, $count); |
| | 37 | if (strlen($postfix) > 0) { |
| | 38 | $paging['postfix'] .= $postfix . '&withSearch=on'; |
| | 39 | } |
| | 40 | return array($trackbacks, $paging); |
| | 41 | } |
| | 42 | |
| | 43 | function getTrackbackLogsWithPagingForOwner($blogid, $category, $site, $ip, $search, $page, $count) { |
| | 44 | global $database; |
| | 45 | |
| | 46 | $postfix = ''; |
| | 47 | $sql = "SELECT t.*, e.title as subject, c.name categoryName |
| | 48 | FROM {$database['prefix']}TrackbackLogs t |
| | 49 | LEFT JOIN {$database['prefix']}Entries e ON t.blogid = e.blogid AND t.entry = e.id AND e.draft = 0 |
| | 50 | LEFT JOIN {$database['prefix']}Categories c ON t.blogid = c.blogid AND e.category = c.id |
| | 51 | WHERE t.blogid = $blogid"; |
| | 52 | if ($category > 0) { |
| | 53 | $categories = POD::queryColumn("SELECT id FROM {$database['prefix']}Categories WHERE blogid = $blogid AND parent = $category"); |
| | 54 | array_push($categories, $category); |
| | 55 | $sql .= ' AND e.category IN (' . implode(', ', $categories) . ')'; |
| | 56 | $postfix .= '&category=' . rawurlencode($category); |
| | 57 | } else |
| | 58 | $sql .= ' AND e.category >= 0'; |
| | 59 | if (!empty($search)) { |
| | 60 | $search = escapeSearchString($search); |
| | 61 | $sql .= " AND (e.title LIKE '%$search%' OR e.content LIKE '%$search%')"; |
