From 273a2f6b43aae0c8a8ed0cfce767ddeedd26106d Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 18 Nov 2005 08:04:41 +0100 Subject: [PATCH] schema updates, ICONS_DIR/ICONS_URL moved to config.php --- backend.php | 6 +++--- config.php-dist | 2 ++ functions.php | 2 +- schema/ttrss_schema_mysql.sql | 4 +--- schema/ttrss_schema_pgsql.sql | 2 -- 5 files changed, 7 insertions(+), 9 deletions(-) diff --git a/backend.php b/backend.php index a8a94cf6..ff43bc6f 100644 --- a/backend.php +++ b/backend.php @@ -858,7 +858,7 @@ foreach ($ids as $id) { db_query($link, "DELETE FROM ttrss_feeds WHERE id = '$id'"); - $icons_dir = get_pref($link, 'ICONS_DIR'); + $icons_dir = ICONS_DIR; if (file_exists($icons_dir . "/$id.ico")) { unlink($icons_dir . "/$id.ico"); @@ -944,11 +944,11 @@ print ""; - $icon_file = get_pref($link, 'ICONS_DIR') . "/$feed_id.ico"; + $icon_file = ICONS_DIR . "/$feed_id.ico"; if (file_exists($icon_file) && filesize($icon_file) > 0) { $feed_icon = ""; + src=\"" . ICONS_URL . "/$feed_id.ico\">"; } else { $feed_icon = " "; } diff --git a/config.php-dist b/config.php-dist index 9cea364d..3af61c32 100644 --- a/config.php-dist +++ b/config.php-dist @@ -13,6 +13,8 @@ define(WEB_DEMO_MODE, false); + define(ICONS_DIR, "icons"); + define(ICONS_URL, "icons"); define(USE_HTTP_AUTH, false); // use HTTP Basic authentication diff --git a/functions.php b/functions.php index 67575cbb..3198c497 100644 --- a/functions.php +++ b/functions.php @@ -81,7 +81,7 @@ $feed_url = preg_replace("/\/.*$/", "", $feed_url); $icon_url = "http://$feed_url/favicon.ico"; - $icon_file = get_pref($link, 'ICONS_DIR') . "/$feed.ico"; + $icon_file = ICONS_DIR . "/$feed.ico"; if (!file_exists($icon_file)) { diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index a6ec9919..31d1ff01 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -55,7 +55,7 @@ create table ttrss_entries (id integer not null primary key auto_increment, feed_id integer not null, updated datetime not null, title text not null, - guid varchar(255) not null unique, + guid varchar(255) not null, link text not null, content text not null, content_hash varchar(250) not null, @@ -153,8 +153,6 @@ create table ttrss_prefs (pref_name varchar(250) not null primary key, foreign key (section_id) references ttrss_prefs_sections(id)) TYPE=InnoDB; insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ENABLE_FEED_ICONS', 1, 'true', 'Enable icons in feedlist',2); -insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ICONS_DIR', 2, 'icons', 'Local directory for feed icons',1); -insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ICONS_URL', 2, 'icons', 'Local URL for icons',1); insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('PURGE_OLD_DAYS', 3, '60', 'Purge old posts after this number of days (0 - disables)',1); insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('UPDATE_POST_ON_CHECKSUM_CHANGE', 1, 'true', 'Update post on checksum change',1); insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ENABLE_PREFS_CATCHUP_UNCATCHUP', 1, 'false', 'Enable catchup/uncatchup buttons in feed editor',2); diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index caecd970..ab839ebf 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -131,8 +131,6 @@ create table ttrss_prefs (pref_name varchar(250) not null primary key, def_value text not null); insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ENABLE_FEED_ICONS', 1, 'true', 'Enable icons in feedlist',2); -insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ICONS_DIR', 2, 'icons', 'Local directory for feed icons',1); -insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ICONS_URL', 2, 'icons', 'Local URL for icons',1); insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('PURGE_OLD_DAYS', 3, '60', 'Purge old posts after this number of days (0 - disables)',1); insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('UPDATE_POST_ON_CHECKSUM_CHANGE', 1, 'true', 'Update post on checksum change',1); insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ENABLE_PREFS_CATCHUP_UNCATCHUP', 1, 'false', 'Enable catchup/uncatchup buttons in feed editor',2); -- 2.39.5