function thankyou($option, $did)
{
global $mainframe, $limitstart, $Itemid;
$my =& JFactory::getUser();
$CONFIG = new JConfig();
$database =& JFactory::getDBO();
//get the submission & form id
$database->setQuery("SELECT * FROM #__forme_data WHERE MD5(CONCAT(id,date_added)) = '" . $did . "'");
$formdata = $database->loadOBject();
if (isset($formdata->form_id)) {
//get form_id
//$database->setQuery("SELECT * FROM #__forme_data WHERE id = '$did'");
//$formdata = $database->loadObject();
//check if form has a thank you message
$database->setQuery("SELECT * FROM #__forme_forms WHERE id = '{$formdata->form_id}'");
$form = $database->loadObject();
$params = prepareParams($formdata->id);
//load fields
$database->setQuery("SELECT * FROM #__forme_fields WHERE form_id = '{$formdata->form_id}' AND published = 1");
$fields = $database->loadObjectList();
$fields = populateGlobal($fields);
foreach ($fields as $field) {
if (!isset($params[$field->name])) {
$params[$field->name] = '';
}
$form->thankyou = str_replace('{' . $field->name . '}', $params[$field->name], $form->thankyou);
$form->return_url = str_replace('{' . $field->name . '}', $params[$field->name], $form->return_url);
}
if ($form->thankyou != '') {
forme_HTML::thankyou($form, $Itemid, $did, $formdata->form_id);
} else {
//if there is a return url
if ($form->return_url != '') {
$mainframe->redirect($form->return_url, _FORME_FRONTEND_REGISTRA_SUCCESS . " ");
} else {
$mainframe->redirect(str_replace('&', '&', sefRelToAbs("index.php?option=com_forme&Itemid={$Itemid}")), _FORME_FRONTEND_REGISTRA_SUCCESS . " ");
}
}
} else {
$mainframe->redirect(str_replace('&', '&', sefRelToAbs("index.php?option=com_forme&Itemid={$Itemid}")), _FORME_FRONTEND_REGISTRA_SUCCESS . " ");
}
}
