Hello,
Was wondering if there is a database query or something that I can run to enable a single setting for all existing users? For example, enabling the "Show Side Panel" option for all users?
Enable Single Setting on All Users
- Madsonic
- Administrator
- Posts: 984
- Joined: 07 Dec 2012, 03:58
- Has thanked: 1201 times
- Been thanked: 470 times
Re: Enable Single Setting on All Users
hi there,
go to db.view and excute this query to enable the SidePanel for all user
best regards
go to db.view and excute this query to enable the SidePanel for all user
Code: Select all
update USER_SETTINGS set SHOW_NOW_PLAYING=true
Re: Enable Single Setting on All Users
Thanks Mad! Your support has been great lately.
Is there somewhere I can find a list of settings I can modify with this type of command? That would be super helpful!
Is there somewhere I can find a list of settings I can modify with this type of command? That would be super helpful!
- Madsonic
- Administrator
- Posts: 984
- Joined: 07 Dec 2012, 03:58
- Has thanked: 1201 times
- Been thanked: 470 times
Re: Enable Single Setting on All Users
you can display it with this query, but you should better change values only via GUI (for save use)!
Code: Select all
SELECT * FROM user_settings
Re: Enable Single Setting on All Users
Ah yes, thank you!
Last question on this topic... how do I run a query against a specific username? For example, changing "show side panel" for username "test"?
Last question on this topic... how do I run a query against a specific username? For example, changing "show side panel" for username "test"?
- Madsonic
- Administrator
- Posts: 984
- Joined: 07 Dec 2012, 03:58
- Has thanked: 1201 times
- Been thanked: 470 times
Re: Enable Single Setting on All Users
Code: Select all
update user_settings set SHOW_ARTIST_INFO=true where username='test'