User stays permanently on line

[EuroBeat2]

Originally Posted by SirAdrian

Try running these two queries:

Resets his last online time

UPDATE user
   SET lastvisit    = unix_timestamp() - 86400
     , lastactivity = unix_timestamp() - 86400 
 WHERE userid = X;

Deletes any session he has, probably not required

DELETE FROM session WHERE userid = X;

Change X to his user ID.

Thank you. Worked perfectly. I needed to use also the second query, first didn't do the job. Much appreciated!

EB