";
}
}
function deletecat($cat_id) {
global $mysql_table_prefix;
$list = implode(",", get_cats($cat_id));
mysql_query("delete from ".$mysql_table_prefix."categories where category_id in ($list)");
echo mysql_error();
mysql_query("delete from ".$mysql_table_prefix."site_category where category_id=$cat_id");
echo mysql_error();
return "
Category deleted.
";
}
function deletesite($site_id) {
global $mysql_table_prefix;
mysql_query("delete from ".$mysql_table_prefix."sites where site_id=$site_id");
echo mysql_error();
mysql_query("delete from ".$mysql_table_prefix."site_category where site_id=$site_id");
echo mysql_error();
$query = "select link_id from ".$mysql_table_prefix."links where site_id=$site_id";
$result = mysql_query($query);
echo mysql_error();
$todelete = array();
while ($row=mysql_fetch_array($result)) {
$todelete[]=$row['link_id'];
}
if (count($todelete)>0) {
$todelete = implode(",", $todelete);
for ($i=0;$i<=15; $i++) {
$char = dechex($i);
$query = "delete from ".$mysql_table_prefix."link_keyword$char where link_id in($todelete)";
mysql_query($query);
echo mysql_error();
}
}
mysql_query("delete from ".$mysql_table_prefix."links where site_id=$site_id");
echo mysql_error();
mysql_query("delete from ".$mysql_table_prefix."pending where site_id=$site_id");
echo mysql_error();
return "
Site deleted
";
}
function deletePage($link_id) {
global $mysql_table_prefix;
mysql_query("delete from ".$mysql_table_prefix."links where link_id=$link_id");
echo mysql_error();
for ($i=0;$i<=15; $i++) {
$char = dechex($i);
mysql_query("delete from ".$mysql_table_prefix."link_keyword$char where link_id=$link_id");
}
echo mysql_error();
return "
Page deleted
";
}
function cleanTemp() {
global $mysql_table_prefix;
$result = mysql_query("delete from ".$mysql_table_prefix."temp where level >= 0");
echo mysql_error();
$del = mysql_affected_rows();
?>
Temp table cleared, $del items deleted.
";
}
function clearLog() {
global $mysql_table_prefix;
$result = mysql_query("delete from ".$mysql_table_prefix."query_log where time >= 0");
echo mysql_error();
$del = mysql_affected_rows();
?>
Search log cleared, $del items deleted.
";
}
function cleanLinks() {
global $mysql_table_prefix;
$query = "select site_id from ".$mysql_table_prefix."sites";
$result = mysql_query($query);
echo mysql_error();
$todelete = array();
if (mysql_num_rows($result)>0) {
while ($row=mysql_fetch_array($result)) {
$todelete[]=$row['site_id'];
}
$todelete = implode(",", $todelete);
$sql_end = " not in ($todelete)";
}
$result = mysql_query("select link_id from ".$mysql_table_prefix."links where site_id".$sql_end);
echo mysql_error();
$del = mysql_num_rows($result);
while ($row=mysql_fetch_array($result)) {
$link_id=$row[link_id];
for ($i=0;$i<=15; $i++) {
$char = dechex($i);
mysql_query("delete from ".$mysql_table_prefix."link_keyword$char where link_id=$link_id");
echo mysql_error();
}
mysql_query("delete from ".$mysql_table_prefix."links where link_id=$link_id");
echo mysql_error();
}
$result = mysql_query("select link_id from ".$mysql_table_prefix."links where site_id is NULL");
echo mysql_error();
$del += mysql_num_rows($result);
while ($row=mysql_fetch_array($result)) {
$link_id=$row[link_id];
for ($i=0;$i<=15; $i++) {
$char = dechex($i);
mysql_query("delete from ".$mysql_table_prefix."link_keyword$char where link_id=$link_id");
echo mysql_error();
}
mysql_query("delete from ".$mysql_table_prefix."links where link_id=$link_id");
echo mysql_error();
}
?>
Links table cleaned, $del links deleted.
";
}
function cleanKeywords() {
global $mysql_table_prefix;
$query = "select keyword_id, keyword from ".$mysql_table_prefix."keywords";
$result = mysql_query($query);
echo mysql_error();
$del = 0;
while ($row=mysql_fetch_array($result)) {
$keyId=$row['keyword_id'];
$keyword=$row['keyword'];
$wordmd5 = substr(md5($keyword), 0, 1);
$query = "select keyword_id from ".$mysql_table_prefix."link_keyword$wordmd5 where keyword_id = $keyId";
$result2 = mysql_query($query);
echo mysql_error();
if (mysql_num_rows($result2) < 1) {
mysql_query("delete from ".$mysql_table_prefix."keywords where keyword_id=$keyId");
echo mysql_error();
$del++;
}
}?>
Keywords table cleaned, $del keywords deleted.
";
}
function getStatistics() {
global $mysql_table_prefix;
$stats = array();
$keywordQuery = "select count(keyword_id) from ".$mysql_table_prefix."keywords";
$linksQuery = "select count(url) from ".$mysql_table_prefix."links";
$siteQuery = "select count(site_id) from ".$mysql_table_prefix."sites";
$categoriesQuery = "select count(category_id) from ".$mysql_table_prefix."categories";
$result = mysql_query($keywordQuery);
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$stats['keywords']=$row[0];
}
$result = mysql_query($linksQuery);
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$stats['links']=$row[0];
}
for ($i=0;$i<=15; $i++) {
$char = dechex($i);
$result = mysql_query("select count(link_id) from ".$mysql_table_prefix."link_keyword$char");
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$stats['index']+=$row[0];
}
}
$result = mysql_query($siteQuery);
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$stats['sites']=$row[0];
}
$result = mysql_query($categoriesQuery);
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$stats['categories']=$row[0];
}
return $stats;
}
function addsite ($url, $title, $short_desc, $cat) {
global $mysql_table_prefix;
$short_desc = addslashes($short_desc);
$title = addslashes($title);
$compurl=parse_url("".$url);
if ($compurl['path']=='')
$url=$url."/";
$result = mysql_query("select site_ID from ".$mysql_table_prefix."sites where url='$url'");
echo mysql_error();
$rows = mysql_numrows($result);
if ($rows==0 ) {
mysql_query("INSERT INTO ".$mysql_table_prefix."sites (url, title, short_desc) VALUES ('$url', '$title', '$short_desc')");
echo mysql_error();
$result = mysql_query("select site_ID from ".$mysql_table_prefix."sites where url='$url'");
echo mysql_error();
$row = mysql_fetch_row($result);
$site_id = $row[0];
$result=mysql_query("select category_id from ".$mysql_table_prefix."categories");
echo mysql_error();
while ($row=mysql_fetch_row($result)) {
$cat_id=$row[0];
if ($cat[$cat_id]=='on') {
mysql_query("INSERT INTO ".$mysql_table_prefix."site_category (site_id, category_id) values ('$site_id', '$cat_id')");
echo mysql_error();
}
}
If (!mysql_error()) {
$message = "
