class.ilDBUpdateEA.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once "./Services/Database/classes/class.ilDBUpdate.php";

class ilDBUpdateEA extends ilDBUpdate
{
        private $hotfix_file_version_ea = 0;
        private $hotfix_current_version_ea = 0;
        
        function hotfixAvailable()
        {
                $hotfixavailable = parent::hotfixAvailable();
                
                $this->readHotfixInfoEA();
                if ($hotfixavailable || $this->hotfix_file_version_ea > $this->hotfix_current_version_ea)
                {
                        return true;
                }
                return false;
        }

        function getHotfixCurrentVersionEA()
        {
                $this->readHotfixInfoEA();
                return $this->hotfix_current_version_ea;
        }

        function setHotfixCurrentVersionEA($a_version)
        {
                $this->readHotfixInfoEA();
                $this->hotfix_setting->set("db_hotfixes_ea", $a_version);
                $this->hotfix_current_version = $a_version;
                return true;
        }

        function getHotfixFileVersionEA()
        {
                $this->readHotfixInfoEA();
                return $this->hotfix_file_version_ea;
        }

        function readHotfixInfoEA($a_force = false)
        {
                if ($this->hotfix_info_read_ea && !$a_force)
                {
                        return;
                }
                include_once './Services/Administration/classes/class.ilSetting.php';
                $GLOBALS["ilDB"] = $this->db;
                $this->hotfix_setting_ea = new ilSetting();
                $hotfix_file = $this->PATH."setup/sql/ilias_ea_dbfixes.php";
                if (is_file($hotfix_file))
                {
                        $this->hotfix_content_ea = @file($hotfix_file);
                        $this->hotfix_current_version_ea = (int) $this->hotfix_setting_ea->get("db_hotfixes_ea");
                        $this->hotfix_file_version_ea = $this->readHotfixFileVersion($this->hotfix_content_ea);
                }
                $this->hotfix_info_read_ea = true;
        }

        function applyUpdateEANr($nr)
        {
                global $ilDB,$ilErr,$ilUser,$ilCtrlStructureReader,$ilModuleReader,$ilMySQLAbstraction;

                //search for desired $nr
                reset($this->filecontent);
                
                //init
                $i = 0;

            //go through filecontent
                while (!ereg("^<#".$nr.">", $this->filecontent[$i]) && $i<count($this->filecontent))
                {
                        $i++;
                }

                //update not found
                if ($i == count($this->filecontent))
                {
                        $this->error = "update_not_found";
                        return false;
                }

                $i++;

                //update found, now extract this update to a new array
                $update = array();
                while ($i<count($this->filecontent) && !ereg("^<#".($nr+1).">", $this->filecontent[$i]))
                {
                        $update[] = trim($this->filecontent[$i]);
                        $i++;
                }

                //now you have the update, now process it
                $sql = array();
                $php = array();
                $mode = "sql";

                foreach ($update as $row)
                {
                        if (ereg("<\?php", $row))
                        {
                                if (count($sql)>0)
                                {
                                        if ($this->execQuery($this->db, implode("\n", $sql)) == false)
                                        {
                                                $this->error = $this->error;
                                                return false;
                                        }
                                        $sql = array();
                                }
                                $mode = "php";
                        }
                        elseif (ereg("\?>", $row))
                        {
                                if (count($php)>0)
                                {
                                        $code = implode("\n", $php);
                                        eval($code);
                                        $php = array();
                                }
                                $mode = "sql";

                        }
                        else
                        {
                                if ($mode == "sql")
                                {
                                        $sql[] = $row;
                                }

                                if ($mode == "php")
                                {
                                        $php[] = $row;
                                }
                        } //else
                } //foreach

                if ($mode == "sql" && count($sql) > 0)
                {
                        if ($this->execQuery($this->db, implode("\n", $sql)) == false)
                        {
                                $this->error = "dump_error: ".$this->error;
                                return false;
                        }
                }
        
                $this->setHotfixCurrentVersionEA($nr);
                
                return true;
                
        }
        
        function getHotfixCurrentVersionAsString()
        {
                if ($this->getHotfixCurrentVersion() > 0 || $this->getHotfixCurrentVersionEA() > 0)
                {
                        return sprintf("ILIAS: %d / EA: %d", $this->getHotfixCurrentVersion(), $this->getHotfixCurrentVersionEA());
                }
                else
                {
                        return "";
                }
        }
        
        function getHotfixFileVersionAsString()
        {
                if ($this->getHotfixFileVersion() > 0 || $this->getHotfixFileVersionEA() > 0)
                {
                        return sprintf("ILIAS: %d / EA: %d", $this->getHotfixFileVersion(), $this->getHotfixFileVersionEA());
                }
                else
                {
                        return "";
                }
        }

        function applyHotfix()
        {
                parent::applyHotfix();
                
                global $ilCtrlStructureReader, $ilMySQLAbstraction;

                include_once './Services/Database/classes/class.ilMySQLAbstraction.php';

                $ilMySQLAbstraction = new ilMySQLAbstraction();
                $GLOBALS['ilMySQLAbstraction'] = $ilMySQLAbstraction;

                $this->readHotfixInfoEA(true);

                $f = $this->getHotfixFileVersionEA();
                $c = $this->getHotfixCurrentVersionEA();

                if ($c < $f)
                {
                        $msg = array();
                        for ($i=($c+1); $i<=$f; $i++)
                        {
                                $this->filecontent = $this->hotfix_content_ea;
                                if ($this->applyUpdateEANr($i) == false)
                                {
                                        $msg[] = array(
                                                "msg" => "update_error: ".$this->error,
                                                "nr" => $i
                                        );
                                        $this->updateMsg = $msg;
                                        return false;
                                }
                                else
                                {
                                        $msg[] = array(
                                                "msg" => "hotfix_applied",
                                                "nr" => $i
                                        );
                                }
                        }

                        $this->updateMsg = $msg;
                }
                else
                {
                        $this->updateMsg = "no_changes";
                }

                return $this->loadXMLInfo();
        }
}