From ce225727f67f5b65b5f92ec96b074712c290ea63 Mon Sep 17 00:00:00 2001 From: Callan Barrett Date: Thu, 10 Jan 2008 11:15:55 +0900 Subject: Bug in uploading PKGBUILDs and aur schema This fixes a bug where TUs and devs couldn't upload packages because the query would have an extra column in it to mark the pkgbuild safe automatically, guessing it got missed when the safe flags were removed. Also fixes a screw up I made with the schema file when I added the tables for the voting app. Signed-off-by: Callan Barrett --- support/schema/aur-schema.sql | 4 ++-- web/html/pkgsubmit.php | 3 --- 2 files changed, 2 insertions(+), 5 deletions(-) diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index c5790a8f..371f140a 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -223,12 +223,12 @@ CREATE TABLE IF NOT EXISTS TU_VoteInfo ( No tinyint(3) unsigned NOT NULL default '0', Abstain tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (ID) -) +); -- Individual vote records -- CREATE TABLE IF NOT EXISTS TU_Votes ( VoteID int(10) unsigned NOT NULL, UserID int(10) unsigned NOT NULL -) +); diff --git a/web/html/pkgsubmit.php b/web/html/pkgsubmit.php index 9bed3f59..46b78cf4 100644 --- a/web/html/pkgsubmit.php +++ b/web/html/pkgsubmit.php @@ -486,9 +486,6 @@ if ($_COOKIE["AURSID"]) { $q.= mysql_real_escape_string($new_pkgbuild['pkgdesc'])."', '"; $q.= mysql_real_escape_string($new_pkgbuild['url']); $q.= "', 2, "; - if (account_from_sid($_COOKIE["AURSID"]) == "Trusted User" || account_from_sid($_COOKIE["AURSID"]) == "Developer") { - $q.= "1, ".uid_from_sid($_COOKIE["AURSID"]).", "; - } $q.= "UNIX_TIMESTAMP(), "; $q.= uid_from_sid($_COOKIE["AURSID"]).", "; $q.= uid_from_sid($_COOKIE["AURSID"]).", '"; -- cgit v1.2.3-24-g4f1b