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(); } } } }