Context Navigation

Changeset 833989

Timestamp:

01/06/2014 05:52:19 PM (12 years ago)

Author:

mcwebdesignro

Message:

update code

Location:

no-posts-user-delete/trunk

Files:

-                      r783026
+                      r833989
             // delete users (and their meta info) with no posts
             //$wpdb->show_errors();
             $sql = $wpdb->prepare("DELETE FROM {$tp}usermeta WHERE user_id NOT IN (SELECT DISTINCT post_author FROM {$tp}posts);");
+            $sql = $wpdb->prepare("DELETE FROM {$tp}usermeta WHERE user_id NOT IN (SELECT DISTINCT post_author FROM {$tp}posts);", $user_id);
             $wpdb->query($sql);
             //$wpdb->show_errors();
             $sql = $wpdb->prepare("DELETE FROM {$tp}users WHERE ID NOT IN (SELECT DISTINCT post_author FROM {$tp}posts);");
+            $sql = $wpdb->prepare("DELETE FROM {$tp}users WHERE ID NOT IN (SELECT DISTINCT post_author FROM {$tp}posts);", $ID);
             $wpdb->query($sql);

r783026	r833989
4	4	Tags: user delete, no posts, zero posts, admin delete
5	5	Requires at least: 3.0
6		Tested up to: 3.~~6.1~~
	6	Tested up to: 3.8
7	7	Stable tag: 1.0
8	8	License: GPLv2 or later

Note: See TracChangeset for help on using the changeset viewer.