function db_schedule_edit_update_c_schedule($c_member_id, $title, $body, $start_date, $start_time, $end_date, $end_time, $is_receive_mail, $c_schedule_id) { // タイトルと本文中に書いてあるURLがSNS内でありセッションパラメータを含んでいた場合は削除 $title = db_ktai_delete_url_session_parameter($title); $body = db_ktai_delete_url_session_parameter($body); $data = array('c_member_id' => intval($c_member_id), 'title' => $title, 'body' => $body, 'start_date' => $start_date, 'start_time' => $start_time, 'end_date' => $end_date, 'end_time' => $end_time, 'u_datetime' => db_now(), 'is_receive_mail' => (bool) $is_receive_mail); $where = array('c_schedule_id' => intval($c_schedule_id)); return db_update('c_schedule', $data, $where); }
function db_message_update_c_message($c_message_id, $subject, $body, $image_filename_1 = '', $image_filename_2 = '', $image_filename_3 = '', $filename = '') { // タイトルと本文中に書いてあるURLがSNS内でありセッションパラメータを含んでいた場合は削除 $subject = db_ktai_delete_url_session_parameter($subject); $body = db_ktai_delete_url_session_parameter($body); $data = array('subject' => $subject, 'body' => $body); if ($image_filename_1) { $data['image_filename_1'] = $image_filename_1; } if ($image_filename_2) { $data['image_filename_2'] = $image_filename_2; } if ($image_filename_3) { $data['image_filename_3'] = $image_filename_3; } if ($filename) { $data['filename'] = $filename; } $where = array('c_message_id' => intval($c_message_id)); return db_update('c_message', $data, $where); }
function do_common_send_message_mail_send_ktai($c_member_id_to, $c_member_id_from, $subject = '', $body = '') { $c_member_to = db_member_c_member4c_member_id($c_member_id_to, true); $ktai_address = $c_member_to['secure']['ktai_address']; $is_receive_ktai_mail = $c_member_to['is_receive_ktai_mail']; $p = array('kad' => t_encrypt(db_member_username4c_member_id($c_member_to['c_member_id'], true))); $login_url = openpne_gen_url('ktai', 'page_o_login', $p); // メッセージ中に書いてあるURLがSNS内でありセッションパラメータを含んでいた場合は削除 $body = db_ktai_delete_url_session_parameter($body); $params = array('c_member_to' => db_member_c_member4c_member_id($c_member_id_to), 'c_member_from' => db_member_c_member4c_member_id($c_member_id_from), 'login_url' => $login_url, 'subject' => $subject, 'body' => $body); return fetch_send_mail($ktai_address, 'm_ktai_message_zyushin', $params, $is_receive_ktai_mail); }
function biz_editTodo($member_id, $memo, $writer_id, $sort_order, $is_all, $biz_todo_id, $is_done, $due_datetime, $priority, $biz_group_id, $public_flag) { $todo = biz_getTodo($biz_todo_id); if ($is_all) { //共有Todo $member_id = 0; } elseif ($member_id == $writer_id) { $writer_name = ''; } if ($is_done != $todo['is_check']) { biz_checkTodo($biz_todo_id, $todo['is_check']); } $sql = 'UPDATE biz_todo SET c_member_id = ?, memo = ?, writer_id = ?,' . 'r_datetime = ?, due_datetime = ?, priority = ?, biz_group_id = ?,' . 'public_flag = ? WHERE biz_todo_id = ?'; $params = array(intval($member_id), db_ktai_delete_url_session_parameter($memo), intval($writer_id), date("Y-m-d H:i"), $due_datetime, intval($priority), intval($biz_group_id), $public_flag, intval($biz_todo_id)); $result = db_query($sql, $params); return $result; }
/** * フレンド申請を追加 * * @param int $c_member_id_from * @param int $c_member_id_to * @param string $message * @return int insert_id */ function db_friend_insert_c_friend_confirm($c_member_id_from, $c_member_id_to, $message) { // タイトルと本文中に書いてあるURLがSNS内でありセッションパラメータを含んでいた場合は削除 $message = db_ktai_delete_url_session_parameter($message); $data = array('c_member_id_from' => intval($c_member_id_from), 'c_member_id_to' => intval($c_member_id_to), 'message' => $message, 'r_datetime' => db_now()); return db_insert('c_friend_confirm', $data); }
/** * 日記コメント追加 * * @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); }
function create_message_friend_link_request($u, $body) { $msg_subject = WORD_FRIEND . 'リンク要請メッセージ'; $c_member_id_from = $u; $c_member = db_member_c_member4c_member_id_LIGHT($u); $WORD_FRIEND = WORD_FRIEND; // メッセージ中に書いてあるURLがSNS内でありセッションパラメータを含んでいた場合は削除 $body = db_ktai_delete_url_session_parameter($body); $msg_body = <<<EOD {$c_member['nickname']} さんから{$WORD_FRIEND}リンク要請のメッセージが届いています。 メッセージ: {$body} この要請について、承認待ちリストから承認または拒否を選択してください。 EOD; return array($msg_subject, $msg_body); }
function db_commu_insert_c_commu_topic_comment_3($comment) { cache_drop_c_commu_list4c_member_id($comment['c_member_id']); db_commu_update_c_commu_topic_u_datetime(intval($comment['c_commu_topic_id'])); // タイトルと本文中に書いてあるURLがSNS内でありセッションパラメータを含んでいた場合は削除 $comment['body'] = db_ktai_delete_url_session_parameter($comment['body']); $data = array('c_commu_id' => intval($comment['c_commu_id']), 'c_member_id' => intval($comment['c_member_id']), 'body' => strval($comment['body']), 'number' => intval($comment['number']), 'c_commu_topic_id' => intval($comment['c_commu_topic_id']), 'image_filename1' => strval($comment['image_filename1']), 'image_filename2' => strval($comment['image_filename2']), 'image_filename3' => strval($comment['image_filename3']), 'filename' => strval($comment['filename4']), 'r_datetime' => db_now(), 'r_date' => db_now()); return db_insert('c_commu_topic_comment', $data); }
function db_member_insert_c_member_pre_profile($c_member_pre_id, $c_profile_id, $c_profile_option_id, $value, $public_flag) { // プロフィール中に書いてあるURLがSNS内でありセッションパラメータを含んでいた場合は削除 $value = db_ktai_delete_url_session_parameter($value); $data = array('c_member_pre_id' => intval($c_member_pre_id), 'c_profile_id' => intval($c_profile_id), 'c_profile_option_id' => intval($c_profile_option_id), 'value' => $value, 'public_flag' => $public_flag); return db_insert('c_member_pre_profile', $data); }
/** * c_album_imageの新規登録 * * @param int $c_album_id * @param int $c_member_id * @param string $image_filename * @param string $image_description * @param int $filesize */ function db_insert_c_album_image($c_album_id, $c_member_id, $image_filename, $image_description, $filesize = 0) { // 写真説明に書いてあるURLがSNS内でありセッションパラメータを含んでいた場合は削除 $image_description = db_ktai_delete_url_session_parameter($image_description); $data = array('c_album_id' => $c_album_id, 'c_member_id' => $c_member_id, 'image_description' => $image_description, 'image_filename' => $image_filename, 'filesize' => $filesize, 'r_datetime' => db_now()); $insert_id = db_insert('c_album_image', $data); if ($insert_id) { db_album_update_c_album_u_datetime($c_album_id); } return $insert_id; }