/** ------------------- Display Widget -------------------------------------------
     * The input form for the testimonial widget is loaded. The visitor inputs a testimonial
     * and clicks the submit button and the testimonial is submitted to the database 
     * and the admin user is notified by email that they have a testimonial to review
     * and approve. If admin user can specify if a captcha is used to help in validation.
     * 
     * @param array $arg array of global theme values
     * @param array $instance array of widget form values
     * 
     * @uses katb_get_options user options from /includes/katb_functions.php
     * @uses katb_allowed_html() for allowed tags from /includes/katb_functions.php
     * 
     *-------------------------------------------------------------------------------- */
    public function widget($args, $instance)
    {
        //Get user options
        $katb_options = katb_get_options();
        $include_widget_email_note = $katb_options['katb_include_widget_email_note'];
        $widget_email_note = $katb_options['katb_widget_email_note'];
        $author_label_widget = $katb_options['katb_widget_author_label'];
        $email_label_widget = $katb_options['katb_widget_email_label'];
        $website_label_widget = $katb_options['katb_widget_website_label'];
        $location_label_widget = $katb_options['katb_widget_location_label'];
        $rating_label_widget = $katb_options['katb_widget_rating_label'];
        $testimonial_label_widget = $katb_options['katb_widget_testimonial_label'];
        $widget_captcha_label = $katb_options['katb_widget_captcha_label'];
        $submit_label_widget = $katb_options['katb_widget_submit_label'];
        $reset_label_widget = $katb_options['katb_widget_reset_label'];
        $exclude_website = $katb_options['katb_exclude_website_input'];
        $require_website = $katb_options['katb_require_website_input'];
        $exclude_location = $katb_options['katb_exclude_location_input'];
        $require_location = $katb_options['katb_require_location_input'];
        $use_ratings = $katb_options['katb_use_ratings'];
        $use_css_ratings = $katb_options['katb_use_css_ratings'];
        $auto_approve = $katb_options['katb_auto_approve'];
        $use_widget_popup = $katb_options['katb_use_widget_popup_message'];
        $labels_above = $katb_options['katb_widget_labels_above'];
        $widget_required_label = $katb_options['katb_widget_required_label'];
        $katb_widget_rating = '0.0';
        //Get the widget title and display
        extract($args);
        echo $before_widget;
        $title = apply_filters('widget_title', $instance['katb_input_widget_title']);
        if (!empty($title)) {
            echo $before_title . esc_html($title) . $after_title;
        }
        //Set up database table name for use later
        global $wpdb, $tablename;
        $tablename = $wpdb->prefix . 'testimonial_basics';
        //Initialize Variables
        if ($labels_above != 1) {
            $katb_widget_author = $author_label_widget;
            $katb_widget_email = $email_label_widget;
            $katb_widget_website = $website_label_widget;
            $katb_widget_location = $location_label_widget;
            $katb_widget_testimonial = $testimonial_label_widget;
        } else {
            $katb_widget_author = '';
            $katb_widget_email = '';
            $katb_widget_website = '';
            $katb_widget_location = '';
            $katb_widget_testimonial = '';
        }
        $katb_allowed_html = katb_allowed_html();
        $katb_widget_input_group = esc_attr($instance['katb_input_widget_group']);
        if ($katb_widget_input_group == '') {
            $katb_widget_input_group = 'All';
        }
        $katb_widget_input_form_no = esc_attr($instance['katb_input_widget_form_no']);
        if ($katb_widget_input_form_no == '') {
            $katb_widget_input_form_no = '1';
        }
        $post_name = 'widget_submitted' . $katb_widget_input_form_no;
        $reset_name = 'widget_reset' . $katb_widget_input_form_no;
        //Process input form
        if (isset($_POST[$post_name]) && wp_verify_nonce($_POST['katb_widget_form_nonce'], 'katb_nonce_2')) {
            //Validate Input
            //initialize error string
            $katb_widget_html_error = '';
            $katb_widget_popup_error = '';
            //Set default variables
            $katb_widget_order = "";
            if ($auto_approve == 1) {
                $katb_widget_approved = 1;
            } else {
                $katb_widget_approved = 0;
            }
            $katb_widget_datetime = current_time('mysql');
            //validate author
            $katb_widget_author = sanitize_text_field($_POST['tb_author']);
            if ($katb_widget_author == $author_label_widget || $katb_widget_author == '') {
                $katb_widget_html_error .= '<br/> - ' . __('Author required', 'testimonial-basics');
                $katb_widget_popup_error .= '\\n - ' . __('Author required', 'testimonial-basics');
                if ($labels_above == 1) {
                    $katb_widget_author = '';
                } else {
                    $katb_widget_author = $author_label_widget;
                }
            }
            //validate email
            $katb_widget_email = sanitize_email($_POST['tb_email']);
            if (!is_email($katb_widget_email)) {
                $katb_widget_html_error .= '<br/> - ' . __('Valid email required ', 'testimonial-basics');
                $katb_widget_popup_error .= '\\n - ' . __('Valid email required ', 'testimonial-basics');
                if ($labels_above == 1) {
                    $katb_widget_email = '';
                } else {
                    $katb_widget_email = $email_label_widget;
                }
            }
            //validate website
            if ($exclude_website != 1) {
                $katb_widget_website = trim($_POST['tb_website']);
                if ($katb_widget_website != '' && $katb_widget_website != $website_label_widget) {
                    $katb_widget_website = esc_url($katb_widget_website);
                } else {
                    if ($require_website == 1) {
                        $katb_widget_html_error .= '<br/> - ' . __('Website required ', 'testimonial-basics');
                        $katb_widget_popup_error .= '\\n - ' . __('Website required ', 'testimonial-basics');
                    }
                    $katb_widget_website = $website_label_widget;
                }
            } else {
                $katb_widget_website = '';
            }
            //validate location
            if ($exclude_location != 1) {
                $katb_widget_location = trim($_POST['tb_location']);
                if ($katb_widget_location != '' && $katb_widget_location != $location_label_widget) {
                    $katb_widget_location = sanitize_text_field($katb_widget_location);
                } else {
                    if ($require_location == 1) {
                        $katb_widget_html_error .= '<br/> - ' . __('Location required ', 'testimonial-basics');
                        $katb_widget_popup_error .= '\\n - ' . __('Location required ', 'testimonial-basics');
                    }
                    $katb_widget_location = $location_label_widget;
                }
            } else {
                $katb_widget_website = '';
            }
            //validate rating
            if ($use_ratings == 1) {
                $katb_widget_rating = sanitize_text_field($_POST['tb_rating_widget']);
                if ($katb_widget_rating == '') {
                    $katb_widget_rating = '0.0';
                }
                if ($katb_widget_rating == '1') {
                    $katb_widget_rating = '1.0';
                }
                if ($katb_widget_rating == '2') {
                    $katb_widget_rating = '2.0';
                }
                if ($katb_widget_rating == '3') {
                    $katb_widget_rating = '3.0';
                }
                if ($katb_widget_rating == '4') {
                    $katb_widget_rating = '4.0';
                }
                if ($katb_widget_rating == '5') {
                    $katb_widget_rating = '5.0';
                }
                if ($katb_widget_rating == '0') {
                    $katb_widget_rating = '0.0';
                }
            }
            //validate testimonial
            $katb_widget_testimonial = wp_kses($_POST['tb_testimonial'], $katb_allowed_html);
            //$katb_widget_testimonial = wp_kses_post( $_POST['tb_testimonial'] );
            if ($katb_widget_testimonial == $testimonial_label_widget || $katb_widget_testimonial == "") {
                $katb_widget_html_error .= '<br/> - ' . __('Testimonial required', 'testimonial-basics');
                $katb_widget_popup_error .= '\\n - ' . __('Testimonial required', 'testimonial-basics');
                if ($labels_above != 1) {
                    $katb_widget_testimonial = $testimonial_label_widget;
                } else {
                    $katb_widget_testimonial = '';
                }
            }
            //Captcha Validation
            if ($katb_options['katb_use_captcha'] == TRUE || $katb_options['katb_use_captcha'] == 1) {
                $katb_captcha_entered = sanitize_text_field($_POST['verify']);
                if ($_SESSION['katb_pass_phrase'] !== sha1($katb_captcha_entered)) {
                    $katb_widget_html_error .= '<br/> - ' . __('Captcha invalid', 'testimonial-basics');
                    $katb_widget_popup_error .= '\\n - ' . __('Captcha invalid', 'testimonial-basics');
                }
            }
            //Validation complete
            if ($katb_widget_html_error == '' && $katb_widget_popup_error == '') {
                if ($katb_widget_website == $website_label_widget) {
                    $katb_widget_website = '';
                }
                if ($katb_widget_location == $location_label_widget) {
                    $katb_widget_location = '';
                }
                //OK $error is empty so let's update the database
                $values = array('tb_date' => $katb_widget_datetime, 'tb_order' => $katb_widget_order, 'tb_approved' => $katb_widget_approved, 'tb_group' => $katb_widget_input_group, 'tb_name' => $katb_widget_author, 'tb_email' => $katb_widget_email, 'tb_location' => $katb_widget_location, 'tb_url' => $katb_widget_website, 'tb_pic_url' => '', 'tb_rating' => $katb_widget_rating, 'tb_testimonial' => $katb_widget_testimonial);
                $formats_values = array('%s', '%d', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');
                $wpdb->insert($tablename, $values, $formats_values);
                //send email
                if (isset($katb_options['katb_contact_email']) && $katb_options['katb_contact_email'] != '') {
                    $emailTo = $katb_options['katb_contact_email'];
                } else {
                    $emailTo = get_option('admin_email');
                }
                $subject = __('You have received a testimonial!', 'testimonial-basics');
                $body = __('Name: ', 'testimonial-basics') . ' ' . stripcslashes($katb_widget_author) . "<br/><br/>" . __('Email: ', 'testimonial-basics') . ' ' . stripcslashes($katb_widget_email) . "<br/><br/>" . __('Comments: ', 'testimonial-basics') . "<br/><br/>" . stripcslashes($katb_widget_testimonial) . "<br/><br/>" . __('Log in to approve or view it:', 'testimonial-basics') . '<a href="' . site_url("/wp-login.php") . '" title="your site login">Log In</a>';
                $headers = 'From: ' . stripcslashes($katb_widget_author) . ' <' . stripcslashes($katb_widget_email) . '>';
                add_filter('wp_mail_content_type', create_function('', 'return "text/html";'));
                wp_mail($emailTo, $subject, $body, $headers);
                $_SESSION['katb_widget_submitted'] = SHA1('true');
                //Initialize Variables
                if ($labels_above != 1) {
                    $katb_widget_author = $author_label_widget;
                    $katb_widget_email = $email_label_widget;
                    $katb_widget_website = $website_label_widget;
                    $katb_widget_location = $location_label_widget;
                    $katb_widget_testimonial = $testimonial_label_widget;
                } else {
                    $katb_widget_author = '';
                    $katb_widget_email = '';
                    $katb_widget_website = '';
                    $katb_widget_location = '';
                    $katb_widget_testimonial = '';
                }
                $katb_widget_rating = '0.0';
            } else {
                if ($use_widget_popup == 1) {
                    $widget_error_message = __('There were errors so the testimonial was not added: ', 'testimonial-basics') . '\\n' . $katb_widget_popup_error;
                    ?>
<script>alert('<?php 
                    echo $widget_error_message;
                    ?>
')</script>
				<?php 
                } else {
                    echo '<div class="katb_widget_error">' . __('Error', 'testimonial-basics') . $katb_widget_html_error . '</div>';
                }
                if ($katb_widget_website == '') {
                    $katb_widget_website = $website_label_widget;
                }
                if ($katb_widget_location == '') {
                    $katb_widget_location = $location_label_widget;
                }
            }
        }
        /* ---------- Reset button is clicked ---------------- */
        if (isset($_POST[$reset_name])) {
            $katb_widget_author = $author_label_widget;
            $katb_widget_email = $email_label_widget;
            $katb_widget_website = $website_label_widget;
            $katb_widget_location = $location_label_widget;
            $katb_widget_testimonial = $testimonial_label_widget;
            $katb_widget_rating = '0.0';
        }
        ?>
		<div class="katb_widget_form">
			
			<?php 
        if ($include_widget_email_note == 1) {
            ?>
				<p><?php 
            echo esc_attr(stripslashes($widget_email_note));
            ?>
</p>
			<?php 
        }
        ?>
			
			<form method="POST">
				
				<?php 
        wp_nonce_field("katb_nonce_2", "katb_widget_form_nonce");
        ?>
				
				<?php 
        if ($labels_above == 1) {
            echo '<label class="katb_widget_input_label">' . esc_attr($author_label_widget) . '</label>';
        }
        ?>
				<input  class="katb_input" type="text" name="tb_author" value="<?php 
        echo esc_attr($katb_widget_author);
        ?>
" />
			
				<?php 
        if ($labels_above == 1) {
            echo '<label class="katb_widget_input_label">' . esc_attr($email_label_widget) . '</label>';
        }
        ?>
				<input  class="katb_input" type="text" name="tb_email" value="<?php 
        echo esc_attr($katb_widget_email);
        ?>
" />
			
				<?php 
        if ($exclude_website != 1) {
            ?>
					<?php 
            if ($labels_above == 1) {
                echo '<label class="katb_widget_input_label">' . esc_attr($website_label_widget) . '</label>';
            }
            ?>
					<input  class="katb_input" type="text" name="tb_website" value="<?php 
            echo esc_attr($katb_widget_website);
            ?>
" />
				<?php 
        }
        if ($exclude_location != 1) {
            ?>
					<?php 
            if ($labels_above == 1) {
                echo '<label class="katb_widget_input_label">' . esc_attr($location_label_widget) . '</label>';
            }
            ?>
					<input  class="katb_input" type="text" name="tb_location" value="<?php 
            echo esc_attr($katb_widget_location);
            ?>
" />
				<?php 
        }
        if ($use_ratings == 1) {
            if ($use_css_ratings != 1) {
                ?>
					
						<label class="katb_widget_input_label"><?php 
                echo esc_attr($rating_label_widget);
                ?>
</label>
						<input type="range" min="0" max="5" value="<?php 
                echo $katb_widget_rating;
                ?>
" step="0.5" name="tb_rating_widget" id="katb_widget_rateit_input_<?php 
                echo $katb_widget_input_form_no;
                ?>
" class="katb_widget_rating_input">
						<div class="rateit katb_widget_input_rating" data-rateit-backingfld="#katb_widget_rateit_input_<?php 
                echo $katb_widget_input_form_no;
                ?>
"></div>
					
					<?php 
            } else {
                ?>
						
						<label class="katb_widget_input_label"><?php 
                echo esc_attr($rating_label_widget);
                ?>
</label>
						
						<select name="tb_rating_widget" class="katb_css_rating_select_widget">
							<option <?php 
                selected($katb_widget_rating);
                ?>
 value="<?php 
                echo $katb_widget_rating;
                ?>
"><?php 
                echo $katb_widget_rating;
                ?>
</option>
							<option value="0.0" <?php 
                selected(esc_attr($katb_widget_rating), "0.0");
                ?>
>0.0</option>
							<option value="0.5" <?php 
                selected(esc_attr($katb_widget_rating), "0.5");
                ?>
>0.5</option>
							<option value="1.0" <?php 
                selected(esc_attr($katb_widget_rating), "1.0");
                ?>
>1.0</option>
							<option value="1.5" <?php 
                selected(esc_attr($katb_widget_rating), "1.5");
                ?>
>1.5</option>
							<option value="2.0" <?php 
                selected(esc_attr($katb_widget_rating), "2.0");
                ?>
>2.0</option>
							<option value="2.5" <?php 
                selected(esc_attr($katb_widget_rating), "2.5");
                ?>
>2.5</option>
							<option value="3.0" <?php 
                selected(esc_attr($katb_widget_rating), "3.0");
                ?>
>3.0</option>
							<option value="3.5" <?php 
                selected(esc_attr($katb_widget_rating), "3.5");
                ?>
>3.5</option>
							<option value="4.0" <?php 
                selected(esc_attr($katb_widget_rating), "4.0");
                ?>
>4.0</option>
							<option value="4.5" <?php 
                selected(esc_attr($katb_widget_rating), "4.5");
                ?>
>4.5</option>
							<option value="5.0" <?php 
                selected(esc_attr($katb_widget_rating), "5.0");
                ?>
>5.0</option>
						</select>
					
					<?php 
            }
        }
        ?>
				
				<?php 
        if ($labels_above == 1) {
            echo '<br/><label class="katb_widget_input_label">' . esc_attr($testimonial_label_widget) . '</label>';
        }
        ?>
				<textarea name="tb_testimonial" rows="5" ><?php 
        echo esc_attr($katb_widget_testimonial);
        ?>
</textarea>
				

				<?php 
        if ($katb_options['katb_show_html_widget'] == TRUE || $katb_options['katb_show_html_widget'] == 1) {
            echo '<p>HTML: <code>a p br i em strong q h1-h6</code></p>';
        }
        if ($katb_options['katb_use_captcha'] == TRUE || $katb_options['katb_use_captcha'] == 1) {
            ?>
					
					<div class="katb_widget_captcha">
						<?php 
            if ($katb_options['katb_use_color_captcha_2'] == TRUE || $katb_options['katb_use_color_captcha_2'] == 1) {
                echo katb_color_captcha_2();
            } elseif ($katb_options['katb_use_color_captcha'] == TRUE || $katb_options['katb_use_color_captcha'] == 1) {
                ?>
							<img src="<?php 
                echo site_url();
                ?>
/wp-content/plugins/testimonial-basics/includes/katb_captcha_color.php" alt="Verification Captcha" />
						<?php 
            } else {
                ?>
							<img src="<?php 
                echo site_url();
                ?>
/wp-content/plugins/testimonial-basics/includes/katb_captcha_bw.php" alt="Verification Captcha" />
						<?php 
            }
            ?>
						<input class="katb_captcha_widget_input" type="text" id="verify" name="verify" value="<?php 
            echo $widget_captcha_label;
            ?>
" onclick="this.select();" /><br/>
					</div>
					
				<?php 
        }
        ?>
				
				<input class="katb_widget_submit" type="submit" name="<?php 
        echo $post_name;
        ?>
" value="<?php 
        echo esc_attr($submit_label_widget);
        ?>
" />
				
				<input class="katb_widget_reset" type="submit" name="<?php 
        echo $reset_name;
        ?>
" value="<?php 
        echo esc_attr($reset_label_widget);
        ?>
" />
			
			</form>
			
			<?php 
        if ($widget_required_label != '') {
            echo '<div class="katb_clear_fix"></div><p>' . esc_attr($widget_required_label) . '</p>';
        }
        ?>
			
			<div class="katb_clear_fix"></div>
			
			<?php 
        if ($katb_options['katb_show_widget_gravatar_link'] == 1) {
            ?>
				<span class="katb_use_gravatar_wrap">
					<span class="use_gravatar"><?php 
            _e('Add a Photo? ', 'testimonial-basics');
            ?>
</span>
					<a href="https://en.gravatar.com/" title="Gravatar Site" target="_blank" >
						<img class="gravatar_logo" src="<?php 
            echo plugins_url();
            ?>
/testimonial-basics/includes/Gravatar80x16.jpg" alt="Gravatar Website" title="Gravatar Website" />
					</a>
				</span>
				
			<?php 
        }
        ?>
			
		</div>
		
		<?php 
        echo '<br style="clear:both;" />';
        echo $after_widget;
        if (isset($_SESSION['katb_widget_submitted']) && $_SESSION['katb_widget_submitted'] == SHA1('true')) {
            //Optional supmitted popup message
            if ($use_widget_popup == 1) {
                ?>
				<script type="text/javascript"><?php 
                echo 'alert("' . __("Testimonial Submitted - Thank You!", "testimonial-basics") . '")';
                ?>
</script>
			<?php 
            } else {
                echo '<div class="katb_widget_sent">' . __('Testimonial Submitted - Thank You!', 'testimonial-basics') . '</div>';
            }
            $_SESSION['katb_widget_submitted'] = SHA1('false');
        }
    }
Beispiel #2
0
function katb_check_for_submitted_testimonial()
{
    global $wpdb, $tablename;
    global $katb_group, $katb_author, $katb_email, $katb_website, $katb_location, $katb_rating, $katb_testimonial, $katb_input_error, $katb_input_success;
    $tablename = $wpdb->prefix . 'testimonial_basics';
    $katb_options = katb_get_options();
    $exclude_website = $katb_options['katb_exclude_website_input'];
    $require_website = $katb_options['katb_require_website_input'];
    $exclude_location = $katb_options['katb_exclude_location_input'];
    $require_location = $katb_options['katb_require_location_input'];
    $use_ratings = $katb_options['katb_use_ratings'];
    $auto_approve = $katb_options['katb_auto_approve'];
    $use_popup = $katb_options['katb_use_popup_message'];
    $katb_allowed_html = katb_allowed_html();
    if (isset($_POST['katb_submitted']) && wp_verify_nonce($_POST['katb_main_form_nonce'], 'katb_nonce_1')) {
        //Initialize error message
        $katb_input_error = '';
        //Initialize session variable used to check if testimonial was successfully submitted
        $_SESSION['katb_submitted'] = SHA1('false');
        //Set up Form Submnitted session variable for multi input forms
        $katb_form_submitted = sanitize_text_field($_POST['katb_form_no']);
        $_SESSION['katb_form_submitted'] = SHA1($katb_form_submitted);
        //Validate-Sanitize Input
        //Set Defaults
        $katb_order = "";
        if ($auto_approve == 1) {
            $katb_approved = 1;
        } else {
            $katb_approved = 0;
        }
        //$katb_group = "";
        $katb_group = sanitize_text_field($_POST['tb_group']);
        $katb_datetime = current_time('mysql');
        //Validate-Sanitize Author
        $katb_author = sanitize_text_field($_POST['tb_author']);
        $_POST['tb_author'] = '';
        if ($katb_author == '') {
            if ($use_popup == 1) {
                $katb_input_error .= '\\n - ' . esc_html__('Author is required', 'testimonial-basics');
            } else {
                $katb_input_error .= '<br/> - ' . esc_html__('Author is required', 'testimonial-basics');
            }
        }
        //Validate-Sanitize E-mail
        $katb_email = sanitize_email($_POST['tb_email']);
        if (!is_email($katb_email)) {
            if ($use_popup == 1) {
                $katb_input_error .= '\\n - ' . esc_html__('Valid email is required', 'testimonial-basics');
            } else {
                $katb_input_error .= '<br/> - ' . esc_html__('Valid email is required', 'testimonial-basics');
            }
        }
        //Validate-Sanitize Website
        if ($exclude_website != 1) {
            $katb_website = trim($_POST['tb_website']);
            if ($katb_website != '') {
                $katb_website = esc_url($katb_website);
            } else {
                if ($require_website == 1) {
                    if ($use_popup == 1) {
                        $katb_input_error .= '\\n - ' . esc_html__('Website is required', 'testimonial-basics');
                    } else {
                        $katb_input_error .= '<br/> - ' . esc_html__('Website is required', 'testimonial-basics');
                    }
                }
            }
        } else {
            $katb_website = '';
        }
        //Validate Location
        if ($exclude_location != 1) {
            $katb_location = trim($_POST['tb_location']);
            if ($katb_location != '') {
                $katb_location = sanitize_text_field($_POST['tb_location']);
            } else {
                if ($require_location == 1) {
                    if ($use_popup == 1) {
                        $katb_input_error .= '\\n - ' . esc_html__('Location is required', 'testimonial-basics');
                    } else {
                        $katb_input_error .= '<br/> - ' . esc_html__('Location is required', 'testimonial-basics');
                    }
                }
            }
        } else {
            $katb_location = '';
        }
        //validate rating
        if ($use_ratings == 1) {
            $katb_rating = sanitize_text_field($_POST['tb_rating']);
            if ($katb_rating == '0') {
                $katb_rating = '0.0';
            }
            if ($katb_rating == '1') {
                $katb_rating = '1.0';
            }
            if ($katb_rating == '2') {
                $katb_rating = '2.0';
            }
            if ($katb_rating == '3') {
                $katb_rating = '3.0';
            }
            if ($katb_rating == '4') {
                $katb_rating = '4.0';
            }
            if ($katb_rating == '5') {
                $katb_rating = '5.0';
            }
        }
        //Validate-Sanitize Testimonial
        $katb_testimonial = wp_kses($_POST['tb_testimonial'], $katb_allowed_html);
        if ($katb_testimonial == "") {
            if ($use_popup == 1) {
                $katb_input_error .= '\\n - ' . esc_html__('Testimonial is required', 'testimonial-basics');
            } else {
                $katb_input_error .= '<br/> - ' . esc_html__('Testimonial is required', 'testimonial-basics');
            }
        }
        //Captcha Check
        if ($katb_options['katb_use_captcha'] == TRUE || $katb_options['katb_use_captcha'] == 1) {
            $katb_captcha_entered = sanitize_text_field($_POST['verify']);
            if ($_SESSION['katb_pass_phrase'] !== sha1($katb_captcha_entered)) {
                if ($use_popup == 1) {
                    $katb_input_error .= '\\n - ' . esc_html__('Captcha is invalid - please try again', 'testimonial-basics');
                } else {
                    $katb_input_error .= '<br/> - ' . esc_html__('Captcha is invalid - please try again', 'testimonial-basics');
                }
            }
        }
        //Validation complete
        if ($katb_input_error == "") {
            //OK $katb_input_error is empty so let's update the database
            $values = array('tb_date' => $katb_datetime, 'tb_order' => $katb_order, 'tb_approved' => $katb_approved, 'tb_group' => $katb_group, 'tb_name' => $katb_author, 'tb_email' => $katb_email, 'tb_location' => $katb_location, 'tb_url' => $katb_website, 'tb_pic_url' => '', 'tb_rating' => $katb_rating, 'tb_testimonial' => $katb_testimonial);
            $formats_values = array('%s', '%d', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');
            $wpdb->insert($tablename, $values, $formats_values);
            //send email
            if (isset($katb_options['katb_contact_email']) && $katb_options['katb_contact_email'] != '') {
                $emailTo = $katb_options['katb_contact_email'];
            } else {
                $emailTo = get_option('admin_email');
            }
            $subject = esc_html__('You have received a testimonial!', 'testimonial-basics');
            $body = esc_html__('Name: ', 'testimonial-basics') . ' ' . stripcslashes($katb_author) . "<br/><br/>" . esc_html__('Email: ', 'testimonial-basics') . ' ' . stripcslashes($katb_email) . "<br/><br/>" . esc_html__('Comments: ', 'testimonial-basics') . "<br/><br/>" . stripcslashes($katb_testimonial) . "<br/><br/>" . esc_html__('Log in to approve or view it:', 'testimonial-basics') . '<a href="' . site_url("/wp-login.php") . '" title="your site login">Log In</a>';
            $headers = 'From: ' . stripcslashes($katb_author) . ' <' . stripcslashes($katb_email) . '>';
            add_filter('wp_mail_content_type', create_function('', 'return "text/html";'));
            wp_mail($emailTo, $subject, $body, $headers);
            //Now empty the variables
            $katb_id = "";
            $katb_order = "";
            $katb_approved = "";
            $katb_date = "";
            $katb_time = "";
            $katb_author = "";
            $katb_website = "";
            $katb_location = "";
            $katb_testimonial = "";
            $katb_email = "";
            $katb_rating = "0.0";
            //set testimonial submitted flag
            $_SESSION['katb_submitted'] = SHA1('true');
            //Redirect and load to reset post variables
            //$redirect = katb_current_page_url();
            //wp_redirect( $redirect );
            //exit;
        }
    } else {
        $katb_id = "";
        $katb_order = "";
        $katb_approved = "";
        $katb_date = "";
        $katb_time = "";
        $katb_author = "";
        $katb_website = "";
        $katb_location = "";
        $katb_testimonial = "";
        $katb_email = "";
        $katb_rating = "";
    }
    /* ---------- Reset button is clicked ---------------- */
    if (isset($_POST['katb_reset'])) {
        $katb_author = "";
        $katb_email = "";
        $katb_website = "";
        $katb_location = "";
        $katb_testimonial = "";
        $katb_rating = "";
    }
}