public static function get_shops($ins_shop_cd)
{
$db = new Class_DB();
$sql = "SELECT a.shop_cd, a.shop_name FROM M_SHOP a inner JOIN M_INS_SHOP_SHOP b on a.shop_cd = b.shop_cd where b.ins_shop_cd = '{$ins_shop_cd}'";
//echo $sql;
$db->query($sql);
$data = array();
while ($row = $db->fetch()) {
$data[] = $row["shop_name"];
}
return implode(",", $data);
}
if ($err_mes['login_pass']) {
$passmsg = $msg_bg . "パスワードは" . $err_mes['login_pass'] . $msg_ed;
if ($err_msg) {
$err_msg = $err_msg . $passmsg;
} else {
$err_msg = $passmsg;
}
}
// login_id and login_pass ok
if ($oerr->clear) {
// get data by login_id and login_pwd
$db = new Class_DB();
$sql = sprintf("SELECT * FROM mp_account WHERE login_id = '%s' AND login_pwd = '%s' ", mysql_real_escape_string($id), mysql_real_escape_string(Class_PWD::do_encode($pass)));
$db->query($sql);
if ($db->num_rows()) {
$row = $db->fetch();
// ログイン不可
if ($row['login_flgs'] == '1') {
$err_msg = '<p class="caution">ログインできません。管理者にお問い合わせください。</p>';
$err = true;
$db->close();
// ログイン可
} else {
// set auth and session
session_name('PREGO_ADMIN');
//session_cache_limiter(private_no_expire);
session_start();
$auth = $row['sorts'];
$_SESSION['PREGO_ADMIN']['STAFF_SEQ'] = $row['id'];
$_SESSION['PREGO_ADMIN']['STAFF_ID'] = $row['login_id'];
$_SESSION['PREGO_ADMIN']['STAFF_PWD'] = $row['login_pwd'];
