function add_white_single()
{
$q = new mysql_squid_builder();
$acl = new squid_acls();
$IP = new IP();
$sql = "CREATE TABLE IF NOT EXISTS `privoxy_whitelist` (\n\t\t\t\t`items` VARCHAR(256) NOT NULL PRIMARY KEY\n\t\t\t\t) ENGINE=MYISAM;";
$q->QUERY_SQL($sql, "artica_backup");
$www = $_POST["whitelist-single"];
$www = $acl->dstdomain_parse($www);
if ($www == null) {
return;
}
$q->QUERY_SQL("INSERT IGNORE INTO privoxy_whitelist (items) VALUES ('{$www}')", "artica_backup");
if (!$q->ok) {
echo $q->mysql_error;
return;
}
}
function add_nocache_save()
{
$table = "denycache_websites";
$q = new mysql_squid_builder();
$q1 = new mysql_squid_builder();
$acl = new squid_acls();
$IP = new IP();
$sql = "CREATE TABLE IF NOT EXISTS `deny_cache_domains` (\n\t\t\t\t`items` VARCHAR(256) NOT NULL PRIMARY KEY\n\t\t\t\t) ENGINE=MYISAM;";
$q->QUERY_SQL($sql);
$tr = explode("\n", $_POST["nocache"]);
$q->QUERY_SQL("TRUNCATE TABLE deny_cache_domains", "artica_backup");
while (list($none, $www) = each($tr)) {
$www = trim(strtolower($www));
if ($www == null) {
continue;
}
if (!$IP->isIPAddressOrRange($www)) {
if (substr($www, 0, 1) != "^") {
$www = $acl->dstdomain_parse($www);
}
}
$q->QUERY_SQL("INSERT IGNORE INTO deny_cache_domains (items) VALUES ('{$www}')", "artica_backup");
if (!$q->ok) {
echo $q->mysql_error;
return;
}
}
}
function biglock(){
$table="deny_websites";
$q=new mysql_squid_builder();
$tpl=new templates();
$acl=new squid_acls();
if(strpos($_POST["biglock"], ",")>0){
$tr=explode(",",$_POST["biglock"]);
}else{
$tr[]=$_POST["biglock"];
}
$sql="CREATE TABLE IF NOT EXISTS `deny_websites` ( `items` VARCHAR( 255 ) NOT NULL PRIMARY KEY ) ENGINE=MYISAM;";
$q->QUERY_SQL($sql);
while (list ($none,$www ) = each ($tr) ){
$www=$acl->dstdomain_parse($www);
if($www==null){continue;}
$q->QUERY_SQL("INSERT IGNORE INTO deny_websites (items) VALUES ('{$_POST["biglock"]}')");
if(!$q->ok){echo $q->mysql_error;return;}
}
echo $tpl->javascript_parse_text("{blacklist}\n".@implode("\n", $tr)."\n{success}.",1);
$sock=new sockets();
$sock->getFrameWork("squid.php?build-blacklist=yes");
}
function add_nocache_save(){
$table="denycache_websites";
$q=new mysql_squid_builder();
$q1=new mysql_squid_builder();
$acl=new squid_acls();
$IP=new IP();
$tr=explode("\n",$_POST["nocache"]);
$q->QUERY_SQL("TRUNCATE TABLE denycache_websites","artica_backup");
while (list ($none,$www ) = each ($tr) ){
$www=$acl->dstdomain_parse($www);
if($www==null){continue;}
$q->QUERY_SQL("INSERT IGNORE INTO denycache_websites (items) VALUES ('{$www}')","artica_backup");
if(!$q->ok){echo $q->mysql_error;return;}
}
}
