]> git.wh0rd.org - tt-rss.git/blob - api/index.php
api: show virtual feeds in getFeeds (fixes)
[tt-rss.git] / api / index.php
1 <?php
2
3 /* This is experimental JSON-based API. It has to be manually enabled:
4 *
5 * Add define('_JSON_API_ENABLED', true) to config.php
6 */
7
8 error_reporting(E_ERROR | E_PARSE);
9
10 require_once "../config.php";
11
12 require_once "../db.php";
13 require_once "../db-prefs.php";
14 require_once "../functions.php";
15
16 if (!defined('_JSON_API_ENABLED')) {
17 print json_encode(array("error" => "API_DISABLED"));
18 return;
19 }
20
21 $link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
22
23 $session_expire = SESSION_EXPIRE_TIME; //seconds
24 $session_name = (!defined('TTRSS_SESSION_NAME')) ? "ttrss_sid_api" : TTRSS_SESSION_NAME . "_api";
25
26 session_start();
27
28 if (!$link) {
29 if (DB_TYPE == "mysql") {
30 print mysql_error();
31 }
32 // PG seems to display its own errors just fine by default.
33 return;
34 }
35
36 init_connection($link);
37
38 $op = db_escape_string($_REQUEST["op"]);
39
40 // header("Content-Type: application/json");
41
42 if (!$_SESSION["uid"] && $op != "login" && $op != "isLoggedIn") {
43 print json_encode(array("error" => 'NOT_LOGGED_IN'));
44 return;
45 }
46
47 /* TODO: add pref key to disable/enable API
48 if ($_SESSION["uid"] && !get_pref($link, 'API_ENABLED')) {
49 print json_encode(array("error" => 'API_DISABLED'));
50 return;
51 } */
52
53 switch ($op) {
54 case "getVersion":
55 $rv = array("version" => VERSION);
56 print json_encode($rv);
57 break;
58 case "login":
59 $login = db_escape_string($_REQUEST["user"]);
60 $password = db_escape_string($_REQUEST["password"]);
61
62 if (authenticate_user($link, $login, $password)) {
63 print json_encode(array("uid" => $_SESSION["uid"]));
64 } else {
65 print json_encode(array("uid" => 0));
66 }
67
68 break;
69 case "logout":
70 logout_user();
71 print json_encode(array("uid" => 0));
72 break;
73 case "isLoggedIn":
74 print json_encode(array("status" => $_SESSION["uid"] != ''));
75 break;
76 case "getUnread":
77 $feed_id = db_escape_string($_REQUEST["feed_id"]);
78 $is_cat = db_escape_string($_REQUEST["is_cat"]);
79
80 if ($feed_id) {
81 print json_encode(array("unread" => getFeedUnread($link, $feed_id, $is_cat)));
82 } else {
83 print json_encode(array("unread" => getGlobalUnread($link)));
84 }
85 break;
86 case "getFeeds":
87 $cat_id = db_escape_string($_REQUEST["cat_id"]);
88 $unread_only = (bool)db_escape_string($_REQUEST["unread_only"]);
89
90 if (!$cat_id) {
91 $result = db_query($link, "SELECT
92 id, feed_url, cat_id, title, ".
93 SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated
94 FROM ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
95 } else {
96 $result = db_query($link, "SELECT
97 id, feed_url, cat_id, title, ".
98 SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated
99 FROM ttrss_feeds WHERE
100 cat_id = '$cat_id' AND owner_uid = " . $_SESSION["uid"]);
101 }
102
103 $feeds = array();
104
105 while ($line = db_fetch_assoc($result)) {
106
107 $unread = getFeedUnread($link, $line["id"]);
108
109 if ($unread || !$unread_only) {
110
111 $row = array(
112 "feed_url" => $line["feed_url"],
113 "title" => $line["title"],
114 "id" => (int)$line["id"],
115 "unread" => (int)$unread,
116 "cat_id" => (int)$line["cat_id"],
117 "last_updated" => strtotime($line["last_updated"])
118 );
119
120 array_push($feeds, $row);
121 }
122 }
123
124 /* Labels */
125
126 if (!$cat_id || $cat_id == -2) {
127 $counters = getLabelCounters($link, false, true);
128
129 foreach (array_keys($counters) as $id) {
130
131 $unread = $counters[$id]["counter"];
132
133 if ($unread || !$unread_only) {
134
135 $row = array(
136 "id" => $id,
137 "title" => $counters[$id]["description"],
138 "unread" => $counters[$id]["counter"],
139 "cat_id" => -2,
140 );
141
142 array_push($feeds, $row);
143 }
144 }
145 }
146
147 /* Virtual feeds */
148
149 if (!$cat_id || $cat_id == -1) {
150 foreach (array(-1, -2, -3, -4) as $i) {
151 $unread = getFeedUnread($link, $i);
152
153 if ($unread || !$unread_only) {
154 $title = getFeedTitle($link, $i);
155
156 $row = array(
157 "id" => $i,
158 "title" => $title,
159 "unread" => $unread,
160 "cat_id" => -1,
161 );
162 array_push($feeds, $row);
163 }
164
165 }
166 }
167
168 print json_encode($feeds);
169
170 break;
171 case "getCategories":
172 $unread_only = (bool)db_escape_string($_REQUEST["unread_only"]);
173
174 $result = db_query($link, "SELECT
175 id, title FROM ttrss_feed_categories
176 WHERE owner_uid = " .
177 $_SESSION["uid"]);
178
179 $cats = array();
180
181 while ($line = db_fetch_assoc($result)) {
182 $unread = getFeedUnread($link, $line["id"], true);
183
184 if ($unread || !$unread_only) {
185 array_push($cats, array($line["id"] =>
186 array("title" => $line["title"], "unread" => $unread)));
187 }
188 }
189
190 print json_encode($cats);
191 break;
192 case "getHeadlines":
193 $feed_id = db_escape_string($_REQUEST["feed_id"]);
194 $limit = (int)db_escape_string($_REQUEST["limit"]);
195 $filter = db_escape_string($_REQUEST["filter"]);
196 $is_cat = (bool)db_escape_string($_REQUEST["is_cat"]);
197 $show_except = (bool)db_escape_string($_REQUEST["show_excerpt"]);
198
199 /* do not rely on params below */
200
201 $search = db_escape_string($_REQUEST["search"]);
202 $search_mode = db_escape_string($_REQUEST["search_mode"]);
203 $match_on = db_escape_string($_REQUEST["match_on"]);
204
205 $qfh_ret = queryFeedHeadlines($link, $feed_id, $limit,
206 $view_mode, $is_cat, $search, $search_mode, $match_on);
207
208 $result = $qfh_ret[0];
209 $feed_title = $qfh_ret[1];
210
211 $headlines = array();
212
213 while ($line = db_fetch_assoc($result)) {
214 $is_updated = ($line["last_read"] == "" &&
215 ($line["unread"] != "t" && $line["unread"] != "1"));
216
217 $headline_row = array(
218 "id" => (int)$line["id"],
219 "unread" => sql_bool_to_bool($line["unread"]),
220 "marked" => sql_bool_to_bool($line["marked"]),
221 "updated" => strtotime($line["updated"]),
222 "is_updated" => $is_updated,
223 "title" => $line["title"],
224 "feed_id" => $line["feed_id"],
225 );
226
227 if ($show_except) $headline_row["excerpt"] = $line["content_preview"];
228
229 array_push($headlines, $headline_row);
230 }
231
232 print json_encode($headlines);
233
234 break;
235 case "updateArticle":
236 $article_id = (int) db_escape_string($_GET["article_id"]);
237 $mode = (int) db_escape_string($_REQUEST["mode"]);
238 $field_raw = (int)db_escape_string($_REQUEST["field"]);
239
240 $field = "";
241 $set_to = "";
242
243 switch ($field_raw) {
244 case 0:
245 $field = "marked";
246 break;
247 case 1:
248 $field = "published";
249 break;
250 case 2:
251 $field = "unread";
252 break;
253 };
254
255 switch ($mode) {
256 case 1:
257 $set_to = "true";
258 break;
259 case 0:
260 $set_to = "false";
261 break;
262 case 2:
263 $set_to = "NOT $field";
264 break;
265 }
266
267 if ($field && $set_to) {
268 if ($field == "unread") {
269 $result = db_query($link, "UPDATE ttrss_user_entries SET $field = $set_to,
270 last_read = NOW()
271 WHERE ref_id = '$article_id' AND owner_uid = " . $_SESSION["uid"]);
272 } else {
273 $result = db_query($link, "UPDATE ttrss_user_entries SET $field = $set_to
274 WHERE ref_id = '$article_id' AND owner_uid = " . $_SESSION["uid"]);
275 }
276 }
277
278 break;
279
280 case "getArticle":
281
282 $article_id = (int)db_escape_string($_REQUEST["article_id"]);
283
284 $query = "SELECT title,link,content,feed_id,comments,int_id,
285 marked,unread,published,
286 ".SUBSTRING_FOR_DATE."(updated,1,16) as updated,
287 author
288 FROM ttrss_entries,ttrss_user_entries
289 WHERE id = '$article_id' AND ref_id = id AND owner_uid = " .
290 $_SESSION["uid"] ;
291
292 $result = db_query($link, $query);
293
294 $article = array();
295
296 if (db_num_rows($result) != 0) {
297 $line = db_fetch_assoc($result);
298
299 $article = array(
300 "title" => $line["title"],
301 "link" => $line["link"],
302 "labels" => get_article_labels($link, $article_id),
303 "unread" => sql_bool_to_bool($line["unread"]),
304 "marked" => sql_bool_to_bool($line["marked"]),
305 "published" => sql_bool_to_bool($line["published"]),
306 "comments" => $line["comments"],
307 "author" => $line["author"],
308 "updated" => strtotime($line["updated"]),
309 "content" => $line["content"],
310 "feed_id" => $line["feed_id"],
311 );
312 }
313
314 print json_encode($article);
315
316 break;
317 }
318
319 db_close($link);
320
321 ?>