https://panoptic.com/mediawiki/aolserver/index.php?action=history&feed=atom&title=Jk-voting-vote_subjects 2026-04-25T20:22:24Z Revision history for this page on the wiki MediaWiki 1.34.2 https://panoptic.com/mediawiki/aolserver/index.php?title=Jk-voting-vote_subjects&diff=2520&oldid=prev 2002-01-15T19:41:19Z

<p>imported from WiKit id 78</p> <p><b>New page</b></p><div>proc vote_subjects {conn context} { <br /> set output &quot;&quot;<br /> foreach {db db2} [[ns_db gethandle postgres 2]] {}<br /> set userrow [[user $db $conn]]<br /> #force_voting_exist $db<br /> <br /> set rows [[ns_db select $db &quot;select * from voting_topics;&quot;]]<br /> set subject_lines &quot;&quot;<br /> set bgcolor 0<br /> while {[[ns_db getrow $db $rows]] == 1} {<br /> set inner_row [[ns_db 0or1row $db2 \<br /> &quot;select sum(votes) from voting_detail where \<br /> topic_identifier = [db_quote [ns_set get $rows topic_identifier]]];&quot;]<br /> set content_set [[ns_set create content_set]]<br /> ns_set put $content_set bgcolor [[color_sequence $bgcolor]]<br /> incr bgcolor<br /> ns_set put $content_set total_votes [[ns_set get $inner_row sum]]<br /> ns_set put $content_set subject [[ns_set get $rows subject]]<br /> ns_set put $content_set author [[ns_set get $rows author]]<br /> ns_set put $content_set topic_identifier \<br /> [[ns_set get $rows topic_identifier]]<br /> if {$userrow != &quot;&quot;} {<br /> #logged in users can vote<br /> ns_set put $content_set vote_option \<br /> &quot;&lt;input type=button value=\&quot;Vote\&quot; \<br /> onClick=\&quot;parent.main.location='/voting/place_vote?id=[[ns_set get $rows topic_identifier]]'\&quot;&gt;&quot;<br /> <br /> #users can delete entries that they authored<br /> if {[[ns_set get $rows author]] == [[ns_set get $userrow name]]} {<br /> ns_set put $content_set delete_option \<br /> &quot;&lt;td&gt;&lt;input type=button value=\&quot;Delete\&quot; \<br /> onClick=\&quot;parent.main.location='/voting/delete_subject?id=[[ns_set get $rows topic_identifier]]'\&quot;&gt;&lt;/td&gt;&quot;<br /> } else {<br /> ns_set put $content_set delete_option &quot;&quot;<br /> }<br /> } else {<br /> ns_set put $content_set vote_option &quot;&quot;<br /> ns_set put $content_set delete_option &quot;&quot;<br /> }<br /> append subject_lines [[template &quot;voting_subject.html&quot; $content_set]]<br /> unset content_set<br /> }<br /> if {[[string length $subject_lines]] &lt;= 0} {<br /> set subject_lines &quot;&lt;tr&gt;&lt;td&gt;&lt;b&gt;There are no Voting Booths Open!&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;&quot;<br /> }<br /> <br /> set content_set [[ns_set create content_set]]<br /> ns_set put $content_set subject_lines $subject_lines<br /> ns_return 200 text/html \<br /> [[template &quot;voting_subject_page.html&quot; $content_set]]<br /> }</div>

WikiSysop