query($query);
$error = $db->errorInfo();
if (!is_null($error[2])) {
var_dump($error);
}
if ($result->rowcount() > 0 ) {
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
// these things are per-candidate.
$cdate['path'] = $row['path'];
$cdate['name'] = $row['name'];
$cdate['submission_time'] = $row['submission_time'];
$cdate['enabled'] = $row['enabled'];
$cdate['dupe_of'] = $row['dupe_of'];
$cdate['pub_notes'] = $row['pub_notes'];
$cdate['upvotes'] = $row['upvotes'];
$cdate['downvotes'] = $row['downvotes'];
}
$cpathp=dirname($cdate['path']);
$cpathf=basename($cdate['path']);
$cpath=$cpathp ."/" .urlencode($cpathf);
$cname=$cdate['name'];
$nocand="false";
} else {
$nocand = "true";
}
if ($nocand != "true") {
// TODO: expand this sql with some joins and shenanigans so we have the details of the competition on each, so the ballot listing can be fleshed out with win/loss and maybe even thumbnails
// ...I think this SQL does it...
$ballistq = "select ballotid,path,name,bal_time,voter_id,won_id,lost_id,tied,skip,comment from Candidates INNER JOIN Ballots on Ballots.left_id = Candidates.id or Ballots.right_id=Candidates.id LEFT JOIN Votes ON Votes.ballot_id = Ballots.ballotid where id != $cid and (left_id=$cid OR right_id=$cid) ORDER BY ballotid";
//$ballistq = "select * from Ballots where left_id=$cid or right_id=$cid";
$ballist = $db->prepare($ballistq);
$ballist->execute();
if (!is_null($error[2])) { header('Location: message.php?candballistfail1'); }
$balcount=$ballist->rowcount();
if ($balcount > 0 ) {
$bcount=0;
while ($row = $ballist->fetch(PDO::FETCH_ASSOC) ) {
$ballotid[$bcount]=$row['ballotid'];
$ballottime[$bcount]=$row['bal_time'];
if ($cid == $row['won_id']) { $ballotresult[$bcount]="WON"; }
elseif ($cid == $row['lost_id'] ) { $ballotresult[$bcount]="lost";}
elseif ($row['tied'] == "1" ) { $ballotresult[$bcount]="tied";}
elseif ($row['skip'] == "1" ) { $ballotresult[$bcount]="skipped";}
else {$ballotresult[$bcount]="discarded"; }
$ballotoppname[$bcount]=$row['name'];
$ballotopppath[$bcount]=$row['path'];
$ballotvoter[$bcount]=$row['voter_id'];
$bcount++;
}
}
}
// close DB resources
$result->closeCursor();
$db = null;
// ////
// HTML
// ////
echo "
Don't Panic - Candidate $cid
";
if ($cdate['pub_notes']) {
echo "$cdate[pub_notes] ";
}
echo "Candidate has been on the system since $cdate[submission_time]
Enabled: $cdate[enabled]
Ballots won: $cdate[upvotes]
Ballots lost: $cdate[downvotes] ";
} else {
echo "
No candidate found
oh dear, I think you'll find reality is on the blink again
\n";
if ($balcount > 0 ) {
for ($b=0 ; $b<$bcount ; $b++) {
if ( $b%10==0) {
echo "
\n";
}
// each span is a ballot.
// TODO:
// bold if the ballot was for the current user
echo " " . gmdate('D, d M Y', strtotime($ballottime[$b])) ." Ballot #$ballotid[$b] $ballotresult[$b] \n";
if ( ( ($b+1)%10==0) && (($b+1)<$bcount) ) {
echo "
\n";
}
}
echo "
\n";
} else {
echo "This candidate has no ballots yet... why not go vote repeatedly till this is fixed? \n";
}
include('footer.inc');
//include('lib/debug.inc'); // debug
// TODO following data should be admin-only
if ($debug) {
// though candidate ID is public - it's in the URL!
echo "\n
![$ballotoppname[$b]]($ballotopppath[$b] "\\"$ballotoppname[$b]\\"")
$ballotresult[$b]