summaryrefslogtreecommitdiffstats
path: root/web
diff options
context:
space:
mode:
authorpjmattal <pjmattal>2004-12-15 01:47:17 +0000
committerpjmattal <pjmattal>2004-12-15 01:47:17 +0000
commit294c14e7bb5a7c880821f145376d1d125662f4dc (patch)
tree8ee507bdc7a8ee35b8f416b236134419e0d7b692 /web
parent19086f4f022cca17db33b608e09853a7e024eda0 (diff)
downloadaurweb-294c14e7bb5a7c880821f145376d1d125662f4dc.tar.xz
renumber none to one, hide none from category/location dropdowns
Diffstat (limited to 'web')
-rw-r--r--web/lib/pkgfuncs.inc13
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;