<?
include "applicationtop.php";
?>
<?
$strmenu="stm_bm([\"menu1a91\",700,\"\",\"\",0,\"\",\"\",0,0,250,0,1000,1,0,0,\"\",\"\",0,0,1,1,\"default\",\"hand\",\"\"],this);\n
	        stm_bp(\"p0\",[0,4,0,0,0,2,4,7,100,\"\",-2,\"\",-2,50,0,0,\"#999999\",\"transparent\",\"\",3,0,1,\"#000000\"]);\n";
		
		
$sql="select id,name,parentid,content,url,wshow from pages where del='N' and parentid='1' and active='Y' and wshow='Y' order by sequence asc";
$objdb->execute_query($sql);
$i=0;

		while($objdb->fetch_array())
		{
			$pname=$objdb->f("name");
			$link="";
			
			if(trim($objdb->f("content"))!="" || trim($objdb->f("url"))	!="")
			{
				if(trim($objdb->f("url"))!="")
					$link=$objdb->f("url");
				else
					$link="main.php?$action=pg&spgid=".$objdb->f("id");	
			}
			
			$strmenu.="stm_ai(\"p0i$i\",[0,\"$pname\",\"\",\"\",-1,-1,0,\"$link\",\"_self\",\"\",\"\",\"\",\"\",4,0,0,\"\",\"\",0,0,0,0,1,\"#305069\",1,\"#345f32\",1,\"".$image_folder_path."menu_bullet-1.gif\",\"".$image_folder_path."menu_bullet1.gif\",3,3,0,0,\"#ffffff\",\"#ffffff\",\"#ffffff\",\"#ffffff\",\"10pt Arial\",\"10pt Arial\",0,0],30,0);\n";
			drawnodes($objdb->f("id"));
			$i++;
		}
//		}

$strmenu.="stm_em();";

$objsmarty->assign("mainmenu",$strmenu);

/// end main menu ///

$strmenu="stm_bm([\"menu413e\",700,\"\",\"{$image_folder_path}blank.gif\",0,\"\",\"\",0,0,250,0,1000,1,0,0,\"\",\"\",0,0,1,1,\"default\",\"hand\",\"\"],this);\n		
                stm_bp(\"p0\",[1,4,0,0,0,2,4,7,100,\"\",-2,\"\",-2,90,0,0,\"transparent\",\"transparent\",\"\",3,0,1,\"#000000\"]);\n";			
		
$sql="select id,name,parentid,content,url from pages where del='N' and parentid='4' and active='Y' order by sequence asc";
$objdb->execute_query($sql);
$i=0;
while($objdb->fetch_array())
{
	$pname=$objdb->f("name");
	$link="";
	
	if(trim($objdb->f("content"))!="" || trim($objdb->f("url"))	!="")
	{
		if(trim($objdb->f("url"))!="")
			$link=$objdb->f("url");
		else
			$link="main.php?$action=pg&spgid=".$objdb->f("id");	
	}
	
	//$strmenu.="stm_ai(\"p0i$i\",[0,\"$pname\",\"\",\"\",-1,-1,0,\"$link\",\"_self\",\"\",\"\",\"\",\"\",4,0,0,\"\",\"\",0,0,0,0,1,\"\",0,\"\",0,\"\",\"\",3,3,1,1,\"\",\"#d5e1ef\",\"#000000\",\"#666666\",\"bold 8pt helvetica\",\"bold 8pt helvetica\",0,0]);\n";
	$strmenu.="stm_ai(\"p0i$i\",[0,\"$pname\",\"\",\"\",-1,-1,0,\"$link\",\"_self\",\"\",\"\",\"\",\"\",4,0,0,\"\",\"\",0,0,0,0,1,\"#315B71\",0,\"#315B71\",1,\"\",\"{$image_folder_path}bluedot.gif\",3,3,1,1,\"#ffffff\",\"#D3E3EF\",\"#ffffff\",\"#666666\",\"bold 8pt helvetica\",\"bold 8pt helvetica\",0,0],167,26);\n";
	drawnodes1($objdb->f("id"));
	$i++;
}

$strmenu.="stm_em();";
$objsmarty->assign("leftmenu",$strmenu);
/// end left menu ///


$strmenu="stm_bm([\"menu413e\",700,\"\",\"{$image_folder_path}blank.gif\",0,\"\",\"\",0,0,250,0,1000,1,0,0,\"\",\"\",0,0,1,1,\"default\",\"hand\",\"\"],this);\n		
                stm_bp(\"p0\",[1,4,0,0,0,2,4,7,100,\"\",-2,\"\",-2,90,0,0,\"transparent\",\"transparent\",\"\",3,0,1,\"#000000\"]);\n";			
		
$sql="select id,name,parentid,content,url from pages where del='N' and parentid='5' and active='Y' order by sequence asc";
$objdb->execute_query($sql);
$i=0;
while($objdb->fetch_array())
{
	$pname=$objdb->f("name");
	$link="";
	
	if(trim($objdb->f("content"))!="" || trim($objdb->f("url"))	!="")
	{
		if(trim($objdb->f("url"))!="")
			$link=$objdb->f("url");
		else
			$link="main.php?$action=pg&spgid=".$objdb->f("id");	
	}
	
	$strmenu.="stm_ai(\"p0i$i\",[0,\"$pname\",\"\",\"\",-1,-1,0,\"$link\",\"_self\",\"\",\"\",\"\",\"\",4,0,0,\"\",\"\",0,0,0,0,1,\"\",0,\"\",0,\"\",\"\",3,3,1,1,\"\",\"#d5e1ef\",\"#000000\",\"#666666\",\"bold 8pt helvetica\",\"bold 8pt helvetica\",0,0]);\n";
	drawnodes1($objdb->f("id"));
	$i++;
}

$strmenu.="stm_em();";
$objsmarty->assign("rightmenu",$strmenu);
/// end right menu ///

$strmenu="stm_bm([\"menu417e\",700,\"\",\"blank.gif\",0,\"\",\"\",0,0,250,0,1000,1,0,0,\"\",\"\",0,0,1,2,\"default\",\"hand\",\"\"],this);\n
                stm_bp(\"p0\",[0,4,0,0,0,5,0,7,100,\"\",-2,\"\",-2,50,0,0,\"#999999\",\"\",\"\",0,0,0,\"#000000\"]);\n";		
		
$sql="select id,name,parentid,content,url,wshow from pages where del='N' and parentid='3' and active='Y' and wshow='Y' order by sequence asc";		
$objdb->execute_query($sql);
$i=0;
while($objdb->fetch_array())
{
	$pname=$objdb->f("name");
	
	$link="";
	if(trim($objdb->f("content"))!="" || trim($objdb->f("url"))	!="")
	{
		if(trim($objdb->f("url"))!="")
			$link=$objdb->f("url");
		else
			$link="main.php?$action=pg&spgid=".$objdb->f("id");	
	}
		
	$strmenu.="stm_ai(\"p0i$i\",[0,\"$pname\",\"\",\"\",-1,-1,0,\"$link\",\"_self\",\"\",\"\",\"\",\"\",0,0,0,\"".$image_folder_path."arrow_r1.gif\",\"\",7,7,0,1,1,\"\",1,\"\",1,\"".$image_folder_path."menu1.jpg\",\"".$image_folder_path."menu1.jpg\",1,1,0,0,\"#FFFFF7\",\"\",\"#ffffff\",\"#ffffff\",\"8pt Verdana\",\"8pt Verdana\",0,0]);\n";
	drawnodes($objdb->f("id"));
	
	$i++;	
}
$strmenu.="stm_em();";
$objsmarty->assign("headermenu",$strmenu);
/// end header menu .///

$strmenu="stm_bm([\"menu5dea\",700,\"\",\"blank.gif\",0,\"\",\"\",0,1,250,0,1000,1,0,0,\"\",\"\",0,0,1,2,\"default\",\"hand\",\"\"],this);\n
               stm_bp(\"p0\",[0,4,0,0,2,3,0,0,100,\"\",-2,\"\",-2,50,0,0,\"#FFFFFF\"]);\n";
	       
$sql="select id,name,parentid,content,url,wshow from pages where del='N' and parentid='2' and active='Y' and wshow='Y' order by sequence asc";		
$objdb->execute_query($sql);
$rcount=$objdb->record_count()-1;
$i=0;
while($objdb->fetch_array())
{	
	$separater="";
	if($rcount!=$i)
		$separater="  |";
		
	$pname=$objdb->f("name").$separater;
	
	$link="";
	
	if(trim($objdb->f("content"))!="" || trim($objdb->f("url"))	!="")
	{
		if(trim($objdb->f("url"))!="")
			$link=$objdb->f("url");
		else
			$link="main.php?$action=pg&spgid=".$objdb->f("id");	
	}

	$strmenu.="stm_ai(\"p0i$i\",[0,\"$pname\",\"\",\"\",-1,-1,0,\"$link\",\"_self\",\"\",\"\",\"\",\"\",0,0,0,\"\",\"\",0,0,0,0,1,\"\",1,\"\",1,\"\",\"\",0,0,0,0,\"#FFFFF7\",\"#FFFFFF\",\"#ffffff\",\"#ffffff\",\"8pt verdana\",\"8pt verdana\",0,0]);\n";
	$i++;
}	
$strmenu.="stm_em();";
$objsmarty->assign("footermenu",$strmenu);


function drawnodes($parentid)
 {	
	global $strmenu;	
	global $image_folder_path;
	global $action;
	
	$sql="select id,name,level,content,url,wshow from pages where del='N' and parentid=$parentid and active='Y' and wshow='Y' order by sequence asc";	
	$rs=mysqli_query($con,$sql);    
	
	if(mysqli_num_rows($rs)>0)
	{
		$row=mysqli_fetch_array($rs);
		$level=$row["level"];
		mysqli_data_seek($rs,0);
		//$strmenu.="stm_bpx(\"p$level\",\"p0\",[1,4]);\n";
		$strmenu.="stm_bpx(\"p$level\",\"p0\",[1,4,0,2,0,5,0,0,80,\"\",-2,\"\",-2,80,0,0,\"#ffffff\",\"#315B71\",\"\"]);";
		//$strmenu.="stm_bpx(\"p$level\",\"p0\",[1,4,0,0,3,0,0]);\n";
		
		while($row=mysqli_fetch_array($rs))
		{
			$link="";
			
			if(trim($row["content"])!="" || trim($row["url"])!="")
			{				
				if(trim($row["url"])!="")
					$link=$row["url"];
				else
					$link="main.php?$action=pg&spgid=".$row["id"];	
			}
		
			//$strmenu.="stm_aix(\"p".$level."i0\",\"p0i0\",[0,\"$row[name]\",\"\",\"\",-1,-1,0,\"$link\",\"_self\",\"\",\"\",\"\",\"\",0,0,0,\"\",\"\",0,0,0,0,1,\"#F9E0CA\",1,\"#666666\",0,\"#000000\",\"".$image_folder_path."nav_mover.jpg\",3,1,0,0,\"#999999\",\"#999999\"],135,29);\n";
			$strmenu.="stm_aix(\"p".$level."i0\",\"p0i0\",[0,\"$row[name]\",\"\",\"\",-1,-1,0,\"$link\",\"_self\",\"\",\"\",\"\",\"\",0,0,0,\"\",\"\",0,0,0,0,1,\"#F9E0CA\",1,\"#ffffff\",0,\"\",\"".$image_folder_path."nav_mover1.jpg\",3,1,0,0,\"#FFFFFF\",\"#ffffff\",\"#FFFFFF\",\"#000000\",\"9pt Arial\",\"9pt Arial\"],0,18);\n";

			drawnodes1($row["id"]);
		}
		$strmenu.="stm_ep();\n";
	}
}	

function drawnodes1($parentid)
{	
	global $strmenu;	
	global $image_folder_path;
	global $action;
	
	$sql="select id,name,level,content,url,wshow from pages where parentid=$parentid and del='N' and active='Y' and wshow='Y' order by sequence asc";
	$rs=mysqli_query($con,$sql);    
	
	if(mysqli_num_rows($rs)>0)
	{
		$row=mysqli_fetch_array($rs);
		$level=$row["level"];
//		$wshow=$row["wshow"];
		mysqli_data_seek($rs,0);	
		
		//$strmenu.="stm_bpx(\"p$level\",\"p0\",[1,4]);\n";
		//$strmenu.="stm_bpx(\"p$level\",\"p0\",[1,2]);\n";
		$strmenu.="stm_bpx(\"p$level\",\"p0\",[1,2,0,2,0,5,0,0,80,\"\",-2,\"\",-2,80,0,0,\"#666666\",\"#315B71\",\"\"]);";

		
		while($row=mysqli_fetch_array($rs))
		{
			$link="";
			
			if(trim($row["content"])!="" || trim($row["url"])!="")
			{				
				if(trim($row["url"])!="")
					$link=$row["url"];
				else
					$link="main.php?$action=pg&spgid=".$row["id"];	
			}
		
		//$strmenu.="stm_aix(\"p".$level."i0\",\"p0i0\",[0,\"$row[name]\",\"\",\"\",-1,-1,0,\"$link\",\"_self\",\"\",\"\",\"\",\"\",0,0,0,\"\",\"\",0,0,0,0,1,\"#913230\",0,\"#ffffff\",0,\"\",\"\",0,0,1,1,\"#ffffff\",\"#ffffff\",\"#ffffff\",\"#F4B005\"]);\n";
			//$strmenu.="stm_aix(\"p".$level."i0\",\"p0i0\",[0,\"$row[name]\",\"\",\"\",-1,-1,0,\"$link\",\"_self\",\"\",\"\",\"\",\"\",0,0,0,\"\",\"\",0,0,0,0,1,\"#913230\",0,\"#913030\",0,\"\",\"\",0,0,1,1,\"#ffCCCC\",\"#913030\",\"#ffcccc\",\"#913030\"]);\n";		 
			$strmenu.="stm_aix(\"p".$level."i0\",\"p0i0\",[0,\"$row[name]\",\"\",\"\",-1,-1,0,\"$link\",\"_self\",\"\",\"\",\"\",\"\",0,0,0,\"\",\"\",0,0,0,0,1,\"#F9E0CA\",1,\"#ffffff\",0,\"\",\"".$image_folder_path."nav_mover1.jpg\",3,1,0,0,\"#FFFFFF\",\"#FFFFFF\",\"#FFFFFF\",\"#000000\",\"9pt Arial\",\"9pt Arial\"],0,18);\n";
			drawnodes1($row["id"]);	
		}
//		}
		$strmenu.="stm_ep();\n";
	}
}
?>
<?
$objdb=new mysql();

$sqlquery="select id ,subject title,description,date_format(publishdate,'%d/%m/%Y') pdate from 
news where del='N' order by publishdate desc limit 100";
$objdb->execute_query($sqlquery);

/*while($objdb->fetch_array())
{
	$arr[$objdb->f("id")]["id"]=$objdb->f("id");
	//$arr[$objdb->f("id")]["id"]=$objdb->f("id");
}

echo "<pre>";
print_r($arr);*/
//$id=$objdb->f("id1");
//$id1=$objdb->f("id1");
//echo $id;

while($objdb->fetch_array())
{
	//$id1=$objdb->f("id");
	//$id=$objdb->f("id");
	$arr_ntop[$objdb->f("id")]["id"]=$objdb->f("id");
	$arr_ntop[$objdb->f("id")]["title"]=$objdb->f("title");
	//
	$desc1=$objdb->f("description");
	$arr_ntop[$objdb->f("id")]["pdate"]=$objdb->f("pdate");
	
	$objdb1=new mysql();
	$sql="select id,counter,alignment from images where del='N' and cattype='NE' and referenceid=".$objdb->f("id")."";
	//echo $sql;
	//echo $id;
	//echo "<br>";
	//echo $id1;
	//exit;
	$objdb1->execute_query($sql);
	while($objdb1->fetch_array())
	{	
		//echo "heloo";
		if($objdb1->f("alignment")=="L")
			$align=" align='left'";
		elseif($objdb1->f("alignment")=="R")
			$align=" align='right'";
			
		$imarker="#$img_marker".$objdb->f("counter")."#";
		
		$params="&parameters=".base64_encode("images|photo|id=".$objdb1->f("id"))."&resizeto=55";			
		
		$imgtag="<img src='main.php?$action=showimg$params' border='0' align='right'>";
		
		$desc=str_replace($imarker,$imgtag,$desc1);
		
		//echo $imgtag;
	}

		$pattern="/#$img_marker"."[0-9]?#/";
		$desc=preg_replace($pattern,$imgtag,$desc);
		$arr_ntop[$objdb->f("id")]["description"]=$desc;
	}


/*foreach ($arr_ntop as $key => $value) 
{
    echo "Key: $key; Value: $value<br />\n";
}

$sql="select id,counter,alignment from images where del='N' and cattype='NE' and referenceid=$id";
//echo $sql;
//echo $id;
echo "<br>";
//echo $id1;
//exit;
$objdb->execute_query($sql);
while($objdb->fetch_array())
{	

	if($objdb->f("alignment")=="L")
		$align=" align='left'";
	elseif($objdb->f("alignment")=="R")
		$align=" align='right'";
		
	$imarker="#$img_marker".$objdb->f("counter")."#";
	
	$params="&parameters=".base64_encode("images|photo|id=".$objdb->f("id"))."&resizeto=50";			
	
	$imgtag="<img src='main.php?$action=showimg$params' border='0' $align>";
	
	$desc=str_replace($imarker,$imgtag,$desc);
}

$pattern="/#$img_marker"."[0-9]?#/";
$desc=preg_replace($pattern,"",$desc);

*/
$middle_fname="$newsdir/news_top.$tpl_ext";

//$arr_ntop["description"]=$desc;

//echo "<pre>";
//print_r($arr_ntop);
$objsmarty->assign("nwaction","nwview");
$objsmarty->assign("more","nwcat");
$objsmarty->assign("arr_ntop",$arr_ntop);
$objsmarty->assign("desc",$desc);

?>