[phpBT-dev] CVS: phpbt bug.php,1.78,1.79

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv10341

Modified Files:
	bug.php 
Log Message:
Bug votes display works

Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.78
retrieving revision 1.79
diff -u -r1.78 -r1.79
--- bug.php	28 Feb 2002 17:31:45 -0000	1.78
+++ bug.php	28 Feb 2002 17:45:53 -0000	1.79
@@ -25,6 +25,34 @@
 include 'include.php';
 
 ///
+/// View the votes for a bug
+function vote_view($bug_id) {
+	global $u, $q, $t, $STRING;
+	
+	$t->set_file('content', 'bugvotes.html');
+	$t->set_block('content', 'row', 'rows');
+	
+	$q->query('select login, v.created_date from '.TBL_AUTH_USER.' u, '.
+		TBL_BUG_VOTE." v where u.user_id = v.user_id and bug_id = $bug_id".
+		' order by v.created_date');
+	if (!$q->num_rows()) {
+		$t->set_var('rows', "<tr><td colspan=\"2\" align=\"center\">{$STRING['no_votes']}</td></tr>");
+	} else {
+		$i = 0;
+		while (list($login, $date) = $q->grab()) {
+			$t->set_var(array(
+      	'bgcolor' => (++$i % 2 == 0) ? '#dddddd' : '#ffffff',
+				'trclass' => $i % 2 ? '' : 'alt',
+				'login' => $login,
+				'date' => date(DATE_FORMAT.' '.TIME_FORMAT, $date)
+			));
+			$t->parse('rows', 'row', true);
+		}
+	}
+	$t->set_var('bugid', $bug_id);
+}
+
+///
 /// Add a vote to a bug to (possibly) promote it
 function vote_bug($bug_id) {
 	global $u, $q, $now, $_pv, $STRING;
@@ -858,6 +886,7 @@
     case 'do' : do_form($_pv['bugid']); break;
     case 'print' : show_bug_printable($_gv['bugid']); break;
     case 'vote' : vote_bug($_gv['bugid']); break;
+    case 'viewvotes' : vote_view($_gv['bugid']); break;
   }
 } else header("Location: query.php");