Revision = 0; $this->Trace = array(); $this->VersionTable = 'SystemVersion'; $this->InstallMethod = 'FullInstall'; $this->InsertSampleDataMethod = 'InsertSampleData'; } function GetDbVersion() { $DbResult = $this->Database->select($this->VersionTable, '*', 'Id=1'); $Version = $DbResult->fetch_assoc(); return($Version['Revision']); } function IsInstalled() { $DbResult = $this->Database->query('SHOW TABLES LIKE "'.$this->VersionTable.'"'); return($DbResult->num_rows > 0); } function IsUpToDate() { return($this->Revision <= $this->GetDbVersion()); } function Update() { $DbRevision = $this->GetDbVersion(); $Output = 'Počáteční revize databáze: '.$DbRevision.'
'; while($this->Revision > $DbRevision) { $TraceItem = $this->Trace[$DbRevision]; $Output .= 'Aktualizace na verzi: '.$TraceItem['Revision'].'
'; $RevUpdate = $TraceItem['Function']; $RevUpdate($this); $DbRevision = $TraceItem['Revision']; $this->Database->query('UPDATE `'.$this->VersionTable.'` SET `Revision`= '.$TraceItem['Revision'].' WHERE `Id`=1'); } return($Output); } function Install() { $InstallMethod = $this->InstallMethod; $InstallMethod($this); } function Uninstall() { } function InsertSampleData() { $InstallMethod = $this->InsertSampleDataMethod; $InstallMethod($this); } function Execute($Query) { echo($Query.';
'); flush(); return($this->Database->query($Query)); } } class UpdateInterface { var $UpdateManager; var $ConfigDefinition; var $Config; var $DatabaseRevision; var $Revision; var $Updates; function __construct() { } function LoginPanel() { $Output = '

Přihlášení k instalaci

'. '
'. ''. ''. '
Systémové heslo:
'. ''. '
'; return($Output); } function ControlPanel() { $YesNo = array(false => 'Ne', true => 'Ano'); $Output = '

Správa instance

'. 'Je instalováno: '.$YesNo[$this->UpdateManager->IsInstalled()].'
'; if($this->UpdateManager->IsInstalled()) $Output .= 'Je aktuální: '.$YesNo[$this->UpdateManager->IsUpToDate()].'
'. 'Verze databáze: '.$this->UpdateManager->GetDbVersion().'
'; $Output .= 'Verze databáze kódu: '.$this->UpdateManager->Revision.'
'. '
'; if($this->UpdateManager->IsInstalled()) { if(!$this->UpdateManager->IsUpToDate()) $Output .= ' '; $Output .= ' '; $Output .= ' '; } else $Output .= ' '; $Output .= ' '; $Output .= ' '; $Output .= '
'; return($Output); } function Show() { $Output = ' '. ''. ''. 'Správa instance'. ''; if(isset($this->Config)) { if(!array_key_exists('SystemPassword', $_SESSION)) $_SESSION['SystemPassword'] = ''; if(array_key_exists('login', $_POST)) $_SESSION['SystemPassword'] = $_POST['SystemPassword']; if(sha1($_SESSION['SystemPassword']) != $this->Config['SystemPassword']) { $Output .= $this->LoginPanel(); } else { date_default_timezone_set('Europe/Prague'); // SQL injection hack protection foreach($_POST as $Index => $Item) $_POST[$Index] = addslashes($Item); foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($Item); if(isset($_SERVER['REMOTE_ADDR'])) session_start(); $Database = new Database(); $Database->Connect($this->Config['Database']['Host'], $this->Config['Database']['User'], $this->Config['Database']['Password'], $this->Config['Database']['Database']); $Database->Prefix = $this->Config['Database']['Prefix']; $Database->charset($this->Config['Database']['Charset']); $Database->ShowSQLError = $this->Config['Web']['ShowSQLError']; $Database->ShowSQLQuery = $this->Config['Web']['ShowSQLQuery']; $this->UpdateManager = new UpdateManager(); $this->UpdateManager->Database = $Database; $this->UpdateManager->Revision = $this->DatabaseRevision; $this->UpdateManager->Trace = $this->Updates; $this->UpdateManager->InstallMethod = 'FullInstall'; if(array_key_exists('logout', $_POST)) { $_SESSION['SystemPassword'] = ''; $Output .= 'Odhlášen'; $Output .= $this->LoginPanel(); } else if(array_key_exists('update', $_POST)) { $Output .= '

Aktualizace

'; $Output .= $this->UpdateManager->Update(); $Output .= $this->ControlPanel(); } else if(array_key_exists('install', $_POST)) { $Output .= '

Instalace

'; $this->UpdateManager->Install(); $Output .= $this->UpdateManager->Update(); $Output .= $this->ControlPanel(); } else if(array_key_exists('uninstall', $_POST)) { $Output .= '

Odinstalace

'; $this->UpdateManager->Uninstall(); $Output .= $this->ControlPanel(); } else if(array_key_exists('insert_sample_data', $_POST)) { $Output .= '

Vložení vzorových dat

'; $this->UpdateManager->InsertSampleData(); $Output .= $this->ControlPanel(); } else if(array_key_exists('configure_save', $_POST)) { $Output .= $this->ConfigSave($this->Config); $Output .= $this->ControlPanel(); } else if(array_key_exists('configure', $_POST)) { $Output .= $this->PrepareConfig($this->Config); } else { $Output .= $this->ControlPanel(); } } } else { if(array_key_exists('configure_save', $_POST)) { $Output .= $this->ConfigSave(array()); $Output .= 'Pokračujte k přihlášení zde'; } else { $Output .= $this->PrepareConfig(array()); } } $Output .= ''; echo($Output); } function PrepareConfig($Config) { $Output = ''; if(!file_exists('../config.php') and !is_writable('..')) $Output .= 'Varování: Konfigurační soubor nebude možné zapsat, protože složka není povolená pro zápis!'; if(file_exists('../config.php') and !is_writable('../config.php')) $Output .= 'Varování: Konfigurační soubor nebude možné zapsat, protože soubor config.php není povolen pro zápis!'; $Output .= '

Nastavení systému

'. '
'. ''; foreach($this->ConfigDefinition as $Def) { $PathParts = explode('/', $Def['Name']); $TempConfig = &$Config; foreach($PathParts as $Part) if(array_key_exists($Part, $TempConfig)) { $TempConfig = &$TempConfig[$Part]; } if(!is_array($TempConfig)) $Value = $TempConfig; else $Value = $Def['Default']; $Output .= ''. ''. '
'.$Def['Title'].''; if($Def['Type'] == 'String') $Output .= ''; if($Def['Type'] == 'Password') $Output .= ''; if($Def['Type'] == 'Integer') $Output .= ''; if($Def['Type'] == 'Boolean') $Output .= ''; } $Output .= '
'. '
'; return($Output); } function ConfigSave($DefaultConfig) { $Config = $DefaultConfig; foreach($this->ConfigDefinition as $Def) { $Value = null; if($Def['Type'] == 'String') if(array_key_exists($Def['Name'], $_POST)) $Value = $_POST[$Def['Name']]; if($Def['Type'] == 'Password') if(array_key_exists($Def['Name'], $_POST) and ($_POST[$Def['Name']] != '')) $Value = $_POST[$Def['Name']]; if($Def['Type'] == 'Integer') if(array_key_exists($Def['Name'], $_POST)) $Value = $_POST[$Def['Name']]; if($Def['Type'] == 'Boolean') if(array_key_exists($Def['Name'], $_POST)) $Value = $_POST[$Def['Name']]; if(!is_null($Value)) { $PathParts = explode('/', $Def['Name']); $TempConfig = &$Config; foreach($PathParts as $Part) { $TempConfig = &$TempConfig[$Part]; } if(!is_array($TempConfig)) $TempConfig = $Value; else $Value = $Def['Default']; } } $ConfigText = $this->CreateConfig($Config); file_put_contents('../config.php', $ConfigText); $Output .= 'Konfigurace nastavena
'; return($Output); } function CreateConfig($Config) { $Output = "ConfigDefinition as $Def) { $PathParts = explode('/', $Def['Name']); $Output .= "\$Config"; foreach($PathParts as $Part) $Output .= "['".$Part."']"; $TempConfig = &$Config; foreach($PathParts as $Part) if(array_key_exists($Part, $TempConfig)) { $TempConfig = &$TempConfig[$Part]; } if(!is_array($TempConfig)) $Value = $TempConfig; else $Value = $Def['Default']; $Output .= " = '".$Value."';\n"; } $Output .= "\n\n?>"; return($Output); } } ?>