/wp-content/plugins/gravityforms/gravityforms.php

<?php

/*

Plugin Name: Gravity Forms

Plugin URI: http://www.gravityforms.com

Description: Easily create web forms and manage form entries within the WordPress admin.

Version: 1.6.11

Author: rocketgenius

Author URI: http://www.rocketgenius.com



------------------------------------------------------------------------

Copyright 2009-2011 Rocketgenius Inc.



This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License as published by

the Free Software Foundation; either version 2 of the License, or

(at your option) any later version.



This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

GNU General Public License for more details.



You should have received a copy of the GNU General Public License

along with this program; if not, write to the Free Software

Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA

*/





//------------------------------------------------------------------------------------------------------------------

//---------- Gravity Forms License Key -----------------------------------------------------------------------------

//------------------------------------------------------------------------------------------------------------------

//If you hardcode a Gravity Forms License Key here, it will automatically populate on activation.

$gf_license_key = "";



//-- OR ---//



//You can also add the Gravity Forms license key to your wp-config.php file to automatically populate on activation

//Add the code in the comment below to your wp-config.php to do so:

//define('GF_LICENSE_KEY','YOUR_KEY_GOES_HERE');

//------------------------------------------------------------------------------------------------------------------



//------------------------------------------------------------------------------------------------------------------

//---------- reCAPTCHA Keys -----------------------------------------------------------------------------

//------------------------------------------------------------------------------------------------------------------

//If you hardcode your reCAPTCHA Keys here, it will automatically populate on activation.

$gf_recaptcha_private_key = "";

$gf_recaptcha_public_key = "";



//-- OR ---//



//You can also add the reCAPTCHA keys to your wp-config.php file to automatically populate on activation

//Add the two lines of code in the comment below to your wp-config.php to do so:

//define('GF_RECAPTCHA_PRIVATE_KEY','YOUR_PRIVATE_KEY_GOES_HERE');

//define('GF_RECAPTCHA_PUBLIC_KEY','YOUR_PUBLIC_KEY_GOES_HERE');

//------------------------------------------------------------------------------------------------------------------



if(!defined("RG_CURRENT_PAGE"))

    define("RG_CURRENT_PAGE", basename($_SERVER['PHP_SELF']));



if(!defined("IS_ADMIN"))

    define("IS_ADMIN",  is_admin());



define("RG_CURRENT_VIEW", RGForms::get("view"));

define("GF_MIN_WP_VERSION", '3.2');

define("GF_SUPPORTED_WP_VERSION", version_compare(get_bloginfo("version"), GF_MIN_WP_VERSION, '>='));



if(!defined("GRAVITY_MANAGER_URL"))

    define("GRAVITY_MANAGER_URL", "http://www.gravityhelp.com/wp-content/plugins/gravitymanager");



require_once(WP_PLUGIN_DIR . "/" . basename(dirname(__FILE__)) . "/common.php");

require_once(WP_PLUGIN_DIR . "/" . basename(dirname(__FILE__)) . "/forms_model.php");

require_once(WP_PLUGIN_DIR . "/" . basename(dirname(__FILE__)) . "/widget.php");





add_action('init',  array('RGForms', 'init'));

add_action('wp',  array('RGForms', 'maybe_process_form'), 9);

add_action('wp',  array('RGForms', 'process_exterior_pages'));



add_filter('user_has_cap', array("RGForms", "user_has_cap"), 10, 3);





//Hooks for no-conflict functionality

if(is_admin() && (RGForms::is_gravity_page() || RGForms::is_gravity_ajax_action())){

    add_action("wp_print_scripts", array("RGForms", "no_conflict_mode_script"), 1000);

    add_action("admin_print_footer_scripts", array("RGForms", "no_conflict_mode_script"), 9);



    add_action("wp_print_styles", array("RGForms", "no_conflict_mode_style"), 1000);

    add_action("admin_print_styles", array("RGForms", "no_conflict_mode_style"), 1);

    add_action("admin_print_footer_scripts", array("RGForms", "no_conflict_mode_style"), 1);

    add_action("admin_footer", array("RGForms", "no_conflict_mode_style"), 1);

}



class RGForms{



    public static function has_members_plugin(){

        return function_exists( 'members_get_capabilities' );

    }



    //Plugin starting point. Will load appropriate files

    public static function init(){



        load_plugin_textdomain( 'gravityforms', false, '/gravityforms/languages' );



        add_filter("gform_logging_supported", array("RGForms", "set_logging_supported"));



        if(IS_ADMIN){



            global $current_user;



            //Members plugin integration. Adding Gravity Forms roles to the checkbox list

            if (self::has_members_plugin())

                add_filter('members_get_capabilities', array("RGForms", "members_get_capabilities"));



            //Loading Gravity Forms if user has access to any functionality

            if(GFCommon::current_user_can_any(GFCommon::all_caps()))

            {

                require_once(GFCommon::get_base_path() . "/export.php");

                GFExport::maybe_export();



                //runs the setup when version changes

                self::setup();



                //creates the "Forms" left menu

                add_action('admin_menu',  array('RGForms', 'create_menu'));



                if(GF_SUPPORTED_WP_VERSION){



                    add_action('admin_footer',  array('RGForms', 'check_upload_folder'));

                    add_action('wp_dashboard_setup', array('RGForms', 'dashboard_setup'));



                    //Adding "embed form" button

                    add_action('media_buttons', array('RGForms', 'add_form_button'), 20);



                    //Plugin update actions

                    add_filter("transient_update_plugins", array('RGForms', 'check_update'));

                    add_filter("site_transient_update_plugins", array('RGForms', 'check_update'));



                    if(in_array(RG_CURRENT_PAGE, array('post.php', 'page.php', 'page-new.php', 'post-new.php'))){

                        add_action('admin_footer',  array('RGForms', 'add_mce_popup'));

                    }

                    else if(self::is_gravity_page()){

                        require_once(GFCommon::get_base_path() . "/tooltips.php");

                        add_action("admin_print_scripts", array('RGForms', 'print_scripts'));

                    }

                    else if(RG_CURRENT_PAGE == 'media-upload.php'){

                        require_once(GFCommon::get_base_path() . "/entry_list.php");

                    }

                    else if(in_array(RG_CURRENT_PAGE, array("admin.php", "admin-ajax.php"))){



                        add_action('wp_ajax_rg_save_form', array('RGForms', 'save_form'));

                        add_action('wp_ajax_rg_change_input_type', array('RGForms', 'change_input_type'));

                        add_action('wp_ajax_rg_add_field', array('RGForms', 'add_field'));

                        add_action('wp_ajax_rg_duplicate_field', array('RGForms', 'duplicate_field'));

                        add_action('wp_ajax_rg_delete_field', array('RGForms', 'delete_field'));

                        add_action('wp_ajax_rg_delete_file', array('RGForms', 'delete_file'));

                        add_action('wp_ajax_rg_select_export_form', array('RGForms', 'select_export_form'));

                        add_action('wp_ajax_rg_start_export', array('RGForms', 'start_export'));

                        add_action('wp_ajax_gf_upgrade_license', array('RGForms', 'upgrade_license'));

                        add_action('wp_ajax_gf_delete_custom_choice', array('RGForms', 'delete_custom_choice'));

                        add_action('wp_ajax_gf_save_custom_choice', array('RGForms', 'save_custom_choice'));

                        add_action('wp_ajax_gf_get_post_categories', array('RGForms', 'get_post_category_values'));

                        add_action('wp_ajax_gf_get_notification_post_categories', array('RGForms', 'get_notification_post_category_values'));



                        //entry list ajax operations

                        add_action('wp_ajax_rg_update_lead_property', array('RGForms', 'update_lead_property'));

                        add_action('wp_ajax_delete-gf_entry', array('RGForms', 'update_lead_status'));



                        //form list ajax operations

                        add_action('wp_ajax_rg_update_form_active', array('RGForms', 'update_form_active'));



                        //dynamic captcha image

                        add_action('wp_ajax_rg_captcha_image', array('RGForms', 'captcha_image'));



                        //dashboard message "dismiss upgrade" link

                        add_action("wp_ajax_rg_dismiss_upgrade", array('RGForms', 'dashboard_dismiss_upgrade'));



                        // entry detial: resend notifications

                        add_action("wp_ajax_gf_resend_notifications", array('RGForms', 'resend_notifications'));



                    }



                    add_filter("plugins_api", array("RGForms", "get_addon_info"), 10, 3);

                    add_action('after_plugin_row_gravityforms/gravityforms.php', array('RGForms', 'plugin_row') );

                    add_action('install_plugins_pre_plugin-information', array('RGForms', 'display_changelog'));

                    add_filter('plugin_action_links', array('RGForms', 'plugin_settings_link'),10,2);

                }

            }

        }

        else{

            add_action('wp_enqueue_scripts', array('RGForms', 'enqueue_scripts'));

            add_action('wp', array('RGForms', 'ajax_parse_request'), 10);



            // ManageWP premium update filters

            add_filter( 'mwp_premium_update_notification', array('RGForms', 'premium_update_push') );

            add_filter( 'mwp_premium_perform_update', array('RGForms', 'premium_update') );

        }



        add_shortcode('gravityform', array('RGForms', 'parse_shortcode'));

        add_shortcode('gravityforms', array('RGForms', 'parse_shortcode'));

    }



    public static function set_logging_supported($plugins)

    {

        $plugins["gravityforms"] = "Gravity Forms Core";

        return $plugins;

    }



    public static function maybe_process_form(){



        $form_id = isset($_POST["gform_submit"]) ? $_POST["gform_submit"] : 0;

        if($form_id){

            $form_info = RGFormsModel::get_form($form_id);

            $is_valid_form = $form_info && $form_info->is_active;



            if($is_valid_form){

                require_once(GFCommon::get_base_path() . "/form_display.php");

                GFFormDisplay::process_form($form_id);

            }

        }

    }



    public static function process_exterior_pages(){

        if(rgempty("gf_page", $_GET))

            return;



        //ensure users are logged in

        if(!is_user_logged_in())

            auth_redirect();



        switch(rgget("gf_page")){

            case "preview":

                require_once(GFCommon::get_base_path() . "/preview.php");

            break;



            case "print-entry" :

                require_once(GFCommon::get_base_path() . "/print-entry.php");

            break;



            case "select_columns" :

                require_once(GFCommon::get_base_path() . "/select_columns.php");

            break;

        }

        exit();

    }



    public static function check_update($update_plugins_option){

        if(!class_exists("GFCommon"))

            require_once("common.php");



        return GFCommon::check_update($update_plugins_option, true);

    }



    //Creates or updates database tables. Will only run when version changes

    public static function setup($force_setup = false){

        global $wpdb;



        $version = GFCommon::$version;



        if(get_option("rg_form_version") != $version || $force_setup){



            $error = "";

            if(!self::has_database_permission($error)){

                ?>

                <div class='error' style="padding:15px;"><?php echo $error?></div>

                <?php

            }



            require_once(ABSPATH . '/wp-admin/includes/upgrade.php');



            if ( ! empty($wpdb->charset) )

                $charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";

            if ( ! empty($wpdb->collate) )

                $charset_collate .= " COLLATE $wpdb->collate";



            //Fixes issue with dbDelta lower-casing table names, which cause problems on case sensitive DB servers.

            add_filter( 'dbdelta_create_queries', array("RGForms", "dbdelta_fix_case"));



            //------ FORM -----------------------------------------------

            $form_table_name = RGFormsModel::get_form_table_name();

            $sql = "CREATE TABLE " . $form_table_name . " (

                  id mediumint(8) unsigned not null auto_increment,

                  title varchar(150) not null,

                  date_created datetime not null,

                  is_active tinyint(1) not null default 1,

                  PRIMARY KEY  (id)

                ) $charset_collate;";

            dbDelta($sql);



            //droping table that was created by mistake in version 1.6.3.2

            $wpdb->query("DROP TABLE IF EXISTS A" . $form_table_name);



            //------ META -----------------------------------------------

            $meta_table_name = RGFormsModel::get_meta_table_name();

            $sql = "CREATE TABLE " . $meta_table_name . " (

                  form_id mediumint(8) unsigned not null,

                  display_meta longtext,

                  entries_grid_meta longtext,

                  PRIMARY KEY  (form_id)

                ) $charset_collate;";

            dbDelta($sql);



            //droping outdated form_id index (if one exists)

            self::drop_index($meta_table_name, 'form_id');



            //------ FORM VIEW -----------------------------------------------

            $form_view_table_name = RGFormsModel::get_form_view_table_name();

            $sql = "CREATE TABLE " . $form_view_table_name . " (

                  id bigint(20) unsigned not null auto_increment,

                  form_id mediumint(8) unsigned not null,

                  date_created datetime not null,

                  ip char(15),

                  count mediumint(8) unsigned not null default 1,

                  PRIMARY KEY  (id),

                  KEY form_id (form_id)

                ) $charset_collate;";

            dbDelta($sql);



            //------ LEAD -----------------------------------------------

            $lead_table_name = RGFormsModel::get_lead_table_name();

            $sql = "CREATE TABLE " . $lead_table_name . " (

                  id int(10) unsigned not null auto_increment,

                  form_id mediumint(8) unsigned not null,

                  post_id bigint(20) unsigned,

                  date_created datetime not null,

                  is_starred tinyint(1) not null default 0,

                  is_read tinyint(1) not null default 0,

                  ip varchar(39) not null,

                  source_url varchar(200) not null default '',

                  user_agent varchar(250) not null default '',

                  currency varchar(5),

                  payment_status varchar(15),

                  payment_date datetime,

                  payment_amount decimal(19,2),

                  transaction_id varchar(50),

                  is_fulfilled tinyint(1),

                  created_by bigint(20) unsigned,

                  transaction_type tinyint(1),

                  status varchar(20) not null default 'active',

                  PRIMARY KEY  (id),

                  KEY form_id (form_id),

                  KEY status (status)

                ) $charset_collate;";

           dbDelta($sql);



           //------ LEAD NOTES ------------------------------------------

            $lead_notes_table_name = RGFormsModel::get_lead_notes_table_name();

            $sql = "CREATE TABLE " . $lead_notes_table_name . " (

                  id int(10) unsigned not null auto_increment,

                  lead_id int(10) unsigned not null,

                  user_name varchar(250),

                  user_id bigint(20),

                  date_created datetime not null,

                  value longtext,

                  PRIMARY KEY  (id),

                  KEY lead_id (lead_id),

                  KEY lead_user_key (lead_id,user_id)

                ) $charset_collate;";

           dbDelta($sql);



            //------ LEAD DETAIL -----------------------------------------

            $lead_detail_table_name = RGFormsModel::get_lead_details_table_name();

            $sql = "CREATE TABLE " . $lead_detail_table_name . " (

                  id bigint(20) unsigned not null auto_increment,

                  lead_id int(10) unsigned not null,

                  form_id mediumint(8) unsigned not null,

                  field_number float not null,

                  value varchar(". GFORMS_MAX_FIELD_LENGTH ."),

                  PRIMARY KEY  (id),

                  KEY form_id (form_id),

                  KEY lead_id (lead_id)

                ) $charset_collate;";

            dbDelta($sql);



            //------ LEAD DETAIL LONG -----------------------------------

            $lead_detail_long_table_name = RGFormsModel::get_lead_details_long_table_name();



            $sql = "CREATE TABLE " . $lead_detail_long_table_name . " (

                  lead_detail_id bigint(20) unsigned not null,

                  value longtext,

                  PRIMARY KEY  (lead_detail_id)

                ) $charset_collate;";

            dbDelta($sql);



            //droping outdated form_id index (if one exists)

            self::drop_index($lead_detail_long_table_name, 'lead_detail_key');



            //------ LEAD META -----------------------------------

            $lead_meta_table_name = RGFormsModel::get_lead_meta_table_name();

            $sql = "CREATE TABLE " . $lead_meta_table_name . " (

                  id bigint(20) unsigned not null auto_increment,

                  lead_id bigint(20) unsigned not null,

                  meta_key varchar(255),

                  meta_value longtext,

                  PRIMARY KEY  (id),

                  KEY meta_key (meta_key),

                  KEY lead_id (lead_id)

                ) $charset_collate;";

            dbDelta($sql);



            remove_filter('dbdelta_create_queries', array("RGForms", "dbdelta_fix_case"));



            //fix checkbox value. needed for version 1.0 and below but won't hurt for higher versions

            self::fix_checkbox_value();



            //auto-setting license key based on value configured via the GF_LICENSE_KEY constant or the gf_license_key variable

            global $gf_license_key;

            $license_key = defined("GF_LICENSE_KEY") && empty($gf_license_key) ? GF_LICENSE_KEY : $gf_license_key;

            if(!empty($license_key))

                update_option("rg_gforms_key", md5($license_key));



            //auto-setting recaptcha keys based on value configured via the constant or global variable

            global $gf_recaptcha_public_key, $gf_recaptcha_private_key;

            $private_key = defined("GF_RECAPTCHA_PRIVATE_KEY") && empty($gf_recaptcha_private_key) ? GF_RECAPTCHA_PRIVATE_KEY : $gf_recaptcha_private_key;

            if(!empty($private_key))

                update_option("rg_gforms_captcha_private_key", $private_key);



            $public_key = defined("GF_RECAPTCHA_PUBLIC_KEY") && empty($gf_recaptcha_public_key) ? GF_RECAPTCHA_PUBLIC_KEY : $gf_recaptcha_public_key;

            if(!empty($public_key))

                update_option("rg_gforms_captcha_public_key", $public_key);



            //Auto-importing forms based on GF_IMPORT_FILE AND GF_THEME_IMPORT_FILE

            if(defined("GF_IMPORT_FILE") && !get_option("gf_imported_file")){

                GFExport::import_file(GF_IMPORT_FILE);

                update_option("gf_imported_file", true);

            }



            //adds empty index.php files to upload folders. only for v1.5.2 and below

            if(version_compare(get_option("rg_form_version"), "1.6", "<")){

                self::add_empty_index_files();

            }



            update_option("rg_form_version", $version);

        }



        //Import theme specific forms if configured. Will only import forms once per theme.

        if(defined("GF_THEME_IMPORT_FILE")){

            $themes = get_option("gf_imported_theme_file");

            if(!is_array($themes))

                $themes = array();



            //if current theme has already imported it's forms, don't import again

            $theme = get_template();

            if(!isset($themes[$theme])){



                //importing forms

                GFExport::import_file(get_stylesheet_directory() . "/" . GF_THEME_IMPORT_FILE);



                //adding current theme to the list of imported themes. So that forms are not imported again for it.

                $themes[$theme] = true;

                update_option("gf_imported_theme_file", $themes);

            }

        }

    }



    public static function dbdelta_fix_case($cqueries){

        foreach ($cqueries as $table => $qry) {

            $table_name = $table;

            if(preg_match("|CREATE TABLE ([^ ]*)|", $qry, $matches)){

                $query_table_name = trim($matches[1], '`' );



                //fix table names that are different just by their casing

                if(strtolower($query_table_name) == $table){

                    $table_name = $query_table_name;

                }

            }

            $queries[$table_name] = $qry;

        }

        return $queries;

    }



    public static function no_conflict_mode_style(){

        if(!get_option("gform_enable_noconflict"))

            return;



        global $wp_styles;

        $wp_required_styles = array("admin-bar", "colors", "ie", "wp-admin");

        $gf_required_styles = array(

            "common" => array(),

            "gf_edit_forms" => array("thickbox"),

            "gf_edit_forms_notification" => array("thickbox", "editor-buttons", "wp-jquery-ui-dialog"),

            "gf_new_form" => array("thickbox"),

            "gf_entries" => array("thickbox"),

            "gf_settings" => array(),

            "gf_export" => array(),

            "gf_help" => array()

        );



        self::no_conflict_mode($wp_styles, $wp_required_styles, $gf_required_styles, "styles");

    }



    public static function no_conflict_mode_script(){

        if(!get_option("gform_enable_noconflict"))

            return;



        global $wp_scripts;



        $wp_required_scripts = array("admin-bar", "common", "jquery-color", "utils");

        $gf_required_scripts = array(

            "common" => array("qtip-init", "sack"),

            "gf_edit_forms" => array("thickbox", "jquery-ui-core", "jquery-ui-sortable", "jquery-ui-tabs", "rg_currency", "gforms_gravityforms" ),

            "gf_edit_forms_notification" => array("editor", "word-count", "quicktags", "wpdialogs-popup", "media-upload", "wplink"),

            "gf_new_form" => array("thickbox", "jquery-ui-core", "jquery-ui-sortable", "jquery-ui-tabs", "rg_currency", "gforms_gravityforms" ),

            "gf_entries" => array("thickbox", "gforms_gravityforms"),

            "gf_settings" => array(),

            "gf_export" => array(),

            "gf_help" => array(),

        );



        self::no_conflict_mode($wp_scripts, $wp_required_scripts, $gf_required_scripts, "scripts");

    }



    private static function no_conflict_mode(&$wp_objects, $wp_required_objects, $gf_required_objects, $type="scripts"){



        $current_page = trim(strtolower(rgget("page")));

        if(empty($current_page))

            $current_page = trim(strtolower(rgget("gf_page")));

        if(empty($current_page))

            $current_page = RG_CURRENT_PAGE;



        $view = rgempty("view", $_GET) ? "default" : rgget("view");

        $page_objects = isset($gf_required_objects[$current_page . "_" . $view]) ? $gf_required_objects[$current_page . "_" . $view] : rgar($gf_required_objects, $current_page);



        //disable no-conflict if $page_objects is false

        if($page_objects === false)

            return;



        if(!is_array($page_objects))

            $page_objects = array();



        //merging wp scripts with gravity forms scripts

        $required_objects = array_merge($wp_required_objects, $gf_required_objects["common"], $page_objects);



        //allowing addons or other products to change the list of no conflict scripts

        $required_objects = apply_filters("gform_noconflict_{$type}", $required_objects);



        $queue = array();

        foreach($wp_objects->queue as $object){

            if(in_array($object, $required_objects))

                $queue[] = $object;

        }

        $wp_objects->queue = $queue;



        $required_objects = self::add_script_dependencies($wp_objects->registered, $required_objects);



        //unregistering scripts

        $registered = array();

        foreach($wp_objects->registered as $script_name => $script_registration){

            if(in_array($script_name, $required_objects)){

                $registered[$script_name] = $script_registration;

            }

        }

        $wp_objects->registered = $registered;

    }



    private static function add_script_dependencies($registered, $scripts){



        //gets all dependent scripts linked to the $scripts array passed

        do{

            $dependents = array();

            foreach($scripts as $script){

                $deps = isset($registered[$script]) && is_array($registered[$script]->deps) ? $registered[$script]->deps : array();

                foreach($deps as $dep){

                    if(!in_array($dep, $scripts) && !in_array($dep, $dependents)){

                        $dependents[] = $dep;

                    }

                }

            }

            $scripts = array_merge($scripts, $dependents);

        }while(!empty($dependents));



        return $scripts;

    }



    //Integration with ManageWP

    public static function premium_update_push( $premium_update ){



        if( !function_exists( 'get_plugin_data' ) )

            include_once( ABSPATH.'wp-admin/includes/plugin.php');



        $update = GFCommon::get_version_info();

        if( $update["is_valid_key"] == true && version_compare(GFCommon::$version, $update["version"], '<') ){

            $gforms = get_plugin_data( __FILE__ );

            $gforms['type'] = 'plugin';

            $gforms['slug'] = 'gravityforms/gravityforms.php';

            $gforms['new_version'] = isset($update['version']) ? $update['version'] : false ;

            $premium_update[] = $gforms;

        }



        return $premium_update;

    }



    //Integration with ManageWP

    public static function premium_update( $premium_update ){



        if( !function_exists( 'get_plugin_data' ) )

            include_once( ABSPATH.'wp-admin/includes/plugin.php');



        $update = GFCommon::get_version_info();

        if( $update["is_valid_key"] == true && version_compare(GFCommon::$version, $update["version"], '<') ){

            $gforms = get_plugin_data( __FILE__ );

            $gforms['slug'] = 'gravityforms/gravityforms.php'; // If not set by default, always pass theme template

            $gforms['type'] = 'plugin';

            $gforms['url'] = isset($update["url"]) ? $update["url"] : false; // OR provide your own callback function for managing the update



            array_push($premium_update, $gforms);

        }

        return $premium_update;

    }



    private static function drop_index($table, $index){

        global $wpdb;

        $has_index = $wpdb->get_var("SHOW INDEX FROM {$table} WHERE Key_name='{$index}'");

        if($has_index){

            $wpdb->query("DROP INDEX {$index} ON {$table}");

        }

    }



    private static function add_empty_index_files(){

        $upload_root = RGFormsModel::get_upload_root();

        GFCommon::recursive_add_index_file($upload_root);

    }



    private static function has_database_permission(&$error){

        global $wpdb;



        $wpdb->hide_errors();



        $has_permission = true;



        $sql = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}rg_test ( col1 int )";

        $wpdb->query($sql);

        $error = "Current database user does not have necessary permissions to create tables.";

        if(!empty($wpdb->last_error))

            $has_permission = false;



        $sql = "ALTER TABLE {$wpdb->prefix}rg_test ADD COLUMN a" . uniqid() ." int";

        $wpdb->query($sql);

        $error = "Current database user does not have necessary permissions to modify (ALTER) tables.";

        if(!empty($wpdb->last_error))

            $has_permission = false;



        $sql = "DROP TABLE {$wpdb->prefix}rg_test";

        $wpdb->query($sql);



        $wpdb->show_errors();



        return $has_permission;

    }



    //Changes checkbox entry values from "!" to the current choice text. Neededed when upgrading users from 1.0

    private static function fix_checkbox_value(){

        global $wpdb;



        $table_name = RGFormsModel::get_lead_details_table_name();



        $sql = "select * from $table_name where value= '!'";

        $results = $wpdb->get_results($sql);

        foreach($results as $result){

            $form = RGFormsModel::get_form_meta($result->form_id);

            $field = RGFormsModel::get_field($form, $result->field_number);

            if($field["type"] == "checkbox"){

                $input = GFCommon::get_input($field, $result->field_number);

                $wpdb->update($table_name, array("value" => $input["label"]), array("id" => $result->id));

            }

        }

    }



    public static function user_has_cap($all_caps, $cap, $args){

        $gf_caps = GFCommon::all_caps();

        $capability = rgar($cap, 0);

        if($capability != "gform_full_access"){

            return $all_caps;

        }



        if(!self::has_members_plugin()){

            //give full access to administrators if the members plugin is not installed

            if(current_user_can("administrator") || is_super_admin()){

                $all_caps["gform_full_access"] = true;

            }

        }

        else if(current_user_can("administrator")|| is_super_admin()){



            //checking if user has any GF permission.

            $has_gf_cap = false;

            foreach($gf_caps as $gf_cap){

                if(rgar($all_caps, $gf_cap))

                    $has_gf_cap = true;

            }



            if(!$has_gf_cap){

                //give full access to administrators if none of the GF permissions are active by the Members plugin

                $all_caps["gform_full_access"] = true;

            }

        }



        return $all_caps;

    }



    //Target of Member plugin filter. Provides the plugin with Gravity Forms lists of capabilities

    public static function members_get_capabilities( $caps ) {

        return array_merge($caps, GFCommon::all_caps());

    }



    //Tests if the upload folder is writable and displays an error message if not

    public static function check_upload_folder(){

        //check if upload folder is writable

        $folder = RGFormsModel::get_upload_root();

        if(empty($folder))

            echo "<div class='error'>Upload folder is not writable. Export and file upload features will not be functional.</div>";

    }



    //Prints common admin scripts

    public static function print_scripts(){

        wp_enqueue_script("sack");

        wp_print_scripts();

    }



    public static function is_gravity_ajax_action(){

        //Gravity Forms AJAX requests

        $current_action = self::post("action");

        $gf_ajax_actions = array('rg_save_form', 'rg_change_input_type', 'rg_add_field', 'rg_duplicate_field',

                                 'rg_delete_field', 'rg_select_export_form', 'rg_start_export', 'gf_upgrade_license',

                                 'gf_delete_custom_choice', 'gf_save_custom_choice', 'gf_get_notification_post_categories',

                                 'rg_update_lead_property', 'delete-gf_entry', 'rg_update_form_active',

                                 'gf_resend_notifications', 'rg_dismiss_upgrade');



        if(defined("DOING_AJAX") && DOING_AJAX && in_array($current_action, $gf_ajax_actions))

            return true;



        //not a gravity forms ajax request.

        return false;

    }



    //Returns true if the current page is one of Gravity Forms pages. Returns false if not

    public static function is_gravity_page(){



        //Gravity Forms pages

        $current_page = trim(strtolower(self::get("page")));

        $gf_pages = array("gf_edit_forms","gf_new_form","gf_entries","gf_settings","gf_export","gf_help");



        return in_array($current_page, $gf_pages);

    }



    public static function do_menu_page(){

        $args = array( 'show_ui' => true, '_builtin' => false, 'show_in_menu' => true );

        $count = (int) count(get_post_types( $args ));

        return $count > 0;

    }



    //Creates "Forms" left nav

    public static function create_menu(){



        $has_full_access = current_user_can("gform_full_access");

        $min_cap = GFCommon::current_user_can_which(GFCommon::all_caps());

        if(empty($min_cap))

            $min_cap = "gform_full_access";



        $addon_menus = array();

        $addon_menus = apply_filters("gform_addon_navigation", $addon_menus);



        $parent_menu = self::get_parent_menu($addon_menus);



        // Add a top-level left nav

        $update_icon = GFCommon::has_update() ? "<span title='" . esc_attr(__("Update Available", "alien")) . "' class='update-plugins count-1'><span class='update-count'>1</span></span>" : "";





        //Getting around a Wordpress bug that prevents menus from displayeing when site has multiple custom post types

        if( self::do_menu_page() )

            add_menu_page(__('Forms', "gravityforms"), __("Forms", "gravityforms") . $update_icon , $has_full_access ? "gform_full_access" : $min_cap, $parent_menu["name"] , $parent_menu["callback"], GFCommon::get_base_url() . '/images/gravity-admin-icon.png', 16.9);

        else

            add_object_page(__('Forms', "gravityforms"), __("Forms", "gravityforms") . $update_icon , $has_full_access ? "gform_full_access" : $min_cap, $parent_menu["name"] , $parent_menu["callback"], GFCommon::get_base_url() . '/images/gravity-admin-icon.png');



        // Adding submenu pages

        add_submenu_page($parent_menu["name"], __("Forms", "gravityforms"), __("Forms", "gravityforms"), $has_full_access ? "gform_full_access" : "gravityforms_edit_forms", "gf_edit_forms", array("RGForms", "forms"));



        add_submenu_page($parent_menu["name"], __("New Form", "gravityforms"), __("New Form", "gravityforms"), $has_full_access ? "gform_full_access" : "gravityforms_create_form", "gf_new_form", array("RGForms", "new_form"));



        add_submenu_page($parent_menu["name"], __("Entries", "gravityforms"), __("Entries", "gravityforms"), $has_full_access ? "gform_full_access" : "gravityforms_view_entries", "gf_entries", array("RGForms", "all_leads_page"));



        if(is_array($addon_menus)){

            foreach($addon_menus as $addon_menu)

                add_submenu_page($parent_menu["name"], $addon_menu["label"], $addon_menu["label"], $has_full_access ? "gform_full_access" : $addon_menu["permission"], $addon_menu["name"], $addon_menu["callback"]);

        }



        add_submenu_page($parent_menu["name"], __("Settings", "gravityforms"), __("Settings", "gravityforms"), $has_full_access ? "gform_full_access" : "gravityforms_view_settings", "gf_settings", array("RGForms", "settings_page"));



        add_submenu_page($parent_menu["name"], __("Import/Export", "gravityforms"), __("Import/Export", "gravityforms"), $has_full_access ? "gform_full_access" : "gravityforms_export_entries", "gf_export", array("RGForms", "export_page"));



        if(current_user_can("install_plugins")){

            add_submenu_page($parent_menu["name"], __("Updates", "gravityforms"), __("Updates", "gravityforms"), $has_full_access ? "gform_full_access" : "gravityforms_view_updates", "gf_update", array("RGForms", "update_page"));

            add_submenu_page($parent_menu["name"], __("Add-Ons", "gravityforms"), __("Add-Ons", "gravityforms"), $has_full_access ? "gform_full_access" : "gravityforms_view_addons", "gf_addons", array("RGForms", "addons_page"));

        }



        add_submenu_page($parent_menu["name"], __("Help", "gravityforms"), __("Help", "gravityforms"), $has_full_access ? "gform_full_access" : $min_cap, "gf_help", array("RGForms", "help_page"));



    }



    //Returns the parent menu item. It needs to be the same as the first sub-menu (otherwise WP will duplicate the main menu as a sub-menu)

    public static function get_parent_menu($addon_menus){



        if(GFCommon::current_user_can_any("gravityforms_edit_forms"))

            $parent = array("name" => "gf_edit_forms", "callback" => array("RGForms", "forms"));



        else if(GFCommon::current_user_can_any("gravityforms_create_form"))

            $parent = array("name" => "gf_new_form", "callback" => array("RGForms", "new_form"));



        else if(GFCommon::current_user_can_any("gravityforms_view_entries"))

            $parent = array("name" => "gf_entries", "callback" => array("RGForms", "all_leads_page"));



        else if(is_array($addon_menus) && sizeof($addon_menus) > 0){

            foreach($addon_menus as $addon_menu)

                if(GFCommon::current_user_can_any($addon_menu["permission"]))

                {

                    $parent = array("name" => $addon_menu["name"], "callback" => $addon_menu["callback"]);

                    break;

                }

        }

        else if(GFCommon::current_user_can_any("gravityforms_view_settings"))

            $parent = array("name" => "gf_settings", "callback" => array("RGForms", "settings_page"));



        else if(GFCommon::current_user_can_any("gravityforms_export_entries"))

            $parent = array("name" => "gf_export", "callback" => array("RGForms", "export_page"));



        else if(GFCommon::current_user_can_any("gravityforms_view_updates"))

            $parent = array("name" => "gf_update", "callback" => array("RGForms", "update_page"));



        else if(GFCommon::current_user_can_any("gravityforms_view_addons"))

            $parent = array("name" => "gf_addons", "callback" => array("RGForms", "addons_page"));



        else if(GFCommon::current_user_can_any(GFCommon::all_caps()))

            $parent = array("name" => "gf_help", "callback" => array("RGForms", "help_page"));



        return $parent;

    }



    //Parses the [gravityform shortcode and returns the front end form UI

    public static function parse_shortcode($attributes, $content = null){

        extract(shortcode_atts(array(

             'title' => true,

             'description' => true,

             'id' => 0,

             'name' => '',

             'field_values' => "",

             'ajax' => false,

             'tabindex' => 1,

             'action' => 'form'

          ), $attributes));



        $shortcode_string = "";



        switch($action) {

            case 'conditional':

                $shortcode_string = GFCommon::conditional_shortcode($attributes, $content);

            break;



            case 'form' :

                //displaying form

                $title = strtolower($title) == "false" ? false : true;

                $description = strtolower($description) == "false" ? false : true;

                $field_values = htmlspecialchars_decode($field_values);

                $field_values = str_replace("&#038;", "&", $field_values);



                $ajax = strtolower($ajax) == "true" ? true : false;



                //using name to lookup form if id is not specified

                if(empty($id))

                    $id = $name;



                parse_str($field_values, $field_value_array); //parsing query string like string for field values and placing them into an associative array

                $field_value_array = stripslashes_deep($field_value_array);



                $shortcode_string = self::get_form($id, $title, $description, false, $field_value_array, $ajax, $tabindex);



            break;

        }



        $shortcode_string = apply_filters("gform_shortcode_{$action}", $shortcode_string, $attributes, $content);



        return $shortcode_string;

    }



    //-------------------------------------------------

    //----------- AJAX --------------------------------



    public static function ajax_parse_request($wp) {



        if (isset($_POST["gform_ajax"])) {

            parse_str($_POST["gform_ajax"]);



            require_once(GFCommon::get_base_path() . "/form_display.php");

            $result = GFFormDisplay::get_form($form_id, $title, $description, false, $_POST["gform_field_values"], true);

            die($result);

        }

    }



//------------------------------------------------------

//------------- PAGE/POST EDIT PAGE ---------------------



    //Action target that adds the "Insert Form" button to the post/page edit screen

    public static function add_form_button(){

        $is_post_edit_page = in_array(RG_CURRENT_PAGE, array('post.php', 'page.php', 'page-new.php', 'post-new.php'));

        if(!$is_post_edit_page)

            return;



        // do a version check for the new 3.5 UI

        $version    = get_bloginfo('version');



        if ($version < 3.5) {

            // show button for v 3.4 and below

            $image_btn = GFCommon::get_base_url() . "/images/form-button.png";

            echo '<a href="#TB_inline?width=480&inlineId=select_gravity_form" class="thickbox" id="add_gform" title="' . __("Add Gravity Form", 'gravityforms') . '"><img src="'.$image_btn.'" alt="' . __("Add Gravity Form", 'gravityform') . '" /></a>';

        } else {

            // display button matching new UI

            echo '<style>.gform_media_icon{

                    background:url(' . GFCommon::get_base_url() . '/images/gravity-admin-icon.png) no-repeat top left;

                    display: inline-block;

                    height: 16px;

                    margin: 0 2px 0 0;

                    vertical-align: text-top;

                    width: 16px;

                    }

                    .wp-core-ui a.gform_media_link{

                     padding-left: 0.4em;

                    }

                 </style>

                  <a href="#TB_inline?width=480&inlineId=select_gravity_form" class="thickbox button gform_media_link" id="add_gform" title="' . __("Add Gravity Form", 'gravityforms') . '"><span class="gform_media_icon "></span> ' . __("Add Form", "gravityforms") . '</a>';

        }

    }



    //Action target that displays the popup to insert a form to a post/page

    public static function add_mce_popup(){

        ?>

        <script>

            function InsertForm(){

                var form_id = jQuery("#add_form_id").val();

                if(form_id == ""){

                    alert("<?php _e("Please select a form", "gravityforms") ?>");

                    return;

                }



                var form_name = jQuery("#add_form_id option[value='" + form_id + "']").text().replace(/[\[\]]/g, '');

                var display_title = jQuery("#display_title").is(":checked");

                var display_description = jQuery("#display_description").is(":checked");

                var ajax = jQuery("#gform_ajax").is(":checked");

                var title_qs = !display_title ? " title=\"false\"" : "";

                var description_qs = !display_description ? " description=\"false\"" : "";

                var ajax_qs = ajax ? " ajax=\"true\"" : "";



                window.send_to_editor("[gravityform id=\"" + form_id + "\" name=\"" + form_name + "\"" + title_qs + description_qs + ajax_qs + "]");

            }

        </script>



        <div id="select_gravity_form" style="display:none;">

            <div class="wrap">

                <div>

                    <div style="padding:15px 15px 0 15px;">

                        <h3 style="color:#5A5A5A!important; font-family:Georgia,Times New Roman,Times,serif!important; font-size:1.8em!important; font-weight:normal!important;"><?php _e("Insert A Form", "gravityforms"); ?></h3>

                        <span>

                            <?php _e("Select a form below to add it to your post or page.", "gravityforms"); ?>

                        </span>

                    </div>

                    <div style="padding:15px 15px 0 15px;">

                        <select id="add_form_id">

                            <option value="">  <?php _e("Select a Form", "gravityforms"); ?>  </option>

                            <?php

                                $forms = RGFormsModel::get_forms(1, "title");

                                foreach($forms as $form){

                                    ?>

                                    <option value="<?php echo absint($form->id) ?>"><?php echo esc_html($form->title) ?></option>

                                    <?php

                                }

                            ?>

                        </select> <br/>

                        <div style="padding:8px 0 0 0; font-size:11px; font-style:italic; color:#5A5A5A"><?php _e("Can't find your form? Make sure it is active.", "gravityforms"); ?></div>

                    </div>

                    <div style="padding:15px 15px 0 15px;">

                        <input type="checkbox" id="display_title" checked='checked' /> <label for="display_title"><?php _e("Display form title", "gravityforms"); ?></label> &nbsp;&nbsp;&nbsp;

                        <input type="checkbox" id="display_description" checked='checked' /> <label for="display_description"><?php _e("Display form description", "gravityforms"); ?></label>&nbsp;&nbsp;&nbsp;

                        <input type="checkbox" id="gform_ajax" /> <label for="gform_ajax"><?php _e("Enable AJAX", "gravityforms"); ?></label>

                    </div>

                    <div style="padding:15px;">

                        <input type="button" class="button-primary" value="Insert Form" onclick="InsertForm();"/>&nbsp;&nbsp;&nbsp;

                    <a class="button" style="color:#bbb;" href="#" onclick="tb_remove(); return false;"><?php _e("Cancel", "gravityforms"); ?></a>

                    </div>

                </div>

            </div>

        </div>



        <?php

    }





    //------------------------------------------------------

    //------------- PLUGINS PAGE ---------------------------

    //------------------------------------------------------



    public static function plugin_settings_link( $links, $file ) {

        if ( $file != plugin_basename( __FILE__ ))

            return $links;



        array_unshift($links, '<a href="' . admin_url("admin.php") . '?page=gf_settings">' . __( 'Settings', 'gravityforms' ) . '</a>');



        return $links;

    }



    //Displays message on Plugin's page

    public static function plugin_row($plugin_name){



        $key = GFCommon::get_key();

        $version_info = GFCommon::get_version_info();



        if(!$version_info["is_valid_key"]){



            $plugin_name = "gravityforms/gravityforms.php";



            $new_version = version_compare(GFCommon::$version, $version_info["version"], '<') ? __('There is a new version of Gravity Forms available.', 'gravityforms') .' <a class="thickbox" title="Gravity Forms" href="plugin-install.php?tab=plugin-information&plugin=gravityforms&TB_iframe=true&width=640&height=808">'. sprintf(__('View version %s Details', 'gravityforms'), $version_info["version"]) . '</a>. ' : '';

            echo '</tr><tr class="plugin-update-tr"><td colspan="3" class="plugin-update"><div class="update-message">' . $new_version . __('<a href="' . admin_url() . 'admin.php?page=gf_settings">Register</a> your copy of Gravity Forms to receive access to automatic upgrades and support. Need a license key? <a href="http://www.gravityforms.com">Purchase one now</a>.', 'gravityforms') . '</div></td>';

        }

    }



    //Displays current version details on Plugin's page

    public static function display_changelog(){

        if($_REQUEST["plugin"] != "gravityforms")

            return;



        $page_text = self::get_changelog();

        echo $page_text;



        exit;

    }



    public static function get_changelog(){

        $key = GFCommon::get_key();

        $body = "key=$key";

        $options = array('method' => 'POST', 'timeout' => 3, 'body' => $body);

        $options['headers'] = array(

            'Content-Type' => 'application/x-www-form-urlencoded; charset=' . get_option('blog_charset'),

            'Content-Length' => strlen($body),

            'User-Agent' => 'WordPress/' . get_bloginfo("version"),

            'Referer' => get_bloginfo("url")

        );



        $raw_response = wp_remote_request(GRAVITY_MANAGER_URL . "/changelog.php?" . GFCommon::get_remote_request_params(), $options);



        if ( is_wp_error( $raw_response ) || 200 != $raw_response['response']['code']){

            $page_text = __("Oops!! Something went wrong.<br/>Please try again or <a href='http://www.gravityforms.com'>contact us</a>.", 'gravityforms');

        }

        else{

            $page_text = $raw_response['body'];

            if(substr($page_text, 0, 10) != "<!--GFM-->")

                $page_text = "";

        }

        return stripslashes($page_text);

    }



//------------------------------------------------------

//-------------- DASHBOARD PAGE -------------------------



    //Registers the dashboard widget

    public static function dashboard_setup(){

        $dashboard_title = apply_filters("gform_dashboard_title", __("Forms", "gravityforms"));

        wp_add_dashboard_widget('rg_forms_dashboard', $dashboard_title,  array('RGForms', 'dashboard'));

    }



    //Displays the dashboard UI

    public static function dashboard(){

        $forms = RGFormsModel::get_form_summary();



        if(sizeof($forms) > 0){

            ?>

            <table class="widefat" cellspacing="0" style="border:0px;">

                <thead>

                    <tr>

                        <td style="text-align:left; padding:8px 18px!important; font-weight:bold;"><i><?php _e("Title", "gravityforms") ?></i></td>

                        <td style="text-align:center; padding:8px 18px!important; font-weight:bold;"><i><?php _e("Unread", "gravityforms") ?></i></td>

                        <td style="text-align:center; padding:8px 18px!important; font-weight:bold;"><i><?php _e("Total", "gravityforms") ?></i></td>

                    </tr>

                </thead>



                <tbody class="list:user user-list">

                    <?php

                    foreach($forms as $form){

                        $date_display = GFCommon::format_date($form["last_lead_date"]);

                        if(!empty($form["total_leads"])){

                            ?>

                            <tr class='author-self status-inherit' valign="top">

                                <td class="column-title" style="padding:8px 18px;">

                                    <a style="display:inline; <?php echo  $form["unread_count"] > 0 ? "font-weight:bold;" : "" ?>" href="admin.php?page=gf_entries&view=entries&id=<?php echo absint($form["id"]) ?>" title="<?php echo esc_html($form["title"]) ?> : <?php _e("View All Entries", "gravityforms") ?>"><?php echo esc_html($form["title"]) ?></a>

                                </td>

                                <td class="column-date" style="padding:8px 18px; text-align:center;"><a style="<?php echo $form["unread_count"] > 0 ? "font-weight:bold;" : "" ?>" href="admin.php?page=gf_entries&view=entries&filter=unread&id=<?php echo absint($form["id"]) ?>" title="<?php printf(__("Last Entry: %s", "gravityforms"), $date_display); ?>"><?php echo absint($form["unread_count"]) ?></a></td>

                                <td class="column-date" style="padding:8px 18px; text-align:center;"><a href="admin.php?page=gf_entries&view=entries&id=<?php echo absint($form["id"]) ?>" title="<?php _e("View All Entries", "gravityforms") ?>"><?php echo absint($form["total_leads"]) ?></a></td>

                            </tr>

                            <?php

                        }

                    }

                    ?>

                </tbody>

            </table>



            <p class="textright">

            <a class="button" href="admin.php?page=gf_edit_forms"><?php _e("View All Forms", "gravityforms") ?></a>

          </p>

            <?php

        }

        else{

            ?>

            <div>

                <?php echo sprintf(__("You don't have any forms. Let's go %s create one %s!", 'gravityforms'), '<a href="admin.php?page=gf_new_form">', '</a>'); ?>

            </div>

            <?php

        }



        if(GFCommon::current_user_can_any("gravityforms_view_updates") && (!function_exists("is_multisite") || !is_multisite() || is_super_admin())){

            //displaying update message if there is an update and user has permission

            self::dashboard_update_message();

        }

    }



    public static function dashboard_update_message(){

        $version_info = GFCommon::get_version_info();



        //don't display a message if use has dismissed the message for this version

        $ary_dismissed = get_option("gf_dismissed_upgrades");



        $is_dismissed = !empty($ary_dismissed) && in_array($version_info["version"], $ary_dismissed);



        if($is_dismissed)

            return;



        if(version_compare(GFCommon::$version, $version_info["version"], '<')) {

            $auto_upgrade = "";



            /*if($version_info["is_valid_key"]){

                $plugin_file = "gravityforms/gravityforms.php";

                $upgrade_url = wp_nonce_url('update.php?action=upgrade-plugin&amp;plugin=' . urlencode($plugin_file), 'upgrade-plugin_' . $plugin_file);

                $auto_upgrade = sprintf(__(" or %sUpgrade Automatically%s", "gravityforms"), "<a href='{$upgrade_url}'>", "</a>");

            }*/

            $message = sprintf(__("There is an update available for Gravity Forms. %sView Details%s %s", "gravityforms"), "<a href='admin.php?page=gf_update'>", "</a>", $auto_upgrade);

            ?>

            <div class='updated' style='padding:15px; position:relative;' id='gf_dashboard_message'><?php echo $message ?>

                <a href="javascript:void(0);" onclick="AlienDismissUpgrade();" style='float:right;'><?php _e("Dismiss", "gravityforms") ?></a>

            </div>

            <script type="text/javascript">

                function AlienDismissUpgrade(){

                    jQuery("#gf_dashboard_message").slideUp();

                    jQuery.post(ajaxurl, {action:"rg_dismiss_upgrade", version:"<?php echo $version_info["version"] ?>"});

                }

            </script>

            <?php

        }

    }



    public static function dashboard_dismiss_upgrade(){

        $ary = get_option("gf_dismissed_upgrades");

        if(!is_array($ary))

            $ary = array();



        $ary[] = $_POST["version"];

        update_option("gf_dismissed_upgrades", $ary);

    }





//------------------------------------------------------

//--------------- ALL OTHER PAGES ---------------------



    public static function get_form($form_id, $display_title=true, $display_description=true, $force_display=false, $field_values=null, $ajax=false, $tabindex = 1){

        require_once(GFCommon::get_base_path() . "/form_display.php");

        return GFFormDisplay::get_form($form_id, $display_title, $display_description, $force_display, $field_values, $ajax, $tabindex);

    }



    public static function new_form(){

        self::forms_page(0);

    }



    public static function enqueue_scripts(){

        require_once(GFCommon::get_base_path() . "/form_display.php");

        GFFormDisplay::enqueue_scripts();

    }



    public static function print_form_scripts($form, $ajax){

        require_once(GFCommon::get_base_path() . "/form_display.php");

        GFFormDisplay::print_form_scripts($form, $ajax);

    }



    public static function forms_page($form_id){

        require_once(GFCommon::get_base_path() . "/form_detail.php");

        GFFormDetail::forms_page($form_id);

    }



    public static function settings_page(){

        require_once(GFCommon::get_base_path() . "/settings.php");

        GFSettings::settings_page();

    }



    public static function add_settings_page($name, $handle, $icon_path=""){

        require_once(GFCommon::get_base_path() . "/settings.php");

        GFSettings::add_settings_page($name, $handle, $icon_path);

    }



    public static function help_page(){

        require_once(GFCommon::get_base_path() . "/help.php");

        GFHelp::help_page();

    }



    public static function export_page(){

        require_once(GFCommon::get_base_path() . "/export.php");

        GFExport::export_page();

    }



    public static function update_page(){

        require_once(GFCommon::get_base_path() . "/update.php");

        GFUpdate::update_page();

    }



    public static function addons_page(){



        wp_print_scripts("thickbox");

        wp_print_styles(array("thickbox"));



        $plugins = get_plugins();

        $installed_plugins = array();

        foreach($plugins as $key => $plugin){

            $is_active = is_plugin_active($key);

            $installed_plugin = array("plugin" => $key, "name" => $plugin["Name"], "is_active"=>$is_active);

            $installed_plugin["activation_url"] = $is_active ? "" : wp_nonce_url("plugins.php?action=activate&plugin={$key}", "activate-plugin_{$key}");

            $installed_plugin["deactivation_url"] = !$is_active ? "" : wp_nonce_url("plugins.php?action=deactivate&plugin={$key}", "deactivate-plugin_{$key}");



            $installed_plugins[] = $installed_plugin;

        }



        $nonces = self::get_addon_nonces();



        $body = array("plugins" => urlencode(serialize($installed_plugins)), "nonces" => urlencode(serialize($nonces)), "key" => GFCommon::get_key());

        $options = array('body' => $body, 'headers' => array('Referer' => get_bloginfo("url")));



        $request_url = GRAVITY_MANAGER_URL . "/api.php?op=plugin_browser&{$_SERVER["QUERY_STRING"]}";

        $raw_response = wp_remote_post($request_url, $options);



         if ( is_wp_error( $raw_response ) || $raw_response['response']['code'] != 200){

            echo "<div class='error' style='margin-top:50px; padding:20px;'>" . __("Add-On browser is currently unavailable. Please try again later.", "gravityforms") . "</div>";

         }

         else{

            echo GFCommon::get_remote_message();

            echo $raw_response["body"];

         }

    }



    public static function get_addon_info($api, $action, $args){

        if($action == "plugin_information" && empty($api) && !rgempty("rg", $_GET)){

            $request_url = GRAVITY_MANAGER_URL . "/api.php?op=get_plugin&slug={$args->slug}";

            $raw_response = wp_remote_post($request_url);



            if ( is_wp_error( $raw_response ) || $raw_response['response']['code'] != 200)

                return false;



            $plugin = unserialize($raw_response["body"]);



            $api = new stdClass();

            $api->name = $plugin["title"];

            $api->version = $plugin["version"];

            $api->download_link = $plugin["download_url"];

        }

        return $api;

    }



    public static function get_addon_nonces(){

        $request_url = GRAVITY_MANAGER_URL . "/api.php?op=get_plugins";

        $raw_response = wp_remote_get($request_url);



        if ( is_wp_error( $raw_response ) || $raw_response['response']['code'] != 200)

            return false;



        $addons = unserialize($raw_response["body"]);

        $nonces = array();

        foreach($addons as $addon){

            $nonces[$addon["key"]] = wp_create_nonce("install-plugin_{$addon["key"]}");

        }



        return $nonces;

    }



    public static function start_export(){

        require_once(GFCommon::get_base_path() . "/export.php");

        GFExport::start_export();

    }



    public static function get_post_category_values(){

        require_once(GFCommon::get_base_path() . "/form_detail.php");

        GFFormDetail::get_post_category_values();

    }



    public static function get_notification_post_category_values(){

        require_once(GFCommon::get_base_path() . "/notification.php");

        GFNotification::get_post_category_values();

    }



    public static function all_leads_page(){



        //displaying lead detail page if lead id is in the query string

        if(rgget('lid') || !rgblank(rgget('pos')))

        {

            require_once(GFCommon::get_base_path() . "/entry_detail.php");

            GFEntryDetail::lead_detail_page();

        }

        else{

            require_once(GFCommon::get_base_path() . "/entry_list.php");

            GFEntryList::all_leads_page();

        }

    }



    public static function form_list_page(){

        require_once(GFCommon::get_base_path() . "/form_list.php");

        GFFormList::form_list_page();

    }



    public static function forms(){

        if(!GFCommon::ensure_wp_version())

            return;



        $id = RGForms::get("id");

        $view = RGForms::get("view");



        if($view == "entries"){

            require_once(GFCommon::get_base_path() . "/entry_list.php");

            GFEntryList::leads_page($id);

        }

        else if($view == "entry"){

            require_once(GFCommon::get_base_path() . "/entry_detail.php");

            GFEntryDetail::lead_detail_page();

        }

        else if($view == "notification"){

            require_once(GFCommon::get_base_path() . "/notification.php");

            GFNotification::notification_page($id);

        }

        else if(is_numeric($id)){

            self::forms_page($id);

        }

        else{

            self::form_list_page();

        }



    }



    public static function get($name, $array=null){

        if(!$array)

            $array = $_GET;



        if(isset($array[$name]))

            return $array[$name];



        return "";

    }



    public static function post($name){

        if(isset($_POST[$name]))

            return $_POST[$name];



        return "";

    }



    // AJAX Function

    public static function resend_notifications(){



        check_admin_referer('gf_resend_notifications', 'gf_resend_notifications');



        $leads = rgpost('leadIds'); // may be a single ID or an array of IDs

        $leads = !is_array($leads) ? array($leads) : $leads;



        $form_id = rgpost('formId');

        $form = apply_filters("gform_before_resend_notifications_{$form_id}", apply_filters('gform_before_resend_notifications', RGFormsModel::get_form_meta($form_id), $leads), $leads);



        if(empty($leads) || empty($form)) {

            _e("There was an error while resending the notifications.", "gravityforms");

            die();

        };



        $send_admin = rgpost('sendAdmin');

        $send_user = rgpost('sendUser');

        $override_options = array();

        $validation_errors = array();



        if(rgpost('sendTo')) {



            if(rgpost('sendTo') && GFCommon::is_invalid_or_empty_email(rgpost('sendTo')))

                $validation_errors[] = __("The <strong>Send To</strong> email address provided is not valid.", "gravityforms");



            if(!empty($validation_errors)) {

                echo count($validation_errors) > 1 ? '<ul><li>' . implode('</li><li>', $validation_errors) . '</li></ul>' : $validation_errors[0];

                die();

            }



            $override_options['to'] = rgpost('sendTo');

            $override_options['bcc'] = ''; // overwrite bcc settings



        }



        foreach($leads as $lead_id){



            $lead = RGFormsModel::get_lead($lead_id);



            if($send_admin)

                GFCommon::send_admin_notification($form, $lead, $override_options);



            if($send_user)

                GFCommon::send_user_notification($form, $lead, $override_options);



        }



        die();



    }



//-------------------------------------------------

//----------- AJAX CALLS --------------------------

    //captcha image



    public static function captcha_image(){

        $field = array("simpleCaptchaSize" => $_GET["size"], "simpleCaptchaFontColor"=> $_GET["fg"], "simpleCaptchaBackgroundColor"=>$_GET["bg"]);

        if($_GET["type"] == "math")

            $captcha = GFCommon::get_math_captcha($field, $_GET["pos"]);

        else

            $captcha = GFCommon::get_captcha($field);



        @ini_set('memory_limit', '256M');

        $image = imagecreatefrompng($captcha["path"]);



        include_once( ABSPATH . 'wp-admin/includes/image-edit.php' );

        wp_stream_image($image, "image/png", 0);

        imagedestroy($image);

        die();

    }



    //entry list

    public static function update_form_active(){

        check_ajax_referer('rg_update_form_active','rg_update_form_active');

        RGFormsModel::update_form_active($_POST["form_id"], $_POST["is_active"]);

    }

    public static function update_lead_property(){

        check_ajax_referer('rg_update_lead_property','rg_update_lead_property');

        RGFormsModel::update_lead_property($_POST["lead_id"], $_POST["name"], $_POST["value"]);

    }



    public static function update_lead_status(){

        check_ajax_referer('gf_delete_entry');

        $status = rgpost("status");

        $lead_id = rgpost("entry");



        switch($status){

            case "unspam" :

                //TODO: call akismet and set entry as not spam.

                RGFormsModel::update_lead_property($lead_id, "status", "active");

            break;



            case "delete" :

                RGFormsModel::delete_lead($lead_id);

            break;



            default :

                RGFormsModel::update_lead_property($lead_id, "status", $status);

            break;

        }

        header("Content-Type: text/xml");

        echo "<?xml version='1.0' standalone='yes'?><wp_ajax></wp_ajax>";

        exit();



    }



    //settings

    public static function upgrade_license(){

        require_once(GFCommon::get_base_path() . "/settings.php");

        GFSettings::upgrade_license();

    }



    //form detail

    public static function save_form(){

        require_once(GFCommon::get_base_path() . "/form_detail.php");

        GFFormDetail::save_form();

    }

    public static function add_field(){

        require_once(GFCommon::get_base_path() . "/form_detail.php");

        GFFormDetail::add_field();

    }

    public static function duplicate_field(){

        require_once(GFCommon::get_base_path() . "/form_detail.php");

        GFFormDetail::duplicate_field();

    }

    public static function delete_field(){

        require_once(GFCommon::get_base_path() . "/form_detail.php");

        GFFormDetail::delete_field();

    }

    public static function change_input_type(){

        require_once(GFCommon::get_base_path() . "/form_detail.php");

        GFFormDetail::change_input_type();

    }

    public static function delete_custom_choice(){

        require_once(GFCommon::get_base_path() . "/form_detail.php");

        GFFormDetail::delete_custom_choice();

    }

    public static function save_custom_choice(){

        require_once(GFCommon::get_base_path() . "/form_detail.php");

        GFFormDetail::save_custom_choice();

    }



    //entry detail

    public static function delete_file(){

        check_ajax_referer("rg_delete_file", "rg_delete_file");

        $lead_id =  intval($_POST["lead_id"]);

        $field_id =  intval($_POST["field_id"]);



        RGFormsModel::delete_file($lead_id, $field_id);

        die("EndDeleteFile($field_id);");

    }



    //export

    public static function select_export_form(){

        check_ajax_referer("rg_select_export_form", "rg_select_export_form");

        $form_id =  intval($_POST["form_id"]);

        $form = RGFormsModel::get_form_meta($form_id);

        $fields = array();



        $form = GFExport::add_default_export_fields($form);



        if(is_array($form["fields"])){

            foreach($form["fields"] as $field){

                if(is_array(rgar($field,"inputs"))){

                    foreach($field["inputs"] as $input)

                        $fields[] =  array($input["id"], GFCommon::get_label($field, $input["id"]));

                }

                else if(!rgar($field,"displayOnly")){

                    $fields[] =  array($field["id"], GFCommon::get_label($field));

                }

            }

        }

        $field_json = GFCommon::json_encode($fields);



        die("EndSelectExportForm($field_json);");

    }



    public static function top_toolbar(){



        $forms = RGFormsModel::get_forms(null, "title");

        $id = rgempty("id", $_GET) ? count($forms) > 0 ? $forms[0]->id : "0" : rgget("id");



        ?>



        <script type="text/javascript">

            function GF_ReplaceQuery(key, newValue){

                var new_query = "";

                var query = document.location.search.substring(1);

                var ary = query.split("&");

                var has_key=false;

                for (i=0; i < ary.length; i++) {

                    var key_value = ary[i].split("=");



                    if (key_value[0] == key){

                        new_query += key + "=" + newValue + "&";

                        has_key = true;

                    }

                    else if(key_value[0] != "display_settings"){

                        new_query += key_value[0] + "=" + key_value[1] + "&";

                    }

                }



                if(new_query.length > 0)

                    new_query = new_query.substring(0, new_query.length-1);



                if(!has_key)

                    new_query += new_query.length > 0 ? "&" + key + "=" + newValue : "?" + key + "=" + newValue;



                return new_query;

            }



            function GF_RemoveQuery(key, query){

                var new_query = "";

                if (query == "")

                {

                	query = document.location.search.substring(1);

				}

                var ary = query.split("&");

                for (i=0; i < ary.length; i++) {

                    var key_value = ary[i].split("=");



                    if (key_value[0] != key){

                        new_query += key_value[0] + "=" + key_value[1] + "&";

                    }

                }



                if(new_query.length > 0)

                    new_query = new_query.substring(0, new_query.length-1);



                return new_query;

            }



            function GF_SwitchForm(id){

                if(id.length > 0){

                    query = GF_ReplaceQuery("id", id);

                    //remove paging from querystring when changing forms

                    new_query = GF_RemoveQuery("paged", query);

                   	new_query = new_query.replace("gf_new_form", "gf_edit_forms");

                    document.location = "?" + new_query;

                }

            }



            function ToggleFormSettings(){

                FieldClick(jQuery('#gform_heading')[0]);

            }



            jQuery(document).ready(function(){

                if(document.location.search.indexOf("display_settings") > 0)

                    ToggleFormSettings()



                jQuery('a.gf_toolbar_disabled').click(function(event){

                    event.preventDefault();

                });

            });



        </script>



        <div id="gf_form_toolbar">

            <ul id="gf_form_toolbar_links">



                <?php

                if(GFCommon::current_user_can_any("gravityforms_edit_forms")){

                    ?>

                    <li class="gf_form_toolbar_editor"><a href="?page=gf_edit_forms&id=<?php echo $id ?>"  <?php echo self::toolbar_class("editor"); ?>><?php _e("Form Editor", "gravityforms"); ?></a></li>

                    <li class="gf_form_toolbar_settings"><a href="javascript: if(jQuery('#gform_heading.selectable').length > 0){FieldClick(jQuery('#gform_heading')[0]);} else{document.location = '?page=gf_edit_forms&id=<?php echo $id ?>&display_settings';}" <?php echo self::toolbar_class("settings"); ?>><?php _e("Form Settings", "gravityforms"); ?></a></li>

                    <li class="gf_form_toolbar_notifications"><a href="?page=gf_edit_forms&view=notification&id=<?php echo $id ?>"  <?php echo self::toolbar_class("notifications"); ?>><?php _e("Notifications", "gravityforms"); ?></a></li>

                    <?php

                }



                if(GFCommon::current_user_can_any(array('gravityforms_view_entries','gravityforms_edit_entries','gravityforms_delete_entries'))){

                    ?>

                    <li class="gf_form_toolbar_entries"><a href="?page=gf_entries&id=<?php echo $id ?>"  <?php echo self::toolbar_class("entries"); ?>>

                        <?php echo RG_CURRENT_VIEW != 'entry' ? __("Entries", "gravityforms") : __("Entries", "gravityforms"); ?>

                    </a></li>

                    <?php

                }



                if(GFCommon::current_user_can_any(array("gravityforms_edit_forms", "gravityforms_create_form", "gravityforms_preview_forms"))){

                    ?>

                    <li class="gf_form_toolbar_preview"><a href="<?php echo site_url() ?>/?gf_page=preview&id=<?php echo $id ?>" target="_blank" <?php echo self::toolbar_class("preview"); ?>><?php _e("Preview", "gravityforms"); ?></a></li>

                    <?php

                }

                ?>



                <li class="gf_form_switcher">

                    <label for="export_form"><?php _e("Select A Form", "gravityforms") ?></label>



                    <?php

                    if(RG_CURRENT_VIEW != 'entry'){ ?>

                        <select name="form_switcher" id="form_switcher" onchange="GF_SwitchForm(jQuery(this).val());">

                            <option value=""><?php _e("Switch Form", "gravityforms") ?></option>

                            <?php

                            foreach($forms as $form_info){

                                ?>

                                <option value="<?php echo $form_info->id ?>"><?php echo $form_info->title ?></option>

                                <?php

                            }

                            ?>

                        </select>

                    <?php

                    } // end view check ?>



                </li>

            </ul>

        </div>





        <?php



    }



    private static function toolbar_class($item){



        switch($item){



            case "editor":

                if(in_array(rgget("page"), array("gf_edit_forms", "gf_new_form")) && rgempty("view", $_GET))

                    return "class='gf_toolbar_active'";

            break;



            case "notifications" :

                if(rgget("page") == "gf_new_form")

                    return "class='gf_toolbar_disabled'";

                else if(rgget("page") == "gf_edit_forms" && rgget("view") == "notification")

                    return "class='gf_toolbar_active'";



            break;



            case "entries" :

                if(rgget("page") == "gf_new_form")

                    return "class='gf_toolbar_disabled'";

                else if(rgget("page") == "gf_entries")

                    return "class='gf_toolbar_active'";



            break;



            case "preview" :

                if(rgget("page") == "gf_new_form")

                    return "class='gf_toolbar_disabled'";



            break;

        }



        return "";

    }

}



//Main function call. Should be used to insert a Gravity Form from code.

function gravity_form($id, $display_title=true, $display_description=true, $display_inactive=false, $field_values=null, $ajax=false, $tabindex = 1){

    echo RGForms::get_form($id, $display_title, $display_description, $display_inactive, $field_values, $ajax, $tabindex);

}



//Enqueues the appropriate scripts for the specified form

function gravity_form_enqueue_scripts($form_id, $is_ajax=false){

    if(!is_admin()){

        require_once(GFCommon::get_base_path() . "/form_display.php");

        $form = RGFormsModel::get_form_meta($form_id);

        GFFormDisplay::enqueue_form_scripts($form, $is_ajax);

    }

}



if(!function_exists("rgget")){

function rgget($name, $array=null){

    if(!isset($array))

        $array = $_GET;



    if(isset($array[$name]))

        return $array[$name];



    return "";

}

}



if(!function_exists("rgpost")){

function rgpost($name, $do_stripslashes=true){

    if(isset($_POST[$name]))

        return $do_stripslashes ? stripslashes_deep($_POST[$name]) : $_POST[$name];



    return "";

}

}



if(!function_exists("rgar")){

function rgar($array, $name){

    if(isset($array[$name]))

        return $array[$name];



    return '';

}

}





if(!function_exists("rgars")){

function rgars($array, $name){

    $names = explode("/", $name);

    $val = $array;

    foreach($names as $current_name){

        $val = rgar($val, $current_name);

    }

    return $val;

}

}



if(!function_exists("rgempty")){

function rgempty($name, $array = null){

    if(!$array)

        $array = $_POST;



    $val = rgget($name, $array);

    return empty($val);

}

}





if(!function_exists("rgblank")){

function rgblank($text){

    return empty($text) && strval($text) != "0";

}

}





if(!function_exists("rgobj")){

function rgobj($obj, $name){

    if(isset($obj->$name))

        return $obj->$name;



    return '';

}

}

if(!function_exists("rgexplode")){

function rgexplode($sep, $string, $count){

    $ary = explode($sep, $string);

    while(count($ary) < $count)

        $ary[] = "";



    return $ary;

}

}



?>