db_mysql_error.php

这个版本只是修正了一些BUG

<?
/*
	db_mysql_error.php - MYSQL 数据库错误处理程序

	Version  : 1.0.0
	Author   : Tracemouse ([e-mail])
	Copyright:
	Writed   : 2003/08/07
	Modified : 2003/08/07
*/

$timestamp = time();
$errmsg = '';

$dberror = $this->error();
$dberrno = $this->errno();

	if($message) {
		$errmsg = "<b>VITCIE info</b>: $message\n\n";
	}
	if($_login_user) {
		$errmsg .= "<b>User</b>: $_login_user\n";
	}
	$errmsg .= "<b>Time</b>: ".gmdate("Y-n-j g:ia", $timestamp)."\n";
	$errmsg .= "<b>Script</b>: ".$GLOBALS[PHP_SELF]."\n\n";
	if($sql) {
		$errmsg .= "<b>SQL</b>: ".htmlspecialchars($sql)."\n";
	}
	$errmsg .= "<b>Error</b>:  $dberror\n";
	$errmsg .= "<b>Errno.</b>:  $dberrno";

	echo "</table></table></table></table></table>\n";
	echo "<p style=\"font-family: Verdana, Tahoma; font-size: 11px; background: #FFFFFF;\">";
	echo nl2br($errmsg);
	if($GLOBALS['adminemail']) {
		$errnos = array();
		$errorlogs = '';
		if($errlog = @file('./tempdata/dberror.log')) {
			for($i = 0; $i < count($errlog); $i++) {
				$log = explode("\t", $errlog[$i]);
				if(($timestamp - $log[0]) > 86400) {
					$errlog[$i] = "";
				} else {
					$errnos[] = $log[1];
				}
			}
		}
		if(!in_array($dberrno, $errnos)) {
			$errorlogs .= "$timestamp\t$dberrno\n";
			echo "<br><br>An error report has been dispatched to our administrator.";
			sendmail($GLOBALS['adminemail'], 'MySQL Error Report',
					"There seems to have been a problem with the database of your site\n\n".
					strip_tags($errmsg)."\n\n".
					"Please check-up your MySQL server and php scripts, similar errors will not be reported again in recent 24 hours\n".
					"If you have troubles in solving this problem, please visit http://bbs.vitci.com");
		} else {
			echo '<br><br>Similar error report has beed dispatched to administrator before.';
		}
		for($i = 0; $i < count($errlog); $i++) {
			$errorlogs .= $errlog[$i] ? trim($errlog[$i])."\n" : NULL;
		}
		@$fp = fopen('./tempdata/dberror.log', 'w');
		@flock($fp, 3);
		@fwrite($fp, $errorlogs);
		@fclose($fp);
	}
	echo '</p>';
	exit;



?>