public function recoverMaterialState($id, $app_bundle) { if (empty($id)) { return false; } $sql = "SELECT bundle_id, filepath, filename, bs FROM " . DB_PREFIX . "material WHERE id IN(" . $id . ")"; $q = $this->db->query($sql); while ($row = $this->db->fetch_array($q)) { //改文件名,源文件的,然后根据缩略图的那个文件也改掉地址!!! hg_editTrue_material(hg_getimg_dir($row["bs"]) . app_to_dir($row['bundle_id']) . $row['filepath'], $row['filename']); } $sql = "UPDATE " . DB_PREFIX . "material SET isdel=1 WHERE id IN(" . $id . ")"; $this->db->query($sql); return true; }
/** * 根据路径、文件名删除图片 * Enter description here ... */ function delMaterialNodb() { if (empty($this->input['path'])) { $this->errorOutput(NOPATH); } if (empty($this->input['filename'])) { $this->errorOutput(NONAME); } $path = $this->input['path']; $filename = $this->input['filename']; hg_editTrue_material(hg_getimg_default_dir() . $path, $filename); hg_delete_material(hg_getimg_default_dir() . $path, $filename); $this->addItem('true'); $this->output(); }
public function delete() { $id = urldecode($this->input['id']); $sql = "SELECT * FROM " . DB_PREFIX . "material WHERE id IN(" . $id . ")"; $r = $this->db->query($sql); while ($row = $this->db->fetch_array($r)) { hg_editTrue_material(hg_getimg_dir($row["bs"]) . app_to_dir($row['bundle_id']) . $row['filepath'], $row['filename']); hg_delete_material(hg_getimg_dir($row["bs"]) . app_to_dir($row['bundle_id']) . $row['filepath'], $row['filename']); } $sql = "DELETE FROM " . DB_PREFIX . "material WHERE id IN(" . $id . ")"; $this->db->query($sql); return true; }