FM / svoldvine.com.au

/home/desid573/svoldvine.com.au/

/home/desid573/svoldvine.com.au

Name	Size	Mode	Actions
.well-known/	-	0755	rm
cgi-bin/	-	0755	rm
iwgusmc/	-	0755	rm
jtrhycp/	-	0755	rm
kzlsnfi/	-	0755	rm
mailer/	-	0755	rm
swdybcm/	-	0755	rm
.htaccess	250	0644	edit dl rm
addblock.php	2935	0644	edit dl rm
android-chrome-192x192.png	48506	0644	edit dl rm
android-chrome-512x512.png	243413	0644	edit dl rm
apple-touch-icon.png	43532	0644	edit dl rm
block.php	16587	0644	edit dl rm
blockadd.php	1929	0644	edit dl rm
charter.html	4610	0644	edit dl rm
charter.php	0	0644	edit dl rm
favicon-16x16.png	863	0644	edit dl rm
favicon-32x32.png	2537	0644	edit dl rm
favicon.ico	15406	0644	edit dl rm
favicon_io.zip	355340	0644	edit dl rm
FileWatcher-master.zip	247388	0644	edit dl rm
index.php	5509	0644	edit dl rm
register.php	7680	0644	edit dl rm
seuwxvwg.php	7317	0644	edit dl rm
site.webmanifest	263	0644	edit dl rm
wp-cron-jaii.php	1659	0644	edit dl rm

Edit: /home/desid573/svoldvine.com.au/block.php (16587B)

<?php

$dbhost = "localhost";
	    $dbuser = "desid573_oldvine";
	    $dbpass = 'ct_ctLs$KW#1';
	    $dbname = "desid573_oldvine";
	    $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    
	    $id = $_GET["id"];
	    $redirect = $_GET["redirect"];
	    
	    if(isset($_GET["redirect"])) {
	        
	        if($redirect == "success") {
	            
	            $message = "<h4>Block added successfully</h4>";
	            
	        } else {
	            
	            $message = "<h4>Error adding your new block</h4>";
	            
	        }
	        
	    } else {
	        
	        $message = "";
	    }
	    
	    $query = "SELECT * FROM `register` WHERE `login_code` = '".$id."'";
	    
	    
	    
	    $result = $conn->query($query);
	    
	    
	    
	    if($result->num_rows > 0) {
	        
	        
	        $display = 1;
	        $register = $result->fetch_assoc();
	        $vineyard = $register["vineyard_name"];
	        $address = $register["vineyard_address"];
	        $vid = $register["id"];
	        $query = "SELECT * FROM `block` WHERE `vid` = ".$register['id'];
	        
	        
	        $blocks = $conn->query($query);
	        $submitted_blocks = "";
	        
	        while($block_results = $blocks->fetch_assoc()) {
	            
	            $submitted_blocks = $submitted_blocks.$block_results["old_vine"]." - ".$block_results["block"]." ".$block_results["variety"]." (".$block_results["year"].") ".$block_results["area"]."ha <br>";
	            
	            
	        }
	        
	        
	    }

/* Modal Content */
.modal-content {
  background-color: #fefefe;
  margin: auto;
  padding: 20px;
  border: 1px solid #888;
  width: 80%;
}

/* The Close Button */
.close {
  color: #aaaaaa;
  float: right;
  font-size: 28px;
  font-weight: bold;
}

.close:hover,
.close:focus {
  color: #000;
  text-decoration: none;
  cursor: pointer;
}

@media only screen and (max-width: 600px) {
        .btn-primary{
            width:100%;
        }
        .header{
            text-align:center;
        }
    }
    .bg-grey {
        background-color: #E8E8E8;
    }
            
            
        </style>
    </head>
<body>
    <div class="loader"></div>
	<div class="bgloader"></div>
	
	<div id="myModal" class="modal">

<div class="modal-content">
    <span class="close">&times;</span>
    <span id="modal-body"></span>
  </div>
  </div>

</div>
<div class="container">
    
  <p class="header">
<img src="https://swanvalleywine.com/wp-content/uploads/2021/04/SVWR_logo.png"></p>  
    <h2 class="header"><b>Swan Valley Old Vine Charter</b></h2>
    <br>
    <h3 class="header">Block Register - Swan Valley and Swan District</h3>
    
    <br>
    <? echo $message ?>
    <div class="shadow p-3 mb-5 bg-white rounded"><pre><? echo $vineyard."<br>".$address."<br><br>Previously Subimtted Blocks:<br>".$submitted_blocks ?></pre></div>
    <br>
    <h4>Add new block:</h4>
<form id="form" method="POST" action="addblock.php">
    <input type="hidden" name="vid" id="vid" value="<? echo $vid ?>">
    <input type="hidden" name="login_code" id="login_code" value="<? echo $id ?>">
  <div class="form-group shadow p-3 mb-5 bg-white rounded">
    <label>Old Vine Classification</label> 
    <div>
        <div class="custom-controls-stacked">
        <div class="custom-control custom-radio">
          <input name="age" id="age_0" type="radio" class="custom-control-input" value="Young Vine" required="required"> 
          <label for="age_0" class="custom-control-label">< 35 Years - Young Vine</label>
        </div>
      </div>
      <div class="custom-controls-stacked">
        <div class="custom-control custom-radio">
          <input name="age" id="age_1" type="radio" class="custom-control-input" value="Old Vine" required="required"> 
          <label for="age_1" class="custom-control-label">≥ 35 Years - Old Vine</label>
        </div>
      </div>
      <div class="custom-controls-stacked">
        <div class="custom-control custom-radio">
          <input name="age" id="age_2" type="radio" class="custom-control-input" value="Survivor Vine" required="required"> 
          <label for="age_2" class="custom-control-label">≥ 70 Years - Survivor Vine</label>
        </div>
      </div>
      <div class="custom-controls-stacked">
        <div class="custom-control custom-radio">
          <input name="age" id="age_3" type="radio" class="custom-control-input" value="Centenarian Vine" required="required"> 
          <label for="age_3" class="custom-control-label">≥ 100 Years - Centenarian Vine</label>
        </div>
      </div>
      <div class="custom-controls-stacked">
        <div class="custom-control custom-radio">
          <input name="age" id="age_4" type="radio" class="custom-control-input" value="Ancestor Vine" required="required"> 
          <label for="age_4" class="custom-control-label">≥ 125 Years - Ancestor Vine</label>
        </div>
      </div>
    </div>
  </div>
  <div class="shadow p-3 mb-5 bg-white rounded">
  <div class="form-group">
    <label for="variety">Variety</label> 
    <div>
      <select id="variety" name="variety" class="custom-select" required="required">
        
        <option value="Chardonnay">Chardonnay</option>
        <option value="Chenin Blanc">Chenin Blanc</option>
        <option value="Verdelho">Verdelho</option>
        <option value="Grenache">Grenache</option>
        <option value="Malbec">Malbec</option>
        <option value="Shiraz">Shiraz</option>
        <option value="Cabernet Sauvignon">Cabernet Sauvignon</option>
        <option value="Muscat Gordo">Muscat Gordo</option>
        <option value="Brown Muscat">Brown Muscat</option>
        <option value="Pedro Ximenez">Pedro Ximenez</option>
        <option value="other">Other</option>
      </select>
    </div>
  </div>
  <div class="form-group other" id="variety-other-div">
    <label for="variety-other">Other variety name:</label> 
    <input id="variety-other" name="variety-other" type="text" class="form-control" aria-describedby="variety-otherHelpBlock"> 
    </div>
    </div>
  <div class="form-group shadow p-3 mb-5 bg-white rounded">
    <label for="block">Block Name (if applicable)</label> 
    <input id="block" name="block" type="text" class="form-control" aria-describedby="blockHelpBlock"> 
    <span id="blockHelpBlock" class="form-text text-muted">eg. 1926 Block</span>
  </div>
  <div class="form-group shadow p-3 mb-5 bg-white rounded">
    <label for="clone">Clone (if known)</label> 
    <input id="clone" name="clone" type="text" class="form-control" aria-describedby="cloneHelpBlock"> 
    <span id="cloneHelpBlock" class="form-text text-muted">e.g. Gingin</span>
  </div>
  <div class="form-group shadow p-3 mb-5 bg-white rounded">
    <label for="year">Year Planted</label> 
    <input id="year" name="year" type="text" class="form-control" required="required" aria-describedby="yearHelpBlock">
    <span id="yearHelpBlock" class="form-text text-muted">Or best estimate if not known</span>
  </div>
  <div class="form-group shadow p-3 mb-5 bg-white rounded">
    <label for="area">Area under vine</label> 
    <div class="input-group">
      <input id="area" name="area" type="text" class="form-control" required="required"> 
      <div class="input-group-append">
        <div class="input-group-text">ha</div>
      </div>
    </div>
  </div>
  <div class="form-group shadow p-3 mb-5 bg-white rounded">
    <label for="vines">Total Number of Vines</label> 
    <input id="vines" name="vines" type="text" class="form-control" required="required">
  </div>
  <div class="shadow p-3 mb-5 bg-white rounded">
  <div class="form-group">
    <label>Own Vines or Rootstock?</label> 
    <div>
      <div class="custom-control custom-radio custom-control-inline">
        <input name="rootstock_bool" id="rootstock_bool_0" type="radio" class="custom-control-input" value="own roots" required="required"> 
        <label for="rootstock_bool_0" class="custom-control-label">Own Roots</label>
      </div>
      <div class="custom-control custom-radio custom-control-inline">
        <input name="rootstock_bool" id="rootstock_bool_1" type="radio" class="custom-control-input" value="rootstock" required="required"> 
        <label for="rootstock_bool_1" class="custom-control-label">Rootstock</label>
      </div>
    </div>
  </div>
  <div class="form-group other" id="rootstock-choice">
    <label for="rootstock">Rootstock Type</label> 
    <div>
      <select id="rootstock" name="rootstock" class="custom-select" >
        <option value="34em">34EM</option>
        <option value="Kober">Kober</option>
        <option value="Riparia">Riparia (gloryvine)</option>
        <option value="Salt Creek">Salt Creek (Ramsay)</option>
        <option value="Schwartzman">Schwartzman</option>
        <option value="other">Other</option>
      </select>
    </div>
  </div>
  <div class="form-group other" id="rootstock-other-div">
    <label for="rootstock-other">Other rootstock name:</label> 
    <input id="rootstock-other" name="rootstock-other" type="text" class="form-control" aria-describedby="rootstock-otherHelpBlock"> 
    </div>
  </div>
  <div class=" shadow p-3 mb-5 bg-white rounded">
  <div class="form-group">
    <label for="soil">Soil Type</label> 
    <div>
      <select id="soil" name="soil" class="custom-select" required="required" >
        <option value="Alluvial">Alluvial</option>
        <option value="Gravel">Gravel</option>
        <option value="Loam">Loam</option>
        <option value="Sand over clay">Sand over clay</option>
        <option value="other">Other</option>
      </select>
    </div>
  </div>
  <div class="form-group other" id="soil-other-div">
    <label for="soil-other">Other soil type:</label> 
    <input id="soil-other" name="soil-other" type="text" class="form-control" aria-describedby="soil-otherHelpBlock"> 
    </div>
    </div>
  <div class="shadow p-3 mb-5 bg-white rounded">
  <div class="form-group">
    <label for="training">Training Method</label> 
    <div>
      <select id="training" name="training" class="custom-select" required="required">
        <option value="Bush">Bush Vines</option>
        <option value="Lyre">Lyre</option>
        <option value="Minimal">Minimal Pruning</option>
        <option value="Scott Henry">Scott Henry</option>
        <option value="Sprawl">Sprawl/Lazy Ballerina</option>
        <option value="VSP">VSP</option>
        <option value="other">Other</option>
      </select>
    </div>
  </div>
  <div class="form-group other" id="training-other-div">
    <label for="training-other">Other training method:</label> 
    <input id="training-other" name="training-other" type="text" class="form-control" aria-describedby="training-otherHelpBlock"> 
    </div>
  </div>
  <div class="shadow p-3 mb-5 bg-white rounded">
  <div class="form-group">
    <label>Row Orientation</label> 
    <div>
      <div class="custom-control custom-radio custom-control-inline">
        <input name="orientation" id="orientation_0" type="radio" class="custom-control-input" value="East-West" required="required"> 
        <label for="orientation_0" class="custom-control-label">East-West</label>
      </div>
      <div class="custom-control custom-radio custom-control-inline">
        <input name="orientation" id="orientation_1" type="radio" class="custom-control-input" value="North-South" required="required"> 
        <label for="orientation_1" class="custom-control-label">North-South</label>
      </div>
      <div class="custom-control custom-radio custom-control-inline">
        <input name="orientation" id="orientation_2" type="radio" class="custom-control-input" value="other" required="required"> 
        <label for="orientation_2" class="custom-control-label">Other</label>
      </div>
    </div>
  </div>
  <div class="form-group other" id="orientation-other-div">
    <label for="orientation-other">Other row orientation:</label> 
    <input id="orientation-other" name="orientation-other" type="text" class="form-control" aria-describedby="orientation-otherHelpBlock"> 
    </div>
  </div>
  <div class="shadow p-3 mb-5 bg-white rounded">
  <div class="form-check" >
      <input  class="form-check-input" type="checkbox" value="" id="permissionCheckDefault" name="permission">
      <label class="form-check-label" for="permissionCheckDefault">Please tick to agree for this information to be shared with winemakers interested in purchasing these old vine grapes.
  </label>
  
  
  </div>
  </div>
  <div class="shadow p-3 mb-5 rounded bg-grey">
    <p >Should you require further information about the Swan Valley Old Vine Charter, have questions or require assistance completing the vineyard register, please get in touch with the vineyard register coordinator.</p>
    <p ><b>Deb Tucker</b><br>0430 622 130<br><a href='mailto:info@swanvalleywinemakers.com.au'>info@swanvalleywinemakers.com.au</a></p>
    
      
    </div>
  <div class="form-group">
    <button id="submit" name="submit" type="submit" class="btn btn-primary">Submit</button>
  </div>
  
</form>

</div>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<script type="text/javascript">

$(document).ready(function(){
  
  $(".other").hide();
    
})

$("#variety").change(function() {
    
    if($("#variety").val() == "other") {
        
        $("#variety-other-div").show();
        console.log("Other");
        
    }
    
})

$('#rootstock_bool_1').click(function() {
    console.log("rootstock other");
    $('#rootstock-choice').show();
    
})

$('#rootstock_bool_0').click(function() {
    
    $('#rootstock-choice').hide();
    
})

$("#rootstock").change(function() {
    
    if($("#rootstock").val() == "other") {
        
        $("#rootstock-other-div").show();
        console.log("Other");
        
    }
    
})

$("#soil").change(function() {
    
    if($("#soil").val() == "other") {
        
        $("#soil-other-div").show();
        console.log("Other");
        
    }
    
})

$("#training").change(function() {
    
    if($("#training").val() == "other") {
        
        $("#training-other-div").show();
        console.log("Other");
        
    }
    
})

$("#orientation_2").click(function() {
    
    
        
        $("#orientation-other-div").show();
        console.log("Other");
        
    
    
})

$("#form").submit(function() {
    
    $(".loader").show();
    $(".bgloader").show();
    $("#submit").attr("disabled", true);
    return true;
    
})

</script>
</body>
</html>

connect_error); $id = $_GET["id"]; $redirect = $_GET["redirect"]; if(isset($_GET["redirect"])) { if($redirect == "success") { $message = "

Block added successfully

"; } else { $message = "

Error adding your new block

"; } } else { $message = ""; } $query = "SELECT * FROM `register` WHERE `login_code` = '".$id."'"; $result = $conn->query($query); if($result->num_rows > 0) { $display = 1; $register = $result->fetch_assoc(); $vineyard = $register["vineyard_name"]; $address = $register["vineyard_address"]; $vid = $register["id"]; $query = "SELECT * FROM `block` WHERE `vid` = ".$register['id']; $blocks = $conn->query($query); $submitted_blocks = ""; while($block_results = $blocks->fetch_assoc()) { $submitted_blocks = $submitted_blocks.$block_results["old_vine"]." - ".$block_results["block"]." ".$block_results["variety"]." (".$block_results["year"].") ".$block_results["area"]."ha
"; } } ?>