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