From 294c14e7bb5a7c880821f145376d1d125662f4dc Mon Sep 17 00:00:00 2001
From: pjmattal <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