if(!defined('CEREBRO'))
	exit;

Class MySQL Extends Core
{
	protected static $host;
	protected static $port = 3306;
	protected static $username;
	protected static $password;
	protected static $database;

	private static $r = array();
	private static $last_resource;

	public function __construct($h, $u, $p, $d)
	{
		if(!empty($h) && !empty($u) && !empty($p) && !empty($d))
		{
			self::$host = $h;
			self::$username = $u;
			self::$password = $p;
			self::$database = $d;
		}


		if(!($connect = mysqli_connect(self::$host, self::$username, self::$password)))
			parent::Status(mysql_errno(), 'No se pudo conectar al servidor MySQL', __LINE__, __FILE__);
		elseif(!(@mysql_select_db(self::$database, $connect)))
			parent::Status(mysql_errno(), 'No se pudo seleccionar la base de datos.', __LINE__, __FILE__);

		self::$r['connect'] = $connect;

		return self::$r['connect'];
	}

	public static function Query($q)
	{
		if(isset(self::$r['connect']))
		{
			if(!empty($q))
			{
				$sql = @mysql_query($q) or die(parent::Status(mysql_error(), 'Error'));
				self::$last_resource = $sql;
			}

			return $sql;
		}
		else
			parent::Status('No existe ninguna conexión MySQL para ejecutar la función ' . __FUNCTION__, 'Error');
	}

	public static function Assoc($q = '')
	{
		if(isset(self::$r['connect']))
		{
			if(!empty($q))
				$sql = @mysql_fetch_assoc($q) or die(parent::Status(mysql_error(), 'Error'));
			else
				$sql = @mysql_fetch_assoc(self::$last_resource) or die(parent::Status(mysql_error(), 'Error'));

			return $sql;
		}
		else
			parent::Status('No existe ninguna conexión MySQL para ejecutar la función ' . __FUNCTION__, 'Error');
	}

	public static function Object($q = '')
	{
		if(isset(self::$r['connect']))
		{
			if(!empty($q))
				$sql = @mysql_fetch_object($q) or die(parent::Status(mysql_error(), 'Error'));
			else
				$sql = @mysql_fetch_object(self::$last_resource) or die(parent::Status(mysql_error(), 'Error'));

			return $sql;
		}
		else
			parent::Status('No existe ninguna conexión MySQL para ejecutar la función ' . __FUNCTION__, 'Error');
	}

	public static function Rows($q = '')
	{
		if(isset(self::$r['connect']))
		{
			if(!empty($q))
				$sql = @mysql_num_rows($q);
			else
				$sql = @mysql_num_rows(self::$last_resource);

			return $sql;
		}
		else
			parent::Status('No existe ninguna conexión MySQL para ejecutar la función ' . __FUNCTION__, 'Error');
	}

	public static function EscapeString($q = '')
	{
		if(isset(self::$r['connect']))
		{
			if(!empty($q))
				$sql = @mysql_real_escape_string($q) or die(mysql_error());
			else
				$sql = @mysql_real_escape_string(self::$last_resource) or die(mysql_error());

			return $sql;
		}
		else
			parent::Status('No existe ninguna conexión MySQL para ejecutar la función ' . __FUNCTION__, 'Error');
	}

	public static function Stat()
	{
		if(isset(self::$r['connect']))
		{
			$s = explode('  ', mysql_stat(self::$r['connect']));
			foreach($s as $p => $v)
				echo '
					<div style="background: #ECB7FF;border-radius: 5px;padding: 5px; width: 290px;padding: 5px;margin-bottom: 5px;color: purple;text-shadow: 1px 1px #F7E4FF;border: 1px solid purple;box-shadow: inset 0 0 2px white;box-shadow: 1px 1px 6px lightgray;">
						' . $p . ': ' . $v . '
					</div>';
		}
		else
			parent::Status('No existe ninguna conexi&oacute;n MySQL para ejecutar la funci&oacute;n ' . __FUNCTION__, 'Error');
	}

	public static function Ping()
	{
		if(@mysql_ping(self::$r['connect']) or isset(self::$r['connect']))
			return true;
		else
			return false;
	}

	public static function Get()
	{
		if(isset(self::$r['connect']))
		{
			printf("
				<div style=\"background: #ECB7FF;border-radius: 5px;padding: 5px; width: 290px;padding: 5px;margin-bottom: 5px;color: purple;text-shadow: 1px 1px #F7E4FF;border: 1px solid purple;box-shadow: inset 0 0 2px white;box-shadow: 1px 1px 6px lightgray;\">
					Versi&oacute;n del servidor MySQL: %s\n
				</div>", mysql_get_server_info());
		}
		else
			parent::Status('No existe ninguna conexi&oacute;n MySQL para ejecutar la funci&oacute;n ' . __FUNCTION__, 'Error');
	}

	public static function Insert($t = 'cms_settings', $v)
	{
		$keys = array_keys($v);
		$values = array_values($v);

		if(isset(self::$r['connect']))
			self::Query("INSERT INTO $t (" . implode(',', $keys) . ") VALUES ('" . implode('\',\'', $values) . "')");
		else
			parent::Status('No existe ninguna conexi&oacute;n MySQL para ejecutar la funci&oacute;n ' . __FUNCTION__, 'Error');
	}

	public static function Update($t, $u, $w = '', $l = 1)
	{
		if(!isset(self::$r['connect']))
			parent::Status('No existe ninguna conexi&oacute;n MySQL para ejecutar la funci&oacute;n ' . __FUNCTION__, 'Error');

		if(!is_array($u))
			return false;

		$query = "UPDATE $t SET ";
		$i = 0;

		foreach($u as $key => $value)
		{
			$i++;
			$query .= "$key = '$value'";

			if(count($u) !== $i)
				$query .= ",";
		}

		if(!empty($where))
		{
			$query .= " WHERE ";

			foreach($w as $key)
				$query .= "  $key";
		}

		if($l !== 0)
			$query .= " LIMIT $l";

		return self::Query($query);
	}
}

?>