getState('searchwords'); $q = \strlen($text); if ($q < 3 && !$this->getState('query.searchuser') && $this->app->getInput()->getString('childforums')) { $this->app->enqueueMessage(Text::_('COM_KUNENA_SEARCH_ERR_SHORTKEYWORD'), 'error'); return 0; } if ($this->total === false) { $this->getResults(); } else { $this->app->enqueueMessage(Text::_('COM_KUNENA_SEARCH_ERR_NOPOSTS'), 'notice'); return 0; } return $this->total; } /** * @return array|boolean * * @since Kunena 6.0 * * @throws null * @throws Exception */ public function getResults() { if ($this->messages !== false) { return $this->messages; } $text = $this->getState('searchwords'); $q = \strlen($text); if (!$this->getState('query.searchuser')) { if ($q < 3) { return false; } } // Get results $hold = $this->getState('query.show'); if ($hold == 1) { $mode = 'unapproved'; } elseif ($hold >= 2) { $mode = 'deleted'; } else { $mode = 'recent'; } $params = [ 'mode' => $mode, 'childforums' => $this->getState('query.childforums'), 'where' => $this->buildWhere(), 'orderby' => $this->buildOrderBy(), 'starttime' => -1, ]; $limitstart = $this->getState('list.start'); $limit = $this->getState('list.limit'); list($this->total, $this->messages) = KunenaMessageHelper::getLatestMessages($this->getState('query.catids'), $limitstart, $limit, $params); if ($this->total < $limitstart) { $this->setState('list.start', \intval($this->total / $limit) * $limit); } $topicids = []; $userids = []; foreach ($this->messages as $message) { $topicids[$message->thread] = $message->thread; $userids[$message->userid] = $message->userid; } if ($topicids) { $topics = KunenaTopicHelper::getTopics($topicids); foreach ($topics as $topic) { $userids[$topic->first_post_userid] = $topic->first_post_userid; } } KunenaUserHelper::loadUsers($userids); KunenaMessageHelper::loadLocation($this->messages); if (empty($this->messages)) { $this->app->enqueueMessage(Text::sprintf('COM_KUNENA_SEARCH_NORESULTS_FOUND', '' . $text . ''), 'notice'); } return $this->messages; } /** * @return string * * @since Kunena 6.0 * * @throws Exception */ protected function buildWhere() { $db = $this->getDatabase(); $querystrings = []; foreach ($this->getSearchWords() as $searchword) { $searchword = $db->escape(StringHelper::trim($searchword)); if (empty($searchword)) { continue; } $not = ''; $operator = ' OR '; if (substr($searchword, 0, 1) == '-' && \strlen($searchword) > 1) { $not = 'NOT'; $operator = 'AND'; $searchword = StringHelper::substr($searchword, 1); } if (!$this->getState('query.titleonly')) { $querystrings[] = "(t.message {$not} LIKE '%{$searchword}%' {$operator} m.subject {$not} LIKE '%{$searchword}%')"; } else { $querystrings[] = "(m.subject {$not} LIKE '%{$searchword}%')"; } } if (!$this->config->pubProfile && !Factory::getApplication()->getIdentity()->guest || $this->config->pubProfile) { // User searching $username = $this->getState('query.searchuser'); if ($username) { if ($this->getState('query.exactname') == '1') { $querystrings[] = "m.name LIKE '" . $db->escape($username) . "'"; } else { $querystrings[] = "m.name LIKE '%" . $db->escape($username) . "%'"; } } } $time = 0; $searchatdate = $this->getState('query.searchatdate'); if (empty($searchatdate) || $searchatdate == Factory::getDate()->format('m/d/Y')) { switch ($this->getState('query.searchdate')) { case 'lastvisit': $time = KunenaFactory::GetSession()->lasttime; break; case 'all': break; case '1': case '7': case '14': case '30': case '90': case '180': case '365': $time = time() - 86400 * \intval($this->getState('query.searchdate')); break; default: $time = time() - 86400 * 365; } if ($time) { if ($this->getState('query.beforeafter') == 'after') { $querystrings[] = "m.time > '{$time}'"; } else { $querystrings[] = "m.time <= '{$time}'"; } } } else { $time_start_day = Factory::getDate($this->getState('query.searchatdate'))->toUnix(); $time_end_day = new DateTime($this->getState('query.searchatdate')); $time_end_day->add(new DateInterval("PT23H59M59S")); $querystrings[] = " m.time > {$time_start_day} AND m.time < {$time_end_day->getTimestamp()}"; } $topic_id = $this->getState('query.topic_id'); if ($topic_id) { $querystrings[] = "m.id = '{$topic_id}'"; } return implode(' AND ', $querystrings); } /** * @return array * * @since Kunena 6.0 */ public function getSearchWords() { // Accept individual words and quoted strings $splitPattern = '/[\s,]*\'([^\']+)\'[\s,]*|[\s,]*"([^"]+)"[\s,]*|[\s,]+/u'; $searchwords = preg_split($splitPattern, $this->getState('searchwords'), 0, PREG_SPLIT_NO_EMPTY | PREG_SPLIT_DELIM_CAPTURE); $result = []; foreach ($searchwords as $word) { // Do not accept one letter strings if (StringHelper::strlen($word) > 1) { $result[] = $word; } } return $result; } /** * @return string * * @since Kunena 6.0 */ protected function buildOrderBy() { if ($this->getState('query.order') == 'dec') { $order1 = 'DESC'; } else { $order1 = 'ASC'; } switch ($this->getState('query.sortby')) { case 'title': $orderby = "m.subject {$order1}, m.time {$order1}"; break; case 'views': $orderby = "m.hits {$order1}, m.time {$order1}"; break; case 'forum': $orderby = "m.catid {$order1}, m.time {$order1}"; break; case 'lastpost': default: $orderby = "m.time {$order1}"; } return $orderby; } /** * @return string * * @since Kunena 6.0 */ public function getUrlParams() { // Turn internal state into URL, but ignore default values $defaults = [ 'titleonly' => 0, 'searchuser' => '', 'exactname' => 0, 'childforums' => 0, 'starteronly' => 0, 'replyless' => 0, 'replylimit' => 0, 'searchdate' => '365', 'beforeafter' => 'after', 'sortby' => 'lastpost', 'order' => 'dec', 'catids' => '0', 'show' => '0', 'topic_id' => 0, 'ids' => 0, 'searchatdate' => '', ]; $url_params = ''; $state = $this->getState(); foreach ($state as $param => $value) { $paramparts = explode('.', $param); if ($paramparts[0] != 'query') { continue; } $param = $paramparts[1]; if ($param == 'catids' || $param == 'ids') { $value = implode(' ', $value); } if ($value != $defaults[$param]) { $url_params .= "&$param=" . urlencode($value); } } return $url_params; } /** * @param string $view view * @param string $searchword searchword * @param int $limitstart limitstart * @param int $limit limit * @param string $params params * @param bool $xhtml xhtml * * @return boolean * * @since Kunena 6.0 * * @throws Exception * @throws null */ public function getSearchURL($view, $searchword = '', $limitstart = 0, $limit = 0, $params = '', $xhtml = true) { $config = KunenaFactory::getConfig(); $limitstr = ""; if ($limitstart > 0) { $limitstr .= "&limitstart=$limitstart"; } if ($limit > 0 && $limit != $config->messagesPerPageSearch) { $limitstr .= "&limit=$limit"; } if ($searchword) { $searchword = '&query=' . urlencode($searchword); } return KunenaRoute::_("index.php?option=com_kunena&view={$view}{$searchword}{$params}{$limitstr}", $xhtml); } /** * Method to auto-populate the model state. * * Note. Calling getState in this method will result in recursion. * * @param null $ordering * @param null $direction * * @return void * * @since Kunena 6.0 * * @throws Exception */ protected function populateState($ordering = null, $direction = null): void { // Get search word list $value = StringHelper::trim($this->app->getInput()->get('query', '', 'string')); if ($value == Text::_('COM_KUNENA_GEN_SEARCH_BOX')) { $value = ''; } $this->setState('searchwords', $value); $value = Factory::getApplication()->getInput()->getInt('titleonly', 0); $this->setState('query.titleonly', $value); $value = Factory::getApplication()->getInput()->getString('searchuser', ''); $this->setState('query.searchuser', rtrim($value)); $value = Factory::getApplication()->getInput()->getInt('starteronly', 0); $this->setState('query.starteronly', $value); if (!$this->config->pubProfile && !Factory::getApplication()->getIdentity()->guest || $this->config->pubProfile) { $value = Factory::getApplication()->getInput()->getInt('exactname', 0); $this->setState('query.exactname', $value); } $value = Factory::getApplication()->getInput()->getInt('replyless', 0); $this->setState('query.replyless', $value); $value = Factory::getApplication()->getInput()->getInt('replylimit', 0); $this->setState('query.replylimit', $value); $value = Factory::getApplication()->getInput()->getString('searchdate', $this->config->searchTime); $this->setState('query.searchdate', $value); $value = Factory::getApplication()->getInput()->getString('searchatdate', null); $this->setState('query.searchatdate', $value); $value = Factory::getApplication()->getInput()->getWord('beforeafter', 'after'); $this->setState('query.beforeafter', $value); $value = Factory::getApplication()->getInput()->getWord('sortby', 'lastpost'); $this->setState('query.sortby', $value); $value = Factory::getApplication()->getInput()->getWord('order', 'dec'); $this->setState('query.order', $value); $value = Factory::getApplication()->getInput()->getInt('childforums', 1); $this->setState('query.childforums', $value); $value = Factory::getApplication()->getInput()->getInt('topic_id', 0); $this->setState('query.topic_id', $value); if (isset($_POST['query']) || isset($_POST['searchword'])) { $value = Factory::getApplication()->getInput()->get('catids', [0], 'post', 'array'); $value = ArrayHelper::toInteger($value); } else { $value = Factory::getApplication()->getInput()->getString('catids', '0', 'get'); $value = explode(' ', $value); $value = ArrayHelper::toInteger($value); } $this->setState('query.catids', $value); if (isset($_POST['searchword'])) { $value = Factory::getApplication()->getInput()->get('ids', [0], 'post', 'array'); $value = ArrayHelper::toInteger($value); if ($value[0] > 0) { $this->setState('query.ids', $value); } } else { $value = Factory::getApplication()->getInput()->getString('ids', '0', 'get'); $value = explode(' ', (int) $value); $value = ArrayHelper::toInteger($value); if ($value[0] > 0) { $this->setState('query.ids', $value); } } $value = Factory::getApplication()->getInput()->getInt('show', 0); $this->setState('query.show', $value); $value = $this->getInt('limitstart', 0); if ($value < 0) { $value = 0; } $this->setState('list.start', $value); $value = $this->getInt('limit', 0); if ($value < 1 || $value > 100) { $value = $this->config->messagesPerPageSearch; } $this->setState('list.limit', $value); } }