Reset customer password from admin

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.

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

after the line:

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

add:

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

after the line (around line 80) :

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

add:

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

Around line 98 :

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

replace with:

  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:

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

after the line:

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

add:

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

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.

i still can't get this to work and i added the coding for 'prefixes' and still nothing. am i looking in the right place under admin/tools??

There's a recently-submitted plugin Reset Client Password from Admin that might do the trick for you (I haven't used it).

lat9:

There's a recently-submitted plugin Reset Client Password from Admin that might do the trick for you (I haven't used it).

wow - perfect - it works... seems like the same one as the one i was trying from the forum but this one has one SQL update statement and that one did not.

Glad to hear that it's working for you!

Hello,

I just installed the "reset password from admin" plugin on a 1.3.9h zencart shop ... the option shows under admin / tools but it did not work : i changed a password but it is still the old password that applies ... any suggestion ?

thanks

badbod:

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

after the line:

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

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

the search don't work: it found a blank customer.

I'm trying to setup the script also but I am running into the mySQL error.

ERROR: Cannot execute because table admin_pages(page_key, does not exist. CHECK PREFIXES!
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

I have the default zencart 1.51 and don't understand where to put whats it looking for. Can someone point me in the right direction?

Thanks

Did you install the SQL patch ?

That is the error I'm getting with the sql file that came with the plugin.

I'm having the same problem when I try to run the adminplacementv15.sql patch on ZC 1.5.1, I get:

Error ERROR: Cannot execute because table admin_pages(page_key, does not exist. CHECK PREFIXES!
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

I've tried changing the prefix to my db name, same error, only then it says MYDBNAME_admin_pages does not exist.

**Dear Jesus, FINALLY! Posting this so everyone else who has dealt with issue can fix theirs, too.

Here is the correct text for the sql**

INSERT INTO admin_pages (page_key, language_key, main_page, menu_key, display_on_menu, sort_order) VALUES ('passChange',
'BOX_TOOLS_PASSCHANGE', 'FILENAME_PASSCHANGE', 'tools', 'Y', '40');

The original one left out the space between "admin_pages" and "(page_key...)"

designsbytrina:

**Dear Jesus, FINALLY! Posting this so everyone else who has dealt with issue can fix theirs, too.

Here is the correct text for the sql**

INSERT INTO admin_pages (page_key, language_key, main_page, menu_key, display_on_menu, sort_order) VALUES ('passChange',
'BOX_TOOLS_PASSCHANGE', 'FILENAME_PASSCHANGE', 'tools', 'Y', '40');

The original one left out the space between "admin_pages" and "(page_key...)"

Thank you very much for this! After an hour of trying this was the remedy. It should probably be changed in the file before others get caught up with the same issue.

Installs on my 1.3.9h site. Admin/tools/Change Passwords appears. No search bar. I installed it on another 1.5.4 site and it works fine. Why no search box on 1.3.9h? Am I supposed to install the 1.5.* sql file for a 1.3.9h site?

charmlt:

Installs on my 1.3.9h site. Admin/tools/Change Passwords appears. No search bar. I installed it on another 1.5.4 site and it works fine. Why no search box on 1.3.9h?
Best guess is that something about the 1.3.9 code is different from the 1.5.4 code such as the name of the function to call for the search box, or the sequence of some internal variables is different. I realize not a highly technical response, but see below..
charmlt:

Am I supposed to install the 1.5.* sql file for a 1.3.9h site?

The real question is shouldn't I be upgrading a 1.3.9 site to the latest version so that when the host no longer offers PHP 5.2.17 possibly later this year that the site will still operate?

Hi there guys,

So I installed everything fine with no errors. Installed the SQL patch too, no problem there. Searched for a customer (used my testing account) and reset my password. But the new password doesn't work. Anyone else have this issue or have a solution?

Regards, Hannat

Edit:

Using: Zen Cart v1.5.4, PHP Version 5.4.33 and my DB doesn't have prefixes

Ok,

I figured out that the reason it isn't changing the password is because after hitting "Submit Query" it will find the customer but when you click on "Change Password" the page that is loaded is 'blank'. The customer is no longer selected, so typing in a password there won't do anything.

Any help here?

Regards, Hannat