UBB.Developers Forums UBB.threads 7 Development How Do I? Make "Main Index" the default

I would like to know if there is a way to make the Main Index the default for all of my users. I know that they can go into their profile and change it themselves, but I want to do it for them. My users are VERY illiterate (did I spell that right?) and I know that when they click the button to enter the forum, login, and are not taken to the forum but to the My Home page, they'll freak.

I found this on the UBB boards that was supposed to do it, but it doesn't seem to work (I tried creating new users and logging in, but it still defaults to the My Home page):

UPDATE w3t_Users SET U_StartPage='mi' WHERE U_Username='username'

Any suggestions?

That command will only update existing users. The 'cp' default is the default hardcoded into the database. You could change the default....

I would recommend backing up your database first, then do this:


ALTER TABLE w3t_Users
CHANGE 'U_StartPage' 'U_StartPage' CHAR(2) DEFAULT 'mi'

Thanks Josh. I will definately back up the db first, but i'm just curious as to what could happen by running query? Anything permanent?

That query that I just posted changes the default... so new records created will default to 'mi' (main index) instead of 'cp' (control panel/my home) which is the default.

So that query I just posted is a permanent change to the defaults and will apply to new users.

I gotcha. Thanx again for the help.

Hmmm I get this...

SQL ERROR: Unable to do_query: ALTER TABLE w3t_Users CHANGE 'U_StartPage' 'U_StartPage' CHAR(2) DEFAULT 'mi'
You have an error in your SQL syntax near ''U_StartPage' 'U_StartPage' CHAR(2) DEFAULT 'mi' ' at line 2 row(s) affected by your query.

Whoops... my bad. Didn't need the little quotes around the field name.

Do it like this:

ALTER TABLE w3t_Users
CHANGE U_StartPage U_StartPage CHAR(2) DEFAULT 'mi'

You can also do this

UPDATE w3t_Users SET U_StartPage='mi' WHERE U_StartPage='cp'

Yeah, that'll just update existing users. Altering the tables default will make it "stick" for all new users to come.

true that

In cases where column names have to be quoted (e.g., if you're insane, and use spaces in them), I think you have to use backquotes: `foo bar`

Ah OK
That makes sense. In threads then we are pretty safe without quotes then.

Thanks Ea... Nevermind.

Thanks.