From aae43d9ad6fc83d04a4975f27392c1422dfa0ec4 Mon Sep 17 00:00:00 2001
From: eric <eric>
Date: Sat, 5 Mar 2005 20:39:36 +0000
Subject: started working on package comments

---
 web/html/packages.php  | 13 ++++++++++---
 web/html/pkgsubmit.php |  8 ++++----
 2 files changed, 14 insertions(+), 7 deletions(-)

(limited to 'web')

diff --git a/web/html/packages.php b/web/html/packages.php
index b2dabef..823a4ca 100644
--- a/web/html/packages.php
+++ b/web/html/packages.php
@@ -209,7 +209,7 @@ if (isset($_REQUEST["do_Flag"])) {
 					}
 				}
 				if (!empty($ids_to_delete)) {
-					# TODO These are the packages that are safe to delete
+					# These are the packages that are safe to delete
 					#
 				  foreach ($ids_to_delete as $id) {
 						# 1) delete from PackageVotes
@@ -228,8 +228,8 @@ if (isset($_REQUEST["do_Flag"])) {
 						$q = "DELETE FROM PackageSources WHERE PackageID = " . $id;
 						$result = db_query($q, $dbh);
 
-						# 5) delete from PackageUploadHistory
-						$q = "DELETE FROM PackageUploadHistory WHERE PackageID = " . $id;
+						# 5) delete from PackageComments
+						$q = "DELETE FROM PackageComments WHERE PackageID = " . $id;
 						$result = db_query($q, $dbh);
 
 						# 6) delete from Packages
@@ -239,6 +239,7 @@ if (isset($_REQUEST["do_Flag"])) {
 						# TODO question: Now that the package as been deleted, does
 						#                the unsupported repo need to be regenerated?
 					  # ANSWER: No, there is no actual repo for unsupported, so no worries! (PJM)
+						# TODO question: What about regenerating the AUR repo? (EJ)
 
 						# Print the success message
 						print "<p>\n";
@@ -355,6 +356,12 @@ if (isset($_REQUEST["do_Flag"])) {
 			$q.= $vote_clauses;
 			db_query($q, $dbh);
 
+			# Update the LastVoted field for this user
+			#
+			$q = "UPDATE Users SET LastVoted = UNIX_TIMESTAMP() ";
+			$q.= "WHERE ID = ".$uid;
+			db_query($q, $dbh);
+
 			print "<p>\n";
 			print __("Your votes have been cast for the selected packages.");
 			print "</p>\n";
diff --git a/web/html/pkgsubmit.php b/web/html/pkgsubmit.php
index ccf1df7..d679704 100644
--- a/web/html/pkgsubmit.php
+++ b/web/html/pkgsubmit.php
@@ -371,8 +371,8 @@ if ($_COOKIE["AURSID"]) {
 
 				# add upload history
 				#
-				$q = "INSERT INTO PackageUploadHistory ";
-				$q.= "(PackageID, UsersID, Comments, UploadTS) VALUES (";
+				$q = "INSERT INTO PackageComments ";
+				$q.= "(PackageID, UsersID, Comments, CommentTS) VALUES (";
 				$q.= $pdata["ID"] . ", " . uid_from_sid($_COOKIE['AURSID']);
 				$q.= ", '" . mysql_escape_string($_REQUEST["comments"]);
 				$q.= "', UNIX_TIMESTAMP())";
@@ -434,8 +434,8 @@ if ($_COOKIE["AURSID"]) {
 
 				# add upload history
 				#
-				$q = "INSERT INTO PackageUploadHistory ";
-				$q.= "(PackageID, UsersID, Comments, UploadTS) VALUES (";
+				$q = "INSERT INTO PackageComments ";
+				$q.= "(PackageID, UsersID, Comments, CommentTS) VALUES (";
 				$q.= $packageID . ", " . uid_from_sid($_COOKIE["AURSID"]) . ", '";
 				$q.= mysql_escape_string($_REQUEST["comments"]);
 				$q.= "', UNIX_TIMESTAMP())";
-- 
cgit v1.2.3-70-g09d2