www.phiadvisorypartners.comIQ-ScuritY Shell

Editing file /home/phiadvis/www/old/lib/lib.sql.php (0644)

// ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
//	Realisation Olivier Rocques (c)2005 
//  Reproduction interdite sans autorisation
//  orocques@gmail.com
//  -------------------------------------------------------------------------------------
//	Fonctions d'interface avec MYSQL
// ......................................................................................

define ("DEBUG", ($_GET["debug"] != ""));
	
	require_once(dirname(__file__)."/../constant.php");
	global $cn_r, $cn_w;
	
	// connect
	function connect($host)
	{
		if (! $cn=mysql_connect($host, SQL_USER, SQL_PASSWORD)) 
		{
		   exit;
		}
		if (! mysql_select_db(SQL_DB, $cn))
		{
			exit;
		}
		return $cn;
	}
	
	// disconnect
	function disconnect()
	{
		global $cn_r, $cn_w;
		mysql_close($cn_r);
		mysql_close($cn_w);
		$cn_r = null;
		$cn_w = null;
	}
	
	// sqlexec
	function sqlexec($sql, $silent=false)
	{
		global $cn_r, $cn_w;
		if (DEBUG)
			echo("<div style='font-size:9px; font-family: Tahoma; color:black'>MySQL [".$sql."]</div>");
		if (preg_match("/^select/", $sql))
		{
			if (!$cn_r)
				$cn_r = connect(SQL_HOST_R);
			$cn = $cn_r;
		}
		else
		{
			if (!$cn_w)
				$cn_w = connect(SQL_HOST_W);
			$cn = $cn_w;
		}
		if (!$cn)
			return null;
		if (($res=mysql_query($sql, $cn))==null && !$silent)
		{
			echo mysql_error();
			exit;
		}
//			outmysql_error());
		return $res;
	}
	
	// getsql
	function getsql($sql)
	{
		$rs = sqlexec($sql);

if (!is_resource($rs) || mysql_num_rows($rs) == 0)
			return null;
		
		$row = mysql_fetch_array($rs, MYSQL_NUM);
		$cnt = ((count($row) == 1) ? $row[0] : $row);
		mysql_free_result($rs);
		return ($cnt);
	}

// rowsaffected
	function rowsaffected()
	{
		global $cn_r, $cn_w;
		return (($cn_r || $cn_w) ? mysql_affected_rows() : 0);
	}
?>

IQ-ScuritY Shell