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'];