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 {
