FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Email confirmation
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Email confirmation [message #19523] Fri, 30 July 2004 14:15 Go to next message
betacire   France
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 Go to previous messageGo to next message
betacire   France
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


Re: Re : Email confirmation [message #19532 is a reply to message #19524] Mon, 02 August 2004 13:21 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The query will check if the user has been confirmed via e-mail.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Old Format
Next Topic: RDF help
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 03:17:24 GMT 2024

Total time taken to generate the page: 0.03412 seconds