0))
{
// $query=$_SERVER['QUERY_STRING'];
$ref=$_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING'];
header("location: /eagritrader/login/login.php?referer=$ref");
exit;
}*/
//require_once("../phplib/alteon.php");
/*
*/
/* $pos = strstr($subs_opt, $comid);
if(($pos===false) || ($pos=="") || ($pos==0))
{
header("location: /eagritrader/login/errorlogin.php");
exit;
}
*/
require_once("phplib/db_mysql_eagri.php");
$q=new DB_Sql();
//echo "COM:".$cid;
//exit;
/////////chk subscription
if($cid==0 || $cid==""){
$sql="select commodityid from CommodityMaster where active='T'";
$q->query($sql);
while($q->next_record())
{
if($m_comsub == "")
$m_comsub = $q->f("commodityid");
else
$m_comsub = $m_comsub . "," . $q->f("commodityid");
}
}
else{
$m_comsub=$cid;
}
/*if($cid <> 0 and $cid <> "")
$m_comfilter = " where commodityid = " . $cid;
$sql = "select distinct commodityid from UserOptions" . $m_comfilter;
$q->query($sql);
while($q->next_record())
{
if($m_comsub == "")
$m_comsub = $q->f("commodityid");
else
$m_comsub = $m_comsub . "," . $q->f("commodityid");
}*/
//echo $sql;
//echo "
" . $m_comsub;
/*if($m_comsub == "")
{
header("location: /eagritrader/login/errorlogin.php");
exit;
}*/
//////////// end of chk subscription
$commname = "Home";
if($cid <> 0 and $cid <> "")
{
$sql = "select commodityname from CommodityMaster where commodityid = " . $cid;
$q->query($sql);
$q->next_record();
$commname = $q->f("commodityname");
}
if($varid <> 0 and $varid <> "")
{
$sql = "select varietyname from VarietyMaster where varietyid = " . $varid;
$q->query($sql);
$q->next_record();
$varname = " > " . $q->f("varietyname");
}
?>