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/addblock.php (2935B)

<?php
require("../public_html/google/google-api-php-client-2.2.1/vineSheetAdd.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);
	    
	    
	    $variety = $_POST["variety"];
	    if($variety == "other") {
	        $variety = $conn->real_escape_string($_POST["variety-other"]);
	    }
	    $rootstock_bool = $_POST["rootstock_bool"];
	    if($rootstock_bool == "rootstock") {
	        
	        $rootstock = $_POST["rootstock"];
	        if($rootstock == "other") {
	            $rootstock = $conn->real_escape_string($_POST["rootstock-other"]);
	        }
	        
	    } else {
	        
	        $rootstock = "";
	    }
	    $soil = $_POST["soil"];
	    if($soil == "other") {
	        
	        $soil = $conn->real_escape_string($_POST["soil-other"]);
	        
	    }
	    $training = $_POST["training"];
	    if($training == "other") {
	        $training = $conn->real_escape_string($_POST["training-other"]);
	    }
	    $orientation = $_POST["orientation"];
	    if($orientation == "other") {
	        $orientation = $conn->real_escape_string($_POST["orientation-other"]);
	    }
	    if(isset($_POST["permission"])) {
	            $permission = "yes";
	        } else {
	            $permission = "no";
	        }
	    
	    
	    $query = "INSERT INTO `block`(`id`, `vid`, `old_vine`, `variety`, `year`, `block`, `clone`, `no_vines`, `area`, `rootstock_bool`, `rootstock`, `soil_type`, `training`, `orientation`, `permission`) VALUES (NULL,".$_POST["vid"].",'".$_POST["age"]."','".$variety."','".$conn->real_escape_string($_POST["year"])."','".$conn->real_escape_string($_POST["block"])."','".$conn->real_escape_string($_POST["clone"])."','".$conn->real_escape_string($_POST["vines"])."','".$conn->real_escape_string($_POST["area"])."','".$rootstock_bool."','".$rootstock."','".$soil."','".$training."','".$orientation."','".$permission."')";

$result = $conn->query($query);
	    
	    if(!$result) {
	        
	        error_log("error adding block ".$conn->error);
	        
	        header('Location: block.php?redirect=error&id='.$_POST["login_code"]);
            exit;
	        
	    } else {
	        
	        $query = "SELECT * FROM `register` WHERE `id` = ".$_POST["vid"];
	        
	        $result = $conn->query($query);
	        
	        
	        
	        $array = $result->fetch_assoc();
	        
	        $vineyard = $array["vineyard_name"];
	        
	        addToSheet($vineyard, $_POST["age"], $_POST["block"], $variety, $_POST["clone"], $_POST["year"], $_POST["vines"], $_POST["area"], $rootstock_bool, $rootstock, $soil, $training, $orientation, $permission);
	        
	     
	         header('Location: block.php?redirect=success&id='.$_POST["login_code"]);
            exit;
	        
	    }

connect_error); $variety = $_POST["variety"]; if($variety == "other") { $variety = $conn->real_escape_string($_POST["variety-other"]); } $rootstock_bool = $_POST["rootstock_bool"]; if($rootstock_bool == "rootstock") { $rootstock = $_POST["rootstock"]; if($rootstock == "other") { $rootstock = $conn->real_escape_string($_POST["rootstock-other"]); } } else { $rootstock = ""; } $soil = $_POST["soil"]; if($soil == "other") { $soil = $conn->real_escape_string($_POST["soil-other"]); } $training = $_POST["training"]; if($training == "other") { $training = $conn->real_escape_string($_POST["training-other"]); } $orientation = $_POST["orientation"]; if($orientation == "other") { $orientation = $conn->real_escape_string($_POST["orientation-other"]); } if(isset($_POST["permission"])) { $permission = "yes"; } else { $permission = "no"; } $query = "INSERT INTO `block`(`id`, `vid`, `old_vine`, `variety`, `year`, `block`, `clone`, `no_vines`, `area`, `rootstock_bool`, `rootstock`, `soil_type`, `training`, `orientation`, `permission`) VALUES (NULL,".$_POST["vid"].",'".$_POST["age"]."','".$variety."','".$conn->real_escape_string($_POST["year"])."','".$conn->real_escape_string($_POST["block"])."','".$conn->real_escape_string($_POST["clone"])."','".$conn->real_escape_string($_POST["vines"])."','".$conn->real_escape_string($_POST["area"])."','".$rootstock_bool."','".$rootstock."','".$soil."','".$training."','".$orientation."','".$permission."')"; $result = $conn->query($query); if(!$result) { error_log("error adding block ".$conn->error); header('Location: block.php?redirect=error&id='.$_POST["login_code"]); exit; } else { $query = "SELECT * FROM `register` WHERE `id` = ".$_POST["vid"]; $result = $conn->query($query); $array = $result->fetch_assoc(); $vineyard = $array["vineyard_name"]; addToSheet($vineyard, $_POST["age"], $_POST["block"], $variety, $_POST["clone"], $_POST["year"], $_POST["vines"], $_POST["area"], $rootstock_bool, $rootstock, $soil, $training, $orientation, $permission); header('Location: block.php?redirect=success&id='.$_POST["login_code"]); exit; }