--- investor.php	2001/03/17 16:14:17	1.6
+++ investor.php	2002/04/08 11:12:34	1.10
@@ -10,11 +10,7 @@
 
 $smarty->assign("section",$section);
 
-$title="INVESTOR'S PAGE";
-$lpic="investor"; $lext=".jpg";
-$mpic="investors.gif";
-
-if ($menu_item) $title.=" : $menu_item";
+include("section.inc");
 
 $smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) );
 
@@ -30,23 +26,13 @@
 	$smarty->assign("analysts",$analysts);
 	$main=$smarty->fetch("analysts.tpl");
 } else {
-	$dbh->dbh_do("set datestyle='german'");
-
-	$sql="select date(date),time(date),type,current,change,high,low,open from stocks order by stocks.date desc,stocks.insert_date asc limit 2";
-	$sth = $dbh->prepare("$sql");
-	$sth->execute();
-	while ($row=$sth->fetchrow_hash()) {
-		$stock[]=$row;
-		$time=$row[time];
-		$date=$row[date];
-	}
-
-	if ($time == "23:23:23") $time="CLOSE";
-
+	include("stocks.inc");
 	$smarty->assign(array(stock=>$stock, date=>$date, time=>$time));
 	$main=$smarty->fetch("investor.tpl");
 }
 $smarty->assign("MAIN",$main);
 
+include("inc/newsletter.php");
+
 $smarty->display("index.tpl");
 ?>