The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/global.php(841) : eval()'d code 40 errorHandler->error
/global.php 841 eval
/printthread.php 16 require_once
Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 909 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 5024 errorHandler->error
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions.php 5044 is_member
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1370 fetch_forum_permissions
/printthread.php 76 forum_permissions
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error



Form Tools
Submission History Module - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Submission History Module (/showthread.php?tid=1429)

Submission History Module - alexh - Jun 30th, 2011

So I think the Submission History module is pretty darn useful (and cool).

I do have a question though..

Where is that data stored? I was thinking about pulling the "Last Modified by" name out and printing it on a page. For example, I am going to be using formtools for employees to post press releases on our website, and the php page I created pulls the data out from each submission and prints it on the page.. but it would be nice to put a "Last Updated by: John Doe" at the bottom.

Is this do-able? I guess I just need to know where the data is stored.

-Alex

RE: Submission History Module - Ben - Jul 11th, 2011

Hi Alex,

Sorry for not getting back to you!

The Submission History table works by making and maintaining a copy of your submissions form, with a few extra fields in it. If your form ID was 5 (and your DB prefix ft_), your main submission table would be called ft_form_5 and the history table would be ft_form_5_history.

Unlike the main submissions table, the history tables logs multiple records for each submission. Each record logs a particular change to a submission. So that's where your history data is stashed.

If I were you, I'd take a look at the module's functions and see if there's anything in there you can re-use. This function in the /modules/submission_history/global/code/code.php file looks especially promising!

Code:
$info = sh_get_last_submission_history_row($form_id, $submission_id);

- Ben


RE: Submission History Module - alexh - Jul 29th, 2011

Thanks Ben! Once I get all my other bugs worked out, I'll see what I can do with this!

Thanks,
Alex

RE: Submission History Module - Hannes - Jul 31st, 2011

Hello Ben,

for me the Submission History Module is unfortunately not working in a freshly installed 2.1.0-beta-20110730.
The tables exist in the database but whenever I start the module I get the message:
Code:
Notice: Undefined index: sh___history_id in C:\apache\htdocs\formtools\modules\submission_history\global\code\code.php on line 725
When clicking "Create History Tables" there is no reaction.

When viewing a submission I can see the blue history box which is showing:
Code:
There is no history logged for this submission.

Hope you have a solution for this.

Have a nice sunday.
Hannes

RE: Submission History Module - Ben - Jul 31st, 2011

Huh! Good to know, I'll check it out!

Thanks, Hannes! Smile

- Ben

RE: Submission History Module - Ben - Jul 31st, 2011

Hi Hannes,

Mind trying upgrading to the latest version of the module (1.1.1)?

Should be fixed now.

- Ben

RE: Submission History Module - Hannes - Aug 1st, 2011

(Jul 31st, 2011, 1:37 PM)Ben Wrote: Hi Hannes,

Mind trying upgrading to the latest version of the module (1.1.1)?

Should be fixed now.

- Ben

Yep, it's fixed and working perfectly now. Thanks a lot for the fast upgrade.