| 1 |
<?php |
<?php |
| 2 |
// $Id: helptip.module,v 1.3.2.8 2006/12/08 19:58:35 yogadex Exp $ |
// $Id: helptip.module,v 1.3.2.9 2006/12/17 04:35:11 yogadex Exp $ |
| 3 |
|
|
| 4 |
/** |
/** |
| 5 |
* @file |
* @file |
| 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)) { |
Parent Directory
| 
Revision Log
| 
Revision Graph
| 
Patch