| Proposal | Created | For/Against"; if ($auth_username) { echo " | Your Vote"; } echo "\n"; while ($prop = mysql_fetch_array($proposal_list)) { $prop_id = $prop['proposal_id']; $votes_for = mysql_query("SELECT * FROM votes WHERE proposal_id='$prop_id' AND vote='for'"); $votes_against = mysql_query("SELECT * FROM votes WHERE proposal_id='$prop_id' AND vote='against'"); $vote_count_for = mysql_num_rows($votes_for); $vote_count_against = mysql_num_rows($votes_against); printf(" | |
|---|---|---|---|---|
| %s: %s", $prop_id, $prop['identifier'], $prop['title']); printf(" | %s | %d/%d", $prop['created'], $vote_count_for, $vote_count_against); if ($auth_username) { $userinfo = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE username='$auth_username'")); $user_id = $userinfo['user_id']; $your_vote = mysql_fetch_array(mysql_query("SELECT * FROM votes WHERE proposal_id='$prop_id' AND user_id='$user_id'")); if ($your_vote) { printf(" | %s\n", ucfirst($your_vote['vote'])); } else { echo " | None\n"; } } } echo " |
Passed proposals:
\n"; $proposal_list = mysql_query("SELECT * FROM proposals WHERE status='passed' ORDER BY closed DESC"); echo "| Proposal | Closed | Status\n"; while ($prop = mysql_fetch_array($proposal_list)) { $prop_id = $prop['proposal_id']; printf(" |
|---|---|---|
| %s: %s", $prop_id, $prop['identifier'], $prop['title']); printf(" | %s | %s\n", $prop['closed'], $prop['status']); } echo " |
Other proposals:
\n"; $proposal_list = mysql_query("SELECT * FROM proposals WHERE status!='open' AND status!='passed' ORDER BY closed DESC"); echo "| Proposal | Closed | Status\n"; while ($prop = mysql_fetch_array($proposal_list)) { $prop_id = $prop['proposal_id']; printf(" |
|---|---|---|
| %s: %s", $prop_id, $prop['identifier'], $prop['title']); printf(" | %s | %s\n", $prop['closed'], $prop['status']); } echo " |