Revize 1366
Přidáno uživatelem Michal Kliment před více než 12 roky(ů)
| freenetis/branches/testing/application/models/monitor_host.php | ||
|---|---|---|
|
$order_by = 'INET_ATON(ip_address)';
|
||
|
|
||
|
return $this->db->query("
|
||
|
SELECT mh.*, GROUP_CONCAT(ip_address SEPARATOR '\n') AS ip_addresses
|
||
|
SELECT mh.*
|
||
|
FROM
|
||
|
(
|
||
|
SELECT
|
||
|
mh.*, d.name AS device_name,
|
||
|
ip_address, ip_address_id,
|
||
|
ip_address, ip_address_id, service,
|
||
|
CONCAT(
|
||
|
IF(
|
||
|
ap.name IS NOT NULL AND ap.name <> '', CONCAT(ap.name,' ('), ''
|
||
| ... | ... | |
|
GROUP BY mh.device_id
|
||
|
ORDER BY $order_by
|
||
|
", array(self::STATE_UNKNOWN, self::STATE_UP, __('Offline'), __('Online'), __('Unknown')));
|
||
|
|
||
|
die(debug::printr($this->db->last_query()));
|
||
|
}
|
||
|
|
||
|
/**
|
||
Také k dispozici: Unified diff
Odstraneni GROUP_CONCAT z funkce get_all_monitored_hosts => zpusoboval nezadouci nahodne vybrani IP adres.