/**
* メッセージをごみ箱から削除
*/
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;
}
