$query = "select * from {$met_column} where bigclass='{$movenow['id']}'";
$moveclass3 = $db->get_all($query);
foreach ($moveclass3 as $key => $val) {
$classtypenext = $movenow['classtype'] + 1;
$classold2 .= " and class{$classtypenext}={$val['id']}";
$query = "update {$table} set class1={$moveto['id']},class2={$movenow['id']},class3={$val['id']} where {$classold2}";
$db->query($query);
}
}
$query = "update {$met_column} set classtype={$moveto['classtype']},foldername='{$moveto['foldername']}' where bigclass='{$id}'";
$db->query($query);
/*delete foldername*/
$admin_lists = $db->get_one("SELECT * FROM {$met_column} WHERE foldername='{$movenow['foldername']}'");
if (!$admin_lists['id'] && ($movenow['classtype'] == 1 || $movenow['releclass'])) {
if ($movenow['foldername'] != '' && ($movenow['module'] < 6 || $movenow['module'] == 8)) {
if (!unkmodule($movenow['foldername'])) {
$foldername = "../../" . $movenow['foldername'];
if (!deldir($foldername)) {
metsave('../column/index.php?anyid=' . $anyid . '&lang=' . $lang, $lang_columntip9);
}
}
}
}
file_unlink("../../cache/column_{$lang}.inc.php");
metsave('../column/index.php?anyid=' . $anyid . '&lang=' . $lang);
}
} else {
/*关联*/
if ($classto == 0) {
$query = "update {$met_column} set classtype=1,bigclass=0,releclass=0 where id='{$id}'";
$db->query($query);
function delcolumn($column)
{
global $lang, $db, $met_deleteimg, $depth;
global $met_admin_table, $met_column, $met_cv, $met_download, $met_feedback, $met_flist, $met_img, $met_job, $met_link, $met_list, $met_message, $met_news, $met_parameter, $met_plist, $met_product, $met_config, $met_mlist;
if ($column['releclass']) {
$classtype = "class1";
} else {
$classtype = "class" . $column['classtype'];
}
switch ($column['module']) {
default:
$query = "delete from {$met_column} where id='{$column['id']}'";
$db->query($query);
break;
case 2:
if ($met_deleteimg) {
$query = "select * from {$met_news} where {$classtype}='{$column['id']}'";
$del = $db->get_all($query);
delimg($del, 2, 2);
}
$query = "delete from {$met_news} where {$classtype}='{$column['id']}'";
$db->query($query);
$query = "delete from {$met_column} where id='{$column['id']}'";
$db->query($query);
break;
case 3:
$query = "select * from {$met_product} where {$classtype}='{$column['id']}'";
$del = $db->get_all($query);
delimg($del, 2, 3);
foreach ($del as $key => $val) {
$query = "delete from {$met_plist} where listid='{$val['id']}' and module='{$column['module']}'";
$db->query($query);
}
$query = "delete from {$met_product} where {$classtype}='{$column['id']}'";
$db->query($query);
$query = "delete from {$met_column} where id='{$column['id']}'";
$db->query($query);
break;
case 4:
$query = "select * from {$met_download} where {$classtype}='{$column['id']}'";
$del = $db->get_all($query);
delimg($del, 2, 4);
foreach ($del as $key => $val) {
$query = "delete from {$met_plist} where listid='{$val['id']}' and module='{$column['module']}'";
$db->query($query);
}
$query = "delete from {$met_download} where {$classtype}='{$column['id']}'";
$db->query($query);
$query = "delete from {$met_column} where id='{$column['id']}'";
$db->query($query);
break;
case 5:
$query = "select * from {$met_img} where {$classtype}='{$column['id']}'";
$del = $db->get_all($query);
delimg($del, 2, 5);
foreach ($del as $key => $val) {
$query = "delete from {$met_plist} where listid='{$val['id']}' and module='{$column['module']}'";
$db->query($query);
}
$query = "delete from {$met_img} where {$classtype}='{$column['id']}'";
$db->query($query);
$query = "delete from {$met_column} where id='{$column['id']}'";
$db->query($query);
break;
case 6:
if ($met_deleteimg) {
$query = "select * from {$met_cv} where lang='{$lang}'";
$del = $db->get_all($query);
delimg($del, 2, 6);
}
$query = "delete from {$met_plist} where lang='{$lang}' and module='{$column['module']}'";
$db->query($query);
$query = "delete from {$met_cv} where lang='{$lang}'";
$db->query($query);
$query = "delete from {$met_job} where lang='{$lang}'";
$db->query($query);
$query = "delete from {$met_column} where id='{$column['id']}'";
$db->query($query);
break;
case 7:
$query = "delete from {$met_message} where lang='{$lang}'";
$db->query($query);
$query = "delete from {$met_column} where id='{$column['id']}'";
$db->query($query);
$query = "delete from {$met_config} where columnid='{$column['id']}' and lang='{$lang}'";
$db->query($query);
$query = "delete from {$met_parameter} where lang='{$lang}' and module=7";
$db->query($query);
$query = "delete from {$met_mlist} where lang='{$lang}' and module=7";
$db->query($query);
break;
case 8:
$query = "select * from {$met_feedback} where class1='{$column['id']}'";
$del = $db->get_all($query);
delimg($del, 2, 8);
foreach ($del as $key => $val) {
$query = "delete from {$met_flist} where listid='{$list['id']}'";
$db->query($query);
}
$query = "delete from {$met_parameter} where module='{$column['module']}' and class1='{$column['id']}' and lang='{$lang}'";
$db->query($query);
$query = "delete from {$met_feedback} where class1='{$column['id']}' and lang='{$lang}'";
$db->query($query);
$query = "delete from {$met_column} where id='{$column['id']}'";
$db->query($query);
$query = "delete from {$met_config} where columnid='{$column['id']}' and lang='{$lang}'";
$db->query($query);
break;
case 9:
$query = "delete from {$met_link} where lang='{$lang}'";
$db->query($query);
$query = "delete from {$met_column} where id='{$column['id']}'";
$db->query($query);
break;
case 10:
$query = "delete from {$met_admin_table} where usertype!=3 and lang='{$lang}'";
$db->query($query);
$query = "delete from {$met_column} where id='{$column['id']}'";
$db->query($query);
break;
}
/*删除文件*/
$admin_lists = $db->get_one("SELECT * FROM {$met_column} WHERE foldername='{$column['foldername']}'");
if (!$admin_lists['id'] && ($column['classtype'] == 1 || $column['releclass'])) {
if ($column['foldername'] != '' && ($column['module'] < 6 || $column['module'] == 8) && $column['if_in'] != 1) {
if (!unkmodule($column['foldername'])) {
$foldername = $depth . "../../" . $column['foldername'];
deldir($foldername);
}
}
}
/*删除栏目图片*/
if ($met_deleteimg) {
file_unlink($depth . "../" . $column[indeximg]);
file_unlink($depth . "../" . $column[columnimg]);
}
}
