$formtype = DB_getItem($_TABLES['nxform_fields'], 'field_values', "formid='{$form_id}' AND field_name='formtype'"); $taskid = intval($taskid); $dup_form_check = DB_getItem($_TABLES['nf_projectforms'], 'id', "created_by_taskid={$taskid} AND formtype='{$formtype}'"); if ($dup_form_check !== NULL) { //form already exists if ($mode == 'draft' and !isset($_POST['custom_handler'])) { echo COM_refresh($form_return_url); } else { echo COM_refresh($_CONF['site_url'] . '/nexflow/index.php' . $optReturnVars); } exit; } DB_query("INSERT INTO {$_TABLES['nf_projectforms']} (formtype,created_by_taskid) VALUES ('{$formtype}', '{$taskid}');"); $project_formid = DB_insertID(); if ($newform == 1) { nexform_dbupdate($form_id, $id); $result_id = $id; } else { $result_id = nexform_dbsave($form_id, $postUID); } $nfclass = new nexflow($processid, $postUID); /* Update the hit or results counter */ DB_query("UPDATE {$_TABLES['nxform_definitions']} SET responses = responses + 1 WHERE id='{$form_id}'"); $newproject = false; if ($processid > 0 and $taskid > 0) { $project_id = $nfclass->get_ProcessVariable('PID'); } // Create new project tracking record if project does not yet exist if ($project_id < 1 or DB_count($_TABLES['nf_projects'], 'id', $project_id) == 0) { $processid = intval($processid); DB_query("INSERT INTO {$_TABLES['nf_projects']} (originator_uid,wf_process_id,wf_task_id,status)\r\n VALUES ('{$postUID}','{$processid}','{$taskid}','1') ");
DB_query("UPDATE {$_TABLES['nxform_definitions']} SET responses = responses + 1 WHERE id='{$form_id}'"); $completion_msg = DB_getItem($_TABLES['nxform_definitions'], 'after_post_text', "id={$form_id}"); if ($completion_msg == '') { echo COM_refresh($returnURL . '?msg=1&plugin=nexform'); } else { echo COM_refresh($CONF_FE['public_url'] . "/complete.php?id={$form_id}"); } exit; } elseif ($_POST['formhandler'] == 'email+dbsave') { /* Save results to Database */ $newform = COM_applyFilter($_REQUEST['newform'], true); /* Save results to Database */ if ($newform == 1) { //this form was already saved by the file uploader ajax $result_id = COM_applyFilter($_REQUEST['res_id'], true); nexform_dbupdate($form_id, $result_id); } else { nexform_dbsave($form_id); } /* Send results via email */ nexform_emailresults(); /* Update the hit or results counter */ DB_query("UPDATE {$_TABLES['nxform_definitions']} SET responses = responses + 1 WHERE id='{$form_id}'"); $completion_msg = DB_getItem($_TABLES['nxform_definitions'], 'after_post_text', "id={$form_id}"); if ($completion_msg == '') { echo COM_refresh($returnURL . '?msg=1&plugin=nexform'); } else { echo COM_refresh($CONF_FE['public_url'] . "/complete.php?id={$form_id}"); } exit; } else {