Limit Database Error Mails

Hack: Limit Database Error Mails
Version: v1.00
Author: MarcoH64 for vBulletin.org
vB Version: 3.5.0
File edits: 1 + 1 (config.php)

Disclaimer:
This hack may not be modified or distributed without the explicit permission of the author. The author don't take responsibility for
any problems caused by this modification.

Description:
With this hack installed you can limit the number of emails sent to your technical mail address in case of Database Errors.
You can specify an interval in seconds between sending mails. All errors generated after the first error, until interval is passed,
are not mailed.

Optionally you can specify a different interval for different types of errors.

Operating system files will be used to keep track of the last mail sent. These will be zero byte files, so won't take any space.

Donations?
If you like this work and want to make a donation, your gifts are always welcomed at Paypal: marcoh64@gmail.com

PS No screenshots!!

[SAngove]

I will have a look at this, as i get quite frustrated to see my inbox full of db error emails

Thanks in Advance.

[reteep]

Oh YEA, this feature should be a default feature for vBulletin.. thanks!

[Marco van Herwaarden]

Then please click install

Edit: Oops you just did

[jugo]

Thanks Marco...this rocks.

Does anyone have a plugin / solution for this: I want to not display the ugly database error when the DB is down on non-vb pages where global.php is included.

[Marco van Herwaarden]

Originally Posted by jugo

Thanks Marco...this rocks.

Does anyone have a plugin / solution for this: I want to not display the ugly database error when the DB is down on non-vb pages where global.php is included.

In includes/class_core.php, find:

PHP Code:

   eval('$message = "' . str_replace('"', '\"', file_get_contents(DIR . '/includes/database_error_page.html')) . '";');
   die($message); 


And replace by:

PHP Code:

   eval('$message = "' . str_replace('"', '\"', file_get_contents(DIR . '/includes/database_error_page.html')) . '";');
   if (VB_AREA != 'NonVB')
   {
    die($message);
   } 


Then in the top of your non vb page script:

PHP Code:

define('VB_AREA', 'NonVB'); 


PS This is not tested.

[jugo]

Thanks Marco...that gave me a whole bunch of other ideas.

They should put a hook there.

[Marco van Herwaarden]

Yes i agree, and i don't agree.

This is a crucial part of the code and will get executed in case of database errors.

No Database = No plugins to be executed = Hooks are useless.

Go Go Marco, this is really something I need. I'm sick of database error emails on my test board.

/me installs

[Marco van Herwaarden]

Well on your testboard, you can simply remove the tech email from the config.php. You won't get any mails at all.