Mass Password Change

I had a similar problem on one of my sites, but for me i had to create passwords for them all. from MySQL i exported the users table to xls changed the password field to the password I wanted then imported it back in. this is probally the worst way to do it, but it worked for me!.

First, Try this Script for your Personal E-Mail or Create a Test Account and Test it for its E-Mail address :

My Personal Website is Down today, so I couldn't tested it...!
Don't forget to change Write the Test Email Address Here with the Email of Test Account.
[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]<?php
require_once CLASSES."LostPassword.class.php";
$result = dbquery("SELECT user_name, user_email, user_password FROM ".DB_USERS." WHERE user_email='Write the Test Email Address Here'";
$reset = new LostPassword();
while ($data = dbarray($result))
{
$reset->checkPasswordRequest($data['user_email'], $data['user_password']);
echo $data['user_name']." : ".$data['user_email']." : New Password Sent<br />";
}
?>[/syntaxhighlighter]

If it works OK, then you can Change the Query to :
[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]$result = dbquery("SELECT user_name, user_email, user_password FROM ".DB_USERS." WHERE user_status=0";[/syntaxhighlighter]
Remember: This Query will Send E-Mails to All the Users(i.e no of registered Users) at the same time.

Ankur,

I think I understand what the script will do, but I want to make sure before I do so. In testing it, the script will change the password? If so, what does it change it to. Then in reading the end of your script you mention that the script will send an email to all registered users. What email is being sent?

Merged on Jul 10 2011 at 09:07:46:
I am also getting the following error msg when running the script:

Warning: require_once(CLASSESLostPassword.class.php) [function.require-once]: failed to open stream: No such file or directory in /hermes/bosweb/web199/b1997/ipw.uname/folder/pass_reset.php on line 2

Fatal error: require_once() [function.require]: Failed opening required 'CLASSESLostPassword.class.php' (include_path='.:/usr/local/lib/php-5.2.17/lib/php') in /hermes/bosweb/web199/b1997/ipw.uname/folder/pass_reset.php on line 2

Did you tried this script in a custom page ?
If running in a separate php file, then dont forget to include maincore.php file...

When previewing the code in a custom page, I get the following error msg:

Fatal error: Class 'PasswordAuth' not found in /hermes/bosweb/web199/b1997/ipw.fredswebp/testsite/includes/classes/LostPassword.class.php on line 20

BTW, the code worked if I changed ClassesLostPassword.class.php to lostpassword.php

He's not using PHP Fusion > 7.02.00 / v7.02.01!

You may not have received the New Password Email, I think...!

So What PHPFusion version actually you are using ?

Here is a screen shot of the admin panel showing that I am running version 7.02.03.

Merged on Jul 11 2011 at 14:02:53:
Anyone else have any further input on this thread? Do I have a corrupted version of php-fusion?