From 252afad9fc0c46089b327a1315580a342cbc87c0 Mon Sep 17 00:00:00 2001 From: pjmattal Date: Wed, 15 Dec 2004 01:33:12 +0000 Subject: tweaks to package functions and schema --- support/schema/aur-schema.sql | 10 +++++++-- web/html/pkgsubmit.php | 4 ++-- web/lib/aur.inc | 13 ------------ web/lib/pkgfuncs.inc | 47 +++++++++++++++++++++++++++++++++++++++++++ 4 files changed, 57 insertions(+), 17 deletions(-) diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 318d727..ef3a9e3 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -67,6 +67,7 @@ CREATE TABLE PackageCategories ( Category CHAR(32) NOT NULL, PRIMARY KEY (ID) ); +INSERT INTO PackageCategories (ID, Category) VALUES (0, 'none'); INSERT INTO PackageCategories (Category) VALUES ('daemons'); INSERT INTO PackageCategories (Category) VALUES ('devel'); INSERT INTO PackageCategories (Category) VALUES ('editors'); @@ -93,6 +94,7 @@ CREATE TABLE PackageLocations ( Location CHAR(32) NOT NULL, PRIMARY KEY (ID) ); +INSERT INTO PackageLocations (ID, Location) VALUES (0, 'none'); INSERT INTO PackageLocations (ID, Location) VALUES (1, 'Unsupported'); INSERT INTO PackageLocations (ID, Location) VALUES (2, 'AUR'); INSERT INTO PackageLocations (ID, Location) VALUES (3, 'Current'); @@ -109,6 +111,9 @@ CREATE TABLE Packages ( CategoryID TINYINT UNSIGNED NOT NULL, Description CHAR(128) NOT NULL DEFAULT "An Arch Package", URL CHAR(255) NOT NULL DEFAULT "http://www.archlinux.org", + DummyPkg TINYINT UNSIGNED NOT NULL DEFAULT 0, -- 1=>dummy + FSPath CHAR(255) NOT NULL DEFAULT '', + URLPath CHAR(255) NOT NULL DEFAULT '', LocationID TINYINT UNSIGNED NOT NULL, NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0, OutOfDate TINYINT UNSIGNED DEFAULT 0, @@ -122,6 +127,7 @@ CREATE TABLE Packages ( UNIQUE (Name), INDEX (CategoryID), INDEX (LocationID), + INDEX (DummyPkg), INDEX (OutOfDate), INDEX (NumVotes), INDEX (SubmitterUID), @@ -169,8 +175,8 @@ CREATE TABLE PackageVotes ( -- CREATE TABLE PackageContents ( PackageID INTEGER UNSIGNED NOT NULL, - FSPath CHAR(256) NOT NULL, - URLPath CHAR(255) NOT NULL, + FSPath CHAR(255) NOT NULL DEFAULT '', + URLPath CHAR(255) NOT NULL DEFAULT '', FileSize BIGINT UNSIGNED NOT NULL default 0, INDEX (PackageID), FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE diff --git a/web/html/pkgsubmit.php b/web/html/pkgsubmit.php index 8373513..1bbcbe3 100644 --- a/web/html/pkgsubmit.php +++ b/web/html/pkgsubmit.php @@ -12,8 +12,8 @@ $DBUG = 1; # this is the directory that new packages will be uploaded to # -$UPLOAD_DIR = "/tmp/aur/temp/"; -$INCOMING_DIR = "/tmp/aur/incoming/"; +$UPLOAD_DIR = "/aur/temp/"; +$INCOMING_DIR = "/aur/incoming/"; if ($_COOKIE["AURSID"]) { diff --git a/web/lib/aur.inc b/web/lib/aur.inc index e696d5b..267b650 100644 --- a/web/lib/aur.inc +++ b/web/lib/aur.inc @@ -444,19 +444,6 @@ function dbug($msg) { return; } -# check to see if the package name exists -# -function package_exists($name="") { - if (!$name) {return 0;} - $dbh = db_connect(); - $q = "SELECT COUNT(*) FROM Packages "; - $q.= "WHERE Name = '".mysql_escape_string($name)."'"; - $result = db_query($q, $dbh); - if (!$result) {return 0;} - $row = mysql_fetch_row($result); - return $row[0]; -} - # check to see if the user can overwrite an existing package # function can_overwrite_pkg($name="", $sid="") { diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc index bfdaa58..6ea3831 100644 --- a/web/lib/pkgfuncs.inc +++ b/web/lib/pkgfuncs.inc @@ -83,6 +83,20 @@ function pkgLocations() { return $locs; } +# check to see if the package name exists +# +function package_exists($name="") { + if (!$name) {return NULL;} + $dbh = db_connect(); + $q = "SELECT ID FROM Packages "; + $q.= "WHERE Name = '".mysql_escape_string($name)."' "; + $q.= "AND DummyPkg = 0"; + $result = db_query($q, $dbh); + if (!$result) {return NULL;} + $row = mysql_fetch_row($result); + return $row[0]; +} + # grab package dependencies # function package_dependencies($pkgid=0) { @@ -102,6 +116,39 @@ function package_dependencies($pkgid=0) { return $deps; } +# create a dummy package and return it's Packages.ID if it already exists, +# return the existing ID +# +function create_dummy($pname="", $sid="") { + if ($pname && $sid) { + $uid = uid_from_sid($sid); + if (!$uid) {return NULL}; + $dbh = db_connect(); + $q = "SELECT ID FROM Packages WHERE Name = '"; + $q.= mysql_escape_string($pname)."'"; + $result = db_query($q, $dbh); + 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.")"; + $result = db_query($q, $dbh); + if (!$result) { + return NULL; + } + return mysql_insert_id($result); + } else { + $data = mysql_fetch_row($result); + return $data['ID']; + } + } + return NULL; + +} + # grab package sources # function package_sources($pkgid=0) { -- cgit v1.2.3-70-g09d2