Changeset 314

Timestamp:

09/11/07 15:23:34 (6 years ago)

Author:

chckens

Message:

fix some wrong banana totals and links from this years leaderboard

Files:

• components/members.php (modified) (2 diffs)

components/members.php

@@ -95 +95 @@
                                 
                                 $usernames[0]['awards'] = $awards; 
-                                $bananasum = $DB->GetAll("select sum(score) as sum from awards where username ~* ?", array($usernames[0]['uid']));
+                                $bananasumsql = "select sum(score) as sum from awards where username ~* ?";
+                                $bananasum = $DB->GetAll($bananasumsql, array("^".$usernames[0]['uid']."$"));
                                 $usernames[0]['bananascore'] = $bananasum[0]['sum'];
                         }
@@ -125 +126 @@
                 foreach ($usernames as $i => $value) {
                         $realUsers[] = $usernames[$i]['uid'];
+                }
+                foreach ($stats['yeartop'] as $i => $value) {
+                        if (in_array(strtolower($stats['yeartop'][$i]['username']), $realUsers)) {
+                                $stats['yeartop'][$i]['real'] = TRUE;
+                        } else {
+                                $stats['yeartop'][$i]['real'] = FALSE;
+                        }
                 }
                 foreach ($stats['top'] as $i => $value) {