SEO Smart Links - Version 2.4

Version Description

  • Added LIMIT 2000 to most queries, should speed things up on large sites
Download this release

Release Info

Developer freediver
Plugin Icon 128x128 SEO Smart Links
Version 2.4
Comparing to
See all releases

Code changes from version 2.3.1 to 2.4

Files changed (2) hide show
  1. readme.txt +4 -1
  2. seo-links.php +4 -4
readme.txt CHANGED
@@ -3,7 +3,7 @@ Contributors: freediver
3
  Donate link: https://www.networkforgood.org/donation/MakeDonation.aspx?ORGID2=520781390
4
  Tags: Post, posts, comments, links, seo, google, automatic, affiliate
5
  Requires at least: 2.3
6
- Tested up to: 2.8.4
7
  Stable tag: trunk
8
 
9
  SEO Smart Links provides automatic SEO benefits for your site in addition to custom keyword lists, nofollow and much more.
@@ -25,6 +25,9 @@ Plugin by Vladimir Prelovac a <a href="http://www.prelovac.com/vladimir/services
25
 
26
  == Changelog ==
27
 
 
 
 
28
  = 2.3.1 =
29
  * General bug fixes. Fixed the issue with str_split. Solved heading issue which changed style code in heading tags.
30
 
3
  Donate link: https://www.networkforgood.org/donation/MakeDonation.aspx?ORGID2=520781390
4
  Tags: Post, posts, comments, links, seo, google, automatic, affiliate
5
  Requires at least: 2.3
6
+ Tested up to: 2.8.5
7
  Stable tag: trunk
8
 
9
  SEO Smart Links provides automatic SEO benefits for your site in addition to custom keyword lists, nofollow and much more.
25
 
26
  == Changelog ==
27
 
28
+ = 2.4 =
29
+ * Added LIMIT 2000 to most queries, should speed things up on large sites
30
+
31
  = 2.3.1 =
32
  * General bug fixes. Fixed the issue with str_split. Solved heading issue which changed style code in heading tags.
33
 
seo-links.php CHANGED
@@ -2,7 +2,7 @@
2
 
3
  /*
4
  Plugin Name: SEO Smart Links
5
- Version: 2.3.1
6
  Plugin URI: http://www.prelovac.com/vladimir/wordpress-plugins/seo-smart-links
7
  Author: Vladimir Prelovac</a>
8
  Author URI: http://www.prelovac.com/vladimir
@@ -150,7 +150,7 @@ function SEOLinks_process_text($text, $mode)
150
  if ($options['lposts'] || $options['lpages'])
151
  {
152
  if ( !$posts = wp_cache_get( 'seo-links-posts', 'seo-smart-links' ) ) {
153
- $query="SELECT post_title, ID, post_type FROM $wpdb->posts WHERE post_status = 'publish' AND LENGTH(post_title)>3 ORDER BY LENGTH(post_title) DESC";
154
  $posts = $wpdb->get_results($query);
155
 
156
  wp_cache_add( 'seo-links-posts', $posts, 'seo-smart-links', 86400 );
@@ -186,7 +186,7 @@ function SEOLinks_process_text($text, $mode)
186
  {
187
  if ( !$categories = wp_cache_get( 'seo-links-categories', 'seo-smart-links' ) ) {
188
 
189
- $query="SELECT $wpdb->terms.name, $wpdb->terms.term_id FROM $wpdb->terms LEFT JOIN $wpdb->term_taxonomy ON $wpdb->terms.term_id = $wpdb->term_taxonomy.term_id WHERE $wpdb->term_taxonomy.taxonomy = 'category' AND LENGTH($wpdb->terms.name)>3 AND $wpdb->term_taxonomy.count >= $minusage ORDER BY LENGTH($wpdb->terms.name) DESC";
190
  $categories = $wpdb->get_results($query);
191
 
192
  wp_cache_add( 'seo-links-categories', $categories, 'seo-smart-links',86400 );
@@ -217,7 +217,7 @@ function SEOLinks_process_text($text, $mode)
217
  {
218
  if ( !$tags = wp_cache_get( 'seo-links-tags', 'seo-smart-links' ) ) {
219
 
220
- $query="SELECT $wpdb->terms.name, $wpdb->terms.term_id FROM $wpdb->terms LEFT JOIN $wpdb->term_taxonomy ON $wpdb->terms.term_id = $wpdb->term_taxonomy.term_id WHERE $wpdb->term_taxonomy.taxonomy = 'post_tag' AND LENGTH($wpdb->terms.name)>3 AND $wpdb->term_taxonomy.count >= $minusage ORDER BY LENGTH($wpdb->terms.name) DESC";
221
  $tags = $wpdb->get_results($query);
222
 
223
  wp_cache_add( 'seo-links-tags', $tags, 'seo-smart-links',86400 );
2
 
3
  /*
4
  Plugin Name: SEO Smart Links
5
+ Version: 2.4
6
  Plugin URI: http://www.prelovac.com/vladimir/wordpress-plugins/seo-smart-links
7
  Author: Vladimir Prelovac</a>
8
  Author URI: http://www.prelovac.com/vladimir
150
  if ($options['lposts'] || $options['lpages'])
151
  {
152
  if ( !$posts = wp_cache_get( 'seo-links-posts', 'seo-smart-links' ) ) {
153
+ $query="SELECT post_title, ID, post_type FROM $wpdb->posts WHERE post_status = 'publish' AND LENGTH(post_title)>3 ORDER BY LENGTH(post_title) DESC LIMIT 2000";
154
  $posts = $wpdb->get_results($query);
155
 
156
  wp_cache_add( 'seo-links-posts', $posts, 'seo-smart-links', 86400 );
186
  {
187
  if ( !$categories = wp_cache_get( 'seo-links-categories', 'seo-smart-links' ) ) {
188
 
189
+ $query="SELECT $wpdb->terms.name, $wpdb->terms.term_id FROM $wpdb->terms LEFT JOIN $wpdb->term_taxonomy ON $wpdb->terms.term_id = $wpdb->term_taxonomy.term_id WHERE $wpdb->term_taxonomy.taxonomy = 'category' AND LENGTH($wpdb->terms.name)>3 AND $wpdb->term_taxonomy.count >= $minusage ORDER BY LENGTH($wpdb->terms.name) DESC LIMIT 2000";
190
  $categories = $wpdb->get_results($query);
191
 
192
  wp_cache_add( 'seo-links-categories', $categories, 'seo-smart-links',86400 );
217
  {
218
  if ( !$tags = wp_cache_get( 'seo-links-tags', 'seo-smart-links' ) ) {
219
 
220
+ $query="SELECT $wpdb->terms.name, $wpdb->terms.term_id FROM $wpdb->terms LEFT JOIN $wpdb->term_taxonomy ON $wpdb->terms.term_id = $wpdb->term_taxonomy.term_id WHERE $wpdb->term_taxonomy.taxonomy = 'post_tag' AND LENGTH($wpdb->terms.name)>3 AND $wpdb->term_taxonomy.count >= $minusage ORDER BY LENGTH($wpdb->terms.name) DESC LIMIT 2000";
221
  $tags = $wpdb->get_results($query);
222
 
223
  wp_cache_add( 'seo-links-tags', $tags, 'seo-smart-links',86400 );