List category posts - Version 0.77

Version Description

  • Improvements in testing by @zymeth25.
  • Removed hardcoded wp_ as table prefix and replaced with $wpdb->prefix to allow for WordPress database tables which are setup to use more secure prefixes by @djadan.
Download this release

Release Info

Developer fernandobt
Plugin Icon 128x128 List category posts
Version 0.77
Comparing to
See all releases

Code changes from version 0.76.1 to 0.77

Files changed (3) hide show
  1. include/lcp-parameters.php +4 -3
  2. list-category-posts.php +1 -1
  3. readme.txt +8 -3
include/lcp-parameters.php CHANGED
@@ -300,12 +300,13 @@ class LcpParameters{
300
 
301
  // Support for both utf8 and utf8mb4
302
  global $wpdb;
303
- $charset = $wpdb->get_col_charset('wp_posts', 'post_title');
 
304
 
305
- $where .= 'AND (wp_posts.post_title ' .
306
  'COLLATE ' . strtoupper($charset) . '_GENERAL_CI LIKE \'' . $letters[0] . "%'";
307
  for ($i=1; $i <sizeof($letters); $i++) {
308
- $where .= 'OR wp_posts.post_title ' .
309
  'COLLATE ' . strtoupper($charset) . '_GENERAL_CI LIKE \'' . $letters[$i] . "%'";
310
  }
311
  $where.=')';
300
 
301
  // Support for both utf8 and utf8mb4
302
  global $wpdb;
303
+ $wp_posts_prefix = $wpdb->prefix . 'posts';
304
+ $charset = $wpdb->get_col_charset($wp_posts_prefix, 'post_title');
305
 
306
+ $where .= 'AND (' . $wp_posts_prefix . '.post_title ' .
307
  'COLLATE ' . strtoupper($charset) . '_GENERAL_CI LIKE \'' . $letters[0] . "%'";
308
  for ($i=1; $i <sizeof($letters); $i++) {
309
+ $where .= 'OR ' . $wp_posts_prefix . '.post_title ' .
310
  'COLLATE ' . strtoupper($charset) . '_GENERAL_CI LIKE \'' . $letters[$i] . "%'";
311
  }
312
  $where.=')';
list-category-posts.php CHANGED
@@ -3,7 +3,7 @@
3
  Plugin Name: List category posts
4
  Plugin URI: https://github.com/picandocodigo/List-Category-Posts
5
  Description: List Category Posts allows you to list posts by category in a post/page using the [catlist] shortcode. This shortcode accepts a category name or id, the order in which you want the posts to display, the number of posts to display and many more parameters. You can use [catlist] as many times as needed with different arguments. Usage: [catlist argument1=value1 argument2=value2].
6
- Version: 0.76.1
7
  Author: Fernando Briano
8
  Author URI: http://fernandobriano.com
9
 
3
  Plugin Name: List category posts
4
  Plugin URI: https://github.com/picandocodigo/List-Category-Posts
5
  Description: List Category Posts allows you to list posts by category in a post/page using the [catlist] shortcode. This shortcode accepts a category name or id, the order in which you want the posts to display, the number of posts to display and many more parameters. You can use [catlist] as many times as needed with different arguments. Usage: [catlist argument1=value1 argument2=value2].
6
+ Version: 0.77
7
  Author: Fernando Briano
8
  Author URI: http://fernandobriano.com
9
 
readme.txt CHANGED
@@ -3,9 +3,9 @@ Contributors: fernandobt
3
  Donate Link: http://picandocodigo.net/programacion/wordpress/list-category-posts-wordpress-plugin-english/#support
4
  Tags: list, categories, posts, cms
5
  Requires at least: 3.3
6
- Tested up to: 4.9.4
7
  Requires PHP: 5.2.4
8
- Stable tag: 0.76.1
9
  License: GPLv2 or later
10
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
11
 
@@ -55,7 +55,7 @@ Some users have made videos on how to use the plugin (thank you, you are awesome
55
 
56
  **Support the plugin**
57
 
58
- If you've found the plugin useful, consider making a [donation via PayPal](http://picandocodigo.net/programacion/wordpress/list-category-posts-wordpress-plugin-english/#support "Donate via PayPal") or visit my Amazon Wishlist for [books](http://www.amazon.com/gp/registry/wishlist/2HU1JYOF7DX5Q/ref=wl_web "Amazon Wishlist") or [comic books](http://www.amazon.com/registry/wishlist/1LVYAOJAZQOI0/ref=cm_wl_rlist_go_o) :).
59
 
60
  **Development**
61
 
@@ -440,6 +440,11 @@ Template system has changed. Custom templates should be stored in WordPress them
440
 
441
  == Changelog ==
442
 
 
 
 
 
 
443
  = 0.76.1 =
444
 
445
  * Fixes parsing error for PHP < 5.4. We will be dropping support for PHP pre 5.4 soon, so we recommend you to upgrade to a newer version.
3
  Donate Link: http://picandocodigo.net/programacion/wordpress/list-category-posts-wordpress-plugin-english/#support
4
  Tags: list, categories, posts, cms
5
  Requires at least: 3.3
6
+ Tested up to: 4.9.6
7
  Requires PHP: 5.2.4
8
+ Stable tag: 0.77
9
  License: GPLv2 or later
10
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
11
 
55
 
56
  **Support the plugin**
57
 
58
+ If you've found the plugin useful, consider making a [donation via PayPal](http://picandocodigo.net/programacion/wordpress/list-category-posts-wordpress-plugin-english/#support "Donate via PayPal").
59
 
60
  **Development**
61
 
440
 
441
  == Changelog ==
442
 
443
+ = 0.77 =
444
+
445
+ * Improvements in testing by @zymeth25.
446
+ * Removed hardcoded wp_ as table prefix and replaced with $wpdb->prefix to allow for WordPress database tables which are setup to use more secure prefixes by @djadan.
447
+
448
  = 0.76.1 =
449
 
450
  * Fixes parsing error for PHP < 5.4. We will be dropping support for PHP pre 5.4 soon, so we recommend you to upgrade to a newer version.