<?
	require $_SERVER['DOCUMENT_ROOT'].'/lib/global.php';

	$sql = "select * from member where idx>2 order by idx ";
	$rs = query($sql);
	if(rows()>0)
	{
		for($i=0;$row=assoc($rs);$i++)
		{
			$list[] = $row;
		}
	}
	//echoAr($list);
	for($i=0;count($list)>$i;$i++)
	{
		$isql = "insert into _MEMBER set m_idx='".$list[$i]["idx"]."', m_hp='".$list[$i]["cell_number"]."', m_id='".$list[$i]["member_id"]."', m_pass='".$list[$i]["member_passwd"]."', m_email='".$list[$i]["member_id"]."', m_regi='".$list[$i]["FCM_token"]."', m_logintype='general', m_type='A', m_site='1', m_last_site='',m_expire_date='',m_expire_time='', regdate='', modidate='', m_ip='', m_agent='', m_free_msg='', m_point='', m_heart='', m_master_idx='".$list[$i]["masterIdx"]."', m_push_cnt='', m_kind='', m_point_state='', m_inapp_subsrc='', m_use='', m_ban='', m_black='', m_recom='', m_birth='', m_gender='".$list[$i]["gender"]."', m_bank_num='', m_bank_name='', m_bank_account='', m_post_is='', m_sms_is='', m_level='', m_chocolate=0, m_ticket='', m_ticket_sdatetime='', m_ticket_edatetime='', m_likecnt='0', m_notice_push='Y', m_talk_push='Y', m_chat_push='Y', m_os='android', m_lastlogindate='".$list[$i]["recent_date"]."', m_expose_cnt='".$list[$i]["expose_cnt"]."', order_point='".$list[$i]["order_point"]."'";
		//echo $isql;
		//query($isql);

		$psql = "insert into _PROFILE set p_m_idx='".$list[$i]["idx"]."'";
		$psql .= ", p_name='".$list[$i]["username"]."'";
		$psql .= ", p_sex='".$list[$i]["gender"]."'";
		$psql .= ", p_date='".$list[$i]["b_year"]."-".$list[$i]["b_month"]."-".$list[$i]["b_day"]."'";
		$psql .= ", p_age='".$list[$i]["age"]."'";
		$psql .= ", p_blood='".$list[$i]["prof_blood"]."'";
		$psql .= ", p_region='".$list[$i]["prof_area"]."'";
		$psql .= ", p_job='".$list[$i]["work_job"]."'";
		$psql .= ", p_work='".$list[$i]["work_office"]."'";
		$psql .= ", p_smoke=''";
		$psql .= ", p_drink='".$list[$i]["prof_drink"]."'";
		$psql .= ", p_height='".$list[$i]["prof_height"]."'";
		$psql .= ", p_weight='".$list[$i]["prof_weight"]."'";
		$psql .= ", p_relation=''";
		$psql .= ", p_religion='".$list[$i]["prof_religion"]."'";
		$psql .= ", p_onoff='on'";
		$psql .= ", p_school='".$list[$i]["lastschool"]."'";
		$psql .= ", p_school_edu='".$list[$i]["prof_edu"]."'";
		$psql .= ", p_major='".$list[$i]["prof_edu"]."'";
		$psql .= ", p_character='".$list[$i]["personal_character"]."'";
		$psql .= ", p_inter=''";
		$psql .= ", p_inter2=''";
		$psql .= ", p_gt='".$list[$i]["introduce"]."'";
		$psql .= ", p_sum_img='".$list[$i]["pimg"]."'";
		$psql .= ", p_img1='".$list[$i]["pimg"]."'";
		$psql .= ", p_img2='".$list[$i]["detail_images"]."'";
		$psql .= ", p_blur=''";
		$psql .= ", p_lat='".$list[$i]["gpsh"]."'";
		$psql .= ", p_lon='".$list[$i]["gpsw"]."'";
		$psql .= ", p_login_type=''";
		$psql .= ", p_like=''";
		$psql .= ", p_hot=''";
		$psql .= ", p_typing=''";
		$psql .= ", p_regdate='".$list[$i]["regdate"]."'";
		$psql .= ", p_modidate=''";
		$psql .= ", p_last_time=''";
		$psql .= ", p_kind='USER'";
		$psql .= ", p_kind_type='1'";
		$psql .= ", p_site='1'";
		$psql .= ", p_use='".$list[$i]["available"]."'";
		$psql .= ", p_tmp_update=''";
		$psql .= ", p_search_use=''";
		$psql .= ", p_location_1='".$list[$i]["addr_1"]."'";
		$psql .= ", p_location_2='".$list[$i]["addr_2"]."'";
		$psql .= ", p_location_3='".$list[$i]["addr_3"]."'";
		$psql .= ", p_personality=''";
		$psql .= ", p_disposition='".$list[$i]["disposition"]."'";
		$psql .= ", p_hobby='".$list[$i]["hobby"]."'";
		$psql .= ", p_leisure='".$list[$i]["leisure"]."'";
		$psql .= ", p_favorite='".$list[$i]["place"]."'";
		$psql .= ", p_dateplace='".$list[$i]["dateplace"]."'";
		$psql .= ", p_wish='".$list[$i]["want"]."'";
		$psql .= ", p_age2='".$list[$i]["p_age"]."'";
		$psql .= ", p_distance='".$list[$i]["p_area"]."'";
		$psql .= ", p_blood2='".$list[$i]["p_blood"]."'";
		$psql .= ", p_height2='".$list[$i]["p_height"]."'";
		$psql .= ", p_weight2='".$list[$i]["p_bodytype"]."'";
		$psql .= ", p_final_education='".$list[$i]["p_edu"]."'";
		$psql .= ", p_body='".$list[$i]["prof_bodytype"]."'";
		$psql .= ", p_personality2='".$list[$i]["p_character"]."'";
		$psql .= ", p_disposition2='".$list[$i]["p_disposition"]."'";
		$psql .= ", p_religion2='".$list[$i]["p_religion"]."'";
		$psql .= ", p_drink2='".$list[$i]["p_drink"]."'";
		$psql .= ", p_ai_use=''";
		$psql .= ", p_ai_img=''";
		$psql .= ", p_ai_name='".$list[$i]["chatname"]."'";
		$psql .= ", recomment_cnt='".$list[$i]["recomment_cnt"]."'";

		//echo $psql;
		//query($psql);
	}

	//머신 재분배
	$sql = "select * from _MEMBER where m_idx>2 and m_idx<2573";
	$rs1 = query($sql);
	if(rows()>0)
	{
		for($i=0;$row1=assoc($rs1);$i++)
		{
			$list1[] = $row1;
		}
	}

	for($i=0;count($list1)>$i;$i++)
	{
		$cpinfo = getValue("_PROFILE"," where p_m_idx='".$list1[$i]["m_id"]."'","ar","*",false);
		if($cpinfo)
		{
			$psql = "insert into _PROFILE set p_m_idx='".$list1[$i]["m_idx"]."'";
			$psql .= ", p_name='".$cpinfo["p_name"]."'";
			$psql .= ", p_sex='".$cpinfo["p_sex"]."'";
			$psql .= ", p_date='".$cpinfo["p_date"]."'";
			$psql .= ", p_age='".$cpinfo["p_age"]."'";
			$psql .= ", p_blood='".$cpinfo["p_blood"]."'";
			$psql .= ", p_region='".$cpinfo["p_region"]."'";
			$psql .= ", p_job='".$cpinfo["p_job"]."'";
			$psql .= ", p_work='".$cpinfo["p_work"]."'";
			$psql .= ", p_smoke='".$cpinfo["p_smoke"]."'";
			$psql .= ", p_drink='".$cpinfo["p_drink"]."'";
			$psql .= ", p_height='".$cpinfo["p_height"]."'";
			$psql .= ", p_weight='".$cpinfo["p_weight"]."'";
			$psql .= ", p_relation='".$cpinfo["p_relation"]."'";
			$psql .= ", p_religion='".$cpinfo["p_religion"]."'";
			$psql .= ", p_onoff='".$cpinfo["p_onoff"]."'";
			$psql .= ", p_school='".$cpinfo["p_school"]."'";
			$psql .= ", p_school_edu='".$cpinfo["p_school_edu"]."'";
			$psql .= ", p_major='".$cpinfo["p_major"]."'";
			$psql .= ", p_character='".$cpinfo["p_character"]."'";
			$psql .= ", p_inter='".$cpinfo["p_inter"]."'";
			$psql .= ", p_inter2='".$cpinfo["p_inter2"]."'";
			$psql .= ", p_gt='".$cpinfo["p_gt"]."'";
			$psql .= ", p_sum_img='".$cpinfo["p_sum_img"]."'";
			$psql .= ", p_img1='".$cpinfo["p_img1"]."'";
			$psql .= ", p_img2='".$cpinfo["p_img2"]."'";
			$psql .= ", p_blur='".$cpinfo["p_blur"]."'";
			$psql .= ", p_lat='".$cpinfo["p_lat"]."'";
			$psql .= ", p_lon='".$cpinfo["p_lon"]."'";
			$psql .= ", p_login_type='".$cpinfo["p_login_type"]."'";
			$psql .= ", p_like='".$cpinfo["p_like"]."'";
			$psql .= ", p_hot='".$cpinfo["p_hot"]."'";
			$psql .= ", p_typing='".$cpinfo["p_typing"]."'";
			$psql .= ", p_regdate='".$cpinfo["p_regdate"]."'";
			$psql .= ", p_modidate='".$cpinfo["p_modidate"]."'";
			$psql .= ", p_last_time='".$cpinfo["p_last_time"]."'";
			$psql .= ", p_kind='".$cpinfo["p_kind"]."'";
			$psql .= ", p_kind_type='".$cpinfo["p_kind_type"]."'";
			$psql .= ", p_site='".$cpinfo["p_site"]."'";
			$psql .= ", p_use='".$cpinfo["p_use"]."'";
			$psql .= ", p_tmp_update='".$cpinfo["p_tmp_update"]."'";
			$psql .= ", p_search_use='".$cpinfo["p_search_type"]."'";
			$psql .= ", p_location_1='".$cpinfo["p_location_1"]."'";
			$psql .= ", p_location_2='".$cpinfo["p_location_2"]."'";
			$psql .= ", p_location_3='".$cpinfo["p_location_3"]."'";
			$psql .= ", p_personality='".$cpinfo["p_personality"]."'";
			$psql .= ", p_disposition='".$cpinfo["p_disposition"]."'";
			$psql .= ", p_hobby='".$cpinfo["p_hobby"]."'";
			$psql .= ", p_leisure='".$cpinfo["p_leisure"]."'";
			$psql .= ", p_favorite='".$cpinfo["p_favorite"]."'";
			$psql .= ", p_dateplace='".$cpinfo["p_dateplace"]."'";
			$psql .= ", p_wish='".$cpinfo["p_wish"]."'";
			$psql .= ", p_age2='".$cpinfo["p_age2"]."'";
			$psql .= ", p_distance='".$cpinfo["p_diatance"]."'";
			$psql .= ", p_blood2='".$cpinfo["p_blood2"]."'";
			$psql .= ", p_height2='".$cpinfo["p_height2"]."'";
			$psql .= ", p_weight2='".$cpinfo["p_weight2"]."'";
			$psql .= ", p_final_education='".$cpinfo["p_final_education"]."'";
			$psql .= ", p_body='".$cpinfo["p_body"]."'";
			$psql .= ", p_personality2='".$cpinfo["p_personality2"]."'";
			$psql .= ", p_disposition2='".$cpinfo["p_disposition2"]."'";
			$psql .= ", p_religion2='".$cpinfo["p_religion2"]."'";
			$psql .= ", p_drink2='".$cpinfo["p_drink2"]."'";
			$psql .= ", p_ai_use='".$cpinfo["p_ai_use"]."'";
			$psql .= ", p_ai_img='".$cpinfo["p_ai_img"]."'";
			$psql .= ", p_ai_name='".$cpinfo["p_ai_name"]."'";
			$psql .= ", recomment_cnt='".$cpinfo["recomment_cnt"]."'";
			query($psql);
		}
	}
	echo $i;
?>