$www=$_REQUEST["WEBTESTS"];

$q=new mysql_squid_builder();

$www=$q->WebsiteStrip($www);

if($www==null){echo "corrupted\n";return;}

$catz=str_replace(",", "\n- ", $q->GET_CATEGORIES($www,true));

echo "\nFinal:\n\"".$q->GET_CATEGORIES($www,true)."\"\n";

$page=CurrentPageName();

$tpl=new templates();

$t=$_GET["t"];

$html="

<div id='anim-$t'>

<textarea style='font-size:13px;height:350px;width:100%;overflow:auto;margin-bottom:10px' id='test-cat-form-$t'></textarea>

<hr>

<div style='text-align:right'>". button("{add}", "PostTestWebsites$t()")."</div>

</div>

<script>

function x_PostTestWebsites2$t(obj){

var tempvalue=obj.responseText;

if(tempvalue.length>3){alert(tempvalue);}

if(document.getElementById('tableau-test-categories')){RefreshTableauTestCategories();}

YahooWin5Hide();

}

function PostTestWebsites$t(){

var XHR = new XHRConnection();

XHR.appendData('websites-add',document.getElementById('test-cat-form-$t').value);

AnimateDiv('anim-$t');

XHR.sendAndLoad('$page', 'POST',x_PostTestWebsites2$t);

}

</script>

";

echo $tpl->_ENGINE_parse_body($html);

$page=CurrentPageName();

$tpl=new templates();

$t=time();

$websites=$tpl->_ENGINE_parse_body("{websites}");

$category=$tpl->_ENGINE_parse_body("{category}");

$add=$tpl->_ENGINE_parse_body("{add}");

$add_websites=$tpl->_ENGINE_parse_body("{add} $websites");

$verify=$tpl->_ENGINE_parse_body("{analyze}");

$retry=$tpl->_ENGINE_parse_body("{retry}");

$squid_test_categories_explain=$tpl->_ENGINE_parse_body("{squid_test_categories_explain}");

$import=$tpl->_ENGINE_parse_body("{import}");

$import_catz_art_expl=$tpl->javascript_parse_text("{import_catz_art_expl}");

$date=$tpl->_ENGINE_parse_body("{zDate}");

$country=$tpl->_ENGINE_parse_body("{country}");

$form=$tpl->_ENGINE_parse_body("

<div style='width:98%' class=form>

<table>

<tr>

<td class=legend style='font-size:14px'>{website}:</td>

<td>". Field_text("WEBTESTS",null,"font-size:14px;padding:3px;border:2px solid #808080",

null,null,null,false,"CheckSingleSite(event)")."</td>

</tr>

</table>

</div>

");

$buttons="

buttons : [

{name: '$verify', bclass: 'add', onpress : Analyze$t},

{name: '$add_websites', bclass: 'add', onpress : AddWebsites$t},

{name: '$retry', bclass: 'Reload', onpress : Retry$t},

{name: 'Porn', bclass: 'Reload', onpress : Porn$t},

{name: '$import - Artica', bclass: 'add', onpress : ImportArt$t},

],";

$html="

<span id='analyze-img-$t'></span>

$form

<div class=text-info style='font-size:12px' id='tableau-test-categories'>$squid_test_categories_explain</div>

<table class='$t' style='display: none' id='$t' style='width:100%'></table>

<script>

var xsite='';

$(document).ready(function(){

$('#$t').flexigrid({

url: '$page?websites-test=yes',

dataType: 'json',

colModel : [

{display: '$date', name : 'zDate', width : 101, sortable : true, align: 'left'},

{display: '$websites', name : 'sitename', width : 196, sortable : true, align: 'left'},

{display: '$category', name : 'category', width : 135, sortable : true, align: 'left'},

{display: '&nbsp;', name : 'autof', width : 165, sortable : false, align: 'left'},

{display: '&nbsp;', name : 'null', width : 30, sortable : false, align: 'left'},

{display: '&nbsp;', name : 'null', width : 30, sortable : false, align: 'left'},

],

$buttons

searchitems : [

{display: '$websites', name : 'sitename'},

{display: '$country', name : 'Country'},

],

sortname: 'zDate',

sortorder: 'desc',

usepager: true,

title: '',

useRp: true,

rp: 50,

showTableToggleBtn: false,

width: '99%',

height: 250,

singleSelect: true,

rpOptions: [10, 20, 30, 50,100,200]

});

});

function x_CheckSingleSite(obj){

var tempvalue=obj.responseText;

if(document.getElementById('analyze-img-$t')){document.getElementById('analyze-img-$t').innerHTML='';}

if(tempvalue.length>3){alert(tempvalue);}

}

function Porn$t(){

$('#$t').flexOptions({url: '$page?websites-test=yes&porn-macro=yes'}).flexReload();

}

function CheckSingleSite(e){

if(!checkEnter(e)){return;}

var XHR = new XHRConnection();

XHR.appendData('WEBTESTS',document.getElementById('WEBTESTS').value);

AnimateDiv('analyze-img-$t');

XHR.sendAndLoad('$page', 'POST',x_CheckSingleSite);

}

function x_PostTestWebsites$t(obj){

var tempvalue=obj.responseText;

if(document.getElementById('analyze-img-$t')){document.getElementById('analyze-img-$t').innerHTML='';}

if(tempvalue.length>3){alert(tempvalue);}else{

if(document.getElementById('test-cat-form-$t')){document.getElementById('test-cat-form-$t').value='';}

}

$('#$t').flexReload();

}

function RefreshTableauTestCategories(){

$('#$t').flexReload();

}

function Retry$t(){

var XHR = new XHRConnection();

XHR.appendData('retry-analyze','ok');

AnimateDiv('analyze-img-$t');

XHR.sendAndLoad('$page', 'POST',x_PostTestWebsites$t);

}

function ImportArt$t(){

if(confirm('$import_catz_art_expl')){

var XHR = new XHRConnection();

XHR.appendData('import-artica','ok');

AnimateDiv('analyze-img-$t');

XHR.sendAndLoad('$page', 'POST',x_PostTestWebsites$t);

}

}

function Analyze$t(){

var XHR = new XHRConnection();

XHR.appendData('websites-analyze','ok');

AnimateDiv('analyze-img-$t');

XHR.sendAndLoad('$page', 'POST',x_PostTestWebsites$t);

}

function DeleteTestCatSitename(site){

var XHR = new XHRConnection();

XHR.appendData('websites-delete',site);

XHR.sendAndLoad('$page', 'POST',x_PostTestWebsites$t);

}

var x_ffCatAdd$t=function(obj){

var tempvalue=obj.responseText;

document.getElementById('analyze-img-$t').innerHTML='';

if(tempvalue.length>3){alert(tempvalue);return;}

$('#row'+xsite).remove();

}

function AddWebsites$t(){

YahooWin5('550','$page?AddWebsites-popup=yes&t=$t','$add_websites');

}

function PerformProposal(category,sitename,md){

xsite=md;

var XHR = new XHRConnection();

XHR.appendData('PerformProposal','yes');

XHR.appendData('category',category);

XHR.appendData('sitename',sitename);

AnimateDiv('analyze-img-$t');

XHR.sendAndLoad('$page', 'POST',x_ffCatAdd$t);

}

function performChoose(md,sitename){

xsite=md;

var category=document.getElementById('cat-'+md).value;

if(!category){alert('select first');return;}

var XHR = new XHRConnection();

XHR.appendData('PerformProposal','yes');

XHR.appendData('category',category);

XHR.appendData('sitename',sitename);

AnimateDiv('analyze-img-$t');

XHR.sendAndLoad('$page', 'POST',x_ffCatAdd$t);

}

function ffCatAdd(sitename,serial){

xsite=sitename;

var XHR = new XHRConnection();

XHR.appendData('ffCatAdd',serial);

AnimateDiv('analyze-img-$t');

XHR.sendAndLoad('$page', 'POST',x_ffCatAdd$t);

}

</script>";

echo $html;

$extcat=$_POST["category"];

$sitename=$_POST["sitename"];

$sock=new sockets();

$uuid=base64_decode($sock->getFrameWork("cmd.php?system-unique-id=yes"));

$newmd5=md5("$extcat$sitename");

$q=new mysql_squid_builder();

$category_table="category_".$q->category_transform_name($extcat);

$q->QUERY_SQL("INSERT IGNORE INTO categorize_changes (zmd5,sitename,category) VALUES('$newmd5','$sitename','$extcat')");

if(!$q->ok){echo $q->mysql_error;return;}

$q->QUERY_SQL("INSERT IGNORE INTO $category_table (zmd5,zDate,category,pattern,uuid) VALUES('$newmd5',NOW(),'$extcat','$sitename','$uuid')");

if(!$q->ok){echo $q->mysql_error;return;}

$q->QUERY_SQL("DELETE FROM webtests WHERE sitename='$sitename'");

if(!$q->ok){echo $q->mysql_error;return;}

$q=new mysql_squid_builder();

$_POST["websites-delete"]=addslashes($_POST["websites-delete"]);

$q->QUERY_SQL("DELETE FROM webtests WHERE sitename='{$_POST["websites-delete"]}'");

$q=new mysql_squid_builder();

$tpl=new templates();

$numS=$q->COUNT_ROWS("webtests");

$f=explode("\n", $_POST["websites-add"]);

while (list ($num, $www) = each ($f) ){

$www=trim(strtolower($www));

if(preg_match("#http:\/\/(.+)#", $www,$re)){$www=$re[1];}

writelogs("$www",__FUNCTION__,__FILE__,__LINE__);

$www=str_replace("www.", "", $www);

if(strpos($www, "/")>0){$www=substr($www, 0,strpos($www, "/"));}

$d[]=$www;

}

if(count($d)==0){return;}

while (list ($num, $www) = each ($d) ){

$www=trim($www);

if(trim($www)==null){continue;}

if(strpos($www, ",")>0){continue;}

if(strpos($www, " ")>0){continue;}

if(strpos($www, ":")>0){continue;}

if(strpos($www, "%")>0){continue;}

if(trim($www)==null){continue;}

$qA[]="('$www')";

}

if(count($qA)>0){

$q->QUERY_SQL("INSERT IGNORE INTO webtests (sitename) VALUES ".@implode(",", $qA));

if(!$q->ok){

if(strpos($q->mysql_error, "doesn't exist")>0){$q->CheckTables();}

$q->QUERY_SQL("INSERT IGNORE INTO webtests (sitename) VALUES ".@implode(",", $qA));

if(!$q->ok){echo $q->mysql_error;}

}

}

$num2=$q->COUNT_ROWS("webtests");

$tot=$num2-$numS;

echo $tpl->javascript_parse_text("$tot {added_websites}");

$sock=new sockets();

$sock->getFrameWork("squid.php?categorize-tests=yes");

$q=new mysql_squid_builder();

$sql="UPDATE webtests SET checked=0";

$q->QUERY_SQL($sql);

$sock=new sockets();

$sock->getFrameWork("squid.php?categorize-tests=yes");

$tpl=new templates();

$MyPage=CurrentPageName();

$q=new mysql_squid_builder();

$table="webtests";

$country_select=null;

$search='%';

$page=1;

$total=0;

if($q->COUNT_ROWS($table)==0){$data['page'] = $page;$data['total'] = $total;$data['rows'] = array();echo json_encode($data);return ;}

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(isset($_GET["porn-macro"])){

$f=explode(",","sex,boobs,penis,pussy,cunt,porn,anal,teen,latina,cum,amateur,bondage,babe,bbw,bukkake,hentai,gangbang,orgy,strip,pov,asian,nipple,tits,blowjob,mature,squirt,shemale,nude,cock,breast,virgin,chicks,escort,facial,horny,orgasm,gay,lesbian,xxx,fuck,dick");

while (list ($index, $items) = each ($f) ){

if($items==null){continue;}

$GR[]="( `sitename` LIKE '%$items%')";

}

$table="(SELECT * FROM webtests WHERE 1 AND ( ".@implode(" OR ", $GR)." ) ) as t";

}

if($searchstring<>null){

$sql="SELECT * FROM $table WHERE 1 $searchstring";

$results=$q->QUERY_SQL($sql);

$total = mysql_num_rows($results);

writelogs("$sql = `$total`",__FUNCTION__,__FILE__,__LINE__);

}else{

if(!isset($_GET["porn-macro"])){

$total = $q->COUNT_ROWS($table);

}else{

$sql="SELECT * FROM $table WHERE 1 $searchstring";

$results=$q->QUERY_SQL($sql);

$total = mysql_num_rows($results);

}

writelogs("$sql = `$total`",__FUNCTION__,__FILE__,__LINE__);

}

if (isset($_POST['rp'])) {$rp = $_POST['rp'];}

if(!is_numeric(v)){$rp=1;}

$pageStart = ($page-1)*$rp;

$limitSql = "LIMIT $pageStart, $rp";

$sql="SELECT * FROM $table WHERE 1 $searchstring $ORDER $limitSql";

writelogs($sql,__FUNCTION__,__FILE__,__LINE__);

$results = $q->QUERY_SQL($sql);

$data = array();

$data['page'] = $page;

$data['total'] = $total;

$data['rows'] = array();

if(!$q->ok){json_error_show($q->mysql_error." $sql",1);}

if(mysql_num_rows($results)==0){json_error_show($q->mysql_error,1);}

writelogs("$sql",__FUNCTION__,__FILE__,__LINE__);

$button=null;

$arrayCtaz[null]=" --";

$dans=new dansguardian_rules();

while (list ($categoryA, $rows) = each ($dans->array_blacksites) ){

$arrayCtaz[$categoryA]=$categoryA;

}

ksort($arrayCtaz);

while ($ligne = mysql_fetch_assoc($results)) {

if($ligne["sitename"]=="http:"){$q->QUERY_SQL("DELETE FROM $table WHERE sitename='{$ligne["sitename"]}'");continue;}

$button=null;

if(trim($ligne["category"])<>null){

$md=md5($ligne["sitename"]);

$fff=base64_encode(serialize(array($ligne["sitename"],$ligne["category"])));

$button=imgsimple("plus-24.png","{$ligne["sitename"]} = {$ligne["category"]}","ffCatAdd('$md','$fff')");

}

$delte=imgtootltip("delete-24.png","{delete} {$ligne["sitename"]}","DeleteTestCatSitename('{$ligne["sitename"]}')");

$jscat="javascript:Loadjs('squid.categorize.php?www={$ligne['sitename']}&day=&week=&month=')";

if($ligne["checked"]==1){

$button="<img src='img/error-24.png'>";

}

if(trim($ligne["category"])==null){

$ligne["category"]=proposal("{$ligne['sitename']}");

}

$country=$ligne["Country"];

if($country<>null){$country="<div>$country</div>";}

$encodesite=urlencode($ligne['sitename']);

$google="<a href=\"http://www.google.com/search?q=$encodesite&ie=utf-8&oe=utf-8&\" target='_blank'><img src='img/Google-18.png' style='float:right'></a>";

$md=md5($ligne['sitename']);

$fieldCatz=Field_array_Hash($arrayCtaz, "cat-$md");

$button=imgsimple("arrow-blue-left-24.png",null,"performChoose('$md','{$ligne['sitename']}')");

$data['rows'][] = array(

'id' => md5($ligne['sitename']),

'cell' => array(

"<a href=\"javascript:blur();\" OnClick=\"$jscat\" style='font-size:11px;font-weight:bold;text-decoration:underline'>{$ligne['zDate']}</span>",

"$google<a href=\"javascript:blur();\" OnClick=\"$jscat\" style='font-size:11px;font-weight:bold;text-decoration:underline'>{$ligne['sitename']}</a></span>

$country ",

"<span style='font-size:11px;font-weight:bold'>{$ligne["category"]}</span>",$fieldCatz,$button,$delte)

);

}

echo json_encode($data);

$f=array();

$md5=md5($www);

$www=trim($www);

if(preg_match("#music#", $www)){$f["music"]=true;}

if(preg_match("#movie#", $www)){

$f["movies"]=true;

$f["audio-video"]=true;

}

if(preg_match("#radio#", $www)){$f["webradio"]=true;}

if(preg_match("#skyrock#", $www)){$f["webradio"]=true;}

if(preg_match("#journal#", $www)){$f["blog"]=true;}

if(preg_match("#shop#", $www)){$f["shopping"]=true;}

if(preg_match("#vintage#", $www)){$f["shopping"]=true;}

if(preg_match("#xxx#", $www)){$f["porn"]=true;}

if(preg_match("#career#", $www)){$f["jobsearch"]=true;}

if(preg_match("#[-\_]fm#", $www)){$f["webradio"]=true;}

if(preg_match("#about\.com$#",$www)){$f["dictionaries"]=true;}

if(preg_match("#politic#",$www)){$f["politic"]=true;}

if(preg_match("#soiree#",$www)){$f["recreation/nightout"]=true;}

if(preg_match("#tv\.#",$www)){$f["webtv"]=true;}

if(preg_match("#school#",$www)){$f["recreation/schools"]=true;}

if(preg_match("#mobile#",$www)){$f["mobile-phone"]=true;}

if(preg_match("#tvprogram#",$www)){$f["webtv"]=true;}

if(preg_match("#.musiwave.com$#",$www)){$f["ringtones"]=true;}

if(preg_match("#\.2o7\.net#",$www)){$f["tracker"]=true;}

if(preg_match("#warcraft#",$www)){$f["games"]=true;}

if(preg_match("#\.fm$#",$www)){$f["webradio"]=true;}

if(preg_match("#soft#",$www)){$f["science/computing"]=true;}

if(preg_match("#tvideos#",$www)){$f["webtv"]=true;}

if(preg_match("#sex#",$www)){$f["porn"]=true;}

if(preg_match("#blip\.tv$#",$www)){$f["webtv"]=true;}

if(preg_match("#car.*insurance#",$www)){$f["finance/insurance"]=true;}

if(preg_match("#health.*insurance#",$www)){$f["finance/insurance"]=true;}

if(preg_match("#home.*insurance#",$www)){$f["finance/insurance"]=true;}

if(preg_match("#\.disqus\.com$#",$www)){$f["socialnet"]=true;}

if(preg_match("#twenga\.[a-z]+$#",$www)){$f["shopping"]=true;}

if(preg_match("#\.maases\.com$#", $www)){$f["music"]=true;}

if(preg_match("#\.zankyou\.com$#", $www)){$f["socialnet"]=true;}

if(preg_match("#\.wikipedia\.org$#",$www)){$f["dictionaries"]=true;}

if(preg_match("#\.wikia.com$#",$www)){$f["dictionaries"]=true;}

if(preg_match("#\.gameleads.ru$#",$www)){$f["publicite"]=true;}

if(preg_match("#immobilier#", $www)){$f["finance/realestate"]=true;}

if(preg_match("#\.icplatform.com$#", $www)){$f["reaffected"]=true;}

if(preg_match("#mailing#", $www)){$f["mailing"]=true;}

if(preg_match("#porn#", $www)){$f["porn"]=true;}

if(preg_match("#sport#", $www)){$f["recreation/sports"]=true;}

if(preg_match("#news#", $www)){$f["news"]=true;}

if(preg_match("#amicale#", $www)){$f["associations"]=true;}

if(preg_match("#video#", $www)){

$f["movies"]=true;

$f["audio-video"]=true;

}

if(preg_match("#game#", $www)){$f["games"]=true;}

$p=new generic_categorize();

$ccc=$p->GetCategories($www);

if($ccc<>null){

$f[$ccc]=true;

}

while (list ($category, $rows) = each ($f) ){

$s[]="<div>

<a href=\"javascript:blur();\" Onclick=\"javascript:PerformProposal('$category','$www','$md5')\"

style='font-size:11px;text-decoration:underline'>$category ?</a>

</div>";

}

return @implode(" ", $s);

$array=unserialize(base64_decode($_POST["ffCatAdd"]));

if(!is_array($array)){echo "Not an array....";return;}

$sitename=$array[0];

$categories=$array[1];

if($sitename==null){echo "Sitename=null";return;}

$q=new mysql_squid_builder();

if(!$q->ADD_CATEGORYZED_WEBSITE($sitename,$categories)){return;}

$q->QUERY_SQL("DELETE FROM webtests WHERE sitename='$sitename'");

$sock=new sockets();

$sock->getFrameWork("squid.php?import_nocatz-artica=yes");

}