FM / svoldvine.com.au

/home/desid573/svoldvine.com.au/

/home/desid573/svoldvine.com.au

Name	Size	Mode	Actions
.well-known/	-	0755	rm
1gqolur/	-	0755	rm
1szbdhn/	-	0755	rm
1zowdkc/	-	0755	rm
arixnlb/	-	0755	rm
arsmxck/	-	0755	rm
arzhqmf/	-	0755	rm
b1vxcyl/	-	0755	rm
bwqmevc/	-	0755	rm
byepvco/	-	0755	rm
bzywvpl/	-	0755	rm
cgi-bin/	-	0755	rm
cwroupi/	-	0755	rm
damsfzb/	-	0755	rm
dbecvxm/	-	0755	rm
edqinak/	-	0755	rm
f1zgneb/	-	0755	rm
fnlwexj/	-	0755	rm
fpqxdir/	-	0755	rm
fxectgd/	-	0755	rm
fzpnerx/	-	0755	rm
gfzcxjt/	-	0755	rm
h1czexs/	-	0755	rm
hcptfdo/	-	0755	rm
hkyiref/	-	0755	rm
hpeywva/	-	0755	rm
htknmpz/	-	0755	rm
iwgusmc/	-	0755	rm
iyoflug/	-	0755	rm
jawmzg1/	-	0755	rm
jqhosza/	-	0755	rm
jtrhycp/	-	0755	rm
kjgbhaf/	-	0755	rm
kqomvtg/	-	0755	rm
krdwqve/	-	0755	rm
kstmhiw/	-	0755	rm
kyiegbx/	-	0755	rm
kzlsnfi/	-	0755	rm
lsqrmaj/	-	0755	rm
mailer/	-	0755	rm
nbqxmlz/	-	0755	rm
nrmsht1/	-	0755	rm
obmqfrw/	-	0755	rm
ocbzhjr/	-	0755	rm
omtphcu/	-	0755	rm
onjdvyg/	-	0755	rm
ox1bmqd/	-	0755	rm
pbdueyl/	-	0755	rm
pgmw1kq/	-	0755	rm
pgythz1/	-	0755	rm
pjzkbfs/	-	0755	rm
plozqab/	-	0755	rm
qjkczrx/	-	0755	rm
qsjwd1e/	-	0755	rm
reszbdi/	-	0755	rm
rkduzal/	-	0755	rm
rpsjmiq/	-	0755	rm
rtbuodn/	-	0755	rm
snevhgq/	-	0755	rm
stuokzc/	-	0755	rm
swdybcm/	-	0755	rm
swtkhdy/	-	0755	rm
tejgfov/	-	0755	rm
tuwsqfb/	-	0755	rm
uqivgzo/	-	0755	rm
vbzxrna/	-	0755	rm
vlwreyp/	-	0755	rm
vytocjf/	-	0755	rm
wej1tig/	-	0755	rm
well-known/	-	0755	rm
whfpjgc/	-	0755	rm
wndvgcz/	-	0755	rm
x1eljmz/	-	0755	rm
xkoyzqc/	-	0755	rm
xkptejz/	-	0755	rm
xlvnjwt/	-	0755	rm
xnfbiho/	-	0755	rm
xprstg1/	-	0755	rm
yavdwlq/	-	0755	rm
ymfsvbp/	-	0755	rm
ytl1ocu/	-	0755	rm
zbeorkm/	-	0755	rm
znoyxwh/	-	0755	rm
zpiashq/	-	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
drjhhzof.php	10560	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
hhizqkht.php	19513	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