function execute($requests)
{
$tail = $GLOBALS['KTAI_URL_TAIL'];
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$ktai_address = $requests['ktai_address'];
// ----------
$ktai_address = str_replace('"', '', $ktai_address);
//--- 権限チェック
//必要なし?
//---
if (!db_common_is_mailaddress($ktai_address)) {
// メールアドレスを入力してください
$p = array('msg' => 12);
openpne_redirect('ktai', 'page_h_regist_address', $p);
}
if (!is_ktai_mail_address($ktai_address)) {
// 携帯メールアドレス以外は指定できません
$p = array('msg' => 16);
openpne_redirect('ktai', 'page_h_regist_address', $p);
}
if (db_member_is_sns_join4mail_address($ktai_address)) {
// このメールアドレスはすでに登録されています
$p = array('msg' => 17);
openpne_redirect('ktai', 'page_h_regist_address', $p);
}
db_member_delete_c_member_ktai_pre4id($ktai_address);
db_member_delete_c_ktai_address_pre4ktai_address($ktai_address);
$session = create_hash();
db_member_insert_c_ktai_address_pre($u, $session, $ktai_address);
//function cache削除
cache_drop_c_member_profile($u);
do_mail_sns_change_ktai_mail_send($u, $session, $ktai_address);
openpne_redirect('ktai', 'page_o_send_mail_end');
}
function db_admin_update_is_login_rejected($c_member_id)
{
// function cacheを削除
cache_drop_c_member_profile($c_member_id);
$sql = 'SELECT is_login_rejected FROM c_member WHERE c_member_id = ?';
$params = array(intval($c_member_id));
$is_login_rejected = db_get_one($sql, $params);
if (is_null($is_login_rejected)) {
return false;
}
$data = array('is_login_rejected' => !$is_login_rejected);
$where = array('c_member_id' => intval($c_member_id));
return db_update('c_member', $data, $where);
}
function db_member_update_is_shinobiashi($c_member_id, $is_shinobiashi)
{
// function cacheを削除
cache_drop_c_member_profile($c_member_id);
$data = array('is_shinobiashi' => intval($is_shinobiashi));
$where = array('c_member_id' => intval($c_member_id));
db_update('c_member', $data, $where);
}
