function query(){
$tpl=new templates();
$also=$tpl->_ENGINE_parse_body("{also}");
$MyPage=CurrentPageName();
$q=new mysql_squid_builder();
$nowebsites=$tpl->_ENGINE_parse_body("{no_saved_web_site_catz}");
$category=null;
if($category==null){if($_GET["category"]<>null){$category=$_GET["category"];$_POST["qtype"]="pattern";}}
if($category==null){if($_POST["qtype"]<>null){$category=$_POST["qtype"];$_POST["qtype"]="pattern";}}
writelogs("Category:$category",__FUNCTION__,__FILE__,__LINE__);
if($_POST["query"]<>null){if($_GET["website"]<>null){$_POST["query"]=$_GET["website"];}}
if($category==null){json_error_show("Please select a category first");}
if($_POST["sortname"]=="sitename"){$_POST["sortname"]="zDate";$_POST["sortorder"]="desc";}
writelogs("Category:$category",__FUNCTION__,__FILE__,__LINE__);
$table="category_".$q->category_transform_name($category);
$search='%';
$page=1;
$COUNT_ROWS=$q->COUNT_ROWS($table);
if($COUNT_ROWS==0){json_error_show("category:$category ,Table: $table, $nowebsites",1);}
if(isset($_POST["sortname"])){if($_POST["sortname"]<>null){$ORDER="ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";}}
if (isset($_POST['page'])) {$page = $_POST['page'];}
$_POST["query"]=trim($_POST["query"]);
$searchstring=string_to_flexquery();
if($searchstring<>null){
$orgQuery=$_POST["query"];
$sql="SELECT COUNT(zmd5) as TCOUNT FROM `$table` WHERE 1 $searchstring";
$ligne=mysql_fetch_array($q->QUERY_SQL($sql,"artica_backup"));
$total = $ligne["TCOUNT"];
}else{
$total = $q->COUNT_ROWS($table);
}
if (isset($_POST['rp'])) {$rp = $_POST['rp'];}
$pageStart = ($page-1)*$rp;
$limitSql = "LIMIT $pageStart, $rp";
$sql="SELECT zDate,zmd5,pattern,enabled FROM `$table` WHERE 1 $searchstring $ORDER $limitSql";
writelogs($sql,__FUNCTION__,__FILE__,__LINE__);
$results = $q->QUERY_SQL($sql);
if(!$q->ok){json_error_show($q->mysql_error,1);}
if(mysql_num_rows($results)==0){json_error_show("$nowebsites",1);}
$disabled_text=$tpl->_ENGINE_parse_body("{disabled}");
$CategoriesCheckRightsWrite=CategoriesCheckRightsWrite();
$data = array();
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
if($orgQuery<>null){$moveAll=imgtootltip("arrow-multiple-right-24.png","{move}","MoveAllCategorizedWebsite2('$category','$table','$orgQuery')");}
while ($ligne = mysql_fetch_assoc($results)) {
$delete=imgtootltip("delete-24.png","{delete}","DeleteCategorizedWebsite('{$ligne["zmd5"]}','$table')");
$move=imgtootltip("arrow-right-24.png","{move}","MoveCategorizedWebsite('{$ligne["zmd5"]}','{$ligne["pattern"]}','$category','$table')");
$added=null;
/*$categories=$q->GET_CATEGORIES($ligne["pattern"],true,true,true);
writelogs("{$ligne["pattern"]}= $categories ",__FUNCTION__,__FILE__,__LINE__);
$categories=str_replace($category, "", $categories);
$ff=explode(",",$categories);
$tt=array();
while (list ($a, $b) = each ($ff) ){if(trim($b)==null){continue;}$tt[]= $b;}
if(count($tt)>0){
$added="<div><i style='font-size:11px'>$also: ".@implode(", ", $tt)."</i></div>";
}
*/
$enabled=$ligne["enabled"];
$color="color:black";
if($enabled==0){
$color="color:#B6ACAC";
$added=$added."<div><i style='font-size:11px'>$disabled_text</i></div>";
$moveAll=" ";
$move=" ";
$delete=imgtootltip("delete-24.png","{delete}","ReallyDeleteCategorizedWebsite('{$ligne["zmd5"]}','$table')");
}
$jscat="<a href=\"javascript:blur();\"
OnClick=\"javascript:Loadjs('squid.categorize.php?www={$ligne["pattern"]}');\"
style='font-size:14px;text-decoration:underline;$color'>";
if(!$CategoriesCheckRightsWrite){
$jscat=null;
$moveAll=null;
$move=null;
$delete=null;
}
$data['rows'][] = array(
'id' => $ligne['zmd5'],
'cell' => array("
<span style='font-size:16px;$color'>{$ligne['zDate']}</span>",
"<span style='font-size:16px;$color'>$jscat{$ligne['pattern']}</a></span>$added",$moveAll,
$move,$delete)
);
}
echo json_encode($data);
return;
$page=CurrentPageName();
$tpl=new templates();
$category=$_GET["category"];
if($category==null){return;}
$q=new mysql_squid_builder();
$tableN="category_".$q->category_transform_name($category);
$strictSearch=$_GET["strictSearch"];
if(!is_numeric($strictSearch)){$strictSearch=0;}
$searchOrg=$_GET["search"];
if($_GET["search"]<>null){
$search=$_GET["search"];
if($strictSearch==0){$search="*$search*";}
$search=str_replace("**", "*", $search);
$search=str_replace("**", "*", $search);
$search=str_replace("*", "%", $search);
$search=" AND pattern LIKE '$search'";
}
$sql="SELECT * FROM $tableN WHERE enabled=1 $search ORDER BY pattern LIMIT 0,25 ";
$table="<center>
<table cellspacing='0' cellpadding='0' border='0' class='tableView' style='width:350px'>
<thead class='thead'>
<tr>
<th width=1%>{website} $category</th>
<th>{date}</th>
<th>$moveall</th>
<th> </th>
</tr>
</thead>
<tbody>";
$results=$q->QUERY_SQL($sql);
$number=mysql_num_rows($results);
if($number==0){
if($searchOrg<>null){
if(strpos($searchOrg, "*")==0){
$html="
<center style='margin:30px'>
<div style='font-size:16px;margin-bottom:15px'><code>«http://$searchOrg» {in} «$category»</code></div>
<div style='font-size:14px'><a href=\"javascript:blur();\"
OnClick=\"javascript:Loadjs('squid.visited.php?add-www=yes&websitetoadd=$searchOrg')\"
style='font-size:14px;font-weight:bold;text-decoration:underline'
>{webiste_notfound_additask}</a>
</div>
</center>
<script>LoadAjaxTiny('subtitles-categories','$page?subtitles-categories=yes');</script>
";
echo $tpl->_ENGINE_parse_body($html);
return;
}
}
}
if(!$q->ok){echo "<H2>$q->mysql_error</H2><center style='font-size:11px'><code>$sql</code></center>";}
while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){
if($classtr=="oddRow"){$classtr=null;}else{$classtr="oddRow";}
if($ligne["pattern"]==null){$q->QUERY_SQL("DELETE FROM $tableN WHERE zmd5='{$ligne["zmd5"]}'");continue;}
$jscat="<a href=\"javascript:blur();\"
OnClick=\"javascript:Loadjs('squid.categorize.php?www={$ligne["pattern"]}');\"
style='font-size:14px;text-decoration:underline'>";
$table=$table."
<tr class=$classtr>
<td style='width:1%;font-size:14px' nowrap>{$ligne["zDate"]}</td>
<td style='width:1%;font-size:14px' nowrap>$jscat{$ligne["pattern"]}</a></td>
<td>$move</td>
<td>$delete</td>
</tr>
";
}
$table=$table."</tbody></table>
<script>
LoadAjaxTiny('subtitles-categories','$page?subtitles-categories=yes');
</script>
";
echo $tpl->_ENGINE_parse_body($table);
}
function query(){
$category=null;
$tpl=new templates();
$also=$tpl->_ENGINE_parse_body("{also}");
$MyPage=CurrentPageName();
$q=new mysql_squid_builder();
$nowebsites=$tpl->_ENGINE_parse_body("{no_saved_web_site_catz}");
writelogs("Category:$category",__FUNCTION__,__FILE__,__LINE__);
if($category==null){if($_GET["category"]<>null){$category=$_GET["category"];}}
if($category==null){if($_POST["qtype"]<>null){$category=$_POST["qtype"];}}
if($_POST["query"]<>null){if($_GET["website"]<>null){$_POST["query"]=$_GET["website"];}}
if($category==null){json_error_show("Please select a category first");}
if($_POST["sortname"]=="sitename"){$_POST["sortname"]="zDate";$_POST["sortorder"]="desc";}
writelogs("Category:$category",__FUNCTION__,__FILE__,__LINE__);
$table="categoryuris_".$q->category_transform_name($category);
$CategoriesCheckRightsWrite=CategoriesCheckRightsWrite();
$q->CreateCategoryUrisTable(null,$table);
$search='%';
$page=1;
$COUNT_ROWS=$q->COUNT_ROWS($table);
if($COUNT_ROWS==0){json_error_show("no data",1);}
if(isset($_POST["sortname"])){if($_POST["sortname"]<>null){$ORDER="ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";}}
if (isset($_POST['page'])) {$page = $_POST['page'];}
$searchstring=string_to_flexquery();
if($searchstring<>null){
$sql="SELECT COUNT(zmd5) as TCOUNT FROM `$table` WHERE 1 $searchstring";
$ligne=mysql_fetch_array($q->QUERY_SQL($sql,"artica_backup"));
$total = $ligne["TCOUNT"];
}else{
$total = $q->COUNT_ROWS($table);
}
if (isset($_POST['rp'])) {$rp = $_POST['rp'];}
$pageStart = ($page-1)*$rp;
$limitSql = "LIMIT $pageStart, $rp";
$sql="SELECT zDate,zmd5,pattern,enabled FROM `$table` WHERE 1 $searchstring $ORDER $limitSql";
$results = $q->QUERY_SQL($sql);
if(!$q->ok){json_error_show($q->mysql_error,1);}
if(mysql_num_rows($results)==0){json_error_show("$nowebsites",1);}
$disabled_text=$tpl->_ENGINE_parse_body("{disabled}");
$data = array();
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
while ($ligne = mysql_fetch_assoc($results)) {
$delete=imgtootltip("delete-24.png","{delete}","DeleteCategorizedURI('{$ligne["zmd5"]}','$table')");
$enabled=$ligne["enabled"];
$color="color:black";
if($enabled==0){
$color="color:#B6ACAC";
$added=$added."<div><i style='font-size:11px'>$disabled_text</i></div>";
$moveAll=" ";
$move=" ";
}
$jscat="<a href=\"javascript:blur();\"
OnClick=\"javascript:Loadjs('squid.categorize.php?www={$ligne["pattern"]}');\"
style='font-size:14px;text-decoration:underline;$color'>";
if(!$CategoriesCheckRightsWrite){
$jscat=null;
$delete=null;
}
$data['rows'][] = array(
'id' => $ligne['zmd5'],
'cell' => array("
<span style='font-size:14px;$color'>{$ligne['zDate']}</span>",
"<span style='font-size:14px;$color'>$jscat{$ligne['pattern']}</a></span>$added",$delete)
);
}
echo json_encode($data);
}
function categories_search()
{
$MyPage = CurrentPageName();
$page = CurrentPageName();
$tpl = new templates();
$sock = new sockets();
$q = new mysql_squid_builder();
$dans = new dansguardian_rules();
$EnableWebProxyStatsAppliance = $sock->GET_INFO("EnableWebProxyStatsAppliance");
if (!is_numeric($EnableWebProxyStatsAppliance)) {
$EnableWebProxyStatsAppliance = 0;
}
$t = $_GET["t"];
$OnlyPersonal = 0;
$rp = 200;
if (isset($_GET["artica"])) {
$artica = true;
}
if (!$q->BD_CONNECT()) {
json_error_show("Testing connection to MySQL server failed...", 1);
}
$sql = "SELECT * FROM personal_categories WHERE `PublicMode`=1";
$table = "personal_categories";
$searchstring = string_to_flexquery();
$page = 1;
if (isset($_POST["sortname"])) {
if ($_POST["sortname"] != null) {
$ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";
}
}
if (isset($_POST['page'])) {
$page = $_POST['page'];
}
if ($searchstring != null) {
$sql = "SELECT COUNT( * ) AS tcount FROM {$table} WHERE PublicMode=1 {$searchstring}";
writelogs($sql, __FUNCTION__, __FILE__, __LINE__);
$ligne = mysql_fetch_array($q->QUERY_SQL($sql, "artica_backup"));
if (!$q->ok) {
json_error_show("Mysql Error [" . __LINE__ . "]: {$q->mysql_error}.<br>{$sql}", 1);
}
$total = $ligne["tcount"];
} else {
$sql = "SELECT COUNT( * ) AS tcount FROM {$table} WHERE PublicMode=1";
writelogs($sql, __FUNCTION__, __FILE__, __LINE__);
$ligne = mysql_fetch_array($q->QUERY_SQL($sql, "artica_backup"));
if (!$q->ok) {
json_error_show("Mysql Error [" . __LINE__ . "]: {$q->mysql_error}.<br>{$sql}", 1);
}
$total = $ligne["tcount"];
}
if (isset($_POST['rp'])) {
$rp = $_POST['rp'];
}
$pageStart = ($page - 1) * $rp;
$limitSql = "LIMIT {$pageStart}, {$rp}";
$sql = "SELECT * FROM {$table} WHERE PublicMode=1 {$searchstring} {$ORDER} {$limitSql} ";
writelogs("{$q->mysql_admin}:{$q->mysql_password}:{$sql}", __FUNCTION__, __FILE__, __LINE__);
$results = $q->QUERY_SQL($sql);
if (!$q->ok) {
if ($q->mysql_error != null) {
json_error_show(date("H:i:s") . "<br>SORT:{$_POST["sortname"]}:<br>Mysql Error [L." . __LINE__ . "]: {$q->mysql_error}<br>{$sql}", 1);
}
}
if (mysql_num_rows($results) == 0) {
json_error_show("Not found...", 1);
}
$data = array();
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
$enc = new mysql_catz();
$field = "category";
$field_description = "category_description";
$CATZ_ARRAY = unserialize(@file_get_contents("/home/artica/categories_databases/CATZ_ARRAY"));
$CategoriesCheckRightsWrite = CategoriesCheckRightsWrite();
$TransArray = $enc->TransArray();
while (list($tablename, $items) = each($CATZ_ARRAY)) {
if (!isset($TransArray[$tablename])) {
continue;
}
$CATZ_ARRAY2[$TransArray[$tablename]] = $items;
}
while ($ligne = mysql_fetch_assoc($results)) {
$color = "black";
$categorykey = $ligne["category"];
if ($categorykey == null) {
$categorykey = "UnkNown";
}
//Array ( [category] => [category_description] => Ma catégorie [master_category] => [sended] => 1 )
if ($GLOBALS["VERBOSE"]) {
echo "Found {$field}:{$categorykey}<br>\n";
}
$categoryname = $categorykey;
$text_category = null;
$table = $q->cat_totablename($categorykey);
if ($GLOBALS["VERBOSE"]) {
echo "Scanning table {$table}<br>\n";
}
$itemsEncTxt = null;
$items = $q->COUNT_ROWS($table);
if (!preg_match("#^category_(.+)#", $table, $re)) {
continue;
}
$compile = imgsimple("compile-distri-32.png", "{saveToDisk}", "DansGuardianCompileDB('{$categoryname}')");
if ($dans->array_pics[$categoryname] != null) {
$pic = "<img src='img/{$dans->array_pics[$categoryname]}'>";
} else {
$pic = " ";
}
$sizedb_org = $q->TABLE_SIZE($table);
$sizedb = FormatBytes($sizedb_org / 1024);
$linkcat = "<a href=\"javascript:blur();\" OnClick=\"javascript:Loadjs('squid.categories.php?category={$categoryname}&t={$t}',true)\"\n\t\t\tstyle='font-size:18px;font-weight:bold;color:{$color};text-decoration:underline'>";
$text_category = $tpl->_ENGINE_parse_body(utf8_decode($ligne[$field_description]));
$text_category = trim($text_category);
$linkcat = "<a href=\"javascript:blur();\" OnClick=\"javascript:Loadjs('{$MyPage}?add-perso-cat-js=yes&cat={$categoryname}&t={$t}',true)\"\n\t\t\tstyle='font-size:18px;font-weight:bold;color:{$color};text-decoration:underline'>";
$viewDB = imgsimple("mysql-browse-database-32.png", null, "javascript:Loadjs('squid.categories.php?category={$categoryname}',true)");
$text_category = utf8_encode($text_category);
$categoryname_text = utf8_encode($categoryname);
$categoryText = $tpl->_ENGINE_parse_body("<span style='font-size:26px';font-weight:bold'>{$linkcat}{$categoryname_text}</div>\n\t\t\t\t\t</a><br><span style='font-size:18px;width:100%;font-weight:normal'>{$text_category}</div>");
$itemsEncTxt = "<span style='font-size:32px;font-weight:bold'>" . numberFormat($items, 0, "", " ");
"</span>";
$compile = imgsimple("compile-distri-48.png", null, "DansGuardianCompileDB('{$categoryname}')");
$delete = imgsimple("dustbin-48.png", null, "TableCategoryPurge('{$table}')");
if ($categoryname == "UnkNown") {
$linkcat = null;
$delete = imgsimple("delete-48.png", null, "TableCategoryPurge('')");
}
if (!$CategoriesCheckRightsWrite) {
$compile = null;
}
$cell = array();
$cell[] = $categoryText;
$cell[] = $itemsEncTxt;
$cell[] = $compile;
$data['rows'][] = array('id' => $ligne['ID'], 'cell' => $cell);
}
echo json_encode($data);
}
function popup()
{
$tpl = new templates();
$TB_WIDTH = 915;
$users = new usersMenus();
$page = CurrentPageName();
$t = time();
$uri = $tpl->_ENGINE_parse_body("{url}");
$date = $tpl->_ENGINE_parse_body("{date}");
$movetext = $tpl->_ENGINE_parse_body("{move}");
$moveall = $tpl->_ENGINE_parse_body("{move} {all}");
$select = $tpl->_ENGINE_parse_body("{select}");
$add_websites = $tpl->_ENGINE_parse_body("{add_urls}");
$category = $_GET["category"];
$q = new mysql_meta();
$searchitem = null;
$category_text = $tpl->_ENGINE_parse_body("{category}");
$removedAll = $tpl->javascript_parse_text("{delete_all}");
$removedisabled_warn = $tpl->javascript_parse_text("{remove_disabled_items_warn}");
$CategoriesCheckRightsWrite = CategoriesCheckRightsWrite();
$export = $tpl->javascript_parse_text("{export}");
$xls = "{name: '<strong style=font-size:18px>{$export}:CSV</strong>', bclass: 'xls', onpress : xls{$t}},";
$RemoveEnabled = "{name: '<strong style=font-size:18px>{$removedAll}</strong>', bclass: 'Delz', onpress : DeleteAll{$t}},";
$BUTTON_ADD = "{name: '<strong style=font-size:18px>{$add_websites}</strong>', bclass: 'Add', onpress : AddWebSites{$t}},";
$xls = null;
if (!$CategoriesCheckRightsWrite) {
$RemoveEnabled = null;
$BUTTON_ADD = null;
}
$buttons = "buttons : [\n\t\t\t{$RemoveEnabled}\n\t\t\t\t],\t";
if ($_GET["middlesize"] == "yes") {
$TB_WIDTH = 915;
}
if ($_GET["category"] != null) {
$table_title = "{$category_text}::{$category}";
$buttons = "buttons : [\n\t\t\t{$BUTTON_ADD}\n\t\t\t{$RemoveEnabled} {$xls}\n\t\t\t\t],";
$searchitem = "\tsearchitems : [\n\t\t{display: '{$uri}', name : 'pattern'}\n\t\t],";
}
$rowebsite = 461;
if (isset($_GET["rowebsite"])) {
$rowebsite = $_GET["rowebsite"];
$rowebsite = $rowebsite - 40;
}
echo "\n\n<div style='margin-left:-15px'>\n\t<table class='{$t}' style='display: none' id='{$t}' style='width:99%;'></table>\n</div>\n<script>\nvar MEMMD{$t}='';\n\$(document).ready(function(){\n\$('#{$t}').flexigrid({\n\turl: '{$page}?query=yes&category={$_GET["category"]}&website={$_GET["website"]}',\n\tdataType: 'json',\n\tcolModel : [\n\t\t\t{display: '<span style=font-size:18px>{$date}</span>', name : 'zDate', width : 179, sortable : true, align: 'left'},\t\n\t\t\t{display: '<span style=font-size:18px>{$uri}</span>', name : 'pattern', width :665, sortable : true, align: 'left'},\n\t\t\t{display: ' ', name : 'none2', width : 40, sortable : false, align: 'left'},\n\t\t\n\t],\n{$buttons}\n{$searchitem}\n\tsortname: 'zDate',\n\tsortorder: 'desc',\n\tusepager: true,\n\ttitle: '<strong style=font-size:22px>{$table_title}</strong>',\n\tuseRp: true,\n\trp: 15,\n\tshowTableToggleBtn: false,\n\twidth: '99%',\n\theight: 300,\n\tsingleSelect: true\n\t\n\t}); \n});\n\nfunction xls{$t}(){\n\tLoadjs('squid.categories.url.export.php?category={$_GET["category"]}&t={$t}');\n}\n\n\tfunction AddWebSites{$t}(){\n\t\tLoadjs('{$page}?add-uris-js=yes&category={$_GET["category"]}&t={$t}');\n\t}\n\n\tfunction MoveCategorizedWebsite(zmd5,website,category,category_table){\n\t\tYahooWinBrowse(550,'{$page}?move-category-popup=yes&YahooWin=YahooWinBrowse&website='+website+'&zmd5='+zmd5+'&category-source='+category+'&table-source='+category_table,'{$movetext}::'+website);\n\t}\n\n\tfunction MoveAllCategorizedWebsite(){\n\t\tYahooWinBrowse(550,'{$page}?move-category-popup=yes&YahooWin=YahooWinBrowse&website=&zmd5=&category-source={$_GET["category"]}&table-source={$table}&bysearch={$_GET["search"]}','{$movetext}::{$_GET["search"]}');\n\t\t\n\t}\n\t\n\tfunction MoveAllCategorizedWebsite2(category,table,search){\n\t\tYahooWinBrowse(550,'{$page}?move-category-popup=yes&YahooWin=YahooWinBrowse&website=&zmd5=&category-source='+category+'&table-source='+table+'&bysearch='+search+'&t={$t}','{$movetext}::'+search);\n\t\t\n\t}\n\n\tvar x_DeleteAll{$t}= function (obj) {\n\t\tvar results=obj.responseText;\n\t\tif(results.length>0){alert(results);return;}\n\t\t\$('#{$t}').flexReload();\n\t}\t\t\n\t\n\tfunction DeleteAll{$t}(){\n\t\tvar categoryZ = '{$_GET["category"]}'\n\t\tif(confirm('{$removedAll}:'+categoryZ)){\n\t\t\tvar XHR = new XHRConnection();\n\t\t\tXHR.appendData('RemoveAll',categoryZ);\n\t\t\tXHR.sendAndLoad('{$page}', 'POST',x_DeleteAll{$t});\n\t\t}\n\t}\n\t\n\t\n\tvar x_DeleteCategorizedWebsite{$t}= function (obj) {\n\t\tvar results=obj.responseText;\n\t\tif(results.length>0){alert(results);return;}\n\t\t\$('#row'+MEMMD{$t}).remove();\n\t}\t\n\n\n\t\n\n\t\n\tfunction DeleteCategorizedURI(zmd5,table){\n\t\tMEMMD{$t}=zmd5;\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('DeleteCategorizedURI',zmd5);\n\t\tXHR.appendData('catz','{$_GET["category"]}');\n\t\tXHR.appendData('TABLE',table);\n\t\tXHR.sendAndLoad('{$page}', 'POST',x_DeleteCategorizedWebsite{$t});\t\n\t}\t\n\n</script>\n";
}
function query()
{
$tpl = new templates();
$also = $tpl->_ENGINE_parse_body("{also}");
$MyPage = CurrentPageName();
$q = new mysql_meta();
$nowebsites = $tpl->_ENGINE_parse_body("{no_saved_web_site_catz}");
$category = null;
if ($category == null) {
if ($_GET["category"] != null) {
$category = $_GET["category"];
$_POST["qtype"] = "pattern";
}
}
if ($category == null) {
if ($_POST["qtype"] != null) {
$category = $_POST["qtype"];
$_POST["qtype"] = "pattern";
}
}
if ($_POST["query"] != null) {
if ($_GET["website"] != null) {
$_POST["query"] = $_GET["website"];
}
}
if ($category == null) {
json_error_show("Please select a category first");
}
if ($_POST["sortname"] == "sitename") {
$_POST["sortname"] = "zDate";
$_POST["sortorder"] = "desc";
}
$search = '%';
$page = 1;
$COUNT_ROWS = $q->COUNT_ROWS("webfiltering_categories_items");
if ($COUNT_ROWS == 0) {
json_error_show("category/COUNT_ROWS:{$category} ,{$nowebsites}", 1);
}
if (isset($_POST["sortname"])) {
if ($_POST["sortname"] != null) {
$ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";
}
}
if (isset($_POST['page'])) {
$page = $_POST['page'];
}
$_POST["query"] = trim($_POST["query"]);
$searchstring = string_to_flexquery();
if ($searchstring != null) {
$orgQuery = $_POST["query"];
$sql = "SELECT COUNT(zmd5) as TCOUNT FROM `webfiltering_categories_items` WHERE category='{$category}' {$searchstring}";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql, "artica_backup"));
$total = $ligne["TCOUNT"];
}
if (isset($_POST['rp'])) {
$rp = $_POST['rp'];
}
$pageStart = ($page - 1) * $rp;
$limitSql = "LIMIT {$pageStart}, {$rp}";
$sql = "SELECT zDate,zmd5,pattern,enabled FROM `webfiltering_categories_items` WHERE 1 {$searchstring} {$ORDER} {$limitSql}";
writelogs($sql, __FUNCTION__, __FILE__, __LINE__);
$results = $q->QUERY_SQL($sql);
if (!$q->ok) {
json_error_show($q->mysql_error, 1);
}
if (mysql_num_rows($results) == 0) {
json_error_show("{$nowebsites}", 1);
}
$disabled_text = $tpl->_ENGINE_parse_body("{disabled}");
$CategoriesCheckRightsWrite = CategoriesCheckRightsWrite();
$data = array();
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
if ($orgQuery != null) {
$moveAll = imgtootltip("arrow-multiple-right-24.png", "{move}", "MoveAllCategorizedWebsite2('{$category}','{$table}','{$orgQuery}')");
}
while ($ligne = mysql_fetch_assoc($results)) {
$delete = imgtootltip("delete-24.png", "{delete}", "DeleteCategorizedWebsite('{$ligne["zmd5"]}','{$table}')");
$move = imgtootltip("arrow-right-24.png", "{move}", "MoveCategorizedWebsite('{$ligne["zmd5"]}','{$ligne["pattern"]}','{$category}','{$table}')");
$added = null;
$enabled = $ligne["enabled"];
$color = "color:black";
$moveAll = " ";
$move = " ";
$delete = imgtootltip("delete-24.png", "{delete}", "ReallyDeleteCategorizedWebsite('{$ligne["zmd5"]}')");
$jscat = "<a href=\"javascript:blur();\" \n\t\tOnClick=\"javascript:Loadjs('squid.categorize.php?www={$ligne["pattern"]}');\"\n\t\tstyle='font-size:14px;text-decoration:underline;{$color}'>";
if (!$CategoriesCheckRightsWrite) {
$jscat = null;
$moveAll = null;
$move = null;
$delete = null;
}
$data['rows'][] = array('id' => $ligne['zmd5'], 'cell' => array("\n\t\t<span style='font-size:18px;{$color}'>{$ligne['zDate']}</span>", "<span style='font-size:18px;{$color}'>{$ligne['pattern']}</a></span>", "<center>{$delete}</center>"));
}
echo json_encode($data);
return;
$page = CurrentPageName();
$tpl = new templates();
$category = $_GET["category"];
if ($category == null) {
return;
}
$q = new mysql_squid_builder();
$tableN = "category_" . $q->category_transform_name($category);
$strictSearch = $_GET["strictSearch"];
if (!is_numeric($strictSearch)) {
$strictSearch = 0;
}
$searchOrg = $_GET["search"];
if ($_GET["search"] != null) {
$search = $_GET["search"];
if ($strictSearch == 0) {
$search = "*{$search}*";
}
$search = str_replace("**", "*", $search);
$search = str_replace("**", "*", $search);
$search = str_replace("*", "%", $search);
$search = " AND pattern LIKE '{$search}'";
}
$sql = "SELECT * FROM {$tableN} WHERE enabled=1 {$search} ORDER BY pattern LIMIT 0,25 ";
$table = "<center>\n<table cellspacing='0' cellpadding='0' border='0' class='tableView' style='width:350px'>\n<thead class='thead'>\n\t<tr>\n\t<th width=1%>{website} {$category}</th>\n\t<th>{date}</th>\n\t<th>{$moveall}</th>\n\t<th> </th>\n\t</tr>\n</thead>\n<tbody>";
$results = $q->QUERY_SQL($sql);
$number = mysql_num_rows($results);
if ($number == 0) {
if ($searchOrg != null) {
if (strpos($searchOrg, "*") == 0) {
$html = "\n\t\t<center style='margin:30px'>\n\t\t<div style='font-size:16px;margin-bottom:15px'><code>«http://{$searchOrg}» {in} «{$category}»</code></div>\n\t\t<div style='font-size:14px'><a href=\"javascript:blur();\" \n\t\tOnClick=\"javascript:Loadjs('squid.visited.php?add-www=yes&websitetoadd={$searchOrg}')\"\n\t\tstyle='font-size:14px;font-weight:bold;text-decoration:underline'\n\t\t>{webiste_notfound_additask}</a>\n\t\t</div>\n\t\t</center>\n\t\t<script>LoadAjaxTiny('subtitles-categories','{$page}?subtitles-categories=yes');</script>\n\t\t";
echo $tpl->_ENGINE_parse_body($html);
return;
}
}
}
if (!$q->ok) {
echo "<H2>{$q->mysql_error}</H2><center style='font-size:11px'><code>{$sql}</code></center>";
}
while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($classtr == "oddRow") {
$classtr = null;
} else {
$classtr = "oddRow";
}
if ($ligne["pattern"] == null) {
$q->QUERY_SQL("DELETE FROM {$tableN} WHERE zmd5='{$ligne["zmd5"]}'");
continue;
}
$jscat = "<a href=\"javascript:blur();\" \n\t\tOnClick=\"javascript:Loadjs('squid.categorize.php?www={$ligne["pattern"]}');\"\n\t\tstyle='font-size:14px;text-decoration:underline'>";
$table = $table . "\n\t\t<tr class={$classtr}>\n\t\t<td style='width:1%;font-size:14px' nowrap>{$ligne["zDate"]}</td>\n\t\t<td style='width:1%;font-size:14px' nowrap>{$jscat}{$ligne["pattern"]}</a></td>\n\t\t<td>{$move}</td>\n\t\t<td>{$delete}</td>\n\t\t</tr>\n\t\t";
}
$table = $table . "</tbody></table>\n\t<script>\n\t\n\t\n\n\t\n\n\t\n\tLoadAjaxTiny('subtitles-categories','{$page}?subtitles-categories=yes');\n\t\n</script>\t\n\t";
echo $tpl->_ENGINE_parse_body($table);
}
