PHP MooFastdbUpdate函数代码示例

/**
@param （忘记密码）通过地址栏用户名和新密码登陆
@param return null
*/
function find_pwd()
{
    global $_MooClass, $dbTablePre, $userid, $_MooCookie;
    //	if($userid){
    //		return;
    //	}
    $uid = MooGetGPC('uid', 'string', G);
    $pwd = MooGetGPC('upwd', 'string', G);
    /*	echo md5($uid).'<br>';
    	echo md5($pwd);
    	print_r($_COOKIE);
    	exit;
    */
    if ($_MooCookie['findpwd'] == md5($pwd) && md5($uid) == $_MooCookie['finduser']) {
        $newpwd = md5(base64_decode($pwd));
        //note 修改密码
        //$_MooClass['MooMySQL']->query("update {$dbTablePre}members set password = '{$newpwd}' where uid = '{$uid}'");
        //if(MOOPHP_ALLOW_FASTDB){
        //			MooFastdbUpdate('members','uid',$uid);
        //		}
        MooSetCookie('auth', MooAuthCode("{$uid}\t{$newpwd}", 'ENCODE'), 86400);
        //note 写入session表需要的字段值
        $online_ip = GetIP();
        $lastactive = $GLOBALS['timestamp'];
        //$uid = $user['uid'];
        //note 更新用户的最近登录ip和最近登录时间
        $updatesqlarr = array('lastip' => $online_ip, 'lastvisit' => $lastactive, 'password' => $newpwd);
        $wheresqlarr = array('uid' => $uid);
        updatetable("members_search", $updatesqlarr, $wheresqlarr);
        if (MOOPHP_ALLOW_FASTDB) {
            $val = array();
            $val['lastip'] = $online_ip;
            $val['lastvisit'] = $lastactive;
            $val['password'] = $newpwd;
            MooFastdbUpdate('members_search', 'uid', $uid, $val);
            //!!
        }
        //note 先删除表里面已存在对应用户的session
        //$_MooClass['MooMySQL']->query("DELETE FROM `{$dbTablePre}membersession` WHERE `uid` ='$uid'");
        //$_MooClass['MooMySQL']->query("REPLACE INTO `{$dbTablePre}membersession` SET `username`= '$user[username]',`password`='$user[password]',`ip` = '$online_ip',`lastactive` = '$lastactive',`uid` = '$uid'");
        return 1;
    }
    return 0;
}

function active_email()
{
    global $_MooClass;
    $uid = $u['uid'] = MooGetGPC('uid', 'string');
    $verifycode = MooGetGPC('verifycode', 'string');
    $username = $u['username'] = MooGetGPC('p', 'string');
    if ($verifycode == strtoupper(md5('hongniangwang' . $u['uid'] . $u['username']))) {
        $online_ip = GetIP();
        $t = time();
        $pass = md5('123456');
        $r = $_MooClass['MooMySQL']->getOne("select * from web_activelog where uid={$uid}  limit 1", true);
        if ($r['username'] == $username) {
            MooMessage("您已经激活过了", "index.php", "05");
        } else {
            //$_MooClass['MooMySQL']->query("update web_members_search,web_members_login set password='$pass',usertype=1,regdate='$t',last_login_time = '$t',login_meb = login_meb+1,lastip='$online_ip',lastvisit='$t'  where uid='$uid'");
            $_MooClass['MooMySQL']->query("update web_members_search as s,web_members_login as l set s.password='{$pass}',s.usertype=1,s.regdate='{$t}',l.last_login_time = '{$t}',l.lastip='{$online_ip}',l.lastvisit='{$t}'  where s.uid='{$uid}' and l.uid='{$uid}'");
            searchApi('members_man members_women')->updateAttr(array('usertype', 'regdate'), array($uid => array(1, $t)));
            $_MooClass['MooMySQL']->query("insert into web_activelog(uid,username,activetime) values('{$uid}','{$username}','{$t}')");
        }
        MooSetCookie('auth', MooAuthCode("{$uid}\t{$pass}", 'ENCODE'), 86400);
        MooSetCookie('username', $u['username'], time() + 3600);
        if (MOOPHP_ALLOW_FASTDB) {
            $user11 = MooFastdbGet('members_search', 'uid', $uid);
            $meb = $user11['login_meb'];
            $val_s = $val_l = array();
            $val_s['password'] = $pass;
            $val_s['usertype'] = 1;
            $val_s['regdate'] = $t;
            $val_l['last_login_time'] = $t;
            $val_l['login_meb'] = $meb + 1;
            $val_l['lMooFastdbUpdateastip'] = $online_ip;
            $val_l['lastvisit'] = $t;
            MooFastdbUpdate('members_search', 'uid', $uid, $val_s);
            //!!
            MooFastdbUpdate('members_login', 'uid', $uid, $val_l);
        }
        //$_MooClass['MooMySQL']->query("INSERT INTO `web_membersession` SET `username`= '$u[username]',`password`='$pass',`ip` = '$online_ip',`lastactive` = '$t',`uid` = '$uid'");
        MooMessage("验证激活成功", "index.php", "05");
    } else {
        MooMessage("参数有误！请注册", "index.php", "02");
    }
}

function ajax_sendmes()
{
    $sender = MooGetGPC('sender', 'integer', 'P');
    $receiver = MooGetGPC('receiver', 'integer', 'P');
    $mes = MooGetGPC('mes', 'string', 'P');
    $time = time();
    $sql = "INSERT INTO {$GLOBALS['dbTablePre']}service_chat(s_uid,s_fromid,s_content,s_time,s_status,is_server,dealstate)\n\t\t\tVALUE({$receiver},{$sender},'{$mes}',{$time},0,{$GLOBALS['adminid']},1)";
    $GLOBALS['_MooClass']['MooMySQL']->query($sql);
    //伪造会员在线
    $time = time();
    $sql = "UPDATE {$GLOBALS['dbTablePre']}members_login SET lastvisit = {$time} WHERE uid = {$sender}";
    $GLOBALS['_MooClass']['MooMySQL']->query($sql);
    if (MOOPHP_ALLOW_FASTDB) {
        MooFastdbUpdate('members_login', 'uid', $sender);
    }
    //写日志
    serverlog(4, $GLOBALS['dbTablePre'] . 'service_chat', "{$GLOBALS['adminid']}号客服{$GLOBALS['username']}在后台以会员{$sender}的身份与会员{$receiver}聊天", $GLOBALS['adminid']);
    echo 'ok';
    exit;
}

function check_member_voice()
{
    $uid = MooGetGPC('uid', 'string');
    $sql = "select a.birthyear,a.gender,b.uid,b.toshoot_voice_check,b.toshoot_voice_url from {$GLOBALS['dbTablePre']}certification b left join {$GLOBALS['dbTablePre']}members a on a.uid=b.uid where b.uid={$uid}";
    $member_voice = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
    $value = array();
    //录音存储路径
    $path_url = strtolower(substr($_SERVER['SERVER_PROTOCOL'], 0, strpos($_SERVER['SERVER_PROTOCOL'], '/'))) . '://' . $_SERVER['HTTP_HOST'];
    $voice_path = $path_url . '/' . $member_voice['toshoot_voice_url'] . '/voi_' . $uid . '.flv';
    if ($_POST) {
        $is_pass = MooGetGPC('pass', 'string');
        $is_onpass = MooGetGPC('nopass', 'string');
        if ($is_onpass) {
            if ($member_voice['toshoot_voice_check'] == 2) {
                $sql = "update {$GLOBALS['dbTablePre']}certification set toshoot_voice_check='1' where uid={$uid}";
                $GLOBALS['_MooClass']['MooMySQL']->query($sql);
            }
            if (MOOPHP_ALLOW_FASTDB) {
                $value['toshoot_video_check'] = 1;
                MooFastdbUpdate('certification', 'uid', $uid, $value);
            }
            sendusermessage($uid, "尊敬的红娘会员，您的录音不符合要求，请重新录音！", "录音审核");
            echo "<script>alert('审核不通过！')</script>";
            exit;
        } elseif ($is_pass) {
            $sql = "update {$GLOBALS['dbTablePre']}certification set toshoot_voice_check='2' where uid={$uid}";
            $GLOBALS['_MooClass']['MooMySQL']->query($sql);
            if (MOOPHP_ALLOW_FASTDB) {
                $value['toshoot_video_check'] = 2;
                MooFastdbUpdate('certification', 'uid', $uid, $value);
            }
            sendusermessage($uid, "尊敬的红娘会员，您的录音已经通过红娘的审核！", "录音审核");
            echo "<script>alert('审核通过!');window.history.go(-1);</script>";
            exit;
        }
    }
    require_once adminTemplate('check_member_voice');
}

/**
@param 给会员加鲜花
@param $uid 会员ID
@param $num 默认加一朵鲜花
@param return null
*/
function MooAddRose($uid, $num = 1)
{
    global $_MooClass, $dbTablePre;
    if ($uid) {
        $_MooClass['MooMySQL']->query("update {$dbTablePre}members_base set rosenumber = rosenumber+{$num} where uid = {$uid} and is_lock = 1");
        if (MOOPHP_ALLOW_FASTDB) {
            $user_inf = MooFastdbGet('members_base', 'uid', $uid);
            $value['rosenumber'] = $user_inf['rosenumber'] + $num;
            MooFastdbUpdate('members_base', 'uid', $uid, $value);
        }
    }
}

function reg_modifytel()
{
    global $userid, $dbTablePre, $_MooClass;
    $tel_val = MooGetGPC('tel_val', 'string', 'G');
    $sql = "update {$dbTablePre}members_search set telphone='{$tel_val}' where uid='{$userid}'";
    if ($_MooClass['MooMySQL']->query($sql)) {
        $tel['telphone'] = $tel_val;
        if (MooFastdbUpdate('members_search', 'uid', $userid, $tel)) {
            echo 'ok';
        }
    }
}

function myuser_delmyuser()
{
    global $h;
    $currenturl = 'http://' . $_SERVER['SERVER_NAME'] . ':' . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"];
    //所管理的客服id列表
    $myservice_idlist = get_myservice_idlist();
    $uid = MooGetGPC('uid', 'integer', 'G');
    $sql = "SELECT sid FROM {$GLOBALS['dbTablePre']}members_search WHERE uid='{$uid}'";
    $sid = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
    if ($sid['sid'] == $GLOBALS['adminid'] || $myservice_idlist == 'all' || in_array($sid['sid'], $myservice_idlist)) {
        //members表sid清0
        $sql = "UPDATE {$GLOBALS['dbTablePre']}members_search  SET sid='0' WHERE uid='{$uid}' ";
        $GLOBALS['_MooClass']['MooMySQL']->query($sql);
        searchApi('members_man members_women')->updateAttr(array('sid'), array($uid => array(0)));
        if (MOOPHP_ALLOW_FASTDB) {
            $arr = array();
            $arr['sid'] = 0;
            MooFastdbUpdate('members_search', 'uid', $uid, $arr);
        }
        //对应的维护会员总数减1
        $sql = "UPDATE {$GLOBALS['dbTablePre']}admin_user SET member_count=member_count-1 WHERE uid='{$sid['sid']}'";
        $GLOBALS['_MooClass']['MooMySQL']->query($sql);
        //后台扩展表标记为删除状态
        $sql = "UPDATE {$GLOBALS['dbTablePre']}member_admininfo SET is_delete=1 WHERE uid='{$uid}'";
        $GLOBALS['_MooClass']['MooMySQL']->query($sql);
        //写日志
        serverlog(3, $GLOBALS['dbTablePre'] . 'members_search', "{$GLOBALS['username']}客服将自己的会员{$uid}删除放弃", $GLOBALS['adminid'], $uid);
        salert('删除成功');
    } else {
        salert('操作不合法');
    }
}

//.........这里部分代码省略.........
    		}
    	
    	}*/
    //echo 'aaa';exit;
    $cl = searchApi('members_man members_women');
    //print_r($cl);
    if ($user['num'] > 60) {
        if ($fgender == '0' || $fgender == '1') {
            $cond[] = array('gender', $fgender, false);
            $cond[] = array('is_lock', '1', false);
            $cond[] = array('province', $province, false);
            $cond[] = array('city', $city, false);
            $cond[] = array('birthyear', array($age1, $age2), false);
            $cond[] = array('images_ischeck', '1', false);
            $cond[] = array('showinformation', '1', false);
            if (!empty($current_user) && $current_user['s_cid'] < 40) {
                $cond[] = array('usertype', '1', false);
            } else {
                $cond[] = array('usertype', '3', false);
            }
            $cl->SetMatchMode(SPH_MATCH_EXTENDED);
            //设置模式
            $cl->SetRankingMode(SPH_RANK_PROXIMITY);
            //设置评分模式
            $cl->SetFieldWeights(array('province' => 1, 'city' => 2));
            //设置字段的权重，如果city命中，那么权重算2
            //$cl->SetSortMode ('SPH_SORT_EXPR','@weight');//按照权重排序
            $sort = '@weight';
            //$sort = 'city desc';
            $rs_total = $cl->getResultOfReset($cond, array(), $sort);
            if ($rs_total['total_found'] >= 1) {
                $rand = mt_rand(1, $rs_total['total_found']);
            }
            $limit = array($rand, 1);
            $rs = $cl->getResultOfReset($cond, $limit, $sort);
        }
    } else {
        if ($fgender == '0' || $fgender == '1') {
            $cond[] = array('gender', $fgender, false);
            $cond[] = array('is_lock', '1', false);
            //$cond[] = array('province',$province,false);
            $cond[] = array('birthyear', array($age1, $age2), false);
            $cond[] = array('images_ischeck', '1', false);
            $cond[] = array('showinformation', '1', false);
            if (!empty($current_user) && $current_user['s_cid'] < 40) {
                $cond[] = array('usertype', '1', false);
            } else {
                $cond[] = array('usertype', '3', false);
            }
            $cl->SetMatchMode(SPH_MATCH_EXTENDED);
            //设置模式
            $cl->SetRankingMode(SPH_RANK_PROXIMITY);
            //设置评分模式
            $cl->SetFieldWeights(array('province' => 1, 'city' => 2));
            //设置字段的权重，如果city命中，那么权重算2
            //$cl->SetSortMode ('SPH_SORT_EXPR','@weight');//按照权重排序
            $sort = '@weight';
            $limit = array($rand, 1);
            //$sort = 'province desc,city desc';
            $rs_total = $cl->getResultOfReset($cond, $limit, $sort);
            if ($rs_total['total_found'] >= 1) {
                $rand = mt_rand(1, $rs_total['total_found']);
            }
            $rs = $cl->getResultOfReset($cond, $limit, $sort);
        }
    }
    if (is_array($rs) && isset($rs['matches']) && !empty($rs['matches'])) {
        $ids = $cl->getIds();
        //print_r($ids);
        if (!empty($ids)) {
            $arrUser['uid'] = $ids[0];
        }
        //$arrUser = $_MooClass ['MooMySQL']->getOne($sql,true);
    }
    if ($arrUser && !MooGetScreen($arrUser['uid'], $uid)) {
        if (MOOPHP_ALLOW_FASTDB) {
            $user = MooFastdbGet('members_login', 'uid', $arrUser['uid']);
        } else {
            $user = $_MooClass['MooMySQL']->getOne('SELECT `lastvisit` FROM `' . $dbTablePre . 'members_login` WHERE uid=' . $arrUser['uid']);
        }
        if ($user['lastvisit'] < $GLOBALS['timestamp'] - 600) {
            $nowtime = $GLOBALS['timestamp'];
        } else {
            $nowtime = rand(1, 100) > 70 ? $GLOBALS['timestamp'] : $GLOBALS['timestamp'] - rand(60, 120) * 60;
        }
        $_MooClass['MooMySQL']->query("UPDATE `{$dbTablePre}members_login` SET `lastvisit`=" . $nowtime . " WHERE `uid`=" . $arrUser['uid']);
        if (MOOPHP_ALLOW_FASTDB) {
            MooFastdbUpdate('members_login', 'uid', $arrUser['uid'], array('lastvisit' => $nowtime));
        }
        $result = $_MooClass['MooMySQL']->getOne("SELECT `vid` FROM `{$dbTablePre}service_visitor` WHERE uid='{$arrUser['uid']}' AND visitorid='{$uid}' AND `who_del`!=2", true);
        if ($result['vid']) {
            $_MooClass['MooMySQL']->query("UPDATE `{$dbTablePre}service_visitor` SET `visitortime`='{$nowtime}' WHERE `vid`={$result['vid']}");
        } else {
            $_MooClass['MooMySQL']->query("INSERT INTO `{$dbTablePre}service_visitor` SET `uid`='{$arrUser['uid']}',`visitorid`='{$GLOBALS['MooUid']}',`visitortime`='{$nowtime}',`who_del`=1");
        }
        return $arrUser['uid'];
    } else {
        return 0;
    }
}

//.........这里部分代码省略.........
    }
    //	foreach ($members_base as $key=>$val){
    //		$membersbase[$key]=$val;
    //	}
    if (count($members_base) >= 1 || count($memberssearch) >= 1) {
        $members_search['updatetime'] = time();
        if (!rtrim($members_search['nickname'])) {
            $error = "昵称必填";
            echo return_data($error, false);
            exit;
        }
        if (preg_match('/^(1[345]\\d{9})|(18[024-9]\\d{8})|(010-?\\d{8})|(02)[012345789]-?\\d{8}|(0[3-9]\\d{2,2}-?\\d{7,8})|(.*@.*)$/', $members_search['nickname'])) {
            //MooMessage("昵称不符合规范！", "javascript:history.go(-1)");
            $error = "昵称不符合规范！";
            echo return_data($error, false);
            exit;
        }
        //echo 'sss';exit;
        str_length($members_search['nickname']);
        //note 昵称截取
        $members_search['nickname'] = MooCutstr($members_search['nickname'], 18, $dot = '');
        if ($members_search['telphone'] && !preg_match('/^((1[345]\\d{9})|(18[0-9]\\d{8}))$/', $members_search['telphone'])) {
            //MooMessage('请输入正确的手机号码','javascript:history.go(-1)');
            $error = "请输入正确的手机号码";
            echo return_data($error, false);
            exit;
        }
        //$birth=strtotime("$birthyear/$birthmonth/$birthday");
        $birth = "{$birthyear}-{$birthmonth}-{$birthday}";
        $members_base['birth'] = $birth;
        updatetable('members_base', $members_base, $where_arr);
        updatetable('members_search', $memberssearch, $where_arr);
        if (MOOPHP_ALLOW_FASTDB) {
            MooFastdbUpdate('members_base', 'uid', $uid, $members_base);
            MooFastdbUpdate('members_search', 'uid', $uid, $memberssearch);
        }
        //searchApi("members_man members_women")->UpdateAttributes(array($uid=>$members_search));
    }
    //提交会员动态makui
    UpdateMembersSNS($uid, '修改了资料');
    //内心独白必填
    //if(rtrim($update2_arr['introduce_check'] != '')){
    $members_introduce['introduce'] = '';
    $members_introduce['introduce_pass'] = '2';
    //if(isset($members_choice)){
    $members_choice['updatetime'] = time();
    updatetable('members_choice', $members_choice, $where_arr);
    //}
    updatetable('members_introduce', $members_introduce, $where_arr);
    if (MOOPHP_ALLOW_FASTDB) {
        $members_choice['uid'] = $uid;
        $members_introduce['uid'] = $uid;
        //print_r($update2_arr);exit;
        if (isset($members_choice)) {
            $members_choice['updatetime'] = time();
            MooFastdbUpdate('members_choice', 'uid', $uid, $members_choice);
        }
        MooFastdbUpdate('members_introduce', 'uid', $uid, $members_introduce);
    }
    //searchApi("members_man members_women")->UpdateAttributes(array($uid=>$members_choice));
    if (MOOPHP_ALLOW_FASTDB) {
        $userchoice = MooFastdbGet('members_choice', 'uid', $uid);
        $introduce = MooFastdbGet('members_introduce', 'uid', $uid);
        $userchoice = array_merge($userchoice, $introduce);
    } else {
        $userchoice = $_MooClass['MooMySQL']->getOne("SELECT * FROM {$dbTablePre}members_choice mc left join {$dbTablePre}members_introduce mi WHERE mc.uid=mi.uid AND uid = '{$uid}'", true);

function interest()
{
    global $_MooClass, $dbTablePre, $userid, $user_arr;
    $members_base['fondactivity'] = ArrToStr(MoogetGPC('fondactions', 'array', 'P'));
    $members_base['fondsport'] = ArrToStr(MoogetGPC('fondsports', 'array', 'P'));
    $members_base['fondmusic'] = ArrToStr(MoogetGPC('fondmusics', 'array', 'P'));
    $members_base['fondprogram'] = ArrToStr(MoogetGPC('fondprograms', 'array', 'P'));
    //memberfield表
    foreach ($members_base as $key => $val) {
        //if($val){
        $membersbase[$key] = $val;
        //}
    }
    $where_arr = array('uid' => $userid);
    if (count($membersbase) >= 1) {
        updatetable('members_base', $membersbase, $where_arr);
        //note 快速常用搜索表更新
        //fastsearch_update($userid,'1');
        //note 快速高级搜索表更新
        //fastsearch_update($userid,'2');
        if (MOOPHP_ALLOW_FASTDB) {
            MooFastdbUpdate('members_base', 'uid', $userid, $membersbase);
        }
    }
    //note 分配客服
    //allotserver($userid);
    MooMessage("操作已完成", 'index.php?n=material');
}

//.........这里部分代码省略.........
    $send_user1 = leer_send_user1($sendtoid);
    $user = leer_send_user1($userid);
    if ($send_user1['gender'] == $user['gender']) {
        MooMessage('不可给同性发送鲜花', 'javascript:history.go(-1);');
        exit;
    }
    //note 如果自己没有玫瑰花了，就提示没有玫瑰花了
    if ($user['rosenumber'] <= 0) {
        MooMessage('您没有鲜花了，获取更多鲜花', "index.php?n=service&h=rose&t=getmorerose");
        exit;
    }
    //发送短信和邮件
    include_once "./module/crontab/crontab_config.php";
    if (MOOPHP_ALLOW_FASTDB) {
        $res = MooFastdbGet('members_search', 'uid', $sendtoid);
        $res_b = MooFastdbGet('members_base', 'uid', $sendtoid);
        $res = array_merge($res, $res_b);
    } else {
        $res = $_MooClass['MooMySQL']->getOne("select s.telphone,b.is_phone,s.username from {$dbTablePre}members_search s left join {$dbTablePre}members_base b on s.uid=b.uid  where s.uid='{$sendtoid}'");
    }
    $send_user_info = $_MooClass['MooMySQL']->getAll("select b.*,c.*,a.* from `{$dbTablePre}members_search` a left join {$dbTablePre}members_base c on a.uid=c.uid  left join  {$dbTablePre}members_choice b  on a.uid=b.uid  where a.uid = '{$userid}'");
    $send_user_info = $send_user_info[0];
    //头像路径
    $path = thumbImgPath(2, $send_user_info[pic_date], $send_user_info[pic_name], $send_user_info['gender']);
    if (file_exists($path)) {
        $img_path = $path;
    } else {
        if ($send_user_info['gender'] == 1) {
            $img_path = "/public/images/service_nopic_woman.gif";
        } else {
            $img_path = "/public/images/service_nopic_man.gif";
        }
    }
    $send_username = $send_user_info['nickname'] ? $send_user_info['nickname'] : $send_user_info['uid'];
    //发送者用户名
    $send_user_grade = $send_user_info['gender'] == 1 ? "女" : "男";
    //发送者性别
    $province = $provice_list[$send_user_info['province']];
    //省
    $city = $city_list[$send_user_info['city']];
    //市
    $height = $send_user_info['height'] ? $height_list[$send_user_info['height']] : "未知";
    //身高
    ob_start();
    require_once MooTemplate('public/mail_space_rosetpl', 'module');
    //模板
    $body = ob_get_clean();
    MooSendMail($res['username'], "真爱一生网系统温馨提示", $body, "", false, $sendtoid);
    if (empty($GLOBALS['MooUid'])) {
        list($uid, $password) = explode("\t", MooAuthCode($_MooCookie['auth'], 'DECODE'));
        $uid = intval($uid);
    } else {
        $uid = $GLOBALS['MooUid'];
    }
    if (empty($uid)) {
        MooMessage('您还没有登录', 'index.php?n=login');
    }
    $leer = $_MooClass['MooMySQL']->getOne("SELECT * FROM {$dbTablePre}service_rose WHERE receiveuid = '{$sendtoid}' AND senduid = '{$userid}' ORDER BY rid DESC LIMIT 1");
    if ($user['rosenumber'] > 0) {
        if ($leer['rid']) {
            $rid = $leer['rid'];
            //note 如果已经发送过玫瑰，就增加发送玫瑰的次数
            $_MooClass['MooMySQL']->query("UPDATE {$dbTablePre}service_rose SET num = num + 1, receivenum = receivenum + 1,sendtime = '{$timestamp}',receivetime='{$timestamp}',receive_del=0,send_del=0 WHERE rid = '{$rid}'");
        } else {
            //note 发送新的玫瑰，写入数据库 发送者，接受者，发送时间
            $_MooClass['MooMySQL']->query("INSERT INTO {$dbTablePre}service_rose SET num = 1, receivenum = 1, sendtime = '{$timestamp}',receivetime='{$timestamp}',senduid  = '{$uid}',receiveuid = '{$sendtoid}' ");
        }
        //note 发送一朵玫瑰，自己就要减少一朵玫瑰
        //enkytest
        //enkytestend
        $_MooClass['MooMySQL']->query("UPDATE {$dbTablePre}members_base SET rosenumber = rosenumber - 1 WHERE uid = '{$uid}'");
        if (MOOPHP_ALLOW_FASTDB) {
            $user_rosenum = $GLOBALS['_MooClass']['MooMySQL']->getOne("SELECT rosenumber FROM {$GLOBALS['dbTablePre']}members_base  WHERE `uid`='{$uid}'  LIMIT 1");
            $value['rosenumber'] = $user_rosenum['rosenumber'];
            MooFastdbUpdate('members_base', 'uid', $userid, $value);
        }
    }
    //将新注册的会员更新为优质会员
    if (in_array($user_arr['sid'], array(0, 52, 123)) && $user_arr['is_well_user'] != 1) {
        update_iswell_user($user_arr['uid']);
    }
    //每天向同一用户发送多次，短信记录数表只记一次
    $send_rose_date = isset($leer['sendtime']) ? date("Y-m-d", $leer['sendtime']) : date("Y-m-d");
    //
    $today_rose_count = isset($leer['rid']) ? $leer['num'] + 1 : 1;
    if (date("Y-m-d") > $send_rose_date) {
        $today_rose_count = 1;
    }
    if ($res['is_phone']) {
        SendMsg($res['telphone'], "真爱一生网 用户ID：" . $userid . "," . $send_user_grade . ",已给您发送鲜花,请及时把握您的缘分！4006780405");
    }
    //提醒所属客服
    $sid = $user_arr['sid'];
    $title = '您的会员 ' . $user_arr['uid'] . ' 向 ' . $sendtoid . ' 发送了鲜花';
    $awoketime = $timestamp + 3600;
    $sql_remark = "insert into {$dbTablePre}admin_remark set sid='{$sid}',title='{$title}',content='{$title}',awoketime='{$awoketime}',dateline='{$timestamp}'";
    $res = $_MooClass['MooMySQL']->query($sql_remark);
    MooMessage('发送鲜花成功' . $note, "index.php?n=service&h=rose&t=isendrose", "05");
    require MooTemplate('public/service_rose_sendrose', 'module');
}

function ajax_sellsendactive()
{
    $type = MooGetGPC('type', 'string', 'G');
    $sendid = MooGetGPC('from', 'integer', 'G');
    $receiveuid = MooGetGPC('to', 'integer', 'G');
    if ($type == '' || $sendid == '' || $receiveuid == '' || $sendid == 0 || $receiveuid == 0) {
        echo 'errors';
    }
    $nowtime = time();
    $user = MooMembersData($receiveuid);
    $senduser = MooMembersData($sendid);
    /*if(MOOPHP_ALLOW_FASTDB){
          $user = MooFastdbGet('members','uid',$receiveuid);
          $senduser = MooFastdbGet('members','uid',$sendid);
      }else{
          $sql = "SELECT username,telphone FROM {$GLOBALS['dbTablePre']}members WHERE `uid`='".$receiveuid."'";
          $user=$GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
          $sql = "SELECT gender FROM {$GLOBALS['dbTablePre']}members WHERE `uid`='".$sendid."'";
          $senduser=$GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
      }*/
    $gender = $senduser['gender'] == 1 ? "女" : "男";
    switch ($type) {
        case 'commission':
            //$sql = "SELECT mid,sendtime FROM {$GLOBALS['dbTablePre']}service_contact WHERE you_contact_other='$sendid' AND other_contact_you = '$userid' and receive_del=0 and send_del=0 and is_server=0";
            $sql = "SELECT * FROM {$GLOBALS['dbTablePre']}service_contact WHERE you_contact_other = '{$receiveuid}' AND other_contact_you = '{$sendid}' ";
            $com = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
            if (empty($com)) {
                $sql = "INSERT INTO {$GLOBALS['dbTablePre']}service_contact SET `you_contact_other`='" . $receiveuid . "',`other_contact_you`='" . $sendid . "',`stat`=1,`syscheck`=1,`sendtime`='" . $nowtime . "',`is_server`=1";
                $result = $GLOBALS['_MooClass']['MooMySQL']->query($sql);
                echo 'ok';
                exit;
            } else {
                echo 'having';
                exit;
            }
            //更改最后活动时间,上线
            $sql = "UPDATE {$GLOBALS['dbTablePre']}members_login SET lastvisit='{$GLOBALS['timestamp']}' WHERE uid='{$sendid}'";
            $GLOBALS['_MooClass']['MooMySQL']->query($sql);
            if (MOOPHP_ALLOW_FASTDB) {
                $value['lastvisit'] = $GLOBALS['timestamp'];
                MooFastdbUpdate('members_login', 'uid', $sendid, $value);
            }
            //发e-mail提醒(委托)-------开始////////////////////////////////////////////
            include_once "./include/crontab_config.php";
            $send_user_info = array_merge(MooGetData('members_choice', 'uid', $sendid), MooMembersData($sendid));
            /*$send_user_info = $GLOBALS['_MooClass']['MooMySQL']->getAll("select * from `{$GLOBALS['dbTablePre']}members` a  left join  {$GLOBALS['dbTablePre']}choice b  on a.uid=b.uid  where a.uid = '$sendid'");
              $send_user_info = $send_user_info[0];*/
            //头像路径
            $path = thumbImgPath(2, $send_user_info['pic_date'], $send_user_info['pic_name'], $send_user_info['gender']);
            if (file_exists($path)) {
                $img_path = $path;
            } else {
                if ($send_user_info['gender'] == 1) {
                    $img_path = "/public/images/service_nopic_woman.gif";
                } else {
                    $img_path = "/public/images/service_nopic_man.gif";
                }
            }
            $send_username = $send_user_info['nickname'] ? $send_user_info['nickname'] : $send_user_info['uid'];
            //发送者用户名
            $send_user_grade = $send_user_info['gender'] == 1 ? "女" : "男";
            //发送者性别
            $province = $provice_list[$send_user_info['province']];
            //省
            $city = $city_list[$send_user_info['city']];
            //市
            $height = $send_user_info['height'] ? $height_list[$send_user_info['height']] : "未知";
            //身高
            ob_start();
            require_once adminTemplate('mail/mail_space_commissiontpl');
            $body = ob_get_clean();
            MooSendMail($user['username'], "真爱一生网系统温馨提示", $body, "", false, $receiveuid);
            //--------->发送邮件提醒  结束///////////////////////////////////////////
            //fangin暂时屏蔽
            Push_message_intab($receiveuid, $user['telphone'], "委托", "尊敬的会员您好!" . $sendid . "，" . $gender . "，委托我们联系您，请及时登录www.zhenaiyisheng.cc查收，把握您的缘分。【真爱一生网】", $sendid);
            //写日志
            serverlog(3, $GLOBALS['dbTablePre'] . 'service_contact', "{$GLOBALS['adminid']}号客服{$GLOBALS['username']}在后台以会员{$sendid}的身份向{$receiveuid}会员发送委托", $GLOBALS['adminid'], $receiveuid);
            echo 'ok';
            exit;
            break;
        case 'leer':
            $sql = "SELECT * FROM {$GLOBALS['dbTablePre']}service_leer WHERE senduid = '{$sendid}' AND receiveuid= '{$receiveuid}' ";
            $leer = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
            if (!empty($leer)) {
                $lid = $leer['lid'];
                //note 如果已经发送过秋波，就增加发送秋波的次数
                $sql = "UPDATE {$GLOBALS['dbTablePre']}service_leer SET fakenum = fakenum + 1,num = num + 1,receivenum = receivenum + 1,sendtime = '{$nowtime}',receivetime = '{$nowtime}',receive_del = '0' WHERE lid = '{$lid}'";
                $GLOBALS['_MooClass']['MooMySQL']->query($sql);
                //note 如果已经收到这个人的秋波，已经拒绝，现在改变注意，又发送秋波给这个人,拒绝状态2更改为0
                if ($leer['receive_del'] == 1 || $leer['stat'] == 2) {
                    $sql = "UPDATE {$GLOBALS['dbTablePre']}service_leer SET stat = '0',receive_del = 0 WHERE senduid = '{$sendid}' AND receiveuid = '{$receiveuid}' AND stat = '2'";
                    $GLOBALS['_MooClass']['MooMySQL']->query($sql);
                }
            } else {
                //note 发送新的秋波，写入数据库 发送者，接受者，发送时间
                $sql = "INSERT INTO {$GLOBALS['dbTablePre']}service_leer SET sendtime = '{$nowtime}',receivetime = '{$nowtime}',fakenum = '1', receivenum = '1', num = '1', senduid  = '{$sendid}',receiveuid = '{$receiveuid}',is_server=1";
                $GLOBALS['_MooClass']['MooMySQL']->query($sql);
            }
            //更改最后活动时间,上线
            $sql = "UPDATE {$GLOBALS['dbTablePre']}members_login SET lastvisit='{$GLOBALS['timestamp']}' WHERE uid='{$sendid}'";
//.........这里部分代码省略.........

function ajax_check_school()
{
    global $_MooClass, $dbTablePre;
    $uid = MooGetGPC('uid', 'integer', 'P');
    $pass = MooGetGPC('pass', 'integer', 'P');
    if (empty($uid)) {
        exit('0');
    }
    $school = trim(MooGetGPC('school', 'string', 'P'));
    if (!empty($school)) {
        $sql = "UPDATE {$dbTablePre}members_base SET finishschool='{$school}' WHERE uid='{$uid}'";
        $value['finishschool'] = $school;
    } else {
        $sql = "UPDATE {$dbTablePre}members_base SET isschool='{$pass}' WHERE uid='{$uid}'";
        $value['isschool'] = $pass;
    }
    //echo $sql;exit;
    $query = $_MooClass['MooMySQL']->query($sql);
    if (MOOPHP_ALLOW_FASTDB) {
        MooFastdbUpdate('members_base', 'uid', $uid, $value);
    }
    if ($query) {
        serverlog(4, $GLOBALS['dbTablePre'] . 'members_base', "{$GLOBALS['adminid']}号客服审核会员{$uid}的毕业院校", $GLOBALS['adminid'], $uid);
        echo '1';
    } else {
        echo '0';
    }
}

function other_add_rose()
{
    if (empty($_POST)) {
        require_once adminTemplate('other_add_rose');
    } else {
        $uid = MooGetGPC('uid', 'integer', 'P');
        $rosenumber = MooGetGPC('rosenumber', 'integer', 'P');
        //enky add 防止人为输入过大,输入过大则设置为10万
        if ($rosenumber > 100000) {
            $rosenumber = 100000;
        }
        //add end
        if (empty($uid) || empty($rosenumber)) {
            exit(json_encode(array('flag' => 0, 'msg' => '请确认鲜花熟练或者用户')));
        } else {
            if ($GLOBALS['_MooClass']['MooMySQL']->query('UPDATE `' . $GLOBALS['dbTablePre'] . 'members_base` SET `rosenumber`=`rosenumber`+(' . $rosenumber . ') WHERE `uid`=' . $uid)) {
                MooFastdbUpdate('members_base', 'uid', $uid);
                exit(json_encode(array('flag' => 1, 'msg' => '花朵赠送成功')));
            } else {
                exit(json_encode(array('flag' => 0, 'msg' => '花朵赠送失败')));
            }
        }
    }
}

function changePWD($uid)
{
    global $_MooClass, $dbTablePre, $user_arr;
    //note 将作为新密码
    $newpwd = rand(100000, 999999);
    //修改密码至表中
    if ($_MooClass['MooMySQL']->query("update web_members_search set password='" . md5($newpwd) . "' where uid='{$uid}'")) {
        if (MOOPHP_ALLOW_FASTDB) {
            $new_user_arr = array();
            $new_user_arr['password'] = md5($newpwd);
            MooFastdbUpdate('members_search', 'uid', $uid, $new_user_arr);
        }
        return $newpwd;
    } else {
        return 0;
    }
}