web256

Can I suggest a great anti-virus scanner? Imunify.

this has been resolved or it was only my issue.

hi Hector

can you please help ??

i am not able to find the .current class.

thank you

hi Hector

i couldn’t find the class.

i am happy to wait for the next release !!

thanks

I see, maybe with CSS ??

Thank you

thanks we have achieved it following the suggestion and we came up with this code where client_id is the user ID column of the form.

require_once(ABSPATH.'wp-includes/pluggable.php');

$current_user = wp_get_current_user();
$u_ID = $current_user->ID;

$exp->export($atts['{$tableValue}'], array('filter' => "client_id=$u_ID", 'limit' => '1'));

while ($row = $exp->nextRow()) {
    extract($row);

}

echo "sid=".$submit_time;

global $wpdb;

$wpdb->get_results("
DELETE submits
FROM <code>cf7dbplugin_submits</code> AS submits
    INNER JOIN (
        SELECT
              submit_time
            , client_id
        FROM (
            SELECT
                  submit_time
                , MAX(CASE WHEN field_name = 'client_id' THEN field_value END) AS client_id
            FROM <code>cf7dbplugin_submits</code>
            GROUP BY submit_time
        ) AS submit_pivot, (SELECT @rank := 0) AS variable
        WHERE client_id = '".$u_ID."' AND submit_time <> '".$submit_time."'
        ORDER BY client_id, submit_time DESC
    ) AS old_questions
        ON submits.submit_time = old_questions.submit_time
");

Hi Micheal, how would you go to build a query to delete all records with the same username or userID, except for the last one?

Thanks for your reply, Micheal, it looks good !!

I’ll update this thread with my code, once I have it working.

hi Micheal

I am a web developer and I am confident I can insert the data behind an SQL request and a jQuery manipulation.

How to find the best way for sending the data via a custom or already existing JS function?

I would like to have a button called “Save to database” that triggers that function.

As I mentioned before, I can retrieve the data and populate the form.

Thank you

hi Creatix

I am interested in this topic as i want to develop a hack for CFDB that can pre-populate fields in the form.

have you ever tried to do this?

thank you

Micheal

you are right, the scope is that users can exit (via a “save & exit” button) then come back (login) and the data from the DB will repopulate the answers in the form.

No cookies involved.

Please let me know where can i start from to address this scope.

Thanks

Mauro

Thanks Michael, I appreciate your help.

Where can I ask for a quote?

Thanks

hi Michael,

i haven’t received any help yet, could you please let me know where to go from here?

my form is a very long sequence of multiple choice questions.

i would like to have a save progress button!

that’s why i thought i could achieve this by submitting on every click of the Next button via PHP and JS.

thanks