connect();
$db->query("
select
id
from
toolovi
where
ime = \"kursnalista\"
");
if (mysql_num_rows($db->rs) != 0) {
$valute = array(
"EUR" => "Euro",
"AUD" => "Australijski Dolar",
"CAD" => "Kanadski Dolar",
"HRK" => "Hrvatska Kuna",
"SIT" => "Slovena[ch]ki Tolar",
"BAM" => "Bosanska Konveribilna Marka",
"CHF" => "[SH]vajcarski Franak",
"GBP" => "Britanska Funta",
"USD" => "Ameri[ch]ki Dolar"
);
$odnosi = array(
"EUR" => "1",
"AUD" => "1",
"CAD" => "1",
"HRK" => "1",
"SIT" => "100",
"BAM" => "1",
"CHF" => "1",
"GBP" => "1",
"USD" => "1",
);
$db->query("
select
eur, aud, cad, hrk, sit, bam, chf, gbp, usd
from
kurslista
where datum = NOW()
");
if (mysql_num_rows($db->rs) != 0) {
$row = mysql_fetch_object($db->rs);
$eur = $row->eur;
$aud = $row->aud;
$cad = $row->cad;
$hrk = $row->hrk;
$sit = $row->sit;
$bam = $row->bam;
$chf = $row->chf;
$gbp = $row->gbp;
$usd = $row->usd;
}
else
{
$currentDate = date("ymd"); //060818
$address = "http://www.nbs.yu/serbian/kursevi/ascii/Kl".$currentDate.".asc";
$file = @fopen($address, "r");
if (!$file) {
$db->query("
select
eur, aud, cad, hrk, sit, bam, chf, gbp, usd
from
kurslista
order by
datum desc
limit 1
");
$row = mysql_fetch_object($db->rs);
$eur = $row->eur;
$aud = $row->aud;
$cad = $row->cad;
$hrk = $row->hrk;
$sit = $row->sit;
$bam = $row->bam;
$chf = $row->chf;
$gbp = $row->gbp;
$usd = $row->usd;
}
else
{
$counter = 0;
while (!feof ($file)) {
$line = fgets ($file, 1024);
$counter ++;
if ($counter==1) // AUD
{
$valuesArray = explode(";", $line);
$aud = $valuesArray[9];
}
if ($counter==4) // CAD
{
$valuesArray = explode(";", $line);
$cad = $valuesArray[9];
}
if ($counter==5) // HRK
{
$valuesArray = explode(";", $line);
$hrk = $valuesArray[9];
}
if ($counter==21) // SIT
{
$valuesArray = explode(";", $line);
$sit = $valuesArray[9];
}
if ($counter==24) // CHF
{
$valuesArray = explode(";", $line);
$chf = $valuesArray[9];
}
if ($counter==25) // GBP
{
$valuesArray = explode(";", $line);
$gbp = $valuesArray[9];
}
if ($counter==26) // USD
{
$valuesArray = explode(";", $line);
$usd = $valuesArray[9];
}
if ($counter==27) // BAM
{
$valuesArray = explode(";", $line);
$bam = $valuesArray[9];
}
if ($counter==28) // EUR
{
$valuesArray = explode(";", $line);
$eur = $valuesArray[9];
}
}
$db->query("
insert into
kurslista
(
datum, eur, aud, cad, hrk, sit, bam, chf, gbp, usd
)
values
(
\"".date("Y-n-j")."\", ".$eur.", ".$aud.", ".$cad.", ".$hrk.", ".$sit.", ".$bam.",".$chf.", ".$gbp.", ".$usd."
)
");
fclose($file);
}
}
?>
" border="0"> 
" border="0"> 
" border="0"> 
" border="0"> 
" border="0"> 
" border="0"> 
" border="0"> 
" border="0"> 
" border="0">