function AcceptOrder_SMS($args)
{
$class = new AktuelSms();
$template = $class->getTemplateDetails(__FUNCTION__);
if ($template['active'] == 0) {
return null;
}
$settings = $class->getSettings();
if (!$settings['api'] || !$settings['apiparams'] || !$settings['gsmnumberfield'] || !$settings['wantsmsfield']) {
return null;
}
$userSql = "SELECT `a`.`id`,`a`.`firstname`, `a`.`lastname`, `b`.`value` as `gsmnumber`\n FROM `tblclients` as `a`\n JOIN `tblcustomfieldsvalues` as `b` ON `b`.`relid` = `a`.`id`\n JOIN `tblcustomfieldsvalues` as `c` ON `c`.`relid` = `a`.`id`\n WHERE `a`.`id` IN (SELECT userid FROM tblorders WHERE id = '" . $args['orderid'] . "')\n AND `b`.`fieldid` = '" . $settings['gsmnumberfield'] . "'\n AND `c`.`fieldid` = '" . $settings['wantsmsfield'] . "'\n AND `c`.`value` = 'on'\n LIMIT 1";
$result = mysql_query($userSql);
$num_rows = mysql_num_rows($result);
if ($num_rows == 1) {
$UserInformation = mysql_fetch_assoc($result);
$template['variables'] = str_replace(" ", "", $template['variables']);
$replacefrom = explode(",", $template['variables']);
$replaceto = array($UserInformation['firstname'], $UserInformation['lastname'], $args['orderid']);
$message = str_replace($replacefrom, $replaceto, $template['template']);
$class->setGsmnumber($UserInformation['gsmnumber']);
$class->setUserid($UserInformation['id']);
$class->setMessage($message);
$class->send();
}
}
function InvoicePaid($args)
{
$class = new AktuelSms();
$template = $class->getTemplateDetails(__FUNCTION__);
if ($template['active'] == 0) {
return null;
}
$settings = $class->getSettings();
if (!$settings['api'] || !$settings['apiparams'] || !$settings['gsmnumberfield'] || !$settings['wantsmsfield']) {
return null;
}
$userSql = "\n SELECT a.duedate,b.id as userid,b.firstname,b.lastname,`c`.`value` as `gsmnumber` FROM `tblinvoices` as `a`\n JOIN tblclients as b ON b.id = a.userid\n JOIN `tblcustomfieldsvalues` as `c` ON `c`.`relid` = `a`.`userid`\n JOIN `tblcustomfieldsvalues` as `d` ON `d`.`relid` = `a`.`userid`\n WHERE a.id = '" . $args['invoiceid'] . "'\n AND `c`.`fieldid` = '" . $settings['gsmnumberfield'] . "'\n AND `d`.`fieldid` = '" . $settings['wantsmsfield'] . "'\n AND `d`.`value` = 'on'\n LIMIT 1\n ";
$result = mysql_query($userSql);
$num_rows = mysql_num_rows($result);
if ($num_rows == 1) {
$UserInformation = mysql_fetch_assoc($result);
$template['variables'] = str_replace(" ", "", $template['variables']);
$replacefrom = explode(",", $template['variables']);
$replaceto = array($UserInformation['firstname'], $UserInformation['lastname'], $class->changeDateFormat($UserInformation['duedate']));
$message = str_replace($replacefrom, $replaceto, $template['template']);
$class->setGsmnumber($UserInformation['gsmnumber']);
$class->setMessage($message);
$class->setUserid($UserInformation['userid']);
$class->send();
}
}
function AfterRegistrarRenewalFailed_admin($args)
{
$class = new AktuelSms();
$template = $class->getTemplateDetails(__FUNCTION__);
if ($template['active'] == 0) {
return null;
}
$settings = $class->getSettings();
if (!$settings['api'] || !$settings['apiparams'] || !$settings['gsmnumberfield'] || !$settings['wantsmsfield']) {
return null;
}
$admingsm = explode(",", $template['admingsm']);
$template['variables'] = str_replace(" ", "", $template['variables']);
$replacefrom = explode(",", $template['variables']);
$replaceto = array($args['params']['sld'] . "." . $args['params']['tld']);
$message = str_replace($replacefrom, $replaceto, $template['template']);
foreach ($admingsm as $gsm) {
if (!empty($gsm)) {
$class->setGsmnumber(trim($gsm));
$class->setUserid(0);
$class->setMessage($message);
$class->send();
}
}
}
function AfterModuleChangePassword($args)
{
$type = $args['params']['producttype'];
if ($type == "hostingaccount") {
$class = new AktuelSms();
$template = $class->getTemplateDetails(__FUNCTION__);
if ($template['active'] == 0) {
return null;
}
$settings = $class->getSettings();
if (!$settings['api'] || !$settings['apiparams'] || !$settings['gsmnumberfield'] || !$settings['wantsmsfield']) {
return null;
}
} else {
return null;
}
$userSql = "SELECT `a`.`id`,`a`.`firstname`, `a`.`lastname`, `b`.`value` as `gsmnumber`\n FROM `tblclients` as `a`\n JOIN `tblcustomfieldsvalues` as `b` ON `b`.`relid` = `a`.`id`\n JOIN `tblcustomfieldsvalues` as `c` ON `c`.`relid` = `a`.`id`\n WHERE `a`.`id` = '" . $args['params']['clientsdetails']['userid'] . "'\n AND `b`.`fieldid` = '" . $settings['gsmnumberfield'] . "'\n AND `c`.`fieldid` = '" . $settings['wantsmsfield'] . "'\n AND `c`.`value` = 'on'\n LIMIT 1";
$result = mysql_query($userSql);
$num_rows = mysql_num_rows($result);
if ($num_rows == 1) {
$UserInformation = mysql_fetch_assoc($result);
$template['variables'] = str_replace(" ", "", $template['variables']);
$replacefrom = explode(",", $template['variables']);
$replaceto = array($UserInformation['firstname'], $UserInformation['lastname'], $args['params']['domain'], $args['params']['username'], $args['params']['password']);
$message = str_replace($replacefrom, $replaceto, $template['template']);
$class->setGsmnumber($UserInformation['gsmnumber']);
$class->setUserid($args['params']['clientsdetails']['userid']);
$class->setMessage($message);
$class->send();
}
}
function ClientAdd_admin($args)
{
$class = new AktuelSms();
$template = $class->getTemplateDetails(__FUNCTION__);
if ($template['active'] == 0) {
return null;
}
$settings = $class->getSettings();
if (!$settings['api'] || !$settings['apiparams'] || !$settings['gsmnumberfield'] || !$settings['wantsmsfield']) {
return null;
}
$admingsm = explode(",", $template['admingsm']);
foreach ($admingsm as $gsm) {
if (!empty($gsm)) {
$class->setGsmnumber(trim($gsm));
$class->setUserid(0);
$class->setMessage($template['template']);
$class->send();
}
}
}
function DomainRenewalNotice($args)
{
$class = new AktuelSms();
$template = $class->getTemplateDetails(__FUNCTION__);
if ($template['active'] == 0) {
return null;
}
$settings = $class->getSettings();
if (!$settings['api'] || !$settings['apiparams'] || !$settings['gsmnumberfield'] || !$settings['wantsmsfield']) {
return null;
}
$extra = $template['extra'];
$sqlDomain = "SELECT `userid` , `domain` , `expirydate`\n FROM `tbldomains`\n WHERE `status` = 'Active'";
$resultDomain = mysql_query($sqlDomain);
while ($data = mysql_fetch_array($resultDomain)) {
$tarih = explode("-", $data['expirydate']);
$yesterday = mktime(0, 0, 0, $tarih[1], $tarih[2] - $extra, $tarih[0]);
$today = date("Y-m-d");
if (date('Y-m-d', $yesterday) == $today) {
$userSql = "SELECT `a`.`id` as userid,`a`.`firstname`, `a`.`lastname`, `b`.`value` as `gsmnumber`\n FROM `tblclients` as `a`\n JOIN `tblcustomfieldsvalues` as `b` ON `b`.`relid` = `a`.`id`\n JOIN `tblcustomfieldsvalues` as `c` ON `c`.`relid` = `a`.`id`\n WHERE `a`.`id` = '" . $data['userid'] . "'\n AND `b`.`fieldid` = '" . $settings['gsmnumberfield'] . "'\n AND `c`.`fieldid` = '" . $settings['wantsmsfield'] . "'\n AND `c`.`value` = 'on'\n LIMIT 1";
$result = mysql_query($userSql);
$num_rows = mysql_num_rows($result);
if ($num_rows == 1) {
$UserInformation = mysql_fetch_assoc($result);
$template['variables'] = str_replace(" ", "", $template['variables']);
$replacefrom = explode(",", $template['variables']);
$replaceto = array($UserInformation['firstname'], $UserInformation['lastname'], $data['domain'], $data['expirydate'], $extra);
$message = str_replace($replacefrom, $replaceto, $template['template']);
$class->setGsmnumber($UserInformation['gsmnumber']);
$class->setMessage($message);
$class->setUserid($UserInformation['userid']);
$class->send();
}
}
}
}
