##############################################################


## MOD Title: Search Post Title Only


## MOD Author: drathbun < [ Only registered users can see links on this board! Get registered or login! ] > (Dave Rathbun) [ Only registered users can see links on this board! Get registered or login! ]


## MOD Description: This mod provides one additional option on the search page. Currently


##         you can search the message + title, or the message only. This mod allows


##         you to search by title only.


## MOD Version: 1.0.0


##


## Installation Level: easy


## Installation Time: 10-15 Minutes


## Files To Edit: constants.php, search.php, lang_main.php, search_body.tpl


## Included Files: n/a


##############################################################


## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the


## latest version of this MOD. Downloading this MOD from other sites could cause malicious code


## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered


## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/


##############################################################


## Author Notes:


## This mod will allow your users to search using the message body + title, message body only,


## or title only. The coding includes new values for constants.php to make the code more transparent


## and easy to maintain. There are no table changes required for this mod. Language entries are


## provided in English only.


##


## There is a demo account set up at the forum listed above (http://www.forumtopics.com/phpBBDemo)


## You can log in to test this (and other) mod(s) using the username demo with a password of demo.


##


## This mod has been installed as written on 2.0.3 and 2.0.4 boards.


##


## There is one language entry for this mod.


## There are no included files for this mod.


##############################################################


## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD


##############################################################





#


#-----[ OPEN ]------------------------------------------


#


includes/constants.php





#


#-----[ FIND ]------------------------------------------


#


?>





#


#-----[ BEFORE, ADD ]------------------------------------------


#


// BEGIN Search Post Title Mod


define(SEARCH_ENTIRE_MESSAGE, 0);


define(SEARCH_MESSAGE_ONLY, 1);


define(SEARCH_TITLE_ONLY, 2);


// END Search Post Title Mod





#


#-----[ OPEN ]------------------------------------------


#


language/lang_english/lang_main.php





#


#-----[ FIND ]------------------------------------------


#


$lang['Search_msg_only'] = 'Search message text only';





#


#-----[ AFTER, ADD ]------------------------------------------


#


// BEGIN Search Post Title Mod


$lang['Search_title_only'] = 'Search title only';


// END Search Post Title Mod





#


#-----[ OPEN ]------------------------------------------


#


templates/subSilver/search_body.tpl





#


#-----[ FIND ]------------------------------------------


#


                <td class="row2" valign="middle"><span class="genmed"><select class="post" name="search_time">{S_TIME_OPTIONS}</select><br /><input type="radio" name="search_fields" value="all" checked="checked" /> {L_SEARCH_MESSAGE_TITLE}<br /><input type="radio" name="search_fields" value="msgonly" /> {L_SEARCH_MESSAGE_ONLY}</span></td>


#


#-----[ REPLACE WITH ]------------------------------------------


#


                <td class="row2" valign="middle"><span class="genmed"><select class="post" name="search_time">{S_TIME_OPTIONS}</select><br /><input type="radio" name="search_fields" value="all" checked="checked" /> {L_SEARCH_MESSAGE_TITLE}<br /><input type="radio" name="search_fields" value="msgonly" /> {L_SEARCH_MESSAGE_ONLY}<br /><input type="radio" name="search_fields" value="titleonly" /> {L_SEARCH_TITLE_ONLY}</span></td>





#


#-----[ OPEN ]------------------------------------------


#


search.php





#


#-----[ FIND ]------------------------------------------


#


        $search_fields = ( $HTTP_POST_VARS['search_fields'] == 'all' ) ? 1 : 0;


#


#-----[ REPLACE WITH ]------------------------------------------


#


        // BEGIN Search Post Title Mod


        switch ( $HTTP_POST_VARS['search_fields'] )


        {


                case 'all' :


                        $search_fields = SEARCH_ENTIRE_MESSAGE;


                        break;


                case 'msgonly' :


                        $search_fields = SEARCH_MESSAGE_ONLY;


                        break;


                case 'titleonly' :


                        $search_fields = SEARCH_TITLE_ONLY;


                        break;


                default :


                        $search_fields = SEARCH_ENTIRE_MESSAGE;


                        break;


        }


        // END Search Post Title Mod


#


#-----[ FIND ]------------------------------------------


#


else


{


        $search_fields = 0;


}





#


#-----[ REPLACE WITH ]------------------------------------------


#


else


{


        $search_fields = SEARCH_ENTIRE_MESSAGE;


}





#


#-----[ FIND ]------------------------------------------


#


                        $search_msg_only = ( !$search_fields ) ? "AND m.title_match = 0" : ( ( strstr($multibyte_charset, $lang['ENCODING']) ) ? '' : '' );


#


#-----[ REPLACE WITH ]------------------------------------------


#


                        // BEGIN Search Post Title Mod


                        // The following code sets up whether we look for title words or not.


                        $search_word_sql = ( $search_fields == SEARCH_MESSAGE_ONLY ) ? "AND m.title_match = 0" : '' ;


                        $search_word_sql = ( $search_fields == SEARCH_TITLE_ONLY ) ? "AND m.title_match = 1" : $search_word_sql ;


                        // END Search Post Title Mod





#


#-----[ FIND ]------------------------------------------


#


                                                        $sql = "SELECT m.post_id


                                                                FROM " . SEARCH_WORD_TABLE . " w, " . SEARCH_MATCH_TABLE . " m


                                                                WHERE w.word_text LIKE '$match_word'


                                                                        AND m.word_id = w.word_id


                                                                        AND w.word_common <> 1


                                                                        $search_msg_only";


#


#-----[ REPLACE WITH ]------------------------------------------


#


                                                        $sql = "SELECT m.post_id


                                                                FROM " . SEARCH_WORD_TABLE . " w, " . SEARCH_MATCH_TABLE . " m


                                                                WHERE w.word_text LIKE '$match_word'


                                                                        AND m.word_id = w.word_id


                                                                        AND w.word_common <> 1


                                                                        $search_word_sql";





#


#-----[ FIND ]------------------------------------------


#


                                                        $search_msg_only = ( $search_fields ) ? "OR post_subject LIKE '$match_word'" : '';





#


#-----[ REPLACE WITH ]------------------------------------------


#


                                                        // BEGIN Search Post Title Mod


                                                        // The following code sets up the search of the actual post, given


                                                        // the words found in the prior search


                                                        switch ( $search_fields )


                                                        {


                                                                case SEARCH_MESSAGE_ONLY :


                                                                        $search_sql = '';


                                                                        break;


                                                                case SEARCH_ENTIRE_MESSAGE :


                                                                        $search_sql = "OR post_subject LIKE '$match_word'";


                                                                        break;


                                                                case SEARCH_TITLE_ONLY :


                                                                        $search_sql = "AND post_subject LIKE '$match_word'";


                                                                        break;


                                                                default :


                                                                        $search_sql = '';


                                                        }


                                                        // END Search Post Title Mod





#


#-----[ FIND ]------------------------------------------


#


                                                        $sql = "SELECT post_id


                                                                FROM " . POSTS_TEXT_TABLE . "


                                                                WHERE post_text LIKE '$match_word'


                                                                $search_msg_only";


#


#-----[ REPLACE WITH ]------------------------------------------


#


                                                        $sql = "SELECT post_id


                                                                FROM " . POSTS_TEXT_TABLE . "


                                                                WHERE post_text LIKE '$match_word'


                                                                $search_sql";


#


#-----[ FIND ]------------------------------------------


#


        'L_SEARCH_MESSAGE_TITLE' => $lang['Search_title_msg'],


#


#-----[ AFTER, ADD ]------------------------------------------


#


        // Begin Search Post Title Mod


        'L_SEARCH_TITLE_ONLY' => $lang['Search_title_only'],


        // End Search Post Title Mod


 


#


#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------


#


# EoM