From dd7d31871e2349edd9a488922eba8f2abfbc3dce Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 18 May 2006 02:20:43 +0100 Subject: new filter action: set starred, rename add filter button --- backend.php | 2 +- functions.php | 10 ++++++++-- schema/ttrss_schema_mysql.sql | 3 +++ schema/ttrss_schema_pgsql.sql | 3 +++ schema/upgrade-1.1.5-1.1.7-mysql.sql | 3 +++ schema/upgrade-1.1.5-1.1.7-pgsql.sql | 3 +++ 6 files changed, 21 insertions(+), 3 deletions(-) diff --git a/backend.php b/backend.php index 7fe0dddab..3a62fe684 100644 --- a/backend.php +++ b/backend.php @@ -2284,7 +2284,7 @@ print ""; + value=\"Create filter\">"; print ""; diff --git a/functions.php b/functions.php index e11eafcb2..06b142d73 100644 --- a/functions.php +++ b/functions.php @@ -529,12 +529,18 @@ $unread = 'false'; $last_read_qpart = 'NOW()'; } + + if ($filter_name == 'mark') { + $marked = 'true'; + } else { + $marked = 'false'; + } $result = db_query($link, "INSERT INTO ttrss_user_entries - (ref_id, owner_uid, feed_id, unread, last_read) + (ref_id, owner_uid, feed_id, unread, last_read, marked) VALUES ('$ref_id', '$owner_uid', '$feed', $unread, - $last_read_qpart)"); + $last_read_qpart, $marked)"); } $post_needs_update = false; diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index d53eb60cd..e1d61009c 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -137,6 +137,9 @@ insert into ttrss_filter_actions (id,name,description) values (1, 'filter', insert into ttrss_filter_actions (id,name,description) values (2, 'catchup', 'Mark as read'); +insert into ttrss_filter_actions (id,name,description) values (3, 'mark', + 'Set starred'); + create table ttrss_filters (id integer not null primary key auto_increment, owner_uid integer not null, feed_id integer default null, diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index b8c813c47..1726ecc8e 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -131,6 +131,9 @@ insert into ttrss_filter_actions (id,name,description) values (1, 'filter', insert into ttrss_filter_actions (id,name,description) values (2, 'catchup', 'Mark as read'); +insert into ttrss_filter_actions (id,name,description) values (3, 'mark', + 'Set starred'); + create table ttrss_filters (id serial not null primary key, owner_uid integer not null references ttrss_users(id) on delete cascade, feed_id integer references ttrss_feeds(id) on delete cascade default null, diff --git a/schema/upgrade-1.1.5-1.1.7-mysql.sql b/schema/upgrade-1.1.5-1.1.7-mysql.sql index aa74eb343..bfccc3358 100644 --- a/schema/upgrade-1.1.5-1.1.7-mysql.sql +++ b/schema/upgrade-1.1.5-1.1.7-mysql.sql @@ -3,5 +3,8 @@ insert into ttrss_themes (theme_name, theme_path) values ('Old-skool', 'compat') insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('ON_CATCHUP_SHOW_NEXT_FEED', 1, 'false', 'On catchup show next feed',2, 'When "Mark as read" button is clicked in toolbar, automatically open next feed with unread articles.'); +insert into ttrss_filter_actions (id,name,description) values (3, 'mark', + 'Set starred'); + update ttrss_version set schema_version = 8; diff --git a/schema/upgrade-1.1.5-1.1.7-pgsql.sql b/schema/upgrade-1.1.5-1.1.7-pgsql.sql index 88b1ecf35..4a2237a3f 100644 --- a/schema/upgrade-1.1.5-1.1.7-pgsql.sql +++ b/schema/upgrade-1.1.5-1.1.7-pgsql.sql @@ -5,6 +5,9 @@ insert into ttrss_themes (theme_name, theme_path) values ('Old-skool', 'compat') insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('ON_CATCHUP_SHOW_NEXT_FEED', 1, 'false', 'On catchup show next feed',2, 'When "Mark as read" button is clicked in toolbar, automatically open next feed with unread articles.'); +insert into ttrss_filter_actions (id,name,description) values (3, 'mark', + 'Set starred'); + update ttrss_version set schema_version = 8; commit; -- cgit v1.2.3