function execute($requests)
{
db_delete_c_skin_filename($requests['skinname']);
// スキンディレクトリの画像からコピーするスキン名
$skinname_list = array('no_image', 'no_logo', 'no_logo_small');
if (in_array($requests['skinname'], $skinname_list)) {
db_insert_c_image4skin_filename($requests['skinname']);
}
pne_cache_drop('fetch_inc_navi', 'h');
admin_client_redirect('edit_skin_image', '画像をデフォルトに戻しました');
}
function execute($requests)
{
db_delete_c_skin_filename('skin_ktai_header');
pne_cache_drop('fetch_inc_navi', 'h');
if (is_null(db_admin_c_admin_config4name('OPENPNE_USE_KTAI_LOGO'))) {
db_admin_insert_c_admin_config('OPENPNE_USE_KTAI_LOGO', !OPENPNE_USE_KTAI_LOGO);
} else {
db_admin_update_c_admin_config('OPENPNE_USE_KTAI_LOGO', !OPENPNE_USE_KTAI_LOGO);
}
admin_client_redirect('edit_skin_image', '携帯版ロゴ画像の表示設定を変更しました');
}
function execute($requests)
{
$value = $requests['value'];
if (!$value || preg_match('/[^\\.\\w]/', $value)) {
admin_client_redirect('edit_skin_image', 'スキン画像を変更できませんでした');
}
$name = 'OPENPNE_SKIN_THEME';
if (is_null(db_admin_c_admin_config4name($name))) {
db_admin_insert_c_admin_config($name, $value);
} else {
db_admin_update_c_admin_config($name, $value);
}
// カスタマイズスキン画像を全削除
db_delete_all_c_skin_filename($value);
pne_cache_drop('fetch_inc_navi', 'h');
admin_client_redirect('edit_skin_image', 'スキン画像を変更しました');
}
function execute($requests)
{
if (!$_FILES['upfile']['size']) {
admin_client_redirect('edit_skin_image', 'ファイルが指定されていません');
}
$prefix = sprintf('skin_%s', $requests['skinname']);
if ($fn = image_insert_c_image($_FILES['upfile'], $prefix)) {
if ($old_fn = db_get_c_skin_filename4skinname($requests['skinname'])) {
db_image_data_delete($old_fn);
}
// 携帯版ロゴ画像がアップロードされた場合は、ロゴの非表示設定を解除する
if ($requests['skinname'] == 'skin_ktai_header') {
if (is_null(db_admin_c_admin_config4name('OPENPNE_USE_KTAI_LOGO'))) {
db_admin_insert_c_admin_config('OPENPNE_USE_KTAI_LOGO', true);
} else {
db_admin_update_c_admin_config('OPENPNE_USE_KTAI_LOGO', true);
}
}
db_replace_c_skin_filename($requests['skinname'], $fn);
pne_cache_drop('fetch_inc_navi', 'h');
admin_client_redirect('edit_skin_image', 'スキン画像を変更しました');
}
admin_client_redirect('edit_skin_image', 'スキン画像を変更できませんでした');
}
function db_message_send_message_event_message($c_member_id_from, $c_member_id_to, $subject, $body)
{
// タイトルと本文中に書いてあるURLがSNS内でありセッションパラメータを含んでいた場合は削除
$subject = db_ktai_delete_url_session_parameter($subject);
$body = db_ktai_delete_url_session_parameter($body);
//メッセージ
db_message_insert_c_message($c_member_id_from, $c_member_id_to, $subject, $body);
pne_cache_drop('db_message_count_c_message_not_is_read4c_member_to_id', (int) $c_member_id_to);
pne_cache_drop('db_message_count_c_message_not_is_read4c_member_to_id', (string) $c_member_id_to);
do_common_send_message_event_message_mail_send($c_member_id_to, $c_member_id_from);
do_common_send_message_mail_send_ktai($c_member_id_to, $c_member_id_from, $subject, $body);
}
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 cacheを削除する
*
* @param int $c_member_id ログインしているメンバーID
* @param int $target_c_member_id 書き込み先のメンバーID
*/
function cache_drop_c_diary($c_member_id, $target_c_member_id)
{
$target_c_member_id = (int) $target_c_member_id;
$c_member_id = (int) $c_member_id;
pne_cache_drop('db_diary_get_c_diary_list4c_member_id', $target_c_member_id, 5, $c_member_id);
pne_cache_drop('p_h_home_c_diary_friend_list4c_member_id', $c_member_id, 5);
//最新日記フィード
$target_c_member_id = (string) $target_c_member_id;
$c_member_id = (string) $c_member_id;
pne_cache_drop('db_diary_get_c_diary_list4c_member_id', $target_c_member_id, 5, $c_member_id);
pne_cache_drop('p_h_home_c_diary_friend_list4c_member_id', $c_member_id, 5);
//最新日記フィード
$target_c_member_id = (int) $target_c_member_id;
$c_member_id = (string) $c_member_id;
pne_cache_drop('db_diary_get_c_diary_list4c_member_id', $target_c_member_id, 5, $c_member_id);
$target_c_member_id = (string) $target_c_member_id;
$c_member_id = (int) $c_member_id;
pne_cache_drop('db_diary_get_c_diary_list4c_member_id', $target_c_member_id, 5, $c_member_id);
}
function execute($requests)
{
db_replace_c_navi($requests['navi_type'], $requests['sort_order'], $requests['url'], $requests['caption']);
pne_cache_drop('fetch_inc_navi', $requests['navi_type']);
admin_client_redirect('edit_c_navi', '変更しました');
}
/**
* フレンド最新書き込みのホーム表示設定
*
* @param int $c_member_id_from (自分)
* @param int $c_member_id_to (対象となるマイフレンド)
* @param int $is_display_friend_home (表示するか否か)
*/
function db_friend_update_is_display_friend_home($c_member_id_from, $c_member_id_to, $is_display_friend_home)
{
pne_cache_drop('p_h_home_c_diary_friend_list4c_member_id', (int) $c_member_id_from, 5, true);
pne_cache_drop('p_h_home_c_diary_friend_list4c_member_id', (string) $c_member_id_from, 5, true);
$data = array('is_display_friend_home' => (bool) $is_display_friend_home);
$where = array('c_member_id_from' => intval($c_member_id_from), 'c_member_id_to' => intval($c_member_id_to));
return db_update('c_friend', $data, $where);
}
function execute($requests)
{
db_delete_c_navi($requests['navi_type'], $requests['sort_order']);
pne_cache_drop('fetch_inc_navi', $requests['navi_type']);
admin_client_redirect('edit_c_navi', 'リセットしました');
}
/**
* 日記コメント追加
*
* @param int $c_member_id
* @param int $c_diary_id
* @param string $body
* @return int insert_id
*/
function db_diary_insert_c_diary_comment($c_member_id, $c_diary_id, $body)
{
//function cache削除
$c_diary = db_diary_get_c_diary4id($c_diary_id);
cache_drop_c_diary($c_member_id, $c_diary['c_member_id']);
pne_cache_drop('p_h_home_c_diary_my_comment_list4c_member_id', $c_member_id, 5);
// 本文中に書いてあるURLがSNS内でありセッションパラメータを含んでいた場合は削除
$body = db_ktai_delete_url_session_parameter($body);
$data = array('c_member_id' => intval($c_member_id), 'c_diary_id' => intval($c_diary_id), 'body' => $body, 'r_datetime' => db_now(), 'image_filename_1' => '', 'image_filename_2' => '', 'image_filename_3' => '', 'number' => db_diary_get_max_c_diary_comment_number4diary($c_diary_id) + 1);
return db_insert('c_diary_comment', $data);
}
/**
* 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;
}
/**
* 日記削除
* コメント、画像も削除
*
* @param int $c_diary_id
*/
function kanshi_db_diary_delete_c_diary($c_diary_id)
{
if ($c_diary = db_diary_get_c_diary4id($c_diary_id)) {
//function cacheの削除
pne_cache_drop('db_diary_get_c_diary_list4c_member_id', $c_diary['c_member_id'], 5);
// 画像
image_data_delete($c_diary['image_filename_1']);
image_data_delete($c_diary['image_filename_2']);
image_data_delete($c_diary['image_filename_3']);
// コメント
$sql = 'SELECT image_filename_1, image_filename_2, image_filename_3 FROM c_diary_comment WHERE c_diary_id =?';
$params = array(intval($c_diary_id));
$comment_images = db_get_all($sql, $params);
//カテゴリ
db_diary_category_delete_c_diary_category_diary($c_diary_id);
foreach ($comment_images as $value) {
image_data_delete($value['image_filename_1']);
image_data_delete($value['image_filename_2']);
image_data_delete($value['image_filename_3']);
}
$sql = 'DELETE FROM c_diary_comment WHERE c_diary_id = ?';
db_query($sql, $params);
// 日記
$sql = 'DELETE FROM c_diary WHERE c_diary_id = ?';
if (db_query($sql, $params)) {
return array(1, 0, '');
} else {
return array(0, 2, 'DB更新エラー');
}
} else {
// return array(0, 99, '既に削除されているか存在しません');
// 監視ツールがリトライを行ってしまう為、成功フラグを返してしまう
return array(1, 0, '');
}
}
function db_admin_delete_c_profile($c_profile_id)
{
$params = array(intval($c_profile_id));
// メンバーのプロフィールから削除
$sql = 'DELETE FROM c_member_profile WHERE c_profile_id = ?';
db_query($sql, $params);
// 選択肢項目を削除
$sql = 'DELETE FROM c_profile_option WHERE c_profile_id = ?';
db_query($sql, $params);
// プロフィール項目を削除
$sql = 'DELETE FROM c_profile WHERE c_profile_id = ?';
db_query($sql, $params);
pne_cache_drop('db_member_c_profile_list');
}
/**
* コミュニティホームの新着表示設定変更
*/
function db_commu_update_is_display_topic_home($c_commu_id, $c_member_id, $is_display_topic_home)
{
pne_cache_drop('db_commu_c_commu_topic_comment_list4c_member_id', (int) $c_member_id, 5, true);
pne_cache_drop('db_commu_c_commu_topic_comment_list4c_member_id', (string) $c_member_id, 5, true);
$data = array('is_display_topic_home' => (bool) $is_display_topic_home);
$where = array('c_commu_id' => intval($c_commu_id), 'c_member_id' => intval($c_member_id));
return db_update('c_commu_member', $data, $where);
}
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;
}
