본문으로 건너뛰기

관리자-유저 세션 격리 강화

PHP 8 · GODO25
변경 파일 수: 1개
변경 파일 목록
총 1개
변경 파일 코드
추가삭제
Component/Member/MemberSnsDAO.php+1
변경 전MemberSnsDAO.php
$this->db->strField .= ', m.email, m.adultConfirmDt, m.adultFl, m.loginCnt, m.changePasswordDt, m.guidePasswordDt';
$this->db->strField .= ', m.modDt AS mModDt, m.regDt AS mRegDt, ms.snsJoinFl, ms.snsTypeFl, ms.connectFl, ms.accessToken';
$this->db->strField .= ', mg.groupNm, mg.groupSort, mh.sno AS hackOutSno';
 
$this->db->strJoin = ' LEFT JOIN ' . DB_MEMBER . ' AS m ON ms.memNo = m.memNo';
$this->db->strJoin .= ' LEFT JOIN ' . DB_MEMBER_GROUP . ' AS mg ON mg.sno = m.groupSno';
$this->db->strJoin .= ' LEFT JOIN ' . DB_MEMBER_HACKOUT . ' AS mh ON mh.memNo = m.memNo';
 
변경 후MemberSnsDAO.php
$this->db->strField .= ', m.email, m.adultConfirmDt, m.adultFl, m.loginCnt, m.changePasswordDt, m.guidePasswordDt';
$this->db->strField .= ', m.modDt AS mModDt, m.regDt AS mRegDt, ms.snsJoinFl, ms.snsTypeFl, ms.connectFl, ms.accessToken';
$this->db->strField .= ', mg.groupNm, mg.groupSort, mh.sno AS hackOutSno';
$this->db->strField .= ', m.mallSno'; // 세션 저장 시 기준몰 판정에 사용 (누락되면 세션 핸들러가 회원을 재조회하며 세션ID를 재발급한다)
$this->db->strJoin = ' LEFT JOIN ' . DB_MEMBER . ' AS m ON ms.memNo = m.memNo';
$this->db->strJoin .= ' LEFT JOIN ' . DB_MEMBER_GROUP . ' AS mg ON mg.sno = m.groupSno';
$this->db->strJoin .= ' LEFT JOIN ' . DB_MEMBER_HACKOUT . ' AS mh ON mh.memNo = m.memNo';