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); }