SHOW:
|
|
- or go back to the newest paste.
1 | // fire the action for all forms | |
2 | - | add_action( 'gform_post_submission', 'my_remove_entries' ), 10, 2 ); |
2 | + | add_action( 'gform_after_submission', 'my_remove_entries' ), 10, 2 ); |
3 | ||
4 | // to only fire the action for a specific form, replace the "2" with the ID of your form | |
5 | - | // add_action( 'gform_post_submission_2', 'my_remove_entries' ), 10, 2 ); |
5 | + | // add_action( 'gform_post_submission_2', 'my_remove_entries', 10, 2 ); |
6 | ||
7 | function my_remove_entries( $entry, $form ) { | |
8 | ||
9 | global $wpdb; | |
10 | ||
11 | $lead_id = $entry['id']; | |
12 | $lead_table = RGFormsModel::get_lead_table_name(); | |
13 | $lead_notes_table = RGFormsModel::get_lead_notes_table_name(); | |
14 | $lead_detail_table = RGFormsModel::get_lead_details_table_name(); | |
15 | $lead_detail_long_table = RGFormsModel::get_lead_details_long_table_name(); | |
16 | ||
17 | // Delete from detail long | |
18 | $sql = $wpdb->prepare( " DELETE FROM $lead_detail_long_table | |
19 | WHERE lead_detail_id IN( | |
20 | SELECT id FROM $lead_detail_table WHERE lead_id=%d | |
21 | )", $lead_id ); | |
22 | $wpdb->query( $sql ); | |
23 | ||
24 | // Delete from lead details | |
25 | $sql = $wpdb->prepare( "DELETE FROM $lead_detail_table WHERE lead_id=%d", $lead_id ); | |
26 | $wpdb->query( $sql ); | |
27 | ||
28 | // Delete from lead notes | |
29 | $sql = $wpdb->prepare( "DELETE FROM $lead_notes_table WHERE lead_id=%d", $lead_id ); | |
30 | $wpdb->query( $sql ); | |
31 | ||
32 | // Delete from lead | |
33 | $sql = $wpdb->prepare( "DELETE FROM $lead_table WHERE id=%d", $lead_id ); | |
34 | $wpdb->query( $sql ); | |
35 | ||
36 | } |