Fud30 users

From FUDforum Wiki
Jump to: navigation, search

Description of FUDforum table fud30_users. This table contains the forum's users with their details and preferences. For more information, see Moderator/User Manager, Add User and Merge Users.

Fields

Column Name Datatype Can be Null? Key? Default Description
id int(11) NO PRI auto_increment
login varchar(50) NO UNI User's login ID.
alias varchar(50) NO UNI User alias.
passwd varchar(32) NO User's password (encrypted).
salt varchar(32) NO Password salt. (Added in FUDforum 3.0.1).
name varchar(255) NO User's name.
email varchar(255) NO UNI User's e-mail address.
location varchar(255) YES
interests varchar(255) YES
occupation varchar(255) YES
avatar int(11) NO 0 References fud30_avatar.id.
avatar_loc varchar(512) YES Avatar location. Changed from TEXT to VARCHAR(512) in FUDforum 3.0.2.
icq bigint(20) YES ICQ handle.
aim varchar(255) YES AIM handle.
yahoo varchar(255) YES Yahoo handle.
msnm varchar(255) YES MSN Messenger handle.
jabber varchar(255) YES Jabber handle.
affero varchar(255) YES Affero handle. (From FUDforum 3.0.7 this column is no longer used).
google varchar(255) YES Google handle.
skype varchar(255) YES Skype handle.
twitter varchar(255) YES Twitter handle.
posts_ppg int(11) NO 0
time_zone varchar(255) NO UTC Time zone. Changed default from America/Montreal to URC in FUDforum 3.0.2.
birthday bday CHAR(8) int(11) YES MUL User's date of birth (MMDDYYYY). (Added in FUDforum 3.0.2). bday was removed in FUDforum 3.0.2.
join_date bigint(20) NO MUL 0 User's registration date.
conf_key varchar(32) YES MUL Confirmation key. Removed NOT NULL and default in FUDforum 3.0.2.
reset_key varchar(32) YES MUL Password reset key. Removed NOT NULL and default in FUDforum 3.0.5.
user_image varchar(255) YES
theme int(11) NO 0 References fud30_themes.id.
posted_msg_count int(11) NO 0
last_visit bigint(20) NO MUL 0 Date of last visit.
referer_id int(11) NO MUL 0 References 'id' (above).
last_read bigint(20) NO 0
custom_status text YES
sig text YES Signature.
level_id int(11) NO 0 User's level. References fud30_level.id.
u_last_post_id int(11) NO 0 References fud30_msg.id.
home_page varchar(255) YES Users home page.
bio text YES Users biography.
cat_collapse_status text YES
custom_color varchar(255) YES
buddy_list text YES
ignore_list text YES
group_leader_list text YES
users_opt int(11) NO MUL 4488117 Options (see below).
sq varchar(32) YES
registration_ip reg_ip VARCHAR(46) </s>bigint(20)</s> NO 0 Registration IP address. Was registration_ip before FUDforum 3.0.4.
ban_expiry bigint(20) NO 0 If user is banned, when the ban will expire.
topics_per_page int(11) NO 40 Number of topics to display per page.
last_login bigint(20) NO 0 Last login time.
flag_cc char(2) YES Country code.
flag_country varchar(50) YES Country name.
last_used_ip last_known_ip VARCHAR(46) bigint(20) NO 0 Last IP address used. Was last_known_ip before FUDforum 3.0.4.
custom_fields text YES Values for Custom profile fields. (Added in FUDforum 3.0.2).

Keys

Index Name Uniqueness Column Name Seq in index Comments
PRIMARY UNIQUE id 1
fud30_users_i_l UNIQUE login 1
fud30_users_i_e UNIQUE email 1
fud30_users_i_a UNIQUE alias 1
fud30_users_i_rk NOT UNIQUE reset_key 1
fud30_users_i_lv NOT UNIQUE last_visit 1
fud30_users_i_ck NOT UNIQUE conf_key 1
fud30_users_i_ri NOT UNIQUE referer_id 1
fud30_users_i_uo NOT UNIQUE users_opt 1
fud30_users_i_jd NOT UNIQUE join_date 1
fud30_users_i_bd NOT UNIQUE birthday 1 (Added in FUDforum 3.0.2).

Options

Binary values for users_opt:

  • 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 (or banned) (ON/OFF)
  • 131072 = email_conf (ON/OFF)
  • 262144 = coppa (ON/OFF)
  • 524288 = is_mod (ON/OFF)
  • 1048576 = is_admin (ON/OFF)
  • 2097152 = acc_status (PENDING/APPROVED)
  • 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)
  • 268435456 = account moderator (ON/OFF)
  • 536870912 = always moderate user's posts (ON/OFF)
  • 1073741824 = is_spider
FUDforum tables

fud30_action log | fud30_ann forums | fud30_announce | fud30_attach | fud30_avatar | fud30_blocked_logins | fud30_bookmarks | fud30_buddy | fud30_calendar | fud30_cat | fud30_custom_fields | fud30_custom_tags | fud30_email_block | fud30_ext_block | fud30_fc_view | fud30_fl_1 | fud30_fl_pg | fud30_fl_pm | fud30_forum | fud30_forum_notify | fud30_forum_read | fud30_geoip | fud30_group_cache | fud30_group_members | fud30_group_resources | fud30_groups | fud30_index | fud30_ip_block | fud30_jobs | fud30_level | fud30_mime | fud30_mlist | fud30_mod | fud30_msg | fud30_msg_report | fud30_msg_store | fud30_nntp | fud30_pages | fud30_plugins | fud30_pmsg | fud30_poll | fud30_poll_opt | fud30_poll_opt_track | fud30_read | fud30_replace | fud30_search | fud30_search cache | fud30_ses | fud30_smiley | fud30_spiders | fud30_stats_cache | fud30_themes | fud30_thr_exchange | fud30_thread | fud30_thread_notify | fud30_thread_rate_track | fud30_title_index | fud30_tv_1 | fud30_user_ignore | fud30_users | fud30_xmlagg

Languages
Personal tools
This is a cached copy of the requested page, and may not be up to date.

Sorry! This site is experiencing technical difficulties.
Try waiting a few minutes and reloading.

(Can't contact the database server: Cannot return last error, no db connection)


You can try searching via Google in the meantime.
Note that their indexes of our content may be out of date.