From 61ddf0a32846fdf2607043d94af1a0a86b80f6fc Mon Sep 17 00:00:00 2001
From: "bbaetz%student.usyd.edu.au" <>
Date: Mon, 12 Aug 2002 12:42:42 +0000
Subject: Bug 43600 - Convert products/components to use ids instead of names.
 Initial attempt by jake@bugzilla.org, updated by me r=joel, preed

---
 votes.cgi | 11 ++++++-----
 1 file changed, 6 insertions(+), 5 deletions(-)

(limited to 'votes.cgi')

diff --git a/votes.cgi b/votes.cgi
index 7a387e0e1..513add4c3 100755
--- a/votes.cgi
+++ b/votes.cgi
@@ -153,7 +153,7 @@ sub show_user {
     # we can do it all in one query.
     my %maxvotesperbug;
     if($canedit) {
-        SendSQL("SELECT products.product, products.maxvotesperbug 
+        SendSQL("SELECT products.name, products.maxvotesperbug 
                  FROM products");
         while (MoreSQLData()) {
             my ($prod, $max) = FetchSQLData();
@@ -173,10 +173,11 @@ sub show_user {
         
         SendSQL("SELECT votes.bug_id, votes.count, bugs.short_desc,
                         bugs.bug_status 
-                  FROM  votes, bugs 
+                  FROM  votes, bugs, products
                   WHERE votes.who = $who 
                     AND votes.bug_id = bugs.bug_id 
-                    AND bugs.product = " . SqlQuote($product) . 
+                    AND bugs.product_id = products.id 
+                    AND products.name = " . SqlQuote($product) . 
                  "ORDER BY votes.bug_id");        
         
         while (MoreSQLData()) {
@@ -270,9 +271,9 @@ sub record_votes {
     # If the user is voting for bugs, make sure they aren't overstuffing
     # the ballot box.
     if (scalar(@buglist)) {
-        SendSQL("SELECT bugs.bug_id, bugs.product, products.maxvotesperbug
+        SendSQL("SELECT bugs.bug_id, products.name, products.maxvotesperbug
                  FROM bugs, products
-                 WHERE products.product = bugs.product
+                 WHERE products.id = bugs.product_id
                    AND bugs.bug_id IN (" . join(", ", @buglist) . ")");
 
         my %prodcount;
-- 
cgit v1.2.3-24-g4f1b