= CURDATE() || A.exp_date ='0000-00-00')";
$rs=mysql_query($sql, $link);
list($rid, $filename, $rtype, $language, $pages, $status, $searchflag, $expdate)=mysql_fetch_array($rs);
if($rtype=="f"){
$sql="select filename from financial_info_attachment where ticker='".$rticker."' and fid='".$rid."' and type='4' and language='".$language."' ";
//echo "";
list($filename)=mysql_fetch_array(mysql_query($sql, $link));
//echo "";
}
if( ($status=="1") || ( (isset($_SESSION['eipsystemid']) || isset($_SESSION['ticker'])) && !empty($rid) ) ){
$version=$language=="e"?"0":$rregionid;
$sql="select ".$language."_symbol, website, themecolor, fontcolor, logopic, ".$language."_memo from canpanel_".$region[$rregionid]." where ticker='$rticker' ";
$rs=mysql_query($sql, $link);
list($symbol, $website, $themecolor, $fontcolor, $logopic, $footer)=mysql_fetch_array($rs);
$nop=strlen($pages);
if($language=="s"){
include "define_".$version."_".$language.".php";
}else{
include "define_".$version.".php";
}
if($rtype=="a"){
$title=$rid.$txannualreport;
$targetpath="/".$regionfolder[$rregionid]."/".$rticker."/annual/".$rid."/".$languagefolder[$language]."/";
$sql="select report, report_title from annual_report where ticker='$rticker' and year='$rid' and language='$language' ";
$rsreport=mysql_query($sql, $link);
list($report, $title)=mysql_fetch_array($rsreport);
}elseif($rtype=="2"){
$title=$rid.$txannualreportpart2;
$targetpath="/".$regionfolder[$rregionid]."/".$rticker."/annual2/".$rid."/".$languagefolder[$language]."/";
$sql="select report, report_title from annual2_report where ticker='$rticker' and year='$rid' and language='$language' ";
list($report, $title)=mysql_fetch_array(mysql_query($sql, $link));
}elseif($rtype=="f"){
$sql="select ".$language."_title from financial_info where ticker='$rticker' and id=$rid";
$rstitle=mysql_query($sql, $link);
list($title)=mysql_fetch_array($rstitle);
$targetpath="/".$regionfolder[$rregionid]."/".$rticker."/financial/".$rid."/".$languagefolder[$language]."/";
$sql="select title, filename from financial_info_attachment where ticker='$rticker' and fid=$rid and type='4' and filename='".$filename."' and language='$language' ";
$rsreport=mysql_query($sql, $link);
list($title, $report)=mysql_fetch_array($rsreport);
if($rregionid!="2"){
$report=$filename;
}
}
$sourcecharset=($language=="c" && ($rregionid=="1" || $rregionid=="2"))?$regcharset[$rregionid]:"utf-8";
/*$charset=($language=="c" && ($rregionid=="1" || $rregionid=="2"))?$regcharset[$rregionid]:"utf-8";
if($language=="s"){
$charset="utf-8";
}*/
$charset="utf-8";
}else{
$sql="select A.rid, A.type, A.language, A.pages, A.status, A.search from canreport A where A.ticker='$rticker' and A.id=$id ";
$rs=mysql_query($sql, $link);
list($rid, $rtype, $language, $pages, $status, $searchflag, $expdate)=mysql_fetch_array($rs);
if($status=="1"){
header("location: expired.php");
}else{
header("location: notexists.php?regionid=".$rregionid);
}
}
?>
CANreport