diff options
| author | Callan Barrett <wizzomafizzo@gmail.com> | 2008-01-10 11:15:55 +0900 |
|---|---|---|
| committer | Dan McGee <dan@archlinux.org> | 2008-01-20 00:21:19 -0600 |
| commit | ce225727f67f5b65b5f92ec96b074712c290ea63 (patch) | |
| tree | 7bc1191180a5bc4ec2f52adb1b0fa5d074d14910 | |
| parent | 8c94552042115d2a7bb04de3b4f66cdf95f2a5de (diff) | |
| download | aurweb-ce225727f67f5b65b5f92ec96b074712c290ea63.tar.xz | |
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 <wizzomafizzo@gmail.com>
| -rw-r--r-- | support/schema/aur-schema.sql | 4 | ||||
| -rw-r--r-- | 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 c5790a8..371f140 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 9bed3f5..46b78cf 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"]).", '"; |