From: Dobrica Pavlinusic Date: Fri, 27 Jan 2012 10:54:47 +0000 (+0100) Subject: fix currency exchange rates X-Git-Url: http://git.rot13.org/?p=koha.git;a=commitdiff_plain;h=087f058706ea0c21d906c8d69ee9a505b14e82e9 fix currency exchange rates --- diff --git a/misc/cronjobs/hnb.pl b/misc/cronjobs/hnb.pl index 3664d511c6..00d68f4ea8 100755 --- a/misc/cronjobs/hnb.pl +++ b/misc/cronjobs/hnb.pl @@ -20,9 +20,11 @@ while(<>) { my ( $sifra, $oznaka, $broj, $kupovni, $srednji, $prodajni ) = unpack 'A3A3A3A15A15A15', $_; warn "$sifra|$oznaka|$broj|$kupovni|$srednji|$prodajni|\n"; + my $tecaj = $srednji / $broj; + print qq{ - INSERT INTO currency SET currency='$oznaka',symbol='$oznaka',rate=$srednji,active=0 - ON DUPLICATE KEY UPDATE rate=$srednji ; + INSERT INTO currency SET currency='$oznaka',symbol='$oznaka',rate=$tecaj,active=0 + ON DUPLICATE KEY UPDATE rate=$tecaj ; }; }