function websitelist()
{
$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["p**n-macro"])) {
$f = explode(",", "sex,boobs,penis,pussy,c**t,p**n,anal,teen,latina,cum,amateur,bondage,babe,bbw,bukkake,hentai,g******g,orgy,strip,pov,asian,nipple,t**s,b*****b,mature,squirt,shemale,nude,c**k,breast,virgin,chicks,escort,facial,horny,o****m,gay,lesbian,xxx,f**k,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["p**n-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>\n\t\t\t\t {$country} ", "<span style='font-size:11px;font-weight:bold'>{$ligne["category"]}</span>", $fieldCatz, $button, $delte));
}
echo json_encode($data);
}
function websitelist()
{
$tpl = new templates();
$MyPage = CurrentPageName();
$q = new mysql_squid_builder();
$table = "webtests";
$country_select = null;
$search = '%';
$page = 1;
$total = 0;
$FORCE = null;
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'];
}
if (isset($_GET["fix-search-domain"])) {
$FORCE = "AND family='{$_GET["fix-search-domain"]}'";
}
if ($_POST["query"] != null or $FORCE != null) {
$_POST["query"] = "*" . trim($_POST["query"]) . "*";
$_POST["query"] = str_replace("**", "*", $_POST["query"]);
$_POST["query"] = str_replace("**", "*", $_POST["query"]);
$_POST["query"] = str_replace("*", "%", $_POST["query"]);
$search = $_POST["query"];
$searchstring = "AND (`{$_POST["qtype"]}` LIKE '{$search}')";
$sql = "SELECT * FROM {$table} WHERE 1 {$FORCE} {$searchstring}";
$results = $q->QUERY_SQL($sql);
$total = mysql_num_rows($results);
writelogs("{$sql} = `{$total}`", __FUNCTION__, __FILE__, __LINE__);
} else {
$total = $q->COUNT_ROWS($table);
writelogs("{$sql} = `{$total}`", __FUNCTION__, __FILE__, __LINE__);
}
if (isset($_POST['rp'])) {
$rp = $_POST['rp'];
}
$pageStart = ($page - 1) * $rp;
$limitSql = "LIMIT {$pageStart}, {$rp}";
$sql = "SELECT * FROM {$table} WHERE 1 {$FORCE} {$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, 1);
}
if (mysql_num_rows($results) == 0) {
json_error_show($q->mysql_error, 1);
}
writelogs("{$sql}", __FUNCTION__, __FILE__, __LINE__);
$button = null;
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 = imgtootltip("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>";
}
$data['rows'][] = array('id' => md5($ligne['sitename']), 'cell' => array("{$ligne['zDate']}</span>", "<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>", $button, $delte));
}
echo json_encode($data);
}