Hi,
Is someone know how to always display the list of the top categories ?
Thank you.
____________________
Fabrice
Is someone know how to always display the list of the top categories ?
Thank you.
____________________
Fabrice
Jul 8, 2005, 5:22 AM
Enthusiast (707 posts)
Jul 8, 2005, 5:22 AM
Post #2 of 7
Views: 3386
You can probably make a loop of sorts, but a good old-fashioned global should also work. Something like this, I suspect:
my $tags = shift;
my $cat_db = $DB->table('Category');
my @root_cats = $cat_db->select (['Full_Name'], { FatherID => 0 })->fetchall_list;
my $output;
foreach my $root_cat (@root_cats) {
my $url = $cat_db->as_url($root_cat);
$output .= qq~<a href="$CFG->{build_root_url}/$url">$root_cat"</a><br />~;
}
return $output;
}
John
Code:
sub { my $tags = shift;
my $cat_db = $DB->table('Category');
my @root_cats = $cat_db->select (['Full_Name'], { FatherID => 0 })->fetchall_list;
my $output;
foreach my $root_cat (@root_cats) {
my $url = $cat_db->as_url($root_cat);
$output .= qq~<a href="$CFG->{build_root_url}/$url">$root_cat"</a><br />~;
}
return $output;
}
John
Jul 8, 2005, 5:36 AM
Novice (12 posts)
Jul 8, 2005, 5:36 AM
Post #3 of 7
Views: 3393
Well, sure ! thank you.
But, i am a beginer, totaly newbie, you know
So, as stupid as I am, I ask you this
: "In a template, how do I use your code ?" (sorry again, I am trying to learn, it is my 2nd day on GLinks 
)
____________________
Fabrice
But, i am a beginer, totaly newbie, you know
So, as stupid as I am, I ask you this
: "In a template, how do I use your code ?" (sorry again, I am trying to learn, it is my 2nd day on GLinks ) ____________________
Fabrice
Jul 8, 2005, 5:52 AM
Enthusiast (707 posts)
Jul 8, 2005, 5:52 AM
Post #4 of 7
Views: 3393
A global has a name, say TopLevelCategories, and is called within a template by using <%TopLevelCategories%> in the template.
To create a global, go to Build > Template Globals. Scroll down and use the New fields. For your new TopLevelCategories global, copy the code above (the "sub"line must be a the very start of the textfield.
That's about it ...
To create a global, go to Build > Template Globals. Scroll down and use the New fields. For your new TopLevelCategories global, copy the code above (the "sub"line must be a the very start of the textfield.
That's about it ...
Pretty cool;
Jul 8, 2005, 9:19 AM
Veteran / Moderator (18441 posts)
Jul 8, 2005, 9:19 AM
Post #6 of 7
Views: 3384
Hi,
Something like this should work;
my ($category,$output);
my $db = $DB->table('Category') || return $GT::SQL::error;
$db->select_options('ORDER BY Full_Name','LIMIT 100') || return $GT::SQL::error;
my $sth = $db->select( ['ID','Full_Name'], { FatherID => 0 } ) || return $GT::SQL::error;
while (my ($id,$full_name) = $sth->fetchrow_array) {
my $safe_full = $full_name;
my @cut = split /\//, $full_name;
$output .= qq|<a href="$CFG->{build_root_url}/| . $db->as_url($safe_full) . qq|">$full_name</a><BR>|. "\n";
}
return \$output;
}
..call it with <%global_name%>
Hope that helps.
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Something like this should work;
Code:
sub { my ($category,$output);
my $db = $DB->table('Category') || return $GT::SQL::error;
$db->select_options('ORDER BY Full_Name','LIMIT 100') || return $GT::SQL::error;
my $sth = $db->select( ['ID','Full_Name'], { FatherID => 0 } ) || return $GT::SQL::error;
while (my ($id,$full_name) = $sth->fetchrow_array) {
my $safe_full = $full_name;
my @cut = split /\//, $full_name;
$output .= qq|<a href="$CFG->{build_root_url}/| . $db->as_url($safe_full) . qq|">$full_name</a><BR>|. "\n";
}
return \$output;
}
..call it with <%global_name%>
Hope that helps.
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!