summaryrefslogtreecommitdiffstats
path: root/web/html/pkgsubmit.php
diff options
context:
space:
mode:
authoreric <eric>2004-07-14 00:20:32 +0000
committereric <eric>2004-07-14 00:20:32 +0000
commit1e1eb451def58b0802ce156d91b8afa13d321eb6 (patch)
treee96d74f1a296d7cdbc9772e148405de7ee813ac3 /web/html/pkgsubmit.php
parent56effc6ae4737f955c972177bf3cc0d7a5e320be (diff)
downloadaurweb-1e1eb451def58b0802ce156d91b8afa13d321eb6.tar.xz
still working on pkgsubmit
Diffstat (limited to 'web/html/pkgsubmit.php')
-rw-r--r--web/html/pkgsubmit.php53
1 files changed, 44 insertions, 9 deletions
diff --git a/web/html/pkgsubmit.php b/web/html/pkgsubmit.php
index fa8f3c7..21b0f94 100644
--- a/web/html/pkgsubmit.php
+++ b/web/html/pkgsubmit.php
@@ -21,11 +21,11 @@ if ($_COOKIE["AURSID"]) {
# first, see if this package already exists, and if it can be overwritten
#
- if (package_exists($_FILES["pfile"]["name"])) { # TODO write function
+ $pkg_exists = package_exists($_FILES["pfile"]["name"]);
+ if ($pkg_exists) {
# ok, it exists - should it be overwritten, and does the user have
# the permissions to do so?
#
- # TODO write 'can_overwrite_pkg' function
if (can_overwrite_pkg($_FILES["pfile"]["name"], $_COOKIE["AURSID"])) {
if (!$_REQUEST["overwrite"]) {
$error = __("You did not tag the 'overwrite' checkbox.");
@@ -36,7 +36,7 @@ if ($_COOKIE["AURSID"]) {
}
}
- if (!$error)) {
+ if (!$error) {
# no errors checking upload permissions, go ahead and try to process
# the uploaded package file.
#
@@ -58,10 +58,48 @@ if ($_COOKIE["AURSID"]) {
}
}
+ # at this point, we can safely create the directories, and update
+ # the database with the new package
+ #
+ # TODO extract the package contents and parse the included files
+ #
+
+
+ # update the backend database
+ #
+ $dbh = db_connect();
+ if ($pkg_exists) {
+
+ # this is an overwrite of an existing package, the database ID
+ # needs to be preserved so that any votes are retained. However,
+ # PackageDepends, PackageSources, and PackageContents can be
+ # purged.
+ #
+ $q = "SELECT * FROM Packages ";
+ $q.= "WHERE Name = '".mysql_escape_string($_FILES["pfile"]["name"])."'";
+ $result = db_query($q, $dbh);
+ $pdata = mysql_fetch_assoc($result);
+
+ # flush out old data that will be replaced with new data
+ #
+ $q = "DELETE FROM PackageContents WHERE PackageID = ".$pdata["ID"];
+ db_query($q, $dbh);
+ $q = "DELETE FROM PackageDepends WHERE PackageID = ".$pdata["ID"];
+ db_query($q, $dbh);
+ $q = "DELETE FROM PackageSources WHERE PackageID = ".$pdata["ID"];
+ db_query($q, $dbh);
+
+
+ } else {
+ # this is a brand new package
+ #
+ }
+
+
}
- if (!$_REQUEST["pkgsubmit"] || !$error)) {
+ if (!$_REQUEST["pkgsubmit"] || $error) {
# give the visitor the default upload form
#
if (ini_get("file_uploads")) {
@@ -93,15 +131,12 @@ if ($_COOKIE["AURSID"]) {
print __("No");
print " </td>\n";
print "</tr>\n";
- print "<tr>\n";
- print " <td align='center' colspan='2'>&nbsp;</td>\n";
- print "</tr>\n";
print "<tr>\n";
- print " <td align='right'>";
+ print " <td>&nbsp;</td>\n";
+ print " <td align='left'>";
print "<input class='button' type='submit' value='".__("Upload")."' />\n";
print "</td>\n";
- print " <td>&nbsp;</td>\n";
print "</tr>\n";
print "</table>\n";