Example #1
0
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);
}
Example #2
0
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);
}
Example #3
0
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;
}
Example #5
0
/**
 * フレンド申請を追加
 *
 * @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);
}
Example #6
0
/**
 * 日記コメント追加
 *
 * @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);
}
Example #7
0
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);
}
Example #8
0
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);
}
Example #9
0
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);
}
Example #10
0
/**
 * 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;
}