Hi,
The node_load function is giving me some problems. I installed and then uninstalled node_privacy_byrole and that seems to have caused some issues.
$node = db_fetch_object(db_query(db_rewrite_sql('SELECT n.*, u.uid, u.name, u.picture, u.data FROM {node} n INNER JOIN {users} u ON u.uid = n.uid WHERE '.\
implode(' AND ', $cond))));
does not return an object when a non admin user executes it.
I did an echo db_rewrite_sql and sure enough for an admin user the query is :
SELECT n.*, u.uid, u.name, u.picture, u.data FROM {node} n INNER JOIN {users} u ON u.uid = n.uid WHERE n.nid = '19'
for a non admin user however, its still trying to do a join with node_users
SELECT n.*, u.uid, u.name, u.picture, u.data FROM {node} n INNER JOIN {node_access} na ON na.nid = n.nid INNER JOIN {users} u ON u.uid = n.uid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0')) AND n.nid = '9'
what gives?
-v