Quick-and-dirty script for getting the source of articles added to a local install of ReAD before this commit: https://github.com/doersino/ReAD/commit/80f08d303f0b2cad7c9263b82ad59794c46208a9
<!-- gets source of your previously ReAD articles | |
before executing this file, update your database according to the | |
import.sql file (i.e. add a column "source" of type MEDIUMTEXT to the | |
"read" table) --> | |
<meta charset="UTF-8"><body style="overflow-x: scroll;"><pre><?php | |
error_reporting(E_ALL); | |
ini_set('max_execution_time', 30); | |
ini_set("user_agent", "Mozilla/5.0 (compatible; ReAD/1.0; +https://github.com/doersino/ReAD)"); | |
require_once "lib/meekrodb.2.3.class.php"; | |
require_once "Helper.class.php"; | |
if (!isset($_GET["offset"])) | |
die('no offset, <a href="?offset=0&limit=10">go to first page</a>'); | |
if (!isset($_GET["limit"])) | |
die('no limit, <a href="?offset=0&limit=10">go to first page</a>'); | |
$offset = intval($_GET["offset"]); | |
$limit = intval($_GET["limit"]); | |
$query = DB::query("SELECT `id`, `url`, `title` FROM `read` ORDER BY `time` DESC LIMIT %i OFFSET %i", $limit, $offset); | |
$i = 0; | |
for (; $i < count($query); ++$i) { | |
$url = $query[$i]["url"]; | |
$id = $query[$i]["id"]; | |
if (strpos($url, "fuckjetpacks.com/read/")) // fuck fuck jetpacks | |
$source = false; | |
else | |
$source = Helper::getSource($url); | |
if (empty($source)) | |
$source = ""; | |
DB::query("UPDATE `read` SET `source` = %s WHERE `id` = %i", $source, $id); | |
echo "<em>" . ($i + $offset) . "</em>\t" . $id . "\t<strong>" . strlen($source) . "</strong>\t\t<a href=\"" . htmlspecialchars($url, ENT_QUOTES, "UTF-8") . "\">" . htmlspecialchars($url, ENT_QUOTES, "UTF-8") . "</a> [" . trim(str_replace("\n", "", $query[$i]["title"])) . "]\n"; | |
} | |
?> | |
done <em><?php echo $offset . "</em>-<em>" . ($i + $offset - 1); ?></em> of <em><?php echo DB::queryFirstField("SELECT COUNT(*) AS 'count' FROM `read`") - 1; ?></em> | |
<form action="update.php" method="get">next <input type="hidden" name="offset" value="<?php echo $offset + $limit; ?>"><input type="text" name="limit" value="<?php echo $limit; ?>" autofocus="autofocus"><input type="submit" value="go"></form> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment