HOWTO: Force all members to change their password


Item has a rating of 5 (Liked by Chris GrahamLiked by DuckLiked by Jason Verhagen)
#1895 (In Topic #371)
Site director
Patrick Schmalstig is in the usergroup ‘Administrators’
This is a VERY easy tutorial on how you can force all members to have to change their password on the next login to your Composr-powered website.

This tutorial only applies to those running the forum driver "Conversr" (Composr's native forum system) and are using an SQL database such as MySQL. If you are using another forum driver, such as PHPBB, then this tutorial does not apply to you.

All you have to do is access your SQL database of your Composr installation and run the following SQL statement (this statement is syntaxed for MySQL... adjust accordingly):

UPDATE (prefix)_f_members SET m_password_compat_scheme = 'temporary' WHERE id > 1 AND m_password_compat_scheme LIKE ''

where prefix is your database table prefix for Composr. The 'id > 1' makes the SQL ignore the guest user; we don't want to have to force guests to change a nonexisting password. m_password_compat_scheme LIKE '' where condition will also skip any members who have a scheme set. This is in case your members may have authenticated elsewhere, such as the Facebook Connect addon.

This will effectively require all members to change their password upon the next login to your Composr website.

Last edit: by Patrick Schmalstig

Online now: No Back to the top
1 guest and 0 members have just viewed this.


Users online:

Philip, babu, deepu_ms, Paul D, Salman, mytracker, Chris Graham

Forum statistics:
  • 1,294 topics, 5,826 posts, 7,053 members
  • Our newest member is Chris Woris
Back to Top