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/register.php (7680B)

<?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);
	    
	    $email = $_POST["contact_email"];
	    
	    $query = "SELECT * FROM `register` WHERE `contact_email` = '".$email."'";
	    
	    $result = $conn->query($query);
	    
	    if($result->num_rows > 0) {
	        
	        //email already used
	        $display = 1;
	        $register = $result->fetch_assoc();
	        $random = $register["login_code"];
	        
	    } else {
	        
	        $rdm_string = $_POST["contact_email"]."grape";
	        $random = md5($rdm_string);
	        $vineyard = $conn->real_escape_string($_POST["vineyard"]);
	        $owner = $conn->real_escape_string($_POST["owner"]);
	        $address = $conn->real_escape_string($_POST["address"]);
	        $suburb = $conn->real_escape_string($_POST["suburb"]);
	        $contact_name = $conn->real_escape_string($_POST["contact_name"]);
	        $contact_email = $conn->real_escape_string($_POST["contact_email"]);
	        $contact_phone = $conn->real_escape_string($_POST["contact_phone"]);
	        $contact_email = $conn->real_escape_string($_POST["contact_mobile"]);
	        $bought = $conn->real_escape_string($_POST["bought"]);
	        $purchased = $conn->real_escape_string($_POST["purchase"]);
	        
	        
	             
	        $query = "INSERT INTO `register`(`id`, `vineyard_name`, `vineyard_owner`, `vineyard_address`, `vineyard_suburb`, `contact_name`, `contact_email`, `contact_phone`, `contact_mobile`, `bought`, `purchase`, `login_code`) VALUES (NULL,'".$vineyard."','".$owner."','".$address."','".$suburb."','".$contact_name."','".$contact_email."','".$contact_phone."','".$contact_email."','".$bought."','".$purchased."','".$random."')";   
	        
	        $result = $conn->query($query);
	        
	   
	        
	        if(!$result) {
	            
	            $display = 2;
	            
	        } else {
	            
	            addToRegister($_POST["vineyard"], $_POST["owner"], $_POST["address"], $_POST['suburb'], $_POST["contact_name"], $_POST["contact_email"], $_POST["contact_phone"], $_POST["contact_mobile"], $_POST["bought"], $_POST["purchase"]);
	            
	            $display = 3;
	            
	        }
	        
	        if($display == 1 OR $display == 3) {
	            
	            require("mailer/PHPMailer_5.2.0/class.phpmailer.php");

$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Mailer = 'smtp';
$mail->SMTPAuth = true;
$mail->Host = 'hp275.hostpapa.com'; 
$mail->Port = 465;
$mail->SMTPSecure = 'ssl';

$mail->Username = "noreply@svoldvine.com.au";
$mail->Password = "0DKyVaV]AhUs";

$mail->IsHTML(true); // if you are going to send HTML formatted emails

$mail->From = "noreply@svoldvine.com.au";
$mail->FromName = "Old Vine Project";

$mail->addAddress($_POST["contact_email"]);

$mail->Subject = "Registration with the Swan Valley Old Vine Project";
$mail->Body = "<p style='font-family: verdana; font-size: 14;'>Hi ".$_POST["contact_name"]."</p>
<p style='font-family: verdana; font-size: 14;'>Thanks for registering ".$_POST["vineyard"]." with the Old Vine Project.</p>
<p style='font-family: verdana; font-size: 14;'>Any time you would like to add new blocks to the register please click the button below</p>
<p style='font-family: verdana; font-size: 14;'><table align='left' cellspacing='0' cellpadding='0' width='100%'>
   <tr>
     <td align='left' style='padding: 5px;'>
       <table border='0' class='mobile-button' cellspacing='0' cellpadding='0'>
         <tr>
           <td align='left' bgcolor='#2b3138' style='background-color: #2b3138; margin: auto; max-width: 600px; -webkit-border-radius: 5px; -moz-border-radius: 5px; border-radius: 5px; padding: 15px 20px; ' width='100%'>
           <a href='https://ov.desidrivers.com.au/block.php?id=".$random."' target='_blank' style='16px; font-family: Verdana, Geneva, sans-serif; color: #ffffff; font-weight:normal; text-align:center; background-color: #2b3138; text-decoration: none; border: none; -webkit-border-radius: 5px; -moz-border-radius: 5px; border-radius: 5px; display: inline-block;'>
                   <span style='font-size: 16px; font-family: Verdana, Geneva, sans-serif; color: #ffffff; font-weight:normal; line-height:1.5em; text-align:center;'>Add Old Vine Blocks</span>
             </a>
             
           </td>
         </tr>
       </table>
     </td>
   </tr>
 </table></p>
    <p style='font-family: verdana; font-size: 14;'>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 style='font-family: verdana; font-size: 14;'><b>Deb Tucker</b><br>0430 622 130<br><a href='mailto:info@swanvalleywinemakers.com.au'>info@swanvalleywinemakers.com.au</a></p>
    ";

if(!$mail->Send()) {
   error_log("Message was not sent <br />PHPMailer Error: " . $mail->ErrorInfo);
} else {
    ;
}
	            
	            
	        }
	        
	    }

<html>
    <head>
        <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
        <link rel="apple-touch-icon" sizes="180x180" href="/apple-touch-icon.png">
<link rel="icon" type="image/png" sizes="32x32" href="/favicon-32x32.png">
<link rel="icon" type="image/png" sizes="16x16" href="/favicon-16x16.png">
<link rel="manifest" href="/site.webmanifest">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css"> 
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
<style>
    body {
        font-family: Verdana;
    }
    .btn-primary {
        background-color: #000000;
        border: 0px;
    }
    .bg-grey {
        background-color: #E8E8E8;
    }
    
</style>
</head>
<body>
<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">Vineyard Register - Swan Valley and Swan District</h3>
    <br>
    
    <?php
    
    if($display == 1) {
    
    echo "<p>This email has already been used to register for the Old Vine Project. Your registration email has been re-sent so you can use the link in the email to add new blocks</p>";
    
    
    
    } else if($display == 2) {
        
        echo "<p>Error adding to register<br><br>".$conn->error;
        
    } else {
        
        echo "<p>Thank you for registering for the Old Vine Project. Please click the button below to begin adding blocks to the register.<br><a href='block.php?id=".$random."'><br><button class='btn btn-primary'>Click Here</button></a></p>";
        
        
        
    }
    
    ?>
    <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>
</body>
</html>

connect_error); $email = $_POST["contact_email"]; $query = "SELECT * FROM `register` WHERE `contact_email` = '".$email."'"; $result = $conn->query($query); if($result->num_rows > 0) { //email already used $display = 1; $register = $result->fetch_assoc(); $random = $register["login_code"]; } else { $rdm_string = $_POST["contact_email"]."grape"; $random = md5($rdm_string); $vineyard = $conn->real_escape_string($_POST["vineyard"]); $owner = $conn->real_escape_string($_POST["owner"]); $address = $conn->real_escape_string($_POST["address"]); $suburb = $conn->real_escape_string($_POST["suburb"]); $contact_name = $conn->real_escape_string($_POST["contact_name"]); $contact_email = $conn->real_escape_string($_POST["contact_email"]); $contact_phone = $conn->real_escape_string($_POST["contact_phone"]); $contact_email = $conn->real_escape_string($_POST["contact_mobile"]); $bought = $conn->real_escape_string($_POST["bought"]); $purchased = $conn->real_escape_string($_POST["purchase"]); $query = "INSERT INTO `register`(`id`, `vineyard_name`, `vineyard_owner`, `vineyard_address`, `vineyard_suburb`, `contact_name`, `contact_email`, `contact_phone`, `contact_mobile`, `bought`, `purchase`, `login_code`) VALUES (NULL,'".$vineyard."','".$owner."','".$address."','".$suburb."','".$contact_name."','".$contact_email."','".$contact_phone."','".$contact_email."','".$bought."','".$purchased."','".$random."')"; $result = $conn->query($query); if(!$result) { $display = 2; } else { addToRegister($_POST["vineyard"], $_POST["owner"], $_POST["address"], $_POST['suburb'], $_POST["contact_name"], $_POST["contact_email"], $_POST["contact_phone"], $_POST["contact_mobile"], $_POST["bought"], $_POST["purchase"]); $display = 3; } if($display == 1 OR $display == 3) { require("mailer/PHPMailer_5.2.0/class.phpmailer.php"); $mail = new PHPMailer(); $mail->IsSMTP(); $mail->Mailer = 'smtp'; $mail->SMTPAuth = true; $mail->Host = 'hp275.hostpapa.com'; $mail->Port = 465; $mail->SMTPSecure = 'ssl'; $mail->Username = "noreply@svoldvine.com.au"; $mail->Password = "0DKyVaV]AhUs"; $mail->IsHTML(true); // if you are going to send HTML formatted emails $mail->From = "noreply@svoldvine.com.au"; $mail->FromName = "Old Vine Project"; $mail->addAddress($_POST["contact_email"]); $mail->Subject = "Registration with the Swan Valley Old Vine Project"; $mail->Body = "

Hi ".$_POST["contact_name"]."

Thanks for registering ".$_POST["vineyard"]." with the Old Vine Project.

Any time you would like to add new blocks to the register please click the button below

Add Old Vine Blocks

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.

Deb Tucker
0430 622 130
info@swanvalleywinemakers.com.au

"; if(!$mail->Send()) { error_log("Message was not sent
PHPMailer Error: " . $mail->ErrorInfo); } else { ; } } } ?>

This email has already been used to register for the Old Vine Project. Your registration email has been re-sent so you can use the link in the email to add new blocks

"; } else if($display == 2) { echo "

Error adding to register

".$conn->error; } else { echo "

Thank you for registering for the Old Vine Project. Please click the button below to begin adding blocks to the register.

"; } ?>

Deb Tucker
0430 622 130
info@swanvalleywinemakers.com.au