summaryrefslogtreecommitdiff
path: root/contrib/feed-browser/includes
diff options
context:
space:
mode:
authorMarcin Juszkiewicz <hrw@openembedded.org>2006-08-25 10:45:56 +0000
committerMarcin Juszkiewicz <hrw@openembedded.org>2006-08-25 10:45:56 +0000
commit15fe10f53b83794d42ff5d59b9006e21cc3f7652 (patch)
tree9f879830c8fc601df2ffbb2f5ba01ae77e64d8b5 /contrib/feed-browser/includes
parent219969bfd684be1d202d581830107b98dd1c9165 (diff)
feed-browser: FIX: feed structure was changed - database NEED to be rebuilt
- package.p_feed is now int -> feeds.f_id
Diffstat (limited to 'contrib/feed-browser/includes')
-rw-r--r--contrib/feed-browser/includes/config.inc2
-rw-r--r--contrib/feed-browser/includes/functions.inc9
2 files changed, 8 insertions, 3 deletions
diff --git a/contrib/feed-browser/includes/config.inc b/contrib/feed-browser/includes/config.inc
index 1397d2c947..0a270a8eb0 100644
--- a/contrib/feed-browser/includes/config.inc
+++ b/contrib/feed-browser/includes/config.inc
@@ -1,6 +1,6 @@
<?php
-define('DB_FILENAME', './feeds2.db');
+define('DB_FILENAME', './feeds.db');
$feeds = array(
array(
diff --git a/contrib/feed-browser/includes/functions.inc b/contrib/feed-browser/includes/functions.inc
index 4edf3f4369..77afca6f5e 100644
--- a/contrib/feed-browser/includes/functions.inc
+++ b/contrib/feed-browser/includes/functions.inc
@@ -79,15 +79,20 @@ function insert_feeds ($db)
if(isset($feeds))
{
+ $id = 1;
+
foreach($feeds as $distro)
{
foreach($distro['feeds'] as $feed)
{
- sqlite_query($db, "INSERT INTO feeds (f_name, f_uri) VALUES
+ sqlite_query($db, "INSERT INTO feeds (f_id, f_name, f_uri) VALUES
(
+ {$id},
'{$distro['distro_name']} {$distro['distro_version']} {$feed['name']}',
'{$distro['feed_base_url']}{$feed['url']}'
)");
+
+ $id++;
}
}
}
@@ -166,7 +171,7 @@ function pkgdetails ($package)
{
$result = db_query("SELECT * FROM packages,feeds
WHERE (packages.p_name='$package' OR packages.p_provides='$package')
- AND feeds.f_name = packages.p_feed
+ AND feeds.f_id = packages.p_feed
ORDER BY packages.p_version DESC, feeds.f_name ASC, packages.p_arch DESC ");
// display first result