$sysTypeSql";
$sysTypeResult = mysqli_query($pubConn,$sysTypeSql);
$sysTypeRows = @mysqli_fetch_array($sysTypeResult);
$sysTypeNo = $sysTypeRows[sysTypeNo];
if($DEBUG) echo "
sysTypeNo=$sysTypeNo";
}
function omcGetObjDb($sysTypeNo){
$dbName = 'OBJ_'.$sysTypeNo;
return($dbName);
}
$objDb=omcGetObjDb($sysTypeNo);
if($DEBUG) echo "
objDb=$objDb";
if($DEBUG) echo "
dataTypeNo=$dataTypeNo";
$dataTypeNo=isset($dataTypeNo)?$dataTypeNo:0;
if($DEBUG) echo "
dataTypeNo=$dataTypeNo";
$paramConfTable = 'subsParamConf_'.$dataTypeNo;
if($DEBUG) echo "
paramConfTable=$paramConfTable";
$maxLevelNum = 10;
if($DEBUG) echo "
$paramConfTable
";
//----------------------
//选择语言版本
if($language == 'eng'){
$objNameField = name_2;
$objSetField = setTemplate_2 ; //语种2
}else{
$objNameField = name_1;
$objSetField = setTemplate_1 ; //语种1(默认语种)
}
//-----------------------
/*****************************保存一个新的参数编辑模板*****************************/
if($save){
if($DEBUG) echo "
keyId = $keyId";
if($keyId > 0){
$saveSql = "UPDATE $paramConfTable
SET $objSetField = '$codeArea'
WHERE keyId='$keyId'
";
$saveResult = mysqli_query($pubConn,$saveSql);
}else{
echo "
Error: keyId == NULL";
exit();
}
if($DEBUG) echo "
$saveSql";
echo mysqli_error($pubConn);
if($saveResult){
//更新备份文件
$csvFileName = '/usr/local/apache/htdocs/db_backup/other/'.$objDb.'.'.$paramConfTable.'.csv';
@unlink($csvFileName);
$csvFileUpdateSql=" SELECT *
INTO OUTFILE '$csvFileName'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
FROM $paramConfTable
";
$csvFileUpdateResult = mysqli_query($pubConn ,$csvFileUpdateSql);
echo mysqli_error($pubConn);
echo "";
}else{
echo "";
}
}
?>