Installing Master Password

[kajunto]

I downloaded the master password contribution... can someone explain how to install it?? i am new to oscommerce so any details would be very helpful

[wheeloftime]

I downloaded the master password contribution... can someone explain how to install it?? i am new to oscommerce so any details would be very helpful

 

There is an install.txt file inside the package which explains what to do to install this contrib. With most contribs there is such installation file to guide you through the steps to perform.

[kajunto]

There is an install.txt file inside the package which explains what to do to install this contrib. With most contribs there is such installation file to guide you through the steps to perform.

 

 

I read the text file, but i still dont understand.... i know how to modify the php files, but i am not sure how to "RUN THE SQL" i am new to oscommerce and not sure what this line means:

 

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('188', 'Master Password', 'MASTER_PASS', 'yourpassword', 'This password will allow you to login to any customers account.', 1, 23, '2004-06-15 07:10:52', '2004-06-15 07:10:52', NULL, NULL);

[wheeloftime]

I read the text file, but i still dont understand.... i know how to modify the php files, but i am not sure how to "RUN THE SQL" i am new to oscommerce and not sure what this line means:

 

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('188', 'Master Password', 'MASTER_PASS', 'yourpassword', 'This password will allow you to login to any customers account.', 1, 23, '2004-06-15 07:10:52', '2004-06-15 07:10:52', NULL, NULL);

Hi Guidry,

 

When an installation speaks of running SQL (statements) it means you will have to take some actions to alter your osCommerce database structure. Before you start doing this and especially if you are failry new to all this you should make a backup of your database first ! A backup of your database you can make through the osCommerce admin interface (that you probably already know) but also through a program called phpMyAdmin which should be available through your host panel. There you can export (and import) your whole database (but easiest is through the osCommerce backup).

For running SQL statements on your database however you will need this phpMyadmin utility. So login into your host panel and look for an option to manage your database(s). Once there you should find some indication of managing database xxxyyyy and that should start the phpMyAdmin interface. Once have started phpMyAdmin you will find in the left column the name of your database on top and a whole bunch of names underneath which are all the tables which make part of your osCommerce database. Don't worry about those and just click on a tab at the upper part of the screen which says SQL.

Now you will get a screen with a larger textbox and inside that textbox you can type SQL statements or copy/paste SQL statements (preferred way :D )

 

Copy the given SQL statement from the installation instruction

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('188', 'Master Password', 'MASTER_PASS', 'yourpassword', 'This password will allow you to login to any customers account.', 1, 23, '2004-06-15 07:10:52', '2004-06-15 07:10:52', NULL, NULL);

and paste it into that textbox. Okay, now you are almost done !

On the lower right of the textbox you will spot a smaller button which says Start and you press that after you pasted the statement. The statement will now be run on your database and after a very short while (it is only one statement after all) you should see a Success message (when there is success there can also be failure but I won't speak about that now as that will not likely happen with this simple statement).

 

Congratulations ! You altered the database and have added an extra option into your admin interface. Go to your admin interface and look under Configuration/My Store. There should be a new last entry which will hold your Master Password.

 

This whole process is essentialy the same for all contributions where database alterations have to be done. After a few times this will be familiar enough, just remember to make a backup before you start in case something goes wrong.

 

I hope this clarifies it enough.

 

regards,

Howard

[kajunto]

That worked.... thanks for all the help.