{dede:field name='id' runphp='yes'}
global $dsql;
$aid=(int)$DedeMeValue;
$t=$dsql->GetOne("SELECT a.title,a.litpic,t.body,t.match_id FROM `#@__archives` a LEFT JOIN `#@__addonteams` t ON t.aid=a.id WHERE a.id='$aid'");
if(!is_array($t)){ $DedeMeValue='
数据不存在
'; }
else{
$title=htmlspecialchars($t['title']);
$body=$t['body']?trim($t['body']):'本站为您聚合'.$title.'最新赛程、直播信号、阵容名单与相关资讯。';
// 关联赛事名;运动类型按赛事标题判定,取不到默认足球
$leagueName='';$tkind='zuqiu';
if((int)$t['match_id']>0){ $lg=$dsql->GetOne("SELECT title FROM `#@__archives` WHERE id='".(int)$t['match_id']."'"); if(is_array($lg)){ $leagueName=htmlspecialchars($lg['title']); $tkind=function_exists('zb_sport_kind')?zb_sport_kind(0,$lg['title'],''):'zuqiu'; } }
$logo=function_exists('zb_litpic_pool')?zb_litpic_pool($t['litpic'],$aid,$tkind):htmlspecialchars($t['litpic']);
$h='
';
$dsql->SetQuery("SELECT l.aid,l.teamz_id,l.teamk_id,l.teamz_num,l.teamk_num,l.matchdatetime,l.is_finish,z.title zn,k.title kn FROM `#@__addonlive` l LEFT JOIN `#@__archives` z ON z.id=l.teamz_id LEFT JOIN `#@__archives` k ON k.id=l.teamk_id WHERE l.teamz_id='$aid' OR l.teamk_id='$aid' ORDER BY l.matchdatetime DESC LIMIT 10");
$dsql->Execute('sc');
$sc=0;
while($r=$dsql->GetArray('sc')){
$sc++;
$zn=htmlspecialchars($r['zn']?:'-'); $kn=htmlspecialchars($r['kn']?:'-');
$tm=$r['matchdatetime']?date('m-d H:i',$r['matchdatetime']):'--';
$ts=intval($r['matchdatetime']);$gap=$ts-time();$fin=intval($r['is_finish']);
if($fin==1||$gap<=-10800){ $scls='ended';$stxt='看录像';$stt='录像回看'; } // 已标记完赛或开赛超3小时
elseif($gap>1800){ $scls='';$stxt='观看直播';$stt='赛前预告'; } // 未开赛
else{ $scls='live';$stxt='观看直播';$stt='正在直播'; } // 近3小时内=直播中
$zcls=((int)$r['teamz_id']==$aid)?' class="active-team"':'';
$kcls=((int)$r['teamk_id']==$aid)?' class="active-team"':'';
$btn=''.$stxt.'';
$h.='
'.($leagueName?$leagueName:'赛事').''.$tm.'
'.$zn.'VS'.$kn.'
'.$btn.'
';
}
if(!$sc) $h.='
暂无近期比赛日程记录
';
$h.='
';
// 3. 阵容名单
$h.='
球队阵容名单
';
$dsql->SetQuery("SELECT a.id,a.title FROM `#@__addonplayer` p JOIN `#@__archives` a ON a.id=p.aid WHERE p.team_id='$aid' AND a.arcrank>=0 ORDER BY a.id LIMIT 12");
$dsql->Execute('pl'); $pn=0;
while($p=$dsql->GetArray('pl')){ $pn++;
$h.='
';
$dsql->SetQuery("SELECT id,title,litpic,pubdate FROM `#@__archives` WHERE channel=10 AND arcrank>=0 AND title LIKE '%$kw%' ORDER BY id DESC LIMIT 6");
$dsql->Execute('nw'); $nn=0;
while($n=$dsql->GetArray('nw')){ $nn++;
$img=htmlspecialchars(zb_litpic_pool($n['litpic'],intval($n['id'])));
$h.='