function phpdigDelSpiderRow($id_connect, $spider_id, $ftp_id = '')
{
global $relative_script_path, $ftp_id;
$query = "DELETE FROM " . PHPDIG_DB_PREFIX . "engine WHERE spider_id={$spider_id}";
$result_id = mysql_query($query, $id_connect);
$query = "DELETE FROM " . PHPDIG_DB_PREFIX . "spider WHERE spider_id={$spider_id};";
$result_id = mysql_query($query, $id_connect);
phpdigDelText($relative_script_path, $spider_id, $ftp_id);
}
<body bgcolor="white">
<h2><?php
phpdigPrnMsg('Cleanup dashes');
?>
</h2>
<?php
$locks = phpdigMySelect($id_connect, 'SELECT locked FROM ' . PHPDIG_DB_PREFIX . 'sites WHERE locked = 1');
if (is_array($locks)) {
phpdigPrnMsg('onelock');
} else {
mysql_query('UPDATE ' . PHPDIG_DB_PREFIX . 'sites SET locked=1', $id_connect);
$query = mysql_query("SELECT spider_id FROM " . PHPDIG_DB_PREFIX . "spider WHERE file = '';");
while ($row = mysql_fetch_array($query)) {
mysql_query("DELETE FROM " . PHPDIG_DB_PREFIX . "engine WHERE spider_id=" . $row['spider_id'] . ";");
mysql_query("DELETE FROM " . PHPDIG_DB_PREFIX . "spider WHERE spider_id=" . $row['spider_id'] . ";");
phpdigDelText($relative_script_path, $row['spider_id']);
$count++;
echo $count . " ";
}
echo phpdigMsg('done');
mysql_query('UPDATE ' . PHPDIG_DB_PREFIX . 'sites SET locked=0', $id_connect);
}
?>
<br /><br />
<a href="index.php?sid=<?php
echo $sid;
?>
" >[<?php
phpdigPrnMsg('back');
?>
]</a> <?php
}
$verify = phpdigMySelect($id_connect, 'SELECT locked FROM ' . PHPDIG_DB_PREFIX . 'sites WHERE site_id=' . $site_id);
if (!is_array($verify)) {
die;
} elseif ($unlock) {
mysql_query('UPDATE ' . PHPDIG_DB_PREFIX . 'sites SET locked=0 WHERE site_id=' . $site_id, $id_connect);
} elseif (!$verify[0]['locked']) {
mysql_query('UPDATE ' . PHPDIG_DB_PREFIX . 'sites SET locked=1 WHERE site_id=' . $site_id, $id_connect);
if ($sup) {
$query = "SELECT spider_id FROM " . PHPDIG_DB_PREFIX . "spider WHERE site_id={$site_id} {$andpath}";
$result_id = mysql_query($query, $id_connect);
if (mysql_num_rows($result_id) > 0) {
$ftp_id = phpdigFtpConnect();
$in = "IN (0";
while (list($spider_id) = mysql_fetch_row($result_id)) {
phpdigDelText($relative_script_path, $spider_id, $ftp_id);
$in .= ",{$spider_id}";
}
$in .= ")";
phpdigFtpClose($ftp_id);
$query = "DELETE FROM " . PHPDIG_DB_PREFIX . "engine WHERE spider_id {$in}";
$result_id = mysql_query($query, $id_connect);
$query = "DELETE FROM " . PHPDIG_DB_PREFIX . "spider WHERE site_id={$site_id} {$andpath}";
$result_id = mysql_query($query, $id_connect);
// deny branch
if ($deny && $path) {
$query = "DELETE FROM " . PHPDIG_DB_PREFIX . "excludes WHERE ex_site_id={$site_id} AND ex_path LIKE '" . str_replace('%', '\\%', $path) . "%'";
mysql_query($query, $id_connect);
$query = "INSERT INTO " . PHPDIG_DB_PREFIX . "excludes (ex_site_id,ex_path) VALUES ({$site_id},'" . str_replace('%', '\\%', $path) . "')";
mysql_query($query, $id_connect);
}
