Does Links SQL include alternate/multiple categories? How many categories can be used for one link? If you have a link with a category then 10 alt cats, will it be counted as 1 link or 11 in the grand total?
Sep 24, 2001, 11:54 AM
Veteran (17240 posts)
Sep 24, 2001, 11:54 AM
Post #2 of 5
Views: 1447
Yes...like I already stated in your other thread.
You can add it to all your categories if you like.
Unfortunately, the "count" only will be carried in the MAIN category
that the link is added to...meaning that it will be ignored
in the alternative categories you add it to.
========================================
Buh Bye!
Cheers,
Me
You can add it to all your categories if you like.
Unfortunately, the "count" only will be carried in the MAIN category
that the link is added to...meaning that it will be ignored
in the alternative categories you add it to.
========================================
Buh Bye!
Cheers,
Me
Sep 25, 2001, 1:00 PM
Administrator (9387 posts)
Sep 25, 2001, 1:00 PM
Post #3 of 5
Views: 1430
Hi,
We will change this in the next release. If you edit admin/Links/Build.pm and change _grand_total to:
# -------------------------------------------------------------------
# Calculates the total in two queries as it is significantly faster
# on large db's.
#
my $total = $DB->table ('CatLinks')->total;
my $unval = $DB->table ('Links')->count ( { isValidated => 'No' } );
return $total - $unval;
}It will include alt's in the grand total.
Cheers,
Alex
--
Gossamer Threads Inc.
We will change this in the next release. If you edit admin/Links/Build.pm and change _grand_total to:
Code:
sub _grand_total { # -------------------------------------------------------------------
# Calculates the total in two queries as it is significantly faster
# on large db's.
#
my $total = $DB->table ('CatLinks')->total;
my $unval = $DB->table ('Links')->count ( { isValidated => 'No' } );
return $total - $unval;
}
Cheers,
Alex
--
Gossamer Threads Inc.
Sep 25, 2001, 1:08 PM
Enthusiast (582 posts)
Sep 25, 2001, 1:08 PM
Post #4 of 5
Views: 1416
And if you modify the link, will it change all the links under the main and altcats?
Is there a limit to how many altcats you can safely add a link to? As I said, I have some links that will go into 100 or more categories.
Is there a limit to how many altcats you can safely add a link to? As I said, I have some links that will go into 100 or more categories.