Is it possible to update users Last visited?

[Snex]

I've recently merged my mybb database to vBulletin.
I'm now wondering, if theirs a modification or possible phpmyadmin sql code that I can use to change/update all my 1,700 members last visited on so it appears they last visited yesterday/today?

[Dustin L.]

The users' last visit also includes the time, so it would look like all 1700 users visited at the same time.

Are you sure you want to do this?

Best,

Dustin

[Snex]

The users' last visit also includes the time, so it would look like all 1700 users visited at the same time.

Are you sure you want to do this?

Best,

Dustin

Yes, is their a way?

[Paul M]

Run a simple sql query

UPDATE User SET Lastvisit = 1234567890

Replace 1234567890 with the unix timestamp of the time you want them all to be.

[Snex]

Run a simple sql query

UPDATE User SET Lastvisit = 1234567890

Replace 1234567890 with the unix timestamp of the time you want them all to be.

Thanks Paul, what is the timestamp format? yyyy/mm/day/time?

I used a timestamp generator, and upon running the Query;
1547 rows affected. ( Query took 0.0132 sec )

However, it doesn't change anyones last visited time.

[Pogo]

You should change lastactivity instead of lastvisit.

Offhand, if the dates are the same then that means the user is currently logged out. If the dates are different then the user is logged in, their session has not yet expired, or their session did expire, with lastvisit being the last time the user visited, before the current session. The next time they visit, the lastvisit will be updated to the value of lastactivity. lastvisit is only updated on the first page view of a visit, or if the user manually chooses to logout.

The online status indicators work onf the premise that if the user's lastactivity was in the last 15 mins (default) and that lastvisit and lastactivityare not the same, then the user is online.

Try it out, logout and you'll see the two fields become equal to each other.

So yes, lastactivity, is the very last time the user was online.

[Snex]

You should change lastactivity instead of lastvisit.

That fixed it.

Anyone know if it's possible to also limit how many members you want to have this affect?

[Trevor Hannant]

You would need to either specify a usergroup(s) or a list of users

[Snex]

You would need to either specify a usergroup(s) or a list of users

How do I go about specifying a usergroup?
And as for the list of users, what do I do with the .txt document with the 208 members I want to of visited last?

[Snex]

anyone?