diff options
| author | Loui Chang <louipc.ist@gmail.com> | 2009-07-19 23:20:36 -0400 |
|---|---|---|
| committer | Loui Chang <louipc.ist@gmail.com> | 2009-07-19 23:20:36 -0400 |
| commit | 57972532a75f7dd770f96b54edb4f0a4213e2764 (patch) | |
| tree | 5a288aa09609bbf4c607674c8f527552449413c9 | |
| parent | 316f4b990c34f95417f63abb75e9ebf0f13b59ea (diff) | |
| download | aurweb-57972532a75f7dd770f96b54edb4f0a4213e2764.tar.xz | |
Add voter list on packages for TUs and devs.
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
| -rw-r--r-- | web/html/voters.php | 40 | ||||
| -rw-r--r-- | web/template/pkg_details.php | 15 |
2 files changed, 53 insertions, 2 deletions
diff --git a/web/html/voters.php b/web/html/voters.php new file mode 100644 index 0000000..a3b2469 --- /dev/null +++ b/web/html/voters.php @@ -0,0 +1,40 @@ +<?php +set_include_path(get_include_path() . PATH_SEPARATOR . '../lib'); +include('aur.inc'); +include('pkgfuncs.inc'); + +function getvotes($pkgid) { + $dbh = db_connect(); + $pkgid = mysql_real_escape_string($pkgid); + + $result = db_query("SELECT UsersID,Username FROM PackageVotes LEFT JOIN Users on (UsersID = ID) WHERE PackageID = $pkgid ORDER BY Username", $dbh); + return $result; +} + +$SID = $_COOKIE['AURSID']; + +$pkgid = $_GET['ID']; +$votes = getvotes($pkgid); +$account = account_from_sid($SID); + +if ($account == 'Trusted User' || $account == 'Developer') { +?> +<html> +<body> +<h3><?php echo account_from_sid($SID) ?></h3> +<h2>Votes for <a href="packages.php?ID=<?php echo $pkgid ?>"><?php echo pkgname_from_id($pkgid) ?></a></h2> +<?php + while ($row = mysql_fetch_assoc($votes)) { + $uid = $row['UsersID']; + $username = $row['Username']; +?> +<a href="account.php?Action=AccountInfo&ID=<?php echo $uid ?>"> +<?php echo $username ?></a><br /> +<?php + } +?> +</body> +</html> +<?php +} + diff --git a/web/template/pkg_details.php b/web/template/pkg_details.php index f60fe35..28d5b20 100644 --- a/web/template/pkg_details.php +++ b/web/template/pkg_details.php @@ -1,9 +1,11 @@ <?php + +$pkgid = intval($_REQUEST['ID']); if ($row["Location"] == "unsupported" and ($uid == $row["MaintainerUID"] or ($atype == "Developer" or $atype == "Trusted User"))) { $edit_cat = "<a href='pkgedit.php?change_Category=1&ID="; - $edit_cat .= intval($_REQUEST["ID"])."'>".$row["Category"]."</a>"; + $edit_cat .= $pkgid ."'>".$row["Category"]."</a>"; $edit_cat .= " <span class='fix'>("; $edit_cat .= __("change category").")</span>"; } @@ -21,6 +23,11 @@ if ($row["MaintainerUID"]) { $maintainer = "None"; } +$votes = __('Votes') . ': ' . $row['NumVotes']; +if ($atype == "Developer" or $atype == "Trusted User") { + $votes = "<a href=\"voters.php?ID=$pkgid\">$votes</a>"; +} + # In case of wanting to put a custom message $msg = __('unknown'); $license = empty($row['License']) ? $msg : $row['License']; @@ -43,7 +50,11 @@ $submitted_time = ($row["SubmittedTS"] == 0) ? "(unknown)" : gmdate("r", intval( <p> <span class='f3'><?php echo $row['Location'] . ' :: ' . $edit_cat ?></span><br /> <span class='f3'><?php echo __('Maintainer') .': ' . $maintainer ?></span><br /> - <span class='f3'><?php echo __('Votes') . ': ' . $row['NumVotes'] ?></span> + <span class='f3'><?php echo $votes ?></span> +<?php +if ($atype == "Developer" or $atype == "Trusted User") { ?> + <a href="voters.php?ID=<?php echo intval($_REQUEST['ID']) ?>"></a> +<?php } ?> </p> <p><span class='f3'><?php echo __('License') . ': ' . $license ?></span></p> |