Print Page - AdMod makes too many updates to the database ! Disable reporting ?

Title: AdMod makes too many updates to the database ! Disable reporting ?
Post by: hartiberlin on December 22, 2006, 04:13:35 PM

Hi,
I have a problem.

I only have 30.000 updates per hour on my hosting platform
from my hoster. This is my hosting limit
at www.overunity.com

Now I have installed SMF 1.1.1 plus Tinyportal 0.97 and SMF_Ads
latest version and I get per page about 3 to 5 updates written to the database...
when I show banner ads inside the topics.

I see, this is used for the report function of SMF_Ads.

Can the report function be disabled and thus reduce the updates to the database ?
I can not see, where I could disable the reporting...

Here is a thread about finding this problem:

http://www.tinyportal.net/index.php?topic=11612.0

Many thanks.

Regards, Stefan.

Title: Re: AdMod makes too many updates to the database ! Disable reporting ?
Post by: jerm on December 23, 2006, 11:29:49 AM

LoadAds.php (in sources)
Look for:

Code Select

	$request = db_query("
		UPDATE {$db_prefix}ads
			SET hits = hits+1
				WHERE ADS_ID = $id", __FILE__, __LINE__);

Change to:

Code Select

/*
	$request = db_query("
		UPDATE {$db_prefix}ads
			SET hits = hits+1
				WHERE ADS_ID = $id", __FILE__, __LINE__);	
*/

SMF Ads Support Forum

Support => Bugs => Topic started by: hartiberlin on December 22, 2006, 04:13:35 PM