[How To?] Update session location?

[Sazze]

Hey you all,
I'm currently working on a plugin, but I wonder: how do I change the online status of a user? using a SQL query (update).

My SQL query so far;

edit: noticed that it shall go in the plugin development, please move the thread Staff.

$uid = $mybb->user["uid"];
 
$timesearch = TIME_NOW - $mybb->settings['wolcutoffmins']*60;
$db->query(" UPDATE ".TABLE_PREFIX."sessions SET `uid`='$uid', `time`={$timesearch}, `location`='New Location!' ");

[Ad Bakker]

I am just wondering why you want to change the status of a user, when this is automatically done by the system. Under which conditions you want to change this?

[Sazze]

I am just wondering why you want to change the status of a user, when this is automatically done by the system. Under which conditions you want to change this?

It's for staff, so they don't have to feel "stalked".

[Ad Bakker]

It's for staff, so they don't have to feel "stalked".

Then they can simply hide themselves from who's online.

[Sazze]

It's for staff, so they don't have to feel "stalked".

Then they can simply hide themselves from who's online.

Still, I'd like to know how to do this.

[Ad Bakker]

Still, I'd like to know how to do this

Every time when a member changes page this session row is refreshed. So you must repeat this action every time they change page.
Undoubtedly there will be ways to do this un a more or less efficient way. But still I think it is cheating your own members.