--- inc/banneri.php	2001/10/16 13:07:03	1.4
+++ inc/banneri.php	2001/10/23 16:13:59	1.5
@@ -1,21 +1,21 @@
 <?php
-	if ($isMed && $isReg) {
-		$banneri = array(
-			// array("slika" => "gastal.gif", "alt" => "Gastal", "url" => "http://www.gastal.com.hr/"),
-			array("slika" => "tonocardin.gif", "alt" => "Tonocardin", "url" => "http://www.tonocardin.com.hr/"),
-			array("slika" => "enazil.gif", "alt" => "Enazil", "url" => "http://www.enazil.com.hr/")
-			// array("slika" => "plivitc.gif", "alt" => "Plivit C", "url" => "http://www.plivitc.com.hr/"),
-			// array("slika" => "bisolex.gif", "alt" => "Bisolex", "url" => "http://www.bisolex.com.hr/"),
-			// array("slika" => "andolc.gif", "alt" => "Andol C", "url" => "http://www.andolc.com.hr/"),
-		);
-	} else {
-		$banneri = array(
-			array("slika" => "gastal.gif", "alt" => "Gastal", "url" => "http://www.gastal.com.hr/"),
-			// array("slika" => "plivitc.gif", "alt" => "Plivit C", "url" => "http://www.plivitc.com.hr/"),
-			// array("slika" => "bisolex.gif", "alt" => "Bisolex", "url" => "http://www.bisolex.com.hr/"),
-			// array("slika" => "andolc.gif", "alt" => "Andol C", "url" => "http://www.andolc.com.hr/")
-			array("slika" => "viponline.gif", "alt" => "VIPonline", "url" => "http://www.vip.hr/"),
-			array("slika" => "globalnet.gif", "alt" => "GlobalNET", "url" => "http://www.globalnet.hr/")
-		);
+	include("inc/conn.php");
+	$sql = "SELECT ban_id, slika, alt, url FROM banneri WHERE (".($isMed && $isReg ? "" : "NOT ")."plivamed) ORDER BY ban_id";
+	$sth = $dbh->prepare($sql);
+	if (!$sth) error("Cannot prepare query: \"$sql\"");
+	if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
+	$banneri = array();
+	while ($row = $sth->fetchrow_array()) {
+		list($id, $pic, $alt, $url) = $row;
+		$banneri[$id] = array("slika" => $pic, "alt" => $alt, "url" => $url);
+	}
+	$sth->finish();
+	$dbh->disconnect();
+	function Click($id) {
+		if (!$id) return;
+		$sql = "UPDATE banneri SET klikovi = klikovi + 1 WHERE ban_id = $id";
+		include("inc/conn.php");
+		$dbh->dbh_do($sql);
+		$dbh->disconnect();
 	}
 ?>