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