SMF Ads Support Forum
May 26, 2013, 02:58:46 am *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome to SMF Ads Support Forum
 
   Home   Help Downloads Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: AdMod makes too many updates to the database ! Disable reporting ?  (Read 2079 times)
0 Members and 1 Guest are viewing this topic.
hartiberlin
Jr. Member
**
Offline Offline

Posts: 16



WWW
« 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.
Logged

jerm
Support
Elite Member
*
Offline Offline

Posts: 726


« Reply #1 on: December 23, 2006, 11:29:49 am »

LoadAds.php (in sources)
Look for:
Code:
$request = db_query("
UPDATE {$db_prefix}ads
SET hits = hits+1
WHERE ADS_ID = $id", __FILE__, __LINE__);
Change to:
Code:
/*
$request = db_query("
UPDATE {$db_prefix}ads
SET hits = hits+1
WHERE ADS_ID = $id", __FILE__, __LINE__);
*/
Logged
SMF Ads Support Forum
   

.
 Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

.
Powered by SMF 1.1.18 | SMF © 2013, Simple Machines
SMFAds for Free Forums
SMF and SimpleMachines are registered trademarks of Simple Machines. SMFAds.com is not affiliated with nor endorsed by Simple Machines.