/includes/adodb/adodb-errorhandler.inc.php

<?php

/**

 * @version V4.94 23 Jan 2007  (c) 2000-2007 John Lim (jlim#natsoft.com.my). All rights reserved.

 * Released under both BSD license and Lesser GPL library license.

 * Whenever there is any discrepancy between the two licenses,

 * the BSD license will take precedence.

 *

 * Set tabs to 4 for best viewing.

 *

 * Latest version is available at http://php.weblogs.com

 *

*/





// added Claudio Bustos  clbustos#entelchile.net

if (!defined('ADODB_ERROR_HANDLER_TYPE')) define('ADODB_ERROR_HANDLER_TYPE',E_USER_ERROR); 



if (!defined('ADODB_ERROR_HANDLER')) define('ADODB_ERROR_HANDLER','ADODB_Error_Handler');



/**

* Default Error Handler. This will be called with the following params

*

* @param $dbms		the RDBMS you are connecting to

* @param $fn		the name of the calling function (in uppercase)

* @param $errno		the native error number from the database

* @param $errmsg	the native error msg from the database

* @param $p1		$fn specific parameter - see below

* @param $p2		$fn specific parameter - see below

* @param $thisConn	$current connection object - can be false if no connection object created

*/

function ADODB_Error_Handler($dbms, $fn, $errno, $errmsg, $p1, $p2, &$thisConnection)

{

	if (error_reporting() == 0) return; // obey @ protocol

	switch($fn) {

	case 'EXECUTE':

		$sql = $p1;

		$inputparams = $p2;



		$s = "$dbms error: [$errno: $errmsg] in $fn(\"$sql\")\n";

		break;



	case 'PCONNECT':

	case 'CONNECT':

		$host = $p1;

		$database = $p2;



		$s = "$dbms error: [$errno: $errmsg] in $fn($host, '****', '****', $database)\n";

		break;

	default:

		$s = "$dbms error: [$errno: $errmsg] in $fn($p1, $p2)\n";

		break;

	}

	/*

	* Log connection error somewhere

	*	0 message is sent to PHP's system logger, using the Operating System's system

	*		logging mechanism or a file, depending on what the error_log configuration

	*		directive is set to.

	*	1 message is sent by email to the address in the destination parameter.

	*		This is the only message type where the fourth parameter, extra_headers is used.

	*		This message type uses the same internal function as mail() does.

	*	2 message is sent through the PHP debugging connection.

	*		This option is only available if remote debugging has been enabled.

	*		In this case, the destination parameter specifies the host name or IP address

	*		and optionally, port number, of the socket receiving the debug information.

	*	3 message is appended to the file destination

	*/

		

	if (defined('ADODB_ERROR_LOG_TYPE')) {

		$t = date('Y-m-d H:i:s');

		if (defined('ADODB_ERROR_LOG_DEST'))

			error_log("($t) $s", ADODB_ERROR_LOG_TYPE, ADODB_ERROR_LOG_DEST);

		else

			error_log("($t) $s", ADODB_ERROR_LOG_TYPE);

	}



	$unique = substr(md5(rand(0, 1000)), 0, 7);

	$errorstring = "";

	$errorstring .= "<div class='dbg' id='" . $unique . "'><span style='font-weight:bold'>".$errmsg."</span> <br />";

	$errorstring .= "<br /><span>SQL Query type: </span><span style='font-weight:bold'>$fn</span><span><br />";

	$errorstring .= "<span>Script: <span style='font-weight:bold'>'{$_SERVER['PHP_SELF']}'</span></span><br />";

	$errorstring .= "<span>SQL Query: <span style='font-weight:bold'>$p1</span></span><br />";

	$errorstring .= "<span>SQL Params: <span style='font-weight:bold'>$p2</span></span><br />";

		

	echo $errorstring . "<hr></div>";

	echo "<script>$('msg-red-debug').setStyle('display', 'block');$('".$unique."').getChildren().injectInside('debug-text');</script>";

	echo "<script>$('".$unique."').getChildren().remove();</script>";

	

	if(!strstr($p1, "_log(type") && !defined("IN_INSTALL"))

		$log = new CSystemLog("e", "sql error", $errmsg . "<br /><br />Query: $p1");

}

?>