\n");
sqlite_query ($db,
"CREATE TABLE packages (
p_name varchar(50),
p_version varchar(10),
p_arch varchar(12),
p_depends varchar(50),
p_maintainer varchar(50),
p_homepage varchar(100),
p_section varchar(20),
p_replaces varchar(50),
p_provides varchar(50),
p_conflicts varchar(50),
p_size int(10),
p_md5 char(32),
p_source varchar(500),
p_feed varchar(20),
p_file varchar(100),
p_desc varchar(1000)
)");
}
if (db_table_exists ($db, 'feeds') == "FALSE")
{
print("creating feeds table
\n");
sqlite_query ($db,
"CREATE TABLE feeds (
f_name varchar(20),
f_uri varchar(100),
f_comments varchar(500)
)");
test_insert_ipkgs ($db) ;
}
//close the db
sqlite_close($db);
$action = '';
if(isset($_GET['action']))
{
$action = $_GET['action'];
}
switch($action)
{
case "details":
$ipkgoutput = pkgdetails ($_GET['pnm']);
break;
case "package":
$edit = $_POST['edit'];
$searchword = $edit['searchword'];
$ipkgoutput = searchpkg ("%$searchword%");
break;
case "section":
$ipkgoutput = searchsection($_GET['section']);
break;
case "letter":
$letter = $_GET['g'];
$ipkgoutput = searchletter ($letter);
break;
default:
$ipkgoutput = searchletter ("a");
break;
}
print $ipkgoutput;
print("