| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/software/smsc smpp installer/software/Services/EmailPenpalAfrica/php/ |
Upload File : |
<?php
include "general.php";
include "connect.php";
include 'sendmailclient.php';
//$query= "select sn,name,email from penpal where domain ='penpalamerica.com' and emailreceived !='1' and photoupload='true' and deleteaccount='0' order by sn ";
$query= "select sn,name,email from penpal where domain ='penpalamerica.com' and emailreceived !='1' and date(lastseen) > '2021/01/01' and date(lastseen) < '2022/04/20/' order by sn ";
//$query= "select sn,name,email from penpal where domain ='penpalafrica.com' and emailreceived !='1' and date(lastseen) > '2020/01/01' and date(lastseen) < '2021/12/22/' order by sn ";
//$query= "select sn,name,email from penpal where domain ='penpalasia.com' and emailreceived !='1' and date(lastseen) > '2020/01/01' and date(lastseen) < '2021/12/22/' order by sn ";
//echo $query;
//die();
$cnt ="#";
$con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
///Check connection
if (mysqli_connect_errno())
{
// //echo mysqli_error($con);
//echo "-1";
return '#';
die();
}
if(!$result= mysqli_query($con,$query))
{
mysqli_close($con);
return "#";
}
else
{
$photo_number=0;
$items= [];
$mysub="Penpal America - We missed you!!!";
$mfrom ="noreply@penpalamerica.com";
$mfromname ="Penpal America";
$cnt=1;
while($row = mysqli_fetch_array($result))
{
// $email = $row[2];
// if($cnt ==1){
// $email ="nosa.osahon@gmail.com";
// }
//if($cnt ==2){
//$email ="osahon.enosakhare@gmail.com";
// }
//if($cnt ==3){
//$email ="nosa.osahon@penpalamerica.com";
//}
$email = $row[2];
$name = $row[1];
$serial = $row[0];
$myMessage= "<!DOCTYPE html> <html lang='en' xmlns='http://www.w3.org/1999/xhtml' xmlns:v='urn:schemas-microsoft-com:vml' xmlns:o='urn:schemas-microsoft-com:office:office'> <head> <meta charset='utf-8'> <!-- utf-8 works for most cases --> <meta name='viewport' content='width=device-width'> <!-- Forcing initial-scale shouldn't be necessary --> <meta http-equiv='X-UA-Compatible' content='IE=edge'> <!-- Use the latest (edge) version of IE rendering engine --> <meta name='x-apple-disable-message-reformatting'> <!-- Disable auto-scale in iOS 10 Mail entirely --> <title></title> <!-- The title tag shows in email notifications, like Android 4.4. --> <link href='https://fonts.googleapis.com/css?family=Poppins:200,300,400,500,600,700' rel='stylesheet'> <!-- CSS Reset : BEGIN --> <style> /* What it does: Remove spaces around the email design added by some email clients. */ /* Beware: It can remove the padding / margin and add a background color to the compose a reply window. */ html, body { margin: 0 auto !important; padding: 0 !important; height: 100% !important; width: 100% !important; background: #f1f1f1; } /* What it does: Stops email clients resizing small text. */ * { -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%; } /* What it does: Centers email on Android 4.4 */ div[style*='margin: 16px 0'] { margin: 0 !important; } /* What it does: Stops Outlook from adding extra spacing to tables. */ table, td { mso-table-lspace: 0pt !important; mso-table-rspace: 0pt !important; } /* What it does: Fixes webkit padding issue. */ table { border-spacing: 0 !important; border-collapse: collapse !important; table-layout: fixed !important; margin: 0 auto !important; } /* What it does: Uses a better rendering method when resizing images in IE. */ img { -ms-interpolation-mode:bicubic; } /* What it does: Prevents Windows 10 Mail from underlining links despite inline CSS. Styles for underlined links should be inline. */ a { text-decoration: none; } /* What it does: A work-around for email clients meddling in triggered links. */ *[x-apple-data-detectors], /* iOS */ .unstyle-auto-detected-links *, .aBn { border-bottom: 0 !important; cursor: default !important; color: inherit !important; text-decoration: none !important; font-size: inherit !important; font-family: inherit !important; font-weight: inherit !important; line-height: inherit !important; } /* What it does: Prevents Gmail from displaying a download button on large, non-linked images. */ .a6S { display: none !important; opacity: 0.01 !important; } /* What it does: Prevents Gmail from changing the text color in conversation threads. */ .im { color: inherit !important; } /* If the above doesn't work, add a .g-img class to any image in question. */ img.g-img + div { display: none !important; } /* What it does: Removes right gutter in Gmail iOS app: https://github.com/TedGoas/Cerberus/issues/89 */ /* Create one of these media queries for each additional viewport size you'd like to fix */ /* iPhone 4, 4S, 5, 5S, 5C, and 5SE */ @media only screen and (min-device-width: 320px) and (max-device-width: 374px) { u ~ div .email-container { min-width: 320px !important; } } /* iPhone 6, 6S, 7, 8, and X */ @media only screen and (min-device-width: 375px) and (max-device-width: 413px) { u ~ div .email-container { min-width: 375px !important; } } /* iPhone 6+, 7+, and 8+ */ @media only screen and (min-device-width: 414px) { u ~ div .email-container { min-width: 414px !important; } } </style> <!-- CSS Reset : END --> <!-- Progressive Enhancements : BEGIN --> <style> .primary{ background: #17bebb; } .bg_white{ background: #ffffff; } .bg_light{ background: #f7fafa; } .bg_black{ background: #000000; } .bg_dark{ background: rgba(0,0,0,.8); } .email-section{ padding:2.5em; } /*BUTTON*/ .btn{ padding: 10px 15px; display: inline-block; } .btn.btn-primary{ border-radius: 5px; background: #17bebb; color: #ffffff; } .btn.btn-white{ border-radius: 5px; background: #ffffff; color: #000000; } .btn.btn-white-outline{ border-radius: 5px; background: transparent; border: 1px solid #fff; color: #fff; } .btn.btn-black-outline{ border-radius: 0px; background: transparent; border: 2px solid #000; color: #000; font-weight: 700; } .btn-custom{ color: rgba(0,0,0,.3); text-decoration: underline; } h1,h2,h3,h4,h5,h6{ font-family: 'Poppins', sans-serif; color: #000000; margin-top: 0; font-weight: 400; } body{ font-family: 'Poppins', sans-serif; font-weight: 400; font-size: 15px; line-height: 1.8; color: rgba(0,0,0,.4); } a{ color: #17bebb; } table{ } /*LOGO*/ .logo h1{ margin: 0; } .logo h1 a{ color: #17bebb; font-size: 24px; font-weight: 700; font-family: 'Poppins', sans-serif; } /*HERO*/ .hero{ position: relative; z-index: 0; } .hero .text{ color: rgba(0,0,0,.3); } .hero .text h2{ color: #000; font-size: 34px; margin-bottom: 0; font-weight: 200; line-height: 1.4; } .hero .text h3{ font-size: 24px; font-weight: 300; } .hero .text h2 span{ font-weight: 600; color: #000; } .text-author{ bordeR: 1px solid rgba(0,0,0,.05); max-width: 50%; margin: 0 auto; padding: 2em; } .text-author img{ border-radius: 50%; padding-bottom: 20px; } .text-author h3{ margin-bottom: 0; } ul.social{ padding: 0; } ul.social li{ display: inline-block; margin-right: 10px; } /*FOOTER*/ .footer{ border-top: 1px solid rgba(0,0,0,.05); color: rgba(0,0,0,.5); } .footer .heading{ color: #000; font-size: 20px; } .footer ul{ margin: 0; padding: 0; } .footer ul li{ list-style: none; margin-bottom: 10px; } .footer ul li a{ color: rgba(0,0,0,1); } @media screen and (max-width: 500px) { } </style> </head> <body width='100%' style='margin: 0; padding: 0 !important; mso-line-height-rule: exactly; background-color: #f1f1f1;'> <center style='width: 100%; background-color: #f1f1f1;'> <div style='display: none; font-size: 1px;max-height: 0px; max-width: 0px; opacity: 0; overflow: hidden; mso-hide: all; font-family: sans-serif;'> ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ </div> <div style='max-width: 600px; margin: 0 auto;' class='email-container'> <!-- BEGIN BODY --> <table align='left' role='presentation' cellspacing='0' cellpadding='0' border='0' width='100%' style='margin: auto;'> <tr> <td valign='top' class='bg_white' style='padding: 1em 2.5em 0 2.5em;'> <table role='presentation' border='0' cellpadding='0' cellspacing='0' width='100%'> <tr> <td class='logo' style='text-align: center;'> <h1><a href='penpalamerica.com'>Penpal America</a></h1> </td> </tr> </table> </td> </tr><!-- end tr --> <tr> <td valign='middle' class='hero bg_white' style='padding: 2em 0 4em 0;'> <table role='presentation' border='0' cellpadding='0' cellspacing='0' width='100%'> <tr> <td style='padding: 0 2.5em; text-align:left; padding-bottom: 3em;'> <div class='text'> <p>Dear $name, <br><br>Your Profile shows that your last seen was over one week ago. Many pals missed you. Please try to log in as soon as possible and start chatting.You can login from the web or from within our app.</p> <p>You can use these links to access our App </p> </div> </td> </tr> <tr> <td style='text-align: center;'> <p style='text-align: center;'><a href='https://penpalamerica.com/' class='btn btn-primary'>Login</a> <a href='https://play.google.com/store/apps/details?id=com.penpalamerica.penpal' class='btn btn-primary'>Download App</a></p><div class='text-author'> </div><img src='http://penpalamerica.com//images//coversmall.png' alt='' style='width: 100%; max-width: 600px; height: auto; margin: auto; display: block;'><p style='text-align: left; margin-left: 40px;'>Best Regards,<br>Support Team<br>Penpal America</p</td> </tr> </table> </td> </tr> <!-- end tr --> <!-- 1 Column Text + Button : END --> </table> <table align='left' role='presentation' cellspacing='0' cellpadding='0' border='0' width='100%' style='margin: auto;'> <tr> <td valign='middle' class='bg_light footer email-section'> <table> <tr> <td valign='top' width='33.333%' style='padding-top: 20px;'> <table role='presentation' cellspacing='0' cellpadding='0' border='0' width='100%'> <tr> <td style='text-align: left; padding-right: 10px;'> <h3 class='heading'>About</h3> <p>Penpal America allows you to meet new people in the continents of North and South America. We have many people joining the site everyday. Invite a friend today... </p> </td> </tr> </table> </td> <td valign='top' width='33.333%' style='padding-top: 20px;'> <table role='presentation' cellspacing='0' cellpadding='0' border='0' width='100%'> <tr> <td style='text-align: center; padding-left: 5px; padding-right: 5px;'> <h3 class='heading'>Contact Info</h3> <ul> <li><span class='text'>support @ penpalamerica.com</span></a></li> </ul> </td> </tr> </table> </td> </tr> </table> </td> </tr><!-- end: tr --> <tr> <td class='bg_light' style='text-align: center;font-size:0.7em'> <p>No longer want to receive these email? You can unsubscribe <a href='http://www.penpalamerica.com/unsubscribe.php?err=$serial' style='color: rgba(0,0,0,.8);'>here</a></p> </td> </tr> </table> </div> </center> </body> </html>";
$myMessage2= $myMessage;
// Validate email
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$end_date = date("Y-m-d H:i:s");
//$email="nosa.osahon@gmail.com";
$mymail = sendmailtoclient($email,$myMessage,$myMmessage2,$mysub,$mfrom,$mfromname);
echo "$serial $name $email $end_date ****done***\n";
sleep(30);
} else {
echo(" Invalid email $email ");
}
$cnt++;
}
//echo $elem;
}
//$last_error = json_last_error_msg();
//if(strtolower($last_error) != "No Error") {
// echo "ERROR: " . $last_error; die;
// }
?>