Kimai_Database_Mysql::get_DBversion PHP Method

get_DBversion() public method

returns the version of the installed Kimai database to compare it with the package version
Author: th [0] => version number (x.x.x) [1] => revision number
public get_DBversion ( ) : array
return array
    public function get_DBversion()
    {
        $filter['option'] = MySQL::SQLValue('version');
        $columns[] = "value";
        $table = $this->kga['server_prefix'] . "configuration";
        $result = $this->conn->SelectRows($table, $filter, $columns);
        if ($result == false) {
            // before database revision 1369 (503 + 866)
            $table = $this->kga['server_prefix'] . "var";
            unset($filter);
            $filter['var'] = MySQL::SQLValue('version');
            $result = $this->conn->SelectRows($table, $filter, $columns);
        }
        $row = $this->conn->RowArray(0, MYSQLI_ASSOC);
        $return[] = $row['value'];
        if ($result == false) {
            $return[0] = "0.5.1";
        }
        $filter['option'] = MySQL::SQLValue('revision');
        $result = $this->conn->SelectRows($table, $filter, $columns);
        if ($result == false) {
            // before database revision 1369 (503 + 866)
            unset($filter);
            $filter['var'] = MySQL::SQLValue('revision');
            $result = $this->conn->SelectRows($table, $filter, $columns);
        }
        $row = $this->conn->RowArray(0, MYSQLI_ASSOC);
        $return[] = $row['value'];
        return $return;
    }
Kimai_Database_Mysql