/** * メッセージをごみ箱から削除 */ function db_message_delete_c_message_from_trash($c_message_id, $c_member_id) { $data = array('is_kanzen_sakujo_from' => 1); $where = 'c_message_id = ' . intval($c_message_id); db_update('c_message', $data, $where); $sql = 'SELECT * FROM c_message WHERE c_message_id = ?'; $params = array(intval($c_message_id)); $c_message = db_get_row($sql, $params); //c_image_sizeのレコード削除 $where = array(); $params = array(); $sql = 'DELETE FROM c_image_size'; if ($c_message['image_filename_1']) { $where[] = "filename = ?"; $params[] = $c_message['image_filename_1']; } if ($c_message['image_filename_2']) { $where[] = "filename = ?"; $params[] = $c_message['image_filename_2']; } if ($c_message['image_filename_3']) { $where[] = "filename = ?"; $params[] = $c_message['image_filename_3']; } if ($where) { $sql .= " WHERE " . implode(' OR ', $where); db_query($sql, $params); } //function cacheの削除 $category = util_image_filename2category($filename); pne_cache_drop('db_image_get_image_filesize', $c_member_id, $category); }
/** * c_image_sizeテーブルにレコードを登録する * * @param string $filename * @param int $c_member_id * @param int $filesize * @return bool */ function db_image_insert_c_image_size($filename, $c_member_id, $filesize, $category = '') { $result = true; if ($c_member_id) { if (!$category) { $category = util_image_filename2category($filename); } $params = array('filename' => $filename, 'c_member_id' => $c_member_id, 'filesize' => $filesize, 'image_category' => $category, 'r_datetime' => db_now()); $result = db_insert('c_image_size', $params); //function cacheの削除 pne_cache_drop('db_image_get_image_filesize', $c_member_id, $category); } return $result; }
function biz_deleteImage($filename, $c_member_id) { if (!$filename) { return false; } $sql = 'DELETE FROM c_image WHERE filename = ?'; $params = array($filename); db_query($sql, $params); $sql = 'DELETE FROM c_image_size WHERE filename = ?'; db_query($sql, $params); // cacheの削除 image_cache_delete($filename); //function cacheの削除 $category = util_image_filename2category($filename); pne_cache_drop('db_image_get_image_filesize', $c_member_id, $category); }
function db_album_image_delete_c_image($filename, $c_member_id, $category) { $db =& db_get_instance('image'); $sql = 'DELETE FROM c_image WHERE filename = ?'; $params = array($filename); $db->query($sql, $params); $sql = 'DELETE FROM c_image_size WHERE filename = ?'; $params = array($filename); $db->query($sql, $params); //function cacheの削除 if (!$category) { $category = util_image_filename2category($filename); } pne_cache_drop('db_image_get_image_filesize', $c_member_id, $category); return true; }