Dec 18th, 2011, 8:34 AM
So I've forsaken working with submission_preparser and added the following code to the hooks manager on the ft_update_submission, start
$result returns 1, and still the database doesn't update when I check from phpmyadmin or from the form tools fontend
Code:
global $g_table_prefix;
$form_id = 1;
$submission_info = ft_get_submission_info($form_id, $submission_id);
if (($_POST["Status"]=="Active") && ($submission_info["status"]=="Inactive"))
{
$result = mysql_query("UPDATE {$g_table_prefix}form_{$form_id} SET transitions = 1 WHERE submission_id = $submission_id");
echo $result;
}
$result returns 1, and still the database doesn't update when I check from phpmyadmin or from the form tools fontend