404

D7net

:/ var / www / html / chatweb02 / database /

Filename : verificaonline.sql

back

Create Procedure verificaonline() 
BEGIN
   UPDATE cht_usuarios 
   SET
   cht_usu_online = 'F'
  WHERE  (cht_usu_dhultlogin is null 
		or TIMEDIFF(CURTIME(),CONVERT(DATE_FORMAT(CONVERT_TZ(cht_usu_dhultlogin,'+00:00','-03:00'),'%H:%i'),TIME)) > CONVERT('00:10:00',TIME)
		)
and cht_usu_online = 'O'	
		;
END;