User Table

Posted: Sat Feb 28, 2009 12:33 am

I had a rash of idiot(s) joining my site and I thought it would be easier just to delete them in MySQL rather than searching each name and then deleting in the ACP, But I can't seem to find where user accounts are kept in the database any help would be appreciated.

registered · Posted: Sat Feb 28, 2009 12:40 am

If you're talking phpNuke/RavenNuke - then its your users table (probably nuke_users)

Posted: Sat Feb 28, 2009 1:04 am

ah thank you. that is what I thought but it turns out I had a partially damaged database. just restored from a backup and everything looks good now thank you

registered · Posted: Tue Mar 03, 2009 5:21 pm

You definitely to NOT want to just delete these via MySQL as you will not cover all the necessary deletions and updates. There are a lot of things tied to each user account. For now, the really only way to manage these is through RNYA.

Posted: Tue Mar 03, 2009 5:56 pm

Yes do not just delete if from the table as montego said! If you running the new 2.3.1 then as montego stated.. the Your_Account module is easy enough to delete users...

Also another note... the forums and RN are not directly tied, but removing a user from the YA module... will remove everything related to that user for you Smile

Worker Joined: Aug 26, 2007 Posts: 236

Earlier I deleted users from nuke_users with phpMyAdmin, but one should never do that because it can cause errors in the forum, if the member have posts in the forums left,

Posted: Thu Mar 05, 2009 12:32 pm

A. As stated above DO NOT use phpmyadmin or a homegrown script to remove users. You will cause no end of problems.
B. In RNYA you need to first deactivate the user. The user will then show up in the deactivated users tab. From there you can remove them. In future versions there probably should be a direct and full one step delete capacity but that is not available now.

Posted: Thu Mar 05, 2009 12:58 pm

If you don´t have RNYA just change the password and the e-mail of the user in the table nuke_users.
The result: They are unable to login anymore and will not receive a new password. Smile