/**
 * 	Displays a EasyContactFormsCustomFormEntryFiles main view record
 *
 * @param object $view
 * 	the EasyContactFormsCustomFormEntryFiles main view object
 * @param object $obj
 * 	a db object
 * @param int $i
 * 	record index
 * @param array $map
 * 	request data
 */
function getCustomFormEntryFilesMainViewRow($view, $obj, $i, $map)
{
    $obj->File = array('doctype' => 'CustomFormEntryFiles', 'docid' => $obj->get('id'), 'field' => 'File', 'tag' => 'a', 'content' => EasyContactFormsT::get('Download'));
    ?>
  <tr class='ufohighlight <?php 
    EasyContactFormsIHTML::getTrSwapClassName($i);
    ?>
'>
    <td class='firstcolumn'>
      <input type='checkbox' id='<?php 
    echo $view->idJoin('cb', $obj->getId());
    ?>
' value='off' class='ufo-deletecb' onchange='this.value=(this.checked)?"on":"off";'/>
    </td>
    <td>
      <?php 
    echo $obj->get('id');
    ?>
    </td>
    <td>
      <?php 
    EasyContactFormsIHTML::echoDate($obj->get('Date'), EasyContactFormsApplicationSettings::getInstance()->getDateFormat('PHP'), 0);
    ?>
    </td>
    <td>
      <a onclick='ufo.redirect({m:"show", oid:"<?php 
    echo $obj->get('CustomForms');
    ?>
", t:"CustomForms"})'>
        <?php 
    echo $obj->get('CustomFormsDescription');
    ?>
      </a>
    </td>
    <td>
      <a onclick='ufo.redirect({m:"show", oid:"<?php 
    echo $obj->get('CustomFormsEntries');
    ?>
", t:"CustomFormsEntries"})'>
        <?php 
    echo $obj->get('CustomFormsEntriesDescription');
    ?>
      </a>
    </td>
    <td>
      <?php 
    echo $obj->get('Description');
    ?>
    </td>
    <td>
      <?php 
    EasyContactFormsIHTML::getFileDownloadLink($obj->File);
    ?>
    </td>
  </tr>
	<?php 
}
Пример #2
0
    /**
     * 	getFormHeader
     *
     * 	a header part of a default page layout
     *
     * @param string $class
     * 	a class to add to a page
     */
    function getFormHeader($class)
    {
        $as = EasyContactFormsApplicationSettings::getInstance();
        $as->showMessages();
        ?>
			<div class = 'ufoccontpage ufo-split <?php 
        echo $class;
        ?>
'>
				<div class = 'ufosp_header'>
					<div class = 'ufospl'>
						<h3>
		<?php 
    }
/**
 * 	Displays a EasyContactFormsCustomFormsEntries main view record
 *
 * @param object $view
 * 	the EasyContactFormsCustomFormsEntries main view object
 * @param object $obj
 * 	a db object
 * @param int $i
 * 	record index
 * @param array $map
 * 	request data
 */
function getCustomFormsEntriesMainViewRow($view, $obj, $i, $map)
{
    $usrname = EasyContactFormsDB::getValue("SELECT display_name  FROM #wp__users WHERE ID = '" . $obj->get('SiteUser') . "'");
    if ($usrname) {
        $obj->SiteUser = $usrname;
    } else {
        $obj->SiteUser = '******';
    }
    ?>
  <tr class='ufohighlight <?php 
    EasyContactFormsIHTML::getTrSwapClassName($i);
    ?>
'>
    <td class='firstcolumn'>
      <input type='checkbox' id='<?php 
    echo $view->idJoin('cb', $obj->getId());
    ?>
' value='off' class='ufo-deletecb' onchange='this.value=(this.checked)?"on":"off";'>
    </td>
    <td>
      <?php 
    $usr = $obj->get('Users');
    if (empty($usr)) {
        $cff = EasyContactFormsClassLoader::getObject('CustomFormFields');
        $cff->getSettingsFormButton('entry-add', EasyContactFormsT::get('CF_ProcessEntry'), "onclick='ufoCf.processEntry(" . $obj->get('id') . ", " . $view->jsconfig . ");'", 'icon_button_add');
    }
    ?>
    </td>
    <td>
      <a onclick='ufo.redirect({m:"show", oid:"<?php 
    echo $obj->get('id');
    ?>
", t:"CustomFormsEntries"})' onmouseover='ufo.showInfo({t:"CustomFormsEntries", m2:"getASList", oid:<?php 
    echo $obj->get('id');
    ?>
, m:"ajaxsuggest"}, this)'>
        <?php 
    EasyContactFormsIHTML::echoStr($obj->get('id'));
    ?>
      </a>
    </td>
    <td>
      <?php 
    EasyContactFormsIHTML::echoDate($obj->get('Date'), EasyContactFormsApplicationSettings::getInstance()->getDateFormat('PHP', TRUE), 0);
    ?>
    </td>
    <td>
      <a onclick='ufo.redirect({m:"show", oid:"<?php 
    echo $obj->get('CustomForms');
    ?>
", t:"CustomForms"})'>
        <?php 
    echo $obj->get('CustomFormsDescription');
    ?>
      </a>
    </td>
    <td>
      <?php 
    echo $obj->get('PageName');
    ?>
    </td>
    <td>
      <a onclick='ufo.redirect({m:"show", oid:"<?php 
    echo $obj->get('Users');
    ?>
", t:"Users"})'>
        <?php 
    echo $obj->get('UsersDescription');
    ?>
      </a>
    </td>
    <td>
      <?php 
    echo $obj->SiteUser;
    ?>
    </td>
  </tr>
	<?php 
}
 /**
  * 	updateTemplate
  *
  * @param  $cf
  * 
  *
  * @return
  * 
  */
 function updateTemplate($cf)
 {
     $query = "SELECT\n\t\t\t\tCustomFormFields.id,\n\t\t\t\tFieldSetListPosition.ListPosition AS FieldSetListPosition,\n\t\t\t\tIF(CustomFormFields.Type=1\n\t\t\t\t\tOR CustomFormFields.Type=2,\n\t\t\t\t\t1,\n\t\t\t\t\t0) AS Container\n\t\t\tFROM\n\t\t\t\t#wp__easycontactforms_customformfields AS CustomFormFields\n\t\t\tINNER JOIN\n\t\t\t\t#wp__easycontactforms_customformfieldtypes AS CustomFormFieldTypes\n\t\t\t\t\tON\n\t\t\t\t\t\tCustomFormFields.Type=CustomFormFieldTypes.id\n\t\t\t\tLEFT JOIN(\n\t\t\t\tSELECT\n\t\t\t\t\tCustomFormFields.id,\n\t\t\t\t\tCustomFormFields.ListPosition\n\t\t\t\tFROM\n\t\t\t\t\t#wp__easycontactforms_customformfields AS CustomFormFields) AS FieldSetListPosition\n\t\t\t\t\tON\n\t\t\t\t\t\tFieldSetListPosition.id=CustomFormFields.FieldSet\n\t\t\tWHERE\n\t\t\t\tCustomFormFields.CustomForms={$cf}\n\t\t\tORDER BY\n\t\t\t\tFieldSetListPosition,\n\t\t\t\tContainer DESC,\n\t\t\t\tCustomFormFields.ListPosition";
     $fields = EasyContactFormsDB::getObjects($query);
     $form = EasyContactFormsClassLoader::getObject('CustomForms', true, $cf);
     $stylespec = $form->getStyleSpec();
     $divmargin = $form->isEmpty('LineHeight') ? '' : "margin-top:{$form->get('LineHeight')}{$form->get('LineHeightUnit')};";
     $rows = array();
     $containertag = '';
     $containerbottom = '';
     $containercf = '';
     $containerbottominside = '';
     $iscontainer = false;
     $vjs = array();
     $items = array();
     foreach ($fields as $fld) {
         $fld = EasyContactFormsClassLoader::getObject('CustomFormFields', true, $fld->id);
         $phase = (object) array('index' => 8);
         include $fld->getTMPFileName('proc');
         $text = $fld->get('Template');
         $xml = simplexml_load_string($text);
         if (!$xml) {
             continue;
         }
         $entry = (object) array();
         $iscontainer = false;
         foreach ($xml->children() as $child) {
             $name = $child->getName();
             if ($name == 'Container') {
                 $iscontainer = true;
                 if (!$containertag == '') {
                     if (!empty($containerbottominside)) {
                         $rows[] = $containerbottominside;
                     }
                     $rows[] = "</{$containertag}>";
                     $rows = $form->templateHTML($rows, $stylespec, 6);
                     $rows = $form->templateHTML($rows, $stylespec, 2);
                     if (!empty($containerbottom)) {
                         $rows[] = $containerbottom;
                     }
                     if (!empty($containercf)) {
                         $rows[] = $containercf;
                     }
                 }
                 $containerbottom = '';
                 $containerbottominside = '';
                 $containertag = (string) $child->attributes()->containertag;
                 $containercf = (string) $child->attributes()->addcf == 'on' ? "<div style='clear:both;height:1px'></div>" : '';
             }
             $iscenter = $name == 'Container' || $name == 'Input' || $name == 'Validation';
             $positionname = $iscenter ? 'center' : $child->attributes()->position;
             $width = isset($child->attributes()->width) ? $child->attributes()->width : '';
             $rowclass = isset($child->attributes()->rowclass) ? $child->attributes()->rowclass : '';
             if (!isset($entry->{$positionname})) {
                 $entry->{$positionname} = (object) array();
                 $entry->{$positionname}->list = array();
                 $entry->{$positionname}->width = '';
                 $entry->{$positionname}->rowclass = '';
             }
             array_push($entry->{$positionname}->list, (string) $child);
             $entry->{$positionname}->width = $width;
             $entry->{$positionname}->rowclass = $rowclass;
         }
         if ($iscontainer) {
             if (isset($entry->top)) {
                 $rows[] = implode('', $entry->top->list);
             }
             if (isset($entry->bottom)) {
                 $containerbottom = implode('', $entry->bottom->list);
             }
             if (isset($entry->{'bottom-inside'})) {
                 $containerbottominside = implode('', $entry->{'bottom-inside'}->list);
             }
             $rows = $form->templateHTML($rows, $stylespec, 4);
             $rows[] = implode('', $entry->center->list);
             if (isset($entry->{'top-inside'})) {
                 $rows[] = implode('', $entry->{'top-inside'}->list);
             }
         } else {
             $fldid = $fld->get('id');
             $typeid = $fld->get('Type');
             $rowclass = empty($entry->center->rowclass) ? '' : ' ' . $entry->center->rowclass;
             $rows[] = "<div class='ufo-fieldtype-{$typeid} ufo-customform-row ufo-row-{$fldid}{$rowclass}' style='{$divmargin}{display-{$fldid}}'>";
             if (isset($entry->top)) {
                 $entry->top->width = $entry->center->width;
                 $rows = EasyContactFormsCustomForms::addRow($rows, $entry->top, isset($entry->left), isset($entry->right), $fldid, 1);
             }
             $entryleft = isset($entry->left) ? $entry->left : false;
             $entryright = isset($entry->right) ? $entry->right : false;
             $rows = EasyContactFormsCustomForms::addRow($rows, $entry->center, $entryleft, $entryright, $fldid, 2);
             if (isset($entry->bottom)) {
                 $entry->bottom->width = $entry->center->width;
                 $rows = EasyContactFormsCustomForms::addRow($rows, $entry->bottom, isset($entry->left), isset($entry->right), $fldid, 3);
             }
             $rows[] = '</div>';
         }
     }
     if (!empty($containerbottominside)) {
         $rows[] = $containerbottominside;
     }
     $rows = $form->templateHTML($rows, $stylespec, 6);
     $rows[] = "</{$containertag}>";
     $rows = $form->templateHTML($rows, $stylespec, 2);
     if (!empty($containerbottom)) {
         $rows[] = $containerbottom;
     }
     if (!empty($containercf)) {
         $rows[] = $containercf;
     }
     $rows = implode('', $rows);
     $html = array();
     $html[] = "<script type='text/javascript'>";
     $html[] = "if (typeof(ecfconfig) == 'undefined'){var ecfconfig={};}";
     $html[] = "ecfconfig[{$cf}]={};";
     if (!$form->isEmpty('FadingDelay')) {
         $html[] = "ecfconfig[{$cf}].fadeDelay='" . $form->get('FadingDelay') . "';";
     }
     if (!$form->isEmpty('MessageDelay')) {
         $html[] = "ecfconfig[{$cf}].messageDelay='" . $form->get('MessageDelay') . "';";
     }
     $ajaxurl = EasyContactFormsApplicationSettings::getInstance()->get('FixStatus0') ? home_url('wp-admin/admin-ajax.php') : admin_url('admin-ajax.php');
     $html[] = "var ufobaseurl =  '{$ajaxurl}';";
     $html[] = "if (typeof(ufoFormsConfig) == 'undefined') {var ufoFormsConfig = {};ufoFormsConfig.submits = [];ufoFormsConfig.resets = [];ufoFormsConfig.validations = [];}";
     $as = EasyContactFormsApplicationSettings::getInstance();
     if (!$as->isEmpty('PhoneRegEx')) {
         $html[] = "ufoFormsConfig.phonenumberre = /^" . $as->get('PhoneRegEx') . "/;";
     }
     $html[] = "</script>";
     $html[] = $form->loadStyle();
     $stylesheet = $form->getStyle();
     if (!empty($stylesheet)) {
         $html[] = "<style>{$stylesheet}</style>";
     }
     $formclass = array();
     $formclass[] = 'ufo-form';
     if (!$form->isEmpty('FormClass')) {
         $formclass[] = $form->get('FormClass');
     }
     $formclass = implode(' ', $formclass);
     $formclass = " class='{$formclass}'";
     $formstyle = array();
     if (!$form->isEmpty('FormStyle')) {
         $formstyle[] = $form->get('FormStyle');
     }
     if (!$form->isEmpty('Width')) {
         $formstyle[] = "width:{$form->get('Width')}{$form->get('WidthUnit')}";
     }
     if (sizeof($formstyle) != 0) {
         $formstyle = " style='" . implode(';', $formstyle) . "'";
     } else {
         $formstyle = '';
     }
     $html[] = "<div{$formclass}{$formstyle} id='ufo-form-id-{$cf}'>";
     $html[] = "<noscript><form method='POST'><input type='hidden' name='cf-no-script' value='1'></noscript>";
     $html[] = "<input type='hidden' value='ufo-form-id-{$cf}' name='hidden-{$cf}' id='ufo-form-hidden-{$cf}'>";
     $html[] = "<input type='hidden' value='{__pagename}' name='ufo-form-pagename' id='ufo-form-pagename'>";
     $html[] = "{preview}";
     $html[] = "<input type='hidden' value='{ufosignature}' name='ufo-sign' id='ufo-sign'>";
     $html = $form->templateHTML($html, $stylespec, 1);
     $html[] = $rows;
     $html = $form->templateHTML($html, $stylespec, 3);
     $html[] = "<div id='ufo-form-id-{$cf}-message'></div>";
     $html[] = "<noscript></form></noscript>";
     $html[] = "</div>";
     if (count($vjs) > 0) {
         $html[] = '<script type="text/javascript">' . implode('', $vjs) . '</script>';
     }
     $txt = implode('', $html);
     $html = array('HTML' => $txt, 'ShortCode' => '[easy_contact_forms fid=' . $cf . ']');
     EasyContactFormsDB::update($html, 'CustomForms', $cf);
 }
 /**
  * 	addRow
  *
  * @param  $rows
  * 
  * @param  $center
  * 
  * @param  $left
  * 
  * @param  $right
  * 
  * @param  $fldid
  * 
  * @param  $rowindex
  * 
  *
  * @return
  * 
  */
 function addRow($rows, $center, $left, $right, $fldid, $rowindex)
 {
     $as = EasyContactFormsApplicationSettings::getInstance();
     $wrappertag = $as->get('w3cCompliant') ? 'div' : 'span';
     $prefix = 'ufo-cell';
     $centerclass = $prefix . '-center';
     $leftclass = $prefix . '-left';
     $rightclass = $prefix . '-right';
     $cellspec = $prefix . '-' . $fldid . '-' . $rowindex;
     if (!isset($center)) {
         return $rows;
     }
     $width = $center->width != '' ? " style='width:{$center->width}'" : '';
     $center = implode('', $center->list);
     $center = "<{$wrappertag} class='{$centerclass}'{$width} id='{$cellspec}-center'>{$center}</{$wrappertag}>";
     if (!$left) {
         $left = '';
     } else {
         if (is_object($left)) {
             $left = implode('', $left->list);
         } else {
             $left = "<p style='display:none'></p>";
         }
         $left = "<{$wrappertag} class='{$leftclass}' id='{$cellspec}-left'>{$left}</{$wrappertag}>";
     }
     if (!$right) {
         $right = '';
     } else {
         if (is_object($right)) {
             $right = implode('', $right->list);
         } else {
             $right = "<p style='display:none'></p>";
         }
         $right = "<{$wrappertag} class='{$rightclass}' id='{$cellspec}-right'>{$right}</{$wrappertag}>";
     }
     $rows[] = "<div class='{$cellspec}-row' id='{$cellspec}'>" . $left . $center . $right . "</div>";
     return $rows;
 }
    /**
     * 	getEmailTemplateRow
     *
     * 	Produces a clickable table row
     *
     * @param string $type
     * 	an object type
     * @param string $field
     * 	an object field
     * @param string $label
     * 	a field label
     * @param boolean $direct
     * 	use direct name
     * @param  $tmce
     * 	use TinyMCE
     */
    function getEmailTemplateRow($type, $field, $label, $direct = FALSE, $tmce = FALSE)
    {
        $direct = $direct ? 'true' : 'false';
        $tmce = $tmce && EasyContactFormsApplicationSettings::getInstance()->get('UseTinyMCE') ? 'true' : 'false';
        ?>

		
<tr style='border:0'>
  <td style='border:0'>
    <a id='<?php 
        echo $type . $field . 'icLink';
        ?>
' title='<?php 
        echo EasyContactFormsT::get('ClickToAddToTheTemplate');
        ?>
' href='javascript:;' class='ufo-id-link' onmousedown='ufo.insertContent(this, "<?php 
        echo $type;
        ?>
","{<?php 
        echo $field;
        ?>
}", <?php 
        echo $direct;
        ?>
, <?php 
        echo $tmce;
        ?>
)'>
      <?php 
        echo $label;
        ?>
    </a>
  </td>
</tr>

		<?php 
    }
Пример #7
0
function easycontactforms_install_data()
{
    global $current_user, $wpdb;
    $userid = NULL;
    if (isset($current_user)) {
        $userid = $current_user->ID;
    }
    $adminemail = get_option('admin_email');
    $rows = array(array('id' => 285, 'Description' => 'Employee', 'Name' => 'Employee', 'ContactType' => 4, 'Birthday' => 300492000, 'Role' => 3, 'Notes' => 'Ut auctor ultrices elementum. Donec quis velit quam, ac mattis turpis. Praesent venenatis auctor sagittis.<br /><br />Morbi pulvinar malesuada risus in tempor. Fusce eu sapien a sem aliquet pulvinar. Nullam elementum facilisis quam, sed sollicitudin tortor gravida et.', 'email' => '*****@*****.**', 'email2' => '*****@*****.**', 'Cell' => '+65 446-8025', 'Phone1' => '+51 939-3961', 'Phone2' => '+17 383-6744', 'Phone3' => '+56 624-1157', 'ContactField3' => 'Morbi pulvinar malesuada risus in tempor. Fusce eu sapien a sem aliquet pulvinar. Nullam elementum facilisis quam, sed sollicitudin tortor gravida et.', 'ContactField4' => 'Etiam neque nunc, fermentum sit amet fermentum ut, ultrices vitae neque. Maecenas nibh enim, dictum a semper et, sagittis viverra purus.', 'Country' => 'USA', 'Address' => '239 Filbert Street', 'City' => 'Ridley Park', 'State' => 'PA', 'Zip' => '19078'), array('id' => 286, 'Description' => 'SuperAdmin', 'Name' => 'SuperAdmin', 'ContactType' => 4, 'Birthday' => 299800800, 'Role' => 1, 'CMSId' => $userid, 'Notes' => 'Maecenas eget lectus ut odio mattis fringilla. Nunc sem leo, interdum id euismod sit amet, varius vel lorem.<br /><br />Ut auctor ultrices elementum. Donec quis velit quam, ac mattis turpis. Praesent venenatis auctor sagittis.', 'email' => $adminemail, 'Cell' => '+67 709-8655', 'Phone1' => '+64 555-1383', 'Phone2' => '+99 040-6159', 'Phone3' => '+86 839-8655', 'ContactField3' => 'Morbi quis magna urna, id viverra ipsum. Fusce nibh orci, interdum id pharetra ut, ultricies vel metus.', 'ContactField4' => 'Nulla tincidunt justo nec diam molestie feugiat. Aenean et est non sapien ultrices posuere id a odio.', 'Country' => 'USA', 'Address' => '28 Victoria Court', 'City' => 'Sanford', 'State' => 'ME', 'Zip' => '04073'), array('id' => 287, 'Description' => 'Pierce', 'Name' => 'Courtney', 'ContactType' => 4, 'Birthday' => 173570400, 'Role' => 4, 'Notes' => 'Morbi quis magna urna, id viverra ipsum. Fusce nibh orci, interdum id pharetra ut, ultricies vel metus.<br /><br />Aliquam eu nisi vel lorem ultricies laoreet. Nulla eget mi ac leo porttitor luctus a nec purus. Phasellus in erat at nulla feugiat aliquam.', 'email' => '*****@*****.**', 'email2' => '*****@*****.**', 'Cell' => '+13 566-5699', 'Phone1' => '+29 240-9540', 'Phone2' => '+79 799-9207', 'Phone3' => '+67 288-1822', 'ContactField3' => 'Maecenas lacinia arcu nec nisl elementum nec cursus massa consequat.', 'ContactField4' => 'Praesent vel quam nunc. Aliquam cursus blandit semper.', 'Country' => 'USA', 'Address' => '188 Seth Street', 'City' => 'Fredonia', 'State' => 'TX', 'Zip' => '76842'), array('id' => 288, 'Description' => 'Hawkins', 'Name' => 'Josefina', 'ContactType' => 4, 'Birthday' => 237420000, 'Role' => 4, 'Notes' => 'Maecenas egestas consectetur nisl quis convallis. Maecenas nisi sapien, molestie ac rutrum et, vehicula sed orci.<br /><br />Etiam neque nunc, fermentum sit amet fermentum ut, ultrices vitae neque. Maecenas nibh enim, dictum a semper et, sagittis viverra purus.', 'email' => '*****@*****.**', 'email2' => '*****@*****.**', 'Cell' => '+41 946-6091', 'Phone1' => '+68 539-2340', 'Phone2' => '+58 360-0962', 'Phone3' => '+09 670-2242', 'ContactField3' => 'Nullam a neque dolor. Pellentesque elementum, magna quis interdum volutpat, libero ipsum scelerisque turpis, porta pretium dolor lectus ac risus.', 'ContactField4' => 'Morbi quis magna urna, id viverra ipsum. Fusce nibh orci, interdum id pharetra ut, ultricies vel metus.', 'Country' => 'USA', 'Address' => '20 Franklin Street', 'City' => 'Montgomery', 'State' => 'AL', 'Zip' => '36107'), array('id' => 289, 'Description' => 'Maldonado', 'Name' => 'Nicole', 'ContactType' => 1, 'Birthday' => 364168800, 'Role' => 4, 'Notes' => 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. In sagittis tincidunt tortor, non bibendum risus lobortis ac.<br /><br />Praesent ut facilisis odio. Maecenas congue neque ut nisi placerat vitae suscipit mauris fermentum.', 'email' => '*****@*****.**', 'email2' => '*****@*****.**', 'Cell' => '+40 612-5881', 'Phone1' => '+34 120-0730', 'Phone2' => '+85 284-3971', 'Phone3' => '+45 100-8004', 'ContactField3' => 'Ut auctor ultrices elementum. Donec quis velit quam, ac mattis turpis. Praesent venenatis auctor sagittis.', 'ContactField4' => 'Maecenas lacinia arcu nec nisl elementum nec cursus massa consequat.', 'Country' => 'USA', 'Address' => '53 Graystone Lakes', 'City' => 'Unadilla', 'State' => 'GA', 'Zip' => '31091'), array('id' => 290, 'Description' => 'Vega', 'Name' => 'Dan', 'ContactType' => 1, 'Birthday' => 112399200, 'Role' => 4, 'Notes' => 'Maecenas eget lectus ut odio mattis fringilla. Nunc sem leo, interdum id euismod sit amet, varius vel lorem.<br /><br />Phasellus in metus in magna vestibulum ultricies. In nec metus mauris, vitae semper justo.', 'email' => '*****@*****.**', 'email2' => '*****@*****.**', 'Cell' => '+55 667-1370', 'Phone1' => '+41 365-4503', 'Phone2' => '+92 160-0475', 'Phone3' => '+04 365-5904', 'ContactField3' => 'Nulla tincidunt justo nec diam molestie feugiat. Aenean et est non sapien ultrices posuere id a odio.', 'ContactField4' => 'Nunc molestie hendrerit arcu, non dapibus nulla suscipit ac. Nam eget nulla sit amet ante mollis pharetra.', 'Country' => 'USA', 'Address' => '149 Seneca Drive', 'City' => 'Silverton', 'State' => 'OR', 'Zip' => '97381'));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_users');
    $count = $wpdb->get_var('SELECT COUNT(*) FROM ' . $table_name . ';');
    if ($count == 0) {
        foreach ($rows as $row) {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('id' => 3315, 'Description' => 'Please fill in the fields below', 'Type' => 2, 'Settings' => '<?xml version="1.0"?>
<form>
  
  
  <LabelTagName>h3</LabelTagName>
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  <ShowDescription>off</ShowDescription>
  <Description/>
  <DescriptionPosition>top</DescriptionPosition>
  <DescriptionCSSClass>ufo-customfields-container-description</DescriptionCSSClass>
  <DescriptionCSSStyle/>
  <SetStyle>off</SetStyle>
  <CSSClass/>
  <CSSStyle/>
  <AddCF>off</AddCF>
  <SetSize>off</SetSize>
  <Width>230</Width>
  <WidthUnit>px</WidthUnit>
<ShowLabel><![CDATA[off]]></ShowLabel><Label><![CDATA[Please fill in the fields below]]></Label></form>', 'Template' => '<field><Container containertag="div" addcf="off"><![CDATA[<div>]]></Container></field>', 'ListPosition' => 3315, 'CustomForms' => 1, 'FieldSet' => 3315), array('id' => 3316, 'Description' => 'Section', 'Type' => 2, 'Settings' => '<?xml version="1.0"?>
<form>
  
  
  <LabelTagName>h3</LabelTagName>
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  
  <Description/>
  
  
  <DescriptionCSSStyle/>
  
  <CSSClass/>
  
  
  <Width>230</Width>
  <WidthUnit>px</WidthUnit>
<DescriptionCSSClass><![CDATA[ufo-customfields-container-description]]></DescriptionCSSClass><DescriptionPosition><![CDATA[top-inside]]></DescriptionPosition><CSSStyle><![CDATA[]]></CSSStyle><SetStyle><![CDATA[off]]></SetStyle><SetSize><![CDATA[off]]></SetSize><ShowDescription><![CDATA[off]]></ShowDescription><ShowLabel><![CDATA[off]]></ShowLabel><AddCF>off</AddCF><Label><![CDATA[Section]]></Label></form>', 'Template' => '<field>
    <Container containertag="div" addcf="off"><![CDATA[<div>
     ]]></Container>
</field>', 'ListPosition' => 3316, 'CustomForms' => 1, 'FieldSet' => 3316), array('id' => 3318, 'Description' => 'First name', 'Type' => 4, 'Settings' => '<?xml version="1.0"?>
<form>
  
  
  
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  <ShowDescription>off</ShowDescription>
  <Description/>
  <DescriptionPosition>bottom</DescriptionPosition>
  <DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass>
  <DescriptionCSSStyle/>
  <SetDefaultValue>off</SetDefaultValue>
  <DefaultValue/>
  <IsBlankValue>on</IsBlankValue>
  <DefaultValueCSSClass/>
  
  
  
  <SetRequiredSuffix>on</SetRequiredSuffix>
  <RequiredSuffix>*</RequiredSuffix>
  <RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass>
  <RequiredSuffixCSSStyle/>
  
  <InvalidCSSClass/>
  <RequiredMessageCSSClass/>
  <RequiredMessageCSSStyle/>
  
  
  
  
  
  <ValidMessage/>
  <ValidMessagePosition>right</ValidMessagePosition>
  <ValidCSSClass/>
  <ValidCSSStyle/>
  <SetStyle>off</SetStyle>
  <CSSClass/>
  <CSSStyle/>
  <RowCSSClass/>
  <SetSize>off</SetSize>
  <Width>230</Width>
  <WidthUnit>px</WidthUnit>
  
  
  
<Required><![CDATA[on]]></Required><Label><![CDATA[First name]]></Label><AbsolutePosition><![CDATA[on]]></AbsolutePosition><RequiredMessagePosition><![CDATA[right]]></RequiredMessagePosition><LabelPosition><![CDATA[left-align-left]]></LabelPosition><ShowLabel><![CDATA[on]]></ShowLabel><Validate><![CDATA[off]]></Validate><MinLength><![CDATA[0]]></MinLength><MaxLength><![CDATA[0]]></MaxLength><SetContactOptions><![CDATA[off]]></SetContactOptions><RegistredUsersOptions><![CDATA[none]]></RegistredUsersOptions><LinkToAppField><![CDATA[]]></LinkToAppField><RequiredMessage><![CDATA[This field is required]]></RequiredMessage><SetValidMessage><![CDATA[off]]></SetValidMessage><ValidMessageAbsolutePosition><![CDATA[off]]></ValidMessageAbsolutePosition></form>', 'Template' => '<field><ShowLabel position="left"><![CDATA[<label for=\'ufo-field-id-3318\'  style=\'text-align:left\'>First name<span class=\'ufo-customfields-required-suffix\'>*</span></label>]]></ShowLabel><RequiredMessage position="right"><![CDATA[<div id=\'ufo-field-id-3318-invalid\'  style=\'display:none\'></div>]]></RequiredMessage><Validation><![CDATA[<script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required"]},"Required":true,"RequiredMessage":"This field is required","AbsolutePosition":true,"RequiredMessagePosition":"right","id":"ufo-field-id-3318","form":"ufo-form-id-1"});</script>]]></Validation><Input ><![CDATA[<input type=\'text\' id=\'ufo-field-id-3318\' value=\'{id-3318}\' name=\'id-3318\' />]]></Input></field>', 'ListPosition' => 3318, 'CustomForms' => 1, 'FieldSet' => 3316), array('id' => 3319, 'Description' => 'Last name', 'Type' => 4, 'Settings' => '<?xml version="1.0"?>
<form>
  
  
  <LabelPosition>left-align-left</LabelPosition>
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  <ShowDescription>off</ShowDescription>
  <Description/>
  <DescriptionPosition>bottom</DescriptionPosition>
  <DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass>
  <DescriptionCSSStyle/>
  <SetDefaultValue>off</SetDefaultValue>
  <DefaultValue/>
  <IsBlankValue>on</IsBlankValue>
  <DefaultValueCSSClass/>
  
  
  
  <SetRequiredSuffix>on</SetRequiredSuffix>
  <RequiredSuffix>*</RequiredSuffix>
  <RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass>
  <RequiredSuffixCSSStyle/>
  
  <InvalidCSSClass/>
  <RequiredMessageCSSClass/>
  <RequiredMessageCSSStyle/>
  
  
  
  
  
  <ValidMessage/>
  <ValidMessagePosition>right</ValidMessagePosition>
  <ValidCSSClass/>
  <ValidCSSStyle/>
  <SetStyle>off</SetStyle>
  <CSSClass/>
  <CSSStyle/>
  <RowCSSClass/>
  <SetSize>off</SetSize>
  <Width>230</Width>
  <WidthUnit>px</WidthUnit>
  
  
  
<Label><![CDATA[Last name]]></Label><Required><![CDATA[on]]></Required><AbsolutePosition><![CDATA[on]]></AbsolutePosition><RequiredMessagePosition><![CDATA[right]]></RequiredMessagePosition><ShowLabel><![CDATA[on]]></ShowLabel><Validate><![CDATA[off]]></Validate><MinLength><![CDATA[0]]></MinLength><MaxLength><![CDATA[0]]></MaxLength><SetContactOptions><![CDATA[off]]></SetContactOptions><RegistredUsersOptions><![CDATA[none]]></RegistredUsersOptions><LinkToAppField><![CDATA[]]></LinkToAppField><RequiredMessage><![CDATA[This field is required]]></RequiredMessage><SetValidMessage><![CDATA[off]]></SetValidMessage><ValidMessageAbsolutePosition><![CDATA[off]]></ValidMessageAbsolutePosition></form>', 'Template' => '<field><ShowLabel position="left"><![CDATA[<label for=\'ufo-field-id-3319\'  style=\'text-align:left\'>Last name<span class=\'ufo-customfields-required-suffix\'>*</span></label>]]></ShowLabel><RequiredMessage position="right"><![CDATA[<div id=\'ufo-field-id-3319-invalid\'  style=\'display:none\'></div>]]></RequiredMessage><Validation><![CDATA[<script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required"]},"Required":true,"RequiredMessage":"This field is required","AbsolutePosition":true,"RequiredMessagePosition":"right","id":"ufo-field-id-3319","form":"ufo-form-id-1"});</script>]]></Validation><Input ><![CDATA[<input type=\'text\' id=\'ufo-field-id-3319\' value=\'{id-3319}\' name=\'id-3319\' />]]></Input></field>', 'ListPosition' => 3319, 'CustomForms' => 1, 'FieldSet' => 3316), array('id' => 3320, 'Description' => 'Email', 'Type' => 5, 'Settings' => '<?xml version="1.0"?>
<form>
  
  <Label>Email</Label>
  
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  <ShowDescription>off</ShowDescription>
  <Description/>
  <DescriptionPosition>bottom</DescriptionPosition>
  <DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass>
  <DescriptionCSSStyle/>
  <SetDefaultValue>off</SetDefaultValue>
  <DefaultValue>Your email</DefaultValue>
  <IsBlankValue>on</IsBlankValue>
  <DefaultValueCSSClass/>
  <Required>on</Required>
  <RequiredMessage>Please enter you email</RequiredMessage>
  
  <SetRequiredSuffix>on</SetRequiredSuffix>
  <RequiredSuffix>*</RequiredSuffix>
  <RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass>
  <RequiredSuffixCSSStyle/>
  
  <InvalidCSSClass/>
  <RequiredMessageCSSClass/>
  <RequiredMessageCSSStyle/>
  <Validate>on</Validate>
  
  
  <ValidMessage/>
  <ValidMessagePosition>right</ValidMessagePosition>
  <ValidCSSClass/>
  <ValidCSSStyle/>
  <SetStyle>off</SetStyle>
  <CSSClass/>
  <CSSStyle/>
  <RowCSSClass/>
  <SetSize>off</SetSize>
  <Width>230</Width>
  <WidthUnit>px</WidthUnit>
  
  
  
<AbsolutePosition><![CDATA[on]]></AbsolutePosition><LabelPosition><![CDATA[left-align-left]]></LabelPosition><RequiredMessagePosition><![CDATA[right]]></RequiredMessagePosition><ShowLabel><![CDATA[on]]></ShowLabel><RegistredUsersOptions><![CDATA[none]]></RegistredUsersOptions><LinkToAppField><![CDATA[]]></LinkToAppField><SetContactOptions><![CDATA[off]]></SetContactOptions><SetValidMessage><![CDATA[off]]></SetValidMessage><ValidMessageAbsolutePosition><![CDATA[off]]></ValidMessageAbsolutePosition></form>', 'Template' => '<field><ShowLabel position="left"><![CDATA[<label for=\'ufo-field-id-3320\'  style=\'text-align:left\'>Email<span class=\'ufo-customfields-required-suffix\'>*</span></label>]]></ShowLabel><RequiredMessage position="right"><![CDATA[<div id=\'ufo-field-id-3320-invalid\'  style=\'display:none\'></div>]]></RequiredMessage><Validation><![CDATA[<script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required","email"]},"Required":true,"Validate":true,"RequiredMessage":"Please enter you email","AbsolutePosition":true,"RequiredMessagePosition":"right","id":"ufo-field-id-3320","form":"ufo-form-id-1"});</script>]]></Validation><Input ><![CDATA[<input type=\'text\' id=\'ufo-field-id-3320\' value=\'{id-3320}\' name=\'id-3320\' />]]></Input></field>', 'ListPosition' => 3320, 'CustomForms' => 1, 'FieldSet' => 3316), array('id' => 3321, 'Description' => 'Your request', 'Type' => 10, 'Settings' => '<?xml version="1.0"?>
<form>
  
  
  
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  
  
  
  <DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass>
  <DescriptionCSSStyle/>
  <SetDefaultValue>off</SetDefaultValue>
  <DefaultValue/>
  <IsBlankValue>on</IsBlankValue>
  <DefaultValueCSSClass/>
  
  <RequiredMessage>This field is required</RequiredMessage>
  <RequiredMessagePosition>right</RequiredMessagePosition>
  <SetRequiredSuffix>on</SetRequiredSuffix>
  <RequiredSuffix>*</RequiredSuffix>
  <RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass>
  <RequiredSuffixCSSStyle/>
  <AbsolutePosition>on</AbsolutePosition>
  <InvalidCSSClass/>
  <RequiredMessageCSSClass/>
  <RequiredMessageCSSStyle/>
  <Validate>off</Validate>
  <MinLength/>
  <MaxLength/>
  
  
  <ValidMessage/>
  <ValidMessagePosition>right</ValidMessagePosition>
  <ValidCSSClass/>
  <ValidCSSStyle/>
  
  <CSSClass/>
  <CSSStyle/>
  <RowCSSClass/>
  
  
  <WidthUnit>px</WidthUnit>
  
  <HeightUnit>px</HeightUnit>
<Label><![CDATA[Your request]]></Label><Description><![CDATA[Please provide us with your request details]]></Description><DescriptionPosition><![CDATA[top]]></DescriptionPosition><Required><![CDATA[on]]></Required><SetSize><![CDATA[on]]></SetSize><LabelPosition><![CDATA[top-align-left]]></LabelPosition><ShowDescription><![CDATA[off]]></ShowDescription><Width><![CDATA[360]]></Width><ShowLabel><![CDATA[on]]></ShowLabel><SetContactOptions>off</SetContactOptions><SetStyle><![CDATA[off]]></SetStyle><Height><![CDATA[100]]></Height><SetValidMessage><![CDATA[off]]></SetValidMessage><ValidMessageAbsolutePosition><![CDATA[off]]></ValidMessageAbsolutePosition></form>', 'Template' => '<field><ShowLabel position="top"><![CDATA[<label for=\'ufo-field-id-3321\'  style=\'text-align:left\'>Your request<span class=\'ufo-customfields-required-suffix\'>*</span></label>]]></ShowLabel><RequiredMessage position="right"><![CDATA[<div id=\'ufo-field-id-3321-invalid\'  style=\'display:none\'></div>]]></RequiredMessage><Validation><![CDATA[<script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required"]},"Required":true,"RequiredMessage":"This field is required","AbsolutePosition":true,"RequiredMessagePosition":"right","id":"ufo-field-id-3321","form":"ufo-form-id-1"});</script>]]></Validation><Input  width="360px"><![CDATA[<textarea id=\'ufo-field-id-3321\' name=\'id-3321\'  style=\'height:100px;width:360px\'>{id-3321}</textarea>]]></Input></field>', 'ListPosition' => 3321, 'CustomForms' => 1, 'FieldSet' => 3316), array('id' => 3322, 'Description' => 'Submit', 'Type' => 6, 'Settings' => '<?xml version="1.0"?>
<form>
  
  
  
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  <SetStyle>off</SetStyle>
  <CSSClass/>
  <CSSStyle/>
  <RowCSSClass/>
  
  <Width>100</Width>
  <WidthUnit>px</WidthUnit>
<InputPosition><![CDATA[left]]></InputPosition><ShowLabel><![CDATA[on]]></ShowLabel><SetSize><![CDATA[off]]></SetSize><Label><![CDATA[Submit]]></Label></form>', 'Template' => '<field><Validation><![CDATA[<script type=\'text/javascript\'>var c = {};c.id = \'ufo-field-id-3322\';c.form = \'ufo-form-id-1\';c.Label = \'Submit\';ufoFormsConfig.submits.push(c);</script>]]></Validation><Input><![CDATA[<span id=\'ufo-field-id-3322-span\'><noscript><button type=\'submit\' id=\'ufo-field-id-3322\' name=\'id-3322\' >Submit</button></noscript></span>]]></Input></field>', 'ListPosition' => 3322, 'CustomForms' => 1, 'FieldSet' => 3316));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_customformfields');
    $count = $wpdb->get_var('SELECT COUNT(*) FROM ' . $table_name . ';');
    if ($count == 0) {
        foreach ($rows as $row) {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('id' => 1, 'Description' => 'Simple contact form', 'NotificationSubject' => 'New request received', 'SendFrom' => 'Champion Forms', 'SendConfirmation' => 0, 'ConfirmationSubject' => 'We have received your request', 'Redirect' => 0, 'ShortCode' => '[easy_contact_forms fid=1]', 'Template' => 0, 'ObjectOwner' => 286, 'SubmissionSuccessText' => 'Thank you for contacting us! We are glad to hear from you.', 'HTML' => '<script type=\'text/javascript\'>if (typeof(ecfconfig) == \'undefined\'){var ecfconfig={};}ecfconfig[1]={};var ufobaseurl =  \'http://localhost/wordpress-3.3/wp-admin/admin-ajax.php\';if (typeof(ufoFormsConfig) == \'undefined\') {var ufoFormsConfig = {};ufoFormsConfig.submits = [];ufoFormsConfig.resets = [];ufoFormsConfig.validations = [];}ufoFormsConfig.phonenumberre = /^(\\+{0,1}\\d{1,2})*\\s*(\\(?\\d{3}\\)?\\s*)*\\d{3}(-{0,1}|\\s{0,1})\\d{2}(-{0,1}|\\s{0,1})\\d{2}$/;</script><link href=\'http://localhost/wordpress-3.3/wp-content/plugins/easy-contact-forms/forms/styles/easyform/css/std.css?ver=1.4.9\' rel=\'stylesheet\' type=\'text/css\'/><div class=\'ufo-form\' id=\'ufo-form-id-1\'><noscript><form method=\'post\'><input type=\'hidden\' name=\'cf-no-script\' value=\'1\'/></noscript><input type=\'hidden\' value=\'ufo-form-id-1\' name=\'hidden-1\' id=\'ufo-form-hidden-1\'/><input type=\'hidden\' value=\'{__pagename}\' name=\'ufo-form-pagename\' id=\'ufo-form-pagename\'/>{preview}<input type=\'hidden\' value=\'{ufosignature}\' name=\'ufo-sign\' id=\'ufo-sign\'/><div></div><div>
     <div class=\'ufo-fieldtype-4 ufo-customform-row ufo-row-3318\' style=\'margin-top:2px;{display-3318}\'><div class=\'ufo-cell-3318-2-row\' id=\'ufo-cell-3318-2\'><span class=\'ufo-cell-left\' id=\'ufo-cell-3318-2-left\'><label for=\'ufo-field-id-3318\'  style=\'text-align:left\'>First name<span class=\'ufo-customfields-required-suffix\'>*</span></label></span><span class=\'ufo-cell-center\' id=\'ufo-cell-3318-2-center\'><script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required"]},"Required":true,"RequiredMessage":"This field is required","AbsolutePosition":true,"RequiredMessagePosition":"right","id":"ufo-field-id-3318","form":"ufo-form-id-1"});</script><input type=\'text\' id=\'ufo-field-id-3318\' value=\'{id-3318}\' name=\'id-3318\' /></span><span class=\'ufo-cell-right\' id=\'ufo-cell-3318-2-right\'><div id=\'ufo-field-id-3318-invalid\'  style=\'display:none\'></div></span></div></div><div class=\'ufo-fieldtype-4 ufo-customform-row ufo-row-3319\' style=\'margin-top:2px;{display-3319}\'><div class=\'ufo-cell-3319-2-row\' id=\'ufo-cell-3319-2\'><span class=\'ufo-cell-left\' id=\'ufo-cell-3319-2-left\'><label for=\'ufo-field-id-3319\'  style=\'text-align:left\'>Last name<span class=\'ufo-customfields-required-suffix\'>*</span></label></span><span class=\'ufo-cell-center\' id=\'ufo-cell-3319-2-center\'><script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required"]},"Required":true,"RequiredMessage":"This field is required","AbsolutePosition":true,"RequiredMessagePosition":"right","id":"ufo-field-id-3319","form":"ufo-form-id-1"});</script><input type=\'text\' id=\'ufo-field-id-3319\' value=\'{id-3319}\' name=\'id-3319\' /></span><span class=\'ufo-cell-right\' id=\'ufo-cell-3319-2-right\'><div id=\'ufo-field-id-3319-invalid\'  style=\'display:none\'></div></span></div></div><div class=\'ufo-fieldtype-5 ufo-customform-row ufo-row-3320\' style=\'margin-top:2px;{display-3320}\'><div class=\'ufo-cell-3320-2-row\' id=\'ufo-cell-3320-2\'><span class=\'ufo-cell-left\' id=\'ufo-cell-3320-2-left\'><label for=\'ufo-field-id-3320\'  style=\'text-align:left\'>Email<span class=\'ufo-customfields-required-suffix\'>*</span></label></span><span class=\'ufo-cell-center\' id=\'ufo-cell-3320-2-center\'><script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required","email"]},"Required":true,"Validate":true,"RequiredMessage":"Please enter you email","AbsolutePosition":true,"RequiredMessagePosition":"right","id":"ufo-field-id-3320","form":"ufo-form-id-1"});</script><input type=\'text\' id=\'ufo-field-id-3320\' value=\'{id-3320}\' name=\'id-3320\' /></span><span class=\'ufo-cell-right\' id=\'ufo-cell-3320-2-right\'><div id=\'ufo-field-id-3320-invalid\'  style=\'display:none\'></div></span></div></div><div class=\'ufo-fieldtype-10 ufo-customform-row ufo-row-3321\' style=\'margin-top:2px;{display-3321}\'><div class=\'ufo-cell-3321-1-row\' id=\'ufo-cell-3321-1\'><span class=\'ufo-cell-center\' style=\'width:360px\' id=\'ufo-cell-3321-1-center\'><label for=\'ufo-field-id-3321\'  style=\'text-align:left\'>Your request<span class=\'ufo-customfields-required-suffix\'>*</span></label></span><span class=\'ufo-cell-right\' id=\'ufo-cell-3321-1-right\'><p style=\'display:none\'></p></span></div><div class=\'ufo-cell-3321-2-row\' id=\'ufo-cell-3321-2\'><span class=\'ufo-cell-center\' style=\'width:360px\' id=\'ufo-cell-3321-2-center\'><script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required"]},"Required":true,"RequiredMessage":"This field is required","AbsolutePosition":true,"RequiredMessagePosition":"right","id":"ufo-field-id-3321","form":"ufo-form-id-1"});</script><textarea id=\'ufo-field-id-3321\' name=\'id-3321\'  style=\'height:100px;width:360px\'>{id-3321}</textarea></span><span class=\'ufo-cell-right\' id=\'ufo-cell-3321-2-right\'><div id=\'ufo-field-id-3321-invalid\'  style=\'display:none\'></div></span></div></div><div class=\'ufo-fieldtype-6 ufo-customform-row ufo-row-3322\' style=\'margin-top:2px;{display-3322}\'><div class=\'ufo-cell-3322-2-row\' id=\'ufo-cell-3322-2\'><span class=\'ufo-cell-center\' id=\'ufo-cell-3322-2-center\'><script type=\'text/javascript\'>var c = {};c.id = \'ufo-field-id-3322\';c.form = \'ufo-form-id-1\';c.Label = \'Submit\';ufoFormsConfig.submits.push(c);</script><span id=\'ufo-field-id-3322-span\'><noscript><button type=\'submit\' id=\'ufo-field-id-3322\' name=\'id-3322\' >Submit</button></noscript></span></span></div></div></div><div id=\'ufo-form-id-1-message\'></div><noscript></form></noscript></div>', 'ShowSubmissionSuccess' => 1, 'WidthUnit' => 'px', 'LineHeight' => 2, 'LineHeightUnit' => 'px', 'Style' => 'easyform', 'TotalEntries' => 2, 'IncludeVisitorsAddressInReplyTo' => 0, 'SendConfirmationAsText' => 0, 'SendNotificationAsText' => 0, 'IncludeIntoReporting' => 1));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_customforms');
    $count = $wpdb->get_var('SELECT COUNT(*) FROM ' . $table_name . ';');
    if ($count == 0) {
        foreach ($rows as $row) {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('id' => 1, 'Description' => '2012-01-25', 'OptionGroup' => 'dateformats', 'Value' => 'Y-m-d^%Y-%m-%d^\\d{4}-\\d{2}-\\d{2}$^2012-01-25'), array('id' => 2, 'Description' => 'Y-m-d hh:mm', 'OptionGroup' => 'datetimeformats', 'Value' => 'Y-m-d H:i^%Y-%m-%d %H:%M^\\d{4}-\\d{1,2}-\\d{1,2}\\s\\d{1,2}:\\d{1,2}^Y-m-d hh:mm'), array('id' => 3, 'Description' => '01/25/2012', 'OptionGroup' => 'dateformats', 'Value' => 'm/d/Y^%m/%d/%Y^\\d{2}\\/\\d{2}\\/\\d{4}$^01/25/2012'), array('id' => 4, 'Description' => 'd.m.Y hh:mm', 'OptionGroup' => 'datetimeformats', 'Value' => 'd.m.Y H:i^%d.%m.%Y %H:%M^\\d{1,2}\\.\\d{1,2}\\.\\d{4}\\s\\d{1,2}:\\d{1,2}^d.m.Y hh:mm'), array('id' => 5, 'Description' => '25/01/2012', 'OptionGroup' => 'dateformats', 'Value' => 'd/m/Y^%d/%m/%Y^\\d{2}\\/\\d{2}\\/\\d{4}$^25/01/2012'), array('id' => 6, 'Description' => '25.01.2012', 'OptionGroup' => 'dateformats', 'Value' => 'd.m.Y^%d.%m.%Y^\\d{2}\\.\\d{2}\\.\\d{4}$^25.01.2012'), array('id' => 7, 'Description' => '25-01-2012', 'OptionGroup' => 'dateformats', 'Value' => 'd-m-Y^%d-%m-%Y^\\d{2}-\\d{2}-\\d{4}$^25-01-2012'));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_options');
    $existent = $wpdb->get_col('SELECT Description FROM ' . $table_name . ';');
    foreach ($rows as $row) {
        $rid = $row['Description'];
        if (!in_array($rid, $existent)) {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('objtype' => 'CustomFormEntryFiles', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Tasks', 'method' => 'viewDetailed', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ContactField2', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'TaskTypes', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ContactField1', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'OrderFiles', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'Products', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Files', 'method' => 'upload', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'OrderField1', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactField1', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'fixOrder', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoardView', 'method' => 'getDashboardAPIText', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'dismissPointer', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'OrderField1', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Users', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormFields', 'method' => 'addCustomField', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'OrderStatuses', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Orders_MailingLists', 'method' => 'view', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomForms', 'method' => 'add', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Locales', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'OrderField2', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'OrderStatuses', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ProductUnitTypes', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'val', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'setFormPageStatisticsShowOnDashboard', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'OrderField1', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactTypes', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ProductUnitTypes', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFields', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'OrderStatuses', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'getSettingsForm', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Tasks', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'Priorities', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomForms_MailingLists', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'val', 'name' => 'main', 'role' => 'Guest'), array('objtype' => 'CustomFields', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Users', 'method' => 'getUserASList', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Roles', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormsEntries', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'preview', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Options', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Roles', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ProductCategories', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Orders', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ApplicationSettings', 'method' => 'allowPBLink', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFieldTemplates', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFieldTypes', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFields', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoardView', 'method' => 'getFormStatistics', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoardView', 'method' => 'getFormPageStatistics', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'OrderField2', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomForms', 'method' => 'installTemplate', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms_MailingLists', 'method' => 'view', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Files', 'method' => 'download', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Templates', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Files', 'method' => 'deletefile', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ApplicationSettings', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFieldTypes', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'TaskStatuses', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ProductCategories', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomForms', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormsEntries', 'method' => 'processEntry', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Locales', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Products', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Orders_Products', 'method' => 'view', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ApplicationSettings', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactFiles', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'TaskStatuses', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Products', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Roles', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ContactFiles', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'moveFieldSet', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoardView', 'method' => 'getEntryStatistics', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Products', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoardView', 'method' => 'getUserStatistics', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'TaskTypes', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'installTemplate', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormFields', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ProductUnitTypes', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactTypes', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoardView', 'method' => 'getFormStatistics', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'TaskTypes', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'fixOrder', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Tasks', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormFields', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'OrderField2', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomForms', 'method' => 'resetStatistics', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'OrderFiles', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFieldTypes', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Users', 'method' => 'getUserASList', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'Users', 'method' => 'getEUserASList', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'getSettingsForm', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'getImage', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'AppTranslations', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Priorities', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'preview', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormFields', 'method' => 'moveFieldSet', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormFieldTypes', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'updateFieldData', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFieldValues', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomForms', 'method' => 'copy', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactFiles', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFields', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'getImage', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFields', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Orders_MailingLists', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactFiles', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Templates', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'DashBoardView', 'method' => 'getUserStatistics', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormFields', 'method' => 'deleteField', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ApplicationSettings', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ProductCategories', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'OrderFiles', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomForms', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'ProductCategories', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoardView', 'method' => 'getFormPageStatistics', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Orders', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Orders', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFieldTypes', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoardView', 'method' => 'getEntryStatistics', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ContactField1', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'copyField', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoardView', 'method' => 'getDashboardAPIText', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFieldTypes', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ApplicationSettings', 'method' => 'allowPBLink', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Orders', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoardView', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormsEntries', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactField1', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ApplicationSettings', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'add', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'AppTranslations', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactFiles', 'method' => 'viewDetailed', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormsEntries', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactField2', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Priorities', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'AppTranslations', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'OrderStatuses', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomForms', 'method' => 'refreshForm', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactField2', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Files', 'method' => 'upload', 'name' => 'main', 'role' => 'Guest'), array('objtype' => 'CustomForms', 'method' => 'add', 'name' => 'main', 'role' => 'Guest'), array('objtype' => 'OrderField2', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Priorities', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Tasks_MailingLists', 'method' => 'view', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'TaskStatuses', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ProductUnitTypes', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ContactFiles', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'setFormPageStatisticsShowOnDashboard', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactField2', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFieldValues', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryFiles', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'deleteField', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFieldValues', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFieldValues', 'method' => 'viewDetailed', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'TaskStatuses', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFieldValues', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'val', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Tasks_MailingLists', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'copy', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormFields', 'method' => 'updateFieldData', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormsEntries', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Users', 'method' => 'getEUserASList', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFieldValues', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'updateOrder', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'RemoteSites', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormEntryFiles', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Options', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'dismissPointer', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Roles', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Tasks', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryFiles', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Templates', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Files', 'method' => 'deletefile', 'name' => 'main', 'role' => 'Guest'), array('objtype' => 'Tasks', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'getAvailableTemplates', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Users', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryFiles', 'method' => 'viewDetailed', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ContactTypes', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Orders', 'method' => 'viewDetailed', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'TaskTypes', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'AppTranslations', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Templates', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Files', 'method' => 'upload', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'OrderField1', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormFields', 'method' => 'viewDetailed', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Files', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'viewDetailed', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ApplicationSettings', 'method' => 'setOptionValue', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomForms', 'method' => 'getAvailableTemplates', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormFields', 'method' => 'updateOrder', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFieldTemplates', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Options', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'OrderFiles', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'resetFormPageStatistics', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFieldTemplates', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ApplicationSettings', 'method' => 'setOptionValue', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Options', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'OrderFiles', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'copyField', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Tasks', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Users', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Products', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'Users', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormsEntries', 'method' => 'processEntry', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'ContactTypes', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'resetFormPageStatistics', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFormFields', 'method' => 'addCustomField', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Files', 'method' => 'download', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Files', 'method' => 'download', 'name' => 'main', 'role' => 'Guest'), array('objtype' => 'CustomFieldTypes', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomFieldTemplates', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Locales', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Orders_Products', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'OrderFiles', 'method' => 'viewDetailed', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Locales', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Orders', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryFiles', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'CustomForms', 'method' => 'refreshForm', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Files', 'method' => 'show', 'name' => 'main', 'role' => 'Owner'), array('objtype' => 'Files', 'method' => 'deletefile', 'name' => 'main', 'role' => 'SuperAdmin'));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_acl');
    $wpdb->query('DELETE FROM ' . $table_name . ' WHERE 1;');
    foreach ($rows as $row) {
        $wpdb->insert($table_name, $row);
    }
    $rows = array(array('id' => 1, 'Description' => 'Client', 'Notes' => 'Aliquam euismod tincidunt velit, in lobortis velit aliquam id. Morbi risus eros, fringilla et blandit at, semper sit amet magna.'), array('id' => 4, 'Description' => 'Employee', 'Notes' => 'Nulla tincidunt justo nec diam molestie feugiat. Aenean et est non sapien ultrices posuere id a odio.'));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_contacttypes');
    $count = $wpdb->get_var('SELECT COUNT(*) FROM ' . $table_name . ';');
    if ($count == 0) {
        foreach ($rows as $row) {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('id' => 1, 'Description' => 'Fieldset', 'CssClass' => 'ufo-customfield-fieldset', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Fieldset</Label><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>top</DescriptionPosition><DescriptionCSSClass>ufo-customfields-container-description</DescriptionCSSClass><DescriptionCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><AddCF>off</AddCF><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 100, 'ValueField' => 0), array('id' => 2, 'Description' => 'Section', 'CssClass' => 'ufo-customfield-section', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Section</Label><LabelTagName>h3</LabelTagName><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>top</DescriptionPosition><DescriptionCSSClass>ufo-customfields-container-description</DescriptionCSSClass><DescriptionCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><AddCF>off</AddCF><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 200, 'ValueField' => 0), array('id' => 3, 'Description' => 'Select', 'CssClass' => 'ufo-customfield-select', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Select</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetOptions>on</SetOptions><HasEmpty>off</HasEmpty><EmptyOption/><Options><option index="1">Option1</option><option index="2">Option2</option><option index="3">Option3</option></Options><Required>off</Required><RequiredMessage>This field is required</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 800, 'ValueField' => 1), array('id' => 4, 'Description' => 'Text', 'CssClass' => 'ufo-customfield-text', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Text</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetDefaultValue>off</SetDefaultValue><DefaultValue/><IsBlankValue>on</IsBlankValue><DefaultValueCSSClass/><Required>off</Required><RequiredMessage>This field is required</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>off</Validate><MinLength/><MaxLength/><SetValidMessage>off</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit><SetContactOptions>off</SetContactOptions><RegistredUsersOptions>none</RegistredUsersOptions><LinkToAppField/></form>', 'ListPosition' => 300, 'ValueField' => 1), array('id' => 5, 'Description' => 'Email', 'CssClass' => 'ufo-customfield-email', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Email</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetDefaultValue>off</SetDefaultValue><DefaultValue>Your email</DefaultValue><IsBlankValue>on</IsBlankValue><DefaultValueCSSClass/><Required>on</Required><RequiredMessage>Please enter your email</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>on</Validate><SetValidMessage>on</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit><SetContactOptions>off</SetContactOptions><RegistredUsersOptions>none</RegistredUsersOptions><LinkToAppField/></form>', 'ListPosition' => 500, 'ValueField' => 1), array('id' => 6, 'Description' => 'Submit button', 'CssClass' => 'ufo-customfield-submitbutton', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Submit</Label><InputPosition>left</InputPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><WindowScroll/><SetSize>off</SetSize><Width>100</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 1300, 'ValueField' => 0), array('id' => 9, 'Description' => 'Checkbox', 'CssClass' => 'ufo-customfield-checkbox', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Checkbox</Label><LabelPosition>right-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle>width:200px;</LabelCSSStyle><DisplayValueOn>on</DisplayValueOn><DisplayValueOff>off</DisplayValueOff><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><Required>off</Required><RequiredMessage>This field is required</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle>width:200px;</RequiredMessageCSSStyle><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>on</SetSize><Width>20</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 700, 'ValueField' => 1), array('id' => 10, 'Description' => 'Text Area', 'CssClass' => 'ufo-customfield-textarea', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Text Area</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetDefaultValue>off</SetDefaultValue><DefaultValue/><IsBlankValue>on</IsBlankValue><DefaultValueCSSClass/><Required>off</Required><RequiredMessage>This field is required</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>off</Validate><MinLength/><MaxLength/><SetValidMessage>off</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>on</SetSize><Width>230</Width><WidthUnit>px</WidthUnit><Height>100</Height><HeightUnit>px</HeightUnit></form>', 'ListPosition' => 400, 'ValueField' => 1), array('id' => 11, 'Description' => 'Number', 'CssClass' => 'ufo-customfield-number', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Number</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetDefaultValue>off</SetDefaultValue><DefaultValue/><IsBlankValue>on</IsBlankValue><DefaultValueCSSClass/><Required>on</Required><RequiredMessage>Please enter a valid number</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>on</Validate><SetValidMessage>on</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 600, 'ValueField' => 1), array('id' => 12, 'Description' => 'Radio Group', 'CssClass' => 'ufo-customfield-radiogroup', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Radio Group</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetOptions>on</SetOptions><Options><option index="1">Option1</option><option index="2">Option2</option><option index="3">Option3</option></Options><Required>off</Required><RequiredMessage>This field is required</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><SetStyle>on</SetStyle><CSSClass/><CSSStyle>float:left</CSSStyle><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 900, 'ValueField' => 1), array('id' => 13, 'Description' => 'reCaptcha', 'CssClass' => 'ufo-customfield-recaptcha', 'Settings' => '<form><ShowLabel>off</ShowLabel><Label>ReCaptcha</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><Required>off</Required><RequiredMessage>Please try again</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass>none</InvalidCSSClass><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>off</Validate><SetValidMessage>on</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>on</SetSize><Width>500</Width><WidthUnit>px</WidthUnit><SetReCaptchaOptions>off</SetReCaptchaOptions><ReCaptchaTheme>red</ReCaptchaTheme><ReCaptchaLanguage/><ReCaptchaPublicKey/><ReCaptchaPrivateKey/></form>', 'ListPosition' => 1100, 'ValueField' => 0), array('id' => 14, 'Description' => 'Hidden', 'CssClass' => 'ufo-customfield-hidden', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Last Name</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetDefaultValue>off</SetDefaultValue><DefaultValue/><IsBlankValue>on</IsBlankValue><DefaultValueCSSClass/><Required>off</Required><RequiredMessage>This field is required</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>off</Validate><MinLength/><MaxLength/><SetValidMessage>off</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 1000, 'ValueField' => 0), array('id' => 16, 'Description' => 'Phone Number', 'CssClass' => 'ufo-customfield-phonenumber', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Phone Number</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetDefaultValue>off</SetDefaultValue><DefaultValue/><IsBlankValue>on</IsBlankValue><DefaultValueCSSClass/><Required>on</Required><RequiredMessage>Please enter a valid phone number</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>on</Validate><SetValidMessage>on</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 650, 'ValueField' => 1), array('id' => 19, 'Description' => 'Text Paragraph', 'CssClass' => 'ufo-customfield-textparagraph', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Text Paragraph</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 450, 'ValueField' => 0), array('id' => 20, 'Description' => 'Google Map', 'CssClass' => 'ufo-customfield-googlemap', 'Settings' => '<form><GoolgeMapSettings>on</GoolgeMapSettings><Latitude/><Longitude/><Zoom>16</Zoom><ShowLabel>on</ShowLabel><Label>Google Map</Label><LabelPosition>top-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>top</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetStyle>off</SetStyle><CSSClass>ufo-google-map</CSSClass><CSSStyle/><RowCSSClass/><SetSize>on</SetSize><Width>400</Width><WidthUnit>px</WidthUnit><Height>500</Height><HeightUnit>px</HeightUnit></form>', 'ListPosition' => 950, 'ValueField' => 0), array('id' => 22, 'Description' => 'File Upload', 'CssClass' => 'ufo-customfield-fileupload', 'Settings' => '<form><FileSettings>on</FileSettings><ButtonText>Upload</ButtonText><UploadingText>Uploading...</UploadingText><OnlyAdminsCanDownload>on</OnlyAdminsCanDownload><AttachToConfirmation>off</AttachToConfirmation><AttachToNotification>off</AttachToNotification><ShowLabel>off</ShowLabel><Label>File Upload</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><Required>off</Required><RequiredMessage>Please select a file</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>off</Validate><SetValidMessage>on</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>on</SetStyle><CSSClass>ufo-frontendbutton blue</CSSClass><CSSStyle>width:130px;</CSSStyle><RowCSSClass/></form>', 'ListPosition' => 925, 'ValueField' => 1));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_customformfieldtypes');
    $existent = $wpdb->get_col('SELECT id FROM ' . $table_name . ';');
    foreach ($rows as $row) {
        $rid = $row['id'];
        if (in_array($rid, $existent)) {
            $wpdb->update($table_name, $row, array('id' => $rid));
        } else {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('id' => 1, 'Description' => 'AppSettings', 'TinyMCEConfig' => '{theme_advanced_buttons4:"",mode:"exact",theme_advanced_statusbar_location:"",theme_advanced_toolbar_align:"left",theme_advanced_resizing:"true",plugins:"fullscreen",theme_advanced_toolbar_location:"top",theme_advanced_buttons1:"bold,italic,underline,|,justifyleft,justifycenter,justifyright,justifyfull,|,formatselect,fontselect,fontsizeselect",theme_advanced_buttons2:"bullist,numlist,|,outdent,indent,|,undo,redo,|,link,unlink,anchor,image,cleanup,|,forecolor,backcolor,|,fullscreen",theme_advanced_buttons3:"",theme:"advanced", relative_urls : false, remove_script_host: false}', 'UseTinyMCE' => 1, 'ApplicationWidth' => 900, 'ApplicationWidth2' => 900, 'DefaultStyle' => 'std2', 'DefaultStyle2' => 'std2', 'NotLoggenInText' => 'Please log in.', 'FileFolder' => 'files', 'FixJSLoading' => 0, 'FixStatus0' => 0, 'ProductVersion' => '1.4.9', 'InitTime' => 0, 'ShowPoweredBy' => 0, 'DateFormat' => 'Y-m-d^%Y-%m-%d^\\d{4}-\\d{2}-\\d{2}$^2012-01-25', 'DateTimeFormat' => 'Y-m-d H:i^%Y-%m-%d %H:%M^\\d{4}-\\d{1,2}-\\d{1,2}\\s\\d{1,2}:\\d{1,2}^Y-m-d hh:mm', 'FixStatus02' => 0, 'w3cCompliant' => 0, 'w3cStyle' => 'easyform', 'FixJSLoading2' => 0, 'AllowMarkupInEntries' => 0, 'SkipWeeklyReport' => 0));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_applicationsettings');
    $count = $wpdb->get_var('SELECT COUNT(*) FROM ' . $table_name . ';');
    if ($count == 0) {
        foreach ($rows as $row) {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('id' => 1, 'Description' => 'SuperAdmin', 'Admin' => 0, 'Employee' => 0), array('id' => 2, 'Description' => 'Owner', 'Admin' => 0, 'Employee' => 0), array('id' => 4, 'Description' => 'Guest', 'Admin' => 0, 'Employee' => 0));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_roles');
    $count = $wpdb->get_var('SELECT COUNT(*) FROM ' . $table_name . ';');
    if ($count == 0) {
        foreach ($rows as $row) {
            $wpdb->insert($table_name, $row);
        }
    }
    require_once dirName(__FILE__) . DIRECTORY_SEPARATOR . 'easy-contact-forms-root.php';
    require_once dirName(__FILE__) . DIRECTORY_SEPARATOR . 'easy-contact-forms-applicationsettings.php';
    $as = EasyContactFormsApplicationSettings::getInstance();
    $as->set('ProductVersion', '1.4.9');
    $as->save();
}
?>
</label>
            <select id='<?php 
echo $obj->sId('Birthday');
?>
' class='ufo-select ufo-filtersign'>
              <?php 
echo $obj->sList('general');
?>
            </select>
            <div class='ufo-input-wrapper' style='width:108px'>
              <input type='text' id='Birthday' READONLY class='ufo-date datebox ufo-internal ufo-filtervalue'/>
              <a id='Birthday-Trigger' href='javascript:;' class='ufo-triggerbutton icon_trigger_calendar'>&nbsp;&nbsp;</a>
            </div>
            <input type='hidden' value='ufo.setupCalendar("Birthday", {ifFormat:"<?php 
echo EasyContactFormsApplicationSettings::getInstance()->getDateFormat('JS');
?>
", firstDay:0, align:"Bl", singleClick:true});' class='ufo-eval'/>
          </div>
          <div>
            <label for='<?php 
echo $obj->sId('Role');
?>
'><?php 
echo EasyContactFormsT::get('Role');
?>
</label>
            <select id='<?php 
echo $obj->sId('Role');
?>
' class='ufo-select ufo-filtersign'>
/**
 * 	Displays a EasyContactFormsUsers main view record
 *
 * @param object $view
 * 	the EasyContactFormsUsers main view object
 * @param object $obj
 * 	a db object
 * @param int $i
 * 	record index
 * @param array $map
 * 	request data
 */
function getUsersMainViewRow($view, $obj, $i, $map)
{
    $obj->Description = array();
    $obj->Description[] = $obj->get('Name');
    $obj->Description[] = $obj->get('Description');
    $obj->Description = EasyContactFormsUtils::vImplode(' ', $obj->Description);
    $usrname = EasyContactFormsDB::getValue("SELECT display_name  FROM #wp__users WHERE ID = '" . $obj->get('CMSId') . "'");
    if ($usrname) {
        $obj->CMSId = $usrname;
    } else {
        $obj->CMSId = '&nbsp;';
    }
    ?>
  <tr class='ufohighlight <?php 
    EasyContactFormsIHTML::getTrSwapClassName($i);
    ?>
'>
    <td class='firstcolumn'>
      <input type='checkbox' id='<?php 
    echo $view->idJoin('cb', $obj->getId());
    ?>
' value='off' class='ufo-deletecb' onchange='this.value=(this.checked)?"on":"off";'/>
    </td>
    <td>
      <?php 
    echo $obj->get('id');
    ?>
    </td>
    <td>
      <a id='<?php 
    echo $obj->elId('Description', $obj->getId());
    ?>
' class='ufo-id-link' onclick='ufo.redirect({m:"show", oid:"<?php 
    echo $obj->get('id');
    ?>
", t:"Users"})' onmouseover='ufo.showInfo({t:"Users", m2:"getUserASList", oid:<?php 
    echo $obj->get('id');
    ?>
, m:"ajaxsuggest"}, this)'>
        <?php 
    echo $obj->Description;
    ?>
      </a>
    </td>
    <td>
      <a onclick='ufo.redirect({m:"show", oid:"<?php 
    echo $obj->get('ContactType');
    ?>
", t:"ContactTypes"})'>
        <?php 
    echo $obj->get('ContactTypeDescription');
    ?>
      </a>
    </td>
    <td>
      <?php 
    EasyContactFormsIHTML::echoDate($obj->get('Birthday'), EasyContactFormsApplicationSettings::getInstance()->getDateFormat('PHP'), 0);
    ?>
    </td>
    <td>
      <?php 
    echo $obj->get('RoleDescription');
    ?>
    </td>
    <td>
      <?php 
    echo $obj->CMSId;
    ?>
    </td>
    <td>
      <?php 
    $a = $obj->get('email');
    if (!empty($a)) {
        ?>
        <a href='mailto:<?php 
        echo $a;
        ?>
'><?php 
        echo $a;
        ?>
</a>
      <?php 
    } else {
        echo '&nbsp;';
    }
    ?>
    </td>
  </tr>
	<?php 
}
Пример #10
0
 /**
  * 	getNotLoggedInHTML
  *
  * 	prints a 'please log in' string
  *
  *
  * @return string
  * 	html text
  */
 function getNotLoggedInHTML()
 {
     echo EasyContactFormsApplicationSettings::getInstance()->get('NotLoggenInText');
 }
 /**
  * 	getInstance
  *
  * 	Returns a single EasyContactFormsApplicationSettings instance
  *
  * @param  $showmessages
  * 
  *
  * @return object
  * 	the EasyContactFormsApplicationSettings instance
  */
 function getInstance($showmessages = TRUE)
 {
     static $obj;
     if (!isset($obj)) {
         $obj = new EasyContactFormsApplicationSettings();
         $obj->selectstmt = "SELECT id, UseTinyMCE, ApplicationWidth, ApplicationWidth2, FixJSLoading, FormCompletionMinTime, FormCompletionMaxTime, FixStatus0, InitTime, ShowPoweredBy, FixStatus02, w3cCompliant, FixJSLoading2, AllowMarkupInEntries, SkipWeeklyReport, FileFolder, ProductVersion, PhoneRegEx FROM " . $obj->getTableName() . " WHERE id = :id";
         $obj->fields = $obj->getObjectData(1);
         $needssave = FALSE;
         if ($obj->get('SecretWord') == '') {
             $obj->set('SecretWord', md5('mt=' . microtime()));
             $needssave = TRUE;
         }
         if ($obj->hasField('InitTime') && $obj->isEmpty('InitTime')) {
             $obj->set('InitTime', date(DATE_ATOM));
             $needssave = TRUE;
         }
         if ($obj->hasField('PhoneRegEx') && $obj->isEmpty('PhoneRegEx')) {
             $obj->set('PhoneRegEx', '(\\+{0,1}\\d{1,2})*\\s*(\\(?\\d{3}\\)?\\s*)*\\d{3}(-{0,1}|\\s{0,1})\\d{2}(-{0,1}|\\s{0,1})\\d{2}$');
             $needssave = TRUE;
         }
         if ($obj->hasField('FileFolder') && $obj->get('FileFolder') == '') {
             $obj->set('FileFolder', 'files');
             $needssave = TRUE;
         }
         if ($needssave) {
             $obj->save();
         }
     }
     if ($showmessages) {
         $obj->getLinkMessage();
     }
     return $obj;
 }
function easycontactforms_install_data()
{
    global $current_user, $wpdb;
    $userid = NULL;
    if (isset($current_user)) {
        $userid = $current_user->ID;
    }
    $adminemail = get_option('admin_email');
    $rows = array(array('id' => 254, 'Description' => 'Flores', 'Name' => 'Leroy', 'ContactType' => 1, 'Birthday' => 330213600, 'Role' => 4, 'Notes' => 'Suspendisse potenti.', 'email' => '*****@*****.**', 'email2' => '*****@*****.**', 'Cell' => '+11 222-7766', 'Phone1' => '+60 033-3993', 'Phone2' => '+37 744-4000', 'Phone3' => '+00 999-9977', 'ContactField3' => 'Fusce massa odio, aliquam ac ullamcorper congue, rutrum sed felis.', 'ContactField4' => 'In nunc purus, volutpat vitae pharetra non, mattis vel quam.', 'Country' => 'USA', 'Address' => '258 Bell Street', 'City' => 'New York', 'State' => 'NY', 'Zip' => '10031'), array('id' => 225, 'Description' => 'Admin', 'Name' => 'Admin', 'ContactType' => 4, 'Birthday' => 109202400, 'Role' => 1, 'CMSId' => $userid, 'email' => $adminemail), array('id' => 255, 'Description' => 'Jackson', 'Name' => 'Brian', 'ContactType' => 1, 'Birthday' => 297036000, 'Role' => 4, 'Notes' => 'Duis purus ipsum, consectetur quis scelerisque in, fringilla id nunc. In bibendum eros quis nulla tempus vitae iaculis ante euismod.', 'email' => '*****@*****.**', 'email2' => '*****@*****.**', 'Cell' => '+22 444-3322', 'Phone1' => '+55 115-5226', 'Phone2' => '+66 322-1228', 'Phone3' => '+80 014-4877', 'ContactField3' => 'Cras massa libero, laoreet non semper id, vulputate nec neque.', 'ContactField4' => 'Aliquam facilisis dolor id diam tempus sed vestibulum magna varius.', 'Country' => 'USA', 'Address' => '18 Filbert Street', 'City' => 'Ridley Park', 'State' => 'PA', 'Zip' => '19078'));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_users');
    $count = $wpdb->get_var('SELECT COUNT(*) FROM ' . $table_name . ';');
    if ($count == 0) {
        foreach ($rows as $row) {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('id' => 659, 'Description' => 'Last Name', 'Type' => 14, 'Settings' => '<?xml version="1.0"?>
<form><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetDefaultValue>off</SetDefaultValue><DefaultValue/><IsBlankValue>on</IsBlankValue><DefaultValueCSSClass/><Required>off</Required><RequiredMessage>This field is required</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>off</Validate><MinLength/><MaxLength/><SetValidMessage>off</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit><Label><![CDATA[Last Name]]></Label><ShowLabel><![CDATA[on]]></ShowLabel></form>', 'Template' => '<field>
      <ShowLabel position="left"><![CDATA[
   <label for=\'ufo-field-id-659\'  style=\'text-align:left\'>
     Last Name   </label>]]></ShowLabel>
            <Input ><![CDATA[<input type=\'text\' id=\'ufo-field-id-659\' value=\'{id-659}\' name=\'id-659\' >]]></Input>
</field>', 'ListPosition' => 639, 'CustomForms' => 2, 'FieldSet' => 622), array('id' => 622, 'Description' => 'Section', 'Type' => 2, 'Settings' => '<?xml version="1.0"?>
<form>
  
  
  <LabelTagName>h3</LabelTagName>
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  
  <Description/>
  
  
  <DescriptionCSSStyle/>
  
  <CSSClass/>
  
  
  <Width>230</Width>
  <WidthUnit>px</WidthUnit>
<DescriptionCSSClass><![CDATA[ufo-customfields-container-description]]></DescriptionCSSClass><DescriptionPosition><![CDATA[top-inside]]></DescriptionPosition><CSSStyle><![CDATA[]]></CSSStyle><SetStyle><![CDATA[off]]></SetStyle><SetSize><![CDATA[off]]></SetSize><ShowDescription><![CDATA[off]]></ShowDescription><ShowLabel><![CDATA[off]]></ShowLabel><AddCF>off</AddCF><Label><![CDATA[Section]]></Label></form>', 'Template' => '<field>
    <Container containertag="div" addcf="off"><![CDATA[<div>
     ]]></Container>
</field>', 'ListPosition' => 625, 'CustomForms' => 2, 'FieldSet' => 622), array('id' => 630, 'Description' => 'Submit', 'Type' => 6, 'Settings' => '<?xml version="1.0"?>
<form>
  
  
  
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  <SetStyle>off</SetStyle>
  <CSSClass/>
  <CSSStyle/>
  <RowCSSClass/>
  <SetSize>off</SetSize>
  <Width>100</Width>
  <WidthUnit>px</WidthUnit>
<Label><![CDATA[Submit]]></Label><InputPosition><![CDATA[left]]></InputPosition><ShowLabel><![CDATA[on]]></ShowLabel></form>', 'Template' => '<field><Validation><![CDATA[<script type=\'text/javascript\'>var c = {};c.id = \'ufo-field-id-630\';c.form = \'ufo-form-id-2\';c.Label = \'Submit\';ufoFormsConfig.submits.push(c);</script>]]></Validation><Input><![CDATA[<span id=\'ufo-field-id-630-span\'><noscript><button type=\'submit\' id=\'ufo-field-id-630\' name=\'id-630\' >Submit</button></noscript></span>]]></Input></field>', 'ListPosition' => 675, 'CustomForms' => 2, 'FieldSet' => 622), array('id' => 625, 'Description' => 'Email', 'Type' => 5, 'Settings' => '<?xml version="1.0"?>
<form>
  
  <Label>Email</Label>
  
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  <ShowDescription>off</ShowDescription>
  <Description/>
  <DescriptionPosition>bottom</DescriptionPosition>
  <DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass>
  <DescriptionCSSStyle/>
  <SetDefaultValue>off</SetDefaultValue>
  <DefaultValue>Your email</DefaultValue>
  <IsBlankValue>on</IsBlankValue>
  <DefaultValueCSSClass/>
  <Required>on</Required>
  <RequiredMessage>Please enter you email</RequiredMessage>
  
  <SetRequiredSuffix>on</SetRequiredSuffix>
  <RequiredSuffix>*</RequiredSuffix>
  <RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass>
  <RequiredSuffixCSSStyle/>
  
  <InvalidCSSClass/>
  <RequiredMessageCSSClass/>
  <RequiredMessageCSSStyle/>
  <Validate>on</Validate>
  
  <ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition>
  <ValidMessage/>
  <ValidMessagePosition>right</ValidMessagePosition>
  <ValidCSSClass/>
  <ValidCSSStyle/>
  <SetStyle>off</SetStyle>
  <CSSClass/>
  <CSSStyle/>
  <RowCSSClass/>
  <SetSize>off</SetSize>
  <Width>230</Width>
  <WidthUnit>px</WidthUnit>
  
  
  
<LinkToAppField><![CDATA[Users_email]]></LinkToAppField><SetValidMessage><![CDATA[on]]></SetValidMessage><AbsolutePosition><![CDATA[on]]></AbsolutePosition><SetContactOptions><![CDATA[on]]></SetContactOptions><LabelPosition><![CDATA[left-align-left]]></LabelPosition><RequiredMessagePosition><![CDATA[right]]></RequiredMessagePosition><RegistredUsersOptions><![CDATA[showfill]]></RegistredUsersOptions><ShowLabel><![CDATA[on]]></ShowLabel></form>', 'Template' => '<field><ShowLabel position="left"><![CDATA[<label for=\'ufo-field-id-625\'  style=\'text-align:left\'>Email<span class=\'ufo-customfields-required-suffix\'>*</span></label>]]></ShowLabel><RequiredMessage position="right"><![CDATA[<div id=\'ufo-field-id-625-invalid\'  style=\'display:none\'></div>]]></RequiredMessage><ValidMessage position="right"><![CDATA[<div id=\'ufo-field-id-625-valid\'  style=\'display:none\'></div>]]></ValidMessage><Validation><![CDATA[<script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required","email"]},"Required":true,"Validate":true,"showValid":true,"ValidMessageAbsolutePosition":true,"ValidMessagePosition":"right","RequiredMessage":"Please enter you email","AbsolutePosition":true,"RequiredMessagePosition":"right","id":"ufo-field-id-625","form":"ufo-form-id-2"});</script>]]></Validation><Input ><![CDATA[<input type=\'text\' id=\'ufo-field-id-625\' value=\'{id-625}\' name=\'id-625\' >]]></Input></field>', 'ListPosition' => 648, 'CustomForms' => 2, 'FieldSet' => 622), array('id' => 647, 'Description' => 'Last name', 'Type' => 4, 'Settings' => '<?xml version="1.0"?>
<form>
  
  
  <LabelPosition>left-align-left</LabelPosition>
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  <ShowDescription>off</ShowDescription>
  <Description/>
  <DescriptionPosition>bottom</DescriptionPosition>
  <DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass>
  <DescriptionCSSStyle/>
  <SetDefaultValue>off</SetDefaultValue>
  <DefaultValue/>
  <IsBlankValue>on</IsBlankValue>
  <DefaultValueCSSClass/>
  
  
  
  <SetRequiredSuffix>on</SetRequiredSuffix>
  <RequiredSuffix>*</RequiredSuffix>
  <RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass>
  <RequiredSuffixCSSStyle/>
  
  <InvalidCSSClass/>
  <RequiredMessageCSSClass/>
  <RequiredMessageCSSStyle/>
  
  
  
  
  <ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition>
  <ValidMessage/>
  <ValidMessagePosition>right</ValidMessagePosition>
  <ValidCSSClass/>
  <ValidCSSStyle/>
  <SetStyle>off</SetStyle>
  <CSSClass/>
  <CSSStyle/>
  <RowCSSClass/>
  <SetSize>off</SetSize>
  <Width>230</Width>
  <WidthUnit>px</WidthUnit>
  
  
  
<Label><![CDATA[Last name]]></Label><Required><![CDATA[on]]></Required><Validate><![CDATA[on]]></Validate><SetValidMessage><![CDATA[on]]></SetValidMessage><AbsolutePosition><![CDATA[on]]></AbsolutePosition><LinkToAppField><![CDATA[Users_Description]]></LinkToAppField><SetContactOptions><![CDATA[on]]></SetContactOptions><MinLength><![CDATA[2]]></MinLength><MaxLength><![CDATA[45]]></MaxLength><RequiredMessage><![CDATA[Your last name is required (from 2 to 45 characters)]]></RequiredMessage><RequiredMessagePosition><![CDATA[right]]></RequiredMessagePosition><RegistredUsersOptions><![CDATA[showfill]]></RegistredUsersOptions><ShowLabel><![CDATA[on]]></ShowLabel></form>', 'Template' => '<field>
      <ShowLabel position="left"><![CDATA[
   <label for=\'ufo-field-id-647\'  style=\'text-align:left\'>
     Last name         <span class=\'ufo-customfields-required-suffix\'>
           *         </span>
            </label>]]></ShowLabel>
          <RequiredMessage position="right"><![CDATA[<div id=\'ufo-field-id-647-invalid\'  style=\'display:none\'></div>]]></RequiredMessage>
        <ValidMessage position="right"><![CDATA[<div id=\'ufo-field-id-647-valid\'  style=\'display:none\'>
        </div>]]></ValidMessage>
        <Validation><![CDATA[<script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required","minmax"]},"Required":true,"Validate":true,"showValid":true,"ValidMessageAbsolutePosition":true,"ValidMessagePosition":"right","RequiredMessage":"Your last name is required (from 2 to 45 characters)","AbsolutePosition":true,"RequiredMessagePosition":"right","min":"2","max":"45","id":"ufo-field-id-647","form":"ufo-form-id-2"});</script>]]></Validation>
    <Input ><![CDATA[<input type=\'text\' id=\'ufo-field-id-647\' value=\'{id-647}\' name=\'id-647\' >]]></Input>
</field>', 'ListPosition' => 647, 'CustomForms' => 2, 'FieldSet' => 622), array('id' => 627, 'Description' => 'First name', 'Type' => 4, 'Settings' => '<?xml version="1.0"?>
<form>
  
  
  
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  <ShowDescription>off</ShowDescription>
  <Description/>
  <DescriptionPosition>bottom</DescriptionPosition>
  <DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass>
  <DescriptionCSSStyle/>
  <SetDefaultValue>off</SetDefaultValue>
  <DefaultValue/>
  <IsBlankValue>on</IsBlankValue>
  <DefaultValueCSSClass/>
  
  
  
  <SetRequiredSuffix>on</SetRequiredSuffix>
  <RequiredSuffix>*</RequiredSuffix>
  <RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass>
  <RequiredSuffixCSSStyle/>
  
  <InvalidCSSClass/>
  <RequiredMessageCSSClass/>
  <RequiredMessageCSSStyle/>
  
  
  
  
  <ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition>
  <ValidMessage/>
  <ValidMessagePosition>right</ValidMessagePosition>
  <ValidCSSClass/>
  <ValidCSSStyle/>
  <SetStyle>off</SetStyle>
  <CSSClass/>
  <CSSStyle/>
  <RowCSSClass/>
  <SetSize>off</SetSize>
  <Width>230</Width>
  <WidthUnit>px</WidthUnit>
  
  
  
<Required><![CDATA[on]]></Required><Validate><![CDATA[on]]></Validate><LinkToAppField><![CDATA[Users_Name]]></LinkToAppField><Label><![CDATA[First name]]></Label><SetValidMessage><![CDATA[on]]></SetValidMessage><AbsolutePosition><![CDATA[on]]></AbsolutePosition><SetContactOptions><![CDATA[on]]></SetContactOptions><MinLength><![CDATA[2]]></MinLength><MaxLength><![CDATA[45]]></MaxLength><RequiredMessagePosition><![CDATA[right]]></RequiredMessagePosition><RequiredMessage><![CDATA[Your first name is required (from 2 to 45 characters)]]></RequiredMessage><LabelPosition><![CDATA[left-align-left]]></LabelPosition><RegistredUsersOptions><![CDATA[showfill]]></RegistredUsersOptions><ShowLabel><![CDATA[on]]></ShowLabel></form>', 'Template' => '<field>
      <ShowLabel position="left"><![CDATA[
   <label for=\'ufo-field-id-627\'  style=\'text-align:left\'>
     First name         <span class=\'ufo-customfields-required-suffix\'>
           *         </span>
            </label>]]></ShowLabel>
          <RequiredMessage position="right"><![CDATA[<div id=\'ufo-field-id-627-invalid\'  style=\'display:none\'></div>]]></RequiredMessage>
        <ValidMessage position="right"><![CDATA[<div id=\'ufo-field-id-627-valid\'  style=\'display:none\'>
        </div>]]></ValidMessage>
        <Validation><![CDATA[<script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required","minmax"]},"Required":true,"Validate":true,"showValid":true,"ValidMessageAbsolutePosition":true,"ValidMessagePosition":"right","RequiredMessage":"Your first name is required (from 2 to 45 characters)","AbsolutePosition":true,"RequiredMessagePosition":"right","min":"2","max":"45","id":"ufo-field-id-627","form":"ufo-form-id-2"});</script>]]></Validation>
    <Input ><![CDATA[<input type=\'text\' id=\'ufo-field-id-627\' value=\'{id-627}\' name=\'id-627\' >]]></Input>
</field>', 'ListPosition' => 643, 'CustomForms' => 2, 'FieldSet' => 622), array('id' => 648, 'Description' => 'Your request', 'Type' => 10, 'Settings' => '<?xml version="1.0"?>
<form>
  
  
  
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  
  
  
  <DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass>
  <DescriptionCSSStyle/>
  <SetDefaultValue>off</SetDefaultValue>
  <DefaultValue/>
  <IsBlankValue>on</IsBlankValue>
  <DefaultValueCSSClass/>
  
  <RequiredMessage>This field is required</RequiredMessage>
  <RequiredMessagePosition>right</RequiredMessagePosition>
  <SetRequiredSuffix>on</SetRequiredSuffix>
  <RequiredSuffix>*</RequiredSuffix>
  <RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass>
  <RequiredSuffixCSSStyle/>
  <AbsolutePosition>on</AbsolutePosition>
  <InvalidCSSClass/>
  <RequiredMessageCSSClass/>
  <RequiredMessageCSSStyle/>
  <Validate>off</Validate>
  <MinLength/>
  <MaxLength/>
  <SetValidMessage>off</SetValidMessage>
  <ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition>
  <ValidMessage/>
  <ValidMessagePosition>right</ValidMessagePosition>
  <ValidCSSClass/>
  <ValidCSSStyle/>
  <SetStyle>off</SetStyle>
  <CSSClass/>
  <CSSStyle/>
  <RowCSSClass/>
  
  
  <WidthUnit>px</WidthUnit>
  
  <HeightUnit>px</HeightUnit>
<Label><![CDATA[Your request]]></Label><Description><![CDATA[Please provide us with your request details]]></Description><DescriptionPosition><![CDATA[top]]></DescriptionPosition><Required><![CDATA[on]]></Required><SetSize><![CDATA[on]]></SetSize><LabelPosition><![CDATA[top-align-left]]></LabelPosition><ShowDescription><![CDATA[off]]></ShowDescription><Height><![CDATA[150]]></Height><Width><![CDATA[360]]></Width><ShowLabel><![CDATA[on]]></ShowLabel></form>', 'Template' => '<field><ShowLabel position="top"><![CDATA[<label for=\'ufo-field-id-648\'  style=\'text-align:left\'>Your request<span class=\'ufo-customfields-required-suffix\'>*</span></label>]]></ShowLabel><RequiredMessage position="right"><![CDATA[<div id=\'ufo-field-id-648-invalid\'  style=\'display:none\'></div>]]></RequiredMessage><Validation><![CDATA[<script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required"]},"Required":true,"RequiredMessage":"This field is required","AbsolutePosition":true,"RequiredMessagePosition":"right","id":"ufo-field-id-648","form":"ufo-form-id-2"});</script>]]></Validation><Input  width="360px"><![CDATA[<textarea id=\'ufo-field-id-648\' name=\'id-648\'  style=\'height:150px;width:360px\'>{id-648}</textarea>]]></Input></field>', 'ListPosition' => 660, 'CustomForms' => 2, 'FieldSet' => 622), array('id' => 675, 'Description' => 'Please fill in the fields below', 'Type' => 2, 'Settings' => '<?xml version="1.0"?>
<form>
  
  
  <LabelTagName>h3</LabelTagName>
  <Advanced/>
  <LabelCSSClass/>
  <LabelCSSStyle/>
  <ShowDescription>off</ShowDescription>
  <Description/>
  <DescriptionPosition>top</DescriptionPosition>
  <DescriptionCSSClass>ufo-customfields-container-description</DescriptionCSSClass>
  <DescriptionCSSStyle/>
  <SetStyle>off</SetStyle>
  <CSSClass/>
  <CSSStyle/>
  <AddCF>off</AddCF>
  <SetSize>off</SetSize>
  <Width>230</Width>
  <WidthUnit>px</WidthUnit>
<ShowLabel><![CDATA[off]]></ShowLabel><Label><![CDATA[Please fill in the fields below]]></Label></form>', 'Template' => '<field><Container containertag="div" addcf="off"><![CDATA[<div>]]></Container></field>', 'ListPosition' => 624, 'CustomForms' => 2, 'FieldSet' => 675));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_customformfields');
    $count = $wpdb->get_var('SELECT COUNT(*) FROM ' . $table_name . ';');
    if ($count == 0) {
        foreach ($rows as $row) {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('id' => 2, 'Description' => 'Contact form', 'NotificationSubject' => 'New request received', 'SendFrom' => 'Champion Forms', 'SendConfirmation' => 0, 'ConfirmationSubject' => 'We have received your request', 'Redirect' => 0, 'ShortCode' => '[champion_forms fid=2]', 'Template' => 0, 'ObjectOwner' => 225, 'SubmissionSuccessText' => 'Thank you for contacting us! We are glad to hear from you.', 'HTML' => '<script type=\'text/javascript\'>if (typeof(ecfconfig) == \'undefined\'){var ecfconfig={};}ecfconfig[2]={};var ufobaseurl =  \'http://192.168.1.100/wordpress-3.3/wp-admin/admin-ajax.php\';if (typeof(ufoFormsConfig) == \'undefined\') {var ufoFormsConfig = {};ufoFormsConfig.submits = [];ufoFormsConfig.resets = [];ufoFormsConfig.validations = [];}ufoFormsConfig.phonenumberre = /^(\\+{0,1}\\d{1,2})*\\s*(\\(?\\d{3}\\)?\\s*)*\\d{3}(-{0,1}|\\s{0,1})\\d{2}(-{0,1}|\\s{0,1})\\d{2}$/;</script><link href=\'http://192.168.1.100/wordpress-3.3/wp-content/plugins/champion-forms/forms/styles/easyform/css/std.css?ver=1.5\' rel=\'stylesheet\' type=\'text/css\'/><style>.ufo-row-659{display:none;}</style><div class=\'ufo-form\' id=\'ufo-form-id-2\'><noscript><form method=\'POST\'><input type=\'hidden\' name=\'cf-no-script\' value=\'1\'></noscript><input type=\'hidden\' value=\'ufo-form-id-2\' name=\'hidden-2\' id=\'ufo-form-hidden-2\'><input type=\'hidden\' value=\'{__pagename}\' name=\'ufo-form-pagename\' id=\'ufo-form-pagename\'>{preview}<input type=\'hidden\' value=\'{ufosignature}\' name=\'ufo-sign\' id=\'ufo-sign\'><div></div><div>
     <div class=\'ufo-fieldtype-14 ufo-customform-row ufo-row-659\' style=\'margin-top:2px;{display-659}\'><div class=\'ufo-cell-659-2-row\' id=\'ufo-cell-659-2\'><span class=\'ufo-cell-left\' id=\'ufo-cell-659-2-left\'>
   <label for=\'ufo-field-id-659\'  style=\'text-align:left\'>
     Last Name   </label></span><span class=\'ufo-cell-center\' id=\'ufo-cell-659-2-center\'><input type=\'text\' id=\'ufo-field-id-659\' value=\'{id-659}\' name=\'id-659\' ></span></div></div><div class=\'ufo-fieldtype-4 ufo-customform-row ufo-row-627\' style=\'margin-top:2px;{display-627}\'><div class=\'ufo-cell-627-2-row\' id=\'ufo-cell-627-2\'><span class=\'ufo-cell-left\' id=\'ufo-cell-627-2-left\'>
   <label for=\'ufo-field-id-627\'  style=\'text-align:left\'>
     First name         <span class=\'ufo-customfields-required-suffix\'>
           *         </span>
            </label></span><span class=\'ufo-cell-center\' id=\'ufo-cell-627-2-center\'><script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required","minmax"]},"Required":true,"Validate":true,"showValid":true,"ValidMessageAbsolutePosition":true,"ValidMessagePosition":"right","RequiredMessage":"Your first name is required (from 2 to 45 characters)","AbsolutePosition":true,"RequiredMessagePosition":"right","min":"2","max":"45","id":"ufo-field-id-627","form":"ufo-form-id-2"});</script><input type=\'text\' id=\'ufo-field-id-627\' value=\'{id-627}\' name=\'id-627\' ></span><span class=\'ufo-cell-right\' id=\'ufo-cell-627-2-right\'><div id=\'ufo-field-id-627-invalid\'  style=\'display:none\'></div><div id=\'ufo-field-id-627-valid\'  style=\'display:none\'>
        </div></span></div></div><div class=\'ufo-fieldtype-4 ufo-customform-row ufo-row-647\' style=\'margin-top:2px;{display-647}\'><div class=\'ufo-cell-647-2-row\' id=\'ufo-cell-647-2\'><span class=\'ufo-cell-left\' id=\'ufo-cell-647-2-left\'>
   <label for=\'ufo-field-id-647\'  style=\'text-align:left\'>
     Last name         <span class=\'ufo-customfields-required-suffix\'>
           *         </span>
            </label></span><span class=\'ufo-cell-center\' id=\'ufo-cell-647-2-center\'><script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required","minmax"]},"Required":true,"Validate":true,"showValid":true,"ValidMessageAbsolutePosition":true,"ValidMessagePosition":"right","RequiredMessage":"Your last name is required (from 2 to 45 characters)","AbsolutePosition":true,"RequiredMessagePosition":"right","min":"2","max":"45","id":"ufo-field-id-647","form":"ufo-form-id-2"});</script><input type=\'text\' id=\'ufo-field-id-647\' value=\'{id-647}\' name=\'id-647\' ></span><span class=\'ufo-cell-right\' id=\'ufo-cell-647-2-right\'><div id=\'ufo-field-id-647-invalid\'  style=\'display:none\'></div><div id=\'ufo-field-id-647-valid\'  style=\'display:none\'>
        </div></span></div></div><div class=\'ufo-fieldtype-5 ufo-customform-row ufo-row-625\' style=\'margin-top:2px;{display-625}\'><div class=\'ufo-cell-625-2-row\' id=\'ufo-cell-625-2\'><span class=\'ufo-cell-left\' id=\'ufo-cell-625-2-left\'><label for=\'ufo-field-id-625\'  style=\'text-align:left\'>Email<span class=\'ufo-customfields-required-suffix\'>*</span></label></span><span class=\'ufo-cell-center\' id=\'ufo-cell-625-2-center\'><script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required","email"]},"Required":true,"Validate":true,"showValid":true,"ValidMessageAbsolutePosition":true,"ValidMessagePosition":"right","RequiredMessage":"Please enter you email","AbsolutePosition":true,"RequiredMessagePosition":"right","id":"ufo-field-id-625","form":"ufo-form-id-2"});</script><input type=\'text\' id=\'ufo-field-id-625\' value=\'{id-625}\' name=\'id-625\' ></span><span class=\'ufo-cell-right\' id=\'ufo-cell-625-2-right\'><div id=\'ufo-field-id-625-invalid\'  style=\'display:none\'></div><div id=\'ufo-field-id-625-valid\'  style=\'display:none\'></div></span></div></div><div class=\'ufo-fieldtype-10 ufo-customform-row ufo-row-648\' style=\'margin-top:2px;{display-648}\'><div class=\'ufo-cell-648-1-row\' id=\'ufo-cell-648-1\'><span class=\'ufo-cell-center\' style=\'width:360px\' id=\'ufo-cell-648-1-center\'><label for=\'ufo-field-id-648\'  style=\'text-align:left\'>Your request<span class=\'ufo-customfields-required-suffix\'>*</span></label></span><span class=\'ufo-cell-right\' id=\'ufo-cell-648-1-right\'><p style=\'display:none\'></p></span></div><div class=\'ufo-cell-648-2-row\' id=\'ufo-cell-648-2\'><span class=\'ufo-cell-center\' style=\'width:360px\' id=\'ufo-cell-648-2-center\'><script type=\'text/javascript\'>ufoFormsConfig.validations.push({"events":{"blur":["required"]},"Required":true,"RequiredMessage":"This field is required","AbsolutePosition":true,"RequiredMessagePosition":"right","id":"ufo-field-id-648","form":"ufo-form-id-2"});</script><textarea id=\'ufo-field-id-648\' name=\'id-648\'  style=\'height:150px;width:360px\'>{id-648}</textarea></span><span class=\'ufo-cell-right\' id=\'ufo-cell-648-2-right\'><div id=\'ufo-field-id-648-invalid\'  style=\'display:none\'></div></span></div></div><div class=\'ufo-fieldtype-6 ufo-customform-row ufo-row-630\' style=\'margin-top:2px;{display-630}\'><div class=\'ufo-cell-630-2-row\' id=\'ufo-cell-630-2\'><span class=\'ufo-cell-center\' id=\'ufo-cell-630-2-center\'><script type=\'text/javascript\'>var c = {};c.id = \'ufo-field-id-630\';c.form = \'ufo-form-id-2\';c.Label = \'Submit\';ufoFormsConfig.submits.push(c);</script><span id=\'ufo-field-id-630-span\'><noscript><button type=\'submit\' id=\'ufo-field-id-630\' name=\'id-630\' >Submit</button></noscript></span></span></div></div></div><div id=\'ufo-form-id-2-message\'></div><noscript></form></noscript></div>', 'ShowSubmissionSuccess' => 1, 'WidthUnit' => 'px', 'LineHeight' => 2, 'LineHeightUnit' => 'px', 'Style' => 'easyform', 'IncludeVisitorsAddressInReplyTo' => 1, 'SendConfirmationAsText' => 0, 'SendNotificationAsText' => 0, 'IncludeIntoReporting' => 1));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_customforms');
    $count = $wpdb->get_var('SELECT COUNT(*) FROM ' . $table_name . ';');
    if ($count == 0) {
        foreach ($rows as $row) {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('id' => 1, 'Description' => 'Client', 'Notes' => 'Maecenas eget lectus ut odio mattis fringilla. Nunc sem leo, interdum id euismod sit amet, varius vel lorem. Nam quis augue a lectus ultrices suscipit a facilisis lacus. Morbi at nisl sit amet nunc porttitor posuere id id risus. Vestibulum eget enim ornare augue venenatis placerat sed vitae mi. Nam elit justo, tincidunt id venenatis et, ullamcorper non tellus. Phasellus quis lorem tortor. <br /><br />Praesent ut facilisis odio. Maecenas congue neque ut nisi placerat vitae suscipit mauris fermentum. Praesent non sem tincidunt odio placerat tincidunt. Nulla gravida lectus sed urna mollis lacinia. Ut egestas viverra volutpat. Vestibulum quis nunc erat. Donec faucibus magna at quam condimentum convallis lobortis ante aliquet. Mauris tempor, ipsum a sollicitudin molestie, orci dui laoreet nulla, non accumsan erat libero a nisl. Quisque id luctus enim. Pellentesque id purus odio. Sed cursus pharetra enim eget tempor.'), array('id' => 4, 'Description' => 'Employee', 'Notes' => 'Suspendisse potenti. <br /><br />Lorem ipsum dolor sit amet, consectetur adipiscing elit. In sagittis tincidunt tortor, non bibendum risus lobortis ac. Fusce at eros sed dolor aliquam vestibulum. Mauris eget ante sapien. Donec eu justo ac purus consectetur faucibus. Nullam consectetur scelerisque massa et scelerisque. Ut a eros justo, et pellentesque felis. Duis at mi erat, nec dapibus nulla. Nam laoreet, eros et tempor convallis, arcu ante fermentum eros, sit amet luctus tellus lorem id nisi. Phasellus tempus, tortor et lacinia fringilla, magna metus dignissim dolor, vel vulputate purus massa non turpis.'));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_contacttypes');
    $count = $wpdb->get_var('SELECT COUNT(*) FROM ' . $table_name . ';');
    if ($count == 0) {
        foreach ($rows as $row) {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('id' => 3, 'Description' => 'Select', 'CssClass' => 'ufo-customfield-select', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Select</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetOptions>on</SetOptions><HasEmpty>off</HasEmpty><EmptyOption/><Options><option index="1">Option1</option><option index="2">Option2</option><option index="3">Option3</option></Options><Required>off</Required><RequiredMessage>This field is required</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 800, 'ValueField' => 1), array('id' => 4, 'Description' => 'Text', 'CssClass' => 'ufo-customfield-text', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Text</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetDefaultValue>off</SetDefaultValue><DefaultValue/><IsBlankValue>on</IsBlankValue><DefaultValueCSSClass/><Required>off</Required><RequiredMessage>This field is required</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>off</Validate><MinLength/><MaxLength/><SetValidMessage>off</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit><SetContactOptions>off</SetContactOptions><RegistredUsersOptions>none</RegistredUsersOptions><LinkToAppField/></form>', 'ListPosition' => 300, 'ValueField' => 1), array('id' => 5, 'Description' => 'Email', 'CssClass' => 'ufo-customfield-email', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Email</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetDefaultValue>off</SetDefaultValue><DefaultValue>Your email</DefaultValue><IsBlankValue>on</IsBlankValue><DefaultValueCSSClass/><Required>on</Required><RequiredMessage>Please enter your email</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>on</Validate><SetValidMessage>on</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit><SetContactOptions>off</SetContactOptions><RegistredUsersOptions>none</RegistredUsersOptions><LinkToAppField/></form>', 'ListPosition' => 500, 'ValueField' => 1), array('id' => 6, 'Description' => 'Submit button', 'CssClass' => 'ufo-customfield-submitbutton', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Submit</Label><InputPosition>left</InputPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><WindowScroll/><SetSize>off</SetSize><Width>100</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 1300, 'ValueField' => 0), array('id' => 10, 'Description' => 'Text Area', 'CssClass' => 'ufo-customfield-textarea', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Text Area</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetDefaultValue>off</SetDefaultValue><DefaultValue/><IsBlankValue>on</IsBlankValue><DefaultValueCSSClass/><Required>off</Required><RequiredMessage>This field is required</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>off</Validate><MinLength/><MaxLength/><SetValidMessage>off</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>on</SetSize><Width>230</Width><WidthUnit>px</WidthUnit><Height>100</Height><HeightUnit>px</HeightUnit></form>', 'ListPosition' => 400, 'ValueField' => 1), array('id' => 11, 'Description' => 'Number', 'CssClass' => 'ufo-customfield-number', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Number</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetDefaultValue>off</SetDefaultValue><DefaultValue/><IsBlankValue>on</IsBlankValue><DefaultValueCSSClass/><Required>on</Required><RequiredMessage>Please enter a valid number</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>on</Validate><SetValidMessage>on</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 600, 'ValueField' => 1), array('id' => 12, 'Description' => 'Radio Group', 'CssClass' => 'ufo-customfield-radiogroup', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Radio Group</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetOptions>on</SetOptions><Options><option index="1">Option1</option><option index="2">Option2</option><option index="3">Option3</option></Options><Required>off</Required><RequiredMessage>This field is required</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><SetStyle>on</SetStyle><CSSClass/><CSSStyle>float:left</CSSStyle><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 900, 'ValueField' => 1), array('id' => 9, 'Description' => 'Checkbox', 'CssClass' => 'ufo-customfield-checkbox', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Checkbox</Label><LabelPosition>right-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle>width:200px;</LabelCSSStyle><DisplayValueOn>on</DisplayValueOn><DisplayValueOff>off</DisplayValueOff><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><Required>off</Required><RequiredMessage>This field is required</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle>width:200px;</RequiredMessageCSSStyle><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>on</SetSize><Width>20</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 700, 'ValueField' => 1), array('id' => 13, 'Description' => 'reCaptcha', 'CssClass' => 'ufo-customfield-recaptcha', 'Settings' => '<form><ShowLabel>off</ShowLabel><Label>ReCaptcha</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><Required>off</Required><RequiredMessage>Please try again</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass>none</InvalidCSSClass><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>off</Validate><SetValidMessage>on</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>on</SetSize><Width>500</Width><WidthUnit>px</WidthUnit><SetReCaptchaOptions>off</SetReCaptchaOptions><ReCaptchaTheme>red</ReCaptchaTheme><ReCaptchaLanguage/><ReCaptchaPublicKey/><ReCaptchaPrivateKey/></form>', 'ListPosition' => 1100, 'ValueField' => 0), array('id' => 14, 'Description' => 'Hidden', 'CssClass' => 'ufo-customfield-hidden', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Last Name</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetDefaultValue>off</SetDefaultValue><DefaultValue/><IsBlankValue>on</IsBlankValue><DefaultValueCSSClass/><Required>off</Required><RequiredMessage>This field is required</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>off</Validate><MinLength/><MaxLength/><SetValidMessage>off</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 1000, 'ValueField' => 0), array('id' => 16, 'Description' => 'Phone Number', 'CssClass' => 'ufo-customfield-phonenumber', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Phone Number</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetDefaultValue>off</SetDefaultValue><DefaultValue/><IsBlankValue>on</IsBlankValue><DefaultValueCSSClass/><Required>on</Required><RequiredMessage>Please enter a valid phone number</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>on</Validate><SetValidMessage>on</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><RowCSSClass/><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 650, 'ValueField' => 1), array('id' => 17, 'Description' => 'Meeting Scheduler', 'CssClass' => 'ufo-customfield-meetingscheduler', 'Settings' => '<form><SetVCitaOptions>on</SetVCitaOptions><ShowLabel>on</ShowLabel><Label>Schedule a meeting with us</Label><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><Advanced/><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><SetStyle>on</SetStyle><CSSClass>ufo-frontendbutton blue</CSSClass><CSSStyle/><RowCSSClass/><UseLink>off</UseLink></form>', 'ListPosition' => 1250, 'ValueField' => 0), array('id' => 22, 'Description' => 'File Upload', 'CssClass' => 'ufo-customfield-fileupload', 'Settings' => '<form><FileSettings>on</FileSettings><ButtonText>Upload</ButtonText><UploadingText>Uploading...</UploadingText><OnlyAdminsCanDownload>on</OnlyAdminsCanDownload><AttachToConfirmation>off</AttachToConfirmation><AttachToNotification>off</AttachToNotification><ShowLabel>off</ShowLabel><Label>File Upload</Label><LabelPosition>left-align-left</LabelPosition><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>bottom</DescriptionPosition><DescriptionCSSClass>ufo-customfields-field-description</DescriptionCSSClass><DescriptionCSSStyle/><Required>off</Required><RequiredMessage>Please select a file</RequiredMessage><RequiredMessagePosition>right</RequiredMessagePosition><SetRequiredSuffix>on</SetRequiredSuffix><RequiredSuffix>*</RequiredSuffix><RequiredSuffixCSSClass>ufo-customfields-required-suffix</RequiredSuffixCSSClass><RequiredSuffixCSSStyle/><AbsolutePosition>on</AbsolutePosition><InvalidCSSClass/><RequiredMessageCSSClass/><RequiredMessageCSSStyle/><Validate>off</Validate><SetValidMessage>on</SetValidMessage><ValidMessageAbsolutePosition>on</ValidMessageAbsolutePosition><ValidMessage/><ValidMessagePosition>right</ValidMessagePosition><ValidCSSClass/><ValidCSSStyle/><SetStyle>on</SetStyle><CSSClass>ufo-frontendbutton blue</CSSClass><CSSStyle>width:130px;</CSSStyle><RowCSSClass/></form>', 'ListPosition' => 925, 'ValueField' => 1), array('id' => 1, 'Description' => 'Fieldset', 'CssClass' => 'ufo-customfield-fieldset', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Fieldset</Label><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>top</DescriptionPosition><DescriptionCSSClass>ufo-customfields-container-description</DescriptionCSSClass><DescriptionCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><AddCF>off</AddCF><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 100, 'ValueField' => 0), array('id' => 2, 'Description' => 'Section', 'CssClass' => 'ufo-customfield-section', 'Settings' => '<form><ShowLabel>on</ShowLabel><Label>Section</Label><LabelTagName>h3</LabelTagName><Advanced/><LabelCSSClass/><LabelCSSStyle/><ShowDescription>off</ShowDescription><Description/><DescriptionPosition>top</DescriptionPosition><DescriptionCSSClass>ufo-customfields-container-description</DescriptionCSSClass><DescriptionCSSStyle/><SetStyle>off</SetStyle><CSSClass/><CSSStyle/><AddCF>off</AddCF><SetSize>off</SetSize><Width>230</Width><WidthUnit>px</WidthUnit></form>', 'ListPosition' => 200, 'ValueField' => 0));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_customformfieldtypes');
    $existent = $wpdb->get_col('SELECT id FROM ' . $table_name . ';');
    foreach ($rows as $row) {
        $rid = $row['id'];
        if (in_array($rid, $existent)) {
            $wpdb->update($table_name, $row, array('id' => $rid));
        } else {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('objtype' => 'CustomForms', 'method' => 'val', 'name' => 'main', 'role' => 'Guest'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'deleteField', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ApplicationSettings', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Files', 'method' => 'deletefile', 'name' => 'main', 'role' => 'Guest'), array('objtype' => 'CustomFormsEntries', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms_MailingLists', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'updateFieldData', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoard', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'add', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryFiles', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoard', 'method' => 'getFormPageStatistics', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormsEntries', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactTypes', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'val', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactTypes', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'moveFieldSet', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Files', 'method' => 'download', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'refreshForm', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'preview', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'setFormPageStatisticsShowOnDashboard', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Files', 'method' => 'download', 'name' => 'main', 'role' => 'Guest'), array('objtype' => 'Files', 'method' => 'upload', 'name' => 'main', 'role' => 'Guest'), array('objtype' => 'DashBoard', 'method' => 'getUserStatistics', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'resetFormPageStatistics', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Files', 'method' => 'upload', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryStatistics', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Users', 'method' => 'getEUserASList', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormEntryFiles', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormsEntries', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'updateOrder', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'copyField', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormsEntries', 'method' => 'processEntry', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'addCustomField', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoard', 'method' => 'getFormStatistics', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'getSettingsForm', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Users', 'method' => 'view', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'DashBoard', 'method' => 'getEntryStatistics', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomFormFields', 'method' => 'viewDetailed', 'name' => 'detailedMain', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'add', 'name' => 'main', 'role' => 'Guest'), array('objtype' => 'Users', 'method' => 'getUserASList', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ApplicationSettings', 'method' => 'allowPBLink', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Users', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Users', 'method' => 'show', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'resetStatistics', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ApplicationSettings', 'method' => 'setOptionValue', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'Files', 'method' => 'deletefile', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'CustomForms', 'method' => 'copy', 'name' => 'main', 'role' => 'SuperAdmin'), array('objtype' => 'ContactTypes', 'method' => 'new', 'name' => 'main', 'role' => 'SuperAdmin'));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_acl');
    $wpdb->query('DELETE FROM ' . $table_name . ' WHERE 1;');
    foreach ($rows as $row) {
        $wpdb->insert($table_name, $row);
    }
    $rows = array(array('id' => 1, 'Description' => 'AppSettings', 'TinyMCEConfig' => '{theme_advanced_buttons4:"",mode:"exact",theme_advanced_statusbar_location:"",theme_advanced_toolbar_align:"left",theme_advanced_resizing:"true",plugins:"fullscreen",theme_advanced_toolbar_location:"top",theme_advanced_buttons1:"bold,italic,underline,|,justifyleft,justifycenter,justifyright,justifyfull,|,formatselect,fontselect,fontsizeselect",theme_advanced_buttons2:"bullist,numlist,|,outdent,indent,|,undo,redo,|,link,unlink,anchor,image,cleanup,|,forecolor,backcolor,|,fullscreen",theme_advanced_buttons3:"",theme:"advanced", relative_urls : false, remove_script_host: false}', 'UseTinyMCE' => 1, 'ApplicationWidth' => 900, 'ApplicationWidth2' => 900, 'DefaultStyle' => 'std2', 'DefaultStyle2' => 'std2', 'NotLoggenInText' => 'Please log in.', 'FileFolder' => 'files', 'FixJSLoading' => 0, 'FixStatus0' => 0, 'DateFormat' => 'Y-m-d^%Y-%m-%d^\\d{4}-\\d{2}-\\d{2}$^2012-01-25', 'DateTimeFormat' => 'Y-m-d H:i^%Y-%m-%d %H:%M^\\d{4}-\\d{1,2}-\\d{1,2}\\s\\d{1,2}:\\d{1,2}^Y-m-d hh:mm', 'ShowPoweredBy' => 0));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_applicationsettings');
    $count = $wpdb->get_var('SELECT COUNT(*) FROM ' . $table_name . ';');
    if ($count == 0) {
        foreach ($rows as $row) {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('id' => 1, 'Description' => '2012-01-25', 'Value' => 'Y-m-d^%Y-%m-%d^\\d{4}-\\d{2}-\\d{2}$^2012-01-25', 'OptionGroup' => 'dateformats'), array('id' => 2, 'Description' => 'Y-m-d hh:mm', 'Value' => 'Y-m-d H:i^%Y-%m-%d %H:%M^\\d{4}-\\d{1,2}-\\d{1,2}\\s\\d{1,2}:\\d{1,2}^Y-m-d hh:mm', 'OptionGroup' => 'datetimeformats'), array('id' => 3, 'Description' => '01/25/2012', 'Value' => 'm/d/Y^%m/%d/%Y^\\d{2}\\/\\d{2}\\/\\d{4}$^01/25/2012', 'OptionGroup' => 'dateformats'), array('id' => 4, 'Description' => 'd.m.Y hh:mm', 'Value' => 'd.m.Y H:i^%d.%m.%Y %H:%M^\\d{1,2}\\.\\d{1,2}\\.\\d{4}\\s\\d{1,2}:\\d{1,2}^d.m.Y hh:mm', 'OptionGroup' => 'datetimeformats'), array('id' => 5, 'Description' => '25/01/2012', 'Value' => 'd/m/Y^%d/%m/%Y^\\d{2}\\/\\d{2}\\/\\d{4}$^25/01/2012', 'OptionGroup' => 'dateformats'), array('id' => 6, 'Description' => '25.01.2012', 'Value' => 'd.m.Y^%d.%m.%Y^\\d{2}\\.\\d{2}\\.\\d{4}$^25.01.2012', 'OptionGroup' => 'dateformats'), array('id' => 7, 'Description' => '25-01-2012', 'Value' => 'd-m-Y^%d-%m-%Y^\\d{2}-\\d{2}-\\d{4}$^25-01-2012', 'OptionGroup' => 'dateformats'));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_options');
    $existent = $wpdb->get_col('SELECT Description FROM ' . $table_name . ';');
    foreach ($rows as $row) {
        $rid = $row['Description'];
        if (!in_array($rid, $existent)) {
            $wpdb->insert($table_name, $row);
        }
    }
    $rows = array(array('id' => 1, 'Description' => 'SuperAdmin', 'Admin' => 0, 'Employee' => 0), array('id' => 4, 'Description' => 'Guest', 'Admin' => 0, 'Employee' => 0));
    $table_name = EasyContactFormsDB::wptn('#wp__easycontactforms_roles');
    $wpdb->query('DELETE FROM ' . $table_name . ' WHERE 1;');
    foreach ($rows as $row) {
        $wpdb->insert($table_name, $row);
    }
    require_once dirName(__FILE__) . DIRECTORY_SEPARATOR . 'easy-contact-forms-root.php';
    require_once dirName(__FILE__) . DIRECTORY_SEPARATOR . 'easy-contact-forms-applicationsettings.php';
    $as = EasyContactFormsApplicationSettings::getInstance();
    $as->set('ProductVersion', '1.4.2');
    $as->save();
}
 /**
  * 	formatComment
  *
  * 	returns a formatted comment
  *
  * @param int $comment
  * 	old object status
  * @param array $request
  * 	request data
  *
  * @return string
  * 	the formatted comment
  */
 function formatComment($comment, $request)
 {
     $as = EasyContactFormsApplicationSettings::getInstance();
     if (!$as->get('UseTinyMCE')) {
         $comment = nl2br(htmlspecialchars($comment));
     }
     $lastname = '';
     $name = '';
     if (isset($this->user)) {
         $userid = $this->user->id;
         $users = EasyContactFormsClassLoader::getObject('Users');
         $lastname = $users->getValue('Description', $userid);
         $name = $users->getValue('Name', $userid);
         $this->_userName = trim("{$name} {$lastname}");
     }
     $date = date($as->getDateFormat('PHP', TRUE));
     return "\n\t\t\t\t<div class='ufo-div-comment'>\n\t\t\t\t\t<div class='ufo-div-comment-header'>\n\t\t\t\t\t\t{$name}&nbsp;{$lastname}\n\t\t\t\t\t\t<br />\n\t\t\t\t\t\t<span>\n\t\t\t\t\t\t\t{$date}\n\t\t\t\t\t\t</span>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class='ufo-div-comment-comment'>\n\t\t\t\t\t\t{$comment}\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<div class='ufo-clear-both'></div>\n\t\t\t\t";
 }
 /**
  * 	send
  *
  * 	sends a message
  *
  * @param object $message
  * 	a message to send
  * @param array $emaillist
  * 	a mainling list
  * @param object $sender
  * 	sender data
  * @param string $email
  * 	custom email address to use instead of default
  * @param  $attachments
  * 
  */
 function send($message, $emaillist, $sender, $email = '', $attachments = array())
 {
     if ($email == '') {
         $email = EasyContactFormsApplicationSettings::getInstance()->get('SendFrom');
     }
     if ($email == '') {
         $email = $sender->email;
     }
     $headers = $email != '' ? "From: {$sender->name} <{$email}>\r\n" : '';
     if (isset($message->replyto)) {
         $headers .= 'Reply-to: ';
         if (isset($message->replyto->name)) {
             $headers .= $message->replyto->name;
         }
         if (isset($message->replyto->email)) {
             $headeremail = $message->replyto->email;
             $headers .= "<{$headeremail}>";
         }
         $headers .= "\n";
     }
     if ($message->ishtml) {
         add_filter('wp_mail_content_type', create_function('', 'return "text/html"; '));
     } else {
         add_filter('wp_mail_content_type', create_function('', 'return "text/plain"; '));
     }
     global $easycontactforms_request;
     $easycontactforms_request->attachment = $attachments;
     wp_mail($emaillist, $message->subject, $message->body, $headers);
 }
DEFINE('EASYCONTACTFORMS__prodVersion', '1.4.2');
$ds = DIRECTORY_SEPARATOR;
/**
 * A file system application root
 */
DEFINE('EASYCONTACTFORMS__APPLICATION_DIR', dirName(__FILE__));
/**
 * A session data root directory
 */
DEFINE('EASYCONTACTFORMS__SESSION_DIR', EASYCONTACTFORMS__APPLICATION_DIR);
/**
 * A web application root
 */
DEFINE('EASYCONTACTFORMS__engineRoot', admin_url('admin-ajax.php') . '?action=easy-contact-forms-submit');
/**
 * file folder subdir name
 */
DEFINE('EASYCONTACTFORMS__fileFolder', EasyContactFormsApplicationSettings::getInstance()->get('FileFolder'));
/**
 * A directory to store regular files and direct access files(images)
 */
DEFINE('EASYCONTACTFORMS__fileUploadDir', ABSPATH . 'wp-content/plugins/easycontact_templates' . $ds . EASYCONTACTFORMS__fileFolder);
$base = get_bloginfo('wpurl');
$base = rtrim($base, '/');
if (!defined('EASYCONTACTFORMS__APPLICATION_ROOT')) {
    DEFINE('EASYCONTACTFORMS__APPLICATION_ROOT', $base);
}
if (!defined('EASYCONTACTFORMS__FILE_DONWLOAD')) {
    DEFINE('EASYCONTACTFORMS__FILE_DONWLOAD', EASYCONTACTFORMS__APPLICATION_ROOT . '/wp-content/plugins/easycontact_templates');
}
DEFINE('EASYCONTACTFORMS__notLoggenInRedirect', '<script>document.location.href="index.php"</script>');
Пример #16
0
 class='ufo-formvalue ufo-customform-fieldform-fieldset-cb' onchange='this.value=(this.checked)?"on":"off";'/></div><div><label for='AttachToNotification'><?php 
echo EasyContactFormsT::get('CF_AttachToNotification');
?>
<span id='AttachToNotificationHin' class='ufo-settingsform-label-hint ufo-label-hint ufo-id-link'>[<a>?</a>]</span></label><input type='hidden' id='AttachToNotificationHint' value='<?php 
echo EasyContactFormsT::get('CF_Hint_AttachToNotification');
?>
' class='ufo-id-link'/><input type='checkbox' id='AttachToNotification' value='<?php 
echo isset($AttachToNotification) && $AttachToNotification == 'on' ? 'on' : 'off';
?>
' <?php 
echo isset($AttachToNotification) && $AttachToNotification == 'on' ? 'checked' : '';
?>
 class='ufo-formvalue ufo-customform-fieldform-fieldset-cb' onchange='this.value=(this.checked)?"on":"off";'/></div><?php 
if (!is_dir(EASYCONTACTFORMS__fileUploadDir)) {
    EasyContactFormsUtils::createFolder(EASYCONTACTFORMS__fileUploadDir);
    $as = EasyContactFormsApplicationSettings::getInstance();
    $as->showMessages();
}
?>
</div></div><div id='ufo-customform-settings-showlabel-fieldset' class='ufo-customform-fieldform-fieldset ufo-id-link'><div class='ufo-customform-fieldform-fieldset-legend'><span id='ufo-customform-settings-showlabel-expander' class='ufo-customform-fieldform-fieldset-expander ufo-id-link' onclick='ufoCf.expanderClick(this.id, "ufo-customform-settings-showlabel");'>&nbsp;</span><input type='hidden' id='ShowLabelHint' value='<?php 
echo EasyContactFormsT::get('CF_Hint_ShowLabel');
?>
' class='ufo-id-link'/><div><input type='checkbox' id='ShowLabel' value='<?php 
echo isset($ShowLabel) && $ShowLabel == 'on' ? 'on' : 'off';
?>
' <?php 
echo isset($ShowLabel) && $ShowLabel == 'on' ? 'checked' : '';
?>
 class='ufo-formvalue ufo-customform-fieldform-fieldset-cb' onchange='this.value=(this.checked)?"on":"off";'/><label for='ShowLabel' style='width:auto;font-family:Arial;clear:none;display:inline;margin:0;float:none;font-size:12px;padding:0;line-height:16px'><?php 
echo EasyContactFormsT::get('CF_ShowLabel');
?>
Пример #17
0
 /**
  * 	update. Overrides EasyContactFormsBase::update()
  *
  * 	updates an object with request data
  *
  * @param array $request
  * 	request data
  * @param int $id
  * 	object id
  */
 function update($request, $id)
 {
     $query = "SELECT\n\t\t\t\tUsers.Role,\n\t\t\t\tUsers.CMSId\n\t\t\tFROM\n\t\t\t\t#wp__easycontactforms_users AS Users\n\t\t\tWHERE\n\t\t\t\tUsers.id='{$id}'";
     $objs = EasyContactFormsDB::getObjects($query);
     $usr = $objs[0];
     global $current_user;
     $currentadmin = $usr->Role == 1 && isset($request->Role) && isset($current_user) && $current_user->ID == $usr->CMSId;
     if ($currentadmin) {
         $as = EasyContactFormsApplicationSettings::getInstance();
         $as->addMessage(EasyContactFormsT::get('CannotChangeCurrentUserRole'));
         $request->Role = 1;
     }
     $request = EasyContactFormsUtils::parseRequest($request, 'ContactType', 'int');
     $request = EasyContactFormsUtils::parseRequest($request, 'Birthday', 'date');
     $request = EasyContactFormsUtils::parseRequest($request, 'Role', 'int');
     $request = EasyContactFormsUtils::parseRequest($request, 'CMSId', 'int');
     parent::update($request, $id);
 }
Пример #18
0
 /**
  * 	createFolder
  *
  * 	creates a folder
  *
  * @param string $targdir
  * 	a folder to created
  */
 function createFolder($targdir)
 {
     $ds = DIRECTORY_SEPARATOR;
     $dirs = explode($ds, $targdir);
     $path = '';
     $as = EasyContactFormsApplicationSettings::getInstance();
     foreach ($dirs as $subdir) {
         $path .= $subdir . '/';
         if (!is_dir($path)) {
             if (!@mkdir($path)) {
                 if (class_exists('EasyContactFormsT')) {
                     $as->addMessage(EasyContactFormsT::get('CannotCreateFolder') . ' ' . $path, 'ufo-message-error');
                 }
                 return FALSE;
             }
             if (!($handle = @fopen($path . 'index.html', 'w'))) {
                 if (class_exists('EasyContactFormsT')) {
                     $as->addMessage(EasyContactFormsT::get('CannotWriteToFile') . ' ' . $path . 'index.html', 'ufo-message-error');
                 }
                 return FALSE;
             }
             if (@fwrite($handle, '<body></body>') === FALSE) {
                 fclose($handle);
                 if (class_exists('EasyContactFormsT')) {
                     $as->addMessage(EasyContactFormsT::get('CannotWriteToFile') . ' ' . $path . 'index.html', 'ufo-message-error');
                 }
                 return FALSE;
             }
             fclose($handle);
         }
     }
 }
Пример #19
0
/**
 * 	Easy Contact Forms entrypoint
 *
 */
function easycontactforms_entrypoint()
{
    $l_locale = get_locale();
    $map = $_REQUEST;
    if (!defined('EASYCONTACTFORMS__APPLICATION_ROOT')) {
        DEFINE('EASYCONTACTFORMS__APPLICATION_ROOT', rtrim(get_bloginfo('wpurl'), '/'));
    }
    if (!defined('EASYCONTACTFORMS__engineWebAppDirectory')) {
        DEFINE('EASYCONTACTFORMS__engineWebAppDirectory', plugins_url('', __FILE__));
    }
    if (!defined('_EASYCONTACTFORMS_PLUGIN_PATH')) {
        DEFINE('_EASYCONTACTFORMS_PLUGIN_PATH', rtrim(plugin_dir_path(__FILE__), "/\\"));
    }
    $tag = strtolower(str_replace('_', '-', $l_locale));
    $map['l'] = $tag;
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . DIRECTORY_SEPARATOR . 'easy-contact-forms-strings.php';
    if (!@(include_once _EASYCONTACTFORMS_PLUGIN_PATH . DIRECTORY_SEPARATOR . 'easy-contact-forms-resources_' . $tag . '.php')) {
        require_once _EASYCONTACTFORMS_PLUGIN_PATH . DIRECTORY_SEPARATOR . 'easy-contact-forms-resources_en-gb.php';
        $map['l'] = 'en-gb';
    }
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . DIRECTORY_SEPARATOR . 'easy-contact-forms-utils.php';
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . DIRECTORY_SEPARATOR . 'easy-contact-forms-database.php';
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . DIRECTORY_SEPARATOR . 'easy-contact-forms-root.php';
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . DIRECTORY_SEPARATOR . 'easy-contact-forms-applicationsettings.php';
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . DIRECTORY_SEPARATOR . 'easy-contact-forms-appconfigdata.php';
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . DIRECTORY_SEPARATOR . 'easy-contact-forms-securitymanager.php';
    global $current_user;
    $userid = $current_user->ID;
    unset($map['frid']);
    $map['frid'] = $userid;
    if (isset($map['ac']) && $map['ac'] == '1') {
        EasyContactFormsRoot::ajaxCall($map);
        die;
    }
    $map = EasyContactFormsSecurityManager::getRights($map);
    if (isset($map['m']) && $map['m'] == 'download') {
        EasyContactFormsRoot::download($map);
        die;
    }
    if (!isset($map['m'])) {
        $map['m'] = 'show';
    }
    if (!isset($map['t'])) {
        $map['t'] = 'DashBoardView';
    }
    wp_enqueue_script('jquery');
    wp_enqueue_script('jquery-ui-core');
    wp_enqueue_script('jquery-ui-widget');
    wp_enqueue_script('jquery-ui-mouse');
    wp_enqueue_script('jquery-ui-sortable');
    wp_enqueue_style('easy-contact-forms-admin-ui-css', 'http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.1/themes/smoothness/jquery-ui.css', false, '1.4.9', false);
    wp_enqueue_script('jquery-ui-draggable');
    wp_enqueue_script('jquery-ui-position');
    wp_enqueue_script('jquery-ui-resizable');
    wp_enqueue_script('jquery-ui-dialog');
    wp_enqueue_script('json-json', plugins_url('js/json.js', __FILE__));
    wp_enqueue_script('easy-contact-forms-html', plugins_url('easy-contact-formshtml.1.4.9.js', __FILE__));
    wp_enqueue_script('jqui-scrollto', plugins_url('js/jqui/scrollto.js', __FILE__));
    wp_enqueue_script('js-as', plugins_url('js/as.js', __FILE__));
    wp_enqueue_script('calendar-stripped', plugins_url('js/calendar/calendar_stripped.js', __FILE__));
    wp_enqueue_script('calendar-setup-stripped', plugins_url('js/calendar/calendar-setup_stripped.js', __FILE__));
    wp_enqueue_script('calendar-lang-en', plugins_url('js/calendar/lang/calendar-en.js', __FILE__));
    wp_enqueue_script('js-as', plugins_url('js/as.js', __FILE__));
    if (EasyContactFormsApplicationSettings::getInstance()->get('UseTinyMCE')) {
        wp_enqueue_script('tiny_mce', plugins_url('js/tinymce/tiny_mce.js', __FILE__));
    }
    $js = "config = {};";
    $js .= "config.url='" . admin_url('admin-ajax.php') . "';";
    $js .= "config.phonenumberre=/^" . EasyContactFormsApplicationSettings::getInstance()->get('PhoneRegEx') . "/;";
    $js .= "config.initial = {t:'" . $map['t'] . "', m:'" . $map['m'] . "'};";
    $js .= "config.bodyid = 'divEasyContactForms';";
    $js .= "config.resources = {};";
    $js .= "config.resources['EmailFormatIsExpected'] = " . json_encode(EasyContactFormsT::get('EmailFormatIsExpected')) . ";";
    $js .= "config.resources['ValueLengthShouldBeBetween'] = " . json_encode(EasyContactFormsT::get('ValueLengthShouldBeBetween')) . ";";
    $js .= "config.resources['ValueLengthShouldBeMoreThan'] = " . json_encode(EasyContactFormsT::get('ValueLengthShouldBeMoreThan')) . ";";
    $js .= "config.resources['ValueLengthShouldBeLessThan'] = " . json_encode(EasyContactFormsT::get('ValueLengthShouldBeLessThan')) . ";";
    $js .= "config.resources['ThisIsAPhoneNumber'] = " . json_encode(EasyContactFormsT::get('ThisIsAPhoneNumber')) . ";";
    $js .= "config.resources['ThisIsAnIntegerField'] = " . json_encode(EasyContactFormsT::get('ThisIsAnIntegerField')) . ";";
    $js .= "config.resources['ThisFieldIsRequired'] = " . json_encode(EasyContactFormsT::get('ThisFieldIsRequired')) . ";";
    $js .= "config.resources['ThisIsAFieldOfCurrencyFormat'] = " . json_encode(EasyContactFormsT::get('ThisIsAFieldOfCurrencyFormat')) . ";";
    $js .= "config.resources['ItwillDeleteRecordsAreYouSure'] = " . json_encode(EasyContactFormsT::get('ItwillDeleteRecordsAreYouSure')) . ";";
    $js .= "config.resources['NoRecordsSelected'] = " . json_encode(EasyContactFormsT::get('NoRecordsSelected')) . ";";
    $js .= "config.resources['CloseFilter'] = " . json_encode(EasyContactFormsT::get('CloseFilter')) . ";";
    $js .= "config.resources['Search'] = " . json_encode(EasyContactFormsT::get('Search')) . ";";
    $js .= "config.resources['NoResults'] = " . json_encode(EasyContactFormsT::get('NoResults')) . ";";
    $js .= "config.resources['Uploading'] = " . json_encode(EasyContactFormsT::get('Uploading')) . ";";
    $js .= "config.resources['Upload'] = " . json_encode(EasyContactFormsT::get('Upload')) . ";";
    $js .= "config.resources['ItWillReorderFieldsets'] = " . json_encode(EasyContactFormsT::get('ItWillReorderFieldsets')) . ";";
    $js .= "config.resources['CF_Pin'] = " . json_encode(EasyContactFormsT::get('CF_Pin')) . ";";
    $js .= "config.resources['CF_UnPin'] = " . json_encode(EasyContactFormsT::get('CF_UnPin')) . ";";
    $js .= "var appManConfig = config;";
    echo "<link href='" . EASYCONTACTFORMS__engineWebAppDirectory . '/js/calendar/css/calendar-system.css' . "' rel='stylesheet' type='text/css'/>";
    if (function_exists('is_admin')) {
        $paramName = is_admin() ? 'DefaultStyle2' : 'DefaultStyle';
        $styleName = EasyContactFormsApplicationSettings::getInstance()->get($paramName);
        $paramName = is_admin() ? 'ApplicationWidth2' : 'ApplicationWidth';
        $appWidth = EasyContactFormsApplicationSettings::getInstance()->get($paramName);
    } else {
        $styleName = EASYCONTACTFORMS__DEFAULT_STYLE;
        $appWidth = EasyContactFormsApplicationSettings::getInstance()->get('ApplicationWidth');
    }
    $wrStyle = 'style=\'width:' . $appWidth . 'px\'';
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . DIRECTORY_SEPARATOR . 'styles' . DIRECTORY_SEPARATOR . $styleName . DIRECTORY_SEPARATOR . 'easy-contact-forms-getstyle.php';
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . DIRECTORY_SEPARATOR . 'easy-contact-forms-menu.php';
    echo "<div id='ufo-app-wrapper' {$wrStyle}>";
    EasyContactFormsMenu::getMenu($map);
    echo "<div id='divEasyContactForms'>";
    echo "<script>{$js}</script>";
    echo EasyContactFormsRoot::processRequest($map);
    echo "</div>";
    echo "</div>";
}
 /**
  * 	update. Overrides EasyContactFormsBase::update()
  *
  * 	updates an object with request data
  *
  * @param array $request
  * 	request data
  * @param int $id
  * 	object id
  */
 function update($request, $id)
 {
     $query = "SELECT\n\t\t\t\tUsers.Role,\n\t\t\t\tUsers.CMSId\n\t\t\tFROM\n\t\t\t\t#wp__easycontactforms_users AS Users\n\t\t\tWHERE\n\t\t\t\tUsers.id='{$id}'";
     $objs = EasyContactFormsDB::getObjects($query);
     $usr = $objs[0];
     global $current_user;
     $currentadmin = $usr->Role == 1 && isset($request->Role) && isset($current_user) && $current_user->ID == $usr->CMSId;
     if ($currentadmin) {
         $as = EasyContactFormsApplicationSettings::getInstance();
         $as->addMessage(EasyContactFormsT::get('CannotChangeCurrentUserRole'));
         $request->Role = 1;
     }
     $request = EasyContactFormsUtils::parseRequest($request, 'ContactType', 'int');
     $request = EasyContactFormsUtils::parseRequest($request, 'Birthday', 'date');
     $request = EasyContactFormsUtils::parseRequest($request, 'Role', 'int');
     $request = EasyContactFormsUtils::parseRequest($request, 'CMSId', 'int');
     if (isset($this->user)) {
         require_once 'easy-contact-forms-backoffice.php';
         $bo = new EasyContactFormsBackOffice();
         $request = $bo->processHistory($request, $this->type, $id, $this->user->id);
     }
     parent::update($request, $id);
 }
        <span class='mandatoryast'>*</span>
      </label>
      <input type='text' id='Description' value='<?php 
echo $obj->get('Description');
?>
' class='textinput ufo-text ufo-formvalue' style='width:100%'/>
      <input type='hidden' value='var c = {};c.id = "Description";c.events = {};c.events.blur = [];c.minmax={};c.minmax.msg=AppMan.resources.ValueLengthShouldBeLessThan;c.minmax.args=[];c.minmax.args.push("200");c.max="200";c.events.blur.push("minmax");c.required={};c.required.msg=AppMan.resources.ThisFieldIsRequired;c.events.blur.push("required");c.InvalidCSSClass = "ufo-fields-invalid-field";AppMan.addValidation(c);' class='ufo-eval'/>
      <div id='Description-invalid' class='ufo-fields-invalid-value ufo-id-link' style='position:absolute;display:none'></div>
    </div>
    <div>
      <label for='Notes' class='ufo-label-top'><?php 
echo EasyContactFormsT::get('Notes');
?>
</label>
      <?php 
if (EasyContactFormsApplicationSettings::getInstance()->get('UseTinyMCE')) {
    EasyContactFormsIHTML::getTinyMCE('Notes');
}
?>
      <textarea id='Notes' class='ufo-formvalue' style='width:100%'><?php 
echo $obj->get('Notes');
?>
</textarea>
    </div>
  </div>
  <div>
    <div class='ufo-float-left'>
      <?php 
echo EasyContactFormsIHTML::getButton(array('id' => "OK", 'label' => EasyContactFormsT::get('OK'), 'events' => " onclick='ufo.save({$obj->jsconfig})'", 'iclass' => " class='icon_button_save ufo-id-link' ", 'bclass' => "button internalimage"));
?>
      <input type='hidden' value='var c = {};c.id = "OK";AppMan.addSubmit(c);' class='ufo-eval'/>
 /**
  * 	processHistory
  *
  * 	performs status/comment/history processing
  *
  * @param array $fieldvalues
  * 	request field data
  * @param string $type
  * 	object type
  * @param int $oid
  * 	object id
  * @param int $uid
  * 	current user id
  */
 function processHistory($fieldvalues, $type, $oid, $uid)
 {
     $object = EasyContactFormsClassLoader::getObject($type, TRUE, $oid);
     $is_st_changed = isset($fieldvalues->Status) && $fieldvalues->Status != $object->get('Status');
     $not_on_sn_chng_var = $type . '_NotifyOnStatusChange';
     $not_on_st_change = EasyContactFormsApplicationSettings::getInstance()->get($not_on_sn_chng_var);
     $is_n_comment = isset($fieldvalues->Comment) && !empty($fieldvalues->Comment);
     $not_on_new_comment_var = $type . '_NotifyOnNewComment';
     $not_on_new_comment = EasyContactFormsApplicationSettings::getInstance()->get($not_on_new_comment_var);
     $send_message = $is_n_comment && $not_on_new_comment || $is_st_changed && $not_on_st_change;
     if (!$is_st_changed && !$is_n_comment) {
         return $fieldvalues;
     }
     $type_status_map = array();
     $objname = EasyContactFormsDB::getTableName($type_status_map[$type]);
     $status = '';
     if (isset($objname)) {
         $sid = $is_st_changed ? intval($fieldvalues->Status) : $object->get('Status');
         $status = EasyContactFormsDB::getValue("SELECT Description FROM {$objname} WHERE id='{$sid}'");
         $status .= ' -- ';
     }
     $user = EasyContactFormsDB::getValue("SELECT CONCAT(Description,' ',Name) FROM #wp__easycontactforms_users WHERE id='{$uid}'");
     $text = (object) array('body' => '', 'subject' => '');
     $comment = '';
     $delimeter = '-- ' . $user . ' -- ' . $status . date(EasyContactFormsT::get('DateTimeFormat')) . ' --<br/>';
     if ($is_n_comment) {
         $comment = $fieldvalues->Comment;
         unset($fieldvalues->Comment);
         $text->body = $comment;
         $stemplate = EasyContactFormsApplicationSettings::getInstance()->get('NewCommentSubject');
         $text->subject = sprintf($stemplate, $type, $object->get('Description'), $status);
     }
     if ($is_st_changed) {
         $stemplate = EasyContactFormsApplicationSettings::getInstance()->get('StatusChangeSubject');
         $text->subject = sprintf($stemplate, $type, $object->get('Description'), $status);
     }
     $history = $delimeter . $text->body . '<br/>' . $object->get('History');
     $fieldvalues->History = $history;
     if ($send_message) {
         $this->sendNotification($uid, $type, $oid, $text);
     }
     return $fieldvalues;
 }
 /**
  * 	getServerPwd
  *
  * 	Returns the Appplicataion Settings SecretWord constant value
  *
  *
  * @return string
  * 	the value
  */
 function getServerPwd()
 {
     return EasyContactFormsApplicationSettings::getInstance()->get('SecretWord');
 }
Пример #24
0
 /**
  * 	api
  *
  * 	Performs a remote api call
  *
  * @param string $action
  * 	Remote method to call
  * @param array $args
  * 	Arguments to pass
  * @param boolean $unserialize
  * 	Unserialization flag
  * @param  $silent
  * 
  *
  * @return arbitrary
  * 	Depends on the api call type
  */
 function api($action, $args, $unserialize = TRUE, $silent = FALSE)
 {
     require_once 'easy-contact-forms-applicationsettings.php';
     $as = EasyContactFormsApplicationSettings::getInstance();
     global $wp_version;
     if (is_array($args)) {
         $args['slug'] = 'easy-contact-forms';
         $args['productVersion'] = $as->get('ProductVersion');
     }
     if (is_object($args)) {
         $args->slug = 'easy-contact-forms';
         $args->productVersion = $as->get('ProductVersion');
     }
     $body = array();
     $body['apiaction'] = $action;
     $body['request'] = serialize($args);
     $body['site'] = get_bloginfo('url');
     $request = array('body' => $body, 'user-agent' => 'WordPress/' . $wp_version . '; ' . get_bloginfo('url'));
     $raw_response = wp_remote_post('http://championforms.com/api.php', $request);
     if (is_wp_error($raw_response) || $raw_response['response']['code'] != 200) {
         if ($silent) {
             return '';
         }
         $msg = "Remote API Action '{$action}' Failed";
         $as->addMessage($msg);
         return new WP_Error('remote_api_failed', $msg);
     }
     $response = $raw_response['body'];
     if ($unserialize) {
         $response = unserialize($response);
         if ($response === FALSE) {
             if ($silent) {
                 return '';
             }
             $msg = "Could not read Remote API Action '{$action}' Response";
             $as->addMessage($msg);
             return new WP_Error('remote_api_failed', $msg);
         }
     }
     return $response;
 }
            <span>
              <?php 
echo $obj->get('CustomFormsDescription');
?>
            </span>
          </div>
        </div>
        <div>
          <div class='ufo-float-left ufo-width50'>
            <div style='width:100%'>
              <label><?php 
echo EasyContactFormsT::get('Date');
?>
</label>
              <?php 
EasyContactFormsIHTML::echoDate($obj->get('Date'), EasyContactFormsApplicationSettings::getInstance()->getDateFormat('PHP', TRUE), 0);
?>
            </div>
          </div>
          <div class='ufo-float-right ufo-width50'>
            <div style='width:100%'>
              <label><?php 
echo EasyContactFormsT::get('PageName');
?>
</label>
              <?php 
echo $obj->get('PageName');
?>
            </div>
          </div>
          <div style='clear:left'></div>
/**
 * 	Easy Contact Forms form entrypoint
 *
 * @param array $map
 * 
 *
 * @return string
 * 
 */
function easycontactforms_formentrypoint($map)
{
    $base = get_bloginfo('wpurl');
    $base = rtrim($base, '/');
    // Http root
    if (!defined('EASYCONTACTFORMS__APPLICATION_ROOT')) {
        DEFINE('EASYCONTACTFORMS__APPLICATION_ROOT', $base);
    }
    // DIRECTORY_SEPARATOR
    if (!defined('WP_DS')) {
        DEFINE('WP_DS', DIRECTORY_SEPARATOR);
    }
    // Plugin directory
    if (!defined('_EASYCONTACTFORMS_DIR')) {
        DEFINE('_EASYCONTACTFORMS_DIR', 'wp-content/plugins/easy-contact-forms');
    }
    // Plugin url
    if (!defined('EASYCONTACTFORMS__engineWebAppDirectory')) {
        DEFINE('EASYCONTACTFORMS__engineWebAppDirectory', rtrim(EASYCONTACTFORMS__APPLICATION_ROOT, '/') . '/' . _EASYCONTACTFORMS_DIR);
    }
    // An absolute plugin path
    if (!defined('_EASYCONTACTFORMS_PLUGIN_PATH')) {
        DEFINE('_EASYCONTACTFORMS_PLUGIN_PATH', ABSPATH . _EASYCONTACTFORMS_DIR);
    }
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . WP_DS . 'easy-contact-forms-utils.php';
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . WP_DS . 'easy-contact-forms-database.php';
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . WP_DS . 'easy-contact-forms-root.php';
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . WP_DS . 'easy-contact-forms-applicationsettings.php';
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . WP_DS . 'easy-contact-forms-customforms.php';
    require_once _EASYCONTACTFORMS_PLUGIN_PATH . WP_DS . 'easy-contact-forms-appconfigdata.php';
    $js = '';
    $as = EasyContactFormsApplicationSettings::getInstance();
    if (!$as->get('FixJSLoading')) {
        wp_enqueue_script('ufoforms', '/' . _EASYCONTACTFORMS_DIR . '/easy-contact-forms-forms.1.4.2.js');
    } else {
        $js = '<script src="' . $base . '/' . _EASYCONTACTFORMS_DIR . '/easy-contact-forms-forms.1.4.2.js"></script>';
    }
    $pb = $as->getPBLink();
    if (!isset($map['pn'])) {
        $pagename = get_query_var('pagename');
        $pageid = get_query_var('page_id');
        if (!$pagename && $pageid > 0) {
            global $wp_query;
            $post = $wp_query->get_queried_object();
            $pagename = $post->post_name;
        }
        $map['pn'] = $pagename;
    }
    $map = array_merge($map, $_REQUEST);
    global $current_user;
    $userid = $current_user->ID;
    unset($map['frid']);
    $map['frid'] = $userid;
    return EasyContactFormsCustomForms::getForm($map) . $pb . $js;
}