Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Most popular links

May 11, 2003, 10:53 PM

klauslovgreen

Enthusiast (671 posts)

May 11, 2003, 10:53 PM

Post #1 of 5

Shortcut

Most popular links

Hi,

I am using the below global to display the 5 most popular links based on Hits which works fine.

My question is how can I modify it to only include links that have:

1. Add_Date equal to today
2. isNew = "Yes"

The two should of course not be combined - ie. two different globals.

Code:
sub { 
my $tags = shift; 
my $table = $DB->table('Links'); 
$table->select_options ('ORDER BY Hits DESC', 'LIMIT 5'); 
my $sth = $table->select; 
my @output; 
while (my $link = $sth->fetchrow_hashref) {  
push (@output, $link);  
} 
return { top5_loop => \@output }; 
}

Cheers
Klaus

http://www.ameinfo.com

May 12, 2003, 2:02 AM

Andy

Veteran / Moderator (18441 posts)

May 12, 2003, 2:02 AM

Post #2 of 5

Shortcut

Re: [klauslovgreen] Most popular links In reply to

Maybe something like this;

Code:
sub {  
my $tags = shift;  
my $table = $DB->table('Links');  
$table->select_options ('ORDER BY Hits DESC', 'LIMIT 5');  
my $sth = $table->select( { isValidated => 'Yes' } );  
my @output;  
while (my $link = $sth->fetchrow_hashref) {   
push (@output, $link);   
}  
return { top5_loop => \@output };  
}

... and for the second one, maybe something like;

Code:
sub {  
my $tags = shift;  
my $date = GT::Date::date_get();
my $table = $DB->table('Links');  
$table->select_options ('ORDER BY Hits DESC', 'LIMIT 5');  
my $sth = $table->select( { Add_Date => $date } );  
my @output;  
while (my $link = $sth->fetchrow_hashref) {   
push (@output, $link);   
}  
return { top5_loop => \@output };  
}