FUDforum: How To » How to Change User Profiles Globally

Home » FUDforum » How To » How to Change User Profiles Globally

Show: Today's Messages :: Polls :: Message Navigator

How to Change User Profiles Globally [message #17940]

Mon, 26 April 2004 22:24

tcsboy

Messages: 25
Registered: August 2003

Karma: 0

Junior Member

I would like to change the Default Topic View setting for all user profiles. Previously I would run an UPDATE statement in SQL that affected the desired option.

Where is the Default Topic View option in the database? Or is there a better way of doing this?

Thanks!

I'm looking on the bright side, but I still don't see the light! Idea

Report message to a moderator

Re: How to Change User Profiles Globally [message #17941 is a reply to message #17940]

Mon, 26 April 2004 22:55

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

UPDATE fud26_users SET users_opt = users_opt &~ 128;

FUDforum Core Developer

Report message to a moderator

Re: How to Change User Profiles Globally [message #17942 is a reply to message #17941]

Mon, 26 April 2004 23:02

tcsboy

Messages: 25
Registered: August 2003

Karma: 0

Junior Member

Ilia wrote on Mon, 26 April 2004 16:55

UPDATE fud26_users SET users_opt = users_opt &~ 128;

So, this will do exactly what? Does this change all the defaults to flat view? What do all the numbers in user_opt represent? What does 128 mean?

Hope that all makes sense.

I'm looking on the bright side, but I still don't see the light! Idea

Report message to a moderator

Re: How to Change User Profiles Globally [message #17943 is a reply to message #17942]

Mon, 26 April 2004 23:04

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

This will set the Default Topic View to "tree view". The 'weird' numbers are bitmasks that define various options. For what these numbers, mean refer to fud_users.tbl file inside the sql/ directory.

FUDforum Core Developer

Report message to a moderator

Re: How to Change User Profiles Globally [message #17944 is a reply to message #17943]

Mon, 26 April 2004 23:06

tcsboy

Messages: 25
Registered: August 2003

Karma: 0

Junior Member

Thanks for everything!

I'm looking on the bright side, but I still don't see the light! Idea

Report message to a moderator

Previous Topic:	Can we count views as well as posts?
Next Topic:	Getting a list of unread subscribed postings

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 19:18:14 GMT 2024

Total time taken to generate the page: 0.02739 seconds