Nomice Proposals

Open proposals:

\n"; $proposal_list = mysql_query("SELECT * FROM proposals WHERE status='open'"); echo "\n"; echo "
ProposalCreatedFor/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 "
\n"; echo "

Passed proposals:

\n"; $proposal_list = mysql_query("SELECT * FROM proposals WHERE status='passed' ORDER BY closed DESC"); echo "\n"; echo "
ProposalClosedStatus\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 "
\n"; echo "

Other proposals:

\n"; $proposal_list = mysql_query("SELECT * FROM proposals WHERE status!='open' AND status!='passed' ORDER BY closed DESC"); echo "\n"; echo "
ProposalClosedStatus\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 "
\n"; if ($auth_username) { echo "

Make a new proposal

"; } ?>

Return to Nomice Main