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