harski111

Hi!

Thanks for the reply but it didn’t help.

I looked at my database with phpmyadmin and noticed that wp_participants_database table (that stores the records) has no column called “last_update_user”.

Table wp_participants_database_fields has a row called “last_update_user”.

Hi again!

First, I have to tell that I got this working!

I turned on debugging and it showed that fields that were defined as read only were all empty, and all other fields were correctly set.

Even if I wrote manually to the $user_data array the fields were showing empty in the log. Something was making those fields values empty.

I even tested to fill the array manually in PHP. So I knew it was filled properly and it was not empty. Still no luck.

$user_data = array(
	'action' => 'signup',
	'first_name' => 'MyName',
	'last_name' => 'MyLastName',
	etc...
	etc...
	);

I looked at the pdb_signup form and noticed that there was a hidden field that had name “action” and value “signup” (just like you’ve been telling to me), and I realized that why I don’t just put a hidden field with that same name and same value to my own CF7 form. And I did that and straight away everything started working!

I don’t know why, but somehow (atleast) in my case putting that 'action' => 'signup' to the data array was not working, but when I included that to my form as a hidden field, it started working. So it leaves little bit a mystery what was making it work like that, but I’m very happy that I got this working and now I can continue with the code!

Thank you one more time, I really appreciate your help!

Hi!

I looked at the plugin code and found that Participants_Db::write_participant method calls the function process_form( $post, $action, $participant_id = false, $column_names = false ) function.

And that function has following statement:

/**
* readonly field data is prevented from being saved by unauthorized users 
* when not using the signup form
*/
if (  
   $field->is_readonly() && 
   ! $field->is_hidden_field() && 
   self::current_user_has_plugin_role( 'editor', 'readonly access' ) === false && 
   self::apply_filters( 'post_action_override', filter_input( INPUT_POST, 'action', FILTER_SANITIZE_STRING ) ) !== 'signup'
   ) {
      $post[$column->name] = '';
   }

So if I understand correctly, because of filter_input() I would need to be sending the ‘action’ => ‘signup’ using HTML-form, and now the function doesn’t get it from the $user_data array.

My knowledge is limited to this point, I don’t know if there is a trick or something that I could send the 'action' => 'signup' variable using HTML-form (INPUT_POST) without actually using the HTML-form. Maybe that would be possible with some tricky PHP-coding?

I was thinking of another solution that I will look at next, I will remove all the “readonly” attributes from my fields, and then with some filtering I will try to manualy add the “readonly” attributes only to my front-end [pdb_record] form.

I wouldn’t like to make filters like this because they might cause me troubles in the future, but at this seems to be the only option for me, if I want to add records manually. Other option would be adding the records manually to my SQL-database, but I don’t want to do that either.

Still I didn’t understand… Sorry.

So I’m using the write_participant method to save data that is given to the form created by Contact Form 7 plugin. I now that I could use the “signup” form by Participants Database plugin, but my form includes many fields that I don’t need to have added to the database. That’s why I’d like to do it this way.

Here’s my code, it is executed after form is submitted from Contact Form 7, and I can get the data that is send from the form.

add_action( 'wpcf7_mail_sent', 'add_to_PDB' ); 

function add_to_PDB( $contact_form ) {
    $title = $contact_form->title;
    $submission = WPCF7_Submission::get_instance();

    if ( $submission ) {
		if ( $title == "Test101" ) {
			$data = $submission->get_posted_data();
			
			$user_data = array(
				'first_name' => $data['firstname'],
				'last_name' => $data['lastname'],
				'address' => $data['address'],
				'zip' => $data['zip'],
				'city' => $data['city'],
				'phone' => $data['phone'],
				'email' => $data['email']
				);
				
			Participants_Db::write_participant( $user_data );
			
		}
    }
	
	return $contact_form;
}

Is it so simple that I add new item “action” with value “signup” to the $user_data array? Don’t believe it works like that..

I have to say that I highly appreceiate the support that you are giving! And also the plugin documentation is one of the best that I have seen! Unfortunatelly I didn’t find much documentation for this Participants_Db::write_participant method though, maybe you could provide some? I think many people would find that helpful!

Now I got it working!

Correct action was “pdb-list_admin_with_selected_approve” so there was one hyphen that needed to be changed to underscore. Now it works as it should!

Hi!

Actually the action you provided doesn’t seem to be working.

I also tried ‘pdb-admin_list_with_selected_approve’ (that is formatted same way as all other actions in the plugin), but no luck.
Also tried add_filter instead of add_action.

Can’t find anything from Google or plugin files that might help…

I got this solved.

“Disabled” attribute doesn’t send value to the server, I should use “readonly” attribute. With readonly it works! This was little bit too obvious answer 😀