Hi,
I would like to display also the categories of the links in the listing,
and link to the category instead of jumping to the link.
<%GT::Template::dump%> does not show me a tag for that.
In my old last-5 script I had this part ....
$link_catlink->select_options("order by ID DESC limit $limit");
my $sth = $link_catlink->select ( {isValidated=>'Yes'}, ['Title','LinkOwner','URL','Links.ID']);
my $i=0;
while (@data = $sth->fetchrow_array) {
# get category ID
my $catLinks = $link_catlink->select ( {LinkID=>$data[3]}, ['CategoryID'] );
$catID = $catLinks->fetchrow;
# get category name
my $cat_name = $category->select ({ID=>$catID},['Full_Name']);
$catName = $cat_name->fetchrow;
# set url for each Category
$clean_name = $category->as_url($catName);
$url = $CFG->{build_root_url} . "/" . $clean_name . "/" . $CFG->{build_index};
Possible to use something like that in combination with the script from this thread?
Michael
--
Michael Skaide
http://www.cycle24.de
I would like to display also the categories of the links in the listing,
and link to the category instead of jumping to the link.
<%GT::Template::dump%> does not show me a tag for that.
In my old last-5 script I had this part ....
$link_catlink->select_options("order by ID DESC limit $limit");
my $sth = $link_catlink->select ( {isValidated=>'Yes'}, ['Title','LinkOwner','URL','Links.ID']);
my $i=0;
while (@data = $sth->fetchrow_array) {
# get category ID
my $catLinks = $link_catlink->select ( {LinkID=>$data[3]}, ['CategoryID'] );
$catID = $catLinks->fetchrow;
# get category name
my $cat_name = $category->select ({ID=>$catID},['Full_Name']);
$catName = $cat_name->fetchrow;
# set url for each Category
$clean_name = $category->as_url($catName);
$url = $CFG->{build_root_url} . "/" . $clean_name . "/" . $CFG->{build_index};
Possible to use something like that in combination with the script from this thread?
Michael
--
Michael Skaide
http://www.cycle24.de