pdo->prepare("SELECT * FROM ttrss_labels2 WHERE id = ? AND owner_uid = ?"); $sth->execute([$label_id, $_SESSION['uid']]); if ($line = $sth->fetch()) { print_hidden("id", "$label_id"); print_hidden("op", "pref-labels"); print_hidden("method", "save"); print "

".__("Caption")."

"; print "

"; $fg_color = $line['fg_color']; $bg_color = $line['bg_color']; print "α"; print ""; print "

"; print "

" . __("Colors") . "

"; print "

"; print ""; print ""; print "

".__("Foreground:")."	".__("Background:"). "
"; print ""; print ""; print " "; print ""; print "	"; print " "; print ""; print "

"; print "

"; # print ""; print "

"; print ""; print ""; print "

"; } } function getlabeltree() { $root = array(); $root['id'] = 'root'; $root['name'] = __('Labels'); $root['items'] = array(); $sth = $this->pdo->prepare("SELECT * FROM ttrss_labels2 WHERE owner_uid = ? ORDER BY caption"); $sth->execute([$_SESSION['uid']]); while ($line = $sth->fetch()) { $label = array(); $label['id'] = 'LABEL:' . $line['id']; $label['bare_id'] = $line['id']; $label['name'] = $line['caption']; $label['fg_color'] = $line['fg_color']; $label['bg_color'] = $line['bg_color']; $label['type'] = 'label'; $label['checkbox'] = false; array_push($root['items'], $label); } $fl = array(); $fl['identifier'] = 'id'; $fl['label'] = 'name'; $fl['items'] = array($root); print json_encode($fl); return; } function colorset() { $kind = $_REQUEST["kind"]; $ids = explode(',', $_REQUEST["ids"]); $color = $_REQUEST["color"]; $fg = $_REQUEST["fg"]; $bg = $_REQUEST["bg"]; foreach ($ids as $id) { if ($kind == "fg" || $kind == "bg") { $sth = $this->pdo->prepare("UPDATE ttrss_labels2 SET ${kind}_color = ? WHERE id = ? AND owner_uid = ?"); $sth->execute([$color, $id, $_SESSION['uid']]); } else { $sth = $this->pdo->prepare("UPDATE ttrss_labels2 SET fg_color = ?, bg_color = ? WHERE id = ? AND owner_uid = ?"); $sth->execute([$fg, $bg, $id, $_SESSION['uid']]); } $caption = Labels::find_caption($id, $_SESSION["uid"]); /* Remove cached data */ $sth = $this->pdo->prepare("UPDATE ttrss_user_entries SET label_cache = '' WHERE label_cache LIKE ? AND owner_uid = ?"); $sth->execute(["%$caption%", $_SESSION['uid']]); } } function colorreset() { $ids = explode(',', $_REQUEST["ids"]); foreach ($ids as $id) { $sth = $this->pdo->prepare("UPDATE ttrss_labels2 SET fg_color = '', bg_color = '' WHERE id = ? AND owner_uid = ?"); $sth->execute([$id, $_SESSION['uid']]); $caption = Labels::find_caption($id, $_SESSION["uid"]); /* Remove cached data */ $sth = $this->pdo->prepare("UPDATE ttrss_user_entries SET label_cache = '' WHERE label_cache LIKE ? AND owner_uid = ?"); $sth->execute(["%$caption%", $_SESSION['uid']]); } } function save() { $id = $_REQUEST["id"]; $caption = trim($_REQUEST["caption"]); $this->pdo->beginTransaction(); $sth = $this->pdo->prepare("SELECT caption FROM ttrss_labels2 WHERE id = ? AND owner_uid = ?"); $sth->execute([$id, $_SESSION['uid']]); if ($row = $sth->fetch()) { $old_caption = $row["caption"]; $sth = $this->pdo->prepare("SELECT id FROM ttrss_labels2 WHERE caption = ? AND owner_uid = ?"); $sth->execute([$caption, $_SESSION['uid']]); if (!$sth->fetch()) { if ($caption) { $sth = $this->pdo->prepare("UPDATE ttrss_labels2 SET caption = ? WHERE id = ? AND owner_uid = ?"); $sth->execute([$caption, $id, $_SESSION['uid']]); /* Update filters that reference label being renamed */ $sth = $this->pdo->prepare("UPDATE ttrss_filters2_actions SET action_param = ? WHERE action_param = ? AND action_id = 7 AND filter_id IN (SELECT id FROM ttrss_filters2 WHERE owner_uid = ?)"); $sth->execute([$caption, $old_caption, $_SESSION['uid']]); print $_REQUEST["value"]; } else { print $old_caption; } } else { print $old_caption; } } $this->pdo->commit(); } function remove() { $ids = explode(",", $_REQUEST["ids"]); foreach ($ids as $id) { Labels::remove($id, $_SESSION["uid"]); } } function add() { $caption = $_REQUEST["caption"]; $output = $_REQUEST["output"]; if ($caption) { if (Labels::create($caption)) { if (!$output) { print T_sprintf("Created label %s", htmlspecialchars($caption)); } } if ($output == "select") { header("Content-Type: text/xml"); print ""; print_label_select("select_label", $caption, ""); print ""; } } return; } function index() { print "

"; print "

"; print ""; #toolbar print "

"; #pane print "

"; print "

". __("Loading, please wait...")."

"; print "

"; #pane PluginHost::getInstance()->run_hooks(PluginHost::HOOK_PREFS_TAB, "hook_prefs_tab", "prefLabels"); print "

"; #container } }