diff options
| author | bbaetz%acm.org <> | 2003-04-27 16:20:36 +0200 |
|---|---|---|
| committer | bbaetz%acm.org <> | 2003-04-27 16:20:36 +0200 |
| commit | 8449ddc1397a699e8473ee657b18e1ed6928f4bb (patch) | |
| tree | 5a37c734d6bc56f529d0dd81537de76a0c0fd87e /globals.pl | |
| parent | f016a7980404372d9855215a5107968beb3c82f4 (diff) | |
| download | bugzilla-8449ddc1397a699e8473ee657b18e1ed6928f4bb.tar.gz bugzilla-8449ddc1397a699e8473ee657b18e1ed6928f4bb.tar.xz | |
Bug 180086 - Rename 'count' column in votes tables
patch by bugzilla@chimpychompy.org (GavinS)
r=bbaetz,justdave
a=justdave
Diffstat (limited to 'globals.pl')
| -rw-r--r-- | globals.pl | 6 |
1 files changed, 3 insertions, 3 deletions
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 " . |