<?php
/**
*
* @	This file is created by http://DeZender.Net
* @	deZender (PHP5 Decoder for ionCube Encoder)
*
* @	Version			:	3.0.8.0
* @	Author			:	DeZender
* @	Release on		:	25.09.2017
* @	Official site	:	http://DeZender.Net
*
*/

function row($caption, $result, $message = '')
{
	global $odd;
	global $diagnostic_output;
	$odd = 1 - $odd;

	if ($result === true) {
		return;
	}

	if ($result === false) {
		$_obfuscate_DVwhJDUcEBcDFCQtNRQJETccFDs3IhE = '#CC5555';
		$_obfuscate_DSsHMggZIhAhLgIZHDALFT00HjEMCSI = 'Failed';
		++$$GLOBALS['errors'];
	}
	else if (is_null( $result )) {
		$_obfuscate_DVwhJDUcEBcDFCQtNRQJETccFDs3IhE = '#EEBB55';
		$_obfuscate_DSsHMggZIhAhLgIZHDALFT00HjEMCSI = 'Warning';
		++$$GLOBALS['warnings'];
	}
	else {
		$_obfuscate_DVwhJDUcEBcDFCQtNRQJETccFDs3IhE = '#CC5555';
		$_obfuscate_DSsHMggZIhAhLgIZHDALFT00HjEMCSI = 'Invalid';
		++$$GLOBALS['errors'];
	}

	$_obfuscate_DSULBzlbNilbBSsoJCs_WzIVBT0iDiI = ((0 < $odd ? '#F0F0F0' : '#E0E0E0'));
	$diagnostic_output .= '<tr style=\'background-color: ' . $_obfuscate_DSULBzlbNilbBSsoJCs_WzIVBT0iDiI . '\'><td>' . $caption . '</td><td style=\'background-color: ' . $_obfuscate_DVwhJDUcEBcDFCQtNRQJETccFDs3IhE . '; color: white; font-weight: bold; text-align: center\'>' . $_obfuscate_DSsHMggZIhAhLgIZHDALFT00HjEMCSI . '</td></tr>';

	if ($message) {
		$diagnostic_output .= '<tr style=\'background-color: ' . $_obfuscate_DSULBzlbNilbBSsoJCs_WzIVBT0iDiI . '\'><td colspan=\'2\' style=\'color: #909090; padding-left: 10px\'>' . $message . '</td></tr>';
	}
}

function load_queries($filename, $convert_engine_to_type = false)
{
	$_obfuscate_DR8SAgwjOzMSBwMhWyIvOx0dCTZbGRE = array(  );
	$_obfuscate_DVsXBRoiCQhbFQIRDwUrJBMSOT8vFDI = file( $filename );

	if (!(is_array( $_obfuscate_DVsXBRoiCQhbFQIRDwUrJBMSOT8vFDI ))) {
		return array(  );
	}

	$_obfuscate_DTUTEgoyKAIzHxYxIxUvPDASHjUGISI = '';

	foreach ($_obfuscate_DVsXBRoiCQhbFQIRDwUrJBMSOT8vFDI as $_obfuscate_DRUULi8QERsGEwEeFjgsEC9bBjIwQDI => $_obfuscate_DTQBQAUjFSYQQDwGPBI5ER4mEzIGGiI) {
		$_obfuscate_DTQBQAUjFSYQQDwGPBI5ER4mEzIGGiI = trim( $_obfuscate_DTQBQAUjFSYQQDwGPBI5ER4mEzIGGiI );

		if (substr( $_obfuscate_DTQBQAUjFSYQQDwGPBI5ER4mEzIGGiI, 0, 2 ) == '--') {
			continue;
		}

		$_obfuscate_DTUTEgoyKAIzHxYxIxUvPDASHjUGISI .= $_obfuscate_DTQBQAUjFSYQQDwGPBI5ER4mEzIGGiI . ' ';

		if (substr( $_obfuscate_DTQBQAUjFSYQQDwGPBI5ER4mEzIGGiI, -1 ) == ';') {
			if ($convert_engine_to_type) {
				if (strtoupper( substr( $_obfuscate_DTUTEgoyKAIzHxYxIxUvPDASHjUGISI, 0, 13 ) ) == 'CREATE TABLE ') {
					$_obfuscate_DTUTEgoyKAIzHxYxIxUvPDASHjUGISI = str_replace( 'ENGINE=MyISAM', 'TYPE=MyISAM', $_obfuscate_DTUTEgoyKAIzHxYxIxUvPDASHjUGISI );
				}
			}

			$_obfuscate_DR8SAgwjOzMSBwMhWyIvOx0dCTZbGRE[] = $_obfuscate_DTUTEgoyKAIzHxYxIxUvPDASHjUGISI;
			$_obfuscate_DTUTEgoyKAIzHxYxIxUvPDASHjUGISI = '';
		}
	}

	return $_obfuscate_DR8SAgwjOzMSBwMhWyIvOx0dCTZbGRE;
}

function install_database($settings)
{
	if (DB_INSTALLED) {
		$settings = array_merge( $settings, array(
			'dbname' => DB_NAME,
			'dbhost' => DB_HOST,
			'dbuser' => DB_USER,
			'dbpass' => DB_PASS
		) );
	}

	try {
		$_obfuscate_DSFbARkvDzcnFj0nJyQNDj8TIxgVFQE = CCSQL::singleton( $settings['dbname'], $settings['dbhost'], $settings['dbuser'], $settings['dbpass'] );
	}
	catch (CSQLException $_obfuscate_DQU4IzYiJTI7KC4KXD4sMwcZOTEhBhE) {
		if (strpos( $_obfuscate_DQU4IzYiJTI7KC4KXD4sMwcZOTEhBhE->getMessage(  ), 'old-passwords' ) !== false) {
			return array( 'Your MySQL user account has been configured using an insecure, old (MySQL v3.x) password format which Centova Cast cannot use.  You can fix this by logging in to your server via SSH and running:' . "\n\n" . '/usr/local/centovacast/bin/mysqlauthfix ' . $settings['dbuser'] . ((($settings['dbhost'] == 'localhost') || ($settings['dbhost'] == '127.0.0.1') ? '' : ' ' . $settings['dbhost'])) . "\n\n" . 'When prompted for the password, enter your MySQL password for the \'' . $settings['dbuser'] . '\' MySQL user to upgrade your password to the newer, secure format.' . "\n\n" . 'After upgrading your password, return to this page to proceed with the installation.' );
		}

		return array( 'Sorry, a database connection could not be established:' . "\n\n" . $_obfuscate_DQU4IzYiJTI7KC4KXD4sMwcZOTEhBhE->getMessage(  ) . "\n\n" . 'Please double-check the database details you specified and try again.' );
	}

	if (!(DB_INSTALLED)) {
............................................................................
.......................................
...................