/[drupal]/contributions/modules/similar/similar.module
ViewVC logotype

Diff of /contributions/modules/similar/similar.module

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.8.2.4, Fri May 8 14:25:21 2009 UTC revision 1.8.2.5, Thu Jul 16 13:15:03 2009 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: similar.module,v 1.8.2.3 2009/05/08 13:44:36 deekayen Exp $  // $Id: similar.module,v 1.8.2.4 2009/05/08 14:25:21 deekayen Exp $
3    
4  /**  /**
5   * @file   * @file
# Line 253  function theme_similar_content($node) { Line 253  function theme_similar_content($node) {
253        $taxonomy_tids = (int)$taxonomy_tids;        $taxonomy_tids = (int)$taxonomy_tids;
254      }      }
255    
256      $result = db_query_range("SELECT r.nid, MATCH(r.body, r.title) AGAINST ('%s') AS score FROM {node_revisions} r INNER JOIN {node} n ON r.nid = n.nid AND r.vid = n.vid INNER JOIN {term_node} t ON n.nid = t.nid AND t.tid IN (%s) WHERE MATCH(r.body, r.title) AGAINST ('%s') AND n.status <> 0 AND r.nid <> %d AND n.type IN ($types) GROUP BY n.nid ORDER BY score DESC, r.vid DESC", $text, $taxonomy_tids, $text, $node->nid, 0, variable_get('similar_num_display', 5));      $query = "SELECT r.nid, MATCH(r.body, r.title) AGAINST ('%s') AS score FROM {node_revisions} r INNER JOIN {node} n ON r.nid = n.nid AND r.vid = n.vid INNER JOIN {term_node} t ON n.nid = t.nid AND t.tid IN (%s) WHERE MATCH(r.body, r.title) AGAINST ('%s') AND n.status <> 0 AND r.nid <> %d AND n.type IN ($types) GROUP BY n.nid ORDER BY score DESC, r.vid DESC";
257    }    }
258    else {    else {
259      $result = db_query_range("SELECT r.nid, MATCH(r.body, r.title) AGAINST ('%s') AS score FROM {node_revisions} r INNER JOIN {node} n ON r.nid = n.nid AND r.vid = n.vid WHERE MATCH(r.body, r.title) AGAINST ('%s') AND n.status <> 0 AND r.nid <> %d AND n.type IN ($types) GROUP BY n.nid ORDER BY score DESC, r.vid DESC", $text, $text, $node->nid, 0, variable_get('similar_num_display', 5));      $query = "SELECT r.nid, MATCH(r.body, r.title) AGAINST ('%s') AS score FROM {node_revisions} r INNER JOIN {node} n ON r.nid = n.nid AND r.vid = n.vid WHERE MATCH(r.body, r.title) AGAINST ('%s') AND n.status <> 0 AND r.nid <> %d AND n.type IN ($types) GROUP BY n.nid ORDER BY score DESC, r.vid DESC";
260    }    }
261    
262      $query = db_rewrite_sql($query, 'n', 'nid');
263      $result = db_query_range($query, $text, $text, $node->nid, 0, variable_get('similar_num_display', 5));
264    
265    while ($node = db_fetch_object($result)) {    while ($node = db_fetch_object($result)) {
266      $content = node_load($node->nid);      $content = node_load($node->nid);
267      if ($teaser) {      if ($teaser) {
Legend:
Removed from v.1.8.2.4  
changed lines
  Added in v.1.8.2.5
  ViewVC Help
Powered by ViewVC 1.1.2