public function getMails($network_id){

        $w = db::get_array_list("SELECT * FROM `network` WHERE `id` IN (".$network_id.")");


        $sql = "SELECT";
        $sql .= "`e`.`ip_v4` as `ip`, ";
        $sql .= "`ad`.`samaccountname` as `samaccountname`, ";
        $sql .= "`ad`.`last_name` as `last_name`, ";
        $sql .= "`ad`.`first_name` as `first_name`, ";
        $sql .= "`ad`.`middle_name` as `middle_name`, ";
        $sql .= "`ad`.`mail` as `mail` ";
        $sql .= "FROM `event` AS `e` INNER JOIN `ad_data` as `ad` ON (`ad`.`samaccountname`=`e`.`user_name`) WHERE 1 AND ";
        $t = array();
        foreach($w as $k => $v){
            $t[] = " ((INET_ATON(`ip_v4`) & '{$v['netmask']}')='{$v['network']}') ";
        }
        $sql .= implode('OR', $t);
        $sql .= "GROUP BY `user_name`";

        return db::get_array_list($sql);
    }