| 1 |
<?php |
<?php |
| 2 |
// $Id: weblinks.module,v 1.86.2.40 2008/08/29 14:11:47 nancyw Exp $ |
// $Id: weblinks.module,v 1.86.2.41 2008/08/30 16:11:14 nancyw Exp $ |
| 3 |
|
|
| 4 |
/** |
/** |
| 5 |
* @file |
* @file |
| 994 |
$query = 'SELECT COUNT(n.nid) FROM {node} n '; |
$query = 'SELECT COUNT(n.nid) FROM {node} n '; |
| 995 |
} |
} |
| 996 |
else { |
else { |
| 997 |
$query = 'SELECT n.nid FROM {node} n '; |
$query = 'SELECT DISTINCT(n.nid) FROM {node} n '; |
| 998 |
} |
} |
| 999 |
$query .= 'INNER JOIN {node_revisions} nr ON nr.vid = n.vid '; |
$query .= 'INNER JOIN {node_revisions} nr ON nr.vid = n.vid '; |
| 1000 |
$query .= 'INNER JOIN {weblinks} bw ON bw.vid = nr.vid '; |
$query .= 'INNER JOIN {weblinks} bw ON bw.vid = nr.vid '; |
| 1032 |
} |
} |
| 1033 |
|
|
| 1034 |
$query = db_rewrite_sql($query); |
$query = db_rewrite_sql($query); |
| 1035 |
|
// drupal_set_message("$tid / $sort / $query"); |
| 1036 |
|
|
| 1037 |
if ($limit) { |
if ($limit) { |
| 1038 |
$result = db_query_range($query, $tid, 0, $limit); |
$result = db_query_range($query, $tid, 0, $limit); |