"debug-feed:",
"force-refetch",
"force-rehash",
- "decrypt-feeds",
"help");
foreach (PluginHost::getInstance()->get_commands() as $command => $data) {
<head>
<title>Tiny Tiny RSS data update script.</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <link rel="stylesheet" type="text/css" href="css/utility.css">
</head>
<body>
print " --debug-feed N - perform debug update of feed N\n";
print " --force-refetch - debug update: force refetch feed data\n";
print " --force-rehash - debug update: force rehash articles\n";
- print " --decrypt-feeds - decrypt feed passwords\n";
print " --help - show this help\n";
print "Plugin options:\n";
if (isset($options["force-update"])) {
_debug("marking all feeds as needing update...");
- $pdo->query( "UPDATE ttrss_feeds SET
+ $pdo->query( "UPDATE ttrss_feeds SET
last_update_started = '1970-01-01', last_updated = '1970-01-01'");
}
$limit = 500;
$processed = 0;
- $sth = $pdo->prepare("SELECT id, title, content FROM ttrss_entries WHERE
+ $sth = $pdo->prepare("SELECT id, title, content FROM ttrss_entries WHERE
tsvector_combined IS NULL ORDER BY id LIMIT ?");
$sth->execute([$limit]);
- $usth = $pdo->prepare("UPDATE ttrss_entries
+ $usth = $pdo->prepare("UPDATE ttrss_entries
SET tsvector_combined = to_tsvector('english', ?) WHERE id = ?");
while (true) {
while ($line = $sth->fetch()) {
- $tsvector_combined = mb_substr($line['title'] . ' ' . strip_tags(str_replace('<', ' <', $line['content'])),
- 0, 1000000);
+ $tsvector_combined = mb_substr(strip_tags($line["title"] . " " . $line["content"]), 0, 1000000);
- $usth->execute([$tsvector_combined, $line['id']]);
+ $usth->execute([$tsvector_combined, $line['id']]);
- $processed++;
+ $processed++;
}
print "Processed $processed articles...\n";
exit($rc);
}
- if (isset($options["decrypt-feeds"])) {
-
- if (!function_exists("mcrypt_decrypt")) {
- _debug("mcrypt functions not available.");
- return;
- }
-
- $res = $pdo->query("SELECT id, auth_pass FROM ttrss_feeds WHERE auth_pass_encrypted = true");
-
- require_once "crypt.php";
-
- $total = 0;
-
- $pdo->beginTransaction();
-
- $usth = $pdo->prepare("UPDATE ttrss_feeds SET auth_pass_encrypted = false, auth_pass = ?
- WHERE id = ?");
-
- while ($line = $res->fetch()) {
- _debug("processing feed id " . $line["id"]);
-
- $auth_pass = decrypt_string($line["auth_pass"]);
-
- $usth->execute([$auth_pass, $line['id']]);
-
- ++$total;
- }
-
- $pdo->commit();
-
- _debug("$total feeds processed.");
- }
-
PluginHost::getInstance()->run_commands($options);
if (file_exists(LOCK_DIRECTORY . "/$lock_filename"))