Hi @dailymay,
Could you please try the following Snippet and see whether it helps:
<?php
add_filter( 'forminator_custom_form_submit_errors', function( $submit_errors, $form_id, $field_data_array ) {
// Add your form IDs here.
$form_ids = array( 361 );
// Change this to the message that you want to show.
$message = 'You cannot submit more than 5 times within 30 days.';
if ( in_array( intval( $form_id ), $form_ids, true ) ) {
$user_ip = Forminator_Geo::get_user_ip();
if ( ! empty( $user_ip ) ) {
$last_entry = wpmudev_get_last_few_entries( $form_id, $user_ip );
if ( ! empty( $last_entry ) ) {
$entry = Forminator_API::get_entry( $form_id, $last_entry );
$current_time = strtotime( date( 'Y-m-d H:i:s' ) );
$future_time = strtotime( '+30 days', strtotime( $entry->date_created_sql ) );
if ( $current_time < $future_time ) {
$submit_errors[]['submit'] = $message;
}
}
}
}
return $submit_errors;
},15,3);
function wpmudev_get_last_few_entries( $form_id, $user_ip ){
global $wpdb;
$table_name = Forminator_Database_Tables::get_table_name( Forminator_Database_Tables::FORM_ENTRY_META );
$entry_table_name = Forminator_Database_Tables::get_table_name( Forminator_Database_Tables::FORM_ENTRY );
$sql = "SELECT m.<code>entry_id</code> FROM {$table_name} m LEFT JOIN {$entry_table_name} e ON(e.<code>entry_id</code> = m.<code>entry_id</code>) WHERE e.<code>form_id</code> = %d AND m.<code>meta_key</code> = %s AND m.<code>meta_value</code> = %s order by m.<code>meta_id</code> desc limit 4,5";
$entry_id = $wpdb->get_var( $wpdb->prepare( $sql, $form_id, '_forminator_user_ip', $user_ip ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
if ( $entry_id ) {
return $entry_id;
}
return false;
}
Please make sure to update the line:
$form_ids = array( 361 );
To your Form ID, ie suppose your form ID is 123, the above line will change to:
$form_ids = array( 123 );
Since its 30days, if you are looking to test it out quickly you can change the value +30 days in the following line:
$future_time = strtotime( '+30 days', strtotime( $entry->date_created_sql ) );
To +30 mins, so that you could test it out to see whether it works in limiting the submission within 30 mins:
$future_time = strtotime( '+30 mins', strtotime( $entry->date_created_sql ) );
The above code can be added as a mu-plugins. Please check this link on how to implement the above code as a mu-plugins:
https://wpmudev.com/docs/using-wordpress/installing-wordpress-plugins/#installing-mu-plugins
Kind Regards,
Nithin
