Tiny Tiny RSS : Help

From 7dc66a616e00559aeed9cd49f0c65208170e122f Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sun, 16 Oct 2005 16:17:12 +0100 Subject: [PATCH] add SQL expression help and placeholder for help mechanism --- backend.php | 56 +++++++++++++++++++++++++++++++++++++++++++++- functions.js | 6 +++++ tt-rss.css | 35 +++++++++++++++++++++++++++++ tt-rss_compact.css | 35 +++++++++++++++++++++++++++++ 4 files changed, 131 insertions(+), 1 deletion(-) diff --git a/backend.php b/backend.php index 41b2c29d..3975cd3b 100644 --- a/backend.php +++ b/backend.php @@ -1125,7 +1125,9 @@ print "

"; print " - + "; $lnum = 0; @@ -1220,5 +1222,57 @@ print ""; } + if ($op == "help") { + print " + Tiny Tiny RSS : Help + + + + + "; + + $tid = sprintf("%d", $_GET["tid"]); + + /* FIXME this badly needs real implementation */ + + print "
"; + + ?> + +
Help for SQL expressions
+ +
Description
+ +
The «SQL expression» is added to WHERE clause of + view feed query. You can match on most fields of ttrss_entries table + and even use subselect to query additional information. This + functionality is considered to be advanced and requires basic + understanding of SQL.
+ +
Examples
+ +
unread = true
+ + Matches all unread articles + +
title like '%Linux%'
+ + Matches all articles which mention Linux in the title. You get the idea. + +
See the database schema included in the distribution package for gruesome + details.
+ + + (Close this window)
"; + + print ""; + + print ""; + + } + db_close($link); ?> diff --git a/functions.js b/functions.js index 323d7d8a..5bf5e697 100644 --- a/functions.js +++ b/functions.js @@ -356,3 +356,9 @@ function update_label_counters(feed) { xmlhttp_rpc.send(null); } } + +function popupHelp(tid) { + var w = window.open("backend.php?op=help&tid=" + tid, + "Popup Help", + "menubar=no,location=no,resizable=yes,scrollbars=yes,status=no"); +} diff --git a/tt-rss.css b/tt-rss.css index 2a9af4ae..5c81a315 100644 --- a/tt-rss.css +++ b/tt-rss.css @@ -352,3 +352,38 @@ table.prefFeedList tr.title td, table.prefFilterList tr.title td, border-style : solid; } +a.helpLink { + color : #808080; +} + +a.helpLink:hover { + color : #5050aa; +} + +div.helpResponse { + margin : 10px; + background-image : url("images/vgrad_light_rev2.png"); + background-position : top left; + background-repeat : repeat-x; + padding : 10px 20px 10px 20px; + border : 1px solid #f0f0f0; +} + +div.helpResponse h1 { + border-width : 0px 0px 1px 0px; + border-style : solid; + border-color : #c0c0c0; + font-size : 16pt; +} + +div.helpResponse h2 { + border-width : 0px 0px 0px 0px; + font-size : 12pt; + +} + +pre { + border : 1px solid #c0c0c0; + padding : 5px; + background : #f0f0f0; +} diff --git a/tt-rss_compact.css b/tt-rss_compact.css index 7f49402d..cef4e47d 100644 --- a/tt-rss_compact.css +++ b/tt-rss_compact.css @@ -379,3 +379,38 @@ table.prefFeedList tr.title td, table.prefFilterList tr.title td, font-size:9pt; } +a.helpLink { + color : #808080; +} + +a.helpLink:hover { + color : #5050aa; +} + +div.helpResponse { + margin : 10px; + background-image : url("images/vgrad_light_rev2.png"); + background-position : top left; + background-repeat : repeat-x; + padding : 10px 20px 10px 20px; + border : 1px solid #f0f0f0; +} + +div.helpResponse h1 { + border-width : 0px 0px 1px 0px; + border-style : solid; + border-color : #c0c0c0; + font-size : 16pt; +} + +div.helpResponse h2 { + border-width : 0px 0px 0px 0px; + font-size : 12pt; + +} + +pre { + border : 1px solid #c0c0c0; + padding : 5px; + background : #f0f0f0; +} -- 2.39.5
Select SQL expression Select SQL expression + (?) + Caption