/home/arranoyd/magicraft/wp-content/plugins/formcraft35/formcraft-main.php
<?php
/*
Plugin Name: FormCraft
Plugin URI: http://formcraft-wp.com
Description: Premium WordPress form and survey builder. Make amazing forms, incredibly fast.
Author: nCrafts
Author URI: http://ncrafts.net
Version: 3.2.25
Text Domain: formcraft
*/
global $fc_meta, $fc_forms_table, $fc_progress_table, $fc_submissions_table, $fc_views_table, $fc_files_table, $wpdb, $fc_addons;
$fc_addons = array();
$fc_templates = array();
$fc_triggers = array();
$fc_templates['General'] = plugin_dir_path( __FILE__ ).'templates/';
$fc_meta['version'] = '3.2.25';
$fc_meta['f3_multi_site_addon'] = is_multisite() ? false : true;
$fc_meta['user_can'] = get_site_url() == 'http://formcraft-wp.com/demo' ? 'read' : 'activate_plugins';
$fc_meta['preview_mode'] = get_site_url() == 'http://formcraft-wp.com/demo' ? true : false;
$fc_forms_table = $wpdb->prefix . "formcraft_3_forms";
$fc_submissions_table = $wpdb->prefix . "formcraft_3_submissions";
$fc_views_table = $wpdb->prefix . "formcraft_3_views";
$fc_progress_table = $wpdb->prefix . "formcraft_3_progress";
$fc_files_table = $wpdb->prefix . "formcraft_3_files";
/*
Create the necessary tables on plugin activation
*/
function formcraft3_activate()
{
global $fc_meta, $fc_forms_table, $fc_submissions_table, $fc_views_table, $fc_files_table, $fc_progress_table, $wpdb;
if ( !is_multisite() )
{
require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
$charset_collate = $wpdb->get_charset_collate();
$sql = "CREATE TABLE $fc_progress_table (id mediumint(9) NOT NULL AUTO_INCREMENT, uniq_key tinytext NOT NULL, form INT NOT NULL, content MEDIUMTEXT NULL, created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, modified datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, to_delete datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, UNIQUE KEY id (id)) $charset_collate;";
dbDelta( $sql );
$sql = "CREATE TABLE $fc_forms_table (id mediumint(9) NOT NULL AUTO_INCREMENT, counter INT NOT NULL,name tinytext NOT NULL,created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,modified datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,html MEDIUMTEXT NULL,builder MEDIUMTEXT NULL,addons MEDIUMTEXT NULL,meta_builder MEDIUMTEXT NULL, old_url tinytext NULL, imported INT NULL,UNIQUE KEY id (id)) $charset_collate;";
dbDelta( $sql );
$sql = "CREATE TABLE $fc_submissions_table (id mediumint(9) NOT NULL AUTO_INCREMENT,form INT NOT NULL,form_name tinytext NOT NULL,created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,content MEDIUMTEXT NULL,visitor MEDIUMTEXT NULL,UNIQUE KEY id (id)) $charset_collate;";
dbDelta( $sql );
$sql = "CREATE TABLE $fc_views_table (id mediumint(9) NOT NULL AUTO_INCREMENT,form INT NOT NULL,views INT NOT NULL,submissions INT NOT NULL, payment FLOAT NOT NULL DEFAULT '0',_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,UNIQUE KEY id (id)) $charset_collate;";
dbDelta( $sql );
$sql = "CREATE TABLE $fc_files_table (id mediumint(9) NOT NULL AUTO_INCREMENT, uniq_key tinytext NOT NULL, name VARCHAR(255) NOT NULL,form INT NOT NULL,submission INT NULL, permanent tinyint(1) NOT NULL, mime VARCHAR(255) NOT NULL, size INT NOT NULL, file_url VARCHAR(1000) NOT NULL,file_path VARCHAR(1000) NOT NULL,created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,UNIQUE KEY id (id)) $charset_collate;";
dbDelta( $sql );
formcraft3_check_for_imports();
}
}
register_activation_hook( __FILE__, 'formcraft3_activate' );
add_action('wp_ajax_formcraft3_verify_license', 'formcraft3_verify_license');
function formcraft3_verify_license()
{
global $wp_version, $fc_meta, $fc_forms_table, $fc_progress_table, $fc_submissions_table, $fc_views_table, $fc_files_table, $wpdb, $fc_addons;
$_POST['key'] = trim($_POST['key']);
$_POST['email'] = trim($_POST['email']);
if ( empty($_POST['key']) )
{
echo json_encode(array('failed'=>'License Key can\'t be empty'));
die();
}
if ( empty($_POST['email']) )
{
echo json_encode(array('failed'=>'Email can\'t be empty'));
die();
}
if ( filter_var( $_POST['email'], FILTER_VALIDATE_EMAIL ) == false )
{
echo json_encode(array('failed'=>'Invalid email'));
die();
}
$_POST['key'] = rawurlencode($_POST['key']);
$_POST['email'] = rawurlencode($_POST['email']);
$args = array(
'timeout' => 15,
'redirection' => 5,
'sslverify' => false
);
$response = wp_remote_get("http://formcraft-wp.com?type=register_license&key=".$_POST['key']."&site=".rawurlencode(site_url())."&email=".$_POST['email'].'&v=2');
if ( is_wp_error( $response ) ) {
echo json_encode(array('failed'=>$response->get_error_message()));
die();
}
$response = json_decode($response['body'], 1);
if ( $response==NULL || empty($response) )
{
echo json_encode(array('failed'=>__('Could not connect','formcraft')));
die();
}
else if ( isset($response['success']) )
{
update_site_option( 'f3_purchased', $response['purchased'] );
update_site_option( 'f3_expires', $response['expires'] );
update_site_option( 'f3_registered', $response['registered'] );
update_site_option( 'f3_key', $_POST['key'] );
update_site_option( 'f3_blog_id', get_current_blog_id() );
update_site_option( 'f3_email', $_POST['email'] );
update_site_option( 'f3_verified', 'yes' );
if ( is_multisite() )
{
require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
$charset_collate = $wpdb->get_charset_collate();
if($wpdb->get_var("SHOW TABLES LIKE '$fc_progress_table'") != $fc_progress_table) {
$sql = "CREATE TABLE $fc_progress_table (id mediumint(9) NOT NULL AUTO_INCREMENT, uniq_key tinytext NOT NULL, form INT NOT NULL, content MEDIUMTEXT NULL, created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, modified datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, to_delete datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, UNIQUE KEY id (id)) $charset_collate;";
dbDelta( $sql );
}
if($wpdb->get_var("SHOW TABLES LIKE '$fc_forms_table'") != $fc_forms_table) {
$sql = "CREATE TABLE $fc_forms_table (id mediumint(9) NOT NULL AUTO_INCREMENT, counter INT NOT NULL,name tinytext NOT NULL,created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,modified datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,html MEDIUMTEXT NULL,builder MEDIUMTEXT NULL,addons MEDIUMTEXT NULL,meta_builder MEDIUMTEXT NULL, old_url tinytext NULL, imported INT NULL,UNIQUE KEY id (id)) $charset_collate;";
dbDelta( $sql );
}
if($wpdb->get_var("SHOW TABLES LIKE '$fc_submissions_table'") != $fc_submissions_table) {
$sql = "CREATE TABLE $fc_submissions_table (id mediumint(9) NOT NULL AUTO_INCREMENT,form INT NOT NULL,form_name tinytext NOT NULL,created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,content MEDIUMTEXT NULL,visitor MEDIUMTEXT NULL,UNIQUE KEY id (id)) $charset_collate;";
dbDelta( $sql );
}
if($wpdb->get_var("SHOW TABLES LIKE '$fc_views_table'") != $fc_views_table) {
$sql = "CREATE TABLE $fc_views_table (id mediumint(9) NOT NULL AUTO_INCREMENT,form INT NOT NULL,views INT NOT NULL,submissions INT NOT NULL, payment FLOAT NOT NULL DEFAULT '0',_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,UNIQUE KEY id (id)) $charset_collate;";
dbDelta( $sql );
}
if($wpdb->get_var("SHOW TABLES LIKE '$fc_files_table'") != $fc_files_table) {
$sql = "CREATE TABLE $fc_files_table (id mediumint(9) NOT NULL AUTO_INCREMENT, uniq_key tinytext NOT NULL, name VARCHAR(255) NOT NULL,form INT NOT NULL,submission INT NULL, permanent tinyint(1) NOT NULL, mime VARCHAR(255) NOT NULL, size INT NOT NULL, file_url VARCHAR(1000) NOT NULL,file_path VARCHAR(1000) NOT NULL,created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,UNIQUE KEY id (id)) $charset_collate;";
dbDelta( $sql );
}
formcraft3_check_for_imports();
}
$response['purchased'] = date(get_option('date_format'),$response['purchased']);
$response['expires'] = date(get_option('date_format'),$response['expires']);
$response['registered'] = date(get_option('date_format'),$response['registered']);
echo json_encode($response);
die();
}
else
{
echo json_encode(array('failed'=>$response['failed']));
die();
}
}
class FormCraft_Plugin_Updater {
private $slug;
private $pluginData;
private $username;
private $repo;
private $pluginFile;
private $githubAPIResult;
private $accessToken;
private $pluginActivated;
function __construct( $pluginFile, $gitHubUsername, $gitHubProjectName, $accessToken = '' ) {
add_filter( "pre_set_site_transient_update_plugins", array( $this, "setTransitent" ) );
add_filter( "plugins_api", array( $this, "setPluginInfo" ), 10, 3 );
add_filter( "upgrader_pre_install", array( $this, "preInstall" ), 10, 3 );
add_filter( "upgrader_post_install", array( $this, "postInstall" ), 10, 3 );
$this->pluginFile = $pluginFile;
$this->username = $gitHubUsername;
$this->repo = $gitHubProjectName;
$this->accessToken = $accessToken;
}
private function initPluginData() {
$this->slug = plugin_basename( $this->pluginFile );
$this->pluginData = get_plugin_data( $this->pluginFile );
}
private function getRepoReleaseInfo() {
$result = wp_remote_get('http://formcraft-wp.com?type=release_info&repo='.$this->repo);
$result = wp_remote_retrieve_body($result);
$this->githubAPIResult = json_decode($result);
}
public function setTransitent( $transient ) {
$this->initPluginData();
$this->getRepoReleaseInfo();
if ( get_site_option( 'f3_expires' )==NULL )
{
return $transient;
}
$expires_time = get_site_option( 'f3_expires' );
if ( ($expires_time-strtotime('now'))/(60 * 60 * 24)<0 )
{
return $transient;
}
if ( empty( $transient->checked ) || empty( $this->githubAPIResult->tag_name ) ) {
return $transient;
}
$doUpdate = version_compare( $this->githubAPIResult->tag_name, $transient->checked[$this->slug] );
if ( $doUpdate == 1 ) {
$tempSlug = explode('/', $this->slug);
$package = $this->githubAPIResult->zipball_url;
$obj = new stdClass();
$obj->slug = sanitize_title_with_dashes($tempSlug[0]);
$obj->new_version = $this->githubAPIResult->tag_name;
$obj->url = $this->pluginData["PluginURI"];
$obj->package = $package;
$transient->response[$this->slug] = $obj;
}
return $transient;
}
public function setPluginInfo( $false, $action, $response ) {
$this->initPluginData();
$this->getRepoReleaseInfo();
$compareSlug = explode('/', $this->slug);
$compareSlug = sanitize_title_with_dashes($compareSlug[0]);
if ( empty( $response->slug ) || ( $response->slug != $compareSlug && $response->slug != $this->slug ) ) {
return $false;
}
require_once( plugin_dir_path( __FILE__ ) . "php/Parser.lib.php" );
require_once( plugin_dir_path( __FILE__ ) . "php/Parsedown.php" );
$response->last_updated = $this->githubAPIResult->published_at;
$response->slug = $this->slug;
$response->plugin_name = $this->pluginData["Name"];
$response->name = $this->pluginData["Name"];
$response->version = $this->githubAPIResult->tag_name;
$response->author = $this->pluginData["AuthorName"];
$response->homepage = $this->pluginData["PluginURI"];
// This is our release download zip file
$downloadLink = $this->githubAPIResult->zipball_url;
$response->download_link = $downloadLink;
$response->sections = array(
'changelog' => class_exists( "Parsedown" )
? Parsedown::instance()->parse( $this->githubAPIResult->body )
: $this->githubAPIResult->body
);
// Gets the required version of WP if available
$matches = null;
preg_match( "/requires:\s([\d\.]+)/i", $this->githubAPIResult->body, $matches );
if ( ! empty( $matches ) ) {
if ( is_array( $matches ) ) {
if ( count( $matches ) > 1 ) {
$response->requires = $matches[1];
}
}
}
// Gets the tested version of WP if available
$matches = null;
preg_match( "/tested:\s([\d\.]+)/i", $this->githubAPIResult->body, $matches );
if ( ! empty( $matches ) ) {
if ( is_array( $matches ) ) {
if ( count( $matches ) > 1 ) {
$response->tested = $matches[1];
}
}
}
return $response;
}
public function preInstall( $true, $args )
{
$this->initPluginData();
$this->pluginActivated = is_plugin_active( $this->slug );
}
public function postInstall( $true, $hook_extra, $result ) {
$this->initPluginData();
global $wp_filesystem;
if ( isset($_GET['plugin']) && $_GET['plugin']!=$this->slug )
{
return $true;
}
if ( isset($_GET['plugin']) )
{
$pluginFolder = WP_PLUGIN_DIR . DIRECTORY_SEPARATOR . dirname( $this->slug );
$result['destination'] = substr($result['destination'], 0, -1);
$wp_filesystem->move( $pluginFolder, $pluginFolder.'-temp', true );
$wp_filesystem->move( $result['destination'], $pluginFolder, true );
$wp_filesystem->delete( $pluginFolder.'-temp', true );
$result['destination'] = $pluginFolder;
if ( $this->pluginActivated )
{
$activate = activate_plugin( $this->slug );
}
return $result;
}
else
{
$pluginFolder = WP_PLUGIN_DIR . DIRECTORY_SEPARATOR . dirname( $this->slug );
$wp_filesystem->move( $result['destination'], $pluginFolder );
$result['destination'] = $pluginFolder;
if ( $this->pluginActivated )
{
$activate = activate_plugin( $this->slug );
}
return $result;
}
}
}
if ( is_admin() ) {
new FormCraft_Plugin_Updater( __FILE__, 'ncrafts', "formcraft3" );
}
function formcraft3_check_for_imports()
{
global $wpdb, $fc_forms_table;
$table_name = $wpdb->prefix . "formcraft_builder";
if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) {
return false;
}
$all_data = $wpdb->get_results( "SELECT * FROM $table_name" , ARRAY_A);
foreach ($all_data as $key => $value) {
if($wpdb->get_var( "SELECT COUNT(*) FROM $fc_forms_table WHERE imported=$value[id]" )!=0){continue;}
$form_name = $value['name'];
$builder = $value['build'].'[BREAK]'.$value['options'].'[BREAK]'.$value['con'].'[BREAK]'.$value['recipients'];
$rows_affected = $wpdb->insert( $fc_forms_table, array(
'name' => $form_name,
'created' => current_time('mysql'),
'modified' => current_time('mysql'),
'builder' => $builder,
'imported' => $value['id']
) );
}
}
/*
Add-On Framework
*/
function register_formcraft_addon($content, $plugin_id, $title, $controller, $logo=false, $templates=false,$trigger=false)
{
global $fc_addons, $fc_templates, $fc_triggers;
$plugin_id = $plugin_id==0 ? false : $plugin_id;
$controller = $controller==false ? '' : $controller;
$logo = $logo==false || $logo=='' ? plugins_url('assets/images/add-on-logo.png', __FILE__ ) : $logo;
$fc_addons[] = array('content_fn'=>$content,'plugin_id'=>$plugin_id,'title'=>$title,'controller'=>$controller,'logo'=>$logo);
$fc_templates[$title] = $templates;
if ( $trigger == true )
{
$fc_triggers[] = $title;
}
}
function formcraft_get_addon_data($addon, $id)
{
global $wpdb, $fc_forms_table;
if ( !isset($id) || !ctype_digit($id) )
{
return false;
}
$qry = $wpdb->get_var( "SELECT addons FROM $fc_forms_table WHERE id='$id'" );
$data = json_decode(stripcslashes($qry),1);
if ( isset($data[$addon]) )
{
return $data[$addon];
}
else
{
return false;
}
}
function formcraft_add_dashboard_widgets() {
wp_add_dashboard_widget(
'formcraft_dashboard_widget',
__('FormCraft Today','formcraft'),
'formcraft_dashboard_widget_function'
);
}
add_action( 'wp_dashboard_setup', 'formcraft_add_dashboard_widgets' );
function formcraft_dashboard_widget_function() {
global $wpdb, $fc_views_table;
$from = date('Y-m-d 00:00:00', time());
$views = $wpdb->get_var( "SELECT SUM(views) FROM $fc_views_table WHERE _date = '$from'");
$submissions = $wpdb->get_var( "SELECT SUM(submissions) FROM $fc_views_table WHERE _date = '$from'");
$payment = $wpdb->get_var( "SELECT SUM(payment) FROM $fc_views_table WHERE _date = '$from'");
$views = empty($views) ? 0 : $views;
$submissions = empty($submissions) ? 0 : $submissions;
$conversion = $views == 0 ? 0 : round(($submissions / $views)*10000)/100;
$conversion2 = $views == 0 ? 0 : round(($payment / $views)*10000)/100;
if ($payment>0)
{
echo "
<div style='letter-spacing: -4px'>
<div style='width: 20%; margin: 20px auto; letter-spacing: 0; display: inline-block; text-align: center; font-size: 20px; color: #999'>$views<span style='display: block; font-size: 11px; margin-top: 10px; font-weight: bold; letter-spacing: .6px; color: rgba(237, 133, 66,.92)'>".__('FORM VIEWS','formcraft')."</span></div>
<div style='width: 20%; margin: 20px auto; letter-spacing: 0; display: inline-block; text-align: center; font-size: 20px; color: #999'>$submissions<span style='display: block; font-size: 11px; margin-top: 10px; font-weight: bold; letter-spacing: .6px; color: rgba(59,161,218, .9)'>".__('SUBMISSIONS','formcraft')."</span></div>
<div style='width: 20%; margin: 20px auto; letter-spacing: 0; display: inline-block; text-align: center; font-size: 20px; color: #999'>$conversion%<span style='display: block; font-size: 11px; margin-top: 10px; font-weight: bold; letter-spacing: .6px; color: rgba(59,161,218, .9)'>".__('CONVERSION','formcraft')."</span></div>
<div style='width: 20%; margin: 20px auto; letter-spacing: 0; display: inline-block; text-align: center; font-size: 20px; color: #999'>$payment<span style='display: block; font-size: 11px; margin-top: 10px; font-weight: bold; letter-spacing: .6px; color: rgb(93, 168, 93)'>".__('CHARGES','formcraft')."</span></div>
<div style='width: 20%; margin: 20px auto; letter-spacing: 0; display: inline-block; text-align: center; font-size: 20px; color: #999'>$conversion2%<span style='display: block; font-size: 11px; margin-top: 10px; font-weight: bold; letter-spacing: .6px; color: rgb(93, 168, 93)'>".__('CONVERSION','formcraft')."</span></div>
</div>
";
}
else
{
echo "
<div style='letter-spacing: -4px'>
<div style='width: 33.3%; margin: 20px auto; letter-spacing: 0; display: inline-block; text-align: center; font-size: 20px; color: #999'>$views<span style='display: block; font-size: 11px; margin-top: 10px; font-weight: bold; letter-spacing: .6px; color: rgba(237, 133, 66,.92)'>".__('FORM VIEWS','formcraft')."</span></div>
<div style='width: 33.3%; margin: 20px auto; letter-spacing: 0; display: inline-block; text-align: center; font-size: 20px; color: #999'>$submissions<span style='display: block; font-size: 11px; margin-top: 10px; font-weight: bold; letter-spacing: .6px; color: rgba(59,161,218, .9)'>".__('SUBMISSIONS','formcraft')."</span></div>
<div style='width: 33.3%; margin: 20px auto; letter-spacing: 0; display: inline-block; text-align: center; font-size: 20px; color: #999'>$conversion%<span style='display: block; font-size: 11px; margin-top: 10px; font-weight: bold; letter-spacing: .6px; color: rgba(59,161,218, .9)'>".__('CONVERSION','formcraft')."</span></div>
</div>";
}
}
/* Add-On Install - Little Ugly */
add_action('wp_ajax_formcraft3_install_plugin', 'formcraft3_install_plugin');
function formcraft3_install_plugin()
{
global $fc_addons, $fc_meta;
if ( $fc_meta['preview_mode']==true ) {
echo json_encode(array('failed'=>'Can\'t install plugins in demo mode')); die();
}
do_action('formcraft_addon_init');
$plugin = intval($_POST['plugin']);
$result = wp_remote_get('http://formcraft-wp.com?type=download_plugin&id='.$plugin.'&key='.get_site_option('f3_key'));
if ( is_wp_error( $result ) ) {
$error_string = $result->get_error_message();
echo json_encode(array('failed'=>$error_string));
die();
}
$result = json_decode($result['body'], 1);
if ( isset($result['failed']) )
{
echo json_encode(array('failed'=>$result['failed']));
die();
}
else if ( !isset($result['success']) )
{
echo json_encode(array('failed'=>__('Unknwon error','formcraft')));
die();
}
$plugin_file = $result['file'];
if ( file_exists(WP_PLUGIN_DIR . DIRECTORY_SEPARATOR . $result['github-repo']) )
{
echo json_encode(array('failed'=>__('Plugin / Add-On is already installed. Please go to the Wordpress Plugins page and activate it.','formcraft')));
die();
}
require_once ABSPATH . 'wp-admin/includes/plugin-install.php';
require_once ABSPATH . 'wp-admin/includes/class-wp-upgrader.php';
class Plugin_Installer_Skin_B extends Plugin_Installer_Skin
{
public $done_header = true;
public $done_footer = true;
public function feedback($string)
{
if ( strpos($string, 'Destination folder already exists.') !== false ) {
echo json_encode(array('failed'=>__('Plugin already installed. Maybe not activated?','formcraft')));
die();
}
}
}
$plugin_obj = new Plugin_Upgrader( $skin = new Plugin_Installer_Skin_B( compact( 'type', 'title', 'url', 'nonce', 'plugin', 'api' ) ) );
$installed = $plugin_obj->install($plugin_file);
$info = $plugin_obj->plugin_info();
$old_location = rtrim(plugin_dir_path($info), '/');
rename(WP_PLUGIN_DIR . DIRECTORY_SEPARATOR . $old_location, WP_PLUGIN_DIR . DIRECTORY_SEPARATOR . $result['github-repo']);
$info = str_replace($old_location, $result['github-repo'], $info);
if ($installed==true)
{
$activated = activate_plugin($info);
if ($activated==NULL)
{
echo json_encode(array('success'=>'true','plugin'=>$plugin));
die();
}
else
{
echo json_encode(array('failed'=>__('Could not activate plugin','formcraft')));
die();
}
}
else
{
echo json_encode(array('failed'=>__('Could not install plugin','formcraft')));
die();
}
die();
}
add_action('wp_ajax_formcraft3_get_stats', 'formcraft3_get_stats');
function formcraft3_get_stats()
{
global $fc_meta, $fc_views_table, $wpdb;
$from = $_GET['from'];
$to = $_GET['to'];
$form = intval($_GET['form']);
$from = date('Y-m-d 00:00:00', strtotime($from));
$to = date('Y-m-d 00:00:00', strtotime('+1day', strtotime($to)));
if ($form==0)
{
$all_data = $wpdb->get_results( "SELECT * FROM $fc_views_table WHERE _date > '$from' AND _date <= '$to'" , ARRAY_A);
}
else
{
$all_data = $wpdb->get_results( "SELECT * FROM $fc_views_table WHERE form = '$form' AND _date > '$from' AND _date <= '$to'" , ARRAY_A);
}
$temp = array();
foreach ($all_data as $key => $value) {
if ( isset($temp[$value['_date']]) )
{
$temp[$value['_date']]['views'] = $temp[$value['_date']]['views'] + $value['views'];
$temp[$value['_date']]['submissions'] = $temp[$value['_date']]['submissions'] + $value['submissions'];
$temp[$value['_date']]['payment'] = $temp[$value['_date']]['payment'] + $value['payment'];
}
else
{
$temp[$value['_date']] = $value;
}
}
$all_data = $temp;
$difference = (strtotime($to)-strtotime($from))/(60*60*24);
$i = 1;
$outputV = array();
$outputS = array();
$outputP = array();
$labels = array();
while ($i<=$difference)
{
$this_date = $to = date('Y-m-d 00:00:00', strtotime('+'.$i.'day', strtotime($from)));
if (isset($all_data[$this_date]))
{
$labels[] = date('d M', strtotime($this_date));
$outputV[] = intval($all_data[$this_date]['views']);
$outputS[] = intval($all_data[$this_date]['submissions']);
$outputP[] = intval($all_data[$this_date]['payment']);
}
else
{
$labels[] = date('d M', strtotime($this_date));
$outputV[] = 0;
$outputS[] = 0;
$outputP[] = 0;
}
$i++;
}
$max_points = 20;
$nos = ceil(count($outputV)/$max_points);
if ($nos>2)
{
$labels = compressStats($labels,$max_points, 'string');
$outputV = compressStats($outputV,$max_points, 'int');
$outputS = compressStats($outputS,$max_points, 'int');
$outputP = compressStats($outputP,$max_points, 'int');
}
echo json_encode(array('success'=>'true','labels'=>$labels,'views'=>$outputV,'submissions'=>$outputS,'payments'=>$outputP));
die();
}
function compressStats($input, $max_points, $type)
{
$x = 0;
$nos = ceil(count($input)/$max_points);
$newOutput = array();
do {
$temp1 = array();
$temp1 = array_slice($input, $x*$nos, $nos);
$temp2 = 0;
foreach ($temp1 as $key => $value) {
if ($type=='int')
{
$temp2 = $value + $temp2;
}
else
{
$temp2 = $temp1[0].' - '.$temp1[ count($temp1) -1 ];
}
}
$newOutput[] = $temp2;
$x++;
} while ($x<$max_points);
return $newOutput;
}
/* Check if the User is Visiting a Form Page */
add_action('template_redirect', 'formcraft3_redirect_to_form_page', 1);
function formcraft3_redirect_to_form_page()
{
global $fc_meta, $fc_forms_table, $fc_progress_table, $wpdb;
if(formcraft3_check_form_page())
{
$form_id = formcraft3_check_form_page();
if(formcraft3_check_form_page_access($form_id))
{
$qry = $wpdb->get_var( "SELECT meta_builder FROM $fc_forms_table WHERE id='$form_id'" );
$qry = json_decode( stripcslashes($qry) , 1);
wp_enqueue_style('fc-form-page-css', plugins_url( 'assets/css/form-page.css', __FILE__ ),array(), $fc_meta['version']);
add_action('wp_head','formcraft3_wp_head');
echo '<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" '; ?><?php language_attributes(); ?><?php echo '>
<head>';
?>
<meta http-equiv="Content-Type" content="<?php bloginfo('html_type'); ?>; charset=<?php bloginfo('charset'); ?>" />
<?php
remove_theme_support('title-tag');
$title = formcraft3_page_title();
echo "<title>$title</title>";
wp_head();
echo '</head>';
if ( is_user_logged_in() && isset($_GET['preview']) )
{
echo "<div id='fc-form-preview'>Form Preview</div>";
}
echo "<div class='fc-form-tip-cover'>";
if ( isset($qry['emailRecipients']) && $qry['emailRecipients']=='' && isset($_GET['preview']) )
{
echo "<div class='fc-form-tip'>To send form notifications to emails, add an email address to<br><strong>Options → Email → Email Notifications → Send Email(s) To</strong></div>";
}
echo "</div>";
echo '<div class="dedicated-page">';
echo do_shortcode("[fc id='$form_id' align='center'][/fc]");
echo "</div>";
wp_footer();
die();
}
}
}
function formcraft3_page_title() {
global $fc_meta, $fc_forms_table, $wpdb;
$url = explode('/',str_ireplace('?preview=true', '', $_SERVER["REQUEST_URI"]));
$form_id = $url[ (count($url)-1) ];
$qry = $wpdb->get_var( "SELECT name FROM $fc_forms_table WHERE id='$form_id'" );
return $qry.' - '.get_bloginfo('name');
}
function formcraft3_wp_head()
{
global $fc_meta, $fc_forms_table, $wpdb;
$url = explode('/',str_ireplace('?preview=true', '', $_SERVER["REQUEST_URI"]));
$form_id = $url[ (count($url)-1) ];
$qry = $wpdb->get_var( "SELECT name FROM $fc_forms_table WHERE id='$form_id'" );
echo '<meta name="viewport" content="width=device-width, initial-scale=1.0">';
}
function formcraft3_check_form_page()
{
global $fc_meta, $fc_forms_table, $wpdb;
$temp_1 = str_replace('&', '/', $_SERVER["REQUEST_URI"]);
$existing = explode('/', get_site_url());
$url = explode('/',str_ireplace('?preview=true', '', $temp_1));
$url = array_filter($url);
foreach ($url as $key => $value) {
if(in_array($value,$existing))
{
unset($url[$key]);
}
}
$url = array_values($url);
if ( isset($url[0]) && isset($url[1]) && $url[0]=='form-view' && ctype_digit($url[1]) )
{
return $url[1];
}
else
{
return false;
}
}
/* Check if current requester is allowed form page access */
function formcraft3_check_form_page_access($form_id)
{
global $fc_meta, $fc_forms_table, $wpdb;
$qry = $wpdb->get_var( "SELECT meta_builder FROM $fc_forms_table WHERE id='$form_id'" );
$qry = json_decode(stripslashes($qry),1);
if(isset($qry['config']) && isset($qry['config']['disable_form_link']) && $qry['config']['disable_form_link']==true)
{
if (is_user_logged_in())
{
if (isset($_GET['preview']) && $_GET['preview']==true)
{
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}
else
{
return true;
}
}
/* Enqueue Styles on Front End Pages, Header */
add_action( 'wp_enqueue_scripts', 'formcraft3_form_styles' );
function formcraft3_form_styles()
{
global $fc_meta, $fc_forms_table, $wpdb;
$form_id = formcraft3_check_form_page();
if($form_id)
{
if(formcraft3_check_form_page_access($form_id))
{
status_header( 200 );
}
}
wp_enqueue_style('fc-form-css', plugins_url( 'assets/css/form.min.css', __FILE__ ),array(), $fc_meta['version']);
}
add_action( 'admin_enqueue_scripts', 'formcraft3_admin_scripts' );
function formcraft3_admin_scripts()
{
global $fc_meta, $fc_forms_table, $wpdb;
wp_enqueue_style('fc-icon-css', plugins_url( 'assets/formcraft-icon.css', __FILE__ ),array(), $fc_meta['version']);
}
/* Custom Add Form Button for the WP Editor */
add_action( 'media_buttons', 'formcraft3_custom_button');
function formcraft3_custom_button( ) {
global $fc_meta, $fc_forms_table, $wpdb;
if ( !current_user_can('edit_posts') || !current_user_can('edit_pages') ) { return; }
$button = '<a id="fc_afb" class="button" title="'.__('Insert FormCraft Form','formcraft').'" data-target="#fc_add_form_modal" data-toggle="fc_modal"><img style="padding-left:2px" width="12" src="'.plugins_url( 'assets/images/plus.png', __FILE__ ).'"/>' .__( 'Add Form', 'formcraft' ). '</a>';
add_action('admin_footer','formcraft3_add_modal');
wp_enqueue_style('fc-common-css', plugins_url( 'assets/css/common-elements.css', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_script('fc-modal-js', plugins_url( 'assets/js/src/fc_modal.js', __FILE__ ));
wp_enqueue_script('fc-add-form-button-js', plugins_url( 'assets/js/src/add-form-button.js', __FILE__ ));
wp_enqueue_style('fc-add-form-button-css', plugins_url( 'assets/css/add-form-button.css', __FILE__ ),array(), $fc_meta['version']);
echo $button;
}
function formcraft3_add_modal()
{
global $fc_meta, $fc_forms_table, $wpdb;
$forms = $wpdb->get_results( "SELECT id,name FROM $fc_forms_table", ARRAY_A );
echo '<div class="fc_modal formcraft-css fc_fade" id="fc_add_form_modal"><form class="fc_modal-dialog" style="width: 340px"><div class="fc_modal-content">';
echo '<div class="fc_modal-header">'.__('FormCraft','formcraft').'<button class="fc_close" type="button" class="close" data-dismiss="fc_modal" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
echo '<div class="fc_modal-body">';
if ( count($forms)!=0 )
{
echo "<div class='fc-modal-head'>".__('Select Form','formcraft')."</div>";
foreach ($forms as $key => $value) {
if ( $value['name']=='' ) { continue; }
echo "<label class='select-form'><input ".($key==0?"checked ":"")."type='radio' value='".$value['id']."' name='fc_form_id'/>".$value['name']."</label>";
}
echo "<br><div class='fc-modal-head'>".__('Select Embed Type','formcraft')."</div>";
echo "<label class='select-alignment'><input checked type='radio' value='inline' name='fc_form_type'/>".__('Inline Form','formcraft')."</label>";
echo "<label class='select-alignment'><input type='radio' value='popup' name='fc_form_type'/>".__('Popup Form','formcraft')."</label>";
echo "<label class='select-alignment'><input type='radio' value='slide' name='fc_form_type'/>".__('Slide In Form','formcraft')."</label>";
echo "<br><div id='fc_form_type_inline'><div class='fc-modal-head'>".__('Select Alignment','formcraft')."</div>";
echo "<label class='select-alignment'><input checked type='radio' value='left' name='fc_form_align'/>".__('Left','formcraft')."</label>";
echo "<label class='select-alignment'><input type='radio' value='center' name='fc_form_align'/>".__('Center','formcraft')."</label>";
echo "<label class='select-alignment'><input type='radio' value='right' name='fc_form_align'/>".__('Right','formcraft')."</label><br></div>";
echo "<div id='fc_form_type_popup'><div class='fc-modal-head'>".__('Select Button Placement','formcraft')."</div>";
echo "<label class='select-alignment'><input checked type='radio' value='left' name='fc_form_btn_align'/>".__('Left','formcraft')."</label>";
echo "<label class='select-alignment'><input type='radio' value='inline' name='fc_form_btn_align'/>".__('Inline','formcraft')."</label>";
echo "<label class='select-alignment'><input type='radio' value='right' name='fc_form_btn_align'/>".__('Right','formcraft')."</label><br></div>";
echo "<div id='fc_form_type_slide'><div class='fc-modal-head'>".__('Select Button Placement','formcraft')."</div>";
echo "<label class='select-alignment'><input checked type='radio' value='left' name='fc_form_btn_align'/>".__('Left','formcraft')."</label>";
echo "<label class='select-alignment'><input type='radio' value='right' name='fc_form_btn_align'/>".__('Right','formcraft')."</label>";
echo "<label class='select-alignment'><input type='radio' value='bottom-right' name='fc_form_btn_align'/>".__('Bottom Right','formcraft')."</label><br></div>";
echo "<input id='fc_button_text' type='text' placeholder='".__('Button Text / Image URL','formcraft')."'/>";
}
else
{
echo "<center style='letter-spacing:0'>".__("You have no forms","formcraft3")."</center>";
}
echo '</div>';
if ( count($forms)!=0 )
{
echo '<div class="fc_modal-footer"><button type="submit" class="button" id="fc_add_form_to_editor">'.__('Add Form','formcraft').'</button></div>';
}
echo '</div></form></div>';
}
add_action('wp_ajax_formcraft3_trigger_view', 'formcraft3_trigger_view');
add_action('wp_ajax_nopriv_formcraft3_trigger_view', 'formcraft3_trigger_view');
function formcraft3_trigger_view()
{
if ( !isset($_GET['id']) || !ctype_digit($_GET['id']) )
{
return false;
}
formcraft3_new_view($_GET['id']);
}
/* Register a Form View */
function formcraft3_new_view($form_id)
{
global $fc_meta, $fc_forms_table, $fc_submissions_table, $fc_views_table, $wpdb;
if ( !strpos($_SERVER["REQUEST_URI"], '?preview=true') && ctype_digit($form_id))
{
if(!isset($_COOKIE["fc_".$form_id])) {
/* 30 min window for counting another view by same user */
if (!headers_sent()) {
setcookie("fc_".$form_id, true, time()+1800, '/');
}
$time = date('Y-m-d 00:00:00',time()+fc_offset());
if($wpdb->get_var( "SELECT COUNT(*) FROM $fc_views_table WHERE _date = '$time' AND form = $form_id" ))
{
$existing = $wpdb->get_var( "SELECT views FROM $fc_views_table WHERE _date = '$time' AND form = $form_id" );
$wpdb->update($fc_views_table, array( 'views' => $existing+1 ), array('form'=>$form_id,'_date'=>$time));
}
else
{
$rows_affected = $wpdb->insert( $fc_views_table, array(
'form' => $form_id,
'views' => 1,
'_date' => $time
) );
}
}
}
}
/* Register a Form Submission */
function formcraft3_new_submission($form_id, $payment)
{
global $fc_meta, $fc_forms_table, $fc_submissions_table, $fc_views_table, $wpdb;
if ( !strpos($_SERVER["REQUEST_URI"], '?preview=true') && ctype_digit($form_id))
{
setcookie("fc_sb_".$form_id, true, time() + (10 * 365 * 24 * 60 * 60), '/');
$time = date('Y-m-d 00:00:00',time()+fc_offset());
$existing = $wpdb->get_var( "SELECT counter FROM $fc_forms_table WHERE id = '$form_id'" );
$wpdb->update($fc_forms_table, array( 'counter' => $existing+1 ), array('id'=>$form_id));
if($wpdb->get_var( "SELECT COUNT(*) FROM $fc_views_table WHERE _date = '$time' AND form = $form_id" ))
{
$existing = $wpdb->get_var( "SELECT submissions FROM $fc_views_table WHERE _date = '$time' AND form = $form_id" );
$existing_pay = $wpdb->get_var( "SELECT payment FROM $fc_views_table WHERE _date = '$time' AND form = $form_id" );
$rows_affected = $wpdb->update($fc_views_table, array( 'submissions' => $existing+1, 'payment' => $existing_pay+$payment ), array('form'=>$form_id,'_date'=>$time));
}
else
{
$rows_affected = $wpdb->insert( $fc_views_table, array(
'form' => $form_id,
'submissions' => 1,
'payment' => $payment,
'_date' => $time
) );
}
/* Check if we need to disable form */
$existing++;
$meta = $wpdb->get_var( "SELECT meta_builder FROM $fc_forms_table WHERE id = '$form_id'" );
$meta = json_decode(stripslashes($meta),1);
if ( isset($meta['config']['disable_after']) && isset($meta['config']['disable_after_nos']) && $meta['config']['disable_after']==true && ctype_digit($meta['config']['disable_after_nos']) )
{
if ($meta['config']['disable_after_nos']==$existing)
{
$meta['config']['form_disable']=true;
$meta = esc_sql(json_encode($meta));
$wpdb->update($fc_forms_table, array( 'meta_builder' => $meta ), array('id'=>$form_id));
}
}
}
}
/* Create a Custom Title for the Form Page */
function formcraft3_modify_title($title, $sep)
{
global $fc_meta, $fc_forms_table, $wpdb;
$url = explode('/',str_ireplace('?preview=true', '', $_SERVER["REQUEST_URI"]));
$form_id = $url[ (count($url)-1) ];
$qry = $wpdb->get_var( "SELECT name FROM $fc_forms_table WHERE id='$form_id'" );
return $sep." ".$qry;
}
/* Enqueue Scripts / Styles if the user is visiting the Form Page */
add_action('init','formcraft3_check');
function formcraft3_check()
{
global $fc_meta, $fc_forms_table, $fc_submissions_table, $fc_views_table, $wpdb, $fc_files_table;
do_action('formcraft_addon_init');
if ( isset($_GET['page']) && $_GET['page']=='formcraft3_dashboard' && isset($_GET['id']) )
{
remove_action( 'wp_head', 'print_emoji_detection_script', 7 );
remove_action( 'admin_print_scripts', 'print_emoji_detection_script' );
remove_action( 'wp_print_styles', 'print_emoji_styles' );
remove_action( 'admin_print_styles', 'print_emoji_styles' );
header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
}
if (is_user_logged_in() && isset($_GET['formcraft3_download_file']) )
{
$value = esc_sql($_GET['formcraft3_download_file']);
$file = $wpdb->get_row("SELECT * FROM $fc_files_table WHERE uniq_key = '$value'", ARRAY_A);
header('Content-Type: application/octet-stream');
header("Content-Transfer-Encoding: Binary");
header('Cache-Control: must-revalidate');
header("Content-disposition: attachment; filename=\"" . $file['name'] . "\"");
readfile($file['file_path']);
die();
}
if (is_user_logged_in() && isset($_GET['formcraft3_export_form']) && ctype_digit($_GET['formcraft3_export_form']) )
{
if ( !current_user_can($fc_meta['user_can']) ) { die(); }
$form_id = $_GET['formcraft3_export_form'];
$data = $wpdb->get_row( "SELECT * FROM $fc_forms_table WHERE id = '$form_id'", ARRAY_A );
$result = array();
$result['plugin'] = 'FormCraft';
$result['created'] = date('Y-m-d H:i:s',time());
$result['html'] = $data['html'];
$result['addons'] = stripslashes($data['addons']);
$result['builder'] = stripslashes($data['builder']);
$result['meta_builder'] = stripslashes($data['meta_builder']);
$result['old_url'] = site_url();
$result = json_encode($result);
header("Content-Type: text/plain");
header('Content-Disposition: attachment; filename="'.$data['name'].'.txt"');
header("Pragma: no-cache");
header("Expires: 0");
print $result;
die();
}
if (is_user_logged_in() && isset($_GET['formcraft_export_entries']) && ctype_digit($_GET['formcraft_export_entries']) )
{
$output = array();
$i = 1;
$exportFrom = isset($_GET['from']) && ctype_digit($_GET['from']) ? $_GET['from'] : 0;
$exportTo = isset($_GET['to']) && ctype_digit($_GET['to']) ? $_GET['to'] : 20000;
if ( !current_user_can($fc_meta['user_can']) ) { die(); }
$form_id = $_GET['formcraft_export_entries'];
$form_name = $wpdb->get_var( "SELECT name FROM $fc_forms_table WHERE id = '$form_id'" );
$meta = $wpdb->get_var( "SELECT meta_builder FROM $fc_forms_table WHERE id = '$form_id'" );
if ($meta==NULL) { echo "Form does not exist"; die(); }
$meta = json_decode(stripcslashes($meta),1);
$meta = $meta['fields'];
$data = $wpdb->get_results( "SELECT content, created FROM $fc_submissions_table WHERE form = '$form_id' LIMIT $exportFrom, $exportTo", ARRAY_A );
if ( count($data)==0 ) { echo "No submissions to export"; die(); }
foreach ($meta as $key2 => $value2) {
if ($value2['type']=='submit'){continue;}
$output[0][] = isset($value2['elementDefaults']['main_label']) ? $value2['elementDefaults']['main_label'] : '...';
}
$output[0][] = 'Created';
foreach ($data as $key => $entry) {
$content = json_decode(stripcslashes($entry['content']),1);
$new_content = array();
foreach ($content as $key2 => $value2) {
$new_content[$value2['identifier']] = $value2['type']=='fileupload' ? $value2['url'] : $value2['value'];
}
foreach ($meta as $key2 => $value2) {
if ($value2['type']=='submit'){continue;}
$output[$i][] = isset($new_content[$value2['identifier']]) ? $new_content[$value2['identifier']] : '';
}
$output[$i][] = $entry['created'];
$i++;
}
header('Content-Encoding: UTF-8');
header('Content-type: text/csv; charset=UTF-8');
header("Content-Disposition: attachment; filename=".urlencode($form_name).".csv");
header("Pragma: no-cache");
header("Expires: 0");
if ( isset($_GET['sep']) )
{
echo "sep=".$_GET['sep']."\n";
}
fc_output_csv($output);
die();
}
}
function formcraft3_shortcode( $atts, $content = "" ) {
global $fc_meta, $fc_forms_table, $fc_progress_table, $wpdb;
extract( shortcode_atts( array(
'id' => '1',
'align' => 'left',
'type' => 'inline',
'bind' => '',
'placement' => '',
'class' => '',
'font_color' => '',
'button_color' => '',
'class' => '',
'auto' => ''
), $atts ) );
$meta = $wpdb->get_var( "SELECT meta_builder FROM $fc_forms_table WHERE id='$id'" );
if (count($meta)==0) {
return "This form does not exist";
}
$meta = json_decode(stripcslashes($meta),1);
$load_datepicker = false;
$load_slider = false;
$load_fileupload = false;
foreach ($meta['fields'] as $key => $value) {
$load_datepicker = $value['type']=='datepicker' ? true : $load_datepicker;
$load_slider = $value['type']=='slider' ? true : $load_slider;
$load_fileupload = $value['type']=='fileupload' ? true : $load_fileupload;
}
$dependencies = array('jquery', 'jquery-ui-core','jquery-ui-mouse');
if ( $load_datepicker==true ) { $dependencies[] = 'jquery-ui-datepicker'; wp_enqueue_script('jquery-ui-datepicker'); }
if ( $load_fileupload==true ) { $dependencies[] = 'jquery-ui-widget'; wp_enqueue_script('jquery-ui-widget'); }
if ( $load_slider==true ) { $dependencies[] = 'jquery-ui-widget'; $dependencies[] = 'jquery-ui-slider'; $dependencies[] = 'jquery-ui-mouse'; }
if ( $load_fileupload==true )
{
wp_enqueue_script('fc-fileupload-js', plugins_url( 'assets/js/vendor/jquery.fileupload.js', __FILE__ ),array('jquery-ui-widget'));
wp_localize_script( 'fc-fileupload-js', 'FC_f',
array(
'ajaxurl' => admin_url( 'admin-ajax.php' )
)
);
}
wp_enqueue_script('fc-modal-js', plugins_url( 'assets/js/src/fc_modal.js', __FILE__ ));
wp_enqueue_script('fc-tooltip-js', plugins_url( 'assets/js/vendor/tooltip.min.js', __FILE__ ), array('jquery', 'fc-modal-js'));
wp_enqueue_script('fc-form-js', plugins_url( 'assets/js/form.min.js', __FILE__ ), $dependencies, $fc_meta['version']);
wp_enqueue_script('fc-toastr-js', plugins_url( 'assets/js/vendor/toastr.min.js', __FILE__ ), array('fc-form-js'));
foreach ($dependencies as $key => $value) {
wp_enqueue_script($value);
}
/* Allow Add-Ons to Load Their Scripts */
do_action('formcraft_form_scripts', $id);
if ( !empty($button_color) && $placement!='left' && $placement!='right' )
{
$class = 'simple_button';
}
if ( !ctype_digit($id) )
{
return '';
}
if ( !empty($meta['config']['Messages']) )
{
unset($meta['config']['Messages']['success']);
wp_localize_script( 'fc-form-js', 'FC',
array(
'ajaxurl' => admin_url( 'admin-ajax.php' ),
'datepickerLang' => plugins_url( 'assets/js/datepicker-lang/', __FILE__ )
)
);
wp_localize_script( 'fc-form-js', 'FC_Validation_'.$id,
$meta['config']['Messages']
);
}
if ( isset($_COOKIE['fc_sb_'.$id]) && isset($meta['config']['disable_multiple']) && $meta['config']['disable_multiple']==true )
{
if ( (!is_user_logged_in() || ( is_user_logged_in() && !isset($_GET['preview']) ) ) || !formcraft3_check_form_page() )
{
if (isset($meta['config']['disable_multiple_message']) && $meta['config']['disable_multiple_message']!='' && $type!='popup')
{
return "<div class='form-disabled-message'>".$meta['config']['disable_multiple_message']."</div>";
}
else
{
return '';
}
}
}
if ( isset($meta['config']['form_disable']) && $meta['config']['form_disable']==true )
{
if ( (!is_user_logged_in() || ( is_user_logged_in() && !isset($_GET['preview']) ) ) || !formcraft3_check_form_page() )
{
if (isset($meta['config']['form_disable_message']) && $meta['config']['form_disable_message']!='' && $type!='popup')
{
return "<div class='form-disabled-message'>".$meta['config']['form_disable_message']."</div>";
}
else
{
return '';
}
}
}
if ( isset($meta['config']['font_family']) && strpos($meta['config']['font_family'], 'Arial')===false && strpos($meta['config']['font_family'], 'sans-serif')===false && strpos($meta['config']['font_family'], 'Courier')===false && strpos($meta['config']['font_family'], 'inherit')===false )
{
$meta['config']['font_family'] = str_replace(' ', '+', $meta['config']['font_family']);
$protocol = is_ssl() ? 'https' : 'http';
$query_args = array(
'family' => $meta['config']['font_family'].':400,600,700'
);
wp_enqueue_style('font-'.$meta['config']['font_family'],
add_query_arg($query_args, "$protocol://fonts.googleapis.com/css" ),
array(), null);
}
$meta['config']['Custom_CSS'] = empty($meta['config']['Custom_CSS']) ? '' : $meta['config']['Custom_CSS'];
$custom_css = empty($meta['config']['Custom_CSS']) ? "" : "<style type='text/css' scoped='scoped'>".$meta['config']['Custom_CSS']."</style>";
$html = $wpdb->get_var( "SELECT html FROM $fc_forms_table WHERE id='$id'" );
$html = str_replace('fc_form_', 'fc-form-', $html);
$html = str_replace('fc_form ', 'fc-form ', $html);
$html = str_replace(' has-input', ' ', $html);
if (empty($html)){return '';}
$uniq = uniqid();
if ( isset($meta['config']['save_progress']) && $meta['config']['save_progress']==true && isset($_COOKIE["fc_sp_$id"]) )
{
$cookie = preg_replace("/\W|_/", "", $_COOKIE["fc_sp_$id"]);
$pre_data = $wpdb->get_var( "SELECT content FROM $fc_progress_table WHERE uniq_key = '$cookie'" );
$saved_data = "<div style='display: none' class='pre-populate-data'>".stripcslashes($pre_data)."</div>";
}
$pre_data = isset($pre_data) ? $pre_data : '';
$saved_data = isset($saved_data) ? $saved_data : '';
ob_start();
do_action('formcraft_form_content', $id, $meta, $pre_data);
$addon_content = ob_get_contents();
ob_end_clean();
$powered_by = ( $fc_meta['f3_multi_site_addon'] == false && ( get_site_option('f3_verified')!='yes' || get_site_option('f3_blog_id')!=get_current_blog_id() ) ) ? '<a class="powered-by" target="_blank" href="http://formcraft-wp.com?source=pb"/>powered by FormCraft</a>' : '';
$meta['config']['Logic'] = isset($meta['config']['Logic']) ? $meta['config']['Logic'] : '';
if ($type=='popup')
{
wp_enqueue_script('fc-modal-js', plugins_url( 'assets/js/src/fc_modal.js', __FILE__ ));
if ( $placement=='left' || $placement=='right' )
{
$button = "<div class='formcraft-css body-append image_button_cover placement-$placement'><a data-toggle='fc_modal' data-target='#modal-$uniq' style='background-color: $button_color; color: $font_color'>$content</a>";
}
else
{
$button = $content=='' ? '<div class="formcraft-css">' : "<div class='formcraft-css'><a class='$class' data-toggle='fc_modal' data-target='#modal-$uniq' style='background-color: $button_color; color: $font_color'>$content</a>";
}
return "$button<div data-auto='$auto' class='fc-form-modal fc_modal fc_fade animate-$placement' id='modal-$uniq'>
<div class='fc_modal-dialog fc_modal-dialog-".$id."' style='width: auto'>
<div data-bind='$bind' data-uniq='".$uniq."' class='uniq-".$uniq." formcraft-css form-live align-$align'>
<button class='fc_close' type='button' class='close' data-dismiss='fc_modal' aria-label='Close'>
<span aria-hidden='true'>×</span>
</button>
".$addon_content.$saved_data.$custom_css."
<div class='form-logic'>".json_encode($meta['config']['Logic'])."</div>".stripcslashes($html)."
</div>".$powered_by."</div>
</div>
</div>";
}
else if ($type=='slide')
{
$button = "<div class='formcraft-css body-append image_button_cover placement-$placement'><a class='fc-sticky-button' data-toggle='fc-sticky' data-target='#sticky-$uniq' style='background-color: $button_color; color: $font_color'>$content</a>";
return "
$button
<div data-auto='$auto' class='fc-sticky fc-sticky-$placement' id='sticky-$uniq'>
<button class='fc-trigger-close'>×</button>
<div data-bind='$bind' data-uniq='".$uniq."' class='uniq-".$uniq." formcraft-css form-live align-$align'>
".$addon_content.$saved_data.$custom_css."
<div class='form-logic'>".json_encode($meta['config']['Logic'])."
</div>".stripcslashes($html)."
</div><span style='position:absolute;bottom:0;left:12px'>".$powered_by."</span></div>
</div>";
}
else
{
formcraft3_new_view($id);
$imageHTML = formcraft3_check_form_page()==true && isset($meta['config']['form_logo_url']) && $meta['config']['form_logo_url']!='' ? "<img src='".$meta['config']['form_logo_url']."' class='form-page-logo'/>" : "";
return "<div data-uniq='".$uniq."' class='uniq-".$uniq." formcraft-css form-live align-$align'>$imageHTML".$addon_content.$saved_data.$custom_css."<div class='form-logic'>".json_encode($meta['config']['Logic'])."</div>".stripcslashes($html).$powered_by."</div>";
}
}
add_shortcode( 'fc', 'formcraft3_shortcode' );
function add_formcraft_form($shortcode)
{
echo do_shortcode($shortcode);
}
class formcraft3_form_widget extends WP_Widget {
function __construct() {
parent::__construct(
'formcraft3_widget',
'FormCraft',
array( 'description' => __( 'Embed Form', 'formcraft' ), )
);
}
public function widget( $args, $instance ) {
echo $args['before_widget'];
if ( $instance['form_type']=='inline' )
{
$shortcode = "[fc id='".$instance['form_id']."' align='".$instance['form_align']."'][/fc]";
}
else if ( $instance['form_type']=='slide' )
{
$extras = $instance['form_placement_slide']!='inline' ? ' button_color="#48e" font_color="white"' : '';
$instance['content_slide'] = filter_var( $instance['content_slide'], FILTER_VALIDATE_URL ) == true ? "<img src='".$instance['content_slide']."'/>" : $instance['content_slide'];
$shortcode = "[fc id='".$instance['form_id']."' type='slide' placement='".$instance['form_placement_slide']."' auto='".$instance['auto_popup_slide']."'$extras]".$instance['content_slide']."[/fc]";
}
else
{
$extras = $instance['form_placement']!='inline' ? ' button_color="#48e" font_color="white"' : '';
$instance['content'] = filter_var( $instance['content'], FILTER_VALIDATE_URL ) == true ? "<img src='".$instance['content']."'/>" : $instance['content'];
$shortcode = "[fc id='".$instance['form_id']."' type='popup' placement='".$instance['form_placement']."' auto='".$instance['auto_popup_popup']."'$extras]".$instance['content']."[/fc]";
}
echo do_shortcode($shortcode);
echo $args['after_widget'];
}
public function form( $instance ) {
global $wpdb, $fc_forms_table;
$forms = $wpdb->get_results("SELECT name,id FROM $fc_forms_table", ARRAY_A);
$instance['form_type'] = empty($instance['form_type']) ? 'inline' : $instance['form_type'];
$instance['form_align'] = empty($instance['form_align']) ? 'left' : $instance['form_align'];
$instance['form_placement'] = empty($instance['form_placement']) ? 'left' : $instance['form_placement'];
$instance['form_placement_slide'] = empty($instance['form_placement_slide']) ? 'left' : $instance['form_placement_slide'];
$instance['auto_popup_popup'] = empty($instance['auto_popup_popup']) ? '' : $instance['auto_popup_popup'];
$instance['auto_popup_slide'] = empty($instance['auto_popup_slide']) ? '' : $instance['auto_popup_slide'];
$instance['content'] = empty($instance['content']) ? '' : $instance['content'];
$instance['content_slide'] = empty($instance['content_slide']) ? '' : $instance['content_slide'];
?>
<div class='formcraft-css'>
<p>
<label for="<?php echo $this->get_field_id( 'form_id' ); ?>"><?php _e( 'Select Form:' ); ?></label>
<select class="widefat" id="<?php echo $this->get_field_id( 'form_id' ); ?>" name="<?php echo $this->get_field_name( 'form_id' ); ?>" type="text">
<?php
foreach ($forms as $key => $value) {
echo $value['id']==$instance['form_id'] ? "<option selected='selected' value='".$value['id']."'>".$value['name']."</option>" : "<option value='".$value['id']."'>".$value['name']."</option>";
}
?>
</select>
</p>
<p>
<label for="<?php echo $this->get_field_id( 'form_type' ); ?>"><?php _e( 'Embed Type:' ); ?></label>
<br>
<label><input class='f3_class_ft' <?php echo $instance['form_type']=='inline' ? 'checked' : ''; ?> name="<?php echo $this->get_field_name( 'form_type' ); ?>" type='radio' value='inline'/><?php _e( 'Inline' ); ?></label>
<label><input class='f3_class_ft' <?php echo $instance['form_type']=='popup' ? 'checked' : ''; ?> name="<?php echo $this->get_field_name( 'form_type' ); ?>" type='radio' value='popup'/><?php _e( 'Popup' ); ?></label>
<label><input class='f3_class_ft' <?php echo $instance['form_type']=='slide' ? 'checked' : ''; ?> name="<?php echo $this->get_field_name( 'form_type' ); ?>" type='radio' value='slide'/><?php _e( 'Slide' ); ?></label>
</p>
<p class='f3_class_ft_inline'>
<label for="<?php echo $this->get_field_id( 'form_align' ); ?>"><?php _e( 'Form Alignment:' ); ?></label>
<br>
<label><input <?php echo $instance['form_align']=='left' ? 'checked' : ''; ?> name="<?php echo $this->get_field_name( 'form_align' ); ?>" type='radio' value='left'/><?php _e( 'Left' ); ?></label>
<label><input <?php echo $instance['form_align']=='center' ? 'checked' : ''; ?> name="<?php echo $this->get_field_name( 'form_align' ); ?>" type='radio' value='center'/><?php _e( 'Center' ); ?></label>
<label><input <?php echo $instance['form_align']=='right' ? 'checked' : ''; ?> name="<?php echo $this->get_field_name( 'form_align' ); ?>" type='radio' value='right'/><?php _e( 'Right' ); ?></label>
</p>
<p class='f3_class_ft_popup' style='display: none'>
<label for="<?php echo $this->get_field_id( 'form_placement' ); ?>"><?php _e( 'Form Placement:' ); ?></label>
<br>
<label><input <?php echo $instance['form_placement']=='left' ? 'checked' : ''; ?> name="<?php echo $this->get_field_name( 'form_placement' ); ?>" type='radio' value='left'/><?php _e( 'Left' ); ?></label>
<label><input <?php echo $instance['form_placement']=='inline' ? 'checked' : ''; ?> name="<?php echo $this->get_field_name( 'form_placement' ); ?>" type='radio' value='inline'/><?php _e( 'Inline' ); ?></label>
<label><input <?php echo $instance['form_placement']=='right' ? 'checked' : ''; ?> name="<?php echo $this->get_field_name( 'form_placement' ); ?>" type='radio' value='right'/><?php _e( 'Right' ); ?></label>
<label style='margin: 1em 0; display: block'><?php _e( 'Auto popup after:' ); ?>
<input style='width: 40px' name="<?php echo $this->get_field_name( 'auto_popup_popup' ); ?>" type='text' value='<?php echo $instance['auto_popup_popup']; ?>'/>
<?php _e( 'seconds' ); ?>
</label>
<label style='margin: 1em 0; display: block' for="<?php echo $this->get_field_id( 'content' ); ?>"><?php _e( 'Button text / Image URL' ); ?>
<input style='width: 100%' name="<?php echo $this->get_field_name( 'content' ); ?>" type='text' value='<?php echo $instance['content']; ?>'/>
</label>
</p>
<p class='f3_class_ft_slide' style='display: none'>
<label for="<?php echo $this->get_field_id( 'form_placement_slide' ); ?>"><?php _e( 'Form Placement:' ); ?></label>
<br>
<label><input <?php echo $instance['form_placement_slide']=='left' ? 'checked' : ''; ?> name="<?php echo $this->get_field_name( 'form_placement_slide' ); ?>" type='radio' value='left'/><?php _e( 'Left' ); ?></label>
<label><input <?php echo $instance['form_placement_slide']=='right' ? 'checked' : ''; ?> name="<?php echo $this->get_field_name( 'form_placement_slide' ); ?>" type='radio' value='right'/><?php _e( 'Right' ); ?></label>
<label><input <?php echo $instance['form_placement_slide']=='bottom-right' ? 'checked' : ''; ?> name="<?php echo $this->get_field_name( 'form_placement_slide' ); ?>" type='radio' value='bottom-right'/><?php _e( 'Bottom Right' ); ?></label>
<label style='margin: 1em 0; display: block'><?php _e( 'Auto popup after:' ); ?>
<input style='width: 40px' name="<?php echo $this->get_field_name( 'auto_popup_slide' ); ?>" type='text' value='<?php echo $instance['auto_popup_slide']; ?>'/>
<?php _e( 'seconds' ); ?>
</label>
<label style='margin: 1em 0; display: block' for="<?php echo $this->get_field_id( 'content_slide' ); ?>"><?php _e( 'Button text / Image URL' ); ?>
<input style='width: 100%' name="<?php echo $this->get_field_name( 'content_slide' ); ?>" type='text' value='<?php echo $instance['content_slide']; ?>'/>
</label>
</p>
</div>
<script>
jQuery(document).ready(function(){
jQuery('.f3_class_ft').trigger('change');
jQuery('body').on('change','.f3_class_ft',function(){
jQuery('.f3_class_ft_popup,.f3_class_ft_inline,.f3_class_ft_slide').hide();
var name = jQuery(this).attr('name');
if ( jQuery('[name="'+name+'"]:checked').val()=='inline' )
{
jQuery('.f3_class_ft_inline').show();
}
else if ( jQuery('[name="'+name+'"]:checked').val()=='slide' )
{
jQuery('.f3_class_ft_slide').show();
}
else
{
jQuery('.f3_class_ft_popup').show();
}
});
});
</script>
<style>
.formcraft-css select
{
-webkit-appearance: none;
cursor: pointer;
}
.formcraft-css input[type='text'],
.formcraft-css select
{
border: 1px solid #ddd;
border-radius: 2px;
padding: 5px 10px;
line-height: 1.4em;
height: auto;
border-top-color: #bababa;
border-left-color: #bfbfbf;
box-shadow: 1px 1px 0 #eee inset;
box-shadow: none;
background-color: #fafafa;
box-sizing: border-box;
-moz-box-sizing: border-box;
}
</style>
<?php
}
public function update( $new_instance, $old_instance ) {
$instance = array();
$instance['form_id'] = (!empty($new_instance['form_id'])) ? strip_tags( $new_instance['form_id'] ) : '';
$instance['form_type'] = (!empty($new_instance['form_type'])) ? strip_tags( $new_instance['form_type'] ) : '';
$instance['form_align'] = (!empty($new_instance['form_align'])) ? strip_tags( $new_instance['form_align'] ) : '';
$instance['form_placement'] = (!empty($new_instance['form_placement'])) ? strip_tags( $new_instance['form_placement'] ) : '';
$instance['form_placement_slide'] = (!empty($new_instance['form_placement_slide'])) ? strip_tags( $new_instance['form_placement_slide'] ) : '';
$instance['auto_popup_popup'] = (!empty($new_instance['auto_popup_popup'])) ? strip_tags( $new_instance['auto_popup_popup'] ) : '';
$instance['auto_popup_slide'] = (!empty($new_instance['auto_popup_slide'])) ? strip_tags( $new_instance['auto_popup_slide'] ) : '';
$instance['content'] = (!empty($new_instance['content'])) ? $new_instance['content'] : '';
$instance['content_slide'] = (!empty($new_instance['content_slide'])) ? $new_instance['content_slide'] : '';
return $instance;
}
}
function formcraft3_register_widgets() {
register_widget( 'formcraft3_form_widget' );
}
add_action( 'widgets_init', 'formcraft3_register_widgets' );
/*
Create New Form Function
*/
add_action( 'wp_ajax_formcraft3_new_form', 'formcraft3_new_form' );
function formcraft3_new_form()
{
global $wpdb, $fc_meta, $fc_forms_table;
do_action('formcraft_new_form');
if($wpdb->get_var("SHOW TABLES LIKE '$fc_forms_table'") != $fc_forms_table && is_multisite()) {
echo json_encode(array('failed'=>'<div style="position: relative; top: 7px">Go to the license tab, and enter the License Key to activate the plugin.</div>'));
die();
}
if ( !current_user_can($fc_meta['user_can']) ) { die(); }
if ( !isset($_POST['form_name']) || empty($_POST['form_name']) )
{
$response = array('failed'=>__('Name is required','formcraft') );
echo json_encode($response); die();
}
$form_name = esc_sql(esc_attr($_POST['form_name']));
switch ($_POST['new_form_type'])
{
case 'blank';
$rows_affected = $wpdb->insert( $fc_forms_table, array(
'name' => $form_name,
'created' => current_time('mysql'),
'modified' => current_time('mysql')
) );
break;
case 'import': case 'template':
$upload = wp_upload_dir( null );
$upload['path'] = $upload['basedir'].'/formcraft3';
$file_name = $_POST['new_form_type']=='import' ? $upload['path']."/".sanitize_file_name($_POST['file']) : $file_path = WP_PLUGIN_DIR.$_POST['template-select-slider'];
$file = file_get_contents($file_name);
$bom = pack('H*','EFBBBF');
$file = json_decode(preg_replace("/^$bom/", '', $file), 1);
if ( !is_array($file) )
{
$response = array('failed'=>__('Invalid JSON File','formcraft') );
echo json_encode($response); die();
}
if ( !isset($file['plugin']) || ($file['plugin']!='FormCraft' && $file['plugin']!='FormCraft Basic') )
{
$response = array('failed'=>__('Not a form template','formcraft') );
echo json_encode($response); die();
}
$file['meta_builder'] = !isset($file['meta_builder']) ? '' : $file['meta_builder'];
$file['addons'] = !isset($file['addons']) ? '' : $file['addons'];
$file['old_url'] = !isset($file['old_url']) ? '' : $file['old_url'];
if ($file['plugin']=='FormCraft Basic')
{
$file['builder'] = base64_decode($file['builder']);
$file['meta_builder'] = base64_decode($file['meta_builder']);
$file['html'] = base64_decode($file['html']);
}
$file['html'] = stripcslashes($file['html']);
$rows_affected = $wpdb->insert( $fc_forms_table, array(
'name' => $form_name,
'created' => current_time('mysql'),
'modified' => current_time('mysql'),
'html' => esc_sql($file['html']),
'builder' => esc_sql($file['builder']),
'addons' => esc_sql($file['addons']),
'old_url' => esc_sql($file['old_url']),
'meta_builder' => esc_sql($file['meta_builder'])
) );
if ($rows_affected==false || !is_int($wpdb->insert_id))
{
$response = array('failed'=>__('Could not write to database','formcraft'));
echo json_encode($response); die();
}
else if ( $_POST['new_form_type']=='import' )
{
unlink($file_name);
}
break;
case 'duplicate';
if ( empty($_POST['duplicate']) || !ctype_digit($_POST['duplicate']) )
{
$response = array('failed'=>__('Select a form to duplicate','formcraft'));
echo json_encode($response); die();
}
$_POST['duplicate'] = esc_sql($_POST['duplicate']);
$existing_form = $wpdb->get_row("SELECT * FROM $fc_forms_table WHERE id = '$_POST[duplicate]'", ARRAY_A);
$rows_affected = $wpdb->insert( $fc_forms_table, array(
'name' => $form_name,
'created' => current_time('mysql'),
'modified' => current_time('mysql'),
'html' => $existing_form['html'],
'builder' => $existing_form['builder'],
'addons' => $existing_form['addons'],
'meta_builder' => $existing_form['meta_builder']
) );
break;
}
do_action('formcraft_after_form_add', array('id'=>$wpdb->insert_id, 'type'=>$_POST['new_form_type'], 'name'=>$form_name));
$response = array('success'=>__('Form created. Redirecting.','formcraft'),'redirect'=>'&id='.$wpdb->insert_id);
echo json_encode($response); die();
}
/*
Load Form Data in the Form Editor Mode
*/
add_action( 'wp_ajax_formcraft3_load_form_data', 'formcraft3_load_form_data' );
function formcraft3_load_form_data()
{
global $wpdb, $fc_forms_table, $fc_meta;
if ( !current_user_can($fc_meta['user_can']) ) { die(); }
$form_id = $_GET['id'];
if (!ctype_digit($form_id))
{
echo json_encode(array('failed'=>__('Invalid Form ID')));
die();
}
if ($_GET['type']=='builder')
{
$name = $wpdb->get_var( "SELECT name FROM $fc_forms_table WHERE id=$form_id" );
$builder = $wpdb->get_var( "SELECT builder FROM $fc_forms_table WHERE id=$form_id" );
$addons = $wpdb->get_var( "SELECT addons FROM $fc_forms_table WHERE id=$form_id" );
$meta = $wpdb->get_var( "SELECT meta_builder FROM $fc_forms_table WHERE id=$form_id" );
$old_url = $wpdb->get_var( "SELECT old_url FROM $fc_forms_table WHERE id=$form_id" );
$builder = $builder==null ? '' : $builder;
$meta = $meta==null ? false : $meta;
$old_url = $old_url==null ? false : $old_url;
if ($meta!=false)
{
$meta = json_decode(stripcslashes($meta),1);
$meta = $meta['config'];
$meta = json_encode($meta);
}
echo json_encode(array('meta_builder'=>$meta,'builder'=>$builder,'addons'=>stripcslashes($addons),'name'=>$name,'old_url'=>$old_url,'new_url'=>site_url()));
}
die();
}
/* Delete Submissions */
add_action( 'wp_ajax_formcraft3_del_submissions', 'formcraft3_del_submissions' );
function formcraft3_del_submissions()
{
global $fc_meta, $fc_forms_table, $fc_submissions_table, $wpdb;
if ( !current_user_can($fc_meta['user_can']) ) { die(); }
$list = explode(',',$_GET['list']);
$deleted = 0;
foreach ($list as $value) {
if ( !ctype_digit($value) ) { continue; }
$done = $wpdb->delete( $fc_submissions_table, array('id'=>$value) );
$deleted = $done==true ? $deleted+1 : $deleted;
}
if ($deleted>0)
{
echo json_encode(array('success'=>__($deleted.' submission(s) deleted','formcraft') ));
die();
}
else
{
echo json_encode(array('failed'=>__('Failed deleting submissions','formcraft') ));
die();
}
}
add_action( 'wp_ajax_formcraft3_reset_analytics', 'formcraft3_reset_analytics' );
function formcraft3_reset_analytics()
{
global $fc_meta, $fc_views_table, $wpdb;
if ( $fc_meta['preview_mode']==true ) {
echo json_encode(array('failed'=>'Can\'t reset data in demo mode')); die();
}
if ( !current_user_can($fc_meta['user_can']) ) { die(); }
$done = $wpdb->query("TRUNCATE TABLE `$fc_views_table`");
echo json_encode(array('success'=>__('Data reset','formcraft')));
die();
}
/* Delete Form */
add_action( 'wp_ajax_formcraft3_del_form', 'formcraft3_del_form' );
function formcraft3_del_form()
{
global $fc_meta, $fc_forms_table, $fc_submissions_table, $wpdb;
if ( !current_user_can($fc_meta['user_can']) ) { die(); }
$form = $_GET['form'];
if ( !ctype_digit($form) ) { die(); }
if ( $wpdb->get_var("SELECT imported from $fc_forms_table WHERE id = $form") == NULL )
{
$deleted = $wpdb->delete( $fc_forms_table, array('id'=>$form) );
}
else
{
$deleted = $wpdb->update( $fc_forms_table, array(
'name' => '',
'html' => '',
), array('id'=>$form));
}
if ($deleted>0)
{
do_action('formcraft_after_form_delete', $form);
echo json_encode(array('success'=>__('Form #'.$form.' deleted','formcraft'), 'form_id'=>$form));
die();
}
else
{
echo json_encode(array('failed'=>__('Failed deleting form','formcraft') ));
die();
}
}
add_action( 'wp_ajax_formcraft3_get_forms', 'formcraft3_get_forms' );
function formcraft3_get_forms()
{
global $fc_meta, $fc_forms_table, $fc_submissions_table, $wpdb;
if ( !current_user_can($fc_meta['user_can']) ) { die(); }
$page = isset($_GET['page']) && ctype_digit($_GET['page']) ? $_GET['page']-1 : 0;
$form = isset($_GET['form']) && ctype_digit($_GET['form']) ? $_GET['form'] : 0;
$per_page = 9;
$from = $page*$per_page;
$to = $per_page;
$sortWhat = !isset($_GET['sortWhat']) && $_GET['sortWhat']!='name' && !$_GET['sortWhat']!='id' && $_GET['sortWhat']!='modified' ? 'id' : $_GET['sortWhat'];
$sortOrder = !isset($_GET['sortOrder']) && $_GET['sortOrder']!='ASC' && !$_GET['sortOrder']!='DESC' ? 'DESC' : $_GET['sortOrder'];
$order_query = "ORDER by $sortWhat $sortOrder";
if ( isset($_GET['query']) && $_GET['query']!='' )
{
$total = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $fc_forms_table WHERE (name LIKE %s or id LIKE %s);", '%' . $wpdb->esc_like($_GET['query']) . '%', '%' . $wpdb->esc_like($_GET['query']) . '%') );
$forms = $wpdb->get_results( $wpdb->prepare( "SELECT id,name,modified FROM $fc_forms_table WHERE (name LIKE %s or id LIKE %s) $order_query LIMIT $from, $to;", '%' . $wpdb->esc_like($_GET['query']) . '%', '%' . $wpdb->esc_like($_GET['query']) . '%'), ARRAY_A );
}
else
{
$total = $wpdb->get_var( "SELECT COUNT(*) FROM $fc_forms_table" );
$forms = $wpdb->get_results( "SELECT id,name,modified FROM $fc_forms_table $order_query LIMIT $from, $to", ARRAY_A );
}
if ( is_array($forms) && count($forms)>0 )
{
foreach ($forms as $key => $value) {
$forms[$key]['name'] = $forms[$key]['name']=='' ? '(No Name)' : $forms[$key]['name'];
$forms[$key]['modified'] = fc_time_ago(strtotime(current_time('mysql'))-strtotime($value['modified']));
}
echo json_encode(array('pages'=>ceil($total/$per_page),'forms'=>$forms,'total'=>$total));
die();
}
else
{
echo json_encode(array('pages'=>'0','total'=>'0'));
die();
}
}
add_action( 'wp_ajax_formcraft3_get_files', 'formcraft3_get_files' );
function formcraft3_get_files()
{
global $fc_meta, $fc_files_table, $fc_submissions_table, $wpdb;
if ( !current_user_can($fc_meta['user_can']) ) { die(); }
$page = isset($_GET['page']) && ctype_digit($_GET['page']) ? $_GET['page']-1 : 0;
$form = isset($_GET['form']) && ctype_digit($_GET['form']) ? $_GET['form'] : 0;
$per_page = 11;
$from = $page*$per_page;
$to = $per_page;
if ( isset($_GET['query']) && $_GET['query']!='' )
{
$total = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $fc_files_table WHERE (name LIKE %s or mime LIKE %s);", '%' . $wpdb->esc_like($_GET['query']) . '%', '%' . $wpdb->esc_like($_GET['query']) . '%') );
$files = $wpdb->get_results( $wpdb->prepare( "SELECT id,name,mime,size,file_url,created,uniq_key FROM $fc_files_table WHERE (name LIKE %s or mime LIKE %s) ORDER BY id DESC LIMIT $from, $to;", '%' . $wpdb->esc_like($_GET['query']) . '%', '%' . $wpdb->esc_like($_GET['query']) . '%'), ARRAY_A );
}
else
{
$total = $wpdb->get_var( "SELECT COUNT(*) FROM $fc_files_table" );
$files = $wpdb->get_results( "SELECT id,name,mime,size,file_url,created,uniq_key FROM $fc_files_table ORDER BY id DESC LIMIT $from, $to", ARRAY_A );
}
if ( is_array($files) && count($files)>0 )
{
foreach ($files as $key => $value) {
if (((strtotime(current_time('mysql'))-strtotime($files[$key]['created']))/(60 * 60 * 24))<1)
{
$files[$key]['created'] = fc_time_ago(strtotime(current_time('mysql'))-strtotime($files[$key]['created']));
}
else
{
$files[$key]['created'] = date(get_option('date_format'), strtotime($files[$key]['created']));
}
}
echo json_encode(array('pages'=>ceil($total/$per_page),'files'=>$files,'total'=>$total));
die();
}
else
{
echo json_encode(array('pages'=>ceil($total/$per_page),'total'=>'0'));
die();
}
}
/* Get List of Submissions */
add_action( 'wp_ajax_formcraft3_get_submissions', 'formcraft3_get_submissions' );
function formcraft3_get_submissions()
{
global $fc_meta, $fc_forms_table, $fc_submissions_table, $wpdb;
if ( !current_user_can($fc_meta['user_can']) ) { die(); }
$page = isset($_GET['page']) && ctype_digit($_GET['page']) ? $_GET['page']-1 : 0;
$form = isset($_GET['form']) && ctype_digit($_GET['form']) ? $_GET['form'] : 0;
$per_page = 9;
$from = $page*$per_page;
$to = $per_page;
$sortWhat = !isset($_GET['sortWhat']) && $_GET['sortWhat']!='created' ? 'created' : $_GET['sortWhat'];
$sortOrder = !isset($_GET['sortOrder']) && $_GET['sortOrder']!='ASC' && !$_GET['sortOrder']!='DESC' ? 'DESC' : $_GET['sortOrder'];
$order_query = "ORDER by $sortWhat $sortOrder";
if ($form==0)
{
$where_clause = '';
}
else
{
$where_clause = "WHERE form = $form ";
}
if (isset($_GET['query']) && $_GET['query']!='')
{
$where_clause = $form==0 ? '' : "AND form = $form ";
$submissions = $wpdb->get_results( $wpdb->prepare( "SELECT id,form,form_name,created FROM $fc_submissions_table WHERE (content LIKE %s or form_name LIKE %s or id LIKE %s) ".$where_clause."$order_query LIMIT $from, $to;", '%' . $wpdb->esc_like($_GET['query']) . '%', '%' . $wpdb->esc_like($_GET['query']) . '%', '%' . $wpdb->esc_like($_GET['query']) . '%'), ARRAY_A );
$total = $wpdb->get_var($wpdb->prepare( "SELECT COUNT(*) FROM $fc_submissions_table WHERE (content LIKE %s or form_name LIKE %s or id LIKE %s) ".$where_clause, '%' . $wpdb->esc_like($_GET['query']) . '%', '%' . $wpdb->esc_like($_GET['query']) . '%', '%' . $wpdb->esc_like($_GET['query']) . '%'));
}
else
{
$submissions = $wpdb->get_results( "SELECT id,form,form_name,created FROM $fc_submissions_table ".$where_clause."$order_query LIMIT $from, $to", ARRAY_A );
$total = $wpdb->get_var("SELECT COUNT(*) FROM $fc_submissions_table ".$where_clause);
}
if ( is_array($submissions) && count($submissions)>0 )
{
foreach ($submissions as $key => $value) {
if (((strtotime(current_time('mysql'))-strtotime($submissions[$key]['created']))/(60 * 60 * 24))<1)
{
$submissions[$key]['created'] = fc_time_ago(strtotime(current_time('mysql'))-strtotime($submissions[$key]['created']));
}
else
{
$submissions[$key]['created'] = date(get_option('date_format'), strtotime($submissions[$key]['created']));
}
}
echo json_encode(array('pages'=>ceil($total/$per_page),'submissions'=>$submissions,'total'=>$total));
die();
}
else
{
echo json_encode(array('pages'=>'0','total'=>'0'));
die();
}
}
/* Get Submission Content */
add_action( 'wp_ajax_formcraft3_get_submission_content', 'formcraft3_get_submission_content' );
function formcraft3_get_submission_content()
{
global $fc_meta, $fc_forms_table, $fc_submissions_table, $wpdb;
if ( !current_user_can($fc_meta['user_can']) ) { die(); }
if ( !isset($_GET['id']) || !ctype_digit($_GET['id']) )
{
die();
}
$id = $_GET['id'];
$submission = $wpdb->get_results( "SELECT id,form,form_name,content,visitor,created FROM $fc_submissions_table WHERE id = $id", ARRAY_A );
$submission[0]['created_date'] = date(get_option('date_format'), strtotime($submission[0]['created']));
$submission[0]['created_time'] = date(get_option('time_format'), strtotime($submission[0]['created']));
$submission[0]['content'] = json_decode(stripslashes($submission[0]['content']),1);
$submission[0]['visitor'] = json_decode(stripslashes($submission[0]['visitor']),1);
foreach ($submission[0]['content'] as $key => $value) {
$submission[0]['content'][$key]['value'] = fc_stripslashes_deep($submission[0]['content'][$key]['value']);
}
echo json_encode($submission);
die();
}
/* Update Submission Content */
add_action( 'wp_ajax_formcraft3_update_submission_content', 'formcraft3_update_submission_content' );
function formcraft3_update_submission_content()
{
global $fc_meta, $fc_forms_table, $fc_submissions_table, $wpdb;
if ( !current_user_can($fc_meta['user_can']) ) { die(); }
if ( !isset($_POST['id']) || !ctype_digit($_POST['id']) )
{
die();
}
$id = $_POST['id'];
$content = array();
foreach ($_POST as $key => $value) {
if (substr($key, 0,5)!='field'){continue;}
$content[$key] = $value;
}
$existing = $wpdb->get_var( "SELECT content FROM $fc_submissions_table WHERE id = $id" );
$existing = json_decode(stripcslashes($existing), 1);
foreach ($existing as $key => $value) {
if ( isset($content[$value['identifier']]) )
{
$existing[$key]['value'] = formcraft3_htmlentities($content[$value['identifier']], ENT_QUOTES, "UTF-8");
}
}
$saved = $wpdb->update($fc_submissions_table, array(
'content' => esc_sql(json_encode($existing)),
), array('id'=>$id));
if ($saved)
{
echo json_encode(array('success'=>'true'));
die();
}
echo json_encode(array('failed'=>'true'));
die();
}
add_action('wp_ajax_formcraft3_get_template', 'formcraft3_get_template');
function formcraft3_get_template()
{
$file_path = WP_PLUGIN_DIR.$_GET['name'];
if ( !is_readable($file_path) )
{
echo "<div style='width: 100%; text-align: center; padding: 50px; color: #777; font-size: 15px'>".__('Could not read template file. Insufficient permission.','formcraft')."</div>";
die();
}
$content = file_get_contents($file_path);
$content = json_decode($content);
if ( !isset($content->html) )
{
echo json_encode(array('html'=>"<div style='width: 100%; text-align: center; padding: 50px; color: #777; font-size: 15px'>".__('Could not read template file','formcraft')."</div>"));
}
else
{
$html = stripcslashes($content->html);
$html = str_replace($content->old_url, site_url(), $html);
echo json_encode(array('html'=>$html,'config'=>json_decode($content->meta_builder)));
}
die();
}
/*
Save Form Progress
*/
add_action('wp_ajax_formcraft3_form_save_progress', 'formcraft3_form_save_progress');
add_action('wp_ajax_nopriv_formcraft3_form_save_progress', 'formcraft3_form_save_progress');
function formcraft3_form_save_progress()
{
global $wpdb, $fc_progress_table;
if ( !isset($_POST['id']) || !ctype_digit($_POST['id']) )
{
die();
}
$id = $_POST['id'];
$max_fields = 200;
$i=1;
foreach ($_POST as $key => $value) {
if ($i>200){break;} $i++;
if (substr($key, 0,5)!='field'){continue;}
$content[$key] = $value;
}
if ( isset($_COOKIE["fc_sp_$id"]) )
{
$cookie = preg_replace("/\W|_/", "", $_COOKIE["fc_sp_$id"]);
if ($wpdb->get_var( "SELECT COUNT(*) FROM $fc_progress_table WHERE uniq_key = '$cookie'" )!=0)
{
$wpdb->update($fc_progress_table, array(
'content' => esc_sql(json_encode($content)),
'modified' => current_time('mysql'),
'to_delete' => date('Y-m-d 00:00:00', strtotime('+60day', strtotime(current_time('mysql'))))
), array('uniq_key'=>$cookie));
}
}
else
{
$uniq = str_shuffle(md5(time()));
setcookie("fc_sp_$id", $uniq, strtotime( '+30 days' ), '/');
$rows_affected = $wpdb->insert( $fc_progress_table, array(
'form' => $id,
'uniq_key' => $uniq,
'content' => esc_sql(json_encode($content)),
'created' => current_time('mysql'),
'modified' => current_time('mysql'),
'to_delete' => date('Y-m-d 00:00:00', strtotime('+60day', strtotime(current_time('mysql'))))
) );
}
die();
}
add_action('wp_ajax_formcraft3_test_email', 'formcraft3_test_email');
function formcraft3_test_email()
{
$_POST = json_decode(file_get_contents('php://input'), true);
if ( empty($_POST['emails']) )
{
echo "<span class='cancel-x'>×</span> ".__('No email specified','formcraft');
die();
}
$emails = $_POST['emails'];
$config = $_POST['config'];
if ( strpos($emails, ',')!=-1 )
{
$emails = explode(',', $_POST['emails']);
}
else
{
$emails = array($emails);
}
$sent = 0;
$failed = 0;
$from_name = isset($config['general_sender_name']) ? $config['general_sender_name'] : 'FormCraft';
$from_email = isset($config['general_sender_email']) ? $config['general_sender_email'] : get_bloginfo('admin_email');
$from_email = filter_var( $from_email, FILTER_VALIDATE_EMAIL ) == false ? get_bloginfo('admin_email') : $from_email;
require_once 'lib/phpmailer/PHPMailerAutoload.php';
foreach ($emails as $key => $email) {
if ( filter_var( $email, FILTER_VALIDATE_EMAIL ) == false ) {
echo "<span class='cancel-x'>×</span> ".__('Invalid e-mail','formcraft');
die();
}
if ( isset($config['_method']) && $config['_method']=='smtp' )
{
$mail = new PHPMailer;
$mail->isSMTP();
$mail->Host = $config['smtp_sender_host'];
if (!empty($config['smtp_sender_port'])) { $mail->SMTPAuth = true; }
if (!empty($config['smtp_sender_username'])) { $mail->Username = $config['smtp_sender_username']; }
if (!empty($config['smtp_sender_password'])) { $mail->Password = $config['smtp_sender_password']; }
if (!empty($config['smtp_sender_security'])) { $mail->SMTPSecure = $config['smtp_sender_security']; }
if (!empty($config['smtp_sender_port'])) { $mail->Port = $config['smtp_sender_port']; }
$mail->From = $from_email;
$mail->FromName = "=?UTF-8?B?".base64_encode($from_name)."?=";
$mail->addAddress($email);
$mail->isHTML(true);
$mail->Subject = "Test Email from FormCraft";
$mail->Body = "Hey,<br><br>This is a test email sent from FormCraft, for WordPress. If you have received this email, it means your settings are working correctly.";
$mail->AltBody = "Hey,\nThis is a test email sent from FormCraft, for WordPress. If you have received this email, it means your settings are working correctly.";
if(!$mail->send()) {
$failed_msg = $mail->ErrorInfo;
echo "<span class='cancel-x'>×</span> ".$failed_msg."<br>";
} else {
$sent++;
}
}
else
{
$subject = "Test Email from FormCraft";
$message = "Hey,<br><br>This is a test email sent from FormCraft, for WordPress. If you have received this email, it means your settings are working correctly.";
$headers = array();
$headers[] = 'From: '."=?UTF-8?B?".base64_encode($from_name)."?=".' <'.$from_email.'>';
$headers[] = 'Content-Type: text/html; charset=UTF-8';
$email_sent = wp_mail( $email, $subject, $message, $headers );
if(!$email_sent) {
echo "<span class='cancel-x'>×</span> Email setup error<br>";
} else {
$sent++;
}
}
}
if ($sent==0)
{
echo "<span class='cancel-x'>×</span> $sent email sent";
}
else
{
echo "<i class='icon-ok' style='color:rgb(20, 173, 20)'></i> $sent email sent";
}
die();
}
/*
Submit The Form
*/
add_action('wp_ajax_formcraft3_form_submit', 'formcraft3_form_submit');
add_action('wp_ajax_nopriv_formcraft3_form_submit', 'formcraft3_form_submit');
function formcraft3_form_submit()
{
global $fc_meta, $fc_forms_table, $fc_submissions_table, $fc_files_table, $wpdb, $fc_final_response;
if ( !isset($_POST['id']) || !ctype_digit($_POST['id']) )
{
echo json_encode(array('failed'=> __('Invalid Form ID','formcraft') ));
die();
}
if ( isset($_POST['website']) && $_POST['website']!='' )
{
echo json_encode(array('failed'=> __('SPAM detected','formcraft') ));
die();
}
$id = $_POST['id'];
$meta = $wpdb->get_var( "SELECT meta_builder FROM $fc_forms_table WHERE id=$id" );
$meta = json_decode(stripcslashes($meta), 1);
/* Allow Editing of Meta */
$meta = apply_filters('formcraft_filter_entry_meta', $meta);
$fc_final_response = array();
$fc_final_response['errors'] = array();
$_POST = apply_filters( 'formcraft_filter_raw', $_POST, $meta );
$integrations = array();
$integrations['not_triggered'] = array();
$_POST['trigger_integration'] = isset($_POST['triggerIntegration']) ? $_POST['triggerIntegration'] : $_POST['trigger_integration'];
$_POST['trigger_integration'] = isset($_POST['trigger_integration']) ? $_POST['trigger_integration'] : '';
$integrations['triggered'] = json_decode(stripcslashes(urldecode($_POST['trigger_integration'])), 1);
$integrations['triggered'] = count($integrations['triggered']) > 0 ? array_unique($integrations['triggered']) : $integrations['triggered'];
if ( isset($meta['config']['Logic']) )
{
foreach ($meta['config']['Logic'] as $key => $logicRow) {
if ( isset($logicRow[1]) && is_array($logicRow[1]) && count($logicRow[1])>0 )
{
foreach ($logicRow[1] as $key2 => $value) {
if ( isset($value[0]) && isset($value[3]) && $value[0]=='trigger_integration' && !in_array($value[3], $integrations['triggered']) )
{
$integrations['not_triggered'][] = $value[3];
}
}
}
}
}
$messages = $meta['config']['Messages'];
$hidden_fields = isset($_POST['hidden']) ? explode(',', preg_replace('/\s+/', '', $_POST['hidden'])) : array();
foreach ($meta['fields'] as $key => $field) {
if ( isset($_POST['type']) && ctype_digit($_POST['type']) && $field['page']!=$_POST['type'] ){continue;}
$value = isset($_POST[$field['identifier']]) ? $_POST[$field['identifier']] : '';
if ( !in_array($field['identifier'], $hidden_fields) )
{
/* Check if Required Field */
if ($field['type']=='matrix' && isset($field['elementDefaults']['required']) && $field['elementDefaults']['required']==true)
{
foreach ($field['elementDefaults']['matrix_rows_output'] as $matrix_key => $matrix_value) {
if ( !isset($_POST[$field['identifier'].'_'.$matrix_key]) )
{
$fc_final_response['errors'][$field['identifier']] = $messages['is_required'];
break;
}
}
}
else if ( isset($field['elementDefaults']['required']) && is_array($value) && $field['elementDefaults']['required']==true && (count($value)==0 || $value[0]=='' ) )
{
$fc_final_response['errors'][$field['identifier']] = $messages['is_required'];
}
else if ( isset($field['elementDefaults']['required']) && $field['elementDefaults']['required']==true && !is_array($value) && trim($value)=='' )
{
$fc_final_response['errors'][$field['identifier']] = $messages['is_required'];
}
else if (isset($field['elementDefaults']['required']) && $field['elementDefaults']['required']==true && !isset($_POST[$field['identifier']]))
{
$fc_final_response['errors'][$field['identifier']] = $messages['is_required'];
}
/* Field Type Validation */
switch ($field['type']) {
case 'email':
if ( trim($value)!='' && filter_var( $value, FILTER_VALIDATE_EMAIL ) == false )
{
$fc_final_response['errors'][$field['identifier']] = $messages['allow_email'];
}
break;
case 'fileupload':
if ( isset($field['elementDefaults']['min_files']) && ctype_digit($field['elementDefaults']['min_files']) && $field['elementDefaults']['min_files']!=0 )
{
if (!isset($_POST[$field['identifier']]))
{
$fc_final_response['errors'][$field['identifier']] = str_ireplace('[x]', $field['elementDefaults']['min_files'], $messages['min_files']);
}
else if ( count($_POST[$field['identifier']]) < $field['elementDefaults']['min_files'] )
{
$fc_final_response['errors'][$field['identifier']] = str_ireplace('[x]', $field['elementDefaults']['min_files'], $messages['min_files']);
}
}
break;
default:
break;
}
/* Explicit Validation */
if ( isset($field['elementDefaults']) && isset($field['elementDefaults']['Validation']) )
{
$spaces = isset($field['elementDefaults']['Validation']['spaces']) && $field['elementDefaults']['Validation']['spaces']==true ? true : false;
$value_to_check = $spaces==true ? str_replace(' ', '', $value) : $value;
$value = is_array($value) ? $value[0] : $value;
foreach ($field['elementDefaults']['Validation'] as $type => $validation) {
if (empty($value)){continue;}
switch ($type) {
case 'allowed':
$value_to_check = is_array($value_to_check) ? $value_to_check[0] : $value_to_check;
if ( $validation=='alphabets' && !ctype_alpha($value_to_check) )
{
$fc_final_response['errors'][$field['identifier']] = $messages['allow_alphabets'];
}
else if ( $validation=='numbers' && !ctype_digit($value_to_check) )
{
$fc_final_response['errors'][$field['identifier']] = $messages['allow_numbers'];
}
else if ( $validation=='alphanumeric' && !ctype_alnum($value_to_check) )
{
$fc_final_response['errors'][$field['identifier']] = $messages['allow_alphanumeric'];
}
else if ( $validation=='url' && !filter_var( $value, FILTER_VALIDATE_URL ) )
{
$fc_final_response['errors'][$field['identifier']] = $messages['allow_url'];
}
break;
case 'minChar':
if ( !ctype_digit($validation) ) break;
if ( (mb_strlen($value)-substr_count( $value, "\n" )) < $validation )
{
$fc_final_response['errors'][$field['identifier']] = str_ireplace('[x]', $validation, $messages['min_char']);
}
break;
case 'maxChar':
if ( !ctype_digit($validation) ) break;
if ( (mb_strlen($value)-substr_count( $value, "\n" )) > $validation )
{
$fc_final_response['errors'][$field['identifier']] = str_ireplace('[x]', $validation, $messages['max_char']);
}
break;
default:
break;
}
}
}
}
} /* End of Fields Loop */
/* If validation failed, show errors */
if ( count($fc_final_response['errors'])>0 )
{
if ( !isset($fc_final_response['failed']) )
{
$fc_final_response['failed'] = isset($meta['config']['messages']['form_errors']) ? $meta['config']['messages']['form_errors'] : $messages['failed'];
}
echo json_encode($fc_final_response);
die();
}
if ( !isset($_POST['type']) || $_POST['type']!='all' )
{
echo json_encode(array('validated'=>$_POST['type']));
die();
}
/* ELSE All is Well with the Submission */
/* Clean the User Input */
foreach ($meta['fields'] as $key => $field) {
if ( isset($_POST[$field['identifier']]) ) {
if (is_array($_POST[$field['identifier']]))
{
foreach($_POST[$field['identifier']] as $key => $value) {
$_POST[$field['identifier']][$key] = htmlentities(stripslashes($value), ENT_QUOTES, "UTF-8");
}
}
else
{
$_POST[$field['identifier']] = stripslashes($_POST[$field['identifier']]);
$_POST[$field['identifier']] = htmlentities($_POST[$field['identifier']], ENT_QUOTES, "UTF-8");
}
}
}
/* Parse and Organize Input */
$content = array();
$all_files = array();
$autoresponder_email = array();
foreach ($meta['fields'] as $key => $field) {
if ( $field['type']=='password' ) { continue; }
if ( $field['type']=='submit' ) { continue; }
$new_row = array();
if ($field['type']=='fileupload')
{
if ( !isset($_POST[$field['identifier']]) ) { continue; }
$files_name = array();
$files_url = array();
foreach($_POST[$field['identifier']] as $key => $value) {
$file_row = $wpdb->get_row("SELECT * FROM $fc_files_table WHERE uniq_key = '$value'", ARRAY_A);
if (!$file_row) {continue;}
$files_name[] = $file_row['name'];
$files_url[] = $file_row['file_url'];
$all_files[] = $file_row;
}
$label = isset($field['elementDefaults']['main_label']) ? $field['elementDefaults']['main_label'] : '';
$new_row = array('label'=>$label,'value'=>$files_name,'url'=>$files_url,'identifier'=>$field['identifier'],'type'=>$field['type'],'page'=>$field['page'],'page_name'=>$meta['config']['page_names'][$field['page']-1]);
}
else if ($field['type']=='matrix')
{
$value = array();
$field['elementDefaults']['matrix_rows_output'] = isset($field['elementDefaults']['matrixRowsOutput']) ? $field['elementDefaults']['matrixRowsOutput'] : $field['elementDefaults']['matrix_rows_output'];
foreach ($field['elementDefaults']['matrix_rows_output'] as $matrix_key => $matrix_value) {
if (isset($_POST[$field['identifier'].'_'.$matrix_key]))
{
$value[] = array('question'=>$matrix_value['value'], 'value'=>$_POST[$field['identifier'].'_'.$matrix_key]);
}
}
$label = isset($field['elementDefaults']['main_label']) ? $field['elementDefaults']['main_label'] : '';
$new_row = array('label'=>$label,'value'=>$value,'identifier'=>$field['identifier'],'type'=>$field['type'],'page'=>$field['page'],'page_name'=>$meta['config']['page_names'][$field['page']-1]);
}
else
{
unset($value);
if ( isset($_POST[$field['identifier']]) ) { $value = $_POST[$field['identifier']]; }
$value = isset($value) ? $value : '';
$label = isset($field['elementDefaults']['main_label']) ? $field['elementDefaults']['main_label'] : '';
if ( $field['type']=='email' && isset($field['elementDefaults']['autoresponder']) && $field['elementDefaults']['autoresponder']==true)
{
$autoresponder_email[] = $value;
}
if ( is_array($value) && count($value)==1 )
{
$value = $value[0];
}
if ( is_array($value) )
{
foreach ($value as $k => $v) {
$value[$k] = html_entity_decode($v, ENT_QUOTES, 'utf-8');
}
}
$new_row = array('label'=>$label,'value'=>$value,'identifier'=>$field['identifier'],'type'=>$field['type'],'page'=>$field['page'],'page_name'=>$meta['config']['page_names'][$field['page']-1]);
}
if ($field['type']=='dropdown' || $field['type']=='checkbox')
{
$new_row['options'] = $field['elementDefaults']['optionsListShow'];
}
if ( isset($field['is_payment']) && $field['is_payment']==true )
{
$form_payment = 1;
$new_row['payment'] = $value;
$new_row['currency'] = isset($field['elementDefaults']['currency']) ? $field['elementDefaults']['currency'] : '';
}
if ( isset($field['elementDefaults']['replyTo']) && $field['elementDefaults']['replyTo']==true )
{
$replyTo = $value;
}
$new_row['width'] = isset($field['elementDefaults']['field_width']) ? $field['elementDefaults']['field_width'] : '100%';
$content[] = $new_row;
$form_nos_pages = $field['page'];
}
$form_payment = isset($form_payment) ? $form_payment : 0;
/* Allow Editing Content */
$content = apply_filters('formcraft_filter_entry_content', $content);
$visitor = array();
$visitor['IP'] = $_SERVER['REMOTE_ADDR'];
$form_name = $wpdb->get_var( "SELECT name FROM $fc_forms_table WHERE id='$id'" );
$template = array();
$template['Form ID'] = $id;
$template['Form Name'] = $form_name;
$template['IP'] = $_SERVER['REMOTE_ADDR'];
$template['URL'] = $visitor['URL'] = isset($_POST['location']) ? $_POST['location'] : __('Unknown','formcraft');
$template['Date'] = current_time(get_option('date_format'));
$template['Time'] = current_time(get_option('time_format'));
$temp = array();
$temp2 = array();
$thisWidth = 0;
foreach ($content as $key => $value) {
if ( $value['value']=='' ) { continue; }
if ($value['type']=='fileupload')
{
foreach ($value['value'] as $key2 => $file) {
$temp[] = "<a href='".$value['url'][$key2]."'>".$value['value'][$key2]."</a>";
}
$value['value'] = implode("\n", $temp);
unset($temp);
}
else if ($value['type']=='dropdown' || $value['type']=='checkbox')
{
$template[$value['label'].'.value'] = is_array($value['value']) ? implode(", ", $value['value']) : $value['value'];
$temp_values = array();
foreach ($meta['fields'] as $key2 => $value2) {
if ($value2['identifier']==$value['identifier'])
{
if ( isset($value2['elementDefaults']['optionsListShow']) && is_array($value2['elementDefaults']['optionsListShow']) )
{
foreach ($value2['elementDefaults']['optionsListShow'] as $key3 => $value3) {
if ( is_array($value['value']) )
{
foreach ($value['value'] as $key4 => $value4) {
if ($value3['value']==$value4)
{
$temp_values[] = $value3['show'];
}
}
$template[$value['label'].'.label'] = implode(", ", $temp_values);
}
else
{
if ($value3['value']==$value['value'])
{
$template[$value['label'].'.label'] = $value3['show'];
$temp_values = $value3['show'];
}
}
}
}
}
}
$value['value'] = is_array($temp_values) ? implode("\n", $temp_values) : $temp_values;
if ( $value['value']=='' && isset($template[$value['label'].'.value']) )
{
$value['value'] = html_entity_decode($template[$value['label'].'.value'], ENT_QUOTES, 'utf-8');
}
}
else if ($value['type']=='matrix')
{
$newValue = array();
foreach ($value['value'] as $key2 => $value2) {
$newValue[] = $value2['question'].': '.$value2['value'];
}
$value['value'] = implode("\n", $newValue);
}
else
{
if ( is_array($value['value']) && count($value['value'])==1 )
{
$value['value'] = $value['value'][0] ;
}
else if ( is_array( $value['value'] ) )
{
$value['value'] = implode("\n", $value['value']) ;
}
else
{
$value['value'] = $value['value'] ;
}
}
if ( $value['value'] == '' && isset($template[$value['label'].'.value']) )
{
$template[$value['label']] = $template[$value['label'].'.value'];
}
else
{
$template[$value['label']] = $value['value'];
}
$meta['page_count'] = isset($meta['page_count']) ? $meta['page_count'] : 1;
if ( (empty($last_page) || $value['page_name']!=$last_page) && $meta['page_count']>1 ) {
$last_page=$value['page_name'];
if ( isset($meta['config']['notifications']['form_layout']) && $meta['config']['notifications']['form_layout']==true )
{
$temp2[] = "<div style='font-weight: bold;margin-top:15px;margin-bottom:10px;float:left;width:600px;font-size:110%'>".$value['page_name']."</div>";
}
else
{
$temp2[] = "<div style='font-weight: bold;margin-top:15px;margin-bottom:10px;width:600px;font-size:110%'>".$value['page_name']."</div>";
}
}
$thisWidth = isset($value['width']) && strpos($value['width'], '%')!=0 ? $thisWidth + ((intval($value['width'])/100)*600) : 600;
$tempW = isset($value['width']) && strpos($value['width'], '%')!=0 ? ((intval($value['width'])/100)*600).'px' : '600px';
$value['value'] = str_replace("\n\n", "<br><div style='height:5px'></div>", $value['value']);
if ( isset($meta['config']['notifications']['form_layout']) && $meta['config']['notifications']['form_layout']==true )
{
if ( $value['type']=='heading' )
{
$temp2[] = "<div style='font-size:120%;float:left;vertical-align:top;width:$tempW;margin-bottom:10px'><div style='font-weight: bold'>".$value['value']."</div></div>";
}
else
{
$temp2[] = "<div style='float:left;vertical-align:top;width:$tempW;margin-bottom:10px'><div style='font-weight: bold'>".$value['label']."</div><div>".$value['value']."</div></div>";
}
}
else
{
if ( $value['type']=='heading' )
{
$temp2[] = "<tr><td colspan='2' style='font-size: 120%; font-weight: bold'>".$value['value']."</td></tr>";
}
else
{
$value['value'] = $value['type']=='checkbox' || $value['type']=='fileupload' ? str_ireplace("<br>", ", ", $value['value']) : $value['value'];
$temp2[] = "<tr><td cellspacing='0' cellpadding='0' style='width: 200px; font-weight: bold; display: inline-block'>".$value['label']."</td> <td>".$value['value']."</td></tr>";
}
}
if ( isset($meta['config']['notifications']['form_layout']) && $meta['config']['notifications']['form_layout']==true && $thisWidth >= 600 )
{
$temp2[] = "</div><div style='width: 600px'>";
$thisWidth = 0;
}
}
if ( !isset($meta['config']['notifications']['form_layout']) || $meta['config']['notifications']['form_layout']==false )
{
array_unshift($temp2, '<table><tbody>');
$temp2[] = '</tbody></table>';
}
$form_content = implode('', $temp2);
$template['Form Content'] = "<div style='width: 600px'>".$form_content."<div style='display:block;clear:both'></div></div>";
/* Check With the Add-Ons Before Submitting */
do_action('formcraft_before_save', $template, $meta, $content, $integrations);
/* If validation failed, show errors */
if ( count($fc_final_response['errors'])>0 )
{
if ( !isset($fc_final_response['failed']) )
{
$fc_final_response['failed'] = isset($meta['config']['messages']['form_errors']) ? $meta['config']['messages']['form_errors'] : $messages['failed'];
}
echo json_encode($fc_final_response);
die();
}
$rows_affected = $wpdb->insert( $fc_submissions_table, array(
'form' => $id,
'form_name' => $form_name,
'content' => esc_sql(json_encode($content)),
'visitor' => esc_sql(json_encode($visitor)),
'created' => current_time('mysql')
) );
$template['Entry ID'] = $wpdb->insert_id;
/* Written to Database, so it works */
if ($rows_affected)
{
formcraft3_new_submission($id, $form_payment);
if ( isset($meta['config']['messages']['form_sent']) )
{
$fc_final_response['success'] = $meta['config']['messages']['form_sent'];
}
else
{
$fc_final_response['success'] = $messages['success'];
$fc_final_response['submission_id'] = $template['Entry ID'];
}
}
else
{
$fc_final_response['failed'] = __('Failed to Write','formcraft');
echo json_encode($fc_final_response); die();
}
if ( isset($autoresponder_email) && is_array($autoresponder_email) && count($autoresponder_email)>0 )
{
$email_subject = isset($meta['config']['autoresponder']['email_subject']) ? $meta['config']['autoresponder']['email_subject'] : __('New Form Submission','formcraft');
$email_subject = fc_template($template, $email_subject);
$email_subject = fc_template_content($content, $email_subject);
$email_body = isset($meta['config']['autoresponder']['email_body']) ? $meta['config']['autoresponder']['email_body'] : __('[Form Content]','formcraft');
$email_body = fc_template($template, $email_body);
$email_body = fc_template_content($content, $email_body);
$email_body = formcraft3_email_template($email_body);
$email_body_text = str_ireplace('<p><br/></p>', '<br/>', $email_body);
$email_body_text = str_ireplace('</table></p>', '', $email_body_text);
$email_body_text = str_ireplace('<p>', '', $email_body_text);
$email_body_text = str_ireplace('</p>', '<br/>', $email_body_text);
$email_body_text = str_ireplace('<tr>', '<br/>', $email_body_text);
$email_body_text = str_ireplace('</tr>', '', $email_body_text);
$email_body_text = str_ireplace('</td><td>', ": ", $email_body_text);
$email_body_text = str_ireplace('<table>', '<br/>', $email_body_text);
$email_body_text = str_ireplace('</table>', '', $email_body_text);
$email_body_text = str_ireplace('<br/>', "\r\n", $email_body_text);
$email_body_text = strip_tags($email_body_text);
$from_name = isset($meta['config']['autoresponder']['email_sender_name']) ? $meta['config']['autoresponder']['email_sender_name'] : 'FormCraft';
$from_name = fc_template($template, $from_name);
$from_email = isset($meta['config']['autoresponder']['email_sender_email']) ? $meta['config']['autoresponder']['email_sender_email'] : get_bloginfo('admin_email');
$from_email = fc_template($template, $from_email);
$from_email = fc_template_content($content, $from_email);
if ( !filter_var($from_email,FILTER_VALIDATE_EMAIL) ){
$from_email = get_bloginfo('admin_email');
}
$sent = 0;
$failed = 0;
require_once 'lib/phpmailer/PHPMailerAutoload.php';
foreach ($autoresponder_email as $email) {
if ( !filter_var($email,FILTER_VALIDATE_EMAIL) ){continue;}
if ( isset($meta['config']['notifications']['_method']) && $meta['config']['notifications']['_method']=='smtp' )
{
$mail = new PHPMailer;
$mail->isSMTP();
$mail->Host = $meta['config']['notifications']['smtp_sender_host'];
if (!empty($meta['config']['notifications']['smtp_sender_port'])) { $mail->SMTPAuth = true; }
if (!empty($meta['config']['notifications']['smtp_sender_username'])) { $mail->Username = $meta['config']['notifications']['smtp_sender_username']; }
if (!empty($meta['config']['notifications']['smtp_sender_password'])) { $mail->Password = $meta['config']['notifications']['smtp_sender_password']; }
if (!empty($meta['config']['notifications']['smtp_sender_security'])) { $mail->SMTPSecure = $meta['config']['notifications']['smtp_sender_security']; }
if (!empty($meta['config']['notifications']['smtp_sender_port'])) { $mail->Port = $meta['config']['notifications']['smtp_sender_port']; }
$mail->From = $from_email;
$mail->FromName = $from_name;
$mail->addAddress($email);
$mail->isHTML(true);
$mail->Subject = $email_subject;
$mail->Body = $email_body;
$mail->AltBody = $email_body_text;
$mail->CharSet = "UTF-8";
if(!$mail->send()) {
$failed++;
$failed_msg = $mail->ErrorInfo;
} else {
$sent++;
}
}
else
{
$subject = $email_subject;
$message = $email_body;
$headers = array();
$headers[] = 'From: '."=?UTF-8?B?".base64_encode($from_name)."?=".' <'.$from_email.'>';
$headers[] = 'Content-Type: text/html; charset=UTF-8';
$email_sent = wp_mail( $email, $subject, $message, $headers );
if(!$email_sent) {
$failed++;
$failed_msg = "Email setup error";
} else {
$sent++;
}
}
}
if ($failed>0){$fc_final_response['debug']['failed'][] = __('Autoresponder Not Sent: ','formcraft').$failed_msg;}
else{$fc_final_response['debug']['success'][] = __($sent.' autoresponder email(s) sent','formcraft');}
}
if ( isset($_POST['emails']) )
{
$meta['config']['notifications']['recipients'] = isset($meta['config']['notifications']['recipients']) ? $meta['config']['notifications']['recipients'].', '.$_POST['emails'] : $_POST['emails'];
}
if ( isset($meta['config']) )
{
if ( isset($meta['config']['notifications']['recipients']) )
{
$meta['config']['notifications']['recipients'] = fc_template($template, $meta['config']['notifications']['recipients']);
$emails = fc_parse_emails($meta['config']['notifications']['recipients'], 10);
$sent = 0;
$failed = 0;
if ( is_array($emails) && count($emails)>0 )
{
$email_subject = isset($meta['config']['notifications']['email_subject']) ? $meta['config']['notifications']['email_subject'] : __('New Form Submission','formcraft');
$email_subject = fc_template($template, $email_subject);
$email_subject = fc_template_content($content, $email_subject);
$email_subject = html_entity_decode($email_subject);
$email_body = isset($meta['config']['notifications']['email_body']) ? $meta['config']['notifications']['email_body'] : __('[Form Content]','formcraft');
$email_body = fc_template($template, $email_body);
$email_body = fc_template_content($content, $email_body);
$email_body = formcraft3_email_template($email_body);
$email_body_text = str_ireplace('<p><br/></p>', '<br/>', $email_body);
$email_body_text = str_ireplace('<p><br/></p>', '<br/>', $email_body);
$email_body_text = str_ireplace('</table></p>', '', $email_body_text);
$email_body_text = str_ireplace('<p>', '', $email_body_text);
$email_body_text = str_ireplace('</p>', '<br/>', $email_body_text);
$email_body_text = str_ireplace('<tr>', '<br/>', $email_body_text);
$email_body_text = str_ireplace('</tr>', '', $email_body_text);
$email_body_text = str_ireplace('</td><td>', ": ", $email_body_text);
$email_body_text = str_ireplace('<table>', '<br/>', $email_body_text);
$email_body_text = str_ireplace('</table>', '', $email_body_text);
$email_body_text = str_ireplace('<br/>', "\r\n", $email_body_text);
$email_body_text = strip_tags($email_body_text);
$from_name = isset($meta['config']['notifications']['general_sender_name']) ? $meta['config']['notifications']['general_sender_name'] : 'FormCraft';
$from_name = fc_template($template, $from_name);
$from_email = isset($meta['config']['notifications']['general_sender_email']) ? $meta['config']['notifications']['general_sender_email'] : get_bloginfo('admin_email');
$from_email = fc_template($template, $from_email);
$from_email = fc_template_content($content, $from_email);
if ( !filter_var($from_email,FILTER_VALIDATE_EMAIL) ){
$from_email = get_bloginfo('admin_email');
}
foreach ($emails as $email => $name) {
if ( isset($meta['config']['notifications']['_method']) && $meta['config']['notifications']['_method']=='smtp' )
{
require_once 'lib/phpmailer/PHPMailerAutoload.php';
$mail = new PHPMailer;
$mail->isSMTP();
$mail->Host = $meta['config']['notifications']['smtp_sender_host'];
if (!empty($meta['config']['notifications']['smtp_sender_port'])) { $mail->SMTPAuth = true; }
if (!empty($meta['config']['notifications']['smtp_sender_username'])) { $mail->Username = $meta['config']['notifications']['smtp_sender_username']; }
if (!empty($meta['config']['notifications']['smtp_sender_password'])) { $mail->Password = $meta['config']['notifications']['smtp_sender_password']; }
if (!empty($meta['config']['notifications']['smtp_sender_security'])) { $mail->SMTPSecure = $meta['config']['notifications']['smtp_sender_security']; }
if (!empty($meta['config']['notifications']['smtp_sender_port'])) { $mail->Port = $meta['config']['notifications']['smtp_sender_port']; }
$mail->From = $from_email;
$mail->FromName = $from_name;
$mail->addAddress($email, $name);
if ( isset($replyTo) )
{
$mail->addReplyTo($replyTo);
}
if ( isset($all_files) && isset($meta['config']['notifications']['attach_images']) && $meta['config']['notifications']['attach_images']==true )
{
foreach ($all_files as $key => $file) {
$mail->addAttachment($file['file_path']);
}
}
$mail->isHTML(true);
$mail->Subject = $email_subject;
$mail->Body = $email_body;
$mail->AltBody = $email_body_text;
$mail->CharSet = "UTF-8";
if(!$mail->send()) {
$failed++;
$failed_msg = $mail->ErrorInfo;
} else {
$sent++;
}
}
else
{
$subject = $email_subject;
$message = $email_body;
$headers = array();
$headers[] = 'From: '.$from_name.' <'.$from_email.'>';
$headers[] = 'Content-Type: text/html; charset=UTF-8';
if ( isset($replyTo) )
{
$headers[] = 'Reply-To: '.$replyTo. "\r\n";
}
$attachments = array();
if ( isset($all_files) && isset($meta['config']['notifications']['attach_images']) && $meta['config']['notifications']['attach_images']==true )
{
foreach ($all_files as $key => $file) {
$attachments[] = $file['file_path'];
}
}
$email_sent = wp_mail( $email, $subject, $message, $headers, $attachments );
if(!$email_sent) {
$failed++;
$failed_msg = "Email setup error";
} else {
$sent++;
}
}
}
if ($failed>0){$fc_final_response['debug']['failed'][] = __('Email Not Sent: ','formcraft').$failed_msg;}
if ($sent>0){$fc_final_response['debug']['success'][] = __($sent.' notification email(s) sent','formcraft');}
}
}
}
// Send Data to Custom URL
if ( isset($meta['config']['Post_data']) && $meta['config']['Post_data']==true && isset($meta['config']['webhook']) )
{
$post_data = array();
$post_data['Entry ID'] = $template['Entry ID'];
foreach ($content as $key => $value) {
if ($value['type']=='fileupload') {
$value['value'] = is_array($value['url']) ? implode(', ', $value['url']) : $value['url'];
} else {
$value['value'] = is_array($value['value']) ? implode(', ', $value['value']) : $value['value'];
}
$post_data[html_entity_decode($value['label'], ENT_QUOTES, 'utf-8')] = html_entity_decode($value['value'], ENT_QUOTES, 'utf-8');
}
if ( isset($meta['config']['webhook_method']) && $meta['config']['webhook_method']=='POST' )
{
wp_remote_post($meta['config']['webhook'], array('body'=>$post_data));
}
else
{
$url = strpos($meta['config']['webhook'], '?') === FALSE ? $meta['config']['webhook'].'?'.http_build_query($post_data) : $meta['config']['webhook'].'&'.http_build_query($post_data);
$url = fc_template($template, $url);
wp_remote_get($url);
}
}
if ( !empty($_POST['redirect']) )
{
$fc_final_response['redirect'] = fc_template($template, $_POST['redirect'], true);
}
else if ( !empty($meta['config']['redirect_main']) )
{
$fc_final_response['redirect'] = fc_template($template, $meta['config']['redirect_main'], true);
}
/* Emails Sent, All Done */
do_action('formcraft_after_save', $template, $meta, $content, $integrations);
echo json_encode($fc_final_response); die();
}
/*
Save Form Data from the Form Editor Mode
*/
add_action( 'wp_ajax_formcraft3_form_save', 'formcraft3_form_save' );
function formcraft3_form_save()
{
global $wpdb, $fc_meta, $fc_forms_table;
if ( !current_user_can($fc_meta['user_can']) ) {
die();
}
$form_id = $_POST['id'];
if (!ctype_digit($form_id)) {
echo json_encode(array('failed'=>__('Invalid Form ID')));
die();
}
$meta_builder = json_decode(stripcslashes($_POST['meta_builder']),1);
$name = $meta_builder['config']['form_name'];
$builder = $_POST['builder'];
$addons = esc_sql(stripslashes($_POST['addons']));
$meta_builder = esc_sql(json_encode($meta_builder));
$html = esc_sql(stripslashes($_POST['html']));
if ( $builder != esc_sql($builder) )
{
echo json_encode(array('failed'=>__('Lost in Translation')));
die();
}
if ( $wpdb->update($fc_forms_table, array( 'meta_builder' => $meta_builder, 'addons' => $addons, 'builder' => $builder, 'html' => $html, 'modified' => current_time('mysql'), 'name' => $name ), array('ID'=>$form_id)) === FALSE) {
echo json_encode(array('failed'=>__('Could not write to database')));
die();
} else {
echo json_encode(array('success'=>__('Form Saved')));
die();
}
die();
}
add_action( 'wp_ajax_formcraft3_get', 'formcraft3_get' );
add_action( 'wp_ajax_nopriv_formcraft3_get', 'formcraft3_get' );
function formcraft3_get()
{
$args = array();
$args['timeout'] = 10;
if ( isset($_GET['URL']) )
{
$response = wp_remote_get($_GET['URL'],$args);
if ( is_wp_error( $response ) ) {
echo json_encode(array('failed'=>$response->get_error_message()));
}
else
{
echo wp_remote_retrieve_body($response);
}
die();
}
}
add_action( 'wp_ajax_formcraft3_file_delete', 'formcraft3_file_delete' );
add_action( 'wp_ajax_nopriv_formcraft3_file_delete', 'formcraft3_file_delete' );
function formcraft3_file_delete()
{
global $wpdb, $fc_meta, $fc_files_table;
if ( !isset($_POST['id']) )
{
die();
}
$uniq_key = esc_sql($_POST['id']);
$file_row = $wpdb->get_row("SELECT * FROM $fc_files_table WHERE uniq_key = '$uniq_key'", ARRAY_A);
if (!$file_row)
{
echo json_encode(array('failed'=> __('Invalid Key?','formcraft'), 'debug' => __('Invalid Key?','formcraft') ));
die();
}
unlink($file_row['file_path']);
$delete = $wpdb->delete( $fc_files_table, array('uniq_key'=>$uniq_key) );
if ($delete)
{
echo json_encode(array('success'=> __('true','formcraft') ));
die();
}
die();
}
add_action( 'wp_ajax_formcraft3_file_delete_admin', 'formcraft3_file_delete_admin' );
function formcraft3_file_delete_admin()
{
global $wpdb, $fc_meta, $fc_files_table;
if ( !isset($_GET['list']) )
{
die();
}
$list = explode(',', $_GET['list']);
$total = 0;
foreach ($list as $key => $value) {
if (!ctype_digit($value)){continue;}
$file_row = $wpdb->get_var("SELECT file_path FROM $fc_files_table WHERE id = '$value'");
if ($file_row)
{
unlink($file_row);
$delete = $wpdb->delete( $fc_files_table, array('id'=>$value) );
$total = $delete==true ? $total+1 : $total;
}
}
echo json_encode(array('success'=>$total.__(' file(s) deleted','formcraft')));
die();
}
add_action( 'wp_ajax_formcraft3_file_upload', 'formcraft3_file_upload' );
add_action( 'wp_ajax_nopriv_formcraft3_file_upload', 'formcraft3_file_upload' );
function formcraft3_file_upload()
{
global $wpdb, $fc_meta, $fc_files_table;
if ( isset($_FILES['files']) )
{
foreach ($_FILES as $key => $file) {
$filename = sanitize_file_name($file['name']);
$filename = explode('.', $filename);
$extension = strtolower($filename[count($filename)-1]);
$extension = preg_replace("/[^A-Za-z0-9]/", '', $extension);
unset($filename[count($filename)-1]);
$filename = implode('', $filename).'.'.$extension;
$allowed = array('png','doc','docx','xls','xlsx','csv','txt','rtf','zip','mp3','wma','wmv','mpg','flv','avi','jpg','jpeg','png','gif','ods','rar','ppt','pptx','tif','wav','mov','psd','eps','sit','sitx','cdr','ai','mp4','m4a','bmp','pps','aif', 'pdf', 'svg', 'odt','psa','stp','step','igs','x_t','dwg','obj','stl','bin','ols');
if (!in_array($extension, $allowed))
{
echo json_encode(array('failed'=>'true','debug'=>__('Invalid File Format','formcraft') ));
die();
}
if ( !isset($_GET['id']) || !ctype_digit($_GET['id']) )
{
echo json_encode(array('failed'=> __('Invalid Form ID','formcraft') ));
die();
}
/* Safe to Upload */
$filename_new = str_shuffle(md5(time())).'-'.$filename;
$file_done = fc_wp_upload_bits($filename_new, null, file_get_contents($file["tmp_name"]), null, $_GET['id']);
if ( isset($file_done['name']) )
{
$uniq_key = str_shuffle(md5(time()));
$file_name_new = substr($file_done['name'], strpos($file_done['name'], '-')+1, strlen($file_done['name']));
$rows_affected = $wpdb->insert( $fc_files_table, array(
'uniq_key' => $uniq_key,
'name' => $file_name_new,
'form' => $_GET['id'],
'permanent' => 0,
'mime' => $file['type'],
'size' => intval($file['size']),
'file_url' => $file_done['url'],
'file_path' => $file_done['file'],
'created' => current_time('mysql')
) );
echo json_encode(array('success'=> $uniq_key, 'file_name' => $file_name_new ));
die();
}
else if ( $file_done['error']==true )
{
echo json_encode(array('failed'=> __('Failed','formcraft'), 'debug' => $file_done['error'] ));
die();
}
}
}
die();
}
/*
Save Imported Form File
*/
add_action( 'wp_ajax_formcraft3_import_file', 'formcraft3_import_file' );
function formcraft3_import_file()
{
global $wpdb, $fc_meta;
if ( !current_user_can($fc_meta['user_can']) ) { die(); }
if ( isset($_FILES['form_file']) )
{
if ( !isset($_FILES['form_file']['type']) || $_FILES['form_file']['type']!='text/plain' )
{
echo json_encode(array('failed'=> __('Invalid File Format','formcraft') ));
die();
}
else
{
$filename = urldecode($_FILES["form_file"]["name"]);
$filename = sanitize_file_name($filename);
$file = fc_wp_upload_bits($filename, null, file_get_contents($_FILES["form_file"]["tmp_name"]));
if ( $file['error']==true )
{
echo json_encode(array('failed'=> __('Failed','formcraft'), 'debug' => $file['error'] ));
die();
}
else
{
echo json_encode(array('success'=> urlencode($file['name'])));
die();
}
}
}
die();
}
/*
Add Dashboard Menu Page
Every user who can activate a plugin (i.e. every admin user) can access FormCraft
*/
add_action('admin_menu', 'formcraft3_admin' );
function formcraft3_admin()
{
global $wp_version, $fc_meta;
$icon_url = $wp_version >= 3.8 ? 'dashicons-list-view' : '';
add_menu_page( 'FormCraft', 'FormCraft', $fc_meta['user_can'], 'formcraft3_dashboard', 'formcraft3_dashboard', $icon_url, '31.3503' );
add_action( 'admin_enqueue_scripts', 'formcraft3_admin_assets' );
}
function formcraft3_admin_assets($hook)
{
global $fc_meta;
if ($hook!='toplevel_page_formcraft3_dashboard') { return false; }
/* Basic Styles and Scripts */
wp_enqueue_script('jquery');
wp_enqueue_script('jquery-ui-datepicker');
wp_enqueue_script('jquery-ui-slider');
wp_enqueue_script('fc-modal-js', plugins_url( 'assets/js/src/fc_modal.js', __FILE__ ));
wp_enqueue_script('fc-tooltip-js', plugins_url( 'assets/js/vendor/tooltip.min.js', __FILE__ ));
wp_enqueue_script('fc-toastr-js', plugins_url( 'assets/js/vendor/toastr.min.js', __FILE__ ));
wp_enqueue_script('fc-autosize-js', plugins_url( 'assets/js/vendor/autosize.js', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_style('fc-common-css', plugins_url( 'assets/css/common-elements.css', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_style('fc-angular-textangular-css', plugins_url( 'assets/css/textAngular.css', __FILE__ ),array(), $fc_meta['version']);
if ( !isset($_GET['id']) )
{
/* Dashboard Styles and Scripts */
wp_enqueue_script('fc-dashboard-js', plugins_url( 'assets/js/dashboard.js', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_script('fc-chart-js', plugins_url( 'assets/js/vendor/chart.min.js', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_script('fc-fileupload-js', plugins_url( 'assets/js/vendor/jquery.fileupload.js', __FILE__ ),array('jquery-ui-widget'));
wp_localize_script( 'fc-dashboard-js', 'FC_1',
array(
'ajaxurl' => admin_url( 'admin-ajax.php' ),
'baseurl' => get_site_url(),
'confirm_delete' => __("Are you sure you want to delete this form?\nThis action cannot be reversed.", 'formcraft')
)
);
wp_enqueue_style('fc-form-css', plugins_url( 'assets/css/form.css', __FILE__ ),array(), $fc_meta['version']);
do_action('formcraft_form_scripts');
wp_enqueue_style('fc-zurb-css', plugins_url( 'assets/css/foundation.min.css', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_style('fc-dashboard-css', plugins_url( 'assets/css/dashboard.css', __FILE__ ),array(), $fc_meta['version']);
do_action('formcraft_dashboard_scripts');
}
if (isset($_GET['id']))
{
/* Builder Styles and Scripts */
wp_enqueue_style( 'wp-color-picker' );
wp_enqueue_style('fc-selectize-css', plugins_url( 'assets/css/selectize.css', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_style('fc-builder-css', plugins_url( 'assets/css/builder.css', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_style('fc-form-css', plugins_url( 'assets/css/form.css', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_script( 'wp-color-picker' );
wp_enqueue_script('fc-selectize-js', plugins_url( 'assets/js/vendor/selectize.min.js', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_script('fc-angular-js', plugins_url( 'assets/js/vendor/angular.min.js', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_script('fc-ui-sortable-js', plugins_url( 'assets/js/vendor/ui.sortable.min.js', __FILE__ ), array('jquery-ui-core','jquery-ui-widget','jquery-ui-mouse','jquery-ui-sortable'), $fc_meta['version']);
wp_enqueue_script('fc-angular-sanitize-js', plugins_url( 'assets/js/vendor/textAngular-sanitize.min.js', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_script('fc-angular-textAngular-js', plugins_url( 'assets/js/vendor/textAngular.min.js', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_script('fc-angular-textAngular-rangy-js', plugins_url( 'assets/js/vendor/textAngular-rangy.min.js', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_script('fc-angular-textAngular-setup-js', plugins_url( 'assets/js/textAngularSetup.js', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_script('fc-builder-js', plugins_url( 'assets/js/builder.js', __FILE__ ), array('jquery-ui-core','jquery-ui-widget','jquery-ui-mouse','jquery-ui-sortable'), $fc_meta['version']);
wp_enqueue_script('fc-builder-mask-js', plugins_url( 'assets/js/vendor/jquery.mask.js', __FILE__ ), array('fc-builder-js'), $fc_meta['version']);
wp_localize_script( 'fc-builder-js', 'FC',
array(
'licenseKey' => get_site_option('f3_key'),
'ajaxurl' => admin_url( 'admin-ajax.php' ),
'pluginurl' => plugins_url( '', __FILE__ ),
'baseurl' => get_site_url(),
'datepickerLang' => plugins_url( 'assets/js/datepicker-lang/', __FILE__ ),
'form_id' => isset($_GET['id']) ? intval($_GET['id']) : 0
)
,array(), $fc_meta['version']);
wp_enqueue_script('fc-deflate-js', plugins_url( 'assets/js/vendor/deflate.all.js', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_script('fc-htmlminifier-js', plugins_url( 'assets/js/vendor/htmlminifier.min.js', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_script('fc-cleancss-js', plugins_url( 'assets/js/vendor/cleancss.js', __FILE__ ),array(), $fc_meta['version']);
wp_enqueue_script('fc-highlightjs-pack-js', plugins_url( 'assets/js/vendor/highlight.pack.js', __FILE__ ),array(), $fc_meta['version']);
wp_deregister_script('wp-emoji');
wp_deregister_script('wpemoji');
do_action('formcraft_addon_scripts');
}
}
function formcraft3_dashboard()
{
if ( isset($_GET['id']) )
{
require_once('views/builder.php');
}
else
{
require_once('views/dashboard.php');
}
}
/* Common Functions */
function fc_formatDate($time) {
if ($time >= strtotime("today 00:00")) {
return "Today at ".date("g:i A", $time);
} elseif ($time >= strtotime("yesterday 00:00")) {
return "Yesterday at " . date("g:i A", $time);
} elseif ($time >= strtotime("-6 day 00:00")) {
return date("l \\a\\t g:i A", $time);
} else {
return date("M j, Y", $time);
}
}
function fc_time_ago($secs){
$bit = array(
' year' => $secs / 31556926 % 12,
' week' => $secs / 604800 % 52,
' day' => $secs / 86400 % 7,
' hr' => $secs / 3600 % 24,
' min' => $secs / 60 % 60,
' sec' => $secs % 60
);
foreach($bit as $k => $v)
{
if($v > 1)$ret[] = $v . $k;
if($v == 1)$ret[] = $v . $k;
if (isset($ret)&&count($ret)==2){break;}
}
if (isset($ret))
{
if (count($ret)>1)
{
array_splice($ret, count($ret)-1, 0, ' ');
}
return join(' ', $ret);
}
return '';
}
function fc_time_pretty($secs){
$bit = array(
'year' => $secs / 31556926 % 12,
'week' => $secs / 604800 % 52,
'day' => $secs / 86400 % 7,
'hr' => $secs / 3600 % 24,
'm' => $secs / 60 % 60,
's' => $secs % 60
);
foreach($bit as $k => $v)
{
if($v > 1)$ret[] = $v . $k;
if($v == 1)$ret[] = $v . $k;
if (isset($ret)&&count($ret)==2){break;}
}
if (isset($ret))
{
if (count($ret)>1)
{
array_splice($ret, count($ret)-1, 0, 'and');
}
return join(' ', $ret);
}
return '';
}
/* General Function to Remove Text */
function formcraft3_replace_comments($beginning, $end, $string, $replace)
{
$loop = false;
while ($loop==false)
{
$beginningPos = null;
$endPos = null;
$beginningPos = strpos($string, $beginning);
$endPos = strpos($string, $end);
if ( $beginningPos===false || $endPos===false)
{
return $string;
$loop = true;
}
$textToDelete = substr($string, $beginningPos, ($endPos + strlen($end)) - $beginningPos);
$string = str_replace($textToDelete, $replace, $string);
$loop = false;
}
return $string;
}
function fc_parse_emails($string, $nos = 20)
{
$emails = array();
if(preg_match_all('/\s*"?([^><,"]+)"?\s*((?:<[^><,]+>)?)\s*/', $string, $matches, PREG_SET_ORDER) > 0)
{
$i = 0;
foreach($matches as $m)
{
if ($i>=$nos){break;}
if(! empty($m[2]))
{
if (!filter_var(trim($m[2], '<>'), FILTER_VALIDATE_EMAIL)) {continue;}
$emails[trim($m[2], '<>')] = trim($m[1]);
}
else
{
if (!filter_var($m[1], FILTER_VALIDATE_EMAIL)) {continue;}
$emails[$m[1]] = '';
}
$i++;
}
}
return $emails;
}
function fc_template($content, $body, $allow_html = false)
{
foreach ($content as $label => $value) {
$value = nl2br($value);
if ($allow_html == true) {
$body = str_ireplace('['.$label.']', html_entity_decode(stripslashes($value), ENT_QUOTES, 'utf-8'), $body);
} else {
$body = str_ireplace('['.$label.']', stripslashes($value), $body);
}
}
return $body;
}
function fc_template_content($content, $body)
{
foreach ($content as $label => $value) {
$value['value'] = is_array($value['value']) ? implode(', ', $value['value']) : $value['value'];
$body = str_ireplace('['.$value['identifier'].']', $value['value'], $body);
}
return $body;
}
function fc_offset()
{
return floatval(get_option('gmt_offset'))*60*60;
}
function fc_stripslashes_deep($value)
{
$value = is_array($value) ?
array_map('stripslashes_deep', $value) :
stripslashes($value);
return $value;
}
function fc_output_csv($data) {
$outputBuffer = fopen("php://output", 'w');
foreach($data as $val)
{
foreach ($val as $key1 => $value1) {
if (is_array($value1))
{
$abc = $value1;
if ( is_array($abc[0]) )
{
foreach ($abc as $key3 => $value3) {
$abc[$key3] = $value3['question'].': '.$value3['value'];
}
}
$abc = implode(', ', $abc);
$val[$key1] = $abc;
}
}
foreach ($val as $key2 => $value2) {
$val[$key2] = html_entity_decode($value2, ENT_QUOTES, 'utf-8');
}
fputcsv($outputBuffer, (array)$val);
}
fclose($outputBuffer);
}
function fc_adjustBrightness($hex, $steps) {
$steps = max(-255, min(255, $steps));
$hex = str_replace('#', '', $hex);
if (strlen($hex) == 3) {
$hex = str_repeat(substr($hex,0,1), 2).str_repeat(substr($hex,1,1), 2).str_repeat(substr($hex,2,1), 2);
}
$color_parts = str_split($hex, 2);
$return = '#';
foreach ($color_parts as $color) {
$color = hexdec($color);
$color = max(0,min(255,$color + $steps));
$return .= str_pad(dechex($color), 2, '0', STR_PAD_LEFT);
}
return $return;
}
function fc_wp_upload_bits( $name, $deprecated, $bits, $time = null, $form = null ) {
if ( !empty( $deprecated ) )
_deprecated_argument( __FUNCTION__, '2.0' );
if ( empty( $name ) )
return array( 'error' => __( 'Empty filename' ) );
$upload = wp_upload_dir( $time );
if ($form)
{
$upload['path'] = $upload['basedir'].'/formcraft3/'.$form;
$upload['url'] = $upload['baseurl'].'/formcraft3/'.$form;
$upload['subdir'] = '/formcraft3/'.$form;
}
else
{
$upload['path'] = $upload['basedir'].'/formcraft3';
$upload['url'] = $upload['baseurl'].'/formcraft3';
$upload['subdir'] = '/formcraft3';
}
if ( $upload['error'] !== false )
return $upload;
$upload_bits_error = apply_filters( 'wp_upload_bits', array( 'name' => $name, 'bits' => $bits, 'time' => $time ) );
if ( !is_array( $upload_bits_error ) ) {
$upload[ 'error' ] = $upload_bits_error;
return $upload;
}
$filename = wp_unique_filename( $upload['path'], $name );
$new_file = $upload['path'] . "/$filename";
if ( ! wp_mkdir_p( dirname( $new_file ) ) ) {
if ( 0 === strpos( $upload['basedir'], ABSPATH ) )
$error_path = str_replace( ABSPATH, '', $upload['basedir'] ) . $upload['subdir'];
else
$error_path = basename( $upload['basedir'] ) . $upload['subdir'];
$message = sprintf( __( 'Unable to create directory %s. Is its parent directory writable by the server?' ), $error_path );
return array( 'error' => $message );
}
$ifp = @ fopen( $new_file, 'wb' );
if ( ! $ifp )
return array( 'error' => sprintf( __( 'Could not write file %s' ), $new_file ) );
@fwrite( $ifp, $bits );
fclose( $ifp );
clearstatcache();
$stat = @ stat( dirname( $new_file ) );
$perms = $stat['mode'] & 0007777;
$perms = $perms & 0000666;
@ chmod( $new_file, $perms );
clearstatcache();
$url = $upload['url'] . "/$filename";
return array( 'file' => $new_file, 'url' => $url, 'name'=> $filename,'error' => false );
}
function formcraft3_htmlentities($content)
{
if ( is_array($content) )
{
$temp = array();
foreach ($content as $key => $value) {
$temp[$key] = htmlentities($value, ENT_QUOTES, "UTF-8");
}
return $temp;
}
else
{
return htmlentities($content, ENT_QUOTES, "UTF-8");
}
}
function formcraft3_email_template($content)
{
$content = str_ireplace('<p></br>', '<p>', $content);
$content = str_ireplace('<p><br/>', '<p>', $content);
$content = str_ireplace('<p><br>', '<p>', $content);
return '
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="viewport" content="width=device-width" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
</head>
<body style="font-size: 100%; line-height: 1.6; -webkit-font-smoothing: antialiased; -webkit-text-size-adjust: none; height: 100%">
<table style="font-size: 100%; line-height: 1.6; width: 100%; margin: 0; padding: 0px;">
<tr>
<td style="clear: both !important; margin: 0; padding: 0px;">
<div style="font-size: 100%; line-height: 1.6; display: block; margin: 0; padding: 0;">
'.$content.'
</div>
</td>
</tr>
</table>
</body>
</html>';
}
?>