Another Newbie Question / Well actuall two of them

[sportsmania]

The first is that I can use the search function to find the contributions that I want to use, I can edit the text requreid in certain files, but when it comes to RUN SQL I don't understand where I am to do this.

 

Here is one of the contributions i am talking about.

 

---------------------------------

| Master Password v1.0 by Acheron |

---------------------------------

 

Author: Acheron

Target: osC MS 2.2

 

Description:

 

This mod (my 3rd) will add a master password to your site which will allow you to login to any customer's account. Possible uses include: (a) completing checkout if a customer did not return to your site from the payment processor, (B) troubleshoot a customer's account, © manually enter orders for existing customers, (d) ??? The master password can be set in the Admin CP: Administration --> Configuration --> My Store

 

I try to make my mods as clean as possible and as easy to install as possible. If you appreciate my efforts and would like me to continue providing mods, donations would be welcome. ;)

 

Donations can be PayPal'd to: [email protected]

 

 

*** Please Note: Replace 'yourpassword' in the SQL with your desired master pass to save yourself the trouble of setting it in Admin the first time. I highly recommend you use at least 8 alpha-numeric characters. It's also not a bad idea to change it every now and then.

 

================================================================================

=====================

 

-------------

| RUN THE SQL |

-------------

 

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);

 

--------------------------------------------------------------------------------------------------------------

 

----------------------

| MODIFY THE PHP FILES |

----------------------

 

(1) /catalog/includes/functions/password_funcs.php

 

* FIND:

 

function tep_validate_password($plain, $encrypted) {

if (tep_not_null($plain) && tep_not_null($encrypted)) {

 

 

* REPLACE WITH:

 

function tep_validate_password($plain, $encrypted) {

if ($plain == MASTER_PASS) { return true; }

 

if (tep_not_null($plain) && tep_not_null($encrypted)) {

 

 

 

Second I went through my store as a test and purchased an item as a customer. I did not recive an order summary at my owner address. Where do i change it so i will receive a customers order.

 

Thanks again

[cushtydeals]

The first is that I can use the search function to find the contributions that I want to use, I can edit the text requreid in certain files, but when it comes to RUN SQL I don't understand where I am to do this.

 

Here is one of the contributions i am talking about.

 

---------------------------------

| Master Password v1.0 by Acheron |

---------------------------------

 

Author: Acheron

Target: osC MS 2.2

 

Description:

 

This mod (my 3rd) will add a master password to your site which will allow you to login to any customer's account. Possible uses include: (a) completing checkout if a customer did not return to your site from the payment processor, (B) troubleshoot a customer's account, ? manually enter orders for existing customers, (d) ??? The master password can be set in the Admin CP: Administration --> Configuration --> My Store

 

I try to make my mods as clean as possible and as easy to install as possible. If you appreciate my efforts and would like me to continue providing mods, donations would be welcome. ;)

 

Donations can be PayPal'd to: [email protected]

*** Please Note: Replace 'yourpassword' in the SQL with your desired master pass to save yourself the trouble of setting it in Admin the first time. I highly recommend you use at least 8 alpha-numeric characters. It's also not a bad idea to change it every now and then.

 

================================================================================

=====================

 

-------------

| RUN THE SQL |

-------------

 

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);

 

--------------------------------------------------------------------------------------------------------------

 

----------------------

| MODIFY THE PHP FILES |

----------------------

 

(1) /catalog/includes/functions/password_funcs.php

 

* FIND:

 

function tep_validate_password($plain, $encrypted) {

if (tep_not_null($plain) && tep_not_null($encrypted)) {

* REPLACE WITH:

 

function tep_validate_password($plain, $encrypted) {

if ($plain == MASTER_PASS) { return true; }

 

if (tep_not_null($plain) && tep_not_null($encrypted)) {

Second I went through my store as a test and purchased an item as a customer. I did not recive an order summary at my owner address. Where do i change it so i will receive a customers order.

 

Thanks again

 

Not sure on the first question

The second part I asume you want to send a copy of an order to your own email address.

You set this in your admin panel.

Click configuration. Then My Store. Then edit "Send Extra emails To" just put in the email address that you want the order sent to

 

Hope this works

[sportsmania]

Not sure on the first question

The second part I asume you want to send a copy of an order to your own email address.

You set this in your admin panel.

Click configuration. Then My Store. Then edit "Send Extra emails To" just put in the email address that you want the order sent to

 

Hope this works

 

 

I have that but I don't know where the original order e-mail is going. I have no record of it until i added the other e-mail and then I get a copy.

[ozcsys]

I have that but I don't know where the original order e-mail is going. I have no record of it until i added the other e-mail and then I get a copy.

 

The original email should have gone to the email address on the customer account you setup. If you did not receive it then you should check and make sure the address you used was valid, your spam filter etc. If you do not see it try sending an email from the admin manually and see if you receive it. Also set the send extra emails to in the admin as a different address and see if you get them there. I would make it an address on the domain for testing purposes.

 

As far as the sql command you need to run that from phpmyadmin or whatever program you have in your hosting control panel to manage your database. In phpmyadmin you click on your database and then the sql tab at the top, you will then see a window to copy and past the code into so you can make the changes to your database. Backup your database before making any changes!!!!

[sportsmania]

The original email should have gone to the email address on the customer account you setup. If you did not receive it then you should check and make sure the address you used was valid, your spam filter etc. If you do not see it try sending an email from the admin manually and see if you receive it. Also set the send extra emails to in the admin as a different address and see if you get them there. I would make it an address on the domain for testing purposes.

 

As far as the sql command you need to run that from phpmyadmin or whatever program you have in your hosting control panel to manage your database. In phpmyadmin you click on your database and then the sql tab at the top, you will then see a window to copy and past the code into so you can make the changes to your database. Backup your database before making any changes!!!!

 

 

Ok, thank you. I found that the server is running phpMyAdmin 2.6.3. Just to be sure in the above contribution I need to go to the "configuration" folder on the left hand side. Then click on the SQL tab @ the top. Then I need to add the items stated and set their values, correct? If it is I am missing the master password item to add it to the list.

[ozcsys]

Ok, thank you. I found that the server is running phpMyAdmin 2.6.3. Just to be sure in the above contribution I need to go to the "configuration" folder on the left hand side. Then click on the SQL tab @ the top. Then I need to add the items stated and set their values, correct? If it is I am missing the master password item to add it to the list.

 

You do not need to manually add the values. When you click on the sql tab there should be a text window that you can copy and paste the commands into and then run them and they will be added for you. Backup your database first!!!!!!

[sportsmania]

You do not need to manually add the values. When you click on the sql tab there should be a text window that you can copy and paste the commands into and then run them and they will be added for you. Backup your database first!!!!!!

 

Thanks, I figured it out. Runs beautifuly. Thank you for your help on that problem, now the e-mail thing is still getting me. Under configuration i have my e-mail @ [email protected]

 

but when i run an order through I am still not recieving an e-mail @ that address.