File: /home/centralexf/www/administrator/components/com_rsform/sample.rsform.sql
INSERT IGNORE INTO `#__rsform_components`
(`ComponentId`, `FormId`, `ComponentTypeId`, `Order`, `Published`)
VALUES
(1, 1, 1, 2, 1),
(2, 1, 10, 1, 1),
(3, 1, 1, 3, 1),
(4, 1, 3, 4, 1),
(5, 1, 5, 5, 1),
(6, 1, 4, 6, 1),
(7, 1, 6, 7, 1),
(8, 1, 13, 8, 1),
(9, 1, 10, 9, 1);
INSERT IGNORE INTO `#__rsform_forms` SET
`FormId`=1,
`FormName`='RSformPro example',
`FormLayout`='<fieldset class="formFieldset">\n<legend>{global:formtitle}</legend>\n{error}\n<!-- Do not remove this ID, it is used to identify the page so that the pagination script can work correctly -->\n<ol class="formContainer" id="rsform_1_page_0">\n <li class="rsform-block rsform-block-header">\n <div class="formCaption">{Header:caption}</div>\n <div class="formBody">{Header:body}<span class="formClr">{Header:validation}</span></div>\n <div class="formDescription">{Header:description}</div>\n </li>\n <li class="rsform-block rsform-block-fullname">\n <div class="formCaption">{FullName:caption}<strong class="formRequired">(*)</strong></div>\n <div class="formBody">{FullName:body}<span class="formClr">{FullName:validation}</span></div>\n <div class="formDescription">{FullName:description}</div>\n </li>\n <li class="rsform-block rsform-block-email">\n <div class="formCaption">{Email:caption}<strong class="formRequired">(*)</strong></div>\n <div class="formBody">{Email:body}<span class="formClr">{Email:validation}</span></div>\n <div class="formDescription">{Email:description}</div>\n </li>\n <li class="rsform-block rsform-block-companysize">\n <div class="formCaption">{CompanySize:caption}<strong class="formRequired">(*)</strong></div>\n <div class="formBody">{CompanySize:body}<span class="formClr">{CompanySize:validation}</span></div>\n <div class="formDescription">{CompanySize:description}</div>\n </li>\n <li class="rsform-block rsform-block-position">\n <div class="formCaption">{Position:caption}<strong class="formRequired">(*)</strong></div>\n <div class="formBody">{Position:body}<span class="formClr">{Position:validation}</span></div>\n <div class="formDescription">{Position:description}</div>\n </li>\n <li class="rsform-block rsform-block-contactby">\n <div class="formCaption">{ContactBy:caption}</div>\n <div class="formBody">{ContactBy:body}<span class="formClr">{ContactBy:validation}</span></div>\n <div class="formDescription">{ContactBy:description}</div>\n </li>\n <li class="rsform-block rsform-block-contactwhen">\n <div class="formCaption">{ContactWhen:caption}<strong class="formRequired">(*)</strong></div>\n <div class="formBody">{ContactWhen:body}<span class="formClr">{ContactWhen:validation}</span></div>\n <div class="formDescription">{ContactWhen:description}</div>\n </li>\n <li class="rsform-block rsform-block-submit">\n <div class="formCaption">{Submit:caption}</div>\n <div class="formBody">{Submit:body}<span class="formClr">{Submit:validation}</span></div>\n <div class="formDescription">{Submit:description}</div>\n </li>\n <li class="rsform-block rsform-block-footer">\n <div class="formCaption">{Footer:caption}</div>\n <div class="formBody">{Footer:body}<span class="formClr">{Footer:validation}</span></div>\n <div class="formDescription">{Footer:description}</div>\n </li>\n</ol>\n</fieldset>',
`FormLayoutName`='inline-xhtml',
`FormLayoutAutogenerate`=1,
`FormTitle`='RSForm! Pro example',
`Published`=1,
`Lang`='',
`ReturnUrl`='',
`Thankyou`='<p>Dear {FullName:value},</p><p> thank you for your submission. One of our staff members will contact you by {ContactBy:value} as soon as possible.</p>',
`UserEmailText`='<p>Dear {FullName:value},</p><p> we received your contact request. Someone will get back to you by {ContactBy:value} soon. </p>',
`UserEmailTo`='{Email:value}',
`UserEmailFrom`='your@email.com',
`UserEmailFromName`='Your Company',
`UserEmailSubject`='Contact confirmation',
`UserEmailMode`=1,
`AdminEmailText`='<p>Customize this e-mail also. You will receive it as administrator. </p><p>{FullName:caption}:{FullName:value}<br />\n{Email:caption}:{Email:value}<br />\n{CompanySize:caption}:{CompanySize:value}<br />\n{Position:caption}:{Position:value}<br />\n{ContactBy:caption}:{ContactBy:value}<br />\n{ContactWhen:caption}:{ContactWhen:value}</p>',
`AdminEmailTo`='youradminemail@email.com',
`AdminEmailFrom`='{Email:value}',
`AdminEmailFromName`='Your Company',
`AdminEmailSubject`='Contact',
`AdminEmailMode`=1,
`Keepdata`=1,
`MultipleSeparator`=', ';
INSERT IGNORE INTO `#__rsform_properties` (`PropertyId`, `ComponentId`, `PropertyName`, `PropertyValue`)
VALUES
(1, 1, 'NAME', 'FullName'),
(2, 1, 'CAPTION', 'Full Name'),
(3, 1, 'REQUIRED', 'YES'),
(4, 1, 'SIZE', '20'),
(5, 1, 'MAXSIZE', ''),
(6, 1, 'VALIDATIONRULE', 'none'),
(7, 1, 'VALIDATIONMESSAGE', 'Please type your full name.'),
(8, 1, 'ADDITIONALATTRIBUTES', ''),
(9, 1, 'DEFAULTVALUE', ''),
(10, 1, 'DESCRIPTION', ''),
(11, 2, 'NAME', 'Header'),
(12, 2, 'TEXT', '<b>This text describes the form. It is added using the Free Text component</b>. HTML code can be added directly here.'),
(13, 3, 'NAME', 'Email'),
(14, 3, 'CAPTION', 'E-mail'),
(15, 3, 'REQUIRED', 'YES'),
(16, 3, 'SIZE', '20'),
(17, 3, 'MAXSIZE', ''),
(18, 3, 'VALIDATIONRULE', 'email'),
(19, 3, 'VALIDATIONMESSAGE', 'Invalid email address.'),
(20, 3, 'ADDITIONALATTRIBUTES', ''),
(21, 3, 'DEFAULTVALUE', ''),
(22, 3, 'DESCRIPTION', ''),
(23, 4, 'NAME', 'CompanySize'),
(24, 4, 'CAPTION', 'Number of Employees'),
(25, 4, 'SIZE', ''),
(26, 4, 'MULTIPLE', 'NO'),
(27, 4, 'ITEMS', '|Please Select[c]\n1-20\n21-50\n51-100\n>100|More than 100'),
(28, 4, 'REQUIRED', 'YES'),
(29, 4, 'ADDITIONALATTRIBUTES', ''),
(30, 4, 'DESCRIPTION', ''),
(31, 4, 'VALIDATIONMESSAGE', 'Please tell us how big is your company.'),
(32, 5, 'NAME', 'Position'),
(33, 5, 'CAPTION', 'Position'),
(34, 5, 'ITEMS', 'CEO\nCFO\nCTO\nHR[c]'),
(35, 5, 'FLOW', 'HORIZONTAL'),
(36, 5, 'REQUIRED', 'YES'),
(37, 5, 'ADDITIONALATTRIBUTES', ''),
(38, 5, 'DESCRIPTION', ''),
(39, 5, 'VALIDATIONMESSAGE', 'Please specify your position in the company'),
(40, 6, 'NAME', 'ContactBy'),
(41, 6, 'CAPTION', 'How should we contact you?'),
(42, 6, 'ITEMS', 'E-mail[c]\nPhone\nNewsletter[c]\nMail'),
(43, 6, 'FLOW', 'HORIZONTAL'),
(44, 6, 'REQUIRED', 'NO'),
(45, 6, 'ADDITIONALATTRIBUTES', ''),
(46, 6, 'DESCRIPTION', ''),
(47, 6, 'VALIDATIONMESSAGE', ''),
(48, 7, 'NAME', 'ContactWhen'),
(49, 7, 'CAPTION', 'When would you like to be contacted?'),
(50, 7, 'REQUIRED', 'YES'),
(51, 7, 'DATEFORMAT', 'dd.mm.yyyy'),
(52, 7, 'CALENDARLAYOUT', 'POPUP'),
(53, 7, 'ADDITIONALATTRIBUTES', ''),
(54, 7, 'READONLY', 'YES'),
(55, 7, 'POPUPLABEL', '...'),
(56, 7, 'DESCRIPTION', ''),
(57, 7, 'VALIDATIONMESSAGE', 'Please select a date when we should contact you.'),
(58, 8, 'NAME', 'Submit'),
(59, 8, 'LABEL', 'Submit'),
(60, 8, 'CAPTION', ''),
(61, 8, 'RESET', 'YES'),
(62, 8, 'RESETLABEL', 'Reset'),
(63, 8, 'ADDITIONALATTRIBUTES', ''),
(64, 9, 'NAME', 'Footer'),
(65, 9, 'TEXT', 'This form is an example. Please check our knowledgebase for articles related to how you should build your form. Articles are updated daily. <a href="http://www.rsjoomla.com/" target="_blank">http://www.rsjoomla.com/</a>');
INSERT INTO `#__rsform_components` (`ComponentId`, `FormId`, `ComponentTypeId`, `Order`, `Published`) VALUES
(10, 2, 1, 2, 1),
(11, 2, 10, 1, 1),
(12, 2, 1, 3, 1),
(13, 2, 3, 6, 1),
(14, 2, 5, 7, 1),
(15, 2, 4, 10, 1),
(16, 2, 6, 11, 1),
(17, 2, 13, 12, 1),
(18, 2, 10, 13, 1),
(19, 2, 41, 4, 1),
(20, 2, 41, 8, 1),
(21, 2, 10, 5, 1),
(22, 2, 10, 9, 1);
INSERT IGNORE INTO `#__rsform_forms` (`FormId`, `FormName`, `FormLayout`, `FormLayoutName`, `FormLayoutAutogenerate`, `CSS`, `JS`, `FormTitle`, `Published`, `Lang`, `ReturnUrl`, `ShowThankyou`, `Thankyou`, `UserEmailText`, `UserEmailTo`, `UserEmailCC`, `UserEmailBCC`, `UserEmailFrom`, `UserEmailReplyTo`, `UserEmailFromName`, `UserEmailSubject`, `UserEmailMode`, `UserEmailAttach`, `UserEmailAttachFile`, `AdminEmailText`, `AdminEmailTo`, `AdminEmailCC`, `AdminEmailBCC`, `AdminEmailFrom`, `AdminEmailReplyTo`, `AdminEmailFromName`, `AdminEmailSubject`, `AdminEmailMode`, `ScriptProcess`, `ScriptProcess2`, `ScriptDisplay`, `UserEmailScript`, `AdminEmailScript`, `MetaTitle`, `MetaDesc`, `MetaKeywords`, `Required`, `ErrorMessage`, `MultipleSeparator`, `TextareaNewLines`,`Keepdata`) VALUES
(2, 'RSformPro Multipage example', '<fieldset class="formFieldset">\n<legend>{global:formtitle}</legend>\n{error}\n<!-- Do not remove this ID, it is used to identify the page so that the pagination script can work correctly -->\n<ol class="formContainer" id="rsform_2_page_0">\n <li class="rsform-block rsform-block-header">\n <div class="formCaption">{Header:caption}</div>\n <div class="formBody">{Header:body}<span class="formClr">{Header:validation}</span></div>\n <div class="formDescription">{Header:description}</div>\n </li>\n <li class="rsform-block rsform-block-fullname">\n <div class="formCaption">{FullName:caption}<strong class="formRequired">(*)</strong></div>\n <div class="formBody">{FullName:body}<span class="formClr">{FullName:validation}</span></div>\n <div class="formDescription">{FullName:description}</div>\n </li>\n <li class="rsform-block rsform-block-email">\n <div class="formCaption">{Email:caption}<strong class="formRequired">(*)</strong></div>\n <div class="formBody">{Email:body}<span class="formClr">{Email:validation}</span></div>\n <div class="formDescription">{Email:description}</div>\n </li>\n <li class="rsform-block rsform-block-page1">\n <div class="formCaption"> </div>\n <div class="formBody">{Page1:body}</div>\n </li>\n </ol>\n<!-- Do not remove this ID, it is used to identify the page so that the pagination script can work correctly -->\n<ol class="formContainer" id="rsform_2_page_1">\n <li class="rsform-block rsform-block-companyheader">\n <div class="formCaption">{CompanyHeader:caption}</div>\n <div class="formBody">{CompanyHeader:body}<span class="formClr">{CompanyHeader:validation}</span></div>\n <div class="formDescription">{CompanyHeader:description}</div>\n </li>\n <li class="rsform-block rsform-block-companysize">\n <div class="formCaption">{CompanySize:caption}<strong class="formRequired">(*)</strong></div>\n <div class="formBody">{CompanySize:body}<span class="formClr">{CompanySize:validation}</span></div>\n <div class="formDescription">{CompanySize:description}</div>\n </li>\n <li class="rsform-block rsform-block-position">\n <div class="formCaption">{Position:caption}<strong class="formRequired">(*)</strong></div>\n <div class="formBody">{Position:body}<span class="formClr">{Position:validation}</span></div>\n <div class="formDescription">{Position:description}</div>\n </li>\n <li class="rsform-block rsform-block-page2">\n <div class="formCaption"> </div>\n <div class="formBody">{Page2:body}</div>\n </li>\n </ol>\n<!-- Do not remove this ID, it is used to identify the page so that the pagination script can work correctly -->\n<ol class="formContainer" id="rsform_2_page_2">\n <li class="rsform-block rsform-block-contactheader">\n <div class="formCaption">{ContactHeader:caption}</div>\n <div class="formBody">{ContactHeader:body}<span class="formClr">{ContactHeader:validation}</span></div>\n <div class="formDescription">{ContactHeader:description}</div>\n </li>\n <li class="rsform-block rsform-block-contactby">\n <div class="formCaption">{ContactBy:caption}</div>\n <div class="formBody">{ContactBy:body}<span class="formClr">{ContactBy:validation}</span></div>\n <div class="formDescription">{ContactBy:description}</div>\n </li>\n <li class="rsform-block rsform-block-contactwhen">\n <div class="formCaption">{ContactWhen:caption}<strong class="formRequired">(*)</strong></div>\n <div class="formBody">{ContactWhen:body}<span class="formClr">{ContactWhen:validation}</span></div>\n <div class="formDescription">{ContactWhen:description}</div>\n </li>\n <li class="rsform-block rsform-block-submit">\n <div class="formCaption">{Submit:caption}</div>\n <div class="formBody">{Submit:body}<span class="formClr">{Submit:validation}</span></div>\n <div class="formDescription">{Submit:description}</div>\n </li>\n <li class="rsform-block rsform-block-footer">\n <div class="formCaption">{Footer:caption}</div>\n <div class="formBody">{Footer:body}<span class="formClr">{Footer:validation}</span></div>\n <div class="formDescription">{Footer:description}</div>\n </li>\n</ol>\n</fieldset>', 'inline-xhtml', 1, '', '', 'RSForm! Pro Multipage example', 1, '', '', 0, '<p>Dear {FullName:value},</p><p> thank you for your submission. One of our staff members will contact you by {ContactBy:value} as soon as possible.</p>', '<p>Dear {FullName:value},</p><p> we received your contact request. Someone will get back to you by {ContactBy:value} soon. </p>', '{Email:value}', '', '', 'your@email.com', '', 'Your Company', 'Contact confirmation', 1, 0, '', '<p>Customize this e-mail also. You will receive it as administrator. </p><p>{FullName:caption}:{FullName:value}<br />\n{Email:caption}:{Email:value}<br />\n{CompanySize:caption}:{CompanySize:value}<br />\n{Position:caption}:{Position:value}<br />\n{ContactBy:caption}:{ContactBy:value}<br />\n{ContactWhen:caption}:{ContactWhen:value}</p>', 'youradminemail@email.com', '', '', '{Email:value}', '', 'Your Company', 'Contact', 1, '', '', '', '', '', 0, 'This is the meta description of your form. You can use it for SEO purposes.', 'rsform, contact, form, joomla', '(*)', '<p class="formRed">Please complete all required fields!</p>', ', ', 1,1);
INSERT IGNORE INTO `#__rsform_properties` (`PropertyId`, `ComponentId`, `PropertyName`, `PropertyValue`) VALUES
(68, 10, 'NAME', 'FullName'),
(69, 10, 'CAPTION', 'Full Name'),
(70, 10, 'REQUIRED', 'YES'),
(71, 10, 'SIZE', '20'),
(72, 10, 'MAXSIZE', ''),
(73, 10, 'VALIDATIONRULE', 'none'),
(74, 10, 'VALIDATIONMESSAGE', 'Please type your full name.'),
(75, 10, 'ADDITIONALATTRIBUTES', ''),
(76, 10, 'DEFAULTVALUE', ''),
(77, 10, 'DESCRIPTION', ''),
(78, 10, 'VALIDATIONEXTRA', ''),
(79, 11, 'NAME', 'Header'),
(80, 11, 'TEXT', '<b>This text describes the form. It is added using the Free Text component</b>. HTML code can be added directly here.'),
(81, 12, 'NAME', 'Email'),
(82, 12, 'CAPTION', 'E-mail'),
(83, 12, 'REQUIRED', 'YES'),
(84, 12, 'SIZE', '20'),
(85, 12, 'MAXSIZE', ''),
(86, 12, 'VALIDATIONRULE', 'email'),
(87, 12, 'VALIDATIONMESSAGE', 'Invalid email address.'),
(88, 12, 'ADDITIONALATTRIBUTES', ''),
(89, 12, 'DEFAULTVALUE', ''),
(90, 12, 'DESCRIPTION', ''),
(91, 12, 'VALIDATIONEXTRA', ''),
(92, 13, 'NAME', 'CompanySize'),
(93, 13, 'CAPTION', 'Number of Employees'),
(94, 13, 'SIZE', ''),
(95, 13, 'MULTIPLE', 'NO'),
(96, 13, 'ITEMS', '|Please Select[c]\n1-20\n21-50\n51-100\n>100|More than 100'),
(97, 13, 'REQUIRED', 'YES'),
(98, 13, 'ADDITIONALATTRIBUTES', ''),
(99, 13, 'DESCRIPTION', ''),
(100, 13, 'VALIDATIONMESSAGE', 'Please tell us how big is your company.'),
(101, 14, 'NAME', 'Position'),
(102, 14, 'CAPTION', 'Position'),
(103, 14, 'ITEMS', 'CEO\nCFO\nCTO\nHR[c]'),
(104, 14, 'FLOW', 'HORIZONTAL'),
(105, 14, 'REQUIRED', 'YES'),
(106, 14, 'ADDITIONALATTRIBUTES', ''),
(107, 14, 'DESCRIPTION', ''),
(108, 14, 'VALIDATIONMESSAGE', 'Please specify your position in the company'),
(109, 15, 'NAME', 'ContactBy'),
(110, 15, 'CAPTION', 'How should we contact you?'),
(111, 15, 'ITEMS', 'E-mail[c]\nPhone\nNewsletter[c]\nMail'),
(112, 15, 'FLOW', 'HORIZONTAL'),
(113, 15, 'REQUIRED', 'NO'),
(114, 15, 'ADDITIONALATTRIBUTES', ''),
(115, 15, 'DESCRIPTION', ''),
(116, 15, 'VALIDATIONMESSAGE', ''),
(117, 16, 'NAME', 'ContactWhen'),
(118, 16, 'CAPTION', 'When would you like to be contacted?'),
(119, 16, 'REQUIRED', 'YES'),
(120, 16, 'DATEFORMAT', 'dd.mm.yyyy'),
(121, 16, 'CALENDARLAYOUT', 'POPUP'),
(122, 16, 'ADDITIONALATTRIBUTES', ''),
(123, 16, 'READONLY', 'YES'),
(124, 16, 'POPUPLABEL', '...'),
(125, 16, 'DESCRIPTION', ''),
(126, 16, 'VALIDATIONMESSAGE', 'Please select a date when we should contact you.'),
(127, 17, 'NAME', 'Submit'),
(128, 17, 'LABEL', 'Submit'),
(129, 17, 'CAPTION', ''),
(130, 17, 'RESET', 'YES'),
(131, 17, 'RESETLABEL', 'Reset'),
(132, 17, 'ADDITIONALATTRIBUTES', ''),
(133, 18, 'NAME', 'Footer'),
(134, 18, 'TEXT', 'This form is an example. Please check our knowledgebase for articles related to how you should build your form. Articles are updated daily. <a href="http://www.rsjoomla.com/" target="_blank">http://www.rsjoomla.com/</a>'),
(135, 19, 'NAME', 'Page1'),
(136, 19, 'NEXTBUTTON', 'Next >'),
(137, 19, 'PREVBUTTON', 'Prev'),
(138, 19, 'ADDITIONALATTRIBUTES', ''),
(139, 20, 'NAME', 'Page2'),
(140, 20, 'NEXTBUTTON', 'Next >'),
(141, 20, 'PREVBUTTON', 'Prev'),
(142, 20, 'ADDITIONALATTRIBUTES', ''),
(143, 21, 'NAME', 'CompanyHeader'),
(144, 21, 'TEXT', 'Please tell us a little about your company.'),
(145, 22, 'NAME', 'ContactHeader'),
(146, 22, 'TEXT', 'Please let us know how and when to contact you.');