feedController.php 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653
  1. <?php
  2. /**
  3. * Controller to handle every feed actions.
  4. */
  5. class FreshRSS_feed_Controller extends Minz_ActionController {
  6. /**
  7. * This action is called before every other action in that class. It is
  8. * the common boiler plate for every action. It is triggered by the
  9. * underlying framework.
  10. */
  11. public function firstAction() {
  12. if (!FreshRSS_Auth::hasAccess()) {
  13. // Token is useful in the case that anonymous refresh is forbidden
  14. // and CRON task cannot be used with php command so the user can
  15. // set a CRON task to refresh his feeds by using token inside url
  16. $token = FreshRSS_Context::$user_conf->token;
  17. $token_param = Minz_Request::param('token', '');
  18. $token_is_ok = ($token != '' && $token == $token_param);
  19. $action = Minz_Request::actionName();
  20. $allow_anonymous_refresh = FreshRSS_Context::$system_conf->allow_anonymous_refresh;
  21. if ($action !== 'actualize' ||
  22. !($allow_anonymous_refresh || $token_is_ok)) {
  23. Minz_Error::error(403);
  24. }
  25. }
  26. $this->updateTTL();
  27. }
  28. /**
  29. * @param $url
  30. * @param string $title
  31. * @param int $cat_id
  32. * @param string $new_cat_name
  33. * @param string $http_auth
  34. * @return FreshRSS_Feed|the
  35. * @throws FreshRSS_AlreadySubscribed_Exception
  36. * @throws FreshRSS_FeedNotAdded_Exception
  37. * @throws FreshRSS_Feed_Exception
  38. * @throws Minz_FileNotExistException
  39. */
  40. public static function addFeed($url, $title = '', $cat_id = 0, $new_cat_name = '', $http_auth = '') {
  41. FreshRSS_UserDAO::touch();
  42. @set_time_limit(300);
  43. $catDAO = new FreshRSS_CategoryDAO();
  44. $url = trim($url);
  45. $cat = null;
  46. if ($new_cat_name != '') {
  47. $new_cat_id = $catDAO->addCategory(array('name' => $new_cat_name));
  48. $cat_id = $new_cat_id > 0 ? $new_cat_id : $cat_id;
  49. }
  50. if ($cat_id > 0) {
  51. $cat = $catDAO->searchById($cat_id);
  52. }
  53. if ($cat == null) {
  54. $catDAO->checkDefault();
  55. }
  56. $cat_id = $cat == null ? FreshRSS_CategoryDAO::DEFAULTCATEGORYID : $cat->id();
  57. $feed = new FreshRSS_Feed($url); //Throws FreshRSS_BadUrl_Exception
  58. $feed->_httpAuth($http_auth);
  59. $feed->load(true); //Throws FreshRSS_Feed_Exception, Minz_FileNotExistException
  60. $feed->_category($cat_id);
  61. $feedDAO = FreshRSS_Factory::createFeedDao();
  62. if ($feedDAO->searchByUrl($feed->url())) {
  63. throw new FreshRSS_AlreadySubscribed_Exception($url, $feed->name());
  64. }
  65. /** @var FreshRSS_Feed $feed */
  66. $feed = Minz_ExtensionManager::callHook('feed_before_insert', $feed);
  67. if ($feed === null) {
  68. throw new FreshRSS_FeedNotAdded_Exception($url, $feed->name());
  69. }
  70. $values = array(
  71. 'url' => $feed->url(),
  72. 'category' => $feed->category(),
  73. 'name' => $title != '' ? $title : $feed->name(),
  74. 'website' => $feed->website(),
  75. 'description' => $feed->description(),
  76. 'lastUpdate' => time(),
  77. 'httpAuth' => $feed->httpAuth(),
  78. );
  79. $id = $feedDAO->addFeed($values);
  80. if (!$id) {
  81. // There was an error in database... we cannot say what here.
  82. throw new FreshRSS_FeedNotAdded_Exception($url, $feed->name());
  83. }
  84. $feed->_id($id);
  85. // Ok, feed has been added in database. Now we have to refresh entries.
  86. self::actualizeFeed($id, $url, false, null, true);
  87. return $feed;
  88. }
  89. /**
  90. * This action subscribes to a feed.
  91. *
  92. * It can be reached by both GET and POST requests.
  93. *
  94. * GET request displays a form to add and configure a feed.
  95. * Request parameter is:
  96. * - url_rss (default: false)
  97. *
  98. * POST request adds a feed in database.
  99. * Parameters are:
  100. * - url_rss (default: false)
  101. * - category (default: false)
  102. * - new_category (required if category == 'nc')
  103. * - http_user (default: false)
  104. * - http_pass (default: false)
  105. * It tries to get website information from RSS feed.
  106. * If no category is given, feed is added to the default one.
  107. *
  108. * If url_rss is false, nothing happened.
  109. */
  110. public function addAction() {
  111. $url = Minz_Request::param('url_rss');
  112. if ($url === false) {
  113. // No url, do nothing
  114. Minz_Request::forward(array(
  115. 'c' => 'subscription',
  116. 'a' => 'index'
  117. ), true);
  118. }
  119. $feedDAO = FreshRSS_Factory::createFeedDao();
  120. $url_redirect = array(
  121. 'c' => 'subscription',
  122. 'a' => 'index',
  123. 'params' => array(),
  124. );
  125. $limits = FreshRSS_Context::$system_conf->limits;
  126. $this->view->feeds = $feedDAO->listFeeds();
  127. if (count($this->view->feeds) >= $limits['max_feeds']) {
  128. Minz_Request::bad(_t('feedback.sub.feed.over_max', $limits['max_feeds']),
  129. $url_redirect);
  130. }
  131. if (Minz_Request::isPost()) {
  132. $cat = Minz_Request::param('category');
  133. $new_cat_name = '';
  134. if ($cat === 'nc') {
  135. // User want to create a new category, new_category parameter
  136. // must exist
  137. $new_cat = Minz_Request::param('new_category');
  138. $new_cat_name = isset($new_cat['name']) ? trim($new_cat['name']) : '';
  139. }
  140. // HTTP information are useful if feed is protected behind a
  141. // HTTP authentication
  142. $user = trim(Minz_Request::param('http_user', ''));
  143. $pass = Minz_Request::param('http_pass', '');
  144. $http_auth = '';
  145. if ($user != '' && $pass != '') { //TODO: Sanitize
  146. $http_auth = $user . ':' . $pass;
  147. }
  148. try {
  149. $feed = self::addFeed($url, '', $cat, $new_cat_name, $http_auth);
  150. } catch (FreshRSS_BadUrl_Exception $e) {
  151. // Given url was not a valid url!
  152. Minz_Log::warning($e->getMessage());
  153. Minz_Request::bad(_t('feedback.sub.feed.invalid_url', $url), $url_redirect);
  154. } catch (FreshRSS_Feed_Exception $e) {
  155. // Something went bad (timeout, server not found, etc.)
  156. Minz_Log::warning($e->getMessage());
  157. Minz_Request::bad(_t('feedback.sub.feed.internal_problem', _url('index', 'logs')), $url_redirect);
  158. } catch (Minz_FileNotExistException $e) {
  159. // Cache directory doesn't exist!
  160. Minz_Log::error($e->getMessage());
  161. Minz_Request::bad(_t('feedback.sub.feed.internal_problem', _url('index', 'logs')), $url_redirect);
  162. } catch (FreshRSS_AlreadySubscribed_Exception $e) {
  163. Minz_Request::bad(_t('feedback.sub.feed.already_subscribed', $e->feedName()), $url_redirect);
  164. } catch (FreshRSS_FeedNotAdded_Exception $e) {
  165. Minz_Request::bad(_t('feedback.sub.feed.not_added', $e->feedName()), $url_redirect);
  166. }
  167. // Entries are in DB, we redirect to feed configuration page.
  168. $url_redirect['params']['id'] = $feed->id();
  169. Minz_Request::good(_t('feedback.sub.feed.added', $feed->name()), $url_redirect);
  170. } else {
  171. // GET request: we must ask confirmation to user before adding feed.
  172. Minz_View::prependTitle(_t('sub.feed.title_add') . ' · ');
  173. $this->catDAO = new FreshRSS_CategoryDAO();
  174. $this->view->categories = $this->catDAO->listCategories(false);
  175. $this->view->feed = new FreshRSS_Feed($url);
  176. try {
  177. // We try to get more information about the feed.
  178. $this->view->feed->load(true);
  179. $this->view->load_ok = true;
  180. } catch (Exception $e) {
  181. $this->view->load_ok = false;
  182. }
  183. $feed = $feedDAO->searchByUrl($this->view->feed->url());
  184. if ($feed) {
  185. // Already subscribe so we redirect to the feed configuration page.
  186. $url_redirect['params']['id'] = $feed->id();
  187. Minz_Request::good(_t('feedback.sub.feed.already_subscribed', $feed->name()), $url_redirect);
  188. }
  189. }
  190. }
  191. /**
  192. * This action remove entries from a given feed.
  193. *
  194. * It should be reached by a POST action.
  195. *
  196. * Parameter is:
  197. * - id (default: false)
  198. */
  199. public function truncateAction() {
  200. $id = Minz_Request::param('id');
  201. $url_redirect = array(
  202. 'c' => 'subscription',
  203. 'a' => 'index',
  204. 'params' => array('id' => $id)
  205. );
  206. if (!Minz_Request::isPost()) {
  207. Minz_Request::forward($url_redirect, true);
  208. }
  209. $feedDAO = FreshRSS_Factory::createFeedDao();
  210. $n = $feedDAO->truncate($id);
  211. invalidateHttpCache();
  212. if ($n === false) {
  213. Minz_Request::bad(_t('feedback.sub.feed.error'), $url_redirect);
  214. } else {
  215. Minz_Request::good(_t('feedback.sub.feed.n_entries_deleted', $n), $url_redirect);
  216. }
  217. }
  218. public static function actualizeFeed($feed_id, $feed_url, $force, $simplePiePush = null, $isNewFeed = false, $noCommit = false) {
  219. @set_time_limit(300);
  220. $feedDAO = FreshRSS_Factory::createFeedDao();
  221. $entryDAO = FreshRSS_Factory::createEntryDao();
  222. // Create a list of feeds to actualize.
  223. // If feed_id is set and valid, corresponding feed is added to the list but
  224. // alone in order to automatize further process.
  225. $feeds = array();
  226. if ($feed_id > 0 || $feed_url) {
  227. $feed = $feed_id > 0 ? $feedDAO->searchById($feed_id) : $feedDAO->searchByUrl($feed_url);
  228. if ($feed) {
  229. $feeds[] = $feed;
  230. }
  231. } else {
  232. $feeds = $feedDAO->listFeedsOrderUpdate(-1);
  233. }
  234. // Calculate date of oldest entries we accept in DB.
  235. $nb_month_old = max(FreshRSS_Context::$user_conf->old_entries, 1);
  236. $date_min = time() - (3600 * 24 * 30 * $nb_month_old);
  237. // PubSubHubbub support
  238. $pubsubhubbubEnabledGeneral = FreshRSS_Context::$system_conf->pubsubhubbub_enabled;
  239. $pshbMinAge = time() - (3600 * 24); //TODO: Make a configuration.
  240. $updated_feeds = 0;
  241. $nb_new_articles = 0;
  242. $is_read = FreshRSS_Context::$user_conf->mark_when['reception'] ? 1 : 0;
  243. foreach ($feeds as $feed) {
  244. $url = $feed->url(); //For detection of HTTP 301
  245. $pubSubHubbubEnabled = $pubsubhubbubEnabledGeneral && $feed->pubSubHubbubEnabled();
  246. if ((!$simplePiePush) && (!$feed_id) && $pubSubHubbubEnabled && ($feed->lastUpdate() > $pshbMinAge)) {
  247. //$text = 'Skip pull of feed using PubSubHubbub: ' . $url;
  248. //Minz_Log::debug($text);
  249. //Minz_Log::debug($text, PSHB_LOG);
  250. continue; //When PubSubHubbub is used, do not pull refresh so often
  251. }
  252. $mtime = 0;
  253. $ttl = $feed->ttl();
  254. if ($ttl < FreshRSS_Feed::TTL_DEFAULT) {
  255. continue; //Feed refresh is disabled
  256. }
  257. if ((!$simplePiePush) && (!$feed_id) &&
  258. ($feed->lastUpdate() + 10 >= time() - ($ttl == FreshRSS_Feed::TTL_DEFAULT ? FreshRSS_Context::$user_conf->ttl_default : $ttl))) {
  259. //Too early to refresh from source, but check whether the feed was updated by another user
  260. $mtime = $feed->cacheModifiedTime();
  261. if ($feed->lastUpdate() + 10 >= $mtime) {
  262. continue; //Nothing newer from other users
  263. }
  264. //Minz_Log::debug($feed->url() . ' was updated at ' . date('c', $mtime) . ' by another user');
  265. //Will take advantage of the newer cache
  266. }
  267. if (!$feed->lock()) {
  268. Minz_Log::notice('Feed already being actualized: ' . $feed->url());
  269. continue;
  270. }
  271. try {
  272. if ($simplePiePush) {
  273. $feed->loadEntries($simplePiePush); //Used by PubSubHubbub
  274. } else {
  275. $feed->load(false, $isNewFeed);
  276. }
  277. } catch (FreshRSS_Feed_Exception $e) {
  278. Minz_Log::warning($e->getMessage());
  279. $feedDAO->updateLastUpdate($feed->id(), true);
  280. $feed->unlock();
  281. continue;
  282. }
  283. $feed_history = $feed->keepHistory();
  284. if ($isNewFeed) {
  285. $feed_history = FreshRSS_Feed::KEEP_HISTORY_INFINITE;
  286. } elseif (FreshRSS_Feed::KEEP_HISTORY_DEFAULT === $feed_history) {
  287. $feed_history = FreshRSS_Context::$user_conf->keep_history_default;
  288. }
  289. $needFeedCacheRefresh = false;
  290. // We want chronological order and SimplePie uses reverse order.
  291. $entries = array_reverse($feed->entries());
  292. if (count($entries) > 0) {
  293. $newGuids = array();
  294. foreach ($entries as $entry) {
  295. $newGuids[] = safe_ascii($entry->guid());
  296. }
  297. // For this feed, check existing GUIDs already in database.
  298. $existingHashForGuids = $entryDAO->listHashForFeedGuids($feed->id(), $newGuids);
  299. $newGuids = array();
  300. $oldGuids = array();
  301. // Add entries in database if possible.
  302. foreach ($entries as $entry) {
  303. if (isset($newGuids[$entry->guid()])) {
  304. continue; //Skip subsequent articles with same GUID
  305. }
  306. $newGuids[$entry->guid()] = true;
  307. $entry_date = $entry->date(true);
  308. if (isset($existingHashForGuids[$entry->guid()])) {
  309. $existingHash = $existingHashForGuids[$entry->guid()];
  310. if (strcasecmp($existingHash, $entry->hash()) === 0 || trim($existingHash, '0') == '') {
  311. //This entry already exists and is unchanged. TODO: Remove the test with the zero'ed hash in FreshRSS v1.3
  312. $oldGuids[] = $entry->guid();
  313. } else { //This entry already exists but has been updated
  314. //Minz_Log::debug('Entry with GUID `' . $entry->guid() . '` updated in feed ' . $feed->id() .
  315. //', old hash ' . $existingHash . ', new hash ' . $entry->hash());
  316. //TODO: Make an updated/is_read policy by feed, in addition to the global one.
  317. $needFeedCacheRefresh = FreshRSS_Context::$user_conf->mark_updated_article_unread;
  318. $entry->_isRead(FreshRSS_Context::$user_conf->mark_updated_article_unread ? false : null); //Change is_read according to policy.
  319. if (!$entryDAO->inTransaction()) {
  320. $entryDAO->beginTransaction();
  321. }
  322. $entryDAO->updateEntry($entry->toArray());
  323. }
  324. } elseif ($feed_history == 0 && $entry_date < $date_min) {
  325. // This entry should not be added considering configuration and date.
  326. $oldGuids[] = $entry->guid();
  327. } else {
  328. if ($isNewFeed) {
  329. $id = min(time(), $entry_date) . uSecString();
  330. $entry->_isRead($is_read);
  331. } elseif ($entry_date < $date_min) {
  332. $id = min(time(), $entry_date) . uSecString();
  333. $entry->_isRead(true); //Old article that was not in database. Probably an error, so mark as read
  334. } else {
  335. $id = uTimeString();
  336. $entry->_isRead($is_read);
  337. }
  338. $entry->_id($id);
  339. $entry = Minz_ExtensionManager::callHook('entry_before_insert', $entry);
  340. if ($entry === null) {
  341. // An extension has returned a null value, there is nothing to insert.
  342. continue;
  343. }
  344. if ($pubSubHubbubEnabled && !$simplePiePush) { //We use push, but have discovered an article by pull!
  345. $text = 'An article was discovered by pull although we use PubSubHubbub!: Feed ' . $url . ' GUID ' . $entry->guid();
  346. Minz_Log::warning($text, PSHB_LOG);
  347. Minz_Log::warning($text);
  348. $pubSubHubbubEnabled = false;
  349. $feed->pubSubHubbubError(true);
  350. }
  351. if (!$entryDAO->inTransaction()) {
  352. $entryDAO->beginTransaction();
  353. }
  354. $entryDAO->addEntry($entry->toArray());
  355. $nb_new_articles++;
  356. }
  357. }
  358. $entryDAO->updateLastSeen($feed->id(), $oldGuids, $mtime);
  359. }
  360. if ($feed_history >= 0 && rand(0, 30) === 1) {
  361. // TODO: move this function in web cron when available (see entry::purge)
  362. // Remove old entries once in 30.
  363. if (!$entryDAO->inTransaction()) {
  364. $entryDAO->beginTransaction();
  365. }
  366. $nb = $feedDAO->cleanOldEntries($feed->id(),
  367. $date_min,
  368. max($feed_history, count($entries) + 10));
  369. if ($nb > 0) {
  370. $needFeedCacheRefresh = true;
  371. Minz_Log::debug($nb . ' old entries cleaned in feed [' .
  372. $feed->url() . ']');
  373. }
  374. }
  375. $feedDAO->updateLastUpdate($feed->id(), false, $mtime);
  376. if ($needFeedCacheRefresh) {
  377. $feedDAO->updateCachedValue($feed->id());
  378. }
  379. if ($entryDAO->inTransaction()) {
  380. $entryDAO->commit();
  381. }
  382. if ($feed->hubUrl() && $feed->selfUrl()) { //selfUrl has priority for PubSubHubbub
  383. if ($feed->selfUrl() !== $url) { //https://code.google.com/p/pubsubhubbub/wiki/MovingFeedsOrChangingHubs
  384. $selfUrl = checkUrl($feed->selfUrl());
  385. if ($selfUrl) {
  386. Minz_Log::debug('PubSubHubbub unsubscribe ' . $feed->url());
  387. if (!$feed->pubSubHubbubSubscribe(false)) { //Unsubscribe
  388. Minz_Log::warning('Error while PubSubHubbub unsubscribing from ' . $feed->url());
  389. }
  390. $feed->_url($selfUrl, false);
  391. Minz_Log::notice('Feed ' . $url . ' canonical address moved to ' . $feed->url());
  392. $feedDAO->updateFeed($feed->id(), array('url' => $feed->url()));
  393. }
  394. }
  395. } elseif ($feed->url() !== $url) { // HTTP 301 Moved Permanently
  396. Minz_Log::notice('Feed ' . $url . ' moved permanently to ' . $feed->url());
  397. $feedDAO->updateFeed($feed->id(), array('url' => $feed->url()));
  398. }
  399. $feed->faviconPrepare();
  400. if ($pubsubhubbubEnabledGeneral && $feed->pubSubHubbubPrepare()) {
  401. Minz_Log::notice('PubSubHubbub subscribe ' . $feed->url());
  402. if (!$feed->pubSubHubbubSubscribe(true)) { //Subscribe
  403. Minz_Log::warning('Error while PubSubHubbub subscribing to ' . $feed->url());
  404. }
  405. }
  406. $feed->unlock();
  407. $updated_feeds++;
  408. unset($feed);
  409. // No more than 10 feeds unless $force is true to avoid overloading
  410. // the server.
  411. if ($updated_feeds >= 10 && !$force) {
  412. break;
  413. }
  414. }
  415. if (!$noCommit) {
  416. if (!$entryDAO->inTransaction()) {
  417. $entryDAO->beginTransaction();
  418. }
  419. $entryDAO->commitNewEntries();
  420. $feedDAO->updateCachedValues();
  421. if ($entryDAO->inTransaction()) {
  422. $entryDAO->commit();
  423. }
  424. }
  425. return array($updated_feeds, reset($feeds), $nb_new_articles);
  426. }
  427. /**
  428. * This action actualizes entries from one or several feeds.
  429. *
  430. * Parameters are:
  431. * - id (default: false): Feed ID
  432. * - url (default: false): Feed URL
  433. * - force (default: false)
  434. * - noCommit (default: 0): Set to 1 to prevent committing the new articles to the main database
  435. * If id and url are not specified, all the feeds are actualized. But if force is
  436. * false, process stops at 10 feeds to avoid time execution problem.
  437. */
  438. public function actualizeAction() {
  439. Minz_Session::_param('actualize_feeds', false);
  440. $id = Minz_Request::param('id');
  441. $url = Minz_Request::param('url');
  442. $force = Minz_Request::param('force');
  443. $noCommit = Minz_Request::fetchPOST('noCommit', 0) == 1;
  444. if ($id == -1 && !$noCommit) { //Special request only to commit & refresh DB cache
  445. $updated_feeds = 0;
  446. $entryDAO = FreshRSS_Factory::createEntryDao();
  447. $feedDAO = FreshRSS_Factory::createFeedDao();
  448. $entryDAO->beginTransaction();
  449. $entryDAO->commitNewEntries();
  450. $feedDAO->updateCachedValues();
  451. $entryDAO->commit();
  452. } else {
  453. list($updated_feeds, $feed, $nb_new_articles) = self::actualizeFeed($id, $url, $force, null, false, $noCommit);
  454. }
  455. if (Minz_Request::param('ajax')) {
  456. // Most of the time, ajax request is for only one feed. But since
  457. // there are several parallel requests, we should return that there
  458. // are several updated feeds.
  459. $notif = array(
  460. 'type' => 'good',
  461. 'content' => _t('feedback.sub.feed.actualizeds')
  462. );
  463. Minz_Session::_param('notification', $notif);
  464. // No layout in ajax request.
  465. $this->view->_useLayout(false);
  466. } else {
  467. // Redirect to the main page with correct notification.
  468. if ($updated_feeds === 1) {
  469. Minz_Request::good(_t('feedback.sub.feed.actualized', $feed->name()), array(
  470. 'params' => array('get' => 'f_' . $feed->id())
  471. ));
  472. } elseif ($updated_feeds > 1) {
  473. Minz_Request::good(_t('feedback.sub.feed.n_actualized', $updated_feeds), array());
  474. } else {
  475. Minz_Request::good(_t('feedback.sub.feed.no_refresh'), array());
  476. }
  477. }
  478. return $updated_feeds;
  479. }
  480. public static function renameFeed($feed_id, $feed_name) {
  481. if ($feed_id <= 0 || $feed_name == '') {
  482. return false;
  483. }
  484. FreshRSS_UserDAO::touch();
  485. $feedDAO = FreshRSS_Factory::createFeedDao();
  486. return $feedDAO->updateFeed($feed_id, array('name' => $feed_name));
  487. }
  488. public static function moveFeed($feed_id, $cat_id, $new_cat_name = '') {
  489. if ($feed_id <= 0 || ($cat_id <= 0 && $new_cat_name == '')) {
  490. return false;
  491. }
  492. FreshRSS_UserDAO::touch();
  493. $catDAO = new FreshRSS_CategoryDAO();
  494. if ($cat_id > 0) {
  495. $cat = $catDAO->searchById($cat_id);
  496. $cat_id = $cat == null ? 0 : $cat->id();
  497. }
  498. if ($cat_id <= 1 && $new_cat_name != '') {
  499. $cat_id = $catDAO->addCategory(array('name' => $new_cat_name));
  500. }
  501. if ($cat_id <= 1) {
  502. $catDAO->checkDefault();
  503. $cat_id = FreshRSS_CategoryDAO::DEFAULTCATEGORYID;
  504. }
  505. $feedDAO = FreshRSS_Factory::createFeedDao();
  506. return $feedDAO->updateFeed($feed_id, array('category' => $cat_id));
  507. }
  508. /**
  509. * This action changes the category of a feed.
  510. *
  511. * This page must be reached by a POST request.
  512. *
  513. * Parameters are:
  514. * - f_id (default: false)
  515. * - c_id (default: false)
  516. * If c_id is false, default category is used.
  517. *
  518. * @todo should handle order of the feed inside the category.
  519. */
  520. public function moveAction() {
  521. if (!Minz_Request::isPost()) {
  522. Minz_Request::forward(array('c' => 'subscription'), true);
  523. }
  524. $feed_id = Minz_Request::param('f_id');
  525. $cat_id = Minz_Request::param('c_id');
  526. if (self::moveFeed($feed_id, $cat_id)) {
  527. // TODO: return something useful
  528. // Log a notice to prevent "Empty IF statement" warning in PHP_CodeSniffer
  529. Minz_Log::notice('Moved feed `' . $feed_id . '` ' .
  530. 'in the category `' . $cat_id . '`');;
  531. } else {
  532. Minz_Log::warning('Cannot move feed `' . $feed_id . '` ' .
  533. 'in the category `' . $cat_id . '`');
  534. Minz_Error::error(404);
  535. }
  536. }
  537. public static function deleteFeed($feed_id) {
  538. FreshRSS_UserDAO::touch();
  539. $feedDAO = FreshRSS_Factory::createFeedDao();
  540. if ($feedDAO->deleteFeed($feed_id)) {
  541. // TODO: Delete old favicon
  542. // Remove related queries
  543. FreshRSS_Context::$user_conf->queries = remove_query_by_get(
  544. 'f_' . $feed_id, FreshRSS_Context::$user_conf->queries);
  545. FreshRSS_Context::$user_conf->save();
  546. return true;
  547. }
  548. return false;
  549. }
  550. /**
  551. * This action deletes a feed.
  552. *
  553. * This page must be reached by a POST request.
  554. * If there are related queries, they are deleted too.
  555. *
  556. * Parameters are:
  557. * - id (default: false)
  558. * - r (default: false)
  559. * r permits to redirect to a given page at the end of this action.
  560. *
  561. * @todo handle "r" redirection in Minz_Request::forward()?
  562. */
  563. public function deleteAction() {
  564. $redirect_url = Minz_Request::param('r', false, true);
  565. if (!$redirect_url) {
  566. $redirect_url = array('c' => 'subscription', 'a' => 'index');
  567. }
  568. if (!Minz_Request::isPost()) {
  569. Minz_Request::forward($redirect_url, true);
  570. }
  571. $id = Minz_Request::param('id');
  572. if (self::deleteFeed($id)) {
  573. Minz_Request::good(_t('feedback.sub.feed.deleted'), $redirect_url);
  574. } else {
  575. Minz_Request::bad(_t('feedback.sub.feed.error'), $redirect_url);
  576. }
  577. }
  578. /**
  579. * This method update TTL values for feeds if needed.
  580. * It changes the old default value (-2) to the new default value (0).
  581. * It changes the old disabled value (-1) to the default disabled value.
  582. */
  583. private function updateTTL() {
  584. $feedDAO = FreshRSS_Factory::createFeedDao();
  585. $feedDAO->updateTTL();
  586. }
  587. }