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


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.
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!
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:
Does this MOD block USER registrations or just news submissions?Blackball is enormous blacklist ruleset designed to cut down the number of spam submissions you may be receiving on a Pligg site.
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
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
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.
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.