function execute($requests)
{
$tail = $GLOBALS['KTAI_URL_TAIL'];
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_diary_comment_id = $requests['target_c_diary_comment_id'];
// ----------
$c_diary_comment = _do_c_diary_comment4c_diary_comment_id($target_c_diary_comment_id);
$target_c_member_id = $c_diary_comment['c_member_id'];
//--- 権限チェック
//日記作成者 or コメント作成者
$c_diary = db_diary_get_c_diary4id($c_diary_comment['c_diary_id']);
if ($c_diary['c_member_id'] != $u && $c_diary_comment['c_member_id'] != $u) {
handle_kengen_error();
}
//---
db_diary_delete_c_diary_comment($target_c_diary_comment_id, $u);
//コメント記入履歴削除実行
db_diary_delete_c_diary_comment_log($target_c_member_id, $c_diary_comment['c_diary_id']);
$p = array('target_c_diary_id' => $c_diary['c_diary_id']);
openpne_redirect('ktai', 'page_fh_diary', $p);
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
$target_c_diary_comment_id = $_REQUEST['target_c_diary_comment_id'];
foreach ($target_c_diary_comment_id as $val) {
//--- 権限チェック
//日記作成者 or コメント作成者
$target_c_diary_comment = _do_c_diary_comment4c_diary_comment_id($val);
$target_c_diary_id = $target_c_diary_comment['c_diary_id'];
$c_diary = db_diary_get_c_diary4id($target_c_diary_id);
if ($c_diary['c_member_id'] != $u && $target_c_diary_comment['c_member_id'] != $u) {
handle_kengen_error();
}
//---
//コメント削除実行
db_diary_delete_c_diary_comment($val, $u);
//コメント記入履歴削除実行
db_diary_delete_c_diary_comment_log($target_c_diary_comment['c_member_id'], $target_c_diary_id);
}
$p = array('target_c_diary_id' => $target_c_diary_id);
openpne_redirect('pc', 'page_fh_diary', $p);
}
/**
* メンバーの日記とコメントを削除
*
* @param int $c_member_id
*/
function db_diary_delete4c_member_id($c_member_id)
{
$sql = 'SELECT * FROM c_diary WHERE c_member_id = ?';
$single = array(intval($c_member_id));
$c_diary_list = db_get_all($sql, $single, 'main');
foreach ($c_diary_list as $c_diary) {
db_image_data_delete($c_diary['image_filename_1']);
db_image_data_delete($c_diary['image_filename_2']);
db_image_data_delete($c_diary['image_filename_3']);
// c_diary_comment
$sql = 'SELECT * FROM c_diary_comment WHERE c_diary_id = ?';
$params = array(intval($c_diary['c_diary_id']));
$c_diary_comment_list = db_get_all($sql, $params, 'main');
foreach ($c_diary_comment_list as $c_diary_comment) {
db_image_data_delete($c_diary_comment['image_filename_1']);
db_image_data_delete($c_diary_comment['image_filename_2']);
db_image_data_delete($c_diary_comment['image_filename_3']);
}
$sql = 'DELETE FROM c_diary_comment WHERE c_diary_id = ?';
db_query($sql, $params);
db_diary_delete_c_diary_comment_log($c_member_id, $c_diary['c_diary_id']);
}
$sql = 'DELETE FROM c_diary WHERE c_member_id = ?';
db_query($sql, $single);
}
