<?session_start();
	require_once( $_SERVER['DOCUMENT_ROOT']."/plus/includefiles/common_function.php");
	require_once( $_SERVER['DOCUMENT_ROOT']."/phplib/alteon_mc.php");
	require_once( $_SERVER['DOCUMENT_ROOT']."/plus/login/authenticate.php");

	#require_once( $_SERVER['DOCUMENT_ROOT']."/phplib/db_mysql_mcplus.php");
	require_once( $_SERVER['DOCUMENT_ROOT']."/plus/functions.php");
	if(isset($_GET["category"])){$category = check_input($_GET["category"],"alphanumeric");}
	
	$user_pack=$_COOKIE['USRPACK'];
	$strtdt = dt_hexstr($_COOKIE['STRTDT']);
	$trader_arr = array('MPTR36', 'MPTR12', 'MPTR06', 'MPTR03', 'MPTR01','MPTR24');
	$inv_arr = array('MPIV36', 'MPIV12', 'MPIV06', 'MPIV03', 'MPIV01','MPIV24');
	$commodity_arr = array('MPCMD24', 'MPCMD12', 'MPCMD06');
	$tr = 0;
	$inv = 0;
	$commodity = 0;
	$usr_pkg = dt_hexstr($_COOKIE['usr_pkg']);
	$usr_pkg = explode("|",$usr_pkg);
	if($usr_pkg[0]==1)
		$tr = 1;
	if($usr_pkg[1]==1)
		$inv = 1;
	if($usr_pkg[2]==1)
		$commodity = 1;
    if(in_array($user_pack, $trader_arr) && $category == "MultiBaggers" && $inv!=1)
	{
		//echo "You have not subscribed to this pack ... Please subscribe";
		header("Location:/plus/subscribed/index.php?category=MultiBaggers");
		exit;
	}
	if(in_array($user_pack, $trader_arr) && $category == "commodity"  && $strtdt >= "2012-05-30" && $commodity!=1)
	{
		//echo "You have not subscribed to this pack ... Please subscribe";
		header("Location:/plus/subscribed/index.php?category=Commodity");
		exit;
	}
	
	if(in_array($user_pack, $inv_arr) && (($category == "PowerCalls" && $tr!=1) || ($category == "commodity" && $commodity!=1)))
	{
		//echo "You have not subscribed to this pack ... Please subscribe";
		header("Location:/plus/subscribed/index.php?category=PowerCalls");
		exit;
	}
	if(in_array($user_pack, $commodity_arr) && $category == "PowerCalls" && $tr!=1)
	{
		//echo "You have not subscribed to this pack ... Please subscribe";
		header("Location:/plus/subscribed/index.php?category=PowerCalls");
		exit;
	}



	$experts_array = get_experts_array();
	$curr_dt = date("Y-m-d");
	$cutoff = date("Y-m-d", strtotime("$curr_dt -1 days"));
	$category_arr = array("MultiBaggers"=>"1", "StockSigns"=>"2", "StockImpact"=>"3", "MktOutlook"=>"4", "StreetTalk"=>"5", "PowerCalls"=>"6");





function stock_details($sc_id,$index)
{
	require_once( $_SERVER['DOCUMENT_ROOT']."/mccode/common/mysql_conn.php");
	$conn_read24=Open_Connection("main_read");
	if($index == "NSE")
	{
		$ex = "NSE : ";
		$table = "livense_tick";
	}
	else
	{
		$ex = "BSE : ";
		$table = "livebse";
	}
    $price_array = array(); 
	$sql_2 = "SELECT CURRENTCLOSEPRICE, SC_ID, SC_COMP, PREVCLOSE, round(((CURRENTCLOSEPRICE/PREVCLOSE)-1)*100,2) PERGAINLOSS, DTTIME from ".$table." WHERE SC_ID='$sc_id'";
	$rec = mysql_query($sql_2,$conn_read24);
	if($row = mysql_fetch_array($rec))
	{
		$price_array['CURRENTCLOSEPRICE']=$row['CURRENTCLOSEPRICE'];
		$price_array['SC_ID']=$row['SC_ID'];
		$price_array['SC_COMP']=$row['SC_COMP'];
		$price_array['PREVCLOSE']=$row['PREVCLOSE'];
		$price_array['PERGAINLOSS']=$row['PERGAINLOSS'];
		$price_array['DTTIME']=$row['DTTIME'];
	}
	return $price_array;
}

function stock_price_string($row_arr,$index='BSE',$opt='',$up_img='')
{

	$month_arr = array("1"=>"Jan", "2"=>"Feb", "3"=>"Mar", "4"=>"Apr", "5"=>"May", "6"=>"Jun", "7"=>"Jul", "8"=>"Aug", "9"=>"Sep", "10"=>"Oct", "11"=>"Nov", "12"=>"Dec");

	if($index == "NSE")
	{
		$ex = "NSE : ";
		//$table = "livense_tick";
	}
	else
	{
		$ex = "BSE : ";
		//$table = "livebse";
	}

	if(count($row_arr)>0)
	{
		$row = $row_arr;
		$currentcloseprice=$row['CURRENTCLOSEPRICE'];
		$sc_id=$row['SC_ID'];
		$sc_comp=$row['SC_COMP'];
		$prevclose=$row['PREVCLOSE'];
		$pergainloss=$row['PERGAINLOSS'];
		$dttime=$row['DTTIME'];

		if(strlen($dttime)==7)
			$feed_time = $month_arr[substr($dttime,0,1)] ." ". substr($dttime,1,2) .", ". substr($dttime,3,2) .":". substr($dttime,5,2);
		else
			$feed_time = $month_arr[substr($dttime,0,2)] ." ". substr($dttime,2,2) .", ". substr($dttime,4,2) .":". substr($dttime,6,2);

		if ($pergainloss>0)
		{
			$image_class="<span class='up'></span>";
			$fontcolor="gr_18";
		}
		else if ($pergainloss<0)
		{
			$image_class="<span class='down'></span>";
			$fontcolor="r_18";
		}
		else
		{
			$image_class="<span class='PL10'></span>";
			$fontcolor="b_18";
		}
		$pergainloss=number_format($pergainloss, 2, '.', '')."%";
		
		$sysdate = date("Hi");
		$day = date("D");

		$i++;
		
		if($opt == "lastprice")
		{
			return $currentcloseprice;
		}
		else
		{
			if($opt == "split")
				$str =  "<p class='gD_15'><a href='/plus/cptmarket/stockprice_main.php?scid=$sc_id' class='gD_15'><strong>".$sc_comp."</strong></a></p>|<strong>".$currentcloseprice."</strong>".$image_class."<span class='".$fontcolor."'>".$pergainloss."</span><span class='gL_10 PL10'>".$ex."".$feed_time."</span></p>";
			else if($opt == "split_big")
				$str =  "<h2><strong>".$sc_comp."</strong></h2>|<p class='gD_20 MT7'><strong>".$currentcloseprice."</strong>".$image_class."<span class='".$fontcolor."'>".$pergainloss."</span><span class='gL_10 PL10'>".$ex."".$feed_time."</span></p>";
			else
			{
				#$str =  "<p class='gD_15'>".$sc_comp."</p><p class='gD_20 MT7'><strong>".$currentcloseprice."</strong>".$image_class."<span class='".$fontcolor."'>".$pergainloss."</span></p>";

				$str =  "<p class='gD_15'><strong><a href='/plus/cptmarket/stockprice_main.php?scid=$sc_id' class='gD_15'><strong>".$sc_comp."</strong></a></strong></p><p class='gD_20 MT7'>".$currentcloseprice."".$image_class."<span class='".$fontcolor."'>".$pergainloss."</span><span class='gL_10 PL10'>".$ex."".$feed_time."</span></p>";
			}

			return $str;
		}
	}
}

	$expimg_arr = all_broker_images();
	/*$expimg_arr = array("Ashwani Gujral"=>"https://images.moneycontrol.com/images/mcplus_plus/ashwaniguj_60.gif", "Hitendra Vasudeo"=>"https://images.moneycontrol.com/images/mcplus_plus/hitendra_vasudev_60.gif", "VK Sharma"=>"https://images.moneycontrol.com/images/mcplus_plus/VKSharma_75.gif", "E Mathew"=>"https://images.moneycontrol.com/images/mcplus_plus/emathew.gif", "Angel Broking"=>"https://images.moneycontrol.com/images/pyt_2010/Angel_Broking_100.jpg", "Bonanza"=>"https://images.moneycontrol.com/images/pyt_2010/Bonanza_100.jpg", "Emkay Global"=>"https://images.moneycontrol.com/images/pyt_2010/emkay_100.jpg", "Hem Securities"=>"https://images.moneycontrol.com/images/pyt_2010/HEM_Securities_100.jpg", "IFCI Financial Services"=>"https://images.moneycontrol.com/images/pyt_2010/IFCI_Financial_Services_100.jpg", "Karvy Stock Broking"=>"https://images.moneycontrol.com/images/pyt_2010/Karvy_100.jpg", "KR Choksey"=>"https://images.moneycontrol.com/images/pyt_2010/KR_Choksey_100.jpg", "Motilal Oswal"=>"https://images.moneycontrol.com/images/pyt_2010/Motilal_Oswal_100.jpg", "Sushil Finance"=>"https://images.moneycontrol.com/images/pyt_2010/Sushil_Finance_100.jpg", "Ventura Securities"=>"https://images.moneycontrol.com/images/pyt_2010/Ventura_Securities_100.jpg",
	"Rahul Mohindar"=>"https://images.moneycontrol.com/images/mcplus_plus/Rahul_Mohindar_60.jpg",
	"Nirmal Bang"=>"https://images.moneycontrol.com/images/pyt_2010/nirmal_bang_100.jpg",
	"Mitesh Thacker"=>"https://images.moneycontrol.com/images/pyt_2010/miteshthacker_60.jpg");*/

	$expdes_arr = array("Ashwani Gujral"=>"ashwanigujral.com", "Hitendra Vasudeo"=>"stockmechanics.com", "VK Sharma"=>"Technical Analyst", "E Mathew"=>"matheweasow.com");

	
	if($category=="commodity"){
		$s_cid = "15";
		$category_name = "Commodity Calls";
		$tab_heading = "commodity";
		$tab_section = "2";
		$cat_sql = "select * from (select 'powercalls_res' news_cat, sc_scid scid, autono, heading, '' summary, expert impact, flag category, '1' exp_img_path, target1 target, stoploss1 recprice, '' stock, '' call_date, ent_date, category cat, scrip_name expiry_date from research_trading_calls where 
        target1 > 0 and sc_scid!='' and (flag='BUY' OR flag='SELL') and category='Commodity') as result order by ent_date desc  limit 30";
	}
	else
	{
		$category = 'PowerCalls';
		$s_cid = "4";
		$category_name = "Power Calls";
		$tab_heading = "stocks";
		$tab_section = "1";
		$cat_sql = "select * from (select 'powercalls_res' news_cat, sc_scid scid, autono, heading, '' summary, expert impact, flag category, '1' exp_img_path, target1 target, stoploss1 recprice, '' stock, '' call_date, ent_date, category cat, scrip_name expiry_date from research_trading_calls where 
        target1 > 0 and sc_scid!='' and (flag='BUY' OR flag='SELL') and category!='Commodity' union select 'powercalls' news_cat, sc_scid scid, autono, heading, '' summary, expert impact, flag category, '' exp_img_path, target1 target, stoploss1 recprice, '' stock, '' call_date, ent_date, '' cat, '' expiry_date  from trading_calls where target1 > 0 and sc_scid!='' and (flag='BUY' OR flag='SELL') ) as result order by ent_date desc  limit 30";
	}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="https://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PowerYourTrade.com - Exclusive Trading Calls, Trading Tips, Stock Signs, Stocks to Watch</title>
<META NAME="Author" CONTENT="Provides news, views, and analysis of stock market, Exclusive Trading Calls, Trading Tips, Stock Signs, Stocks to Watch, Stock Market Commentary, Share Price Ticker, BSE, NSE, Expert Speaks, Company Information, Company Results, Broker Research Reports, Top Gainers, Top Losers, Most Active, 52-Week High, 52-Week Lows, Index Composition">
<META NAME="Keywords" CONTENT="Provides news, views, and analysis of stock market, Exclusive Trading Calls, Trading Tips, Stock Signs, Stocks to Watch, Stock Market Commentary, Share Price Ticker, BSE, NSE, Expert Speaks, Company Information, Company Results, Broker Research Reports, Top Gainers, Top Losers, Most Active, 52-Week High, 52-Week Lows, Index Composition">
<META NAME="Description" CONTENT="Provides news, views, and analysis of stock market, Exclusive Trading Calls, Trading Tips, Stock Signs, Stocks to Watch, Stock Market Commentary, Share Price Ticker, BSE, NSE, Expert Speaks, Company Information, Company Results, Broker Research Reports, Top Gainers, Top Losers, Most Active, 52-Week High, 52-Week Lows, Index Composition">
<script language="javascript" src="https://images.moneycontrol.com/plus/disable_mouse.js"></script>
<div class="main">
	<div><?require_once( $_SERVER['DOCUMENT_ROOT']."/plus/common_top.php");?></div>

	<div class="mainctnt">
		<div><img src="https://images.moneycontrol.com/images/pyt_2010/topc.gif" width="988" height="10" alt="" /></div>
		<div class="clearfix">
			<div><?require_once( $_SERVER['DOCUMENT_ROOT']."/plus/includefiles/lhs.php");?></div>

			<div class="cont2">
			<h1></h1>
				<div class="brdb4 MT15">	
					<div class="btn1"><a href="/plus/listing/index.php?category="> <span>Latest</span></a></div>
					<div class="btn1"><a href="?category=" class="act"><span>Potential Profit in </span></a></div>
					<div class="CL"></div>
				</div>	
			<?
			$q1 = new DB_Sql_mcplus_main();
			$q = new DB_Sql_mcplus();
			$q->query($cat_sql);
			$tot = $q->num_rows();
            $ctr=0;
			$q->query($cat_sql);
			while($q->next_record())
			{
				$news_cat = $q->f('news_cat');
				$scid = $q->f('scid');
				$autono = $q->f('autono');
				$heading = $q->f('heading');
				$summary = $q->f('summary');
				$impact = $q->f('impact');
				$category = $q->f('category');
				$exp_img_path = $q->f('exp_img_path');
				$target = $q->f('target');
				$rec_price = $q->f('recprice');
				$stock = $q->f('stock');
				$ent_date = $q->f('ent_date');
				$diff = $q->f('diff');
				$call_cat = $q->f('cat');
				$expiry_date = $q->f('expiry_date');
				
				
				/*$lastprice = stock_price($scid,"NSE","lastprice","1");
				if($stock_name == "")
				{
				   $lastprice = stock_price($scid,"BSE","lastprice","1");
				}*/
				if(strlen($scid)>0 and $call_cat != "Commodity")
				{
					$stock_arr = stock_details($scid,"BSE"); 
					$ex = "BSE";
					if(count($stock_arr)==0){
						$stock_arr = stock_details($scid,"NSE"); 
						$ex= "NSE";
					}
					$lastprice = $stock_arr['CURRENTCLOSEPRICE'];
					$sc_comp = $stock_arr['SC_COMP'];
					$prevclose = $stock_arr['PREVCLOSE'];
					$pergainloss = $stock_arr['PERGAINLOSS'];
					$dttime  = $stock_arr['DTTIME'];
					$cont_expiry = "";
				}else if(strlen($scid)>0 and $call_cat == "Commodity"){
					$get_mcx_price = "select ltp, ltt, close, cont_symbol, cont_expiry from mcx_commodity where cont_symbol='".$scid."' and expiry_date='".$expiry_date."'";
					$q1->query($get_mcx_price);
					if($q1->next_record()){
						$ex = "MCX";
						$lastprice = $q1->f("ltp");
						$dttime = $q1->f("ltt");
						$sc_comp = $q1->f("cont_symbol");
						$cont_expiry = $q1->f("cont_expiry");
						$prevclose = $q1->f("close");
						$pergainloss = number_format(((($lastprice-$prevclose)/$prevclose)*100),2);
					}
				}

				$rec_price = sprintf("%01.2f",$rec_price,2);
				if(($category=='BUY' && $lastprice >= $rec_price) || ($category=='SELL' && $lastprice <= $rec_price)){
						if($category=='BUY') {
							   $sort_price =   (($target-$lastprice)/$lastprice)*100;
						}else if($category == "SELL"){
							   $sort_price =   (($lastprice-$target)/$lastprice)*100;
						}else{
							 $sort_price = '';
						}

						//echo'<br> autono='.$autono.' cat='.$category.' Cpr='.$lastprice.' SL='.$rec_price;
                        $exp_name = $impact;
						$expimg = $expimg_arr[$exp_name];
						$powercall_array[0][$ctr] = $autono;
						$powercall_array[1][$ctr] = $exp_name;
						$powercall_array[2][$ctr] = $expimg;
						$powercall_array[3][$ctr] = $expdesig;
						$powercall_array[4][$ctr] = $target;
						$powercall_array[5][$ctr] = $stop_loss;
						$powercall_array[6][$ctr] = $category;
						$powercall_array[7][$ctr] = $scid;
						$powercall_array[8][$ctr] = $heading;
						$powercall_array[9][$ctr] = $summary;
						$powercall_array[10][$ctr] = $exp_img_path;
						$powercall_array[11][$ctr] = $ent_date;
						$powercall_array[12][$ctr] = $sort_price;
						$powercall_array[13][$ctr] = $lastprice;
						$powercall_array[14][$ctr] = $sc_comp;
						$powercall_array[15][$ctr] = $prevclose;
						$powercall_array[16][$ctr] = $pergainloss;
						$powercall_array[17][$ctr] = $dttime;
						$powercall_array[18][$ctr] = $ex;
						$powercall_array[19][$ctr] = $cont_expiry;
						$ctr++;
				}
			}//while

			
			###############  Sort array here #########################

			array_multisort($powercall_array[12],SORT_DESC,SORT_NUMERIC,$powercall_array[0],$powercall_array[1],
			$powercall_array[2],$powercall_array[3],$powercall_array[4],$powercall_array[5],$powercall_array[6],
			$powercall_array[7],$powercall_array[8],$powercall_array[9],$powercall_array[10],$powercall_array[11],
			$powercall_array[13],$powercall_array[14],$powercall_array[15],$powercall_array[16],
			$powercall_array[17],$powercall_array[18],$powercall_array[19]);

			##########################################################

		 
            if($ctr >= 15)$ctr = 15;
			for($i=0; $i < $ctr; $i++)
			{
				$autono = $powercall_array[0][$i];
				$exp_name = $powercall_array[1][$i];
				$expimg = $powercall_array[2][$i];
				$expdesig = $powercall_array[3][$i];
				$target = $powercall_array[4][$i];
				$stop_loss = $powercall_array[5][$i];
				$category = $powercall_array[6][$i];
				$scid = $powercall_array[7][$i];
				$heading = $powercall_array[8][$i];
				$summary = $powercall_array[9][$i];
				$exp_img_path = $powercall_array[10][$i];
				$ent_date = $powercall_array[11][$i];
				$sort_price  = $powercall_array[12][$i];

				$lastprice  = $powercall_array[13][$i];
				$sc_comp  = $powercall_array[14][$i];
				$prevclose  = $powercall_array[15][$i];
				$pergainloss  = $powercall_array[16][$i];
				$dttime  = $powercall_array[17][$i];
				$ex  = $powercall_array[18][$i];
				$cont_expiry  = $powercall_array[19][$i];
				if($ex!="MCX")
				{
					$pass_arr =  array("CURRENTCLOSEPRICE"=>$lastprice,"SC_ID"=>$scid,"SC_COMP"=>$sc_comp, "PREVCLOSE"=>$prevclose,"PERGAINLOSS"=>$pergainloss,"DTTIME"=>$dttime);

					/*$msg_dat=substr($ent_date,0,10);
					$msg_yr=substr($ent_date,0,4);
					$curr_dat=date("Y-m-d");
					$curr_yr=date("Y");
					if($curr_dat!=$msg_dat)
					{
						$date_all  = explode(" ",$ent_date);
						$time_xpld = explode(":",$date_all[1]);
						$date_xpld = explode("-",$date_all[0]);
						if($curr_yr==$msg_yr)
						{
							$filing_dt  =  date("g.i A M jS", mktime($time_xpld[0], $time_xpld[1], 0, $date_xpld[1], $date_xpld[2], $date_xpld[0]));
						}
						else
						{
							$filing_dt  =  date("g.i A M jS Y", mktime($time_xpld[0], $time_xpld[1], 0, $date_xpld[1], $date_xpld[2], $date_xpld[0]));
						}
					}
					else
					{
						$filing_dt = dateTimeDiff($ent_date)." ago";
					}

					$str =  "<p class='gD_15'><strong><a href='/plus/cptmarket/stockprice_main.php?scid=$sc_id' class='gD_15'><strong>".$sc_comp."</strong></a></strong></p><p class='gD_20 MT7'>".$currentcloseprice."".$image_class."<span class='".$fontcolor."'>".$pergainloss."</span><span class='gL_10 PL10'>".$ex."".$feed_time."</span></p>";*/
					
					$stock_name = stock_price_string($pass_arr,$scid);
					if($stock_name == "")
					{
						$stock_name = stock_price_string($pass_arr,$scid);
					}
				}else if($ex=="MCX"){
					if ($pergainloss>0)
					{
						$image_class="<span class='up'></span>";
						$fontcolor="gr_18";
					}
					else if ($pergainloss<0)
					{
						$image_class="<span class='down'></span>";
						$fontcolor="r_18";
					}
					else
					{
						$image_class="<span class='PL10'></span>";
						$fontcolor="b_18";
					}
					$last_trd_time = explode(" ",$dttime);
					$date = explode("-",$last_trd_time[0]);
					$time = explode(":",$last_trd_time[1]);
					$feed_time = date("M d, G:i",mktime($time[0],$time[1],$time[2],$date[1],$date[2],$date[0]));
					$stock_name = "<p class='gD_15'><strong>".$sc_comp." ".$cont_expiry."</strong></p><p class='gD_20 MT7'>".number_format($lastprice,2)."".$image_class."<span class='".$fontcolor."'>".$pergainloss."%</span><span class='gL_10 PL10'>MCX ".$feed_time."</span></p>";
				}

                if($news_cat == "powercalls")
				{
					$disp_exp_name = $exp_name;
					if(in_array($exp_name,$experts_array))$width = '60px';  
					else $width = '100px'; 

					$expimg = "<a href='/plus/expert/experts.php?expert=".$exp_name."'><img src='".$expimg."' width='".$width."' height='60' alt='' class='brd3' /></a>";

					if($category == "BUY")
						$image_name = "<img src='https://images.moneycontrol.com/images/pyt_2010/buy.gif' width='48' height='32' alt='' class='FL MR25' />";
					else if($category == "SELL")
						$image_name = "<img src='https://images.moneycontrol.com/images/pyt_2010/sell.gif' width='48' height='32' alt='' class='FL MR25' />";
					else
						$image_name = "<img src='https://images.moneycontrol.com/images/pyt_2010/blank.gif' width='48' height='32' alt='' class='FL MR25' />";

					$det_flag = 0;
					$det_disp = "<div class='brd_b PB7 MT7 clearfix'>";
					if($target != "" && $target != 0)
					{
						$det_flag = 1;
						$det_disp .= "<p class='gr_12 FL'><strong>TARGET </strong><span class='gD_18 ML5'><strong>".number_format($target,2)."</strong></span></p>";
					}
					
					if($stop_loss != "" && $stop_loss != 0)
					{
						$det_flag = 1;
						$det_disp .= "<p class='gr_12 FL ML20'><strong>STOP LOSS</strong><span class='gD_18 ML5'><strong>".number_format($stop_loss,2)."</strong></span></p>";
					}
					
					if($det_flag == 1)
						$det_disp .= "<p class='CL'></p></div>";
					else
						$det_disp = "";

					echo "<div class='grbx clearfix MT15'><div class='grlt'><div>".$expimg."</div><p class='gD_15 MT10'><strong>".$disp_exp_name."</strong></p><p class='PT2'><a href='/plus/expert/tradingcall.php?autono=".$autono."' class='bl_12'>".$expdesig."</a></p><p class='gL_10 PT2'>".$filing_dt."</p></div><div class='FL' style='width:360px'><div class='brd_b PB5 MT20'>".$image_name."<p class='gD_15'>".$stock_name."</p></div>".$det_disp."<p class='gL_15 MT10'><a href='/plus/expert/tradingcall.php?autono=".$autono."' class='gL_15'>".$heading."</a></p></div><div class='CL'></div></div>";

					
				}
				else if($news_cat == "powercalls_res")
				{
					if(in_array($exp_name,$experts_array))$width = '60px';  
					else $width = '100px'; 
					$disp_exp_name = "";
					$expimg = "<a href='/plus/my_broker/index.php?broker=".$exp_name."&tab=".$tab_section."'><img src='".$expimg."' width='".$width."' height='60' alt='' class='brd3' /></a>";
					$det_flag = 0;
					$det_disp = "<div class='brd_b PB7 MT7 clearfix'>";
					if($target != "" && $target != 0)
					{
						$det_flag = 1;
						$det_disp .= "<p class='gr_12 FL'><strong>TARGET </strong><span class='gD_18 ML5'><strong>".number_format($target,2)."</strong></span></p>";
					}
					
					if($stop_loss != "" && $stop_loss != 0)
					{
						$det_flag = 1;
						$det_disp .= "<p class='gr_12 FL ML20'><strong>STOP LOSS</strong><span class='gD_18 ML5'><strong>".number_format($stop_loss,2)."</strong></span></p>";
					}
					
					if($det_flag == 1)
						$det_disp .= "<p class='CL'></p></div>";
					else
						$det_disp = "";
					
					if($category == "BUY")
						$image_name = "<img src='https://images.moneycontrol.com/images/pyt_2010/buy.gif' width='48' height='32' alt='' class='FL MR25' />";
					else if($category == "SELL")
						$image_name = "<img src='https://images.moneycontrol.com/images/pyt_2010/sell.gif' width='48' height='32' alt='' class='FL MR25' />";
					else
						$image_name = "<img src='https://images.moneycontrol.com/images/pyt_2010/blank.gif' width='48' height='32' alt='' class='FL MR25' />";

					echo "<div class='grbx clearfix MT12'><div class='grlt'><div class='MT12'>".$expimg."</div><p class='gD_15 MT10'><strong>".$disp_exp_name."</strong></p><p class='PT2 bl_12'>".$expdesig."</p><p class='gL_10 PT2'>".$filing_dt."</p></div><div class='FL' style='width:360px'><div class='brd_b PB5 MT20'>".$image_name."<p class='gD_15'>".$stock_name."</p></div>".$det_disp."<p class='gL_15 MT10'>".$heading."</p></div><div class='CL'></div></div>";

			     }
			}//for

			if($tot==0){
				?><div class="grbx clearfix MT15"><p align="center" class="gD_15 MT10 MB10">No Power Calls at the moment.</p></div><?
			}

		    ?>
				<!-- <div class="pgn_btm tar PB20">
					<ul>
						<?//echo$pageall;?>
					</ul>
				</div> -->
			</div>

			<div class="cont3">
						<script language="JavaScript">

function show_market_action_chart(name_index){

		if(name_index == 'nifty'){

			$("#showdiv1").hide();$("#showdiv2").show();
			$('#boxgr1').removeClass('act2');
			$('#boxgr2').addClass('act2');
			$('#boxgr1').addClass('act1');
			$("#market_action_chart_nifty").attr("src", "https://www.moneycontrol.com/mccode/common/indices_chart/indices_chart.php?market=i&period=1d&ind_id=9&width=200&height=150");

		}else if(name_index == 'sensex'){

			$("#showdiv1").show();$("#showdiv2").hide();
			$('#boxgr2').removeClass('act2');
			$('#boxgr1').addClass('act2');
			$('#boxgr1').removeClass('act1');
			$("#market_action_chart_sensex").attr("src", "https://www.moneycontrol.com/mccode/common/indices_chart/indices_chart.php?market=i&period=1d&ind_id=4&width=200&height=150");

		}

}


function show_galdiv(a)
{
	for(var i=1; i<=4; i++)
	{
		if(i == a)
		{
			document.getElementById('boxgr'+i).className = "act2";
			document.getElementById('showdiv'+i).style.display = "block";
		}
		else
		{
			document.getElementById('boxgr'+i).className = "act1";
			document.getElementById('showdiv'+i).style.display = "none";
		}
	}
}

function show_gal(a)
{
	for(var i=1; i<=2; i++)
	{
		if(i == a)
		{
			document.getElementById('boxg'+i).className = "act22";
			document.getElementById('showd'+i).style.display = "block";
		}
		else
		{
			document.getElementById('boxg'+i).className = "act11";
			document.getElementById('showd'+i).style.display = "none";
		}
	}
}

function show_gtab(tab_nm, tab_no)
{
	for(var i=1; i<=2; i++)
	{
		if(i == tab_no)
		{
			document.getElementById('tab_'+tab_nm+"_"+i).className = "act";
			document.getElementById('gtab_'+tab_nm+"_"+i).style.display = "block";
		}
		else
		{
			document.getElementById('tab_'+tab_nm+"_"+i).className = "";
			document.getElementById('gtab_'+tab_nm+"_"+i).style.display = "none";
		}
	}
}

function post_indextech(ind_id)
{
	if(ind_id == "4")
	{
		document.indextech_frm.action= "https://www.moneycontrol.com/sensex/bse/sensex-live/";
	}
	else if(ind_id == "9")
	{
		document.indextech_frm.action= "https://www.moneycontrol.com/nifty/nse/nifty-live";
	}
	else
	{
		document.indextech_frm.action= "https://www.moneycontrol.com/stocks/cptmarket/indices_tech.php";
	}

	document.getElementById("index_id").value=ind_id;
	document.indextech_frm.submit();
	return false;
}
</script>
<div>
	<!-- <div class="PB10" style="text-align:center;">
		<?
			if(date("Ymd")<"20140114")
			{
			if(date("Ymd")=="20131120")
				$img = "samvat_offer_5.jpg";
			else if(date("Ymd")=="20131119")
				$img = "samvat_offer_6.jpg";
			else if(date("Ymd")=="20131121")
				$img = "samvat_offer_4.jpg";
			else if(date("Ymd")=="20131122")
				$img = "samvat_offer_3.jpg";
			else if(date("Ymd")=="20131123")
				$img = "samvat_offer_2.jpg";
			else if(date("Ymd")=="20131124")
				$img = "samvat_offer_1.jpg";
			else if(date("Ymd")=="20131125")
				$img = "samvat_offer_0.jpg";
			else
				$img = "samvat_rhs.gif";
		?>
		<a href="https://poweryourtrade.moneycontrol.com/plus/registration/offers.php?utm_source=PYTRHS"><img src="https://images.moneycontrol.com/images/promo/new_year_2014_180x300_1.jpg" alt="" border="0" align="center" /></a>
		<?}?>
	</div>  -->
	<div class="PB10" >
	  <a href="https://goo.gl/forms/WbpUQhPAxdULQQal1" target="_blank">
		<img src="https://images.moneycontrol.com/images/promo/2017/PYT-Survery-Auguest-2017.png">
	  </a>
	</div>
     <style>
	.iw_pyt_banner{background: #b8e3e4 url(https://images.moneycontrol.com/images/promo/iw/iwpr_bg.gif) repeat-x; width: 194px; padding: 8px 8px 20px; font: 14px Arial; color: #666}
	.iw_pyt_banner img{ border:0}
	.FL { float: left }.FR { float: right }.CL { clear: both }
	.iw_pyt_banner .blu18 { color: #004f87; font: bold 14px Arial; line-height: 20px; margin: 12px 0}
	.iw_pyt_banner .blu18 span { font-size: 18px }
	.iw_pyt_banner .rd18 { color: #da251c; font-size: 16px; margin: 15px 0 20px }
	.iw_pyt_banner .CTR { text-align: center; }
	</style>
	<div class="iw_pyt_banner">
		<div><a href="https://investmentwatch.moneycontrol.com/tracker.php?package_id=1&source=IW_PYTRHS&utm_source=IW_PYTRHS" target="_blank"><img src="https://images.moneycontrol.com/images/promo/iw/iw_logo_01082017.gif" width="84" height="24" alt="" class="FL" /></a><a href="http://www.network18online.com/?utm_source=IW_PYTRHS" target="_blank"><img src="https://images.moneycontrol.com/images/promo/iw/network18_logo_01082017.png" width="20" height="20" alt="" class="FR" /></a>
			<div class="CL"></div>
		</div>
		<p class="blu18">Missed investment opportunities can <span>cost you dearly</span></p>
		<p style="margin:0"> Get critical & timely information
			on <strong>your Stocks</strong> on SMS, email 
			and on our desktop application</p>
		<p class="rd18 CTR"><!-- <strong>Special offer - 50% off</strong> --></p>
		<div class="CTR"><a href="https://investmentwatch.moneycontrol.com/tracker.php?package_id=1&utm_source=IW_PYTRHS" target="_blank"><img src="https://images.moneycontrol.com/images/promo/iw/book_now.gif" width="129" height="32" alt="" /></a></div>
	</div>
	<?
	$sqlch="select celeb_name, celeb_desgn, celeb_orgn, preface, rank, date_format(chat_date,'%d_%m_%Y') as folderdate, date_format(chat_date,'Day - %D %b. %Y<br> Time - %H.%ihrs') as cdate, status, file_name cfilename, autono from chat_plus where rank in(1,3,5,7) order by rank ";
	$q10->query($sqlch);
	$q10->next_record();
	$preface = $q10->f("preface");
	
	$cceoname = $q10->f("celeb_name");
	$cstatus = $q10->f("status");
	$cdesi = $q10->f("celeb_desgn");
	$corg = $q10->f("celeb_orgn");
	$folderdate = $q10->f("folderdate");
	$cceoname = ucwords($cceoname);
	if($cceoname != "" && $cdesi != "")
		$cdesi = "<strong>".$cceoname ."</strong>, ". $cdesi;
	if($cceoname!="" && $cdesi=="")
		$cdesi = "<strong>".$cceoname."</strong>";
	
	if(strlen($corg)!=1 && strlen($cdesi)!=0)
	{
		$corg=$corg;
	}
	$cdate = $q10->f("cdate");
	
	$cfilename = $q10->f("cfilename");
	$tmp = split (' ', $cceoname);
	$img = "https://images.moneycontrol.com/images/mcplus_plus/chat/".$tmp[0].".gif";
	$imgpath = "<img src='$img' border=0 width='60' height='60' class='FL MR10 brd3' >";

	if($cstatus=="live")
	{
		$chatgif="<img src='https://images.moneycontrol.com/images/news/homepage/chatani_live.gif'>";
		$ctrtime="";
		$ctrname=$cceoname;
		$joinnow="<br><a  href='http://chats.moneycontrol.com/mcplus/pyt_chat/mcchat_main.php' target='_new'><img src='https://images.moneycontrol.com/images/news/joinani.gif' border=0></a>";
		$currentchat="";
	}
	else if($cstatus=="next")
	{
		$chatgif="<img src='https://images.moneycontrol.com/images/news/icon_chat.gif'>";
		$ctrtime=$cdate;
		$ctrname="<a class=gfont><u>".$cceoname."</u></a>";
		$joinnow="";
	}
	else if($cstatus=="transcript")
	{
		$chatgif="<img src='https://images.moneycontrol.com/images/news/icon_chat.gif'>";
		$ctrtime=$cdate;
		$ctrname=$cceoname;
		$currentchat="<table width=100%><tr><td class=arial11blue><a  href=/news/mgmtinterviews/chats/archives_new.php target='_new'>Previous</a></td><td align=right class=arial11blue><a href=/news/mgmtinterviews/chats/detail_new.php target='_new'>Current</a></td></tr></table>";
		$joinnow="";
	}
	else if($cstatus=="upcoming")
	{
		$chatgif="<img src='https://images.moneycontrol.com/images/news/icon_chat.gif'>";
		$ctrname=$cceoname;
		$currentchat="<table width=100%><tr><td class=arial11blue><a  href=/news/mgmtinterviews/chats/archives_new.php target='_new'>Previous</a></td><td class=arial11blue align=right><a href=/news/mgmtinterviews/chats/detail_new.php?type=upcoming target='_new' >Upcoming</a></td></tr></table>";
		$joinnow="";
	}
	?>
	
		
	<b class="whbox"> <b class="whbox1"><b></b></b> <b class="whbox2"><b></b></b> <b class="whbox3"></b> <b class="whbox4"></b> <b class="whbox5"></b></b>
	<div class="whboxfg" id="market_action_chart">
		<div>
			<p class="gD_12 brd_b2 PB5">Market Action</p>
			<div class="MT5 PB5 brd_b">
				<p class="FL" style="width:90px"><a href="javascript:void(0);" class="act2"  id='boxgr1' onclick="show_market_action_chart('sensex');"><strong>Sensex</strong></a></p>
								<p class="CL"></p>
				<div class="MT5" id="showdiv1" style="display:block">
					<iframe id="market_action_chart_sensex" name="market_action_chart_sensex" src="https://www.moneycontrol.com/mccode/common/indices_chart/indices_chart.php?market=i&period=1d&ind_id=4&width=200&height=150" width="200" height="150" frameborder="0"></iframe>
				</div>
			</div>
			
			<div class="MT5 PB5 brd_b">
				<p class="FL" style="width:90px"><a href="javascript:void(0);" class="act1" id='boxgr2' onclick="show_market_action_chart('nifty');"><strong>Nifty</strong></a></p>
								<p class="CL"></p>
				<div class="MT5" id="showdiv2" style="display:none">
					<iframe id="market_action_chart_nifty" name="market_action_chart_nifty" width="200" height="150" frameborder="0"></iframe>
				</div>
			</div>
		</div>
	</div>
	<div class="PT10 bgw">
		<div class="rhd">
			<ul class="tab">
				<li><a href="javascript:void(0);" id="tab_1_1" onclick="show_gtab('1','1');" class="act">All Indices</a></li>
				<li><a href="javascript:void(0);" id="tab_1_2" onclick="show_gtab('1','2');">Commodities</a></li>
			</ul>
		</div>
		
		<div id="gtab_1_1" style="display:block">
			<div class="PA7 brd_b">
			<form name="indextech_frm" id="indextech_frm" method="post" onsubmit="" action="https://www.moneycontrol.com/stocks/cptmarket/indices_tech.php" target='_blank'>
			<input type="hidden" name="index_id" id="index_id">
			</form>
				<p><a href="javascript:void(0);" class="act22" id='boxg1' onclick="show_gal('1');"><strong>INDIAN INDICES</strong></a></p>
				<div class="MT7" id="showd1">
				<table width="100%" class="datatbl b_12">
				<?
				$index_sql="select bridgesymbol, shortname, lastprice, (lastprice-close) `change`, close, entdate, (CASE bridgesymbol WHEN 'IN;aox' THEN 0 WHEN 'IN;bkx' THEN 1 WHEN 'in;nbx' THEN 2 WHEN 'IN;CGX' THEN 3 WHEN 'IN;CDX' THEN 4 WHEN 'IN;FMX' THEN 5 WHEN 'IN;HAX' THEN 6 WHEN 'IN;ifx' THEN 7 WHEN 'IN;MLX' THEN 8 WHEN 'IN;ogx' THEN 9 WHEN 'in;pbx' THEN 10 WHEN 'in;tkx' THEN 11 WHEN 'in;BCX' THEN 12 WHEN 'in;bmx' THEN 13 WHEN 'in;ccx' THEN 14 end) sortorder from cnbc_indices where bridgesymbol in ('IN;aox','IN;bkx','in;nbx','IN;CGX','IN;CDX','IN;FMX','IN;HAX','IN;ifx','IN;MLX','IN;ogx','in;pbx','in;tkx','in;BCX','in;bmx','in;ccx') order by sortorder";
					
				$disp_ind=array(array("20", "BSE Auto"),array("18", "BANKEX"),array("23", "Bank Nifty"),array("13", "Capital Goods"),array("16", "Consumer Durables"),array("14", "BSE FMCG"),array("15", "BSE Healthcare"),array("17", "BSE IT"),array("21", "BSE Metals"),array("22", "Oil and Gas"),array("11", "BSE PSU"),array("10", "BSE TECk"),array("26", "BSE Small Cap"),array("25", "BSE Mid-Cap"),array("27", "CNX Midcap"));
				$ar = 0;
				$rec = mysqli_query($main_read, $index_sql);
				while($row = mysqli_fetch_array($rec))
				{
					$shortname = $row[1];
					$index_value = $disp_ind[$ar];

					$index_name = str_replace(' ', '-', strtolower($index_value[1]));
		            $index_link = "<a href='https://www.moneycontrol.com/indian-indices/".$index_name."-".$index_value[0].".html' class='bl_12 uline' target='_blank'>".$index_value[1]."</a>";
					
					$lastprice = $row[2];
					$change = $row[3];
					$chan = str_replace('-','',$change);

					if($change > 0)
						$color = "gr_12";
					elseif($change < 0)
						$color = "r_12";
					else
						$color = "b_12";

					echo "<tr><td width='42%'>".$index_link."</td><td width='36%' align='right'>".$lastprice."</td><td width='22%' align='right' class='".$color."'>".$change."</td></tr>";
					$ar++;
				}
				?>
				</table>
				</div>
			</div>
			<div class="PA7 brd_b">
				<p><a href="javascript:void(0);" class="act11" id='boxg2' onclick="show_gal('2');"><strong>GLOBAL INDICES</strong></a></p>
				<div class="MT7" id="showd2" style="display:none">
				<table width="100%" class="datatbl b_12">
				<?
				#$sql="select bridgesymbol, shortname, lastprice, (lastprice-close) `change`, close, entdate, (CASE bridgesymbol WHEN 'US;dji' THEN 0 WHEN 'us;COMP' THEN 1 WHEN 'JP;N225' THEN 2 WHEN 'sg;STII' THEN 3 WHEN 'cn;hsi' THEN 4 WHEN 'tw;IXTA' THEN 5 WHEN 'kr;KSPI' THEN 6 WHEN 'cn;shi' THEN 7 WHEN 'gb;FTSE' THEN 8 WHEN 'fr;CAC' THEN 9 WHEN 'de;qx' THEN 10 end) sortorder, date_format(ENTDATE,'%b %e') entrydate, ENTDATE, ENTTIME from cnbc_indices where bridgesymbol in ('US;dji','us;COMP','JP;N225','sg;STII','cn;hsi','tw;IXTA','kr;KSPI', 'cn;shi','gb;FTSE','fr;CAC','de;qx') order by sortorder";
				$sql="select bridgesymbol, shortname, lastprice, (lastprice-close) `change`, close, entdate, (CASE bridgesymbol WHEN 'US;dji' THEN 0 WHEN 'us;COMP' THEN 1 WHEN 'JP;N225' THEN 2 WHEN 'sg;STII' THEN 3 WHEN 'cn;hsi' THEN 4 WHEN 'tw;IXTA' THEN 5 WHEN 'kr;KSPI' THEN 6 WHEN 'cn;shi' THEN 7 WHEN 'gb;FTSE' THEN 8 WHEN 'fr;CAC' THEN 9 WHEN 'de;qx' THEN 10 end) sortorder, date_format(ENTDATE,'%b %e') entrydate, ENTDATE, ENTTIME from cnbc_indices where bridgesymbol in ('us;COMP','JP;N225','sg;STII','cn;hsi','tw;IXTA','kr;KSPI', 'cn;shi','gb;FTSE','fr;CAC','de;qx') order by sortorder";

				$rec = mysqli_query($main_read, $sql);
				$cc=0;
				while($row = mysqli_fetch_array($rec))
				{
					$shortname = $row[1];									
					if($shortname=="Dow Jones")
						$index_link = "<a href='https://www.moneycontrol.com/live-index/dowjones' target='_blank' class='bl_12 uline'>".$shortname."</a>";
					elseif($shortname=="Nasdaq")
						$index_link = "<a href='https://www.moneycontrol.com/live-index/nasdaq' target='_blank' class='bl_12 uline'>".$shortname."</a>";
					elseif($shortname=="FTSE")
						$index_link = "<a href='https://www.moneycontrol.com/live-market/ftse' target='_blank' class='bl_12 uline'>".$shortname."</a>";
					elseif($shortname=="CAC")
						$index_link = "<a href='https://www.moneycontrol.com/live-market/cac' target='_blank' class='bl_12 uline'>".$shortname."</a>";
					elseif($shortname=="DAX")
						$index_link = "<a href='https://www.moneycontrol.com/live-market/dax' target='_blank' class='bl_12 uline'>".$shortname."</a>";
					elseif($shortname=="Nikkei 225")
						$index_link = "<a href='https://www.moneycontrol.com/live-market/nikkei' target='_blank' class='bl_12 uline'>".$shortname."</a>";
					elseif($shortname=="Straits Times")
						$index_link = "<a href='https://www.moneycontrol.com/live-market/straitstimes' target='_blank' class='bl_12 uline'>".$shortname."</a>";
					elseif($shortname=="Hang Seng")
						$index_link = "<a href='https://www.moneycontrol.com/live-market/hangseng' target='_blank' class='bl_12 uline'>".$shortname."</a>";
					elseif($shortname=="Taiwan Index")
						$index_link = "<a href='https://www.moneycontrol.com/live-market/taiwan' target='_blank' class='bl_12 uline'>".$shortname."</a>";
					elseif($shortname=="KOSPI")
						$index_link = "<a href='https://www.moneycontrol.com/live-market/kospi' target='_blank' class='bl_12 uline'>".$shortname."</a>";
					elseif($shortname=="Shanghai Composite")
						$index_link = "<a href='https://www.moneycontrol.com/live-market/shanghai' target='_blank' class='bl_12 uline'>".$shortname."</a>";
					else
						$index_link = $shortname;

					$lastprice = $row[2];
					$sort_no = $row[6];
					$change = $row[3];
					$chan = str_replace('-','',$change);
					if($change > 0)
						$color = "gr_12";
					else if($change < 0)
						$color = "r_12";
					else
						$color = "b_12";

					$entrydate_main = $row[7];

					if(($shortname=="Dow Jones") || ($shortname=="Nasdaq"))
					{
						$entrydate_full = $row[8];
						$entry_time = $row[9];
						$entry_date_time=$entrydate_full." ".$entry_time;
						$start_time=strtotime($entry_date_time);
						$deduct_time=(60*60*9)+(60*30);
						$time_difference=$start_time-$deduct_time;
						//echo date('d-M-Y h:i:s',$time_difference);
						$entrydate="&nbsp;<font style='FONT-size:9px; FONT-family:arial; COLOR:#666666;FONT-WEIGHT:normal;'>(".date('M d',$time_difference).")</font>";
					}
					else
					{
						$entrydate="&nbsp;<font style='FONT-size:9px; FONT-family:arial; COLOR:#666666;FONT-WEIGHT:normal;'>(".$entrydate_main.")</font>";
					}
					
					$index_link.=$entrydate;
					$mkt_txt="";
					if($sort_no=='0')
					{
						$mkt_txt="<tr><td colspan='3' align='left' class='b_12'><B>US</B></td></tr>";
					}
					elseif($sort_no=='2')
					{
						$mkt_txt="<tr><td colspan='3' align='left' class='b_12'><B>Asia</B></td></tr>";
					}
					elseif($sort_no=='8')
					{
						$mkt_txt="<tr><td colspan='3' align='left' class='b_12'><B>Europe</B></td></tr>";
					}
					echo $mkt_txt;
				?>
				<tr>
					<td width="42%"></td>
					<td width="36%" align="right"></td>
					<td width="22%" align="right" class=""></td>
				</tr>
				<?
					unset($index_link);
					$cc++;
				}
				?>
				</table>
				</div>
			</div>
		</div>
		
		<div id="gtab_1_2" style="display:none" class="PA7 brd_b">
			<p class="act22"><strong>COMMODITY PRICES</strong></p>
			<div class="MT7">
			<table width="100%" class="datatbl b_12">
		<?
		$sql_com = "select (case bridgesymbol when 'GOLD0Y' then 1 when 'SILVER0Y' then 2 when 'COPPER0Y' then 3 when 'NICKEL0Y' then 4 when 'ALUMINIUM0Y' then 5 when 'CRUDEOIL0Y' then 6 when 'ZINC0Y' then 6 end) sortorder1, shortname, lastprice, close, `change`, percentchange, bridgesymbol from cnbc_indices where bridgesymbol in ('GOLD0Y','SILVER0Y','COPPER0Y','NICKEL0Y','ALUMINIUM0Y','CRUDEOIL0Y','ZINC0Y') order by sortorder1";
		$rec = mysqli_query($main_read, $sql_com);
		while($row = mysqli_fetch_array($rec))
		{
			$change=$row['lastprice']-$row['close'];
			$change = number_format($change,2);
			if($change > 0)
				$class = "gr_12";
			else if($change < 0)
				$class = "r_12";
			else
				$class = "b_12";
				
			if($row['bridgesymbol'] == "ALUMINIUM0Y")
				$shortname = "Aluminium";
			elseif($row['bridgesymbol'] == "NICKEL0Y")
				$shortname = "Nickel";
			elseif($row['bridgesymbol'] == "ZINC0Y")
				$shortname = "Zinc MCX";
			else $shortname = $row['shortname'];
			
			#echo $shortname."==<br>";
			echo "<tr><td width='42%'>".$shortname."</td><td width='36%' align='right'>".$row['lastprice']."</td><td width='22%' align='right' class='".$class."'>".$change."</td></tr>";
		}

		?>
			</table>
			</div>
		</div>
	</div>

	<div class="MT10 bgw">
		<div class="rhd">
			<ul class="tab">
				<li><a href="javascript:void(0);" id="tab_3_1" onclick="show_gtab('3','1');" class="act">MARKET STATS</a></li>
				<li><a href="javascript:void(0);" id="tab_3_2" onclick="show_gtab('3','2');">MARKET INFO</a></li>
			</ul>
		</div>
		<div class="PA10" id="gtab_3_1" style="display:block">
			<ul class="list1">
				<li><a href="https://www.moneycontrol.com/stocks/marketstats/bsegainer/index.php" target="_blank">Top Gainers</a></li>
				<li><a href="https://www.moneycontrol.com/stocks/marketstats/bseloser/index.php" target="_blank">Top Loser</a></li>
				<li><a href="https://www.moneycontrol.com/stocks/marketstats/highlows/index.php?sel_opt=highs" target="_blank">52 Week High</a></li>
				<li><a href="https://www.moneycontrol.com/stocks/marketstats/highlows/index.php?sel_opt=lows&sel_index=B|4" target="_blank">52 Week Low</a></li>
				<li><a href="https://www.moneycontrol.com/stocks/marketstats/onlybuyers.php" target="_blank">Only Buyers</a></li>
				<li><a href="https://www.moneycontrol.com/stocks/marketstats/onlysellers.php" target="_blank">Only Sellers</a></li>
				<li><a href="https://www.moneycontrol.com/stocks/marketstats/bse_pshockers/index.php" target="_blank">Price Shockers</a></li>
				<li><a href="https://www.moneycontrol.com/stocks/marketstats/bse_vshockers/index.php" target="_blank">Volume Shockers</a></li>
			</ul>
		</div>

		<div class="PA10" id="gtab_3_2" style="display:none">
			<ul class="list1">
				<li><a href="https://www.moneycontrol.com/india/stockmarket/statistics/blockdeals/02/40/BSE" target="_blank">Bulk Deals On BSE</a></li>
				<li><a href="https://www.moneycontrol.com/india/stockmarket/statistics/blockdeals/02/40/NSE" target="_blank">Bulk Deals On NSE</a></li>
				<li><a href="https://www.moneycontrol.com/india/stockmarket/foreigninstitutionalinvestors/02/40/activity/FII" target="_blank">FII Activity</a></li>
				<li><a href="https://www.moneycontrol.com/india/stockmarket/foreigninstitutionalinvestors/02/40/activity/MF" target="_blank">MF Activity</a></li>
				<li><a href="https://www.moneycontrol.com/stocks/marketinfo/meetings.php?opttopic=brdmeeting" target="_blank">Board Meetings</a></li>
				<li><a href="https://www.moneycontrol.com/stocks/marketinfo/meetings.php?opttopic=bookclosure" target="_blank">Book Closures</a></li>
				<li><a href="https://www.moneycontrol.com/stocks/marketstats/bsetopdiv/div_calendar.php" target="_blank">Dividend Calendar</a></li>
			</ul>
		</div>
	</div>
	
	<div class="MT10 bgw">
		<div class="rhd1 w_12"><strong>BROKERAGE RECCOS</strong></div>
		<div class="PA10">
			<ul class="list">
			<?
			$sql_rec = "Select ent_date, autono, heading,video_path,video_flag from NEWS_PUBLISH where category in  ('Recommendations','FIIs on Results','Brokerage Recos') and (related_scid<>'NULL' and related_scid is not NULL) and publish='Y'order by ent_date desc limit 0,5";
			$result_rec = mysqli_query($main_read, $sql_rec);
			$cntt = 0;
			while($row_rec = mysqli_fetch_array($result_rec))
			{
				$cntt++;
				$heading_rec = $row_rec['heading'];
				$autono_rec = $row_rec['autono'];
				echo "<li><a href='https://www.moneycontrol.com/mccode/news/article/news_article.php?autono=".$autono_rec."' target='_blank'>".$heading_rec."</a></li>";
			}
			?>
			</ul>
			<p class="MT5"><a href="/plus/listing/index.php?category=BrokReco" class="bl_12">Read All</a></p>

		</div>
	</div>
	
	<div class="MT10 bgw">
		<div class="rhd1 w_12"><strong>IPO NEWS</strong></div>
		<div class="PA10">
			<ul class="list">
			<?
			$sql = "Select ent_date, autono, heading,video_path,video_flag from NEWS_PUBLISH where category like ('IPO%') and publish='Y'order by ent_date desc limit 0,3";
			$result = mysqli_query($main_read, $sql);
			while($row1=mysqli_fetch_array($result))
			{
				$heading = $row1['heading'];
				$autono = $row1['autono'];
				echo "<li><a href='https://www.moneycontrol.com/mccode/news/article/news_article.php?autono=".$autono."' target='_blank'>".$heading."</a></li>";
			}
			?>
			</ul>
			<p class="MT5"><a href="https://www.moneycontrol.com/mccode/news/marketnews/marketnews.php?category=17" class="bl_12" target='_blank'>Read All</a></p>
		</div>
	</div>
</div>
<?
Close_Connection($main_read);
?>			</div>
			<div class="CL"></div>
		</div> 
		<div><img src="https://images.moneycontrol.com/images/pyt_2010/btmc.gif" width="988" height="10" alt="" /></div>
	</div>
</div>
<?
require_once( $_SERVER['DOCUMENT_ROOT']."/plus/footer.php");
?>
</body>
</html>