Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Admin Login Contribution


Guest

Recommended Posts

I'm going to install the Admin Login Contribution. Which file and where in catalog/admin do I place the cut and paste sql from admin.sql file ? Does this contribution work?

 

CREATE TABLE `admin` (

`ID` INT NOT NULL AUTO_INCREMENT ,

`Login` VARCHAR( 50 ) NOT NULL ,

`Password` VARCHAR( 50 ) NOT NULL ,

PRIMARY KEY ( `ID` )

);

 

INSERT INTO `admin` ( `ID` , `Login` , `Password` )

VALUES (

'', 'Admin', 'Admin'

);

Link to comment
Share on other sites

  • 4 weeks later...

I am having the same problem. :(

 

I am using the Admin Login Contribution because I have to password protect my admin directory because my host dosent have cpanel.

 

The directions are:

 

1. Cut and paste sql from admin.sql file into phpmyadmin or in similar fashion.

2. Copy application_top.php and header.php into \catalog\admin\includes folder

3. Copy adminLogin.php, adminProcesslogin.php and adminLogout.php into \catalog\admin\

 

I have 2 and 3 taken care of. But I do not understand 1 at all. Where am I suposted to put the admin.sql file?

 

Thanks,

Jason :)

Link to comment
Share on other sites

The cut and paste sql is meant to be added to your database

startup phpMyAdmin in the left hanf window select the database, then in the right hand window click on the SQL tab in the window paste your text thet is for cut and paste or select browse locate the sql file on your local machine and click on go

 

job done

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Ok, I did that and it made the tabel "admin" and I can change the user and password. But....whenever I try to log into my store "/catalog/admin" it brings up the password box, I put in the correct password, but it says "invalid username or password". Can anyone help me?

 

Thanks, Jason :)

Edited by Jason Hilton
Link to comment
Share on other sites

Try to change in adminProcesslogin.php in:

 

$SQL="SELECT * FROM Admin WHERE Login = '".strtolower($Login)."' and Password = '".$Password."'";

 

 

from Admin to admin (small a!)

 

(or in the admin.sql should be changed to Admin prior dump!)

 

 

 

Give this a try, it worked for me.

Jerry

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...