Hi,
Mmm.. you could do it with a custom script. Something along these lines;
Code:
my $catID = 111; # set as the category you wanna ge sub-cats of
my $catids = $DB->table('Category')->children($catID); # business
my $tbl = $DB->table('CatLinks','Links');
my $sth = $tbl->select( ['Links.Photo','Links.ID'] , GT::SQL::Condition->new ('CatLinks.CategoryID', 'IN', $catids, 'isValidated', '=', 'Yes' ) ) || die $GT::SQL::error;
while (my $hit = $sth->fetchrow_hashref) {
# you have access to all values from glinks_Links and glinks_CatLinks here - so would need to get the values from glinks_Category seperatly
}
I can't afford the time to write the whole thing for you I'm afraid - spent too much of my Xmas hol's helping people out this year
Hope that helps though.
Cheers
Andy (mod)
andy@ultranerds.com Merry Xmas and a Happy New Year!
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! Custom Toolbar for IE and Firefox! -
Compare our different Plugin packages *new*
Free CSS Templates
