members.php

在传统CMS文章内容管理功能基础上

<?php
/*
    [BBWPS!] (C)2006-2010 小蜜蜂版权所有.
	  This is NOT a freeware, use is subject to license terms
*/
/*:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:   功能:同步论坛和平台的用户                                       :
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::*/
error_reporting(0);
//-------------------------------------
//校验用户是不是非法操作
//-------------------------------------
if(!function_exists("CheckRequire")){
	exit("Forbidden");
}
if(file_exists("./data/userconfig.php")){
	include_once("./data/userconfig.php");
}
//------------------------------
//$db平台数据库对像
//------------------------------
$db=new DB($hostname,$username,$password,$database);
//------------------------------
//$discuzDb论坛数据库对像
//------------------------------
$discuzhost = $discuzhost?$discuzhost:"localhost";
$discuzDb=new DB($discuzhost,$discuzusername,$discuzpwd,$discuzdatabase); //实例化discuz数据库实例
//------------------------------
//把$_GET数组的下标做为变量
//------------------------------
extract($_GET);
//------------------------------
//默认脚本执行时间
//------------------------------
$bbwpslimit = ($bbwpslimit||$bbwpslimit>30)?$bbwpslimit:30;
$dzlimit = ($dzlimit||$dzlimit>30)?$dzlimit:30;
//------------------------------
//平台同步到论坛
//------------------------------
if($action=="todz"){
	is_numeric($bbwpsuid)?null:exit("<script language=javascript>window.location.href='./admin.php?mod=member&f=userconf';</script>");
	set_time_limit($bbwpslimit);
	$bbwpsSql = "select * from ".$database.".".$prefix."members where uid<".$bbwpsuid;
	$bbwpsRes = $db->query($bbwpsSql,true);
	while ($bbwpsObj = $db->fetch_object($bbwpsRes)){
		$dzSql = "select * from ".$discuzdatabase.".".$discuzprefix."members where username='".$bbwpsObj->username."'";
		//---------------------------------------------------
		//检查论坛中有没有重名的用户，如果有则不插入，没有则插入
		//---------------------------------------------------
		if(!$dzObj=$discuzDb->get_one($dzSql)){
			//---------------------------------------------------------
			//查出平台中memberfields表中对应的数据
			//---------------------------------------------------------
			$bbwpsMemberfieldsSql = "select * from ".$database.".".$prefix."memberfields where username='".$bbwpsObj->username."'";
			$bbwpsMemberfieldsObj = $db->get_one($bbwpsMemberfieldsSql);
			//---------------------------------------------------
			//插入论坛members表中
			//---------------------------------------------------
			//:::::::::::::::::::::::::::::::::::::::::::::::::::
			//导入会员用户组
			//:::::::::::::::::::::::::::::::::::::::::::::::::::
			if($usergroups==-1){
				//------------------------------------------------------
				//查出最小的会员用户组的积分字段
				//------------------------------------------------------
				$creditshigherSql = "select min(creditshigher) as groupid from ".$discuzdatabase.".".$discuzprefix."usergroups where type='member' and creditshigher>=0";
				$creditshigherObj = $discuzDb->get_one($creditshigherSql);
				//------------------------------------------------------
				//查出最小的会员用户组的用户组ID号
				//------------------------------------------------------
				$groupIdSql = "select groupid from ".$discuzdatabase.".".$discuzprefix."usergroups where type='member' and creditshigher='".$creditshigherObj->groupid."'";
				$groupIdObj = $discuzDb->get_one($groupIdSql);
				$dzMembersSql = "insert into ".$discuzdatabase.".".$discuzprefix."members (`username`,`password`,`regip`,`regdate`,`lastip`,`lastvisit`,`oltime`,`bday`,`gender`,`email`,`adminid`,`groupid`) values ('$bbwpsObj->username','$bbwpsObj->password','$bbwpsObj->regip','$bbwpsObj->regdate','$bbwpsObj->lastip','$bbwpsObj->lastvisit','$bbwpsObj->oltime','$bbwpsMemberfieldsObj->bday','$bbwpsMemberfieldsObj->gender','$bbwpsObj->email','0','$groupIdObj->groupid')";
			//:::::::::::::::::::::::::::::::::::::::::::::::::::
			//导入特殊用户组
			//:::::::::::::::::::::::::::::::::::::::::::::::::::
			}else {
				$dzMembersSql = "insert into ".$discuzdatabase.".".$discuzprefix."members (`username`,`password`,`regip`,`regdate`,`lastip`,`lastvisit`,`oltime`,`bday`,`gender`,`email`,`adminid`,`groupid`) values ('$bbwpsObj->username','$bbwpsObj->password','$bbwpsObj->regip','$bbwpsObj->regdate','$bbwpsObj->lastip','$bbwpsObj->lastvisit','$bbwpsObj->oltime','$bbwpsMemberfieldsObj->bday','$bbwpsMemberfieldsObj->gender','$bbwpsObj->email','-1','$usergroups')";
			}
			$discuzDb->update($dzMembersSql);
			//---------------------------------------------------------
			//插入到平台memberfields表中
			//---------------------------------------------------------
			$dzMemberfieldsSql = "insert into ".$discuzdatabase.".".$discuzprefix."memberfields (`uid`,`nickname`,`site`,`alipay`,`icq`,`qq`,`yahoo`,`msn`,`taobao`,`location`,`bio`) values ('".$db->insert_id()."','$bbwpsMemberfieldsObj->name','$bbwpsMemberfieldsObj->site','$bbwpsMemberfieldsObj->alipay','$bbwpsMemberfieldsObj->icq','$bbwpsMemberfieldsObj->qq','$bbwpsMemberfieldsObj->yahoo','$bbwpsMemberfieldsObj->msn','$bbwpsMemberfieldsObj->taobao','$bbwpsMemberfieldsObj->location','$bbwpsMemberfieldsObj->bio')";
			$discuzDb->update($dzMemberfieldsSql);
		}
	}
	unset($db,$discuzDb);
	print ("<script language=javascript>alert('同步成功!');window.location.href='./admin.php?mod=member&f=userconf';</script>");
	exit();
}
//------------------------------
//论坛同步到平台
//------------------------------
if($action=="tobbwps"){
	set_time_limit($dzlimit);
	is_numeric($dzuid)?null:exit("<script language=javascript>window.location.href='./admin.php?mod=member&f=userconf';</script>");
	$dzSql = "select * from ".$discuzdatabase.".".$discuzprefix."members where uid<".$dzuid;
	$dzRes = $discuzDb->query($dzSql,true);
	while ($dzObj = $discuzDb->fetch_object($dzRes)){
		$bbwpsSql = "select * from ".$database.".".$prefix."members where username='".$dzObj->username."'";
		//---------------------------------------------------
		//检查平台中有没有重名的用户，如果有则不插入，没有则插入
		//---------------------------------------------------
		if(!$bbwpsObj=$db->get_one($bbwpsSql)){
			//---------------------------------------------------
			//插入平台members表中
			//---------------------------------------------------
			$bbwpsMembersSql = "insert into ".$database.".".$prefix."members (`username`,`password`,`regip`,`regdate`,`lastip`,`lastvisit`,`oltime`,`online`,`onlinetime`,`email`,`available`) values ('$dzObj->username','$dzObj->password','$dzObj->regip','$dzObj->regdate','$dzObj->lastip','$dzObj->lastvisit','$dzObj->oltime','','','$dzObj->email','1')";
			$db->update($bbwpsMembersSql);
			//---------------------------------------------------------
			//查出论坛中memberfields表中对应的数据，并查出到平台相应的表中
			//---------------------------------------------------------
			$dzMemberfieldsSql = "select * from ".$discuzdatabase.".".$discuzprefix."memberfields where uid='".$dzObj->uid."'";
			$dzMemberfieldsObj = $discuzDb->get_one($dzMemberfieldsSql);
			$bbwpsMemberfieldsSql = "insert into ".$database.".".$prefix."memberfields (`username`,`name`,`gender`,`site`,`alipay`,`bday`,`icq`,`qq`,`yahoo`,`msn`,`taobao`,`location`,`phone`,`mobile`,`comadd`,`postalcode`,`bio`,`email`) values ('$dzObj->username','$dzMemberfieldsObj->nickname','$dzObj->gender','$dzMemberfieldsObj->site','$dzMemberfieldsObj->alipay','$dzObj->bday','$dzMemberfieldsObj->icq','$dzMemberfieldsObj->qq','$dzMemberfieldsObj->yahoo','$dzMemberfieldsObj->msn','$dzMemberfieldsObj->taobao','$dzMemberfieldsObj->location','','','','','$dzMemberfieldsObj->bio','$dzObj->email')";
			$db->update($bbwpsMemberfieldsSql);
		}
	}
	unset($db,$discuzDb);
	print ("<script language=javascript>alert('同步成功!');window.location.href='./admin.php?mod=member&f=userconf';</script>");
	exit();
}
?>