| what table is the ban column in? [message #34513] |
Sun, 05 November 2006 20:21  |
Jay D.
Messages: 22
Registered: September 2005
Location: West Palm
Karma: 0
|
Junior Member |
|
|
I am looking for the ban flag/column, that I can update from a simple mysql update. All I see in the members table is the ban expire time. No other column.
Thanks for the help!
J
howdy
|
|
|
|
|
|
| Re: what table is the ban column in? [message #34537 is a reply to message #34513] |
Mon, 06 November 2006 18:00  |
Jay D.
Messages: 22
Registered: September 2005
Location: West Palm
Karma: 0
|
Junior Member |
|
|
thank you. Also, where is the invisible column at? and what flag would it have?
I have taken out the invisible option and we have one member running around invisible, and I'd like to make all of them visible.
howdy
|
|
|
|
| Re: what table is the ban column in? [message #34540 is a reply to message #34537] |
Mon, 06 November 2006 18:08 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Invisible is also a bit setting of the users_opt field. To see the bit definitions look inside of the fud_users.tbl file inside the sql/ directory.
FUDforum Core Developer
|
|
|
|
| Re: what table is the ban column in? [message #34542 is a reply to message #34513] |
Mon, 06 November 2006 18:20 |
Jay D.
Messages: 22
Registered: September 2005
Location: West Palm
Karma: 0
|
Junior Member |
|
|
I'm not sure I understand this. how do I add more than one code to create the options?
# Opts
# 1 display_email (ON/OFF)
# 2 notify (ON/OFF)
# 4 notify_method (EMAIL/ICQ) (ICQ notification is no longer used)
# 8 ignore_admin (ON/OFF)
# 16 email_messages (ON/OFF)
# 32 pm_messages (ON/OFF)
# 64 pm_notify (ON/OFF)
# 128 default_topic_view (MSG/TREE)
# 256 default_message_view (MSG/TREE)
# 512 gender (UNSPECIFIED)
# 1024 gender (MALE/FEMALE)
# 2048 append_sig (ON/OFF)
# 4096 show_sigs (ON/OFF)
# 8192 show_avatars (ON/OFF)
# 16384 show_im (ON/OFF)
# 32768 invisible_mode (ON/OFF)
# 65536 blocked (ON/OFF)
# 131072 email_conf (ON/OFF)
# 262144 coppa (ON/OFF)
# 524288 is_mod (ON/OFF)
# 1048576 is_admin (ON/OFF)
# 2097152 acc_status (P/A)
# 4194304 avatar_approved (No Avatar)
# 8388608 avatar_approved YES
# 16777216 avatar_approved NO
# 33554432 admin disabled PM (ON/OFF)
# 67108864 admin disabled signature (ON/OFF)
# 134217728 do not send e-mail notifications (ON/OFF)
Do I add them together?
howdy
|
|
|
|
|
|
|
|
| Re: what table is the ban column in? [message #34587 is a reply to message #34577] |
Wed, 08 November 2006 17:18 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
You need to take existing value as OR it to 65536
In database you'd do UPATE users SET users_opt=users_opt| 65536 ....
FUDforum Core Developer
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]