$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]); } }