2025-12-25 09:09:59SELECT `dtb_room`.*
FROM `dtb_room`
JOIN `dtb_room_option` as `dro` ON `dtb_room`.`room_id` = `dro`.`room_id`
WHERE `del_flg` =0
AND   (
`room_limit` IS NULL
OR `room_limit` <= '2025-12-25 09:09:59'
 )Array
(
    [roomlist] => Array
        (
            [0] => Array
                (
                    [room_id] => 1
                    [room_name] => テストROOM
                    [room_limit] => 10
                    [room_daylimit] => 2020-04-17 17:00:00
                    [del_flg] => 0
                    [create_at] => 2020-04-17 00:00:00
                    [update_at] => 2020-04-17 00:00:00
                )

        )

    [color] => Array
        (
            [0] => Array
                (
                    [color_id] => 1
                    [color_code] => #ffffff
                    [create_at] => 
                    [update_at] => 
                )

            [1] => Array
                (
                    [color_id] => 2
                    [color_code] => #333333
                    [create_at] => 
                    [update_at] => 
                )

            [2] => Array
                (
                    [color_id] => 3
                    [color_code] => #ff0000
                    [create_at] => 
                    [update_at] => 
                )

            [3] => Array
                (
                    [color_id] => 4
                    [color_code] => #ff0080
                    [create_at] => 
                    [update_at] => 
                )

            [4] => Array
                (
                    [color_id] => 5
                    [color_code] => #ff00ff
                    [create_at] => 
                    [update_at] => 
                )

            [5] => Array
                (
                    [color_id] => 6
                    [color_code] => #8000ff
                    [create_at] => 
                    [update_at] => 
                )

            [6] => Array
                (
                    [color_id] => 7
                    [color_code] => #0000ff
                    [create_at] => 
                    [update_at] => 
                )

            [7] => Array
                (
                    [color_id] => 8
                    [color_code] => #0080ff
                    [create_at] => 
                    [update_at] => 
                )

            [8] => Array
                (
                    [color_id] => 9
                    [color_code] => #00ffff
                    [create_at] => 
                    [update_at] => 
                )

            [9] => Array
                (
                    [color_id] => 10
                    [color_code] => #00ff80
                    [create_at] => 
                    [update_at] => 
                )

            [10] => Array
                (
                    [color_id] => 11
                    [color_code] => #00ff00
                    [create_at] => 
                    [update_at] => 
                )

            [11] => Array
                (
                    [color_id] => 12
                    [color_code] => #80ff00
                    [create_at] => 
                    [update_at] => 
                )

            [12] => Array
                (
                    [color_id] => 13
                    [color_code] => #ffff00
                    [create_at] => 
                    [update_at] => 
                )

            [13] => Array
                (
                    [color_id] => 14
                    [color_code] => #ff8000
                    [create_at] => 
                    [update_at] => 
                )

        )

    [font] => Array
        (
            [1] => Array
                (
                    [font_id] => 1
                    [font_name] => 焔明朝
                    [font_path] => 05HomuraM-SemiBold.otf
                    [create_at] => 0000-00-00 00:00:00
                    [update_at] => 0000-00-00 00:00:00
                )

            [2] => Array
                (
                    [font_id] => 2
                    [font_name] => 
                    [font_path] => f910-shin-comic-2.04.otf
                    [create_at] => 0000-00-00 00:00:00
                    [update_at] => 0000-00-00 00:00:00
                )

            [3] => Array
                (
                    [font_id] => 3
                    [font_name] => 
                    [font_path] => FGMediumHankaku.ttf
                    [create_at] => 0000-00-00 00:00:00
                    [update_at] => 0000-00-00 00:00:00
                )

            [4] => Array
                (
                    [font_id] => 4
                    [font_name] => 
                    [font_path] => FGMediumOldHankaku.ttf
                    [create_at] => 0000-00-00 00:00:00
                    [update_at] => 0000-00-00 00:00:00
                )

            [5] => Array
                (
                    [font_id] => 5
                    [font_name] => 
                    [font_path] => ipagp.ttf
                    [create_at] => 0000-00-00 00:00:00
                    [update_at] => 0000-00-00 00:00:00
                )

            [6] => Array
                (
                    [font_id] => 6
                    [font_name] => 
                    [font_path] => ipamp.ttf
                    [create_at] => 0000-00-00 00:00:00
                    [update_at] => 0000-00-00 00:00:00
                )

        )

)
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <title>Coming - Bootstrap Under Construction Template</title>
  <meta content="width=device-width, initial-scale=1.0" name="viewport">
  <meta content="" name="keywords">
  <meta content="" name="description">

  <!-- Favicons -->
  <link href="img/favicon.png" rel="icon">
  <link href="img/apple-touch-icon.png" rel="apple-touch-icon">

  <!-- Google Fonts -->
  <link href="https://fonts.googleapis.com/css?family=Lato:300,400,700,900" rel="stylesheet">

  <!-- Bootstrap CSS File -->
  <link href="lib/bootstrap/css/bootstrap.min.css" rel="stylesheet">

  <!-- Libraries CSS Files -->
  <link href="lib/ionicons/css/ionicons.min.css" rel="stylesheet">

  <!-- Main Stylesheet File -->
  <link href="css/style.css" rel="stylesheet">

  <!-- =======================================================
    Template Name: Coming
    Template URL: https://templatemag.com/coming-bootstrap-under-construction-template/
    Author: TemplateMag.com
    License: https://templatemag.com/license/
  ======================================================= -->
</head>

<body>

  <div id="h">
    <div class="container">
      <div class="row">
        <div class="col-md-8 col-md-offset-2">
          <h1>GET a <bold>VIRTUAL TICKET!</bold></h1>
          <h5>仮想ライブのチケット発行サイトです。あくまでも仮想チケットです。</h5>
          <div class="col-md-6 col-md-offset-3">
            <form role="form" action="register.php" method="post" enctype="plain">
              <input type="email" name="email" class="subscribe-input" placeholder="Enter your e-mail address..." required>
              <button class='btn btn-conf btn-go' type="submit">Get Access Now</button>
            </form>
          </div>
        </div>
      </div>
      <!--/row-->
    </div>
    <!--/container-->
  </div>
  <!--/H-->
  <div id="contact">
    <div class="container">
      <div class="row">
        <div class="col-md-8 col-md-offset-2">
      	  <h2>New ROOM</h2>
          <form class="contact-form php-mail-form" role="form" action="contactform/contactform.php" method="POST">

            <div class="form-group">
              <input type="name" name="room_name" class="form-control" id="contact-name" placeholder="Room Name" data-rule="minlen:4" data-msg="Please enter at least 4 chars" >
              <div class="validate"></div>
              ROOM名がチケットタイトルとなります。<br>
            </div>
            <div class="form-group">
              背景色<br>
                            <label><input type="radio" name="bg_color" value="1" style="float:left;" required checked><span style="color:#ffffff;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	                <label><input type="radio" name="bg_color" value="2" style="float:left;" ><span style="color:#333333;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	                <label><input type="radio" name="bg_color" value="3" style="float:left;" ><span style="color:#ff0000;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	                <label><input type="radio" name="bg_color" value="4" style="float:left;" ><span style="color:#ff0080;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	                <label><input type="radio" name="bg_color" value="5" style="float:left;" ><span style="color:#ff00ff;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	                <label><input type="radio" name="bg_color" value="6" style="float:left;" ><span style="color:#8000ff;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	                <label><input type="radio" name="bg_color" value="7" style="float:left;" ><span style="color:#0000ff;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	                <label><input type="radio" name="bg_color" value="8" style="float:left;" ><span style="color:#0080ff;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	                <label><input type="radio" name="bg_color" value="9" style="float:left;" ><span style="color:#00ffff;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	                <label><input type="radio" name="bg_color" value="10" style="float:left;" ><span style="color:#00ff80;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	                <label><input type="radio" name="bg_color" value="11" style="float:left;" ><span style="color:#00ff00;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	                <label><input type="radio" name="bg_color" value="12" style="float:left;" ><span style="color:#80ff00;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	                <label><input type="radio" name="bg_color" value="13" style="float:left;" ><span style="color:#ffff00;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	                <label><input type="radio" name="bg_color" value="14" style="float:left;" ><span style="color:#ff8000;float:left;font-size:200%;margin-right: 10px;">■</span></label>
          	              </div>
            <div class="form-group">
              ロゴ<br>
              <input type="file" name="logo">
              ※横360px×縦100px ぐらいの画像をアップください。<br>
              横幅に合わせて縮小されます。<br>
            </div>
            <div class="form-group">
              フォント<br>
                            <label><input type="radio" name="title_font" value="1" style="float:left;" required checked><img src="/fontsample/?code=1"></label>
                            <label><input type="radio" name="title_font" value="2" style="float:left;" ><img src="/fontsample/?code=2"></label>
                            <label><input type="radio" name="title_font" value="3" style="float:left;" ><img src="/fontsample/?code=3"></label>
                            <label><input type="radio" name="title_font" value="4" style="float:left;" ><img src="/fontsample/?code=4"></label>
                            <label><input type="radio" name="title_font" value="5" style="float:left;" ><img src="/fontsample/?code=5"></label>
                            <label><input type="radio" name="title_font" value="6" style="float:left;" ><img src="/fontsample/?code=6"></label>
                          </div>
            <div class="form-group">
              フォント色<br>
                            <label><input type="radio" name="f_color" value="1" style="float:left;" required checked><span style="color:#ffffff;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                            <label><input type="radio" name="f_color" value="2" style="float:left;" ><span style="color:#333333;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                            <label><input type="radio" name="f_color" value="3" style="float:left;" ><span style="color:#ff0000;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                            <label><input type="radio" name="f_color" value="4" style="float:left;" ><span style="color:#ff0080;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                            <label><input type="radio" name="f_color" value="5" style="float:left;" ><span style="color:#ff00ff;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                            <label><input type="radio" name="f_color" value="6" style="float:left;" ><span style="color:#8000ff;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                            <label><input type="radio" name="f_color" value="7" style="float:left;" ><span style="color:#0000ff;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                            <label><input type="radio" name="f_color" value="8" style="float:left;" ><span style="color:#0080ff;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                            <label><input type="radio" name="f_color" value="9" style="float:left;" ><span style="color:#00ffff;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                            <label><input type="radio" name="f_color" value="10" style="float:left;" ><span style="color:#00ff80;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                            <label><input type="radio" name="f_color" value="11" style="float:left;" ><span style="color:#00ff00;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                            <label><input type="radio" name="f_color" value="12" style="float:left;" ><span style="color:#80ff00;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                            <label><input type="radio" name="f_color" value="13" style="float:left;" ><span style="color:#ffff00;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                            <label><input type="radio" name="f_color" value="14" style="float:left;" ><span style="color:#ff8000;float:left;font-size:200%;margin-right: 10px;">■</span></label>
                          </div>
            <div class="form-group">
              注意事項<br>
              <textarea style="width:100%" rows="5" name="note" class="form-control" placeholder="注意事項があれば３行ぐらいで（40文字ぐらいで改行してください）"></textarea>
            </div>

            <div class="form-group">
              <input type="email" name="email" class="form-control" id="contact-email" placeholder="Your Email" data-rule="email" data-msg="Please enter a valid email">
              <div class="validate"></div>
            </div>
            <div class="form-group">
              <input type="text" name="password" class="form-control" id="contact-password" placeholder="PassWord" data-rule="minlen:6" data-msg="Please enter at least 6 chars of PassWord">
              <div class="validate"></div>
            </div>


            <div class="loading"></div>
            <div class="error-message"></div>
            <div class="sent-message">Your message has been sent. Thank you!</div>

            <div class="form-send">
              <button type="submit" class="btn btn-large">Make Room</button>
            </div>

          </form>
        </div>
      </div>
    </div>
  </div>


  <div id="copyrights">
    <div class="container">
      <p>
        &copy; Copyrights <strong>Coming</strong>. All Rights Reserved
      </p>
      <div class="credits">
        <!--
          You are NOT allowed to delete the credit link to TemplateMag with free version.
          You can delete the credit link only if you bought the pro version.
          Buy the pro version with working PHP/AJAX contact form: https://templatemag.com/coming-bootstrap-under-construction-template/
          Licensing information: https://templatemag.com/license/
        -->
        Created with Coming template by <a href="https://templatemag.com/">TemplateMag</a>
      </div>
    </div>
  </div>
  <!-- JavaScript Libraries -->
  <script src="lib/jquery/jquery.min.js"></script>
  <script src="lib/jquery/jquery.plugin.min.js"></script>
  <script src="lib/bootstrap/js/bootstrap.min.js"></script>
  <script src="lib/php-mail-form/validate.js"></script>
  <script src="lib/countdown/countdown.min.js"></script>

  <!-- Template Main Javascript File -->
  <script src="js/main.js"></script>

</body>
</html>