[Blue2000]

Originally posted by bandersen
Here's some feedback:
"top 10 richest people" do not include money in the bank. Hence, I show up broke even I am not....
Is there a way to include money in the bank in the count?

here you go fella

find

PHP Code:


if ($action=="top10") {

$topresult = $DB_site->query("SELECT * FROM user ORDER BY storep+bank DESC LIMIT 25");
while ($top = mysql_fetch_array($topresult)) {
    if (($counter++ % 2) != 0) {
                $backcolor="{firstaltcolor}";
                $bgclass="alt1";
            } else {
                $backcolor = "{secondaltcolor}";
                $bgclass="alt2";
            }
eval("\$top10rich .= \"".gettemplate("store_top10_bit")."\";");
}
eval("dooutput(\"".gettemplate("store_top10_main")."\");");

} 


replace with

PHP Code:

if ($action=="top10") {

$topresult = $DB_site->query("SELECT * FROM user ORDER BY storep+bank DESC LIMIT 25");
while ($top = mysql_fetch_array($topresult)) {
    if (($counter++ % 2) != 0) {
                $backcolor="{firstaltcolor}";
                $bgclass="alt1";
            } else {
                $backcolor = "{secondaltcolor}";
                $bgclass="alt2";
            }
$allmoney = $top[bank]+$top[storep];
eval("\$top10rich .= \"".gettemplate("store_top10_bit")."\";");
}
eval("dooutput(\"".gettemplate("store_top10_main")."\");");

} 


text file updated