vijinho /
f3-cms
| @@ 567-571 (lines=5) @@ | ||
| 564 | ||
| 565 | // get total results |
|
| 566 | $query = 'SELECT COUNT(*) AS results FROM ' . $db->quotekey($m->table()) . ' WHERE '; |
|
| 567 | if (empty($users_uuid)) { |
|
| 568 | $query .= join(' OR ', $sqlClauses); |
|
| 569 | } else { |
|
| 570 | $query .= ' users_uuid = ' . $db->quote($users_uuid) . ' AND ('. join(' OR ', $sqlClauses) . ')'; |
|
| 571 | } |
|
| 572 | $rows = $db->exec($query); |
|
| 573 | $rows = (int) $rows[0]['results']; |
|
| 574 | if ($rows < 1) { |
|
| @@ 640-644 (lines=5) @@ | ||
| 637 | ||
| 638 | // retrieve results |
|
| 639 | $query = 'SELECT * FROM ' . $db->quotekey($m->table()) . ' WHERE '; |
|
| 640 | if (empty($users_uuid)) { |
|
| 641 | $query .= join(' OR ', $sqlClauses); |
|
| 642 | } else { |
|
| 643 | $query .= ' users_uuid = ' . $db->quote($users_uuid) . ' AND ('. join(' OR ', $sqlClauses) . ')'; |
|
| 644 | } |
|
| 645 | $query .= sprintf(' LIMIT %d,%d', (1 == $page) ? 0 : ($page - 1) * $perPage, $perPage); |
|
| 646 | $results = $db->exec($query); |
|
| 647 | foreach ($results as $row) { |
|
| @@ 314-318 (lines=5) @@ | ||
| 311 | ||
| 312 | // retrieve results |
|
| 313 | $query = 'SELECT * FROM ' . $db->quotekey($m->table()) . ' WHERE '; |
|
| 314 | if (empty($users_uuid)) { |
|
| 315 | $query .= join(' OR ', $sqlClauses); |
|
| 316 | } else { |
|
| 317 | $query .= ' users_uuid = ' . $db->quote($users_uuid) . ' AND ('. join(' OR ', $sqlClauses) . ')'; |
|
| 318 | } |
|
| 319 | $query .= sprintf(' LIMIT %d,%d', (1 == $page) ? 0 : ($page - 1) * $perPage, $perPage); |
|
| 320 | $results = $db->exec($query); |
|
| 321 | foreach ($results as $row) { |
|
