Exemplo n.º 1
0
 /**
  * Optimize all existing tables
  * Warning: This does only work for  MyISAM-, BDB- and InnoDB tables
  */
 public function optimizeTables()
 {
     $tables = $this->getExistingTables();
     foreach ($tables as $table => $tableLower) {
         $this->db->query("OPTIMIZE TABLE `{$table}`");
     }
 }
Exemplo n.º 2
0
    /**
     * Get content
     */
    public function getContent()
    {
        $errors = $checkErrors = array();
        $writeableFolders = array(CHOQ_ACTIVE_MODULE_DIRECTORY, CHOQ_ACTIVE_MODULE_DIRECTORY . "/public/static", CHOQ_ACTIVE_MODULE_DIRECTORY . "/public/img/favicons", CHOQ_ACTIVE_MODULE_DIRECTORY . "/tmp");
        foreach ($writeableFolders as $folder) {
            if (!is_dir($folder)) {
                $errors[] = sprintf(t("install.folder.notexist"), $folder);
                break;
            }
            if (!is_writable($folder)) {
                $errors[] = sprintf(t("install.folder.writeable"), $folder);
                break;
            }
        }
        if (!ini_get("allow_url_fopen")) {
            $errors[] = sprintf(t("install.php.feature"), "allow_url_fopen");
        }
        if (!function_exists("fsockopen")) {
            $errors[] = sprintf(t("install.php.feature"), "fsockopen/sockets");
        }
        if (!function_exists("simplexml_load_file")) {
            $errors[] = sprintf(t("install.php.feature"), "SimpleXML");
        }
        if (!CHOQ_DB_Mysql::isAvailable()) {
            $errors[] = sprintf(t("install.php.feature"), "MySQLi");
        }
        if (post("install")) {
            try {
                $connString = "mysql://" . post("mysql-user") . ":" . post("mysql-pass") . "@" . post("mysql-host") . "/" . post("mysql-db");
                CHOQ_DB::add($connString, "test");
                db("test")->query("DROP TABLE IF EXISTS " . db("test")->quote("RDR_test"));
                db("test")->query("CREATE TABLE " . db("test")->quote("RDR_test") . " (" . db("test")->quote("id") . " INT NOT NULL)");
                db("test")->query("DROP TABLE IF EXISTS " . db("test")->quote("RDR_test"));
                $fileData = "<?php\nif(!defined(\"CHOQ\")) die();\n/**\n * Local Configuration\n**/\n\n";
                $fileData .= 'CHOQ_DB::add(\'' . $connString . '\');' . "\n";
                $fileData .= 'v("hash.salt", "' . uniqid(NULL, true) . sha1(microtime() . uniqid(NULL, true)) . '");' . "\n";
                $tmpfile = CHOQ_ACTIVE_MODULE_DIRECTORY . "/tmp/_RDR.local.tmp.php";
                file_put_contents($tmpfile, $fileData);
                include $tmpfile;
                $generator = CHOQ_DB_Generator::create(db());
                $tables = $generator->getExistingTables();
                foreach ($tables as $table) {
                    if ($table == "_choqled_metadata" || substr(strtolower($table), 0, 3) == "rdr_") {
                        db()->query("DROP TABLE " . db()->quote($table));
                    }
                }
                RDR_DBUpdate::run();
                $user = new RDR_User(db());
                $user->username = post("admin-user");
                $user->setPassword(post("admin-pass"));
                $user->role = RDR_User::ROLE_ADMIN;
                $user->store();
                rename($tmpfile, CHOQ_ACTIVE_MODULE_DIRECTORY . "/_RDR.local.php");
                redirect(url()->getByAlias("base"));
            } catch (Exception $e) {
                $checkErrors[] = $e->getMessage();
            }
        }
        ?>
        <div class="center">
            <img src="<?php 
        echo url()->getByAlias("public", "img/logo-1.png");
        ?>
" alt=""/>
        </div>
        <?php 
        if (!$errors) {
            $this->showErrors($checkErrors);
            $form = $this->getForm();
            $formTable = new Form_Table($form);
            $formTable->addSubmit(t("install.finish"));
            echo $formTable->getHtml();
            echo "<div class='center'><br/>" . t("install.warn") . "</div>";
        } else {
            $this->showErrors($errors);
        }
    }