Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Display Links by Category on home.html

Jun 9, 2007, 10:31 AM

sangiro

Enthusiast (524 posts)

Jun 9, 2007, 10:31 AM

Post #1 of 4

Shortcut

Display Links by Category on home.html

Heya all,

I'm looking for a mod similar to the Yahoo Subcats plugin, except I don't want to show the sub-categories for a category, I'd like to display the Link titles of all links in that category (and subcats) ie: An output similar to this:

Category 1
- Link 1
- Link 2

Category 2
- Link 3
- Link 4

I've search and couldn't find this. Apologies in advance if I missed it.

Safe swoops
Sangiro

Jun 10, 2007, 3:02 AM

Andy

Veteran / Moderator (18441 posts)

Jun 10, 2007, 3:02 AM

Post #2 of 4

Shortcut

Re: [sangiro] Display Links by Category on home.html In reply to

Hi,

Totally untested (and written with a hangover =)), but you could give this a go:

Code:
sub { 

   my $ctbl = $DB->table('Category'); 
      $ctbl->select_options('ORDER BY Name ASC'); 
   my $sth = $ctbl->select( { FatherID => 0 } ) || die $GT::SQL::error; 
   my @cats; 
   while (my $hit = $sth->fetchrow_hashref) {  
      $hit->{links} = load_links($hit->{ID}); 
      push @cats, $hit;   
   } 

   return { cat_loop => \@cats  }; 

   sub load_links { 

       my $tbl = $DB->table('CatLinks','Links'); 
       $tbl->Select_options('LIMIT 20','ORDER BY Title ASC'); 
       my $sth = $tbl->select( GT::SQL::Condition->new('CatLinks.CategoryID','=',$_[0]) ) || die $GT::SQL::error; 
       my $back; 
       while (my $hit = $sth->fetchrow_hashref) {  
          $back .= qq|<a href="#">$hit->{Title}</a>|<br />|; 
       } 
       return $back; 
   } 

}

Call with:

Code:
<%global_name%>

..and then:

Code:
<%loop cat_loop%> 
   NORMAL CATEGORY STUFF 
      <%links%> <%-- this will show the link titles for this cat --%> 
<%endloop%>

Hope that helps =)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jun 10, 2007, 2:38 PM

sangiro

Enthusiast (524 posts)

Jun 10, 2007, 2:38 PM

Post #3 of 4

Shortcut

Re: [Andy] Display Links by Category on home.html In reply to

Hey Andy!

Hope you're doing well. Smile

Thanks for having a go at this. I get:

Code:
Unable to compile 'catlinks': syntax error at (eval 2944) line 21, near "/>"

Safe swoops
Sangiro

Jun 11, 2007, 1:04 AM

Andy

Veteran / Moderator (18441 posts)

Jun 11, 2007, 1:04 AM

Post #4 of 4

Shortcut

Re: [sangiro] Display Links by Category on home.html In reply to

Hi,

Ya, not doing too bad thanks =)

Regarding the error, that serves me right trying to write this global when recovering from a hangover Tongue

The line:

Code:
$back .= qq|<a href="#">$hit->{Title}</a>|<br />|;

..should read:

Code:
$back .= qq|<a href="#">$hit->{Title}</a> <br />|;

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk