[web2py] onlinestatus

[pk]

hi together,

i have a function for the onlineuser:

usersall=db(db.online.last_visit>time.time()-dt)
(db.online.user_id==db.auth_user.id).select(db.auth_user.ALL)
return TABLE(*[TD(user.user_name) for user in usersall])

but i will to get all the onlineuser which are friends of mine.
here is my friendsdatabasetable:

#########################################################################
## Tabelle Freunde
#########################################################################
db.define_table('friends',
                SQLField('userid',
                         default=auth.user.id if auth.user else 0,
                         writable=False, readable=False),
                SQLField('hauptperson',
                         default=auth.user.user_name if auth.user else
0,
                         writable=False, readable=False,
label='Hauptperson'),
                SQLField('freund', label='Freund'),
                SQLField('freundseit', 'datetime',
default=request.now, label='Freund seit'),
                SQLField('bestaetigt','boolean', default=False))

db.friends.userid.requires=IS_IN_DB(db,'auth_user.id')
db.friends.hauptperson.requires=IS_IN_DB(db,'auth_user.user_name')
db.friends.freund.requires=IS_IN_DB(db,'auth_user.user_name')

how can i get this list and how can i do the name clickable???

thanks for your help

peter