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";
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
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