feed-browser: feeds adding improved, updater more silent

- includes/config.inc contain array with all feeds
- check_database() adds feeds if they are not present
- updater does not show feed URL

4 files changed, 138 insertions, 85 deletions

diff --git a/contrib/feed-browser/includes/config.inc b/contrib/feed-browser/includes/config.inc
new file mode 100644
index 0000000000..1397d2c947
--- /dev/null
+++ b/contrib/feed-browser/includes/config.inc
@@ -0,0 +1,118 @@
+<?php
+
+define('DB_FILENAME', './feeds2.db');
+
+$feeds = array(
+	array(
+		'distro_name'=>'OpenZaurus', 
+		'distro_version'=>'3.5.4',
+		'feed_base_url'=>'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4/feed/',
+		'feeds'=>array(
+			array(
+				'name'=>'base',
+				'url'=>'base',
+			),
+			array(
+				'name'=>'opie',
+				'url'=>'opie',
+			),
+			array(
+				'name'=>'x11',
+				'url'=>'x11',
+			),
+			array(
+				'name'=>'upgrades',
+				'url'=>'upgrades',
+			),
+			array(
+				'name'=>'perl',
+				'url'=>'perl',
+			),
+			array(
+				'name'=>'python',
+				'url'=>'python',
+			),
+			array(
+				'name'=>'Collie upgrades',
+				'url'=>'upgrades/machine/collie',
+			),
+			array(
+				'name'=>'Tosa upgrades',
+				'url'=>'upgrades/machine/tosa',
+			),
+			array(
+				'name'=>'Poodle upgrades',
+				'url'=>'upgrades/machine/poodle',
+			),
+			array(
+				'name'=>'Poodle',
+				'url'=>'machine/poodle',
+			),
+			array(
+				'name'=>'Collie',
+				'url'=>'machine/collie',
+			),
+			array(
+				'name'=>'Tosa',
+				'url'=>'machine/tosa',
+			)
+		)
+	),
+	array(
+		'distro_name'=>'OpenZaurus', 
+		'distro_version'=>'3.5.4.1',
+		'feed_base_url'=>'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/',
+		'feeds'=>array(
+			array(
+				'name'=>'base',
+				'url'=>'base',
+			),
+			array(
+				'name'=>'opie',
+				'url'=>'opie',
+			),
+			array(
+				'name'=>'perl',
+				'url'=>'perl',
+			),
+			array(
+				'name'=>'python',
+				'url'=>'python',
+			),
+			array(
+				'name'=>'upgrades',
+				'url'=>'upgrades',
+			),
+			array(
+				'name'=>'x11',
+				'url'=>'x11',
+			),
+			array(
+				'name'=>'C7x0',
+				'url'=>'machine/c7x0',
+			),
+			array(
+				'name'=>'Spitz',
+				'url'=>'machine/spitz',
+			),
+			array(
+				'name'=>'Akita',
+				'url'=>'machine/akita',
+			),
+			array(
+				'name'=>'Akita upgrades',
+				'url'=>'upgrades/machine/akita',
+			),
+			array(
+				'name'=>'C7x0 upgrades',
+				'url'=>'upgrades/machine/c7x0',
+			),
+			array(
+				'name'=>'Spitz upgrades',
+				'url'=>'upgrades/machine/spitz',
+			)
+		)
+	)
+);
+
+?>
diff --git a/contrib/feed-browser/includes/functions.inc b/contrib/feed-browser/includes/functions.inc
index d18b129650..4edf3f4369 100644
--- a/contrib/feed-browser/includes/functions.inc
+++ b/contrib/feed-browser/includes/functions.inc
@@ -20,8 +20,6 @@
 
 error_reporting(E_ALL);
 
-define('DB_FILENAME', './feeds.db');
-
 function db_query($query)
 {
     $result = FALSE;
@@ -36,7 +34,6 @@ function db_query($query)
     return $result;
 }
 
-
 function db_query_n($query)
 {
     $result = FALSE;
@@ -76,88 +73,24 @@ function db_table_exists ($db, $mytable)
 	return FALSE;
 }
 
-function test_insert_ipkgs ($db) 
+function insert_feeds ($db) 
 {
+	global $feeds;
 
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,           f_uri)
-		VALUES             ('3541-base',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/base')
-		");
-
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('3541-opie',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/opie')
-		");
-
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('3541-perl',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/perl')
-		");
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('3541-python',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/python')
-		");
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('3541-upgrades',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/upgrades')
-		");
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('3541-x11',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/x11')
-		");
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('3541-machine-c7x0',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/machine/c7x0')
-		");
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('3541-machine-spitz',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/machine/spitz')
-		");
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('3541-machine-akita',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/machine/akita')
-		");
-
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('3541-upgrades-machine-akita',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/upgrades/machine/akita')
-		");
-
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('3541-upgrades-machine-c7x0',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/upgrades/machine/c7x0')
-		");
-
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('3541-upgrades-machine-spitz',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/upgrades/machine/spitz')
-		");
-
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('3541-upgrades-machine-tosa',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4.1/feed/upgrades/machine/tosa')
-		");
-
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,           f_uri)
-		VALUES             ('354-base',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4/feed/base')
-		");
-
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('354-opie',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4/feed/opie')
-		");
-
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('354-x11',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4/feed/x11')
-		");
-
-	sqlite_query($db,
-		"INSERT INTO feeds (f_name,             f_uri)
-		VALUES             ('354-upgrades',    'http://ewi546.ewi.utwente.nl/mirror/www.openzaurus.org/official/unstable/3.5.4/feed/upgrades')
-		");
-
+	if(isset($feeds))
+	{
+		foreach($feeds as $distro)
+		{
+			foreach($distro['feeds'] as $feed)
+			{
+				sqlite_query($db, "INSERT INTO feeds (f_name, f_uri) VALUES
+					(
+						'{$distro['distro_name']} {$distro['distro_version']} {$feed['name']}',
+						'{$distro['feed_base_url']}{$feed['url']}'
+					)");
+			}
+		}
+	}
 }
 
 function searchletter($searchletter = '')
@@ -492,7 +425,7 @@ function check_database()
 				f_uri        varchar(100),
 				f_comments    varchar(500))");
 
-			test_insert_ipkgs ($db) ;
+			insert_feeds ($db) ;
 		}
 
 		sqlite_close($db);
diff --git a/contrib/feed-browser/index.php b/contrib/feed-browser/index.php
index b3fb41bcd8..df7282db7d 100644
--- a/contrib/feed-browser/index.php
+++ b/contrib/feed-browser/index.php
@@ -30,6 +30,7 @@
  *
  */
 
+require_once 'includes/config.inc';
 require_once 'includes/functions.inc';
 
 check_database();
diff --git a/contrib/feed-browser/update.php b/contrib/feed-browser/update.php
index ed7d6e47ef..94c8608616 100644
--- a/contrib/feed-browser/update.php
+++ b/contrib/feed-browser/update.php
@@ -16,6 +16,7 @@
  *              
  */         
 
+require_once 'includes/config.inc';
 require_once 'includes/functions.inc';
 
 /*
@@ -45,7 +46,7 @@ $feeds = db_query("SELECT f_name, f_uri FROM feeds");
 
 foreach($feeds as $feed)
 {
-    print("Updating {$feed['f_name']}: {$feed['f_uri']}: ");
+    print("Updating {$feed['f_name']}: ");
     db_query_n("DELETE FROM packages WHERE p_feed = '{$feed['f_name']}'");
 
     $count = 0;