· 6 years ago · Oct 27, 2019, 11:48 AM
1function contact_backup() {
2
3 global $wpdb;
4 $charset_collate = $wpdb->get_charset_collate();
5 $sql = "CREATE TABLE IF NOT EXISTS `contact_form_backup` (
6 firstname varchar(100) NOT NULL,
7 lastname varchar(100) NOT NULL,
8 email varchar(100) NOT NULL,
9 message text,
10 created_at datetime NOT NULL
11 ) $charset_collate;";
12
13 require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
14 maybe_create_table('contact_form_backup', $sql);
15
16 $form = WPCF7_ContactForm::get_current();
17 $submission = WPCF7_Submission::get_instance();
18 $field = $submission->get_posted_data();
19
20 $wpdb->insert(
21 'contact_form_backup',
22 array(
23 'firstname' => $field["firstname"],
24 'lastname' => $field["lastname"],
25 'email' => $field["email"],
26 'message' => $field["message"],
27 'created_at' => current_time('mysql')
28
29 ),
30 array(
31 '%s','%s', '%s', '%s', '%s'
32 )
33 );
34}
35add_action("wpcf7_before_send_mail", "contact_backup");