i have try to have a test for the scripts however there is no any links returned. i am not sure what is the problems it is
i am tested with latest version of linksql, however it should worked and been tested before by people.
if it is not worked with latest version of linksql? .
i am stucked now. would any one here light me a bit?
-----------------------
featured.cgi
main();
sub main {
#---------------------------------------------------
#
my $pageNum = $IN->param('nh') || 1;
my $linksPP = 10;
my $start = $linksPP * $pageNum - $linksPP;
$start = ($pageNum < 2) ? 0 : $start;
my ($sth,$tab,$output);
$tab = $DB->table('Links');
$tab->select_options('ORDER BY Title', 'LIMIT ' . $linksPP . ' OFFSET ' . $start);
$sth = $tab->select( { isValidated => 'Yes' } );
my $hits = $tab->hits;
while (my $rec = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display('8linkfeatured', $rec);
}
my $tags;
$tags->{'paging'}->{'url'} = $CFG->{db_cgi_url} . "/featured.cgi";
$tags->{'paging'}->{'num_hits'} = $hits;
$tags->{'paging'}->{'max_hits'} = $linksPP;
$tags->{'paging'}->{'current_page'} = $pageNum;
$tags->{'output'} = $output;
print $IN->header();
print Links::SiteHTML::display('8featured', $tags);
}
----------------------
8linkfeatured.html
<%if Description%><div class="linkdescription"><%if highlight%><%Links::Tools::highlight($Description, $query)%><%else%><%Description%><%endif%></div><%endif%>
------------------------------------------
8featured.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/...ml1-transitional.dtd">
<html>
<head>
<title><%site_title%>: New Links xx</title>
<%include include_common_head.html%>
</head>
<body id="new">
<p>Here are your matching links:<br><br>
<%loop link_results_loop%>
<a href="<%URL%>"><%Title%></a>: <%Hits%>
<%endloop%>
<p><p><p><p><p>
<p>Here are your matching links:<br><br>
<%loop link_results_loop%>
<tr><td><%include 8linkfeatured.html%></td></tr>
<%endloop%>
</body>
</html>
