/** * Delete all GravityView-generated entry notes * @since 1.15 * @return void */ private function delete_entry_notes() { global $wpdb; $notes_table = class_exists('GFFormsModel') ? GFFormsModel::get_lead_notes_table_name() : $wpdb->prefix . 'rg_lead_notes'; $disapproved = __('Disapproved the Entry for GravityView', 'gravityview'); $approved = __('Approved the Entry for GravityView', 'gravityview'); $sql = $wpdb->prepare("\n\t\t\tDELETE FROM {$notes_table}\n WHERE (\n `note_type` = 'gravityview' OR\n\t\t\t\t`value` = %s OR\n\t\t\t\t`value` = %s\n );\n ", $approved, $disapproved); $wpdb->query($sql); }
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); }
/** * Get a single note by note ID * * @since 1.17 * * @param int $note_id The ID of the note in the `{prefix}_rg_lead_notes` table * * @return object|bool False if not found; note object otherwise. */ public static function get_note($note_id) { global $wpdb; $notes_table = GFFormsModel::get_lead_notes_table_name(); $results = $wpdb->get_results($wpdb->prepare(" SELECT n.id, n.user_id, n.date_created, n.value, n.note_type, ifnull(u.display_name,n.user_name) as user_name, u.user_email\n\t FROM {$notes_table} n\n\t LEFT OUTER JOIN {$wpdb->users} u ON n.user_id = u.id\n\t WHERE n.id=%d", $note_id)); return $results ? $results[0] : false; }