<?php 
        
        require_once('../wp-load.php');
        global $wpdb;
        
        function write_to_reset_member_log($message) {
    // Get WordPress root directory
    $log_file = ABSPATH . 'reset_member_logs.txt';

    // Format message with timestamp
    $log_message = "[" . date("Y-m-d H:i:s") . "] " . $message . PHP_EOL;

    // Write to log file (append mode)
    file_put_contents($log_file, $log_message, FILE_APPEND | LOCK_EX);
    }


        $table_name = $wpdb->prefix . 'hubstaff_members';
        $members_array = $wpdb->get_results("SELECT * FROM $table_name");
 			$result = $wpdb->query($wpdb->prepare("UPDATE $table_name SET api_for_user='n' "));


            if($result === false) {                               
                                        write_to_reset_member_log("❌ Database error: $wpdb->last_error");
            }elseif($result === 0) {
                                        write_to_reset_member_log("ℹ️ No rows were affected. It may have already been -> n ");
            } else {                
            						    write_to_reset_member_log("✅ Successfully updated $result row(s).");
            }