Locale imported as - (UTC) Monrovia, Reykjavik

[CTXMedia]

I've just noticed that after importing from IP.Board 3.1.4 most members time zone is set to (UTC) Monrovia, Reykjavik when ideally, as a mainly UK forum, it should be (UTC) Dublin, Edinburgh, Lisbon, London.

Is there a query I can run to change everyone who is on (UTC) Monrovia, Reykjavik to (UTC) Dublin, Edinburgh, Lisbon, London?

NB: I don't want to change ALL members as we do have some overseas visitors.

Thanks,
Shaun

 

[Paul B]

UPDATE xf_user SET timezone = 'Europe/London' WHERE timezone = 'Atlantic/Reykjavik'

 

[CTXMedia]

Thanks Paul - or should that be Flash, ahhhaaaaaaaa!!!

Edit: Affected rows: 15045 (Query took 0.6222 sec)