session_start();
require_once("login/authenticate.php");
require_once("phplib/db_mysql_eagri.php");
$type="GC";
$q=new DB_Sql();
$q1=new DB_Sql();
$common_top=join(" ", file("http://www.commoditiescontrol.com/eagritrader/home_menu.php?cid=1&userid=$userid&login=$login"));
$common_footer=join(" ", file("http://127.0.0.1/eagritrader/common/footer.php"));
$type="GST";
$itemid=$id;
$Vcomments=join(" ", file('http://127.0.0.1/eagritrader/common/news_comments.php?itemid='.$itemid.'&type='.$type.'&cid='.$cid.'&varid='.$varid));
$sqlCount="select count(id) as count from news_comment where type='".$type."' and itemid='".$itemid."'";
if($cid)
{
$sqlCount.=" and commodityid='".$cid."'";
}
$sqlCount.=" and active='Y'";
$q->query($sqlCount);
$q->next_record();
$rec=$q->f("count");
//echo "rec => ".$rec;
/**************traking Page View********************/
$news_count = join(" ", file('http://127.0.0.1/eagritrader/news_track.php?itemid='.$itemid.'&type='.$type.'&cid='.$cid.'&varid='.$varid));
//$news_count = count_page_view($type,$itemid,$cid,$varid);
if($news_count)
{
$news_count="Viewed: $news_count ";
}
/**************traking Page View********************/
/*
$sql="select count from news_track where itemid=".$itemid." and type='".$type."'";
$q1->query($sql);
$c=0;
if($q1->next_record())
{
$c=$q1->f("count");
$news_count=$c;
$c=$c+1;
$sql5="update news_track set count=".$c.",update_date=now() where itemid=".$itemid ." and type='".$type."'";
}
else
{
$c=1;
$sql5="insert into news_track(itemid,comid,varid,type,count,news_date,update_date) values(".$itemid.",".$cid.",'".$varid."','".$type."',".$c.",now(),now())";
}
if(($_SERVER['REMOTE_ADDR']=="210.211.136.143") || ($_SERVER['REMOTE_ADDR']=="202.149.219.148"))
{
}
else
{
//$q1->query($sql5);
}
if($news_count)
{
$news_count="Viewed:$news_count ";
}
*/
//$Comment_link="[ Share your comments ] ";
if($rec>0)
{
//$Comment_link.=" [ view all comments ] ";
}
$Mysql="select id,topic,name,Photo,companyname,guest_columns.guestid,designation,details,guest_columns.PostedDate from guest_master inner join guest_columns on guest_master.guestid=guest_columns.guestid where id = ".$id."";
//echo $Mysql;
//exit;
$q->query($Mysql);
while($q->next_record())
{
$name=$q->f("name");
$topic=$q->f("topic");
$designation=$q->f("designation");
$companyname=$q->f("companyname");
$detail=$q->f("details");
$posted_date=$q->f("PostedDate");
$date_time=$q->f("PostedDate");
$display_photo="
f("Photo")." width=\"50px\" height=\"50px\" border=1>
";
$display_bottom="- ".$name;
if($designation)
{
$display_bottom.=",".$designation;
}
if($companyname){
$display_bottom.=",".$companyname;
}
//$posted_date=substr($q->f("PostedDate"),8,2)."-".date("m",strtotime($q->f("PostedDate")))."-".substr($q->f("PostedDate"),11,5);
}
if($previous || $next){
$gColumns="".join(" ", file('http://127.0.0.1/eagritrader/guesttop5.php?guestid='.$guestid.'&id='.$id.''))." ";
}
//$gstCols="".join(" ", file('http://127.0.0.1/eagritrader/coltop3.php?guestid='.$guestid.'&id='.$id.''))." ";
//$gsts="".join(" ", file('http://127.0.0.1/eagritrader/top5guest.php?guestid='.$guestid.'&id='.$id.''))." ";
########### CHAT END ########################
?>
commoditiescontrol.com - Top Gainers in MCX, Top Losers in MCX,
Expert Talk, Agri News, Weather News, World Press, Shipping News, Events,
Plant Quotes, Arrivals, International Quotes, Domestic Quotes, FOREX, Veg
Oils, Pulses, Cotton, Spices, Grains, Precious Metals, Metals, Energy,
Pulses, Cotton, Spices, Grains, Precious Metals, Metals, Energy, Others, Soy
Complex, Soy Complex, Others
if($login == 'mctest' || $login == 'tech')
{
?>
}
?>
Comments |
Post Comment |
Email |
Print |
Font Size A A A
".$detail.""; ?>
$sqlback="select id,Topic, Name,Photo,CompanyName,Designation,guest_columns.PostedDate from guest_master, guest_columns where guest_master.guestid=guest_columns.guestid and guest_master.guestid='".$guestid."' and id < ".$id." order by id desc limit 1";
//echo $sqlback;
$q->query($sqlback);
if($q->next_record()){
$itemid3=$q->f("id");
$caption3=$q->f("Topic");
$previous="
";// onMouseover=\"EnterContent3('ToolTip','Previous news:','$caption3'); Activate();\" onMouseout=\"deActivate()\"
}
$sqlNext="select id,Topic,Name,Photo,CompanyName,Designation,guest_columns.PostedDate from guest_master,guest_columns where guest_master.guestid=guest_columns.guestid and guest_master.guestid='".$guestid."' and id > ".$id." order by id asc limit 1";
$q->query($sqlNext);
if($q->next_record()){
$itemid3=$q->f("id");
$caption3=$q->f("Topic");
$next="
";// onMouseover=\"EnterContent3('ToolTip','Next news:','$caption3'); Activate();\" onMouseout=\"deActivate()\"
}
if($previous || $next)
{
echo "".$previous." ".$next." ";
echo "
";
}
?>
//$top5=join(" ", file("http://www.commoditiescontrol.com/eagritrader/common/top5news.php?type=" . $type . "&itemid=" . $itemid . "&comid=" . $cid . "&cid1=" . $cid . "&varietyid=" . $varid . "&varid=" . $varid . "&log=Y&userid=$userid"));
$rating=join(" ", file("http://www.commoditiescontrol.com/eagritrader/common/news_rating.php?type=" . $type . "&itemid=" . $itemid . "&comid=" . $cid . "&cid1=" . $cid . "&varietyid=" . $varid . "&varid=" . $varid . "&log=Y&userid=$userid"));
$comments=join(" ", file("http://www.commoditiescontrol.com/eagritrader/common/news_comments.php?type=" . $type ."&cap=".urlencode($topic)."&itemid=" . $itemid . "&comid=" . $cid . "&cid1=" . $cid . "&varietyid=" . $varid . "&varid=" . $varid . "&log=Y&userid=$userid"));
echo $rating;
echo " ";
echo $comments;
?>
$top5comments=join(" ", file("http://127.0.0.1/eagritrader/common/top5comments.php?itemid=$itemid&type=ISS&varid=$varid&cid=$cid"));
$top5=join(" ", file("http://www.commoditiescontrol.com/eagritrader/common/top5news.php?type=" . $type . "&itemid=" . $itemid . "&comid=" . $comid_track . "&cid1=" . $cid1 . "&varietyid=" . $varietyid . "&varid=" . $varid . "&log=Y&userid=$userid"));
?>
include "/common/ht_count.php";
$key = array_search($_SERVER['REMOTE_ADDR'], $arr_iplist);
if($key=="")
{
include "http://gateway.commoditiescontrol.com/eagriAdmin1/eagritrader_english_page_count.php?pages=".$type."&cid=".$cid."&varid=".$varid;
}
/************************** Hits Tracking Page ************************************/
include "http://gateway.commoditiescontrol.com/eagriAdmin1/page_track.php?itemid=".$itemid."&type=".$type."&cid=".$cid."&varid=".$varid;
/************************** Hits Tracking Page ************************************/
?>