summaryrefslogtreecommitdiffstats
path: root/web/html/voters.php
blob: cf119a65f1a4ec9bc60c60837e955053f134d0ef (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
<?php
set_include_path(get_include_path() . PATH_SEPARATOR . '../lib');
include('aur.inc.php');
include('pkgfuncs.inc.php');

function getvotes($pkgid) {
	$dbh = db_connect();
	$pkgid = db_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 = intval($_GET['ID']);
$votes = getvotes($pkgid);
$atype = account_from_sid($SID);

html_header(__("Voters"));

if ($atype == 'Trusted User' || $atype== 'Developer'):
?>

<div class="box">
	<h2>Votes for <a href="packages.php?ID=<?php echo $pkgid ?>"><?php echo pkgname_from_id($pkgid) ?></a></h2>
	<div class="boxbody">

<?php
	while ($row = mysql_fetch_assoc($votes)):
		$uid = $row['UsersID'];
		$username = $row['Username'];
?>
		<a href="account.php?Action=AccountInfo&amp;ID=<?php echo $uid ?>"><?php echo htmlspecialchars($username) ?></a><br />
	<?php endwhile; ?>
	</div>
</div>

<?php
endif;

html_footer(AUR_VERSION);