Broken Link Checker - Version 0.4.3

Version Description

Download this release

Release Info

Developer whiteshadow
Plugin Icon 128x128 Broken Link Checker
Version 0.4.3
Comparing to
See all releases

Code changes from version 0.4.2 to 0.4.3

Files changed (3) hide show
  1. broken-link-checker.php +6 -3
  2. readme.txt +1 -1
  3. wsblc_ajax.php +3 -1
broken-link-checker.php CHANGED
@@ -3,7 +3,7 @@
3
  Plugin Name: Broken Link Checker
4
  Plugin URI: http://w-shadow.com/blog/2007/08/05/broken-link-checker-for-wordpress/
5
  Description: Checks your posts for broken links and missing images and notifies you on the dashboard if any are found.
6
- Version: 0.4.2
7
  Author: Janis Elsts
8
  Author URI: http://w-shadow.com/blog/
9
  */
@@ -20,7 +20,7 @@ class ws_broken_link_checker {
20
  var $options_name='wsblc_options';
21
  var $postdata_name;
22
  var $linkdata_name;
23
- var $version='0.4.2';
24
  var $myfile='';
25
  var $myfolder='';
26
  var $mybasename='';
@@ -272,7 +272,10 @@ class ws_broken_link_checker {
272
  $sql="INSERT INTO ".$this->postdata_name."(post_id, last_check)
273
  SELECT ".$wpdb->posts.".id, '00-00-0000 00:00:00' FROM ".$wpdb->posts."
274
  LEFT JOIN ".$this->postdata_name." ON ".$wpdb->posts.".id=".$this->postdata_name.".post_id
275
- WHERE ".$this->postdata_name.".post_id IS NULL";
 
 
 
276
  $wpdb->query($sql);
277
  }
278
 
3
  Plugin Name: Broken Link Checker
4
  Plugin URI: http://w-shadow.com/blog/2007/08/05/broken-link-checker-for-wordpress/
5
  Description: Checks your posts for broken links and missing images and notifies you on the dashboard if any are found.
6
+ Version: 0.4.3
7
  Author: Janis Elsts
8
  Author URI: http://w-shadow.com/blog/
9
  */
20
  var $options_name='wsblc_options';
21
  var $postdata_name;
22
  var $linkdata_name;
23
+ var $version='0.4.3';
24
  var $myfile='';
25
  var $myfolder='';
26
  var $mybasename='';
272
  $sql="INSERT INTO ".$this->postdata_name."(post_id, last_check)
273
  SELECT ".$wpdb->posts.".id, '00-00-0000 00:00:00' FROM ".$wpdb->posts."
274
  LEFT JOIN ".$this->postdata_name." ON ".$wpdb->posts.".id=".$this->postdata_name.".post_id
275
+ WHERE
276
+ ".$this->postdata_name.".post_id IS NULL
277
+ AND ".$wpdb->posts.".post_status = 'publish'
278
+ AND ".$wpdb->posts.".post_type IN ('post', 'page') ";
279
  $wpdb->query($sql);
280
  }
281
 
readme.txt CHANGED
@@ -3,7 +3,7 @@ Contributors: whiteshadow
3
  Tags: links, broken, maintenance
4
  Requires at least: 2.0.2
5
  Tested up to: 2.6
6
- Stable tag: 0.4.2
7
 
8
  This plugin will check your posts for broken links and missing images in background and notify you on the dashboard if any are found.
9
 
3
  Tags: links, broken, maintenance
4
  Requires at least: 2.0.2
5
  Tested up to: 2.6
6
+ Stable tag: 0.4.3
7
 
8
  This plugin will check your posts for broken links and missing images in background and notify you on the dashboard if any are found.
9
 
wsblc_ajax.php CHANGED
@@ -96,7 +96,9 @@
96
  echo "<!-- run_check -->";
97
 
98
  $sql="SELECT b.* FROM $postdata_name a, $wpdb->posts b
99
- WHERE a.last_check<'$check_treshold' AND a.post_id=b.id ORDER BY a.last_check ASC LIMIT 40";
 
 
100
 
101
  $rows=$wpdb->get_results($sql, OBJECT);
102
  if($rows && (count($rows)>0)){
96
  echo "<!-- run_check -->";
97
 
98
  $sql="SELECT b.* FROM $postdata_name a, $wpdb->posts b
99
+ WHERE a.last_check<'$check_treshold' AND a.post_id=b.id
100
+ AND b.post_status = 'publish' AND b.post_type IN ('post', 'page')
101
+ ORDER BY a.last_check ASC LIMIT 40";
102
 
103
  $rows=$wpdb->get_results($sql, OBJECT);
104
  if($rows && (count($rows)>0)){