Email confirmation [message #19523] |
Fri, 30 July 2004 14:15 |
betacire
Messages: 18 Registered: July 2004
Karma: 0
|
Junior Member |
|
|
Hi,
Where can I find the info if a user is confirmed or not ?
I need a sql query to extract only confirmed users so something like that :
select distinct email from fud_users where ????
What is the "users_opt" field ?
I saw this in the fud_users.tpl file :
# Opts
# 1 display_email (ON/OFF)
# 2 notify (ON/OFF)
# 4 notify_method (EMAIL/ICQ)
# 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)
But how can I use that ?
Thanks,
Béa
|
|
|
Re : Email confirmation [message #19524 is a reply to message #19523] |
Fri, 30 July 2004 16:05 |
betacire
Messages: 18 Registered: July 2004
Karma: 0
|
Junior Member |
|
|
Citation : | Hi,
Where can I find the info if a user is confirmed or not ?
I need a sql query to extract only confirmed users so something like that :
select distinct email from fud_users where ????
What is the "users_opt" field ?
I saw this in the fud_users.tpl file :
# Opts
# 1 display_email (ON/OFF)
# 2 notify (ON/OFF)
# 4 notify_method (EMAIL/ICQ)
# 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)
But how can I use that ?
Thanks,
Béa
|
Ok, I think I found it, it's something like :
SELECT email FROM fud_users WHERE users_opt & 131072
Is it ok ?
Thanks
|
|
|
|