need to reset secure connections

Store Builder Questions
1

How can I reset the following options so they are all DISABLED from outside of the admin area? I cannot access admin so I need to be able to do it from the configuration files.



Enable secure connection at checkout (SSL certificate is required to be installed on your server)

Enable secure connection in the administration panel (SSL certificate is required to be installed on your server)

Enable secure connection for authentication, profile and orders pages (SSL certificate is required to be installed on your server)

Keep HTTPS connection once a secure page is visited



Please help… my site is basically down!!! :frowning:

2

You can run these queries using phpmyadmin to turn off those settings


UPDATE `cscart_settings` SET value='N' WHERE option_name='secure_admin';
UPDATE `cscart_settings` SET value='N' WHERE option_name='secure_auth';
UPDATE `cscart_settings` SET value='N' WHERE option_name='secure_checkout';

3

Great, thank you, but I’m not sure what phpmyadmin is and how to use?

4

This should work if you don’t know how to run queries



Copy this code below and paste it to notepad then save it as filename.php (make sure it retains the php extention).

Upload it to your store directory

Point your browser to yourdomain.com

```php
define('AREA', 'C');
define('AREA_NAME' ,'customer');
define('NO_SESSION', true);
require './prepare.php';
require './init.php';

db_query("UPDATE cscart_settings SET value = 'N' WHERE option_id = 10003");
db_query("UPDATE cscart_settings SET value = 'N' WHERE option_id = 10004");
db_query("UPDATE cscart_settings SET value = 'N' WHERE option_id = 7147");

?> ```

This will disable all 3 SSL settings



[COLOR=“Red”]Be sure to delete this file when done[/COLOR]