Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

user toplist with link to profile

Quote Reply
user toplist with link to profile
Hi Andy,
who else ;-) Do you know how to integrate the link to the user profile
community.cgi?view_profile=1;user=<%Username%>
into the following global just after the linkowner name?
my $url = $CFG->{db_cgi_url} . "/search.cgi?query=;LinkOwner=$s";


Code:
sub {

my $db = $DB->table('Links');
$db->select_options( "GROUP BY LinkOwner","ORDER BY link_count DESC" );
my $sth = $db->select("LinkOwner", "COUNT(*) as link_count", "SUM(Hits) as hits_count") or die "Query Error: $GT::SQL::error";

my $back;
while (my ($s, $c,$h) = $sth->fetchrow_array) {
if ($c < 7) { next; }
my $url = $CFG->{db_cgi_url} . "/search.cgi?query=;LinkOwner=$s";
$back .= qq|> <a href="$url">$s</a> - $c Einträge mit $h Downloads <br />|;
}

return $back;

}

Thanks
Matthias

Matthias
gpaed.de
Subject Author Views Date
Thread user toplist with link to profile Matthias70 4122 Feb 28, 2008, 9:17 AM
Thread Re: [Matthias70] user toplist with link to profile
Andy 3973 Feb 28, 2008, 9:26 AM
Thread Re: [Andy] user toplist with link to profile
Matthias70 3988 Feb 28, 2008, 9:53 AM
Post Re: [Matthias70] user toplist with link to profile
Andy 4000 Feb 28, 2008, 9:55 AM
Post Re: [Matthias70] user toplist with link to profile
Matthias70 3969 Feb 28, 2008, 9:56 AM