diff --git a/user_badges.module b/user_badges.module index a79eeec156d74c75a7e4eb1cfdb5028dd40cdea6..a9c3dcb10bffbce4ea7aad3f51dd5b2c93d6a059 100644 --- a/user_badges.module +++ b/user_badges.module @@ -953,7 +953,7 @@ function user_badges_get_badges($uid, $options = array()) { if ($usr && variable_get('user_badges_showblocked', 0)) { $sql = db_query('SELECT DISTINCT b.bid, u.uid, b.weight, b.name, b.image, b.href, - b.unhideable, b.fixedweight, b.doesnotcounttolimit, u.userweight, b.tid, r.rid + b.unhideable, b.fixedweight, b.doesnotcounttolimit, u.userweight, b.tid, r.rid, CASE WHEN b.fixedweight = 1 THEN b.weight ELSE COALESCE(u.userweight,b.weight) END coalescedweight FROM {user_badges_badges} b INNER JOIN {user_badges_user} u ON b.bid = u.bid