Active
Project:
Site map
Version:
6.x-2.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
16 Mar 2012 at 02:41 UTC
Updated:
16 Mar 2012 at 02:41 UTC
This is needed to ensure that the module does not show access controlled content. I was actually surprised that the Domain Access rewrite worked with the aggregate SQL, but it did.
$sql = "SELECT DISTINCT u.uid, u.name, count(u.uid) AS numitems
FROM {node} n
INNER JOIN {users} u ON u.uid = n.uid
WHERE n.type = 'blog' AND n.status = 1
GROUP BY u.uid, u.name
ORDER BY numitems DESC, u.name";
# Line 169 site_map.module
- $result = db_query_range($sql, 0, 10);
+ $result = db_query_range(db_rewrite_sql($sql), 0, 10);