Delete users from database and admin user management

[bbrian017]

I'm having issues deleting the test users I created. I can stop the account from being active delete the users and all comments/posts but when I look at the top users page, they are all still there as if I never deleted them.

How do I permanently get rid of the users ?

Delete users from database and admin user management

See the users test users still show up

[betagirl]

I'd love to be able to do this as well. We sometimes get requests from users to delete their accounts, and while killspamming removes their stories and comments, their accounts can still be search for and navigated to if the direct URL and username is known. Why is there no "delete user account" option?

[bbrian017]

I would also like to see a Delete story. You can always access deleted stories and if it's porn related this is unacceptable. Is there an option to delete a story not just discard it?

[depapepe]

yea.. i have to delete from phpmyadmin cpanel admin manually.. so impractical

[hokewilcox]

Impractical yes, but doable....I wonder if they will fix that?

[cchh]

I made patch for delete emtpy users.
Users with now votes and stories (links).

Open admin->manage->users. here you can sea: Count empty users All users: 1478
click to `Count empty users` and you can sea Delete N empty users, click it and all spammers will be die!

Here is my patch:

Index: admin/admin_users.php
===================================================================
--- admin/admin_users.php       (revision 685)
+++ admin/admin_users.php       (working copy)
@@ -702,7 +702,46 @@
                }

                $main_smarty->assign('userlist', $userlist);
+
+               if (sanitize($_GET["countEmptyUsers"], 3) == "count"){ //count Empty Users
+
+                       $emptyUsers = mysql_query("SELECT count(distinct u.user_id) ".
+                       "FROM " . table_users . " u ".
+                       "LEFT JOIN " . table_links . " l ON u.user_id = l.link_author ".
+                       "LEFT JOIN " . table_votes . " v ON u.user_id = v.vote_user_id ".
+                       "WHERE l.link_id IS NULL ".
+                       "AND v.vote_user_id IS NULL");
+
+                       $arr = mysql_fetch_array( $emptyUsers);
+
+
+                       $main_smarty->assign('countEmptyUsers', $arr[0] );
+               }
+
+               if (sanitize($_GET["countEmptyUsers"], 3) == "delete"){ //delete Empty Users
+
+                           $emptyUsers = mysql_query("SELECT distinct u.user_id ".
+                           "FROM " . table_users . " u ".
+                           "LEFT JOIN " . table_links . " l ON u.user_id = l.link_author ".
+                           "LEFT JOIN " . table_votes . " v ON u.user_id = v.vote_user_id ".
+                           "WHERE l.link_id IS NULL ".
+                           "AND v.vote_user_id IS NULL");
+                           while ($arr = mysql_fetch_array( $emptyUsers)) {
+                                   $db->query('DELETE FROM `' . table_comments . '` WHERE `comment_user_id` = "'. $arr[0] . '"');
+                                          $db->query('DELETE FROM `' . table_votes . '` WHERE `vote_user_id` = "'.$arr[0].'"');
+                                          $db->query('DELETE FROM `' . table_saved_links . '` WHERE `saved_user_id` = "'.$arr[0].'"');
+                                          $db->query('DELETE FROM `' . table_trackbacks . '` WHERE `trackback_user_id` = "'.$arr[0].'"');
+                                          $db->query('DELETE FROM `' . table_friends . '` WHERE `friend_id` = "'.$arr[0].'"');
+                                          $db->query('DELETE FROM `' . table_messages . '` WHERE `sender` = "'.$arr[0].'"');
+                                          $db->query('DELETE FROM `' . table_messages . '` WHERE `receiver` = "'.$arr[0].'"');
+                                   $db->query('DELETE FROM `' . table_users . '` WHERE `user_id` = "'. $arr[0] . '"');
+                           }
+                          }
+
+                      $main_smarty->assign('countUsers', $rows );

+
+
                // breadcrumbs anf page title
                $navwhere['text1'] = $main_smarty->get_config_vars('PLIGG_Visual_Header_AdminPanel');
                $navwhere['link1'] = getmyurl('admin', '');
Index: templates/admin/user_listall_center.tpl
===================================================================
--- templates/admin/user_listall_center.tpl     (revision 685)
+++ templates/admin/user_listall_center.tpl     (working copy)
@@ -14,7 +14,17 @@

   <a href="{$my_pligg_base}/admin/admin_users.php?mode=create" title="Create User" id="create">{#PLIGG_Visual_AdminPanel_New_User#}</a>
   <div class="multiBoxDesc create">{#PLIGG_Visual_AdminPanel_New_User_Desc#}</div>
-
+
+&nbsp;&nbsp;&nbsp;
+  {if !isset($countEmptyUsers)}
+       <a href='{$my_pligg_base}/admin/admin_users.php?countEmptyUsers=count'>Count empty users</a>
+  {else}
+       <a href='{$my_pligg_base}/admin/admin_users.php?countEmptyUsers=delete'>Delete {$countEmptyUsers} empty users</a>
+  {/if}
+  &nbsp;&nbsp;&nbsp;
+
+  All users: {$countUsers}
+
 </form>
 <form action="{$my_pligg_base}/admin/admin_users.php" method="get">
        {#PLIGG_Visual_AdminPanel_Pagination_Items#}

[cchh]

has anyone review my patch?

[chuckroast]

has anyone review my patch?

I have and I think it's great. Thanks for sharing.
I would recommend starting a new thread under the "modification tutorials" forum.
Something good like this kind of gets lost, deep inside a thread like this.

[fontadoni]

has anyone review my patch?

Thanks a lot man! It works great. I just got rid of 300 hundred spammers. This function should be included in the original script.

[esavvy]

I'd love to be able to do this as well. We sometimes get requests from users to delete their accounts, and while killspamming removes their stories and comments, their accounts can still be search for and navigated to if the direct URL and username is known. Why is there no "delete user account" option?

I appologize if this question has already been answered. I am posting it here because I couldn't find any suitable answer anywhere in this forum.

I would like to know if betagirls concern about deleting user accounts when they request it, has been addressed because I will like to be able to do that without affecting my entire site.

I think this is important because of the ever changing laws regarding online privacy and the right of individuals to decide how much of their personal information is stored online by websites.

Any helpful tips are welcome.

Thanks