}
$purge_intervals = array(
- 0 => "Default",
+ 0 => "Use default",
-1 => "Never purge",
- 5 => "1 week",
- 14 => "2 weeks",
- 31 => "1 month",
- 60 => "2 months",
- 90 => "3 months");
+ 5 => "1 week old",
+ 14 => "2 weeks old",
+ 31 => "1 month old",
+ 60 => "2 months old",
+ 90 => "3 months old");
$update_intervals = array(
- 0 => "Default",
+ 0 => "Use default",
-1 => "Disable updates",
- 30 => "30 minutes",
- 60 => "1 hour",
- 240 => "4 hours",
- 720 => "12 hours",
+ 30 => "Each 30 minutes",
+ 60 => "Hourly",
+ 240 => "Each 4 hours",
+ 720 => "Each 12 hours",
1440 => "Daily",
10080 => "Weekly");
print "<div class=\"infoBoxContents\">";
-# print "<h1>$feed_icon $title</h1>";
+ print "<form id=\"edit_feed_form\">";
- print "<table width='100%'>";
+ print "<input type=\"hidden\" name=\"id\" value=\"$feed_id\">";
+ print "<input type=\"hidden\" name=\"op\" value=\"pref-feeds\">";
+ print "<input type=\"hidden\" name=\"subop\" value=\"editSave\">";
-# $row_class = "odd";
+ print "<table width='100%'>";
- print "<tr class='$row_class'><td>Title:</td>";
- print "<td><input id=\"iedit_title\" value=\"$title\"></td></tr>";
+ print "<tr><td>Title:</td>";
+ print "<td><input class=\"iedit\" name=\"title\" value=\"$title\"></td></tr>";
$feed_url = db_fetch_result($result, 0, "feed_url");
$feed_url = htmlspecialchars(db_unescape_string(db_fetch_result($result,
0, "feed_url")));
-# $row_class = toggleEvenOdd($row_class);
-
- print "<tr class='$row_class'><td>Feed URL:</td>";
- print "<td><input id=\"iedit_link\" value=\"$feed_url\"></td></tr>";
+
+ print "<tr><td>Feed URL:</td>";
+ print "<td><input class=\"iedit\" name=\"feed_url\" value=\"$feed_url\"></td></tr>";
if (get_pref($link, 'ENABLE_FEED_CATS')) {
$cat_id = db_fetch_result($result, 0, "cat_id");
-# $row_class = toggleEvenOdd($row_class);
-
- print "<tr class='$row_class'><td>Category:</td>";
+ print "<tr><td>Category:</td>";
print "<td>";
- print "<select id=\"iedit_fcat\">";
- print "<option id=\"0\">Uncategorized</option>";
-
- $tmp_result = db_query($link, "SELECT id,title FROM ttrss_feed_categories
- WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
- if (db_num_rows($tmp_result) > 0) {
- print "<option disabled>--------</option>";
- }
+ print_feed_cat_select($link, "cat_id", $cat_id);
- while ($tmp_line = db_fetch_assoc($tmp_result)) {
- if ($tmp_line["id"] == $cat_id) {
- $is_selected = "selected";
- } else {
- $is_selected = "";
- }
- printf("<option $is_selected id='%d'>%s</option>",
- $tmp_line["id"], $tmp_line["title"]);
- }
-
- print "</select></td>";
+ print "</td>";
print "</td></tr>";
}
$update_interval = db_fetch_result($result, 0, "update_interval");
-# $row_class = toggleEvenOdd($row_class);
- print "<tr class='$row_class'><td>Update Interval:</td>";
-// print "<td><input id=\"iedit_updintl\"
-// value=\"$update_interval\"></td></tr>";
+ print "<tr><td>Update Interval:</td>";
print "<td>";
- print "<select id=\"iedit_updintl\">";
+ print "<select name=\"update_interval\">";
foreach (array_keys($update_intervals) as $i) {
} else {
$selected = "";
}
- print "<option $selected id=\"$i\">" . $update_intervals[$i] . "</option>";
+ print "<option $selected value=\"$i\">" . $update_intervals[$i] . "</option>";
}
print "</select>";
print "</td>";
-# $row_class = toggleEvenOdd($row_class);
-
- print "<tr class='$row_class'><td>Link to:</td><td>";
+ print "<tr><td>Link to:</td><td>";
$tmp_result = db_query($link, "SELECT COUNT(id) AS count
FROM ttrss_feeds WHERE parent_feed = '$feed_id'");
$disabled = "disabled";
}
- print "<select $disabled id=\"iedit_parent_feed\">";
+ print "<select $disabled name=\"parent_feed\">";
- print "<option id=\"0\">Not linked</option>";
+ print "<option value=\"0\">Not linked</option>";
if (get_pref($link, 'ENABLE_FEED_CATS')) {
if ($cat_id) {
} else {
$is_selected = "";
}
- printf("<option $is_selected id='%d'>%s</option>",
+ printf("<option $is_selected value='%d'>%s</option>",
$tmp_line["id"], $tmp_line["title"]);
}
print "</td></tr>";
$purge_interval = db_fetch_result($result, 0, "purge_interval");
-# $row_class = toggleEvenOdd($row_class);
- print "<tr class='$row_class'><td>Purge Days:</td>";
-// print "<td><input id=\"iedit_purgintl\"
-// value=\"$purge_interval\"></td></tr>";
+ print "<tr><td>Article purging:</td>";
print "<td>";
- print "<select id=\"iedit_purgintl\">";
+ print "<select name=\"purge_interval\">";
foreach (array_keys($purge_intervals) as $i) {
} else {
$selected = "";
}
- print "<option $selected id=\"$i\">" . $purge_intervals[$i] . "</option>";
+ print "<option $selected value=\"$i\">" . $purge_intervals[$i] . "</option>";
}
print "</select>";
print "</td>";
-// print "<tr><td colspan=\"2\"><b>Authentication</b></td></tr>";
-
-# $row_class = toggleEvenOdd($row_class);
$auth_login = db_fetch_result($result, 0, "auth_login");
- print "<tr class='$row_class'><td>Login:</td>";
- print "<td><input id=\"iedit_login\"
- value=\"$auth_login\"></td></tr>";
+ print "<tr><td>Login:</td>";
+ print "<td><input class=\"iedit\" name=\"auth_login\" value=\"$auth_login\"></td></tr>";
-# $row_class = toggleEvenOdd($row_class);
$auth_pass = db_fetch_result($result, 0, "auth_pass");
- print "<tr class='$row_class'><td>Password:</td>";
- print "<td><input type=\"password\" id=\"iedit_pass\"
+ print "<tr><td>Password:</td>";
+ print "<td><input class=\"iedit\" type=\"password\" name=\"auth_pass\"
value=\"$auth_pass\"></td></tr>";
-# $row_class = toggleEvenOdd($row_class);
$private = sql_bool_to_bool(db_fetch_result($result, 0, "private"));
if ($private) {
$checked = "";
}
- print "<tr class='$row_class'><td valign='top'>Options:</td>";
- print "<td><input type=\"checkbox\" id=\"iedit_private\"
- $checked><label for=\"iedit_private\">Hide from feed browser</label>";
+ print "<tr><td valign='top'>Options:</td>";
+ print "<td><input type=\"checkbox\" name=\"private\" id=\"private\"
+ $checked><label for=\"private\">Hide from feed browser</label>";
$rtl_content = sql_bool_to_bool(db_fetch_result($result, 0, "rtl_content"));
$checked = "";
}
- print "<br><input type=\"checkbox\" id=\"iedit_rtl\"
- $checked><label for=\"iedit_rtl\">Right-to-left content</label>";
+ print "<br><input type=\"checkbox\" id=\"rtl_content\" name=\"rtl_content\"
+ $checked><label for=\"rtl_content\">Right-to-left content</label>";
print "</td></tr>";
print "</table>";
+
+ print "</form>";
+
print "</div>";
print "<div align='center'>
}
if ($subop == "editSave") {
- $feed_title = db_escape_string(trim($_POST["t"]));
- $feed_link = db_escape_string(trim($_POST["l"]));
- $upd_intl = db_escape_string($_POST["ui"]);
- $purge_intl = db_escape_string($_POST["pi"]);
- $feed_id = db_escape_string($_POST["id"]);
- $cat_id = db_escape_string($_POST["catid"]);
- $auth_login = db_escape_string(trim($_POST["login"]));
- $auth_pass = db_escape_string(trim($_POST["pass"]));
- $parent_feed = db_escape_string($_POST["pfeed"]);
- $private = db_escape_string($_POST["is_pvt"]);
- $rtl_content = db_escape_string($_POST["is_rtl"]);
-
- if (strtoupper($upd_intl) == "DEFAULT")
- $upd_intl = 0;
-
- if (strtoupper($upd_intl) == "DISABLED")
- $upd_intl = -1;
-
- if (strtoupper($purge_intl) == "DEFAULT")
- $purge_intl = 0;
-
- if (strtoupper($purge_intl) == "DISABLED")
- $purge_intl = -1;
- if ($cat_id != 0) {
+ $feed_title = db_escape_string(trim($_POST["title"]));
+ $feed_link = db_escape_string(trim($_POST["feed_url"]));
+ $upd_intl = db_escape_string($_POST["update_interval"]);
+ $purge_intl = db_escape_string($_POST["purge_interval"]);
+ $feed_id = db_escape_string($_POST["id"]);
+ $cat_id = db_escape_string($_POST["cat_id"]);
+ $auth_login = db_escape_string(trim($_POST["auth_login"]));
+ $auth_pass = db_escape_string(trim($_POST["auth_pass"]));
+ $parent_feed = db_escape_string($_POST["parent_feed"]);
+ $private = checkbox_to_sql_bool(db_escape_string($_POST["private"]));
+ $rtl_content = checkbox_to_sql_bool(db_escape_string($_POST["rtl_content"]));
+
+ if ($cat_id && $cat_id != 0) {
$category_qpart = "cat_id = '$cat_id'";
} else {
$category_qpart = 'cat_id = NULL';
}
- if ($parent_feed != 0) {
+ if ($parent_feed && $parent_feed != 0) {
$parent_qpart = "parent_feed = '$parent_feed'";
} else {
$parent_qpart = 'parent_feed = NULL';
print " | ";
- $result = db_query($link, "SELECT title,id FROM ttrss_feed_categories
- WHERE owner_uid = ".$_SESSION["uid"]."
- ORDER BY title");
-
- print "<select id=\"sfeed_set_fcat\" disabled=\"true\">";
- print "<option id=\"0\">Uncategorized</option>";
-
- if (db_num_rows($result) != 0) {
-
- print "<option disabled>--------</option>";
-
- while ($line = db_fetch_assoc($result)) {
- printf("<option id='%d'>%s</option>",
- $line["id"], $line["title"]);
- }
- }
-
- print "</select>";
+ print_feed_cat_select($link, "sfeed_set_fcat", "", "disabled");
print " <input type=\"submit\" class=\"button\" disabled=\"true\"
onclick=\"javascript:categorizeSelectedFeeds()\" value=\"Recategorize\">";
print "<h3>Edit Categories</h3>";
- // print "<h3>Categories</h3>";
-
print "<div class=\"prefGenericAddBox\">
<input id=\"fadd_cat\"
onkeyup=\"toggleSubmitNotEmpty(this, 'catadd_submit_btn')\"
array_push($filter_types, $line["description"]);
}
-/* print "<div class=\"prefGenericAddBox\">
- <input id=\"fadd_regexp\" size=\"40\"> ";
-
- print_select("fadd_match", "Title", $filter_types);
-
- print " <select id=\"fadd_feed\">";
-
- print "<option selected id=\"0\">All feeds</option>";
-
- $result = db_query($link, "SELECT id,title FROM ttrss_feeds
- WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
-
- if (db_num_rows($result) > 0) {
- print "<option disabled>--------</option>";
- }
-
- while ($line = db_fetch_assoc($result)) {
- printf("<option id='%d'>%s</option>", $line["id"],
- db_unescape_string($line["title"]));
- }
-
- print "</select> ";
-
- print " Action: ";
-
- print "<select id=\"fadd_action\">";
-
- $result = db_query($link, "SELECT id,description FROM ttrss_filter_actions
- ORDER BY name");
-
- while ($line = db_fetch_assoc($result)) {
- printf("<option id='%d'>%s</option>", $line["id"], $line["description"]);
- }
-
- print "</select> ";
-
-/* print "<input type=\"submit\"
- class=\"button\" onclick=\"javascript:testFilter()\"
- value=\"Test filter\"> "; */
-
-/* print "<input type=\"submit\"
- class=\"button\" onclick=\"javascript:addFilter()\"
- value=\"Create filter\">"; */
-
print "<input type=\"submit\"
class=\"button\"
onclick=\"javascript:displayDlg('quickAddFilter', false)\"
value=\"Create filter\">";
-// print "</div>";
-
$result = db_query($link, "SELECT
ttrss_filters.id AS id,reg_exp,
ttrss_filter_types.name AS filter_type_name,
print "<td><input id=\"iedit_regexp\" value=\"".$line["reg_exp"].
"\"></td>";
- print "<td>";
- print "<select id=\"iedit_feed\">";
- print "<option id=\"0\">All feeds</option>";
-
- $tmp_result = db_query($link, "SELECT id,title FROM ttrss_feeds
- WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
-
- if (db_num_rows($tmp_result) > 0) {
- print "<option disabled>--------</option>";
- }
-
- while ($tmp_line = db_fetch_assoc($tmp_result)) {
- if ($tmp_line["id"] == $line["feed_id"]) {
- $is_selected = "selected";
- } else {
- $is_selected = "";
- }
- printf("<option $is_selected id='%d'>%s</option>",
- $tmp_line["id"], db_unescape_string($tmp_line["title"]));
- }
-
- print "</select></td>";
-
+ print "<td>";
+ print_feed_select($link, "iedit_feed", $line["feed_id"]);
+ print "</td>";
+
print "<td>";
print_select("iedit_match", $line["filter_type_descr"], $filter_types);
print "</td>";
if ($num_matches > 0) {
- print "<p>Query returned <b>$num_matches</b> matches, first 5 follow:</p>";
+ print "<p>Query returned <b>$num_matches</b> matches, showing first 15:</p>";
$result = db_query($link,
"SELECT title,
WHERE ($expr) AND
ttrss_user_entries.ref_id = ttrss_entries.id
AND owner_uid = " . $_SESSION["uid"] . "
- ORDER BY date_entered DESC LIMIT 5");
+ ORDER BY date_entered DESC LIMIT 15");
- print "<ul class=\"nomarks\">";
+ print "<ul class=\"filterTestResults\">";
+
+ $row_class = "even";
+
while ($line = db_fetch_assoc($result)) {
- print "<li>".$line["title"].
+ $row_class = toggleEvenOdd($row_class);
+
+ print "<li class=\"$row_class\">".$line["title"].
" <span class=\"insensitive\">(".$line["feed_title"].")</span></li>";
}
print "</ul>";
</td</tr>";
print "<tr class=\"title\">
- <td align='center' width=\"5%\"> </td>
+ <td width=\"5%\"> </td>
<td width=\"40%\">SQL expression
<a class=\"helpLink\" href=\"javascript:displayHelpInfobox(1)\">(?)</a>
</td>
if (!$line["description"]) $line["description"] = "[No description]";
- print "<td><input disabled=\"true\" type=\"checkbox\"
+ print "<td align='center'><input disabled=\"true\" type=\"checkbox\"
id=\"LICHK-".$line["id"]."\"></td>";
print "<td>".$line["sql_exp"]."</td>";
} else {
- print "<td><input disabled=\"true\" type=\"checkbox\" checked></td>";
+ print "<td align='center'><input disabled=\"true\" type=\"checkbox\" checked></td>";
print "<td><input id=\"iedit_expr\" value=\"".$line["sql_exp"].
"\"></td>";
print "<div id=\"infoBoxTitle\">Create filter</div>";
print "<div class=\"infoBoxContents\">";
+// print "<div class=\"notice\"><b>Note:</b> filter will only apply to new articles.</div>";
+
$result = db_query($link, "SELECT description
FROM ttrss_filter_types ORDER BY description");
print_select("fadd_match", "Title", $filter_types);
print "</td></tr>";
- print "<tr><td>Feed:</td><td><select id=\"fadd_feed\">";
-
- print "<option selected id=\"0\">All feeds</option>";
-
- $result = db_query($link, "SELECT id,title FROM ttrss_feeds
- WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
-
- if (db_num_rows($result) > 0) {
- print "<option disabled>--------</option>";
- }
-
- while ($line = db_fetch_assoc($result)) {
- if ($param == $line["id"]) {
- $selected = "selected";
- } else {
- $selected = "";
- }
- printf("<option id='%d' %s>%s</option>", $line["id"], $selected, $line["title"]);
- }
-
- print "</select></td></tr>";
+ print "<tr><td>Feed:</td><td>";
+
+ print_feed_select($link, "fadd_feed");
+
+ print "</td></tr>";
print "<tr><td>Action:</td>";
}
- if ($op == "feed-details") {
-
-// $feed_id = $_GET["id"];
-
- $feed_ids = split(",", db_escape_string($_GET["id"]));
-
- print "<div id=\"infoBoxTitle\">Feed details</div>";
- print "<div class=\"infoBoxContents\">";
-
- foreach ($feed_ids as $feed_id) {
-
- $result = db_query($link,
- "SELECT
- title,feed_url,
- SUBSTRING(last_updated,1,16) as last_updated,
- icon_url,site_url,
- (SELECT COUNT(int_id) FROM ttrss_user_entries
- WHERE feed_id = id) AS total,
- (SELECT COUNT(int_id) FROM ttrss_user_entries
- WHERE feed_id = id AND unread = true) AS unread,
- (SELECT COUNT(int_id) FROM ttrss_user_entries
- WHERE feed_id = id AND marked = true) AS marked
- FROM ttrss_feeds
- WHERE id = '$feed_id' AND owner_uid = ".$_SESSION["uid"]);
-
- if (db_num_rows($result) == 0) return;
-
- $title = db_unescape_string(db_fetch_result($result, 0, "title"));
- $last_updated = date(get_pref($link, 'LONG_DATE_FORMAT'),
- strtotime(db_fetch_result($result, 0, "last_updated")));
- $feed_url = db_fetch_result($result, 0, "feed_url");
- $icon_url = db_fetch_result($result, 0, "icon_url");
- $total = db_fetch_result($result, 0, "total");
- $unread = db_fetch_result($result, 0, "unread");
- $marked = db_fetch_result($result, 0, "marked");
- $site_url = db_fetch_result($result, 0, "site_url");
-
- $result = db_query($link, "SELECT COUNT(id) AS subscribed
- FROM ttrss_feeds WHERE feed_url = '$feed_url' AND private = false");
-
- $subscribed = db_fetch_result($result, 0, "subscribed");
-
- $icon_file = ICONS_DIR . "/$feed_id.ico";
-
- if (file_exists($icon_file) && filesize($icon_file) > 0) {
- $feed_icon = "<img width=\"16\" height=\"16\"
- src=\"" . ICONS_URL . "/$feed_id.ico\">";
- } else {
- $feed_icon = "";
- }
-
- print "<h1>$feed_icon $title</h1>";
-
- print "<table width='100%'>";
-
- if ($site_url) {
- print "<tr><td width='30%'>Link</td>
- <td><a href=\"$site_url\">$site_url</a>
- <a href=\"$feed_url\">(feed)</a></td>
- </td></tr>";
- } else {
- print "<tr><td width='30%'>Feed URL</td>
- <td><a href=\"$feed_url\">$feed_url</a></td></tr>";
- }
- print "<tr><td>Last updated</td><td>$last_updated</td></tr>";
- print "<tr><td>Total articles</td><td>$total</td></tr>";
- print "<tr><td>Unread articles</td><td>$unread</td></tr>";
- print "<tr><td>Starred articles</td><td>$marked</td></tr>";
- print "<tr><td>Subscribed users</td><td>$subscribed</td></tr>";
-
- print "</table>";
-
-/* $result = db_query($link, "SELECT title,
- SUBSTRING(updated,1,16) AS updated,unread
- FROM ttrss_entries,ttrss_user_entries
- WHERE ref_id = id AND feed_id = '$feed_id'
- ORDER BY date_entered DESC LIMIT 5");
-
- if (db_num_rows($result) > 0) {
-
- print "<h1>Latest headlines</h1>";
-
- print "<ul class=\"nomarks\">";
-
- while ($line = db_fetch_assoc($result)) {
- if ($line["unread"] == "t" || $line["unread"] == "1") {
- $line["title"] = "<b>" . $line["title"] . "</b>";
- }
- print "<li>" . $line["title"].
- " <span class=\"insensitive\">(" .
- date(get_pref($link, 'SHORT_DATE_FORMAT'),
- strtotime($line["updated"])).
- ")</span></li>";
- }
-
- print "</ul>";
-
- } */
- }
-
- print "</div>";
-
- print "<div align='center'>
- <input type='submit' class='button'
- onclick=\"closeInfoBox()\" value=\"Close this window\"></div>";
- }
-
if ($op == "pref-feed-browser") {
if (!ENABLE_FEED_BROWSER) {
git.wh0rd.org / tt-rss.git / blobdiff