@@ 87-91 (lines=5) @@ | ||
84 | $params[] = $group; |
|
85 | } |
|
86 | $deletedSql = ''; |
|
87 | if ($deleted !== false) { |
|
88 | $deleted = (int) $deleted; |
|
89 | $deletedSql = 'and n.deleted = ?'; |
|
90 | $params[] = $deleted; |
|
91 | } |
|
92 | $sql = "SELECT id, uid, name, grouping, shared, mtime, deleted, note FROM *PREFIX*ownnote n WHERE `uid` = ? $groupSql $deletedSql"; |
|
93 | $results = []; |
|
94 | foreach ($this->execute($sql, $params)->fetchAll() as $item) { |
|
@@ 119-123 (lines=5) @@ | ||
116 | } |
|
117 | ||
118 | $deletedSql = ''; |
|
119 | if ($deleted !== false) { |
|
120 | $deleted = (int) $deleted; |
|
121 | $deletedSql = 'and n.deleted = ?'; |
|
122 | $params[] = $deleted; |
|
123 | } |
|
124 | ||
125 | $sql = "SELECT n.uid, n.id, n.name, n.grouping, n.shared, n.mtime, n.deleted, p.pid, GROUP_CONCAT(p.note SEPARATOR '') as note FROM *PREFIX*ownnote n INNER JOIN *PREFIX*ownnote_parts p ON n.id = p.id WHERE n.deleted = 0 $uidSql and n.grouping = ? GROUP BY p.id"; |
|
126 | $results = []; |