if (!empty($wheresqltemp)) { $wheresql = '(' . $wheresql . ')' . ' and t.itemid = i.itemid and ' . $wheresqltemp; } else { $wheresql = '(' . $wheresql . ')' . ' and t.itemid = i.itemid'; } $query = $_SGLOBAL['db']->query('SELECT COUNT(*) FROM ' . tname('spaceitems') . ' i, ' . tname('spacenews') . ' t WHERE ' . $wheresql); $listcount1 = $_SGLOBAL['db']->result($query, 0); $query = $_SGLOBAL['db']->query('SELECT COUNT(*) FROM ' . tname('creativeitems') . ' i, ' . tname('creativemessage') . ' t WHERE ' . $wheresql); $listcount2 = $_SGLOBAL['db']->result($query, 0); $query = $_SGLOBAL['db']->query('SELECT COUNT(*) FROM ' . tname('defectitems') . ' i, ' . tname('defectmessage') . ' t WHERE ' . $wheresql); $listcount3 = $_SGLOBAL['db']->result($query, 0); $query = $_SGLOBAL['db']->query('SELECT COUNT(*) FROM ' . tname('toolitems') . ' i, ' . tname('toolmessage') . ' t WHERE ' . $wheresql); $listcount4 = $_SGLOBAL['db']->result($query, 0); $listcount3 += $listcount4; $wherearr2[] = getsearchkeysql($searchkey, $searchmode, 'subject'); $wherearr2[] = getsearchkeysql($searchkey, $searchmode, 'filename'); $wheresql2 = implode(' OR ', $wherearr2); //链接搜索条件 if (!empty($wheresqltemp)) { $wheresql2 = $wheresql2 . ' and ' . $wheresqltemp; } else { $wheresql2 = $wheresql2; } $query = $_SGLOBAL['db']->query('SELECT COUNT(*) FROM ' . tname('attachments') . ' WHERE ' . $wheresql2); $listcount4 = $_SGLOBAL['db']->result($query, 0); $listcount = $listcount1 + $listcount2 + $listcount3 + $listcount4; if ($listcount) { if ($start < $listcount1) { $query = $_SGLOBAL['db']->query('SELECT * FROM ' . tname('spaceitems') . ' i, ' . tname('spacenews') . ' t WHERE ' . $wheresql . ' LIMIT ' . $start . ',' . $perpage); while ($item = $_SGLOBAL['db']->fetch_array($query)) { $item['url'] = geturl('action/viewnews/itemid/' . $item['itemid'] . '/searchkeys/' . rawurlencode($searchkey));
$item['url'] = geturl('action/viewnews/itemid/' . $item['itemid']); foreach ($searchkeyarr as $keyword) { $item['subject'] = str_ireplace($keyword, '<font color="red">' . $keyword . '</font>', $item['subject']); } $iarr[] = $item; } $multipage = multi($listcount, $perpage, $page, S_URL . '/search.php?' . $urlplus); //分页 } else { showmessage('not_find_relevant_data'); } } else { if ($searchname == 'message') { $wherearr[] = 't.itemid = i.itemid'; // $wherearr[] = 't.message LIKE \'%'.$searchkey.'%\''; $wherearr[] = getsearchkeysql($searchkey, $searchmode, 'message'); $wheresql = implode(' AND ', $wherearr); //链接搜索条件 $query = $_SGLOBAL['db']->query('SELECT COUNT(*) FROM ' . tname('spaceitems') . ' i, ' . tname('spacenews') . ' t WHERE ' . $wheresql); $listcount = $_SGLOBAL['db']->result($query, 0); if ($listcount) { $query = $_SGLOBAL['db']->query('SELECT * FROM ' . tname('spaceitems') . ' i, ' . tname('spacenews') . ' t WHERE ' . $wheresql . ' LIMIT ' . $start . ',' . $perpage); while ($item = $_SGLOBAL['db']->fetch_array($query)) { $item['url'] = geturl('action/viewnews/itemid/' . $item['itemid'] . '/searchkeys/' . rawurlencode($searchkey)); foreach ($searchkeyarr as $keyword) { $item['subject'] = str_ireplace($keyword, '<font color="red">' . $keyword . '</font>', $item['subject']); } $iarr[] = $item; } $multipage = multi($listcount, $perpage, $page, S_URL . '/search.php?' . $urlplus); } else {