[tt-rss.git] / classes / rpc.php

<?php
class RPC extends Handler_Protected {

	function csrf_ignore($method) {
		$csrf_ignored = array("sanitycheck", "completelabels");

		return array_search($method, $csrf_ignored) !== false;
	}

	function setprofile() {
		$id = db_escape_string( $_REQUEST["id"]);

		$_SESSION["profile"] = $id;
		$_SESSION["prefs_cache"] = array();
	}

	function remprofiles() {
		$ids = explode(",", db_escape_string( trim($_REQUEST["ids"])));

		foreach ($ids as $id) {
			if ($_SESSION["profile"] != $id) {
				db_query( "DELETE FROM ttrss_settings_profiles WHERE id = '$id' AND
							owner_uid = " . $_SESSION["uid"]);
			}
		}
	}

	// Silent
	function addprofile() {
		$title = db_escape_string( trim($_REQUEST["title"]));
		if ($title) {
			db_query( "BEGIN");

			$result = db_query( "SELECT id FROM ttrss_settings_profiles
				WHERE title = '$title' AND owner_uid = " . $_SESSION["uid"]);

			if (db_num_rows($result) == 0) {

				db_query( "INSERT INTO ttrss_settings_profiles (title, owner_uid)
							VALUES ('$title', ".$_SESSION["uid"] .")");

				$result = db_query( "SELECT id FROM ttrss_settings_profiles WHERE
					title = '$title'");

				if (db_num_rows($result) != 0) {
					$profile_id = db_fetch_result($result, 0, "id");

					if ($profile_id) {
						initialize_user_prefs( $_SESSION["uid"], $profile_id);
					}
				}
			}

			db_query( "COMMIT");
		}
	}

	// Silent
	function saveprofile() {
		$id = db_escape_string( $_REQUEST["id"]);
		$title = db_escape_string( trim($_REQUEST["value"]));

		if ($id == 0) {
			print __("Default profile");
			return;
		}

		if ($title) {
			db_query( "BEGIN");

			$result = db_query( "SELECT id FROM ttrss_settings_profiles
				WHERE title = '$title' AND owner_uid =" . $_SESSION["uid"]);

			if (db_num_rows($result) == 0) {
				db_query( "UPDATE ttrss_settings_profiles
							SET title = '$title' WHERE id = '$id' AND
							owner_uid = " . $_SESSION["uid"]);
				print $title;
			} else {
				$result = db_query( "SELECT title FROM ttrss_settings_profiles
							WHERE id = '$id' AND owner_uid =" . $_SESSION["uid"]);
				print db_fetch_result($result, 0, "title");
			}

			db_query( "COMMIT");
		}
	}

	// Silent
	function remarchive() {
		$ids = explode(",", db_escape_string( $_REQUEST["ids"]));

		foreach ($ids as $id) {
			$result = db_query( "DELETE FROM ttrss_archived_feeds WHERE
		(SELECT COUNT(*) FROM ttrss_user_entries
							WHERE orig_feed_id = '$id') = 0 AND
		id = '$id' AND owner_uid = ".$_SESSION["uid"]);

			$rc = db_affected_rows( $result);
		}
	}

	function addfeed() {
		$feed = db_escape_string( $_REQUEST['feed']);
		$cat = db_escape_string( $_REQUEST['cat']);
		$login = db_escape_string( $_REQUEST['login']);
		$pass = trim($_REQUEST['pass']); // escaped later

		$rc = subscribe_to_feed( $feed, $cat, $login, $pass);

		print json_encode(array("result" => $rc));
	}

	function togglepref() {
		$key = db_escape_string( $_REQUEST["key"]);
		set_pref( $key, !get_pref( $key));
		$value = get_pref( $key);

		print json_encode(array("param" =>$key, "value" => $value));
	}

	function setpref() {
		// set_pref escapes input, so no need to double escape it here
		$key = $_REQUEST['key'];
		$value = str_replace("\n", "<br/>", $_REQUEST['value']);

		set_pref( $key, $value, $_SESSION['uid'], $key != 'USER_STYLESHEET');

		print json_encode(array("param" =>$key, "value" => $value));
	}

	function mark() {
		$mark = $_REQUEST["mark"];
		$id = db_escape_string( $_REQUEST["id"]);

		if ($mark == "1") {
			$mark = "true";
		} else {
			$mark = "false";
		}

		$result = db_query( "UPDATE ttrss_user_entries SET marked = $mark,
					last_marked = NOW()
					WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);

		print json_encode(array("message" => "UPDATE_COUNTERS"));
	}

	function delete() {
		$ids = db_escape_string( $_REQUEST["ids"]);

		$result = db_query( "DELETE FROM ttrss_user_entries
		WHERE ref_id IN ($ids) AND owner_uid = " . $_SESSION["uid"]);

		purge_orphans();

		print json_encode(array("message" => "UPDATE_COUNTERS"));
	}

	function unarchive() {
		$ids = explode(",", $_REQUEST["ids"]);

		foreach ($ids as $id) {
			$id = db_escape_string( trim($id));
			db_query( "BEGIN");

			$result = db_query( "SELECT feed_url,site_url,title FROM ttrss_archived_feeds
				WHERE id = (SELECT orig_feed_id FROM ttrss_user_entries WHERE ref_id = $id
				AND owner_uid = ".$_SESSION["uid"].")");

			if (db_num_rows($result) != 0) {
				$feed_url = db_escape_string( db_fetch_result($result, 0, "feed_url"));
				$site_url = db_escape_string( db_fetch_result($result, 0, "site_url"));
				$title = db_escape_string( db_fetch_result($result, 0, "title"));

				$result = db_query( "SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_url'
					AND owner_uid = " .$_SESSION["uid"]);

				if (db_num_rows($result) == 0) {

					if (!$title) $title = '[Unknown]';

					$result = db_query(
						"INSERT INTO ttrss_feeds
							(owner_uid,feed_url,site_url,title,cat_id,auth_login,auth_pass,update_method)
							VALUES (".$_SESSION["uid"].",
							'$feed_url',
							'$site_url',
							'$title',
							NULL, '', '', 0)");

					$result = db_query(
						"SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_url'
						AND owner_uid = ".$_SESSION["uid"]);

					if (db_num_rows($result) != 0) {
						$feed_id = db_fetch_result($result, 0, "id");
					}

				} else {
					$feed_id = db_fetch_result($result, 0, "id");
				}

				if ($feed_id) {
					$result = db_query( "UPDATE ttrss_user_entries
						SET feed_id = '$feed_id', orig_feed_id = NULL
						WHERE ref_id = $id AND owner_uid = " . $_SESSION["uid"]);
				}
			}

			db_query( "COMMIT");
		}

		print json_encode(array("message" => "UPDATE_COUNTERS"));
	}

	function archive() {
		$ids = explode(",", db_escape_string( $_REQUEST["ids"]));

		foreach ($ids as $id) {
			$this->archive_article( $id, $_SESSION["uid"]);
		}

		print json_encode(array("message" => "UPDATE_COUNTERS"));
	}

	private function archive_article( $id, $owner_uid) {
		db_query( "BEGIN");

		$result = db_query( "SELECT feed_id FROM ttrss_user_entries
			WHERE ref_id = '$id' AND owner_uid = $owner_uid");

		if (db_num_rows($result) != 0) {

			/* prepare the archived table */

			$feed_id = (int) db_fetch_result($result, 0, "feed_id");

			if ($feed_id) {
				$result = db_query( "SELECT id FROM ttrss_archived_feeds
					WHERE id = '$feed_id'");

				if (db_num_rows($result) == 0) {
					db_query( "INSERT INTO ttrss_archived_feeds
						(id, owner_uid, title, feed_url, site_url)
					SELECT id, owner_uid, title, feed_url, site_url from ttrss_feeds
				  	WHERE id = '$feed_id'");
				}

				db_query( "UPDATE ttrss_user_entries
					SET orig_feed_id = feed_id, feed_id = NULL
					WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
			}
		}

		db_query( "COMMIT");
	}

	function publ() {
		$pub = $_REQUEST["pub"];
		$id = db_escape_string( $_REQUEST["id"]);
		$note = trim(strip_tags(db_escape_string( $_REQUEST["note"])));

		if ($pub == "1") {
			$pub = "true";
		} else {
			$pub = "false";
		}

		$result = db_query( "UPDATE ttrss_user_entries SET
			published = $pub, last_published = NOW()
			WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);

		$pubsub_result = false;

		if (PUBSUBHUBBUB_HUB) {
			$rss_link = get_self_url_prefix() .
				"/public.php?op=rss&id=-2&key=" .
				get_feed_access_key( -2, false);

			$p = new Publisher(PUBSUBHUBBUB_HUB);

			$pubsub_result = $p->publish_update($rss_link);
		}

		print json_encode(array("message" => "UPDATE_COUNTERS",
			"pubsub_result" => $pubsub_result));
	}

	function getAllCounters() {
		$last_article_id = (int) $_REQUEST["last_article_id"];

		$reply = array();

		if ($seq) $reply['seq'] = $seq;

		if ($last_article_id != getLastArticleId()) {
			$reply['counters'] = getAllCounters();
		}

		$reply['runtime-info'] = make_runtime_info();

		print json_encode($reply);
	}

	/* GET["cmode"] = 0 - mark as read, 1 - as unread, 2 - toggle */
	function catchupSelected() {
		$ids = explode(",", db_escape_string( $_REQUEST["ids"]));
		$cmode = sprintf("%d", $_REQUEST["cmode"]);

		catchupArticlesById( $ids, $cmode);

		print json_encode(array("message" => "UPDATE_COUNTERS", "ids" => $ids));
	}

	function markSelected() {
		$ids = explode(",", db_escape_string( $_REQUEST["ids"]));
		$cmode = sprintf("%d", $_REQUEST["cmode"]);

		$this->markArticlesById( $ids, $cmode);

		print json_encode(array("message" => "UPDATE_COUNTERS"));
	}

	function publishSelected() {
		$ids = explode(",", db_escape_string( $_REQUEST["ids"]));
		$cmode = sprintf("%d", $_REQUEST["cmode"]);

		$this->publishArticlesById( $ids, $cmode);

		print json_encode(array("message" => "UPDATE_COUNTERS"));
	}

	function sanityCheck() {
		$_SESSION["hasAudio"] = $_REQUEST["hasAudio"] === "true";
		$_SESSION["hasSandbox"] = $_REQUEST["hasSandbox"] === "true";
		$_SESSION["hasMp3"] = $_REQUEST["hasMp3"] === "true";

		$reply = array();

		$reply['error'] = sanity_check();

		if ($reply['error']['code'] == 0) {
			$reply['init-params'] = make_init_params();
			$reply['runtime-info'] = make_runtime_info();
		}

		print json_encode($reply);
	}

	function completeLabels() {
		$search = db_escape_string( $_REQUEST["search"]);

		$result = db_query( "SELECT DISTINCT caption FROM
				ttrss_labels2
				WHERE owner_uid = '".$_SESSION["uid"]."' AND
				LOWER(caption) LIKE LOWER('$search%') ORDER BY caption
				LIMIT 5");

		print "<ul>";
		while ($line = db_fetch_assoc($result)) {
			print "<li>" . $line["caption"] . "</li>";
		}
		print "</ul>";
	}

	function purge() {
		$ids = explode(",", db_escape_string( $_REQUEST["ids"]));
		$days = sprintf("%d", $_REQUEST["days"]);

		foreach ($ids as $id) {

			$result = db_query( "SELECT id FROM ttrss_feeds WHERE
				id = '$id' AND owner_uid = ".$_SESSION["uid"]);

			if (db_num_rows($result) == 1) {
				purge_feed( $id, $days);
			}
		}
	}

	function updateFeedBrowser() {
		$search = db_escape_string( $_REQUEST["search"]);
		$limit = db_escape_string( $_REQUEST["limit"]);
		$mode = (int) db_escape_string( $_REQUEST["mode"]);

		require_once "feedbrowser.php";

		print json_encode(array("content" =>
			make_feed_browser( $search, $limit, $mode),
				"mode" => $mode));
	}

	// Silent
	function massSubscribe() {

		$payload = json_decode($_REQUEST["payload"], false);
		$mode = $_REQUEST["mode"];

		if (!$payload || !is_array($payload)) return;

		if ($mode == 1) {
			foreach ($payload as $feed) {

				$title = db_escape_string( $feed[0]);
				$feed_url = db_escape_string( $feed[1]);

				$result = db_query( "SELECT id FROM ttrss_feeds WHERE
					feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);

				if (db_num_rows($result) == 0) {
					$result = db_query( "INSERT INTO ttrss_feeds
									(owner_uid,feed_url,title,cat_id,site_url)
									VALUES ('".$_SESSION["uid"]."',
									'$feed_url', '$title', NULL, '')");
				}
			}
		} else if ($mode == 2) {
			// feed archive
			foreach ($payload as $id) {
				$result = db_query( "SELECT * FROM ttrss_archived_feeds
					WHERE id = '$id' AND owner_uid = " . $_SESSION["uid"]);

				if (db_num_rows($result) != 0) {
					$site_url = db_escape_string( db_fetch_result($result, 0, "site_url"));
					$feed_url = db_escape_string( db_fetch_result($result, 0, "feed_url"));
					$title = db_escape_string( db_fetch_result($result, 0, "title"));

					$result = db_query( "SELECT id FROM ttrss_feeds WHERE
						feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);

					if (db_num_rows($result) == 0) {
						$result = db_query( "INSERT INTO ttrss_feeds
										(owner_uid,feed_url,title,cat_id,site_url)
									VALUES ('$id','".$_SESSION["uid"]."',
									'$feed_url', '$title', NULL, '$site_url')");
					}
				}
			}
		}
	}

	function catchupFeed() {
		$feed_id = db_escape_string( $_REQUEST['feed_id']);
		$is_cat = db_escape_string( $_REQUEST['is_cat']) == "true";
		$mode = db_escape_string( $_REQUEST['mode']);

		catchup_feed( $feed_id, $is_cat, false, false, $mode);

		print json_encode(array("message" => "UPDATE_COUNTERS"));
	}

	function quickAddCat() {
		$cat = db_escape_string( $_REQUEST["cat"]);

		add_feed_category( $cat);

		$result = db_query( "SELECT id FROM ttrss_feed_categories WHERE
			title = '$cat' AND owner_uid = " . $_SESSION["uid"]);

		if (db_num_rows($result) == 1) {
			$id = db_fetch_result($result, 0, "id");
		} else {
			$id = 0;
		}

		print_feed_cat_select( "cat_id", $id);
	}

	// Silent
	function clearArticleKeys() {
		db_query( "UPDATE ttrss_user_entries SET uuid = '' WHERE
			owner_uid = " . $_SESSION["uid"]);

		return;
	}

	function setpanelmode() {
		$wide = (int) $_REQUEST["wide"];

		setcookie("ttrss_widescreen", $wide,
			time() + SESSION_COOKIE_LIFETIME);

		print json_encode(array("wide" => $wide));
	}

	function updaterandomfeed() {
		// Test if the feed need a update (update interval exceded).
		if (DB_TYPE == "pgsql") {
			$update_limit_qpart = "AND ((
					ttrss_feeds.update_interval = 0
					AND ttrss_feeds.last_updated < NOW() - CAST((ttrss_user_prefs.value || ' minutes') AS INTERVAL)
				) OR (
					ttrss_feeds.update_interval > 0
					AND ttrss_feeds.last_updated < NOW() - CAST((ttrss_feeds.update_interval || ' minutes') AS INTERVAL)
				) OR ttrss_feeds.last_updated IS NULL
				OR last_updated = '1970-01-01 00:00:00')";
		} else {
			$update_limit_qpart = "AND ((
					ttrss_feeds.update_interval = 0
					AND ttrss_feeds.last_updated < DATE_SUB(NOW(), INTERVAL CONVERT(ttrss_user_prefs.value, SIGNED INTEGER) MINUTE)
				) OR (
					ttrss_feeds.update_interval > 0
					AND ttrss_feeds.last_updated < DATE_SUB(NOW(), INTERVAL ttrss_feeds.update_interval MINUTE)
				) OR ttrss_feeds.last_updated IS NULL
				OR last_updated = '1970-01-01 00:00:00')";
		}

		// Test if feed is currently being updated by another process.
		if (DB_TYPE == "pgsql") {
			$updstart_thresh_qpart = "AND (ttrss_feeds.last_update_started IS NULL OR ttrss_feeds.last_update_started < NOW() - INTERVAL '5 minutes')";
		} else {
			$updstart_thresh_qpart = "AND (ttrss_feeds.last_update_started IS NULL OR ttrss_feeds.last_update_started < DATE_SUB(NOW(), INTERVAL 5 MINUTE))";
		}

		$random_qpart = sql_random_function();

		// We search for feed needing update.
		$result = db_query( "SELECT ttrss_feeds.feed_url,ttrss_feeds.id
			FROM
				ttrss_feeds, ttrss_users, ttrss_user_prefs
			WHERE
				ttrss_feeds.owner_uid = ttrss_users.id
				AND ttrss_users.id = ttrss_user_prefs.owner_uid
				AND ttrss_user_prefs.pref_name = 'DEFAULT_UPDATE_INTERVAL'
				AND ttrss_feeds.owner_uid = ".$_SESSION["uid"]."
				$update_limit_qpart $updstart_thresh_qpart
			ORDER BY $random_qpart LIMIT 30");

		$feed_id = -1;

		require_once "rssfuncs.php";

		$num_updated = 0;

		$tstart = time();

		while ($line = db_fetch_assoc($result)) {
			$feed_id = $line["id"];

			if (time() - $tstart < ini_get("max_execution_time") * 0.7) {
				update_rss_feed( $feed_id, true);
				++$num_updated;
			} else {
				break;
			}
		}

		// Purge orphans and cleanup tags
		purge_orphans();
		cleanup_tags( 14, 50000);

		if ($num_updated > 0) {
			print json_encode(array("message" => "UPDATE_COUNTERS",
				"num_updated" => $num_updated));
		} else {
			print json_encode(array("message" => "NOTHING_TO_UPDATE"));
		}

	}

	private function markArticlesById( $ids, $cmode) {

		$tmp_ids = array();

		foreach ($ids as $id) {
			array_push($tmp_ids, "ref_id = '$id'");
		}

		$ids_qpart = join(" OR ", $tmp_ids);

		if ($cmode == 0) {
			db_query( "UPDATE ttrss_user_entries SET
			marked = false, last_marked = NOW()
			WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
		} else if ($cmode == 1) {
			db_query( "UPDATE ttrss_user_entries SET
			marked = true, last_marked = NOW()
			WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
		} else {
			db_query( "UPDATE ttrss_user_entries SET
			marked = NOT marked,last_marked = NOW()
			WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
		}
	}

	private function publishArticlesById( $ids, $cmode) {

		$tmp_ids = array();

		foreach ($ids as $id) {
			array_push($tmp_ids, "ref_id = '$id'");
		}

		$ids_qpart = join(" OR ", $tmp_ids);

		if ($cmode == 0) {
			db_query( "UPDATE ttrss_user_entries SET
			published = false,last_published = NOW()
			WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
		} else if ($cmode == 1) {
			db_query( "UPDATE ttrss_user_entries SET
			published = true,last_published = NOW()
			WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
		} else {
			db_query( "UPDATE ttrss_user_entries SET
			published = NOT published,last_published = NOW()
			WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
		}

		if (PUBSUBHUBBUB_HUB) {
			$rss_link = get_self_url_prefix() .
				"/public.php?op=rss&id=-2&key=" .
				get_feed_access_key( -2, false);

			$p = new Publisher(PUBSUBHUBBUB_HUB);

			$pubsub_result = $p->publish_update($rss_link);
		}
	}

	function getlinktitlebyid() {
		$id = db_escape_string( $_REQUEST['id']);

		$result = db_query( "SELECT link, title FROM ttrss_entries, ttrss_user_entries
			WHERE ref_id = '$id' AND ref_id = id AND owner_uid = ". $_SESSION["uid"]);

		if (db_num_rows($result) != 0) {
			$link = db_fetch_result($result, 0, "link");
			$title = db_fetch_result($result, 0, "title");

			echo json_encode(array("link" => $link, "title" => $title));
		} else {
			echo json_encode(array("error" => "ARTICLE_NOT_FOUND"));
		}
	}

}
?>
Commit	Line	Data
d5112468	1	<?php
369dbc19	2	class RPC extends Handler_Protected {
d5112468	3
8484ce22	4	function csrf_ignore($method) {
6c2637d9	5	$csrf_ignored = array("sanitycheck", "completelabels");
8484ce22 AD	6
	7	return array_search($method, $csrf_ignored) !== false;
	8	}
	9
d5112468	10	function setprofile() {
6322ac79	11	$id = db_escape_string( $_REQUEST["id"]);
46da73c2	12
d5112468 AD	13	$_SESSION["profile"] = $id;
	14	$_SESSION["prefs_cache"] = array();
	15	}
	16
	17	function remprofiles() {
6322ac79	18	$ids = explode(",", db_escape_string( trim($_REQUEST["ids"])));
d5112468 AD	19
	20	foreach ($ids as $id) {
	21	if ($_SESSION["profile"] != $id) {
6322ac79	22	db_query( "DELETE FROM ttrss_settings_profiles WHERE id = '$id' AND
d5112468 AD	23	owner_uid = " . $_SESSION["uid"]);
	24	}
	25	}
	26	}
	27
	28	// Silent
	29	function addprofile() {
6322ac79	30	$title = db_escape_string( trim($_REQUEST["title"]));
d5112468	31	if ($title) {
6322ac79	32	db_query( "BEGIN");
d5112468	33
6322ac79	34	$result = db_query( "SELECT id FROM ttrss_settings_profiles
d5112468 AD	35	WHERE title = '$title' AND owner_uid = " . $_SESSION["uid"]);
	36
	37	if (db_num_rows($result) == 0) {
	38
6322ac79	39	db_query( "INSERT INTO ttrss_settings_profiles (title, owner_uid)
d5112468 AD	40	VALUES ('$title', ".$_SESSION["uid"] .")");
d5112468 AD	41
6322ac79	42	$result = db_query( "SELECT id FROM ttrss_settings_profiles WHERE
d5112468 AD	43	title = '$title'");
	44
	45	if (db_num_rows($result) != 0) {
	46	$profile_id = db_fetch_result($result, 0, "id");
	47
	48	if ($profile_id) {
6322ac79	49	initialize_user_prefs( $_SESSION["uid"], $profile_id);
d5112468 AD	50	}
	51	}
	52	}
	53
6322ac79	54	db_query( "COMMIT");
d5112468 AD	55	}
	56	}
	57
	58	// Silent
	59	function saveprofile() {
6322ac79 AD	60	$id = db_escape_string( $_REQUEST["id"]);
6322ac79 AD	61	$title = db_escape_string( trim($_REQUEST["value"]));
d5112468 AD	62
	63	if ($id == 0) {
	64	print __("Default profile");
	65	return;
	66	}
	67
	68	if ($title) {
6322ac79	69	db_query( "BEGIN");
d5112468	70
6322ac79	71	$result = db_query( "SELECT id FROM ttrss_settings_profiles
d5112468 AD	72	WHERE title = '$title' AND owner_uid =" . $_SESSION["uid"]);
	73
	74	if (db_num_rows($result) == 0) {
6322ac79	75	db_query( "UPDATE ttrss_settings_profiles
d5112468 AD	76	SET title = '$title' WHERE id = '$id' AND
	77	owner_uid = " . $_SESSION["uid"]);
	78	print $title;
	79	} else {
6322ac79	80	$result = db_query( "SELECT title FROM ttrss_settings_profiles
d5112468 AD	81	WHERE id = '$id' AND owner_uid =" . $_SESSION["uid"]);
	82	print db_fetch_result($result, 0, "title");
	83	}
	84
6322ac79	85	db_query( "COMMIT");
d5112468 AD	86	}
	87	}
	88
	89	// Silent
	90	function remarchive() {
6322ac79	91	$ids = explode(",", db_escape_string( $_REQUEST["ids"]));
d5112468 AD	92
d5112468 AD	93	foreach ($ids as $id) {
6322ac79	94	$result = db_query( "DELETE FROM ttrss_archived_feeds WHERE
d5112468 AD	95	(SELECT COUNT(*) FROM ttrss_user_entries
	96	WHERE orig_feed_id = '$id') = 0 AND
	97	id = '$id' AND owner_uid = ".$_SESSION["uid"]);
	98
6322ac79	99	$rc = db_affected_rows( $result);
d5112468 AD	100	}
	101	}
	102
	103	function addfeed() {
6322ac79 AD	104	$feed = db_escape_string( $_REQUEST['feed']);
	105	$cat = db_escape_string( $_REQUEST['cat']);
	106	$login = db_escape_string( $_REQUEST['login']);
41694a95	107	$pass = trim($_REQUEST['pass']); // escaped later
d5112468	108
6322ac79	109	$rc = subscribe_to_feed( $feed, $cat, $login, $pass);
d5112468 AD	110
	111	print json_encode(array("result" => $rc));
	112	}
	113
d5112468	114	function togglepref() {
6322ac79 AD	115	$key = db_escape_string( $_REQUEST["key"]);
	116	set_pref( $key, !get_pref( $key));
	117	$value = get_pref( $key);
d5112468 AD	118
	119	print json_encode(array("param" =>$key, "value" => $value));
	120	}
	121
	122	function setpref() {
0380cfa9	123	// set_pref escapes input, so no need to double escape it here
74eef4fc AD	124	$key = $_REQUEST['key'];
74eef4fc AD	125	$value = str_replace("\n", "<br/>", $_REQUEST['value']);
d5112468	126
6322ac79	127	set_pref( $key, $value, $_SESSION['uid'], $key != 'USER_STYLESHEET');
d5112468 AD	128
	129	print json_encode(array("param" =>$key, "value" => $value));
	130	}
	131
	132	function mark() {
	133	$mark = $_REQUEST["mark"];
6322ac79	134	$id = db_escape_string( $_REQUEST["id"]);
d5112468 AD	135
	136	if ($mark == "1") {
	137	$mark = "true";
	138	} else {
	139	$mark = "false";
	140	}
	141
6322ac79	142	$result = db_query( "UPDATE ttrss_user_entries SET marked = $mark,
7873d588	143	last_marked = NOW()
d5112468 AD	144	WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
	145
	146	print json_encode(array("message" => "UPDATE_COUNTERS"));
	147	}
	148
	149	function delete() {
6322ac79	150	$ids = db_escape_string( $_REQUEST["ids"]);
d5112468	151
6322ac79	152	$result = db_query( "DELETE FROM ttrss_user_entries
d5112468 AD	153	WHERE ref_id IN ($ids) AND owner_uid = " . $_SESSION["uid"]);
d5112468 AD	154
6322ac79	155	purge_orphans();
f0d3c94a	156
d5112468 AD	157	print json_encode(array("message" => "UPDATE_COUNTERS"));
	158	}
	159
	160	function unarchive() {
b029f916 AD	161	$ids = explode(",", $_REQUEST["ids"]);
	162
	163	foreach ($ids as $id) {
6322ac79 AD	164	$id = db_escape_string( trim($id));
6322ac79 AD	165	db_query( "BEGIN");
b029f916	166
6322ac79	167	$result = db_query( "SELECT feed_url,site_url,title FROM ttrss_archived_feeds
b029f916 AD	168	WHERE id = (SELECT orig_feed_id FROM ttrss_user_entries WHERE ref_id = $id
	169	AND owner_uid = ".$_SESSION["uid"].")");
	170
	171	if (db_num_rows($result) != 0) {
6322ac79 AD	172	$feed_url = db_escape_string( db_fetch_result($result, 0, "feed_url"));
	173	$site_url = db_escape_string( db_fetch_result($result, 0, "site_url"));
	174	$title = db_escape_string( db_fetch_result($result, 0, "title"));
b029f916	175
6322ac79	176	$result = db_query( "SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_url'
b029f916 AD	177	AND owner_uid = " .$_SESSION["uid"]);
	178
	179	if (db_num_rows($result) == 0) {
	180
	181	if (!$title) $title = '[Unknown]';
	182
6322ac79	183	$result = db_query(
b029f916 AD	184	"INSERT INTO ttrss_feeds
	185	(owner_uid,feed_url,site_url,title,cat_id,auth_login,auth_pass,update_method)
	186	VALUES (".$_SESSION["uid"].",
	187	'$feed_url',
	188	'$site_url',
	189	'$title',
	190	NULL, '', '', 0)");
d5112468	191
6322ac79	192	$result = db_query(
b029f916 AD	193	"SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_url'
	194	AND owner_uid = ".$_SESSION["uid"]);
	195
	196	if (db_num_rows($result) != 0) {
	197	$feed_id = db_fetch_result($result, 0, "id");
	198	}
	199
	200	} else {
	201	$feed_id = db_fetch_result($result, 0, "id");
	202	}
	203
	204	if ($feed_id) {
6322ac79	205	$result = db_query( "UPDATE ttrss_user_entries
b029f916 AD	206	SET feed_id = '$feed_id', orig_feed_id = NULL
	207	WHERE ref_id = $id AND owner_uid = " . $_SESSION["uid"]);
	208	}
	209	}
	210
6322ac79	211	db_query( "COMMIT");
b029f916	212	}
d5112468 AD	213
	214	print json_encode(array("message" => "UPDATE_COUNTERS"));
	215	}
	216
	217	function archive() {
6322ac79	218	$ids = explode(",", db_escape_string( $_REQUEST["ids"]));
d5112468 AD	219
d5112468 AD	220	foreach ($ids as $id) {
6322ac79	221	$this->archive_article( $id, $_SESSION["uid"]);
d5112468 AD	222	}
	223
	224	print json_encode(array("message" => "UPDATE_COUNTERS"));
	225	}
	226
6322ac79 AD	227	private function archive_article( $id, $owner_uid) {
6322ac79 AD	228	db_query( "BEGIN");
87d7e850	229
6322ac79	230	$result = db_query( "SELECT feed_id FROM ttrss_user_entries
87d7e850 AD	231	WHERE ref_id = '$id' AND owner_uid = $owner_uid");
	232
	233	if (db_num_rows($result) != 0) {
	234
	235	/* prepare the archived table */
	236
	237	$feed_id = (int) db_fetch_result($result, 0, "feed_id");
	238
	239	if ($feed_id) {
6322ac79	240	$result = db_query( "SELECT id FROM ttrss_archived_feeds
87d7e850 AD	241	WHERE id = '$feed_id'");
	242
	243	if (db_num_rows($result) == 0) {
6322ac79	244	db_query( "INSERT INTO ttrss_archived_feeds
87d7e850 AD	245	(id, owner_uid, title, feed_url, site_url)
	246	SELECT id, owner_uid, title, feed_url, site_url from ttrss_feeds
	247	WHERE id = '$feed_id'");
	248	}
	249
6322ac79	250	db_query( "UPDATE ttrss_user_entries
87d7e850 AD	251	SET orig_feed_id = feed_id, feed_id = NULL
	252	WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
	253	}
	254	}
	255
6322ac79	256	db_query( "COMMIT");
87d7e850 AD	257	}
87d7e850 AD	258
d5112468 AD	259	function publ() {
d5112468 AD	260	$pub = $_REQUEST["pub"];
6322ac79 AD	261	$id = db_escape_string( $_REQUEST["id"]);
6322ac79 AD	262	$note = trim(strip_tags(db_escape_string( $_REQUEST["note"])));
d5112468 AD	263
	264	if ($pub == "1") {
	265	$pub = "true";
	266	} else {
	267	$pub = "false";
	268	}
	269
6322ac79	270	$result = db_query( "UPDATE ttrss_user_entries SET
7873d588	271	published = $pub, last_published = NOW()
d5112468 AD	272	WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
	273
	274	$pubsub_result = false;
	275
	276	if (PUBSUBHUBBUB_HUB) {
	277	$rss_link = get_self_url_prefix() .
	278	"/public.php?op=rss&id=-2&key=" .
6322ac79	279	get_feed_access_key( -2, false);
d5112468 AD	280
	281	$p = new Publisher(PUBSUBHUBBUB_HUB);
	282
	283	$pubsub_result = $p->publish_update($rss_link);
	284	}
	285
	286	print json_encode(array("message" => "UPDATE_COUNTERS",
	287	"pubsub_result" => $pubsub_result));
	288	}
	289
	290	function getAllCounters() {
	291	$last_article_id = (int) $_REQUEST["last_article_id"];
	292
	293	$reply = array();
	294
5b55e9e2	295	if ($seq) $reply['seq'] = $seq;
d5112468	296
6322ac79 AD	297	if ($last_article_id != getLastArticleId()) {
6322ac79 AD	298	$reply['counters'] = getAllCounters();
5b55e9e2	299	}
d5112468	300
6322ac79	301	$reply['runtime-info'] = make_runtime_info();
d5112468	302
5b55e9e2	303	print json_encode($reply);
d5112468 AD	304	}
	305
	306	/* GET["cmode"] = 0 - mark as read, 1 - as unread, 2 - toggle */
	307	function catchupSelected() {
6322ac79	308	$ids = explode(",", db_escape_string( $_REQUEST["ids"]));
d5112468 AD	309	$cmode = sprintf("%d", $_REQUEST["cmode"]);
d5112468 AD	310
6322ac79	311	catchupArticlesById( $ids, $cmode);
d5112468	312
ae31704b	313	print json_encode(array("message" => "UPDATE_COUNTERS", "ids" => $ids));
d5112468 AD	314	}
	315
	316	function markSelected() {
6322ac79	317	$ids = explode(",", db_escape_string( $_REQUEST["ids"]));
d5112468 AD	318	$cmode = sprintf("%d", $_REQUEST["cmode"]);
d5112468 AD	319
6322ac79	320	$this->markArticlesById( $ids, $cmode);
d5112468 AD	321
	322	print json_encode(array("message" => "UPDATE_COUNTERS"));
	323	}
	324
	325	function publishSelected() {
6322ac79	326	$ids = explode(",", db_escape_string( $_REQUEST["ids"]));
d5112468 AD	327	$cmode = sprintf("%d", $_REQUEST["cmode"]);
d5112468 AD	328
6322ac79	329	$this->publishArticlesById( $ids, $cmode);
d5112468 AD	330
	331	print json_encode(array("message" => "UPDATE_COUNTERS"));
	332	}
	333
	334	function sanityCheck() {
	335	$_SESSION["hasAudio"] = $_REQUEST["hasAudio"] === "true";
4f7d69e1	336	$_SESSION["hasSandbox"] = $_REQUEST["hasSandbox"] === "true";
40fe2d73	337	$_SESSION["hasMp3"] = $_REQUEST["hasMp3"] === "true";
d5112468 AD	338
	339	$reply = array();
	340
6322ac79	341	$reply['error'] = sanity_check();
d5112468 AD	342
d5112468 AD	343	if ($reply['error']['code'] == 0) {
6322ac79 AD	344	$reply['init-params'] = make_init_params();
6322ac79 AD	345	$reply['runtime-info'] = make_runtime_info();
d5112468 AD	346	}
	347
	348	print json_encode($reply);
	349	}
	350
1b4d1a6b	351	function completeLabels() {
6322ac79	352	$search = db_escape_string( $_REQUEST["search"]);
1b4d1a6b	353
6322ac79	354	$result = db_query( "SELECT DISTINCT caption FROM
1b4d1a6b AD	355	ttrss_labels2
	356	WHERE owner_uid = '".$_SESSION["uid"]."' AND
	357	LOWER(caption) LIKE LOWER('$search%') ORDER BY caption
	358	LIMIT 5");
	359
	360	print "<ul>";
	361	while ($line = db_fetch_assoc($result)) {
	362	print "<li>" . $line["caption"] . "</li>";
	363	}
	364	print "</ul>";
	365	}
	366
d5112468	367	function purge() {
6322ac79	368	$ids = explode(",", db_escape_string( $_REQUEST["ids"]));
d5112468 AD	369	$days = sprintf("%d", $_REQUEST["days"]);
	370
	371	foreach ($ids as $id) {
	372
6322ac79	373	$result = db_query( "SELECT id FROM ttrss_feeds WHERE
d5112468 AD	374	id = '$id' AND owner_uid = ".$_SESSION["uid"]);
	375
	376	if (db_num_rows($result) == 1) {
6322ac79	377	purge_feed( $id, $days);
d5112468 AD	378	}
	379	}
	380	}
	381
d5112468	382	function updateFeedBrowser() {
6322ac79 AD	383	$search = db_escape_string( $_REQUEST["search"]);
	384	$limit = db_escape_string( $_REQUEST["limit"]);
	385	$mode = (int) db_escape_string( $_REQUEST["mode"]);
d5112468	386
55c7f092 AD	387	require_once "feedbrowser.php";
55c7f092 AD	388
d5112468	389	print json_encode(array("content" =>
6322ac79	390	make_feed_browser( $search, $limit, $mode),
d5112468 AD	391	"mode" => $mode));
	392	}
	393
	394	// Silent
	395	function massSubscribe() {
	396
	397	$payload = json_decode($_REQUEST["payload"], false);
	398	$mode = $_REQUEST["mode"];
	399
	400	if (!$payload \|\| !is_array($payload)) return;
	401
	402	if ($mode == 1) {
	403	foreach ($payload as $feed) {
	404
6322ac79 AD	405	$title = db_escape_string( $feed[0]);
6322ac79 AD	406	$feed_url = db_escape_string( $feed[1]);
d5112468	407
6322ac79	408	$result = db_query( "SELECT id FROM ttrss_feeds WHERE
d5112468 AD	409	feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);
	410
	411	if (db_num_rows($result) == 0) {
6322ac79	412	$result = db_query( "INSERT INTO ttrss_feeds
d5112468 AD	413	(owner_uid,feed_url,title,cat_id,site_url)
	414	VALUES ('".$_SESSION["uid"]."',
	415	'$feed_url', '$title', NULL, '')");
	416	}
	417	}
	418	} else if ($mode == 2) {
	419	// feed archive
	420	foreach ($payload as $id) {
6322ac79	421	$result = db_query( "SELECT * FROM ttrss_archived_feeds
d5112468 AD	422	WHERE id = '$id' AND owner_uid = " . $_SESSION["uid"]);
	423
	424	if (db_num_rows($result) != 0) {
6322ac79 AD	425	$site_url = db_escape_string( db_fetch_result($result, 0, "site_url"));
	426	$feed_url = db_escape_string( db_fetch_result($result, 0, "feed_url"));
	427	$title = db_escape_string( db_fetch_result($result, 0, "title"));
d5112468	428
6322ac79	429	$result = db_query( "SELECT id FROM ttrss_feeds WHERE
d5112468 AD	430	feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);
	431
	432	if (db_num_rows($result) == 0) {
6322ac79	433	$result = db_query( "INSERT INTO ttrss_feeds
d5112468 AD	434	(owner_uid,feed_url,title,cat_id,site_url)
	435	VALUES ('$id','".$_SESSION["uid"]."',
	436	'$feed_url', '$title', NULL, '$site_url')");
	437	}
	438	}
	439	}
	440	}
	441	}
	442
d5112468	443	function catchupFeed() {
6322ac79 AD	444	$feed_id = db_escape_string( $_REQUEST['feed_id']);
	445	$is_cat = db_escape_string( $_REQUEST['is_cat']) == "true";
	446	$mode = db_escape_string( $_REQUEST['mode']);
d5112468	447
6322ac79	448	catchup_feed( $feed_id, $is_cat, false, false, $mode);
d5112468 AD	449
	450	print json_encode(array("message" => "UPDATE_COUNTERS"));
	451	}
	452
d5112468	453	function quickAddCat() {
6322ac79	454	$cat = db_escape_string( $_REQUEST["cat"]);
d5112468	455
6322ac79	456	add_feed_category( $cat);
d5112468	457
6322ac79	458	$result = db_query( "SELECT id FROM ttrss_feed_categories WHERE
d5112468 AD	459	title = '$cat' AND owner_uid = " . $_SESSION["uid"]);
	460
	461	if (db_num_rows($result) == 1) {
	462	$id = db_fetch_result($result, 0, "id");
	463	} else {
	464	$id = 0;
	465	}
	466
6322ac79	467	print_feed_cat_select( "cat_id", $id);
d5112468 AD	468	}
d5112468 AD	469
d5112468 AD	470	// Silent
d5112468 AD	471	function clearArticleKeys() {
6322ac79	472	db_query( "UPDATE ttrss_user_entries SET uuid = '' WHERE
d5112468 AD	473	owner_uid = " . $_SESSION["uid"]);
	474
	475	return;
	476	}
	477
7d8f5657 AD	478	function setpanelmode() {
	479	$wide = (int) $_REQUEST["wide"];
	480
f03701fe AD	481	setcookie("ttrss_widescreen", $wide,
f03701fe AD	482	time() + SESSION_COOKIE_LIFETIME);
7d8f5657 AD	483
	484	print json_encode(array("wide" => $wide));
	485	}
	486
8b83bf5f AD	487	function updaterandomfeed() {
	488	// Test if the feed need a update (update interval exceded).
	489	if (DB_TYPE == "pgsql") {
	490	$update_limit_qpart = "AND ((
	491	ttrss_feeds.update_interval = 0
	492	AND ttrss_feeds.last_updated < NOW() - CAST((ttrss_user_prefs.value \|\| ' minutes') AS INTERVAL)
	493	) OR (
	494	ttrss_feeds.update_interval > 0
	495	AND ttrss_feeds.last_updated < NOW() - CAST((ttrss_feeds.update_interval \|\| ' minutes') AS INTERVAL)
	496	) OR ttrss_feeds.last_updated IS NULL
	497	OR last_updated = '1970-01-01 00:00:00')";
	498	} else {
	499	$update_limit_qpart = "AND ((
	500	ttrss_feeds.update_interval = 0
	501	AND ttrss_feeds.last_updated < DATE_SUB(NOW(), INTERVAL CONVERT(ttrss_user_prefs.value, SIGNED INTEGER) MINUTE)
	502	) OR (
	503	ttrss_feeds.update_interval > 0
	504	AND ttrss_feeds.last_updated < DATE_SUB(NOW(), INTERVAL ttrss_feeds.update_interval MINUTE)
	505	) OR ttrss_feeds.last_updated IS NULL
	506	OR last_updated = '1970-01-01 00:00:00')";
	507	}
	508
	509	// Test if feed is currently being updated by another process.
	510	if (DB_TYPE == "pgsql") {
	511	$updstart_thresh_qpart = "AND (ttrss_feeds.last_update_started IS NULL OR ttrss_feeds.last_update_started < NOW() - INTERVAL '5 minutes')";
	512	} else {
	513	$updstart_thresh_qpart = "AND (ttrss_feeds.last_update_started IS NULL OR ttrss_feeds.last_update_started < DATE_SUB(NOW(), INTERVAL 5 MINUTE))";
	514	}
	515
	516	$random_qpart = sql_random_function();
	517
	518	// We search for feed needing update.
6322ac79	519	$result = db_query( "SELECT ttrss_feeds.feed_url,ttrss_feeds.id
8b83bf5f AD	520	FROM
	521	ttrss_feeds, ttrss_users, ttrss_user_prefs
	522	WHERE
	523	ttrss_feeds.owner_uid = ttrss_users.id
	524	AND ttrss_users.id = ttrss_user_prefs.owner_uid
	525	AND ttrss_user_prefs.pref_name = 'DEFAULT_UPDATE_INTERVAL'
	526	AND ttrss_feeds.owner_uid = ".$_SESSION["uid"]."
	527	$update_limit_qpart $updstart_thresh_qpart
	528	ORDER BY $random_qpart LIMIT 30");
	529
	530	$feed_id = -1;
	531
	532	require_once "rssfuncs.php";
	533
	534	$num_updated = 0;
	535
	536	$tstart = time();
	537
	538	while ($line = db_fetch_assoc($result)) {
	539	$feed_id = $line["id"];
	540
6b1a4ecd	541	if (time() - $tstart < ini_get("max_execution_time") * 0.7) {
6322ac79	542	update_rss_feed( $feed_id, true);
8b83bf5f AD	543	++$num_updated;
	544	} else {
	545	break;
	546	}
	547	}
	548
cda55d67	549	// Purge orphans and cleanup tags
6322ac79 AD	550	purge_orphans();
6322ac79 AD	551	cleanup_tags( 14, 50000);
cda55d67	552
8b83bf5f AD	553	if ($num_updated > 0) {
	554	print json_encode(array("message" => "UPDATE_COUNTERS",
	555	"num_updated" => $num_updated));
	556	} else {
	557	print json_encode(array("message" => "NOTHING_TO_UPDATE"));
	558	}
	559
	560	}
	561
6322ac79	562	private function markArticlesById( $ids, $cmode) {
87d7e850 AD	563
	564	$tmp_ids = array();
	565
	566	foreach ($ids as $id) {
	567	array_push($tmp_ids, "ref_id = '$id'");
	568	}
	569
	570	$ids_qpart = join(" OR ", $tmp_ids);
	571
	572	if ($cmode == 0) {
6322ac79	573	db_query( "UPDATE ttrss_user_entries SET
7873d588	574	marked = false, last_marked = NOW()
87d7e850 AD	575	WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
87d7e850 AD	576	} else if ($cmode == 1) {
6322ac79	577	db_query( "UPDATE ttrss_user_entries SET
7873d588	578	marked = true, last_marked = NOW()
87d7e850 AD	579	WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
87d7e850 AD	580	} else {
6322ac79	581	db_query( "UPDATE ttrss_user_entries SET
7873d588	582	marked = NOT marked,last_marked = NOW()
87d7e850 AD	583	WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
	584	}
	585	}
	586
6322ac79	587	private function publishArticlesById( $ids, $cmode) {
87d7e850 AD	588
	589	$tmp_ids = array();
	590
	591	foreach ($ids as $id) {
	592	array_push($tmp_ids, "ref_id = '$id'");
	593	}
	594
	595	$ids_qpart = join(" OR ", $tmp_ids);
	596
	597	if ($cmode == 0) {
6322ac79	598	db_query( "UPDATE ttrss_user_entries SET
7873d588	599	published = false,last_published = NOW()
87d7e850 AD	600	WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
87d7e850 AD	601	} else if ($cmode == 1) {
6322ac79	602	db_query( "UPDATE ttrss_user_entries SET
7873d588	603	published = true,last_published = NOW()
87d7e850 AD	604	WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
87d7e850 AD	605	} else {
6322ac79	606	db_query( "UPDATE ttrss_user_entries SET
7873d588	607	published = NOT published,last_published = NOW()
87d7e850 AD	608	WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
	609	}
	610
	611	if (PUBSUBHUBBUB_HUB) {
	612	$rss_link = get_self_url_prefix() .
	613	"/public.php?op=rss&id=-2&key=" .
6322ac79	614	get_feed_access_key( -2, false);
87d7e850 AD	615
	616	$p = new Publisher(PUBSUBHUBBUB_HUB);
	617
	618	$pubsub_result = $p->publish_update($rss_link);
	619	}
	620	}
	621
5defc29f	622	function getlinktitlebyid() {
6322ac79	623	$id = db_escape_string( $_REQUEST['id']);
7fc2e87e	624
6322ac79	625	$result = db_query( "SELECT link, title FROM ttrss_entries, ttrss_user_entries
7fc2e87e AD	626	WHERE ref_id = '$id' AND ref_id = id AND owner_uid = ". $_SESSION["uid"]);
	627
	628	if (db_num_rows($result) != 0) {
	629	$link = db_fetch_result($result, 0, "link");
5defc29f	630	$title = db_fetch_result($result, 0, "title");
7fc2e87e	631
5defc29f	632	echo json_encode(array("link" => $link, "title" => $title));
7fc2e87e AD	633	} else {
	634	echo json_encode(array("error" => "ARTICLE_NOT_FOUND"));
	635	}
	636	}
	637
d5112468 AD	638	}
d5112468 AD	639	?>