Esempio n. 1
0
 function dbConnect($par_order = FALSE)
 {
     global $databaseGlobal;
     $dbHostname = GetDbHost();
     if ($par_order) {
         $dbDatabase = GetOrderDbName();
     } else {
         $dbDatabase = GetDbName();
     }
     $dbUsername = GetDbUser();
     $dbPassword = GetDbPassword();
     //echo $dbDatabase;
     $Connect = mysql_connect($dbHostname, $dbUsername, $dbPassword) or die('<storng>Database connect error: </strong>' . mysql_error());
     mysql_query("SET NAMES 'utf8'", $Connect);
     return array($dbDatabase, $Connect);
 }
Esempio n. 2
0
function Setup3()
{
    global $zbp;
    global $CheckResult, $option;
    CheckServer();
    $hasMysql = false;
    $hasSqlite = false;
    $hasPgsql = false;
    $hasMysql = (bool) ((bool) $CheckResult['mysql'][0] or (bool) $CheckResult['mysqli'][0] or (bool) $CheckResult['pdo_mysql'][0]);
    $hasSqlite = (bool) ((bool) $CheckResult['sqlite3'][0] or (bool) $CheckResult['sqlite'][0] or (bool) $CheckResult['pdo_sqlite'][0]);
    $hasPgsql = (bool) ((bool) $CheckResult['pgsql'][0] or (bool) $CheckResult['pdo_pgsql'][0]);
    ?>
<dl>
  <dt></dt>
  <dd id="ddleft"><div id="headerimg"><img src="../zb_system/image/admin/install.png" alt="Z-BlogPHP" />
  <strong><?php 
    echo $zbp->lang['zb_install']['install_program'];
    ?>
</strong></div>
    <div class="left"><?php 
    echo $zbp->lang['zb_install']['install_progress'];
    ?>
&nbsp;</div>
    <div id="setup3"  class="left"></div>
    <p><b><?php 
    echo $zbp->lang['zb_install']['install_license'];
    ?>
</b> » <b><?php 
    echo $zbp->lang['zb_install']['environment_check'];
    ?>
</b> » <b><?php 
    echo $zbp->lang['zb_install']['db_build_set'];
    ?>
</b> » <?php 
    echo $zbp->lang['zb_install']['install_result'];
    ?>
</p>
  </dd>
  <dd id="ddright">
    <div id="title"><?php 
    echo $zbp->lang['zb_install']['db_build_set'];
    ?>
</div>
    <div id="content">
      <div>
        <p><b><?php 
    echo $zbp->lang['zb_install']['database'];
    ?>
</b>
        <?php 
    if ($hasMysql) {
        ?>
          <label class="dbselect" id="mysql_radio">
          <input type="radio" name="fdbtype" value="mysql"/> MySQL</label>
        <?php 
        echo '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
    }
    ?>
        <?php 
    if ($hasSqlite) {
        ?>
          <label class="dbselect" id="sqlite_radio">
          <input type="radio" name="fdbtype" value="sqlite"/> SQLite</label>
        <?php 
        echo '&nbsp;&nbsp;&nbsp;&nbsp;';
    }
    ?>
        </p>
      </div>
      <?php 
    if ($hasMysql) {
        ?>
      <div class="dbdetail" id="mysql">
        <p><b><?php 
        echo $zbp->lang['zb_install']['server'];
        ?>
</b>
          <input type="text" name="dbmysql_server" id="dbmysql_server" value="<?php 
        echo $option['ZC_MYSQL_SERVER'];
        ?>
" style="width:350px;" />
        </p>
        <p><b><?php 
        echo $zbp->lang['zb_install']['username'];
        ?>
</b>
          <input type="text" name="dbmysql_username" id="dbmysql_username" value="<?php 
        echo $option['ZC_MYSQL_USERNAME'];
        ?>
" style="width:350px;" />
        </p>
        <p><b><?php 
        echo $zbp->lang['zb_install']['password'];
        ?>
</b>
          <input type="password" name="dbmysql_password" id="dbmysql_password" value="<?php 
        echo $option['ZC_MYSQL_PASSWORD'];
        ?>
" style="width:350px;" />
        </p>
        <p><b><?php 
        echo $zbp->lang['zb_install']['db_name'];
        ?>
</b>
          <input type="text" name="dbmysql_name" id="dbmysql_name" value="<?php 
        echo $option['ZC_MYSQL_NAME'];
        ?>
" style="width:350px;" />
        </p>
        <p><b><?php 
        echo $zbp->lang['zb_install']['db_pre'];
        ?>
</b>
          <input type="text" name="dbmysql_pre" id="dbmysql_pre" value="<?php 
        echo $option['ZC_MYSQL_PRE'];
        ?>
" style="width:350px;" />
        </p>
<?php 
        if ($zbp->option['ZC_YUN_SITE'] == '') {
            ?>
        <p><b><?php 
            echo $zbp->lang['zb_install']['db_engine'];
            ?>
</b>
          <select id="dbengine" name="dbengine" style="width:360px;" >
		  <option value="MyISAM" selected>MyISAM(<?php 
            echo $zbp->lang['msg']['default'];
            ?>
)</option>
          <option value="InnoDB" >InnoDB</option>
        </select>
        </p>
<?php 
        }
        ?>
      <p><b><?php 
        echo $zbp->lang['zb_install']['db_drive'];
        ?>
</b>
        <?php 
        if ($CheckResult['mysqli'][0]) {
            ?>
        <label>
          <input value="mysqli" type="radio" name="dbtype"/> mysqli</label>
        <?php 
        }
        ?>
&nbsp;&nbsp;&nbsp;&nbsp;
        <?php 
        if ($CheckResult['pdo_mysql'][0]) {
            ?>
        <label>
          <input value="pdo_mysql" type="radio" name="dbtype"/> pdo_mysql</label>
        <?php 
        }
        ?>
&nbsp;&nbsp;&nbsp;&nbsp;
<?php 
        if (version_compare(PHP_VERSION, '5.5.0', '<')) {
            ?>
        <?php 
            if ($CheckResult['mysql'][0] && !$CheckResult['mysqli'][0] && !$CheckResult['pdo_mysql'][0]) {
                // 强制淘汰mysql
                ?>
        <label>
          <input value="mysql" type="radio" name="dbtype"/> mysql</label>
        <?php 
            }
            ?>
&nbsp;&nbsp;&nbsp;&nbsp;
<?php 
        }
        ?>
		<br/><small><?php 
        echo $zbp->lang['zb_install']['db_set_port'];
        ?>
</small>
      </p>
      </div>
      <?php 
    }
    ?>

      <?php 
    if ($hasSqlite) {
        ?>
      <div class="dbdetail" id="sqlite">
        <p><b><?php 
        echo $zbp->lang['zb_install']['db_name'];
        ?>
</b>
          <input type="text" name="dbsqlite_name" id="dbsqlite_name" value="<?php 
        echo GetDbName();
        ?>
" readonly style="width:350px;" />
        </p>
        <p><b><?php 
        echo $zbp->lang['zb_install']['db_pre'];
        ?>
</b>
          <input type="text" name="dbsqlite_pre" id="dbsqlite_pre" value="zbp_" style="width:350px;" />
        </p>
      <p><b><?php 
        echo $zbp->lang['zb_install']['db_drive'];
        ?>
</b>
        <?php 
        if ($CheckResult['sqlite3'][0]) {
            ?>
        <label>
          <input value="sqlite3" type="radio" name="dbtype" /> sqlite3</label>
        <?php 
            echo '&nbsp;&nbsp;&nbsp;&nbsp;';
        }
        ?>
        <?php 
        if ($CheckResult['pdo_sqlite'][0]) {
            ?>
        <label>
          <input value="pdo_sqlite" type="radio" name="dbtype" /> pdo_sqlite</label>
        <?php 
            echo '&nbsp;&nbsp;&nbsp;&nbsp;';
        }
        ?>
        <?php 
        if ($CheckResult['sqlite'][0]) {
            ?>
        <label>
          <input value="sqlite" type="radio" name="dbtype" /> sqlite</label>
        <?php 
            echo '&nbsp;&nbsp;&nbsp;&nbsp;';
        }
        ?>
      </p>
      </div>
      <?php 
    }
    ?>

      <p class="title"><?php 
    echo $zbp->lang['zb_install']['website_setting'];
    ?>
</p>
      <p><b><?php 
    echo $zbp->lang['zb_install']['blog_name'];
    ?>
</b>
        <input type="text" name="blogtitle" id="blogtitle" value="" style="width:350px;" />
      </p>
      <p><b><?php 
    echo $zbp->lang['zb_install']['admin_username'];
    ?>
</b>
        <input type="text" name="username" id="username" value="" style="width:200px;" />
        &nbsp;<small><?php 
    echo $zbp->lang['zb_install']['username_intro'];
    ?>
</small></p>
      <p><b><?php 
    echo $zbp->lang['zb_install']['admin_password'];
    ?>
</b>
        <input type="password" name="password" id="password" value="" style="width:200px;" />
        &nbsp;<small><?php 
    echo $zbp->lang['zb_install']['password_intro'];
    ?>
</small></p>
      <p><b><?php 
    echo $zbp->lang['zb_install']['re_password'];
    ?>
</b>
        <input type="password" name="repassword" id="repassword" value="" style="width:200px;" />
      </p>
    </div>
    <div id="bottom">
      <input type="submit" name="next" id="netx" onClick="return Setup3()" value="<?php 
    echo $zbp->lang['zb_install']['next'];
    ?>
" />
    </div>
  </dd>
</dl>
<script type="text/javascript">
$(".dbselect").click(function(){
  $(".dbdetail").hide();
  $("#"+$(this).attr("id").split("_radio")[0]).show();
  $("input[name='dbtype']:visible").get(0).click();
});
$(".dbdetail").hide();
$("#"+$(".dbselect").attr("id").split("_radio")[0]).show();
$("input[name='dbtype']:visible").get(0).click();
$("input[name='fdbtype']:visible").get(0).click();
</script>
<?php 
}