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;} } }