Execute("SELECT seg.segmentid, seg.tipid, css.css, sad.sadrzaj_$lg sadrzaj FROM segment seg, sadrzaj sad, css css WHERE seg.cssid = css.cssid AND seg.segmentid = sad.segmentid AND seg.stranaid = $str AND seg.sektorid = 1 ORDER BY segmentid") or die($infosystem->ErrorMsg()); $levo = $infosystem->Execute("SELECT seg.segmentid, seg.tipid, css.css, sad.sadrzaj_$lg sadrzaj FROM segment seg, sadrzaj sad, css css WHERE seg.cssid = css.cssid AND seg.segmentid = sad.segmentid AND seg.stranaid = $str AND seg.sektorid = 2 ORDER BY segmentid") or die($infosystem->ErrorMsg()); $gore = $infosystem->Execute("SELECT seg.segmentid, seg.tipid, css.css, sad.sadrzaj_$lg sadrzaj FROM segment seg, sadrzaj sad, css css WHERE seg.cssid = css.cssid AND seg.segmentid = sad.segmentid AND seg.stranaid = $str AND seg.sektorid = 3 ORDER BY segmentid") or die($infosystem->ErrorMsg()); $centar = $infosystem->Execute("SELECT seg.segmentid, seg.tipid, css.css, sad.sadrzaj_$lg sadrzaj FROM segment seg, sadrzaj sad, css css WHERE seg.cssid = css.cssid AND seg.segmentid = sad.segmentid AND seg.stranaid = $str AND seg.sektorid = 4 ORDER BY segmentid") or die($infosystem->ErrorMsg()); $dole = $infosystem->Execute("SELECT seg.segmentid, seg.tipid, css.css, sad.sadrzaj_$lg sadrzaj FROM segment seg, sadrzaj sad, css css WHERE seg.cssid = css.cssid AND seg.segmentid = sad.segmentid AND seg.stranaid = $str AND seg.sektorid = 5 ORDER BY segmentid") or die($infosystem->ErrorMsg()); $desno = $infosystem->Execute("SELECT seg.segmentid, seg.tipid, css.css, sad.sadrzaj_$lg sadrzaj FROM segment seg, sadrzaj sad, css css WHERE seg.cssid = css.cssid AND seg.segmentid = sad.segmentid AND seg.stranaid = $str AND seg.sektorid = 6 ORDER BY segmentid") or die($infosystem->ErrorMsg()); $footer = $infosystem->Execute("SELECT seg.segmentid, seg.tipid, css.css, sad.sadrzaj_$lg sadrzaj FROM segment seg, sadrzaj sad, css css WHERE seg.cssid = css.cssid AND seg.segmentid = sad.segmentid AND seg.stranaid = $str AND seg.sektorid = 7 ORDER BY segmentid") or die($infosystem->ErrorMsg()); $maxDatum = $infosystem->Execute("SELECT MAX(datum) poslednji FROM berza") or die($infosystem->ErrorMsg()); $maxDatum = $maxDatum->Fields("poslednji"); $datumIspis = explode("-",$maxDatum); $datum = $datumIspis[2].".".$datumIspis[1].".".$datumIspis[0]."."; $izvestaj = $infosystem->Execute("SELECT cena, obim FROM berza WHERE datum = '$maxDatum'") or die($infosystem->ErrorMsg()); function format($pok) { global $infosystem; $maxDatum = $infosystem->Execute("SELECT MAX(datum) poslednji FROM berza") or die($infosystem->ErrorMsg()); $maxDatum = $maxDatum->Fields("poslednji"); $izvestaj = $infosystem->Execute("SELECT * FROM berza WHERE datum = '$maxDatum'") or die($infosystem->ErrorMsg()); $prikaz = (strlen($izvestaj->Fields($pok))>3)?substr($izvestaj->Fields($pok),0,strlen($izvestaj->Fields($pok))-3).",".substr($izvestaj->Fields($pok),strlen($izvestaj->Fields($pok))-3,3):$izvestaj->Fields($pok); return ($prikaz); } dnevnik("poseta"); ?> TIGAR
SRPSKI      ENGLISH
EOF) { switch($header->Fields("tipid")) { case 1: ?>
">Fields("sadrzaj")?>
">Fields("sadrzaj_en")==2)?"e":""; ?> .jpg" width="150" align="right" class="Fields("cssid")?>">MoveNext(); ?> Fields("sadrzaj")?>
">Fields("sadrzaj_en")==2)?"e":""; ?> .jpg" width="300" align="center" class="Fields("cssid")?>">
Fields("sadrzaj")); break; } $header->MoveNext(); } ?>
EOF) { switch($levo->Fields("tipid")) { case 1: ?>
">Fields("sadrzaj")?>
">Fields("sadrzaj")?> .jpg" width="150" align="right" class="Fields("cssid")?>">MoveNext(); ?> Fields("sadrzaj")?>
"> .jpg" width="300" align="center" class="Fields("cssid")?>">
Fields("sadrzaj")); break; } $levo->MoveNext(); } ?>
EOF) { switch($gore->Fields("tipid")) { case 1: ?>
">Fields("sadrzaj")?>
">Fields("sadrzaj")?> .jpg" width="150" align="right" class="Fields("cssid")?>">MoveNext(); ?> Fields("sadrzaj")?>
"> .jpg" width="300" align="center" class="Fields("cssid")?>">
Fields("sadrzaj")); break; } $gore->MoveNext(); } ?>
EOF) { switch($centar->Fields("tipid")) { case 1: $sdr = $centar->Fields("sadrzaj"); if(isset($_GET['search'])) { $ispis = ""; $tekst = $sdr; $tekst2 = strtolower($tekst); $src = strtolower(trim($_GET['search'])); if(strpos($tekst2,$src)>-1) { while(strpos($tekst2,$src)>-1) { $ispis .= substr($tekst,0,strpos($tekst2,$src))."".substr($tekst,strpos($tekst2,$src),strlen($src)) . ""; $ostatak = substr($tekst,strpos($tekst2,$src)+strlen($src)); $tekst = substr($tekst,strpos($tekst2,$src)+strlen($src)); $tekst2 = substr($tekst2,strpos($tekst2,$src)+strlen($src)); } $ispis .= $ostatak; } else { $ispis = $tekst; } } else { $ispis = $sdr; } ?>
">
class="sivo3">Fields("sadrzaj")==2)?"e":""; ?> .jpg" width="150" align="left" class="Fields("css")?>">MoveNext(); $sdr = $centar->Fields("sadrzaj"); if(isset($_GET['search'])) { $ispis = ""; $tekst = $sdr; $tekst2 = strtolower($tekst); $src = strtolower(trim($_GET['search'])); if(strpos($tekst2,$src)>-1) { while(strpos($tekst2,$src)>-1) { $ispis .= substr($tekst,0,strpos($tekst2,$src))."".substr($tekst,strpos($tekst2,$src),strlen($src)) . ""; $ostatak = substr($tekst,strpos($tekst2,$src)+strlen($src)); $tekst = substr($tekst,strpos($tekst2,$src)+strlen($src)); $tekst2 = substr($tekst2,strpos($tekst2,$src)+strlen($src)); } $ispis .= $ostatak; } else { $ispis = $tekst; } } else { $ispis = $sdr; } ?>
" align="center">Fields("sadrzaj")==2)?"e":""; ?> .jpg" width="400" align="center" class="Fields("cssid")?>">
Fields("sadrzaj")); break; } $centar->MoveNext(); } ?>
EOF) { switch($dole->Fields("tipid")) { case 1: ?>
">Fields("sadrzaj")?>
">Fields("sadrzaj")?> .jpg" width="150" align="right" class="Fields("cssid")?>">Fields("sadrzaj")?>
"> .jpg" width="300" align="right" class="Fields("cssid")?>">
Fields("sadrzaj")); break; } $dole->MoveNext(); } ?>
EOF) { switch($desno->Fields("tipid")) { case 1: ?>
">Fields("sadrzaj")?>
">Fields("sadrzaj")?> .jpg" width="150" align="right" class="Fields("cssid")?>">Fields("sadrzaj")?>
"> .jpg" width="300" align="right" class="Fields("cssid")?>">
Fields("sadrzaj")); break; } $desno->MoveNext(); } ?>
EOF) { switch($footer->Fields("tipid")) { case 1: ?>
">Fields("sadrzaj")?>
">Fields("sadrzaj")?> .jpg" width="150" align="right" class="Fields("cssid")?>">Fields("sadrzaj")?>
"> .jpg" width="300" align="right" class="Fields("cssid")?>">
Fields("sadrzaj")); break; } $footer->MoveNext(); } ?>