FX currency factor for SAR and XDR is 1

-- url of the page with the problem -- : shop.smartgart.com
-- HikaShop version -- : 2.6.3
-- Joomla version -- : 3.5.1
-- PHP version -- : 5.5
-- Browser(s) name and version -- : Chrome
-- Error-message(debug-mod must be tuned on) -- : SAR 1
XDR 1

Hi, I am running HikaShop Business on default currency Euro and consume hourly currency (FX) updates.

Looking into ... > Hikashop > Configuration > System > Currency, I am successfully using CHF, USD and other major currencies. But it looks like as if SAR (Saudi Ryial) and XDR (IMF special drawing rights) are not updated because they stand on 1 (rather than a meaningful fractional number).

Perhaps they can be included in the future because I am targeting Arabic clients, and XDR is useful for customs declarations (the 300 XDR limit for CN 23 exports).

best regards

Klaus

Thanks Nicolas - I overlooked your answer by the time, became silly and coded a little workaround (and probably re-invented the wheel) and now directly insert into the database from a php page that is hourly called from a cron-job. Yahoo has all those exotic currencies; unfortunately PayPal does not handle them. Your suggestion is perfect.

best regards

Klaus

wget "http://www.....com/import/fx-xdr.php" -O /dev/null -o /dev/null

fx-xdr.php:

<?php
$content = file_get_contents('http://download.finance.yahoo.com/d/quotes.csv?s=EURXDR=X&f=nab');

$tok = explode(',', $content);

$fx = 0.1; // chose low value as default (currently roundabout 0.8)
if($tok[1] > 0 && $tok[2] > 0) $fx = ($tok[1] + $tok[2]) / 2;
else if($tok[1] > 0) $fx = $tok[1];
else if($tok[2] > 0) $fx = $tok[2];

$time = time();

$mysqli = new MySQLi("localhost", ...);
if($mysqli->connect_errno) printf("%d: %s<br>/n", $mysqli->connect_errno, $mysqli->connect_error);
$update = "UPDATE joomla_hikashop_currency SET currency_rate = '$fx', currency_modified = '$time' WHERE currency_code = 'XDR'";

if ($mysqli->query($update) === TRUE) {
	echo "Record updated successfully";
} else {
	echo "Error updating record: " . $mysqli->error;
}
?>