); $res=$tikilib->query("SELECT MAX(id) as `id` FROM `tiki_invite` WHERE `inviter`=? AND `ts`=?", array($user, $tikilib->now)); $row=$res->fetchRow(); $id=$row['id']; foreach ($emails as $m) $tikilib->query( "INSERT INTO `tiki_invited` (id_invite, email, firstname, lastname, used) VALUES (?,?,?,?,?)", array($id, $m['email'], $m['firstname'], $m['lastname'], "no") ); $_SERVER['SCRIPT_URI'] = empty($_SERVER['SCRIPT_URI']) ? 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'] : $_SERVER['SCRIPT_URI']; foreach ($emails as $m) { $mail = new TikiMail(); $mail->setFrom($prefs['sender_email']); $mail->setSubject($_REQUEST["emailsubject"]); $mail->setCrlf("\n"); $url=str_replace('tiki-invite.php', 'tiki-invited.php', $_SERVER['SCRIPT_URI']) .'?invite='.$id.'&email='.urlencode($m['email']); $text=$_text; $text=str_replace('{link}', $url, $text); $text=str_replace('{email}', $m['email'], $text); $text=str_replace('{firstname}', $m['firstname'], $text); $text=str_replace('{lastname}', $m['lastname'], $text); $mail->setText($text); $mail->send(array($m['email'])); } $smarty->assign('sentresult', true); } $smarty->assign('emails', $emails); }