function insertDefaultContent($overwrite = false)
 {
     $field_slugs = array('name' => 'ccf_name', 'message' => 'ccf_message', 'phone' => 'ccf_phone', 'google' => 'ccf_google', 'date' => 'ccf_schedule_date', 'contact_method' => 'ccf_contact_method');
     $option_slugs = array('email' => 'ccf_email', 'phone' => 'ccf_phone', 'yes' => 'ccf_yes', 'nocontact' => 'ccf_no_contact', 'pleaseselect' => 'please_select');
     $form_slugs = array('contact_form' => 'ccf_contact_form');
     if ($overwrite) {
         foreach ($field_slugs as $slug) {
             parent::deleteField(0, $slug);
         }
         foreach ($option_slugs as $slug) {
             parent::deleteFieldOption(0, $slug);
         }
         foreach ($form_slugs as $slug) {
             parent::deleteForm(0, $slug);
         }
     }
     $name_field = array('field_slug' => $field_slugs['name'], 'field_label' => __('Your Name:', 'custom-contact-forms'), 'field_required' => 1, 'field_instructions' => __('Please enter your full name.', 'custom-contact-forms'), 'field_maxlength' => '100', 'field_type' => 'Text');
     $date_field = array('field_slug' => $field_slugs['date'], 'field_label' => __('When Should I Contact You:', 'custom-contact-forms'), 'field_required' => 0, 'field_instructions' => __('Please choose a date you would like to be contacted.', 'custom-contact-forms'), 'field_maxlength' => '100', 'field_type' => 'Date');
     $message_field = array('field_slug' => $field_slugs['message'], 'field_label' => __('Your Message:', 'custom-contact-forms'), 'field_required' => 0, 'field_instructions' => __('Enter any message or comment.', 'custom-contact-forms'), 'field_maxlength' => 0, 'field_type' => 'Textarea');
     $phone_field = array('field_slug' => $field_slugs['phone'], 'field_label' => __('Your Phone Number:', 'custom-contact-forms'), 'field_required' => 0, 'field_instructions' => __('Please enter your phone number.', 'custom-contact-forms'), 'field_maxlength' => 30, 'field_type' => 'Text');
     $google_field = array('field_slug' => $field_slugs['google'], 'field_label' => __('Did you find my website through Google?', 'custom-contact-forms'), 'field_required' => 0, 'field_instructions' => __('If you found my website through Google, check this box.', 'custom-contact-forms'), 'field_maxlength' => 0, 'field_type' => 'Checkbox', 'field_value' => __('Yes', 'custom-contact-forms'));
     $contact_method_field = array('field_slug' => $field_slugs['contact_method'], 'field_label' => __('How should we contact you?', 'custom-contact-forms'), 'field_required' => 1, 'field_instructions' => __('By which method we should contact you?', 'custom-contact-forms'), 'field_maxlength' => 0, 'field_type' => 'Dropdown');
     $email_field = parent::selectField(0, 'fixedEmail');
     $website_field = parent::selectField(0, 'fixedWebsite');
     $captcha_field = parent::selectField(0, 'captcha');
     $reset_button = parent::selectField(0, 'resetButton');
     $pleaseselect_option = array('option_slug' => $option_slugs['pleaseselect'], 'option_dead' => 1, 'option_label' => __('Please Select:', 'custom-contact-forms'));
     $email_option = array('option_slug' => $option_slugs['email'], 'option_label' => __('By Email', 'custom-contact-forms'));
     $phone_option = array('option_slug' => $option_slugs['phone'], 'option_label' => __('By Phone', 'custom-contact-forms'));
     $nocontact_option = array('option_slug' => $option_slugs['nocontact'], 'option_label' => __('Do Not Contact Me', 'custom-contact-forms'));
     $yes_option = array('option_slug' => $option_slugs['yes'], 'option_label' => __('Yes, I did.', 'custom-contact-forms'));
     $contact_form = array('form_slug' => $form_slugs['contact_form'], 'form_title' => __('Contact Form', 'custom-contact-forms'), 'form_method' => 'Post', 'submit_button_text' => __('Send Message', 'custom-contact-forms'), 'form_email' => get_option('admin_email'), 'form_success_message' => __('Thank you for filling out our contact form. We will contact you very soon by the way you specified.', 'custom-contact-forms'), 'form_success_title' => __('Thank You!', 'custom-contact-forms'), 'form_access' => parent::getRolesArray(), 'form_style' => 0);
     $name_field_id = parent::insertField($name_field);
     $date_field_id = parent::insertField($date_field);
     $message_field_id = parent::insertField($message_field);
     $phone_field_id = parent::insertField($phone_field);
     $google_field_id = parent::insertField($google_field);
     $contact_method_field_id = parent::insertField($contact_method_field);
     $email_option_id = parent::insertFieldOption($email_option);
     $yes_option_id = parent::insertFieldOption($yes_option);
     $pleaseselect_option_id = parent::insertFieldOption($email_option);
     $phone_option_id = parent::insertFieldOption($phone_option);
     $nocontact_option_id = parent::insertFieldOption($nocontact_option);
     $contact_form_id = parent::insertForm($contact_form);
     parent::addFieldOptionToField($pleaseselect_option_id, $contact_method_field_id);
     parent::addFieldOptionToField($email_option_id, $contact_method_field_id);
     parent::addFieldOptionToField($phone_option_id, $contact_method_field_id);
     parent::addFieldOptionToField($nocontact_option_id, $contact_method_field_id);
     parent::addFieldOptionToField($yes_option_id, $google_field_id);
     parent::addFieldToForm($name_field_id, $contact_form_id);
     parent::addFieldToForm($website_field->id, $contact_form_id);
     parent::addFieldToForm($email_field->id, $contact_form_id);
     parent::addFieldToForm($phone_field_id, $contact_form_id);
     parent::addFieldToForm($google_field_id, $contact_form_id);
     parent::addFieldToForm($contact_method_field_id, $contact_form_id);
     parent::addFieldToForm($date_field_id, $contact_form_id);
     parent::addFieldToForm($message_field_id, $contact_form_id);
     parent::addFieldToForm($captcha_field->id, $contact_form_id);
     parent::addFieldToForm($reset_button->id, $contact_form_id);
 }
 function importFromFile($file, $settings = array('mode' => 'clear_import', 'import_general_settings' => false, 'import_forms' => true, 'import_fields' => true, 'import_field_options' => true, 'import_styles' => true, 'import_saved_submissions' => false))
 {
     $path = CCF_BASE_PATH . 'import/';
     $file_name = basename(time() . $file['name']);
     $file_extension = pathinfo($file['name'], PATHINFO_EXTENSION);
     if (stripos($file_extension, 'sql')) {
         unlink($file['tmp_name']);
         wp_die('You can only import .sql files.');
     }
     if (move_uploaded_file($file['tmp_name'], $path . $file_name)) {
         $data = file_get_contents($path . $file_name);
         $data = preg_replace('/^#.*?[\\n\\r]*$/ims', '', $data);
         $commands = $this->parseMultiQuery($data);
         $errors = 0;
         if ($settings['mode'] == 'clear_import') {
             parent::emptyAllTables();
         }
         foreach ($commands as $command) {
             if (preg_match('/^[\\s]*UPDATE/is', $command)) {
                 if ($settings['import_general_settings']) {
                     if (!parent::query($command)) {
                         $errors++;
                     }
                 }
             } elseif (preg_match('/^[\\s]*INSERT INTO/is', $command)) {
                 $table_name = $this->extractTableFromQuery($command);
                 $no_query = 0;
                 if ($settings['import_forms'] == 0) {
                     if ($table_name == CCF_FORMS_TABLE) {
                         $no_query = 1;
                     }
                 }
                 if ($settings['import_fields'] == 0) {
                     if ($table_name == CCF_FIELDS_TABLE) {
                         $no_query = 1;
                     }
                 }
                 if ($settings['import_field_options'] == 0) {
                     if ($table_name == CCF_FIELD_OPTIONS_TABLE) {
                         $no_query = 1;
                     }
                 }
                 if ($settings['import_styles'] == 0) {
                     if ($table_name == CCF_STYLES_TABLE) {
                         $no_query = 1;
                     }
                 }
                 if ($settings['import_saved_submissions'] == 0) {
                     if ($table_name == CCF_USER_DATA_TABLE) {
                         $no_query = 1;
                     }
                 }
                 if ($no_query == 0) {
                     if (!parent::query($command)) {
                         $errors++;
                     }
                 }
             }
         }
         ccf_utils::load_module('db/custom-contact-forms-activate-db.php');
         CustomContactFormsActivateDB::insertFixedFields();
         parent::serializeAllFormFields();
         parent::serializeAllFieldOptions();
         return $errors == 0 ? true : $errors;
     }
     return false;
 }
 function makeAllFormsAccessible()
 {
     $forms = parent::selectAllForms();
     foreach ($forms as $form) {
         parent::updateForm(array('form_access_update' => 1, 'form_access' => array_values(parent::getRolesArray())), $form->id);
     }
 }