fetch_assoc()){ $userobj = userObj((int)$user['id']); foreach($userobj as $k => $val){ $context['user'.$k] = $val; } query("INSERT INTO `emails` (to_id,subject,template,context) VALUES (%d,'%s','%s','%s')",array($user['id'],$subject,$template,json_encode($context))); } } } function sendFromQueue($limit = 5){ if($res = query("SELECT e.id,u.email,e.subject,e.template,e.context FROM `emails` e JOIN `users` u ON u.id = e.to_id LIMIT %d",array($limit))){ while($email = $res->fetch_assoc()){ if(sendMail($email['template'],$email['subject'],$email['email'],get('email'),json_decode($email['context'],true))){ query("DELETE FROM `emails` WHERE id = %d",array($email['id'])); }else{ query("UPDATE `emails` SET failed=1 WHERE id = %d",array($email['id'])); } } } } ?>