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

Diff of /contributions/modules/helptip/helptip.module

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

revision 1.12, Fri Jan 5 03:28:50 2007 UTC revision 1.13, Mon May 21 00:30:36 2007 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: helptip.module,v 1.11 2006/12/17 04:35:26 yogadex Exp $  // $Id: helptip.module,v 1.12 2007/01/05 03:28:50 yogadex Exp $
3    
4  /**  /**
5   * @file   * @file
# Line 108  function helptip_block($op = 'list', $de Line 108  function helptip_block($op = 'list', $de
108      $paths = _helptip_get_current_paths();      $paths = _helptip_get_current_paths();
109      $path_clause = "('" . implode("' LIKE ht.path OR '", $paths) . "' LIKE ht.path)";      $path_clause = "('" . implode("' LIKE ht.path OR '", $paths) . "' LIKE ht.path)";
110      // use db_rewrite_sql for people with node_access modules      // use db_rewrite_sql for people with node_access modules
111      $result = db_query(db_rewrite_sql("SELECT ht.* FROM {node} n LEFT JOIN {helptip} ht ON ht.nid = n.nid LEFT JOIN {helptip_user_data} ht_hidden ON ht_hidden.uid=$user->uid AND ht_hidden.nid=n.nid AND ht_hidden.relation='hidden' WHERE n.status = 1 AND ht_hidden.relation IS NULL AND $path_clause AND weight >= $settings[min_weight] AND weight <= $settings[max_weight] ORDER BY ht.weight, RAND() LIMIT %d"),      $result = db_query(db_rewrite_sql("SELECT n.nid FROM {node} n LEFT JOIN {helptip} ht ON ht.nid = n.nid LEFT JOIN {helptip_user_data} ht_hidden ON ht_hidden.uid=$user->uid AND ht_hidden.nid=n.nid AND ht_hidden.relation='hidden' WHERE n.status = 1 AND ht_hidden.relation IS NULL AND $path_clause AND weight >= $settings[min_weight] AND weight <= $settings[max_weight] ORDER BY ht.weight, RAND() LIMIT %d"),
112                         $settings['how_many']);                         $settings['how_many']);
113      $block = array();      $block = array();
114      while ($data = db_fetch_object($result)) {      while ($data = db_fetch_object($result)) {
Legend:
Removed from v.1.12  
changed lines
  Added in v.1.13
  ViewVC Help
Powered by ViewVC 1.1.2