From 294c14e7bb5a7c880821f145376d1d125662f4dc Mon Sep 17 00:00:00 2001 From: pjmattal Date: Wed, 15 Dec 2004 01:47:17 +0000 Subject: renumber none to one, hide none from category/location dropdowns --- web/lib/pkgfuncs.inc | 13 ++++++------- 1 file changed, 6 insertions(+), 7 deletions(-) (limited to 'web/lib') diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc index 6ea3831..4ae7a4e 100644 --- a/web/lib/pkgfuncs.inc +++ b/web/lib/pkgfuncs.inc @@ -56,7 +56,7 @@ function canManagePackage($uid=0,$AURMUID=0, $MUID=0, $SUID=0, $managed=0) { function pkgCategories() { $cats = array(); $dbh = db_connect(); - $q = "SELECT * FROM PackageCategories "; + $q = "SELECT * FROM PackageCategories WHERE ID != 1 "; $q.= "ORDER BY Category ASC"; $result = db_query($q, $dbh); if ($result) { @@ -72,7 +72,7 @@ function pkgCategories() { function pkgLocations() { $locs = array(); $dbh = db_connect(); - $q = "SELECT * FROM PackageLocations "; + $q = "SELECT * FROM PackageLocations WHERE ID != 1 "; $q.= "ORDER BY Location ASC"; $result = db_query($q, $dbh); if ($result) { @@ -130,11 +130,10 @@ function create_dummy($pname="", $sid="") { if (!$result) { # Insert the dummy # - $q = "INSERT INTO Packages (Name, CategoryID, Description, "; - $q.= "URL, LocationID, SubmittedTS, SubmitterUID) VALUES ('"; - $q.= mysql_escape_string($pname)."', 0, "; - $q.= "'A dummy package', '/#', 0, UNIX_TIMESTAMP(), "; - $q.= $uid.")"; + $q = "INSERT INTO Packages (Name, Description, URL, SubmittedTS, "; + $q.= "SubmitterUID) VALUES ('"; + $q.= mysql_escape_string($pname)."', 'A dummy package', '/#', "; + $q.= "UNIX_TIMESTAMP(), ".$uid.")"; $result = db_query($q, $dbh); if (!$result) { return NULL; -- cgit v1.2.3-70-g09d2