ImpressCMS/impresscms

<?php

class upgrade_2018 {

    var $usedFiles = array( );

    function isApplied() {
        return $this->check_config_type();
    }

    function apply() {
        return $this->apply_alter_tables();
    }

    function check_config_type() {
        $db = $GLOBALS['xoopsDB'];
        $sql = "SHOW COLUMNS FROM " . $db->prefix("config") . " LIKE 'conf_title'";
        $result = $db->queryF( $sql );
        while ($row = $db->fetchArray($result)) {
            if (strtolower( trim($row["Type"]) ) == "varchar(255)") {
                return true;
            }
        }
        return false;
    }

    function query($sql) {
        //echo "<li>" . $sql . "</li>";
        $db = $GLOBALS['xoopsDB'];
        if (!($ret = $db->queryF($sql))) {
            echo "<li style='font-weight: bold; color: red;'>" . $db->error() . "</li>";
        }
    }

    function apply_alter_tables() {
        $db = $GLOBALS['xoopsDB'];
        $this->fields = array(
                        "config" => array(
                                        "conf_title" => "varchar(255) NOT NULL default ''",
                                        "conf_desc"  => "varchar(255) NOT NULL default ''"
                                        ),
                        "configcategory" => array( "confcat_name"  => "varchar(255) NOT NULL default ''" ),
                                        );

                                        foreach ($this->fields as $table => $data) {
                                            foreach ($data as $field => $property) {
                                                $sql = "ALTER TABLE " . $db->prefix($table) . " CHANGE `$field` `$field` $property";
                                                $this->query( $sql );
                                            }
                                        }
                                        return true;
    }
}

$upg = new upgrade_2018();
return $upg;

?>