Thread komplexes update (4 answers)
Opened by esskar at 2004-04-12 23:14

esskar
 2004-04-13 00:03
#32026 #32026
User since
2003-08-04
7321 Artikel
ModeratorIn

user image
also weder

Code: (dl )
1
2
3
4
5
my $statement = qq~UPDATE $libyn::Config::DbTables{user_settings}
                   SET
                   lastAction=NOW()
                   WHERE sessionId=$sidQ and DATE_ADD(lastAction, INTERVAL 1 HOUR) < NOW()~;


noch

Code: (dl )
1
2
3
4
my $statement = qq~UPDATE $libyn::Config::DbTables{user_settings}
                   SET
                   lastAction=NOW()
                   WHERE sessionId=$sidQ AND TO_DAYS(NOW()) - TO_DAYS(lastAction) > 1/24~;


funzt!

View full thread komplexes update