change everyone's viewing preference

[boiboi]

can someone give me the query to change everyone's viewing preference to linear oldest first or linear newest first.

thanks

[Princeton]

this can be done via ADMINCP/ IMPORT & MAINTENANCE/ EXECUTE SQL QUERY

take a look at the choices in the dropdown menu

[boiboi]

thanks!