From 06217f25d24e3fd6c1e711bb0b7fd58527d32264 Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Fri, 27 Jan 2012 11:59:10 +0100 Subject: [PATCH] fix currency rate units larger than 1 --- hnb.pl | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/hnb.pl b/hnb.pl index 3664d51..00d68f4 100644 --- a/hnb.pl +++ b/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 ; }; } -- 2.20.1