From 814bff66496bb8d57ced77771edcfb4f173ce5ee Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sun, 18 Jan 2009 12:23:35 +0100 Subject: [PATCH] add function get_article_labels() --- functions.php | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) diff --git a/functions.php b/functions.php index 326fa74b..793fa5f4 100644 --- a/functions.php +++ b/functions.php @@ -6008,6 +6008,25 @@ } } + function get_article_labels($link, $id) { + $result = db_query($link, + "SELECT DISTINCT label_id,caption + FROM ttrss_labels2, ttrss_user_labels2 + WHERE id = label_id + AND article_id = '$id' + AND owner_uid = ".$_SESSION["uid"]); + + $rv = array(); + + while ($line = db_fetch_assoc($result)) { + $rk = array($line["label_id"], $line["caption"]); + array_push($rv, $rk); + } + + return $rv; + } + + function label_find_caption($link, $label, $owner_uid) { $result = db_query($link, "SELECT caption FROM ttrss_labels2 WHERE id = '$label' -- 2.39.5