how do I ?????

[jeffj]

I want to show one of my optional fields in the member table in the $whosonlinebit template. I believe I have to add some code i online.php, but I don't see that user or the userfield tables are even accessed in online.php.

any ideas on how to do this?

thanks in advance...

- jeff

[Xenon]

in online.php you see this:

PHP Code:

  $allusers= $DB_site->query("SELECT user.username, session.location, session.lastactivity, user.userid, user.usergroupid, user.invisible, session.host, user.showemail, user.receivepm
                              FROM session
                              ". iif($WOLguests, " LEFT JOIN user USING (userid) ", ",user") ."
                              WHERE session.lastactivity > $datecut
                              ". iif(!$WOLguests, " AND session.userid = user.userid", "") ."
                              ORDER BY user.username
                              "); 


there is the user-table in a join-query....

change it to:

PHP Code:

  $allusers= $DB_site->query("SELECT user.username, session.location, session.lastactivity, user.userid, user.usergroupid, user.invisible, session.host, user.showemail, user.receivepm, userfield.fieldX
                              FROM session
                              ". iif($WOLguests, " LEFT JOIN user USING (userid) LEFT JOIN userfield USING(userid)", ",user") ."
                              WHERE session.lastactivity > $datecut
                              ". iif(!$WOLguests, " AND session.userid = user.userid", "") ."
                              ORDER BY user.username
                              "); 


replace fieldX with the one you want

i think that should work