Changeset 1573315

Timestamp:

01/12/2017 01:21:12 PM (9 years ago)

Author:

WebTechGlobal

Message:

Update for WordPress 4.7.1

Location:

csv-2-post

Files:

• tags/8.1.37/Thumbs.db (deleted)
• trunk (modified) (1 prop)
• trunk/arrays (modified) (1 prop)
• trunk/classes (modified) (1 prop)
• trunk/classes/class-csv2post.php (modified) (1 diff)
• trunk/classes/class-forms.php (modified) (2 diffs)
• trunk/classes/class-install.php (modified) (5 diffs)
• trunk/css (modified) (1 prop)
• trunk/css/jqueryui (modified) (1 prop)
• trunk/csv-2-post.php (modified) (2 diffs)
• trunk/functions (modified) (1 prop)
• trunk/images (modified) (1 prop)
• trunk/images/menus (modified) (1 prop)
• trunk/images/scriptgraphics (modified) (1 prop)
• trunk/images/themeforest-light-background.png (added)
• trunk/inc (modified) (1 prop)
• trunk/inc/fields (modified) (1 prop)
• trunk/js (modified) (1 prop)
• trunk/js/datetimepicker (modified) (1 prop)
• trunk/languages (modified) (1 prop)
• trunk/posttypes (modified) (1 prop)
• trunk/readme.txt (modified) (2 diffs)
• trunk/samples (modified) (1 prop)
• trunk/samples/imagegroups (modified) (1 prop)
• trunk/views (modified) (1 prop)

csv-2-post/trunk/classes/class-csv2post.php

@@ -217 +217 @@
             add_action( "load-{$page_hook}", array( $this, 'load_admin_page' ) );
         }
-        
-        // TODO 1 Task: Temporary function while the 
-        // update system is not in use
-        self::projectstable_add_status_column();
-    }
-    
-    /**
-    * Add "status" column to 
-    * 
-    * @author Ryan R. Bayne
-    * @package WebTechGlobal WordPress Plugins
-    * @version 1.0
-    */
-    public function projectstable_add_status_column() {
-        global $charset_collate, $wpdb;
-        
-        require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
-        
-        // having to remove tabs to make the table alter work, strange!
-        $sql_create_table = "CREATE TABLE {$wpdb->c2pprojects} (
-projectid bigint(5) unsigned NOT NULL AUTO_INCREMENT,
-projectname varchar(45) DEFAULT NULL,
-status tinyint(1) unsigned DEFAULT 1,
-timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-source1 int(5) unsigned DEFAULT 0,
-source2 int(5) unsigned DEFAULT 0,
-source3 int(5) unsigned DEFAULT 0,
-source4 int(5) unsigned DEFAULT 0,
-source5 int(5) unsigned DEFAULT 0,
-lockcontent tinyint(1) unsigned DEFAULT 0,
-lockmeta tinyint(1) unsigned DEFAULT '0',
-datatreatment VARCHAR(50) DEFAULT 'single',
-projectsettings longtext DEFAULT NULL,
-settingschange DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
-PRIMARY KEY projectid $charset_collate; ";
-
-        dbDelta( $sql_create_table );             
-    }
-        
+    }
+    
     /**
      * Render the view that has been initialized in load_admin_page() (called by WordPress when the actual page content is needed)

csv-2-post/trunk/classes/class-forms.php

@@ -595 +595 @@
     * @package CSV 2 POST
     * @since 0.0.1
-    * @version 1.0
+    * @version 1.1
     */
     public function apply_form_security() {
@@ -601 +601 @@
 
         # if form ID value does not exist FAIL - this is used to access form registration data
-        if( !isset( $_POST['csv2post_form_formid'] ) ) { 
+        if( !isset( $_POST['csv2post_form_formid'] ) ) 
+        { 
             return false;
         }
-                
-        # possible move nonce check to here, where it is may be better as it is before even this but not 100% sure
-        
-        # detect extra fields (not registered), unless form is not registered at all then we do not do this
-        
+        
+        if( !isset( $_POST['csv2post_form_name'] ) )
+        {
+            return false;
+        }
+              
+        if( !isset( $_POST['_wpnonce'] ) ) 
+        {
+            return false;
+        }
+        
+        $nonce_result = wp_verify_nonce( $_POST['_wpnonce'], $_POST['csv2post_form_name'] );
+        if( !$nonce_result )
+        {
+            return false;
+        }
+ 
         # check capability and ensure user submitting form still has permission (what if permission is revoked after form loads?)
             //  task has been created for this, form registation needs to begin earlier, before actual inputs so that

csv-2-post/trunk/classes/class-install.php

@@ -79 +79 @@
     * @author Ryan R. Bayne
     * @package CSV 2 POST
-    * @version 1.4
+    * @version 1.6
     * 
     * @todo put all tables into their own function as done with log table
@@ -107 +107 @@
 projectsettings longtext DEFAULT NULL,
 settingschange DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
-UNIQUE KEY  (projectid)
+UNIQUE KEY projectid (projectid)
  ) $charset_collate; ";
         dbDelta( $sql_create_table );
@@ -125 +125 @@
 
         // c2psources
-        $sql_create_table = "CREATE TABLE {$wpdb->c2psources} (sourceid bigint(20) unsigned NOT NULL AUTO_INCREMENT,projectid int(5) unsigned DEFAULT 0,name varchar(250) DEFAULT NULL,sourcetype varchar(45) DEFAULT NULL,progress int(12) DEFAULT 0,rows int(12) DEFAULT 0,tablename varchar (50) NOT NULL DEFAULT '0',filesarray text DEFAULT NULL,timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,path varchar(500) DEFAULT NULL,directory varchar(500) DEFAULT NULL,idcolumn varchar(50) DEFAULT NULL,monitorfilechange tinyint(1) unsigned DEFAULT 1, changecounter int(8) unsigned DEFAULT '0',datatreatment varchar (50) NOT NULL DEFAULT 'single',rules longtext DEFAULT NULL,thesep varchar(1) DEFAULT NULL,theconfig text DEFAULT NULL,PRIMARY KEY (sourceid)) $charset_collate; ";
+        $sql_create_table = "CREATE TABLE " . $wpdb->prefix . "c2psources (
+sourceid bigint(20) unsigned NOT NULL AUTO_INCREMENT,
+projectid int(5) unsigned DEFAULT 0,
+name varchar(250) DEFAULT NULL,
+sourcetype varchar(45) DEFAULT NULL,
+progress int(12) DEFAULT 0,
+rows int(12) DEFAULT 0,
+tablename varchar (50) NOT NULL DEFAULT '0',
+filesarray text DEFAULT NULL,
+timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+path varchar(500) DEFAULT NULL,
+directory varchar(500) DEFAULT NULL,
+idcolumn varchar(50) DEFAULT NULL,
+monitorfilechange tinyint(1) unsigned DEFAULT 1,
+changecounter int(8) unsigned DEFAULT '0',
+datatreatment varchar (50) NOT NULL DEFAULT 'single',
+rules longtext DEFAULT NULL,
+thesep varchar(1) DEFAULT NULL,
+theconfig text DEFAULT NULL,PRIMARY KEY (sourceid)
+) $charset_collate; ";
         dbDelta( $sql_create_table );  
    
@@ -298 +317 @@
     * @package WebTechGlobal WordPress Plugins
     * @since 0.0.9
-    * @version 1.2
+    * @version 1.3
     */
     public function webtechglobal_schedule() {
@@ -319 +338 @@
 delay int(4) NOT NULL DEFAULT 3600,
 firsttime timestamp NULL,
-UNIQUE KEY (rowid) ) $charset_collate; ";
+UNIQUE KEY rowid (rowid) ) $charset_collate; ";
 
 /*

csv-2-post/trunk/csv-2-post.php

@@ -2 +2 @@
 /*
 Plugin Name: CSV 2 POST
-Version: 8.2.18
+Version: 8.2.19
 Plugin URI: http://www.webtechglobal.co.uk/csv-2-post
 Description: CSV 2 POST data importer for WordPress by Ryan R. Bayne.
 Author: WebTechGlobal
 Author URI: http://www.webtechglobal.co.uk/
-Last Updated: August 2016
+Last Updated: January 2017
 Text Domain: csv2post
 Domain Path: /languages
@@ -39 +39 @@
               
 // define constants                              
-if(!defined( "CSV2POST_VERSION") ){define( "CSV2POST_VERSION", '8.2.18' );}
+if(!defined( "CSV2POST_VERSION") ){define( "CSV2POST_VERSION", '8.2.19' );}
 if(!defined( "CSV2POST_WPVERSIONMINIMUM") ){define( "CSV2POST_WPVERSIONMINIMUM", '4.2.0' );}// The minimum php version that will allow the plugin to work
 if(!defined( "CSV2POST_PHPVERSIONMINIMUM") ){define( "CSV2POST_PHPVERSIONMINIMUM", '5.4.0' );}// The minimum php version that will allow the plugin to work 

csv-2-post/trunk/readme.txt

@@ -6 +6 @@
 Tags: CSV 2 POST,csv2post, WordPress Data Importer, Autoblog, Autoblogger, CSV Import, Data Importer
 Requires at least: 4.2.0
-Tested up to: 4.5.3
+Tested up to: 4.7.1
 Stable tag: trunk
 
@@ -128 +128 @@
 
 == Changelog == 
+= 8.2.19 =
+* Feature Changes
+    * None
+* Technical Changes
+    * Correction made for installation of sources database table.
+    * Removed projectstable_add_status_column() which updated very old versions but was being called too frequently.
+    
 = 8.2.18 =
 * Feature Changes