function add_category_save()
{
include_once dirname(__FILE__) . "/ressources/class.ldap.inc";
$ldap = new clladp();
$dans = new dansguardian_rules();
$_POST["personal_database"] = strtolower($ldap->StripSpecialsChars($_POST["personal_database"]));
if ($_POST["personal_database"] == "security") {
$_POST["personal_database"] = "security2";
}
if (isset($dans->array_blacksites[$_POST["personal_database"]])) {
$tpl = new templates();
echo $tpl->javascript_parse_text("{category_already_exists}");
return;
}
if ($_POST["CatzByGroupA"] != null) {
$_POST["CatzByGroupL"] = $_POST["CatzByGroupA"];
}
$_POST["CatzByGroupL"] = addslashes($_POST["CatzByGroupL"]);
$_POST["category_text"] = addslashes($_POST["category_text"]);
$q = new mysql_squid_builder();
$sql = "SELECT category FROM personal_categories WHERE category='{$_POST["personal_database"]}'";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql));
if ($ligne["category"] != null) {
$sql = "UPDATE personal_categories \n\t\t\tSET category_description='{$_POST["category_text"]}',\n\t\t\tmaster_category='{$_POST["CatzByGroupL"]}'\n\t\t\tWHERE category='{$_POST["personal_database"]}'\n\t\t\t";
} else {
$sql = "INSERT IGNORE INTO personal_categories (category,category_description,master_category) \n\t\tVALUES ('{$_POST["personal_database"]}','{$_POST["category_text"]}','{$_POST["CatzByGroupL"]}');";
}
$q->QUERY_SQL($sql);
if (!$q->ok) {
echo $q->mysql_error;
return;
}
$q->CreateCategoryTable($_POST["personal_database"]);
$dans->CategoriesTableCache();
$dans->CleanCategoryCaches();
$sock = new sockets();
$sock->getFrameWork("squid.php?clean-catz-cache=yes");
$sock->getFrameWork("squid.php?export-web-categories=yes");
}
function add_category_save()
{
$_POST["personal_database"] = url_decode_special_tool($_POST["personal_database"]);
$_POST["category_text"] = url_decode_special_tool($_POST["category_text"]);
$org = $_POST["personal_database"];
include_once dirname(__FILE__) . "/ressources/class.html.tools.inc";
$html = new htmltools_inc();
$dans = new dansguardian_rules();
$_POST["personal_database"] = strtolower($html->StripSpecialsChars($_POST["personal_database"]));
if ($_POST["personal_database"] == null) {
echo "No category set or wrong category name \"{$org}\"\n";
return;
}
if ($_POST["personal_database"] == "security") {
$_POST["personal_database"] = "security2";
}
if ($_POST["CatzByGroupA"] != null) {
$_POST["CatzByGroupL"] = $_POST["CatzByGroupA"];
}
$_POST["CatzByGroupL"] = mysql_escape_string2($_POST["CatzByGroupL"]);
$_POST["category_text"] = url_decode_special_tool($_POST["category_text"]);
$_POST["category_text"] = mysql_escape_string2($_POST["category_text"]);
$q = new mysql_squid_builder();
$sql = "SELECT category FROM personal_categories WHERE category='{$_POST["personal_database"]}'";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql));
if ($ligne["category"] != null) {
$sql = "UPDATE personal_categories\n\t\tSET category_description='{$_POST["category_text"]}',\n\t\t`PublicMode`='{$_POST["PublicMode"]}',\n\t\tmaster_category='{$_POST["CatzByGroupL"]}'\n\t\tWHERE category='{$_POST["personal_database"]}'\n\t\t";
} else {
if (isset($dans->array_blacksites[$_POST["personal_database"]])) {
$tpl = new templates();
echo $tpl->javascript_parse_text("{$_POST["personal_database"]}:{category_already_exists}");
return;
}
$sql = "INSERT IGNORE INTO personal_categories (category,category_description,master_category,PublicMode)\n\t\tVALUES ('{$_POST["personal_database"]}','{$_POST["category_text"]}','{$_POST["CatzByGroupL"]}','{$_POST["PublicMode"]}');";
}
$q->QUERY_SQL($sql);
if (!$q->ok) {
echo $q->mysql_error;
return;
}
$q->CreateCategoryTable($_POST["personal_database"]);
$sql = "TRUNCATE TABLE webfilters_categories_caches";
$dans->CategoriesTableCache();
$dans->CleanCategoryCaches();
}
function free_refresh_catgorized(){
$tpl=new templates();
$dans=new dansguardian_rules();
$dans->CleanCategoryCaches();
$cats=$dans->LoadBlackListes();
while (list ($num, $ligne) = each ($cats) ){$newcat[$num]=$num;}
$newcat[null]="{select}";
echo $tpl->_ENGINE_parse_body(Field_array_Hash($newcat,"free-category-add",null,"free_catgorized_explain()","style:font-size:16px"));
}
