Revize 53cf4ce8
Přidáno uživatelem Ondřej Fibich před téměř 8 roky(ů)
| application/models/ip_address.php | ||
|---|---|---|
|
JOIN messages_ip_addresses mip ON mip.ip_address_id = ip.id
|
||
|
");
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Same as previous method, but return unallowed ip addresses for a specific
|
||
|
* message type
|
||
|
*
|
||
|
* @author Ondrej Fibich
|
||
|
* @see Web_interface_Controller#unallowed_ip_addresses
|
||
|
* @param int $type message type constant
|
||
|
* @return type
|
||
|
*/
|
||
|
public function get_unallowed_ip_addresses_by_type($type)
|
||
|
{
|
||
|
return $this->db->query("
|
||
|
SELECT DISTINCT ip.ip_address
|
||
|
FROM ip_addresses ip
|
||
|
JOIN messages_ip_addresses mip ON mip.ip_address_id = ip.id
|
||
|
JOIN messages m ON m.id = mip.message_id
|
||
|
WHERE m.type = ?
|
||
|
", $type);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Function gets all ip address of interfaces of devices of users of given member.
|
||
Také k dispozici: Unified diff
Resolves #1060: implement filter for message type in Web interface unallowed_ip_addresses