<?
echo '<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />';
$link = mysql_connect('host이름', '계정이름', '비번');
$tablename = "테이블이름";
mysql_select_db('db이름', $link);
mysql_query("set names utf8;");
// 회원 데이타 변환
 $result=mysql_query("select * from xe_member_o where user_id <> 'admin';",$link);
 $i=0;
 while($data=mysql_fetch_array($result))
{
  $i++;
$user_id = $data[user_id];

  $data1 = unserialize($data[extra_vars]);
  $array = array();
  if (!is_object($data1)) {echo "이크";}
  if (is_object($data1))
  {
  $array = get_object_vars($data1);
  }
  $o = sizeof($array);
  $extra_s = 'O:8:"stdClass":'.$o.':{';
$jumin= $license = $major = $comment = $job = $hobby = $homeaddress = $hometel = $officeaddress = $officetel = $handphone = blank;
if($array[jumin]) {
 $jumin = $array[jumin];
 $extra_s .= 's:5:"jumin";'.serialize($jumin);
 }
if($array[license]) {
 $license = $array[license];
 $extra_s .= 's:7:"license";'.serialize($license);
 }
if($array[major]) {
 $major = $array[major];
 $extra_s .= 's:5:"major";'.serialize($major);
 }
if($array[comment]) {
 $comment = $array[comment];
 $extra_s .= 's:7:"comment";'.serialize($comment);
 }
if($array[job]) {
 $job = $array[job];
 $extra_s .= 's:3:"job";'.serialize($job);
 }
if($array[hobby]) {
 $hobby = $array[hobby];
 $extra_s .= 's:5:"hobby";'.serialize($hobby);
 }
if($array[homeaddress]) {
 $homeaddress = $array[homeaddress];
 $homeaddress = array(preg_replace('/[1-9\-]+$/','',$homeaddress),str_replace(preg_replace('/[1-9\-]+$/','',$homeaddress),'', $homeaddress)); 
 $extra_s .= 's:11:"homeaddress";'.serialize($homeaddress);
 }
if($array[hometel]) {
 $hometel = $array[hometel];
    $hometel = array(substr($hometel,0,3),str_replace('-','',substr($hometel,3,-4)), substr($hometel,-4));
 $extra_s .= 's:7:"hometel";'.serialize($hometel);
 }
if($array[officeaddress]) {
 $officeaddress = $array[officeaddress];
 $officeaddress = array(preg_replace('/[1-9\-]+$/','',$officeaddress),str_replace(preg_replace('/[1-9\-]+$/','',$officeaddress),'', $officeaddress));
 $extra_s .= 's:13:"officeaddress";'.serialize($officeaddress); 
 }
if($array[officetel]) {
 $officetel = $array[officetel];
    $officetel = array(substr($officetel,0,3),str_replace('-','',substr($officetel,3,-4)), substr($officetel,-4));
    $extra_s .= 's:9:"officetel";'.serialize($officetel);
 }
if($array[handphone]) {
 $handphone = $array[handphone];
    $handphone = array(substr($handphone,0,3),str_replace('-','',substr($handphone,3,-4)), substr($handphone,-4));
 $extra_s .= 's:9:"handphone";'.serialize($handphone);
 }
$extra_s .= "}";

$que = "update xe_member set extra_vars = '".$extra_s."' where user_id = '".$user_id."';";

mysql_query($que,$link);

}
echo "총 업데이트 쿼리 수:".$i;

?>