7.3 - set all users to have 'My Stuff' on the left

Not really a mod - more a database change, but one that several users may wish to make.

Before making any changes to your database, I would suggest backing it up.

Code

UPDATE ubbt_USER_PROFILE SET USER_SHOW_LEFT_MYSTUFF = '1' WHERE USER_SHOW_LEFT_MYSTUFF = '0'

To make new members also have the 'My Stuff' as a left menu option run

Code

alter table ubbt_USER_PROFILE change USER_SHOW_LEFT_MYSTUFF USER_SHOW_LEFT_MYSTUFF tinyint(1) not null default '1'

Use at your own risk, but you should be fine

Please note that it's only recommended for users of higher resolution to use this option; so you will have alienated users whining that they want it back because their screen scrolls to the left

...

BTW, you have an html line break in your second mysql code

...

Originally Posted by Gizmo

BTW, you have an html line break in your second mysql code

...

That is how the beta seems to store sql commands

Originally Posted by Gizmo

Please note that it's only recommended for users of higher resolution to use this option; so you will have alienated users whining that they want it back because their screen scrolls to the left

...

They can always change it back - but I do not think it will cause an issue on 99% of users displays.

1024 width is the base standard these days.

I found it too restricting on my wife's 1024

... though looks fine on my 1400