Hello,
Anybody know how to show number of categories such as number of links? Thank you in advance.
Kay
Anybody know how to show number of categories such as number of links? Thank you in advance.
Kay
Jan 4, 2000, 9:52 PM
Veteran (1311 posts)
Jan 4, 2000, 9:52 PM
Post #2 of 10
Views: 1863
do you mean number of categories in your database? or the number of sub categories in a single category? I did the second one at my site
------------------
LookHard Search
lookhard.hypermart.net
Lavon Russell
------------------
LookHard Search
lookhard.hypermart.net
Lavon Russell
Hi Lavon,
Thanks for responding. I mean the number of categories in the database. But the number of sub cat in a single cat also sounds pretty cool. May i know the way to do that, please? Thank you.
Regards,
Kay
Thanks for responding. I mean the number of categories in the database. But the number of sub cat in a single cat also sounds pretty cool. May i know the way to do that, please? Thank you.
Regards,
Kay
Jan 5, 2000, 4:28 PM
Veteran (1311 posts)
Jan 5, 2000, 4:28 PM
Post #4 of 10
Views: 1862
Ok, i think to get the number of all cats, you just have to open the database and then print it into a scalar, something like
open (CAT, "<$db_category_id_file_name");
print CAT $catnum;
close CAT;
and then put catnum => $catnum, in site_html_templates.pl. I tried this but its not working so i'll look at it later.
-----------------------
I got the categories in a cat like this, in nph-build.cgi go to sub build_category_pages
find
$title = &build_unlinked_title ($cat);
$total = ($#{$links{$cat}} + 1) / ($#db_cols + 1);
$category_name = $cat;
$category_name_escaped = &urlencode ($cat);
$category_clean = &build_clean ($cat);and change it to this
$title = &build_unlinked_title ($cat);
$total = ($#{$links{$cat}} + 1) / ($#db_cols + 1);
$category_name = $cat;
$category_name_escaped = &urlencode ($cat);
$category_clean = &build_clean ($cat);
$subnum = ($#{$subcategories{$cat}} + 1);
Then in site_html_templates.pl, go to sub site_html_category
and put subnum => $subnum, in it. Then wherever you want it to show how many categories are in the category your in.
------------------
LookHard Search
lookhard.hypermart.net
Lavon Russell
open (CAT, "<$db_category_id_file_name");
print CAT $catnum;
close CAT;
and then put catnum => $catnum, in site_html_templates.pl. I tried this but its not working so i'll look at it later.
-----------------------
I got the categories in a cat like this, in nph-build.cgi go to sub build_category_pages
find
Code:
$title_linked = &build_linked_title ($cat); $title = &build_unlinked_title ($cat);
$total = ($#{$links{$cat}} + 1) / ($#db_cols + 1);
$category_name = $cat;
$category_name_escaped = &urlencode ($cat);
$category_clean = &build_clean ($cat);
Code:
$title_linked = &build_linked_title ($cat); $title = &build_unlinked_title ($cat);
$total = ($#{$links{$cat}} + 1) / ($#db_cols + 1);
$category_name = $cat;
$category_name_escaped = &urlencode ($cat);
$category_clean = &build_clean ($cat);
$subnum = ($#{$subcategories{$cat}} + 1);
Then in site_html_templates.pl, go to sub site_html_category
and put subnum => $subnum, in it. Then wherever you want it to show how many categories are in the category your in.
------------------
LookHard Search
lookhard.hypermart.net
Lavon Russell
Bmxer,
Nice try with trying to use the $db_category_id_file_name. But this will not work because that file contains the last Category ID number, which is not the same for the total number of categories in the categories.db file.
For example, I have 401 in the $db_category_id_file_name file, but I only have 394 Categories in the categories.db file due to deletion of categories.
Regards,
------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------
Nice try with trying to use the $db_category_id_file_name. But this will not work because that file contains the last Category ID number, which is not the same for the total number of categories in the categories.db file.
For example, I have 401 in the $db_category_id_file_name file, but I only have 394 Categories in the categories.db file due to deletion of categories.
Regards,
------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------
Thanks a lot for your suggestions, Lavon and Eliot. Do you have any better solution about the issue above, Eliot? I really hope you have.
Regards,
Kay
[This message has been edited by Kay (edited January 06, 2000).]
Regards,
Kay
[This message has been edited by Kay (edited January 06, 2000).]
Jan 16, 2024, 2:04 PM
Veteran (1127 posts)
Jan 16, 2024, 2:04 PM
Post #8 of 10
Views: 577
Just in case if anyone needs it, here is a global that I am using to count number of subcategories in any given category.
sub {
# GLOBAL NAME: Count_Subcategories
# PURPOSE: Count the number of sub-categories within a given category.
# CALL TAG: <%Count_Subcategories($ID)%>
my $category_id = shift; # Get the category ID passed to the global
# Ensure the category ID is provided
return 0 unless $category_id;
# Access the Category table
my $category_table = $DB->table('Category');
# Count sub-categories
my $subcategory_count = $category_table->count({ FatherID => $category_id });
return $subcategory_count; # Return just the count
}
Vishal
-------------------------------------------------------
sub {
# GLOBAL NAME: Count_Subcategories
# PURPOSE: Count the number of sub-categories within a given category.
# CALL TAG: <%Count_Subcategories($ID)%>
my $category_id = shift; # Get the category ID passed to the global
# Ensure the category ID is provided
return 0 unless $category_id;
# Access the Category table
my $category_table = $DB->table('Category');
# Count sub-categories
my $subcategory_count = $category_table->count({ FatherID => $category_id });
return $subcategory_count; # Return just the count
}
Vishal
-------------------------------------------------------
Mar 15, 2024, 1:38 AM
Veteran / Moderator (18441 posts)
Mar 15, 2024, 1:38 AM
Post #9 of 10
Views: 275
You are in the Links2 forum - not LinksSQL/GossamerLinks ;)
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!
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!