diff options
| author | Andrew Dolgov <[email protected]> | 2005-10-16 16:17:12 +0100 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2005-10-16 16:17:12 +0100 |
| commit | 7dc66a616e00559aeed9cd49f0c65208170e122f (patch) | |
| tree | f67e55adc801535add7b66bf061cec03c19bc8db /backend.php | |
| parent | 6e0584e9308e0dc0049d2d59d2b0c86f619720b0 (diff) | |
add SQL expression help and placeholder for help mechanism
Diffstat (limited to 'backend.php')
| -rw-r--r-- | backend.php | 56 |
1 files changed, 55 insertions, 1 deletions
diff --git a/backend.php b/backend.php index 41b2c29db..3975cd3b7 100644 --- a/backend.php +++ b/backend.php @@ -1125,7 +1125,9 @@ print "<p><table width=\"100%\" class=\"prefLabelList\" id=\"prefLabelList\">"; print "<tr class=\"title\"> - <td width=\"5%\">Select</td><td width=\"40%\">SQL expression</td> + <td width=\"5%\">Select</td><td width=\"40%\">SQL expression + <a class=\"helpLink\" href=\"javascript:popupHelp(1)\">(?)</a> + </td> <td width=\"40%\">Caption</td></tr>"; $lnum = 0; @@ -1220,5 +1222,57 @@ print "</div>"; } + if ($op == "help") { + print "<html><head> + <title>Tiny Tiny RSS : Help</title> + <link rel=\"stylesheet\" href=\"tt-rss.css\" type=\"text/css\"> + <script type=\"text/javascript\" src=\"functions.js\"></script> + <script type=\"text/javascript\" src=\"feedlist.js\"></script> + <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"> + </head><body>"; + + $tid = sprintf("%d", $_GET["tid"]); + + /* FIXME this badly needs real implementation */ + + print "<div class='helpResponse'>"; + + ?> + + <h1>Help for SQL expressions</h1> + + <h2>Description</h2> + + <p>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.</p> + + <h2>Examples</h2> + + <pre>unread = true</pre> + + Matches all unread articles + + <pre>title like '%Linux%'</pre> + + Matches all articles which mention Linux in the title. You get the idea. + + <p>See the database schema included in the distribution package for gruesome + details.</p> + + <? + + print "<div align='center'> + <a class=\"helpLink\" + href=\"javascript:window.close()\">(Close this window)</a></div>"; + + print "</div>"; + + print "</body></html>"; + + } + db_close($link); ?> |