function delpic($pic) { $thumbfilepath = gethumb($pic, '', '', false, true, true); FS::del(FS::fp($pic, '+iPATH')); $msg = $pic . ' 文件删除…<span style=\'color:green;\'>√</span><br />'; if ($thumbfilepath) { foreach ($thumbfilepath as $wh => $fp) { FS::del(FS::fp($fp, '+iPATH')); $msg .= '缩略图 ' . $wh . ' 文件删除…<span style=\'color:green;\'>√</span><br />'; } } $filename = FS::info($pic)->filename; iCMS_DB::query("DELETE FROM `#iCMS@__file` WHERE `filename` = '{$filename}'"); $msg .= $pic . ' 数据删除…<span style=\'color:green;\'>√</span><br />'; return $msg; }
function dodelpic() { $id = (int) $_GET['id']; $mid = (int) $_GET['mid']; $table = model::tbn($_GET['table']); $field = $_GET['field']; $fp = $_GET['fp']; if (empty($fp)) { return; } !$id && javascript::alert("请选择要删除图片的内容"); $thumbfilepath = gethumb($fp, '', '', false, true, true); FS::del(FS::fp($fp, '+iPATH')); if ($thumbfilepath) { foreach ($thumbfilepath as $wh => $tfp) { FS::del(FS::fp($tfp, '+iPATH')); } } $filename = FS::info($fp)->filename; iCMS_DB::query("DELETE FROM `#iCMS@__file` WHERE `filename` = '{$filename}'"); iCMS_DB::query("UPDATE `#iCMS@__{$table}` SET `{$field}` = '' WHERE `id` ='{$id}'"); echo '<script type="text/javascript"> parent.$("#' . $field . '2").hide(); parent.$("#c' . $field . '1").hide(); parent.$("#' . $field . '1").show(); parent.$("[name=' . $field . ']").val("");</script>'; }
function delArticle($id) { global $DreamCMS; $id = (int) $id; $art = $DreamCMS->db->get_row("SELECT `pic`,`filename`,`cid`,`tags`FROM `#DC@__article` WHERE id='{$id}' Limit 1"); if ($art->pic) { $thumbfilepath = gethumb($art->pic); delfile(DCPATH . $art->pic); $thumbfilepath && delfile(DCPATH . $art->pic); $DreamCMS->db->query("DELETE FROM `#DC@__file` WHERE `path` = '{$art->pic}'"); } $body = $DreamCMS->db->get_var("SELECT `body` FROM `#DC@__articledata` WHERE aid='{$id}' Limit 1"); if ($art->filename) { $bArray = explode('<div style="page-break-after: always"><span style="display: none"> </span></div>', $body); $total = count($bArray); delfile(DCPATH . $DreamCMS->config['htmdir'] . $art->filename . ".html"); if ($total > 1) { for ($i = 1; $i <= $total; $i++) { delfile(DCPATH . $DreamCMS->config['htmdir'] . $art->filename . '_' . $i . '.html'); } } } $frs = $DreamCMS->db->get_results("SELECT `path`, `thumbpath` FROM `#DC@__file` WHERE `aid`='{$id}'"); for ($i = 0; $i < count($frs); $i++) { if (!empty($frs[$i])) { $frs[$i]['path'] && delfile(DCPATH . $frs[$i]['path']); $frs[$i]['thumbpath'] && delfile(DCPATH . $frs[$i]['thumbpath']); } } if ($art->tags) { $tagArray = explode(" ", $art->tags); foreach ($tagArray as $k => $v) { if ($DreamCMS->db->get_var("SELECT `count` FROM `#DC@__tags` WHERE `name`='{$v}'") == "1") { $DreamCMS->db->query("DELETE FROM `#DC@__tags` WHERE `name`='{$v}'"); } else { $DreamCMS->db->query("UPDATE `#DC@__tags` SET `count`=count-1 WHERE `name`='{$v}'"); } } } $DreamCMS->db->query("DELETE FROM `#DC@__file` WHERE `aid`='{$id}'"); $DreamCMS->db->query("DELETE FROM `#DC@__comment` WHERE aid='{$id}'"); $DreamCMS->db->query("DELETE FROM `#DC@__article` WHERE id='{$id}'"); $DreamCMS->db->query("DELETE FROM `#DC@__articledata` WHERE `id`='{$id}'"); $DreamCMS->db->query("UPDATE `#DC@__catalog` SET `count` = count-1 WHERE `id` ='{$art->cid}' LIMIT 1"); return true; }
function delArticle($id, $uid = '-1', $postype = '1') { global $iCMS; $sql = $uid != "-1" ? "and `userid`='{$uid}' and `postype`='{$postype}'" : ""; $id = (int) $id; $art = iCMS_DB::getRow("SELECT * FROM `#iCMS@__article` WHERE id='{$id}' {$sql} Limit 1"); if ($art->pic) { $usePic = iCMS_DB::getValue("SELECT id FROM `#iCMS@__article` WHERE `pic`='{$art->pic}' and `id`<>'{$id}'"); if (empty($usePic)) { $thumbfilepath = gethumb($art->pic, '', '', false, true, true); FS::del(uploadpath($art->pic, '+iPATH')); $msg .= $art->pic . ' 文件删除…<span style=\'color:green;\'>√</span><br />'; if ($thumbfilepath) { foreach ($thumbfilepath as $wh => $fp) { FS::del(uploadpath($fp, '+iPATH')); $msg .= '缩略图 ' . $wh . ' 文件删除…<span style=\'color:green;\'>√</span><br />'; } } $filename = FS::info($art->pic)->filename; iCMS_DB::query("DELETE FROM `#iCMS@__file` WHERE `filename` = '{$filename}'"); $msg .= $art->pic . ' 数据删除…<span style=\'color:green;\'>√</span><br />'; } else { $msg .= $art->pic . '文件 其它文章正在使用,请到文件管理删除…<span style=\'color:green;\'>×</span><br />'; } } $forum = $iCMS->getCache('system/forum.cache', $art->fid); $body = iCMS_DB::getValue("SELECT `body` FROM `#iCMS@__article_data` WHERE aid='{$id}' Limit 1"); if ($forum['mode'] && strstr($forum['contentRule'], '{PHP}') === false && empty($art->url)) { $bArray = explode('<!--iCMS.PageBreak-->', $body); $total = count($bArray); for ($i = 1; $i <= $total; $i++) { $iurl = $iCMS->iurl('show', array((array) $art, $forum), $i); FS::del($iurl->path); $msg .= $iurl->path . ' 静态文件删除…<span style=\'color:green;\'>√</span><br />'; } } $frs = iCMS_DB::getArray("SELECT `filename`,`path`,`ext` FROM `#iCMS@__file` WHERE `aid`='{$id}'"); for ($i = 0; $i < count($frs); $i++) { if (!empty($frs[$i])) { $path = $frs[$i]['path'] . '/' . $frs[$i]['filename'] . '.' . $frs[$i]['ext']; FS::del(uploadpath($frs[$i]['path'], '+iPATH')); $msg .= $path . ' 文件删除…<span style=\'color:green;\'>√</span><br />'; } } if ($art->tags) { $tagArray = explode(",", $art->tags); foreach ($tagArray as $k => $v) { if (iCMS_DB::getValue("SELECT `count` FROM `#iCMS@__tags` WHERE `name`='{$v}'") == "1") { iCMS_DB::query("DELETE FROM `#iCMS@__tags` WHERE `name`='{$v}'"); $iCMS->iCache->delete($iCMS->getTagKey($v)); } else { iCMS_DB::query("UPDATE `#iCMS@__tags` SET `count`=count-1 ,`updatetime`='" . time() . "' WHERE `name`='{$v}'"); } } iCMS_DB::query("DELETE FROM `#iCMS@__taglist` WHERE indexId='{$id}' AND modelId='0'"); $msg .= '标签更新…<span style=\'color:green;\'>√</span><br />'; } iCMS_DB::query("DELETE FROM `#iCMS@__file` WHERE `aid`='{$id}'"); $msg .= '相关文件数据删除…<span style=\'color:green;\'>√</span><br />'; iCMS_DB::query("DELETE FROM `#iCMS@__comment` WHERE indexId='{$id}' and mid='0'"); $msg .= '评论数据删除…<span style=\'color:green;\'>√</span><br />'; iCMS_DB::query("DELETE FROM `#iCMS@__article` WHERE id='{$id}'"); iCMS_DB::query("DELETE FROM `#iCMS@__article_data` WHERE `id`='{$id}'"); iCMS_DB::query("DELETE FROM `#iCMS@__vlink` WHERE indexId='{$id}' AND modelId='0'"); $msg .= '文章数据删除…<span style=\'color:green;\'>√</span><br />'; iCMS_DB::query("UPDATE `#iCMS@__forum` SET `count` = count-1 WHERE `fid` ='{$art->fid}' LIMIT 1"); $msg .= '栏目数据更新…<span style=\'color:green;\'>√</span><br />'; $msg .= '删除完成…<span style=\'color:green;\'>√</span><hr />'; return $msg; }
</table> <table class="tb tb2 " width="100%"> <tr> <th>文件名</th> <th>文件大小</th> <th>最后修改时间</th> </tr> <?php for ($i = 0; $i < count($L['FileList']); $i++) { //$operation=='template'?'templates':$iCMS->config['uploadfiledir'] if ($operation == 'template') { $filepath = $L['FileList'][$i]['path']; } elseif ($operation == 'file') { $filepath = $iCMS->config['uploadfiledir'] . "/" . $L['FileList'][$i]['path']; if (in_array($L['FileList'][$i]['ext'], array('jpg', 'gif', 'png', 'bmp', 'jpeg'))) { $thumbfilepath = gethumb($filepath, '', '', false, true); $li = ''; if ($thumbfilepath) { foreach ($thumbfilepath as $wh => $tfp) { $tfp = $iCMS->dir . getfilepath($tfp, iPATH, '-'); $li .= '<li><a href="javascript:void(0)" onclick="insert(\'' . $tfp . '\',\'' . $in . '\');" title="插入缩略图">' . $wh . '</a></li>'; } } } $filepath = $iCMS->dir . $filepath; } ?> <tr> <td><a href="<?php echo $Folder . "/" . $L['FileList'][$i]['path']; ?>
function doDelpic() { $id = (int) $_GET['id']; $fp = $_GET['fp']; if (empty($fp)) { return; } !$id && javascript::alert("请选择要删除图片的文章"); $thumbfilepath = gethumb($fp, '', '', false, true, true); FS::del(FS::fp($fp, '+iPATH')); if ($thumbfilepath) { foreach ($thumbfilepath as $wh => $tfp) { FS::del(FS::fp($tfp, '+iPATH')); } } $filename = FS::info($fp)->filename; iCMS_DB::query("DELETE FROM `#iCMS@__file` WHERE `filename` = '{$filename}'"); iCMS_DB::query("UPDATE `#iCMS@__article` SET `isPic`='0',`pic` = '' WHERE `id` = '{$id}'"); echo '<script type="text/javascript"> parent.$("#pic2").hide(); parent.$("#cpic1").hide(); parent.$("#pic1").show(); parent.$("[name=pic]").val("");</script>'; }
function delArticle($id, $uid = '-1', $postype = '1') { global $iCMS; $sql = $uid != "-1" ? "and `userid`='{$uid}' and `postype`='{$postype}'" : ""; $id = (int) $id; $art = $iCMS->db->getRow("SELECT * FROM `#iCMS@__article` WHERE id='{$id}' {$sql} Limit 1"); if ($art->pic) { $usePic = $iCMS->db->getValue("SELECT id FROM `#iCMS@__article` WHERE `pic`='{$art->pic}' and `id`<>'{$id}'"); if (empty($usePic)) { $thumbfilepath = gethumb($art->pic, '', '', true, true); delfile(iPATH . $art->pic); echo $art->pic . ' 文件删除…<span style="color:green;">√</span><br />'; if ($thumbfilepath) { foreach ($thumbfilepath as $wh => $fp) { delfile($fp); echo '缩略图 ' . $wh . ' 文件删除…<span style="color:green;">√</span><br />'; } } $iCMS->db->query("DELETE FROM `#iCMS@__file` WHERE `path` = '{$art->pic}'"); echo $art->pic . ' 数据删除…<span style="color:green;">√</span><br />'; } else { echo $art->pic . '文件 其它文章正在使用,请到文件管理删除…<span style="color:green;">×</span><br />'; } } $catalog = $iCMS->cache('catalog.cache', 'include/syscache', 0, true); $art->catalogdir = $iCMS->cdir($catalog[$art->cid]); $_urlArray = array('id' => $art->id, 'link' => $art->customlink, 'url' => $art->url, 'dir' => $art->catalogdir, 'pubdate' => $art->pubdate); $body = $iCMS->db->getValue("SELECT `body` FROM `#iCMS@__articledata` WHERE aid='{$id}' Limit 1"); if ($iCMS->config['ishtm'] && empty($art->url)) { $bArray = explode('<div style="page-break-after: always"><span style="display: none"> </span></div>', $body); $total = count($bArray); if ($total > 1) { for ($i = 0; $i <= $total; $i++) { $filename = $iCMS->iurl('show', $_urlArray, $i, iPATH); echo getfilepath($filename, iPATH, '-') . ' 静态文件删除…<span style="color:green;">√</span><br />'; delfile($filename, false); } } } $frs = $iCMS->db->getArray("SELECT `path` FROM `#iCMS@__file` WHERE `aid`='{$id}'"); for ($i = 0; $i < count($frs); $i++) { if (!empty($frs[$i])) { $frs[$i]['path'] && delfile(iPATH . $frs[$i]['path']); echo $frs[$i]['path'] . ' 文件删除…<span style="color:green;">√</span><br />'; } } if ($art->tags) { $tagArray = explode(",", $art->tags); foreach ($tagArray as $k => $v) { if ($iCMS->db->getValue("SELECT `count` FROM `#iCMS@__tags` WHERE `name`='{$v}'") == "1") { $iCMS->db->query("DELETE FROM `#iCMS@__tags` WHERE `name`='{$v}'"); } else { $iCMS->db->query("UPDATE `#iCMS@__tags` SET `count`=count-1 WHERE `name`='{$v}'"); } } echo ' 标签更新…<span style="color:green;">√</span><br />'; } $iCMS->db->query("DELETE FROM `#iCMS@__file` WHERE `aid`='{$id}'"); echo ' 相关文件数据删除…<span style="color:green;">√</span><br />'; $iCMS->db->query("DELETE FROM `#iCMS@__comment` WHERE aid='{$id}'"); echo ' 评论数据删除…<span style="color:green;">√</span><br />'; $iCMS->db->query("DELETE FROM `#iCMS@__article` WHERE id='{$id}'"); $iCMS->db->query("DELETE FROM `#iCMS@__articledata` WHERE `id`='{$id}'"); echo ' 文章数据删除…<span style="color:green;">√</span><br />'; $iCMS->db->query("UPDATE `#iCMS@__catalog` SET `count` = count-1 WHERE `id` ='{$art->cid}' LIMIT 1"); echo ' 栏目数据更新…<span style="color:green;">√</span><br />'; echo ' 删除完成…<span style="color:green;">√</span><br />'; return true; }
</table> <table class="tb tb2 " width="100%"> <tr> <th>文件名</th> <th>文件大小</th> <th>最后修改时间</th> </tr> <?php for ($i = 0; $i < count($L['FileList']); $i++) { //$operation=='template'?'templates':$DreamCMS->config['uploadfiledir'] if ($operation == 'template') { $filepath = $L['FileList'][$i]['path']; } elseif ($operation == 'file') { $filepath = $DreamCMS->config['uploadfiledir'] . "/" . $L['FileList'][$i]['path']; if (in_array($L['FileList'][$i]['ext'], array('jpg', 'gif', 'png', 'bmp', 'jpeg'))) { $thumbfilepath = gethumb($filepath); if ($thumbfilepath) { $from == "editor" && ($thumbfilepath = $DreamCMS->dir . $thumbfilepath); $Thumbnail = ' <a href="javascript:void(0)" onclick="insert(\'' . $thumbfilepath . '\',\'' . $in . '\');" title="插入缩略图"><img src="admin/images/file/image.gif" align="absmiddle" alt="缩略图"></a>'; } } $from == "editor" && ($filepath = $DreamCMS->dir . $filepath); } ?> <tr> <td><a href="<?php echo $Folder . "/" . $L['FileList'][$i]['path']; ?> " class="viewpic" target="_blank"><?php echo $L['FileList'][$i]['icon'];
function deletefile($fid) { global $iCMS; $rs = $iCMS->db->getRow("SELECT * FROM `#iCMS@__file` WHERE `id`='{$fid}' LIMIT 1"); $thumbfilepath = gethumb($rs->path, '', '', true, true); delfile(iPATH . $rs->path, false); echo $rs->path . ' 文件删除…<span style="color:green;">√</span><br />'; if ($thumbfilepath) { foreach ($thumbfilepath as $wh => $fp) { delfile($fp, false); echo '缩略图 ' . $wh . ' 文件删除…<span style="color:green;">√</span><br />'; } } $iCMS->db->query("UPDATE `#iCMS@__article` SET `pic`='' WHERE `pic`='{$rs->path}'"); $iCMS->db->query("DELETE FROM `#iCMS@__file` WHERE `id`='{$fid}' LIMIT 1"); return true; }
function delfile($fid) { $rs = iCMS_DB::getRow("SELECT * FROM `#iCMS@__file` WHERE `id`='{$fid}' LIMIT 1"); $path = $rs->path . '/' . $rs->filename . '.' . $rs->ext; $tfp = gethumb($path, '', '', false, true, true); FS::del(uploadpath($path, '+iPATH')); $msg = $path . ' 文件删除…<span style=\\"color:green;\\">√</span><br />'; if ($tfp) { foreach ($tfp as $wh => $fp) { FS::del(uploadpath($fp, '+iPATH')); $msg .= '缩略图 ' . $wh . ' 文件删除…<span style=\\"color:green;\\">√</span><br />'; } } iCMS_DB::query("UPDATE `#iCMS@__article` SET `pic`='' WHERE `pic`='{$path}'"); iCMS_DB::query("DELETE FROM `#iCMS@__file` WHERE `id`='{$fid}' LIMIT 1"); return $msg; }