function CreateTempTb($gid, $en)
{
global $empire, $dbtbpre;
if ($gid == 1) {
return "";
}
$templist = ReturnTemptbList();
$r = explode(",", $templist);
$count = count($r);
for ($i = 0; $i < $count; $i++) {
$otb = $dbtbpre . $r[$i];
$tb = $dbtbpre . $r[$i] . $en;
CopyEcmsTb($otb, $tb);
}
}
function AddDataTable($add, $userid, $username)
{
global $empire, $dbtbpre;
//操作权限
CheckLevel($userid, $username, $classid, "table");
$tid = (int) $add['tid'];
$tbname = RepPostVar($add['tbname']);
$datatb = (int) $add['datatb'];
if (!$tid || !$tbname || !$datatb) {
printerror("EmptyDataTable", "history.go(-1)");
}
$tr = $empire->fetch1("select tid,datatbs from {$dbtbpre}enewstable where tid='{$tid}'");
if (!$tr['tid']) {
printerror("EmptyDataTable", "history.go(-1)");
}
if (strstr($tr['datatbs'], ',' . $datatb . ',')) {
printerror("ReDataTable", "history.go(-1)");
}
if (empty($tr['datatbs'])) {
$tr['datatbs'] = ',';
}
$newdatatbs = $tr['datatbs'] . $datatb . ',';
//建表
$odtb = $dbtbpre . "ecms_" . $tbname . "_data_1";
$dtb = $dbtbpre . "ecms_" . $tbname . "_data_" . $datatb;
CopyEcmsTb($odtb, $dtb);
$sql = $empire->query("update {$dbtbpre}enewstable set datatbs='{$newdatatbs}' where tid='{$tid}'");
GetConfig(1);
//更新缓存
if ($sql) {
//操作日志
insert_dolog("tid=" . $tid . "<br>tbname=" . $tbname . "&datatb={$datatb}");
printerror("AddDataTableSuccess", "db/ListDataTable.php?tid={$tid}&tbname={$tbname}");
} else {
printerror("DbError", "history.go(-1)");
}
}
function AddPlDataTable($add, $userid, $username)
{
global $empire, $dbtbpre;
//操作权限
CheckLevel($userid, $username, $classid, "pltable");
$datatb = (int) $add['datatb'];
if (!$datatb) {
printerror("EmptyPlDataTable", "history.go(-1)");
}
$tr = $empire->fetch1("select pldatatbs from {$dbtbpre}enewspublic limit 1");
if (strstr($tr['pldatatbs'], ',' . $datatb . ',')) {
printerror("RePlDataTable", "history.go(-1)");
}
if (empty($tr['pldatatbs'])) {
$tr['pldatatbs'] = ',';
}
$newdatatbs = $tr['pldatatbs'] . $datatb . ',';
//建表
$odtb = $dbtbpre . "enewspl_data_1";
$dtb = $dbtbpre . "enewspl_data_" . $datatb;
CopyEcmsTb($odtb, $dtb);
$sql = $empire->query("update {$dbtbpre}enewspublic set pldatatbs='{$newdatatbs}' limit 1");
if ($sql) {
//操作日志
insert_dolog("datatb={$datatb}");
printerror("AddPlDataTableSuccess", "pl/ListPlDataTable.php");
} else {
printerror("DbError", "history.go(-1)");
}
}
