Changeset 1207 for trunk/wp-admin/users.php

Timestamp:

04/28/2004 08:36:31 PM (22 years ago)

Author:

saxmatt

Message:

Don't delete everything if there are no posts.

File:

• trunk/wp-admin/users.php (modified) (1 diff)

trunk/wp-admin/users.php

@@ -139 +139 @@
 
         $post_ids = $wpdb->get_col("SELECT ID FROM $tableposts WHERE post_author = $id");
-        $post_ids = implode(',', $post_ids);
-        
-        // Delete comments, *backs
-        $wpdb->query("DELETE FROM $tablecomments WHERE comment_post_ID IN ($post_ids)");
-        // Clean cats
-        $wpdb->query("DELETE FROM $tablepost2cat WHERE post_id IN ($post_ids)");
-        // Clean post_meta
-        $wpdb->query("DELETE FROM $tablepostmeta WHERE post_id IN ($post_ids)");
-        // Clean links
-        $wpdb->query("DELETE FROM $tablelinks WHERE link_owner = $id");
-        // Delete posts
-        $wpdb->query("DELETE FROM $tableposts WHERE post_author = $id");
-        // FINALLY, delete user
-        $wpdb->query("DELETE FROM $tableusers WHERE ID = $id");
-        
+        if ($post_ids) {
+                $post_ids = implode(',', $post_ids);
+                
+                // Delete comments, *backs
+                $wpdb->query("DELETE FROM $tablecomments WHERE comment_post_ID IN ($post_ids)");
+                // Clean cats
+                $wpdb->query("DELETE FROM $tablepost2cat WHERE post_id IN ($post_ids)");
+                // Clean post_meta
+                $wpdb->query("DELETE FROM $tablepostmeta WHERE post_id IN ($post_ids)");
+                // Clean links
+                $wpdb->query("DELETE FROM $tablelinks WHERE link_owner = $id");
+                // Delete posts
+                $wpdb->query("DELETE FROM $tableposts WHERE post_author = $id");
+                // FINALLY, delete user
+                $wpdb->query("DELETE FROM $tableusers WHERE ID = $id");
+        }
         header('Location: users.php?deleted=true');