e?
function signed_up_already($email)
{
db_connect();
$query="SELECT custemail FROM custinfo WHERE email='$email' LIMIT 1";
$result=mysql_query($query);
db_disconnect();
$rows=mysql_num_rows($result);
if ( $rows >= 1 )
{
//echo "user exists";
return 1;
}
else
{
return 0;
}
}
function crm_email($to,$subject,$message)
{
$blacklist="dawde.din@gmail.com snnrman@icloud.com mattaufiero@gmail.com jkennedy@byteproductions.com ";
if (stristr($blacklist,$to))
{
return 1;
}
$headers = "From: Pro VPN Accounts
\r\n" .
'Reply-To: Pro VPN Accounts ' . "\r\n" .
'BCC: areeby@compevo.com,fastsupport@provpnaccounts.com'. "\r\n" .
"MIME-Version: 1.0\r\n";
//$subject = "Pro VPN Accounts Trial Started";
//$to = $email;
//$to = "fastsupport@provpnaccounts.com";
$email_message=$message;
// $email_message=nl
mail($to, $subject, $email_message, $headers);
}
function connect_but_nosignup()
{
db_connect();
// $sql="INSERT INTO vpntrial(email,fname,lname,vpnusername,vpnpassword,findus,fromcountry,purpose,ip)
// VALUES('$email','$lname','$fname','$vpnusername','$vpnpassword','$findus','$country','$reason_edit','$ip')";
$sql = "SELECT * FROM vpntrial WHERE active='No'";
$result=mysql_query($sql);
db_disconnect();
while ( $row = mysql_fetch_assoc($result) )
{
$fname=$row["fname"];
$lname=$row["lname"];
$email=$row["email"];
$email_message = <<< HTML
Dear $fname $lname
Thank you for trying our VPN service by signing up for the free trial.
We just wanted to remind you that your trial account is no longer active and how simple it is to get a full account.
To upgrade to a full account instantly visit our website and order from here:
http://provpnaccounts.com/Buy_VPN_Account-118-articles
If you have any questions please let us know.
Cheers
Pro VPN Accounts
http://provpnaccounts.com
HTML;
$subject="Get a full VPN Instantly - $email";
if ( signed_up_already($email) == 0 )
{
crm_email($email,$subject,$email_message);
}
}
}
function not_connected()
{
db_connect();
// $sql="INSERT INTO vpntrial(email,fname,lname,vpnusername,vpnpassword,findus,fromcountry,purpose,ip)
// VALUES('$email','$lname','$fname','$vpnusername','$vpnpassword','$findus','$country','$reason_edit','$ip')";
$sql = "SELECT * FROM vpntrial WHERE active='Yes' AND deleteon IS NULL";
$result=mysql_query($sql);
db_disconnect();
while ( $row = mysql_fetch_assoc($result) )
{
$fname=$row["fname"];
$lname=$row["lname"];
$email=$row["email"];
$email_message = <<< HTML
Dear $fname $lname
Thank you for signing up for our free VPN trial.
We noticed you haven't connected yet and wanted to know if you need any help getting started.
If you want to upgrade to a full account instantly visit our website and order from here:
http://provpnaccounts.com/Buy_VPN_Account-118-articles
If you need any help just let us know.
Cheers
Pro VPN Accounts
http://provpnaccounts.com
HTML;
$subject="Need Help With Your VPN Trial? - $email";
if ( signed_up_already($email) == 0 )
{
crm_email($email,$subject,$email_message);
}
}
}
?>
Free VPN Trial Signup Form
Tags:vpn,