member.inc.php

phpcms2007很好的cms内容管理系统,操作方便

		}
		$arrgroupname = $arrgroupname ? implode(' | ', $arrgroupname) : '';

        $fields = $field->show_list('<tr><td class="tablerowhighlight" align="right">$title :</td><td class="tablerow" colspan=3> $value </td></tr>');

		include admintpl('member_view');

		break;

    case 'delete':

		if(!isset($userid)) showmessage($LANG['select_account'], $forward);

		$member->delete($userid);
		showmessage($LANG['operation_success'], $forward);

		break;

    case 'manage':

		$page = isset($page) ? intval($page) : 1;
		$pagesize = $PHPCMS['pagesize'] ? $PHPCMS['pagesize'] : 30;
		$offset = ($page-1)*$pagesize;
		$frommoney = isset($frommoney) ? intval($frommoney) : 0;
		$tomoney = isset($tomoney) ? intval($tomoney) : 0;
		$frompayment = isset($frompayment) ? intval($frompayment) : 0;
		$topayment = isset($topayment) ? intval($topayment) : 0;
		$frompoint = isset($frompoint) ? intval($frompoint) : 0;
		$topoint = isset($topoint) ? intval($topoint) : 0;
		$fromcredit = isset($fromcredit) ? intval($fromcredit) : 0;
		$tocredit = isset($tocredit) ? intval($tocredit) : 0;
        $groupid = isset($groupid) ? intval($groupid) : 0;

        if(!isset($username)) $username = '';
        if(!isset($industry)) $industry = '';
        if(!isset($edulevel)) $edulevel = '';
        if(!isset($income)) $income = '';
        if(!isset($occupation)) $occupation = '';
        if(!isset($province)) $province = '';
        if(!isset($city)) $city = '';

        if(!isset($truename)) $truename = '';
        if(!isset($address)) $address = '';
        if(!isset($qq)) $qq = '';
        if(!isset($email)) $email = '';
        if(!isset($msn)) $msn = '';
        if(!isset($skype)) $skype = '';
        if(!isset($icq)) $icq = '';
        if(!isset($homepage)) $homepage = '';

		$condition = '';
		$condition .= $username ? " and m.username like '%$username%'" : '';
		$condition .= $groupid ? " and (m.groupid=$groupid or m.arrgroupid like '%,$groupid,%')" : '';
		$condition .= $email ? " and m.email='$email'" : '';
		$condition .= $truename ? " and i.truename like '%$truename%'" : '';
		$condition .= $province ? " and i.province='$province'" : '';
		$condition .= $qq ? " and i.qq='$qq'" : '';
		$condition .= $msn ? " and i.msn='$msn'" : '';
		$condition .= $icq ? " and i.icq='$icq'" : '';
		$condition .= $skype ? " and i.skype='$skype'" : '';
		$condition .= $industry ? " and i.industry='$industry'" : '';
		$condition .= $edulevel ? " and i.edulevel='$edulevel'" : '';
		$condition .= $income ? " and i.income='$income'" : '';
		$condition .= $occupation ? " and i.occupation='$occupation'" : '';
		$condition .= $frommoney ? " and m.money>=$frommoney" : '';
		$condition .= $tomoney ? " and m.money<=$tomoney" : '';
		$condition .= $frompayment ? " and m.payment>=$frompayment" : '';
		$condition .= $topayment ? " and m.payment<=$topayment" : '';
		$condition .= $frompoint ? " and m.point>=$frompoint" : '';
		$condition .= $topoint ? " and m.point<=$topoint" : '';
		$condition .= $fromcredit ? " and m.credit>=$fromcredit" : '';
		$condition .= $tocredit ? " and m.credit<=$tocredit" : '';
		$condition .= $city ? " and i.city like '%$city%'" : '';
		$condition .= $homepage ? " and i.homepage like '%$homepage%'" : '';
		$condition .= $address ? " and i.address like '%$address%'" : '';

		$r = $db->get_one("SELECT count(*) as num FROM ".TABLE_MEMBER." m,".TABLE_MEMBER_INFO." i WHERE m.userid=i.userid $condition");
		$pages = phppages($r['num'], $page, $pagesize);

		$members = $member->get_list($condition, $page, $pagesize);

		$groupids = showgroup('select', 'groupid', $groupid);

		require PHPCMS_ROOT.'/include/area.func.php';
        $provinces = province();

		include admintpl('member_manage');

		break;

		case 'check':

        if($dosubmit)
	    {
            $member->check($userid);
            showmessage($LANG['operation_success'], $forward);
		}
		else
	    {
			$page = isset($page) ? intval($page) : 1;
			$pagesize = $PHPCMS['pagesize'] ? $PHPCMS['pagesize'] : 30;
			$offset = ($page-1)*$pagesize;

			$condition = " AND m.groupid=5";

			$r = $db->get_one("SELECT count(*) as num FROM ".TABLE_MEMBER." m,".TABLE_MEMBER_INFO." i WHERE m.userid=i.userid $condition");
			$pages = phppages($r['num'], $page, $pagesize);

			$members = $member->get_list($condition, $page, $pagesize);

			include admintpl('member_check');
		}

		break;

    case 'lock':

		if(!isset($userid)) showmessage($LANG['select_account'], $forward);

		$member->lock($userid, $val);
		showmessage($LANG['operation_success'], $forward);

		break;

    case 'note':
		if($dosubmit)
		{
			$db->query("UPDATE ".TABLE_MEMBER_INFO." SET note='$note' WHERE userid=$userid");
			showmessage($LANG['operation_success'], $forward);
		}
		else
		{
			$r = $db->get_one("SELECT m.username,i.note FROM ".TABLE_MEMBER." m,".TABLE_MEMBER_INFO." i WHERE m.userid=i.userid	AND m.userid=$userid");
			@extract($r);
			include admintpl('member_note');
		}
	break;

	case 'checkuser':
		if(strtolower($CONFIG['charset']) != 'utf-8' && preg_match("/^([\s\S]*?)([\x81-\xfe][\x40-\xfe])([\s\S]*?)/", $username))
		{
			include PHPCMS_ROOT.'/include/charset.func.php';
			$username = convert_encoding('utf-8', $CONFIG['charset'], $username);
			$member->set_username($username);
		}
		if(strlen($username) < 2 || strlen($username) > 20)
		{
			echo 1;
		}
		elseif($member->is_badword($username))
		{
			echo 2;
		}
		elseif($member->get_info())
		{
			echo 3;
		}
		elseif($member->get_info())
		{
			echo 4;
		}
		else
		{
			echo 0;
		}
	break;
	case 'search':
		$groupids = showgroup('select', 'groupid', $groupid);

		require PHPCMS_ROOT.'/include/area.func.php';
        $provinces = province();
        include admintpl('member_search');
		break;

	case 'move':
		$userids = is_array($userid) ? implode(',', $userid) : $userid;
	    if(!$userids) showmessage($LANG['select_account'], $PHP_REFERER);

		if($dosubmit)
	    {
			$groupid = intval($groupid);
	        if(!$groupid) showmessage($LANG['select_group'], $PHP_REFERER);

		    $sql = '';
		    if($ischargebynewgroup)
			{
				@extract($member->group($groupid));
				$begindate = date('Y-m-d');
				$date->dayadd($defaultvalidday);
				$enddate = $defaultvalidday == -1 ? '0000-00-00' : $date->get_date();
				$point = $defaultpoint;
				$sql = ",point='$point',chargetype='$chargetype',begindate='$begindate',enddate='$enddate'";
			}
            $db->query("UPDATE ".TABLE_MEMBER." SET groupid=$groupid $sql WHERE userid IN($userids)");
			showmessage($LANG['operation_success'], $forward);
		}
		else
	    {
			$member = array();
			$result = $db->query("SELECT userid,username FROM ".TABLE_MEMBER." WHERE userid IN($userids)");
			while($r = $db->fetch_array($result))
			{
				$member[$r['userid']] = $r['username'];
			}
			$groupids = showgroup('select', 'groupid', $groupid);
			include admintpl('member_move');
		}
		break;

    default :
}
?>