<?php
/**
*
* @ This file is created by deZender.Net
* @ deZender (PHP5 Decoder for SourceGuardian & phpSHIELD)
*
* @	Version			:	1.1.6.0
* @	Author			:	DeZender
* @	Release on		:	02.06.2013
* @	Official site	:	http://DeZender.Net
*
*/

	if (!session_id(  )) {
		session_start(  );
	}

	require_once( 'locale.php' );
	include_once( 'security.php' );
	include_once( 'display.php' );
	require_once( 'utils.php' );
	include_once( 'checkDate.js' );
	include_once( 'sharedUserAdmin.php' );
	$checkiphone = strpos( $_SERVER['HTTP_USER_AGENT'], 'iPhone' );
	$checkandroid = strpos( $_SERVER['HTTP_USER_AGENT'], 'Android' );
	$checkpalmpre = strpos( $_SERVER['HTTP_USER_AGENT'], 'webOS' );
	$checkberry = strpos( $_SERVER['HTTP_USER_AGENT'], 'BlackBerry' );
	$checknokia = strpos( $_SERVER['HTTP_USER_AGENT'], 'Nokia' );
	$checksonye = strpos( $_SERVER['HTTP_USER_AGENT'], 'SonyEricsson' );
	$checkipod = strpos( $_SERVER['HTTP_USER_AGENT'], 'iPod' );
	$checkipad = strpos( $_SERVER['HTTP_USER_AGENT'], 'iPad' );

	if (( ( ( ( ( ( $checkiphone || $checkandroid ) || $checkipod ) || $checkipad ) || $checknokia ) || $checksonye ) || $checkberry )) {
		header( 'Location: iPhone.php' );
	} else {
		$study = 'study';
		$dir = dirname( $_SERVER['SCRIPT_FILENAME'] );
		$dir = substr( $dir, 0, strlen( $dir ) - 3 );
		$bypass = $dir . 'blank.easyWebpage.code';

		if (( ( file_exists( $bypass ) && !isset( $_GET['settingCookies'] ) ) && strlen( $_GET['pageNumber'] ) == 0 )) {
			$study = '1';
		}

		$dbcon = new MyConnection(  );
		$database = $dbcon->database;
		$username = $dbcon->username;
		$queryexists1 = 'CREATE TABLE IF NOT EXISTS rvaeforward (id int(11) NOT NULL AUTO_INCREMENT, username char(25) NOT NULL, dbname char(255) NOT NULL, status smallint(1) NOT NULL, PRIMARY KEY (`id`))';
		$queryexists2 = 'CREATE TABLE IF NOT EXISTS rvsecurity (id smallint(6) NOT NULL AUTO_INCREMENT, function char(64) NOT NULL, description char(255) NOT NULL, status tinyint(1) DEFAULT NULL, minchar smallint(2) DEFAULT NULL, PRIMARY KEY (`id`))';
		$queryexists3 = 'CREATE TABLE IF NOT EXISTS rviqview (id int(11) NOT NULL AUTO_INCREMENT, function char(64) NOT NULL, description char(255) NOT NULL, status smallint(1) NOT NULL, PRIMARY KEY (`id`))';
		$queryexists4 = 'CREATE TABLE IF NOT EXISTS `rviqviewcall` (id smallint(6) NOT NULL AUTO_INCREMENT, computername char(255) NOT NULL, description char(255) DEFAULT NULL, iqviewurl char(255) DEFAULT NULL, PRIMARY KEY (`id`))';
		$resultCount1 = $dbcon->query( $queryexists1 );
		$resultCount2 = $dbcon->query( $queryexists2 );
		$resultCount3 = $dbcon->query( $queryexists3 );
		$resultCount4 = $dbcon->query( $queryexists4 );
		$resultCount2bb = $dbcon->query( 'SELECT * FROM rviqview' );
		$resultCount2aaa = $dbcon->num_rows( $resultCount2bb );

		if ($resultCount2aaa == 0) {
			$queryinsert2a = 'INSERT INTO rvsecurity (id, function, description, status, minchar) VALUES
(1, \'complexity\', \'Activate the password complexity mode\', 1, NULL),
(2, \'length\', \'Define the minimum number of characters for the password\', 0, 5),
(3, \'uppercase\', \'The password must feature at least one uppercase\', 0, NULL),
(4, \'lowercase\', \'The password must feature at least one lowercase\', 0, NULL),
(5, \'numbers\', \'The password must feature at least one number\', 0, NULL),
(6, \'specialchar\', \'The password must feature at least one special character\', 0, NULL)';
			$resultCountInsert2a = $dbcon->query( $queryinsert2a );
			$queryinsert3a = 'INSERT INTO rviqview (id, function, description, status) VALUES (1, \'iqcall\', \'Active iQ-VIEW call instead of iQ-X\', 1)';
			$resultCountInsert3a = $dbcon->query( $queryinsert3a );
			$todososusers = $dbcon->query( 'SELECT * FROM privilege' );

			while ($rowusers = $dbcon->fetch_row( $todososusers )) {
				$actualuser = $rowusers[0];
				addPrivilege( $database, $actualuser, $error );
			}
		}

		function calculation($checkNumber, $checkFunction) {
			settype( $checkNumber, 'string' );

			if ($checkFunction == 0) {
				$checkRes = 1;
				for  ($i = 0; $i < strlen( $checkNumber ); $i++) {
					$checkRes = $checkRes * $checkNumber[$i];
				}

				$checkRes = $checkRes / $i;
			} else {
				if ($checkFunction == 1) {
					$checkRes = 0;
					for  ($i = 0; $i < strlen( $checkNumber ); $i++) {
						$checkRes = $checkRes + $checkNumber[$i];
					}
				} else {
					return false;
				}
			}

			return $checkRes;
		}

		function getPatientsAge($birthdate) {
			list( $year, $month, $day ) = explode( '-', $birthdate );
			$year_diff = date( 'Y' ) - $year;
			$month_diff = date( 'm' ) - $month;
			$day_diff = date( 'd' ) - $day;

			if (( ( $day_diff < 0 && $month_diff == 0 ) || $month_diff < 0 )) {
				$year_diff--;
			}

			return $year_diff;
		}

		function sortItems($array, $order = 'ASC') {
			if (( is_array( $array ) && 0 < count( $array ) )) {
				foreach (array_keys( $array ) as $key) {
					$temp[$key] = $array[$key];
................................................................
............................
.........