xoops forums

Cuidiu

Quite a regular
Posted on: 2009/3/3 21:34
Cuidiu
Cuidiu (Show more)
Quite a regular
Posts: 358
Since: 2006/4/23
#1

Deleting Users

Hi All,

Is there a way to batch delete users in 2.2.4? I have a membership site that needs serious cleaning up and deleting only one user account at a time will take hours.

Thanks in advance.
Working sites:
XOOPS 2.0.16 PHP 5.2.2, MySQL 5.0.24a-standard-log, Apache/2.0.54 (Unix)
XOOPS 2.2.4, PHP 4.3.10, MySQL 3.23.58, Apache/1.3.33 (Unix)

Catzwolf

Home away from home
Posted on: 2009/3/4 2:24
Catzwolf
Catzwolf (Show more)
Home away from home
Posts: 1392
Since: 2007/9/30
#2

Re: Deleting Users

Make a back up of your XOOPS database, and delete the users using myphpadmin. That should speed things up for you. :)

But I don't know of any modules or scripts that could currently batch delete at this very moment.

Cuidiu

Quite a regular
Posted on: 2009/3/4 15:50
Cuidiu
Cuidiu (Show more)
Quite a regular
Posts: 358
Since: 2006/4/23
#3

Re: Deleting Users

Thanks, catzwolf. I was hoping I wouldn't have to venture in there to delete users. I would need to delete in two areas - profile and users, right? (Can't really remember offhand). That might prove to be difficult for me.

I do have them separated into a specific group. Too bad deleting the group doesn't have an option to delete the users (within it) from the database.
Working sites:
XOOPS 2.0.16 PHP 5.2.2, MySQL 5.0.24a-standard-log, Apache/2.0.54 (Unix)
XOOPS 2.2.4, PHP 4.3.10, MySQL 3.23.58, Apache/1.3.33 (Unix)

Catzwolf

Home away from home
Posted on: 2009/3/4 18:55
Catzwolf
Catzwolf (Show more)
Home away from home
Posts: 1392
Since: 2007/9/30
#4

Re: Deleting Users

Just had a look at the way this has been done. It will take a bit more than just deleting the users from the users table, seems the profile module as a link id to it now.

Give me a few hours, I will update the profile module to allow deleting of groups and post a link here for it k.

Cuidiu

Quite a regular
Posted on: 2009/3/5 0:25
Cuidiu
Cuidiu (Show more)
Quite a regular
Posts: 358
Since: 2006/4/23
#5

Re: Deleting Users

For 2.2.4? Wow... that will be great! Thanks so much!
Working sites:
XOOPS 2.0.16 PHP 5.2.2, MySQL 5.0.24a-standard-log, Apache/2.0.54 (Unix)
XOOPS 2.2.4, PHP 4.3.10, MySQL 3.23.58, Apache/1.3.33 (Unix)

Cuidiu

Quite a regular
Posted on: 2009/7/15 14:16
Cuidiu
Cuidiu (Show more)
Quite a regular
Posts: 358
Since: 2006/4/23
#6

Re: Deleting Users

Hi Catzwolf,
Have you had a chance to update the profile module?

Edited: Sorry... I just now ran across your post from earlier this month and see that you are no longer coding. Please disregard the above. I wish you the best and a quick recovery.

Thanks,
Cuidiu

Quote:
Catzwolf wrote:
Just had a look at the way this has been done. It will take a bit more than just deleting the users from the users table, seems the profile module as a link id to it now.

Give me a few hours, I will update the profile module to allow deleting of groups and post a link here for it k.
Working sites:
XOOPS 2.0.16 PHP 5.2.2, MySQL 5.0.24a-standard-log, Apache/2.0.54 (Unix)
XOOPS 2.2.4, PHP 4.3.10, MySQL 3.23.58, Apache/1.3.33 (Unix)