Page 1 of 1

Enable Single Setting on All Users

Posted: 22 Sep 2015, 18:08
by TastyJams
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?

Re: Enable Single Setting on All Users

Posted: 22 Sep 2015, 20:52
by Madsonic
hi there,

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
best regards

Re: Enable Single Setting on All Users

Posted: 22 Sep 2015, 21:37
by TastyJams
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!

Re: Enable Single Setting on All Users

Posted: 22 Sep 2015, 21:44
by Madsonic
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

Posted: 22 Sep 2015, 22:57
by TastyJams
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"?

Re: Enable Single Setting on All Users

Posted: 22 Sep 2015, 23:38
by Madsonic
;)

Code: Select all

update user_settings set SHOW_ARTIST_INFO=true where username='test'
best regards