示例#1
0
function SetDb($add)
{
    global $version;
    if (!$add['mydbver'] || !$add['mydbhost'] || !$add['mydbname'] || !$add['mydbtbpre'] || !$add['mycookievarpre'] || !$add['myadmincookievarpre']) {
        InstallShowMsg('带*项不能为空');
    }
    //链接数据库
    $dbver = InstallConnectDb($add['mydbver'], $add['mydbhost'], $add['mydbport'], $add['mydbusername'], $add['mydbpassword'], $add['mydbname'], $add['mysetchar'], $add['mydbchar']);
    if ($add['mydbver'] == 'auto') {
        $add['mydbver'] = $dbver;
    }
    //初使化网站信息
    $siteurl = ReturnEcmsSiteUrl();
    $add[keyrnd] = ins_make_password(30);
    $add[downpass] = ins_make_password(20);
    //配置文件
    RepEcmsConfig($add, $siteurl);
    //执行SQL语句
    DoRunQuery(ReturnInstallSql(0), $add['mydbchar'], $add['mydbtbpre'], $add['mydbver']);
    @mysql_query("update " . $add['mydbtbpre'] . "enewspublic set newsurl='{$siteurl}',fileurl='" . $siteurl . "d/file/',softversion='{$version}',keyrnd='{$add['keyrnd']}',downpass='******'downpass']}' limit 1");
    @mysql_query("update " . $add['mydbtbpre'] . "enewsshoppayfs set payurl='" . $siteurl . "e/payapi/ShopPay.php?paytype=alipay' where payid=3");
    @mysql_close();
    echo "配置数据库完毕,正进入模板数据导入......<script>self.location.href='index.php?enews=templatedata&f=4&ok=1&defaultdata={$add['defaultdata']}';</script>";
    exit;
}
示例#2
0
function ExecSql($id, $userid, $username)
{
    global $empire, $dbtbpre;
    $id = (int) $id;
    if (empty($id)) {
        printerror('EmptyExecSqlid', '');
    }
    $r = $empire->fetch1("select sqltext from {$dbtbpre}enewssql where id='{$id}'");
    if (!$r['sqltext']) {
        printerror('EmptyExecSqlid', '');
    }
    $query = stripSlashes(RepSqlTbpre($r['sqltext']));
    DoRunQuery($query);
    //操作日志
    insert_dolog("query=" . $query);
    printerror("DoExecSqlSuccess", "ListSql.php");
}