/b2b/install/install.core.php

<?php

define('IN_INSTALLER',true);

require(CORE_DIR.'/kernel.php');

require(CORE_DIR.'/func_ext.php');

class installCore extends kernel{

    function __construct(){

        if($_POST['dbname'] && $_POST['dbuser'] && $_POST['dbhost']){

            $this->type = 'autoInstall';

            if(file_exists('../config/install.lock')){

                $this->outJson('false','Access denied by install.lock');

                exit();

            }

            $_POST['uname'] = $_POST['dbuser'];

            $_POST['pwd'] = $_POST['dbpass'];

            $_POST['prefix']=$_POST['prefix']?$_POST['prefix']:'sdb_';

            $_POST['use_demo']=($_POST['data']=='true')?true:false;

            $_POST['stimezone']=$_POST['stimezone']?$_POST['stimezone']:8;

            parent::kernel();

            $this->installReady();

        }else{

            if(file_exists('../config/install.lock')){

                $this->responseCode('403');

                echo 'Access denied by install.lock';

                exit();

            }else{

                parent::kernel();

                $this->checkPerm();

                $this->run();

            }

        }

    }



    function installReady(){

        if(!($link = mysql_connect($_POST['dbhost'], $_POST['dbuser'], $_POST['dbpass']))){

            $this->outJson('false','Can not connect database!');

            exit();

        }

        if(!$dbselect = mysql_select_db($_POST['dbname'],$link)){

            $this->outJson('false','Please select a Database!');

            exit();

        }

        $this->step_setdb();

        $this->loadConfig();

        $this->step_install();

    }



    function run(){



        $_GET['step'] = $_GET['step']?$_GET['step']:1;

        $method = 'step_'.$_GET['step'];

        if(method_exists($this,$method)){

            call_user_func(array(&$this,$method));

        }else{

            header("HTTP/1.0 404 Not Found",true,404);

            echo '<h1>404 Not Found</h1><hr />';

        }

    }



    function loadConfig(){

        ob_start();

        if(include('../config/config.php')){

            if(defined('DB_NAME') && defined('DB_USER') && defined('DB_PASSWORD') && defined('DB_HOST')){

                ob_end_clean();

                return true;

            }

        }

        ob_end_clean();

        return false;

    }



    function installCore(){

        $this->__construct();

    }



    function step_checkdb(){

        if(!($link = mysql_connect($_POST['dbhost'], $_POST['uname'], $_POST['pwd']))){

            header("Cache-Control: no-cache, must-revalidate",true,503);

            exit();

        }

        $database = array();

        if($result = mysql_query('show databases')){

            while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

                if($row['Database']!='mysql' && $row['Database']!='information_schema')

                    $database[] = $row['Database'];

            }

        }

        mysql_free_result($result);

        mysql_close($link);

        if(count($database)>0){

            $html = '<select id="db_name" name="dbname">';

            foreach($database as $db){

                $html .= '<option value="'.htmlspecialchars($db).'">'.$db.'</option>';

            }

            echo $html .= '</select>';

        }

    }



    function step_1(){

        $this->output('step_1.html');

    }



    function step_2(){

        if(is_file(BASE_DIR.'/config/config.php')){

            require_once(BASE_DIR.'/config/config.php');

            $this->pagedata['database_username'] = DB_USER;

            $this->pagedata['database_password'] = DB_PASSWORD;

            $this->pagedata['database_name'] = DB_NAME;

            $this->pagedata['host'] = DB_HOST;

            $this->pagedata['database_prefix'] = DB_PREFIX;

        }

        $this->pagedata['timezone'] = timezone_list();

        $this->pagedata['default_timezone'] = 8;



        $this->output('step_2.html');

    }



    /**

     * step_mysqlver ????????

     *

     * @access public

     * @return void

     */

    function step_mysqlver(){



        $this->pagedata['type'] = $_GET['type'];

        $this->output('mysqlver.html');

    }



    function step_setdb(){



        define('DB_NAME', $_POST['dbname']);  // The name of the database

        define('DB_USER', $_POST['uname']);  // Your MySQL username

        define('DB_PASSWORD', $_POST['pwd']); // ...and password

        define('DB_HOST', $_POST['dbhost']);

        define('DB_PREFIX', $_POST['prefix']);

        define('SERVER_TIMEZONE', $_POST['stimezone']);



        if(php_sapi_name()=='isapi'){

            $constant['WITHOUT_FLOCK'] = true;

        }



        if(!defined('STORE_KEY') || strlen(trim(STORE_KEY))==0){

            $constant['STORE_KEY'] = md5(print_r(microtime(),true).print_r($_SERVER,true));

        }



        $this->db = &$this->database();

        if(!$this->db->rwInstance(true)){

            $this->output('wrong_db.html');

        }else{

            if(file_exists(BASE_DIR.'/config/config.php')){

                $sample = file_get_contents(BASE_DIR.'/config/config.php');

            }else{

                $sample = file_get_contents(BASE_DIR.'/config/config.sample.php');

            }

            $s = array('DB_NAME', 'DB_USER', 'DB_PASSWORD', 'DB_HOST','STORE_KEY','DB_PREFIX','SERVER_TIMEZONE');



            foreach($s as $v){

                if(defined($v) || isset($constant[$v])){

                    $arr['#(define\\s*\\(\\s*[\'"]'.$v.'[\'"]\\s*,\\s*)[^;]+;#i'] = '\\1\''.str_replace('\'','\\\'',isset($constant[$v])?$constant[$v]:constant($v)).'\');';

                }else{

                    echo 'error: undefined constant: '.$v;

                    exit();

                }

            }

            if(RANDOM_HOME) $arr['#(define\\(\\s*[\'"]HOME_DIR[\'"]\\s*,\\s*)[^;]+;#i'] = '\\1dirname(__FILE__).\'/home'.'_'.substr(md5(microtime()),3,6).'\');';



            if(file_put_contents(BASE_DIR.'/config/config.php',preg_replace(array_keys($arr),array_values($arr),$sample))){

                //header('Location: index.php?step=ready');

            }else{

                if($this->type == 'autoInstall'){ 

                    $this->outJson('false','configure file write error!');

                    exit();

                }

                echo 'error: configure file write error! ';

                exit();

            }

        }

    }



    function step_ready(){

        $this->step_setdb();

        if($this->loadConfig()) {



            include('svinfo.php');

            $tester = new mdl_serverinfo();

            $this->pagedata['svinfo'] = $tester->run();

            $this->pagedata['status'] = 0;

            $this->db = &$this->database();

            if(!$this->db->rwInstance(true)){

                echo 'error: can\'t connect MySql Server! '.mysql_error();



                exit();

            }

            if(!defined('DB_PREFIX')){

                define('DB_PREFIX','');

            }

            $this->pagedata['db_pre'] = DB_PREFIX;

            $this->set_timezone(SERVER_TIMEZONE);

            $tz = timezone_list();



            $timelist = array();

            foreach($tz as $z=>$t){

                $timelist[$z] = date('H:i',time()+($z-SERVER_TIMEZONE)*3600).'-'.$t;

            }



            $this->pagedata['defaultHour'] = SERVER_TIMEZONE;

            $this->pagedata['timelist'] = &$timelist;

            $this->pagedata['stimezone'] = $tz[SERVER_TIMEZONE];



            $this->output('step_ready.html');

        }else header('Location: index.php?step=1');



    }



    function step_cluster(){

        if($this->loadConfig()) {

            $this->output('step_cluster.html');

        }else header('Location: index.php?step=1');

    }



    function step_install(){



        set_time_limit(0);



        if($this->loadConfig()) {

            $this->db = &$this->database();

            $this->db->exec('SET NAMES utf8');



            if(!$this->db->rwInstance(true)){

                $this->output('wrong_db.html');

                exit;

            }else{

                $sqlContent = file_get_contents('dbscripts/mysql.sql');

                $sqlContent .= file_get_contents('dbscripts/init.sql');

                if($_POST['use_demo']){

                    $sqlContent .= file_get_contents('dbscripts/demo.sql');

                }

            

                foreach($this->db->splitSql($sqlContent) as $sql){

                    if(!$this->db->exec($sql,true)){

                        echo '<h3>Sql Error</h3><textarea style="width:500px;height:300px">'.htmlspecialchars($sql).'</textarea><br />';

                        echo $this->db->errorInfo();

                        exit();

                    }

                }

                if($this->type == 'autoInstall'){

                    $password = $_POST['password'];

                }else{

                    $password = md5($_POST['password']);

                }

                $uname = $_POST['username']?$_POST['username']:'admin';

                $rs = $this->db->exec('select * from sdb_operators where 0=1');

                $sql = $this->db->getInsertSQL($rs,array(

                    'username'=>$uname,

                    'userpass'=>$password,

                    'status'=>1,

                    'super'=>1

                ));

                if(!$this->db->exec($sql,true)){

                    if($this->type == 'autoInstall'){

                        $this->outJson('false','cannot create administrator account.');

                        exit();

                    }

                    echo 'error: cannot create administrator account.';

                    exit();

                }

                if(RANDOM_HOME){

                    if(!is_dir(HOME_DIR)){

                        if(!mkdir(HOME_DIR,0777)){

                            echo 'error: can\' mk home dir';

                            exit();

                        }

                    }



                    if(

                        !mkdir_p(HOME_DIR.'/cache/data') ||

                        !mkdir_p(HOME_DIR.'/cache/front_tmpl') ||

                        !mkdir_p(HOME_DIR.'/cache/admin_tmpl') ||

                        !mkdir_p(HOME_DIR.'/download') ||

                        !mkdir_p(HOME_DIR.'/fonts') ||

                        !mkdir_p(HOME_DIR.'/logs') ||

                        !mkdir_p(HOME_DIR.'/template') ||

                        !mkdir_p(HOME_DIR.'/upload')

                    ){

                        echo 'error: can\' mk home dir';

                        exit();

                    }

                }



                $this->setConf('system.timezone.default',$_POST['timezone']);

                $this->init();



                $this->pagedata['password'] = $_POST['password'];

                $this->pagedata['uname'] = $uname;



                file_put_contents(BASE_DIR.'config/install.lock','If you want to reinstall system, delete this file!');

                $this->cache->clear();

                

                $data['article'] = $this->db->selectrow("SELECT max(article_id) as max FROM sdb_articles");

                $data['goods'] = $this->db->selectrow("SELECT max(goods_id) as max FROM sdb_goods");

                $data['goods_cat'] = $this->db->selectrow("SELECT max(cat_id) as max FROM sdb_goods_cat");

                $data['goods_memo'] = $this->db->selectrow("SELECT max(goods_id) as max FROM sdb_goods_memo");

                $data['goods_type'] = $this->db->selectrow("SELECT max(type_id) as max FROM sdb_goods_type");

                $data['package_product'] = $this->db->selectrow("SELECT max(product_id) as max FROM sdb_package_product");

                $data['products'] = $this->db->selectrow("SELECT max(product_id) as max FROM sdb_products");

                $data['spec_values'] = $this->db->selectrow("SELECT max(spec_value_id) as max FROM sdb_spec_values");

                $data['specification'] = $this->db->selectrow("SELECT max(spec_id) as max FROM sdb_specification");

                $data['type_brand'] = $this->db->selectrow("SELECT max(type_id) as max FROM sdb_type_brand");

                $data['brand'] = $this->db->selectrow("SELECT max(brand_id) as max FROM sdb_brand");

                $data['goods_virtual_cat'] = $this->db->selectrow("SELECT max(virtual_cat_id) as max FROM sdb_goods_virtual_cat");

                $data['gimages'] = $this->db->selectrow("SELECT max(gimage_id) as max FROM sdb_gimages");

                $data['status'] = $this->db->selectrow("SELECT max(last_update) as max FROM sdb_status");

                $this->setConf('system.test.database',serialize($data));

            

                if($this->type == 'autoInstall'){

                    $this->outJson('true','Shop had installed!');

                    exit;

                }

                $this->output('step_install.html');



                exit();

            }

        }

        header('Location: index.php?step=1');

    }



    function init(){

        $ver = $this->version();

        $db = &$this->database();

        $db->exec('drop table if exists sdb_dbver');

        $ver['dbver'] = $ver['dbver']?$ver['dbver']:'dbver';

        $db->exec("create table sdb_dbver(`{$ver['dbver']}` varchar(255)) type = MYISAM");



        $o = &$this->loadModel('content/sitemap');

        $o->update();



        $o = &$this->loadModel('system/template');

        $o->initTheme('b2b_dgfc');

        $result=$o->setDefault('b2b_dgfc');

        $usedTpl = $o->getDefault();

        $o->getList();



        $o = &$this->loadModel('system/local');

        $rs = $o->use_package(defined('DEFAULT_LOCAL')?DEFAULT_LOCAL:'mainland');

    }



    function step_reinstall(){

        $this->step_install();

    }



    function output($file){

        header('Content-type: text/html;charset=utf-8');

        $this->pagedata['PAGE'] = $file;

        $this->pagedata['version'] = $this->version();

        $smarty = &$this->template();

        $smarty->ctl = &$this;

        $smarty->plugins_dir[] = CORE_DIR.'/admin/smartyplugin';

        $smarty->template_dir = 'view';

        if(defined('HOME_DIR')){

            $smarty->compile_dir = HOME_DIR.'/cache/front_tmpl';

        }

        $smarty->left_delimiter='{';

        $smarty->right_delimiter='}';

        foreach($this->pagedata as $k=>$v){

            $smarty->assign($k,$v);

        }

        $smarty->display('main.html');

        exit();

    }



    function checkPerm(){

        if(!is_writable('templates_c')){

            echo '<strong>Error:</strong> <i>install/templates_c</i> is not writable!';

            exit();

        }

        $arr = array(

            array('path'=>'install/templates_c','is_writable'=>true)

        );



        chdir('../');

        $this->_checkDirPerm('config',$arr);

        $this->_checkDirPerm('themes',$arr);

        $this->_checkDirPerm('home',$arr,true);

        chdir('install');



        foreach($arr as $item){

            if(!$item['is_writable']){

                $this->pagedata['dirs'] = $arr;

                $this->output('permview.html');

                exit();

            }

        }

    }



    function _checkDirPerm($dir,&$arr,$r=false){



        $arr[] = array(

            'path'=>$dir,

            'is_writable'=>is_writable($dir),

        );



        if($r){

            if($handle = opendir($dir)){

                while(false != ($file = readdir($handle))){

                    if($file{0}!='.' && is_dir($dir.'/'.$file)){

                        $this->_checkDirPerm($dir.'/'.$file,$arr,$r);

                    }

                }

                closedir($handle);

            }

        }

    }



    function base_url(){

        return dirname(dirname($_SERVER["PHP_SELF"]));

    }



    function outJson($res,$rsp){

    //$res:??  $rsp:????

        $outjson = array("res"=>"$res","rsp"=>"$rsp");

        echo json_encode($outjson);

    }



}



?>