From ede184cacc411173ba29f05f9b8a12d18a595e0f Mon Sep 17 00:00:00 2001 From: plegall Date: Fri, 19 Aug 2005 13:54:40 +0000 Subject: - modification : RSS feed work only with a given feed identifier. Thus we can avoid fixed frequency notification to concentrate on variable frequency notification, which is much more interesting. To do this, feeds have moved to a dedicated table allowing each user (including guest user) to have more than on feed. git-svn-id: http://piwigo.org/svn/trunk@833 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/include/functions.php | 1 + admin/maintenance.php | 13 ++++++++++++- 2 files changed, 13 insertions(+), 1 deletion(-) (limited to 'admin') diff --git a/admin/include/functions.php b/admin/include/functions.php index b787d8a21..2b7a9a5cc 100644 --- a/admin/include/functions.php +++ b/admin/include/functions.php @@ -1292,6 +1292,7 @@ SELECT user_id // table $tables = array( + USER_FEED_TABLE, USER_INFOS_TABLE, USER_ACCESS_TABLE, USER_CACHE_TABLE, diff --git a/admin/maintenance.php b/admin/maintenance.php index f6dfa3297..935e42f0a 100644 --- a/admin/maintenance.php +++ b/admin/maintenance.php @@ -68,6 +68,16 @@ DELETE DELETE FROM '.SESSIONS_TABLE.' WHERE expiration < NOW() +;'; + pwg_query($query); + break; + } + case 'feeds' : + { + $query = ' +DELETE + FROM '.USER_FEED_TABLE.' + WHERE last_check IS NULL ;'; pwg_query($query); break; @@ -91,7 +101,8 @@ $template->assign_vars( 'U_MAINT_CATEGORIES' => add_session_id($start_url.'categories'), 'U_MAINT_IMAGES' => add_session_id($start_url.'images'), 'U_MAINT_HISTORY' => add_session_id($start_url.'history'), - 'U_MAINT_SESSIONS' => add_session_id($start_url.'sessions') + 'U_MAINT_SESSIONS' => add_session_id($start_url.'sessions'), + 'U_MAINT_FEEDS' => add_session_id($start_url.'feeds'), ) ); -- cgit v1.2.3