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


## MOD Title: Similar Topics


## MOD Author: Leuchte < mail@leuchte.net > http://www.leuchte.net 


## MOD Description: This mod adds a table at the bottom of a thread and displays other threads that are silimar in topic.


##


## MOD Version: 1.0.1


## 


## Installation Level: Easy 


## Installation Time: 5 Minutes 


## Files To Edit: 3


##


##         lang_main.php


##         viewtopic.php


##         templates/subSilver/viewtopic_body.tpl


##


## Included Files: 0 


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


## For Security Purposes, Please Check: http://www.leuchte.net/mods/ for the 


## latest version of this MOD.


## 


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


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


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


## MOD History:


##


##   2004-09-25 - Initial Release


##


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


# 


#-----[ SQL ]------------------------------------------ 


# Run the following command on your sql database (replace phpbb_ with your db prefix) before you edit the files!


ALTER TABLE nuke_bbtopics ADD FULLTEXT (topic_title);





# 


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


# 


modules/forums/language/lang_english/lang_main.php 





# 


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


# 


?>





# 


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


# 


$lang['Similar'] = 'Similar Topics';





# 


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


# 


viewtopic.php 





# 


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


# 


//


// Go ahead and pull all data for this topic


//





# 


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


# 


// Similar Topics


$sql = "SELECT topic_id


FROM ". nuke_bbtopics ."


WHERE topic_id != $topic_id


AND MATCH (topic_title) AGAINST ('". addslashes($topic_title) ."')


ORDER BY topic_time DESC LIMIT 0,5";


if ( !($result = $db->sql_query($sql)) )


{


   message_die(GENERAL_ERROR, "Could not get main information for similar topics", '', __LINE__, __FILE__, $sql);


}


$topics = array();


while ( $row = $db->sql_fetchrow($result) )


{


  $topics[] = $row;


}


  $count_similar = count($topics);


if ( $count_similar > 0 )


{


  $template->assign_block_vars('similar', array(


         'L_SIMILAR' => $lang['Similar'],


         'L_TOPIC' => $lang['Topic'],


         'L_AUTHOR' => $lang['Author'],


         'L_FORUM' =>  $lang['Forum'],


         'L_REPLIES' => $lang['Replies'],


         'L_LAST_POST' => $lang['Posted'])


  );


  





for($i = 0; $i < $count_similar; $i++)


{


  $sql = "SELECT t.topic_type, t.topic_status, t.topic_id, t.topic_title, t.topic_time, t.topic_replies, t.topic_last_post_id, u.user_id, u.username, f.forum_id, f.forum_name, p.post_time, p.post_username


  FROM ". nuke_bbtopics ." t, ". nuke_users ." u, ". nuke_bbforums ." f, ". nuke_bbposts ." p


  WHERE t.topic_id = '". $topics[$i]['topic_id'] ."'


  AND f.forum_id = t.forum_id


  AND p.topic_id = t.topic_id 


  AND u.user_id = p.poster_id


  GROUP BY t.topic_id";


 if ( !($result = $db->sql_query($sql)) )


 {


     message_die(GENERAL_ERROR, "Could not get similar topics", '', __LINE__, __FILE__, $sql);


 }


  


  while ( $row = $db->sql_fetchrow($result) )


  {


   $similar = $row;


   


   $tracking_topics = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_t']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_t']) : array();


   $tracking_forums = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_f']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_f']) : array();


   $topic_type =  ( $similar['topic_type'] == POST_ANNOUNCE ) ? $lang['Topic_Announcement'] .' ': '';


    $topic_type .= ( $similar['topic_type'] == POST_STICKY ) ? $lang['Topic_Sticky'] .' ': '';


    $topic_type .= ( $similar['topic_vote'] ) ? $lang['Topic_Poll'] .' ': '';


   $replies = $similar['topic_replies'];


   


   if( $similar['topic_status'] == TOPIC_LOCKED )


   {


      $folder = $images['folder_locked'];


      $folder_new = $images['folder_locked_new'];


   }


   else if( $similar['topic_type'] == POST_ANNOUNCE )


   {


      $folder = $images['folder_announce'];


      $folder_new = $images['folder_announce_new'];


   }


   else if( $similar['topic_type'] == POST_GLOBAL_ANNOUNCE )


   {


      $folder = $images['folder_global_announce'];


      $folder_new = $images['folder_global_announce_new'];


   }


   else if( $similar['topic_type'] == POST_STICKY )


   {


      $folder = $images['folder_sticky'];


      $folder_new = $images['folder_sticky_new'];


   }


   else


   {


      if( $replies >= $board_config['hot_threshold'] )


      {


         $folder = $images['folder_hot'];


         $folder_new = $images['folder_hot_new'];


      }


      else


      {


         $folder = $images['folder'];


         $folder_new = $images['folder_new'];


      }


   }


  if( $userdata['session_logged_in'] )


   {


      if( $similar['post_time'] > $userdata['user_lastvisit'] ) 


      {


         if( !empty($tracking_topics) || !empty($tracking_forums) || isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_f_all']) )


         {


            $unread_topics = true;


            if( !empty($tracking_topics[$topic_id]) )


            {


               if( $tracking_topics[$topic_id] >= $similar['post_time'] )


               {


                  $unread_topics = false;


               }


            }


            if( !empty($tracking_forums[$forum_id]) )


            {


               if( $tracking_forums[$forum_id] >= $similar['post_time'] )


               {


                  $unread_topics = false;


               }


            }


            if( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_f_all']) )


            {


               if( $HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_f_all'] >= $similar['post_time'] )


               {


                  $unread_topics = false;


               }


            }





            if( $unread_topics )


            {


               $folder_image = $folder_new;


               $folder_alt = $lang['New_posts'];


               $newest_img = '<a href="'. append_sid("viewtopic.$phpEx?". POST_TOPIC_URL ."=$topic_id&amp;view=newest") .'"><img src="'. $images['icon_newest_reply'] .'" alt="'. $lang['View_newest_post'] .'" title="'. $lang['View_newest_post'] .'" border="0" /></a> ';


            }


            else


            {


               $folder_image = $folder;


               $folder_alt = ( $similar['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts'];


               $newest_img = '';


            }


         }


         else


         {


            $folder_image = $folder_new;


            $folder_alt = ( $similar['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['New_posts'];


            $newest_img = '<a href="'. append_sid("viewtopic.$phpEx?". POST_TOPIC_URL ."=$topic_id&amp;view=newest") .'"><img src="'. $images['icon_newest_reply'] .'" alt="'. $lang['View_newest_post'] .'" title="'. $lang['View_newest_post'] .'" border="0" /></a> ';


         }


      }


      else 


      {


         $folder_image = $folder;


         $folder_alt = ( $similar['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts'];


         $newest_img = '';


      }


   }


   else


   {


      $folder_image = $folder;


      $folder_alt = ( $similar['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts'];


      $newest_img = '';


   }





   $title = (strlen($similar['topic_title']) > 40) ? (substr($similar['topic_title'], 0, 37) . '...') : $similar['topic_title']; 


   $topic_url = '<a href="'. append_sid("viewtopic.$phpEx?". POST_TOPIC_URL .'='. $similar['topic_id']) .'">'. $title . '</a>';





   $author_url = append_sid("profile.$phpEx?mode=viewprofile&amp;". POST_USERS_URL .'='. $similar['user_id']);





   $author = ( $similar['user_id'] != ANONYMOUS ) ? '<a href="'. append_sid("profile.$phpEx?mode=viewprofile&amp;". POST_USERS_URL .'='. $similar['user_id']) .'">'. $similar['username'] .'</a>' : ( ($similar['post_username'] != '' ) ? $similar['post_username'] : $lang['Guest'] );


  


   $forum_url = append_sid("viewforum.$phpEx?f=". $similar['forum_id']);  


   $forum = '<a href="'. $forum_url .'">'. $similar['forum_name'] .'</a>';


   $post_url = '<a href="'. append_sid("viewtopic.$phpEx?". POST_POST_URL .'='. $similar['topic_last_post_id']) .'#'. $similar['topic_last_post_id'] .'"><img src="'. $images['icon_latest_reply'] .'" alt="'. $lang['View_latest_post'] .'" title="'. $lang['View_latest_post'] .'" border="0" /></a>';


   $post_time = create_date($board_config['default_dateformat'], $similar['topic_time'], $board_config['board_timezone']);


 


    $template->assign_block_vars('similar.topics', array(


         'FOLDER' => $folder_image,


         'ALT' => $folder_alt,


         'TYPE' => $topic_type,


         'TOPICS' => $topic_url,


         'AUTHOR' => $author,


         'FORUM' => $forum,


         'REPLIES' => $replies,


         'NEWEST' => $newest_img,


         'POST_TIME' => $post_time,


         'POST_URL' => $post_url)


    );


  } // while


 } // for $i


} // if ( $count_similar > 0 )





# 


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


# 


# If your Nuke Theme has a forum folder edit





themes/forums/viewtopic_body.tpl for all themes that have the file





or if not edit the file below in your modules/forums/templates/ folder





templates/subSilver/viewtopic_body.tpl





# 


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


#


   <td align="right" valign="top" nowrap="nowrap">{JUMPBOX}<span class="gensmall">{S_AUTH_LIST}</span></td>


  </tr>


</table>





# 


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


# 


   <td align="right" valign="top" nowrap="nowrap">{JUMPBOX}<span class="gensmall">{S_AUTH_LIST}</span></td>


  </tr>


      <tr>


   <td width="100%" colspan="2" align="center">


   <br />


<!-- BEGIN similar -->


<table width="85%" cellspacing="1" cellpadding="4" border="0" align="center" class="forumline">


 <tr>


  <td class="catHead" colspan="6"><span class="genmed"><b>{similar.L_SIMILAR}</b></span></td>


 </tr>


 <tr>


  <th colspan="2">{similar.L_TOPIC}</th>


  <th>{similar.L_AUTHOR}</th>


  <th>{similar.L_FORUM}</th>


  <th>{similar.L_REPLIES}</th>


  <th>{similar.L_LAST_POST}</th>


 </tr>


 <!-- BEGIN topics -->


 <tr>


  <td class="row1" align="center"><span class="genmed"><img src="{similar.topics.FOLDER}" border="0" alt="{similar.topics.ALT}" title="{similar.topics.ALT}" /></span></td>


  <td class="row1" width="30%">{similar.topics.NEWEST}<span class="gensmall">{similar.topics.TYPE}</span> <span class="topictitle">{similar.topics.TOPICS}</span></td>


  <td class="row1" width="10%"><span class="genmed">{similar.topics.AUTHOR}</span></td>


  <td class="row1"><span class="genmed">{similar.topics.FORUM}</span></td>


  <td class="row1" width="15%" align="center"><span class="genmed">{similar.topics.REPLIES}</span></td>


  <td class="row1"><span class="genmed">{similar.topics.POST_TIME} {similar.topics.POST_URL}</span></td>


 </tr>


 <!-- END topics -->


</table>


<!-- END similar -->


   </td>


  </tr>


</table>





# 


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


# 


# EoM