XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / How to mass activate users?
Register
1
ali44
How to mass activate users?

  • 2004/9/30 19:48

  • ali44

  • Just popping in

  • Posts: 86

  • Since: 2004/5/24


I have like over 2000 users that have legitimate emails but somehow the activation emails didn't delivered in manner. I'd like to activate them all but one by one take forever... Any one knows please help. Many thanks
2
Dave_L
Re: How to mass activate users?

  • 2004/9/30 22:07

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


This query should activate all inactivated users:

UPDATE xoops_users SET level = 1 WHERE level = 0


Back up the database (at least the xoops_users table) first.
3
ali44
Re: How to mass activate users?

  • 2004/10/4 6:29

  • ali44

  • Just popping in

  • Posts: 86

  • Since: 2004/5/24


Would you please tell me which file to edit? Thanks :)
4
Dave_L
Re:How to mass activate users?

  • 2004/10/4 14:45

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


There's no file to edit. The information is stored in the database. What I posted is a MySQL database query that updates the information.

To perform the query, you would need to use phpMyAdmin or the equivalent. This may be already provided by your web hosting service.

But don't attempt to modify the database in this manner unless you know what you're doing.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

200 user(s) are online (128 user(s) are browsing Support Forums)

Members: 0

Guests: 200

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits