User hiding while disabled for normal members

[Leppie]

i've disabled the option to hide online status for normal members, however there's a user who probably set this option before i disabled it. i've been monitoring him for a while now (like a week), but he still appears with hidden online status.
is there any way that i can remove this setting for this user in rc3? i would even edit the sql database, but i don't know which variable holds the info for this option.

all help and suggestions much appreciated.

[IrateZebra]

SQL Query

Code Select Expand

UPDATE `smf_members` SET `show_online` = 1 WHERE `show_online` = 0

[Leppie]

thanks a million, that worked a charm

[IrateZebra]

Happy I could help