diff options
| author | Simon Rettberg | 2016-12-07 13:18:23 +0100 |
|---|---|---|
| committer | Simon Rettberg | 2016-12-07 13:18:23 +0100 |
| commit | 5a68ea106980a52850cc527da098f481223b07b1 (patch) | |
| tree | e5f90c716a984b16e74870d1decbe3c594e05fc3 /modules-available/roomplanner/page.inc.php | |
| parent | [js_selectize] Update to 0.12.4 - fixes search highlighting (diff) | |
| download | slx-admin-5a68ea106980a52850cc527da098f481223b07b1.tar.gz slx-admin-5a68ea106980a52850cc527da098f481223b07b1.tar.xz slx-admin-5a68ea106980a52850cc527da098f481223b07b1.zip | |
[roomplanner] Tighten up computer list, better search result caching
Diffstat (limited to 'modules-available/roomplanner/page.inc.php')
| -rw-r--r-- | modules-available/roomplanner/page.inc.php | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/modules-available/roomplanner/page.inc.php b/modules-available/roomplanner/page.inc.php index 1ddbdc30..a35023b9 100644 --- a/modules-available/roomplanner/page.inc.php +++ b/modules-available/roomplanner/page.inc.php @@ -94,7 +94,8 @@ class Page_Roomplanner extends Page . 'WHERE machineuuid LIKE :query ' . ' OR macaddr LIKE :query ' . ' OR clientip LIKE :query ' - . ' OR hostname LIKE :query ', ['query' => "%$query%"]); + . ' OR hostname LIKE :query ' + . ' LIMIT 100', ['query' => "%$query%"]); $returnObject = ['machines' => []]; @@ -268,8 +269,6 @@ class Page_Roomplanner extends Page $machines = []; while ($row = $result->fetch(PDO::FETCH_ASSOC)) { - // For searching - $row['combined'] = $row['machineuuid'] . ' ' . $row['macaddr'] . ' ' . $row['clientip'] . ' ' . $row['hostname']; $machines[] = $row; } |