0){ $ss = $db->get_one("SELECT * FROM {$DT_PRE}kword WHERE tid = '$tid'"); $tagname = $ss['tagname']; }else{ $tagname = ''; } $all = $db->query("SELECT `moduleid`,GROUP_CONCAT(aid) FROM {$table} WHERE tagid=".$tid." GROUP BY moduleid"); $list = array(); while($r = $db->fetch_array($all)) { $r['list'] = $r['GROUP_CONCAT(aid)']; unset($r['GROUP_CONCAT(aid)']); $list[] =$r; } $menu = array(); foreach($list as $b=>$y){ $tt['mid'] = $y['moduleid']; $tt['name'] = $MODULE[$y['moduleid']]['name']; $menu[] = $tt; } $otag = array(); $table1 = $DT_PRE."kword"; $condition = "item>0"; $res = $db->query("SELECT * FROM {$table1} WHERE {$condition} ORDER BY rand() limit 20"); while($r = $db->fetch_array($res)) { $otags[] = $r; } if($mid){ $wz_table = $DT_PRE.$MODULE[$mid]['module'].'_'.$mid; $condition = 'tagid = '.$tid.' AND moduleid='.$mid.' AND aid != 0'; $items = $db->count($table, $condition, $CFG['db_expires']); $wzs = $tags = array(); $pagesize = 8; $offset = ($page-1)*$pagesize; $url = "show-{$tid}-{$mid}"; $pages = pagetagmore($items, $pagesize, $page, $url); if($items) { $result = $db->query("SELECT aid FROM {$table} WHERE {$condition} ORDER BY addtime desc LIMIT {$offset},{$pagesize}", ($CFG['db_expires'] && $page == 1) ? 'CACHE' : '', $CFG['db_expires']); while($r = $db->fetch_array($result)) { $wzs[] = $r['aid']; } if($DT_IP=='112.237.170.122'){ //var_dump("SELECT aid FROM {$table} WHERE {$condition} ORDER BY addtime desc LIMIT {$offset},{$pagesize}");exit; } if(count($wzs)>1){ $wzids = implode(",",$wzs); $wz_condition = 'itemid in ('.$wzids.')'; }else{ $wz_condition = 'itemid = '.$wzs[0]; } $wz_result = $db->query("SELECT * FROM {$wz_table} WHERE {$wz_condition} ORDER BY addtime desc", ($CFG['db_expires'] && $page == 1) ? 'CACHE' : '', $CFG['db_expires']); while($wr = $db->fetch_array($wz_result)) { if($mid==34){ $wr['moburl'] = $MODULE[$mid]['mobile'].'show-'.$wr['itemid'].'.html'; }else{ $wr['moburl'] = $MODULE[$mid]['mobile'].$wr['linkurl']; } if($mid==34){ $wr['linkurl'] = $MODULE[$mid]['linkurl'].'show-'.$wr['itemid'].'.html'; }else{ $wr['linkurl'] = $MODULE[$mid]['linkurl'].$wr['linkurl']; } $tags[] = $wr; } $db->free_result($result); } $seotitle = array( '15'=>"资料下载", '21'=>"新闻动态", '25'=>"标准下载", '26'=>"法规资讯" ); if($seotitle[$mid]){ $ttitle = "标签:".$tagname."-".$tagname."相关".$seotitle[$mid]; }else{ $ttitle = "标签:".$tagname."-".$tagname."相关信息"; } $showpage = 1; $datetype = 4; $seo_title = "标签:".$tagname."-".$tagname."相关的".$MODULE[$mid]['name']."-中实仪信网"; $head_keywords = $tagname."相关的".$MODULE[$mid]['name'].",".$ttitle; $head_description = "中实仪信网中".$tagname."相关的".$MODULE[$mid]['name']."。"; $back_link = $forward; $head_name = $tagname; include template('show','lable'); }else{ $lists = $ert = array(); foreach($list as $k=>$v){ $ttable = $DT_PRE.$MODULE[$v['moduleid']]['module'].'_'.$v['moduleid']; $wz_condition = 'itemid in ('.$v['list'].')'; $ert = $db->query("SELECT * FROM {$ttable} WHERE {$wz_condition} ORDER BY addtime desc LIMIT 10"); while($r = $db->fetch_array($ert)) { if($v['moduleid']==34){ $r['linkurl'] = 'show-'.$r['itemid'].'.html'; } $lists[$v['moduleid']][] = $r; } } $showpage = 1; $datetype = 4; $seo_title = "标签:".$tagname."-".$tagname."相关的资讯、产品、企业、标准、资料、法规、知识等信息-中实仪信网"; $head_keywords = $tagname."相关的资讯,".$tagname."相关的产品,".$tagname."相关的企业,".$tagname."相关的标准,".$tagname."相关的资料,".$tagname."相关的知识,".$tagname."相关的法规"; $head_description = "中实仪信网中".$tagname."相关的资讯、产品、企业、标准、资料、法规、知识等信息的聚合页面"; $back_link = "https://tag.lab216.com/"; $head_name = $tagname; include template('list','lable'); } ?>