if (!isset($_GET["first"]) || !isset($_GET["last"])) {
redirect(url(".", array("first" => 1, "last" => 2000)));
}
$first = intval($_GET["first"]);
$last = intval($_GET["last"]);
$isFinished = false;
$result = sql_query("SELECT MAX(`objid`) FROM `objects`");
if ($data = mysql_fetch_row($result)) {
if ($last > $data[0]) {
$last = $data[0];
$isFinished = true;
}
}
include_once INCLUDES . "files.php";
for ($objid = $first; $objid <= $last; $objid++) {
updateFilterKeywords($objid);
}
echo "Updating filters and keywords for submissions from {$first} to {$last}...";
$_documentTitle = "{$first} to {$last}";
if (!$isFinished) {
?>
<script type="text/javascript">
//<![CDATA[
window.setTimeout(
"document.location='<?php
echo url(".", array("first" => $last + 1, "last" => $last + 2000), '&');
?>
';", 500);
//]]>
</script>
function submitKeywords($objid, $keywordList)
{
// Delete previous keywords, if any.
$sql = "DELETE FROM `objKeywords`" . dbWhere(array("objKobject" => $objid));
sql_query($sql);
// Add newly chosen keywords.
$idList = preg_split('/\\s/', $keywordList, -1, PREG_SPLIT_NO_EMPTY);
foreach ($idList as $keyid) {
$keyid = intval($keyid);
if ($keyid > 0) {
$sql = "SELECT `keyid` FROM `keywords`" . dbWhere(array("keyid" => $keyid));
$result = sql_query($sql);
if (mysql_num_rows($result) > 0 && $keyid > 0) {
$sql = "INSERT INTO `objKeywords`" . dbValues(array("objKobject" => $objid, "objKkeyword" => $keyid));
sql_query($sql);
}
}
}
updateFilterKeywords($objid);
}
