userprofile and nodeprofile

johanneshahn - March 13, 2008 - 17:09
Project:Views Fusion
Version:5.x-1.2
Component:Code
Category:feature request
Priority:normal
Assigned:johanneshahn
Status:reviewed & tested by the community
Description

hi,
i want to display a userlist with the current logged in users.
so i created a view with the fields usernode: picture; usernode:name etc and display it as a list to
run through the _views_view_list_[myviewname] function.

then i want to have additional data in my Primary-View wich comes from the
usernode/node-profile modules.

I created a second view for this data and fused it with my primary userlist view.
so my problem was that my userlist shows only users that created a node for
the additional data.

i watched the sql select and found that the nodefamily sqlpart is a INNER JOIN statement


..._users ON usernode.uid = usernode_users.uid INNER JOIN nodefamily nodefamily_parent ON...

after changing it to LEFt JOIN

..._users ON usernode.uid = usernode_users.uid LEFT JOIN nodefamily nodefamily_parent ON...

i get all my online users. in my userlist.

adding to the the views_fusion.module at line 348
this codeline:


$joininfo['type']='left';

to do the LEFT JOIN.

 
 

Drupal is a registered trademark of Dries Buytaert.