[bananalive]

Originally Posted by riskofficer

Hello, bananalive!

My base already has more then 400 entries, each entry has more then 10 columns, some cells could have a lot of chars, so excel export prepare file for 30 seconds now. Could you please give an option to turn off live export, but prepare export file by schedule?

Question 2. For example I had one of the option in drop-down menu named EG1, now i want to rename it to EG1-1 (EG1 -- is incorrect name), how to mass change it in base field which are already filled with wrong name?

Question 3. How to add "edit" link to thread post by easyform?

Question 4. If I delete one question for example "date", and there are a lot of answers on this question, will easyforms delete everything from base? Or it will affect only on new answers? And if so, how to delete all answers with question?

Thank you!

1. I'm not sure what you mean? (In v4.2.0 I'm adding option to export by last X results which would decrease time taken to export your results)

2. It would only affect new answers. You would have to manual edit each result and change it or use phpmyadmin and do a mysql replace() query

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

3. 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]"; 
    } 


4. No if you delete a field it will not affect results already submitted, but it will remove the column from the form results table