Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Counting of Links

Jun 15, 2006, 5:39 PM
Jobu
User (137 posts)
Jun 15, 2006, 5:39 PM
Post #1 of 9
Views: 690
Shortcut
Quote Reply
Counting of Links
I have searched the forums for this to no avail. I have "copied" links into multiple categories; however, the total count of links is being skewed.

For example, say I have two categories: Category A and Category B. When I put the same link in both categories, shouldn't my total number of links be 1? Mine is showing 2.

Thanks.
Jun 16, 2006, 7:51 AM
MJB
Enthusiast (511 posts)
MJB's avatar
Jun 16, 2006, 7:51 AM
Post #2 of 9
Views: 666
Shortcut
Quote Reply
Re: [Jobu] Counting of Links In reply to
That's because <%grand_total%> in home.html counts the CatLinks table. What you want it to do is count the Links table.

[Post edited to remove incorrect global (MJB)]

Last edited by:

MJB: Jun 16, 2006, 8:46 AM
Jun 16, 2006, 8:27 AM
Jobu
User (137 posts)
Jun 16, 2006, 8:27 AM
Post #3 of 9
Views: 658
Shortcut
Quote Reply
Re: [MJB] Counting of Links In reply to
Thanks, MJB. I did this, however, when I now try to load home.html I get the following error:

Quote:

A fatal error has occured:
Can't call method "fetchrow_array" on an undefined value at (eval 20) line 2.

Please enable debugging in setup for more details.

Quote:



Any ideas?

Thanks,

AD
Jun 16, 2006, 8:45 AM
MJB
Enthusiast (511 posts)
MJB's avatar
Jun 16, 2006, 8:45 AM
Post #4 of 9
Views: 654
Shortcut
Quote Reply
Re: [Jobu] Counting of Links In reply to
OK, scrap the last and use this:

Code:
sub { # show total number of Links (without commas - 123456)
$DB->table('Links')->count({isValidated => 'Yes'})
}
Jun 16, 2006, 9:01 AM
Jobu
User (137 posts)
Jun 16, 2006, 9:01 AM
Post #5 of 9
Views: 651
Shortcut
Quote Reply
Re: [MJB] Counting of Links In reply to
Great, thanks! That works great. Now, is there a way to do it so that commas are added, or is that what was causing the problem?
Jun 16, 2006, 9:28 AM
MJB
Enthusiast (511 posts)
MJB's avatar
Jun 16, 2006, 9:28 AM
Post #6 of 9
Views: 649
Shortcut
Quote Reply
Re: [Jobu] Counting of Links In reply to
Untested:

Code:
sub { # show total number of actual Links (with commas - 123,456)
my $tags = shift;
local $_ = $DB->table('Links')->count({isValidated => 'Yes'});
return 0 unless defined $_;
1 while s/^([-+]?\d+)(\d{3})/$1,$2/;
return $_;
}

I don't have over 999 links so please let me know if it works Wink
Jun 16, 2006, 9:31 AM
Jobu
User (137 posts)
Jun 16, 2006, 9:31 AM
Post #7 of 9
Views: 646
Shortcut
Quote Reply
Re: [MJB] Counting of Links In reply to
I don't have over 999 links either, yet, but no errors when I run it so so far so good. When we get over 999, I will let you know!

Thanks again.
Jun 19, 2006, 7:15 AM
Andy
Veteran / Moderator (17366 posts)
Andy's avatar
Jun 19, 2006, 7:15 AM
Post #8 of 9
Views: 631
Shortcut
Quote Reply
Re: [MJB] Counting of Links In reply to
This may be quicker, as it simply gets the category counts (Direct_Links) from the lsql_Category table :)

Code:
sub {
my $tmp = $DB->table('Category')->select( ['SUM(Direct_Links)'] )->fetchrow;
my $tmp2 = reverse $tmp;
$tmp2 = sprintf "%.2f", $tmp2;
$tmp2 =~ s/(\d\d\d)(?=\d)(?!\d*\.)/$1,/g;
return scalar reverse $tmp2;
}


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
Jan 26, 2007, 6:42 AM
pacifico
New User (1 post)
Jan 26, 2007, 6:42 AM
Post #9 of 9
Views: 568
Shortcut
Post deleted by pacifico In reply to