Reset customer password from admin

**badbod** · 5 Dec 2012, 08:39 AM

Hi,
I added a search, it is by email only.

after the line:

Code:

$action = (isset($_GET['action']) ? $_GET['action'] : '');

add:

Code:

$searchemail = (isset($_POST['email']) ? $_POST['email'] : '');

after the line (around line 80) :

Code:

<td class="pageHeading"><?php echo PASSCHANGE_HEADING_TITLE; ?></td>

add:

Code:

<td class="pageHeading">Search email <form action='' method=post><input type=text name=email><input type=submit></form></td>

Around line 98 :

Code:

    $passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from $passchangeCust order by customers_id";

replace with:

Code:

  if ($searchemail){
		$passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from $passchangeCust WHERE customers_email_address='$searchemail'";
  }else{
		$passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from $passchangeCust order by customers_id";
  }

It is quick and dirty, does not take into account languages etc but works for me.

Enjoy:

**badbod** · 5 Dec 2012, 08:54 AM

ouch, forgot the security check, the first part of the post above should read

after the line:

Code:

$action = (isset($_GET['action']) ? $_GET['action'] : '');

add:

Code:

$searchemail = (isset($_POST['email']) ? $_POST['email'] : '');
$searchemail = zen_db_prepare_input($searchemail);

**badbod** · 5 Dec 2012, 09:04 AM

Originally Posted by dbltoe

The idea in Post #7 is probably a better way BUT I would use the Encrypted Master Password mod for 1.5.0 versus the older master password mod.

It does not work for me, using the master password for 'old password' gives 'bad old password' error. Hence the last 2 posts from me with how to add search to the excellent tool provided by Lebrand2006.

I prefer this method anyway rather than editing core files. Makes upgrades a nightmare when you have to go find all your core file mods and apply them to upgrades.