PHP MooGetGPC函数代码示例

function active_rightbottom_sitemail()
{
    if ($_POST) {
        $sid = MooGetGPC('msg_sid', 'integer', 'P');
        if (empty($_POST['msg_sid']) && !empty($_POST['msg_username'])) {
            $username = MooGetGPC('msg_username', 'string', 'P');
            $sql = "SELECT uid FROM {$GLOBALS['dbTablePre']}admin_user WHERE username='{$username}'";
            $admin_user = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
            if (empty($admin_user)) {
                salert('此用户不存在');
                exit;
            }
            $sid = $admin_user['uid'];
        }
        $data['sid'] = $sid;
        $data['title'] = "{$GLOBALS['adminid']}号客服:" . MooGetGPC('msg_title', 'string', 'P');
        $data['content'] = MooGetGPC('msg_content', 'string', 'P');
        $data['awoketime'] = time() + 120;
        $data['dateline'] = time();
        $data['send_id'] = $GLOBALS['adminid'];
        inserttable('admin_remark', $data);
        salert('发送成功');
        exit;
    }
    $group_list = get_group_type();
    require adminTemplate('other_rightbottom_sitemail');
}

function system_adminaction_edit()
{
    global $menu_nav_arr, $dbTablePre;
    $actionid = MooGetGPC('actionid', 'integer');
    $ispost = MooGetGPC('ispost', 'integer');
    if (empty($actionid)) {
        MooMessageAdmin('参数错误', 'index.php?action=adminaction&h=list', 1);
    }
    if ($ispost) {
        $actiondesc = MooGetGPC('actiondesc', 'string');
        $actioncode = MooGetGPC('actioncode', 'string');
        $navcode = MooGetGPC('navcode', 'string');
        $navname = MooGetGPC('navname', 'string');
        if (empty($actiondesc) || empty($actioncode) || empty($navcode) || empty($navname)) {
            $admin->showMessage('请将信息填写完整', 'index.php?action=adminaction&h=add', 1);
        }
        $sql = "UPDATE {$GLOBALS['dbTablePre']}admin_action SET navname='{$navname}',navcode='{$navcode}',actioncode='{$actioncode}',actiondesc='{$actiondesc}' WHERE id='{$actionid}'";
        $result = $GLOBALS['_MooClass']['MooMySQL']->query($sql);
        if ($result) {
            //note 插入日志
            serverlog(2, $GLOBALS['dbTablePre'] . 'admin_action', "{$GLOBALS['username']}修改操作{$actionid}", $GLOBALS['adminid']);
            salert('修改成功', 'index.php?action=system_adminaction&h=list');
            //MooMessageAdmin('修改成功','index.php?action=system_adminaction&h=list',1);
        } else {
            salert('修改失败', 'index.php?action=system_adminaction&h=list');
            //MooMessageAdmin('修改失败','index.php?action=system_adminaction&h=list',1);
        }
    }
    $sql = "SELECT * FROM {$GLOBALS['dbTablePre']}admin_action WHERE id='{$actionid}'";
    $adminaction = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
    require_once adminTemplate('adminaction_edit');
}

function transfer_del()
{
    $id = MooGetGPC('id', 'integer', 'G');
    $sql = "DELETE FROM {$GLOBALS['dbTablePre']}members_transfer WHERE `id`=" . $id;
    $GLOBALS['_MooClass']['MooMySQL']->query($sql);
    salert("删除成功", "index.php?action=other_members_transfer&h=list");
}

function site_media_edit()
{
    $ispost = MooGetGPC('ispost', 'integer', 'P');
    if ($ispost) {
        $id = MooGetGPC('id', 'integer', 'P');
        $title = MooGetGPC('title', 'string', 'P');
        $type = MooGetGPC('type', 'string', 'P');
        $addtime = strtotime(MooGetGPC('addtime', 'string', 'P'));
        $source = MooGetGPC('source', 'string', 'P');
        $content = MooGetGPC('content', 'string', 'P');
        if (empty($content)) {
            salert("内容不能为空");
        }
        $sql = "UPDATE {$GLOBALS['dbTablePre']}media SET sid = {$GLOBALS['adminid']},type = '{$type}', title = '{$title}', content = '{$content}', addtime = '{$addtime}', source = '{$source}' WHERE id={$id}";
        $GLOBALS['_MooClass']['MooMySQL']->query($sql);
        //note 插入日志
        serverlog(2, $GLOBALS['dbTablePre'] . 'media', "{$GLOBALS['username']}编辑媒体报道", $GLOBALS['adminid']);
        salert("编辑成功", "index.php?action=site_media&h=edit&id=" . $id);
    }
    $isedit = 1;
    $id = MooGetGPC('id', 'integer', 'G');
    $sql = "SELECT * FROM {$GLOBALS['dbTablePre']}media WHERE id = {$id}";
    $news = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
    require adminTemplate('site_media_add');
}

function getone()
{
    global $_MooClass, $dbTablePre, $userid, $memcached;
    $sendid = MooGetGPC('sendid', 'integer', 'G');
    //$sendid = '21691205';
    $user = MooMembersData($sendid);
    if ($user['uid'] != $sendid || $sendid == '') {
        $error = '查无此人';
        echo return_data($error, false);
        exit;
    }
    if (MooGetphoto($user['uid'], 'com')) {
        $mainimg = MooGetphoto($userid, 'com');
        $user['mainimg'] = $mainimg;
    }
    $user['password'] = '';
    $user['regip'] = '';
    $user['qq'] = '';
    $user['msn'] = '';
    $user['telphone'] = '';
    $user['username'] = '';
    //print_r($user);
    echo return_data($user, true);
    exit;
}

function getlatestvisitor()
{
    global $_MooClass, $dbTablePre, $userid, $timestamp, $user_arr;
    $pagesize = 4;
    //note 获取删除提交的变量
    $delvisitor = MooGetGPC('delvisitor', 'string');
    $delvisitorid = MooGetGPC('delvisitorid', 'array');
    //note 删除提交的数据
    if ($delvisitor && count($delvisitorid)) {
        for ($i = 0; $i < count($delvisitorid); $i++) {
            $result = $_MooClass['MooMySQL']->getOne("SELECT `who_del` FROM `" . $dbTablePre . "service_visitor` WHERE `vid`=" . $delvisitorid[$i], true);
            if ($result['who_del'] != 0) {
                $_MooClass['MooMySQL']->query("DELETE FROM {$dbTablePre}service_visitor WHERE vid = '{$delvisitorid[$i]}'");
            } else {
                $_MooClass['MooMySQL']->query("UPDATE `" . $dbTablePre . "service_visitor` SET `who_del`=2 WHERE `vid`=" . $delvisitorid[$i]);
            }
        }
        MooMessage("删除成功", 'index.php?n=service&h=mindme', '05');
    }
    //note 如果提交的数据不存在，或者是提交的时候没有选中
    if ($delvisitor && !count($delvisitorid)) {
        MooMessage('请选择要删除选项', 'index.php?n=service&h=mindme', '01');
        exit;
    }
    //note 获得当前url
    $currenturl = 'http://' . $_SERVER['SERVER_NAME'] . ':' . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"];
    $currenturl2 = preg_replace("/(&page=\\d+)/", "", $currenturl);
    //note 获得第几页
    $page = empty($_GET['page']) ? '1' : $_GET['page'];
    //note limit查询开始位置
    $start = ($page - 1) * $pagesize;
    //note 多少个人访问统计总数
    $ret_c = $_MooClass['MooMySQL']->getOne("SELECT count(*) as c FROM {$dbTablePre}service_visitor WHERE uid >0 and visitorid = '{$userid}' AND who_del !=2");
    $total = $ret_c['c'];
    if ($total > 200) {
        $total = 200;
    }
    //更改最近留意我的人最我显示200个
    $tomeArr = $_MooClass['MooMySQL']->getOne("SELECT count(*) FROM {$dbTablePre}service_visitor WHERE uid = '{$userid}' AND who_del !=1");
    $tome = $tomeArr['count(*)'];
    //note 查询出谁访问过我相关信息
    if ($total) {
        $results = $_MooClass['MooMySQL']->getAll("SELECT * FROM {$dbTablePre}service_visitor WHERE  uid >0 and visitorid = '{$userid}' AND who_del !=2 order by visitortime desc LIMIT {$start},{$pagesize}");
        $visitors = array();
        foreach ($results as $k => $v) {
            $send_user1 = array();
            $send_user2 = array();
            $vistor = array();
            $send_user1 = leer_send_user1($v['uid']);
            $send_user2 = leer_send_user2($v['uid']);
            $vistor['l'] = $v;
            $vistor['l']['visitortime'] = $vistor['l']['visitortime'] ? $vistor['l']['visitortime'] : time();
            $vistor['s'] = $send_user1;
            $vistor['t'] = $send_user2;
            $visitors[$k] = $vistor;
        }
    }
    require MooTemplate('public/service_visitor_latestvisitor', 'module');
}

function whoismyfriend()
{
    global $_MooClass, $dbTablePre, $userid, $pagesize, $user_arr, $memcached;
    $userid = $memcached->get('uid');
    //验证登录
    $and_uuid = $_GET['uuid'];
    $checkuuid = check_uuid($and_uuid);
    if (!$checkuuid) {
        $error = "uuid_error";
        echo return_data($error, false);
        exit;
    }
    $pagesize = 12;
    //note 获取删除提交的变量
    $delfriend = MooGetGPC('delfriend', 'string');
    $delfriendid = MooGetGPC('delfriendid', 'array');
    //note 删除提交的数据
    if ($delfriend && count($delfriendid)) {
        foreach ($delfriendid as $v) {
            $_MooClass['MooMySQL']->query("DELETE FROM {$dbTablePre}service_friend WHERE fid = '{$v}'");
        }
        $return = "删除意中人成功";
        echo return_data($return);
        exit;
    }
    //note 如果提交的数据不存在，或者是提交的时候没有选中
    if ($delfriend && !count($delfriendid)) {
        $error = "请选择要删除的意中人";
        echo return_data($error, false);
        exit;
        exit;
    }
    //note 获得当前url
    $currenturl = 'http://' . $_SERVER['SERVER_NAME'] . ':' . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"];
    $currenturl2 = preg_replace("/(&page=\\d+)/", "", $currenturl);
    //note 获得第几页
    $page = empty($_GET['page']) ? 1 : $_GET['page'];
    //note limit查询开始位置
    $start = ($page - 1) * $pagesize;
    //note 已收到的统计总数
    $query = $_MooClass['MooMySQL']->getOne("select count(1) as num FROM {$dbTablePre}service_friend WHERE uid = '{$userid}'");
    $total = $query['num'];
    $total2Arr = $_MooClass['MooMySQL']->getOne("SELECT count(*) FROM {$dbTablePre}service_friend WHERE friendid = '{$userid}'");
    $total2 = $total2Arr['count(*)'];
    //note 查询出意中人相关信息
    if ($total) {
        $friend = $_MooClass['MooMySQL']->getAll("SELECT * FROM {$dbTablePre}service_friend WHERE uid = '{$userid}' order by sendtime desc LIMIT {$start},{$pagesize}");
    }
    $friendid = array();
    foreach ($friend as $k => $f) {
        $friendid[] = $f['friendid'];
    }
    $frienduid = implode(',', $friendid);
    $frienduser = $_MooClass['MooMySQL']->getAll("select s.uid,s.nickname,s.birthyear,s.height,s.salary,s.province,s.city,b.mainimg,s.gender from {$dbTablePre}members_search s left join {$dbTablePre}members_base b on s.uid=b.uid where s.uid=b.uid and s.uid in({$frienduid})");
    echo return_data($frienduser);
    exit;
}

function site_lovequestion_del()
{
    $tid = MooGetGPC('tid', 'integer', 'G');
    $sql = "DELETE FROM {$GLOBALS['dbTablePre']}love_question WHERE lid = {$tid}";
    $GLOBALS['_MooClass']['MooMySQL']->query($sql);
    //note 插入日志
    serverlog(4, $GLOBALS['dbTablePre'] . 'love_question', '删除爱情测试题目', $GLOBALS['adminid']);
    salert("删除成功", 'index.php?action=site_lovequestion&h=list');
}

function site_lovetype_del()
{
    $id = MooGetGPC('id', 'integer', 'G');
    $sql = "DELETE FROM {$GLOBALS['dbTablePre']}love_type WHERE id = {$id}";
    $GLOBALS['_MooClass']['MooMySQL']->query($sql);
    //note 插入日志
    serverlog(4, $GLOBALS['dbTablePre'] . 'love_type', '删除测试评分结果', $GLOBALS['adminid']);
    salert("删除成功", 'index.php?action=site_lovetype&h=list');
}

function getComment($type, $id)
{
    global $dbTablePre, $user_arr;
    $page_per = 15;
    $page_now = MooGetGPC('page', 'integer', 'G');
    $page_url = preg_replace('/&page=[^&]*/', '', $_SERVER['REQUEST_URI']);
    $uid = empty($user_arr['uid']) ? 0 : $user_arr['uid'];
    $from_where = "FROM {prefix}comment WHERE type = '{$type}' AND id= '{$id}' AND ( ischeck = 1 OR uid = '{$uid}' ) ";
    return readTable($page_now, $page_per, $page_url, $from_where, $order_by = 'ORDER BY cid DESC', $fd_list = '*');
}

/**
 * 删除白名单
 */
function other_del_white()
{
    $id = MooGetGPC('id', 'integer', 'P');
    if (empty($id)) {
        exit(json_encode(array('flag' => 0, 'msg' => '数据不完整')));
    }
    if ($GLOBALS['_MooClass']['MooMySQL']->query('DELETE FROM ' . $GLOBALS['dbTablePre'] . 'white_list WHERE id=' . $id)) {
        exit(json_encode(array('flag' => 1, 'msg' => '白名单删除成功')));
    } else {
        exit(json_encode(array('flag' => 0, 'msg' => '删除失败')));
    }
}

function login_login()
{
    global $_MooClass, $dbTablePre, $memcached;
    /*
    $seccode1 = strtolower(MooGetGPC('vertify_code','string','P'));
    $seccode2 = MooGetGPC('seccode','string','C');
    $session_seccode = $memcached->get($seccode2);
    
    if($seccode1 != $session_seccode){
    	MooMessageAdmin("验证码填写不正确，请确认。", "index.php?action=login",'','',3);
    }
    */
    $username = MooGetGPC('username', 'string', 'P');
    $password = MooGetGPC('password', 'string', 'P');
    $password = md5($password);
    //判断用户名和密码是否为空
    if ($username == '' || $password == '') {
        MooMessageAdmin('用户名或密码不能为空', 'index.php?n=login', 1);
    }
    $userinfo = $_MooClass['MooMySQL']->getOne("SELECT * FROM {$dbTablePre}admin_user WHERE `username`='{$username}' LIMIT 1 ", true);
    if ($userinfo['uid'] && $userinfo['password'] == $password) {
        MooSetCookie('admin', MooAuthCode("{$userinfo['uid']}\t{$userinfo['password']}", 'ENCODE'), 86400);
        //note 写入session表需要的字段值
        $online_ip = GetIP();
        $lastactive = $GLOBALS['timestamp'];
        //note 提取快到期的高级用户并加入备注中
        $nowtime = time();
        $endtime = $nowtime + 8 * 24 * 60 * 60;
        $_MooClass['MooMySQL']->query("DELETE FROM {$dbTablePre}custom_remark WHERE `keyword`='会员到期' AND `cid`='{$userinfo['uid']}'");
        $remark = $_MooClass['MooMySQL']->getAll("SELECT `uid`,`endtime` FROM {$dbTablePre}members_search WHERE `sid`={$userinfo['uid']} AND `s_cid`=30 AND `endtime`<{$endtime}", 0, 0, 0, true);
        for ($i = 0; $i < count($remark); $i++) {
            $content = "尊敬的客服，您的红娘号为" . $remark[$i]['uid'] . "的会员将于" . date('Y-m-d', $remark[$i]['endtime']) . "到期，请尽快与该会员联系";
            $_MooClass['MooMySQL']->query("INSERT INTO {$dbTablePre}custom_remark SET `cid`={$userinfo['uid']},`keyword`='会员到期',`content`='{$content}',`awoketime`='{$remark[$i]['endtime']}'");
        }
        //更新最后登录相关记录
        $sql = "UPDATE {$dbTablePre}admin_user SET lastlogin='{$nowtime}',lastip='{$online_ip}' WHERE uid='{$userinfo['uid']}'";
        $GLOBALS['_MooClass']['MooMySQL']->query($sql);
        $sid_list = '';
        //得到我所管理的客服id列表
        $sid_list = get_mymanage_serviceid_list($userinfo['uid'], $userinfo['groupid']);
        $time = time();
        $sql = "REPLACE INTO {$GLOBALS['dbTablePre']}admin_usersession SET uid='{$userinfo['uid']}',groupid='{$userinfo['groupid']}',dateline='{$time}',sid_list='{$sid_list}'";
        $GLOBALS['_MooClass']['MooMySQL']->query($sql);
        //添加操作日志
        serverlog(3, $dbTablePre . "admin_usersession", "{$userinfo['uid']}成功登陆后台", $userinfo['uid']);
        MooMessageAdmin('登陆成功', 'index.php?n=main', 1);
    } else {
        MooMessageAdmin('用户名或密码错误', 'index.php?n=login', 1);
    }
}

/**
*来源获取（网站来源访问和推荐用户ID）
*@返回COOKIE值在注册的时候写入
*PHPYOU
*/
function MooGetFromwhere(){
    global $_MooCookie;
	$puid=$_MooCookie['puid'] ?$_MooCookie['puid'] :MooGetGPC('puid','integer','G');
	if($puid){
		MooSetCookie('puid', $puid, 24*3600);
	}
	$website=$_MooCookie['website']?$_MooCookie['website']:MooGetGPC('website','string','G');
	if($website){
		MooSetCookie('website', $puid, 24*3600);
	}
	if( isset($_GET['wf']) && isset($_GET['st']) ){
		MooSetCookie('where_from', "http://www.7651.com/virtual/?".$_SERVER['QUERY_STRING'], 24*3600);
		return;
	}
	if( preg_match("/\/virtual\//",$_MooCookie['where_from']) ) return;
	$rf_url = $_SERVER['HTTP_REFERER'];
	// 判断是否有外来页
	if (empty($rf_url)) {
		//error_log("rf error", 0);
		return false;
	}
	
	$rf_arr = parse_url($rf_url);
	$rf_hostname = $rf_arr["host"];
	$rf_path = $rf_ar["path"];
	
	//print_r($rf_arr);
	// 判断外来是否是本站
	if ($rf_hostname == $_SERVER["HTTP_HOST"] && strstr($rf_url, "/pop/") === false && strstr($rf_url, "/reg/") === false) {
		//error_log("rf error1", 0);
		$where_from = $_MooCookie['where_from'];
		$where_from_arr = parse_url($where_from);
		if ($where_from_arr["host"] == $_SERVER["HTTP_HOST"]) {
			MooSetCookie('where_from', "", -24*3600);
		}
		
		return false;
	}

	$where_from = $_MooCookie['where_from'];
	// 判断外来与cookie中记录是否一致
	if ($where_from == $rf_url) {
		return false;
	}

	MooSetCookie('where_from', $_SERVER['HTTP_REFERER'], 24*3600);
	return true;
}

function system_adminlog_search()
{
    $condition = array();
    //客服sid搜索
    if ($_GET['sid']) {
        $sid = MooGetGPC('sid', 'integer', 'G');
        $condition[] = " a.sid='{$sid}'";
    }
    if ($_GET['sid2']) {
        $sid = MooGetGPC('sid2', 'integer', 'G');
        $condition[] = " a.sid='{$sid}'";
    }
    //会员id搜索
    if ($_GET['uid']) {
        $uid = MooGetGPC('uid', 'integer', 'G');
        $condition[] = " a.uid='{$uid}'";
    }
    if ($_GET['date1']) {
        $date1 = strtotime(MooGetGPC('date1', 'string', 'G'));
        $condition[] = " a.time>='{$date1}'";
    }
    if ($_GET['date2']) {
        $date2 = strtotime(MooGetGPC('date2', 'string', 'G'));
        $condition[] = " a.time<='{$date2}'";
    }
    $sql_where = '';
    if (!empty($condition)) {
        $sql_where = 'AND ' . implode('AND', $condition);
    }
    $page = max(1, MooGetGPC('page', 'integer'));
    $limit = 15;
    $offset = ($page - 1) * $limit;
    $page_per = 15;
    //note 得出总数
    $sql = "SELECT count(1) as count FROM {$GLOBALS['dbTablePre']}server_log a JOIN {$GLOBALS['dbTablePre']}admin_user as b \n    \t\tWHERE a.sid=b.uid {$sql_where}";
    $query = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
    $total = $query['count'];
    $sql = "SELECT a.*,b.username FROM {$GLOBALS['dbTablePre']}server_log as a \n    \t\tJOIN {$GLOBALS['dbTablePre']}admin_user as b \n    \t\tWHERE a.sid=b.uid {$sql_where}  ORDER BY a.slid DESC LIMIT {$offset},{$limit}";
    $adminlogin_list = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
    $currenturl = 'http://' . $_SERVER['SERVER_NAME'] . ':' . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"];
    $currenturl = preg_replace("/www./", "", $currenturl);
    $currenturl = preg_replace("/(&page=\\d+)/", "", $currenturl);
    $page_links = multipage($total, $page_per, $page, $currenturl);
    // $page_links=str_replace('7651','7652',$page_links);
    $sql = "SELECT uid,username FROM {$GLOBALS['dbTablePre']}admin_user";
    $user_list = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
    require_once adminTemplate('adminlog_list');
}

function financial_ordertotal_list()
{
    //note 处理搜索会员聊天
    if ($_GET['action'] == 'financial_ordertotal') {
        $bgtime = MooGetGPC('bgtime', 'string');
        $endtime = MooGetGPC('endtime', 'string');
        $where = ' WHERE 1=1 ';
        if (!empty($bgtime) && !empty($endtime)) {
            $bgtime_arr = explode("-", $bgtime);
            $bgtime_mk = mktime(0, 0, 0, $bgtime_arr[1], $bgtime_arr[2], $bgtime_arr[0]);
            $endtime_arr = explode("-", $endtime);
            $endtime_mk = mktime(0, 0, 0, $endtime_arr[1], $endtime_arr[2], $endtime_arr[0]);
            if ($endtime < $bgtime) {
                echo "<script>alert('结束日期不能小于开始日期');window.location.href='index.php?action=financial_ordertotal&h=list'</script>";
                exit;
            }
            $where .= " AND dateline >= '{$bgtime_mk}' AND dateline <= '{$endtime_mk}'";
        }
    }
    //note 处理导出功能
    $export = MooGetGPC('export', 'string', 'G');
    //if($_GET['export']) {
    if ($export) {
        ob_clean();
        if (empty($user_arr)) {
            echo '没有找到符合条件的财务报表';
            exit;
        }
        $today = date("Y-m-d");
        header("Content-type:application/vnd.ms-excel; charset=gbk");
        header("Content-Disposition:attachment; filename={$today}.xls");
        echo iconv('utf-8', 'gbk', '成功订单总数') . "\t";
        echo iconv('utf-8', 'gbk', '日期') . "\t\n";
        foreach ($user_arr as $k => $v) {
            echo iconv('utf-8', 'gbk', $v['name']) . "\t";
            echo iconv('utf-8', 'gbk', date("Y-m-d", $v['dateline'])) . "\t\n";
        }
        exit;
    }
    //note 数据库查询
    $sql = "SELECT COUNT(*) num FROM {$GLOBALS['dbTablePre']}financial_orderok {$where}";
    $total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
    //note 插入日志
    serverlog(1, $GLOBALS['dbTablePre'] . 'financial_orderok', "{$GLOBALS['username']}查看成功订单总数记录列表", $GLOBALS['adminid']);
    //note 调用模板
    require adminTemplate('financial_ordertotal_list');
}