From 7dc66a616e00559aeed9cd49f0c65208170e122f Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sun, 16 Oct 2005 16:17:12 +0100 Subject: add SQL expression help and placeholder for help mechanism --- backend.php | 56 +++++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 55 insertions(+), 1 deletion(-) (limited to 'backend.php') diff --git a/backend.php b/backend.php index 41b2c29db..3975cd3b7 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); ?> -- cgit v1.2.3
SelectSQL expressionSelectSQL expression + (?) + Caption