Gossamer Forum
Quote Reply
top review writer
Hi could not find it in the forum,
so I changed the user links top 10 global
to a user reviews top 10 global by myself.

Still wondering that the global is working Wink

The global shows the top 5 review writer


Code:
sub {

my $db = $DB->table('Reviews');
$db->select_options( "GROUP BY Review_Owner","ORDER BY review_count DESC","LIMIT 10");
my $sth = $db->select("Review_Owner", "COUNT(*) as review_count") or die "Query Error: $GT::SQL::error";

my $back;
while (my ($s, $c) = $sth->fetchrow_array) {
my $url = $CFG->{db_cgi_url} . "/review.cgi?username=$s";
$back .= qq| <a href="$url">$s</a> ($c Kommentare) <br />|;
}

return $back;

}

Matthias

Matthias
gpaed.de
Subject Author Views Date
Thread top review writer Matthias70 1949 Nov 2, 2007, 11:45 AM
Post Re: [Matthias70] top review writer
Andy 1873 Nov 5, 2007, 8:39 AM