key "rndc-key" {
        algorithm hmac-md5;
        secret "Nd1jgIAu3cjBQm/cttGv4A==";
 };
 controls {
        inet 127.0.0.1 port 953
                allow { 127.0.0.1; } keys { "rndc-key"; };
 };
 include "/usr/local/bind/etc/cnc.ip";
 include "/usr/local/bind/etc/other.ip";
 include "/usr/local/bind/etc/view.conf";

view "cnc_view" {
 
 match-clients           { CNC; };
 allow-query-cache       { none; };
 allow-recursion         { none; };
 allow-transfer          { none; };
 recursion               no;
 
 dlz "Mysql zone" {
   database "mysql
   {host=127.0.0.1 dbname=dns ssl=false port=3306 user=root pass= }
   {select zone from dns_records where zone = '%zone%' and view='CNC' limit 1}
   {select  ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') when lower(type) = 'soa' then  concat_ws(' ', data, resp_person, serial, refresh, retry, expire, minimum) else data end as mydata from dns_records where zone = '%zone%' and host = '%record%' and view='CNC'}
   {}
   {select  ttl, type, host, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') else data end as mydata, resp_person, serial, refresh, retry, expire, minimum from dns_records where zone = '%zone%' and view='CNC'}
   {select zone from xfr_table where zone = '%zone%' and client = '%client%' and view='CNC' limit 1}
   {update data_count set count = count + 1 where zone ='%zone%' and view='CNC'}";
 };
 
};
#yemaosheng.com
view "other_view" {
 
 match-clients           { other; };
 allow-query-cache       { none; };
 allow-recursion         { none; };
 allow-transfer          { none; };
 recursion               no;
 
 dlz "Mysql zone" {
   database "mysql
   {host=127.0.0.1 dbname=dns ssl=false port=3306 user=root pass= }
   {select zone from dns_records where zone = '%zone%' and view='other' limit 1}
   {select  ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') when lower(type) = 'soa' then  concat_ws(' ', data, resp_person, serial, refresh, retry, expire, minimum) else data end as mydata from dns_records where zone = '%zone%' and host = '%record%' and view='other'}
   {}
   {select  ttl, type, host, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') else data end as mydata, resp_person, serial, refresh, retry, expire, minimum from dns_records where zone = '%zone%' and view='other'}
   {select zone from xfr_table where zone = '%zone%' and client = '%client%' and view='other' limit 1}
   {update data_count set count = count + 1 where zone ='%zone%' and view='other'}";
 };
 
};