| 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/Services/EmailPenpalAfrica/php -247sms/ |
Upload File : |
<?php
include "general.php";
include "connect.php";
include 'sendmailclient.php';
$query= "select a.sn,a.username,balnaira,email,dateused from smsaccount as a ,userlogin as b where a.username = b.username and a.domain =b.domain and a.domain ='247sms.com' and a.username !='system' and a.sn > 75 order by a.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="247sms Account Balance Notification";
$mfrom ="noreply@247sms.com";
$mfromname ="247sms Support";
$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";
//}
// a.sn,a.username,balnaira,email,dateused
$serial=$row[0];//date("d-m-Y",$row[4]);
$name = $row[1];
$credit = number_format($row[2],2);
$email = $row[3];
$lastused = date("d-m-Y H:i",strtotime($row[4]));//$row[4];
//echo "\n"."lastused ".$lastused."\n";
//echo "credit". $credit."\n";
//echo "email ".$email."\n";
//echo "name ".$name."\n";
//echo "serial ".$serial."\n" ;
// die();
$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='247sms.com'>247sms Account Balance</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>Below is your Account Credit Balance with us. <br><br>Credit: $credit<br>Last Used: $lastused<br><br>Note:<br>We have implemented usage validity of 3 months and additional grace period of 3 months. This means we will delete your account If you do not use it after 6 months. We need to do this because it is expensive to keep unused clients' accounts in the cloud.<br><br>For additional enquiries please call our support line +2347062012965 or send an email to support @ 247sms.com<br></p> <p>You can use these links to access our website </p> </div> </td> </tr> <tr> <td style='text-align: center;'> <p style='text-align: center;'><a href='https://247sms.com/' class='btn btn-primary'>Login</a> <a href='https://play.google.com/store/apps/details?id=com.a247sms.a247sms' class='btn btn-primary'>Download App</a></p>Best Regards,<br>Support Team<br>247sms Bulksms Service</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>247sms.com Bulksms service allows you to send SMS messages to many people at the same time to over 160 countries in the world. Service is available to individuals, companies and government agencies. Try it today: 247sms.com </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 @ 247sms.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.247sms.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
//echo $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(1080);
} 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;
// }
?>