index.php 19.1 KB
Newer Older
Andrew Dolgov's avatar
Andrew Dolgov committed
1 2 3 4 5 6 7 8 9
<?php
	error_reporting(E_ERROR | E_PARSE);

	require_once "../config.php";
	
	require_once "../db.php";
	require_once "../db-prefs.php";
	require_once "../functions.php";

10 11 12
	define('API_STATUS_OK', 0);
	define('API_STATUS_ERR', 1);

13 14 15 16
	if (defined('ENABLE_GZIP_OUTPUT') && ENABLE_GZIP_OUTPUT) {
		ob_start("ob_gzhandler");
	}

Andrew Dolgov's avatar
Andrew Dolgov committed
17 18 19 20 21
	$link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);	

	$session_expire = SESSION_EXPIRE_TIME; //seconds
	$session_name = (!defined('TTRSS_SESSION_NAME')) ? "ttrss_sid_api" : TTRSS_SESSION_NAME . "_api";

22 23 24 25 26 27
	session_name($session_name);

	if ($_REQUEST["sid"]) {
		session_id($_REQUEST["sid"]);
	}

Andrew Dolgov's avatar
Andrew Dolgov committed
28 29 30 31 32 33 34 35 36 37 38 39 40
	session_start();

	if (!$link) {
		if (DB_TYPE == "mysql") {
			print mysql_error();
		}
		// PG seems to display its own errors just fine by default.		
		return;
	}

	init_connection($link);

	$op = db_escape_string($_REQUEST["op"]);
41
	$seq = (int) $_REQUEST["seq"];
Andrew Dolgov's avatar
Andrew Dolgov committed
42 43 44

//	header("Content-Type: application/json");

45 46 47 48 49 50
	function api_wrap_reply($status, $seq, $reply) {
		print json_encode(array("seq" => $seq,
			"status" => $status,
			"content" => $reply));
	}

Andrew Dolgov's avatar
Andrew Dolgov committed
51
	if (!$_SESSION["uid"] && $op != "login" && $op != "isLoggedIn") {
52
		print api_wrap_reply(API_STATUS_ERR, $seq, array("error" => 'NOT_LOGGED_IN'));
Andrew Dolgov's avatar
Andrew Dolgov committed
53 54 55
		return;
	}

56
	if ($_SESSION["uid"] && $op != "logout" && !get_pref($link, 'ENABLE_API_ACCESS')) {
57
		print api_wrap_reply(API_STATUS_ERR, $seq, array("error" => 'API_DISABLED'));
Andrew Dolgov's avatar
Andrew Dolgov committed
58
		return;
59
	} 
Andrew Dolgov's avatar
Andrew Dolgov committed
60 61

	switch ($op) {
62
	
Andrew Dolgov's avatar
Andrew Dolgov committed
63 64
		case "getVersion":
			$rv = array("version" => VERSION);
65
			print api_wrap_reply(API_STATUS_OK, $seq, $rv);
66 67
			break;
		
Andrew Dolgov's avatar
Andrew Dolgov committed
68 69 70
		case "login":
			$login = db_escape_string($_REQUEST["user"]);
			$password = db_escape_string($_REQUEST["password"]);
71
			$password_base64 = db_escape_string(base64_decode($_REQUEST["password"]));
Andrew Dolgov's avatar
Andrew Dolgov committed
72

73 74
			if (SINGLE_USER_MODE) $login = "admin";

75 76 77 78 79 80 81 82
			$result = db_query($link, "SELECT id FROM ttrss_users WHERE login = '$login'");

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

83
			if ($uid && get_pref($link, "ENABLE_API_ACCESS", $uid)) {
84
				if (authenticate_user($link, $login, $password)) {               // try login with normal password
85 86
					print api_wrap_reply(API_STATUS_OK, $seq, 
						array("session_id" => session_id()));
87
				} else if (authenticate_user($link, $login, $password_base64)) { // else try with base64_decoded password
88 89
					print api_wrap_reply(API_STATUS_OK, $seq, 
						array("session_id" => session_id()));
90
				} else {                                                         // else we are not logged in
91 92
					print api_wrap_reply(API_STATUS_ERR, $seq, 
						array("error" => "LOGIN_ERROR"));
93
				}
Andrew Dolgov's avatar
Andrew Dolgov committed
94
			} else {
95 96
				print api_wrap_reply(API_STATUS_ERR, $seq,
					array("error" => "API_DISABLED"));
Andrew Dolgov's avatar
Andrew Dolgov committed
97 98 99
			}

			break;
100
			
Andrew Dolgov's avatar
Andrew Dolgov committed
101 102
		case "logout":
			logout_user();
103
			print api_wrap_reply(API_STATUS_OK, $seq, array("status" => "OK"));
Andrew Dolgov's avatar
Andrew Dolgov committed
104
			break;
105
			
Andrew Dolgov's avatar
Andrew Dolgov committed
106
		case "isLoggedIn":
107 108
			print api_wrap_reply(API_STATUS_OK, $seq, 
				array("status" => $_SESSION["uid"] != ''));
Andrew Dolgov's avatar
Andrew Dolgov committed
109
			break;
110
			
Andrew Dolgov's avatar
Andrew Dolgov committed
111 112 113 114 115
		case "getUnread":
			$feed_id = db_escape_string($_REQUEST["feed_id"]);
			$is_cat = db_escape_string($_REQUEST["is_cat"]);

			if ($feed_id) {
116 117
				print api_wrap_reply(API_STATUS_OK, $seq, 
					array("unread" => getFeedUnread($link, $feed_id, $is_cat)));
Andrew Dolgov's avatar
Andrew Dolgov committed
118
			} else {
119 120
				print api_wrap_reply(API_STATUS_OK, $seq, 
					array("unread" => getGlobalUnread($link)));
Andrew Dolgov's avatar
Andrew Dolgov committed
121
			}
122
			break;
123 124
			
		/* Method added for ttrss-reader for Android */
125
		case "getCounters":
126

127 128
			/* flct (flc is the default) FIXME: document */
			$output_mode = db_escape_string($_REQUEST["output_mode"]);
129

130 131
			print api_wrap_reply(API_STATUS_OK, $seq, 
				getAllCounters($link, $output_mode));
Andrew Dolgov's avatar
Andrew Dolgov committed
132
			break;
133
			
Andrew Dolgov's avatar
Andrew Dolgov committed
134 135 136
		case "getFeeds":
			$cat_id = db_escape_string($_REQUEST["cat_id"]);
			$unread_only = (bool)db_escape_string($_REQUEST["unread_only"]);
137 138 139
			$limit = (int) db_escape_string($_REQUEST["limit"]);
			$offset = (int) db_escape_string($_REQUEST["offset"]);

140 141
			chdir(".."); // so feed_has_icon() would work properly for relative ICONS_DIR

142
			$feeds = api_get_feeds($link, $cat_id, $unread_only, $limit, $offset);
143

144
			print api_wrap_reply(API_STATUS_OK, $seq, $feeds);
Andrew Dolgov's avatar
Andrew Dolgov committed
145 146

			break;
147
			
Andrew Dolgov's avatar
Andrew Dolgov committed
148
		case "getCategories":
Andrew Dolgov's avatar
Andrew Dolgov committed
149 150
			$unread_only = (bool)db_escape_string($_REQUEST["unread_only"]);

Andrew Dolgov's avatar
Andrew Dolgov committed
151 152 153 154 155 156 157 158 159
			$result = db_query($link, "SELECT 
					id, title FROM ttrss_feed_categories 
				WHERE owner_uid = " . 
				$_SESSION["uid"]);

			$cats = array();

			while ($line = db_fetch_assoc($result)) {
				$unread = getFeedUnread($link, $line["id"], true);
Andrew Dolgov's avatar
Andrew Dolgov committed
160 161

				if ($unread || !$unread_only) {
162 163 164
					array_push($cats, array("id" => $line["id"],
						"title" => $line["title"], 
						"unread" => $unread));
Andrew Dolgov's avatar
Andrew Dolgov committed
165
				}
Andrew Dolgov's avatar
Andrew Dolgov committed
166 167
			}

168
			print api_wrap_reply(API_STATUS_OK, $seq, $cats);
Andrew Dolgov's avatar
Andrew Dolgov committed
169
			break;
170
			
Andrew Dolgov's avatar
Andrew Dolgov committed
171 172 173
		case "getHeadlines":
			$feed_id = db_escape_string($_REQUEST["feed_id"]);
			$limit = (int)db_escape_string($_REQUEST["limit"]);
174
			$offset = (int)db_escape_string($_REQUEST["skip"]);
Andrew Dolgov's avatar
Andrew Dolgov committed
175 176
			$filter = db_escape_string($_REQUEST["filter"]);
			$is_cat = (bool)db_escape_string($_REQUEST["is_cat"]);
177 178
			$show_excerpt = (bool)db_escape_string($_REQUEST["show_excerpt"]);
			$show_content = (bool)db_escape_string($_REQUEST["show_content"]);
179 180
			/* all_articles, unread, adaptive, marked, updated */
			$view_mode = db_escape_string($_REQUEST["view_mode"]);
Andrew Dolgov's avatar
Andrew Dolgov committed
181

182 183
			$headlines = api_get_headlines($link, $feed_id, $limit, $offset,
				$filter, $is_cat, $show_excerpt, $show_content, $view_mode, false);
Andrew Dolgov's avatar
Andrew Dolgov committed
184

185
			print api_wrap_reply(API_STATUS_OK, $seq, $headlines);
Andrew Dolgov's avatar
Andrew Dolgov committed
186

Andrew Dolgov's avatar
Andrew Dolgov committed
187
			break;
188
			
Andrew Dolgov's avatar
Andrew Dolgov committed
189
		case "updateArticle":
190
			$article_ids = split(",", db_escape_string($_REQUEST["article_ids"]));
Andrew Dolgov's avatar
Andrew Dolgov committed
191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220
			$mode = (int) db_escape_string($_REQUEST["mode"]);
			$field_raw = (int)db_escape_string($_REQUEST["field"]);

			$field = "";
			$set_to = "";

			switch ($field_raw) {
				case 0:
					$field = "marked";
					break;
				case 1:
					$field = "published";
					break;
				case 2:
					$field = "unread";
					break;
			};

			switch ($mode) {
				case 1:
					$set_to = "true";
					break;
				case 0:
					$set_to = "false";
					break;
				case 2:
					$set_to = "NOT $field";
					break;
			}

221 222 223 224
			if ($field && $set_to && count($article_ids) > 0) {

				$article_ids = join(", ", $article_ids);

Andrew Dolgov's avatar
Andrew Dolgov committed
225 226 227
				if ($field == "unread") {
					$result = db_query($link, "UPDATE ttrss_user_entries SET $field = $set_to,
						last_read = NOW()
228
						WHERE ref_id IN ($article_ids) AND owner_uid = " . $_SESSION["uid"]);
Andrew Dolgov's avatar
Andrew Dolgov committed
229 230
				} else {
					$result = db_query($link, "UPDATE ttrss_user_entries SET $field = $set_to
231
						WHERE ref_id IN ($article_ids) AND owner_uid = " . $_SESSION["uid"]);
Andrew Dolgov's avatar
Andrew Dolgov committed
232
				}
233

234 235 236 237 238 239 240 241 242 243 244
				$num_updated = db_affected_rows($link, $result);

				if ($num_updated > 0 && $field == "unread") {
					$result = db_query($link, "SELECT DISTINCT feed_id FROM ttrss_user_entries
						WHERE ref_id IN ($article_ids)");

					while ($line = db_fetch_assoc($result)) {
						ccache_update($link, $line["feed_id"], $_SESSION["uid"]);
					}
				}

245
				print api_wrap_reply(API_STATUS_OK, $seq, array("status" => "OK", 
246 247 248
					"updated" => $num_updated));

			} else {
249 250
				print api_wrap_reply(API_STATUS_ERR, $seq, 
					array("error" => 'INCORRECT_USAGE'));
Andrew Dolgov's avatar
Andrew Dolgov committed
251 252 253 254
			}

			break;

Andrew Dolgov's avatar
Andrew Dolgov committed
255 256
		case "getArticle":

257
			$article_id = db_escape_string($_REQUEST["article_id"]);
Andrew Dolgov's avatar
Andrew Dolgov committed
258

259
			$query = "SELECT id,title,link,content,feed_id,comments,int_id,
Andrew Dolgov's avatar
Andrew Dolgov committed
260
				marked,unread,published,
Andrew Dolgov's avatar
Andrew Dolgov committed
261 262 263
				".SUBSTRING_FOR_DATE."(updated,1,16) as updated,
				author
				FROM ttrss_entries,ttrss_user_entries
264
				WHERE	id IN ($article_id) AND ref_id = id AND owner_uid = " . 
Andrew Dolgov's avatar
Andrew Dolgov committed
265 266 267
					$_SESSION["uid"] ;

			$result = db_query($link, $query);
268 269 270

			$articles = array();

Andrew Dolgov's avatar
Andrew Dolgov committed
271 272
			if (db_num_rows($result) != 0) {

273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292
				while ($line = db_fetch_assoc($result)) {

					$attachments = get_article_enclosures($link, $line['id']);

					$article = array(
						"id" => $line["id"],
						"title" => $line["title"],
						"link" => $line["link"],
						"labels" => get_article_labels($link, $line['id']),
						"unread" => sql_bool_to_bool($line["unread"]),
						"marked" => sql_bool_to_bool($line["marked"]),
						"published" => sql_bool_to_bool($line["published"]),
						"comments" => $line["comments"],
						"author" => $line["author"],
						"updated" => strtotime($line["updated"]),
						"content" => $line["content"],
						"feed_id" => $line["feed_id"],
						"attachments" => $attachments
					);

293 294
					array_push($articles, $article);

295 296
				}
			}
Andrew Dolgov's avatar
Andrew Dolgov committed
297

298 299
			print api_wrap_reply(API_STATUS_OK, $seq, $articles);

Andrew Dolgov's avatar
Andrew Dolgov committed
300
			break;
301
			
Andrew Dolgov's avatar
Andrew Dolgov committed
302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317
		case "getConfig":
			$config = array(
				"icons_dir" => ICONS_DIR,
				"icons_url" => ICONS_URL);

			if (ENABLE_UPDATE_DAEMON) {
				$config["daemon_is_running"] = file_is_locked("update_daemon.lock");
			}

			$result = db_query($link, "SELECT COUNT(*) AS cf FROM
				ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);

			$num_feeds = db_fetch_result($result, 0, "cf");

			$config["num_feeds"] = (int)$num_feeds;
	
318
			print api_wrap_reply(API_STATUS_OK, $seq, $config);
Andrew Dolgov's avatar
Andrew Dolgov committed
319

Andrew Dolgov's avatar
Andrew Dolgov committed
320
			break;
Andrew Dolgov's avatar
Andrew Dolgov committed
321

Andrew Dolgov's avatar
Andrew Dolgov committed
322 323 324
		case "updateFeed":
			$feed_id = db_escape_string($_REQUEST["feed_id"]);

325
			update_rss_feed($link, $feed_id, true);
Andrew Dolgov's avatar
Andrew Dolgov committed
326

327
			print api_wrap_reply(API_STATUS_OK, $seq, array("status" => "OK"));
Andrew Dolgov's avatar
Andrew Dolgov committed
328

Andrew Dolgov's avatar
Andrew Dolgov committed
329 330
			break;

Andrew Dolgov's avatar
Andrew Dolgov committed
331 332
		case "catchupFeed":
			$feed_id = db_escape_string($_REQUEST["feed_id"]);
333
			$is_cat = db_escape_string($_REQUEST["is_cat"]);
Andrew Dolgov's avatar
Andrew Dolgov committed
334

Andrew Dolgov's avatar
Andrew Dolgov committed
335
			catchup_feed($link, $feed_id, $is_cat);
Andrew Dolgov's avatar
Andrew Dolgov committed
336

337
			print api_wrap_reply(API_STATUS_OK, $seq, array("status" => "OK"));
Andrew Dolgov's avatar
Andrew Dolgov committed
338 339 340

			break;

Andrew Dolgov's avatar
Andrew Dolgov committed
341 342
		case "getPref":
			$pref_name = db_escape_string($_REQUEST["pref_name"]);
343 344 345

			print api_wrap_reply(API_STATUS_OK, $seq, 
				array("value" => get_pref($link, $pref_name)));
Andrew Dolgov's avatar
Andrew Dolgov committed
346
			break;
347 348 349
		
		/* Method added for ttrss-reader for Android */
		case "getArticles":
350
			$isCategory = (int)db_escape_string($_REQUEST["is_cat"]);
351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463
			$id = (int)db_escape_string($_REQUEST["id"]);
			$displayUnread = (int)db_escape_string($_REQUEST["unread"]);
			$limit = (int)db_escape_string($_REQUEST["limit"]);
			$feeds = array();
			
			if ($isCategory > 0) {
				// Get Feeds of the category
				
				if ($id == 0) {
					$category_part = "cat_id is NULL";
				} else {
					$category_part = "cat_id = '$id'";
				}
				
				$result = db_query($link, "SELECT id FROM ttrss_feeds WHERE ".
							$category_part." AND owner_uid = '".$_SESSION["uid"]."'");				
				
				while ($line = db_fetch_assoc($result)) {
					array_push($feeds, $line["id"]);
				}
				
				// Virtual feeds
				$match_part = "";
				if ($id == -1) {
					$match_part = "marked = true";
					array_push($feeds, -1);
				} else if ($id == -2) {
					$match_part = "published = true";
					array_push($feeds, -2);
				} else if ($id == -3) {
					$match_part = "unread = true";
					array_push($feeds, -3);

					$intl = get_pref($link, "FRESH_ARTICLE_MAX_AGE", $owner_uid);

					if (DB_TYPE == "pgsql") {
						$match_part .= " AND updated > NOW() - INTERVAL '$intl hour' "; 
					} else {
						$match_part .= " AND updated > DATE_SUB(NOW(), INTERVAL $intl HOUR) ";
					}
				} else if ($id == -4) {
					$match_part = "true";
					array_push($feeds, -4);
				}
			} else {
				// Only add one feed
				array_push($feeds, $id);
			}
			
			$ret = array();
			
			if (DB_TYPE == "mysql") {
				$limit_part = " LIMIT 0,".$limit;
			} else if (DB_TYPE == "pgsql") {
				$limit_part = " LIMIT ".$limit;
			} else {
				$limit_part = "";
			}

			// Fetch articles for the feeds
			foreach ($feeds as $feed) {
				
				if ($match_part) {
					$from_qpart = "ttrss_user_entries,ttrss_feeds,ttrss_entries";
					$feeds_qpart = "ttrss_user_entries.feed_id = ttrss_feeds.id AND";

					$query = "SELECT ttrss_entries.id,ttrss_entries.title,link,content,feed_id,comments,int_id,
						marked,unread,published,".SUBSTRING_FOR_DATE."(updated,1,16) as updated,author 
						FROM $from_qpart WHERE
						ttrss_user_entries.ref_id = ttrss_entries.id AND 
						$feeds_qpart ($match_part) AND ttrss_user_entries.owner_uid = ".$_SESSION["uid"]." ORDER BY updated DESC".$limit_part;
					
					$result = db_query($link, $query);
				} else {
					$query = "SELECT ttrss_entries.id,ttrss_entries.title,link,content,feed_id,comments,int_id,
						marked,unread,published,".SUBSTRING_FOR_DATE."(updated,1,16) as updated,author 
						FROM ttrss_entries,ttrss_user_entries 
						WHERE feed_id = '".$feed."' AND ref_id = id AND owner_uid = ".
							$_SESSION["uid"]." AND unread >= '".$displayUnread."' ORDER BY updated DESC".$limit_part;
							
					$result = db_query($link, $query);
				}
				
				$articles = array();
				$i=0;
				while ($i < mysql_numrows($result)) {
					
					$article_id = db_fetch_result($result, $i, "id");
					
					$attachments = get_article_enclosures($link, $article_id);

					$article = array(
						"id" => db_fetch_result($result, $i, "ttrss_entries.id"),
						"title" => db_fetch_result($result, $i, "ttrss_entries.title"),
						"link" => db_fetch_result($result, $i, "link"),
						"labels" => get_article_labels($link, $article_id),
						"unread" => sql_bool_to_bool(db_fetch_result($result, $i, "unread")),
						"marked" => sql_bool_to_bool(db_fetch_result($result, $i, "marked")),
						"published" => sql_bool_to_bool(db_fetch_result($result, $i, "published")),
						"comments" => db_fetch_result($result, $i, "comments"),
						"author" => db_fetch_result($result, $i, "author"),
						"updated" => strtotime(db_fetch_result($result, $i, "updated")),
						"content" => db_fetch_result($result, $i, "content"),
						"feed_id" => db_fetch_result($result, $i, "feed_id"),
						"attachments" => $attachments
					);
					
					array_push($ret, $article);
					
					$i++;
				}
			}

464
			print api_wrap_reply(API_STATUS_OK, $seq, $ret);
465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550
			break;
		
		/* Method added for ttrss-reader for Android */
		case "getNewArticles":
			$time = (int) db_escape_string($_REQUEST["time"]);
			// unread=1 zeigt alle an, unread=0 nur ungelesene
			$displayUnread = (int) db_escape_string($_REQUEST["unread"]);
			
			if (DB_TYPE == "mysql") {
				$db_time_function = " AND last_updated > FROM_UNIXTIME(".$time.")";
			} else if (DB_TYPE == "pgsql") {
				$db_time_function = " AND last_updated > to_timestamp(".$time.")";
			} else {
				$db_time_function = "";
			}
			
			if (DB_TYPE == "mysql") {
				$db_time_function2 = " AND updated > FROM_UNIXTIME(".$time.")";
			} else if (DB_TYPE == "pgsql") {
				$db_time_function2 = " AND updated > to_timestamp(".$time.")";
			} else {
				$db_time_function2 = "";
			}
			
			$cats = array();


			// Add uncategorized feeds
			$unread = getFeedUnread($link, 0, true);
			if ($unread || $displayUnread > 0) {
				$feeds = array();
				$result_0 = db_query($link, "SELECT id, feed_url, cat_id, title, ".
						SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated ".
						"FROM ttrss_feeds WHERE cat_id IS null AND owner_uid = '".$_SESSION["uid"]."'" . $db_time_function);
				
				while ($line_feeds = db_fetch_assoc($result_0)) {
					$unread_feed = getFeedUnread($link, $line_feeds["id"], false);
					if ($unread || $displayUnread > 0) {
						
						$result_1 = db_query($link, "SELECT id,title,link,content,feed_id,comments,int_id,
							marked,unread,published,".
							SUBSTRING_FOR_DATE."(updated,1,16) as updated,author
							FROM ttrss_entries,ttrss_user_entries
							WHERE feed_id = '".$line_feeds["id"]."' AND ref_id = id AND owner_uid = " . 
								$_SESSION["uid"]." AND unread >= '".$displayUnread."'" . $db_time_function2);
						
						$articles = array();
						while ($line_articles = db_fetch_assoc($result_1)) {
							$article_id = db_fetch_result($result, $i, "id");
							$attachments = get_article_enclosures($link, $article_id);
							array_push($articles, $article = array(
								"id" => $line_articles["id"],
								"title" => $line_articles["title"],
								"link" => $line_articles["link"],
								"labels" => $article_id,
								"unread" => $line_articles["unread"],
								"marked" => $line_articles["marked"],
								"published" => $line_articles["published"],
								"comments" => $line_articles["comments"],
								"author" => $line_articles["author"],
								"updated" => strtotime($line_articles["updated"]),
								"content" => $line_articles["content"],
								"feed_id" => $line_articles["feed_id"],
								"attachments" => $attachments));
						}
						
						array_push($feeds, array(
							"feed_url" => $line_feeds["feed_url"],
							"title" => $line_feeds["title"],
							"id" => (int)$line_feeds["id"],
							"unread" => (int)$unread_feed,
							"has_icon" => $has_icon,
							"cat_id" => (int)$line_feeds["cat_id"],
							"last_updated" => strtotime($line_feeds["last_updated"]),
							"articles" => $articles
						));
					}
				}
				
				array_push($cats,
					array(
						"id" => 0,
						"title" => "Uncategorized Feeds", 
						"unread" => $unread,
						"feeds" => $feeds));
			}
551

552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615
			
			$result = db_query($link, "SELECT id, title FROM ttrss_feed_categories WHERE owner_uid = " . $_SESSION["uid"]);
			while ($line = db_fetch_assoc($result)) {
				$unread = getFeedUnread($link, $line["id"], true);

				if ($unread || $displayUnread > 0) {
					$feeds = array();
					$result_0 = db_query($link, "SELECT id, feed_url, cat_id, title, ".
						SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated ".
						"FROM ttrss_feeds WHERE cat_id = '".
						$line["id"]."' AND owner_uid = '".$_SESSION["uid"]."'" . $db_time_function);
					
					while ($line_feeds = db_fetch_assoc($result_0)) {
						$unread_feed = getFeedUnread($link, $line_feeds["id"], false);
						if ($unread_feed || $displayUnread > 0) {
							
							$result_1 = db_query($link, "SELECT id,title,link,content,feed_id,comments,int_id,
								marked,unread,published,".
								SUBSTRING_FOR_DATE."(updated,1,16) as updated,author
								FROM ttrss_entries,ttrss_user_entries
								WHERE feed_id = '".$line_feeds["id"]."' AND ref_id = id AND owner_uid = " . 
									$_SESSION["uid"]." AND unread >= '".$displayUnread."'" . $db_time_function2);
							
							$articles = array();
							while ($line_articles = db_fetch_assoc($result_1)) {
								$article_id = db_fetch_result($result, $i, "id");
								$attachments = get_article_enclosures($link, $article_id);
								array_push($articles, $article = array(
									"id" => $line_articles["id"],
									"title" => $line_articles["title"],
									"link" => $line_articles["link"],
									"labels" => $article_id,
									"unread" => $line_articles["unread"],
									"marked" => $line_articles["marked"],
									"published" => $line_articles["published"],
									"comments" => $line_articles["comments"],
									"author" => $line_articles["author"],
									"updated" => strtotime($line_articles["updated"]),
									"content" => $line_articles["content"],
									"feed_id" => $line_articles["feed_id"],
									"attachments" => $attachments));
							}
							
							array_push($feeds, array(
								"feed_url" => $line_feeds["feed_url"],
								"title" => $line_feeds["title"],
								"id" => (int)$line_feeds["id"],
								"unread" => (int)$unread_feed,
								"cat_id" => (int)$line_feeds["cat_id"],
								"last_updated" => strtotime($line_feeds["last_updated"]),
								"articles" => $articles
							));
						
						}
					}
					
					array_push($cats,
						array(
							"id" => $line["id"],
							"title" => $line["title"], 
							"unread" => $unread,
							"feeds" => $feeds));
				}
			}
616
			print api_wrap_reply(API_STATUS_OK, $seq, $cats);
617 618
			break;
		
619
		default:
620 621
			print api_wrap_reply(API_STATUS_ERR, $seq, 
				array("error" => 'UNKNOWN_METHOD'));
622 623
			break;

Andrew Dolgov's avatar
Andrew Dolgov committed
624 625 626 627 628
	}

	db_close($link);
	
?>