run_mode = DB_RUN_DEBUG;
$item_per_page = 5;
/******************************************************************************
* 매개변수
******************************************************************************/
$p_page = intval($p_page);
$p_page = max($p_page, 1);
$p_pl_code = trim($p_pl_code);
$p_run_mode = trim($p_run_mode);
/**** modified by allou at 20080310
$list_url = $PHP_SELF . '?pl_bcode=' . $p_pl_bcode;
****/
$list_url = $PHP_SELF . '?pl_code=' . $p_pl_code;
/******************************************************************************
* 페이징하기 위한 정보 처리
******************************************************************************/
$where = array();
/**** 동영상인코딩, modified by allou at 200704
$where[] = 'a.pl_code=b.pl_bcode';
[**** 서비스시작(service_start), 서비스제공기간(service_term) 무의미함. 조건제외
***** blocked by allou at 20060803
$where[] = 'GETDATE() BETWEEN a.service_start AND DATEADD(week, 8, a.service_start)';
****]
$where[] = 'service_status=\'Y\'';
//$where[] = 'DATEDIFF(yy, GETDATE(), a.relay_time)=0';
if( $param[pl_bcode] != "" ) $where[] = ' b.pl_bcode="'.$param[pl_bcode].'"';
****/
$where[] = 'service_status=\'Y\'';
if($p_pl_code != '') $where[] = "pl_code='$p_pl_code'";
// 2008북경 중계, added by allou at 20080808
else { $where[] = 'pl_code < \'90\''; }
//총건수
/**** 동영상인코딩, modified by allou at 200704
$sql = sprintf("SELECT COUNT(DISTINCT a.replay_key) AS cnt FROM tb_sports_replay a, tb_play_code b WHERE %s"
, implode(' AND ', $where));
****/
$sql = sprintf("SELECT COUNT(replay_key) AS cnt FROM tb_sports_replay WHERE %s"
, implode(' AND ', $where));
$g_db_news->Query($sql, $temprow);
$totalCnt = $temprow[0]['cnt'];
// 페이징 정보를 구한다.
$paging = GetPaging($totalCnt, $item_per_page, $p_page, $list_url);
//목록
/**** 동영상인코딩, modified by allou at 200704
$sql = 'SET ROWCOUNT %d'
. ' SELECT DISTINCT a.replay_key, b.pl_bcode, a.pl_code, a.htitle, a.btitle, a.image_s, a.image_u, a.channel, a.relay_time, a.service_term'
. ' FROM tb_sports_replay a, tb_play_code b'
. ' WHERE %s'
. ' ORDER BY a.relay_time DESC'
. ' SET ROWCOUNT 0';
$sql = sprintf($sql, ($param[page]*$param[page_per_cnt]), implode(' and ', $where ));
//printf("\n
sql=[ %s ]", $sql);
$num_seek = ($param[page]-1) * $param[page_per_cnt];
$rsCnt = $g_db_news->Query($sql, $row,$param[page_per_cnt],$num_seek);
//$totalCnt = $g_db_news->Query($sql, $temprow);
****/
$sql = sprintf("
SET ROWCOUNT %d
SELECT replay_key, pl_code, htitle, btitle, image_s, image_u, channel, relay_time, service_term
FROM tb_sports_replay
WHERE %s
ORDER BY relay_time DESC
SET ROWCOUNT 0"
, ($p_page*$item_per_page), implode(' AND ', $where));
// 리스트할 뉴스의 시작 위치
$item_start_pos = ($p_page - 1) * $item_per_page;
$arr = array();
$cnt = $g_db_news->Query($sql, $arr, $item_per_page, $item_start_pos, true);
for($i=0; $i<$cnt; $i++) {
$row = &$arr[$i];
$row['_relay_time'] = TimeFormat(SybTm2UnixTm($row['relay_time']), -1, 'Y년 n월 j일');
$row['_channel'] = $channelArr[$row['channel']];
if(strlen($row['image_u']) > 0) $row['_image_link'] = $row['image_u'];
else{
if(strlen($row['image_s']) > 0) $row['_image_link'] = $row['image_s'];
}
if($p_run_mode != 'preview' && $row['_image_link']) {
$row['_image_link'] = DOMAIN_IMAGE . $row['_image_link'];
}
$sql = sprintf("SELECT replay_subkey, seq, title, filename, filename2 FROM tb_sports_replay_file WHERE replay_key=%d"
, $row['replay_key']);
$fileArr = array();
$fileCount = $g_db_news->Query($sql, $fileArr, 0, 0, false, '', 'seq');
$row['filecount'] = $fileCount;
$row['file'] = $fileArr;
unset($row);
}
/**** 동영상인코딩, modified by allou at 200704
$sql = "select distinct pl_bname,pl_bcode from tb_play_code";
$g_db_news->Query($sql,$pl_name_arr);
$pl_name_list = "";
$pl_name_list .= "";
foreach($pl_name_arr as $key=>$rs)
{
($param[pl_bcode] == $rs[pl_bcode]) ? $selected = "selected" : $selected = "";
$pl_name_list .= "";
}
****/
getPlayCode($plcodeArr);
// 2008북경 중계, added by allou at 20080808
ksort($plcodeArr);
$plcodeArr = array_slice($plcodeArr, 0, 7);
$g_db_news->close();
include('replay_index_main.html');
?>