Example #1
0
 $_CONF['path_data'] = $gl_path . 'data/';
 $config->set('path_images', $html_path . 'images/');
 $_CONF['path_images'] = $html_path . 'images/';
 $config->set('path_themes', $html_path . 'layout/');
 $_CONF['path_themes'] = $html_path . 'layout/';
 $config->set('path_editors', $html_path . 'editors/');
 $_CONF['path_editors'] = $html_path . 'editors/';
 $config->set('rdf_file', $html_path . 'backend/geeklog.rss');
 $_CONF['rdf_file'] = $html_path . 'backend/geeklog.rss';
 $config->set('path_pear', $_CONF['path_system'] . 'pear/');
 $_CONF['path_pear'] = $_CONF['path_system'] . 'pear/';
 // reset cookie domain and path as wrong values may prevent login
 $config->set('cookiedomain', '');
 $_CONF['cookiedomain'] = '';
 $config->set('cookie_path', INST_guessCookiePath($_CONF['site_url']));
 $_CONF['cookie_path'] = INST_guessCookiePath($_CONF['site_url']);
 if (substr($_CONF['site_url'], 0, 6) == 'https:') {
     $config->set('cookiesecure', true);
     $_CONF['cookiesecure'] = 1;
 } else {
     $config->set('cookiesecure', false);
     $_CONF['cookiesecure'] = 0;
 }
 // check the default theme
 $theme = '';
 if (empty($_CONF['theme'])) {
     // try old conf value
     $theme = $_OLD_CONF['theme'];
 } else {
     $theme = $_CONF['theme'];
 }
Example #2
0
 /**
  * Do a sanity check on the paths and URLs
  * This is somewhat speculative but should provide the user with a working
  * site even if, for example, a site backup was installed elsewhere.
  *
  * @param    string $path           proper /path/to/Geeklog
  * @param    string $path_html      path to public_html
  * @param    string $site_url       The site's URL
  * @param    string $site_admin_url URL to the admin directory
  */
 private function fixPathsAndUrls($path, $path_html, $site_url, $site_admin_url)
 {
     require_once $path . 'system/classes/config.class.php';
     $config = config::get_instance();
     $config->set_configfile($path . 'db-config.php');
     $config->load_baseconfig();
     $config->initConfig();
     $_CONF = $config->get_config('Core');
     clearstatcache();
     if (!file_exists($_CONF['path_log'] . 'error.log')) {
         $config->set('path_log', $path . 'logs/');
     }
     if (!file_exists($_CONF['path_language'] . $_CONF['language'] . '.php')) {
         $config->set('path_language', $path . 'language/');
     }
     if (!file_exists($_CONF['backup_path'])) {
         $config->set('backup_path', $path . 'backups/');
     }
     if (!file_exists($_CONF['path_data'])) {
         $config->set('path_data', $path . 'data/');
     }
     if (!$_CONF['have_pear'] && !file_exists($_CONF['path_pear'] . 'PEAR.php')) {
         $config->set('path_pear', $path . 'system/pear/');
     }
     if (!file_exists($_CONF['path_html'] . 'lib-common.php')) {
         $config->set('path_html', $path_html);
     }
     if (!file_exists($_CONF['path_themes'] . $_CONF['theme'] . '/header.thtml')) {
         $config->set('path_themes', $path_html . 'layout/');
         if (!file_exists($path_html . 'layout/' . $_CONF['theme'] . '/header.thtml')) {
             $config->set('theme', 'professional');
         }
     }
     if (!file_exists($_CONF['path_images'] . 'articles')) {
         $config->set('path_images', $path_html . 'images/');
     }
     if (!file_exists($_CONF['path_editors'] . 'ckeditor')) {
         $config->set('path_editors', $path_html . 'editors/');
     }
     if (substr($_CONF['rdf_file'], strlen($path_html)) != $path_html) {
         // this may not be correct but neither was the old value apparently ...
         $config->set('rdf_file', $path_html . 'backend/geeklog.rss');
     }
     if (!empty($site_url) && $_CONF['site_url'] != $site_url) {
         $config->set('site_url', $site_url);
         // if we had to fix the site's URL, chances are that cookie domain
         // and path are also wrong and the user won't be able to log in
         $config->set('cookiedomain', '');
         $config->set('cookie_path', INST_guessCookiePath($site_url));
     }
     if (!empty($site_admin_url) && $_CONF['site_admin_url'] != $site_admin_url) {
         $config->set('site_admin_url', $site_admin_url);
     }
 }
Example #3
0
/**
 * Installer engine
 *
 * The guts of the installation and upgrade package.
 *
 * @param   string  $install_type   'install' or 'upgrade'
 * @param   int     $install_step   1 - 4
 */
function INST_installEngine($install_type, $install_step)
{
    global $_CONF, $_TABLES, $LANG_INSTALL, $LANG_CHARSET, $_DB, $_DB_dbms, $_DB_table_prefix, $_URL, $gl_path, $html_path, $dbconfig_path, $siteconfig_path, $display, $language, $form_label_dir, $use_innodb;
    switch ($install_step) {
        /**
         * Page 1 - Enter Geeklog config information
         */
        case 1:
            require_once $dbconfig_path;
            // Get the current DB info
            if ($install_type == 'upgrade') {
                $v = INST_checkPost150Upgrade($dbconfig_path, $siteconfig_path);
                // will skip to step 3 if possible, otherwise return here
                if ($v == VERSION) {
                    // looks like we're already up to date
                    $display .= '<h2>' . $LANG_INSTALL[74] . '</h2>' . LB . '<p>' . $LANG_INSTALL[75] . '</p>';
                    return;
                }
            }
            $display .= '<h1 class="heading">' . $LANG_INSTALL[101] . ' ' . htmlspecialchars($_REQUEST['display_step']) . ' - ' . $LANG_INSTALL[102] . '</h1>' . LB;
            // Set all the form values either with their defaults or with received POST data.
            // The only instance where you'd get POST data would be if the user has to
            // go back because they entered incorrect database information.
            $site_name = isset($_POST['site_name']) ? str_replace('\\', '', $_POST['site_name']) : $LANG_INSTALL[29];
            $site_slogan = isset($_POST['site_slogan']) ? str_replace('\\', '', $_POST['site_slogan']) : $LANG_INSTALL[30];
            $db_selected = '';
            if (isset($_POST['db_type'])) {
                switch ($_POST['db_type']) {
                    case 'mysql-innodb':
                        $db_selected = 'mysql-innodb';
                        break;
                    case 'mssql':
                        $db_selected = 'mssql';
                        break;
                    case 'pgsql':
                        $db_selected = 'pgsql';
                        break;
                    default:
                        $db_selected = 'mysql';
                        break;
                }
            } else {
                switch ($_DB_dbms) {
                    case 'mssql':
                        $db_selected = 'mssql';
                        break;
                    case 'pgsql':
                        $db_selected = 'pgsql';
                        break;
                    default:
                        $db_selected = 'mysql';
                        break;
                }
            }
            if ($_DB_host != 'localhost' || $_DB_name != 'geeklog' || $_DB_user != 'username' || $_DB_pass != 'password') {
                // only display those if they all have their default values
                $_DB_host = '';
                $_DB_name = '';
                $_DB_user = '';
                $_DB_pass = '';
            }
            $db_host = isset($_POST['db_host']) ? $_POST['db_host'] : ($_DB_host != 'localhost' ? '' : $_DB_host);
            $db_name = isset($_POST['db_name']) ? $_POST['db_name'] : ($_DB_name != 'geeklog' ? '' : $_DB_name);
            $db_user = isset($_POST['db_user']) ? $_POST['db_user'] : ($_DB_user != 'username' ? '' : $_DB_user);
            $db_pass = isset($_POST['db_pass']) ? $_POST['db_pass'] : '';
            $db_prefix = isset($_POST['db_prefix']) ? $_POST['db_prefix'] : $_DB_table_prefix;
            $site_url = isset($_POST['site_url']) ? $_POST['site_url'] : INST_getSiteUrl();
            $site_admin_url = isset($_POST['site_admin_url']) ? $_POST['site_admin_url'] : INST_getSiteAdminUrl();
            $host_name = explode(':', $_SERVER['HTTP_HOST']);
            $host_name = $host_name[0];
            if (empty($_CONF['site_mail'])) {
                $_CONF['site_mail'] = '*****@*****.**';
            }
            $site_mail = isset($_POST['site_mail']) ? $_POST['site_mail'] : ($_CONF['site_mail'] != '*****@*****.**' ? $_CONF['site_mail'] : 'admin@' . $host_name);
            if (empty($_CONF['noreply_mail'])) {
                $_CONF['noreply_mail'] = '*****@*****.**';
            }
            $noreply_mail = isset($_POST['noreply_mail']) ? $_POST['noreply_mail'] : ($_CONF['noreply_mail'] != '*****@*****.**' ? $_CONF['noreply_mail'] : 'noreply@' . $host_name);
            if (isset($_POST['utf8']) && $_POST['utf8'] == 'on') {
                $utf8 = true;
            } else {
                $utf8 = false;
                if (strcasecmp($LANG_CHARSET, 'utf-8') == 0) {
                    $utf8 = true;
                }
            }
            if ($install_type == 'install') {
                $buttontext = $LANG_INSTALL[50];
            } else {
                $buttontext = $LANG_INSTALL[25];
            }
            $display .= '<h2>' . $LANG_INSTALL[31] . '</h2>
            <form action="index.php" method="post" name="install">
            <input type="hidden" name="mode" value="' . htmlspecialchars($install_type) . '"' . XHTML . '>
            <input type="hidden" name="step" value="2"' . XHTML . '>
            <input type="hidden" name="display_step" value="' . htmlspecialchars($_REQUEST['display_step']) . '"' . XHTML . '>
            <input type="hidden" name="language" value="' . $language . '"' . XHTML . '>
            <input type="hidden" name="dbconfig_path" value="' . htmlspecialchars($dbconfig_path) . '"' . XHTML . '>

            <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[32] . ' ' . INST_helpLink('site_name') . '</label> <input type="text" name="site_name" value="' . htmlspecialchars($site_name) . '" size="40"' . XHTML . '></p>
            <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[33] . ' ' . INST_helpLink('site_slogan') . '</label> <input type="text" name="site_slogan" value="' . htmlspecialchars($site_slogan) . '" size="40"' . XHTML . '></p>
            <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[34] . ' ' . INST_helpLink('db_type') . '</label> ' . INST_listOfSupportedDBs($dbconfig_path, $db_selected, $install_type == 'install' ? true : false) . '</p>
            <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[39] . ' ' . INST_helpLink('db_host') . '</label> <input type="text" name="db_host" value="' . htmlspecialchars($db_host) . '" size="20"' . XHTML . '></p>
            <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[40] . ' ' . INST_helpLink('db_name') . '</label> <input type="text" name="db_name" value="' . htmlspecialchars($db_name) . '" size="20"' . XHTML . '></p>
            <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[41] . ' ' . INST_helpLink('db_user') . '</label> <input type="text" name="db_user" value="' . htmlspecialchars($db_user) . '" size="20"' . XHTML . '></p>
            <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[42] . ' ' . INST_helpLink('db_pass') . '</label> <input type="password" name="db_pass" value="' . $db_pass . '" size="20"' . XHTML . '></p>
            <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[43] . ' ' . INST_helpLink('db_prefix') . '</label> <input type="text" name="db_prefix" value="' . htmlspecialchars($db_prefix) . '" size="20"' . XHTML . '></p>

            <br' . XHTML . '>
            <h2>' . $LANG_INSTALL[44] . '</h2>
            <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[45] . ' ' . INST_helpLink('site_url') . '</label> <input type="text" name="site_url" value="' . htmlspecialchars($site_url) . '" size="50"' . XHTML . '>  &nbsp; ' . $LANG_INSTALL[46] . '</p>
            <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[47] . ' ' . INST_helpLink('site_admin_url') . '</label> <input type="text" name="site_admin_url" value="' . htmlspecialchars($site_admin_url) . '" size="50"' . XHTML . '>  &nbsp; ' . $LANG_INSTALL[46] . '</p>
            <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[48] . ' ' . INST_helpLink('site_mail') . '</label> <input type="text" name="site_mail" value="' . htmlspecialchars($site_mail) . '" size="50"' . XHTML . '></p>
            <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[49] . ' ' . INST_helpLink('noreply_mail') . '</label> <input type="text" name="noreply_mail" value="' . htmlspecialchars($noreply_mail) . '" size="50"' . XHTML . '></p>';
            if ($install_type == 'install') {
                $display .= '
                <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[92] . ' ' . INST_helpLink('utf8') . '</label> <input type="checkbox" name="utf8"' . ($utf8 ? ' checked="checked"' : '') . XHTML . '></p>';
            }
            $display .= '<br' . XHTML . '>
            <input type="submit" name="submit" class="submit button big-button" value="' . $buttontext . ' &gt;&gt;"' . XHTML . '>
            <input type="submit" name="install_plugins" class="submit button big-button" value="' . $buttontext . ' ' . $LANG_INSTALL[103] . ' &gt;&gt;"' . XHTML . '>
            </form>' . LB;
            break;
            /**
             * Page 2 - Enter information into db-config.php
             * and ask about InnoDB tables (if supported)
             */
        /**
         * Page 2 - Enter information into db-config.php
         * and ask about InnoDB tables (if supported)
         */
        case 2:
            // Set all the variables from the received POST data.
            $site_name = $_POST['site_name'];
            $site_slogan = $_POST['site_slogan'];
            $site_url = $_POST['site_url'];
            $site_admin_url = $_POST['site_admin_url'];
            $site_mail = $_POST['site_mail'];
            $noreply_mail = $_POST['noreply_mail'];
            $utf8 = isset($_POST['utf8']) && $_POST['utf8'] == 'on' ? true : false;
            $install_plugins = isset($_POST['install_plugins']) ? true : false;
            $DB = array('type' => $_POST['db_type'], 'host' => $_POST['db_host'], 'name' => $_POST['db_name'], 'user' => $_POST['db_user'], 'pass' => $_POST['db_pass'], 'table_prefix' => $_POST['db_prefix']);
            // Check if $site_admin_url is correct
            if (!INST_urlExists($site_admin_url)) {
                $display .= '<h2>' . $LANG_INSTALL[104] . '</h2><p>' . $LANG_INSTALL[105] . '</p>' . INST_showReturnFormData($_POST) . LB;
                // Check for blank password in production environment
            } else {
                if (!INST_dbPasswordCheck($site_url, $DB)) {
                    $display .= '<h2>' . $LANG_INSTALL[54] . '</h2><p>' . $LANG_INSTALL[107] . '</p>' . INST_showReturnFormData($_POST) . LB;
                    // Check if we can connect to the database
                } else {
                    if (!INST_dbConnect($DB)) {
                        $display .= '<h2>' . $LANG_INSTALL[54] . '</h2><p>' . $LANG_INSTALL[55] . '</p>' . INST_showReturnFormData($_POST) . LB;
                        // Check if the user's version of MySQL is out of date
                    } else {
                        if (INST_mysqlOutOfDate($DB)) {
                            $myv = mysql_v($DB['host'], $DB['user'], $DB['pass']);
                            $display .= '<h1>' . sprintf($LANG_INSTALL[51], SUPPORTED_MYSQL_VER) . '</h1>' . LB;
                            $display .= '<p>' . sprintf($LANG_INSTALL[52], SUPPORTED_MYSQL_VER) . $myv[0] . '.' . $myv[1] . '.' . $myv[2] . $LANG_INSTALL[53] . '</p>' . LB;
                            // Check if database doesn't exist
                        } else {
                            if (!INST_dbExists($DB)) {
                                $display .= '<h2>' . $LANG_INSTALL[56] . '</h2><p>' . $LANG_INSTALL[57] . '</p>' . INST_showReturnFormData($_POST) . LB;
                            } else {
                                // Write the database info to db-config.php
                                if (!INST_writeConfig($dbconfig_path, $DB)) {
                                    exit($LANG_INSTALL[26] . ' ' . htmlspecialchars($dbconfig_path) . $LANG_INSTALL[58]);
                                }
                                // for the default charset, patch siteconfig.php again
                                if ($install_type != 'upgrade') {
                                    if (!INST_setDefaultCharset($siteconfig_path, $utf8 ? 'utf-8' : $LANG_CHARSET)) {
                                        exit($LANG_INSTALL[26] . ' ' . $siteconfig_path . $LANG_INSTALL[58]);
                                    }
                                }
                                require $dbconfig_path;
                                require_once $siteconfig_path;
                                require_once $_CONF['path_system'] . 'lib-database.php';
                                $req_string = 'index.php?mode=' . $install_type . '&step=3&dbconfig_path=' . urlencode($dbconfig_path) . '&install_plugins=' . $install_plugins . '&language=' . $language . '&site_name=' . urlencode($site_name) . '&site_slogan=' . urlencode($site_slogan) . '&site_url=' . urlencode($site_url) . '&site_admin_url=' . urlencode($site_admin_url) . '&site_mail=' . urlencode($site_mail) . '&noreply_mail=' . urlencode($noreply_mail);
                                if ($utf8) {
                                    $req_string .= '&utf8=true';
                                }
                                switch ($install_type) {
                                    case 'install':
                                        $hidden_fields = '<input type="hidden" name="mode" value="' . $install_type . '"' . XHTML . '>
                            <input type="hidden" name="language" value="' . $language . '"' . XHTML . '>
                            <input type="hidden" name="dbconfig_path" value="' . htmlspecialchars($dbconfig_path) . '"' . XHTML . '>
                            <input type="hidden" name="site_name" value="' . urlencode($site_name) . '"' . XHTML . '>
                            <input type="hidden" name="site_slogan" value="' . urlencode($site_slogan) . '"' . XHTML . '>
                            <input type="hidden" name="site_url" value="' . urlencode($site_url) . '"' . XHTML . '>
                            <input type="hidden" name="site_admin_url" value="' . urlencode($site_admin_url) . '"' . XHTML . '>
                            <input type="hidden" name="site_mail" value="' . urlencode($site_mail) . '"' . XHTML . '>
                            <input type="hidden" name="noreply_mail" value="' . urlencode($noreply_mail) . '"' . XHTML . '>
                            <input type="hidden" name="utf8" value="' . ($utf8 ? 'true' : 'false') . '"' . XHTML . '>';
                                        // If using MySQL check to see if InnoDB is supported
                                        if ($DB['type'] == 'mysql-innodb' && !INST_innodbSupported()) {
                                            // Warn that InnoDB tables are not supported
                                            $display .= '<h2>' . $LANG_INSTALL[59] . '</h2>
                    <p>' . $LANG_INSTALL['60'] . '</p>

                    <br' . XHTML . '>
                    <div style="margin-left: auto; margin-right: auto; width: 125px">
                        <div style="position: relative; right: 10px">
                            <form action="index.php" method="post">
                            <input type="hidden" name="language" value="' . $language . '"' . XHTML . '>
                            <input type="hidden" name="step" value="1"' . XHTML . '>
                            ' . $hidden_fields . '
                            <input type="submit" class="button big-button" value="&lt;&lt; ' . $LANG_INSTALL[61] . '"' . XHTML . '>
                            </form>
                        </div>

                        <div style="position: relative; left: 65px; top: -27px">
                            <form action="index.php" method="post">
                            <input type="hidden" name="language" value="' . $language . '"' . XHTML . '>
                            <input type="hidden" name="step" value="3"' . XHTML . '>
                            ' . $hidden_fields . '
                            <input type="hidden" name="innodb" value="false"' . XHTML . '>
                            <input type="submit" class="button big-button" name="submit" value="' . $LANG_INSTALL[62] . ' &gt;&gt;"' . XHTML . '>
                            </form>
                        </div>
                    </div>' . LB;
                                        } else {
                                            // Continue on to step 3 where the installation will happen
                                            if ($DB['type'] == 'mysql-innodb') {
                                                $req_string .= '&innodb=true';
                                            }
                                            header('Location: ' . $req_string);
                                        }
                                        break;
                                    case 'upgrade':
                                        // Try and find out what the current version of GL is
                                        $curv = INST_identifyGeeklogVersion();
                                        if ($curv == VERSION) {
                                            // If current version is the newest version
                                            // then there's no need to update.
                                            $display .= '<h2>' . $LANG_INSTALL[74] . '</h2>' . LB . '<p>' . $LANG_INSTALL[75] . '</p>';
                                        } elseif ($curv == 'empty') {
                                            $display .= '<h2>' . $LANG_INSTALL[90] . '</h2>' . LB . '<p>' . $LANG_INSTALL[91] . '</p>';
                                        } else {
                                            $old_versions = array('1.2.5-1', '1.3', '1.3.1', '1.3.2', '1.3.2-1', '1.3.3', '1.3.4', '1.3.5', '1.3.6', '1.3.7', '1.3.8', '1.3.9', '1.3.10', '1.3.11', '1.4.0', '1.4.1', '1.5.0', '1.5.1', '1.5.2', '1.6.0', '1.6.1', '1.7.0', '1.7.1', '1.7.2');
                                            if (empty($curv)) {
                                                // If we were unable to determine the current GL
                                                // version is then ask the user what it is
                                                $display .= '<h2>' . $LANG_INSTALL[76] . '</h2>
                            <p>' . $LANG_INSTALL[77] . '</p>
                            <form action="index.php" method="post">
                            <input type="hidden" name="mode" value="upgrade"' . XHTML . '>
                            <input type="hidden" name="step" value="3"' . XHTML . '>
                            <input type="hidden" name="dbconfig_path" value="' . htmlspecialchars($dbconfig_path) . '"' . XHTML . '>
                            <p><label class="' . $form_label_dir . '">' . $LANG_INSTALL[89] . '</label> <select name="version">';
                                                $tmp_counter = 0;
                                                $ver_selected = '';
                                                foreach ($old_versions as $version) {
                                                    if ($tmp_counter == count($old_versions) - 1) {
                                                        $ver_selected = ' selected="selected"';
                                                    }
                                                    $display .= LB . '<option' . $ver_selected . '>' . $version . '</option>';
                                                    $tmp_counter++;
                                                }
                                                $display .= '</select></p>
                            <br' . XHTML . '>
                            <input type="submit" name="submit" class="submit button big-button" value="' . $LANG_INSTALL[25] . ' &gt;&gt;"' . XHTML . '>
                            </form>' . LB;
                                                $curv = $old_versions[count($old_versions) - 1];
                                            } else {
                                                // Continue on to step 3 where the upgrade will happen
                                                header('Location: ' . $req_string . '&version=' . $curv);
                                            }
                                        }
                                        break;
                                }
                            }
                        }
                    }
                }
            }
            break;
            /**
             * Page 3 - Install
             */
        /**
         * Page 3 - Install
         */
        case 3:
            $gl_path = str_replace('db-config.php', '', $dbconfig_path);
            $install_plugins = isset($_REQUEST['install_plugins']) && !empty($_REQUEST['install_plugins']) ? true : false;
            $next_link = $install_plugins ? 'install-plugins.php?language=' . $language : 'success.php?type=' . $install_type . '&language=' . $language;
            switch ($install_type) {
                case 'install':
                    if (isset($_POST['submit']) && $_POST['submit'] == '<< ' . $LANG_INSTALL[61]) {
                        header('Location: index.php?mode=install');
                    }
                    // Check whether to use InnoDB tables
                    $use_innodb = false;
                    if (isset($_POST['innodb']) && $_POST['innodb'] == 'true' || isset($_GET['innodb']) && $_GET['innodb'] == 'true') {
                        $use_innodb = true;
                    }
                    $utf8 = false;
                    if (isset($_POST['utf8']) && $_POST['utf8'] == 'true' || isset($_GET['utf8']) && $_GET['utf8'] == 'true') {
                        $utf8 = true;
                    }
                    // We need all this just to do one DB query
                    require_once $dbconfig_path;
                    require_once $siteconfig_path;
                    require_once $_CONF['path_system'] . 'lib-database.php';
                    if ($_DB_dbms == 'pgsql') {
                        //Create a func to check if plpgsql is already installed
                        DB_query("CREATE OR REPLACE FUNCTION make_plpgsql()\n                    RETURNS VOID LANGUAGE SQL AS \$\$\n                    CREATE LANGUAGE plpgsql;\n                    \$\$;\n                    SELECT\n                        CASE\n                        WHEN EXISTS( SELECT 1 FROM pg_catalog.pg_language WHERE lanname='plpgsql')\n                        THEN NULL\n                        ELSE make_plpgsql() END;");
                        //Create a function to check if table exists
                        DB_query("CREATE OR REPLACE FUNCTION check_table(varchar, varchar)\n                        RETURNS boolean AS \$\$\n                         DECLARE\n                           v_cnt integer;\n                           v_tbl boolean;\n                         BEGIN\n                           SELECT count(1) INTO v_cnt FROM pg_tables where tablename = \$1 and\n                        schemaname = \$2;\n                            IF v_cnt > 0 THEN\n                             v_tbl = 'true';\n                            END IF;\n                        return v_tbl;\n                        END;\n                        \$\$ LANGUAGE 'plpgsql'");
                    }
                    // Check if GL is already installed
                    if (INST_checkTableExists('vars')) {
                        $display .= '<p>' . $LANG_INSTALL[63] . '</p>
                        <ol>
                            <li>' . $LANG_INSTALL[64] . '</li>
                            <li>' . $LANG_INSTALL[65] . '</li>
                        </ol>

                        <div style="margin-left: auto; margin-right: auto; width: 175px">
                            <div style="position: absolute">
                                <form action="index.php" method="post">
                                <input type="hidden" name="mode" value="install"' . XHTML . '>
                                <input type="hidden" name="step" value="3"' . XHTML . '>
                                <input type="hidden" value="' . $language . '"' . XHTML . '>
                                <input type="hidden" name="dbconfig_path" value="' . htmlspecialchars($dbconfig_path) . '"' . XHTML . '>
                                <input type="hidden" name="innodb" value="' . ($use_innodb ? 'true' : 'false') . '"' . XHTML . '>
                                <input type="hidden" name="install_plugins" value="' . $install_plugins . '"' . XHTML . '>
                                <input type="submit" class="button big-button" value="' . $LANG_INSTALL[66] . '"' . XHTML . '>
                                </form>
                            </div>

                            <div style="position: relative; left: 105px; top: 5px">
                                <form action="index.php" method="post">
                                <input type="hidden" name="mode" value="upgrade"' . XHTML . '>
                                <input type="hidden" name="language" value="' . $language . '"' . XHTML . '>
                                <input type="hidden" name="dbconfig_path" value="' . htmlspecialchars($dbconfig_path) . '"' . XHTML . '>
                                <input type="submit" class="button big-button" value="' . $LANG_INSTALL[25] . '"' . XHTML . '>
                                </form>
                            </div>
                        </div>
                        ' . LB;
                    } else {
                        if (INST_createDatabaseStructures()) {
                            $site_name = isset($_POST['site_name']) ? $_POST['site_name'] : (isset($_GET['site_name']) ? $_GET['site_name'] : '');
                            $site_slogan = isset($_POST['site_slogan']) ? $_POST['site_slogan'] : (isset($_GET['site_slogan']) ? $_GET['site_slogan'] : '');
                            $site_url = isset($_POST['site_url']) ? $_POST['site_url'] : (isset($_GET['site_url']) ? $_GET['site_url'] : '');
                            $site_admin_url = isset($_POST['site_admin_url']) ? $_POST['site_admin_url'] : (isset($_GET['site_admin_url']) ? $_GET['site_admin_url'] : '');
                            $site_mail = isset($_POST['site_mail']) ? $_POST['site_mail'] : (isset($_GET['site_mail']) ? $_GET['site_mail'] : '');
                            $noreply_mail = isset($_POST['noreply_mail']) ? $_POST['noreply_mail'] : (isset($_GET['noreply_mail']) ? $_GET['noreply_mail'] : '');
                            INST_personalizeAdminAccount($site_mail, $site_url);
                            // Insert the form data into the conf_values table
                            $site_name = urldecode($site_name);
                            $site_name = INST_cleanString($site_name);
                            $site_slogan = urldecode($site_slogan);
                            $site_slogan = INST_cleanString($site_slogan);
                            require_once $_CONF['path_system'] . 'classes/config.class.php';
                            require_once 'config-install.php';
                            install_config();
                            $config = config::get_instance();
                            $config->set('site_name', $site_name);
                            $config->set('site_slogan', $site_slogan);
                            $config->set('site_url', urldecode($site_url));
                            $config->set('site_admin_url', urldecode($site_admin_url));
                            $config->set('site_mail', urldecode($site_mail));
                            $config->set('noreply_mail', urldecode($noreply_mail));
                            $config->set('path_html', $html_path);
                            $config->set('path_log', $gl_path . 'logs/');
                            $config->set('path_language', $gl_path . 'language/');
                            $config->set('backup_path', $gl_path . 'backups/');
                            $config->set('path_data', $gl_path . 'data/');
                            $config->set('path_images', $html_path . 'images/');
                            $config->set('path_themes', $html_path . 'layout/');
                            $config->set('path_editors', $html_path . 'editors/');
                            $config->set('rdf_file', $html_path . 'backend/geeklog.rss');
                            $config->set('path_pear', $_CONF['path_system'] . 'pear/');
                            $config->set('cookie_path', INST_guessCookiePath(urldecode($site_url)));
                            $config->set_default('default_photo', urldecode($site_url) . '/default.jpg');
                            $lng = INST_getDefaultLanguage($gl_path . 'language/', $language, $utf8);
                            if (!empty($lng)) {
                                $config->set('language', $lng);
                            }
                            INST_setVersion($siteconfig_path);
                            if (!$install_plugins) {
                                // do a default install of all available plugins
                                /**
                                 * For the plugin install we would actually need
                                 * lib-common.php in the global namespace. Since
                                 * we're in a function, we need to hack a few
                                 * things and rely on a few global declarations
                                 * (see beginning of function).
                                 */
                                // Hack: not needed here - avoid notice
                                $_DB_mysqldump_path = '';
                                // Hack: lib-common will overwrite $language
                                $lx_inst = $language;
                                require_once '../../lib-common.php';
                                $language = $lx_inst;
                                INST_defaultPluginInstall();
                            }
                            // Installation is complete. Continue onto either
                            // custom plugin installation page or success page
                            header('Location: ' . $next_link);
                        } else {
                            $display .= "<h2>" . $LANG_INSTALL[67] . "</h2><p>" . $LANG_INSTALL[68] . "</p>";
                        }
                    }
                    break;
                case 'upgrade':
                    // Get and set which version to display
                    $version = '';
                    if (isset($_GET['version'])) {
                        $version = $_GET['version'];
                    } else {
                        if (isset($_POST['version'])) {
                            $version = $_POST['version'];
                        }
                    }
                    // Let's do this
                    require_once $dbconfig_path;
                    require_once $siteconfig_path;
                    require_once $_CONF['path_system'] . 'lib-database.php';
                    // If this is a MySQL database check to see if it was
                    // installed with InnoDB support
                    if ($_DB_dbms == 'mysql') {
                        // Query `vars` and see if 'database_engine' == 'InnoDB'
                        $result = DB_query("SELECT `name`,`value` FROM {$_TABLES['vars']} WHERE `name`='database_engine'");
                        $row = DB_fetchArray($result);
                        if ($row['value'] == 'InnoDB') {
                            $use_innodb = true;
                        } else {
                            $use_innodb = false;
                        }
                    }
                    if (INST_doDatabaseUpgrades($version)) {
                        if (version_compare($version, '1.5.0') == -1) {
                            // After updating the database we'll want to update some of the information from the form.
                            $site_name = isset($_POST['site_name']) ? $_POST['site_name'] : (isset($_GET['site_name']) ? $_GET['site_name'] : '');
                            $site_slogan = isset($_POST['site_slogan']) ? $_POST['site_slogan'] : (isset($_GET['site_slogan']) ? $_GET['site_slogan'] : '');
                            $site_url = isset($_POST['site_url']) ? $_POST['site_url'] : (isset($_GET['site_url']) ? $_GET['site_url'] : '');
                            $site_admin_url = isset($_POST['site_admin_url']) ? $_POST['site_admin_url'] : (isset($_GET['site_admin_url']) ? $_GET['site_admin_url'] : '');
                            $site_mail = isset($_POST['site_mail']) ? $_POST['site_mail'] : (isset($_GET['site_mail']) ? $_GET['site_mail'] : '');
                            $noreply_mail = isset($_POST['noreply_mail']) ? $_POST['noreply_mail'] : (isset($_GET['noreply_mail']) ? $_GET['noreply_mail'] : '');
                            $site_name = urldecode($site_name);
                            $site_name = INST_cleanString($site_name);
                            $site_slogan = urldecode($site_slogan);
                            $site_slogan = INST_cleanString($site_slogan);
                            require_once $_CONF['path_system'] . 'classes/config.class.php';
                            $config = config::get_instance();
                            $config->set('site_name', $site_name);
                            $config->set('site_slogan', $site_slogan);
                            $config->set('site_url', urldecode($site_url));
                            $config->set('site_admin_url', urldecode($site_admin_url));
                            $config->set('site_mail', urldecode($site_mail));
                            $config->set('noreply_mail', urldecode($noreply_mail));
                            $config->set_default('default_photo', urldecode($site_url) . '/default.jpg');
                        } else {
                            $site_url = isset($_POST['site_url']) ? $_POST['site_url'] : (isset($_GET['site_url']) ? $_GET['site_url'] : '');
                            $site_admin_url = isset($_POST['site_admin_url']) ? $_POST['site_admin_url'] : (isset($_GET['site_admin_url']) ? $_GET['site_admin_url'] : '');
                        }
                        INST_fixPathsAndUrls($_CONF['path'], $html_path, urldecode($site_url), urldecode($site_admin_url));
                        // disable plugins for which we don't have the source files
                        INST_checkPlugins();
                        // extra step 4: upgrade plugins
                        $next_link = 'index.php?step=4&mode=' . $install_type . '&language=' . $language;
                        if ($install_plugins) {
                            $next_link .= '&install_plugins=true';
                        }
                        header('Location: ' . $next_link);
                    } else {
                        $display .= '<h2>' . $LANG_INSTALL[78] . '</h2>
                        <p>' . $LANG_INSTALL[79] . '</p>' . LB;
                    }
                    break;
            }
            // Clear the Geeklog Cache
            INST_clearCache();
            break;
            /**
             * Extra Step 4 - Upgrade plugins
             */
        /**
         * Extra Step 4 - Upgrade plugins
         */
        case 4:
            INST_pluginUpgrades();
            $install_plugins = isset($_GET['install_plugins']) && !empty($_GET['install_plugins']) ? true : false;
            if (!$install_plugins) {
                // if we don't do the manual selection, install all new plugins now
                INST_autoinstallNewPlugins();
            }
            $next_link = $install_plugins ? 'install-plugins.php?language=' . $language : 'success.php?type=' . $install_type . '&language=' . $language;
            header('Location: ' . $next_link);
            break;
    }
}