PHP RGFormsModel::get_lead_details_table_name方法代码示例

function get_makerfaire_status_counts($form_id)
{
    global $wpdb;
    $lead_details_table_name = RGFormsModel::get_lead_details_table_name();
    $sql = $wpdb->prepare("SELECT count(0) as entries,value as label FROM {$lead_details_table_name}\n\t\t\t      join wp_rg_lead lead \n                                    on  lead.id = {$lead_details_table_name}.lead_id and \n                                        lead.status = 'active'\n                        where field_number='303'\n\t\t\tand {$lead_details_table_name}.form_id=%d\n\t\t\tgroup by value", $form_id);
    $results = $wpdb->get_results($sql, ARRAY_A);
    return $results;
}

 private static function fix_checkbox_value()
 {
     global $wpdb;
     $table_name = RGFormsModel::get_lead_details_table_name();
     $sql = "select * from {$table_name} where value= '!'";
     $results = $wpdb->get_results($sql);
     foreach ($results as $result) {
         $form = RGFormsModel::get_form_meta($result->form_id);
         $field = RGFormsModel::get_field($form, $result->field_number);
         if ($field->type == 'checkbox') {
             $input = GFCommon::get_input($field, $result->field_number);
             $wpdb->update($table_name, array('value' => $input['label']), array('id' => $result->id));
         }
     }
 }

 public function delete_signature($lead_id, $field_id)
 {
     global $wpdb;
     $lead = RGFormsModel::get_lead($lead_id);
     $this->delete_signature_file(rgar($lead, $field_id));
     $lead_detail_table = RGFormsModel::get_lead_details_table_name();
     $sql = $wpdb->prepare("UPDATE {$lead_detail_table} SET value = '' WHERE lead_id=%d AND field_number BETWEEN %s AND %s", $lead_id, doubleval($field_id) - 0.001, doubleval($field_id) + 0.001);
     return $wpdb->query($sql);
 }

 /**
  * get_lead_detail_long_value
  * 
  * Helper to get the 'long value' for a specific entry field
  * 
  * @param	int			$lead_id	Entry ID
  * @param	int			$field_id	Field ID
  * @return	string		$results	Value from 'long value' gforms table
  * @access 	public
  * @author	Ben Moody
  */
 private function get_lead_detail_long_value($lead_id = NULL, $field_id = NULL)
 {
     //Init vars
     global $wpdb;
     $lead_detail_id = NULL;
     $results = NULL;
     if (isset($lead_id, $field_id)) {
         $lead_details_table_name = RGFormsModel::get_lead_details_table_name();
         $lead_details_long_table_name = RGFormsModel::get_lead_details_long_table_name();
         $lead_detail_id = $wpdb->get_results("SELECT lead_detail_id FROM {$lead_details_table_name} d\n\t        \t INNER JOIN {$lead_details_long_table_name} l ON d.id = l.lead_detail_id\n\t        \t WHERE lead_id = {$lead_id} AND field_number = {$field_id}");
         if (isset($lead_detail_id[0]->lead_detail_id)) {
             $lead_detail_id = $lead_detail_id[0]->lead_detail_id;
             $results = $wpdb->get_results("SELECT {$lead_details_long_table_name}.value FROM {$lead_details_long_table_name}\n\t\t        \t WHERE lead_detail_id = {$lead_detail_id}");
         }
         if (isset($results[0]->value)) {
             $results = maybe_unserialize($results[0]->value);
         }
     }
     return $results;
 }

 public function detachFormEntry($lead_id)
 {
     $entries = $this->getFormEntryIds();
     Cart66Common::log('[' . basename(__FILE__) . ' - line ' . __LINE__ . "] Start to detach gravity forms: " . print_r($entries, true));
     if (in_array($lead_id, $entries)) {
         Cart66Common::log('[' . basename(__FILE__) . ' - line ' . __LINE__ . "] Lead id is in the list of entries: " . $lead_id);
         if (class_exists('RGForms')) {
             if (!class_exists('RGFormsModel')) {
                 RGForms::init();
             }
             if (class_exists('RGFormsModel')) {
                 global $wpdb;
                 $lead_table = RGFormsModel::get_lead_table_name();
                 $lead_notes_table = RGFormsModel::get_lead_notes_table_name();
                 $lead_detail_table = RGFormsModel::get_lead_details_table_name();
                 $lead_detail_long_table = RGFormsModel::get_lead_details_long_table_name();
                 //Delete from detail long
                 $sql = $wpdb->prepare(" DELETE FROM {$lead_detail_long_table}\n                                  WHERE lead_detail_id IN(\n                                      SELECT id FROM {$lead_detail_table} WHERE lead_id=%d\n                                  )", $lead_id);
                 $wpdb->query($sql);
                 //Delete from lead details
                 $sql = $wpdb->prepare("DELETE FROM {$lead_detail_table} WHERE lead_id=%d", $lead_id);
                 $wpdb->query($sql);
                 //Delete from lead notes
                 $sql = $wpdb->prepare("DELETE FROM {$lead_notes_table} WHERE lead_id=%d", $lead_id);
                 $wpdb->query($sql);
                 //Delete from lead
                 $sql = $wpdb->prepare("DELETE FROM {$lead_table} WHERE id=%d", $lead_id);
                 $wpdb->query($sql);
                 // Remove entry from array
                 $entries = array_values(array_diff($entries, array($lead_id)));
                 $this->_formEntryIds = $entries;
                 $qty = $this->getQuantity();
                 $this->setQuantity($qty - 1);
             }
         }
     }
 }

 /**
  * define map field value
  *
  * @since
  */
 public function rtlib_defined_map_field_value()
 {
     $form_id = $_REQUEST['map_form_id'];
     if (isset($_REQUEST['mapSourceType']) && 'gravity' == $_REQUEST['mapSourceType']) {
         $field_id = intval($_REQUEST['field_id']);
         $tableName = RGFormsModel::get_lead_details_table_name();
         global $wpdb;
         $result = $wpdb->get_results($wpdb->prepare("select distinct value from {$tableName} where form_id= %d and field_number = %d ", $form_id, $field_id));
     } else {
         $field_id = $_REQUEST['field_id'];
         $csv = new parseCSV();
         $csv->auto($form_id);
         $result = array();
         $field_id = str_replace('-s-', ' ', $field_id);
         foreach ($csv->data as $cdt) {
             $tmpArr = array('value' => $cdt[$field_id]);
             if (!in_array($tmpArr, $result)) {
                 $result[] = $tmpArr;
             }
             if (count($result) > 15) {
                 break;
             }
         }
     }
     header('Content-Type: application/json');
     if (count($result) < 15) {
         echo json_encode($result);
     } else {
         echo json_encode(array());
     }
     die(0);
 }

 /**
  * update_gforms_entry_meta
  * 
  * Updates form entry data to show api video uploads in entries view
  * 
  * @access 	private
  * @author	Ben Moody
  */
 private function update_gforms_entry_meta($field_values = array())
 {
     //Init vars
     global $wpdb;
     $lead_details_table_name = NULL;
     $lead_details_long_table_name = NULL;
     $entry_id = NULL;
     $results = NULL;
     if (!empty($field_values) && isset($this->data['gforms_entry']['id'])) {
         //Cache entry data provided from gravity forms
         $entry_id = $this->data['gforms_entry']['id'];
         //Allow devs to hook before we get the gravity form table names ect
         do_action('prso_gform_youtube_uploader_pre_update_meta', $field_values, $this->data);
         //Get gravity forms table names
         $lead_details_table_name = RGFormsModel::get_lead_details_table_name();
         $lead_details_long_table_name = RGFormsModel::get_lead_details_long_table_name();
         //Loop the array of field values and update the gravity forms meta for each field
         foreach ($field_values as $field_id => $value) {
             //Get the lead detail id required to find the our value in gforms meta table
             $results = $wpdb->get_results("SELECT lead_detail_id FROM {$lead_details_table_name} d\n\t\t        \t INNER JOIN {$lead_details_long_table_name} l ON d.id = l.lead_detail_id\n\t\t        \t WHERE lead_id = {$entry_id} AND field_number = {$field_id}");
             //Update the gforms meta values with our new data including the video api data
             if (isset($results[0]->lead_detail_id)) {
                 //Update upload details
                 //Serialize array
                 $value = maybe_serialize($value);
                 //As gforms only looks at details long table if value maxs out the std table
                 //Update std table before long table - value will be truncated by mysql
                 //No probs as it will be stored ok in long table next
                 $wpdb->query($wpdb->prepare("UPDATE {$lead_details_table_name} SET value = %s \n\t\t\t        \t\t WHERE id = %d", $value, $results[0]->lead_detail_id));
                 $wpdb->query($wpdb->prepare("UPDATE {$lead_details_long_table_name} SET value = %s \n\t\t\t        \t\t WHERE lead_detail_id = %d", $value, $results[0]->lead_detail_id));
             }
         }
     }
 }

 public function gform_post_submission($entry, $form)
 {
     global $wpdb;
     $this->options['entries'] = apply_filters($this->name . '_entries', $this->options['entries'], $form);
     if (!$this->options['entries'] || $this->is_delete()) {
         $tables = (object) array('lead_table' => RGFormsModel::get_lead_table_name(), 'lead_notes_table' => RGFormsModel::get_lead_notes_table_name(), 'lead_detail_table' => RGFormsModel::get_lead_details_table_name(), 'lead_detail_long_table' => RGFormsModel::get_lead_details_long_table_name());
         $queries = array($wpdb->prepare("DELETE FROM {$tables->lead_detail_long_table} WHERE lead_detail_id IN (SELECT id FROM {$tables->lead_detail_table} WHERE lead_id = %d)", $entry['id']), $wpdb->prepare("DELETE FROM {$tables->lead_detail_table} WHERE lead_id = %d", $entry['id']), $wpdb->prepare("DELETE FROM {$tables->lead_notes_table} WHERE lead_id = %d", $entry['id']), $wpdb->prepare("DELETE FROM {$tables->lead_table} WHERE id = %d", $entry['id']));
         foreach ($queries as $query) {
             $wpdb->query($query);
         }
     }
     if ($this->is_delete()) {
         wp_delete_post($this->post['ID']);
     }
     // If a custom field is unique, get all the rows and combine them into one
     foreach ($form['fields'] as $field) {
         if ($field['type'] == 'post_custom_field' && isset($field['postCustomFieldUnique'])) {
             $meta = get_post_meta($this->post['ID'], $field['postCustomFieldName']);
             delete_post_meta($this->post['ID'], $field['postCustomFieldName']);
             add_post_meta($this->post['ID'], $field['postCustomFieldName'], is_array($meta) && count($meta) == 1 ? $meta[0] : $meta, true);
         }
     }
 }

 /**
  * Adapted from forms_model.php, RGFormsModel::save_lead($Form, $lead)
  * @param  array $form Form object.
  * @param  array $lead Lead object
  * @return void
  */
 public static function save_lead($form, &$lead)
 {
     global $wpdb;
     if (IS_ADMIN && !GFCommon::current_user_can_any("gravityforms_edit_entries")) {
         die(__("You don't have adequate permission to edit entries.", "gravityforms"));
     }
     $lead_detail_table = RGFormsModel::get_lead_details_table_name();
     //Inserting lead if null
     if ($lead == null) {
         global $current_user;
         $user_id = $current_user && $current_user->ID ? $current_user->ID : 'NULL';
         $lead_table = RGFormsModel::get_lead_table_name();
         $user_agent = RGFormsModel::truncate($_SERVER["HTTP_USER_AGENT"], 250);
         $currency = GFCommon::get_currency();
         $source_url = RGFormsModel::truncate(RGFormsModel::get_current_page_url(), 200);
         $wpdb->query($wpdb->prepare("INSERT INTO {$lead_table}(form_id, ip, source_url, date_created, user_agent, currency, created_by) VALUES(%d, %s, %s, utc_timestamp(), %s, %s, {$user_id})", $form["id"], RGFormsModel::get_ip(), $source_url, $user_agent, $currency));
         //reading newly created lead id
         $lead_id = $wpdb->insert_id;
         $lead = array("id" => $lead_id);
     }
     $current_fields = $wpdb->get_results($wpdb->prepare("SELECT id, field_number FROM {$lead_detail_table} WHERE lead_id=%d", $lead["id"]));
     $original_post_id = rgget("post_id", $lead);
     $total_fields = array();
     $calculation_fields = array();
     $recalculate_total = false;
     foreach ($form["fields"] as $field) {
         //Ignore fields that are marked as display only
         if (rgget("displayOnly", $field) && $field["type"] != "password") {
             continue;
         }
         //ignore pricing fields in the entry detail
         if (RG_CURRENT_VIEW == "entry" && GFCommon::is_pricing_field($field["type"])) {
             continue;
         }
         //process total field after all fields have been saved
         if ($field["type"] == "total") {
             $total_fields[] = $field;
             continue;
         }
         //only save fields that are not hidden (except on entry screen)
         if (RG_CURRENT_VIEW == "entry" || !RGFormsModel::is_field_hidden($form, $field, array(), $lead)) {
             // process calculation fields after all fields have been saved (moved after the is hidden check)
             if (GFCommon::has_field_calculation($field)) {
                 $calculation_fields[] = $field;
                 continue;
             }
             if ($field['type'] == 'post_category') {
                 $field = GFCommon::add_categories_as_choices($field, '');
             }
             if (isset($field["inputs"]) && is_array($field["inputs"])) {
                 foreach ($field["inputs"] as $input) {
                     RGFormsModel::save_input($form, $field, $lead, $current_fields, $input["id"]);
                 }
             } else {
                 RGFormsModel::save_input($form, $field, $lead, $current_fields, $field["id"]);
             }
         }
         //Refresh lead to support conditionals (not optimal but...)
         $lead = RGFormsModel::get_lead($lead['id']);
     }
     if (!empty($calculation_fields)) {
         foreach ($calculation_fields as $calculation_field) {
             if (isset($calculation_field["inputs"]) && is_array($calculation_field["inputs"])) {
                 foreach ($calculation_field["inputs"] as $input) {
                     RGFormsModel::save_input($form, $calculation_field, $lead, $current_fields, $input["id"]);
                     RGFormsModel::refresh_lead_field_value($lead["id"], $input["id"]);
                 }
             } else {
                 RGFormsModel::save_input($form, $calculation_field, $lead, $current_fields, $calculation_field["id"]);
                 RGFormsModel::refresh_lead_field_value($lead["id"], $calculation_field["id"]);
             }
         }
         RGFormsModel::refresh_product_cache($form, $lead = RGFormsModel::get_lead($lead['id']));
     }
     //saving total field as the last field of the form.
     if (!empty($total_fields)) {
         foreach ($total_fields as $total_field) {
             GFCommon::log_debug("Saving total field.");
             RGFormsModel::save_input($form, $total_field, $lead, $current_fields, $total_field["id"]);
         }
     }
 }

 function get_lead_count($form_id, $search, $star = null, $read = null, $column, $approved = false, $leads = array(), $start_date = null, $end_date = null, $limituser = false)
 {
     global $wpdb, $current_user;
     if (!is_numeric($form_id)) {
         return "";
     }
     $detail_table_name = RGFormsModel::get_lead_details_table_name();
     $lead_table_name = RGFormsModel::get_lead_table_name();
     $star_filter = $star !== null ? $wpdb->prepare("AND is_starred=%d ", $star) : "";
     $read_filter = $read !== null ? $wpdb->prepare("AND is_read=%d ", $read) : "";
     if (function_exists('gform_get_meta')) {
         $status_filter = $wpdb->prepare(" AND status=%s ", 'active');
     } else {
         $status_filter = '';
     }
     $start_date_filter = empty($start_date) ? "" : " AND datediff(date_created, '{$start_date}') >=0";
     $end_date_filter = empty($end_date) ? "" : " AND datediff(date_created, '{$end_date}') <=0";
     $search_term = "%{$search}%";
     $search_filter = empty($search) ? "" : $wpdb->prepare("AND ld.value LIKE %s", $search_term);
     $user_filter = '';
     if ($limituser) {
         get_currentuserinfo();
         if ((int) $current_user->ID !== 0 || $current_user->ID === 0 && apply_filters('kws_gf_show_entries_if_not_logged_in', apply_filters('kws_gf_treat_not_logged_in_as_user', true))) {
             if (!empty($current_user->ID)) {
                 $user_filter = $wpdb->prepare(" AND l.created_by=%d ", $current_user->ID);
             } else {
                 $user_filter = $wpdb->prepare(" AND (created_by IS NULL OR created_by=%d)", $current_user->ID);
             }
         } else {
             return false;
         }
     }
     $in_filter = "";
     if ($approved) {
         $in_filter = $wpdb->prepare("l.id IN (SELECT lead_id from {$detail_table_name} WHERE field_number BETWEEN %f AND %f) AND", $column - 0.001, $column + 0.001);
         // This will work once all the fields are converted to the meta_key after 1.6
         #$search_filter .= $wpdb->prepare(" AND m.meta_key = 'is_approved' AND m.meta_value = %s", 1);
     }
     $sql = "SELECT count(distinct l.id) FROM {$lead_table_name} as l,\n\t\t\t\t{$detail_table_name} as ld";
     #		$sql .= function_exists('gform_get_meta') ? " INNER JOIN wp_rg_lead_meta m ON l.id = m.lead_id " : ""; // After 1.6
     $sql .= "\n\t\t\t\tWHERE {$in_filter}\n\t\t\t\tl.form_id={$form_id}\n\t\t\t\tAND ld.form_id={$form_id}\n\t\t\t\tAND l.id = ld.lead_id\n\t\t\t\t{$star_filter}\n\t\t\t\t{$read_filter}\n\t\t\t\t{$status_filter}\n\t\t\t\t{$user_filter}\n\t\t\t\t{$start_date_filter}\n\t\t\t\t{$end_date_filter}\n\t\t\t\t{$search_filter}";
     return $wpdb->get_var($sql);
 }

 function process_attachments($entry, $form)
 {
     $upload_field_ids = array();
     foreach ($form['fields'] as $form_field) {
         if ($form_field->type == 'fileupload') {
             array_push($upload_field_ids, $form_field->id);
         }
     }
     //loop through upload field IDS and push contents to S3
     foreach ($upload_field_ids as $upload_field_id) {
         if (!empty($entry[$upload_field_id])) {
             // Grab the field value
             $field_value = $entry[$upload_field_id];
             // If multi-uplaod is enabled for the field, the value will be a JSON string.
             // Decode it so we can test if it's an array
             $field_value_decoded = json_decode($field_value);
             // If we have an aray, loop through it and upload each file
             // Else, just uplaod the one file.
             if (is_array($field_value_decoded)) {
                 // empty array to store new urls
                 $new_file_url = array();
                 foreach ($field_value_decoded as $attachment_url) {
                     //push file to S3 and return new url
                     $multi_file_item_url = upload_to_s3($attachment_url, $form['id']);
                     //push new url in the new url array
                     array_push($new_file_url, $multi_file_item_url);
                 }
                 //json encode the new url before updating DB
                 $new_file_url = json_encode($new_file_url);
             } else {
                 $new_file_url = upload_to_s3($field_value, $form['id']);
             }
             //gform_update_meta( $entry['id'], 'api_response', $new_file_url );
             global $wpdb;
             $lead_detail_table = RGFormsModel::get_lead_details_table_name();
             if (is_array($field_value_decoded)) {
                 $entry_detail_row = $wpdb->get_row("SELECT * FROM {$lead_detail_table} WHERE field_number = {$upload_field_id} AND lead_id = {$entry['id']} AND form_id = {$entry['form_id']}", ARRAY_A);
                 $entry_detail_id = $entry_detail_row["id"];
                 $lead_detail_long_table = RGFormsModel::get_lead_details_long_table_name();
                 $wpdb->update($lead_detail_long_table, array('value' => $new_file_url), array('lead_detail_id' => $entry_detail_id));
             } else {
                 $wpdb->update($lead_detail_table, array('value' => $new_file_url), array('field_number' => $upload_field_id, 'lead_id' => $entry['id'], 'form_id' => $entry['form_id']));
             }
         }
     }
 }

 /**
  * Save payment information to DB
  *
  * @since 1.7.9.1
  *
  * @uses  rgar()
  * @uses  GFCommon::get_currency()
  * @uses  rgpost()
  * @uses  RGFormsModel::get_lead_details_table_name()
  * @uses  wpdb->prepare()
  * @uses  wpdb->get_results()
  * @uses  RGFormsModel::get_lead_detail_id()
  * @uses  wpdb->update()
  * @uses  wpdb->insert()
  * @uses  RGFormsModel::update_lead()
  * @uses  apply_filters()
  * @uses  GFP_Stripe::get_feed()
  * @uses  gform_update_meta()
  * @uses  GFP_Stripe_Data::insert_transaction()
  *
  * @param $entry
  * @param $form
  *
  * @return void
  */
 public function gform_entry_created($entry, $form)
 {
     global $wpdb;
     $entry_id = rgar($entry, 'id');
     if (!empty(self::$transaction_response)) {
         //Current Currency
         $currency = GFCommon::get_currency();
         $transaction_id = self::$transaction_response['transaction_id'];
         $transaction_type = self::$transaction_response['transaction_type'];
         $amount = array_key_exists('amount', self::$transaction_response) ? self::$transaction_response['amount'] : null;
         $payment_date = gmdate('Y-m-d H:i:s');
         $entry['currency'] = $currency;
         if ('1' == $transaction_type) {
             $entry['payment_status'] = 'Approved';
         } else {
             $entry['payment_status'] = 'Active';
         }
         $entry['payment_amount'] = $amount;
         $entry['payment_date'] = $payment_date;
         $entry['transaction_id'] = $transaction_id;
         $entry['transaction_type'] = $transaction_type;
         $entry['is_fulfilled'] = true;
         //save card type since it gets stripped
         $form_id = $entry['form_id'];
         foreach ($form['fields'] as $field) {
             if ('creditcard' == $field['type']) {
                 $creditcard_field_id = $field['id'];
             }
         }
         $card_type_name = "input_" . $creditcard_field_id . "_4";
         $card_type_id = $creditcard_field_id . ".4";
         $card_type_value = rgpost($card_type_name);
         $card_type_value = substr($card_type_value, 0, GFORMS_MAX_FIELD_LENGTH);
         $lead_detail_table = RGFormsModel::get_lead_details_table_name();
         $current_fields = $wpdb->get_results($wpdb->prepare("SELECT id, field_number FROM {$lead_detail_table} WHERE lead_id=%d", $entry_id));
         $lead_detail_id = RGFormsModel::get_lead_detail_id($current_fields, $card_type_id);
         if ($lead_detail_id > 0) {
             $wpdb->update($lead_detail_table, array('value' => $card_type_value), array('id' => $lead_detail_id), array("%s"), array("%d"));
         } else {
             $wpdb->insert($lead_detail_table, array('lead_id' => $entry_id, 'form_id' => $form['id'], 'field_number' => $card_type_id, 'value' => $card_type_value), array("%d", "%d", "%f", "%s"));
         }
         $entry = apply_filters('gfp_stripe_entry_created_update_lead', $entry, self::$transaction_response);
         RGFormsModel::update_lead($entry);
         //saving feed id
         $feed = self::$_this->get_feed($form);
         gform_update_meta($entry_id, 'Stripe_feed_id', $feed['id']);
         //updating form meta with current payment gateway
         gform_update_meta($entry_id, 'payment_gateway', 'stripe');
         $subscriber_id = apply_filters('gfp_stripe_entry_created_subscriber_id', '', self::$transaction_response, $entry);
         GFP_Stripe_Data::insert_transaction($entry['id'], apply_filters('gfp_stripe_entry_created_insert_transaction_type', 'payment', $transaction_type), $subscriber_id, $transaction_id, $amount);
     }
 }

 /**
  * Setup the current lead_id to update the entry
  * instead of creating a new one
  */
 function spgfle_gform_entry_id_pre_save_lead($entry_id, $form)
 {
     if (intval($entry_id) > 0) {
         return $entry_id;
     }
     if (!$form['spgfle_enableedit']) {
         return $entry_id;
     }
     $entry_id = (int) $_POST['gform_lead_id'];
     $lead = RGFormsModel::get_lead($entry_id);
     if (GFCommon::current_user_can_any('gravityforms_edit_entries') || $lead['created_by'] == wp_get_current_user()->ID) {
         /**
          * In case that GF only stores data for fields that are set
          * we have to delete the old entry data
          */
         global $wpdb;
         $lead_details_table_name = RGFormsModel::get_lead_details_table_name();
         $lead_details_long_table_name = RGFormsModel::get_lead_details_long_table_name();
         $wpdb->query($wpdb->prepare("DELETE FROM {$lead_details_table_name} WHERE lead_id = %d", $entry_id));
         //$wpdb->query( $wpdb->prepare( "DELETE FROM {$lead_details_long_table_name} WHERE lead_id = %d", $entry_id ) );
         return $entry_id;
     }
 }

    private static function fix_checkbox_value(){
        global $wpdb;

        $table_name = RGFormsModel::get_lead_details_table_name();

        $sql = "select * from $table_name where value= '!'";
        $results = $wpdb->get_results($sql);
        foreach($results as $result){
            $form = RGFormsModel::get_form_meta($result->form_id);
            $field = RGFormsModel::get_field($form, $result->field_number);
            if($field["type"] == "checkbox"){
                $input = GFCommon::get_input($field, $result->field_number);
                $wpdb->update($table_name, array("value" => $input["label"]), array("id" => $result->id));
            }
        }
    }

/**
 * Delete Gravity Forms entry specified
 * @global object $wpdb
 *@param string $lead_id, id of gravity form entry to remove
 */
function ovr_delete_gf_entry($lead_id)
{
    global $wpdb;
    // Prepare variables.
    $lead_table = RGFormsModel::get_lead_table_name();
    $lead_notes_table = RGFormsModel::get_lead_notes_table_name();
    $lead_detail_table = RGFormsModel::get_lead_details_table_name();
    $lead_detail_long_table = RGFormsModel::get_lead_details_long_table_name();
    // Delete from lead detail long.
    $sql = $wpdb->prepare("DELETE FROM {$lead_detail_long_table} WHERE lead_detail_id IN(SELECT id FROM {$lead_detail_table} WHERE lead_id = %d)", $lead_id);
    $wpdb->query($sql);
    // Delete from lead details.
    $sql = $wpdb->prepare("DELETE FROM {$lead_detail_table} WHERE lead_id = %d", $lead_id);
    $wpdb->query($sql);
    // Delete from lead notes.
    $sql = $wpdb->prepare("DELETE FROM {$lead_notes_table} WHERE lead_id = %d", $lead_id);
    $wpdb->query($sql);
    // Delete from lead.
    $sql = $wpdb->prepare("DELETE FROM {$lead_table} WHERE id = %d", $lead_id);
    $wpdb->query($sql);
    // Finally, ensure everything is deleted (like stuff from Addons).
    GFAPI::delete_entry($lead_id);
}