<?php
	function Conectar() 
	{
		$db = mysql_connect('sql.fourdplan.com', 'austral3d', 'kiASpxpzKFkGIAXAcTOm') or die('Could not connect: ' . mysql_error()); 
		mysql_select_db('fourdplan3') or die('Could not select database');
		return $db;
	}
	
	//obtiene el primer atributo del primer  record de la consulta SQL
	function consultar($query)
	{
		$result = mysql_query($query) or die('Query failed: ' . mysql_error());
		$value = mysql_fetch_row($result)[0];
		return $value;
	}
	
	//obtiene la IP del cliente: http://stackoverflow.com/questions/15699101/get-the-client-ip-address-using-php
	function get_client_ip() {
		try 
		{
			$ipaddress = '';
			if (getenv('HTTP_CLIENT_IP'))
				$ipaddress = getenv('HTTP_CLIENT_IP');
			else if(getenv('HTTP_X_FORWARDED_FOR'))
				$ipaddress = getenv('HTTP_X_FORWARDED_FOR');
			else if(getenv('HTTP_X_FORWARDED'))
				$ipaddress = getenv('HTTP_X_FORWARDED');
			else if(getenv('HTTP_FORWARDED_FOR'))
				$ipaddress = getenv('HTTP_FORWARDED_FOR');
			else if(getenv('HTTP_FORWARDED'))
			   $ipaddress = getenv('HTTP_FORWARDED');
			else if(getenv('REMOTE_ADDR'))
				$ipaddress = getenv('REMOTE_ADDR');
			else
				$ipaddress = 'UNKNOWN';
		}
		catch (Exception $e) 
		{
			$ipaddress = 'UNKNOWN';
		}
		return $ipaddress;
	}
	
	function ejecutar($query)
	{
		$result = mysql_query($query) or die('Query failed: ' . mysql_error());
		return $result;
	}
	
 ?>