From 396927890b0daf83f835ffe50dcdc14e038acf74 Mon Sep 17 00:00:00 2001 From: Marcin Juszkiewicz Date: Thu, 24 Aug 2006 11:46:27 +0000 Subject: feed-browser/update.php: define database name once --- contrib/feed-browser/update.php | 31 ++++++++++++++++++++----------- 1 file changed, 20 insertions(+), 11 deletions(-) diff --git a/contrib/feed-browser/update.php b/contrib/feed-browser/update.php index c32e1804cc..07f4f15bc9 100644 --- a/contrib/feed-browser/update.php +++ b/contrib/feed-browser/update.php @@ -39,6 +39,7 @@ $start = time(); $p_count = 0; +define('DB_FILENAME', './feeds.db'); $feeds = db_query("SELECT f_name, f_uri FROM feeds"); @@ -151,22 +152,30 @@ function insert_ipkgs ($package, $version, $depends, $section, $arch, $maintaine function db_query($query) { - $db_name = "./feeds.db"; - $db_h = sqlite_open($db_name); - $query_h = sqlite_query ($db_h, $query); - $result = sqlite_fetch_all ($query_h, SQLITE_ASSOC); - sqlite_close($db_h); - return ($result); + $result = FALSE; + + if($db_h = sqlite_open(DB_FILENAME)) + { + $query_h = sqlite_query ($db_h, $query); + $result = sqlite_fetch_all ($query_h, SQLITE_ASSOC); + sqlite_close($db_h); + } + + return $result; } function db_query_n($query) { - $db_name = "./feeds.db"; - $db_h = sqlite_open($db_name); - $query_h = sqlite_query ($db_h, $query); - sqlite_close($db_h); - return ($result); + $result = FALSE; + + if($db_h = sqlite_open(DB_FILENAME)) + { + $query_h = sqlite_query ($db_h, $query); + sqlite_close($db_h); + } + + return $result; } -- cgit v1.2.3