Pommo_Fields::subscribersAffected PHP Method

    function subscribersAffected($id = array(), $val = null)
    {
        $dbo =& Pommo::$_dbo;
        $o = array();
        $query = "\n            SELECT DISTINCT subscriber_id\n            FROM " . $dbo->table['subscriber_data'] . "\n            WHERE field_id IN(%c)\n            [AND value='%S']";
        $query = $dbo->prepare($query, array($id, $val));
        while ($row = $dbo->getRows($query, TRUE)) {
            $o[] = $row[0];
        }
        return $o;
    }

         $options = Pommo_Fields::optionAdd($field, $_REQUEST['options']);
     }
     if (!options) {
         $json->fail(Pommo::_T('Error with addition.'));
     }
     $json->add('callbackFunction', 'updateOptions');
     $json->add('callbackParams', $options);
     $json->serve();
     break;
 case 'delOption':
     // validate field ID
     $field = current(Pommo_Fields::get(array('id' => $_REQUEST['field_id'])));
     if ($field['id'] != $_REQUEST['field_id']) {
         die('bad field ID');
     }
     $affected = Pommo_Fields::subscribersAffected($field['id'], $_REQUEST['options']);
     if (count($affected) > 0 && empty($_REQUEST['confirmed'])) {
         $msg = sprintf(Pommo::_T('Deleting option %1$s will affect %2$s subscribers who have selected this choice. They will be flagged as needing to update their records.'), '<b>' . $_REQUEST['options'] . '</b>', '<em>' . count($affected) . '</em>');
         $msg .= "\n " . Pommo::_T('Are you sure?');
         $json->add('callbackFunction', 'confirm');
         $json->add('callbackParams', $msg);
         $json->serve();
     } else {
         require_once Pommo::$_baseDir . 'classes/Pommo_Subscribers.php';
         $options = Pommo_Fields::optionDel($field, $_REQUEST['options']);
         if (!options) {
             $json->fail(Pommo::_T('Error with deletion.'));
         }
         // flag subscribers for update
         if (count($affected) > 0) {
             Pommo_Subscribers::flagByID($affected);