Admin Login by Asienka

[verminha]

:huh:

I was surprised that the administration of my web shop can be done by anyone knowing the right address. Fortunately, I found an Admin Login extra files on your Contribution list. But I encountered a problem while installing it. Now I can't access my administration page at all. I'm getting a warning page like this below:

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/int2000/a/7187/html/catalog/admin/adminProcesslogin.php on line 13

 

Warning: Cannot modify header information - headers already sent by (output started at /www/int2000/a/7187/html/catalog/admin/adminProcesslogin.php:13) in /www/int2000/a/7187/html/catalog/admin/adminProcesslogin.php on line 22

[joeabouata]

I'm having this problem too. The instructions are unclear on step one as to what the PHP file should be called, and where it should be saved to! Anyone have a solution??

[verminha]

I think you have to modify the database with a PROGRAM called phpmyadmin or similar software. I was using MySQL-Front for that but I don't know if it went right through to the database. The program gave lots of errors but then I could see the login and password in the database table called "admin" in the end... but still I get the error/warning as described above in my first letter. <_<

[joeabouata]

I downloaded the program, but I'm lost as to what is the next step!! help

[verminha]

Sorry for taking time to answer. I'm about to give a birth soon and that's why my thoughts are a bit elsewhere than in this web shop.

I managed to make a password protection by making a .htaccess file in the server. If you don't know how to make that, You should make it according to the advices of your server administrator.

 

If you wanna still try the Admin Login by Asienka:

How the MySQL-Front works, it is still a bit mystery to me since it makes so many errors... atleast in my computer. Of course first you need to put your SQL server settings in MySQL (the database name, your username etc from your server should be the same than for OsCommerce installation asked from you).

After connected to your host, you see a list of your SQL tables made by OsCommerce installation. Now you should ad one table to those (table called "admin"): You have to first paste the first part of the text (Create table) to the SQL Query field. On the bottom of the program screen you should see if it resulted with errors or ok. If there's no errors you should see in the list of tables (Tab called Database) also the table "admin".

Now you can paste the same way to the SQL Query the rest of the code (Insert into etc.) and it should insert the username and password for the database. In the place of values ('Admin', 'Admin') you could put something else than the original username and password since it should be only you who knows them.

 

Tell, if you manage! :)