Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

admin password v1.43


margegunderson

Recommended Posts

Hi all,

 

I need to change my admin password, but there doesn't seem to be a nice easy password change function in the backend. We are running v1.43 which seems to have a different admin p/w feature compared to later versions. The admin section in 1.43 is not protected via htaccess/htpasswd.

 

The login script runs the following sql which may give you a better idea of the DB infastructure.

 

$sQuery = "SELECT ID, MD5(UNIX_TIMESTAMP() + ID + RAND(UNIX_TIMESTAMP())), sGUID FROM administrator WHERE (sName = '$psName') AND (sPassword = password('$psPassword'))";

 

Any ideas will be appreciated. I've tried to insert a new record in the DB with the following sql, but had no luck. Anyone got a simple way to change the password.

 

INSERT INTO administrator (`sName`,`sPassword`) VALUES ('username', MD5('password'))

Link to comment
Share on other sites

version 1.43 of what?

 

Apologies it doesnt actually have a version number. It just says:

 

E-Commerce Engine Copyright © 2005 osCommerce

 

If it helps, the relevant db table schema is as follows:

 

administrator (ID, sName, sPassword, sGUID, sData)

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...