堪萨斯城竞技VS皇家盐湖城直播与录像

相关资讯 · 视频 · 集锦

{dede:field name='arcid' runphp='yes'} global $dsql; function zb_t_h3($s){return htmlspecialchars((string)$s,ENT_QUOTES,'UTF-8');} $u3=ZB_THEME_LIB.'/zb_url.php'; if(is_file($u3)) require_once $u3; $tid=intval($GLOBALS['ZB_TAG_TID']); if(!$tid){ $DedeMeValue='

暂无相关资讯

'; } else{ $dsql->SetQuery("SELECT a.id,a.channel,a.title,a.description,a.pubdate,tp.typename FROM `#@__taglist` tl JOIN `#@__archives` a ON a.id=tl.aid AND a.channel IN (10,11,12,13) AND a.arcrank>-1 LEFT JOIN `#@__arctype` tp ON tp.id=a.typeid WHERE tl.tid=$tid ORDER BY a.id DESC LIMIT 20"); $dsql->Execute('tn');$rows=array();while($r=$dsql->GetArray('tn'))$rows[]=$r; // 兜底:无精确tag关联时,按队名/联赛名/标签名标题LIKE资讯+视频+录像+集锦 if(empty($rows)&&!empty($GLOBALS['ZB_TAG_FBKW'])){ $lk=array();foreach($GLOBALS['ZB_TAG_FBKW'] as $fw){$fw=addslashes($fw);$lk[]="a.title LIKE '%$fw%'";} $dsql->SetQuery("SELECT a.id,a.channel,a.title,a.description,a.pubdate,tp.typename FROM `#@__archives` a LEFT JOIN `#@__arctype` tp ON tp.id=a.typeid WHERE a.arcrank>-1 AND a.channel IN (10,11,12,13) AND (".implode(' OR ',$lk).") ORDER BY a.id DESC LIMIT 20"); $dsql->Execute('tnf');while($r=$dsql->GetArray('tnf'))$rows[]=$r; } if(empty($rows)){ $DedeMeValue='

该标签暂无相关资讯

'; } else{ $h='

'; foreach($rows as $r){ $desc=trim((string)$r['description']); if($desc==='')$desc='点击查看「'.zb_t_h3($r['title']).'」详细内容'; $ctype=intval($r['channel'])==11?'视频':(intval($r['channel'])==13?'集锦':'资讯'); $h.='

' .'

'.zb_t_h3($r['title']).'

' .'

'.zb_t_h3(cn_substr($desc,120)).'

' .'

类型: '.$ctype.'栏目: '.zb_t_h3($r['typename']).'时间: '.date('Y-m-d',intval($r['pubdate'])).'

' .'

'; } $h.='

';$DedeMeValue=$h; } } {/dede:field}