diff options
| author | pjmattal <pjmattal> | 2004-12-15 01:47:17 +0000 |
|---|---|---|
| committer | pjmattal <pjmattal> | 2004-12-15 01:47:17 +0000 |
| commit | 294c14e7bb5a7c880821f145376d1d125662f4dc (patch) | |
| tree | 8ee507bdc7a8ee35b8f416b236134419e0d7b692 /web/lib | |
| parent | 19086f4f022cca17db33b608e09853a7e024eda0 (diff) | |
| download | aurweb-294c14e7bb5a7c880821f145376d1d125662f4dc.tar.xz | |
renumber none to one, hide none from category/location dropdowns
Diffstat (limited to 'web/lib')
| -rw-r--r-- | web/lib/pkgfuncs.inc | 13 |
1 files changed, 6 insertions, 7 deletions
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; |