<?

//기존 db 연결 부분
$db_host		= "localhost";
$db_user		= "queenjbs";
$db_pass		= "jbs5642";
$db_name	= "jyjsite";

$db_con = mysql_connect($db_host, $db_user, $db_pass) or die(mysql_error());
$db_sel = mysql_select_db($db_name, $db_con) or die(mysql_error());
//db 연결 부분 끝

// =============================================== Query

//$QUERY_PAGE  = "SELECT * FROM  user where auth_code = 10 and userid ='ushi6002'";
$QUERY_PAGE  = "SELECT * FROM  user where auth_code = 10 order by id desc";

$result= mysql_query($QUERY_PAGE,$db_con);

//신규 db 연결 부분
$db_host_1 = "localhost";
$db_user_1 = "queenjbs";
$db_pass_1 = "jbs5642";
$db_name_1 = "sihooCafe";
$db_con_1 = mysql_connect($db_host_1, $db_user_1, $db_pass_1) or die(mysql_error());
$db_sel_1 = mysql_select_db($db_name_1, $db_con_1) or die(mysql_error());
?>
<META http-equiv=Content-Type content="text/html; charset=UTF-8">
<?
$kk=1;
while($row = mysql_fetch_array($result)) {


	$QUERY_DB1  = "SELECT member_srl,user_id FROM  `xe_member` where member_srl = '$row[id]'";
	$results= mysql_query($QUERY_DB1,$db_con_1);
	$rows = mysql_fetch_array($results);
	//echo "$kk 번 $rows[member_srl] <br>";
	if(!$rows[member_srl]){
	$mailArr  = explode("@","$row[email]");
	/*회원 삽입*/
	$userID = 'cafe_'.$row[userid];

	$insert_query="INSERT INTO `xe_member` (`member_srl`, `user_id`, `email_address`, `password`, `email_id`, `email_host`, `user_name`, `nick_name`, `homepage`, `blog`, `birthday`, `allow_mailing`, `allow_message`, `denied`, `limit_date`, `regdate`, `last_login`, `is_admin`, `description`, `extra_vars`) VALUES
($row[id], '$userID', '$row[email]', '$row[password]', '$mailArr[0]', '$mailArr[1]', '$row[nickname]_', '$row[nickname]_', '', '', '', 'N', 'N', 'N', '', '', '', 'N', '', '')";
	mysql_query($insert_query,$db_con_1);

	//echo "$kk 번 idx : ".$row[id]." ID :".$userID."<br>";
	//echo "$insert_query <br>";
	$kk++;
	}

}
echo "end";
?>