[bananalive]

Originally Posted by Billspaintball

Bananalive, thank you for all the time and effort that you have put into creating this really handy mod.
I have been keeping an eye on it since it was released, and it now looks like it has all the features that I need.

I have just started playing with setting up some forms on my test system and have a question.
My scenario is that I have a form that submits its output to a forum and into the database.
I want to have a link in the forum post that is submitted that links right back to the edit function for this forms result so that users can easily edit their own form results if needed.

For example the link would be something like - http://testsite/forums/misc.php?do=e...ult&id=3&fid=1
I know I could just link to the list of forms with http://testsite/forums/misc.php?do=formresults&fid=1, but I would prefer to link to the exact form.

How would I get the id= variable to include in the url when submitting?

No. The post gets created before the database entry.

Edit:

Although, if you uncheck 'Save to Database' in Edit Form

Then add the following code to Form Hook: Before Submit:

PHP Code:

    if ($complete && !$show['editing'])
    {
        $sdata = serialize($qo);
        $db->query_write("INSERT INTO " . TABLE_PREFIX . "formresults
        (fid, userid, username, time, title, output, sdata)
        VALUES ('".$form[fid]."', '".$vbulletin->userinfo['userid']."', '".$db->escape_string($vbulletin->userinfo['username'])."', ".TIMENOW.", '".$db->escape_string($threadtitle)."', '".$db->escape_string($formoutput)."', '".$db->escape_string($sdata)."')
        ");
        if ($form[submitmessage])
        {
            $errormessage = $form[submitmessage];
        }
        else
        {
            $errormessage = "Form was submitted successfully.";
        }
        
        $formoutput .= "\r\n\r\n[url]http://testsite/forums/misc.php?do=editformresult&id=" . $db->insert_id() . "&fid=" . $fid . "[/url]";
    }