summaryrefslogtreecommitdiffstats
path: root/web/html/addvote.php
diff options
context:
space:
mode:
authorCallan Barrett <wizzomafizzo@gmail.com>2007-12-26 20:38:39 +0100
committerDan McGee <dan@archlinux.org>2008-01-20 07:21:19 +0100
commita8e574ef2897e9ca709c2cfa5ff78d2f69464092 (patch)
tree48bfc85a2ab6416af3e19183bb782ad7d20c94dd /web/html/addvote.php
parent32b863203fcda13f322aa0802bc64eec64dcaa51 (diff)
downloadaur-a8e574ef2897e9ca709c2cfa5ff78d2f69464092.tar.gz
aur-a8e574ef2897e9ca709c2cfa5ff78d2f69464092.tar.xz
AUR Voting Application
Added support for TU voting through AUR Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com>
Diffstat (limited to 'web/html/addvote.php')
-rw-r--r--web/html/addvote.php79
1 files changed, 79 insertions, 0 deletions
diff --git a/web/html/addvote.php b/web/html/addvote.php
new file mode 100644
index 00000000..91a06583
--- /dev/null
+++ b/web/html/addvote.php
@@ -0,0 +1,79 @@
+<?php
+
+set_include_path(get_include_path() . PATH_SEPARATOR . '../lib' . PATH_SEPARATOR . '../lang');
+
+include("pkgfuncs_po.inc");
+include("aur.inc");
+set_lang();
+check_sid();
+html_header();
+
+if (isset($_COOKIE["AURSID"])) {
+ $atype = account_from_sid($_COOKIE["AURSID"]);
+} else {
+ $atype = "";
+}
+
+if ($atype == "Trusted User" OR $atype == "Developer") {
+ $dbh = db_connect();
+
+ if (!empty($_POST['addVote'])) {
+ $aweek = 60*60*24*7;
+ $error = "";
+
+ if (!empty($_REQUEST['user'])) {
+ $qcheck = "SELECT * FROM Users WHERE Username = '" . mysql_real_escape_string($_REQUEST['user']) . "'";
+ $check = mysql_num_rows(db_query($qcheck, $dbh));
+
+ if ($check == 0) {
+ $error.= "<div style='color: red; font-weight: bold'>Username does not exist.</div>";
+ } else {
+ $qcheck = "SELECT * FROM TU_VoteInfo WHERE User = '" . mysql_real_escape_string($_REQUEST['user']) . "'";
+ $qcheck.= " AND Submitted + " . $aweek . " > UNIX_TIMESTAMP()";
+ $check = mysql_num_rows(db_query($qcheck, $dbh));
+
+ if ($check != 0) {
+ $error.= "<div style='color: red; font-weight: bold'>" . mysql_real_escape_string($_REQUEST['user']) . " already has proposal running for them.</div>";
+ }
+ }
+ }
+
+ if (empty($_REQUEST['agenda'])) {
+ $error.= "<div style='color: red; font-weight: bold'>Proposal cannot be empty.</div>";
+ }
+ }
+
+ if (!empty($_POST['addVote']) && empty($error)) {
+ $q = "INSERT INTO TU_VoteInfo (Agenda, User, Submitted, SubmitterID) VALUES ";
+ $q.= "('" . mysql_real_escape_string($_REQUEST['agenda']) . "', ";
+ $q.= "'" . mysql_real_escape_string($_REQUEST['user']) . "', ";
+ $q.= "UNIX_TIMESTAMP(), " . uid_from_sid($_COOKIE["AURSID"]) . ")";
+
+ db_query($q, $dbh);
+ print "<p>New proposal submitted.</p>\n";
+ } else {
+?>
+<p>Submit a proposal to vote on.</p>
+<?php if (!empty($error)) { print $error . "<br />"; } ?>
+<form action='addvote.php' method='post'>
+<b>Applicant/TU:</b>
+<input type='text' name='user' value='<?php if (!empty($_POST['user'])) { print htmlentities($_POST['user'], ENT_QUOTES); } ?>'>
+(empty if not applicable)
+<br />
+<b>Proposal:</b><br />
+<textarea name='agenda' rows='10' cols='50'><?php if (!empty($_POST['agenda'])) { print htmlentities($_POST['agenda']); } ?></textarea><br />
+<input type='hidden' name='addVote' value='1'>
+<input type='submit' class='button' value='Submit'>
+</form>
+<br />
+<?php
+ }
+ print "<a href='tu.php'>Back</a>";
+} else {
+ print "You are not allowed to access this area.\n";
+}
+
+html_footer(AUR_VERSION);
+# vim: ts=2 sw=2 noet ft=php
+
+?>