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