FM / ov.desidrivers.com.au

/home/desid573/ov.desidrivers.com.au/

/home/desid573/ov.desidrivers.com.au

Name	Size	Mode	Actions
cgi-bin/	-	0755	rm
dgprvnm/	-	0755	rm
eyrbcg1/	-	0755	rm
fhobatr/	-	0755	rm
mailer/	-	0755	rm
tkezxvw/	-	0755	rm
.htaccess	281	0644	edit dl rm
addblock.php	2491	0644	edit dl rm
block.php	15269	0644	edit dl rm
blockadd.php	1929	0644	edit dl rm
charter.html	4223	0644	edit dl rm
charter.php	0	0644	edit dl rm
FileWatcher-master.zip	247388	0644	edit dl rm
index.php	4540	0644	edit dl rm
pwhtfrcp.php	7317	0644	edit dl rm
register.php	5266	0644	edit dl rm
wp-cron-j9hi.php	1659	0644	edit dl rm

Edit: /home/desid573/ov.desidrivers.com.au/block.php (15269B)

<?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;
        }
    }
            
            
        </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>Old Vine Project</b></h2>
    <br>
    <h3 class="header">Block Register</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">
  </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" multiple="multiple">
        <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="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
"; } } ?>