// if($_GET[fbclass]=="view"){
// $sql_str="INSERT INTO analysis SET parm='fbclass',
// mag='ad',
// add_date='".date("Y-m-d")."'
// ";
// mysql_query($sql_str);
// }
// if($_GET[googleclass]=="view"){
// $sql_str="INSERT INTO analysis SET parm='googleclass',
// mag='ad',
// add_date='".date("Y-m-d")."'
// ";
// mysql_query($sql_str2);
// }
if($_GET['testdate'] == "")
{
if($_GET['current_month'] == "")
{
if ($_GET['volume'] == "")
{
//$current_month = date('Y-m-01');
$volume = date('Y-m-01');
} else {
$volume = $_GET['volume'];
}
}
else
{
//$current_month = $_GET['current_month'];
$volume = $_GET['current_month'];
}
}
else
{
//$current_month = $_GET['testdate'];
$volume = $_GET['testdate'];
}
if (!isset($_GET['article_id'])) {
header("location:/ad");
} else {
$article_id = trim($_GET['article_id']);
};
if (substr($article_id,3,1)=='d') {
$a_no=substr($article_id,4,2);
} else {
$a_no=substr($article_id,3,2);
}
//$file_prefix = "http://air.hihit.net/studio/AD" . substr($current_month,2,2) . substr($current_month,5,2) . "_" . $a_no;
// Obtain Topic Talk info
$file_prefix = "http://203.69.69.81/studio/AD" . substr($current_month,2,2) . substr($current_month,5,2) . "_" . $a_no;
$tt_query = "SELECT * FROM topic_talk WHERE article_id='$article_id' AND volume='$volume' ";
//2020.11.5 ��ƪ�topic_talk�W�[volume��primary_key
//$tt_query = "SELECT * FROM topic_talk WHERE article_id='$article_id';";
//print $tt_query;
$tt_result = mysql_query($tt_query);
if (mysql_num_rows($tt_result) == 0) {
echo "Sorry! The Topic Talks for this article is no longer available online.";
exit;
};
$tt_row = mysql_fetch_array($tt_result,MYSQL_ASSOC);
if ($current_month != "")
{
$monthname = MonthChange($current_month);
}
// Obtain all information for article listing
/*
$article_query =
"SELECT article_id,date_range,title_eng,volume FROM article
WHERE magazine='A' AND is_published='Y' AND volume='$current_month' ORDER BY article_id";
*/
$article_query =
"SELECT article_id,date_range,title_eng,volume FROM article
WHERE magazine='A' AND is_published='Y' AND volume='$volume' ORDER BY article_id";
$article_result = mysql_query($article_query);
//echo $article_query;
while ($article_row = mysql_fetch_array($article_result,MYSQL_ASSOC)) {
$article[$article_row['article_id']]['date_range'] = $article_row['date_range'];
$article[$article_row['article_id']]['title_eng'] = $article_row['title_eng'];
};
?>