Hi,
I don't know what version of Links SQL you're using, but for later versions (I use 2.1.1) if you look in Build.pm you'll find the following:
$SUBS{build_reset_hits} = <<'END_OF_SUB';
sub build_reset_hits {
------------------------------------------------------------------
Remove old hit and rate tracking information.
Links::init_date();
my $delete_by = GT::Date::date_get ( time() - 172800 ); # 2 days old
my $click_db = $DB->table ('ClickTrack');
$click_db->delete ( GT::SQL::Condition->new ( 'Created', '<', $delete_by ));
}
END_OF_SUB
That automatically deletes records from ClickTrack that are more than 2 days old I think. I like to keep my data for a month and then export it to my own database, and manually empty it, so I comment out this code.
I don't know if this code could be added to Build.pm or nph-build.cgi for older versions of Links SQL.
-Rover
I don't know what version of Links SQL you're using, but for later versions (I use 2.1.1) if you look in Build.pm you'll find the following:
$SUBS{build_reset_hits} = <<'END_OF_SUB';
sub build_reset_hits {
------------------------------------------------------------------
Remove old hit and rate tracking information.
Links::init_date();
my $delete_by = GT::Date::date_get ( time() - 172800 ); # 2 days old
my $click_db = $DB->table ('ClickTrack');
$click_db->delete ( GT::SQL::Condition->new ( 'Created', '<', $delete_by ));
}
END_OF_SUB
That automatically deletes records from ClickTrack that are more than 2 days old I think. I like to keep my data for a month and then export it to my own database, and manually empty it, so I comment out this code.
I don't know if this code could be added to Build.pm or nph-build.cgi for older versions of Links SQL.
-Rover