diff options
author | Simon Rettberg | 2022-04-13 12:49:41 +0200 |
---|---|---|
committer | Simon Rettberg | 2022-04-13 12:49:41 +0200 |
commit | f0ef328db5fc34db87070dc83e3af9d382a74eed (patch) | |
tree | 659ddf697a91daf947b47f0eeda3627ce6929b9f /modules-available/statistics/pages/list.inc.php | |
parent | [inc/Database] Force more sql_mode options in debug mode (diff) | |
download | slx-admin-f0ef328db5fc34db87070dc83e3af9d382a74eed.tar.gz slx-admin-f0ef328db5fc34db87070dc83e3af9d382a74eed.tar.xz slx-admin-f0ef328db5fc34db87070dc83e3af9d382a74eed.zip |
[statistics] Add PCI device filter option
Diffstat (limited to 'modules-available/statistics/pages/list.inc.php')
-rw-r--r-- | modules-available/statistics/pages/list.inc.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/modules-available/statistics/pages/list.inc.php b/modules-available/statistics/pages/list.inc.php index d3c8069e..4d4da2b6 100644 --- a/modules-available/statistics/pages/list.inc.php +++ b/modules-available/statistics/pages/list.inc.php @@ -36,14 +36,14 @@ class SubPage if (Module::isAvailable('runmode')) { $xtra .= ', runmode.module AS rmmodule, runmode.isclient'; if (strpos($join, 'runmode') === false) { - $join .= ' LEFT JOIN runmode USING (machineuuid) '; + $join .= ' LEFT JOIN runmode ON (m.machineuuid = runmode.machineuuid) '; } } $res = Database::simpleQuery("SELECT m.machineuuid, m.locationid, m.macaddr, m.clientip, m.lastseen, m.logintime, m.state, m.currentuser, m.currentrunmode, m.realcores, m.mbram, m.kvmstate, m.cpumodel, m.id44mb, m.hostname, m.notes IS NOT NULL AS hasnotes, m.badsectors, Count(s.machineuuid) AS confvars $xtra FROM machine m - LEFT JOIN setting_machine s USING (machineuuid) + LEFT JOIN setting_machine s ON (m.machineuuid = s.machineuuid) $join WHERE $where GROUP BY m.machineuuid", $args); $rows = array(); $singleMachine = 'none'; |