OpenMarine
Finding all new threads - Printable Version

+- OpenMarine (https://forum.openmarine.net)
+-- Forum: OpenPlotter (https://forum.openmarine.net/forumdisplay.php?fid=1)
+--- Forum: General discussion (https://forum.openmarine.net/forumdisplay.php?fid=2)
+--- Thread: Finding all new threads (/showthread.php?tid=3797)



Finding all new threads - CapnKernel - 2021-12-08

Hi folks,

When I visit this forum from time to time, I use this link to find the articles I haven't yet read:

  https://forum.openmarine.net/search.php?action=getnew

That way I don't miss any messages.  But on today's visit, I see this up the top of the page:

  Welcome back, CapnKernel. You last visited: Yesterday, 12:00 AM

So, somehow my last logged in time has been reset.

Is there a way to see messages that have been posted since a given date?  (I've tried using search to find all articles since (say) three months ago, but it needs a search term, and I can't use common words like "and" that would find most threads).

Alternatively, could a mod please touch the db and reset my last login date?  I think I last logged in on October 19.

Thanks!

(2021-12-08, 01:33 AM)CapnKernel Wrote: Alternatively, could a mod please touch the db and reset my last login date?  I think I last logged in on October 19.

Seems it's table mybb_users, field lastvisit, and it's a unix timestamp.  FWIW I think this would do it:

Code:
UPDATE mybb_users SET lastvisit = 1634601600 WHERE uid=3407;

Forum gods please?


RE: Finding all new threads - Sailoog - 2021-12-09

Done, I have ran:
UPDATE mybb_users SET lastvisit = 1634601600 WHERE uid=3407;