if ( !defined("_INCLUDED_GLOBAL") ) exit; // [Security]Allow_url_fopen = On ?> if($G_SYS['NM_PWDCHANGE_POPUP_USE']){ // [2022-07-28] oracle 쿼리적용. if ($G_SYS['DB'] == 'oracle') { $mbr_pwdchndate = db_get_row(" SELECT case when TO_DATE(nvl(m_last_pwdchgdate, m_regdate), 'YYYY-MM-DD HH24:MI:SS') < add_months(sysdate , -".$G_SYS['NM_PWDCHANGE_POPUP_MONTH'].") then 'Y' else 'N' end pwd_change_pupup , nvl(m_last_pwdchgdate, m_regdate) m_last_pwdchgdate FROM ".$TB['MEMBER']." WHERE m_usertype IS NULL AND m_no='". $AUTH['auth_m_no'] . "' "); } else { $mbr_pwdchndate = db_get_row(" SELECT case when IFNULL(m_last_pwdchgdate, m_regdate) < now() - INTERVAL ".$G_SYS['NM_PWDCHANGE_POPUP_MONTH']." MONTH then 'Y' else 'N' end pwd_change_pupup , IFNULL(m_last_pwdchgdate, m_regdate) m_last_pwdchgdate FROM ".$TB['MEMBER']." WHERE m_usertype IS NULL AND m_no='". $AUTH['auth_m_no'] . "' "); } if($mbr_pwdchndate['pwd_change_pupup']=="Y" && $_COOKIE['nm_pwd_change_popup_yn']!="N" && $_SERVER['PHP_SELF'] === '/index.php'){ ?>
} } ?>