query field setup

Hello

I am trying to create a field to use in a cb content module.

The job of this field is to return an online users list and the avatar of each user.

I made the following query:
SELECT DISTINCT a.userid AS auser, b.id AS bid, b.username AS busername, c.user_id AS cuser, c.avatar AS cavatar
FROM #__session a
LEFT JOIN #__users b ON a.userid = b.id
LEFT JOIN #__comprofiler c ON a.userid = c.user_id WHERE a.userid !=0 ORDER BY b.username ASC;

Tested the query in database and it works.

Now i take it to the field.

New query field and the above query in Parameters/Query.

Display Tab:

Multiple rows
Header: <table width='100%'>

Row: <tr><td width="30%"><img scr="/images/comprofiler/tn[column_cavatar]" width="40px" height="40px"></td><td width="70%">[column_busername] [cb:userfield field="avatar" userid="user_id" /]</td></tr>

Footer: </table>

and here is the result...



Can you please tell me what i am doing wrong?

The avatars are in place and accessible as images through the browser.

Thank you.

The job of this field is to return an online users list and the avatar of each user.

We provide the CB Online Module included with CB for doing exactly that. Is that not sufficient for your needs? Your query doesn't seam to be doing any custom filtering to require needing to use CB Query Field.

Row: <tr><td width="30%"><img scr="/images/comprofiler/tn[column_cavatar]" width="40px" height="40px"></td><td width="70%">[column_busername] [cb:userfield field="avatar" userid="user_id" /]</td></tr>

Substitutions support nesting for some parts. The below for example will render their avatar safely.

[cb:userfield field="avatar" user="[column_id]" /]

Your query should only need to select the ID column as you'll be able to use this nesting behavior for all user parameters in substitutions. Please read our substitution documentation below carefully as it covers explaining how to properly use substitutions and the nesting behavior.

www.joomlapolis.com/documentation/279-community-builder/tutorials/18353-using-substitutions-throughout-cb

We provide the CB Online Module included with CB for doing exactly that. Is that not sufficient for your needs? Your query doesn't seam to be doing any custom filtering to require needing to use CB Query Field.

I checked the cb online module but it does not return both username and avatar. It is the one or the other. Also i need to add an extra field of gender in the list when this is fixed.

Even with this code i have no results...

<tr><td width="30%"><img scr=" www.domain/images/comprofiler/tn [column_cavatar]" width="40px" height="40px"></td><td width="70%">[column_busername]</td></tr>

returns:


If you check the url it is correct and you can open the avatar with a browser!

I checked the cb online module but it does not return both username and avatar. It is the one or the other. Also i need to add an extra field of gender in the list when this is fixed.

It can display whatever you want it to display. Use the "User-text" parameter to completely customize what HTML is displayed per user displayed. This supports HTML and substitutions. You do not need a query field for this and that's really the hard way to be doing this. Example as follows.

User-text
It however looks like you just want to display their canvas containers. CB Online Module includes a layout for doing exactly that. Under Advanced Options set Layout to "canvas".

Thank you Krileon!

The "User-text" field solution did the trick and it shows pretty fine with the appropriate css classes.

ere is the last step we have to deal with but we can not find anything related in the substitutions tutorial or inside the forum

Right now we have this:

<div>
<div>[cb:userfield field="formatname" reason="list" /]</div>
<div>[cb:userfield field="avatar" reason="list" /]</div>
</div>

We need to continue in the second div with the following...

We also tried [cb:userfield field="GENDER" reason="list" /] and it returns the gender of each user successfully.

But we need to condition it like this:

if [cb:userfield field="GENDER" reason="list" /] is male... show a beautiful "M"
and
if [cb:userfield field="GENDER" reason="list" /] is female... show a beautiful "F"

F and M may be an img script.

I am sure that something like this can be done using substitutions! Can you please point us to the right direction?

Thank you