Yasr – Yet Another Stars Rating - Version 2.1.1

Version Description

  • FIXED: on new installations, tables yasr_multi_set and yasr_multi_set_fields didn't get created
Download this release

Release Info

Developer Dudo
Plugin Icon 128x128 Yasr – Yet Another Stars Rating
Version 2.1.1
Comparing to
See all releases

Code changes from version 2.1.0 to 2.1.1

Files changed (4) hide show
  1. lib/admin/yasr-update-functions.php +12 -1
  2. lib/yasr-db-functions.php +2 -2
  3. readme.txt +4 -2
  4. yet-another-stars-rating.php +2 -2
lib/admin/yasr-update-functions.php CHANGED
@@ -176,8 +176,19 @@ function yasr_update_version() {
176
  }
177
  }
178
 
179
- /****** End backward compatibility functions ******/
 
 
 
 
 
 
 
 
 
 
180
 
 
181
  if ($yasr_version_installed != YASR_VERSION_NUM) {
182
  update_option('yasr-version', YASR_VERSION_NUM);
183
  }
176
  }
177
  }
178
 
179
+ //remove begin 2021
180
+ //this fix a bug of table not created on version 2.0.9 and 2.1.0
181
+ if (version_compare($yasr_version_installed,'2.1.1') === -1) {
182
+ $multi_set_name_exists = $wpdb->get_var("SELECT COUNT(1) FROM ". YASR_MULTI_SET_NAME_TABLE);
183
+
184
+ $multi_set_field_exists = $wpdb->get_var("SELECT COUNT(1) FROM ". YASR_MULTI_SET_FIELDS_TABLE);
185
+
186
+ if($multi_set_name_exists === NULL || $multi_set_field_exists === NULL) {
187
+ yasr_create_tables();
188
+ }
189
+ }
190
 
191
+ /****** End backward compatibility functions ******/
192
  if ($yasr_version_installed != YASR_VERSION_NUM) {
193
  update_option('yasr-version', YASR_VERSION_NUM);
194
  }
lib/yasr-db-functions.php CHANGED
@@ -107,14 +107,14 @@ function yasr_create_tables () {
107
  //but not the yasr tables.
108
 
109
  $sql_yasr_multi_set_table = "CREATE TABLE $yasr_multi_set_table (
110
- set_id int(2) NOT NULL AUTO_INCREMENT,,
111
  set_name varchar(64) COLLATE utf8_unicode_ci NOT NULL,
112
  UNIQUE KEY set_id (set_id),
113
  UNIQUE KEY set_name (set_name)
114
  ) COLLATE 'utf8_unicode_ci';";
115
 
116
  $sql_yasr_multi_set_fields = "CREATE TABLE $yasr_multi_set_fields (
117
- id bigint(20) NOT NULL AUTO_INCREMENT,,
118
  parent_set_id int(2) NOT NULL,
119
  field_name varchar(40) COLLATE utf8_unicode_ci NOT NULL,
120
  field_id int(2) NOT NULL,
107
  //but not the yasr tables.
108
 
109
  $sql_yasr_multi_set_table = "CREATE TABLE $yasr_multi_set_table (
110
+ set_id int(2) NOT NULL AUTO_INCREMENT,
111
  set_name varchar(64) COLLATE utf8_unicode_ci NOT NULL,
112
  UNIQUE KEY set_id (set_id),
113
  UNIQUE KEY set_name (set_name)
114
  ) COLLATE 'utf8_unicode_ci';";
115
 
116
  $sql_yasr_multi_set_fields = "CREATE TABLE $yasr_multi_set_fields (
117
+ id bigint(20) NOT NULL AUTO_INCREMENT,
118
  parent_set_id int(2) NOT NULL,
119
  field_name varchar(40) COLLATE utf8_unicode_ci NOT NULL,
120
  field_id int(2) NOT NULL,
readme.txt CHANGED
@@ -5,7 +5,7 @@ Requires at least: 4.3.0
5
  Contributors: Dudo
6
  Tested up to: 5.4
7
  Requires PHP: 5.3
8
- Stable tag: 2.1.0
9
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
10
 
11
  Boost the way people interact with your website, e-commerce or blog with an easy and intuitive WordPress rating system!
@@ -125,13 +125,15 @@ If doesn't, it's suggested to ask in a SEO oriented forum.
125
 
126
  The full changelog can be found in the plugin's directory. Recent entries:
127
 
 
 
 
128
  = 2.1.0 =
129
  * TWEAKED: This is the second important release after 2.0.9. YASR Database structure is now more efficent if you're
130
  using MultiSets. If everything works, it is possible to remove the table _yasr_multi_values.
131
  * TWEAKED: "logs" page is now called "stats"
132
  * NEW FEATURE: inside the "stats" page is now possible to see, and delete, stats for yasr_visitor_multiset shortcode
133
  * TWEAKED: Code cleanup
134
- **BACKUP YOUR DATABASE BEFORE UPDATING**
135
 
136
  = 2.0.9 =
137
  * TWEAKED: This is the first of two important releases for YASR. Some changes in the database has been done.
5
  Contributors: Dudo
6
  Tested up to: 5.4
7
  Requires PHP: 5.3
8
+ Stable tag: 2.1.1
9
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
10
 
11
  Boost the way people interact with your website, e-commerce or blog with an easy and intuitive WordPress rating system!
125
 
126
  The full changelog can be found in the plugin's directory. Recent entries:
127
 
128
+ = 2.1.1 =
129
+ * FIXED: on new installations, tables yasr_multi_set and yasr_multi_set_fields didn't get created
130
+
131
  = 2.1.0 =
132
  * TWEAKED: This is the second important release after 2.0.9. YASR Database structure is now more efficent if you're
133
  using MultiSets. If everything works, it is possible to remove the table _yasr_multi_values.
134
  * TWEAKED: "logs" page is now called "stats"
135
  * NEW FEATURE: inside the "stats" page is now possible to see, and delete, stats for yasr_visitor_multiset shortcode
136
  * TWEAKED: Code cleanup
 
137
 
138
  = 2.0.9 =
139
  * TWEAKED: This is the first of two important releases for YASR. Some changes in the database has been done.
yet-another-stars-rating.php CHANGED
@@ -4,7 +4,7 @@
4
  * Plugin Name: Yet Another Stars Rating
5
  * Plugin URI: http://wordpress.org/plugins/yet-another-stars-rating/
6
  * Description: Yasr - Yet Another Stars Rating is a powerful way to add SEO-friendly user-generated reviews and testimonials to your website posts, pages and CPT, without affecting its speed.
7
- * Version: 2.1.0
8
  * Author: Dario Curvino
9
  * Author URI: https://dariocurvino.it/
10
  * Text Domain: yet-another-stars-rating
@@ -76,7 +76,7 @@ if ( !function_exists( 'yasr_fs' ) ) {
76
  yasr_fs();
77
  // Signal that SDK was initiated.
78
  do_action( 'yasr_fs_loaded' );
79
- define( 'YASR_VERSION_NUM', '2.1.0' );
80
  //Plugin relative path
81
  define( "YASR_ABSOLUTE_PATH", dirname( __FILE__ ) );
82
  //Plugin RELATIVE PATH without slashes (just the directory's name)
4
  * Plugin Name: Yet Another Stars Rating
5
  * Plugin URI: http://wordpress.org/plugins/yet-another-stars-rating/
6
  * Description: Yasr - Yet Another Stars Rating is a powerful way to add SEO-friendly user-generated reviews and testimonials to your website posts, pages and CPT, without affecting its speed.
7
+ * Version: 2.1.1
8
  * Author: Dario Curvino
9
  * Author URI: https://dariocurvino.it/
10
  * Text Domain: yet-another-stars-rating
76
  yasr_fs();
77
  // Signal that SDK was initiated.
78
  do_action( 'yasr_fs_loaded' );
79
+ define( 'YASR_VERSION_NUM', '2.1.1' );
80
  //Plugin relative path
81
  define( "YASR_ABSOLUTE_PATH", dirname( __FILE__ ) );
82
  //Plugin RELATIVE PATH without slashes (just the directory's name)