if ($limit != "0") {
$stmt->setLimit($limit);
}
$count = $stmt->execute();
if ($count == 0) {
print "";
exit;
}
$cursor = $stmt->getCursor();
$res .= "<center><table>";
$res .= "<tr><th>Title</th><th>Starting URL</th><th>Next crawl date</th><th class='priority'>Priority</th></tr><tbody>";
while ($cursor->hasNext()) {
$rs = $cursor->getNext();
$query = array('$and' => array(array("type" => "cnx"), array("id" => intval($rs["type"]))));
mg_get_value($mg, "plugins", "class_php", $query, $class);
$source = SourceFactory::createInstance($class, $config, $id_account_current, $mg, $aLanguages, $aCountries);
$source->load($rs);
$res .= "<tr>";
$res .= "<td class='name'>";
$res .= $rs["name"] . " (id=" . $rs["id"] . ")";
$res .= "</td>";
$res .= "<td class='url'>";
$res .= getStartingUrls($source->getUrl());
$res .= "</td>";
$res .= "<td>";
$timestamp = $rs["crawl_nexttime"]->sec;
$now = time();
if ($now > $timestamp) {
$res .= "As soon as possible<br />(originally scheduled at " . date('Y-m-d H:i:s', $rs["crawl_nexttime"]->sec) . ")";
} else {
$res .= date('Y-m-d H:i:s', $rs["crawl_nexttime"]->sec);
require_once_all('sources/*.inc.php');
$db = db_connect($config, "", "", "");
$stmt = new db_stmt_select("sources");
$stmt->addColumn("*");
$s = $stmt->getStatement();
$rs = $db->Execute($s);
if (!$rs) {
echo "Error while reading sources table !";
exit;
}
$count = 0;
while (!$rs->EOF) {
$id = $rs->fields["id"];
// load
db_get_value($db, "plugins", "class_php", "id=" . $rs->fields["type"], $class);
$source = SourceFactory::createInstance($class, $config, $id_account_current, $db, null, null);
$source->load($rs->GetRowAssoc());
// delete
$delstmt = new db_stmt_delete('sources');
$delstmt->setWhereClause("id = '" . $id . "'");
$s = $delstmt->getStatement();
if (!$db->Execute($s)) {
echo 'Error while deleting record ' . $id;
exit;
} else {
// insert
$s = $source->getSqlStmt('insert');
if (!$db->Execute($s)) {
echo 'Error while writing record ' . $id;
echo '</br>Stop upgrade (' . $count . ' sources upgraded)';
echo '</br>' . $db->ErrorMsg();
