fetch_rowset(' SELECT u.username, u.user_email, u.user_lang FROM ' . BB_USERS . ' u, ' . BB_USER_GROUP . " ug WHERE ug.group_id = $group_id AND ug.user_pending = 0 AND u.user_id = ug.user_id AND u.user_active = 1 AND u.user_id NOT IN(" . EXCLUDED_USERS . $banned_users . ') '); } else { $user_list = DB()->fetch_rowset(' SELECT username, user_email, user_lang FROM ' . BB_USERS . ' WHERE user_active = 1 AND user_id NOT IN(' . EXCLUDED_USERS . $banned_users . ') '); } foreach ($user_list as $i => $row) { // Sending email $emailer = new TorrentPier\Emailer(); $emailer->set_to($row['user_email'], $row['username']); $emailer->set_subject($subject); $emailer->set_reply($reply_to); $emailer->set_template('admin_send_email'); $emailer->assign_vars(['MESSAGE' => trim(html_entity_decode($message))]); $emailer->send($message_type); } } } // // Generate page // $sql = 'SELECT group_id, group_name FROM ' . BB_GROUPS . ' WHERE group_single_user = 0 ORDER BY group_name '; $groups = ['-- ' . $lang['ALL_USERS'] . ' --' => -1]; foreach (DB()->fetch_rowset($sql) as $row) { $groups[$row['group_name']] = $row['group_id']; } $template->assign_vars([ 'MESSAGE' => $message, 'SUBJECT' => $subject, 'REPLY_TO' => $reply_to, 'ERROR_MESSAGE' => $errors ? implode('
', array_unique($errors)) : '', 'S_USER_ACTION' => 'admin_mass_email.php', 'S_GROUP_SELECT' => build_select(POST_GROUPS_URL, $groups) ]); print_page('admin_mass_email.tpl', 'admin');