CREATE TABLE `jos3_facileforms_forms` (
  `id` int(11) NOT NULL,
  `alt_mailfrom` text,
  `alt_fromname` text,
  `mb_alt_mailfrom` text,
  `mb_alt_fromname` text,
  `mailchimp_email_field` varchar(255) NOT NULL DEFAULT '',
  `mailchimp_checkbox_field` varchar(255) NOT NULL DEFAULT '',
  `mailchimp_api_key` varchar(255) NOT NULL DEFAULT '',
  `mailchimp_list_id` varchar(255) NOT NULL DEFAULT '',
  `mailchimp_double_optin` tinyint(1) NOT NULL DEFAULT '1',
  `mailchimp_mergevars` text,
  `mailchimp_text_html_mobile_field` varchar(255) NOT NULL DEFAULT '',
  `mailchimp_send_errors` tinyint(1) NOT NULL DEFAULT '0',
  `mailchimp_update_existing` tinyint(1) NOT NULL DEFAULT '0',
  `mailchimp_replace_interests` tinyint(1) NOT NULL DEFAULT '0',
  `mailchimp_send_welcome` tinyint(1) NOT NULL DEFAULT '0',
  `mailchimp_default_type` varchar(255) NOT NULL DEFAULT 'text',
  `mailchimp_delete_member` tinyint(1) NOT NULL DEFAULT '0',
  `mailchimp_send_goodbye` tinyint(1) NOT NULL DEFAULT '1',
  `mailchimp_send_notify` tinyint(1) NOT NULL DEFAULT '1',
  `mailchimp_unsubscribe_field` varchar(255) NOT NULL DEFAULT '',
  `salesforce_token` varchar(255) NOT NULL DEFAULT '',
  `salesforce_username` varchar(255) NOT NULL DEFAULT '',
  `salesforce_password` varchar(255) NOT NULL DEFAULT '',
  `salesforce_type` varchar(255) NOT NULL DEFAULT '',
  `salesforce_fields` text,
  `salesforce_enabled` tinyint(1) NOT NULL DEFAULT '0',
  `dropbox_email` varchar(255) NOT NULL DEFAULT '',
  `dropbox_password` varchar(255) NOT NULL DEFAULT '',
  `dropbox_folder` text,
  `dropbox_submission_enabled` tinyint(1) NOT NULL DEFAULT '0',
  `dropbox_submission_types` varchar(255) NOT NULL DEFAULT 'pdf',
  `tags_content` text NOT NULL,
  `tags_content_template` mediumtext NOT NULL,
  `tags_content_template_default_element` int(11) NOT NULL DEFAULT '0',
  `tags_form` text NOT NULL,
  `tags_content_default_category` int(11) NOT NULL DEFAULT '0',
  `tags_content_default_state` int(11) NOT NULL DEFAULT '1',
  `tags_content_default_access` int(11) NOT NULL DEFAULT '1',
  `tags_content_default_language` varchar(7) NOT NULL DEFAULT '*',
  `tags_content_default_featured` int(11) NOT NULL DEFAULT '0',
  `tags_content_default_publishup` varchar(255) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `tags_content_default_publishdown` varchar(255) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `autoheight` tinyint(1) NOT NULL DEFAULT '0',
  `package` varchar(30) NOT NULL DEFAULT '',
  `template_code` longtext NOT NULL,
  `template_code_processed` longtext NOT NULL,
  `template_areas` longtext NOT NULL,
  `ordering` int(11) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `runmode` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `custom_mail_subject` varchar(255) NOT NULL DEFAULT '',
  `mb_custom_mail_subject` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` text,
  `class1` varchar(30) DEFAULT NULL,
  `class2` varchar(30) DEFAULT NULL,
  `width` int(11) NOT NULL DEFAULT '0',
  `widthmode` tinyint(1) NOT NULL DEFAULT '0',
  `height` int(11) NOT NULL DEFAULT '0',
  `heightmode` tinyint(1) NOT NULL DEFAULT '0',
  `pages` int(11) NOT NULL DEFAULT '1',
  `emailntf` tinyint(1) NOT NULL DEFAULT '1',
  `mb_emailntf` tinyint(1) NOT NULL DEFAULT '1',
  `emaillog` tinyint(1) NOT NULL DEFAULT '1',
  `mb_emaillog` tinyint(1) NOT NULL DEFAULT '1',
  `emailxml` tinyint(1) NOT NULL DEFAULT '0',
  `mb_emailxml` tinyint(1) NOT NULL DEFAULT '0',
  `email_type` tinyint(1) NOT NULL DEFAULT '0',
  `mb_email_type` tinyint(1) NOT NULL DEFAULT '0',
  `email_custom_template` text,
  `mb_email_custom_template` text,
  `email_custom_html` tinyint(1) NOT NULL DEFAULT '0',
  `mb_email_custom_html` tinyint(1) NOT NULL DEFAULT '0',
  `emailadr` text,
  `dblog` tinyint(1) NOT NULL DEFAULT '1',
  `script1cond` tinyint(1) NOT NULL DEFAULT '0',
  `script1id` int(11) DEFAULT NULL,
  `script1code` text,
  `script2cond` tinyint(1) NOT NULL DEFAULT '0',
  `script2id` int(11) DEFAULT NULL,
  `script2code` text,
  `piece1cond` tinyint(1) NOT NULL DEFAULT '0',
  `piece1id` int(11) DEFAULT NULL,
  `piece1code` text,
  `piece2cond` tinyint(1) NOT NULL DEFAULT '0',
  `piece2id` int(11) DEFAULT NULL,
  `piece2code` text,
  `piece3cond` tinyint(1) NOT NULL DEFAULT '0',
  `piece3id` int(11) DEFAULT NULL,
  `piece3code` text,
  `piece4cond` tinyint(1) NOT NULL DEFAULT '0',
  `piece4id` int(11) DEFAULT NULL,
  `piece4code` text,
  `prevmode` tinyint(1) NOT NULL DEFAULT '2',
  `prevwidth` int(11) DEFAULT NULL,
  `filter_state` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `jos3_facileforms_forms`
--

INSERT INTO `jos3_facileforms_forms` (`id`, `alt_mailfrom`, `alt_fromname`, `mb_alt_mailfrom`, `mb_alt_fromname`, `mailchimp_email_field`, `mailchimp_checkbox_field`, `mailchimp_api_key`, `mailchimp_list_id`, `mailchimp_double_optin`, `mailchimp_mergevars`, `mailchimp_text_html_mobile_field`, `mailchimp_send_errors`, `mailchimp_update_existing`, `mailchimp_replace_interests`, `mailchimp_send_welcome`, `mailchimp_default_type`, `mailchimp_delete_member`, `mailchimp_send_goodbye`, `mailchimp_send_notify`, `mailchimp_unsubscribe_field`, `salesforce_token`, `salesforce_username`, `salesforce_password`, `salesforce_type`, `salesforce_fields`, `salesforce_enabled`, `dropbox_email`, `dropbox_password`, `dropbox_folder`, `dropbox_submission_enabled`, `dropbox_submission_types`, `tags_content`, `tags_content_template`, `tags_content_template_default_element`, `tags_form`, `tags_content_default_category`, `tags_content_default_state`, `tags_content_default_access`, `tags_content_default_language`, `tags_content_default_featured`, `tags_content_default_publishup`, `tags_content_default_publishdown`, `autoheight`, `package`, `template_code`, `template_code_processed`, `template_areas`, `ordering`, `published`, `runmode`, `name`, `custom_mail_subject`, `mb_custom_mail_subject`, `title`, `description`, `class1`, `class2`, `width`, `widthmode`, `height`, `heightmode`, `pages`, `emailntf`, `mb_emailntf`, `emaillog`, `mb_emaillog`, `emailxml`, `mb_emailxml`, `email_type`, `mb_email_type`, `email_custom_template`, `mb_email_custom_template`, `email_custom_html`, `mb_email_custom_html`, `emailadr`, `dblog`, `script1cond`, `script1id`, `script1code`, `script2cond`, `script2id`, `script2code`, `piece1cond`, `piece1id`, `piece1code`, `piece2cond`, `piece2id`, `piece2code`, `piece3cond`, `piece3id`, `piece3code`, `piece4cond`, `piece4id`, `piece4code`, `prevmode`, `prevwidth`, `filter_state`) VALUES
(1, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'QuickModeForms', '[encoded data, 7500 characters]', 'QuickMode', '[{\"elements\":[{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"300px\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"300px\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"44\",\"script3code\":\"\",\"script3msg\":\"Please tell us your name.\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_valuenotempty\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Name\",\"name\":\"Name\",\"page\":\"1\",\"orderNumber\":1,\"dbId\":40,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode9554026\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"42\",\"script3code\":\"\",\"script3msg\":\"Please enter a valid email address.\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_validemail\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Email\",\"name\":\"email\",\"page\":\"1\",\"orderNumber\":2,\"dbId\":41,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode7919690\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Textarea\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"44\",\"script3code\":\"\",\"script3msg\":\"Please enter a message here.\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_valuenotempty\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Message\",\"name\":\"message\",\"page\":\"1\",\"orderNumber\":3,\"dbId\":42,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode6345075\",\"internalType\":\"bfTextarea\",\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"41\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle\",\"name\":\"bfFakeName\",\"page\":1,\"orderNumber\":0,\"dbId\":43,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"23\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle2\",\"name\":\"bfFakeName2\",\"page\":1,\"orderNumber\":0,\"dbId\":44,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"40\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle3\",\"name\":\"bfFakeName3\",\"page\":1,\"orderNumber\":0,\"dbId\":45,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"38\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle4\",\"name\":\"bfFakeName4\",\"page\":1,\"orderNumber\":0,\"dbId\":46,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"}],\"elementCount\":3}]', 2, 1, 0, 'SampleQuickModeContactForm', '', '', 'SAMPLE QuickMode Contact Form', 'Sample Contact Form for QuickMode', '', '', 400, 0, 500, 0, 2, 2, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, 'your@email.com', 1, 0, NULL, NULL, 2, NULL, 'function ff_SampleQuickModeContactForm_submitted(status, message){ff_switchpage(2);}', 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 2, 0, ''),
(2, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'QuickModeForms', '[encoded data, 18928 characters]', 'QuickMode', '[{\"elements\":[{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"44\",\"script3code\":\"\",\"script3msg\":\"Please tell us your name.\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_valuenotempty\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Your Name\",\"name\":\"yourname\",\"page\":\"1\",\"orderNumber\":1,\"dbId\":47,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode5111280\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":true,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"42\",\"script3code\":\"\",\"script3msg\":\"Please enter your email address.\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_validemail\",\"flag1\":0,\"flag2\":0,\"mailback\":1,\"mailbackfile\":\"\",\"title\":\"Your Email\",\"name\":\"youremail\",\"page\":\"1\",\"orderNumber\":2,\"dbId\":48,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode23906\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":1,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"44\",\"script3code\":\"\",\"script3msg\":\"Please enter your friend\'s name.\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_valuenotempty\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Friend\'s Name\",\"name\":\"friendname\",\"page\":\"1\",\"orderNumber\":3,\"dbId\":49,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode4663142\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":true,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"42\",\"script3code\":\"\",\"script3msg\":\"Please enter your friend\'s email address.\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_validemail\",\"flag1\":0,\"flag2\":0,\"mailback\":1,\"mailbackfile\":\"\",\"title\":\"Friend\'s Email\",\"name\":\"friendsEmail\",\"page\":\"1\",\"orderNumber\":4,\"dbId\":50,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode77706\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Textarea\",\"elementType\":\"\",\"options\":{\"value\":\"Hi, \\n\\nI thought you might be interested in this website. \",\"placeholder\":\"\",\"readonly\":false},\"data1\":\"Hi, \\n\\nI thought you might be interested in this website. \",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Message\",\"name\":\"Message\",\"page\":\"1\",\"orderNumber\":5,\"dbId\":51,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode2119360\",\"internalType\":\"bfTextarea\",\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Captcha\",\"elementType\":\"\",\"options\":{\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Enter Captcha Code\",\"name\":\"captcha\",\"page\":\"1\",\"orderNumber\":6,\"dbId\":52,\"appElementOrderId\":0,\"id\":0,\"logging\":false,\"qId\":\"bfQuickMode8502384\",\"internalType\":\"bfCaptcha\",\"width\":230,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Unknown\",\"elementType\":\"\",\"options\":{\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Your Name\",\"name\":\"bfQuickMode3314439\",\"page\":\"2\",\"orderNumber\":7,\"dbId\":53,\"appElementOrderId\":0,\"id\":0,\"logging\":false,\"qId\":\"bfQuickMode3314439\",\"internalType\":\"bfSummarize\",\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Unknown\",\"elementType\":\"\",\"options\":{\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Your Email\",\"name\":\"bfQuickMode8493\",\"page\":\"2\",\"orderNumber\":8,\"dbId\":54,\"appElementOrderId\":0,\"id\":0,\"logging\":false,\"qId\":\"bfQuickMode8493\",\"internalType\":\"bfSummarize\",\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Unknown\",\"elementType\":\"\",\"options\":{\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Friend\'s Name\",\"name\":\"bfQuickMode21599\",\"page\":\"2\",\"orderNumber\":9,\"dbId\":55,\"appElementOrderId\":0,\"id\":0,\"logging\":false,\"qId\":\"bfQuickMode21599\",\"internalType\":\"bfSummarize\",\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Unknown\",\"elementType\":\"\",\"options\":{\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Friend\'s Email\",\"name\":\"bfQuickMode41439\",\"page\":\"2\",\"orderNumber\":10,\"dbId\":56,\"appElementOrderId\":0,\"id\":0,\"logging\":false,\"qId\":\"bfQuickMode41439\",\"internalType\":\"bfSummarize\",\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Unknown\",\"elementType\":\"\",\"options\":{\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Message\",\"name\":\"bfQuickMode34370\",\"page\":\"2\",\"orderNumber\":11,\"dbId\":57,\"appElementOrderId\":0,\"id\":0,\"logging\":false,\"qId\":\"bfQuickMode34370\",\"internalType\":\"bfSummarize\",\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"41\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle\",\"name\":\"bfFakeName\",\"page\":1,\"orderNumber\":0,\"dbId\":58,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"23\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle2\",\"name\":\"bfFakeName2\",\"page\":1,\"orderNumber\":0,\"dbId\":59,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"40\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle3\",\"name\":\"bfFakeName3\",\"page\":1,\"orderNumber\":0,\"dbId\":60,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"38\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle4\",\"name\":\"bfFakeName4\",\"page\":1,\"orderNumber\":0,\"dbId\":61,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"}],\"elementCount\":11}]', 3, 1, 0, 'sampleQuickModeTellaFriendForm', '', '', 'SAMPLE QuickMode Tell A Friend Form', 'Sample Tell A Friend form, with summary, for QuickMode', '', '', 400, 0, 500, 0, 3, 2, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, 'your@email.com', 1, 0, NULL, NULL, 2, NULL, 'function ff_sampleQuickModeTellaFriendForm_submitted(status, message){ff_switchpage(3);}', 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 2, 0, '');
INSERT INTO `jos3_facileforms_forms` (`id`, `alt_mailfrom`, `alt_fromname`, `mb_alt_mailfrom`, `mb_alt_fromname`, `mailchimp_email_field`, `mailchimp_checkbox_field`, `mailchimp_api_key`, `mailchimp_list_id`, `mailchimp_double_optin`, `mailchimp_mergevars`, `mailchimp_text_html_mobile_field`, `mailchimp_send_errors`, `mailchimp_update_existing`, `mailchimp_replace_interests`, `mailchimp_send_welcome`, `mailchimp_default_type`, `mailchimp_delete_member`, `mailchimp_send_goodbye`, `mailchimp_send_notify`, `mailchimp_unsubscribe_field`, `salesforce_token`, `salesforce_username`, `salesforce_password`, `salesforce_type`, `salesforce_fields`, `salesforce_enabled`, `dropbox_email`, `dropbox_password`, `dropbox_folder`, `dropbox_submission_enabled`, `dropbox_submission_types`, `tags_content`, `tags_content_template`, `tags_content_template_default_element`, `tags_form`, `tags_content_default_category`, `tags_content_default_state`, `tags_content_default_access`, `tags_content_default_language`, `tags_content_default_featured`, `tags_content_default_publishup`, `tags_content_default_publishdown`, `autoheight`, `package`, `template_code`, `template_code_processed`, `template_areas`, `ordering`, `published`, `runmode`, `name`, `custom_mail_subject`, `mb_custom_mail_subject`, `title`, `description`, `class1`, `class2`, `width`, `widthmode`, `height`, `heightmode`, `pages`, `emailntf`, `mb_emailntf`, `emaillog`, `mb_emaillog`, `emailxml`, `mb_emailxml`, `email_type`, `mb_email_type`, `email_custom_template`, `mb_email_custom_template`, `email_custom_html`, `mb_email_custom_html`, `emailadr`, `dblog`, `script1cond`, `script1id`, `script1code`, `script2cond`, `script2id`, `script2code`, `piece1cond`, `piece1id`, `piece1code`, `piece2cond`, `piece2id`, `piece2code`, `piece3cond`, `piece3id`, `piece3code`, `piece4cond`, `piece4id`, `piece4code`, `prevmode`, `prevwidth`, `filter_state`) VALUES
(12, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'Samples', '', '', '', 12, 1, 0, 'RnrContestList', '', '', 'Rock\'N\'Roll dance contest partipicant list', 'Partipicants list for the Rock\'N\'Roll dance contest. \r\n(Please run registration first in order to automaticly create tables)', '', '', 95, 1, 10, 1, 1, 0, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, '', 0, 0, NULL, NULL, 0, NULL, NULL, 1, 12, NULL, 0, NULL, NULL, 2, NULL, '//+trace dis\r\n\r\n// load the standard submit utilities\r\n$this->execPieceByName(\'ff_InitLib\');\r\n\r\n// get the userid to delete\r\n$deleteid = 0;\r\nforeach ($this->submitdata as $data)\r\n    if ($data[_FF_DATA_NAME]==\'deleteid\') {\r\n        $deleteid = $data[_FF_DATA_VALUE];\r\n        break;\r\n    } // if\r\n\r\n// delete the record if userid found\r\nif ($deleteid > 0)\r\n    ff_query(\"delete from `#__rnr_contest` where id=$deleteid\");', 0, NULL, NULL, 2, 450, ''),
(13, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'Samples', '', '', '', 13, 1, 0, 'SubmitContent', '', '', 'Submit Content', 'This form shows how content can be submitted by users.', 'content_outline', '', 420, 0, 500, 0, 3, 0, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, '', 0, 0, NULL, NULL, 0, NULL, NULL, 2, NULL, '//+trace dis\r\n\r\n// configuration variables\r\n$register = 1;  // 0 = public access, 1 = registred users only\r\n\r\n// load the standard piece library\r\n$this->execPieceByName(\'ff_InitLib\');  \r\n\r\n// check for registred users\r\nif ($register && JFactory::getUser()->get(\'id\',0) == 0) $this->page = 2;', 0, NULL, NULL, 2, NULL, '//+trace dis\r\n\r\n// configuration variables\r\n$moderate = 1;  // 0 = publish directly, 1 = leave unpublished\r\n\r\n// declare globals used in this piece\r\nglobal $Itemid;\r\n\r\n// load the standard piece library\r\n$this->execPieceByName(\'ff_InitLib\');\r\n\r\n// get values from submission\r\n$name     = ff_getSubmit(\'name\',     \'\');\r\n$title    = ff_getSubmit(\'title\',    \'\');\r\n$text     = ff_getSubmit(\'text\',     \'\');\r\n$section  = ff_getSubmit(\'section\',  0);\r\n$category = ff_getSubmit(\'category\', 0);\r\n\r\n// get the userid of a superadministrator. the article will be created\r\n// by the superadmin, but use as author alias the name of the person\r\n// who submitted it.\r\n$creator = ff_select(\"select id, email, sendEmail from #__users where gid=25\");\r\n$creator = $creator[0]; // take first row\r\n\r\n// format text, date and state\r\n$text = ff_markdown($text);\r\n$date = date( \"Y-m-d H:i:s\" );\r\nif ($moderate) $state = 0; else $state = 1;\r\n\r\n// save new submission into #__content table\r\nff_query(\r\n    \"insert into #__content \".\r\n        \"(title, title_alias, introtext, state, sectionid, \".\r\n         \"catid, created, created_by, created_by_alias) \".\r\n    \"values \".\r\n        \"(\'$title\', \'$title\', \'$text\', \'$state\', \'$section\', \".\r\n         \"\'$category\', \'$date\', \'$creator->id\', \'$name\')\"\r\n);\r\n\r\n// get section and cat name\r\n$section_name = ff_selectValue(\"select title from #__sections where id=\'$section\'\");\r\n$cat_name = ff_selectValue(\"select title from #__categories where id=\'$category\'\");\r\n\r\n// update #__messages table for backend notices\r\n$subject = \"New content submitted\";\r\n$message = \"A new product was submitted by [$name] \".\r\n           \"titled [$title] in section [$section_name] and category [$cat_name]\";\r\nff_query(\r\n    \"insert into #__messages (user_id_from, user_id_to, date_time, subject,message) \".\r\n    \"values (\'\".JFactory::getUser()->get(\'id\',0).\"\', \'$creator->id\', \'$date\', \'$subject\',\'$message\')\"\r\n);\r\n\r\n// send a mail notice to superadmin\r\nif ($creator->sendEmail) {\r\n    // if sent by unregistred we dont know the email\r\n    if (JFactory::getUser()->get(\'id\',0) != 0) $from = JFactory::getUser()->get(\'email\',\'\'); else $from = \"somebody@unknown.com\";\r\n    $this->sendMail(\r\n        $from,              // senders email\r\n        $name,              // senders name\r\n        $creator->email,    // recipient email\r\n        $subject,           // subject line\r\n        $message            // the message\r\n    );\r\n} // if\r\n\r\nff_redirectSelf(\"&ff_page=3\"); // show thank you page', 0, NULL, NULL, 2, 0, ''),
(3, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'QuickModeForms', '[encoded data, 12892 characters]', 'QuickMode', '[{\"elements\":[{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"44\",\"script3code\":\"\",\"script3msg\":\"Please fill in your first Name\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_valuenotempty\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"First Name\",\"name\":\"firstName\",\"page\":\"1\",\"orderNumber\":1,\"dbId\":62,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode6556417\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"44\",\"script3code\":\"\",\"script3msg\":\"Please tell us your last name.\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_valuenotempty\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Last Name\",\"name\":\"lastName\",\"page\":\"1\",\"orderNumber\":2,\"dbId\":63,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode3321721\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"42\",\"script3code\":\"\",\"script3msg\":\"Please fill in your email address\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_validemail\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Email\",\"name\":\"email\",\"page\":\"1\",\"orderNumber\":3,\"dbId\":64,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode9342370\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"44\",\"script3code\":\"\",\"script3msg\":\"Please fill in the donation amount\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_valuenotempty\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Donation Amount\",\"name\":\"bfQuickMode3720817\",\"page\":\"1\",\"orderNumber\":4,\"dbId\":65,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode3720817\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Hidden Input\",\"elementType\":\"\",\"options\":{\"readonly\":false},\"data1\":\"0.00\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"PayPal Select\",\"name\":\"PayPalSelect\",\"page\":\"1\",\"orderNumber\":5,\"dbId\":66,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode1698674\",\"internalType\":\"bfHidden\",\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"PayPal\",\"elementType\":\"\",\"options\":{\"testaccount\":true,\"useIpn\":true,\"downloadableFile\":false,\"filepath\":\"\",\"downloadTries\":\"1\",\"business\":\"yourprimary@PayPalEmailAddress.com\",\"token\":\"EnterTokenStringHere\",\"testBusiness\":\"primary@paypalaccount.com\",\"testToken\":\"EnterYourTestTokenHere\",\"itemname\":\"Donation\",\"itemnumber\":\"\",\"amount\":\"0\",\"tax\":\"0\",\"thankYouPage\":\"http:\\/\\/www.yourwebsite.com\\/index.php?option=com_breezingforms&ff_name=paypal_donation_form&ff_page=2\",\"locale\":\"us\",\"currencyCode\":\"USD\",\"image\":\"http:\\/\\/www.paypal.com\\/en_US\\/i\\/btn\\/btn_paynowCC_LG.gif\",\"sendNotificationAfterPayment\":true,\"readonly\":false},\"data1\":\"http:\\/\\/www.paypal.com\\/en_US\\/i\\/btn\\/btn_paynowCC_LG.gif\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":2,\"script2id\":0,\"script2code\":\"function ff_bfQuickMode5339732_action(element, action)\\n{\\n    switch (action) {\\n        case \'click\':\\nff_getElementByName(\'PayPalSelect\').value = \'Donation|0|\' + ff_getElementByName(\'bfQuickMode3720817\') + \'|0\';\\nff_validate_submit();\\n            break;\\n        default:;\\n    } \\/\\/ switch\\n} \\/\\/ ff_bfQuickMode5339732_action\\n\\n\",\"script2flag1\":1,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"ff_bfQuickMode5339732_action\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Submit Donation \",\"name\":\"bfQuickMode5339732\",\"page\":\"1\",\"orderNumber\":6,\"dbId\":67,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode5339732\",\"internalType\":\"bfPayPal\",\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"41\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle\",\"name\":\"bfFakeName\",\"page\":1,\"orderNumber\":0,\"dbId\":68,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"23\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle2\",\"name\":\"bfFakeName2\",\"page\":1,\"orderNumber\":0,\"dbId\":69,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"40\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle3\",\"name\":\"bfFakeName3\",\"page\":1,\"orderNumber\":0,\"dbId\":70,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"38\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle4\",\"name\":\"bfFakeName4\",\"page\":1,\"orderNumber\":0,\"dbId\":71,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"}],\"elementCount\":6}]', 4, 1, 0, 'SampleQuickModePaypalDonationForm', '', '', 'SAMPLE QuickMode PayPal Donation Form', 'Sample PayPal Donation Form (user enters a price into a textfield) for QuickMode', '', '', 200, 0, 500, 1, 2, 2, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, 'your@email.com', 1, 0, NULL, NULL, 2, NULL, 'function ff_SampleQuickModePaypalDonationForm_submitted(status, message){ff_switchpage(2);}', 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 2, 0, ''),
(9, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'Samples', '', '', '', 9, 1, 0, 'SampleEmbeddedCode', '', '', 'Embedded php code', 'Demonstrates the use of embedded php code in various ways.', '', '', 180, 0, 300, 0, 1, 0, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, '', 0, 2, NULL, 'function ff_SampleEmbeddedCode_init()\r\n{\r\n    alert(\r\n        \'This sample shows some applications of embedded php code:\\n\'+\r\n        \'\\n\'+\r\n        \'- Code in static text as personalized welcome\\n\'+\r\n        \'- Options of the select list are populated by a sql query\\n\'+\r\n        \'- A hidden input submitting the user id\\n\'+\r\n        \'\\n\'+\r\n        \'Embedded php code can be used in parameters of forms, elements \'+\r\n        \'and scripts that have a multiline textarea for editing.\'\r\n    );\r\n} // ff_SampleEmbeddedCode_init', 1, 32, NULL, 1, 12, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 2, 0, ''),
(10, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'Samples', '', '', '', 10, 1, 0, 'SamplePizzaShop', '', '', 'Pizza shop', 'A complete pizza order form with all bells and whistles. Only the selection of pizzas is very limited. And dont blame me if it doesn\'t arrive in time ;)', '', '', 400, 0, 400, 0, 6, 0, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, '', 1, 0, NULL, NULL, 2, NULL, 'function ff_SamplePizzaShop_submitted(status)\r\n{\r\n    if (status != 0) {\r\n        alert(\r\n            \"Sorry, but submission of you entries unfotunately failed.\\n\"+\r\n            \"We will check this problem and hope on your understanding.\\n\"+\r\n            \"You will be redirected to the home page now.\"\r\n        );\r\n        ff_returnHome();\r\n    } else\r\n        ff_switchpage(ff_getPageByName(\'pst_picture\')); // thank you\r\n} // ff_SamplePizzaShop_submitted', 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 2, 0, ''),
(11, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'Samples', '', '', '', 11, 1, 0, 'RnrContestRegist', '', '', 'Rock\'N\'Roll dance contest registration', 'This is the registration form for the Rock\'N\'Roll dance contest. Every site member can make one registration only in this sample. Existing registrations can be edited.', '', '', 350, 0, 200, 0, 2, 0, 1, 1, 1, 1, 0, 0, 0, NULL, NULL, 0, 0, '', 0, 2, NULL, 'function ff_RnrContestRegist_init()\r\n{\r\n    if (ff_getElementByName(\'userid\').value==\'0\') ff_switchpage(2);\r\n} // ff_RnrContestRegist_init', 0, NULL, NULL, 2, NULL, '//+trace dis\r\n\r\n// load the standard form creation utilities\r\n$this->execPieceByName(\'ff_InitLib\');\r\n\r\n// create table if it does not yet exist\r\nff_query(\r\n    \"CREATE TABLE IF NOT EXISTS `#__rnr_contest` (\".\r\n        \"`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,\".\r\n        \"`userid` INT( 11 ) DEFAULT \'0\' NOT NULL ,\".\r\n        \"`couple` VARCHAR( 50 ) NOT NULL ,\".\r\n        \"`age` TINYINT( 1 ) DEFAULT \'0\' NOT NULL ,\".\r\n        \"`acro` TINYINT( 1 ) DEFAULT \'0\' NOT NULL ,\".\r\n        \"`fun` TINYINT( 1 ) DEFAULT \'0\' NOT NULL ,\".\r\n        \"`boogie` TINYINT( 1 ) DEFAULT \'0\' NOT NULL,\".\r\n        \"PRIMARY KEY  (`id`)\".\r\n    \") TYPE=MyISAM AUTO_INCREMENT=1\"\r\n);\r\n\r\n// load old record if any\r\nglobal $record;\r\n$rows = ff_select(\"select * from `#__rnr_contest` where userid=\".JFactory::getUser()->get(\'id\',0));\r\nif (count($rows)) {\r\n   $record = $rows[0];\r\n   ff_setChecked(\'age\', $record->age);\r\n   if ($record->acro  ) ff_setChecked(\'acro\'  ,\'1\');\r\n   if ($record->fun   ) ff_setChecked(\'fun\'   ,\'1\');\r\n   if ($record->boogie) ff_setChecked(\'boogie\',\'1\');\r\n} else\r\n   $record = NULL;', 0, NULL, NULL, 2, NULL, '//+trace dis\r\n\r\n// load the standard submit utilities\r\n$this->execPieceByName(\'ff_InitLib\');\r\n\r\n// retrieve the submitted values\r\n$recordid = ff_getSubmit(\'recordid\');\r\n$userid   = JFactory::getUser()->get(\'id\',0);\r\n$couple   = ff_getSubmit(\'couple\', \'\');\r\n$age      = ff_getSubmit(\'age\',    0);\r\n$acro     = ff_getSubmit(\'acro\',   0);\r\n$fun      = ff_getSubmit(\'fun\',    0);\r\n$boogie   = ff_getSubmit(\'boogie\', 0);\r\n\r\nif (is_numeric($recordid))\r\n    // update existing record\r\n    ff_query(\r\n        \"update `#__rnr_contest` \".\r\n           \"set `couple` = \'$couple\', \".\r\n               \"`age`    = \'$age\', \".\r\n               \"`acro`   = \'$acro\', \".\r\n               \"`fun`    = \'$fun\', \".\r\n               \"`boogie` = \'$boogie\' \".\r\n         \"where `id`     = $recordid\"\r\n    );\r\nelse\r\n    // save new record\r\n    ff_query(\r\n        \"insert into `#__rnr_contest` \".\r\n            \"(`userid`, `couple`, `age`, `acro`, `fun`, `boogie`) \".\r\n        \"values (\'$userid\', \'$couple\', \'$age\', \'$acro\', \'$fun\', \'$boogie\')\"\r\n    );', 2, NULL, 'ff_redirectForm(\"RnrContestList\");', 2, 0, '');
INSERT INTO `jos3_facileforms_forms` (`id`, `alt_mailfrom`, `alt_fromname`, `mb_alt_mailfrom`, `mb_alt_fromname`, `mailchimp_email_field`, `mailchimp_checkbox_field`, `mailchimp_api_key`, `mailchimp_list_id`, `mailchimp_double_optin`, `mailchimp_mergevars`, `mailchimp_text_html_mobile_field`, `mailchimp_send_errors`, `mailchimp_update_existing`, `mailchimp_replace_interests`, `mailchimp_send_welcome`, `mailchimp_default_type`, `mailchimp_delete_member`, `mailchimp_send_goodbye`, `mailchimp_send_notify`, `mailchimp_unsubscribe_field`, `salesforce_token`, `salesforce_username`, `salesforce_password`, `salesforce_type`, `salesforce_fields`, `salesforce_enabled`, `dropbox_email`, `dropbox_password`, `dropbox_folder`, `dropbox_submission_enabled`, `dropbox_submission_types`, `tags_content`, `tags_content_template`, `tags_content_template_default_element`, `tags_form`, `tags_content_default_category`, `tags_content_default_state`, `tags_content_default_access`, `tags_content_default_language`, `tags_content_default_featured`, `tags_content_default_publishup`, `tags_content_default_publishdown`, `autoheight`, `package`, `template_code`, `template_code_processed`, `template_areas`, `ordering`, `published`, `runmode`, `name`, `custom_mail_subject`, `mb_custom_mail_subject`, `title`, `description`, `class1`, `class2`, `width`, `widthmode`, `height`, `heightmode`, `pages`, `emailntf`, `mb_emailntf`, `emaillog`, `mb_emaillog`, `emailxml`, `mb_emailxml`, `email_type`, `mb_email_type`, `email_custom_template`, `mb_email_custom_template`, `email_custom_html`, `mb_email_custom_html`, `emailadr`, `dblog`, `script1cond`, `script1id`, `script1code`, `script2cond`, `script2id`, `script2code`, `piece1cond`, `piece1id`, `piece1code`, `piece2cond`, `piece2id`, `piece2code`, `piece3cond`, `piece3id`, `piece3code`, `piece4cond`, `piece4id`, `piece4code`, `prevmode`, `prevwidth`, `filter_state`) VALUES
(4, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'QuickModeForms', '[encoded data, 10176 characters]', 'QuickMode', '[{\"elements\":[{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"44\",\"script3code\":\"\",\"script3msg\":\"Please fill in your Name\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_valuenotempty\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"First Name\",\"name\":\"bfQuickMode6556417\",\"page\":\"1\",\"orderNumber\":1,\"dbId\":72,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode6556417\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"44\",\"script3code\":\"\",\"script3msg\":\"Please enter your last name.\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_valuenotempty\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Last Name\",\"name\":\"bfQuickMode3321721\",\"page\":\"1\",\"orderNumber\":2,\"dbId\":73,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode3321721\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":0,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"42\",\"script3code\":\"\",\"script3msg\":\"Please fill in your email address\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_validemail\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Email\",\"name\":\"bfQuickMode9342370\",\"page\":\"1\",\"orderNumber\":3,\"dbId\":74,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode9342370\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"PayPal\",\"elementType\":\"\",\"options\":{\"testaccount\":true,\"useIpn\":true,\"downloadableFile\":false,\"filepath\":\"\",\"downloadTries\":\"1\",\"business\":\"your@PrimaryPayPalEmailAddress.com\",\"token\":\"EnterTokenStringHere\",\"testBusiness\":\"primary@paypalaccount.com\",\"testToken\":\"EnterYourTestTokenHere\",\"itemname\":\"Test\",\"itemnumber\":\"1\",\"amount\":\".01\",\"tax\":\"0\",\"thankYouPage\":\"http:\\/\\/www.yourdomain.com\\/index.php?option=com_breezingforms&ff_name=paypalForm&ff_page=2\",\"locale\":\"us\",\"currencyCode\":\"USD\",\"image\":\"http:\\/\\/www.paypal.com\\/en_US\\/i\\/btn\\/btn_paynowCC_LG.gif\",\"sendNotificationAfterPayment\":true,\"readonly\":false},\"data1\":\"http:\\/\\/www.paypal.com\\/en_US\\/i\\/btn\\/btn_paynowCC_LG.gif\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"41\",\"script2code\":\"function ff_bfQuickMode5339732_action(element, action)\\n{\\n    switch (action) {\\n        case \'click\':\\nff_getElementByName(\'PayPalSelect\').value = \'Donation|0|\' + ff_getElementByName(\'bfQuickMode3720817\') + \'|0\';\\nff_validate_submit();\\n            break;\\n        default:;\\n    } \\/\\/ switch\\n} \\/\\/ ff_bfQuickMode5339732_action\\n\\n\",\"script2flag1\":1,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"ff_validate_submit\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Pay Now\",\"name\":\"payNow\",\"page\":\"1\",\"orderNumber\":4,\"dbId\":75,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"bfQuickMode5339732\",\"internalType\":\"bfPayPal\",\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"41\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle\",\"name\":\"bfFakeName\",\"page\":1,\"orderNumber\":0,\"dbId\":76,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"23\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle2\",\"name\":\"bfFakeName2\",\"page\":1,\"orderNumber\":0,\"dbId\":77,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"40\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle3\",\"name\":\"bfFakeName3\",\"page\":1,\"orderNumber\":0,\"dbId\":78,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"38\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle4\",\"name\":\"bfFakeName4\",\"page\":1,\"orderNumber\":0,\"dbId\":79,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"}],\"elementCount\":4}]', 15, 1, 0, 'SampleQuickModePayPalForm', '', '', 'SAMPLE QuickMode PayPal Form (Regular Button)', 'Paypal form for QuickMode with single PayPal button', '', '', 200, 0, 500, 1, 2, 2, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, 'your@email.com', 1, 0, NULL, NULL, 2, NULL, 'function ff_SampleQuickModePayPalForm_submitted(status, message){ff_switchpage(2);}', 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 2, 0, ''),
(5, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'Samples', '', '', '', 5, 1, 0, 'SampleContactForm', '', '', 'Contact form', 'This sample is a basic contact form everybody should be able to master. It does not require any scripting skills to make such a form.', '', '', 400, 0, 450, 0, 1, 1, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, '', 2, 0, NULL, NULL, 1, 34, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 2, 0, ''),
(6, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'Samples', '', '', '', 6, 1, 0, 'SampleTabNavigation', '', '', 'Using tabs for page navigation', 'Demonstrates how you can build a dialog with tabs for each page. It also shows another reasonable use of rectangles besides framing and highlighting contents.', '', '', 470, 0, 420, 0, 3, 0, 1, 0, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, '', 0, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 2, 0, ''),
(7, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'Samples', '', '', '', 7, 1, 0, 'SampleCountrySelect', '', '', 'Country selection', 'Shows the interaction between logically connected select lists, as well as dynamic replacement of select list options. Not really stuff for rookies.', '', '', 320, 0, 240, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, '', 0, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 2, 0, ''),
(8, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'Samples', '', '', '', 8, 1, 0, 'SamplePieceApp', '', '', 'Piece sending mail', 'Shows how a piece can be used to send a mail to an arbitraty address. \r\nIt takes the fields email, subject and message from the form to send a mail.', '', '', 350, 0, 400, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, '', 0, 0, NULL, NULL, 1, 32, NULL, 0, NULL, NULL, 0, NULL, NULL, 2, NULL, '// declare globals used in this piece\r\nglobal $mosConfig_mailfrom, $mosConfig_fromname;\r\n\r\n// include FacileForms standard library\r\n$this->execPieceByName(\'ff_InitLib\');\r\n\r\n// send the mail\r\n$this->sendMail(\r\n    $mosConfig_mailfrom,                // email addr of submitter (1)\r\n    $mosConfig_fromname.\' - Message\',   // name of submitter (1)\r\n    ff_getSubmit(\'email\'),              // email of recipient (2)\r\n    ff_getSubmit(\'subject\'),            // subject of the mail (3)\r\n    ff_getSubmit(\'message\')             // body of the mail (3)\r\n);\r\n\r\n/*--------------------------------------------------------------------\r\nNotes:\r\n\r\n(1) In this sample we use the site admin as submitter of the email,\r\n    but basicly you could use anything. Note that many mail servers \r\n    however impose constraints about the submitters email address and\r\n    in case refuse to sent the mail to prevent from spamming. (This\r\n    will mostly be reported as \'relaying denied\').\r\n\r\n(2) Recipient can also be an array of email addresses if you want to \r\n    send the same mail to multiple recipients. Note that all email\r\n    adresses will however be visible to all recipients, so maybe\r\n    it is better to call $this->sendMail for each recipient \r\n    individually.\r\n\r\n(3) Subject and body could of cause also be composed here in the \r\n    piece instead of taking it completely from the submitted values.\r\n--------------------------------------------------------------------*/', 0, NULL, NULL, 2, 0, ''),
(14, NULL, NULL, NULL, NULL, '', '', '', '', 1, NULL, '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, 'pdf', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'Samples', '', '', '', 14, 1, 0, 'SubmitContentPreview', '', '', 'Submit Content Preview', 'This is the preview form for the content submit piece. \r\nIt is not meant to be called directly, but by form\r\nSubmitContent.', 'content_outline', '', 100, 1, 10, 1, 1, 0, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, '', 0, 0, NULL, NULL, 0, NULL, NULL, 1, 12, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, 2, 400, ''),
(15, 'remitent alternatiu admin', 'Administrador AMICS de l\'AIGUA', 'Remitent Alternatiu', 'AMICS de l\'AIGUA', '', '', '', '', 1, '', '', 0, 0, 0, 0, 'text', 0, 1, 1, '', '', '', '', '', NULL, 0, '', '', '', 0, '', '', '', 0, '', 0, 1, 1, '*', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'QuickModeForms', '[encoded data, 11324 characters]', 'QuickMode', '[{\"elements\":[{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":\"8\",\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":\"16\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"44\",\"script3code\":\"\",\"script3msg\":\"El camp Nom \\u00e9s necessari.\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_valuenotempty\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Nom\",\"name\":\"name\",\"page\":\"1\",\"orderNumber\":1,\"dbId\":\"220\",\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"name\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":\"8\",\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":\"16\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"42\",\"script3code\":\"\",\"script3msg\":\"El Correu Electr\\u00f2nic especificat \\u00e9s incorrecte.\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_validemail\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Correu Electr\\u00f2nic\",\"name\":\"email\",\"page\":\"1\",\"orderNumber\":2,\"dbId\":\"221\",\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"email\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Text\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"password\":false,\"mailback\":false,\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":\"8\",\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":\"16\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"44\",\"script3code\":\"\",\"script3msg\":\"El camp Assumpte \\u00e9s necessari.\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_valuenotempty\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Assumpte\",\"name\":\"subject\",\"page\":\"1\",\"orderNumber\":3,\"dbId\":235,\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"subject\",\"internalType\":\"bfTextfield\",\"mailbackAsSender\":0,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Textarea\",\"elementType\":\"\",\"options\":{\"value\":\"\",\"placeholder\":\"\",\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":\"8\",\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":\"16\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":1,\"script3id\":\"44\",\"script3code\":\"\",\"script3msg\":\"El camp Missatge \\u00e9s necessari.\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"ff_valuenotempty\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Missatge\",\"name\":\"message\",\"page\":\"1\",\"orderNumber\":4,\"dbId\":\"222\",\"appElementOrderId\":0,\"id\":0,\"logging\":true,\"qId\":\"message\",\"internalType\":\"bfTextarea\",\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"Captcha\",\"elementType\":\"\",\"options\":{\"readonly\":false},\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":0,\"script2id\":null,\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"Codi de Seguretat\",\"name\":\"captcha\",\"page\":\"1\",\"orderNumber\":5,\"dbId\":236,\"appElementOrderId\":0,\"id\":0,\"logging\":false,\"qId\":\"captcha\",\"internalType\":\"bfCaptcha\",\"width\":300,\"tabIndex\":\"-1\",\"hideInMailback\":false},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"41\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle\",\"name\":\"bfFakeName\",\"page\":1,\"orderNumber\":0,\"dbId\":257,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"23\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle2\",\"name\":\"bfFakeName2\",\"page\":1,\"orderNumber\":0,\"dbId\":258,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"40\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle3\",\"name\":\"bfFakeName3\",\"page\":1,\"orderNumber\":0,\"dbId\":259,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"},{\"element\":null,\"bfType\":\"\",\"elementType\":\"\",\"options\":[],\"data1\":\"\",\"data2\":\"\",\"data3\":\"\",\"script1cond\":0,\"script1id\":0,\"script1code\":\"\",\"script1flag1\":0,\"script1flag2\":0,\"script2cond\":1,\"script2id\":\"38\",\"script2code\":\"\",\"script2flag1\":0,\"script2flag2\":0,\"script2flag3\":0,\"script2flag4\":0,\"script2flag5\":0,\"script3cond\":0,\"script3id\":0,\"script3code\":\"\",\"script3msg\":\"\",\"functionNameScript1\":\"\",\"functionNameScript2\":\"\",\"functionNameScript3\":\"\",\"flag1\":0,\"flag2\":0,\"mailback\":0,\"mailbackfile\":\"\",\"title\":\"bfFakeTitle4\",\"name\":\"bfFakeName4\",\"page\":1,\"orderNumber\":0,\"dbId\":260,\"appElementOrderId\":0,\"id\":0,\"logging\":0,\"qId\":0,\"internalType\":\"\"}],\"elementCount\":5}]', 1, 1, 0, 'QFCA01', 'Solicitut d\'Informació des de la web', 'AMICS de l\'AIGUA - Contacte', 'Formulari de Contacte CA', 'Formulari de Contacte CA', '', '', 400, 0, 500, 0, 2, 2, 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 'info@amicsaigua.com', 1, 0, 31, '', 2, 32, 'function ff_QFCA01_submitted(status, message){if(status==0){ff_switchpage(2);}else{alert(message);}}', 0, 1, '', 0, NULL, '', 0, 5, '', 0, NULL, '', 2, 0, '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_facileforms_integrator_criteria_fixed`
--

CREATE TABLE `jos3_facileforms_integrator_criteria_fixed` (
  `id` int(11) NOT NULL,
  `rule_id` int(11) NOT NULL,
  `reference_column` varchar(255) NOT NULL,
  `operator` varchar(255) NOT NULL,
  `fixed_value` text NOT NULL,
  `andor` varchar(3) NOT NULL DEFAULT 'AND'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_facileforms_integrator_criteria_form`
--

CREATE TABLE `jos3_facileforms_integrator_criteria_form` (
  `id` int(11) NOT NULL,
  `rule_id` int(11) NOT NULL,
  `reference_column` varchar(255) NOT NULL,
  `operator` varchar(255) NOT NULL,
  `element_id` varchar(255) NOT NULL,
  `andor` varchar(3) NOT NULL DEFAULT 'AND'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_facileforms_integrator_criteria_joomla`
--

CREATE TABLE `jos3_facileforms_integrator_criteria_joomla` (
  `id` int(11) NOT NULL,
  `rule_id` int(11) NOT NULL,
  `reference_column` varchar(255) NOT NULL,
  `operator` varchar(255) NOT NULL,
  `joomla_object` varchar(255) NOT NULL,
  `andor` varchar(3) NOT NULL DEFAULT 'AND'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_facileforms_integrator_items`
--

CREATE TABLE `jos3_facileforms_integrator_items` (
  `id` int(11) NOT NULL,
  `rule_id` int(11) NOT NULL,
  `element_id` int(11) NOT NULL,
  `reference_column` varchar(255) NOT NULL,
  `code` text NOT NULL,
  `published` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_facileforms_integrator_rules`
--

CREATE TABLE `jos3_facileforms_integrator_rules` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `form_id` int(11) NOT NULL,
  `reference_table` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'insert',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `finalize_code` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_facileforms_packages`
--

CREATE TABLE `jos3_facileforms_packages` (
  `id` varchar(30) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `version` varchar(30) NOT NULL DEFAULT '',
  `created` varchar(20) NOT NULL DEFAULT '',
  `title` varchar(50) NOT NULL DEFAULT '',
  `author` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `url` varchar(50) NOT NULL DEFAULT '',
  `description` varchar(100) NOT NULL DEFAULT '',
  `copyright` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `jos3_facileforms_packages`
--

INSERT INTO `jos3_facileforms_packages` (`id`, `name`, `version`, `created`, `title`, `author`, `email`, `url`, `description`, `copyright`) VALUES
('', 'mypck_001', '0.0.1', '2005-07-31 22:21:23', 'My First Package', 'My Name', 'my.name@my.domain', 'http://www.my.domain', 'This is the first package that I created', 'This FacileForms package is released under the GNU/GPL license'),
('FF', 'stdlib.english', '1.8', '2012-09-21 11:50:15', 'BreezingForms-Standard Piece and Script Libraries', 'Markus Bopp', 'markus.bopp@crosstec.org', 'http://www.crosstec.org', 'These are the standard BreezingForms script and piece libraries.', 'This BreezingForms package is released under the GNU/GPL license'),
('QuickModeSamples', 'QuickModeSamples', '0.0.1', '2010-06-21 16:58:49', 'QuickMode Sample Forms', 'Crosstec', 'support@crosstec.de', 'http://www.crosstec.de', 'Sample Forms for QuickMode (Contact, Tell a Friend, PayPal Payment, PayPal Donation)', 'This FacileForms package is released under the GNU/GPL license'),
('samples.english', 'samples.english', '0.0.1', '2010-06-22 00:14:24', 'ClassicMode Sample Package', 'Markus Bopp', 'markus.bopp@crosstec.de', 'http://www.crosstec.de', 'These are the original samples that come with BreezingForms (former FacileForms)', 'This BreezingForms package is released under the GNU/GPL license');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_facileforms_pieces`
--

CREATE TABLE `jos3_facileforms_pieces` (
  `id` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `package` varchar(30) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` text,
  `type` varchar(30) NOT NULL DEFAULT '',
  `code` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `jos3_facileforms_pieces`
--

INSERT INTO `jos3_facileforms_pieces` (`id`, `published`, `package`, `name`, `title`, `description`, `type`, `code`) VALUES
(1, 1, 'FF', 'ff_addCustomCSSFile', 'Add custom CSS File', 'Adds a custom css file to the form. To choose a css file, execute this piece and call the function ff_addCustomCSSFile(\'path/to/css/file\') with the RELATIVE (not full!) path to your joomla installation.\r\nDo not forget to call $this->execPieceByName(\'ff_InitLib\') before!\r\n\r\nExample:\r\n\r\nglobal $mainframe;\r\n\r\n$this->execPieceByName(\'ff_InitLib\');\r\n$this->execPieceByName(\'ff_addCustomCSSFile\');\r\n\r\nff_addCustomCSSFile(\'templates/\' . $mainframe->getTemplate() . \'/css/template.css\');', 'Before Form', 'function ff_addCustomCSSFile($path){\r\n	if(file_exists(JPATH_SITE . \'/\' . $path)){\r\n		JFactory::getDocument()->addStyleSheet(JURI::root() . $path);\r\n	}\r\n}'),
(2, 1, 'FF', 'ff_Constants', 'Constansts definitions', 'Library constants definitions', 'Before Form', 'define(\'FF_DIE\',       \'_ff_die_on_errors_\');\r\ndefine(\'FF_DONTDIE\',   \'_ff_stay_alive_\');\r\ndefine(\'FF_IGNOREDIE\', \'_ff_ignore_if_dying_\');\r\n\r\ndefine(\'FF_ARRAY\',     \'_ff_return_as_array_\');\r\ndefine(\'FF_LIST\',      \'_ff_return_as_list_\');\r\ndefine(\'FF_SLIST\',     \'_ff_return_as_slist_\');\r\ndefine(\'FF_DLIST\',     \'_ff_return_as_dlist_\');\r\n\r\ndefine(\'FF_NOTRIM\',    1);\r\ndefine(\'FF_ALLOWHTML\', 2);\r\ndefine(\'FF_ALLOWRAW\',  4);'),
(3, 1, 'FF', 'ff_die', 'Terminate form gracefully', 'Gracefully terminates the form and shows a message plus opionally a \r\nCONTINUE button for further redirection.\r\n\r\nCall:\r\n\r\n    ff_die($message=null, $action=\'stop\', $target=\'\', $params=\'\', $label=\'Continue\');\r\n    return;\r\n\r\n    $message = A message to display. If no message is provided, it will\r\n               display:\r\n\r\n                    Fatal error in $formname, processing stopped.\r\n\r\n    $action  = \'stop\' : Dont show a CONTINUE button (default)\r\n               \'self\' : Redirect to the same form\r\n               \'form\' : Redirect to another form \r\n               \'page\' : Redirect to another page of this site\r\n               \'home\' : Redirect to homepage of the site\r\n               \'url\'  : Redirect to a url\r\n\r\n    $target  = Target name/url for \'form\', \'page\' and \'url\'\r\n\r\n    $params  = Additional parameters for \'self\' and \'form\'\r\n\r\n    $label   = Text for the continue button\r\n\r\nExamples:\r\n\r\n    // Display standard message without continue button\r\n    ff_die(); \r\n\r\n    // Display message without continue button\r\n    ff_die(\'Sorry, cannot continue for some reason.\');\r\n\r\n    // Display standard message and return to same form with a parameter\r\n    ff_die(null, \'self\', \'&ff_param_foo=bar\');\r\n\r\n    // Redirect to another form\r\n    ff_die(\'Guess you are hungry now...\', \'form\', \'SamplePizzaShop\', null, \'Order\');\r\n\r\n    // Redirect to another site page\r\n    ff_die(\r\n        \'Something strange has happened!\', \r\n        \'page\', \r\n        \'index.php?option=com_content&task=section&id=1&Itemid=2\'\r\n    );', 'Untyped', 'function ff_die($message=\'\', $action=\'stop\', $target=\'\', $params=\'\', $label=\'Continue\')\r\n{\r\n    global $ff_processor;\r\n    if ($ff_processor->dying) return;\r\n\r\n    ob_end_clean();\r\n    $form =& $ff_processor->formrow;\r\n    if (!$message) \r\n        $message = \r\n            \"<strong>Fatal error in $form->name, form processing halted.</strong>\";\r\n    switch ($action) {\r\n        case \'self\': $url = ff_makeSelfUrl($params); break;\r\n        case \'form\': $url = ff_makeFormUrl($target, $params); break;\r\n        case \'page\': $url = ff_makePageUrl($target); break;\r\n        case \'home\': $url = \"{mossite}\"; break;\r\n        case \'url\' : $url = $target; break;\r\n        default    : $url = \'\';\r\n    } // switch\r\n    if ($form->class1 != \'\') echo \'<div class=\"\'.$form->class1.\'\">\'.nl();\r\n    echo($message.\'<br/><br/><br/>\'.nl());\r\n    if ($url) {\r\n        if (!$ff_processor->inline) echo \'<form action=\"#redirect\">\'.nl();\r\n        if ($ff_processor->inframe) $t = \'parent\'; else $t = \'document\';\r\n        echo \'<input type=\"button\" class=\"button\" value=\"\'.$label.\'\"\'.\r\n             \' onClick=\"\'.$t.\'.location.href=\\\'\'.htmlentities($url,ENT_QUOTES).\'\\\';\"\'.\r\n             \'/>\'.nl();\r\n        if (!$ff_processor->inline) echo \'</form>\'.nl();\r\n    } // if\r\n    if ($form->class1 != \'\') echo \'</div>\'.nl();\r\n    unset($form);\r\n    ob_start();\r\n    $ff_processor->suicide();\r\n} // ff_die'),
(4, 1, 'FF', 'ff_DisableFormTrace', 'Disable tracing at view time', 'Disables tracing for use as before form piece', 'Before Form', '//+trace dis'),
(5, 1, 'FF', 'ff_DisableSubmitTrace', 'Disable tracing at submit time', 'Disables tracing for use as begin submit piece', 'Begin Submit', '//+trace dis'),
(6, 1, 'FF', 'ff_dying', 'Query live status', 'Query if form is dying', 'Untyped', '//+trace max none\r\nfunction ff_dying()\r\n{\r\n    global $ff_processor; \r\n    return $ff_processor->dying;\r\n} // ff_dying'),
(7, 1, 'FF', 'ff_expString', 'String export', 'Export string function: escapes special characters in c-codes', 'Untyped', 'function ff_expString($text)\r\n{\r\n    return expstring($text);\r\n} // ff_expString'),
(8, 1, 'FF', 'ff_getPageByNameX', 'Get page # by element name', 'Gets the page number by the name of an element. \r\nTypically used to redirect to a certain page in a before form piece \r\nas \r\n\r\n    $this->page = ff_getPageByName(\'elementname\');', 'Untyped', 'function ff_getPageByName($name)\r\n{\r\n    global $ff_processor;\r\n    foreach($ff_processor->rows as $row)\r\n        if ($row->name==$name)\r\n            return $row->page;\r\n    return null;\r\n} // ff_getPageByName'),
(9, 1, 'FF', 'ff_getParam', 'Get GET/POST parameter', 'Direct replacement for mosGetParam. ff_getParam will attempt to filter \r\nout parameters that are targeted to another form on the same page.', 'Untyped', 'function ff_getParam($name, $default=null, $mask=0)\r\n{\r\n    global $ff_request;\r\n    if (substr($name,0,9)==\'ff_param_\') {\r\n        if (!isset($ff_request[$name])) return $default;\r\n        $val = $ff_request[$name];\r\n    } else {\r\n        if (!isset($_REQUEST[$name])) return $default;\r\n        $val = $_REQUEST[$name];\r\n    } // if\r\n    $dotrim = ($mask & FF_NOTRIM)==0;\r\n    $dostrp = ($mask & FF_ALLOWHTML)==0;\r\n    $addsla = ($mask & FF_ALLOWRAW)==0 && !get_magic_quotes_gpc();\r\n    $remsla = ($mask & FF_ALLOWRAW)!=0 && get_magic_quotes_gpc();\r\n    if (is_array($val)) {\r\n        $cnt = count($val);\r\n        for ($v = 0; $v < $cnt; $v++)\r\n            if (is_string($val[$v])) {\r\n                if ($dotrim) $val[$v] = trim($val[$v]);\r\n                if ($dostrp) $val[$v] = strip_tags($val[$v]);\r\n                if ($addsla) $val[$v] = addslashes($val[$v]);\r\n                if ($remsla) $val[$v] = stripslashes($val[$v]);\r\n            } // if\r\n    } else {\r\n        if (is_string($val)) {\r\n            if ($dotrim) $val = trim($val);\r\n            if ($dostrp) $val = strip_tags($val);\r\n            if ($addsla) $val = addslashes($val);\r\n            if ($remsla) $val = stripslashes($val);\r\n        } // if\r\n    } // if\r\n    return $val;\r\n} // ff_getParam'),
(10, 1, 'FF', 'ff_getSubmit', 'Get submited data', 'Returns submitdata either as scalar, array or list. In case of list the values\r\nare returned as a string with the values concatenated by comma.\r\n\r\nExamples:\r\n\r\n// Get as scalar: Optionally pass a default value as second parameter.\r\n// If no default is provided, it will return NULL if no value was submitted\r\n\r\n    $myval = ff_getSubmit(\'myvar\');        // return NULL if not submitted\r\n\r\n    $myval = ff_getSubmit(\'myvar\',1);      // return 1 if not submitted\r\n\r\n    $myval = ff_getSubmit(\'myvar\',\'foo\');  // return \'foo\' if not submitted\r\n\r\n    ff_query(\r\n        \"insert into #__mytable(id, name) \".\r\n        \"values (\'\".\r\n            ff_getSubmit(\'id\').\", \".\r\n            ff_getSubmit(\'name\',\'unknown\').\r\n        \"\')\"\r\n    );\r\n\r\n// Get as array: Pass FF_ARRAY as second Parameter\r\n\r\n    $myarr = $ff_getSubmit(\'myarr\', FF_ARRAY);\r\n\r\n    foreach ($myarr as $myval) ...\r\n\r\n// Get as list: Pass either FF_LIST, FF_SLIST or FF_DLIST as 2nd parameter.\r\n\r\n    // FF_LIST will return numeric data unquoted and strings in single quotes:\r\n    //    1,2,\'a\',4\r\n\r\n    // FF_SLIST will return all data single quoted:\r\n    //    \'1\',\'2\',\'a\',\'4\'\r\n\r\n    // FF_DLIST will return all data double quoted:\r\n    //    \"1\",\"2\",\"a\",\"4\"\r\n\r\n    ff_query(\r\n        \"delete from #__mytable \".\r\n        \"where id in (\".ff_getSubmit(\'itemlist\',FF_LIST).\")\"\r\n    );', 'Untyped', 'function ff_getSubmit($name, $default=null)\r\n{\r\n    global $ff_processor;\r\n\r\n    switch ((string)$default) {\r\n        case FF_ARRAY: $value = array(); break;\r\n        case FF_LIST : \r\n        case FF_SLIST:\r\n        case FF_DLIST: $value = \'\'; break;\r\n        default      : $value = $default;\r\n    } // switch\r\n    foreach ($ff_processor->submitdata as $data)\r\n        if ($data[_FF_DATA_NAME]==$name) {\r\n            $q = \'\';\r\n            switch ((string)$default) {\r\n                case FF_ARRAY:\r\n                    $value[] = $data[_FF_DATA_VALUE];\r\n                    break;\r\n                case FF_SLIST:\r\n                    $q = \"\'\";\r\n                case FF_DLIST:\r\n                    if ($q==\'\') $q = \'\"\';\r\n                case FF_LIST:\r\n                    if ($q==\'\' && !is_numeric($data[_FF_DATA_VALUE])) $q = \"\'\";\r\n                    if ($value!=\'\') $value.=\',\';\r\n                    $value .= $q.$data[_FF_DATA_VALUE].$q;\r\n                    break;\r\n                default:\r\n                    return $data[_FF_DATA_VALUE];\r\n            } // switch\r\n         } // if\r\n    return $value;\r\n} // ff_getSubmit'),
(11, 1, 'FF', 'ff_impString', 'String import', 'Import string function: unescapes c-coded characters of a string', 'Untyped', 'function ff_impString($text)\r\n{\r\n    return impstring($text);\r\n} // ff_impString'),
(12, 1, 'FF', 'ff_InitLib', 'Init Library', 'A collection of useful functions for use in form pieces. \r\n\r\nInclude by: \r\n\r\n    $this->execPieceByName(\'ff_InitLib\');', 'Before Form', '//+trace high none\r\nif (!defined(\'FF_DIE\'))                    $this->execPieceByName(\'ff_Constants\');\r\nif (!function_exists(\'ff_expstring\'))      $this->execPieceByName(\'ff_expstring\');\r\nif (!function_exists(\'ff_makePageUrl\'))    $this->execPieceByName(\'ff_makePageUrl\');\r\nif (!function_exists(\'ff_makeFormUrl\'))    $this->execPieceByName(\'ff_makeFormUrl\');\r\nif (!function_exists(\'ff_makeSelfUrl\'))    $this->execPieceByName(\'ff_makeSelfUrl\');\r\nif (!function_exists(\'ff_die\'))            $this->execPieceByName(\'ff_die\');\r\nif (!function_exists(\'ff_dying\'))          $this->execPieceByName(\'ff_dying\');\r\nif (!function_exists(\'ff_redirect\'))       $this->execPieceByName(\'ff_redirect\');\r\nif (!function_exists(\'ff_redirectParent\')) $this->execPieceByName(\'ff_redirectParentX\');\r\nif (!function_exists(\'ff_redirectPage\'))   $this->execPieceByName(\'ff_redirectPage\');\r\nif (!function_exists(\'ff_redirectForm\'))   $this->execPieceByName(\'ff_redirectForm\');\r\nif (!function_exists(\'ff_redirectSelf\'))   $this->execPieceByName(\'ff_redirectSelf\');\r\nif (!function_exists(\'ff_setChecked\'))     $this->execPieceByName(\'ff_setCheckedX\');\r\nif (!function_exists(\'ff_setSelected\'))    $this->execPieceByName(\'ff_setSelectedX\');\r\nif (!function_exists(\'ff_setValue\'))       $this->execPieceByName(\'ff_setValueX\');\r\nif (!function_exists(\'ff_getPageByName\'))  $this->execPieceByName(\'ff_getPageByNameX\');\r\nif (!function_exists(\'ff_getParam\'))       $this->execPieceByName(\'ff_getParam\');\r\nif (!function_exists(\'ff_getSubmit\'))      $this->execPieceByName(\'ff_getSubmit\');\r\nif (!function_exists(\'ff_impString\'))      $this->execPieceByName(\'ff_impString\');\r\nif (!function_exists(\'ff_expString\'))      $this->execPieceByName(\'ff_expString\');\r\nif (!function_exists(\'ff_securityImage\'))  $this->execPieceByName(\'ff_securityImage\');\r\nif (!function_exists(\'ff_select\'))         $this->execPieceByName(\'ff_select\');\r\nif (!function_exists(\'ff_selectValue\'))    $this->execPieceByName(\'ff_selectValue\');\r\nif (!function_exists(\'ff_query\'))          $this->execPieceByName(\'ff_query\');\r\nif (!function_exists(\'ff_markdown\'))       $this->execPieceByName(\'ff_markdown\');'),
(13, 1, 'FF', 'ff_makeFormUrl', 'Make URL to other form', 'Redirects to another facile form. \r\n\r\nCall: \r\n\r\n    $url = ff_makeFormUrl($name, $params = \'\');\r\n\r\nExample:\r\n\r\n    $url = ff_makeFormUrl(\r\n       \'OtherForm\', \r\n       \'&ff_param_email=\'.urlencode($email)\r\n    );', 'Untyped', 'function ff_makeFormUrl($name, $params=\'\')\r\n{\r\n    global $ff_processor, $ff_otherparams;\r\n    $url = \'\';\r\n    switch ($ff_processor->runmode) {\r\n        case 2: // preview\r\n        case 1: // backend\r\n            $url .= \'administrator/index2.php?option=com_breezingforms&act=run\'.\r\n                    \'&ff_name=\'.urlencode($name);\r\n            if ($ff_processor->inframe) $url .= \'&ff_frame=1\';\r\n            if ($ff_processor->border) $url .= \'&ff_border=1\';\r\n            break;\r\n        default: // frontend\r\n            $url .= \'index.php?ff_name=\'.urlencode($name);\r\n            if ($ff_otherparams[\'option\'] == \'com_breezingforms\') {\r\n                reset($ff_otherparams);\r\n                while (list($prop, $val) = each($ff_otherparams))\r\n                    $url .= \'&\'.urlencode($prop).\'=\'.urlencode($val);\r\n            } else\r\n                $url .= \'&option=com_breezingforms\';\r\n            if ($ff_processor->target > 1) $url .= \'&ff_target=\'.$ff_processor->target;\r\n            if ($ff_processor->inframe) $url .= \'&ff_frame=1\';\r\n            if ($ff_processor->border) $url .= \'&ff_border=1\';\r\n            if ($ff_processor->align !=1) $url .= \'&ff_align=\'.$ff_processor->align;\r\n            if ($ff_processor->top>0) $url .= \'&ff_top=\'.$ff_processor->top;\r\n    } // switch\r\n    return ff_makePageUrl($url. $params);\r\n} // ff_makeFormUrl'),
(14, 1, 'FF', 'ff_makePageUrl', 'Make URL to other page', 'Builds an URL to another mambo page\r\n\r\nCall: \r\n\r\n    $url = ff_makePageUrl($params = \'\');\r\n\r\nExample:\r\n\r\n    $url = ff_makePageUrl(\r\n        \'index.php?option=com_content&task=blogsection&id=0&Itemid=39\'\r\n    );', 'Untyped', 'function ff_makePageUrl($params=\'\')\r\n{\r\n    $url = \'{mossite}\';\r\n    if ($params != \'\') {\r\n        $len = strlen($url);\r\n        if ($len > 0 && $url{$len-1} != \'/\') $url .= \'/\';\r\n        $url .= $params;\r\n    } // if\r\n    return $url;\r\n} // ff_makePageUrl'),
(15, 1, 'FF', 'ff_makeSelfUrl', 'Make URL to same form', 'Make an URL to the same form. \r\n\r\nCall: \r\n\r\n    $url = ff_makeSelfUrl($params = \'\');\r\n\r\nExample:\r\n\r\n    $url = ff_makeSelfUrl(\'&ff_param_email=\'.urlencode($email));', 'Untyped', 'function ff_makeSelfUrl($params=\'\')\r\n{\r\n    global $ff_processor;\r\n    return ff_makeFormUrl($ff_processor->formrow->name, $params);\r\n} // ff_makeSelfUrl'),
(16, 1, 'FF', 'ff_query', 'Non-select queries against db', 'Execute a simple db query.\r\n\r\nInclude by one of:\r\n\r\n    $this->execPieceByName(\'ff_InitUtilities\');\r\n    $this->execPieceByName(\'ff_SubmitUtilities\');\r\n    if (!function_exists(\'ff_query\')) $this->execPieceByName(\'ff_query\');\r\n\r\nCall syntax:\r\n\r\n    [$newid = ] ff_query($sql [, $insert = 0]);\r\n\r\n    $sql:    Sql statement to call\r\n    $insert: 1 = return key of auto column when inserting rows\r\n    $newid:  The key of the new row.', 'Untyped', 'function ff_query($sql, $insert=false, $error=FF_DIE)\r\n{\r\n    global $ff_processor;\r\n    $database = JFactory::getDBO();\r\n    if ($ff_processor->dying && $error!=FF_IGNOREDIE) return -1;\r\n    $database->setQuery($sql);\r\n    $database->query();\r\n    if ($database->getErrorNum()) {\r\n        $dienow = $error==FF_DIE;\r\n        $error = $database->stderr();\r\n        if ($dienow) ff_die($error);\r\n    } else {\r\n        $error = null;\r\n        if ($insert) return $database->insertid();\r\n    } // if\r\n    return 0;\r\n} // ff_query'),
(17, 1, 'FF', 'ff_redirect', 'Basic redirection', 'Basic redirection routine supporting multiple targets and methods.\r\n\r\nCall:\r\n \r\nff_redirect($url [, $target=\'self\' , $method=\'post\'])\r\n\r\n    $url    = The url to redirect to including the parameters appended.\r\n\r\n    $target = \'top\', \'parent\', \'self\' or \'blank\'\r\n\r\n              \'top\'    = redirect to the top browser window\r\n              \'parent\' = redirect to the parent frame\r\n              \'self\'   = redirect in the same frame (the default)\r\n              \'blank\'  = redirect to a new browser window \r\n                         (blank works with post method only)\r\n\r\n    $method = \'post\' or \'get\'. The default is \'post\'.\r\n\r\n    Example:\r\n\r\n       ff_redirect(\r\n          \'http://mysite.net/index.php?option=xxx&Itemid=33\',\r\n          \'top\'\r\n       );', 'Untyped', 'function ff_redirect($url, $target=\'self\', $method=\'post\')\r\n{\r\n    global $ff_processor, $ff_request;\r\n    if ($ff_processor->dying) return;\r\n\r\n    ob_end_clean();\r\n    switch (strtolower($method)) {\r\n        case \'get\': {\r\n            switch (strtolower($target)) {\r\n                case \'top\'   :\r\n                case \'parent\': break;\r\n                default      : $target = \'document\';\r\n            } // switch\r\n            echo \'<script type=\"text/javascript\">\'.nl().\r\n                 \'<!--\'.nl().\r\n                 \"onload=function() { \".$target.\".location.href=\'\".$url.\"\'; }\".nl().\r\n                 \'-->\'.nl().\r\n                 \'</script>\'.nl().\r\n                 \'</body>\'.nl();\r\n            break;\r\n        } // url\r\n        default: { // post\r\n            $pos = strpos($url,\'?\');\r\n            $ff_request = array();\r\n            if ($pos === false)\r\n                $action = $url;\r\n            else {\r\n                $action = substr($url,0,$pos);\r\n                addRequestParams(substr($url, $pos+1));\r\n            } // if\r\n            switch (strtolower($target)) {\r\n                case \'blank\' : $target = \' target=\"_blank\"\';  break;\r\n                case \'top\'   : $target = \' target=\"_top\"\';    break;\r\n                case \'parent\': $target = \' target=\"_parent\"\'; break;\r\n                default      : $target = \' target=\"_self\"\';\r\n            } // switch\r\n            echo \'<script language=\"javascript\" type=\"text/javascript\">\'.nl().\r\n                 \'<!--\'.nl().\r\n                 \'onload = function() { document.ff_redirect.submit(); }\'.nl().\r\n                 \'-->\'.nl().\r\n                 \'</script>\'.nl().\r\n                 \'<form action=\"\'.$action.\'\" \'.\r\n                  \'method=\"post\" \'.\r\n                  \'name=\"ff_redirect\" id=\"ff_redirect\" \'.\r\n                  \'enctype=\"multipart/form-data\"\'.\r\n                  $target.\r\n                 \'>\'.nl();\r\n            while (list($prop, $val) = each($ff_request))\r\n                echo \'<input type=\"hidden\" name=\"\'.$prop.\'\" \'.\r\n                            \'value=\"\'.htmlentities(urldecode($val)).\'\"/>\'.nl();\r\n            echo \'</form>\'.nl().\r\n                 \'</body>\'.nl();\r\n        } // post\r\n    } // switch\r\n    exit;\r\n} // ff_redirect'),
(18, 1, 'FF', 'ff_redirectForm', 'Redirect to other form', 'Redirects to another facile form. \r\n\r\nCall: \r\n\r\n    ff_redirectForm($name, $params = \'\');\r\n\r\nExample:\r\n\r\n    ff_redirectForm(\r\n        $this, \r\n       \'SecondForm\', \r\n       \'&ff_param_email=\'.urlencode($email)\r\n    );', 'Untyped', 'function ff_redirectForm($name, $params=\'\', $method=\'post\')\r\n{\r\n    ff_redirectParent(ff_makeFormUrl($name, $params), $method);\r\n} // ff_redirectForm'),
(19, 1, 'FF', 'ff_redirectPage', 'Redirect to other page', 'Redirects to another mambo page. \r\n\r\nCall: \r\n\r\n    ff_redirectPage($params = \'\');\r\n\r\nExample:\r\n\r\n    ff_redirectPage(\r\n        \'index.php?option=com_content&task=blogsection&id=0&Itemid=39\'\r\n    );', 'Untyped', 'function ff_redirectPage($params=\'\', $method=\'post\')\r\n{\r\n    ff_redirectParent(ff_makePageUrl($params), $method);\r\n} // ff_redirectPage'),
(20, 1, 'FF', 'ff_redirectParentX', 'Redirect to parent window', 'Redirects to the parent window when runing in iframe, otherwise to self. \r\n\r\nff_redirectParent($url [, $method=\'post\'])\r\n\r\n    $url    = The url to redirect to including the parameters appended.\r\n\r\n    $method = \'post\' or \'url\'. The default is \'post\'.\r\n\r\n    Example:\r\n\r\n       ff_redirectParent(\r\n          \'http://mysite.net/index.php?option=xxx&Itemid=33\',\r\n          \'url\'\r\n       );', 'Untyped', 'function ff_redirectParent($url, $method = \'post\')\r\n{\r\n    global $ff_processor;\r\n    if ($ff_processor->inframe) $target = \'parent\'; else $target = \'self\'; \r\n    ff_redirect($url, $target, $method);\r\n} // ff_redirectParent'),
(21, 1, 'FF', 'ff_redirectSelf', 'Redirect to same form', 'Redirects to the same form. \r\n\r\nCall: \r\n\r\n    ff_redirectSelf($params = \'\');\r\n\r\nExample:\r\n\r\n    ff_redirectSelf(\'&ff_param_email=\'.urlencode($email));', 'Untyped', 'function ff_redirectSelf($params=\'\', $method=\'post\')\r\n{\r\n    ff_redirectParent(ff_makeSelfUrl($params), $method);\r\n} // ff_redirectSelf'),
(22, 1, 'FF', 'ff_securityImage', 'Security Image', 'Create code to display the security image', 'Untyped', 'global $ff_seccode;\r\n\r\nif (!isset($this->record_id)) { $ff_seccode = null; }\r\n\r\nfunction ff_securityImage()\r\n{\r\n    global $ff_comsite, $ff_seccode;\r\n    if (!isset($ff_seccode)) { \r\n        mt_srand((double)microtime()*1000000);\r\n        $ff_seccode = mt_rand(10000, 99999);\r\n        JFactory::getSession()->set(\'ff_seccode\', $ff_seccode);\r\n    } // if\r\n\r\n    return \'<img src=\"\'.JURI::root().\'ff_secimage.php?option=com_breezingforms&showSecImage=true\" title=\"\" alt=\"\" />\';\r\n} // ff_securityImage'),
(23, 1, 'FF', 'ff_select', 'Select rows from db', 'Execute a select query\r\n\r\nInclude by one of:\r\n\r\n    $this->execPieceByName(\'ff_InitUtilities\');\r\n    $this->execPieceByName(\'ff_SubmitUtilities\');\r\n    if (!function_exists(\'ff_select\')) $this->execPieceByName(\'ff_select\');\r\n\r\nCall syntax:\r\n\r\n    $rows = ff_select($sql);\r\n\r\n    $sql:    Sql SELECT-statement to call\r\n    $rows:   List of row objects', 'Untyped', 'function ff_select($sql, $error=FF_DIE)\r\n{\r\n    $database = JFactory::getDBO();\r\n    $database->setQuery($sql);\r\n    $rows = $database->loadObjectList();\r\n    if ($database->getErrorNum()) {\r\n        $dienow = $error==FF_DIE;\r\n        $error = $database->stderr();\r\n        $rows = array();\r\n        if ($dienow) ff_die($error);\r\n    } else\r\n        $error = null;\r\n    return $rows;\r\n} // ff_select'),
(24, 1, 'FF', 'ff_selectValue', 'Select single value from db', 'Execute query to read a single value\r\n\r\nInclude by one of:\r\n\r\n    $this->execPieceByName(\'ff_InitUtilities\');\r\n    $this->execPieceByName(\'ff_SubmitUtilities\');\r\n    if (!function_exists(\'ff_selectValue\')) $this->execPieceByName(\'ff_selectValue\');\r\n\r\nCall syntax:\r\n\r\n    $value = ff_selectValue($sql);\r\n\r\n    $sql:    Sql SELECT-statement to call\r\n    $value:  The value returned by the database', 'Untyped', 'function ff_selectValue($sql, $def=null, $error=FF_DIE)\r\n{\r\n    $database = JFactory::getDBO();\r\n    $database->setQuery($sql);\r\n    $value = $database->loadResult();\r\n    if ($database->getErrorNum()) {\r\n        $dienow = $error==FF_DIE;\r\n        $error = $database->stderr();\r\n        if ($dienow) ff_die($error);\r\n    } else {\r\n        $error = null;\r\n        if ($value) return $value;\r\n    } // if\r\n    return $def;\r\n} // ff_selectValue'),
(25, 1, 'FF', 'ff_setCheckedX', 'Set checkbox/radiobutton checked', 'Set a radio button or checkbox checked. \r\n\r\nCall: \r\n\r\n    ff_setChecked(\'name\', \'value\');', 'Untyped', 'function ff_setChecked($name, $value)\r\n{\r\n    global $ff_processor;\r\n    for ($r = 0; $r < $ff_processor->rowcount; $r++) {\r\n        $row =& $ff_processor->rows[$r];\r\n        if ($row->name==$name && $row->data1==$value)\r\n            $row->flag1 = 1;\r\n        unset($row);\r\n    } // for\r\n} // ff_setChecked'),
(26, 1, 'FF', 'ff_setSelectedX', 'Set a select list option to *selected*', 'Sets a select list option to selected. \r\n\r\nCall: \r\n\r\n    ff_setSelected(\'name\', \'value\');', 'Untyped', 'function ff_setSelected($name, $value)\r\n{\r\n    global $ff_processor;\r\n    for ($r = 0; $r < $ff_processor->rowcount; $r++) {\r\n        $row =& $ff_processor->rows[$r];\r\n        if ($row->name==$name)\r\n            $row->data2 =\r\n                preg_replace(\r\n                    \'/(^|\\r\\n|\\n)(0|1);([^;]*);(\'.$value.\')($|\\r\\n|\\n)/\',\r\n                    \'${1}1;${3};${4}${5}\',\r\n                    $row->data2\r\n                );\r\n        unset($row);\r\n    } // for\r\n} // ff_setSelected'),
(27, 1, 'FF', 'ff_setValueX', 'Set text, textarea, hidden value', 'Set value of a Static Text, Text, Textarea or Hidden Input. \r\n\r\nCall: \r\n\r\n    ff_setValue(\'name\', \'value\');', 'Untyped', 'function ff_setValue($name, $value)\r\n{\r\n    global $ff_processor;\r\n    for ($r = 0; $r < $ff_processor->rowcount; $r++) {\r\n        $row =& $ff_processor->rows[$r];\r\n        if ($row->name==$name)\r\n            $row->data1 = $value;\r\n        unset($row);\r\n    } // for\r\n} // ff_setValue');
INSERT INTO `jos3_facileforms_pieces` (`id`, `published`, `package`, `name`, `title`, `description`, `type`, `code`) VALUES
(28, 1, 'FF', 'Markdown', 'Original Markdown Processor', 'Converts text marked up by \'Markdown\' into HTML.\r\n\r\nPlease use ff_markdown() in forms instead of Markdown()', 'Untyped', '#\r\n# Markdown  -  A text-to-HTML conversion tool for web writers\r\n#\r\n# Copyright (c) 2004-2005 John Gruber\r\n# <http://daringfireball.net/projects/markdown/>\r\n#\r\n# Copyright (c) 2004-2005 Michel Fortin - PHP Port\r\n# <http://www.michelf.com/projects/php-markdown/>\r\n#\r\n\r\nglobal	$MarkdownPHPVersion, $MarkdownSyntaxVersion,\r\n		$md_empty_element_suffix, $md_tab_width,\r\n		$md_nested_brackets_depth, $md_nested_brackets,\r\n		$md_escape_table, $md_backslash_escape_table,\r\n		$md_list_level;\r\n\r\n$MarkdownPHPVersion    = \'1.0.1b\'; # Mon 6 Jun 2005\r\n$MarkdownSyntaxVersion = \'1.0.1\';  # Sun 12 Dec 2004\r\n\r\n\r\n#\r\n# Global default settings:\r\n#\r\n$md_empty_element_suffix = \" />\";     # Change to \">\" for HTML output\r\n$md_tab_width = 4;\r\n\r\n#\r\n# WordPress settings:\r\n#\r\n$md_wp_posts    = true;  # Set to false to remove Markdown from posts.\r\n$md_wp_comments = true;  # Set to false to remove Markdown from comments.\r\n\r\n\r\n# -- WordPress Plugin Interface -----------------------------------------------\r\n/*\r\nPlugin Name: Markdown\r\nPlugin URI: http://www.michelf.com/projects/php-markdown/\r\nDescription: <a href=\"http://daringfireball.net/projects/markdown/syntax\">Markdown syntax</a> allows you to write using an easy-to-read, easy-to-write plain text format. Based on the original Perl version by <a href=\"http://daringfireball.net/\">John Gruber</a>. <a href=\"http://www.michelf.com/projects/php-markdown/\">More...</a>\r\nVersion: 1.0.1b\r\nAuthor: Michel Fortin\r\nAuthor URI: http://www.michelf.com/\r\n*/\r\nif (isset($wp_version)) {\r\n	# More details about how it works here:\r\n	# <http://www.michelf.com/weblog/2005/wordpress-text-flow-vs-markdown/>\r\n\r\n	# Post content and excerpts\r\n	if ($md_wp_posts) {\r\n		remove_filter(\'the_content\',  \'wpautop\');\r\n		remove_filter(\'the_excerpt\',  \'wpautop\');\r\n		add_filter(\'the_content\',     \'Markdown\', 6);\r\n		add_filter(\'get_the_excerpt\', \'Markdown\', 6);\r\n		add_filter(\'get_the_excerpt\', \'trim\', 7);\r\n		add_filter(\'the_excerpt\',     \'md_add_p\');\r\n		add_filter(\'the_excerpt_rss\', \'md_strip_p\');\r\n\r\n		remove_filter(\'content_save_pre\',  \'balanceTags\', 50);\r\n		remove_filter(\'excerpt_save_pre\',  \'balanceTags\', 50);\r\n		add_filter(\'the_content\',  	  \'balanceTags\', 50);\r\n		add_filter(\'get_the_excerpt\', \'balanceTags\', 9);\r\n\r\n		function md_add_p($text) {\r\n			if (strlen($text) == 0) return;\r\n			if (strcasecmp(substr($text, -3), \'<p>\') == 0) return $text;\r\n			return \'<p>\'.$text.\'</p>\';\r\n		}\r\n		function md_strip_p($t) { return preg_replace(\'{</?[pP]>}\', \'\', $t); }\r\n	}\r\n\r\n	# Comments\r\n	if ($md_wp_comments) {\r\n		remove_filter(\'comment_text\', \'wpautop\');\r\n		remove_filter(\'comment_text\', \'make_clickable\');\r\n		add_filter(\'pre_comment_content\', \'Markdown\', 6);\r\n		add_filter(\'pre_comment_content\', \'md_hide_tags\', 8);\r\n		add_filter(\'pre_comment_content\', \'md_show_tags\', 12);\r\n		add_filter(\'get_comment_text\',    \'Markdown\', 6);\r\n		add_filter(\'get_comment_excerpt\', \'Markdown\', 6);\r\n		add_filter(\'get_comment_excerpt\', \'md_strip_p\', 7);\r\n\r\n		global $md_hidden_tags;\r\n		$md_hidden_tags = array(\r\n			\'<p>\'	=> md5(\'<p>\'),		\'</p>\'	=> md5(\'</p>\'),\r\n			\'<pre>\'	=> md5(\'<pre>\'),	\'</pre>\'=> md5(\'</pre>\'),\r\n			\'<ol>\'	=> md5(\'<ol>\'),		\'</ol>\'	=> md5(\'</ol>\'),\r\n			\'<ul>\'	=> md5(\'<ul>\'),		\'</ul>\'	=> md5(\'</ul>\'),\r\n			\'<li>\'	=> md5(\'<li>\'),		\'</li>\'	=> md5(\'</li>\'),\r\n			);\r\n\r\n		function md_hide_tags($text) {\r\n			global $md_hidden_tags;\r\n			return str_replace(array_keys($md_hidden_tags),\r\n								array_values($md_hidden_tags), $text);\r\n		}\r\n		function md_show_tags($text) {\r\n			global $md_hidden_tags;\r\n			return str_replace(array_values($md_hidden_tags),\r\n								array_keys($md_hidden_tags), $text);\r\n		}\r\n	}\r\n}\r\n\r\n\r\n# -- bBlog Plugin Info --------------------------------------------------------\r\nfunction identify_modifier_markdown() {\r\n	global $MarkdownPHPVersion;\r\n	return array(\r\n		\'name\'			=> \'markdown\',\r\n		\'type\'			=> \'modifier\',\r\n		\'nicename\'		=> \'Markdown\',\r\n		\'description\'	=> \'A text-to-HTML conversion tool for web writers\',\r\n		\'authors\'		=> \'Michel Fortin and John Gruber\',\r\n		\'licence\'		=> \'GPL\',\r\n		\'version\'		=> $MarkdownPHPVersion,\r\n		\'help\'			=> \'<a href=\"http://daringfireball.net/projects/markdown/syntax\">Markdown syntax</a> allows you to write using an easy-to-read, easy-to-write plain text format. Based on the original Perl version by <a href=\"http://daringfireball.net/\">John Gruber</a>. <a href=\"http://www.michelf.com/projects/php-markdown/\">More...</a>\'\r\n	);\r\n}\r\n\r\n# -- Smarty Modifier Interface ------------------------------------------------\r\nfunction smarty_modifier_markdown($text) {\r\n	return Markdown($text);\r\n}\r\n\r\n# -- Textile Compatibility Mode -----------------------------------------------\r\n# Rename this file to \"classTextile.php\" and it can replace Textile anywhere.\r\nif (strcasecmp(substr(__FILE__, -16), \"classTextile.php\") == 0) {\r\n	# Try to include PHP SmartyPants. Should be in the same directory.\r\n	@include_once \'smartypants.php\';\r\n	# Fake Textile class. It calls Markdown instead.\r\n	class Textile {\r\n		function TextileThis($text, $lite=\'\', $encode=\'\', $noimage=\'\', $strict=\'\') {\r\n			if ($lite == \'\' && $encode == \'\')   $text = Markdown($text);\r\n			if (function_exists(\'SmartyPants\')) $text = SmartyPants($text);\r\n			return $text;\r\n		}\r\n	}\r\n}\r\n\r\n\r\n\r\n#\r\n# Globals:\r\n#\r\n\r\n# Regex to match balanced [brackets].\r\n# Needed to insert a maximum bracked depth while converting to PHP.\r\n$md_nested_brackets_depth = 6;\r\n$md_nested_brackets =\r\n	str_repeat(\'(?>[^\\[\\]]+|\\[\', $md_nested_brackets_depth).\r\n	str_repeat(\'\\])*\', $md_nested_brackets_depth);\r\n\r\n# Table of hash values for escaped characters:\r\n$md_escape_table = array(\r\n	\"\\\\\" => md5(\"\\\\\"),\r\n	\"`\" => md5(\"`\"),\r\n	\"*\" => md5(\"*\"),\r\n	\"_\" => md5(\"_\"),\r\n	\"{\" => md5(\"{\"),\r\n	\"}\" => md5(\"}\"),\r\n	\"[\" => md5(\"[\"),\r\n	\"]\" => md5(\"]\"),\r\n	\"(\" => md5(\"(\"),\r\n	\")\" => md5(\")\"),\r\n	\">\" => md5(\">\"),\r\n	\"#\" => md5(\"#\"),\r\n	\"+\" => md5(\"+\"),\r\n	\"-\" => md5(\"-\"),\r\n	\".\" => md5(\".\"),\r\n	\"!\" => md5(\"!\")\r\n);\r\n# Create an identical table but for escaped characters.\r\n$md_backslash_escape_table;\r\nforeach ($md_escape_table as $key => $char)\r\n	$md_backslash_escape_table[\"\\\\$key\"] = $char;\r\n\r\n\r\nfunction Markdown($text) {\r\n#\r\n# Main function. The order in which other subs are called here is\r\n# essential. Link and image substitutions need to happen before\r\n# _EscapeSpecialCharsWithinTagAttributes(), so that any *\'s or _\'s in the <a>\r\n# and <img> tags get encoded.\r\n#\r\n	# Clear the global hashes. If we don\'t clear these, you get conflicts\r\n	# from other articles when generating a page which contains more than\r\n	# one article (e.g. an index page that shows the N most recent\r\n	# articles):\r\n	global $md_urls, $md_titles, $md_html_blocks;\r\n	$md_urls = array();\r\n	$md_titles = array();\r\n	$md_html_blocks = array();\r\n\r\n	# Standardize line endings:\r\n	#   DOS to Unix and Mac to Unix\r\n	$text = str_replace(array(\"\\r\\n\", \"\\r\"), \"\\n\", $text);\r\n\r\n	# Make sure $text ends with a couple of newlines:\r\n	$text .= \"\\n\\n\";\r\n\r\n	# Convert all tabs to spaces.\r\n	$text = _Detab($text);\r\n\r\n	# Strip any lines consisting only of spaces and tabs.\r\n	# This makes subsequent regexen easier to write, because we can\r\n	# match consecutive blank lines with /\\n+/ instead of something\r\n	# contorted like /[ \\t]*\\n+/ .\r\n	$text = preg_replace(\'/^[ \\t]+$/m\', \'\', $text);\r\n\r\n	# Turn block-level HTML blocks into hash entries\r\n	$text = _HashHTMLBlocks($text);\r\n\r\n	# Strip link definitions, store in hashes.\r\n	$text = _StripLinkDefinitions($text);\r\n\r\n	$text = _RunBlockGamut($text);\r\n\r\n	$text = _UnescapeSpecialChars($text);\r\n\r\n	return $text . \"\\n\";\r\n}\r\n\r\n\r\nfunction _StripLinkDefinitions($text) {\r\n#\r\n# Strips link definitions from text, stores the URLs and titles in\r\n# hash references.\r\n#\r\n	global $md_tab_width;\r\n	$less_than_tab = $md_tab_width - 1;\r\n\r\n	# Link defs are in the form: ^[id]: url \"optional title\"\r\n	$text = preg_replace_callback(\'{\r\n						^[ ]{0,\'.$less_than_tab.\'}\\[(.+)\\]:	# id = $1\r\n						  [ \\t]*\r\n						  \\n?				# maybe *one* newline\r\n						  [ \\t]*\r\n						<?(\\S+?)>?			# url = $2\r\n						  [ \\t]*\r\n						  \\n?				# maybe one newline\r\n						  [ \\t]*\r\n						(?:\r\n							(?<=\\s)			# lookbehind for whitespace\r\n							[\"(]\r\n							(.+?)			# title = $3\r\n							[\")]\r\n							[ \\t]*\r\n						)?	# title is optional\r\n						(?:\\n+|\\Z)\r\n		}xm\',\r\n		\'_StripLinkDefinitions_callback\',\r\n		$text);\r\n	return $text;\r\n}\r\nfunction _StripLinkDefinitions_callback($matches) {\r\n	global $md_urls, $md_titles;\r\n	$link_id = strtolower($matches[1]);\r\n	$md_urls[$link_id] = _EncodeAmpsAndAngles($matches[2]);\r\n	if (isset($matches[3]))\r\n		$md_titles[$link_id] = str_replace(\'\"\', \'&quot;\', $matches[3]);\r\n	return \'\'; # String that will replace the block\r\n}\r\n\r\n\r\nfunction _HashHTMLBlocks($text) {\r\n	global $md_tab_width;\r\n	$less_than_tab = $md_tab_width - 1;\r\n\r\n	# Hashify HTML blocks:\r\n	# We only want to do this for block-level HTML tags, such as headers,\r\n	# lists, and tables. That\'s because we still want to wrap <p>s around\r\n	# \"paragraphs\" that are wrapped in non-block-level tags, such as anchors,\r\n	# phrase emphasis, and spans. The list of tags we\'re looking for is\r\n	# hard-coded:\r\n	$block_tags_a = \'p|div|h[1-6]|blockquote|pre|table|dl|ol|ul|\'.\r\n					\'script|noscript|form|fieldset|iframe|math|ins|del\';\r\n	$block_tags_b = \'p|div|h[1-6]|blockquote|pre|table|dl|ol|ul|\'.\r\n					\'script|noscript|form|fieldset|iframe|math\';\r\n\r\n	# First, look for nested blocks, e.g.:\r\n	# 	<div>\r\n	# 		<div>\r\n	# 		tags for inner block must be indented.\r\n	# 		</div>\r\n	# 	</div>\r\n	#\r\n	# The outermost tags must start at the left margin for this to match, and\r\n	# the inner nested divs must be indented.\r\n	# We need to do this before the next, more liberal match, because the next\r\n	# match will start at the first `<div>` and stop at the first `</div>`.\r\n	$text = preg_replace_callback(\"{\r\n				(						# save in $1\r\n					^					# start of line  (with /m)\r\n					<($block_tags_a)	# start tag = $2\r\n					\\\\b					# word break\r\n					(.*\\\\n)*?			# any number of lines, minimally matching\r\n					</\\\\2>				# the matching end tag\r\n					[ \\\\t]*				# trailing spaces/tabs\r\n					(?=\\\\n+|\\\\Z)	# followed by a newline or end of document\r\n				)\r\n		}xm\",\r\n		\'_HashHTMLBlocks_callback\',\r\n		$text);\r\n\r\n	#\r\n	# Now match more liberally, simply from `\\n<tag>` to `</tag>\\n`\r\n	#\r\n	$text = preg_replace_callback(\"{\r\n				(						# save in $1\r\n					^					# start of line  (with /m)\r\n					<($block_tags_b)	# start tag = $2\r\n					\\\\b					# word break\r\n					(.*\\\\n)*?			# any number of lines, minimally matching\r\n					.*</\\\\2>				# the matching end tag\r\n					[ \\\\t]*				# trailing spaces/tabs\r\n					(?=\\\\n+|\\\\Z)	# followed by a newline or end of document\r\n				)\r\n		}xm\",\r\n		\'_HashHTMLBlocks_callback\',\r\n		$text);\r\n\r\n	# Special case just for <hr />. It was easier to make a special case than\r\n	# to make the other regex more complicated.\r\n	$text = preg_replace_callback(\'{\r\n				(?:\r\n					(?<=\\n\\n)		# Starting after a blank line\r\n					|				# or\r\n					\\A\\n?			# the beginning of the doc\r\n				)\r\n				(						# save in $1\r\n					[ ]{0,\'.$less_than_tab.\'}\r\n					<(hr)				# start tag = $2\r\n					\\b					# word break\r\n					([^<>])*?			#\r\n					/?>					# the matching end tag\r\n					[ \\t]*\r\n					(?=\\n{2,}|\\Z)		# followed by a blank line or end of document\r\n				)\r\n		}x\',\r\n		\'_HashHTMLBlocks_callback\',\r\n		$text);\r\n\r\n	# Special case for standalone HTML comments:\r\n	$text = preg_replace_callback(\'{\r\n				(?:\r\n					(?<=\\n\\n)		# Starting after a blank line\r\n					|				# or\r\n					\\A\\n?			# the beginning of the doc\r\n				)\r\n				(						# save in $1\r\n					[ ]{0,\'.$less_than_tab.\'}\r\n					(?s:\r\n						<!\r\n						(--.*?--\\s*)+\r\n						>\r\n					)\r\n					[ \\t]*\r\n					(?=\\n{2,}|\\Z)		# followed by a blank line or end of document\r\n				)\r\n			}x\',\r\n			\'_HashHTMLBlocks_callback\',\r\n			$text);\r\n\r\n	return $text;\r\n}\r\nfunction _HashHTMLBlocks_callback($matches) {\r\n	global $md_html_blocks;\r\n	$text = $matches[1];\r\n	$key = md5($text);\r\n	$md_html_blocks[$key] = $text;\r\n	return \"\\n\\n$key\\n\\n\"; # String that will replace the block\r\n}\r\n\r\n\r\nfunction _RunBlockGamut($text) {\r\n#\r\n# These are all the transformations that form block-level\r\n# tags like paragraphs, headers, and list items.\r\n#\r\n	global $md_empty_element_suffix;\r\n\r\n	$text = _DoHeaders($text);\r\n\r\n	# Do Horizontal Rules:\r\n	$text = preg_replace(\r\n		array(\'{^[ ]{0,2}([ ]?\\*[ ]?){3,}[ \\t]*$}mx\',\r\n			  \'{^[ ]{0,2}([ ]? -[ ]?){3,}[ \\t]*$}mx\',\r\n			  \'{^[ ]{0,2}([ ]? _[ ]?){3,}[ \\t]*$}mx\'),\r\n		\"\\n<hr$md_empty_element_suffix\\n\",\r\n		$text);\r\n\r\n	$text = _DoLists($text);\r\n	$text = _DoCodeBlocks($text);\r\n	$text = _DoBlockQuotes($text);\r\n\r\n	# We already ran _HashHTMLBlocks() before, in Markdown(), but that\r\n	# was to escape raw HTML in the original Markdown source. This time,\r\n	# we\'re escaping the markup we\'ve just created, so that we don\'t wrap\r\n	# <p> tags around block-level tags.\r\n	$text = _HashHTMLBlocks($text);\r\n	$text = _FormParagraphs($text);\r\n\r\n	return $text;\r\n}\r\n\r\n\r\nfunction _RunSpanGamut($text) {\r\n#\r\n# These are all the transformations that occur *within* block-level\r\n# tags like paragraphs, headers, and list items.\r\n#\r\n	global $md_empty_element_suffix;\r\n\r\n	$text = _DoCodeSpans($text);\r\n\r\n	$text = _EscapeSpecialChars($text);\r\n\r\n	# Process anchor and image tags. Images must come first,\r\n	# because ![foo][f] looks like an anchor.\r\n	$text = _DoImages($text);\r\n	$text = _DoAnchors($text);\r\n\r\n	# Make links out of things like `<http://example.com/>`\r\n	# Must come after _DoAnchors(), because you can use < and >\r\n	# delimiters in inline links like [this](<url>).\r\n	$text = _DoAutoLinks($text);\r\n	$text = _EncodeAmpsAndAngles($text);\r\n	$text = _DoItalicsAndBold($text);\r\n\r\n	# Do hard breaks:\r\n	$text = preg_replace(\'/ {2,}\\n/\', \"<br$md_empty_element_suffix\\n\", $text);\r\n\r\n	return $text;\r\n}\r\n\r\n\r\nfunction _EscapeSpecialChars($text) {\r\n	global $md_escape_table;\r\n	$tokens = _TokenizeHTML($text);\r\n\r\n	$text = \'\';   # rebuild $text from the tokens\r\n#	$in_pre = 0;  # Keep track of when we\'re inside <pre> or <code> tags.\r\n#	$tags_to_skip = \"!<(/?)(?:pre|code|kbd|script|math)[\\s>]!\";\r\n\r\n	foreach ($tokens as $cur_token) {\r\n		if ($cur_token[0] == \'tag\') {\r\n			# Within tags, encode * and _ so they don\'t conflict\r\n			# with their use in Markdown for italics and strong.\r\n			# We\'re replacing each such character with its\r\n			# corresponding MD5 checksum value; this is likely\r\n			# overkill, but it should prevent us from colliding\r\n			# with the escape values by accident.\r\n			$cur_token[1] = str_replace(array(\'*\', \'_\'),\r\n				array($md_escape_table[\'*\'], $md_escape_table[\'_\']),\r\n				$cur_token[1]);\r\n			$text .= $cur_token[1];\r\n		} else {\r\n			$t = $cur_token[1];\r\n			$t = _EncodeBackslashEscapes($t);\r\n			$text .= $t;\r\n		}\r\n	}\r\n	return $text;\r\n}\r\n\r\n\r\nfunction _DoAnchors($text) {\r\n#\r\n# Turn Markdown link shortcuts into XHTML <a> tags.\r\n#\r\n	global $md_nested_brackets;\r\n	#\r\n	# First, handle reference-style links: [link text] [id]\r\n	#\r\n	$text = preg_replace_callback(\"{\r\n		(					# wrap whole match in $1\r\n		  \\\\[\r\n			($md_nested_brackets)	# link text = $2\r\n		  \\\\]\r\n\r\n		  [ ]?				# one optional space\r\n		  (?:\\\\n[ ]*)?		# one optional newline followed by spaces\r\n\r\n		  \\\\[\r\n			(.*?)		# id = $3\r\n		  \\\\]\r\n		)\r\n		}xs\",\r\n		\'_DoAnchors_reference_callback\', $text);\r\n\r\n	#\r\n	# Next, inline-style links: [link text](url \"optional title\")\r\n	#\r\n	$text = preg_replace_callback(\"{\r\n		(				# wrap whole match in $1\r\n		  \\\\[\r\n			($md_nested_brackets)	# link text = $2\r\n		  \\\\]\r\n		  \\\\(			# literal paren\r\n			[ \\\\t]*\r\n			<?(.*?)>?	# href = $3\r\n			[ \\\\t]*\r\n			(			# $4\r\n			  ([\'\\\"])	# quote char = $5\r\n			  (.*?)		# Title = $6\r\n			  \\\\5		# matching quote\r\n			)?			# title is optional\r\n		  \\\\)\r\n		)\r\n		}xs\",\r\n		\'_DoAnchors_inline_callback\', $text);\r\n\r\n	return $text;\r\n}\r\nfunction _DoAnchors_reference_callback($matches) {\r\n	global $md_urls, $md_titles, $md_escape_table;\r\n	$whole_match = $matches[1];\r\n	$link_text   = $matches[2];\r\n	$link_id     = strtolower($matches[3]);\r\n\r\n	if ($link_id == \"\") {\r\n		$link_id = strtolower($link_text); # for shortcut links like [this][].\r\n	}\r\n\r\n	if (isset($md_urls[$link_id])) {\r\n		$url = $md_urls[$link_id];\r\n		# We\'ve got to encode these to avoid conflicting with italics/bold.\r\n		$url = str_replace(array(\'*\', \'_\'),\r\n						   array($md_escape_table[\'*\'], $md_escape_table[\'_\']),\r\n						   $url);\r\n		$result = \"<a href=\\\"$url\\\"\";\r\n		if ( isset( $md_titles[$link_id] ) ) {\r\n			$title = $md_titles[$link_id];\r\n			$title = str_replace(array(\'*\',     \'_\'),\r\n								 array($md_escape_table[\'*\'],\r\n									   $md_escape_table[\'_\']), $title);\r\n			$result .=  \" title=\\\"$title\\\"\";\r\n		}\r\n		$result .= \">$link_text</a>\";\r\n	}\r\n	else {\r\n		$result = $whole_match;\r\n	}\r\n	return $result;\r\n}\r\nfunction _DoAnchors_inline_callback($matches) {\r\n	global $md_escape_table;\r\n	$whole_match	= $matches[1];\r\n	$link_text		= $matches[2];\r\n	$url			= $matches[3];\r\n	$title			=& $matches[6];\r\n\r\n	# We\'ve got to encode these to avoid conflicting with italics/bold.\r\n	$url = str_replace(array(\'*\', \'_\'),\r\n					   array($md_escape_table[\'*\'], $md_escape_table[\'_\']),\r\n					   $url);\r\n	$result = \"<a href=\\\"$url\\\"\";\r\n	if (isset($title)) {\r\n		$title = str_replace(\'\"\', \'&quot;\', $title);\r\n		$title = str_replace(array(\'*\', \'_\'),\r\n							 array($md_escape_table[\'*\'], $md_escape_table[\'_\']),\r\n							 $title);\r\n		$result .=  \" title=\\\"$title\\\"\";\r\n	}\r\n\r\n	$result .= \">$link_text</a>\";\r\n\r\n	return $result;\r\n}\r\n\r\n\r\nfunction _DoImages($text) {\r\n#\r\n# Turn Markdown image shortcuts into <img> tags.\r\n#\r\n	global $md_nested_brackets;\r\n\r\n	#\r\n	# First, handle reference-style labeled images: ![alt text][id]\r\n	#\r\n	$text = preg_replace_callback(\'{\r\n		(				# wrap whole match in $1\r\n		  !\\[\r\n			(\'.$md_nested_brackets.\')		# alt text = $2\r\n		  \\]\r\n\r\n		  [ ]?				# one optional space\r\n		  (?:\\n[ ]*)?		# one optional newline followed by spaces\r\n\r\n		  \\[\r\n			(.*?)		# id = $3\r\n		  \\]\r\n\r\n		)\r\n		}xs\',\r\n		\'_DoImages_reference_callback\', $text);\r\n\r\n	#\r\n	# Next, handle inline images:  ![alt text](url \"optional title\")\r\n	# Don\'t forget: encode * and _\r\n\r\n	$text = preg_replace_callback(\'{\r\n		(				# wrap whole match in $1\r\n		  !\\[\r\n			(\'.$md_nested_brackets.\')		# alt text = $2\r\n		  \\]\r\n		  \\(			# literal paren\r\n			[ \\t]*\r\n			<?(\\S+?)>?	# src url = $3\r\n			[ \\t]*\r\n			(			# $4\r\n			  ([\\\'\"])	# quote char = $5\r\n			  (.*?)		# title = $6\r\n			  \\5		# matching quote\r\n			  [ \\t]*\r\n			)?			# title is optional\r\n		  \\)\r\n		)\r\n		}xs\',\r\n		\'_DoImages_inline_callback\', $text);\r\n\r\n	return $text;\r\n}\r\nfunction _DoImages_reference_callback($matches) {\r\n	global $md_urls, $md_titles, $md_empty_element_suffix, $md_escape_table;\r\n	$whole_match = $matches[1];\r\n	$alt_text    = $matches[2];\r\n	$link_id     = strtolower($matches[3]);\r\n\r\n	if ($link_id == \"\") {\r\n		$link_id = strtolower($alt_text); # for shortcut links like ![this][].\r\n	}\r\n\r\n	$alt_text = str_replace(\'\"\', \'&quot;\', $alt_text);\r\n	if (isset($md_urls[$link_id])) {\r\n		$url = $md_urls[$link_id];\r\n		# We\'ve got to encode these to avoid conflicting with italics/bold.\r\n		$url = str_replace(array(\'*\', \'_\'),\r\n						   array($md_escape_table[\'*\'], $md_escape_table[\'_\']),\r\n						   $url);\r\n		$result = \"<img src=\\\"$url\\\" alt=\\\"$alt_text\\\"\";\r\n		if (isset($md_titles[$link_id])) {\r\n			$title = $md_titles[$link_id];\r\n			$title = str_replace(array(\'*\', \'_\'),\r\n								 array($md_escape_table[\'*\'],\r\n									   $md_escape_table[\'_\']), $title);\r\n			$result .=  \" title=\\\"$title\\\"\";\r\n		}\r\n		$result .= $md_empty_element_suffix;\r\n	}\r\n	else {\r\n		# If there\'s no such link ID, leave intact:\r\n		$result = $whole_match;\r\n	}\r\n\r\n	return $result;\r\n}\r\nfunction _DoImages_inline_callback($matches) {\r\n	global $md_empty_element_suffix, $md_escape_table;\r\n	$whole_match	= $matches[1];\r\n	$alt_text		= $matches[2];\r\n	$url			= $matches[3];\r\n	$title			= \'\';\r\n	if (isset($matches[6])) {\r\n		$title		= $matches[6];\r\n	}\r\n\r\n	$alt_text = str_replace(\'\"\', \'&quot;\', $alt_text);\r\n	$title    = str_replace(\'\"\', \'&quot;\', $title);\r\n	# We\'ve got to encode these to avoid conflicting with italics/bold.\r\n	$url = str_replace(array(\'*\', \'_\'),\r\n					   array($md_escape_table[\'*\'], $md_escape_table[\'_\']),\r\n					   $url);\r\n	$result = \"<img src=\\\"$url\\\" alt=\\\"$alt_text\\\"\";\r\n	if (isset($title)) {\r\n		$title = str_replace(array(\'*\', \'_\'),\r\n							 array($md_escape_table[\'*\'], $md_escape_table[\'_\']),\r\n							 $title);\r\n		$result .=  \" title=\\\"$title\\\"\"; # $title already quoted\r\n	}\r\n	$result .= $md_empty_element_suffix;\r\n\r\n	return $result;\r\n}\r\n\r\n\r\nfunction _DoHeaders($text) {\r\n	# Setext-style headers:\r\n	#	  Header 1\r\n	#	  ========\r\n	#\r\n	#	  Header 2\r\n	#	  --------\r\n	#\r\n	$text = preg_replace(\r\n		array(\'{ ^(.+)[ \\t]*\\n=+[ \\t]*\\n+ }emx\',\r\n			  \'{ ^(.+)[ \\t]*\\n-+[ \\t]*\\n+ }emx\'),\r\n		array(\"\'<h1>\'._RunSpanGamut(_UnslashQuotes(\'\\\\1\')).\'</h1>\\n\\n\'\",\r\n			  \"\'<h2>\'._RunSpanGamut(_UnslashQuotes(\'\\\\1\')).\'</h2>\\n\\n\'\"),\r\n		$text);\r\n\r\n	# atx-style headers:\r\n	#	# Header 1\r\n	#	## Header 2\r\n	#	## Header 2 with closing hashes ##\r\n	#	...\r\n	#	###### Header 6\r\n	#\r\n	$text = preg_replace(\"{\r\n			^(\\\\#{1,6})	# $1 = string of #\'s\r\n			[ \\\\t]*\r\n			(.+?)		# $2 = Header text\r\n			[ \\\\t]*\r\n			\\\\#*			# optional closing #\'s (not counted)\r\n			\\\\n+\r\n		}xme\",\r\n		\"\'<h\'.strlen(\'\\\\1\').\'>\'._RunSpanGamut(_UnslashQuotes(\'\\\\2\')).\'</h\'.strlen(\'\\\\1\').\'>\\n\\n\'\",\r\n		$text);\r\n\r\n	return $text;\r\n}\r\n\r\n\r\nfunction _DoLists($text) {\r\n#\r\n# Form HTML ordered (numbered) and unordered (bulleted) lists.\r\n#\r\n	global $md_tab_width, $md_list_level;\r\n	$less_than_tab = $md_tab_width - 1;\r\n\r\n	# Re-usable patterns to match list item bullets and number markers:\r\n	$marker_ul  = \'[*+-]\';\r\n	$marker_ol  = \'\\d+[.]\';\r\n	$marker_any = \"(?:$marker_ul|$marker_ol)\";\r\n\r\n	$markers = array($marker_ul, $marker_ol);\r\n\r\n	foreach ($markers as $marker) {\r\n		# Re-usable pattern to match any entirel ul or ol list:\r\n		$whole_list = \'\r\n			(								# $1 = whole list\r\n			  (								# $2\r\n				[ ]{0,\'.$less_than_tab.\'}\r\n				(\'.$marker.\')				# $3 = first list item marker\r\n				[ \\t]+\r\n			  )\r\n			  (?s:.+?)\r\n			  (								# $4\r\n				  \\z\r\n				|\r\n				  \\n{2,}\r\n				  (?=\\S)\r\n				  (?!						# Negative lookahead for another list item marker\r\n					[ \\t]*\r\n					\'.$marker.\'[ \\t]+\r\n				  )\r\n			  )\r\n			)\r\n		\'; // mx\r\n\r\n		# We use a different prefix before nested lists than top-level lists.\r\n		# See extended comment in _ProcessListItems().\r\n\r\n		if ($md_list_level) {\r\n			$text = preg_replace_callback(\'{\r\n					^\r\n					\'.$whole_list.\'\r\n				}mx\',\r\n				\'_DoLists_callback_top\', $text);\r\n		}\r\n		else {\r\n			$text = preg_replace_callback(\'{\r\n					(?:(?<=\\n\\n)|\\A\\n?)\r\n					\'.$whole_list.\'\r\n				}mx\',\r\n				\'_DoLists_callback_nested\', $text);\r\n		}\r\n	}\r\n\r\n	return $text;\r\n}\r\nfunction _DoLists_callback_top($matches) {\r\n	# Re-usable patterns to match list item bullets and number markers:\r\n	$marker_ul  = \'[*+-]\';\r\n	$marker_ol  = \'\\d+[.]\';\r\n	$marker_any = \"(?:$marker_ul|$marker_ol)\";\r\n\r\n	$list = $matches[1];\r\n	$list_type = preg_match(\"/$marker_ul/\", $matches[3]) ? \"ul\" : \"ol\";\r\n\r\n	$marker_any = ( $list_type == \"ul\" ? $marker_ul : $marker_ol );\r\n\r\n	# Turn double returns into triple returns, so that we can make a\r\n	# paragraph for the last item in a list, if necessary:\r\n	$list = preg_replace(\"/\\n{2,}/\", \"\\n\\n\\n\", $list);\r\n	$result = _ProcessListItems($list, $marker_any);\r\n\r\n	# Trim any trailing whitespace, to put the closing `</$list_type>`\r\n	# up on the preceding line, to get it past the current stupid\r\n	# HTML block parser. This is a hack to work around the terrible\r\n	# hack that is the HTML block parser.\r\n	$result = rtrim($result);\r\n	$result = \"<$list_type>\" . $result . \"</$list_type>\\n\";\r\n	return $result;\r\n}\r\nfunction _DoLists_callback_nested($matches) {\r\n	# Re-usable patterns to match list item bullets and number markers:\r\n	$marker_ul  = \'[*+-]\';\r\n	$marker_ol  = \'\\d+[.]\';\r\n	$marker_any = \"(?:$marker_ul|$marker_ol)\";\r\n\r\n	$list = $matches[1];\r\n	$list_type = preg_match(\"/$marker_ul/\", $matches[3]) ? \"ul\" : \"ol\";\r\n\r\n	$marker_any = ( $list_type == \"ul\" ? $marker_ul : $marker_ol );\r\n\r\n	# Turn double returns into triple returns, so that we can make a\r\n	# paragraph for the last item in a list, if necessary:\r\n	$list = preg_replace(\"/\\n{2,}/\", \"\\n\\n\\n\", $list);\r\n	$result = _ProcessListItems($list, $marker_any);\r\n	$result = \"<$list_type>\\n\" . $result . \"</$list_type>\\n\";\r\n	return $result;\r\n}\r\n\r\n\r\nfunction _ProcessListItems($list_str, $marker_any) {\r\n#\r\n#	Process the contents of a single ordered or unordered list, splitting it\r\n#	into individual list items.\r\n#\r\n	global $md_list_level;\r\n\r\n	# The $md_list_level global keeps track of when we\'re inside a list.\r\n	# Each time we enter a list, we increment it; when we leave a list,\r\n	# we decrement. If it\'s zero, we\'re not in a list anymore.\r\n	#\r\n	# We do this because when we\'re not inside a list, we want to treat\r\n	# something like this:\r\n	#\r\n	#		I recommend upgrading to version\r\n	#		8. Oops, now this line is treated\r\n	#		as a sub-list.\r\n	#\r\n	# As a single paragraph, despite the fact that the second line starts\r\n	# with a digit-period-space sequence.\r\n	#\r\n	# Whereas when we\'re inside a list (or sub-list), that line will be\r\n	# treated as the start of a sub-list. What a kludge, huh? This is\r\n	# an aspect of Markdown\'s syntax that\'s hard to parse perfectly\r\n	# without resorting to mind-reading. Perhaps the solution is to\r\n	# change the syntax rules such that sub-lists must start with a\r\n	# starting cardinal number; e.g. \"1.\" or \"a.\".\r\n\r\n	$md_list_level++;\r\n\r\n	# trim trailing blank lines:\r\n	$list_str = preg_replace(\"/\\n{2,}\\\\z/\", \"\\n\", $list_str);\r\n\r\n	$list_str = preg_replace_callback(\'{\r\n		(\\n)?							# leading line = $1\r\n		(^[ \\t]*)						# leading whitespace = $2\r\n		(\'.$marker_any.\') [ \\t]+		# list marker = $3\r\n		((?s:.+?)						# list item text   = $4\r\n		(\\n{1,2}))\r\n		(?= \\n* (\\z | \\2 (\'.$marker_any.\') [ \\t]+))\r\n		}xm\',\r\n		\'_ProcessListItems_callback\', $list_str);\r\n\r\n	$md_list_level--;\r\n	return $list_str;\r\n}\r\nfunction _ProcessListItems_callback($matches) {\r\n	$item = $matches[4];\r\n	$leading_line =& $matches[1];\r\n	$leading_space =& $matches[2];\r\n\r\n	if ($leading_line || preg_match(\'/\\n{2,}/\', $item)) {\r\n		$item = _RunBlockGamut(_Outdent($item));\r\n	}\r\n	else {\r\n		# Recursion for sub-lists:\r\n		$item = _DoLists(_Outdent($item));\r\n		$item = preg_replace(\'/\\n+$/\', \'\', $item);\r\n		$item = _RunSpanGamut($item);\r\n	}\r\n\r\n	return \"<li>\" . $item . \"</li>\\n\";\r\n}\r\n\r\n\r\nfunction _DoCodeBlocks($text) {\r\n#\r\n#	Process Markdown `<pre><code>` blocks.\r\n#\r\n	global $md_tab_width;\r\n	$text = preg_replace_callback(\"{\r\n			(?:\\\\n\\\\n|\\\\A)\r\n			(	            # $1 = the code block -- one or more lines, starting with a space/tab\r\n			  (?:\r\n				(?:[ ]\\{$md_tab_width} | \\\\t)  # Lines must start with a tab or a tab-width of spaces\r\n				.*\\\\n+\r\n			  )+\r\n			)\r\n			((?=^[ ]{0,$md_tab_width}\\\\S)|\\\\Z)	# Lookahead for non-space at line-start, or end of doc\r\n		}xm\",\r\n		\'_DoCodeBlocks_callback\', $text);\r\n\r\n	return $text;\r\n}\r\nfunction _DoCodeBlocks_callback($matches) {\r\n	$codeblock = $matches[1];\r\n\r\n	$codeblock = _EncodeCode(_Outdent($codeblock));\r\n//	$codeblock = _Detab($codeblock);\r\n	# trim leading newlines and trailing whitespace\r\n	$codeblock = preg_replace(array(\'/\\A\\n+/\', \'/\\s+\\z/\'), \'\', $codeblock);\r\n\r\n	$result = \"\\n\\n<pre><code>\" . $codeblock . \"\\n</code></pre>\\n\\n\";\r\n\r\n	return $result;\r\n}\r\n\r\n\r\nfunction _DoCodeSpans($text) {\r\n#\r\n# 	*	Backtick quotes are used for <code></code> spans.\r\n#\r\n# 	*	You can use multiple backticks as the delimiters if you want to\r\n# 		include literal backticks in the code span. So, this input:\r\n#\r\n#		  Just type ``foo `bar` baz`` at the prompt.\r\n#\r\n#	  	Will translate to:\r\n#\r\n#		  <p>Just type <code>foo `bar` baz</code> at the prompt.</p>\r\n#\r\n#		There\'s no arbitrary limit to the number of backticks you\r\n#		can use as delimters. If you need three consecutive backticks\r\n#		in your code, use four for delimiters, etc.\r\n#\r\n#	*	You can use spaces to get literal backticks at the edges:\r\n#\r\n#		  ... type `` `bar` `` ...\r\n#\r\n#	  	Turns to:\r\n#\r\n#		  ... type <code>`bar`</code> ...\r\n#\r\n	$text = preg_replace_callback(\'@\r\n			(?<!\\\\\\)	# Character before opening ` can\\\'t be a backslash\r\n			(`+)		# $1 = Opening run of `\r\n			(.+?)		# $2 = The code block\r\n			(?<!`)\r\n			\\1			# Matching closer\r\n			(?!`)\r\n		@xs\',\r\n		\'_DoCodeSpans_callback\', $text);\r\n\r\n	return $text;\r\n}\r\nfunction _DoCodeSpans_callback($matches) {\r\n	$c = $matches[2];\r\n	$c = preg_replace(\'/^[ \\t]*/\', \'\', $c); # leading whitespace\r\n	$c = preg_replace(\'/[ \\t]*$/\', \'\', $c); # trailing whitespace\r\n	$c = _EncodeCode($c);\r\n	return \"<code>$c</code>\";\r\n}\r\n\r\n\r\nfunction _EncodeCode($_) {\r\n#\r\n# Encode/escape certain characters inside Markdown code runs.\r\n# The point is that in code, these characters are literals,\r\n# and lose their special Markdown meanings.\r\n#\r\n	global $md_escape_table;\r\n\r\n	# Encode all ampersands; HTML entities are not\r\n	# entities within a Markdown code span.\r\n	$_ = str_replace(\'&\', \'&amp;\', $_);\r\n\r\n	# Do the angle bracket song and dance:\r\n	$_ = str_replace(array(\'<\',    \'>\'),\r\n					 array(\'&lt;\', \'&gt;\'), $_);\r\n\r\n	# Now, escape characters that are magic in Markdown:\r\n	$_ = str_replace(array_keys($md_escape_table),\r\n					 array_values($md_escape_table), $_);\r\n\r\n	return $_;\r\n}\r\n\r\n\r\nfunction _DoItalicsAndBold($text) {\r\n	# <strong> must go first:\r\n	$text = preg_replace(\'{\r\n			(						# $1: Marker\r\n				(?<!\\*\\*) \\*\\* |	#     (not preceded by two chars of\r\n				(?<!__)   __		#      the same marker)\r\n			)\r\n			(?=\\S) 					# Not followed by whitespace\r\n			(?!\\1)					#   or two others marker chars.\r\n			(						# $2: Content\r\n				(?:\r\n					[^*_]+?			# Anthing not em markers.\r\n				|\r\n									# Balence any regular emphasis inside.\r\n					([*_]) (?=\\S) .+? (?<=\\S) \\3	# $3: em char (* or _)\r\n				|\r\n					(?! \\1 ) .		# Allow unbalenced * and _.\r\n				)+?\r\n			)\r\n			(?<=\\S) \\1				# End mark not preceded by whitespace.\r\n		}sx\',\r\n		\'<strong>\\2</strong>\', $text);\r\n	# Then <em>:\r\n	$text = preg_replace(\r\n		\'{ ( (?<!\\*)\\* | (?<!_)_ ) (?=\\S) (?! \\1) (.+?) (?<=\\S) \\1 }sx\',\r\n		\'<em>\\2</em>\', $text);\r\n\r\n	return $text;\r\n}\r\n\r\n\r\nfunction _DoBlockQuotes($text) {\r\n	$text = preg_replace_callback(\'/\r\n		  (								# Wrap whole match in $1\r\n			(\r\n			  ^[ \\t]*>[ \\t]?			# \">\" at the start of a line\r\n				.+\\n					# rest of the first line\r\n			  (.+\\n)*					# subsequent consecutive lines\r\n			  \\n*						# blanks\r\n			)+\r\n		  )\r\n		/xm\',\r\n		\'_DoBlockQuotes_callback\', $text);\r\n\r\n	return $text;\r\n}\r\nfunction _DoBlockQuotes_callback($matches) {\r\n	$bq = $matches[1];\r\n	# trim one level of quoting - trim whitespace-only lines\r\n	$bq = preg_replace(array(\'/^[ \\t]*>[ \\t]?/m\', \'/^[ \\t]+$/m\'), \'\', $bq);\r\n	$bq = _RunBlockGamut($bq);		# recurse\r\n\r\n	$bq = preg_replace(\'/^/m\', \"  \", $bq);\r\n	# These leading spaces screw with <pre> content, so we need to fix that:\r\n	$bq = preg_replace_callback(\'{(\\s*<pre>.+?</pre>)}sx\',\r\n								\'_DoBlockQuotes_callback2\', $bq);\r\n\r\n	return \"<blockquote>\\n$bq\\n</blockquote>\\n\\n\";\r\n}\r\nfunction _DoBlockQuotes_callback2($matches) {\r\n	$pre = $matches[1];\r\n	$pre = preg_replace(\'/^  /m\', \'\', $pre);\r\n	return $pre;\r\n}\r\n\r\n\r\nfunction _FormParagraphs($text) {\r\n#\r\n#	Params:\r\n#		$text - string to process with html <p> tags\r\n#\r\n	global $md_html_blocks;\r\n\r\n	# Strip leading and trailing lines:\r\n	$text = preg_replace(array(\'/\\A\\n+/\', \'/\\n+\\z/\'), \'\', $text);\r\n\r\n	$grafs = preg_split(\'/\\n{2,}/\', $text, -1, PREG_SPLIT_NO_EMPTY);\r\n\r\n	#\r\n	# Wrap <p> tags.\r\n	#\r\n	foreach ($grafs as $key => $value) {\r\n		if (!isset( $md_html_blocks[$value] )) {\r\n			$value = _RunSpanGamut($value);\r\n			$value = preg_replace(\'/^([ \\t]*)/\', \'<p>\', $value);\r\n			$value .= \"</p>\";\r\n			$grafs[$key] = $value;\r\n		}\r\n	}\r\n\r\n	#\r\n	# Unhashify HTML blocks\r\n	#\r\n	foreach ($grafs as $key => $value) {\r\n		if (isset( $md_html_blocks[$value] )) {\r\n			$grafs[$key] = $md_html_blocks[$value];\r\n		}\r\n	}\r\n\r\n	return implode(\"\\n\\n\", $grafs);\r\n}\r\n\r\n\r\nfunction _EncodeAmpsAndAngles($text) {\r\n# Smart processing for ampersands and angle brackets that need to be encoded.\r\n\r\n	# Ampersand-encoding based entirely on Nat Irons\'s Amputator MT plugin:\r\n	#   http://bumppo.net/projects/amputator/\r\n	$text = preg_replace(\'/&(?!#?[xX]?(?:[0-9a-fA-F]+|\\w+);)/\',\r\n						 \'&amp;\', $text);;\r\n\r\n	# Encode naked <\'s\r\n	$text = preg_replace(\'{<(?![a-z/?\\$!])}i\', \'&lt;\', $text);\r\n\r\n	return $text;\r\n}\r\n\r\n\r\nfunction _EncodeBackslashEscapes($text) {\r\n#\r\n#	Parameter:  String.\r\n#	Returns:    The string, with after processing the following backslash\r\n#				escape sequences.\r\n#\r\n	global $md_escape_table, $md_backslash_escape_table;\r\n	# Must process escaped backslashes first.\r\n	return str_replace(array_keys($md_backslash_escape_table),\r\n					   array_values($md_backslash_escape_table), $text);\r\n}\r\n\r\n\r\nfunction _DoAutoLinks($text) {\r\n	$text = preg_replace(\"!<((https?|ftp):[^\'\\\">\\\\s]+)>!\",\r\n						 \'<a href=\"\\1\">\\1</a>\', $text);\r\n\r\n	# Email addresses: <address@domain.foo>\r\n	$text = preg_replace(\'{\r\n		<\r\n        (?:mailto:)?\r\n		(\r\n			[-.\\w]+\r\n			\\@\r\n			[-a-z0-9]+(\\.[-a-z0-9]+)*\\.[a-z]+\r\n		)\r\n		>\r\n		}exi\',\r\n		\"_EncodeEmailAddress(_UnescapeSpecialChars(_UnslashQuotes(\'\\\\1\')))\",\r\n		$text);\r\n\r\n	return $text;\r\n}\r\n\r\n\r\nfunction _EncodeEmailAddress($addr) {\r\n#\r\n#	Input: an email address, e.g. \"foo@example.com\"\r\n#\r\n#	Output: the email address as a mailto link, with each character\r\n#		of the address encoded as either a decimal or hex entity, in\r\n#		the hopes of foiling most address harvesting spam bots. E.g.:\r\n#\r\n#	  <a href=\"&#x6D;&#97;&#105;&#108;&#x74;&#111;:&#102;&#111;&#111;&#64;&#101;\r\n#		x&#x61;&#109;&#x70;&#108;&#x65;&#x2E;&#99;&#111;&#109;\">&#102;&#111;&#111;\r\n#		&#64;&#101;x&#x61;&#109;&#x70;&#108;&#x65;&#x2E;&#99;&#111;&#109;</a>\r\n#\r\n#	Based by a filter by Matthew Wickline, posted to the BBEdit-Talk\r\n#	mailing list: <http://tinyurl.com/yu7ue>\r\n#\r\n	$addr = \"mailto:\" . $addr;\r\n	$length = strlen($addr);\r\n\r\n	# leave \':\' alone (to spot mailto: later)\r\n	$addr = preg_replace_callback(\'/([^\\:])/\',\r\n								  \'_EncodeEmailAddress_callback\', $addr);\r\n\r\n	$addr = \"<a href=\\\"$addr\\\">$addr</a>\";\r\n	# strip the mailto: from the visible part\r\n	$addr = preg_replace(\'/\">.+?:/\', \'\">\', $addr);\r\n\r\n	return $addr;\r\n}\r\nfunction _EncodeEmailAddress_callback($matches) {\r\n	$char = $matches[1];\r\n	$r = rand(0, 100);\r\n	# roughly 10% raw, 45% hex, 45% dec\r\n	# \'@\' *must* be encoded. I insist.\r\n	if ($r > 90 && $char != \'@\') return $char;\r\n	if ($r < 45) return \'&#x\'.dechex(ord($char)).\';\';\r\n	return \'&#\'.ord($char).\';\';\r\n}\r\n\r\n\r\nfunction _UnescapeSpecialChars($text) {\r\n#\r\n# Swap back in all the special characters we\'ve hidden.\r\n#\r\n	global $md_escape_table;\r\n	return str_replace(array_values($md_escape_table),\r\n					   array_keys($md_escape_table), $text);\r\n}\r\n\r\n\r\n# _TokenizeHTML is shared between PHP Markdown and PHP SmartyPants.\r\n# We only define it if it is not already defined.\r\nif (!function_exists(\'_TokenizeHTML\')) :\r\nfunction _TokenizeHTML($str) {\r\n#\r\n#   Parameter:  String containing HTML markup.\r\n#   Returns:    An array of the tokens comprising the input\r\n#               string. Each token is either a tag (possibly with nested,\r\n#               tags contained therein, such as <a href=\"<MTFoo>\">, or a\r\n#               run of text between tags. Each element of the array is a\r\n#               two-element array; the first is either \'tag\' or \'text\';\r\n#               the second is the actual value.\r\n#\r\n#\r\n#   Regular expression derived from the _tokenize() subroutine in\r\n#   Brad Choate\'s MTRegex plugin.\r\n#   <http://www.bradchoate.com/past/mtregex.php>\r\n#\r\n	$index = 0;\r\n	$tokens = array();\r\n\r\n	$match = \'(?s:<!(?:--.*?--\\s*)+>)|\'.	# comment\r\n			 \'(?s:<\\?.*?\\?>)|\'.				# processing instruction\r\n			 								# regular tags\r\n			 \'(?:<[/!$]?[-a-zA-Z0-9:]+\\b(?>[^\"\\\'>]+|\"[^\"]*\"|\\\'[^\\\']*\\\')*>)\';\r\n\r\n	$parts = preg_split(\"{($match)}\", $str, -1, PREG_SPLIT_DELIM_CAPTURE);\r\n\r\n	foreach ($parts as $part) {\r\n		if (++$index % 2 && $part != \'\')\r\n			$tokens[] = array(\'text\', $part);\r\n		else\r\n			$tokens[] = array(\'tag\', $part);\r\n	}\r\n\r\n	return $tokens;\r\n}\r\nendif;\r\n\r\n\r\nfunction _Outdent($text) {\r\n#\r\n# Remove one level of line-leading tabs or spaces\r\n#\r\n	global $md_tab_width;\r\n	return preg_replace(\"/^(\\\\t|[ ]{1,$md_tab_width})/m\", \"\", $text);\r\n}\r\n\r\n\r\nfunction _Detab($text) {\r\n#\r\n# Replace tabs with the appropriate amount of space.\r\n#\r\n	global $md_tab_width;\r\n\r\n	# For each line we separate the line in blocks delemited by\r\n	# tab characters. Then we reconstruct every line by adding the\r\n	# appropriate number of space between each blocks.\r\n\r\n	$lines = explode(\"\\n\", $text);\r\n	$text = \"\";\r\n\r\n	foreach ($lines as $line) {\r\n		# Split in blocks.\r\n		$blocks = explode(\"\\t\", $line);\r\n		# Add each blocks to the line.\r\n		$line = $blocks[0];\r\n		unset($blocks[0]); # Do not add first block twice.\r\n		foreach ($blocks as $block) {\r\n			# Calculate amount of space, insert spaces, insert block.\r\n			$amount = $md_tab_width - strlen($line) % $md_tab_width;\r\n			$line .= str_repeat(\" \", $amount) . $block;\r\n		}\r\n		$text .= \"$line\\n\";\r\n	}\r\n	return $text;\r\n}\r\n\r\n\r\nfunction _UnslashQuotes($text) {\r\n#\r\n#	This function is useful to remove automaticaly slashed double quotes\r\n#	when using preg_replace and evaluating an expression.\r\n#	Parameter:  String.\r\n#	Returns:    The string with any slash-double-quote (\\\") sequence replaced\r\n#				by a single double quote.\r\n#\r\n	return str_replace(\'\\\"\', \'\"\', $text);\r\n}\r\n\r\n\r\n/*\r\n\r\nPHP Markdown\r\n============\r\n\r\nDescription\r\n-----------\r\n\r\nThis is a PHP translation of the original Markdown formatter written in\r\nPerl by John Gruber.\r\n\r\nMarkdown is a text-to-HTML filter; it translates an easy-to-read /\r\neasy-to-write structured text format into HTML. Markdown\'s text format\r\nis most similar to that of plain text email, and supports features such\r\nas headers, *emphasis*, code blocks, blockquotes, and links.\r\n\r\nMarkdown\'s syntax is designed not as a generic markup language, but\r\nspecifically to serve as a front-end to (X)HTML. You can use span-level\r\nHTML tags anywhere in a Markdown document, and you can use block level\r\nHTML tags (like <div> and <table> as well).\r\n\r\nFor more information about Markdown\'s syntax, see:\r\n\r\n<http://daringfireball.net/projects/markdown/>\r\n\r\n\r\nBugs\r\n----\r\n\r\nTo file bug reports please send email to:\r\n\r\n<michel.fortin@michelf.com>\r\n\r\nPlease include with your report: (1) the example input; (2) the output you\r\nexpected; (3) the output Markdown actually produced.\r\n\r\n\r\nVersion History\r\n---------------\r\n\r\nSee the readme file for detailed release notes for this version.\r\n\r\n1.0.1b - 6 Jun 2005\r\n\r\n1.0.1a - 15 Apr 2005\r\n\r\n1.0.1 - 16 Dec 2004\r\n\r\n1.0 - 21 Aug 2004\r\n\r\n\r\nAuthor & Contributors\r\n---------------------\r\n\r\nOriginal Perl version by John Gruber\r\n<http://daringfireball.net/>\r\n\r\nPHP port and other contributions by Michel Fortin\r\n<http://www.michelf.com/>\r\n\r\n\r\nCopyright and License\r\n---------------------\r\n\r\nCopyright (c) 2004-2005 Michel Fortin\r\n<http://www.michelf.com/>\r\nAll rights reserved.\r\n\r\nCopyright (c) 2003-2004 John Gruber\r\n<http://daringfireball.net/>\r\nAll rights reserved.\r\n\r\nRedistribution and use in source and binary forms, with or without\r\nmodification, are permitted provided that the following conditions are\r\nmet:\r\n\r\n*	Redistributions of source code must retain the above copyright notice,\r\n	this list of conditions and the following disclaimer.\r\n\r\n*	Redistributions in binary form must reproduce the above copyright\r\n	notice, this list of conditions and the following disclaimer in the\r\n	documentation and/or other materials provided with the distribution.\r\n\r\n*	Neither the name \"Markdown\" nor the names of its contributors may\r\n	be used to endorse or promote products derived from this software\r\n	without specific prior written permission.\r\n\r\nThis software is provided by the copyright holders and contributors \"as\r\nis\" and any express or implied warranties, including, but not limited\r\nto, the implied warranties of merchantability and fitness for a\r\nparticular purpose are disclaimed. In no event shall the copyright owner\r\nor contributors be liable for any direct, indirect, incidental, special,\r\nexemplary, or consequential damages (including, but not limited to,\r\nprocurement of substitute goods or services; loss of use, data, or\r\nprofits; or business interruption) however caused and on any theory of\r\nliability, whether in contract, strict liability, or tort (including\r\nnegligence or otherwise) arising in any way out of the use of this\r\nsoftware, even if advised of the possibility of such damage.\r\n\r\n*/');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_facileforms_records`
--

CREATE TABLE `jos3_facileforms_records` (
  `id` int(11) NOT NULL,
  `submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `form` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `ip` varchar(30) NOT NULL DEFAULT '',
  `browser` varchar(255) NOT NULL DEFAULT '',
  `opsys` varchar(255) NOT NULL DEFAULT '',
  `provider` varchar(255) NOT NULL DEFAULT '',
  `viewed` tinyint(1) NOT NULL DEFAULT '0',
  `exported` tinyint(1) NOT NULL DEFAULT '0',
  `archived` tinyint(1) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `username` varchar(255) NOT NULL DEFAULT '',
  `user_full_name` varchar(255) NOT NULL DEFAULT '',
  `paypal_tx_id` varchar(255) NOT NULL DEFAULT '',
  `paypal_payment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `paypal_testaccount` tinyint(1) NOT NULL DEFAULT '0',
  `paypal_download_tries` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `jos3_facileforms_records`
--

INSERT INTO `jos3_facileforms_records` (`id`, `submitted`, `form`, `title`, `name`, `ip`, `browser`, `opsys`, `provider`, `viewed`, `exported`, `archived`, `user_id`, `username`, `user_full_name`, `paypal_tx_id`, `paypal_payment_date`, `paypal_testaccount`, `paypal_download_tries`) VALUES
(1, '2016-10-06 10:56:55', 15, 'Formulari de Contacte CA', 'QFCA01', '88.21.144.109', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.143 Safari/537.36', 'win', 'Unknown', 0, 0, 0, 0, '-', '-', '', '0000-00-00 00:00:00', 0, 0),
(2, '2017-01-13 11:14:22', 15, 'Formulari de Contacte CA', 'QFCA01', '80.37.229.233', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0', 'win', 'Unknown', 0, 0, 0, 0, '-', '-', '', '0000-00-00 00:00:00', 0, 0),
(3, '2017-03-13 17:50:40', 15, 'Formulari de Contacte CA', 'QFCA01', '5.40.77.124', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:51.0) Gecko/20100101 Firefox/51.0', 'mac', 'Unknown', 0, 0, 0, 0, '-', '-', '', '0000-00-00 00:00:00', 0, 0),
(4, '2017-04-12 17:12:38', 15, 'Formulari de Contacte CA', 'QFCA01', '83.63.153.125', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'win', 'Unknown', 1, 0, 0, 0, '-', '-', '', '0000-00-00 00:00:00', 0, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_facileforms_scripts`
--

CREATE TABLE `jos3_facileforms_scripts` (
  `id` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `package` varchar(30) NOT NULL DEFAULT '',
  `name` varchar(30) NOT NULL DEFAULT '',
  `title` varchar(50) NOT NULL DEFAULT '',
  `description` text,
  `type` varchar(30) NOT NULL DEFAULT '',
  `code` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `jos3_facileforms_scripts`
--

INSERT INTO `jos3_facileforms_scripts` (`id`, `published`, `package`, `name`, `title`, `description`, `type`, `code`) VALUES
(1, 1, 'FF', 'ff_anychecked', 'Any Checked', 'Validate that any radio button or checkbox of a group is checked.', 'Element Validation', 'function ff_anychecked(element, message)\r\n{\r\n    // get plain name\r\n   // alert(document.ff_form52[\'ff_nm_bfQuickMode6303958[]\']);\r\n   // alert(document.getElementById(element.id).id);\r\n    var name = \'\';\r\n    if(!element.name){\r\n    	if(element.length && element.length != 0){\r\n           name = element[0].name;\r\n           var cnt = 0;\r\n           for (var i = 0; i < element.length; i++)\r\n             if (element[i].name==name) \r\n              if (element[i].checked) cnt++;                      \r\n           if (cnt==0) {\r\n            ff_validationFocus(element[0].name);\r\n            if (message==\'\') message = \"Please check or select \"+name+\".\\n\";\r\n            return message;\r\n           } // if \r\n\r\n        } else {\r\n           return \'\';\r\n        }\r\n    } else {\r\n      name = element.name;\r\n      if (name.substr(0,6) == \'ff_nm_\') name = name.substring(6,name.length-2);\r\n\r\n      // loop through elements and count selections\r\n      var cnt = 0;\r\n      for (var i = 0; i < ff_elements.length; i++)\r\n        if (ff_elements[i][2]==name) \r\n            if (ff_getElementByIndex(i).checked) cnt++;\r\n\r\n      // if none selected, emitt error\r\n      if (cnt==0) {\r\n        ff_validationFocus(element.name);\r\n        if (message==\'\') message = \"Please check or select \"+name+\".\\n\";\r\n        return message;\r\n      } // if\r\n    }\r\n    \r\n    return \'\';\r\n} // ff_anychecked'),
(2, 1, 'FF', 'ff_checked', 'Checked', 'Validate that radio button or checkbox is checked.', 'Element Validation', 'function ff_checked(element, message)\r\n{\r\n    if (element.checked) \r\n        return \'\'; \r\n    else {\r\n        if (message==\'\') message = element.name+\" is not checked.\\n\";\r\n        ff_validationFocus(element.name);\r\n        return message;\r\n    } \r\n}'),
(3, 1, 'FF', 'ff_checkedValue', 'Get checked value', 'Get value of the currently checked radiobutton.', 'Untyped', 'function ff_checkedValue(name)\r\n{\r\n    // loop through elements and find checked\r\n    for (i = 0; i < ff_elements.length; i++)\r\n        if (ff_elements[i][2]==name) {\r\n            e = ff_getElementByIndex(i);\r\n            if (e.checked) return e.value;\r\n        } // if \r\n    return \'\';\r\n} // ff_checkedValue'),
(4, 1, 'FF', 'ff_countQuerySelections', 'Count Query Selections', 'Counts how many checkboxes/radiobuttons are checked/selected in a query list element', 'Untyped', 'function ff_countQuerySelections(name)\r\n{\r\n    var id = ff_getIdByName(name);\r\n    var cnt = ff_queryRows[id].length;\r\n    var pagesize = ff_queryPageSize[id];\r\n    if (pagesize>0) {\r\n        var currpage = ff_queryCurrPage[id];\r\n        var p;\r\n        for (p = 1; p < currpage; p++) cnt -= pagesize;\r\n        if (cnt > pagesize) cnt = pagesize;\r\n    } // if\r\n    var curr;\r\n    var sels = 0;\r\n    for (curr = 0; curr < cnt; curr++)\r\n        if (document.getElementById(\'ff_cb\'+id+\'_\'+curr).checked) sels++;\r\n    return sels;\r\n} // ff_countQuerySelections'),
(5, 1, 'FF', 'ff_dollaramount2dp', 'Dollar Amount with 2 Decimal Places', 'Validate that a dollar amount with two decimal places is entered.', 'Element Validation', 'function ff_dollaramount2dp(element, message)\r\n{\r\n    var ex  = /^\\d+$|^\\d+\\.\\d{2}$/;\r\n    if (!ex.test(element.value)) {\r\n        if (message==\'\') message = element.name+\" must be a number with two decimal places.\\n\";\r\n        ff_validationFocus(element.name);\r\n        return message;\r\n    } // if\r\n    return \'\';\r\n} // ff_dollaramount2dp'),
(6, 1, 'FF', 'ff_expString', 'String export', 'Export string function: escapes special characters of a string', 'Untyped', 'function ff_expString(text)\r\n{\r\n    text = trim(text);\r\n    var i;\r\n    var o = \'\';\r\n    for(i = 0; i < text.length; i++) {\r\n        c = text.charAt(i);\r\n        switch(c) {\r\n            case \';\' : o += \'\\\\x3B\'; break;\r\n            case \',\' : o += \'\\\\x2C\'; break;\r\n            case \'&\' : o += \'\\\\x26\'; break;\r\n            case \'<\' : o += \'\\\\x3C\'; break;\r\n            case \'>\' : o += \'\\\\x3E\'; break;\r\n            case \'\\\'\': o += \'\\\\x27\'; break;\r\n            case \'\\\\\': o += \'\\\\x5C\'; break;\r\n            case \'\"\' : o += \'\\\\x22\'; break;\r\n            case \'\\n\': o += \'\\\\n\'; break;\r\n            case \'\\r\': o += \'\\\\r\'; break;\r\n            default: o += c;\r\n        } // switch\r\n    } // for\r\n    return o;\r\n} // expString'),
(7, 1, 'FF', 'ff_flashupload_not_empty', 'Flash Upload Not Empty (QuickMode only!)', 'Validates if a flash upload is empty or not.', 'Element Validation', 'function ff_flashupload_not_empty(element, message)\r\n{\r\n    if(typeof bfSummarizers == \"undefined\") { alert(\"Flash upload validation only available in QuickMode!\"); return \'\'}\r\n    if(JQuery(\'#bfFlashFileQueue\'+element.id.split(\'ff_elem\')[1]).html() != \'\') return \'\';\r\n    if (message==\'\') message = \"Please enter \"+element.name+\".\\n\";\r\n    ff_validationFocus(element.name);\r\n    return message;\r\n} // ff_valuenotempty'),
(8, 1, 'FF', 'ff_getfocus', 'Get focus', 'Get the focus. Usually this is for the first element of the form/page.', 'Element Init', 'function ff_getfocus(element,condition)\r\n{\r\n    if(!element.name){\r\n    	if(element.length && element.length != 0){\r\n    		element[0].focus();\r\n    	}\r\n    }else{\r\n    	element.focus();\r\n    }\r\n}'),
(9, 1, 'FF', 'ff_getQuerySelectedRows', 'Get Query Selected Rows', 'Returns the selected rows in a 2-dimensional array', 'Untyped', 'function ff_getQuerySelectedRows(name)\r\n{\r\n    var id = ff_getIdByName(name);\r\n    var rcnt = ff_queryRows[id].length;\r\n    var cnt = rcnt;\r\n    var pagesize = ff_queryPageSize[id];\r\n    if (pagesize>0) {\r\n        var currpage = ff_queryCurrPage[id];\r\n        var p;\r\n        for (p = 1; p < currpage; p++) cnt -= pagesize;\r\n        if (cnt > pagesize) cnt = pagesize;\r\n    } // if\r\n    var curr, r;\r\n    var selcnt = 0;\r\n    var sels = new Array;\r\n    for (curr = 0; curr < cnt; curr++) {\r\n        var elem = document.getElementById(\'ff_cb\'+id+\'_\'+curr);\r\n        if (elem.checked) {\r\n            var ident = elem.value;\r\n            for (r = 0; r < rcnt; r++)\r\n                if (ff_queryRows[id][r][0] == ident) {\r\n                    sels[selcnt++] = ff_queryRows[id][r];\r\n                    break;\r\n                } // if\r\n        } // if\r\n    } // for\r\n    return sels;\r\n} // ff_getQuerySelectedRows'),
(10, 1, 'FF', 'ff_getQuerySelections', 'Get Query Selected ID\'s', 'Returns the column values of the checked/selected checkboxes/radiobuttons in an array', 'Untyped', 'function ff_getQuerySelections(name)\r\n{\r\n    var id = ff_getIdByName(name);\r\n    var cnt = ff_queryRows[id].length;\r\n    var pagesize = ff_queryPageSize[id];\r\n    if (pagesize>0) {\r\n        var currpage = ff_queryCurrPage[id];\r\n        var p;\r\n        for (p = 1; p < currpage; p++) cnt -= pagesize;\r\n        if (cnt > pagesize) cnt = pagesize;\r\n    } // if\r\n    var curr;\r\n    var selcnt = 0;\r\n    var sels = new Array;\r\n    for (curr = 0; curr < cnt; curr++) {\r\n        var elem = document.getElementById(\'ff_cb\'+id+\'_\'+curr);\r\n        if (elem.checked) \r\n            sels[selcnt++] = elem.value;\r\n    } // for\r\n    return sels;\r\n} // ff_getQuerySelections'),
(11, 1, 'FF', 'ff_htmlvaluenotempty', 'HTML Texteditor Not Empty', 'Checks if an HTML editor element is empty or not', 'Element Validation', 'function ff_htmlvaluenotempty( element, message ){\r\n    \r\n    if( typeof bf_htmltextareanames == \"undefined\" ) return \'\';\r\n\r\n    var content = \"\";\r\n\r\n    for(var i = 0; i < bf_htmltextareanames.length; i++){\r\n      if( element.name == bf_htmltextareanames[i] ) {\r\n          eval(\"content = \" + bf_htmltextareas[i]);\r\n          break;\r\n      }\r\n    }\r\n    if (JQuery.trim(content) == \"\") {\r\n        if (message==\'\') message = element.name+\" must not be empty.\\n\";\r\n        return message;\r\n    } // if\r\n    return \'\';\r\n}'),
(12, 1, 'FF', 'ff_impString', 'String import', 'Import string function: unescapes c-coded characters of a string', 'Untyped', 'function ff_impString(text)\r\n{\r\n    var str = \'\';\r\n    var ss = 0;\r\n    var s;\r\n    var tl = text.length;\r\n    var hexdigs = \"0123456789abcdefABCDEF\";\r\n    while (ss < tl) {\r\n        s = text.charAt(ss++);\r\n        if (s == \'\\\\\') {\r\n            if (ss < tl) s = text.charAt(ss++); else s = 0;\r\n            switch (s) {\r\n                case 0   : break;\r\n                case \'e\' : str += \'\\33\'; break;\r\n                case \'t\' : str += \'\\t\'; break;\r\n                case \'r\' : str += \'\\r\'; break;\r\n                case \'n\' : str += \'\\n\'; break;\r\n                case \'f\' : str += \'\\f\'; break;\r\n                case \'x\' : {\r\n                    if (ss < tl) s = text.charAt(ss++); else s = 0;\r\n                    var ch = \'\';\r\n                    while (hexdigs.indexOf(s)>=0 && ch.length < 2) {\r\n                        ch += s;\r\n                        if (ss < tl) s = text.charAt(ss++); else s = 0;\r\n                    } // while\r\n                    while (ch.length < 2) ch = \'0\'+ch;\r\n                    str += unescape(\'%\'+ch);\r\n                    if (s) ss--;\r\n                    break;\r\n                }\r\n                default:\r\n                    str += s;\r\n            } // switch\r\n        } else\r\n            str += s;\r\n    } // while\r\n    return str;\r\n} // impString'),
(13, 1, 'FF', 'ff_integer', 'Integer Number', 'Validate that an integer value is entered.', 'Element Validation', 'function ff_integer(element, message)\r\n{\r\n    var ex  = /(^-?\\d\\d*$)/;\r\n    if (!ex.test(element.value)) {\r\n        if (message==\'\') message = element.name+\" must be integer.\\n\";\r\n        ff_validationFocus(element.name);\r\n        return message;\r\n    } // if\r\n    return \'\';\r\n} // ff_integer'),
(14, 1, 'FF', 'ff_integeramount', 'Positive Integer', 'Validate that an positive integer value is entered.', 'Element Validation', 'function ff_integeramount(element, message)\r\n{\r\n    var ex  = /(^-?\\d\\d*$)/;\r\n    if (!ex.test(element.value)) {\r\n        if (message==\'\') message = element.name+\" must be integer.\\n\";\r\n        ff_validationFocus(element.name);\r\n        return message;\r\n    } // if\r\n    return \'\';\r\n} // ff_integeramount'),
(15, 1, 'FF', 'ff_integer_or_empty', 'Integer or empty', 'Validate that either an integer value or nothing is entered.', 'Element Validation', 'function ff_integer_or_empty(element, message)\r\n{\r\n    if (element.value != \'\') {\r\n        var ex  = /(^-?\\d\\d*$)/;\r\n        if (!ex.test(element.value)) {\r\n            if (message==\'\') message = element.name+\" must be integer.\\n\";\r\n            ff_validationFocus(element.name);\r\n            return message;\r\n        } // if\r\n    } // if\r\n    return \'\';\r\n} // ff_integer_or_empty'),
(16, 1, 'FF', 'ff_nextpage', 'Next page', 'Switchs to the next page.', 'Element Action', 'function ff_nextpage(element, action)\r\n{\r\n    if (ff_currentpage < ff_lastpage) {\r\n        ff_switchpage(ff_currentpage+1);\r\n        self.scrollTo(0,0);\r\n    }\r\n} // ff_nextpage'),
(17, 1, 'FF', 'ff_page1', 'Page 1', 'Switches to the first page.', 'Element Action', 'function ff_page1(element, action)\r\n{\r\n    ff_switchpage(1);\r\n} // ff_page1'),
(18, 1, 'FF', 'ff_page2', 'Page 2', 'Switches to the second page.', 'Element Action', 'function ff_page2(element, action)\r\n{\r\n    if (ff_lastpage >= 2) ff_switchpage(2);\r\n} // ff_page2'),
(19, 1, 'FF', 'ff_page3', 'Page 3', 'Switches to the third page.', 'Element Action', 'function ff_page3(element, action)\r\n{\r\n    if (ff_lastpage >= 3) ff_switchpage(3);\r\n} // ff_page3'),
(20, 1, 'FF', 'ff_previouspage', 'Previous page', 'Switches to the previous page.', 'Element Action', 'function ff_previouspage(element, action)\r\n{\r\n    if (ff_currentpage > 1){\r\n        ff_switchpage(ff_currentpage-1);\r\n        self.scrollTo(0,0);\r\n    }\r\n} // ff_previouspage'),
(21, 1, 'FF', 'ff_real', 'Real Number', 'Validate that a real number is entered.', 'Element Validation', 'function ff_real(element, message)\r\n{\r\n    var ex  = /(^-?\\d\\d*\\.?\\d*$)/;\r\n    if (!ex.test(element.value)) {\r\n        if (message==\'\') message = element.name+\" must be a number.\\n\";\r\n        ff_validationFocus(element.name);\r\n        return message;\r\n    } // if\r\n    return \'\';\r\n} // ff_real'),
(22, 1, 'FF', 'ff_realamount', 'Positive Real Number', 'Validate that a positive real number is entered.', 'Element Validation', 'function ff_realamount(element, message)\r\n{\r\n    var ex  = /(^\\d\\d*\\.?\\d*$)/;\r\n    if (!ex.test(element.value)) {\r\n        if (message==\'\') message = element.name+\" must be a number.\\n\";\r\n        ff_validationFocus(element.name);\r\n        return message;\r\n    } // if\r\n    return \'\';\r\n} // ff_realamount'),
(23, 1, 'FF', 'ff_resetForm', 'Reset form', 'Reset all form inputs to the initial values.', 'Element Action', 'function ff_resetForm(element, action)\r\n{\r\n    eval(\'document.\'+ff_processor.form_id).reset();\r\n} // ff_resetForm'),
(24, 1, 'FF', 'ff_securitycode_entered', 'Security code entered', 'Check that a security code was entered.', 'Element Validation', 'function ff_securitycode_entered(element, message)\r\n{\r\n    var ex  = /(^\\d{5}$)/;\r\n    if (!ex.test(element.value)) {\r\n        if (message==\'\') message = \"Security code must be entered as five digits.\\n\";\r\n        ff_validationFocus(element.name);\r\n        return message;\r\n    } // if\r\n    return \'\';\r\n} // ff_securitycode_entered'),
(25, 1, 'FF', 'ff_securitycode_ok', 'Security code ok', 'Check that a valid security code was entered.', 'Element Validation', 'function ff_securitycode_ok(element, message)\r\n{\r\n<?php\r\n    global $ff_seccode;\r\n    if (!isset($ff_seccode)) { \r\n        mt_srand((double)microtime()*1000000);\r\n        $ff_seccode = mt_rand(10000, 99999);\r\n        JFactory::getSession()->set(\'ff_seccode\', $ff_seccode);\r\n    } // if\r\n    $enc = array();\r\n    mt_srand((double)microtime()*1000000);\r\n    for ($i = 0; $i < 256; $i++) $enc[] = mt_rand(0, 255);\r\n    $seccode = (string)$ff_seccode;\r\n    $hash = \'\';\r\n    $ini = $ff_seccode % 240;\r\n    for ($i = 0; $i < 5; $i++) {\r\n        $d = $ini+intval($seccode{$i});\r\n        for ($j = 0; $j < 7; $j++) $d = $enc[$d];\r\n        $hash .= $d;\r\n        $ini = ($ini+$d) % 240;\r\n    } // for\r\n    return\r\n        \"var enc = \".$this->expJsValue($enc).\";\\n\".\r\n        \"var seccode = new String(element.value);\\n\".\r\n        \"if (seccode.length==5) {\\n\".\r\n        \"    var hash = \'\';\\n\".\r\n        \"    var ini = parseInt(element.value) % 240;\\n\".\r\n        \"    var i, j;\\n\".\r\n        \"    for (i = 0; i < 5; i++) {\\n\".\r\n        \"        var d = ini+parseInt(seccode.charAt(i));\\n\".\r\n        \"        for (j = 0; j < 7; j++) d = enc[d];\\n\".\r\n        \"        hash += d;\\n\".\r\n        \"        ini = (ini+d) % 240;\\n\".\r\n        \"    } // for\\n\".\r\n        \"    if (hash == \'$hash\') return \'\';\\n\". \r\n        \"} // if\\n\".\r\n        \"if (message==\'\') message = \\\"Security code is missing or wrong.\\\\n\\\";\\n\".\r\n        \"ff_validationFocus(element.name);\\n\".\r\n        \"return message;\\n\";\r\n?>\r\n} // ff_securitycode_ok'),
(26, 1, 'FF', 'ff_selectedValues', 'Get selected values as list', 'Get values of selected options of a select list as list:\r\n\r\nx = ff_selectedValues(\'myselectlist\');\r\n// x = green,red', 'Untyped', 'function ff_selectedValues(name)\r\n{\r\n    vals = \'\';\r\n    opts = ff_getElementByName(name).options;\r\n    for (o = 0; o < opts.length; o++)\r\n        if (opts[o].selected) {\r\n            if (vals != \'\') vals += \',\';\r\n            vals += opts[o].value;\r\n        } // if\r\n    return vals;\r\n} // ff_selectedValues'),
(27, 1, 'FF', 'ff_setChecked', 'Set radiobutton checked', 'Set a radiobutton checked/unchecked', 'Untyped', 'function ff_setChecked(name, value, checked)\r\n{\r\n    if (arguments.length<3) checked = true;\r\n    for (var i = 0; i < ff_elements.length; i++)\r\n        if (ff_elements[i][2]==name) {\r\n            var e = ff_getElementByIndex(i);\r\n            if (e.value == value) {\r\n                e.checked = checked;\r\n                break;\r\n            } // if\r\n        } // if\r\n} // ff_setChecked'),
(28, 1, 'FF', 'ff_setSelected', 'Select options of  select list', 'Select options in a Select List element.\r\n\r\nff_setSelected(\'mylist\', \'green\'); // select green in single or multi mode, unselect all other options\r\nff_setSelected(\'mylist\', \'red,green\'); // select red and green in multi mode, unselect all other options', 'Untyped', 'function ff_setSelected(name, list)\r\n{\r\n    ids = list.split(\',\')\r\n    opts = ff_getElementByName(name).options;\r\n    for (o = 0; o < opts.length; o++) {\r\n        state = false;\r\n        for (i = 0; i < ids.length; i++) \r\n            if (ids[i]==opts[o].value) {\r\n                state = true;\r\n                break;\r\n            } // if\r\n        opts[o].selected = state;\r\n    } // for\r\n} // ff_setSelected'),
(29, 1, 'FF', 'ff_showaction', 'Show action', 'Displays the element action.', 'Element Action', 'function ff_showaction(element, action)\r\n{\r\n   alert(\'Action \'+action+\' performed by element \'+element.id);\r\n}'),
(30, 1, 'FF', 'ff_showelementinit', 'Show element initialization', 'Display the element initialization (mainly for debugging)', 'Element Init', 'function ff_showelementinit(element,condition)\r\n{\r\n    if(!element.name)\r\n    	if(element.length && element.length != 0)\r\n    		alert(\'Initialization of \'+element[0].name+\' at \'+condition);\r\n    else\r\n    	alert(\'Initialization of \'+element.name+\' at \'+condition);\r\n}'),
(31, 1, 'FF', 'ff_showforminit', 'Show form initialization', 'Show when form initialization is run (for debugging)', 'Form Init', 'function ff_showforminit()\r\n{\r\n    alert(\'Form initialization\');\r\n}'),
(32, 1, 'FF', 'ff_showsubmitted', 'Show submitted status', 'Display submit status as user feedback.', 'Form Submitted', 'function ff_showsubmitted(status, message)\r\n{\r\n    alert(message);\r\n} // ff_showsubmitted'),
(33, 1, 'FF', 'ff_showvalidation', 'Show element validation', 'Display element validation (for debugging)', 'Element Validation', 'function ff_showvalidation(element, message)\r\n{\r\n    alert(\'Validation of \'+element.name+\" with message: \\n\"+message);\r\n    return \'\';\r\n}'),
(34, 1, 'FF', 'ff_submittedhome', 'Return to homepage', 'Display submit status and then return to the home page of the site.', 'Form Submitted', 'function ff_submittedhome(status, message)\r\n{\r\n    alert(message+\"\\nYou will be redirected to the home page now.\");\r\n    ff_returnHome();\r\n} // ff_submittedhome'),
(35, 1, 'FF', 'ff_unchecked', 'Unchecked', 'Validate that radio button or checkbox is unchecked.', 'Element Validation', 'function ff_unchecked(element, message)\r\n{\r\n    if (!element.checked) \r\n        return \'\'; \r\n    else {\r\n        if (message==\'\') message = element.name+\" is checked.\\n\";\r\n        ff_validationFocus(element.name);\r\n        return message;\r\n    } // if\r\n} // ff_unchecked'),
(36, 1, 'FF', 'ff_validate_date_DDMMYYYY', 'Validate Date DD/MM/YYYY format', 'Validates that the date in a textfield is correctly formatted in DD/MM/YYYY format.\r\nCan be used with a textfield element and/or the Calendar element.', 'Element Validation', 'function ff_validate_date_DDMMYYYY(element, message)\r\n{\r\n   // Regular expression used to check if date is in correct format\r\n   var pattern = /[0-3][0-9]\\/(0|1)[0-9]\\/(19|20)[0-9]{2}/;\r\n   if(pattern.test(element.value))\r\n   {\r\n      var date_array = element.value.split(\'/\');\r\n      var day = date_array[0];\r\n\r\n      // Attention! Javascript consider months in the range 0 - 11\r\n      var month = date_array[1] - 1;\r\n      var year = date_array[2];\r\n\r\n      // This instruction will create a date object\r\n      source_date = new Date(year,month,day);\r\n\r\n      if(year != source_date.getFullYear())\r\n      {\r\n         return message == \'\' ? \'Element \' + element.name + \' failed my test\' : message;\r\n      }\r\n\r\n      if(month != source_date.getMonth())\r\n      {\r\n         return message == \'\' ? \'Element \' + element.name + \' failed my test\' : message;\r\n      }\r\n\r\n      if(day != source_date.getDate())\r\n      {\r\n         return message == \'\' ? \'Element \' + element.name + \' failed my test\' : message;\r\n      }\r\n   }\r\n   else\r\n   {\r\n      return message == \'\' ? \'Element \' + element.name + \' failed my test\' : message;\r\n   }\r\n\r\n   return \'\';\r\n}'),
(37, 1, 'FF', 'ff_validate_form', 'Validate form', 'Validates the form and displays the result.', 'Element Action', 'function ff_validate_form(element, action)\r\n{\r\n    if(typeof bfUseErrorAlerts != \'undefined\'){\r\n     JQuery(\".bfErrorMessage\").html(\'\');\r\n     JQuery(\".bfErrorMessage\").css(\"display\",\"none\");\r\n    }\r\n    error = ff_validation(0);\r\n    if (error != \'\') {\r\n        if(typeof bfUseErrorAlerts == \'undefined\'){\r\n           alert(error);\r\n        } else {\r\n           bfShowErrors(error);\r\n        }\r\n        ff_validationFocus(\'\');\r\n    } else\r\n        alert(\'All inputs are valid.\');\r\n} // ff_validate_form'),
(38, 1, 'FF', 'ff_validate_nextpage', 'Validate and next page', 'Validates the current page, and if everything is ok is switches to the next page.', 'Element Action', 'function ff_validate_nextpage(element, action)\r\n{\r\n    if(typeof bfUseErrorAlerts != \'undefined\'){\r\n     JQuery(\".bfErrorMessage\").html(\'\');\r\n     JQuery(\".bfErrorMessage\").css(\"display\",\"none\");\r\n    }\r\n\r\n    error = ff_validation(ff_currentpage);\r\n    if (error != \'\') {\r\n       if(typeof bfUseErrorAlerts == \'undefined\'){\r\n           alert(error);\r\n        } else {\r\n           bfShowErrors(error);\r\n        }\r\n        ff_validationFocus(\'\');\r\n    } else {\r\n        ff_switchpage(ff_currentpage+1);\r\n        self.scrollTo(0,0);   \r\n    }\r\n} // ff_validate_nextpage'),
(39, 1, 'FF', 'ff_validate_page', 'Validate page', 'Validates the current page and displays the result.', 'Element Action', 'function ff_validate_page(element, action)\r\n{\r\n    if(typeof bfUseErrorAlerts != \'undefined\'){\r\n     JQuery(\".bfErrorMessage\").html(\'\');\r\n     JQuery(\".bfErrorMessage\").css(\"display\",\"none\");\r\n    }\r\n    error = ff_validation(ff_currentpage);\r\n    if (error != \'\') {\r\n        if(typeof bfUseErrorAlerts == \'undefined\'){\r\n           alert(error);\r\n        } else {\r\n           bfShowErrors(error);\r\n        }\r\n        ff_validationFocus(\'\');\r\n    } else\r\n        alert(\'All inputs are valid.\');\r\n} // ff_validate_page'),
(40, 1, 'FF', 'ff_validate_prevpage', 'Validate previous page', 'Validates the current page and switches to the previous page if all is ok', 'Element Action', 'function ff_validate_prevpage(element, action)\r\n{\r\n    if(typeof bfUseErrorAlerts != \'undefined\'){\r\n     JQuery(\".bfErrorMessage\").html(\'\');\r\n     JQuery(\".bfErrorMessage\").css(\"display\",\"none\");\r\n    }\r\n\r\n    error = ff_validation(ff_currentpage);\r\n    if (error != \'\') {\r\n       if(typeof bfUseErrorAlerts == \'undefined\'){\r\n           alert(error);\r\n        } else {\r\n           bfShowErrors(error);\r\n        }\r\n        ff_validationFocus(\'\');\r\n    } else{\r\n    	if(ff_currentpage > 1){\r\n	 ff_switchpage(ff_currentpage-1);\r\n	 self.scrollTo(0,0);\r\n        }\r\n    }\r\n} // ff_validate_prevpage'),
(41, 1, 'FF', 'ff_validate_submit', 'Validate and submit form', 'Validates the whole form, and if everything is ok it submits the form.', 'Element Action', 'function ff_validate_submit(element, action)\r\n{\r\n    if(typeof bfUseErrorAlerts != \'undefined\'){\r\n     JQuery(\".bfErrorMessage\").html(\'\');\r\n     JQuery(\".bfErrorMessage\").css(\"display\",\"none\");\r\n    }\r\n    error = ff_validation(0);\r\n    if (error != \'\') {\r\n\r\n        if(typeof bfUseErrorAlerts == \'undefined\'){\r\n           alert(error);\r\n        } else {\r\n           bfShowErrors(error);\r\n        }\r\n        ff_validationFocus();\r\n    } else\r\n        ff_submitForm();\r\n} // ff_validate_submit'),
(42, 1, 'FF', 'ff_validemail', 'Valid email', 'Validate entry of a valid email (syntax check only)', 'Element Validation', 'function ff_validemail(element, message)\r\n{\r\n    var check =\r\n    /^([a-zA-Z0-9_\\.\\-])+\\@(([a-zA-Z0-9\\-])+\\.)+([a-zA-Z0-9]{2,4})+$/;\r\n    if (!check.test(element.value)){\r\n        if (message==\'\') message = element.name+\" is no valid email address.\\n\";\r\n        ff_validationFocus(element.name);\r\n        return message;\r\n    } // if\r\n    return \'\';\r\n} // ff_validemail'),
(43, 1, 'FF', 'ff_validemail_repeat', 'Validate Email repeat', 'Checks if the field value is a valid email address and has a second counterpart that has an equal value.\r\nThe 2nd email field must be named \"FIELDNAME_repeat\"!', 'Element Validation', 'function ff_validemail_repeat(element, message)\r\n{\r\n    var check =\r\n    /^([a-zA-Z0-9_\\.\\-])+\\@(([a-zA-Z0-9\\-])+\\.)+([a-zA-Z0-9]{2,4})+$/;\r\n    if (!check.test(element.value)){\r\n        if (message==\'\') message = element.name+\" is no valid email address.\\n\";\r\n        ff_validationFocus(element.name);\r\n        return message;\r\n    } // if\r\n	\r\n    try{\r\n	    var repeat = element.name.split(\"ff_nm_\")[1].split(\"[]\")[0];\r\n	\r\n	    if(!ff_getElementByName(repeat + \'_repeat\')){\r\n	     	if (message==\'\') message = repeat+\" has no repeat email field.\\n\";\r\n	        ff_validationFocus(element.name);\r\n	        return message;\r\n	    } else {\r\n	        if(ff_getElementByName(repeat + \'_repeat\').value != element.value){\r\n	           if (message==\'\') message = element.name+\" and \" + repeat + \"_repeat do not match.\\n\";\r\n	           ff_validationFocus(repeat + \'_repeat\');\r\n	           return message;\r\n	        }\r\n	    }\r\n    }catch(e){\r\n        return e.description;\r\n    }\r\n\r\n    return \'\';\r\n} // ff_validemail'),
(44, 1, 'FF', 'ff_valuenotempty', 'Value not empty', 'Validate that value is not empty.', 'Element Validation', 'function ff_valuenotempty(element, message)\r\n{\r\n    if (element.value!=\'\') return \'\'; \r\n    if (message==\'\') message = \"Please enter \"+element.name+\".\\n\";\r\n    ff_validationFocus(element.name);\r\n    return message;\r\n} // ff_valuenotempty');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_facileforms_subrecords`
--

CREATE TABLE `jos3_facileforms_subrecords` (
  `id` int(11) NOT NULL,
  `record` int(11) NOT NULL DEFAULT '0',
  `element` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(255) NOT NULL DEFAULT '',
  `value` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `jos3_facileforms_subrecords`
--

INSERT INTO `jos3_facileforms_subrecords` (`id`, `record`, `element`, `title`, `name`, `type`, `value`) VALUES
(1, 1, 220, 'Nom', 'name', 'Text', 'Xavier Pérez'),
(2, 1, 221, 'Correu Electrònic', 'email', 'Text', 'bilanzbarna2@gmail.com'),
(3, 1, 235, 'Assumpte', 'subject', 'Text', 'Congrés maig'),
(4, 1, 222, 'Missatge', 'message', 'Textarea', 'M´agradaria em fesiu arribar informació sobre el congrés que teniu programat pels dies 22-23 de maig de 2007.\r\nSaber si es necessari alguna acreditació o si es obert a tothom.'),
(5, 2, 220, 'Nom', 'name', 'Text', 'Cristobal Urquieta'),
(6, 2, 221, 'Correu Electrònic', 'email', 'Text', 'cristobal.urquieta@gmail.com'),
(7, 2, 235, 'Assumpte', 'subject', 'Text', 'Consulta de información'),
(8, 2, 222, 'Missatge', 'message', 'Textarea', 'Buen día, mi nombre es Cristóbal Urquieta, estudio en el máster de ciencia y gestión integral del agua en la Universidad de Barcelona. Estoy realizando un balance hídrico del acuífero de la mediana y baja Tordera. Quiero contactar a Susana Mató Pujol, quien presento un ESTUDIO HIDROGEOLÓGICO DEL ACUÍFERO ALUVIAL DE LA ALTA Y MEDIA TORDERA, en el Congreso del Agua de Cataluña (18 y 19 de marzo de 2015). Ustedes tienen su contacto. Aprovecho la ocasión para consultarles sobre si conocen bibliografía útil para el trabajo que estoy desarrollando.\r\n\r\nDesde ya agradezco su colaboración.\r\n\r\nSaludos.\r\n'),
(9, 3, 220, 'Nom', 'name', 'Text', 'Lídia Hervas'),
(10, 3, 221, 'Correu Electrònic', 'email', 'Text', 'lhervas@erf.cat'),
(11, 3, 235, 'Assumpte', 'subject', 'Text', 'Media Partner'),
(12, 3, 222, 'Missatge', 'message', 'Textarea', 'Hola, soc la Lídia Hervàs, de Sostenible, la revista de la Xarxa de Ciutats i Pobles cap a la Sostenibilitat. Em pose en contacte amb vosaltres per saber com ser un mitjà col.laborador amb el congrés. Gràcies '),
(13, 4, 220, 'Nom', 'name', 'Text', 'PILAR SORIANO VILAPLANA'),
(14, 4, 221, 'Correu Electrònic', 'email', 'Text', 'ralip.onairos@gmail.com'),
(15, 4, 235, 'Assumpte', 'subject', 'Text', 'Canvi número de compte '),
(16, 4, 222, 'Missatge', 'message', 'Textarea', 'Benvolguts amics, mitjançant aquest missatge us faig avinent que el meu número de compte associat ha canviat.\r\nSi us plau, agrairia que els càrrecs es facin al número ES49 2100 0829 0901 0340 6849. Gràcies. Salutacions cordials. Pilar Soriano Vilaplana. C/Gomis, 43, àtic 5ena. 08023 - BARCELONA.');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_filters`
--

CREATE TABLE `jos3_finder_filters` (
  `filter_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `state` tinyint(1) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int(10) UNSIGNED NOT NULL,
  `created_by_alias` varchar(255) NOT NULL,
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `checked_out` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `map_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `data` text NOT NULL,
  `params` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links`
--

CREATE TABLE `jos3_finder_links` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `url` varchar(255) NOT NULL,
  `route` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `indexdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `md5sum` varchar(32) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `state` int(5) DEFAULT '1',
  `access` int(5) DEFAULT '0',
  `language` varchar(8) NOT NULL,
  `publish_start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `list_price` double UNSIGNED NOT NULL DEFAULT '0',
  `sale_price` double UNSIGNED NOT NULL DEFAULT '0',
  `type_id` int(11) NOT NULL,
  `object` mediumblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_terms0`
--

CREATE TABLE `jos3_finder_links_terms0` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_terms1`
--

CREATE TABLE `jos3_finder_links_terms1` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_terms2`
--

CREATE TABLE `jos3_finder_links_terms2` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_terms3`
--

CREATE TABLE `jos3_finder_links_terms3` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_terms4`
--

CREATE TABLE `jos3_finder_links_terms4` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_terms5`
--

CREATE TABLE `jos3_finder_links_terms5` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_terms6`
--

CREATE TABLE `jos3_finder_links_terms6` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_terms7`
--

CREATE TABLE `jos3_finder_links_terms7` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_terms8`
--

CREATE TABLE `jos3_finder_links_terms8` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_terms9`
--

CREATE TABLE `jos3_finder_links_terms9` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_termsa`
--

CREATE TABLE `jos3_finder_links_termsa` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_termsb`
--

CREATE TABLE `jos3_finder_links_termsb` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_termsc`
--

CREATE TABLE `jos3_finder_links_termsc` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_termsd`
--

CREATE TABLE `jos3_finder_links_termsd` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_termse`
--

CREATE TABLE `jos3_finder_links_termse` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_links_termsf`
--

CREATE TABLE `jos3_finder_links_termsf` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `term_id` int(10) UNSIGNED NOT NULL,
  `weight` float UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_taxonomy`
--

CREATE TABLE `jos3_finder_taxonomy` (
  `id` int(10) UNSIGNED NOT NULL,
  `parent_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `state` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `ordering` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `jos3_finder_taxonomy`
--

INSERT INTO `jos3_finder_taxonomy` (`id`, `parent_id`, `title`, `state`, `access`, `ordering`) VALUES
(1, 0, 'ROOT', 0, 0, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_taxonomy_map`
--

CREATE TABLE `jos3_finder_taxonomy_map` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `node_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_terms`
--

CREATE TABLE `jos3_finder_terms` (
  `term_id` int(10) UNSIGNED NOT NULL,
  `term` varchar(75) NOT NULL,
  `stem` varchar(75) NOT NULL,
  `common` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `phrase` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `weight` float UNSIGNED NOT NULL DEFAULT '0',
  `soundex` varchar(75) NOT NULL,
  `links` int(10) NOT NULL DEFAULT '0',
  `language` char(3) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_terms_common`
--

CREATE TABLE `jos3_finder_terms_common` (
  `term` varchar(75) NOT NULL,
  `language` varchar(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `jos3_finder_terms_common`
--

INSERT INTO `jos3_finder_terms_common` (`term`, `language`) VALUES
('a', 'en'),
('about', 'en'),
('after', 'en'),
('ago', 'en'),
('all', 'en'),
('am', 'en'),
('an', 'en'),
('and', 'en'),
('ani', 'en'),
('any', 'en'),
('are', 'en'),
('aren\'t', 'en'),
('as', 'en'),
('at', 'en'),
('be', 'en'),
('but', 'en'),
('by', 'en'),
('for', 'en'),
('from', 'en'),
('get', 'en'),
('go', 'en'),
('how', 'en'),
('if', 'en'),
('in', 'en'),
('into', 'en'),
('is', 'en'),
('isn\'t', 'en'),
('it', 'en'),
('its', 'en'),
('me', 'en'),
('more', 'en'),
('most', 'en'),
('must', 'en'),
('my', 'en'),
('new', 'en'),
('no', 'en'),
('none', 'en'),
('not', 'en'),
('noth', 'en'),
('nothing', 'en'),
('of', 'en'),
('off', 'en'),
('often', 'en'),
('old', 'en'),
('on', 'en'),
('onc', 'en'),
('once', 'en'),
('onli', 'en'),
('only', 'en'),
('or', 'en'),
('other', 'en'),
('our', 'en'),
('ours', 'en'),
('out', 'en'),
('over', 'en'),
('page', 'en'),
('she', 'en'),
('should', 'en'),
('small', 'en'),
('so', 'en'),
('some', 'en'),
('than', 'en'),
('thank', 'en'),
('that', 'en'),
('the', 'en'),
('their', 'en'),
('theirs', 'en'),
('them', 'en'),
('then', 'en'),
('there', 'en'),
('these', 'en'),
('they', 'en'),
('this', 'en'),
('those', 'en'),
('thus', 'en'),
('time', 'en'),
('times', 'en'),
('to', 'en'),
('too', 'en'),
('true', 'en'),
('under', 'en'),
('until', 'en'),
('up', 'en'),
('upon', 'en'),
('use', 'en'),
('user', 'en'),
('users', 'en'),
('veri', 'en'),
('version', 'en'),
('very', 'en'),
('via', 'en'),
('want', 'en'),
('was', 'en'),
('way', 'en'),
('were', 'en'),
('what', 'en'),
('when', 'en'),
('where', 'en'),
('whi', 'en'),
('which', 'en'),
('who', 'en'),
('whom', 'en'),
('whose', 'en'),
('why', 'en'),
('wide', 'en'),
('will', 'en'),
('with', 'en'),
('within', 'en'),
('without', 'en'),
('would', 'en'),
('yes', 'en'),
('yet', 'en'),
('you', 'en'),
('your', 'en'),
('yours', 'en');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_tokens`
--

CREATE TABLE `jos3_finder_tokens` (
  `term` varchar(75) NOT NULL,
  `stem` varchar(75) NOT NULL,
  `common` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `phrase` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `weight` float UNSIGNED NOT NULL DEFAULT '1',
  `context` tinyint(1) UNSIGNED NOT NULL DEFAULT '2',
  `language` char(3) NOT NULL DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_tokens_aggregate`
--

CREATE TABLE `jos3_finder_tokens_aggregate` (
  `term_id` int(10) UNSIGNED NOT NULL,
  `map_suffix` char(1) NOT NULL,
  `term` varchar(75) NOT NULL,
  `stem` varchar(75) NOT NULL,
  `common` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `phrase` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `term_weight` float UNSIGNED NOT NULL,
  `context` tinyint(1) UNSIGNED NOT NULL DEFAULT '2',
  `context_weight` float UNSIGNED NOT NULL,
  `total_weight` float UNSIGNED NOT NULL,
  `language` char(3) NOT NULL DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_finder_types`
--

CREATE TABLE `jos3_finder_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(100) NOT NULL,
  `mime` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_languages`
--

CREATE TABLE `jos3_languages` (
  `lang_id` int(11) UNSIGNED NOT NULL,
  `lang_code` char(7) NOT NULL,
  `title` varchar(50) NOT NULL,
  `title_native` varchar(50) NOT NULL,
  `sef` varchar(50) NOT NULL,
  `image` varchar(50) NOT NULL,
  `description` varchar(512) NOT NULL,
  `metakey` text NOT NULL,
  `metadesc` text NOT NULL,
  `sitename` varchar(1024) NOT NULL DEFAULT '',
  `published` int(11) NOT NULL DEFAULT '0',
  `access` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `jos3_languages`
--

INSERT INTO `jos3_languages` (`lang_id`, `lang_code`, `title`, `title_native`, `sef`, `image`, `description`, `metakey`, `metadesc`, `sitename`, `published`, `access`, `ordering`) VALUES
(1, 'en-GB', 'English (UK)', 'English (UK)', 'en', 'en', '', '', '', '', 0, 1, 1),
(2, 'es-ES', 'Español (ES)', 'Español (ES)', 'es', 'es_es', '', '', '', '', 0, 1, 0),
(3, 'ca-ES', 'Català (CA)', 'Català (CA)', 'ca', 'ca_es', '', '', '', '', 1, 1, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_menu`
--

CREATE TABLE `jos3_menu` (
  `id` int(11) NOT NULL,
  `menutype` varchar(24) NOT NULL COMMENT 'The type of menu this item belongs to. FK to #__menu_types.menutype',
  `title` varchar(255) NOT NULL COMMENT 'The display title of the menu item.',
  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The SEF alias of the menu item.',
  `note` varchar(255) NOT NULL DEFAULT '',
  `path` varchar(1024) NOT NULL COMMENT 'The computed path of the menu item based on the alias field.',
  `link` varchar(1024) NOT NULL COMMENT 'The actually link the menu item refers to.',
  `type` varchar(16) NOT NULL COMMENT 'The type of link: Component, URL, Alias, Separator',
  `published` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The published state of the menu link.',
  `parent_id` int(10) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'The parent menu item in the menu tree.',
  `level` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The relative level in the tree.',
  `component_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'FK to #__extensions.id',
  `checked_out` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'FK to #__users.id',
  `checked_out_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'The time the menu item was checked out.',
  `browserNav` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The click behaviour of the link.',
  `access` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The access level required to view the menu item.',
  `img` varchar(255) NOT NULL COMMENT 'The image of the menu item.',
  `template_style_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `params` text NOT NULL COMMENT 'JSON encoded data for the menu item.',
  `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
  `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
  `home` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Indicates if this menu item is the home or default page.',
  `language` char(7) NOT NULL DEFAULT '',
  `client_id` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `jos3_menu`
--

INSERT INTO `jos3_menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `checked_out`, `checked_out_time`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`) VALUES
(1, '', 'Menu_Item_Root', 'root', '', '', '', '', 1, 0, 0, 0, 0, '0000-00-00 00:00:00', 0, 0, '', 0, '', 0, 101, 0, '*', 0),
(2, 'menu', 'com_banners', 'Banners', '', 'Banners', 'index.php?option=com_banners', 'component', 0, 1, 1, 4, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners', 0, '', 1, 10, 0, '*', 1),
(3, 'menu', 'com_banners', 'Banners', '', 'Banners/Banners', 'index.php?option=com_banners', 'component', 0, 2, 2, 4, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners', 0, '', 2, 3, 0, '*', 1),
(4, 'menu', 'com_banners_categories', 'Categories', '', 'Banners/Categories', 'index.php?option=com_categories&extension=com_banners', 'component', 0, 2, 2, 6, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-cat', 0, '', 4, 5, 0, '*', 1),
(5, 'menu', 'com_banners_clients', 'Clients', '', 'Banners/Clients', 'index.php?option=com_banners&view=clients', 'component', 0, 2, 2, 4, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-clients', 0, '', 6, 7, 0, '*', 1),
(6, 'menu', 'com_banners_tracks', 'Tracks', '', 'Banners/Tracks', 'index.php?option=com_banners&view=tracks', 'component', 0, 2, 2, 4, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-tracks', 0, '', 8, 9, 0, '*', 1),
(7, 'menu', 'com_contact', 'Contacts', '', 'Contacts', 'index.php?option=com_contact', 'component', 0, 1, 1, 8, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact', 0, '', 33, 38, 0, '*', 1),
(8, 'menu', 'com_contact', 'Contacts', '', 'Contacts/Contacts', 'index.php?option=com_contact', 'component', 0, 7, 2, 8, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact', 0, '', 34, 35, 0, '*', 1),
(9, 'menu', 'com_contact_categories', 'Categories', '', 'Contacts/Categories', 'index.php?option=com_categories&extension=com_contact', 'component', 0, 7, 2, 6, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact-cat', 0, '', 36, 37, 0, '*', 1),
(10, 'menu', 'com_messages', 'Messaging', '', 'Messaging', 'index.php?option=com_messages', 'component', 0, 1, 1, 15, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages', 0, '', 39, 44, 0, '*', 1),
(11, 'menu', 'com_messages_add', 'New Private Message', '', 'Messaging/New Private Message', 'index.php?option=com_messages&task=message.add', 'component', 0, 10, 2, 15, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages-add', 0, '', 40, 41, 0, '*', 1),
(12, 'menu', 'com_messages_read', 'Read Private Message', '', 'Messaging/Read Private Message', 'index.php?option=com_messages', 'component', 0, 10, 2, 15, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages-read', 0, '', 42, 43, 0, '*', 1),
(13, 'menu', 'com_newsfeeds', 'News Feeds', '', 'News Feeds', 'index.php?option=com_newsfeeds', 'component', 0, 1, 1, 17, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds', 0, '', 45, 50, 0, '*', 1),
(14, 'menu', 'com_newsfeeds_feeds', 'Feeds', '', 'News Feeds/Feeds', 'index.php?option=com_newsfeeds', 'component', 0, 13, 2, 17, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds', 0, '', 46, 47, 0, '*', 1),
(15, 'menu', 'com_newsfeeds_categories', 'Categories', '', 'News Feeds/Categories', 'index.php?option=com_categories&extension=com_newsfeeds', 'component', 0, 13, 2, 6, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds-cat', 0, '', 48, 49, 0, '*', 1),
(16, 'menu', 'com_redirect', 'Redirect', '', 'Redirect', 'index.php?option=com_redirect', 'component', 0, 1, 1, 24, 0, '0000-00-00 00:00:00', 0, 0, 'class:redirect', 0, '', 51, 52, 0, '*', 1),
(17, 'menu', 'com_search', 'Basic Search', '', 'Basic Search', 'index.php?option=com_search', 'component', 0, 1, 1, 19, 0, '0000-00-00 00:00:00', 0, 0, 'class:search', 0, '', 53, 54, 0, '*', 1),
(18, 'menu', 'com_finder', 'Smart Search', '', 'Smart Search', 'index.php?option=com_finder', 'component', 0, 1, 1, 27, 0, '0000-00-00 00:00:00', 0, 0, 'class:finder', 0, '', 55, 56, 0, '*', 1),
(19, 'menu', 'com_joomlaupdate', 'Joomla! Update', '', 'Joomla! Update', 'index.php?option=com_joomlaupdate', 'component', 1, 1, 1, 28, 0, '0000-00-00 00:00:00', 0, 0, 'class:joomlaupdate', 0, '', 57, 58, 0, '*', 1),
(20, 'main', 'com_tags', 'Tags', '', 'Tags', 'index.php?option=com_tags', 'component', 0, 1, 1, 29, 0, '0000-00-00 00:00:00', 0, 1, 'class:tags', 0, '', 59, 60, 0, '', 1),
(21, 'main', 'com_postinstall', 'Post-installation messages', '', 'Post-installation messages', 'index.php?option=com_postinstall', 'component', 0, 1, 1, 32, 0, '0000-00-00 00:00:00', 0, 1, 'class:postinstall', 0, '', 61, 62, 0, '*', 1),
(101, 'mainmenu', 'Inici', 'inici', '', 'inici', 'index.php?option=com_content&view=featured', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 9, '{\"featured_categories\":[\"\"],\"layout_type\":\"blog\",\"num_leading_articles\":\"\",\"num_intro_articles\":\"\",\"num_columns\":\"\",\"num_links\":\"\",\"multi_column_order\":\"\",\"orderby_pri\":\"\",\"orderby_sec\":\"\",\"order_date\":\"\",\"show_pagination\":\"\",\"show_pagination_results\":\"\",\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_readmore\":\"\",\"show_readmore_title\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"show_feed_link\":\"\",\"feed_summary\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"1\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 11, 12, 1, '*', 0),
(102, 'main', 'JCE', 'jce', '', 'jce', 'index.php?option=com_jce', 'component', 0, 1, 1, 10006, 0, '0000-00-00 00:00:00', 0, 1, 'components/com_jce/media/img/menu/logo.png', 0, '{}', 63, 72, 0, '', 1),
(103, 'main', 'WF_MENU_CPANEL', 'wf-menu-cpanel', '', 'jce/wf-menu-cpanel', 'index.php?option=com_jce', 'component', 0, 102, 2, 10006, 0, '0000-00-00 00:00:00', 0, 1, 'components/com_jce/media/img/menu/jce-cpanel.png', 0, '{}', 64, 65, 0, '', 1),
(104, 'main', 'WF_MENU_CONFIG', 'wf-menu-config', '', 'jce/wf-menu-config', 'index.php?option=com_jce&view=config', 'component', 0, 102, 2, 10006, 0, '0000-00-00 00:00:00', 0, 1, 'components/com_jce/media/img/menu/jce-config.png', 0, '{}', 66, 67, 0, '', 1),
(105, 'main', 'WF_MENU_PROFILES', 'wf-menu-profiles', '', 'jce/wf-menu-profiles', 'index.php?option=com_jce&view=profiles', 'component', 0, 102, 2, 10006, 0, '0000-00-00 00:00:00', 0, 1, 'components/com_jce/media/img/menu/jce-profiles.png', 0, '{}', 68, 69, 0, '', 1),
(106, 'main', 'WF_MENU_INSTALL', 'wf-menu-install', '', 'jce/wf-menu-install', 'index.php?option=com_jce&view=installer', 'component', 0, 102, 2, 10006, 0, '0000-00-00 00:00:00', 0, 1, 'components/com_jce/media/img/menu/jce-install.png', 0, '{}', 70, 71, 0, '', 1),
(107, 'main', 'COM_WIDGETKIT', 'com-widgetkit', '', 'com-widgetkit', 'index.php?option=com_widgetkit', 'component', 0, 1, 1, 10011, 0, '0000-00-00 00:00:00', 0, 1, 'components/com_widgetkit/images/widgetkit_16.png', 0, '{}', 73, 74, 0, '', 1),
(108, 'mainmenu', 'Qui som ?', 'qui-som', '', 'qui-som', 'index.php?option=com_content&view=article&id=1', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 13, 14, 0, 'ca-ES', 0),
(109, 'mainmenu', 'Principis', 'principis', '', 'principis', 'index.php?option=com_content&view=article&id=2', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 15, 16, 0, 'ca-ES', 0),
(110, 'mainmenu', 'Premis de l\'Aigua', 'premis-aigua', '', 'premis-aigua', 'index.php?option=com_content&view=article&id=3', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 17, 18, 0, 'ca-ES', 0),
(111, 'mainmenu', 'Què diem ?', 'que-diem', '', 'que-diem', 'index.php?option=com_content&view=article&id=4', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 19, 20, 0, 'ca-ES', 0),
(112, 'mainmenu', 'Aigua Amiga', 'aigua-amiga', '', 'aigua-amiga', 'index.php?option=com_content&view=article&id=5', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 21, 22, 0, 'ca-ES', 0),
(113, 'mainmenu', 'Publicacions', 'publicacions', '', 'publicacions', 'index.php?option=com_content&view=article&id=6', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 23, 24, 0, 'ca-ES', 0),
(117, 'mainmenu', 'Galeria', 'galeria', '', 'galeria', 'index.php?option=com_content&view=article&id=13', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 25, 32, 0, 'ca-ES', 0),
(118, 'mainmenu', 'Premis de l\'Aigua 2016', 'galeria-premis-aigua-2016', '', 'galeria/galeria-premis-aigua-2016', 'index.php?option=com_content&view=article&id=10', 'component', 1, 117, 2, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 30, 31, 0, 'ca-ES', 0),
(119, 'topmenu', 'Fes-te Soci', 'fes-te-soci', '', 'fes-te-soci', 'index.php?option=com_content&view=article&id=9', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 75, 76, 0, 'ca-ES', 0),
(120, 'topmenu', 'Agenda', 'agenda', '', 'agenda', 'index.php?option=com_content&view=article&id=7', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 77, 78, 0, 'ca-ES', 0),
(121, 'topmenu', 'Contacte', 'contacte', '', 'contacte', 'index.php?option=com_content&view=article&id=8', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 79, 80, 0, 'ca-ES', 0),
(122, 'mainmenu', 'Visita a l\'embassament de la Baells 18-05-2016', 'visita-a-l-embassament-de-la-baells-18-05-2016', '', 'galeria/visita-a-l-embassament-de-la-baells-18-05-2016', 'index.php?option=com_content&view=article&id=11', 'component', 1, 117, 2, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 28, 29, 0, 'ca-ES', 0),
(123, 'main', 'BreezingForms', 'BreezingForms', '', 'BreezingForms', 'index.php?option=com_breezingforms', 'component', 0, 1, 1, 10018, 0, '0000-00-00 00:00:00', 0, 1, 'class:component', 0, '{}', 81, 96, 0, '', 1),
(124, 'main', 'COM_BREEZINGFORMS_MANAGE_RECORDS', 'Manage Records', '', 'BreezingForms/Manage Records', 'index.php?option=com_breezingforms&act=managerecs', 'component', 0, 123, 2, 10018, 0, '0000-00-00 00:00:00', 0, 1, 'components/com_breezingforms/images/js/ThemeOffice/checkin.png', 0, '{}', 82, 83, 0, '', 1),
(125, 'main', 'COM_BREEZINGFORMS_MANAGE_FORMS', 'Manage Forms', '', 'BreezingForms/Manage Forms', 'index.php?option=com_breezingforms&act=manageforms', 'component', 0, 123, 2, 10018, 0, '0000-00-00 00:00:00', 0, 1, 'components/com_breezingforms/images/js/ThemeOffice/content.png', 0, '{}', 84, 85, 0, '', 1),
(126, 'main', 'COM_BREEZINGFORMS_MANAGE_SCRIPTS', 'Manage Scripts', '', 'BreezingForms/Manage Scripts', 'index.php?option=com_breezingforms&act=managescripts', 'component', 0, 123, 2, 10018, 0, '0000-00-00 00:00:00', 0, 1, 'components/com_breezingforms/images/js/ThemeOffice/controlpanel.png', 0, '{}', 86, 87, 0, '', 1),
(127, 'main', 'COM_BREEZINGFORMS_MANAGE_PIECES', 'Manage Pieces', '', 'BreezingForms/Manage Pieces', 'index.php?option=com_breezingforms&act=managepieces', 'component', 0, 123, 2, 10018, 0, '0000-00-00 00:00:00', 0, 1, 'components/com_breezingforms/images/js/ThemeOffice/controlpanel.png', 0, '{}', 88, 89, 0, '', 1),
(128, 'main', 'COM_BREEZINGFORMS_INTEGRATOR', 'Integrator', '', 'BreezingForms/Integrator', 'index.php?option=com_breezingforms&act=integrate', 'component', 0, 123, 2, 10018, 0, '0000-00-00 00:00:00', 0, 1, 'components/com_breezingforms/images/js/ThemeOffice/controlpanel.png', 0, '{}', 90, 91, 0, '', 1),
(129, 'main', 'COM_BREEZINGFORMS_MANAGE_BACKEND_MENUS', 'Manage Backend Menus', '', 'BreezingForms/Manage Backend Menus', 'index.php?option=com_breezingforms&act=managemenus', 'component', 0, 123, 2, 10018, 0, '0000-00-00 00:00:00', 0, 1, 'components/com_breezingforms/images/js/ThemeOffice/mainmenu.png', 0, '{}', 92, 93, 0, '', 1),
(130, 'main', 'COM_BREEZINGFORMS_CONFIGURATION', 'Configuration', '', 'BreezingForms/Configuration', 'index.php?option=com_breezingforms&act=configuration', 'component', 0, 123, 2, 10018, 0, '0000-00-00 00:00:00', 0, 1, 'components/com_breezingforms/images/js/ThemeOffice/config.png', 0, '{}', 94, 95, 0, '', 1),
(131, 'main', 'COM_OSMAP_TITLE', 'com-osmap-title', '', 'com-osmap-title', 'index.php?option=com_osmap', 'component', 0, 1, 1, 10021, 0, '0000-00-00 00:00:00', 0, 1, 'class:component', 0, '{}', 97, 98, 0, '', 1),
(132, 'topmenu', 'Mapa del lloc', 'mapa-del-lloc', '', 'mapa-del-lloc', 'index.php?option=com_osmap&view=html&id=1', 'component', 1, 1, 1, 10021, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"debug\":\"0\",\"use_css\":\"1\",\"show_menu_titles\":\"1\",\"show_sitemap_description\":\"0\",\"sitemap_description\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 99, 100, 0, '*', 0),
(133, 'mainmenu', 'Premis de l\'Aigua 2017', 'galeria-premis-aigua-2017', '', 'galeria/galeria-premis-aigua-2017', 'index.php?option=com_content&view=article&id=14', 'component', 1, 117, 2, 22, 0, '0000-00-00 00:00:00', 0, 1, ' ', 0, '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_vote\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_image\":\"\",\"menu_text\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"menu-meta_keywords\":\"\",\"robots\":\"\",\"secure\":0}', 26, 27, 0, 'ca-ES', 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jos3_menu_types`
--

