Gossamer Forum: Products: Gossamer Links: Discussions: Any variable for number of sub-cats?

Jun 10, 2010, 8:21 AM

carfac

Veteran (1214 posts)

Jun 10, 2010, 8:21 AM

Post #1 of 14

Shortcut

Any variable for number of sub-cats?

I wanted to know if there is a variable I can call from a category page that returns the number of sub categories. I want to use it to "personalize and quantify" the title, thus:

XXX XDirector<%~if subcat > 1%>ies<%else%>y<%endif%>:

Thanks!
dave

Big Cartoon DataBase
Big Comic Book DataBase

Jun 10, 2010, 9:42 AM

Andy

Veteran / Moderator (17366 posts)

Jun 10, 2010, 9:42 AM

Post #2 of 14

Shortcut

Re: [carfac] Any variable for number of sub-cats? In reply to

So you wanna get the number of categories that are directly in the category the person is in?

For example:

Something/Bla
Something/Bla/Whatever
Something/Bla/Whatever/Something else
Something/Bla/Whatever2
Something/Bla/Whatever2/Whatever
Something/Bla/Whatever3

..in "Something/Bla" would return 3 (as there are 3 categories that are linked to it)

If so, this simple global should do the trick:

see_how_many_sub_cats

Code:
sub { 
  return $DB->table('Category')->count( { FatherID => $_[0] } ) || 0; 
}

...then call with:

Code:
<%see_how_many_sub_cats($ID)%>

Hope that helps.

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

Jun 10, 2010, 11:28 AM

carfac

Veteran (1214 posts)

Jun 10, 2010, 11:28 AM

Post #3 of 14

Shortcut

Re: [Andy] Any variable for number of sub-cats? In reply to

Andy-

As always, perfect, and thank you!
dave

Big Cartoon DataBase
Big Comic Book DataBase

Jun 11, 2010, 11:06 AM

carfac

Veteran (1214 posts)

Jun 11, 2010, 11:06 AM

Post #4 of 14

Shortcut

Re: [carfac] Any variable for number of sub-cats? In reply to

Whoops- does NOT quite work. ($ID) does return the correct Categoryt ID number (I checked it), but the global returns the total number of categorys, not the number with a FatherID = ID....

So, somehow $ID is not getting into that global....
dave

Big Cartoon DataBase
Big Comic Book DataBase

Jun 11, 2010, 6:01 PM

brewt

Staff (4071 posts)

Jun 11, 2010, 6:01 PM

Post #5 of 14

Shortcut

Re: [carfac] Any variable for number of sub-cats? In reply to

The correct variable might be $CategoryID

Adrian

Jun 12, 2010, 3:05 AM

Andy

Veteran / Moderator (17366 posts)

Jun 12, 2010, 3:05 AM

Post #6 of 14

Shortcut

Re: [carfac] Any variable for number of sub-cats? In reply to

This in category.html, or detailed.html ?

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jun 12, 2010, 8:17 AM

carfac

Veteran (1214 posts)

Jun 12, 2010, 8:17 AM

Post #7 of 14

Shortcut

Re: [Andy] Any variable for number of sub-cats? In reply to

Sorry- it is called from a Category.html page.

I called <%set variable = $ID%> and variable is the correct Category ID.... but the global returns (on any category.html, for any category) 6,384, whic\h is the sum total of ALL categorys... not just those with $ID as FatherID
dave

Big Cartoon DataBase
Big Comic Book DataBase

Jun 13, 2010, 12:20 AM

Andy

Veteran / Moderator (17366 posts)

Jun 13, 2010, 12:20 AM

Post #8 of 14

Shortcut

Re: [carfac] Any variable for number of sub-cats? In reply to

MMm, try adding some debugging to the global:

Code:
sub { 
   print qq| { FatherID => $_[0] }|; 
   return $DB->table('Category')->count( { FatherID => $_[0] } ) || 0;  
}

..and see what that prints out.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jun 13, 2010, 8:57 AM

carfac

Veteran (1214 posts)

Jun 13, 2010, 8:57 AM

Post #9 of 14

Shortcut

Re: [Andy] Any variable for number of sub-cats? In reply to

At the top of the page:

{ FatherID => 2108 } { FatherID => HASH(0x808dc9690) }

Where I called the code: 10

10 is NOT correct, in this instance, it should be 2

Here is the test page:

http://www.bcdb.com/bcdb/page.cgi?g=Other_Studios/D/DNA_Productions/

the code is called right after: "<meta name="keywords" content="
dave

Big Cartoon DataBase
Big Comic Book DataBase

Jun 13, 2010, 9:07 AM

Andy

Veteran / Moderator (17366 posts)

Jun 13, 2010, 9:07 AM

Post #10 of 14

Shortcut

Re: [carfac] Any variable for number of sub-cats? In reply to

Are you calling it 2 times? Cos you should only see:

{ FatherID => 2108 }

..not:

{ FatherID => 2108 } { FatherID => HASH(0x808dc9690) }

Also, whats the EXACT template code you are using?

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jun 13, 2010, 10:47 AM

carfac

Veteran (1214 posts)

Jun 13, 2010, 10:47 AM

Post #11 of 14

Shortcut

Re: [Andy] Any variable for number of sub-cats? In reply to

OH- found the problem... (and yes, I am an ijut!)

I was using <%set cat_num = sub_cats_num($ID)%> and then calling <%cat_num%> ... did not realize cat_num was used!

I changed to <%set num_o_cats = sub_cats_num($ID)%> and it works!
dave

Big Cartoon DataBase
Big Comic Book DataBase