how to get FCKEdit mediawiki riched_start_disabled=1 on star

thanks for the link - we had come to same conclusion i.e "go in & hack everybody's SQL prefs" - I dont like it but havent seen any other solutions.

If we come up w/ a generic, reusable script to do this then I'll repost it here.

cheers, Alan

hello,

For completeness here's the SQL commands we used to ensure that the Rich Editor comes up disabled by default for existing users, as it already does for new users: -

# Update riched_use_toggle if it already exists, or add it if it doesn't
update wiki_user set user_options = REPLACE(user_options, 'riched_use_toggle=0', 'riched_use_toggle=1') where user_options regexp 'riched_use_toggle=';
update wiki_user set user_options = CONCAT_WS('\n', user_options, 'riched_use_toggle=1') where user_options not regexp 'riched_use_toggle=';

# Update riched_start_disabled if it already exists, or add it if it doesn't
update wiki_user set user_options = REPLACE(user_options, 'riched_start_disabled=0', 'riched_start_disabled=1') where user_options regexp 'riched_start_disabled=';
update wiki_user set user_options = CONCAT_WS('\n', user_options, 'riched_start_disabled=1') where user_options not regexp 'riched_start_disabled=';

# Update riched_use_popup if it already exists, or add it if it doesn't
update wiki_user set user_options = REPLACE(user_options, 'riched_use_popup=0', 'riched_use_popup=1') where user_options regexp 'riched_use_popup=';
update wiki_user set user_options = CONCAT_WS('\n', user_options, 'riched_use_popup=1') where user_options not regexp 'riched_use_popup=';

# Update riched_toggle_remember_state if it already exists, or add it if it doesn't
update wiki_user set user_options = REPLACE(user_options, 'riched_toggle_remember_state=0', 'riched_toggle_remember_state=1') where user_options regexp 'riched_toggle_remember_state=';
update wiki_user set user_options = CONCAT_WS('\n', user_options, 'riched_toggle_remember_state=1') where user_options not regexp 'riched_toggle_remember_state=';

cheers, Alan