can nobody help me???
On 3 Jan., 23:13, pk <peter.kirch...@youngdesigners.de> wrote:
> 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
