//require_once( $_SERVER['DOCUMENT_ROOT']."/phplib/db_mysql_mcplus.php");
//$q = new DB_Sql_mcplus();
$broker = $_REQUEST['broker'];
$tag_array = array("Angel Broking"=>"PYT_210x600_AngelBroking","Bonanza"=>"PYT_210x600_Bonanza",
"Hem Securities"=>"PYT_210x600_HEMSecurities","IFCI Financial Services"=>"PYT_210x600_IFCI",
"Karvy Stock Broking"=>"PYT_210x600_Karvy","KR Choksey"=>"PYT_210x600_KRChoksey",
"Motilal Oswal"=>"","Sushil Finance"=>"PYT_210x600_SushilFinance",
"Ventura Securities"=>"PYT_210x600_VenturaSecurities","Emkay Global"=>"PYT_210x600_EmkayGlobal",
"Nirmal Bang"=>"PYT_210x600_NirmalBang","Mitesh Thacker"=>"PYT_210x600_Mitesh_Thacker",
"Indiabulls Securities"=>"PYT_210x600_Indiabulls","Aditya Birla Money"=>"PYT_210x600_AdityaBirlaMoney");
$tag =$tag_array[$broker];
//"Motilal Oswal"=>"PYT_210x600_MotilalOswal"
$rhs_banner_broker = '';
if(trim($_REQUEST['broker']) == 'Motilal Oswal'){
$rhs_banner_broker = '';
}else if(trim($_REQUEST['broker']) == 'Ventura Securities'){
$rhs_banner_broker = '';
}else if(trim($_REQUEST['broker']) == 'Sushil Finance'){
$rhs_banner_broker = '';
}else if(trim($_REQUEST['broker']) == 'Nirmal Bang'){
$rhs_banner_broker = '';
}
echo $rhs_banner_broker;
if($tag!='')
{
?>
### Chat link ###
if($broker!=''){
$q10 = new DB_Sql_mcplus_news();
$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
Time - %H.%ihrs') as cdate, status, file_name cfilename, autono from chat_plus where CELEB_ORGN ='".$broker."' order by chat_date desc limit 1 "; $q10->query($sqlch); $tot = $q10->num_rows(); if($tot>0){ $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 = "".$cceoname .", ". $cdesi; if($cceoname!="" && $cdesi=="") $cdesi = "".$cceoname.""; 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 = "
";
if($cstatus=="live")
{
$chatgif="
";
$ctrtime="";
$ctrname=$cceoname;
$joinnow="
";
$currentchat="";
}
else if($cstatus=="next")
{
$chatgif="
";
$ctrtime=$cdate;
$ctrname="".$cceoname."";
$joinnow="";
}
else if($cstatus=="transcript")
{
$chatgif="
";
$ctrtime=$cdate;
$ctrname=$cceoname;
$currentchat="
";
$joinnow="";
}
else if($cstatus=="upcoming")
{
$chatgif="
";
$ctrname=$cceoname;
$currentchat="
";
$joinnow="";
}
?>
}//if
}//if
### Research report #####
$sql = "select id,broker_id,heading,file_flag,file_name, date_format(ent_date,'%d%m/%Y %H:%i') ent_date from pyt_broker_msg where broker_id in(select code from pyt_broker_detail where name = '".$broker."') order by ent_date desc limit 5";
$result = $q->query($sql);
$nr = $q->num_rows();
if($nr){
echo'
';
}
}
else
{
echo'
Time - %H.%ihrs') as cdate, status, file_name cfilename, autono from chat_plus where CELEB_ORGN ='".$broker."' order by chat_date desc limit 1 "; $q10->query($sqlch); $tot = $q10->num_rows(); if($tot>0){ $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 = "".$cceoname .", ". $cdesi; if($cceoname!="" && $cdesi=="") $cdesi = "".$cceoname.""; 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 = "
";
$ctrtime="";
$ctrname=$cceoname;
$joinnow="
";
$currentchat="";
}
else if($cstatus=="next")
{
$chatgif="| Previous | Current |
| Previous | Upcoming |
EXCLUSIVE LIVE CHAT!
Research Report
- ';
while($q->next_record()){
if($q->f('file_flag')=='y'){
$file_name = 'https://poweryourtrade.moneycontrol.com';
$file_name .= $q->f('file_name');
echo'
- '.wordwrap(substr($q->f('heading'),0,65),30,"
\n",true).' ';
}
}
echo'
';
#require_once( $_SERVER['DOCUMENT_ROOT']."/plus/common_rhs.php");
#require_once( $_SERVER['DOCUMENT_ROOT']."/plus/rhs/homebody.php");
require_once( $_SERVER['DOCUMENT_ROOT']."/plus/rhs/homebody.php");
echo'
';
}
?>
