[AndrewD]

Originally Posted by hydn

THanks. That does help. However, I logged in / clicked administer / then clicked settings / ...

But can't find that prune_downloadtable.

I'm on version 2.1.0

Is this an option I can set with a Mysql query maybe? Or other solution(s)?

Thanks much.

Goodness, version 2.1.0.

You're in luck - that part of the code has not changed very much in two years Take a copy of the file include/local_links_include.php. Edit, and go to line 1078, which reads:

function record_hit($id, $url, $status, $size=0) {
	global $vbulletin, $links_permissions, $links_defaults;

	if ($links_permissions["can_bypass_hit_recording"]) {

Change to:

function record_hit($id, $url, $status, $size=0) {
	global $vbulletin, $links_permissions, $links_defaults;

	$when = TIMENOW-24*60*60*XXX;
	$vbulletin->db->query_write("
		DELETE FROM ".THIS_TABLE."linksdownloads
		WHERE usertime<'".$when."'
	");

	if ($links_permissions["can_bypass_hit_recording"]) {

where XXX is the number of days you want to retain in the table, e.g. 30.