public static function delServiceFiles($service_id, $filename, $type) { $service_info = db_factory::get_one(sprintf("select * from %switkey_service where service_id='%d' ", TABLEPRE, intval($service_id))); $filelist = array(); if ($type == 'pic') { if ($service_info['pic']) { $filelist = explode(',', $service_info['pic']); } } else { if ($service_info['file_path']) { $filelist = explode(',', $service_info['file_path']); } } if ($filelist) { CommonClass::delFileBySavename($filename); $newlist = array(); foreach ($filelist as $k => $v) { if ($filename != $v) { $newlist[] = $v; } } } $filepath = ''; if ($newlist) { $filepath = implode(',', $newlist); } if ($type == 'pic') { $sql = "UPDATE `" . TABLEPRE . "witkey_service` SET `pic`='{$filepath}' WHERE (`service_id`='{$service_id}')"; } else { $sql = "UPDATE `" . TABLEPRE . "witkey_service` SET `file_path`='{$filepath}' WHERE (`service_id`='{$service_id}')"; } return db_factory::execute($sql); }