public static function is_valid_table($table_name)
{
global $wpdb;
$tables = array(GFFormsModel::get_form_table_name(), GFFormsModel::get_form_view_table_name(), GFFormsModel::get_meta_table_name(), GFFormsModel::get_lead_table_name(), GFFormsModel::get_lead_notes_table_name(), GFFormsModel::get_lead_details_table_name(), GFFormsModel::get_lead_details_long_table_name(), GFFormsModel::get_lead_meta_table_name(), GFFormsModel::get_incomplete_submissions_table_name(), "{$wpdb->prefix}gf_addon_feed", "{$wpdb->prefix}gf_addon_payment_transaction", "{$wpdb->prefix}gf_addon_payment_callback");
return in_array($table_name, $tables);
}
private static function fix_leading_and_trailing_spaces()
{
global $wpdb;
$meta_table_name = GFFormsModel::get_meta_table_name();
$lead_details_table = GFFormsModel::get_lead_details_table_name();
$lead_details_long_table = GFFormsModel::get_lead_details_long_table_name();
$result = $wpdb->query("UPDATE {$lead_details_table} SET value = TRIM(value)");
$result = $wpdb->query("UPDATE {$lead_details_long_table} SET value = TRIM(value)");
$results = $wpdb->get_results("SELECT form_id, display_meta, confirmations, notifications FROM {$meta_table_name}", ARRAY_A);
foreach ($results as &$result) {
$form_id = $result['form_id'];
$form = GFFormsModel::unserialize($result['display_meta']);
$form_updated = false;
$form = GFFormsModel::trim_form_meta_values($form, $form_updated);
if ($form_updated) {
GFFormsModel::update_form_meta($form_id, $form);
}
$confirmations = GFFormsModel::unserialize($result['confirmations']);
$confirmations_updated = false;
$confirmations = GFFormsModel::trim_conditional_logic_values($confirmations, $form, $confirmations_updated);
if ($confirmations_updated) {
GFFormsModel::update_form_meta($form_id, $confirmations, 'confirmations');
}
$notifications = GFFormsModel::unserialize($result['notifications']);
$notifications_updated = false;
$notifications = GFFormsModel::trim_conditional_logic_values($notifications, $form, $notifications_updated);
if ($notifications_updated) {
GFFormsModel::update_form_meta($form_id, $notifications, 'notifications');
}
}
return $results;
}
private static function fix_leading_and_trailing_spaces()
{
global $wpdb;
$meta_table_name = GFFormsModel::get_meta_table_name();
$lead_details_table = GFFormsModel::get_lead_details_table_name();
$lead_details_long_table = GFFormsModel::get_lead_details_long_table_name();
//fast but doesn't allow for the gform_trim_input_value filter
//$result = $wpdb->query("UPDATE $lead_details_table SET value = TRIM(value)");
//$result = $wpdb->query("UPDATE $lead_details_long_table SET value = TRIM(value)");
$results = $wpdb->get_results("SELECT form_id, display_meta FROM {$meta_table_name}", ARRAY_A);
foreach ($results as &$result) {
$form_id = $result["form_id"];
$form = GFFormsModel::unserialize($result["display_meta"]);
$form_updated = false;
if (isset($form["fields"]) && is_array($form["fields"])) {
$fields_to_update = array();
foreach ($form["fields"] as &$field) {
$trim_value = apply_filters("gform_trim_input_value", true, $form_id, $field);
if (!$trim_value) {
continue;
}
if (isset($field["label"]) && $field["label"] != trim($field["label"])) {
$field["label"] = trim($field["label"]);
$form_updated = true;
}
if (isset($field["choices"]) && is_array($field["choices"])) {
foreach ($field["choices"] as &$choice) {
if (isset($choice["text"]) && $choice["text"] != trim($choice["text"])) {
$choice["text"] = trim($choice["text"]);
$form_updated = true;
}
if (isset($choice["value"]) && $choice["value"] != trim($choice["value"])) {
$choice["value"] = trim($choice["value"]);
$form_updated = true;
}
}
}
if (isset($field["inputs"]) && is_array($field["inputs"])) {
foreach ($field["inputs"] as &$input) {
if (isset($input["label"]) && $input["label"] != trim($input["label"])) {
$input["label"] = trim($input["label"]);
$form_updated = true;
}
}
}
$field_id = (int) $field["id"];
$field_number_min = $field_id - 0.001;
$field_number_max = $field_id + 0.999;
$fields_to_update[] = sprintf("field_number BETWEEN %s AND %s", $field_number_min, $field_number_max);
}
if (!empty($fields_to_update)) {
$fields_to_update_str = join(" OR ", $fields_to_update);
//slow - may cause timeouts on sites with high volume of entries
$result = $wpdb->query("UPDATE {$lead_details_table} SET value = TRIM(value) WHERE form_id = {$form_id} AND ({$fields_to_update_str})");
$result = $wpdb->query("UPDATE {$lead_details_long_table} SET value = TRIM(value) WHERE lead_detail_id IN (SELECT id FROM {$lead_details_table} WHERE form_id = {$form_id} AND ({$fields_to_update_str}))");
}
}
if ($form_updated) {
GFFormsModel::update_form_meta($form_id, $form);
}
}
return $results;
}
