|
@@ 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 = []; |