Text Messaging - Opted out and blocked: the numbers that replied STOP (nothing is * texted to them until they reply START) and the ones blocked as spam (their texts go * straight to Spam). Each can be put back - opting someone back in is for when they ask, by * any other way than texting START (admin/post/sms_provider.php). */ require_once '../../includes/modal_header.php'; $rows = []; try { $sql = mysqli_query($mysqli, "SELECT sms_number_phone, sms_number_label, sms_number_opted_out_at, sms_number_blocked_at, user_name FROM sms_numbers LEFT JOIN users ON user_id = sms_number_blocked_by WHERE sms_number_opted_out_at IS NOT NULL OR sms_number_blocked_at IS NOT NULL ORDER BY GREATEST(COALESCE(sms_number_opted_out_at, 0), COALESCE(sms_number_blocked_at, 0)) DESC LIMIT 500"); $rows = mysqli_fetch_all($sql, MYSQLI_ASSOC); } catch (Throwable $e) { // Before the 3.6.0 database update } $csrf = $_SESSION['csrf_token']; ob_start(); ?>
Opted out and blocked
No number has replied STOP, and none is blocked as spam.
Number What
Replied STOP
Blocked as spam
Opt back in Unblock