Community Forums

by **JAY6390** » Tue Jun 08, 2010 12:39 am

Want something similar in a vQmod? Check this thread out

After seeing a thread earlier asking how to reset their admin password I thought I'd create a little app that hopefully will be useful when people get stuck. It's taken from my Wordpress admin reset file I made a while back, with just a few tweaks to allow resetting OC passwords - It's actually taken me more time to write this post than to code it

Instructions for use
1. Either download the file here or copy the source code below and save it to a file called ocreset.php in your store's directory (The same one as the .htaccess/.htaccess.txt file)
2. Run the file through your browser by visiting your site's store address followed by ocreset.php, so for a localhost in a directory called shop it would be

Code: Select all: http://localhost/shop/ocreset.php

- for your domain in the root directory just use

Code: Select all: http://www.yoursite.com/ocreset.php

3. You should now see a screen with the following on it, and in the dropdown should be a list of your site administrators

4. Select your administrator name you want to reset, type your password in the password field and click "Change Password"
5. If all went well a message should appear at the top of the screen with

Code: Select all: User `admin` updated successfully!

where admin is the name of the user you've just reset
6. Once you've reset your password MAKE SURE YOU DELETE THE OCRESET.PHP FILE from your server, to avoid anyone gaining unauthorised access to your store

For those interested, here's the source code with commenting. If anyone has any suggestions for improvement or bugs please let me know

Code: Select all: <?php // Load config include('config.php'); // Connect to database mysql_connect(DB_HOSTNAME, DB_USERNAME, DB_PASSWORD) or die('ERROR CONNECTING TO SERVER'); mysql_select_db(DB_DATABASE) or die('ERROR SELECTING TABLE'); // Get list of active adminstrators $query = "SELECT user_id, username FROM ".DB_PREFIX."user WHERE user_group_id = '1' AND status = '1'"; $result = mysql_query($query); if(!$result) { echo 'ERROR WITH QUERY: '.mysql_error().'<br />'; die($query); } while($r = mysql_fetch_assoc($result)) { $users[$r['user_id']] = $r['username']; } // Form has been submitted if(isset($_POST['ID'])) { // Clean up password field and make sure it has a value $pass = trim($_POST['password']); if($pass == '') { $info = 'ERROR: Password needed in order to reset'; }else{ // Update the table with the new information $query = sprintf("UPDATE ".DB_PREFIX."user SET password = '%s' WHERE user_id = '%s'", md5($pass), mysql_real_escape_string($_POST['ID'])); $result = mysql_query($query); if(!$result) { $info = 'Could not update the database<br />'.mysql_error(); }else{ $info = 'User `'.$users[$_POST['ID']].'` updated successfully!'; } } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Open Cart administrator password reset</title> <style type="text/css">  </style> </head> <body> <?php if(isset($info)) { echo "<div class=\"info\">$info</div>"; } ?> <h1>Open Cart administrator password reset</h1> <form id="frmReset" method="post" action=""> <fieldset style="border: none;"> <label for="ID" class="lbl">Administrator to reset: </label> <select name="ID" id="ID" class="input"> <?php foreach($users as $id => $username): ?> <option value="<?php echo $id; ?>"><?php echo $username; ?></option> <?php endforeach; ?> </select> <label for="password" class="lbl">New password: </label> <input type="text" name="password" id="password" class="input" /> <br /> <br /> <input class="lbl" type="submit" name="button" id="button" value="Change password"/> </fieldset> </form> </body> </html>

by **cmebd** » Tue Jun 08, 2010 5:56 am

%hanks for this - a brilliant "admin" helper........

by **JAY6390** » Tue Jun 08, 2010 10:06 am

No problem

by **Moggin** » Tue Jun 08, 2010 5:20 pm

Many thanks JAY6390. Great app, which will solve something very high up on my worry list..
Cheers

by **JAY6390** » Tue Jun 08, 2010 7:10 pm

No problem. I will be adding more once 1.4.8 is released that will be useful for installing modules more easily (if everything goes to plan), and I have another idea or two up my sleeves yet

by **clairekw** » Fri Jul 02, 2010 8:22 pm

THANK YOU!!!!!!!

YOU SAVED MY LIFE

I AM NOT TECHY BUT I COULD FOLLOW THE INSTRUCTIONS - OLISH YOUR HALO!!!

by **JAY6390** » Fri Jul 02, 2010 8:36 pm

haha no problem

by **qahar** » Sat Jul 03, 2010 12:20 pm

interesting stuff.. nice work..

by **JAY6390** » Sat Jul 03, 2010 10:15 pm

No problem

Glad it helped you!

by **JCO** » Thu Nov 11, 2010 3:46 am

Whooooooo! Thanks Jay ... I just used it!!!!!!!!

by **JAY6390** » Thu Nov 11, 2010 10:46 am

lol no problem

by **ilovekhym** » Mon Nov 22, 2010 1:23 am

Hello Guys,

I just created and submitted the script for this. You can check it here
http://www.opencart.com/index.php?route ... ion_id=879

I will upload a demo site for this later.

by **JAY6390** » Mon Nov 22, 2010 2:28 am

lol you didn't create a script fro this, you created a PAID module to allow people to reset their admin passwords from the admin login. big difference tbh

by **ilovekhym** » Tue Nov 23, 2010 1:08 am

@JAY6390 - Hello, Yes its paid and i decide to make it paid since its easy to use and is already attached to the admins interface and on the users database. you can visit the extension page and try it yourself. I already put a demo site and test account/email for that. anyway, thanks for the feedback.

by **JAY6390** » Tue Nov 23, 2010 1:21 am

It wasn't feedback, I was pointing out that you were spamming the forum. I'm well aware of the way the extension works and how, I just don't see how it's pertinent to this thread to be honest. Your extension is fine I'm sure, and should probably be part of the core