| \n \n | \n\n \n \n {{$page_name}} \n\n {{error_message}}\n\n \n\n | \n
{$comments}
\n{/if}', '', 'input.cf_password {\r\n width: 120px;\r\n}', ''),
(4, 'no', 'yes', '{$LANG.text_non_deletable_fields}', NULL, '{$LANG.word_dropdown}', 'dropdown', 1, 'no', 'no', 'select', 11, 4, '1char,2chars,tiny,small,medium,large', 'smarty', 'core', 'FormTools\\FieldTypes::displayFieldTypeDropdown', '{strip}{if $contents != ""}\n {foreach from=$contents.options item=curr_group_info name=group}\n {assign var=options value=$curr_group_info.options}\n {foreach from=$options item=option name=row}\n {if $VALUE == $option.option_value}{$option.option_name}{/if}\n {/foreach}\n {/foreach}\n{/if}{/strip}', '{if $contents == ""}\n \n {$LANG.phrase_not_assigned_to_option_list}\n
\n{else}\n \n{/if}\n{if $comments}\n {$comments}
\n{/if}', '', '', ''),
(5, 'no', 'yes', '{$LANG.text_non_deletable_fields}', NULL, '{$LANG.phrase_multi_select_dropdown}', 'multi_select_dropdown', 1, 'no', 'no', 'multi-select', 13, 5, '1char,2chars,tiny,small,medium,large', 'php', 'core', 'FormTools\\FieldTypes::displayFieldTypeMultiSelectDropdown', '{if $contents != ""}\n {assign var=vals value="`$g_multi_val_delimiter`"|explode:$VALUE}\n {assign var=is_first value=true}\n {strip}\n {foreach from=$contents.options item=curr_group_info name=group}\n {assign var=options value=$curr_group_info.options}\n {foreach from=$options item=option name=row}\n {if $option.option_value|in_array:$vals}\n {if $is_first == false}, {/if}\n {$option.option_name}\n {assign var=is_first value=false}\n {/if}\n {/foreach}\n {/foreach}\n {/strip}\n{/if}', '{if $contents == ""}\n {$LANG.phrase_not_assigned_to_option_list}
\n{else}\n {assign var=vals value="`$g_multi_val_delimiter`"|explode:$VALUE}\n \n{/if}\n\n{if $comments}\n {$comments}
\n{/if}', '', '', ''),
(6, 'no', 'yes', '{$LANG.text_non_deletable_fields}', NULL, '{$LANG.phrase_radio_buttons}', 'radio_buttons', 1, 'no', 'no', 'radio-buttons', 16, 6, '1char,2chars,tiny,small,medium,large', 'php', 'core', 'FormTools\\FieldTypes::displayFieldTypeRadios', '{strip}{if $contents != ""}\n {foreach from=$contents.options item=curr_group_info name=group}\n {assign var=options value=$curr_group_info.options}\n {foreach from=$options item=option name=row}\n {if $VALUE == $option.option_value}{$option.option_name}{/if}\n {/foreach}\n {/foreach}\n{/if}{/strip}', '{if $contents == ""}\n {$LANG.phrase_not_assigned_to_option_list}
\n{else}\n {assign var=is_in_columns value=false}\n {if $formatting == "cf_option_list_2cols" || \n $formatting == "cf_option_list_3cols" || \n $formatting == "cf_option_list_4cols"}\n {assign var=is_in_columns value=true}\n {/if}\n\n {assign var=counter value="1"}\n {foreach from=$contents.options item=curr_group_info name=group}\n {assign var=group_info value=$curr_group_info.group_info}\n {assign var=options value=$curr_group_info.options}\n {if array_key_exists("group_name", $group_info) && !empty($group_info["group_name"])}\n {$group_info.group_name}
\n {/if}\n {if $is_in_columns}{/if}\n \n {foreach from=$options item=option name=row}\n {if $is_in_columns}
{/if}\n \n {assign var=counter value=$counter+1}\n {/foreach}\n \n {if $is_in_columns}
{/if}\n {/foreach}\n {if $comments}{/if}\n \n \n {if $is_in_columns}
{/if}\n {if $formatting == "vertical"}{/if}\n \n {assign var=counter value=$counter+1}\n {/foreach}\n \n {if $is_in_columns}
{$comments}
{/if}\n{/if}', '', '/* All CSS styles for this field type are found in Shared Resources */', ''),
(7, 'no', 'yes', '{$LANG.text_non_deletable_fields}', NULL, '{$LANG.word_checkboxes}', 'checkboxes', 1, 'no', 'no', 'checkboxes', 19, 7, '1char,2chars,tiny,small,medium,large', 'php', 'core', 'FormTools\\FieldTypes::displayFieldTypeCheckboxes', '{strip}{if $contents != ""}\n {assign var=vals value="`$g_multi_val_delimiter`"|explode:$VALUE}\n {assign var=is_first value=true}\n {strip}\n {foreach from=$contents.options item=curr_group_info name=group}\n {assign var=options value=$curr_group_info.options}\n {foreach from=$options item=option name=row}\n {if $option.option_value|in_array:$vals}\n {if $is_first == false}, {/if}\n {$option.option_name}\n {assign var=is_first value=false}\n {/if}\n {/foreach}\n {/foreach}\n {/strip}\n{/if}{/strip}', '{if $contents == ""}\n {$LANG.phrase_not_assigned_to_option_list}
\n{else}\n {assign var=vals value="`$g_multi_val_delimiter`"|explode:$VALUE}\n {assign var=is_in_columns value=false}\n {if $formatting == "cf_option_list_2cols" || \n $formatting == "cf_option_list_3cols" ||\n $formatting == "cf_option_list_4cols"}\n {assign var=is_in_columns value=true}\n {/if}\n \n {assign var=counter value="1"}\n {foreach from=$contents.options item=curr_group_info name=group}\n {assign var=group_info value=$curr_group_info.group_info}\n {assign var=options value=$curr_group_info.options}\n \n {if array_key_exists("group_name", $group_info) && !empty($group_info["group_name"])}\n {$group_info.group_name}
\n {/if}\n {if $is_in_columns}{/if}\n \n {foreach from=$options item=option name=row}\n {if $is_in_columns}
{/if}\n \n {assign var=counter value=$counter+1}\n {/foreach}\n \n {if $is_in_columns}
{/if}\n {/foreach}\n\n {if $comments}\n {/if}\n \n \n {if $is_in_columns}
{/if}\n {if $formatting == "vertical"}{/if}\n \n {assign var=counter value=$counter+1}\n {/foreach}\n \n {if $is_in_columns}
{$comments}
\n {/if}\n{/if}', '', '/* all CSS is found in Shared Resources */', ''),
(8, 'no', 'yes', '{$LANG.text_non_deletable_fields}', NULL, '{$LANG.word_date}', 'date', 2, 'no', 'yes', '', NULL, 1, 'small', 'php', 'core', 'FormTools\\FieldTypes::displayFieldTypeDate', '{strip}\n{if $VALUE}\n {assign var=tzo value=0}\n {if $apply_timezone_offset == "yes"}\n {assign var=tzo value=$ACCOUNT_INFO.timezone_offset}\n {/if}\n {if $display_format == "yy-mm-dd" || !$display_format}\n {$VALUE|custom_format_date:$tzo:"Y-m-d"}\n {elseif $display_format == "dd/mm/yy"}\n {$VALUE|custom_format_date:$tzo:"d/m/Y"}\n {elseif $display_format == "mm/dd/yy"}\n {$VALUE|custom_format_date:$tzo:"m/d/Y"}\n {elseif $display_format == "M d, yy"}\n {$VALUE|custom_format_date:$tzo:"M j, Y"}\n {elseif $display_format == "MM d, yy"}\n {$VALUE|custom_format_date:$tzo:"F j, Y"}\n {elseif $display_format == "D M d, yy"}\n {$VALUE|custom_format_date:$tzo:"D M j, Y"}\n {elseif $display_format == "DD, MM d, yy"}\n {$VALUE|custom_format_date:$tzo:"l M j, Y"}\n {elseif $display_format == "dd. mm. yy"}\n {$VALUE|custom_format_date:$tzo:"d. m. Y"}\n {elseif $display_format == "datetime:dd/mm/yy|h:mm TT|ampm`true"}\n {$VALUE|custom_format_date:$tzo:"d/m/Y g:i A"}\n {elseif $display_format == "datetime:mm/dd/yy|h:mm TT|ampm`true"}\n {$VALUE|custom_format_date:$tzo:"m/d/Y g:i A"}\n {elseif $display_format == "datetime:yy-mm-dd|h:mm TT|ampm`true"}\n {$VALUE|custom_format_date:$tzo:"Y-m-d g:i A"}\n {elseif $display_format == "datetime:yy-mm-dd|hh:mm"}\n {$VALUE|custom_format_date:$tzo:"Y-m-d H:i"}\n {elseif $display_format == "datetime:yy-mm-dd|hh:mm:ss|showSecond`true"}\n {$VALUE|custom_format_date:$tzo:"Y-m-d H:i:s"}\n {elseif $display_format == "datetime:dd. mm. yy|hh:mm"}\n {$VALUE|custom_format_date:$tzo:"d. m. Y H:i"}\n {/if}\n{/if}\n{/strip}', '{assign var=class value="cf_datepicker"}\n{if $display_format|strpos:"datetime" === 0}\n {assign var=class value="cf_datetimepicker"}\n{/if}\n\n{assign var="val" value=""}\n{if $VALUE}\n {assign var=tzo value=""}\n {if $apply_timezone_offset == "yes"}\n {assign var=tzo value=$ACCOUNT_INFO.timezone_offset}\n {/if}\n {if $display_format == "yy-mm-dd"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"Y-m-d"}\n {elseif $display_format == "dd/mm/yy"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"d/m/Y"}\n {elseif $display_format == "mm/dd/yy"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"m/d/Y"}\n {elseif $display_format == "M d, yy"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"M j, Y"}\n {elseif $display_format == "MM d, yy"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"F j, Y"}\n {elseif $display_format == "D M d, yy"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"D M j, Y"}\n {elseif $display_format == "DD, MM d, yy"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"l M j, Y"}\n {elseif $display_format == "dd. mm. yy"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"d. m. Y"}\n {elseif $display_format == "datetime:dd/mm/yy|h:mm TT|ampm`true"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"d/m/Y g:i A"}\n {elseif $display_format == "datetime:mm/dd/yy|h:mm TT|ampm`true"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"m/d/Y g:i A"}\n {elseif $display_format == "datetime:yy-mm-dd|h:mm TT|ampm`true"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"Y-m-d g:i A"}\n {elseif $display_format == "datetime:yy-mm-dd|hh:mm"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"Y-m-d H:i"}\n {elseif $display_format == "datetime:yy-mm-dd|hh:mm:ss|showSecond`true"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"Y-m-d H:i:s"}\n {elseif $display_format == "datetime:dd. mm. yy|hh:mm"}\n {assign var=val value=$VALUE|custom_format_date:$tzo:"d. m. Y H:i"}\n {/if}\n{/if}\n\n\n 
\n \n {if $comments}\n
', '$field_name = $vars["field_info"]["field_name"];\n$date = $vars["data"][$field_name];\n$display_format = $vars["settings"]["display_format"];\n$atzo = $vars["settings"]["apply_timezone_offset"];\n$account_info = isset($vars["account_info"]) ? $vars["account_info"] : array();\n\nif (empty($date)) {\n $value = "";\n} else { \n if (strpos($display_format, "datetime:") === 0) {\n $parts = explode(" ", $date);\n switch ($display_format) {\n case "datetime:dd/mm/yy|h:mm TT|ampm`true":\n $date = substr($date, 3, 2) . "/" . substr($date, 0, 2) . "/" . substr($date, 6);\n break;\n case "datetime:dd. mm. yy|hh:mm":\n $date = substr($date, 4, 2) . "/" . substr($date, 0, 2) . "/" . substr($date, 8, 4) . " " . substr($date, 14);\n break;\n }\n } else {\n if ($display_format == "dd/mm/yy") {\n $date = substr($date, 3, 2) . "/" . substr($date, 0, 2) . "/" . substr($date, 6);\n } else if ($display_format == "dd. mm. yy") {\n $parts = explode(" ", $date);\n $date = trim($parts[1], ".") . "/" . trim($parts[0], ".") . "/" . trim($parts[2], ".");\n }\n }\n $time = strtotime($date);\n \n // lastly, if this field has a timezone offset being applied to it, do the\n // appropriate math on the date\n if ($atzo == "yes" && !isset($account_info["timezone_offset"])) {\n $seconds_offset = $account_info["timezone_offset"] * 60 * 60;\n $time += $seconds_offset;\n }\n $value = date("Y-m-d H:i:s", $time);\n}', '.cf_datepicker {\n width: 160px;\n}\n.cf_datetimepicker {\n width: 160px;\n}\n.ui-datepicker-trigger {\n cursor: pointer;\n}', '$(function() {\n // the datetimepicker has a bug that prevents the icon from appearing. So\n // instead, we add the image manually into the page and assign the open event\n // handler to the image\n var default_settings = {\n changeYear: true,\n changeMonth: true\n }\n $(".cf_datepicker").each(function() {\n var field_name = $(this).attr("name");\n var settings = default_settings;\n if ($("#" + field_name + "_id").length) {\n settings.dateFormat = $("#" + field_name + "_format").val();\n }\n $(this).datepicker(settings);\n $("#" + field_name + "_icon_id").bind("click", { field_id: "#" + field_name + "_id" }, function(e) {\n $.datepicker._showDatepicker($(e.data.field_id)[0]);\n });\n });\n \n $(".cf_datetimepicker").each(function() {\n var field_name = $(this).attr("name");\n var settings = default_settings;\n\n if ($("#" + field_name + "_id").length) {\n var settings_str = $("#" + field_name + "_format").val();\n settings_str = settings_str.replace(/datetime:/, "");\n var settings_list = settings_str.split("|");\n var settings = {};\n settings.dateFormat = settings_list[0];\n settings.timeFormat = settings_list[1];\n for (var i=2; i\n \n {if $comments}\n {$comments}
\n {/if}\n{$comments}
\n {/if}\n', '', '.cf_timepicker {\n width: 60px;\n}\n.ui-timepicker-div .ui-widget-header {\n margin-bottom: 8px;\n}\n.ui-timepicker-div dl {\n text-align: left;\n}\n.ui-timepicker-div dl dt {\n height: 25px;\n}\n.ui-timepicker-div dl dd {\n margin: -25px 0 10px 65px;\n}\n.ui-timepicker-div td {\n font-size: 90%;\n}', '$(function() {\n var default_settings = {\n buttonImage: g.root_url + "/global/images/clock.png",\n showOn: "both",\n buttonImageOnly: true\n }\n $(".cf_timepicker").each(function() {\n var field_name = $(this).attr("name");\n var settings = default_settings;\n if ($("#" + field_name + "_id").length) {\n var settings_list = $("#" + field_name + "_id").val().split("|");\n if (settings_list.length > 0) {\n settings.timeFormat = settings_list[0];\n for (var i=1; i\n \n
\n\n\n\n{if $comments}\n {$comments}
\n{/if}', '', '.cf_view_markup_field {\n margin: 0px;\n}\n.cf_code_view .CodeMirror {\n background-color: transparent;\n height: auto;\n}\n.cf_code_view .CodeMirror-scroll {\n max-height: 300px;\n}\n.cf_code_view .CodeMirror-cursor { \n display: none !important;\n}', 'var cf_code = {};\ncf_code.check_required = function() {\n var errors = [];\n for (var i=0; i{$filenames|@count} {$LANG.word_files|lower}
\n{/if}\n{elseif $CONTEXTPAGE == ''edit_submission''}\n - \n {foreach from=$filenames item=filename}\n
- \n {$filename}\n \n {/foreach}\n
\n \n\n
\n\n{if $comments}\n - \n
- \n \n {$LANG.word_file}\n \n {foreach from=$filenames item=filename}\n
- \n \n {$filename}\n {if $num_files == 1 && $multiple_files == "no"}\n \n {/if}\n \n {/foreach}\n
{$comments}
\n{/if}', '', '.cf_file_list {\n display: none;\n list-style-type: none;\n padding: 0;\n margin: 0;\n}\n.ft_file_multiple.cf_file_list {\n margin-bottom: 4px;\n}\n.cf_file_list_view {\n list-style-type: none;\n padding: 0;\n margin: 0;\n}\n.cf_file_list_view.cf_file_list_horizontal li {\n display: inline-block;\n}\n.cf_file.cf_file_has_items .cf_file_list {\n display: block;\n}\n.cf_file_top_row {\n border-bottom: 1px solid #dddddd;\n display: none;\n}\n.cf_file.cf_file_has_items.cf_file_multiple .cf_file_top_row,\n.cf_file.cf_file_has_multiple_items .cf_file_top_row {\n display: block;\n}\n.cf_file_col {\n font-style: italic;\n color: #999999;\n}\n.cf_file_row_cb {\n display: none;\n}\n.cf_file.cf_file_has_items.cf_file_multiple .cf_file_row_cb,\n.cf_file.cf_file_has_multiple_items .cf_file_row_cb {\n display: inline-block;\n}\n.cf_file_num_files {\n color: #444444;\n}', '/* all JS for this module is found in /modules/field_type_file/scripts/edit_submission.js */'),
(13, 'no', 'yes', 'This module can only be edited via the tinyMCE module.', 7, '{$LANG.word_wysiwyg}', 'tinymce', 2, 'no', 'no', 'textarea', NULL, 5, 'large,very_large', 'smarty', 'core', '', '{if $CONTEXTPAGE == "edit_submission"}\n {$VALUE}\n{elseif $CONTEXTPAGE == "submission_listing"}\n {$VALUE|strip_tags}\n{else}\n {$VALUE|nl2br}\n{/if}', '\n\n{if $comments}\n {$comments}
\n{/if}', '', 'body .mce-ico {\n font-size: 13px;\n}\nbody .mce-btn button {\n padding: 3px 5px 3px 7px;\n}', '// this is populated by each tinyMCE WYWISYG with their settings on page load\nvar cf_tinymce_settings = {};\n\n$(function() {\n $(''textarea.cf_tinymce'').each(function() {\n var field_name = $(this).attr("name");\n var settings = cf_tinymce_settings[field_name];\n settings.selector = "#" + $(this).attr("id");\n tinymce.init(settings);\n });\n});\n\ncf_tinymce_settings.check_required = function() {\n var errors = [];\n for (var i=0; i{$export_type_smarty_template}
\n\n', 1),
(2, 'Excel', 'public', 'all', NULL, 'show', 'xls.gif', 'new_window', 'Generate', 'text', NULL, NULL, 'Pragma: public\nCache-Control: max-age=0\nContent-Type: application/vnd.ms-excel; charset=utf-8\nContent-Disposition: attachment; filename={$filename}', '\n\n\n\n\n{$export_type_smarty_template}\n\n\n', 2),
(3, 'XML', 'public', 'all', NULL, 'hide', 'xml.jpg', 'new_window', 'Generate', 'text', NULL, NULL, 'Content-type: application/xml; charset="octet-stream"\r\nContent-Disposition: attachment; filename={$filename}', '\r\n\r\n{$export_type_smarty_template}', 3),
(4, 'CSV', 'public', 'all', NULL, 'hide', 'csv.gif', 'new_window', 'Generate', 'text', NULL, NULL, 'Content-type: text/csv;\r\nContent-Disposition: attachment; filename={$filename}', '{$export_type_smarty_template}', 4);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]module_export_group_clients`
--
CREATE TABLE `[[dbprefix]]module_export_group_clients` (
`export_group_id` mediumint(8) unsigned NOT NULL,
`account_id` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`export_group_id`,`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]module_export_types`
--
CREATE TABLE `[[dbprefix]]module_export_types` (
`export_type_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`export_type_name` varchar(255) NOT NULL,
`export_type_visibility` enum('show','hide') NOT NULL DEFAULT 'show',
`filename` varchar(255) NOT NULL,
`export_group_id` smallint(6) DEFAULT NULL,
`smarty_template` text NOT NULL,
`list_order` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`export_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `[[dbprefix]]module_export_types`
--
INSERT INTO `[[dbprefix]]module_export_types` VALUES
(1, 'Table format', 'show', 'submissions-{$M}.{$j}.html', 1, '{$form_name} - {$view_name}
\n\n| {$column.field_title} | \n {/foreach}\n
|---|
| \n {smart_display_field form_id=$form_id view_id=$view_id submission_id=$submission_id\n field_info=$field_info field_types=$field_types settings=$settings value=$value}\n | \n {/foreach}\n
{$form_name} - {$view_name}
\n\n{strip}\n{foreach from=$submissions item=submission}\n {assign var=submission_id value=$submission.submission_id}\n| {$field_info.field_title} | \n\n {smart_display_field form_id=$form_id view_id=$view_id submission_id=$submission_id field_info=$field_info\n field_types=$field_types settings=$settings value=$value}\n | \n
|---|
{$form_name} - {$view_name}
\n\n{foreach from=$submissions item=submission name=row}\n {assign var=submission_id value=$submission.submission_id}\n| {$field_info.field_title} | \n\n {smart_display_field form_id=$form_id view_id=$view_id submission_id=$submission_id field_info=$field_info\n field_types=$field_types settings=$settings value=$value}\n | \n
|---|
- {$L.phrase_new_page} -
\n \n {/if}\n{/foreach}', 3), (4, 'Table format', 'show', 'submissions-{$M}.{$j}.xls', 2, '
{$form_name} - {$view_name}
\n\n| {$column.field_title} | \n {/foreach}\n
|---|
| \n {smart_display_field form_id=$form_id view_id=$view_id submission_id=$submission_id\n field_info=$field_info field_types=$field_types settings=$settings value=$value escape="excel"}\n | \n {/foreach}\n
\n
\n
\n {{$form_name}}
\n\n
', 2),
(3, 1, 'header', 'No Header', '\n\n\n{{$form_name}} \n {{$required_resources}}\n {{$R.styles}}\n\n\n{{$form_name}} \n \n {{$required_resources}}\n {{$R.styles}}\n\n\n
\n
\n\n\n', 4),
(5, 1, 'form_page', 'Form Page', '{{navigation}}\n\n\n
\n', 3),
(4, 1, 'footer', 'Footer', '
\n {{$page_name}}
\n\n{{error_message}}\n\n', 5), (6, 1, 'review_page', 'Review Page', '{{navigation}}\n\n{{$review_page_title}}
\n\n\n', 6), (7, 1, 'thankyou_page', 'Thankyou Page', '{{navigation}}\n\n{{$thankyou_page_content}}', 7), (8, 1, 'form_offline_page', 'Form Offline Page', '{{$form_offline_page_content}}', 8), (9, 1, 'continue_block', 'Continue - Button Only', '', 9), (10, 1, 'continue_block', 'Continue - Detailed', '\n \n This is page {{$current_page}} of {{$num_pages}}. You must complete \n all steps in order for your submission to be processed. Please click continue.\n
\n\n', 10),
(11, 1, 'navigation', 'Navigation', '', 11),
(12, 1, 'navigation', 'Navigation - Numbered', '', 12),
(13, 1, 'navigation', 'No Navigation', '', 13),
(14, 1, 'error_message', 'Error Message', '{{if $validation_error}}\n {{$validation_error}}
\n{{/if}}', 14),
(15, 2, 'page_layout', 'Page Layout', '{{header}}\n{{page}}\n{{footer}}', 1),
(16, 2, 'header', 'Header', '\n\n\n \n {{$form_name}} \n {{$required_resources}}\n {{$R.styles}}\n\n\n {{$form_name}} \n {{$required_resources}}\n \n {{$R.styles}}\n\n\n \n
\n {{form_builder_edit_link}}\n
\n\n', 2),
(17, 2, 'header', 'No Header', '\n\n\n {{$form_name}}
\n\n\n', 3),
(18, 2, 'footer', 'Footer', ' \n
\n\n\n', 4),
(19, 2, 'form_page', 'Form Page', '{{navigation}}\n\n\n
\n', 5),
(20, 2, 'review_page', 'Review Page', '{{navigation}}\n\n\n\n
\n{{$page_name}}
\n\n {{error_message}}\n\n \n \n\n
\n\n', 6),
(21, 2, 'thankyou_page', 'Thankyou Page', '{{navigation}}\n\n\n\n
\n{{$review_page_title}}
\n\n \n\n\n
\n', 7),
(22, 2, 'form_offline_page', 'Form Offline Page', '\n {{$thankyou_page_content}}\n
\n\n
\n', 8),
(23, 2, 'continue_block', 'Continue - Button Only', '', 9),
(24, 2, 'continue_block', 'Continue - Detailed', '\n {{$form_offline_page_content}}\n
\n\n \n This is page {{$current_page}} of {{$num_pages}}. You must complete \n all steps in order for your submission to be processed. Please click continue.\n
\n\n', 10),
(25, 2, 'navigation', 'Navigation - Arrows', '', 11),
(26, 2, 'navigation', 'Navigation - Numbered', '', 12),
(27, 2, 'navigation', 'No Navigation', '', 13),
(28, 2, 'error_message', 'Error Message', '{{if $validation_error}}\n {{$validation_error}}
\n{{/if}}\n\n', 14),
(29, 3, 'page_layout', 'Page Layout', '{{header}}\n{{page}}\n{{footer}}', 1),
(30, 3, 'header', 'Header', '\n\n\n \n \n {{form_builder_edit_link}}\n\n
{{$form_name}}
\n \n\n', 2),
(31, 3, 'header', 'No Header', '\n\n\n {{$form_name}} \n {{$required_resources}}\n \n {{$R.styles}}\n\n\n {{$form_name}} \n {{$required_resources}}\n {{$R.styles}}\n \n\n\n {{$form_name}} \n \n {{$required_resources}}\n {{$R.styles}}\n \n \n \n\n\n
\n {{form_builder_edit_link}}\n
\n\n\n\n\n', 4),
(33, 3, 'form_page', 'Form Page', '{{navigation}}\n\n', 3),
(32, 3, 'footer', 'Footer', '\n\n
\n\n\n
\n', 5),
(34, 3, 'review_page', 'Review Page', '{{navigation}}\n\n{{$page_name}}
\n\n{{error_message}}\n\n\n \n\n\n
\n\n', 6),
(35, 3, 'thankyou_page', 'Thankyou Page', '{{navigation}}\n\n{{$review_page_title}}
\n\n\n \n\n{{$thankyou_page_content}} \n
\n', 7),
(36, 3, 'form_offline_page', 'Form Offline Page', '{{$form_offline_page_content}}', 8),
(37, 3, 'continue_block', 'Continue - Button Only', '', 9),
(38, 3, 'navigation', 'Navigation', '{{if $current_page == $num_pages}}\n\n\n\n{{else}}\n\n\n\n{{/if}}\n\n', 10),
(39, 3, 'navigation', 'Navigation - Numbered', '', 11),
(40, 3, 'error_message', 'Error Message', '{{if $validation_error}}\n {{$validation_error}}
\n{{/if}}\n\n', 12),
(41, 4, 'page_layout', 'Page Layout', '{{header}}\n{{page}}\n{{footer}}', 1),
(42, 4, 'header', 'Header', '\n\n\n \n
\n\n\n', 3),
(44, 4, 'form_page', 'Form Page', '{{navigation}}\n\n{{form_builder_edit_link}}\n\n\n', 2),
(43, 4, 'footer', 'Footer', '
\n{{$page_name}}
\n\n{{error_message}}\n\n', 4), (45, 4, 'review_page', 'Review Page', '{{navigation}}\n\n{{form_builder_edit_link}}\n\n{{$review_page_title}}
\n\n\n Please review the information below to confirm it is correct. If you need to edit any\n values, just click the EDIT link at the top right of the section.\n
\n\n\n', 5), (46, 4, 'thankyou_page', 'Thankyou Page', '{{navigation}}\n\n{{form_builder_edit_link}}\n\n{{$thankyou_page_content}}\n', 6), (47, 4, 'form_offline_page', 'Form Offline Page', '{{$form_offline_page_content}}', 7), (48, 4, 'continue_block', 'Continue - Simple', '\n \n
', 8),
(49, 4, 'continue_block', 'Continue - Detailed', '\n \n This is page {{$current_page}} of {{$num_pages}}. You must complete all steps in order for your submission to be processed. Please click continue.\n
\n', 9),
(50, 4, 'navigation', 'Navigation - 1', '', 10),
(51, 4, 'navigation', 'Navigation - 2', '', 11),
(52, 4, 'navigation', 'Navigation - 3', '', 12),
(53, 4, 'navigation', 'Navigation - None', '', 13),
(54, 4, 'error_message', 'Error Message', '{{if $validation_error}}\n {{$validation_error}}
\n{{/if}}\n', 14),
(55, 5, 'page_layout', 'Page Layout', '{{header}}\n{{page}}\n{{footer}}', 1),
(56, 5, 'header', 'Header', '\n\n\n \n {{$form_name}} \n \n {{$required_resources}}\n {{$R.styles}}\n \n \n \n \n\n\n
\n\n\n', 4),
(59, 5, 'form_page', 'Form Page', '\n {{form_builder_edit_link}}\n
\n\n', 2),
(57, 5, 'header', 'No Header', '\n\n\n {{$form_name|upper}}
\n\n {{form_builder_edit_link}}\n', 3),
(58, 5, 'footer', 'Footer', '
\n \n \n \n\n\n \n
\n
\n', 5),
(60, 5, 'review_page', 'Review Page', '\n \n
\n
\n', 6),
(61, 5, 'thankyou_page', 'Thankyou Page', '| \n \n | \n\n \n \n {{$review_page_title}} \n\n \n\n | \n
\n \n
\n
\n\n', 7),
(62, 5, 'form_offline_page', 'Form Offline Page', '| \n \n | \n\n \n {{$thankyou_page_content}} \n \n | \n
\n {{$form_offline_page_content}}\n
', 8),
(63, 5, 'continue_block', 'Continue - Button Only', '', 9),
(64, 5, 'navigation', 'Navigation', '', 10),
(65, 5, 'navigation', 'Navigation - Numbered', '', 11),
(66, 5, 'error_message', 'Error Message', '{{if $validation_error}}\n \n{{/if}}\n\n', 12);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]module_form_builder_template_sets`
--
CREATE TABLE `[[dbprefix]]module_form_builder_template_sets` (
`set_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`set_name` varchar(255) NOT NULL,
`version` varchar(20) NOT NULL,
`description` mediumtext,
`is_complete` enum('yes','no') NOT NULL,
`list_order` smallint(6) NOT NULL,
PRIMARY KEY (`set_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `[[dbprefix]]module_form_builder_template_sets`
--
INSERT INTO `[[dbprefix]]module_form_builder_template_sets` VALUES
(1, 'Default Template Set', '1.2', 'A neutral, grey-themed set of templates that lets you choose a highlight colour to match your site.', 'yes', 1),
(2, 'Conformist', '1.2', 'A clean blue Template Set with delicate CSS3 gradients and tab-like, top-row page navigation.', 'yes', 2),
(3, 'Illuminate', '1.1', 'A bold, bright-coloured theme with choice of colour set and footer content. Navigation is required and displayed as a left column. Uses the "Trykker" Google Web Font for a little extra snap!', 'yes', 3),
(4, 'ProSimple', '1.3', 'A simple, professional-looking and attractive grey-themed Template Set without a header. It contains placeholders to let you choose the highlight colour, font and font size. Labels are placed directly above the fields to provide clear identification.', 'yes', 4),
(5, 'Theme - Default', '1.1', 'A form template set based on the same styles as the default Form Tools user interface. Complete with choice of swatches!', 'yes', 5);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]module_form_builder_template_set_placeholders`
--
CREATE TABLE `[[dbprefix]]module_form_builder_template_set_placeholders` (
`placeholder_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`set_id` mediumint(9) NOT NULL,
`placeholder_label` varchar(255) NOT NULL,
`placeholder` varchar(255) NOT NULL,
`field_type` enum('textbox','textarea','password','radios','checkboxes','select','multi-select') NOT NULL,
`field_orientation` enum('horizontal','vertical','na') NOT NULL,
`default_value` varchar(255) DEFAULT NULL,
`field_order` smallint(6) NOT NULL,
PRIMARY KEY (`placeholder_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `[[dbprefix]]module_form_builder_template_set_placeholders`
--
INSERT INTO `[[dbprefix]]module_form_builder_template_set_placeholders` VALUES
(1, 1, 'Highlight Colours', 'colours', 'select', 'na', 'Blue-Grey', 1),
(2, 2, 'Title Font', 'font', 'select', 'na', 'Italianno', 1),
(3, 2, 'Title Font Size', 'font_size', 'select', 'na', '44px', 2),
(4, 3, 'Colours', 'colours', 'select', 'na', 'Orange', 1),
(5, 3, 'Footer HTML', 'footer_html', 'textarea', 'horizontal', '', 2),
(6, 4, 'Colour Palette', 'colours', 'select', 'na', 'Green', 1),
(7, 4, 'Font', 'font', 'select', 'na', 'Verdana', 2),
(8, 4, 'Font Size', 'font_size', 'select', 'na', '9pt', 3),
(9, 5, 'Swatch', 'swatch', 'select', 'na', 'Orange', 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]module_form_builder_template_set_placeholder_opts`
--
CREATE TABLE `[[dbprefix]]module_form_builder_template_set_placeholder_opts` (
`placeholder_id` mediumint(9) NOT NULL,
`option_text` varchar(255) NOT NULL,
`field_order` smallint(6) NOT NULL,
PRIMARY KEY (`placeholder_id`,`field_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]module_form_builder_template_set_placeholder_opts`
--
INSERT INTO `[[dbprefix]]module_form_builder_template_set_placeholder_opts` VALUES
(1, 'Red', 1),
(1, 'Orange', 2),
(1, 'Yellow', 3),
(1, 'Green', 4),
(1, 'Blue', 5),
(1, 'Blue-Grey', 6),
(1, 'Grey', 7),
(2, 'Aladin', 1),
(2, 'Alegreya SC', 2),
(2, 'Alike Angular', 3),
(2, 'Almendra SC', 4),
(2, 'Chango', 5),
(2, 'Fredericka the Great', 6),
(2, 'Frijole', 7),
(2, 'Gudea', 8),
(2, 'Italianno', 9),
(2, 'Jim Nightshade', 10),
(2, 'Lustria', 11),
(2, 'Miss Fajardose', 12),
(2, 'Montez', 13),
(2, 'Telex', 14),
(2, 'Yesteryear', 15),
(3, '20px', 1),
(3, '22px', 2),
(3, '24px', 3),
(3, '26px', 4),
(3, '28px', 5),
(3, '30px', 6),
(3, '32px', 7),
(3, '34px', 8),
(3, '36px', 9),
(3, '38px', 10),
(3, '40px', 11),
(3, '42px', 12),
(3, '44px', 13),
(3, '46px', 14),
(3, '48px', 15),
(3, '50px', 16),
(3, '52px', 17),
(3, '54px', 18),
(3, '56px', 19),
(3, '58px', 20),
(3, '60px', 21),
(4, 'Red', 1),
(4, 'Orange', 2),
(4, 'Green', 3),
(4, 'Blue', 4),
(4, 'Black', 5),
(4, 'Grey', 6),
(4, 'White', 7),
(6, 'Blue', 1),
(6, 'Green', 2),
(6, 'Orange', 3),
(6, 'Purple', 4),
(7, 'Arial', 1),
(7, 'Georgia, Verdana', 2),
(7, '"Lucida Grande","Lucida Sans Unicode", Tahoma, sans-serif', 3),
(7, 'Tahoma', 4),
(7, 'Verdana', 5),
(8, '8pt', 1),
(8, '9pt', 2),
(8, '10pt', 3),
(8, '11pt', 4),
(8, '12pt', 5),
(9, 'Aquamarine', 1),
(9, 'Blue', 2),
(9, 'Dark Blue', 3),
(9, 'Green', 4),
(9, 'Grey', 5),
(9, 'Light Brown', 6),
(9, 'Orange', 7),
(9, 'Purple', 8),
(9, 'Red', 9),
(9, 'Yellow', 10);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]module_form_builder_template_set_resources`
--
CREATE TABLE `[[dbprefix]]module_form_builder_template_set_resources` (
`resource_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`resource_type` enum('css','js') NOT NULL,
`template_set_id` mediumint(8) unsigned NOT NULL,
`resource_name` varchar(255) NOT NULL,
`placeholder` varchar(100) NOT NULL,
`content` mediumtext NOT NULL,
`last_updated` datetime NOT NULL,
`list_order` smallint(6) NOT NULL,
PRIMARY KEY (`resource_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `[[dbprefix]]module_form_builder_template_set_resources`
--
INSERT INTO `[[dbprefix]]module_form_builder_template_set_resources` VALUES
(1, 'css', 1, 'General Styles', 'styles', 'body {\n text-align: center;\n padding: 0px;\n margin: 0px;\n background-color: #efefef;\n}\ntd, th, p, input, textarea, select,ul,li,div, span {\n font-family: "Lucida Grande","Lucida Sans Unicode", Tahoma, sans-serif;\n font-size: 12px;\n color: #555555;\n}\ntd, th, p, textarea, ul,li, div {\n line-height: 22px;\n}\na:link, a:visited {\n color: #336699;\n}\ntable {\n empty-cells: show;\n}\n\n/* page sections */\n.ts_page:after {\n -moz-transform: translate(0pt, 0pt);\n background: none repeat scroll 0 0 transparent;\n border-radius: 20px 20px 20px 20px;\n box-shadow: 15px 0 30px rgba(0, 0, 0, 0.2);\n content: "";\n left: 0;\n position: absolute;\n width: 100%;\n z-index: -2;\n}\n.ts_page {\n margin: 40px auto;\n position: relative;\n text-align: left;\n}\n.ts_header {\n background: none repeat scroll 0 0 rgba(0, 0, 0, 0.5);\n border: 3px solid #CCCCCC;\n height: 140px;\n background: #3a3a3a; /* Old browsers */\n background: -moz-linear-gradient(45deg, #777777 0%, #999999 100%); /* FF3.6+ */\n background: -webkit-gradient(linear, left bottom, right top, color-stop(0%,#777777), color-stop(100%,#999999)); /* Chrome,Safari4+ */\n background: -webkit-linear-gradient(45deg, #777777 0%,#999999 100%); /* Chrome10+,Safari5.1+ */\n background: -o-linear-gradient(45deg, #777777 0%,#999999 100%); /* Opera 11.10+ */\n background: -ms-linear-gradient(45deg, #777777 0%,#999999 100%); /* IE10+ */\n background: linear-gradient(45deg, #777777 0%,#999999 100%); /* W3C */\n filter: progid:DXImageTransform.Microsoft.gradient( startColorstr=''#777777'', endColorstr=''#999999'',GradientType=1 ); /* IE6-9 fallback on horizontal gradient */\n box-shadow: 0 1px 12px rgba(0, 0, 0, 0.1);\n}\n.ts_header h1 {\n margin: 56px 50px;\n padding: 0px;\n font-size: 20px;\n color: white;\n}\n.ts_content {\n background-color: white;\n border: 1px solid #CCCCCC;\n box-shadow: 0 0 12px rgba(0, 0, 0, 0.1);\n padding: 25px 50px;\n}\n.ts_continue_block {\n margin-top: 16px;\n background-color: #ffffdd;\n padding: 8px;\n box-shadow:1px 2px 2px #878787;\n}\n.ts_continue_block input {\n float: right;\n}\n.ts_continue_button {\n margin-top: 12px;\n}\n.highlighted_cell {\n color: #990000;\n background-color: #ffffee;\n text-align: center;\n}\n.light_grey {\n color: #999999;\n}\nh2 {\n font-size: 24px;\n}\nh3 {\n border-top-left-radius: 4px;\n border-top-right-radius: 4px;\n -webkit-border-top-left-radius: 4px;\n -webkit-border-top-right-radius: 4px;\n -moz-border-radius-topleft: 4px;\n -moz-border-radius-topright: 4px;\n font-size: 12px;\n font-weight: normal;\n margin-bottom: 0;\n margin-right: 1px;\n padding: 1px 0 0 5px;\n width: 792px;\n height: 22px;\n}\nh3 a:link, h3 a:visited {\n background-color: white;\n -webkit-border-radius: 2px;\n -moz-border-radius: 2px;\n border-radius: 2px;\n color: black;\n float: right;\n line-height: 17px;\n margin-right: 3px;\n margin-top: 2px;\n padding: 0 8px;\n text-decoration: none;\n}\nh3 a:hover {\n -webkit-border-radius: 2px;\n -moz-border-radius: 2px;\n border-radius: 2px;\n}\n\n/* navigation */\nul#css_nav {\n clear: both;\n width:100%;\n margin: 0px;\n padding: 0px;\n overflow: hidden;\n}\nul#css_nav li {\n float: left;\n background-color: #efefef;\n -webkit-border-radius: 2px;\n -moz-border-radius: 2px;\n border-radius: 2px;\n list-style: none;\n text-align:center;\n margin: 0px 2px 20px 0px;\n color: #666666;\n font-size: 11px;\n line-height: 20px;\n}\nul#css_nav li span {\n font-size: 11px;\n line-height: 20px;\n}\n\nul#css_nav li.css_nav_current_page {\n background-color: #999999;\n color: white;\n}\nul#css_nav li a:link, ul#css_nav li a:visited {\n display: block;\n text-decoration: none;\n color: white;\n background-color: #999999;\n -webkit-border-radius: 2px;\n -moz-border-radius: 2px;\n border-radius: 2px;\n}\nul#css_nav li a:hover {\n -webkit-border-radius: 2px;\n -moz-border-radius: 2px;\n border-radius: 2px;\n}\n.nav_1_pages li {\n width: 100%;\n}\n.nav_2_pages li {\n width: 49.7%;\n}\n.nav_3_pages li {\n width: 33%;\n}\n.nav_4_pages li {\n width: 24.7%;\n}\n.nav_5_pages li {\n width: 19.7%;\n}\n.nav_6_pages li {\n width: 16.4%;\n}\n.nav_7_pages li {\n width: 14%;\n}\n.nav_8_pages li {\n width: 12.2%;\n}\n\n/* notifications */\n.notify {\n border: 1px solid #336699;\n background-color: #ffffee;\n color: #336699;\n padding: 8px;\n width: 400px;\n}\n.notify li { color: #336699; }\n.error {\n font-size: 8pt;\n border: 1px solid #cc0000;\n background-color: #ffffee;\n color: #cc0000;\n padding: 8px;\n width: 550px;\n}\n.error span {\n color: #cc0000;\n font-weight: bold;\n margin-bottom: 4px;\n}\n\n/* forms */\ntable.table_1 > tbody > tr > td {\n border-bottom: 1px solid #dddddd;\n}\n.table_1_bg td {\n padding: 1px;\n padding-left: 1px;\n background-color: #336699;\n border-bottom: 1px solid #cccccc;\n}\ntd.answer {\n background-color: #efefef;\n}\n.pad_left {\n padding-left: 4px;\n}\n.req {\n color: #aa0000;\n}\n.fb_error {\n border: 1px solid #990000;\n padding: 8px;\n background-color: #ffefef;\n}\n\n/* for the code / markup editor */\n.editor {\n background-color: white;\n border: 1px solid #999999;\n padding: 3px;\n}\n\n\n/* - - - "Highlight Colour" placeholder conditional CSS - - -*/\n{{if $P.colours == "Red"}}\nh3 {\n background-color: #cc3131;\n color: white;\n}\nul#css_nav li a:hover {\n background-color: #861e1e;\n}\nh3 a:hover {\n background-color: #fac1c1;\n color: black;\n}\n{{elseif $P.colours == "Orange"}}\nh3 {\n background-color: #ff9c00;\n color: white;\n}\nul#css_nav li a:hover {\n background-color: #4c3512;\n}\nh3 a:hover {\n background-color: #ffefd5;\n color: black;\n}\n{{elseif $P.colours == "Yellow"}}\nh3 {\n background-color: #FAEC0C;\n color: #777777;\n}\nul#css_nav li a:hover {\n background-color: #595900;\n}\nh3 a:hover {\n background-color: #444000;\n color: #ffffcc;\n}\n{{elseif $P.colours == "Green"}}\nh3 {\n background-color: #009211;\n color: white;\n}\nul#css_nav li a:hover {\n background-color: #004608;\n}\nh3 a:hover {\n background-color: #daf4dd;\n color: black;\n}\n{{elseif $P.colours == "Blue"}}\nh3 {\n background-color: #2969c9;\n color: white;\n}\nh3 a:hover {\n background-color: #a6c8f0;\n color: black;\n}\nul#css_nav li a:hover {\n background-color: #1e4580;\n}\n{{elseif $P.colours == "Grey"}}\nh3 {\n background-color: #777777;\n color: white;\n}\nul#css_nav li a:hover {\n background-color: #333333;\n}\nh3 a:hover {\n background-color: #222222;\n color: white;\n}\n{{else}}\nh3 {\n background-color: #6D8AAC;\n color: white;\n}\nul#css_nav li a:hover {\n background-color: #2e425a;\n}\nh3 a:hover {\n background-color: #c9e2ff;\n color: black;\n}\n{{/if}}\n', '[[regtime]]', 1),
(2, 'css', 2, 'General Styles', 'styles', 'html {\nheight: 100%;\n}\nbody {\nheight: 100%;\ntext-align: center;\npadding: 0px;\nmargin: 0px;\nbackground: rgb(106,147,184);\nbackground: -moz-linear-gradient(top, rgba(106,147,184,1) 0%, rgba(115,151,183,1) 100%);\nbackground: -webkit-gradient(linear, left top, left bottom, color-stop(0%,rgba(106,147,184,1)), color-stop(100%,rgba(115,151,183,1)));\nbackground: -webkit-linear-gradient(top, rgba(106,147,184,1) 0%,rgba(115,151,183,1) 100%);\nbackground: -o-linear-gradient(top, rgba(106,147,184,1) 0%,rgba(115,151,183,1) 100%);\nbackground: -ms-linear-gradient(top, rgba(106,147,184,1) 0%,rgba(115,151,183,1) 100%);\nbackground: linear-gradient(top, rgba(106,147,184,1) 0%,rgba(115,151,183,1) 100%);\nfilter: progid:DXImageTransform.Microsoft.gradient( startColorstr=''#6a93b8'', endColorstr=''#7397b7'',GradientType=0 );\nbackground-repeat: no-repeat;\nbackground-attachment: fixed;\n}\ntd, th, p, input, textarea, select,ul,li,div, span {\nfont-family: "Lucida Grande","Lucida Sans Unicode", Tahoma, sans-serif;\nfont-size: 12px;\ncolor: #555555;\n}\ntd, th, p, textarea, ul, li, div {\nline-height: 22px;\n}\na:link, a:visited {\ncolor: #336699;\n}\ntable {\nempty-cells: show;\n}\n\n/* page sections */\n.ts_page:after {\n-moz-transform: translate(0pt, 0pt);\nbackground: none repeat scroll 0 0 transparent;\nborder-radius: 20px 20px 20px 20px;\nbox-shadow: 15px 0 30px rgba(0, 0, 0, 0.2);\ncontent: "";\nleft: 0;\nposition: absolute;\nwidth: 100%;\nz-index: -2;\n}\n.ts_page {\nmargin: 40px auto;\nposition: relative;\ntext-align: left;\n}\n.ts_header h1 {\nmargin: 0px 0px 42px 20px;\npadding: 0px;\nfont-size: {{$P.font_size}};\ncolor: white;\nfont-family: "{{$P.font}}", "Lucida Grande", Arial;\nfont-weight: normal;\n}\n.ts_footer {\nbackground: rgb(64,86,107);\nbackground: -moz-linear-gradient(top, rgb(64,86,107) 0%, rgb(44,61,76) 100%);\nbackground: -webkit-gradient(linear, left top, left bottom, color-stop(0%,rgb(64,86,107)), color-stop(100%,rgb(44,61,76)));\nbackground: -webkit-linear-gradient(top, rgb(64,86,107) 0%,rgb(44,61,76) 100%);\nbackground: -o-linear-gradient(top, rgb(64,86,107) 0%,rgb(44,61,76) 100%);\nbackground: -ms-linear-gradient(top, rgb(64,86,107) 0%,rgb(44,61,76) 100%);\nbackground: linear-gradient(top, rgb(64,86,107) 0%,rgb(44,61,76) 100%);\nfilter: progid:DXImageTransform.Microsoft.gradient( startColorstr=''#40566b'', endColorstr=''#2c3d4c'',GradientType=0 );\n-webkit-border-bottom-left-radius: 6px;\n-webkit-border-bottom-right-radius: 6px;\n-moz-border-radius-bottomleft: 6px;\n-moz-border-radius-bottomright: 6px;\nborder-bottom-left-radius: 6px;\nborder-bottom-right-radius: 6px;\npadding: 10px 0px;\ntext-align: center;\ncolor: #dddddd;\nbox-shadow: 0 8px 12px rgba(0, 0, 0, 0.3);\nheight: 5px;\n}\n.ts_content {\nbackground-color: white;\nborder: 1px solid #777777;\nborder-top: 0px;\nbox-shadow: 0 8px 12px rgba(0, 0, 0, 0.3);\npadding: 25px 50px;\n}\n.ts_continue_block {\nmargin-top: 16px;\nbackground-color: #ffffdd;\npadding: 8px;\nbox-shadow: 1px 2px 2px #878787;\n}\n.ts_continue_block input {\nfloat: right;\n}\n.ts_continue_button {\nmargin-top: 12px;\n}\n.light_grey {\ncolor: #999999;\n}\nh2 {\nfont-size: 20px;\n}\n.ts_heading {\nfont-size: 20px;\n}\n\nh3 {\nborder-top-left-radius: 4px;\nborder-top-right-radius: 4px;\n-webkit-border-top-left-radius: 4px;\n-webkit-border-top-right-radius: 4px;\n-moz-border-radius-topleft: 4px;\n-moz-border-radius-topright: 4px;\nfont-size: 12px;\nfont-weight: normal;\nmargin-bottom: 0;\nmargin-right: 1px;\npadding: 1px 0 0 5px;\nwidth: 792px;\nbackground-color: #36485a;\ncolor: white;\nheight: 22px;\n}\nh3 a:link, h3 a:visited {\nbackground-color: white;\n-webkit-border-radius: 2px;\n-moz-border-radius: 2px;\nborder-radius: 2px;\ncolor: black;\nfloat: right;\nline-height: 17px;\nmargin-right: 3px;\nmargin-top: 2px;\npadding: 0 8px;\ntext-decoration: none;\n}\nh3 a:hover {\n-webkit-border-radius: 2px;\n-moz-border-radius: 2px;\nborder-radius: 2px;\n}\n\n/* navigation */\nul#css_nav {\nclear: both;\nmargin: 0px;\npadding: 0px 40px;\noverflow: hidden;\nbackground: rgb(64,86,107);\nbackground: -moz-linear-gradient(top, rgb(64,86,107) 0%, rgb(44,61,76) 100%);\nbackground: -webkit-gradient(linear, left top, left bottom, color-stop(0%,rgb(64,86,107)), color-stop(100%,rgb(44,61,76)));\nbackground: -webkit-linear-gradient(top, rgb(64,86,107) 0%,rgb(44,61,76) 100%);\nbackground: -o-linear-gradient(top, rgb(64,86,107) 0%,rgb(44,61,76) 100%);\nbackground: -ms-linear-gradient(top, rgb(64,86,107) 0%,rgb(44,61,76) 100%);\nbackground: linear-gradient(top, rgb(64,86,107) 0%,rgb(44,61,76) 100%);\nfilter: progid:DXImageTransform.Microsoft.gradient( startColorstr=''#40566b'', endColorstr=''#2c3d4c'',GradientType=0 );\n-webkit-border-top-left-radius: 6px;\n-webkit-border-top-right-radius: 6px;\n-moz-border-radius-topleft: 6px;\n-moz-border-radius-topright: 6px;\nborder-top-left-radius: 6px;\nborder-top-right-radius: 6px;\nheight: 38px;\n}\nul#css_nav li {\nfloat: left;\nlist-style: none;\ntext-align:center;\ncolor: #dddddd;\nfont-size: 11px;\npadding: 8px 0px;\n}\nul#css_nav li span {\nfont-size: 11px;\n}\n\nul#css_nav li.completed_page {\npadding: 0px;\n}\nul#css_nav li.css_nav_current_page {\nbackground: rgb(249,249,249);\nbackground: -moz-linear-gradient(top, rgba(249,249,249,1) 0%, rgba(255,255,255,1) 100%);\nbackground: -webkit-gradient(linear, left top, left bottom, color-stop(0%,rgba(249,249,249,1)), color-stop(100%,rgba(255,255,255,1)));\nbackground: -webkit-linear-gradient(top, rgba(249,249,249,1) 0%,rgba(255,255,255,1) 100%);\nbackground: -o-linear-gradient(top, rgba(249,249,249,1) 0%,rgba(255,255,255,1) 100%);\nbackground: -ms-linear-gradient(top, rgba(249,249,249,1) 0%,rgba(255,255,255,1) 100%);\nbackground: linear-gradient(top, rgba(249,249,249,1) 0%,rgba(255,255,255,1) 100%);\nfilter: progid:DXImageTransform.Microsoft.gradient( startColorstr=''#f9f9f9'', endColorstr=''#ffffff'',GradientType=0 );\ncolor: #000000;\n}\nul#css_nav li a:link, ul#css_nav li a:visited, ul#css_nav li span {\ndisplay: block;\ntext-decoration: none;\ncolor: white;\nbackground-color: #333333;\npadding: 8px 0px;\nopacity: 0.5;\nfilter: alpha(opacity=50);\n}\nul#css_nav li a:hover {\nbackground-color: #222222;\nopacity: 0.9;\nfilter: alpha(opacity=90);\n}\n\n.nav_1_pages li {\nwidth: 150px;\n}\n.nav_2_pages li {\nwidth: 150px;\n}\n.nav_3_pages li {\nwidth: 150px;\n}\n.nav_4_pages li {\nwidth: 150px;\n}\n.nav_5_pages li {\nwidth: 150px;\n}\n.nav_6_pages li {\nwidth: 136px;\n}\n.nav_7_pages li {\nwidth: 116px;\n}\n.nav_8_pages li {\nwidth: 102px;\n}\n\n\n/* notifications */\n.notify {\nborder: 1px solid #336699;\nbackground-color: #ffffee;\ncolor: #336699;\npadding: 8px;\nwidth: 400px;\n}\n.notify li { color: #336699; }\n.error {\nfont-size: 8pt;\nborder: 1px solid #cc0000;\nbackground-color: #ffffee;\ncolor: #cc0000;\npadding: 8px;\nwidth: 550px;\n}\n.error span {\ncolor: #cc0000;\nfont-weight: bold;\nmargin-bottom: 4px;\n}\n\n/* forms */\ntable.table_1 > tbody > tr > td {\nborder-bottom: 1px solid #dddddd;\n}\n.table_1_bg td {\npadding: 1px;\npadding-left: 1px;\nbackground-color: #336699;\nborder-bottom: 1px solid #cccccc;\n}\ntd.answer {\nbackground-color: #efefef;\n}\n.pad_left {\npadding-left: 4px;\n}\n.req {\ncolor: #aa0000;\n}\n.fb_error {\nborder: 1px solid #990000;\npadding: 8px;\nbackground-color: #ffefef;\n}\n\n/* for the code / markup editor */\n.editor {\nbackground-color: white;\nborder: 1px solid #999999;\npadding: 3px;\n}\n#form_builder__edit_link {\nposition: absolute;\nright: 5px;\ntop: 0px;\ntext-decoration: none;\n}\n#form_builder__edit_link:hover {\ncolor: #990000;\ntext-decoration: underline;\n}\n', '[[regtime]]', 1),
(3, 'css', 3, 'General Styles', 'styles', '{{* This top section defines the colours, based on the selected Colour placeholder *}}\n{{assign var=header_colour value="#ffffff"}}\n{{assign var=header_shadow value="on"}}\n{{if $P.colours == "Red"}}\n {{assign var=c1 value="#950000"}}\n {{assign var=c2 value="#af0a0a"}}\n {{assign var=link_colour value="#ffffcc"}}\n {{assign var=line value="#670000"}}\n {{assign var=fieldset_bg value="#780404"}}\n {{assign var=fieldset_lines value="#660909"}}\n {{assign var=fieldset_colour value="#FFFF99"}}\n {{assign var=fieldset_shadow value="on"}}\n {{assign var=font_colour value="#ffffff"}}\n {{assign var=page_heading value="#000000"}}\n {{assign var=nav_next_page value="#999999"}}\n {{assign var=nav_prev_page_text value="#999999"}}\n {{assign var=nav_prev_page_bg_over value="#D78B00"}}\n {{assign var=nav_prev_page_border value="#999999"}}\n {{assign var=submit_btn_over value="#ff3c00"}}\n {{assign var=edit_link_colour value="#ffffff"}}\n{{elseif $P.colours == "Orange"}}\n {{assign var=c1 value="#ffa500"}}\n {{assign var=c2 value="#ffb12b"}}\n {{assign var=link_colour value="#990000"}}\n {{assign var=line value="#ffc558"}}\n {{assign var=fieldset_bg value="#ef9c00"}}\n {{assign var=fieldset_lines value="#d28900"}}\n {{assign var=fieldset_colour value="#FFFF99"}}\n {{assign var=fieldset_shadow value="on"}}\n {{assign var=font_colour value="#333333"}}\n {{assign var=page_heading value="#ffffff"}}\n {{assign var=nav_next_page value="#555555"}}\n {{assign var=nav_prev_page_text value="#AF8D4F"}}\n {{assign var=nav_prev_page_bg_over value="#D78B00"}}\n {{assign var=nav_prev_page_border value="#E69500"}}\n {{assign var=submit_btn_over value="#ff3c00"}}\n {{assign var=edit_link value="#990000"}}\n{{elseif $P.colours == "Green"}}\n {{assign var=c1 value="#299a0b"}}\n {{assign var=c2 value="#31a612"}}\n {{assign var=link_colour value="#FFFF99"}}\n {{assign var=line value="#1c7e00"}}\n {{assign var=fieldset_bg value="#228a00"}}\n {{assign var=fieldset_lines value="#1e7d00"}}\n {{assign var=fieldset_colour value="#FFFF99"}}\n {{assign var=fieldset_shadow value="on"}}\n {{assign var=font_colour value="#eeeeee"}}\n {{assign var=page_heading value="#333333"}}\n {{assign var=nav_next_page value="#0f4f00"}}\n {{assign var=nav_prev_page_text value="#136600"}}\n {{assign var=nav_prev_page_bg_over value="#135205"}}\n {{assign var=nav_prev_page_border value="#1e710b"}}\n {{assign var=submit_btn_over value="#0093E8"}}\n {{assign var=edit_link value="#990000"}}\n{{elseif $P.colours == "Blue"}}\n {{assign var=c1 value="#0083cf"}}\n {{assign var=c2 value="#0690e0"}}\n {{assign var=link_colour value="#FFFF99"}}\n {{assign var=line value="#0c5e8d"}}\n {{assign var=fieldset_bg value="#0878b8"}}\n {{assign var=fieldset_lines value="#0669a2"}}\n {{assign var=fieldset_colour value="#FFFF99"}}\n {{assign var=fieldset_shadow value="on"}}\n {{assign var=font_colour value="#eeeeee"}}\n {{assign var=page_heading value="#222222"}}\n {{assign var=nav_next_page value="#333333"}}\n {{assign var=nav_prev_page_text value="#efefef"}}\n {{assign var=nav_prev_page_bg_over value="#3396e2"}}\n {{assign var=nav_prev_page_border value="#cccccc"}}\n {{assign var=submit_btn_over value="#621111"}}\n {{assign var=edit_link value="#621111"}}\n{{elseif $P.colours == "Black"}}\n {{assign var=c1 value="#222222"}}\n {{assign var=c2 value="#333333"}}\n {{assign var=link_colour value="#c8ebff"}}\n {{assign var=line value="#444444"}}\n {{assign var=fieldset_bg value="#353535"}}\n {{assign var=fieldset_lines value="#444444"}}\n {{assign var=fieldset_colour value="#c8ebff"}}\n {{assign var=fieldset_shadow value="on"}}\n {{assign var=font_colour value="#efefef"}}\n {{assign var=page_heading value="#eeeeee"}}\n {{assign var=nav_next_page value="#999999"}}\n {{assign var=nav_prev_page_text value="#3a8ab8"}}\n {{assign var=nav_prev_page_bg_over value="#3a8ab8"}}\n {{assign var=nav_prev_page_border value="#4a99c7"}}\n {{assign var=submit_btn_over value="#3a8ab8"}}\n {{assign var=edit_link value="#c8ebff"}}\n{{elseif $P.colours == "Grey"}}\n {{assign var=c1 value="#dddddd"}}\n {{assign var=c2 value="#ffffff"}}\n {{assign var=link_colour value="#0033cc"}}\n {{assign var=line value="#cccccc"}}\n {{assign var=fieldset_bg value="#f2f2f2"}}\n {{assign var=fieldset_lines value="#aaaaaa"}}\n {{assign var=fieldset_colour value="#888888"}}\n {{assign var=fieldset_shadow value="off"}}\n {{assign var=font_colour value="#333333"}}\n {{assign var=page_heading value="#555555"}}\n {{assign var=nav_next_page value="#999999"}}\n {{assign var=nav_prev_page_text value="#888888"}}\n {{assign var=nav_prev_page_bg_over value="#888888"}}\n {{assign var=nav_prev_page_border value="#888888"}}\n {{assign var=submit_btn_over value="#3a8ab8"}}\n {{assign var=edit_link value="#c8ebff"}}\n{{elseif $P.colours == "White"}}\n {{assign var=c1 value="#ffffff"}}\n {{assign var=c2 value="#ffffff"}}\n {{assign var=header_colour value="#222222"}}\n {{assign var=header_shadow value="off"}}\n {{assign var=link_colour value="#0093e8"}}\n {{assign var=line value="#000000"}}\n {{assign var=fieldset_bg value="#ffffff"}}\n {{assign var=fieldset_lines value="#000000"}}\n {{assign var=fieldset_colour value="#000000"}}\n {{assign var=fieldset_shadow value="off"}}\n {{assign var=font_colour value="#333333"}}\n {{assign var=page_heading value="#555555"}}\n {{assign var=nav_next_page value="#999999"}}\n {{assign var=nav_prev_page_text value="#888888"}}\n {{assign var=nav_prev_page_bg_over value="#888888"}}\n {{assign var=nav_prev_page_border value="#888888"}}\n {{assign var=submit_btn_over value="#0093e8"}}\n {{assign var=edit_link value="#0093e8"}}\n{{/if}}\nhtml {\n height: 100%;\n margin: 0px;\n}\nbody {\n height: 100%;\n text-align: center;\n padding: 0px;\n margin: 0px;\n background: {{$c2}}; /* Old browsers */\n background: -moz-linear-gradient(top, {{$c1}} 0%, {{$c2}} 100%); /* FF3.6+ */\n background: -webkit-gradient(linear, left top, left bottom, color-stop(0%,{{$c1}}), color-stop(100%,{{$c2}})); /* Chrome,Safari4+ */\n background: -webkit-linear-gradient(top, {{$c1}} 0%,{{$c2}} 100%); /* Chrome10+,Safari5.1+ */\n background: -o-linear-gradient(top, {{$c1}} 0%,{{$c2}} 100%); /* Opera 11.10+ */\n background: -ms-linear-gradient(top, {{$c1}} 0%,{{$c2}} 100%); /* IE10+ */\n background: linear-gradient(top, {{$c1}} 0%,{{$c2}} 100%); /* W3C */\n filter: progid:DXImageTransform.Microsoft.gradient( startColorstr=''{{$c1}}'', endColorstr=''{{$c2}}'',GradientType=0 ); /* IE6-9 */\n background-repeat: no-repeat;\n background-attachment: fixed;\n}\ntd, th, p, ul,li,div, span {\n font-family: Trykker, "Lucida Grande", Georgia, serif;\n font-size: 12px;\n color: {{$font_colour}};\n}\ninput, textarea, select {\n font-family: Trykker, "Lucida Grande", Georgia, serif;\n font-size: 12px;\n}\ntd, th, p, textarea, ul,li, div, a {\n line-height: 25px;\n}\ntable {\n empty-cells: show;\n}\n.clear {\n clear: both;\n}\na:link, a:visited {\n color: {{$link_colour}};\n text-decoration: none;\n}\na:hover {\n text-decoration: underline;\n}\ndiv.ui-dialog div, div.ui-dialog li, div.ui-dialog span {\n color: #333333;\n}\n\n/* page sections */\n.ts_page {\n margin: 40px auto;\n position: relative;\n text-align: left;\n}\n.ts_head_bg {\n height: 105px;\n border-bottom: 1px solid {{$line}};\n position: absolute;\n top: 0px;\n width: 100%;\n}\n.ts_header {\n height: 70px;\n}\n.ts_header h1 {\n margin: 20px 20px;\n font-family: Trykker, "Lucida Grande", Georgia, serif;\n font-weight: bold;\n padding: 0px;\n font-size: 30px;\n color: {{$header_colour}};\n {{if $header_shadow == "on"}}text-shadow: 2px 2px 5px #555555;{{/if}}\n}\nh2 {\n font-size: 21px;\n font-family: Trykker, "Lucida Grande", Georgia, serif;\n color: {{$page_heading}};\n}\n\n/* navigation */\n#ts_css_nav {\n width: 180px;\n float: left;\n list-style: none;\n padding: 20px;\n margin: 0px;\n}\n#ts_css_nav li {\n list-style: none;\n margin: 0px 0px 2px;\n color: #666666;\n font-size: 12px;\n line-height: 20px;\n text-align: left;\n}\n#ts_css_nav div {\n color: {{$nav_next_page}};\n}\n#ts_css_nav li div, #ts_css_nav li a {\n padding: 5px 0px 5px 12px;\n display: block;\n}\nul#ts_css_nav li.completed_page {\n -webkit-border-radius: 4px;\n -moz-border-radius: 4px;\n border-radius: 4px;\n border: 1px solid {{$nav_prev_page_border}};\n}\nul#ts_css_nav li.completed_page div {\n color: {{$nav_prev_page_text}};\n}\nul#ts_css_nav li.css_nav_current_page {\n -webkit-border-radius: 4px;\n -moz-border-radius: 4px;\n border-radius: 4px;\n border: 1px solid #ffffff;\n}\nul#ts_css_nav li.css_nav_current_page div {\n background-color: #222222;\n color: white;\n margin: 1px;\n -webkit-border-radius: 3px;\n -moz-border-radius: 3px;\n border-radius: 3px;\n}\nul#ts_css_nav li a {\n margin: 1px;\n -webkit-border-radius: 3px;\n -moz-border-radius: 3px;\n border-radius: 3px;\n}\nul#ts_css_nav li a:link, ul#ts_css_nav li a:visited {\n text-decoration: none;\n color: {{$nav_prev_page_text}};\n -webkit-border-radius: 2px;\n -moz-border-radius: 2px;\n border-radius: 2px;\n}\nul#ts_css_nav li a:hover {\n color: white;\n background-color: {{$nav_prev_page_bg_over}};\n -webkit-border-radius: 3px;\n -moz-border-radius: 3px;\n border-radius: 3px;\n}\n\n/* notifications */\n.notify {\n border: 1px solid #336699;\n background-color: #ffffee;\n color: #336699;\n padding: 8px;\n width: 400px;\n}\n.notify li { color: #336699; }\n.error {\n font-size: 8pt;\n border: 1px solid #cc0000;\n background-color: #ffffee;\n color: #cc0000;\n padding: 8px;\n width: 550px;\n}\n.error span {\n color: #cc0000;\n font-weight: bold;\n margin-bottom: 4px;\n}\n\n/* forms */\ntable.table_1 > tbody > tr > td {\n border-bottom: 1px solid {{$fieldset_lines}};\n}\ntable.table_1 > tbody > tr > td.rowN {\n border-bottom: none;\n}\n.req {\n color: #aa0000;\n}\n.fb_error {\n background-color: #FFFFCC;\n border: 1px solid #CC0000;\n color: #CC0000;\n margin-bottom: 12px;\n padding: 8px;\n}\n\n/* for the code / markup editor */\n.editor {\n background-color: white;\n border: 1px solid #999999;\n padding: 3px;\n}\n.ts_page_content {\n width: 720px;\n float: right;\n}\nfieldset {\n border: 1px solid {{$fieldset_lines}};\n font-size: 11pt;\n font-weight: bold;\n color: {{$fieldset_colour}};\n margin-bottom: 10px;\n background-color: {{$fieldset_bg}};\n}\n{{if $fieldset_shadow == "on"}}\nfieldset legend {\n text-shadow: 2px 2px 3px #333333;\n}\n{{/if}}\n.ts_continue_button input {\n background-color: #222222;\n color: white;\n padding: 2px 10px;\n border-radius: 3px;\n border: 0px;\n cursor: pointer;\n}\n.ts_continue_button input:hover {\n background-color: {{$submit_btn_over}};\n}\n#ts_footer {\n border-top: 1px solid {{$line}};\n padding: 20px;\n color: #222222;\n}\n.edit_link {\n text-shadow: none;\n margin-left: 12px;\n}\n.edit_link a {\n color: {{$edit_link_colour}};\n text-decoration: none;\n}\n.edit_link a:hover {\n text-decoration: underline;\n}\n\n#form_builder__edit_link {\n position: absolute;\n right: 5px;\n top: 5px;\n padding: 2px 10px;\n background-color: black;\n border: 1px solid white;\n color: white;\n text-decoration: none;\n border-radius: 4px;\n}\n#form_builder__edit_link:hover {\n color: #06a4ff;\n}', '[[regtime]]', 1),
(4, 'css', 4, 'General Styles', 'styles', '{{if $P.colours == "Blue"}}\n {{assign var=header_bg value="#388ef4"}}\n {{assign var=border_colour value="#C4DFFF"}}\n {{assign var=selected_row_bg value="#d5e8ff"}}\n {{assign var=selected_row_bottom value="#d5e8ff"}}\n {{assign var=content_border value="#94c5fe"}}\n {{assign var=continue_block_colour value="#f1f7ff"}}\n{{elseif $P.colours == "Green"}}\n {{assign var=header_bg value="#0b9c00"}}\n {{assign var=border_colour value="#e7ffe5"}}\n {{assign var=selected_row_bg value="#d9f4cb"}}\n {{assign var=selected_row_bottom value="#d9f4cb"}}\n {{assign var=content_border value="#ade0aa"}}\n {{assign var=continue_block_colour value="#E9F9E7"}}\n{{elseif $P.colours == "Purple"}}\n {{assign var=header_bg value="#ac52ce"}}\n {{assign var=border_colour value="#f7e0ff"}}\n {{assign var=selected_row_bg value="#f6dfff"}}\n {{assign var=selected_row_bottom value="#f6dfff"}}\n {{assign var=content_border value="#e9c1f8"}}\n {{assign var=continue_block_colour value="#ffffcc"}}\n{{elseif $P.colours == "Orange"}}\n {{assign var=header_bg value="#ffa904"}}\n {{assign var=border_colour value="#ffa904"}}\n {{assign var=selected_row_bg value="#ffd789"}}\n {{assign var=selected_row_bottom value="#ffa904"}}\n {{assign var=content_border value="#CE911A"}}\n {{assign var=continue_block_colour value="#f1f7ff"}}\n{{/if}}\n\nbody {\n text-align: center;\n padding: 0px;\n margin: 0px;\n background-color: #999999;\n}\ntd, th, p, input, textarea, select,ul,li,div, span {\n font-family: {{$P.font}};\n font-size: {{$P.font_size}};\n color: #555555;\n}\ntd, th, p, textarea, ul,li, div {\n line-height: 22px;\n}\na:link, a:visited {\n color: #336699;\n}\ntable {\n empty-cells: show;\n}\n#form_builder__edit_link {\n float: right;\n}\n.req {\n color: #aa0000;\n}\n.fb_error {\n margin-top: 16px;\n padding: 8px;\n box-shadow: 1px 2px 2px #878787;\n background-color: #ffefef;\n}\n\n\n/* page sections */\n.ts_page:after {\n -moz-transform: translate(0pt, 0pt);\n background: none repeat scroll 0 0 transparent;\n border-radius: 20px 20px 20px 20px;\n box-shadow: 15px 0 30px rgba(0, 0, 0, 0.2);\n content: "";\n left: 0;\n position: absolute;\n width: 100%;\n z-index: -2;\n}\n.ts_page {\n margin: 20px auto 0px;\n background: #ccc;\n position:relative;\n box-shadow: 1px 6px 11px rgba(0, 0, 0, 0.36);\n -moz-box-shadow: 1px 6px 11px rgba(0, 0, 0, 0.36);\n -webkit-box-shadow: 1px 6px 11px rgba(0, 0, 0, 0.36);\n text-align: left;\n border: 5px solid {{$border_colour}};\n}\n.ts_header {\n background: none repeat scroll 0 0 rgba(0, 0, 0, 0.5);\n border: 3px solid #CCCCCC;\n height: 140px;\n background: #3a3a3a; /* Old browsers */\n background: -moz-linear-gradient(45deg, #777777 0%, #999999 100%); /* FF3.6+ */\n background: -webkit-gradient(linear, left bottom, right top, color-stop(0%,#3a3a3a), color-stop(100%,#4f4f4f)); /* Chrome,Safari4+ */\n background: -webkit-linear-gradient(45deg, #3a3a3a 0%,#4f4f4f 100%); /* Chrome10+,Safari5.1+ */\n background: -o-linear-gradient(45deg, #3a3a3a 0%,#4f4f4f 100%); /* Opera 11.10+ */\n background: -ms-linear-gradient(45deg, #3a3a3a 0%,#4f4f4f 100%); /* IE10+ */\n background: linear-gradient(45deg, #3a3a3a 0%,#4f4f4f 100%); /* W3C */\n filter: progid:DXImageTransform.Microsoft.gradient( startColorstr=''#3a3a3a'', endColorstr=''#4f4f4f'',GradientType=1 ); /* IE6-9 fallback on horizontal gradient */\n box-shadow: 0 1px 12px rgba(0, 0, 0, 0.1);\n}\n.ts_header h1 {\n margin: 56px 50px;\n padding: 0px;\n font-size: 20px;\n color: white;\n}\n.ts_content {\n background-color: white;\n box-shadow: 0 0 12px rgba(0, 0, 0, 0.1);\n padding: 25px 50px;\n border: 1px solid {{$content_border}};\n}\n.ts_continue_block {\n margin-top: 16px;\n padding: 8px;\n box-shadow: 1px 2px 2px #878787;\n background-color: {{$continue_block_colour}};\n}\n.ts_continue_block input {\n float: right;\n}\n.ts_field_row_selected {\n background-color: {{$selected_row_bg}};\n border-bottom: 1px solid {{$selected_row_bottom}};\n}\n.ts_continue_button {\n margin-top: 12px;\n}\n.highlighted_cell {\n color: #990000;\n background-color: #ffffee;\n text-align: center;\n}\n.light_grey {\n color: #999999;\n}\n.ts_field {\n border-bottom: 1px solid #efefef;\n padding: 10px 6px 15px;\n list-style: none;\n margin: 0px;\n}\n.ts_review_table td {\n border-bottom: 1px solid #efefef;\n padding: 3px 5px 2px;\n}\nh2 {\n font-size: 24px;\n}\nh3 {\n background-color: {{$header_bg}};\n color: white;\n font-size: 12px;\n font-weight: normal;\n margin-bottom: 0;\n padding: 1px 0 0 5px;\n height: 22px;\n}\nh3 a:link, h3 a:visited {\n background-color: white;\n -webkit-border-radius: 2px;\n -moz-border-radius: 2px;\n border-radius: 2px;\n color: black;\n float: right;\n line-height: 17px;\n margin-right: 3px;\n margin-top: 2px;\n padding: 0 8px;\n text-decoration: none;\n}\nh3 a:hover {\n -webkit-border-radius: 2px;\n -moz-border-radius: 2px;\n border-radius: 2px;\n}\n\n/* navigation */\nul#css_nav {\n clear: both;\n width:100%;\n margin: 0px;\n padding: 0px;\n overflow: hidden;\n}\nul#css_nav li {\n float: left;\n background-color: #efefef;\n -webkit-border-radius: 2px;\n -moz-border-radius: 2px;\n border-radius: 2px;\n list-style: none;\n text-align:center;\n margin: 0px 2px 20px 0px;\n color: #666666;\n font-size: 11px;\n line-height: 20px;\n}\nul#css_nav li.css_nav_current_page {\n background-color: #999999;\n color: white;\n}\nul#css_nav li a:link, ul#css_nav li a:visited {\n display: block;\n text-decoration: none;\n color: white;\n background-color: #999999;\n -webkit-border-radius: 2px;\n -moz-border-radius: 2px;\n border-radius: 2px;\n}\nul#css_nav li a:hover {\n -webkit-border-radius: 2px;\n -moz-border-radius: 2px;\n border-radius: 2px;\n}\n.nav_1_pages li {\n width: 100%;\n}\n.nav_2_pages li {\n width: 50%;\n}\n.nav_3_pages li {\n width: 33%;\n}\n.nav_4_pages li {\n width: 24.7%;\n}\n.nav_5_pages li {\n width: 19.5%;\n}\n.nav_6_pages li {\n width: 16%;\n}\n.nav_7_pages li {\n width: 13%;\n}\n.nav_8_pages li {\n width: 12%;\n}\n\n/* notifications */\n.notify {\n border: 1px solid #336699;\n background-color: #ffffee;\n color: #336699;\n padding: 8px;\n width: 400px;\n}\n.notify li { color: #336699; }\n.error {\n font-size: 8pt;\n border: 1px solid #cc0000;\n background-color: #ffffee;\n color: #cc0000;\n padding: 8px;\n width: 550px;\n}\n.error span {\n color: #cc0000;\n font-weight: bold;\n margin-bottom: 4px;\n}\n\n/* for the code / markup editor */\n.editor {\n background-color: white;\n border: 1px solid #999999;\n padding: 3px;\n}\nul#css_nav li a:hover {\n background-color: #2e425a;\n}\nh3 a:hover {\n background-color: #c9e2ff;\n color: black;\n}\n', '[[regtime]]', 1),
(5, 'css', 5, 'Additional Styles', 'styles', '/**\n * The majority of styles for this Template Set are pulled directly from the Core''s default theme.\n * This supplements them for a few things that aren''t covered.\n */\nh1 {\n margin: 0px;\n padding: 28px 0px 0px 21px;\n float: left;\n font-family: ''Lato'', Arial;\n color: white;\n font-size: 20px;\n font-weight: normal;\n}\n#ts_css_nav {\n list-style:none;\n margin: 0px;\n padding: 0px;\n}\n#ts_css_nav li {\n height: 27px;\n}\n#ts_css_nav li a, #ts_css_nav li div {\n padding: 2px 0px 2px 4px;\n width: 150px;\n}\n#ts_css_nav li.completed_page a:link, #ts_css_nav li.completed_page a:visited {\n display: block;\n text-underline: none;\n}\n#ts_css_nav li.css_nav_current_page div {\n font-weight: bold;\n}\n.edit_link {\n float: right;\n}\n.edit_link a:link, .edit_link a:visited {\n padding: 0px 7px;\n background-color: #aaaaaa;\n color: white;\n border-radius: 3px;\n letter-spacing: 0px;\n}\n.edit_link a:hover {\n background-color: #222222;\n text-decoration: none;\n}\n#form_builder__edit_link {\n background-color: #444444;\n border-radius: 3px 3px 3px 3px;\n color: white;\n float: right;\n margin: 25px;\n padding: 0 8px;\n}\n#form_builder__edit_link:hover {\n background-color: #000000;\n text-decoration: none;\n}\n.ts_heading {\n font: 17.6px/20px Verdana,sans-serif;\n padding-bottom: 5px;\n margin: 0px;\n}', '[[regtime]]', 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]module_menu_items`
--
CREATE TABLE `[[dbprefix]]module_menu_items` (
`menu_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`module_id` mediumint(8) unsigned NOT NULL,
`display_text` varchar(100) NOT NULL,
`url` varchar(255) NOT NULL,
`is_submenu` enum('yes','no') NOT NULL DEFAULT 'no',
`list_order` smallint(6) NOT NULL,
PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;
--
-- Dumping data for table `[[dbprefix]]module_menu_items`
--
INSERT INTO `[[dbprefix]]module_menu_items` VALUES
(1, 5, 'Visualizations', '[[softurl]]/modules/data_visualization/index.php', 'no', 1),
(2, 5, 'Main Settings', '[[softurl]]/modules/data_visualization/settings.php', 'no', 2),
(3, 5, 'Activity Charts', '[[softurl]]/modules/data_visualization/activity_charts/settings.php', 'yes', 3),
(4, 5, 'Field Charts', '[[softurl]]/modules/data_visualization/field_charts/settings.php', 'yes', 4),
(5, 5, 'Help', '[[softurl]]/modules/data_visualization/help.php', 'no', 5),
(6, 2, 'Export Manager', '[[softurl]]/modules/export_manager/index.php', 'no', 1),
(7, 2, 'Settings', '[[softurl]]/modules/export_manager/settings.php', 'yes', 2),
(8, 2, 'Reset to Defaults', '[[softurl]]/modules/export_manager/reset.php', 'yes', 3),
(9, 2, 'Help', '[[softurl]]/modules/export_manager/help.php', 'yes', 4),
(10, 3, 'File Upload', '[[softurl]]/modules/field_type_file/index.php', 'no', 1),
(11, 6, 'Template Sets', '[[softurl]]/modules/form_builder/index.php', 'no', 1),
(12, 6, 'Settings', '[[softurl]]/modules/form_builder/settings.php', 'no', 2),
(13, 6, 'Help', '[[softurl]]/modules/form_builder/help.php', 'no', 3),
(14, 8, 'Pages', '[[softurl]]/modules/pages/index.php', 'no', 1),
(15, 8, 'Add Page', '[[softurl]]/modules/pages/add.php', 'yes', 2),
(16, 8, 'Settings', '[[softurl]]/modules/pages/settings.php', 'no', 3),
(17, 8, 'Help', '[[softurl]]/modules/pages/help.php', 'no', 4),
(18, 1, 'Swift Mailer', '[[softurl]]/modules/swift_mailer/index.php', 'no', 1),
(19, 1, 'Help', '[[softurl]]/modules/swift_mailer/help.php', 'yes', 2),
(20, 4, 'System Check', '[[softurl]]/modules/system_check/index.php', 'no', 1),
(21, 4, 'File Verification', '[[softurl]]/modules/system_check/files.php', 'yes', 2),
(22, 4, 'Table Verification', '[[softurl]]/modules/system_check/tables.php', 'yes', 3),
(23, 4, 'Hook Verification', '[[softurl]]/modules/system_check/hooks.php', 'yes', 4),
(24, 4, 'Orphan Clean-up', '[[softurl]]/modules/system_check/orphans.php', 'yes', 5),
(25, 4, 'Environment Info', '[[softurl]]/modules/system_check/env.php', 'no', 6),
(26, 4, 'Help', '[[softurl]]/modules/system_check/help.php', 'no', 7),
(27, 7, 'TinyMCE Field', '[[softurl]]/modules/field_type_tinymce/index.php', 'no', 1),
(28, 7, 'Help', '[[softurl]]/modules/field_type_tinymce/help.php', 'no', 2);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]module_pages`
--
CREATE TABLE `[[dbprefix]]module_pages` (
`page_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`page_name` varchar(50) NOT NULL,
`access_type` enum('admin','public','private') NOT NULL DEFAULT 'admin',
`content_type` enum('html','php','smarty') NOT NULL DEFAULT 'html',
`use_wysiwyg` enum('yes','no') NOT NULL DEFAULT 'yes',
`heading` varchar(255) DEFAULT NULL,
`content` text,
PRIMARY KEY (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]module_pages_clients`
--
CREATE TABLE `[[dbprefix]]module_pages_clients` (
`page_id` mediumint(9) unsigned NOT NULL,
`client_id` mediumint(9) unsigned NOT NULL,
PRIMARY KEY (`page_id`,`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]module_swift_mailer_email_template_fields`
--
CREATE TABLE `[[dbprefix]]module_swift_mailer_email_template_fields` (
`email_template_id` mediumint(9) NOT NULL,
`return_path` varchar(255) NOT NULL,
PRIMARY KEY (`email_template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]multi_page_form_urls`
--
CREATE TABLE `[[dbprefix]]multi_page_form_urls` (
`form_id` mediumint(8) unsigned NOT NULL,
`form_url` varchar(255) NOT NULL,
`page_num` tinyint(4) NOT NULL DEFAULT '2',
PRIMARY KEY (`form_id`,`page_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]new_view_submission_defaults`
--
CREATE TABLE `[[dbprefix]]new_view_submission_defaults` (
`view_id` mediumint(9) NOT NULL,
`field_id` mediumint(9) NOT NULL,
`default_value` text NOT NULL,
`list_order` smallint(6) NOT NULL,
PRIMARY KEY (`view_id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]option_lists`
--
CREATE TABLE `[[dbprefix]]option_lists` (
`list_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`option_list_name` varchar(100) NOT NULL,
`is_grouped` enum('yes','no') NOT NULL,
`original_form_id` mediumint(8) unsigned DEFAULT NULL,
PRIMARY KEY (`list_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]public_form_omit_list`
--
CREATE TABLE `[[dbprefix]]public_form_omit_list` (
`form_id` mediumint(8) unsigned NOT NULL,
`account_id` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`form_id`,`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]public_view_omit_list`
--
CREATE TABLE `[[dbprefix]]public_view_omit_list` (
`view_id` mediumint(8) unsigned NOT NULL,
`account_id` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`view_id`,`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]sessions`
--
CREATE TABLE `[[dbprefix]]sessions` (
`session_id` varchar(100) NOT NULL DEFAULT '',
`session_data` text NOT NULL,
`expires` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]settings`
--
CREATE TABLE `[[dbprefix]]settings` (
`setting_id` mediumint(9) NOT NULL AUTO_INCREMENT,
`setting_name` varchar(100) NOT NULL,
`setting_value` text NOT NULL,
`module` varchar(100) NOT NULL DEFAULT 'core',
PRIMARY KEY (`setting_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=98 ;
--
-- Dumping data for table `[[dbprefix]]settings`
--
INSERT INTO `[[dbprefix]]settings` VALUES
(1, 'program_version', '3.1.1', 'core'),
(2, 'release_date', '20230226', 'core'),
(3, 'release_type', 'main', 'core'),
(4, 'api_version', '', 'core'),
(5, 'available_languages', 'af,Afrikaans|ar,Arabic|az,Azerbaijani|be,Byelorussian|bg,Bulgarian|ca,Catalan|cs,Czech|cy,Welsh|da,Danish|de,German|el,Greek|en_us,English (US)|es,Spanish|et,Estonian|fa,Persian|fi,Finnish|fr,French|ga,Irish|gl,Galician|hi,Hindi|hr,Croatian|hu,Hungarian|id,Indonesian|is,Icelandic|it,Italian|ja,Japanese|ko,Korean|la,Latvian|lt,Lithuanian|mk,Macedonian|ms,Malay|mt,Maltese|nl,Dutch|no,Norwegian|pl,Polish|pt,Portuguese|pt_br,Portuguese (Brazilian)|pt_eu,Portuguese (European)|ro,Romanian|ru,Russian|sk,Slovak|sl,Slovenian|sr,Serbian|sv,Swedish|sw,Swahili|th,Thai|tl,Filipino|tr,Turkish|uk,Ukrainian|vi,Vietnamese|yi,Yiddish|zh_cn,Chinese (Simplified)|zh_tw,Chinese (Traditional)', 'core'),
(6, 'clients_may_edit_date_format', 'no', 'core'),
(7, 'clients_may_edit_footer_text', 'no', 'core'),
(8, 'clients_may_edit_logout_url', 'yes', 'core'),
(9, 'clients_may_edit_max_failed_login_attempts', 'no', 'core'),
(10, 'clients_may_edit_page_titles', 'no', 'core'),
(11, 'clients_may_edit_sessions_timeout', 'no', 'core'),
(12, 'clients_may_edit_theme', 'yes', 'core'),
(13, 'clients_may_edit_timezone_offset', 'yes', 'core'),
(14, 'clients_may_edit_ui_language', 'yes', 'core'),
(15, 'default_client_menu_id', '2', 'core'),
(16, 'default_client_swatch', 'green', 'core'),
(17, 'default_date_field_search_value', 'none', 'core'),
(18, 'default_date_format', 'M jS y, g:i A', 'core'),
(19, 'default_footer_text', '', 'core'),
(20, 'default_language', '[[language]]', 'core'),
(21, 'default_login_page', 'client_forms', 'core'),
(22, 'default_logout_url', '[[softurl]]', 'core'),
(23, 'default_max_failed_login_attempts', '', 'core'),
(24, 'default_num_submissions_per_page', '10', 'core'),
(25, 'default_page_titles', 'Form Tools - {$page}', 'core'),
(26, 'default_sessions_timeout', '30', 'core'),
(27, 'default_theme', 'default', 'core'),
(28, 'default_timezone_offset', '0', 'core'),
(29, 'edit_submission_shared_resources_js', '$(function() {\n $(".fancybox").fancybox();\n});', 'core'),
(30, 'edit_submission_shared_resources_css', '/* used in the "Highlight" setting for most field types */\n.cf_colour_red {\n background-color: #990000;\n color: white;\n}\n.cf_colour_orange {\n background-color: orange;\n}\n.cf_colour_yellow {\n background-color: yellow;\n}\n.cf_colour_green {\n background-color: green;\n color: white;\n}\n.cf_colour_blue {\n background-color: #336699;\n color: white;\n}\n/* field comments */\n.cf_field_comments {\n font-style: italic;\n color: #999999;\n clear: both;\n}\n\n/* column layouts for radios & checkboxes */\n.cf_option_list_group_label {\n font-weight: bold;\n clear: both;\n margin-left: 4px;\n}\n.cf_option_list_2cols,\n.cf_option_list_3cols,\n.cf_option_list_4cols {\n clear: both;\n}\n.cf_option_list_2cols .column {\n width: 50%;\n float: left;\n}\n.cf_option_list_3cols .column {\n width: 33%;\n float: left;\n}\n.cf_option_list_4cols .column {\n width: 25%;\n float: left;\n}\n\n/* Used for the date and time pickers */\n.cf_date_group img {\n margin-bottom: -4px;\n padding: 1px;\n}', 'core'),
(31, 'edit_submission_onload_resources', '\n\n\n\n\n\n\n', 'core'),
(32, 'field_type_settings_shared_characteristics', 'field_comments:textbox,comments`textarea,comments`password,comments`dropdown,comments`multi_select_dropdown,comments`radio_buttons,comments`checkboxes,comments`date,comments`time,comments`phone,comments`code_markup,comments`file,comments`google_maps_field,comments`tinymce,comments|data_source:dropdown,contents`multi_select_dropdown,contents`radio_buttons,contents`checkboxes,contents|column_formatting:checkboxes,formatting`radio_buttons,formatting|maxlength_attr:textbox,maxlength|colour_highlight:textbox,highlight|folder_path:file,folder_path|folder_url:file,folder_url|permitted_file_types:file,folder_url|max_file_size:file,max_file_size|date_display_format:date,display_format|apply_timezone_offset:date,apply_timezone_offset', 'core'),
(33, 'file_upload_dir', '[[softpath]]/upload', 'core'),
(34, 'file_upload_filetypes', 'bmp,gif,jpg,jpeg,png,avi,mp3,mp4,doc,txt,pdf,xml,csv,swf,fla,xls,tif', 'core'),
(35, 'file_upload_url', '[[softurl]]/upload', 'core'),
(36, 'file_upload_max_size', '2000', 'core'),
(37, 'forms_page_default_message', 'Welcome! This program stores all information submitted by your website visitors. To view submissions for a particular form just click on the VIEW link, or see the leftmost navigation menu for other options.', 'core'),
(38, 'logo_link', 'https://formtools.org', 'core'),
(39, 'min_password_length', '', 'core'),
(40, 'num_clients_per_page', '10', 'core'),
(41, 'num_emails_per_page', '10', 'core'),
(42, 'num_forms_per_page', '10', 'core'),
(43, 'num_menus_per_page', '10', 'core'),
(44, 'num_modules_per_page', '10', 'core'),
(45, 'num_option_lists_per_page', '10', 'core'),
(46, 'num_password_history', '', 'core'),
(47, 'program_name', 'Form Tools', 'core'),
(48, 'required_password_chars', '', 'core'),
(49, 'timezone_offset', '0', 'core'),
(50, 'core_version_upgrade_track', '3.1.1', 'core'),
(51, 'quicklinks_dialog_width', '880', 'data_visualization'),
(52, 'quicklinks_dialog_height', '400', 'data_visualization'),
(53, 'quicklinks_dialog_thumb_size', '200', 'data_visualization'),
(54, 'default_cache_frequency', '30', 'data_visualization'),
(55, 'hide_from_client_accounts', 'no', 'data_visualization'),
(56, 'clients_may_refresh_cache', 'yes', 'data_visualization'),
(57, 'activity_chart_date_range', 'last_30_days', 'data_visualization'),
(58, 'activity_chart_submission_count_group', 'day', 'data_visualization'),
(59, 'activity_chart_default_chart_type', 'line_chart', 'data_visualization'),
(60, 'activity_chart_colour', 'blue', 'data_visualization'),
(61, 'activity_chart_line_width', '2', 'data_visualization'),
(62, 'field_chart_default_chart_type', 'pie_chart', 'data_visualization'),
(63, 'field_chart_include_legend_quicklinks', 'no', 'data_visualization'),
(64, 'field_chart_colour', 'blue', 'data_visualization'),
(65, 'field_chart_include_legend_full_size', 'yes', 'data_visualization'),
(66, 'field_chart_pie_chart_format', '2D', 'data_visualization'),
(67, 'field_chart_ignore_empty_fields', 'yes', 'data_visualization'),
(68, 'file_upload_dir', '[[softpath]]/upload', 'export_manager'),
(69, 'file_upload_url', '[[softurl]]/upload', 'export_manager'),
(70, 'export_timeout', '300', 'export_manager'),
(71, 'default_form_offline_page_content', 'Sorry!
\n\n\n The form is currently offline.\n
', 'form_builder'), (72, 'scheduled_offline_form_behaviour', 'allow_completion', 'form_builder'), (73, 'default_thankyou_page_content', 'Thanks!
\n\n\n Your form has been processed. Thanks for submitting the form.\n
\n\n\n Click here to put through another submission.\n
', 'form_builder'), (74, 'default_published_folder_path', '[[softpath]]/modules/form_builder/published', 'form_builder'), (75, 'default_published_folder_url', '[[softurl]]/modules/form_builder/published', 'form_builder'), (76, 'review_page_title', 'Review', 'form_builder'), (77, 'thankyou_page_title', 'Thankyou', 'form_builder'), (78, 'form_builder_width', '1000', 'form_builder'), (79, 'form_builder_height', '700', 'form_builder'), (80, 'edit_form_builder_link_action', 'same_window', 'form_builder'), (81, 'demo_mode', 'off', 'form_builder'), (82, 'num_pages_per_page', '10', 'pages'), (83, 'swiftmailer_enabled', 'no', 'swift_mailer'), (84, 'smtp_server', '', 'swift_mailer'), (85, 'port', '', 'swift_mailer'), (86, 'requires_authentication', 'no', 'swift_mailer'), (87, 'username', '', 'swift_mailer'), (88, 'password', '', 'swift_mailer'), (89, 'authentication_procedure', '', 'swift_mailer'), (90, 'use_encryption', '', 'swift_mailer'), (91, 'encryption_type', '', 'swift_mailer'), (92, 'charset', 'UTF-8', 'swift_mailer'), (93, 'server_connection_timeout', '15', 'swift_mailer'), (94, 'use_anti_flooding', '', 'swift_mailer'), (95, 'anti_flooding_email_batch_size', '', 'swift_mailer'), (96, 'anti_flooding_email_batch_wait_time', '', 'swift_mailer'), (97, 'installation_complete', 'yes', 'core'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]themes` -- CREATE TABLE `[[dbprefix]]themes` ( `theme_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `theme_folder` varchar(100) NOT NULL, `theme_name` varchar(50) NOT NULL, `uses_swatches` enum('yes','no') NOT NULL DEFAULT 'no', `swatches` mediumtext, `author` varchar(200) DEFAULT NULL, `author_email` varchar(255) DEFAULT NULL, `author_link` varchar(255) DEFAULT NULL, `theme_link` varchar(255) DEFAULT NULL, `description` mediumtext, `is_enabled` enum('yes','no') NOT NULL DEFAULT 'yes', `theme_version` varchar(50) DEFAULT NULL, PRIMARY KEY (`theme_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Dumping data for table `[[dbprefix]]themes` -- INSERT INTO `[[dbprefix]]themes` VALUES (1, 'deepblue', 'Deep Blue', 'no', '', 'ben.keen@gmail.com', NULL, NULL, 'https://themes.formtools.org/', 'A fixed-width blue-coloured theme designed for 1024 pixel minimum screens.', 'yes', '2.0.5'), (2, 'classicgrey', 'Classic Grey', 'no', '', 'Ben Keen', NULL, NULL, 'https://themes.formtools.org', 'A remodelling of the old grey-styled Form Tools 1.x theme.', 'yes', '2.0.7'), (3, 'default', 'Default', 'yes', 'red,{$LANG.word_red}|orange,{$LANG.word_orange}|yellow,{$LANG.word_yellow}|green,{$LANG.word_green}|aquamarine,{$LANG.word_aquamarine}|blue,{$LANG.word_blue}|dark_blue,{$LANG.phrase_dark_blue}|purple,{$LANG.word_purple}|grey,{$LANG.word_grey}|light_brown,{$LANG.phrase_light_brown}', 'Ben Keen', NULL, NULL, 'http://themes.formtools.org', 'The default Form Tools theme. It''s a fixed-width theme requiring 1024 minimum width screens, with a few different colour swatches to choose from.', 'yes', '1.0.0'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]views` -- CREATE TABLE `[[dbprefix]]views` ( `view_id` smallint(6) NOT NULL AUTO_INCREMENT, `form_id` mediumint(8) unsigned NOT NULL, `access_type` enum('admin','public','private','hidden') NOT NULL DEFAULT 'public', `view_name` varchar(100) NOT NULL, `view_order` smallint(6) NOT NULL DEFAULT '1', `is_new_sort_group` enum('yes','no') NOT NULL, `group_id` smallint(6) DEFAULT NULL, `num_submissions_per_page` smallint(6) NOT NULL DEFAULT '10', `default_sort_field` varchar(255) NOT NULL DEFAULT 'submission_date', `default_sort_field_order` enum('asc','desc') NOT NULL DEFAULT 'desc', `may_add_submissions` enum('yes','no') NOT NULL DEFAULT 'yes', `may_copy_submissions` enum('yes','no') NOT NULL DEFAULT 'no', `may_edit_submissions` enum('yes','no') NOT NULL DEFAULT 'yes', `may_delete_submissions` enum('yes','no') NOT NULL DEFAULT 'yes', `has_client_map_filter` enum('yes','no') NOT NULL DEFAULT 'no', `has_standard_filter` enum('yes','no') NOT NULL DEFAULT 'no', PRIMARY KEY (`view_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]view_columns` -- CREATE TABLE `[[dbprefix]]view_columns` ( `view_id` mediumint(9) NOT NULL, `field_id` mediumint(9) NOT NULL, `list_order` smallint(6) NOT NULL, `is_sortable` enum('yes','no') NOT NULL, `auto_size` enum('yes','no') NOT NULL DEFAULT 'yes', `custom_width` varchar(10) DEFAULT NULL, `truncate` enum('truncate','no_truncate') NOT NULL DEFAULT 'truncate', PRIMARY KEY (`view_id`,`field_id`,`list_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]view_fields` -- CREATE TABLE `[[dbprefix]]view_fields` ( `view_id` mediumint(8) unsigned NOT NULL, `field_id` mediumint(8) unsigned NOT NULL, `group_id` mediumint(9) DEFAULT NULL, `is_editable` enum('yes','no') NOT NULL DEFAULT 'yes', `is_searchable` enum('yes','no') NOT NULL DEFAULT 'yes', `list_order` smallint(5) unsigned DEFAULT NULL, `is_new_sort_group` enum('yes','no') NOT NULL, PRIMARY KEY (`view_id`,`field_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]view_filters` -- CREATE TABLE `[[dbprefix]]view_filters` ( `filter_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `view_id` mediumint(8) unsigned NOT NULL, `filter_type` enum('standard','client_map') NOT NULL DEFAULT 'standard', `field_id` mediumint(8) unsigned NOT NULL, `operator` enum('equals','not_equals','like','not_like','before','after') NOT NULL DEFAULT 'equals', `filter_values` mediumtext NOT NULL, `filter_sql` mediumtext NOT NULL, PRIMARY KEY (`filter_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]view_tabs` -- CREATE TABLE `[[dbprefix]]view_tabs` ( `view_id` mediumint(8) unsigned NOT NULL, `tab_number` tinyint(3) unsigned NOT NULL, `tab_label` varchar(50) DEFAULT NULL, PRIMARY KEY (`view_id`,`tab_number`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;