DIR : /home/kozerus/public_html/dgs/forum/search.php

/home/kozerus/public_html/dgs/forum

<?php
/*
Dragon Go Server
Copyright (C) 2001-  Erik Ouchterlony, Rod Ival, Jens-Uwe Gaspar

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU Affero General Public License as
published by the Free Software Foundation, either version 3 of the
License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU Affero General Public License for more details.

You should have received a copy of the GNU Affero General Public License
along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/

$TranslateGroups[] = "Forum";

chdir('..');
require_once 'forum/forum_functions.php';
require_once 'include/std_classes.php';
require_once 'include/contacts.php';
require_once 'include/filter.php';
require_once 'include/filterlib_mysqlmatch.php';


{
   connect2mysql();

   $logged_in = who_is_logged( $player_row);
   if ( !$logged_in )
      error('login_if_not_logged_in', 'forum.search');
   $my_id = $player_row['ID'];

   $switch_moderator = switch_admin_status( $player_row, ADMIN_FORUM, @$_REQUEST['moderator'] );
   $is_moderator = ($switch_moderator == 1); // true, if in moderating mode
   $is_admin_moderator = ( $switch_moderator >= 0 ); // true, if forum moderator

   // build forum-array for filter: ( Name => Forum_ID )
   $f_opts = new ForumOptions( $player_row );
   $arr_fnames = Forum::load_cache_forum_names( $f_opts ); // id => name
   $farr_vis = array_keys($arr_fnames); // IDs of visible forums
   $arr_forum = array( T_('All#forum') => '' );
   foreach ( $arr_fnames as $id => $name )
      $arr_forum[$name] = 'P.Forum_ID=' . $id;

   $arr_filter_tags = array();
   $forum_tags = Tag::load_cache_tags( $my_id );
   foreach ($forum_tags as $tag_id => $tag)
   {
      $tagOption = sprintf( "<td>%%s%s</td>\n", $tag->render_tag() );
      $arr_filter_tags[$tagOption] = $tag->ID;
   }
   $show_forum_tags = ENABLE_FORUM_TAGS && count($forum_tags) > 0;

   $disp_forum = new DisplayForum( $my_id, $is_moderator );
   $disp_forum->setForumTags( $forum_tags );
   $disp_forum->set_hide_post_users(
      Contact::load_cache_contact_uids_by_systemflag( "forum.search", $my_id, CSYSFLAG_F_HIDE_POSTS) );
   $disp_forum->links = LINKPAGE_SEARCH | LINK_SEARCH;

   $page = "search.php";

   if ( $is_admin_moderator )
      $disp_forum->links |= LINK_TOGGLE_MODERATOR;
   else
      $disp_forum->is_moderator = 0;

   $title = T_('Forum search');
   start_page($title, true, $logged_in, $player_row, null, null, null, STARTFLAG_TAGS );

   echo "<h3 class=Header>$title</h3>\n";
   $disp_forum->prepare_forum_tags();

   if ( @$_REQUEST[FFORM_RESET_ACTION] )
   {
      $offset = 0;
      $order = 0;
   }
   else
   {
      $offset = max(0,(int)@$_REQUEST['offset']);
      $order = get_request_arg( 'order', 0 );
   }
   $disp_forum->offset = $offset;

   // for order-form-element
   $arr_order = array(
      0 => T_('Term relevance#forumsort'), // default: time-sort for no-term-search
      5 => T_('Likes#forumsort'),
      1 => T_('Creation date (new first)#forumsort'),
      2 => T_('Creation date (old first)#forumsort'),
      3 => T_('Modification date (new first)#forumsort'),
      4 => T_('Modification date (old first)#forumsort'),
   );
   $arr_sql_order = array( // index=arr_order[order]
      0 => 'Score DESC, Time DESC',
      1 => 'Time DESC',
      2 => 'Time ASC',
      3 => 'X_MaxEdit DESC',
      4 => 'X_MaxEdit ASC',
      5 => 'CountLikes DESC',
   );
   if ( !ENABLE_FORUM_TAGS )
      unset($arr_order[5]);
   if ( !is_numeric($order) || !isset($arr_order[$order]) )
      $order = 0;
   $sql_order = $arr_sql_order[$order];

   // show max-rows
   $maxrows = (int)@$_REQUEST['maxrows'];
   $maxrows = get_maxrows( $maxrows, MAXROWS_PER_PAGE_FORUM, MAXROWS_PER_PAGE_DEFAULT );
   $arr_maxrows = build_maxrows_array( $maxrows, MAXROWS_PER_PAGE_FORUM );
   $disp_forum->max_rows = $maxrows;

   // static filters
   $ffilter = new SearchFilter();
   $ffilter->add_filter( 1, 'Selection', $arr_forum, true);
   $ffilter->add_filter( 2, 'MysqlMatch', 'P.Subject,P.Text', true,
         array( FC_SIMPLE_QUERY => '(P.Subject LIKE #VAL OR P.Text LIKE #VAL)' ));
   $ffilter->add_filter( 3, 'Text', 'PAuthor.Handle', true,
         array( FC_SIZE => 16 ));
   $ffilter->add_filter( 4, 'Selection',
      array( T_('All messages#forum') => '',
             T_('First messages#forum') => 'P.Parent_ID=0' ),
      true );
   $ffilter->add_filter( 5, 'RelativeDate', 'P.Time', true,
         array( FC_TIME_UNITS => FRDTU_ALL_ABS, FC_SIZE => 12 ) );

   // guest is not allowed to see hidden guest posts with emails from others
   if ( $my_id > GUESTS_ID_MAX )
   {
      if ( $is_admin_moderator )
      {
         $ffilter->add_filter( 6, 'Selection',
            array( T_('All shown messages#forum') => "P.Approved='Y'",
                   T_('All hidden messages#forum') => "P.Approved IN ('N','P')",
                   T_('My hidden messages#forum') => "P.User_ID=$my_id AND P.Approved IN ('N','P')",
                   T_('Pending approval messages#forum') => "P.Approved='P'" ),
            true );
      }
      else
      {
         $ffilter->add_filter( 6, 'Boolean',
            array( true  => "P.User_ID=$my_id AND P.Approved IN ('N','P')",
                   false => "P.Approved='Y'" ),
            true );
      }
   }

   if ($show_forum_tags)
   {
      $ffilter->add_filter( 7, 'CheckboxArray',
         "P.ID IN (SELECT TG.Post_ID FROM Tagged AS TG WHERE TG.User_ID=$my_id AND TG.Tag_ID #VAL)", true,
          array( FC_FNAME => 'tag_$VAL', FC_SIZE => 5, FC_MULTIPLE => $arr_filter_tags, FC_SQL_TEMPLATE => true ));
   }
   $ffilter->init(); // parse current value from $_REQUEST
   $filter2 =& $ffilter->get_filter(2);

   // form for static filters
   $fform = new Form( 'tableFSF', $page, FORM_POST );
   $fform->attach_table($ffilter); // add hiddens

   $fform->add_row( array(
         'DESCRIPTION', T_('Forum'),
         'FILTER',      $ffilter, 1 ));
   $fform->add_row( array(
         'DESCRIPTION', T_('Search terms#forum'),
         'CELL',        1, 'align=left width=500',
         'FILTER',      $ffilter, 2,
         'BR',
         'FILTERWARN',  $ffilter, 2, $FWRN1, $FWRN2.'<BR>', false,
         'FILTERERROR', $ffilter, 2, $FERR1, $FERR2.'<BR>', true,
         ));
   $fform->add_row( array(
         'DESCRIPTION', T_('Author (Userid)'),
         'FILTER',      $ffilter, 3,
         'FILTERERROR', $ffilter, 3, '<BR>'.$FERR1, $FERR2, true,
         ));
   if ($show_forum_tags)
   {
      $fform->add_row( array(
            'ROW', 'SelectTags',
            'DESCRIPTION', T_('Forum tags'),
            'FILTER',      $ffilter, 7 ));
   }
   $arr = array(
         'DESCRIPTION', T_('Message scope#forum'),
         'FILTER',      $ffilter, 4,
      );
   if ( $my_id > GUESTS_ID_MAX )
   {
      $filter6_str = ($is_admin_moderator)
         ? span('AdminOption', T_('(moderator only)') )
         : T_('Show hidden posts#forum');
      array_push( $arr,
            'TEXT',     SMALL_SPACING,
            'FILTER',   $ffilter, 6,
            'TEXT',     $filter6_str );
   }
   $fform->add_row( $arr );
   $fform->add_row( array(
         'DESCRIPTION', T_('Date#forum'),
         'CELL',        1, 'align=left',
         'FILTER',      $ffilter, 5,
         'FILTERERROR', $ffilter, 5, "<BR>$FERR1", $FERR2, true,
         ));
   $fform->add_row( array(
         'DESCRIPTION', T_('Order#forum'),
         'SELECTBOX',   'order', 1, $arr_order, $order, false, ));
   $fform->add_row( array(
         'DESCRIPTION', T_('Number of hits#forum'),
         'SELECTBOX',   'maxrows', 1, $arr_maxrows, $maxrows, false, ));
   $fform->add_row( array(
         'TAB',
         'CELL',        1, 'align=left',
         'OWNHTML',     implode( '', $ffilter->get_submit_elements( $fform ) ) ));

   echo $fform->get_form_string();

   // Perform query
   $findposts = array();
   $nr_rows = 0;
   $has_query = false;
   if ( $ffilter->is_init() && !$ffilter->is_reset() )
   {
      // get clause-part for mysql-match as select-col
      $has_query = true;
      if ( is_null($filter2->get_query()) )
         $query_match = '1';
      else
         $query_match = $filter2->get_match_query_part();

      $qsql = ForumPost::build_query_sql();
      if ( ALLOW_SQL_CALC_ROWS )
         $qsql->add_part( SQLP_OPTS, SQLOPT_CALC_ROWS );
      $qsql->add_part( SQLP_FIELDS, "$query_match AS Score" );

      // need approved-state for non-moderators (see filter6 above)
      if ( $my_id <= GUESTS_ID_MAX )
         $qsql->add_part( SQLP_WHERE, "P.Approved='Y'" );
      $qsql->add_part( SQLP_WHERE, "P.PosIndex>''" ); // '' == inactivated (edited)

      // restrict query on "visible" forums (matching admin-options)
      $qsql->add_part( SQLP_WHERE,
         'P.Forum_ID IN ('.implode(',', $farr_vis).')' );

      $query_filter = $ffilter->get_query(); // clause-parts for filter
      $qsql->merge($query_filter);

      if ( $sql_order)
         $qsql->add_part( SQLP_ORDER, $sql_order );
      $qsql->add_part( SQLP_LIMIT, "$offset," . ($maxrows+1) ); // +1 for next-page detection
      $query = $qsql->get_select();

      $result = db_query( 'forum_search.find', $query );
      $nr_rows = mysql_num_rows($result);
      $found_rows = mysql_found_rows('forum_search.found_rows');
      if ( $found_rows >= 0 )
         $disp_forum->show_found_rows( $found_rows );

      $cnt_rows = $maxrows; // read only what is needed (nr_rows maybe +1)
      $post_ids = array();
      while ( ($row = mysql_fetch_array( $result )) && $cnt_rows-- > 0 )
      {
         $post = ForumPost::new_from_row($row);
         $post->forum_name = @$arr_fnames[$post->forum_id];
         $post->score = $row['Score'];
         $findposts[] = $post;
         $post_ids[] = $post->id;
      }
      mysql_free_result($result);

      $user_tags = $disp_forum->sortForumUserTags( Tagged::load_tagged_by_user( $my_id, $post_ids ) );
      foreach( $findposts as $post )
      {
         if (isset($user_tags[$post->id]))
            $post->add_user_tags( $user_tags[$post->id] );
      }
      // end of DB-stuff
   }


   // Display results
   $disp_forum->cols = $cols = 2;
   $disp_forum->headline = array( T_('Search result') => "colspan=$cols" );

   $disp_forum->links |= LINK_FORUMS;
   if ( $offset > 0 )
      $disp_forum->links |= LINK_PREV_PAGE;
   if ( $nr_rows > $maxrows )
      $disp_forum->links |= LINK_NEXT_PAGE;

   // build navi-URL for paging (offset/maxrows set in forum_start_table/make_link_array-func)
   $rp = $ffilter->get_req_params();
   $rp->add_entry( 'order',  $order );

   // show resultset of search
   $rx_term = implode('|', $filter2->get_rx_terms() );
   $disp_forum->show_score = true; // for draw_post
   $disp_forum->set_rx_term( $rx_term );

   echo "<br>\n";
   $disp_forum->print_moderation_note('99%');
   $disp_forum->forum_start_table('Search', $rp);
   echo "<tr><td colspan=$cols><table width=\"100%\" cellpadding=2 cellspacing=0 border=0>\n";

   foreach ( $findposts as $post )
   {
      $is_my_post = $post->is_author($my_id);
      $hidden = !$post->is_approved();
      if ( $hidden && !$is_admin_moderator && !$is_my_post )
         continue;

      $drawmode = DRAWPOST_SEARCH;
      if ( $hidden )
         $drawmode |= MASK_DRAWPOST_HIDDEN;

      $disp_forum->draw_post( $drawmode, $post, $is_my_post );

      echo "<tr><td colspan=$cols></td></tr>\n"; //separator
   }

   echo "</table></td></tr>\n";
   $disp_forum->forum_end_table( $has_query );

   end_page();
}
?>