Enable Single Setting on All Users

Need help? Post your questions here.
TastyJams
Posts: 59
Joined: 30 Aug 2014, 19:46
Has thanked: 2 times
Been thanked: 22 times

Enable Single Setting on All Users

Unread post 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?
User avatar
Madsonic
Administrator
Administrator
Posts: 984
Joined: 07 Dec 2012, 03:58
Answers: 7
Has thanked: 1201 times
Been thanked: 470 times

Re: Enable Single Setting on All Users

Unread post 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
These users thanked the author Madsonic for the post:
TastyJams
Rating: 7.69%
TastyJams
Posts: 59
Joined: 30 Aug 2014, 19:46
Has thanked: 2 times
Been thanked: 22 times

Re: Enable Single Setting on All Users

Unread post 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!
These users thanked the author TastyJams for the post:
Madsonic
Rating: 7.69%
User avatar
Madsonic
Administrator
Administrator
Posts: 984
Joined: 07 Dec 2012, 03:58
Answers: 7
Has thanked: 1201 times
Been thanked: 470 times

Re: Enable Single Setting on All Users

Unread post 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
TastyJams
Posts: 59
Joined: 30 Aug 2014, 19:46
Has thanked: 2 times
Been thanked: 22 times

Re: Enable Single Setting on All Users

Unread post 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"?
These users thanked the author TastyJams for the post:
Madsonic
Rating: 7.69%
User avatar
Madsonic
Administrator
Administrator
Posts: 984
Joined: 07 Dec 2012, 03:58
Answers: 7
Has thanked: 1201 times
Been thanked: 470 times

Re: Enable Single Setting on All Users

Unread post by Madsonic »

;)

Code: Select all

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