Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Alphabetical pages

Dec 2, 2009, 10:03 AM

MJB

Enthusiast (511 posts)

Dec 2, 2009, 10:03 AM

Post #1 of 7

Shortcut

Alphabetical pages

Is this possible? Can I set up an alphabetical hyperlink list so that when a user clicks on 'G' for example I will display a page that lists all links in alphabetical order that start with that letter on a separate page (or custom template)?

Dec 2, 2009, 10:35 AM

Andy

Veteran / Moderator (17366 posts)

Dec 2, 2009, 10:35 AM

Post #2 of 7

Shortcut

Re: [MJB] Alphabetical pages In reply to

Like this?

http://www.ultranerds.com/...ugins/AlphaBar_L170/

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Dec 2, 2009, 12:11 PM

MJB

Enthusiast (511 posts)

Dec 2, 2009, 12:11 PM

Post #3 of 7

Shortcut

Re: [Andy] Alphabetical pages In reply to

Sort of but site related not just category.

I want it to list just the title of the link but for the whole database regardless of what category a link is in.

Dec 2, 2009, 11:12 PM

Andy

Veteran / Moderator (17366 posts)

Dec 2, 2009, 11:12 PM

Post #4 of 7

Shortcut

Re: [MJB] Alphabetical pages In reply to

Should be possible with a global like this:

get_links_by_letter

Code:
sub { 

   my $tbl = $DB->table('Links'); 
      $tbl->select_options("ORDER BY Title"); 

   my $letter = $IN->param('letter'); 

   my $sth = $tbl->select( GT::SQL::Condition->new('isValidated','=',"Yes",'Title','LIKE',"$letter%") ); 

   my @loop; 
   while (my $hit = $sth->fetchrow_hashref) { 
	   if ($CFG->{build_detailed}) { $hit->{detailed_url} = $CFG->{build_root_url} . "/" . $DB->table('Links')->detailed_url( $hit->{ID} ); } 
	   if ($hit->{isNew} eq "Yes")     { $hit->{isNew} = 1;     } else { $hit->{isNew} = 0;     } 
	   if ($hit->{isPopular} eq "Yes") { $hit->{isPopular} = 1; } else { $hit->{isPopular} = 0; } 
	   if ($hit->{isChanged} eq "Yes") { $hit->{isChanged} = 1; } else { $hit->{isChanged} = 0; }        
	   push @loop, $hit; 
   } 


   return { links_loop => \@loop }; 

}

Then make a new template (called get_links_by_letter.html) ... and call that global with:

Code:
<%get_links_by_letter%> 
<%if links_loop.length%> 
   <ul> 
      <%loop links_loop%> 
        <li><%Title%></li> 
     <%endloop%> 
   </ul> 
<%else%> 
   No matches 
<%endif%>

Then call with page.cgi?p=get_links_by_letter;letter=A (that should get a list of all links where "Title" starts with "A" or "a")

Untested - and was written literally after getting out of bed - so could be some issues that may need fixing :)

Cheers

Andy (mod)
andy@ultranerds.co.uk