#########################################################################
## Tabelle Onlineuser
#########################################################################
db.define_table('online',
SQLField('user_id',db.auth_user),
SQLField('last_visit','integer'))
On 4 Jan., 16:40, Richard Vézina <[email protected]> wrote:
> The model are missing for db.online
>
> Richard
>
>
>
>
>
>
>
> On Mon, Jan 3, 2011 at 5:13 PM, pk <[email protected]> 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
