/** 	
  * processes all the general list actions: delete and  set items-per-page
  */
 private static function _process_general()
 {
     global $wpdb;
     if (isset($_POST['action']) && $_POST['action'] == 'list_action') {
         switch ($_POST['submit-button']) {
             case self::$i18n['delete_checked']:
                 $count = count($_POST['pid']);
                 $pattern = $count > 1 ? 'IN ( ' . trim(str_repeat('%s,', $count), ',') . ' )' : '= %s';
                 $sql = "DELETE FROM " . Participants_Db::$participants_table . " WHERE id " . $pattern;
                 $wpdb->query($wpdb->prepare($sql, $_POST['pid']));
                 Participants_Db::set_admin_message(__('Record delete successful.', 'participants-database'), 'updated');
                 break;
             case self::$i18n['change']:
                 if (floatval($_POST['list_limit']) > 0) {
                     self::set_admin_user_setting('list_limit', $_POST['list_limit']);
                 }
                 $_GET[self::$list_page] = 1;
                 break;
             default:
         }
     }
 }
 /**
  * processes the form submission
  * 
  * @global object $wpdb
  * @return null 
  */
 protected function process_submit()
 {
     global $wpdb;
     // process form submission
     $action = filter_input(INPUT_POST, 'action', FILTER_SANITIZE_STRING);
     switch ($action) {
         case 'reorder_fields':
             unset($_POST['action'], $_POST['submit-button']);
             foreach ($_POST as $key => $value) {
                 $wpdb->update(Participants_Db::$fields_table, array('order' => filter_var($value, FILTER_VALIDATE_INT)), array('id' => filter_var(str_replace('row_', '', $key), FILTER_VALIDATE_INT)));
             }
             break;
         case 'reorder_groups':
             unset($_POST['action'], $_POST['submit-button']);
             foreach ($_POST as $key => $value) {
                 $wpdb->update(Participants_Db::$groups_table, array('order' => filter_var($value, FILTER_VALIDATE_INT)), array('name' => filter_var(str_replace('order_', '', $key), FILTER_SANITIZE_STRING)));
             }
             break;
         case $this->i18n['update fields']:
             // dispose of these now unneeded fields
             unset($_POST['action'], $_POST['submit-button']);
             foreach ($_POST as $name => $row) {
                 // skip all non-row elements
                 if (false === strpos($name, 'row_')) {
                     continue;
                 }
                 if ($row['status'] == 'changed') {
                     $id = filter_var($row['id'], FILTER_VALIDATE_INT);
                     if (!empty($row['values'])) {
                         $row['values'] = serialize($this->prep_values_array($row['values']));
                     }
                     if (!empty($row['validation']) && !in_array($row['validation'], array('yes', 'no'))) {
                         $row['validation'] = str_replace('\\\\', '\\', $row['validation']);
                     }
                     /*
                      * modify the datatype if necessary
                      * 
                      * we prevent the datatype from being changed to a smaller type to protect 
                      * data. If the user really wants to do this, they will have to do it manually
                      */
                     if (isset($row['group']) && $row['group'] != 'internal') {
                         $sql = "SHOW FIELDS FROM " . Participants_Db::$participants_table . ' WHERE `field` = "%s"';
                         $field_info = $wpdb->get_results($wpdb->prepare($sql, $row['name']));
                         $new_type = PDb_FormElement::get_datatype($row['form_element']);
                         $current_type = current($field_info)->Type;
                         if ($new_type != $current_type and !($new_type == 'tinytext' and $current_type == 'text')) {
                             $sql = "ALTER TABLE " . Participants_Db::$participants_table . " MODIFY COLUMN `" . esc_sql($row['name']) . "` " . $new_type;
                             $result = $wpdb->get_results($sql);
                         }
                     }
                     /*
                      * enforce the values for a captcha field
                      */
                     if (isset($row['form_element']) && $row['form_element'] === 'captcha') {
                         $row['validation'] = 'captcha';
                         foreach (array('display_column', 'admin_column', 'CSV', 'persistent', 'sortable') as $c) {
                             $row[$c] = 0;
                         }
                         $row['readonly'] = 1;
                     }
                     foreach (array('title', 'help_text', 'default') as $field) {
                         if (isset($row[$field])) {
                             $row[$field] = stripslashes($row[$field]);
                         }
                     }
                     // remove the fields we won't be updating
                     unset($row['status'], $row['id'], $row['name']);
                     $wpdb->update(Participants_Db::$fields_table, $row, array('id' => $id));
                 }
             }
             break;
         case $this->i18n['update groups']:
             // dispose of these now unneeded fields
             unset($_POST['action'], $_POST['submit-button'], $_POST['group_title'], $_POST['group_order']);
             foreach ($_POST as $name => $row) {
                 foreach (array('title', 'description') as $field) {
                     if (isset($row[$field])) {
                         $row[$field] = stripslashes($row[$field]);
                     }
                 }
                 // make sure name is legal
                 //$row['name'] = $this->make_name( $row['name'] );
                 $wpdb->update(Participants_Db::$groups_table, $row, array('name' => stripslashes_deep($name)));
             }
             break;
             // add a new blank field
         // add a new blank field
         case $this->i18n['add field']:
             // use the wp function to clear out any irrelevant POST values
             $atts = shortcode_atts(array('name' => $this->make_name(filter_input(INPUT_POST, 'title', FILTER_SANITIZE_STRING)), 'title' => htmlspecialchars(stripslashes(filter_input(INPUT_POST, 'title', FILTER_SANITIZE_STRING)), ENT_QUOTES, "UTF-8", false), 'group' => filter_input(INPUT_POST, 'group', FILTER_SANITIZE_STRING), 'order' => filter_input(INPUT_POST, 'order', FILTER_SANITIZE_NUMBER_INT), 'validation' => 'no'), $_POST);
             if (empty($atts['name'])) {
                 break;
                 // ignore empty field name
             }
             // if they're trying to use a reserved name, stop them
             if (in_array($atts['name'], Participants_Db::$reserved_names)) {
                 Participants_Db::set_admin_message(sprintf('<h3>%s</h3> %s:<br />%s', __('Cannot add a field with that name', 'participants-database'), __('This name is reserved; please choose another. Reserved names are', 'participants-database'), implode(', ', Participants_Db::$reserved_names)), 'error');
                 break;
             }
             // prevent name from beginning with a number
             if (preg_match('/^(\\d)/', $atts['name'])) {
                 Participants_Db::set_admin_message(sprintf('<h3>%s</h3> %s', __('The name cannot begin with a number', 'participants-database'), __('Please choose another.', 'participants-database')), 'error');
                 break;
             }
             $result = Participants_Db::add_blank_field($atts);
             if (false === $result) {
                 Participants_Db::set_admin_message($this->parse_db_error($wpdb->last_error, $action), 'error');
             }
             break;
             // add a new blank field
         // add a new blank field
         case $this->i18n['add group']:
             global $wpdb;
             $wpdb->hide_errors();
             $atts = array('name' => $this->make_name($_POST['group_title']), 'title' => htmlspecialchars(stripslashes($_POST['group_title']), ENT_QUOTES, "UTF-8", false), 'order' => $_POST['group_order']);
             $wpdb->insert(Participants_Db::$groups_table, $atts);
             if ($wpdb->last_error) {
                 Participants_Db::set_admin_message($this->parse_db_error($wpdb->last_error, $action), 'error');
             }
             break;
         case 'delete_field':
             global $wpdb;
             $wpdb->hide_errors();
             $result = $wpdb->query($wpdb->prepare('
   DELETE FROM ' . Participants_Db::$fields_table . '
   WHERE id = "%s"', $_POST['delete']));
             break;
         case 'delete_group':
             global $wpdb;
             //$wpdb->hide_errors();
             $group_count = $wpdb->get_var($wpdb->prepare('SELECT COUNT(*) FROM ' . Participants_Db::$fields_table . ' WHERE `group` = "%s"', $_POST['delete']));
             if ($group_count == 0) {
                 $result = $wpdb->query($wpdb->prepare('DELETE FROM ' . Participants_Db::$groups_table . ' WHERE `name` = "%s"', $_POST['delete']));
             }
             break;
         default:
             $action = '';
     }
     if (!empty($action) && empty(Participants_Db::$admin_message)) {
         Participants_Db::set_admin_message(__('Your information has been updated', 'participants-database'), 'updated');
     }
 }
 /** 	
  * processes all the general list actions: delete and  set items-per-page
  */
 private static function _process_general()
 {
     global $wpdb;
     if (filter_input(INPUT_POST, 'action') == 'list_action') {
         switch (filter_input(INPUT_POST, 'submit-button')) {
             case self::$i18n['delete_checked']:
                 $selected_ids = filter_input(INPUT_POST, 'pid', FILTER_DEFAULT, FILTER_REQUIRE_ARRAY);
                 if ($selected_ids) {
                     $count = count($selected_ids);
                     $pattern = $count > 1 ? 'IN ( ' . trim(str_repeat('%s,', $count), ',') . ' )' : '= %s';
                     $sql = "DELETE FROM " . Participants_Db::$participants_table . " WHERE id " . $pattern;
                     $wpdb->query($wpdb->prepare($sql, $selected_ids));
                     Participants_Db::set_admin_message(__('Record delete successful.', 'participants-database'), 'updated');
                 }
                 break;
             case self::$i18n['change']:
                 $list_limit = filter_input(INPUT_POST, 'list_limit', FILTER_VALIDATE_INT);
                 if ($list_limit > 0) {
                     self::set_admin_user_setting('list_limit', $list_limit);
                 }
                 $_GET[self::$list_page] = 1;
                 break;
             default:
                 /**
                  * action: pdb-process_admin_list_submission
                  * 
                  * @version 1.6
                  */
                 do_action(Participants_Db::$prefix . 'process_admin_list_submission', $this);
         }
     }
 }