Hi,
I'm using this global to display LastLinks on my homepage:
my $tags = shift;
my $table = $DB->table('Links');
$table->select_options ('ORDER BY ID DESC', 'LIMIT 6');
my $sth = $table->select ({isValidated => "Yes"});
my @output;
while (my $link = $sth->fetchrow_hashref) {
$link->{detailed_url} = $CFG->{build_root_url} . "/" . $DB->table('Links')->detailed_url( $link->{ID} );
push (@output, $link);
}
return { LastLinks_loop => \@output };
}
But this code also show links that are validated but still awaiting payment. Well, don't want to show links that are awaiting payment. How to do this?
Regards.
UnReal Network
I'm using this global to display LastLinks on my homepage:
Code:
sub { my $tags = shift;
my $table = $DB->table('Links');
$table->select_options ('ORDER BY ID DESC', 'LIMIT 6');
my $sth = $table->select ({isValidated => "Yes"});
my @output;
while (my $link = $sth->fetchrow_hashref) {
$link->{detailed_url} = $CFG->{build_root_url} . "/" . $DB->table('Links')->detailed_url( $link->{ID} );
push (@output, $link);
}
return { LastLinks_loop => \@output };
}
But this code also show links that are validated but still awaiting payment. Well, don't want to show links that are awaiting payment. How to do this?
Regards.
UnReal Network
LastLinks global