Currency Update (Automatic)

[vanhorn_s]

#!/usr/bin/php 

Was used in version 4 and presumably earlier. As of version 5 it is no longer in the currency_update.php file.

That's what I figured. Do you have any insight to thie error I am getting emailed?

/home2/redsauto/public_html/currency_update.php: line 1: ?php: No such file or directory
/home2/redsauto/public_html/currency_update.php: line 2: /0: Permission denied
/home2/redsauto/public_html/currency_update.php: line 3: access-logs: command not found
/home2/redsauto/public_html/currency_update.php: line 4: syntax error near unexpected token `('
/home2/redsauto/public_html/currency_update.php: line 4: ` * Originally by Richard Fink (masterblaster) based on Zen Cart manual currency update'

It looks like the cron job isn't recognizing that it is a php file.

[Design75]

That's what I figured. Do you have any insight to thie error I am getting emailed?


It looks like the cron job isn't recognizing that it is a php file.

Can you past the contents of your currency_update.php? I suspect you are missing some characters at the start of the file

[vanhorn_s]

Can you past the contents of your currency_update.php? I suspect you are missing some characters at the start of the file

<?php
/*
 * Automatic Currency Update v5.0
 * Originally by Richard Fink (masterblaster)  based on Zen Cart manual currency update
 * updated by Kuroi to include Zen Cart's currency uplift ratio
 * further updated by Kuroi to use European Central Bank reference rates  (adapted from ECB-supplied code)
 * updated by Zen4All (design75) use Zen Cart standard coding
 *
 * Rework for PHP 5.3 compatibility (ereg and mysql_db_query functions deprecated in PHP 5.3.0)
 * switched to using SimpleXML and mysqli instead.
 * JeRo www.jero.co.nz 18/06/2010
 *
 * license: GNU Public License V2.0
 *
 */

require_once('includes/application_top.php');
/*
 *  Get default currency.
 */
$defaulCurrency = $db->Execute("SELECT configuration_value
                                FROM " . TABLE_CONFIGURATION . "
                                WHERE configuration_key = 'DEFAULT_CURRENCY' LIMIT 1 ");

/* 
 * Get currency conversion ratio.
 */
$currencyUpliftRatio = $db->Execute("SELECT configuration_value
                                     FROM " . TABLE_CONFIGURATION . "
                                     WHERE configuration_key = 'CURRENCY_UPLIFT_RATIO' LIMIT 1 ");

/*
 * Create new SimpleXML element from the Euro zone file
 * If your PHP configuration does not have allow_url_fopen, you may need to
 * write a script to pick it up using wget:
 * wget -O eurofxref-daily.xml www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml
 * and then uncomment/comment these next two lines:
 * $xml = new SimpleXMLElement(file_get_contents("eurofxref-daily.xml"));
 */
$xml = new SimpleXMLElement(file_get_contents("http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml"));

/*
 * extract your preferred currency's exchange rate.
 */
$nzd = $xml->xpath("//*[@currency='" . $defaulCurrency->fields['configuration_value'] . "']");
$base = (float)$nzd[0]['rate'];

# If our default currency is the Euro, it won't be in the XML,
# so set the base exchange rate to 1
if ($defaulCurrency->fields['configuration_value'] == 'EUR') {
  $base = (float)1;
}

/*
 * Get array of currency data from the XML file.
 */
$currencies = $xml->xpath("//*[@currency]");

/*
 *  Iterate over array, pulling out currency code and rate.
 * Convert into your preferred currency.
 * Pump it into the database.
 */
foreach ($currencies as $curr) {
  $cc = $curr[0]['currency'];
  $rr = (float)$curr[0]['rate'] * $currencyUpliftRatio->fields['configuration_value'];
  $new = $rr / $base;
/*
 * But don't uplift your default currency!
 */
  if ($cc != $defaulCurrency->fields['configuration_value']) {
    $sql_data_array = array('value' => $new,
                            'last_updated' => 'now()',
                            'code' => $cc);
    zen_db_perform(TABLE_CURRENCIES, $sql_data_array, 'update', "code = '" . $cc . "'");
  }
}

/*
 * Feed is based on the Euro, which is not included in the feed,
 * therefore we need to update it manually,
 * unless of course our preferred currency is the Euro
 */
$cc = 'EUR';
$rr = 1 / $base * CURRENCY_UPLIFT_RATIO;
if ($defaulCurrency->fields['configuration_value'] != $cc) {
  $sql_data_array = array('value' => $rr,
                          'last_updated' => 'now()',
                          'code' => $cc);
  zen_db_perform(TABLE_CURRENCIES, $sql_data_array, 'update', "code = '" . $cc . "'");
}

[s_mack]

The error YOU yourself postd:

/home2/redsauto/public_html/currency_update.php: line 1: ?php: No such file or directory

Seemingly indicates that line 1 is missing the very first character... the "<" before "?php".

You said you upgraded to V6 (my code) but you just posted code from V5.

I *think* what you did was copy all but the first character from my code.

[vanhorn_s]

The error YOU yourself postd:

/home2/redsauto/public_html/currency_update.php: line 1: ?php: No such file or directory

Seemingly indicates that line 1 is missing the very first character... the "<" before "?php".

You said you upgraded to V6 (my code) but you just posted code from V5.

I *think* what you did was copy all but the first character from my code.

The v6 was a typo. I meant v5. I downloaded the latest one last week from here: https://www.zen-cart.com/downloads.php?do=file&id=286
I did not edit it, I only uploaded the file as I downloaded it. What I posted above, is the contents of that file.

[gprit]

Should this work with Zencart v 1.5.6 and PHP v8.0?

I ran it through a PHP tester and got the following:
Warning: require_once(): open_basedir restriction in effect. File(includes/application_top.php) is not within the allowed path(s): (/var/tmp/) in /tmp/31yrgpkae1ktco5pkq/tester.php on line 17 Warning: require_once(includes/application_top.php): Failed to open stream: Operation not permitted in /tmp/31yrgpkae1ktco5pkq/tester.php on line 17 Fatal error: Uncaught Error: Failed opening required 'includes/application_top.php' (include_path='.:') in /tmp/31yrgpkae1ktco5pkq/tester.php:17 Stack trace: #0 {main} thrown in /tmp/31yrgpkae1ktco5pkq/tester.php on line 17

[jtlswan]

Anyone have an updated version for 1.5.8 (1.5.8a)? or will this current version 5.0 work with it?

[torvista]

As mentioned on the plugin page, this is now built-in:

NOTE: In Zen Cart 1.5.5 and above, the admin/currency_cron.php facility can be used.