Revize 3f5d6df7
Přidáno uživatelem Michal Kliment před více než 4 roky(ů)
application/models/monitor_host.php | ||
---|---|---|
$order_by = 'INET_ATON(ip_address)';
|
||
|
||
return $this->db->query("
|
||
SELECT mh.*
|
||
SELECT mh.*, SUBSTRING_INDEX(GROUP_CONCAT(ip_address ORDER BY service DESC), ',', 1) AS ip_address
|
||
FROM
|
||
(
|
||
SELECT
|
||
... | ... | |
LEFT JOIN translations tr ON et.value = tr.original_term AND lang = 'cs'
|
||
LEFT JOIN users u ON d.user_id = u.id
|
||
LEFT JOIN members m ON u.member_id = m.id
|
||
ORDER BY service DESC, INET_ATON(ip_address)
|
||
) mh
|
||
$where
|
||
GROUP BY mh.device_id
|
Také k dispozici: Unified diff
refs #1148: Service IP address in monitoring