X-Git-Url: https://git.wh0rd.org/?a=blobdiff_plain;f=update.php;h=216a9c1f47758aa7030541a8cb46db5642e2a861;hb=9044e2e062e6e4cfc750613588557606704cd649;hp=8a00cdd55b087d7453f4708be2d875fae0bbeacd;hpb=73ef6f0459883667f4459e4d7e165eb3e587bb9e;p=tt-rss.git diff --git a/update.php b/update.php index 8a00cdd5..216a9c1f 100755 --- a/update.php +++ b/update.php @@ -346,24 +346,21 @@ while (true) { $result = db_query("SELECT id, title, content FROM ttrss_entries WHERE tsvector_combined IS NULL ORDER BY id LIMIT $limit"); - if (db_num_rows($result) != 0) { - while ($line = db_fetch_assoc($result)) { - $tsvector_combined = db_escape_string(mb_substr($line['title'] . ' ' . strip_tags($line['content']), - 0, 1000000)); + while ($line = db_fetch_assoc($result)) { + $tsvector_combined = db_escape_string(mb_substr($line['title'] . ' ' . strip_tags($line['content']), + 0, 1000000)); - db_query("UPDATE ttrss_entries SET tsvector_combined = to_tsvector('english', '$tsvector_combined') WHERE id = " . $line["id"]); - } + db_query("UPDATE ttrss_entries SET tsvector_combined = to_tsvector('english', '$tsvector_combined') WHERE id = " . $line["id"]); + } - $processed += db_num_rows($result); - print "Processed $processed articles...\n"; + $processed += db_num_rows($result); + print "Processed $processed articles...\n"; - } else { + if (db_num_rows($result) != $limit) { echo "All done.\n"; break; } - } - } if (isset($options["list-plugins"])) {