<?php
$user_whmcs = "db_user";
$password_whmcs="db_pwd";
$host_whmcs="db_hostname";
$database_whmcs="db_name";
$remind_trial_days = "4";
$clientArea = "https://yourdomain.com/whmcs/clientarea.php";

$whmcs_conn_string=mysql_connect($host_whmcs,$user_whmcs,$password_whmcs);
$whmcs_dbconn=mysql_select_db($database_whmcs,$whmcs_conn_string);

$sql_gettrial = "select orderid,userid from tblhosting where DATEDIFF(now(),regdate)=$remind_trial_days and (packageid=16 or packageid=17)";
$rs_gettrial = mysql_query($sql_gettrial);

while($row = mysql_fetch_array($rs_gettrial, MYSQL_ASSOC))
{
$orderid = $row['orderid'];
$userid = $row['userid'];
$rs_getemail = mysql_query("SELECT email FROM tblclients WHERE id = ".$userid."");
$ada_email = mysql_numrows($rs_getemail);

while($rowemail = mysql_fetch_array($rs_getemail, MYSQL_ASSOC))
	{
$mailme = $rowemail['email'];

$Name = "WebHost.Com"; //senders name
$email = "admin@webhost.com"; //senders e-mail adress
$recipient = $mailme; //recipient
$mail_body = "Hello,
This is a reminder that your Trial Acccount will be terminated in three days. All data within this account will be terminated if you do not upgrade your account.

This is the only and last reminder for you to upgrade your account. Please follow the steps below when you decide to keep the account.

UPGRADING A TRIAL ACCOUNT TO A REGULLAR ACCOUNT:
To upgrade to a regullar account, you must follow these steps:
1. Login to the client area at $clientArea using your email address and password\n
2. Click on My Hosting Packages from the left navigation menu\n
3. Click on View Details on your hosting package\n
4. Click on Upgrade/Downgrade Package\n
5. Choose the respective hosting plan\n
6. Click the continue button, then Make Payment by clicking the Invoice Number\n
7. Upon making payment your account will be upgraded.\n

If you do not wish to continue using your web hosting account, please ignore this email, your account will be automatically terminated in three days.

Thank you for using our trial account!"; //mail body
$subject = "Your Hosting Trial Account Termination Reminder"; //subject
$header = "From: ". $Name . " <" . $email . ">\r\n"; //optional headerfields

mail($recipient, $subject, $mail_body, $header); //mail command :)

	}

}

print "Trial reminders sent!";
?>