$query_sql .= " AND a.articleid IN ({$aids}) ORDER BY a.dateline DESC LIMIT {$start_limit}, " . $pagenum; } $pageurl = gettaglink($r['slug']); $navtext = $r['name']; $options['title'] = settitle($r['name']); $indexpage = 0; // 查看搜索结果的文章 } elseif ($searchid) { $search = $DB->fetch_one_array("SELECT * FROM {$db_prefix}searchindex WHERE searchid='" . $searchid . "' AND expiration>'{$timestamp}'"); if (!$search) { $DB->unbuffered_query("DELETE FROM {$db_prefix}searchindex WHERE expiration < '{$timestamp}'"); message('您指定的搜索不存在或已过期,请返回.', './'); } $total = $search['totals']; $query_sql .= " AND a.articleid IN (" . $search['ids'] . ") ORDER BY a.dateline DESC LIMIT {$start_limit}, " . $pagenum; $pageurl = getsearchlink($searchid); $navtext = '搜索“<strong>' . $search['keywords'] . '</strong>”的结果'; $indexpage = 0; // 查看首页文章 } else { if ($options['permalink']) { $pageurl = $options['url'] . 'page/'; } else { $pageurl = $options['url'] . '?action=article'; } $navtext = ''; $total = $stats['article_count']; // 检查是否设置分类参数 $cid = (int) $_GET['cid']; $curl = sax_addslashes($_GET['curl']); if ($cid || $curl) {
} $query_sql .= " AND ({$sqltxtsrch}) ORDER BY dateline DESC LIMIT 500"; //搜索500个出来足够了.保证效率.反正一般BLOG也没有多少数据. $totals = 0; $ids = $comma = ''; $query = $DB->query($query_sql); while ($article = $DB->fetch_array($query)) { $ids .= $comma . $article['articleid']; $comma = ','; $totals++; } $DB->free_result($query); $DB->query("INSERT INTO {$db_prefix}searchindex (keywords, searchstring, dateline, expiration, totals, ids, ipaddress, uid) VALUES ('" . char_cv($keywords) . "', '{$searchstring}', '{$timestamp}', '" . ($timestamp + 3600) . "', '{$totals}', '{$ids}', '{$onlineip}', '{$sax_uid}')"); $searchid = $DB->insert_id(); } $gourl = getsearchlink($searchid); if ($options['showmsg']) { message('搜索成功完成,现在将转入结果页面.', $gourl); } else { $gourl = str_replace("&", "&", $gourl); @header("Location: " . $gourl); exit; } } } message('未定义操作', $referer); // 检查用户提交内容合法性 function checkcontent($content) { global $options; if (empty($content)) {