Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/public_html/crm

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: cron_renewal_reminder_email.php

<!doctype html>
<html>
  <head>
    <meta name="viewport" content="width=device-width" />
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>Renewal Alert</title>

body {
        background-color: #f6f6f6;
        font-family: sans-serif;
        -webkit-font-smoothing: antialiased;
        font-size: 14px;
        line-height: 1.4;
        margin: 0;
        padding: 0; 
        -ms-text-size-adjust: 100%;
        -webkit-text-size-adjust: 100%; }

table {
        border-collapse: separate;
        mso-table-lspace: 0pt;
        mso-table-rspace: 0pt;
        width: 100%; }
        table td {
          font-family: sans-serif;
          font-size: 14px;
          vertical-align: top; }

/* -------------------------------------
          BODY & CONTAINER
      ------------------------------------- */

.body {
        background-color: #f6f6f6;
        width: 100%; }

/* Set a max-width, and make it display as block so it will automatically stretch to that width, but will also shrink down on a phone or something */
      .container {
        display: block;
        Margin: 0 auto !important;
        /* makes it centered */
        max-width: 780px;
        padding: 10px;
        width: 780px; }

/* This should also be a block element, so that it will fill 100% of the .container */
      .content {
        box-sizing: border-box;
        display: block;
        Margin: 0 auto;
        max-width: 780px;
        padding: 10px; }

/* -------------------------------------
          HEADER, FOOTER, MAIN
      ------------------------------------- */
      .main {
        background: #fff;
        border-radius: 3px;
        width: 100%; }

.wrapper {
        box-sizing: border-box;
        padding: 20px; }

.footer {
        clear: both;
        padding-top: 10px;
        text-align: center;
        width: 100%; }
        .footer td,
        .footer p,
        .footer span,
        .footer a {
          color: #999999;
          font-size: 12px;
          text-align: center; }

/* -------------------------------------
          TYPOGRAPHY
      ------------------------------------- */
      h1,
      h2,
      h3,
      h4 {
        color: #000000;
        font-family: sans-serif;
        font-weight: 400;
        line-height: 1.4;
        margin: 0;
        Margin-bottom: 30px; }

h1 {
        font-size: 35px;
        font-weight: 300;
        text-align: center;
        text-transform: capitalize; }

p,
      ul,
      ol {
        font-family: sans-serif;
        font-size: 14px;
        font-weight: normal;
        margin: 0;
        Margin-bottom: 15px; }
        p li,
        ul li,
        ol li {
          list-style-position: inside;
          margin-left: 5px; }

a {
        color: #3498db;
        text-decoration: underline; }

.powered-by a {
        text-decoration: none; }

hr {
        border: 0;
        border-bottom: 1px solid #f6f6f6;
        Margin: 20px 0; }

/* -------------------------------------
          RESPONSIVE AND MOBILE FRIENDLY STYLES
      ------------------------------------- */
      @media only screen and (max-width: 620px) {
        table[class=body] h1 {
          font-size: 28px !important;
          margin-bottom: 10px !important; }
        table[class=body] p,
        table[class=body] ul,
        table[class=body] ol,
        table[class=body] td,
        table[class=body] span,
        table[class=body] a {
          font-size: 16px !important; }
        table[class=body] .wrapper,
        table[class=body] .article {
          padding: 10px !important; }
        table[class=body] .content {
          padding: 0 !important; }
        table[class=body] .container {
          padding: 0 !important;
          width: 100% !important; }
        table[class=body] .main {
          border-left-width: 0 !important;
          border-radius: 0 !important;
          border-right-width: 0 !important; }
        table[class=body] .btn table {
          width: 100% !important; }
        table[class=body] .btn a {
          width: 100% !important; }
        table[class=body] .img-responsive {
          height: auto !important;
          max-width: 100% !important;
          width: auto !important; }}

</style>
   
<?php 
	session_start();
	define("DBHOST","localhost");
	// Database Username
	define("DBUSER","root"); 
	// Database Password
	define("DBPASS","root");                           
	// Database Name
	define("DBNAME","crm");

$cxn = mysql_connect(DBHOST, DBUSER, DBPASS);
	mysql_select_db(DBNAME,$cxn) or die('Could not connect.');

function getDomainRenewalPrice($renewal,$type){
			
		$date = date('Y-m-d');
		$query = mysql_query( "SELECT * FROM service_rate WHERE ref_service_id = '1' AND ref_renewal_type_id = '".$renewal."' AND ref_domain_type_id = '".$type."' AND service_rate_from_date <= '".$date."' AND delete_status = 0 AND transaction_id = 0  ORDER BY service_rate_from_date DESC LIMIT 1");

while($row = mysql_fetch_assoc($query)){
			return $row;
		}
	}

function getHostingRenewalPrice($renewal,$type){
		
		$date = date('Y-m-d');
		
		$query = mysql_query( "SELECT * FROM service_rate WHERE ref_service_id = '2' AND ref_renewal_type_id = '".$renewal."' AND ref_server_type_id = '".$type."' AND service_rate_from_date <= '".$date."'  AND delete_status = 0 AND transaction_id = 0 ORDER BY service_rate_from_date DESC LIMIT 1");

while($row = mysql_fetch_assoc($query)){
			return $row;
		}
	}

function getEmailRenewalPrice($renewal){
		
		$date = date('Y-m-d');
		
		$query = mysql_query( "SELECT * FROM service_rate WHERE ref_service_id = '3' AND ref_renewal_type_id = '".$renewal."' AND service_rate_from_date <= '".$date."' AND service_rate_to_date AND ref_email_type_id = 1 AND delete_status = 0 AND transaction_id = 0 ORDER BY service_rate_from_date DESC LIMIT 1");

while($row = mysql_fetch_assoc($query)){
			return $row;
		}
	}

$res_domain_list = getRenewalsList('domain_list','30 days');
	getRenewalDetails($res_domain_list,'30');
	
	$res_domain_list = getRenewalsList('domain_list','15 days');
	getRenewalDetails($res_domain_list,'15');

$res_domain_list = getRenewalsList('domain_list','7 days');
	getRenewalDetails($res_domain_list,'7');
	
	$res_domain_list = getRenewalsList('domain_list','today');
	getRenewalDetails($res_domain_list,'');
	
	
	//~ echo '<pre>';
	//~ print_r($res_domain_list);
	//~ echo '</pre>';

function sendEmail($to_address,$message){
		require 'PHPMailer/PHPMailerAutoload.php';
		$mail = new PHPMailer;
		$mail->isSMTP();                                   // Set mailer to use SMTP
		$mail->Host = 'smtp.gmail.com';                    // Specify main and backup SMTP servers
		$mail->SMTPAuth = true;                            // Enable SMTP authentication
		$mail->Username = 'sigmatestacct@gmail.com';          // SMTP username
		$mail->Password = 'sigma@pwd567'; // SMTP password
		$mail->SMTPSecure = 'tls';                         // Enable TLS encryption, `ssl` also accepted
		$mail->Port = 587;                                 // TCP port to connect to

$mail->setFrom('sigmatestacct@gmail.com', 'Sigma');
		$mail->addReplyTo('sigmatestacct@gmail.com', 'Sigma');
		//$mail->addAddress($to_address);   // Add a recipient
		$mail->addAddress('sigmatestacct@gmail.com');   // Add a recipient
		//$mail->addCC('cc@example.com');
		//$mail->addBCC('bcc@example.com');

$mail->isHTML(true);  // Set email format to HTML
		
		$mail->Subject = 'Domain/Email Renewals';
				
		echo $mail->Body    = $message;
		
		if(!$mail->send()) {
			$mail_status = 'Mail not Sent!'.$mail->ErrorInfo;
		}else{
			$mail_status = 'Mail Sent!';
		}
		echo $mail_status;
			
	}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: cron_renewal_reminder_email.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation