[Plugin: Contact Form 7 to Database Extension] Database entries

kbarlow have you find any solution on this? I am looking for the same

hello again michael, i was able to try the code you provided, and i was able to save the attachment in the temp dir and store only the link in the database. unfortunately, when i received the test email sent by cf7, there was no attachment. my question is, does the filtering in function.php (for cf2db extension) happen before cf7 sends the form to the recipient email? (thus, attachment gets deleted before it is sent)
– cf7 form
– form is filled and processed
– cf2db gets data and puts these to db
– cf7 sends form to recipient

is this the reason why no attachment was sent?

thanks!

ok, thanks for the quick reply! i’ll look into other possible solutions. and share any progress.

thanks again

thanks, my first step had something similar. i think i hit a snag where the table/database of cf7todb adds a link of the attachment (a link to the database “blob”) to the value of the form-attachment field. i am trying another way, am i correct to think that if i can keep the filename (like, “upload.pdf”) without the link part, the database will also not save the blob part? i think saving the attachment part is ok (through commenting out some codes in cf7), the hard part is ‘detaching’ the blob from “wp_cf7dbplugin_submits” without deleting it before it gets sent by cf7 =)

hi michael, here is the code i added to my function.php (after i comment out the lines in cf7 code, prev):

function cfdbFilter($formData){
    $formName='Dummy form';
    $uploaddir='http://localhost/smc/wp/wp-content/uploads/wpcf7_uploads'; // note: modify htaccess of "wpcf7_uploads"
    if($formData && $formName == $formData->title){
        $formData->posted_data['form-attachment']=$uploaddir.'/'.$formData->posted_data['form-file'];
        unset($formData->posted_data['form-file']);
        unset($formData->uploaded_files['form-file']);
    }
    return $formData;
}
add_filter('cfdb_form_data','cfdbFilter');

a different approach:
also, i looked at the code of both plugins, trying to see where the ‘write to db’ happens (and also the ‘send’, in the case of cf7). and as with the previous instructions, i commented out code in cf7 and i also tried to comment out this part of “CF7DBPlugin.php”:

if ($filePath) {
    /*$content = file_get_contents($filePath);
    $wpdb->query($wpdb->prepare($parametrizedFileQuery,
                                $content,
                                $time,
                                $title,
                                $nameClean,
                                $valueClean));*/
}

(lines 520 to 528)

and

if (!in_array($field, $foundUploadFiles) && $filePath) {
    /*$fileName = basename($filePath);
    $wpdb->query($wpdb->prepare($parametrizedQuery,
                                $time,
                                $title,
                                $field,
                                $fileName,
                                $order++));
    $content = file_get_contents($filePath);
    $wpdb->query($wpdb->prepare($parametrizedFileQuery,
                                $content,
                                $time,
                                $title,
                                $field,
                                $fileName));*/
}

(lines 536 to 551)

finally, for the filter in function.php, i just added the path to “form-file” and did not unset anything.

the result is my desired effect, except of course, it is “ugly” since it tinkers directly with the code of both plugins. i was able to save the attachment from the cf7 form in the filesystem, save the path (and not the file itself) to the cfdb table, and also receive the attachment in the test email.