Cron Job

[frank18]

fortunately it works.
wget -O - www.xxxxxx/xxxxx/adminxxx/store_status.php
add... define('CRON_ADMIN_USER_ID', '1');

but :)

if store status 2= Showcase with prices, it change 1= Showcase no prices
if store status 0= Normal Store, its change 1= Showcase no prices again
if store status 1= Showcase no prices, its not changing

That indicates that the script is working as per configuration:

if ((date(H) >= $store_open) && (date(H) <= $store_close)) {
$zen_store_stat = 0; // Store is Open Normal Zen Cart
} else {
$zen_store_stat = 1; // Store is Closed Showcase no Prices
} 

If you wanted store status = 2 then you would need to set

$zen_store_stat = 2; // Store is Closed Showcase with prices 

[Cenkki]

It doesn't change store status open (0), with all combination.

[Cenkki]

I forget add that code also...

admin/init_includes/init_admin_auth.php

if (!isset($_SESSION['admin_id']) && defined('CRON_ADMIN_USER_ID') && (int)CRON_ADMIN_USER_ID != 0) {
$_SESSION['admin_id'] = CRON_ADMIN_USER_ID;
}

[frank18]

It doesn't change store status open (0), with all combination.

Played with this on a local install. I changed

if ((date(H) >= $store_open) && (date(H) <= $store_close)) { 

to

if ((date('H:i:s') >= $store_open) && (date('H:i:s') <= $store_close)) { 

and it appears to work

[Cenkki]

You know this work.
Thanks

[frank18]

You know this work.
Thanks

Good to see that you got this working for you now.

Cheers / Frank

[yesaul]

Hello,

The described solution works, but I found out, it causes the following PHP Warning (in case the sctipt is being executed by cron, not from Admin):

PHP Warning: include() [<a href='function.include'>function.include</a>]: Failed opening 'includes/languages/english/' for inclusion (include_path='.:/usr/lib64/php:/usr/share/pear') in /.../admin/includes/init_includes/init_languages.php on line 38

Here is the appropriate part of init_languages.php (strings 34...39):

// include the language translations
  require(DIR_WS_LANGUAGES . $_SESSION['language'] . '.php');
  $current_page = basename($PHP_SELF);
  if (file_exists(DIR_WS_LANGUAGES . $_SESSION['language'] . '/' . $current_page)) {
    include(DIR_WS_LANGUAGES . $_SESSION['language'] . '/' . $current_page);
  }

I have found out, the $SERVER['PHP_SELF'] is an empty string (in case the script is being executed by cron!), thus $current_page is also empty.

How such issue can be fixed?

Thank you in advance and best regards,

AR

[frank18]

Hello,

The described solution works, but I found out, it causes the following PHP Warning (in case the sctipt is being executed by cron, not from Admin):



Here is the appropriate part of init_languages.php (strings 34...39):

// include the language translations
  require(DIR_WS_LANGUAGES . $_SESSION['language'] . '.php');
  $current_page = basename($PHP_SELF);
  if (file_exists(DIR_WS_LANGUAGES . $_SESSION['language'] . '/' . $current_page)) {
    include(DIR_WS_LANGUAGES . $_SESSION['language'] . '/' . $current_page);
  }

I have found out, the $SERVER['PHP_SELF'] is an empty string (in case the script is being executed by cron!), thus $current_page is also empty.

How such issue can be fixed?

Thank you in advance and best regards,

AR

Take a look at this plugin - created after reading through this thread.

Cheers / Frank

[frank18]

......
The described solution works, but I found out, it causes the following PHP Warning (in case the sctipt is being executed by cron, not from Admin):...

Considering your installation works when the script is executed from admin, take a look at the readme.html file contained in the ASOC plugin. The 'Configuration' tab in that file says:

Configuration

1. Login to your cPanel (or similar installation)
2. Go to Cron TabsCreate 2 new cron jobs and enter these configurations (or equivalent)
   
   • 00 9 * * * wget http://yourdomain.com/YOUR_ADMIN/aut...open_close.php >/dev/null 2>&1
     
     30 22 * * * wget http://yourdomain.com/YOUR_ADMIN/aut...open_close.php >/dev/null 2>&1
   
   These times need to be adjusted to reflect your actual opening closing times.
   

Do you still get the error when you use the suggested lines in the cron tab?