There is a way add this functionality to gluon/contrib/comer_server.py
which is going to be more reliable (exact!) and faster (no db
access!).
I will add it in the next few days.
Massimo
On Jan 4, 4:46 pm, pk <peter.kirch...@youngdesigners.de> wrote:
> @auth.requires_login()
> def keepalive():
> import time
> db(db.online.id>0).delete() #evtl. weglassen
> if auth.user.id:
> if db(db.online.user_id==auth.user.id).count()==0:
>
> db.online.insert(user_id=auth.user.id,last_visit=time.time())
> else:
>
> db(db.online.user_id==auth.user.id).update(last_visit=time.time())
> dt = 5000
> 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 what i need is not the auth.user which are online, i need the user
> from another table for example friends.
>
> On 4 Jan., 21:04, Richard Vézina <ml.richard.vez...@gmail.com> wrote:
>
> > Ok and how do you fill up this table?
>
> > By the way SQLField is deprecated... Use Field() instead.
>
> > Richard
>
> > On Tue, Jan 4, 2011 at 2:43 PM, pk <peter.kirch...@youngdesigners.de> wrote:
> > > #########################################################################
> > > ## Tabelle Onlineuser
> > > #########################################################################
> > > db.define_table('online',
> > > SQLField('user_id',db.auth_user),
> > > SQLField('last_visit','integer'))
>
> > > On 4 Jan., 16:40, Richard Vézina <ml.richard.vez...@gmail.com> wrote:
> > > > The model are missing for db.online
>
> > > > Richard
>
> > > > On Mon, Jan 3, 2011 at 5:13 PM, 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
>
>
