Hi @dglassman
Would you please explain what specific information do you need to change?
Perhaps we can share with you more detailed information.
– Gaby, Customer Support.
In Gallery -> Other Options -> Roles & Capabilities, I need to change all of the roles from “Administrator” to “Editor” with the exception of “Main NextGEN Gallery overview” and “Change options”.
If you could just tell me where this data is stored in the mysql database, I will be able to manually edit it myself via MySql Shell.
Hi @dglassman
We usually don’t answer this kind of questions because they are out of our support scope. But this time, the developer took some time to answer us back.
WordPress stores user roles in the wp_options table; the following SQL will retrieve the site roles:
SELECT * FROM wp_options WHERE option_name = 'wp_user_roles'
However, WP stores the content as a serialized PHP object so the following PHP may be easier:
$role = get_role('editor');
// $role->add_cap('NextGEN Gallery overview'); - Skipping intentionally
$role->add_cap('NextGEN Use TinyMCE');
$role->add_cap('NextGEN Upload images');
$role->add_cap('NextGEN Manage gallery');
$role->add_cap('NextGEN Manage tags');
$role->add_cap('NextGEN Manage others gallery');
$role->add_cap('NextGEN Edit album');
$role->add_cap('NextGEN Change style');
$role->add_cap('NextGEN Change options');
$role->add_cap('NextGEN Attach Interface');
– Gaby, Customer Support
Thank you! I appreciate you taking the time to answer that question for me!