Difference between revisions of "Set a user preference"

From Organic Design wiki
(New page: {{procedure |description = This proced...)
 
(status = in use)
Line 2: Line 2:
 
|description = This procedure allows you to directly modify a wiki user's preference from the database
 
|description = This procedure allows you to directly modify a wiki user's preference from the database
 
|role = sysop
 
|role = sysop
 +
|status = in use
 
}}
 
}}
 
You can change a preference such as the skin with the following SQL query. Remove the WHERE clause to apply to all users.
 
You can change a preference such as the skin with the following SQL query. Remove the WHERE clause to apply to all users.

Revision as of 02:52, 16 July 2008

Procedure.svg Set a user preference
Organic Design procedure

You can change a preference such as the skin with the following SQL query. Remove the WHERE clause to apply to all users.

UPDATE user SET user_options = REPLACE(user_options,'skin=monobook','skin=organicdesign') WHERE user_name = 'Foo';