2017-05-24, 06:34 PM
i would like to set all current users to source mode, and by default for new users to set as source mode as well. I would also like the users to be able to reset this option if they want it.
This post is the closest i find
https://community.mybb.com/thread-165583...pid1132132
But i think its the opposite to set source mode off. Do you just switch 0s to 1s and 1s to 0s. Does this include TINYINT(1)? And im not sure if it allows the users to change it? What would be the exact command given to set current and future users by default to source mode that will allow them to change it if they wish later?
so i did this
Why is this?
This post is the closest i find
https://community.mybb.com/thread-165583...pid1132132
But i think its the opposite to set source mode off. Do you just switch 0s to 1s and 1s to 0s. Does this include TINYINT(1)? And im not sure if it allows the users to change it? What would be the exact command given to set current and future users by default to source mode that will allow them to change it if they wish later?
so i did this
mysql> ALTER TABLE `mybb_users` CHANGE `sourceeditor` `sourceeditor` TINYINT(0) NOT NULL DEFAULT '1';
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> UPDATE `mybb_users` SET `sourceeditor` = '1' WHERE `sourceeditor` = '0';
Query OK, 1319 rows affected (0.03 sec)
Rows matched: 1319 Changed: 1319 Warnings: 0
mysql>
which my intention was to set current and future accounts to source mode by default. It did change the current users to source mode, but when i created a new account it did not have the editor in source mode checked off.Why is this?