View difference between Paste ID: quvsvGHJ and p1cJ0xWM

-// fire the action for all forms
+add_action( 'gform_after_submission', 'nifty_gform_remove_entries ), 10, 2 );
-add_action( 'gform_after_submission', 'my_remove_entries' ), 10, 2 );
+ function nifty_gform_remove_entries( $entry, $form ) {
-
+
-// to only fire the action for a specific form, replace the "2" with the ID of your form
+    	    if($form["id"] == 5){
-// add_action( 'gform_post_submission_2', 'my_remove_entries', 10, 2 );
+    	    	    return;
-
+    	    }
-function my_remove_entries( $entry, $form ) {
+
-
+            global $wpdb;
-	global $wpdb;
+
-
+            $lead_id                = $entry['id'];
-	$lead_id                = $entry['id'];
+            $lead_table             = RGFormsModel::get_lead_table_name();
-	$lead_table             = RGFormsModel::get_lead_table_name();
+            $lead_notes_table       = RGFormsModel::get_lead_notes_table_name();
-	$lead_notes_table       = RGFormsModel::get_lead_notes_table_name();
+            $lead_detail_table      = RGFormsModel::get_lead_details_table_name();
-	$lead_detail_table      = RGFormsModel::get_lead_details_table_name();
+            $lead_detail_long_table = RGFormsModel::get_lead_details_long_table_name();
-	$lead_detail_long_table = RGFormsModel::get_lead_details_long_table_name();
+
-
+            // Delete from detail long
-	// Delete from detail long
+            $sql = $wpdb->prepare( " DELETE FROM $lead_detail_long_table
-	$sql = $wpdb->prepare( " DELETE FROM $lead_detail_long_table
+                                                            WHERE lead_detail_id IN(
-							WHERE lead_detail_id IN(
+                                                            SELECT id FROM $lead_detail_table WHERE lead_id=%d
-							SELECT id FROM $lead_detail_table WHERE lead_id=%d
+                                                            )", $lead_id );
-							)", $lead_id );
+            $wpdb->query( $sql );
-	$wpdb->query( $sql );
+
-
+           // Remove file uploads
-	// Delete from lead details
+           $sql = $wpdb->prepare("SELECT value FROM $lead_detail_table WHERE lead_id=%d", $lead_id );
-	$sql = $wpdb->prepare( "DELETE FROM $lead_detail_table WHERE lead_id=%d", $lead_id );
+           $results = $wpdb->get_results($sql, ARRAY_A ) or die(mysql_error());
-	$wpdb->query( $sql );
+            foreach ($results as $check_value_for_file) {
-
+            	$file_url = parse_url($check_value_for_file['value']);
-	// Delete from lead notes
+        	$file_path = $file_url['path'];
-	$sql = $wpdb->prepare( "DELETE FROM $lead_notes_table WHERE lead_id=%d", $lead_id );
+        	$upload_dir = wp_upload_dir();
-	$wpdb->query( $sql );
+        	$file_location = realpath($upload_dir['basedir']. "/../../").$file_path;
-
+           	if (file_exists($file_location)) {
-	// Delete from lead
+           		unlink($file_location);
-	$sql = $wpdb->prepare( "DELETE FROM $lead_table WHERE 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 );
 
     }