Gossamer Forum: Products: Gossamer Links: Discussions: ULTRAGlobals question

Aug 7, 2008, 1:56 AM

Knubbel

User (72 posts)

Aug 7, 2008, 1:56 AM

Post #1 of 5

Shortcut

ULTRAGlobals question

Hello.
I'm using UltraGlobals to show random links of a category on the category page:

# Random_Links

<%Plugins::ULTRAGlobals::Random_Links(LIMIT,'category_id')%>

Example:

<%Plugins::ULTRAGlobals::Random_Links(10,$ID)%>
<%if Random_Loop.length%>
<%loop Random_Loop%>
<%include link.html%>
<%endloop%>
<%endif%>

Now my question: Is it possible to show links from all child-categories of the with $ID selected category?
Currently it shows only the links from the with $ID selected category.

Knubbel

Last edited by:

Knubbel: Aug 7, 2008, 1:59 AM

Aug 7, 2008, 2:00 AM

Andy

Veteran / Moderator (17298 posts)

Aug 7, 2008, 2:00 AM

Post #2 of 5

Shortcut

Re: [Knubbel] ULTRAGlobals question In reply to

Hi,

Untested, but you could try a new global:

random_links_by_category

Code:
sub { 

 my $cat = $_[0]; 
 my $all_ids = $DB->table('Category')->children($cat); 
 push @$all_ids, $cat;  

 my $db_obj = $DB->table('Links','CatLinks','Category'); 
    $db_obj->select_options ("ORDER BY RAND() Limit $_[1]"); 

 my $cond = GT::SQL::Condition->new('CategoryID', 'IN', $all_ids); 
 my $cond2 = GT::SQL::Condition->new('isValidated','=','Yes'); 
 my $sth = $db_obj->select (['Links.*'], $cond, $cond2 ) || die $GT::SQL::error; 

 my @cats; 
 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 @cats, $hit; 
 } 

 return { rand_links_in_this_cat => \@cats }  

}

..then call with:

Code:
<%random_links_by_category($ID,10)%> 
<%if rand_links_in_this_cat.length%> 
  <%loop rand_links_in_this_cat%> 
    <%include link.html%> 
  <%endloop%> 
<%endif%>

Untested, but should work fine =)

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