From 8449ddc1397a699e8473ee657b18e1ed6928f4bb Mon Sep 17 00:00:00 2001 From: "bbaetz%acm.org" <> Date: Sun, 27 Apr 2003 14:20:36 +0000 Subject: Bug 180086 - Rename 'count' column in votes tables patch by bugzilla@chimpychompy.org (GavinS) r=bbaetz,justdave a=justdave --- globals.pl | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'globals.pl') diff --git a/globals.pl b/globals.pl index 4caaa3f84..88c8720e8 100644 --- a/globals.pl +++ b/globals.pl @@ -1355,7 +1355,7 @@ sub RemoveVotes { if ($who) { $whopart = " AND votes.who = $who"; } - SendSQL("SELECT profiles.login_name, profiles.userid, votes.count, " . + SendSQL("SELECT profiles.login_name, profiles.userid, votes.vote_count, " . "products.votesperuser, products.maxvotesperbug " . "FROM profiles " . "LEFT JOIN votes ON profiles.userid = votes.who " . @@ -1393,7 +1393,7 @@ sub RemoveVotes { my $newvotestext; if ($newvotes) { - SendSQL("UPDATE votes SET count = $newvotes " . + SendSQL("UPDATE votes SET vote_count = $newvotes " . "WHERE bug_id = $id AND who = $userid"); $s = $newvotes == 1 ? "" : "s"; $newvotestext = "You still have $newvotes vote$s on this bug." @@ -1436,7 +1436,7 @@ sub RemoveVotes { close SENDMAIL; } } - SendSQL("SELECT SUM(count) FROM votes WHERE bug_id = $id"); + SendSQL("SELECT SUM(vote_count) FROM votes WHERE bug_id = $id"); my $v = FetchOneColumn(); $v ||= 0; SendSQL("UPDATE bugs SET votes = $v, delta_ts = delta_ts " . -- cgit v1.2.3-24-g4f1b