--- inc/menuMED.php 2001/10/05 15:10:53 1.3 +++ inc/menuMED.php 2001/10/27 16:54:50 1.4 @@ -1,29 +1,56 @@ prepare($sql); - if (!$sth) error("Cannot prepare query: \"$sql\""); - if (!$sth->execute()) error("Cannot execute query: \"$sql\""); - $levels = array_shift($sth->fetchrow_array()); - $sth->finish(); - if (!$levels) $levels = 1; - $menu3 = array(); - for ($i = 0; $i < $levels; $i++) { - $sql = "SELECT spec_id, opis, level FROM specijalizacije WHERE (spec_id != 0) AND (NOT link) AND (level = ".($i + 1).")"; + if ($section == "knjiznica") { + $menu4 = array( + array("name" => "Liječnički vjesnik", "secmenu" => "vjesnik"), + array("name" => "Infektološki glasnik", "secmenu" => "inf_glasnik"), + array("name" => "MEDICUS", "secmenu" => "medicus"), + array("name" => "MedInfo", "secmenu" => "medinfo"), + array("name" => "Vodič za hospitalne infekcije", "secmenu" => "vodic") + ); + $tpl->assign("MENU4", $menu4); + } else if ($spec) { + $sql = "SELECT opis FROM specijalizacije WHERE (spec_id = $spec)"; $sth = $dbh->prepare($sql); if (!$sth) error("Cannot prepare query: \"$sql\""); if (!$sth->execute()) error("Cannot execute query: \"$sql\""); - $tmp = array(); - while ($row = $sth->fetchrow_array()) { - list($id2, $txt) = $row; - array_push($tmp, array("id" => $id2, "title" => MyEscape($txt))); - } + $row = $sth->fetchrow_array(); + $sth->finish(); + if ($row) $row = array_shift($row); + $tpl->assign("MENU4_title", $row); + $menu4 = array( + array("name" => "HOME", "sec" => "home"), + array("name" => "Arhiva vijesti i članaka", "sec" => "arhiva"), + array("name" => "Kalendar događanja", "sec" => "kalendar"), + array("name" => "Linkovi", "sec" => "linkovi") + ); + $tpl->assign("MENU4", $menu4); + } else { + function my_cmp2($a, $b) { return MyCompare($a["title"], $b["title"]); } + $sql = "SELECT MAX(level) FROM specijalizacije"; + $sth = $dbh->prepare($sql); + if (!$sth) error("Cannot prepare query: \"$sql\""); + if (!$sth->execute()) error("Cannot execute query: \"$sql\""); + $levels = array_shift($sth->fetchrow_array()); $sth->finish(); - usort($tmp, "my_cmp2"); - array_push($menu3, $tmp); + if (!$levels) $levels = 1; + $menu3 = array(); + for ($i = 0; $i < $levels; $i++) { + $sql = "SELECT spec_id, opis, level FROM specijalizacije WHERE (spec_id != 0) AND (NOT link) AND (level = ".($i + 1).")"; + $sth = $dbh->prepare($sql); + if (!$sth) error("Cannot prepare query: \"$sql\""); + if (!$sth->execute()) error("Cannot execute query: \"$sql\""); + $tmp = array(); + while ($row = $sth->fetchrow_array()) { + list($id2, $txt) = $row; + array_push($tmp, array("id" => $id2, "title" => MyEscape($txt))); + } + $sth->finish(); + usort($tmp, "my_cmp2"); + array_push($menu3, $tmp); + } + $MENU3_section = ($section == "home" || $section == "arhiva" || $section == "linkovi" || $section == "kalendar") ? $section : "home"; + $tpl->assign("MENU3_section", $MENU3_section); + $tpl->assign("MENU3", $menu3); } - $MENU3_section = ($section == "home" || $section == "arhiva" || $section == "linkovi" || $section == "kalendar") ? $section : "home"; - $tpl->assign("MENU3_section", $MENU3_section); - $tpl->assign("MENU3", $menu3); ?>