Results 1 to 9 of 9
  1. #1
    Casual Pligger MORGARTEN's Avatar
    Joined
    Feb 2009
    Posts
    31

    Question How delete users?

    How can the admin delete a user account? How can a user delete his own account?

  2. #2
    New Pligger cegeland's Avatar
    Joined
    Oct 2007
    Posts
    25
    I don't know how a user can delete their own account but the admin can delete any users account by going to the database and going to the pligg_users table and then selecting and deleting the user account you no longer want. Back up your database first before doing anything just in case something goes wrong you can restore to a working version.

  3. #3
    Pligg Developer chuckroast's Avatar
    Joined
    Jun 2006
    Posts
    5,478
    Again there really should be no reason to delete a users a from that database. The way pligg works is that a user is either active or inactive. This is done for a reason. Once you start deleting users from the database your going to have serious problems. Lets say you have a spammer. You delete his name from the database, there is nothing now from stopping him from registering and using the same username and account again.

  4. #4
    New Pligger wjc2009's Avatar
    Joined
    Sep 2009
    Posts
    11
    Quote Originally Posted by chuckroast View Post
    Again there really should be no reason to delete a users a from that database. The way pligg works is that a user is either active or inactive. This is done for a reason. Once you start deleting users from the database your going to have serious problems. Lets say you have a spammer. You delete his name from the database, there is nothing now from stopping him from registering and using the same username and account again.
    Surely it makes more sense to:

    - have two delete settings ('disable' and 'destroy' or similar wording)
    - if you disable a user, they stay on the database in case they wish to be re-enabled later on,
    - if you Destroy a user, they are deleted from the database, and all their information is copied over to a 'destroyed_users' table
    - 'destroyed_users' is checked in the signup process to determine whether their username/email address has been previously destroyed?

    All I know is we'd love to see a button in the Manage > Users panel saying something like "Permanently Delete User" and know that they'd be compeltely dropped from the Users table.

    Any ideas?

    Thanks!

  5. #5
    New Pligger Cruth's Avatar
    Joined
    Oct 2007
    Posts
    11

    SPAM problem: 4321 users & bandwith getting eaten

    Quote Originally Posted by chuckroast View Post
    Again there really should be no reason to delete a users a from that database. The way pligg works is that a user is either active or inactive. This is done for a reason. Once you start deleting users from the database your going to have serious problems. Lets say you have a spammer. You delete his name from the database, there is nothing now from stopping him from registering and using the same username and account again.
    Thanks for your info. I just started my site (or am redoing it ) at MetroSpecials.com

    Found out this domain is using way more bandwith than any other CPanel account, and I am assuming it must be due to all of the registered user. Even tho, as you can see I have no stories yet.

    I changed to recaptcha.

    Is there a way to:

    1) block certain email addresses ( I see most users are from hotmail.com)
    2) bulk delete all users INSIDE of Pligg
    3) bulk delete as many users as I select, INSIDE Pligg
    4) just buld delete inside phpAdmin>

    If I missed the answer to this, I apologize in advance. Please let me know where that info might be. I have looked.

    UPDATE: I found some info on site. Thanks. 2nd question:

    Blackball is enormous blacklist ruleset designed to cut down the number of spam submissions you may be receiving on a Pligg site.
    Does this MOD block USER registrations or just news submissions?

    Also, are there any other premium MODS offered at Pligg shop that I can buy that will help solve the excessive user registration issue, or is ther any other feasible solution, so that I can prevent the unnecessary bandwith usage?

    Thanks

    cruth

  6. #6
    New Pligger Cruth's Avatar
    Joined
    Oct 2007
    Posts
    11

    Wink update regarding delete users

    For a number of reasons, i decided to delete the 4000+ spam users on my site.

    Just in case someone else has this issue.

    I use Cpanel, and deleted all without problems using the phpMyAdmin.

    There were no published posts, and I had discard all waiting posts Inside Pligg) prior to deleting the users.

    Thanks

  7. #7
    New Pligger textheavy's Avatar
    Joined
    May 2008
    Posts
    16
    Quote Originally Posted by chuckroast View Post
    Again there really should be no reason to delete a users a from that database. The way pligg works is that a user is either active or inactive. This is done for a reason. Once you start deleting users from the database your going to have serious problems. Lets say you have a spammer. You delete his name from the database, there is nothing now from stopping him from registering and using the same username and account again.
    Well, I would disagree with the assumption that there's no good reason to delete a user account.

    I had to create 10 test user accounts in order to fix a problem with the registration mailing (covered in another thread). Now I have 10 accounts listed that I know are dummies and are just taking up 10 slots on my User list, which I don't particularly want to see every time I go to manage users. I would like to delete them out, but I don't know enough about databases to know whether I can delete just from one field in the pligg_users table, or if I'm going to have to go in and take some time to look through all the fields and remove all corresponding data in each field.

    Would be so much easier if I could just delete them through the Admin screens.

  8. #8
    Pligg Developer chuckroast's Avatar
    Joined
    Jun 2006
    Posts
    5,478
    Quote Originally Posted by textheavy View Post
    Well, I would disagree with the assumption that there's no good reason to delete a user account.

    I had to create 10 test user accounts in order to fix a problem with the registration mailing (covered in another thread). Now I have 10 accounts listed that I know are dummies and are just taking up 10 slots on my User list, which I don't particularly want to see every time I go to manage users. I would like to delete them out, but I don't know enough about databases to know whether I can delete just from one field in the pligg_users table, or if I'm going to have to go in and take some time to look through all the fields and remove all corresponding data in each field.

    Would be so much easier if I could just delete them through the Admin screens.
    All you need to do is check the box killspam next to the user name in the user management list and click apply changes. You will no longer see them when you first open the user management panel. They will also not appear in the public users list, nor will their profiles be available for viewing anymore. All stories and comments are removed. It basically does the exact same thing as deleting them except for the fact that someone can't just re-register using the same credentials. As I stated above this is done on purpose. Otherwise it would be taken advantage of by spammers.

    Just deleting the name from the pligg_users table will cause you a ton of problems. There is much more to a user than just a name. There are votes, submissions, comments, comments votes, karma, groups, saved stories, last login ip info, registration ip info, email address, and all the stuff that people can enter into their profile.

  9. #9
    New Pligger darjana's Avatar
    Joined
    May 2010
    Posts
    22
    What you could do is add a ban table, with username, email.

    Then by using killspam sql queries, to create another as delete and then instead of disabling(killspam), you would do DROP.

    just my 2c.

Similar Threads

  1. Delete DB users 0 links
    By seomaker in forum Questions & Comments
    Replies: 4
    Last Post: 03-21-2011, 10:49 AM
  2. Delete Spam users
    By seomaker in forum Questions & Comments
    Replies: 0
    Last Post: 04-18-2010, 03:59 AM
  3. can users delete their own comments
    By mizar in forum Questions & Comments
    Replies: 2
    Last Post: 04-16-2010, 11:59 AM
  4. Using PhpMyAdmin to delete users
    By Grimmjow in forum Questions & Comments
    Replies: 2
    Last Post: 03-29-2010, 12:18 PM
  5. How to delete all users from database
    By Fuggled in forum Questions & Comments
    Replies: 1
    Last Post: 10-06-2009, 08:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Pligg Modules and Pligg Templates from Pligg Pro Donate to Pligg CMS Dreamhost Web Hosting Host Gator Web Hosting