[재질문] 엑셀 회원 일괄등록 질문드려요!! (패스워드 관련!) 채택완료
ddddddddd
11년 전
조회 5,534
엑셀로 회원리스트 작성하여 업로드 테스트를 하고 있는데요
패스워드만 먹히질 않습니다. 그냥 아예 아무것도 입력이 안되요.
아마도 암호화 때문일거라고 생각은 드는데
lib/common.lib.php 에서 패스워드 관련 수정을 하면 패스워드값 올려는지는데 로그인이 안되네요
아래 원문소스 입니다.. 도움부탁드려요 ㅠ
</div>
<div><div><?</div>
<div>$sub_menu = "200200";</div>
<div>include_once("./_common.php");</div>
<div>include_once("./admin.head.php");</div>
<div>
</div>
<div>$csvLoad = file($_FILES['fr_od_id']['tmp_name']); </div>
<div>$csvArray = split("\n",implode($csvLoad));</div>
<div>
</div>
<div>for($i=1;$i<count($csvArray)-1;$i++) { </div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$csvArray_utf = iconv('euc-kr','utf-8',$csvArray[$i]); </div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$minfo=explode(",", $csvArray_utf);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_id=$minfo[0]; // 아이디</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_password=$minfo[1]; // </div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_name=$minfo[2]; // 이름</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_nick=$minfo[3]; // 별명</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_email=$minfo[4]; // 이메일</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_sex=$minfo[5]; //성별</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_birth=$minfo[6]; //생년월일</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_addr1=$minfo[7]; //주소1</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_addr2=$minfo[8]; //주소2</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_hp=$minfo[9]; //핸드폰</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_tel=$minfo[10]; //전화번호</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_level=$minfo[11]; //레벨</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_point=$minfo[12]; //포인트</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_datetime=$minfo[13]; //가입일</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_today_login=$minfo[14]; //로그인일</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_mailling=$minfo[15]; //메일링여부</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if($m_mailling=="예") $m_mailling = 1;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>else $m_mailling = 0;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_open=$minfo[16]; //공개여부</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if($m_open=="예") $m_open = 1;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>else $m_open = 0;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_email_certify=$minfo[17]; //이메일인증일</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_intercept_date=$minfo[18]; //차단일</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_1=$minfo[19];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_2=$minfo[20];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_3=$minfo[21];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_4=$minfo[22];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_5=$minfo[23];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$m_6=$minfo[24];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span></div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$sql = "select count(*) as cnt from $g4[member_table] where mb_id='$m_id' ";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$row2 = sql_fetch($sql);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if($row2[cnt]>0){</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$sql=" update $g4[member_table] set<span class="Apple-tab-span" style="white-space: pre"> </span></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_name='$m_name',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_nick='$m_nick',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_email='$m_email',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_sex='$m_sex',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_birth='$m_birth',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_addr1='$m_addr1',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_addr2='$m_addr2',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_hp='$m_hp',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_tel='$m_tel',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_level='$m_level',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_point='$m_point',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_datetime='$m_datetime',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_today_login='$m_today_login',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_mailling='$m_mailling',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_open='$m_open',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_1='$m_1',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_2='$m_2',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_3='$m_3',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_4='$m_4',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_5='$m_5',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_6='$m_6'</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>where mb_id='$m_id'";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}else{</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$sql=" insert into $g4[member_table] set</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_id='$m_id',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_password='$m_password',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_name='$m_name',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_nick='$m_nick',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_email='$m_email',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_sex='$m_sex',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_birth='$m_birth',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_addr1='$m_addr1',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_addr2='$m_addr2',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_hp='$m_hp',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_tel='$m_tel',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_level='$m_level',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_point='$m_point',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_datetime='$m_datetime',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_today_login='$m_today_login',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_mailling='$m_mailling',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_open='$m_open',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_1='$m_1',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_2='$m_2',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_3='$m_3',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_4='$m_4',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_5='$m_5',</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_6='$m_6'";</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>sql_query($sql);</div>
<div>}</div>
<div>
</div>
<div>$num=count($csvArray)-2;</div>
<div>
</div>
<div>echo "{$num}건 변환 완료 되었습니다.";</div>
<div>echo "
<input type='button' class=btn1 value='완료' onclick=\"location.href('$g4[path]/adm/member_list.php');\">";</div>
<div>include_once ("./admin.tail.php");</div>
<div>?></div></div>
<div>
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
답변을 작성하려면 로그인이 필요합니다.
로그인