203                 $query = $INPUT->arr('query');
204                 $query['resultset'] = 'query';
205                 $query['limit'] = 20;
206                 $query['offset'] = $INPUT->int('query-offset');
207                 $this->htmlSearchResults($query);
231                 $query['limit'] = $this->commentLimit;
232                 $query['offset'] = $INPUT->int('comment-offset');
233                 $query['resultset'] = 'comment';
234                 $this->htmlLatestItems($query);
236                 $query['limit'] = $this->entryLimit;
237                 $query['offset'] = $INPUT->int('entry-offset');
238                 $query['resultset']  = 'entry';
239                 $this->htmlLatestItems($query);
249      * @param array $query url parameters for query
251     private function htmlSearchResults($query) {  argument
256         switch($query['filter']) {
282         if(isset($query['blog']) && $query['blog']) {
283             $where = 'WHERE blog = ' . $db->quote_string($query['blog']) . ' ';
288         if(isset($query['string']) && $query['string'] != '') {
289             switch($query['filter']) {
291                     $where .= 'AND ( title LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
294                     $where .= 'AND ( author LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
297 …            $where .= 'AND ( comments.text LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
300 …              $where .= 'AND ( comments.ip LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
303 …                 $where .= 'AND ( tags.tag LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
309         if(isset($query['pid']) && $query['pid'] != '') {
310             $where .= 'AND ( comments.pid = ' . $db->quote_string($query['pid']) . ' ) ';
317         $sqlselect .= ' LIMIT '.$query['limit'];
318         if($query['offset'] > 0) {
319             $sqlselect .= ' OFFSET '.$query['offset'];
322         $res = $db->query($sqlcount);
325         $resid = $db->query($sqlselect);
327 …     $this->htmlShowPaginatedResult($resid, $query, $itemdisplaycallback, $count, $query['limit']);
335      * @param array  $query    Query parameters
343     private function htmlShowPaginatedResult($resid, $query, $itemdisplaycallback, $count, $limit) {  argument
347         $currentpage   =  floor($query['offset'] / $limit) + 1;
356                 $this->htmlPagination($query, $currentpage, $count, $limit);
359             call_user_func(array($this, $itemdisplaycallback), $items, $query);
369             $this->htmlPagination($query, $currentpage, $count, $limit);
376      * @param array  $query       Query parameters
383     private function htmlPagination($query, $currentpage, $maximum, $limit) {  argument
409 …        $this->htmlPaginationurl($query, ($currentpage - 2) * $limit, '«', $currentpage - 1);
420                 $this->htmlPaginationurl($query, ($page - 1) * $limit, $page, $page);
426             $this->htmlPaginationurl($query, $currentpage * $limit, '»', $currentpage + 1);
435      * @param array   $query   Query parameters
441     private function htmlPaginationurl($query, $offset, $text, $title) {  argument
443         list($params, $anchor) = $this->buildUrlParams($query, $offset);
450      * @param array  $query   Query parameters
454     private function buildUrlParams($query, $offset) {  argument
458             $query['resultset'].'-offset' => $offset
460         $anchor = $query['resultset'] . '_latest';
462         if($query['resultset'] == 'query') {
465                     'query[filter]' => $query['filter'],
466                     'query[blog]'   => $query['blog'],
467                     'query[string]' => $query['string'],
468                     'query[pid]'    => $query['pid']
478      * @param array $query parameters
483     private function htmlLatestItems($query) {  argument
484         $resultset = $query['resultset']; //query,comment,entry
486 …printf("<h2 id='{$resultset}_latest'>".$this->getLang($resultset.'_latest').'</h2>', $query['limit…
487         $this->htmlLimitForm($query);
509         $limit = $query['limit'];
511         if($query['offset']) {
512             $sqlselect .= ' OFFSET ' . $query['offset'];
515         $res = $this->sqlitehelper->getDB()->query($sqlcount);
518         $resid = $this->sqlitehelper->getDB()->query($sqlselect);
522         $this->htmlShowPaginatedResult($resid, $query, $itemdisplaycallback, $count, $limit);
529      * @param array $query parameters
533     private function htmlEntryList($entries, $query) {  argument
546             $this->htmlEntryItem($entry, $query);
556      * @param array $query Query parameters
560     private function htmlEntryItem($entry, $query) {  argument
571 …  ptln('<td class="entry_set_blog">' . $this->htmlEntryEditForm($entry, $query, 'blog') . '</th>');
572 …ptln('<td class="entry_set_commentstatus">' . $this->htmlEntryEditForm($entry, $query, 'commentsta…
622      * @param array $query    Query parameters
627     private function htmlCommentList($comments, $query) {  argument
634         ptln('<input type="hidden" name="comment-offset" value="' .$query['offset']. '" />');
744      * @param array $query Query parameters
751     private function htmlEntryEditForm($entry, $query, $field = 'commentstatus') {  argument
761         $form->addHidden('entry-offset', $query['offset']);
832         $query = $INPUT->arr('query');
833 …$form->addElement(form_makeListBoxField('query[blog]', $blogs, $query['blog'], $this->getLang('blo…
834 …ter]', ['entry_title', 'entry_author', 'comment', 'comment_ip', 'tags'], $query['filter'], $this->…
835         $form->addElement(form_makeTextField('query[string]', $query['string'],''));
847      * @param array $query Query parameters
851     private function htmlLimitForm($query) {  argument
854         $resultset = $query['resultset'];
864                     $query['limit'],
866         $form->addHidden($resultset . '-offset', $query['offset']);