Guest Posted March 3, 2004 Share Posted March 3, 2004 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' ); Quote Link to comment Share on other sites More sharing options...
Jason Hilton Posted March 31, 2004 Share Posted March 31, 2004 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 :) Quote Link to comment Share on other sites More sharing options...
Jason Hilton Posted March 31, 2004 Share Posted March 31, 2004 Anyone? I really need to get this to work before I make my sitelive. :) Quote Link to comment Share on other sites More sharing options...
241 Posted March 31, 2004 Share Posted March 31, 2004 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 Quote 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! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
Jason Hilton Posted March 31, 2004 Share Posted March 31, 2004 (edited) 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 March 31, 2004 by Jason Hilton Quote Link to comment Share on other sites More sharing options...
Guest Posted March 31, 2004 Share Posted March 31, 2004 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 Quote Link to comment Share on other sites More sharing options...
Jason Hilton Posted April 1, 2004 Share Posted April 1, 2004 THANK YOU ALL SO MUCH! I finally got it to work! Thanks Again! :D Jason Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.