<?php
	#
	# MySQL-Front Version 3.2.14.3
	# Copyright Copyright (C) 2000-2013
	# PHP tunneling engine
	# This script is used by the Windows GUI MySQL-Front only
	# http://www.mysqlfront.de/
	#

	$VersionStr = '2.0.16';

	error_reporting(E_ERROR | E_PARSE);
	header('Content-Type: application/MySQL-Front');

	function Escape($String) {
		$Result = $String;
		
		$Result = str_replace('\\', '\\\\', $Result);
		$Result = str_replace("\n", '\n', $Result);
		$Result = str_replace("\r", '\r', $Result);
		$Result = str_replace("\0", '\0', $Result);
		$Result = str_replace('"', '\"', $Result);
		
		return '"' . $Result . '"';
	}
	
	foreach(array_keys($_POST) as $Name)
		if ((bool) ini_get('magic_quotes_gpc'))
			$$Name = stripslashes($_POST[$Name]);
		else
			$$Name = $_POST[$Name];
	
	if ($function == 'mysql_real_connect') {
		if (! isset($timeout)) $timeout = 30;
		set_time_limit($timeout);
	}
	else
		set_time_limit(0);
	
	if (version_compare(phpversion(), '4.3.0') >= 0)
		$mysql = mysql_connect($host . ':' . $port, $user, $password, true, (int) $clientflag);
	if (! isset($mysql) || mysql_errno($mysql))
		$mysql = mysql_connect($host . ':' . $port, $user, $password);
	if ($mysql && (mysql_errno($mysql) == 0) && $database)
		mysql_select_db($database, $mysql);
	if ($charset && (version_compare(mysql_get_server_info($mysql), '4.1.1') >= 0))
		mysql_query('SET NAMES ' . $charset . ';', $mysql);
	
	
	if (($function == 'mysql_connect') || ($function == 'mysql_real_connect')) {
		echo 'Tunnel-Info=' . $VersionStr . "\n";
		echo 'Client-Info=' . Escape(mysql_get_client_info($mysql)) . "\n";
		echo 'Host-Info=' . Escape(mysql_get_host_info($mysql)) . "\n";
		echo 'PHP-Info=' . Escape(phpversion()) . "\n";
		echo 'Server-Info=' . Escape(mysql_get_server_info($mysql)) . "\n";
		if (version_compare(mysql_get_server_info($mysql), '4.1.1') < 0) {
			$result = mysql_query('SHOW VARIABLES LIKE \'character_set\';', $mysql);
			if (($Row = mysql_fetch_array($result, MYSQL_NUM)) && $Row[1])
				echo 'Character-Set-Name=' . Escape($Row[1]) . "\n";
		} else {
			$result = mysql_query('SHOW VARIABLES LIKE \'character_set_connection\';', $mysql);
			if (($Row = mysql_fetch_array($result, MYSQL_NUM)) && $Row[1]) {
				$result = mysql_query('SHOW COLLATION LIKE \'' . $Row[1] . '_%\';', $mysql);
				while ($Row = mysql_fetch_array($result, MYSQL_NUM))
					if (strtoupper($Row['Default']) == 'YES')
						echo 'Character-Set-Name=' . Escape($Row['Collation']) . "\n";
			}
		}
	} else {
		for ($q = 0; $q < $query_count; $q++) if (! mysql_errno()) {
			$var_name = 'query_' . $q;
			$query = ereg_replace('\\\\', '\\', $$var_name);
			$result = mysql_query($query, $mysql);
			
			echo "\n";
			
			if ($result) {
				echo 'Errno=' . (int) mysql_errno() . "\n";
				if (mysql_errno())
					echo 'Error=' . Escape(mysql_error()) . "\n";
				echo 'Affected-Rows=' . mysql_affected_rows($mysql) . "\n";
				if (mysql_affected_rows($mysql) >= 0)
					$AffectedRows += mysql_affected_rows($mysql);
				if ((int) mysql_insert_id($mysql) > 0)
					$InsertId = mysql_insert_id($mysql);
				if ((int) mysql_insert_id($mysql) > 0)
					echo 'Insert-Id=' . mysql_insert_id($mysql) . "\n";
				if ((version_compare(phpversion(), '4.3.0') >= 0) && mysql_info())
					echo 'Info=' . Escape(mysql_info()) . "\n";
				
				if (mysql_num_fields($result) > 0) {
					echo "Fields:\n";
					for ($i = 0; $i < mysql_num_fields($result); $i++) {
						$Fields[$i] = mysql_fetch_field($result, $i);
						$Fields[$i]->type = mysql_field_type($result, $i);
						if ($Fields[$i]->type == 'unknown') $Fields[$i]->type = 'float';
						$Fields[$i]->NeedQuoting = ! (($Fields[$i]->type == 'real') || ($Fields[$i]->type == 'float') || ($Fields[$i]->type == 'int') || ($Fields[$i]->type == 'timestamp') || ($Fields[$i]->type == 'year'));
						
						echo 'Name=' . Escape($Fields[$i]->name) . ',';
						echo 'Table=' . Escape($Fields[$i]->table) . ',';
						echo 'Length=' . (int) mysql_field_len($result, $i) . ',';
						if (($Fields[$i]->type == 'real') || ($Fields[$i]->type == 'float')) {
							while (($Row = mysql_fetch_array($result, MYSQL_NUM)) && ! isset($Row[$i])) ;
							if (isset($Row))
								echo 'Decimals=' . (int) (StrLen($Row[$i]) - StrPos($Row[$i], '.') - 1) . ',';
							mysql_data_seek($result, 0);
						}
						echo 'Type=' . $Fields[$i]->type . ',';
						echo 'Max-Length=' . (int) $Fields[$i]->max_length;
						foreach (explode(' ', trim(mysql_field_flags($result, $i))) as $flag)
							if ($flag)
								echo ',Flag=' . $flag;
						echo "\n";
					}
				}

				if (mysql_num_rows($result) > 0) {
					echo "Rows:\n";
					while ($Row = mysql_fetch_array($result, MYSQL_NUM)) {
						for ($i = 0; $i < mysql_num_fields($result); $i++) {
							if ($i > 0) echo ',';
							if (! isset($Row[$i]) && ! $Fields[$i]->not_null)
								echo 'NULL';
							else if ($Fields[$i]->NeedQuoting)
								echo Escape($Row[$i]);
							else
								echo $Row[$i];
						}
						echo "\n";
					}
				}
			}
		}
	}
	
	$PreHeader .= 'Errno=' . (int) mysql_errno() . "\n";
	if (mysql_errno())
		$PreHeader .= 'Error=' . Escape(mysql_error()) . "\n";
	if (isset($AffectedRows))
		$PreHeader .= 'Affected-Rows=' . (int) $AffectedRows . "\n";
	if (isset($InsertId))
		$PreHeader .= 'Insert-Id=' . (int) $InsertId . "\n";
	echo $PreHeader . strlen($PreHeader);
	
	mysql_close($mysql);
?>