57 feilds, Yes I see them. Here is the list
Quote
USER_ID int(9) PRI 0
USER_REAL_EMAIL varchar(50) MUL
USER_DISPLAY_EMAIL varchar(50) YES
USER_SIGNATURE text YES
USER_DEFAULT_SIGNATURE text YES
USER_HOMEPAGE varchar(150) YES
USER_OCCUPATION varchar(150) YES
USER_HOBBIES varchar(200) YES
USER_LOCATION varchar(200) YES
USER_START_VIEW varchar(20) cfrm
USER_FAVORITES_TAB varchar(10) forums
USER_FAVORITES_SORT varchar(10) reply
USER_TOPIC_VIEW_TYPE varchar(10) flat
USER_TOPICS_PER_PAGE int(1) YES
USER_NOTIFY_ON_PM char(3) no
USER_ICQ varchar(200) YES
USER_YAHOO varchar(200) YES
USER_MSN varchar(200) YES
USER_AIM varchar(200) YES
USER_EXTRA_FIELD_1 varchar(200) YES
USER_EXTRA_FIELD_2 varchar(200) YES
USER_EXTRA_FIELD_3 varchar(200) YES
USER_EXTRA_FIELD_4 varchar(200) YES
USER_EXTRA_FIELD_5 varchar(200) YES
USER_AVATAR varchar(150) YES
USER_SHOW_AVATARS tinyint(1) 1
USER_VISIBLE_ONLINE_STATUS char(3) YES yes
USER_ACCEPT_PM char(3) YES yes
USER_EMAIL_WATCHLISTS tinyint(1) 0
USER_TITLE varchar(100) YES
USER_POSTS_PER_TOPIC char(2) YES
USER_TEMPORARY_PASSWORD varchar(32) YES
USER_NAME_COLOR varchar(15) YES
USER_TIME_OFFSET varchar(10) YES
USER_TOTAL_PM int(4) YES 0
USER_TOTAL_POSTS int(9) YES 0
USER_SHOW_SIGNATURES char(3) YES
USER_RATING int(1) YES
USER_TOTAL_RATES mediumint(6) 0
USER_AVATAR_WIDTH int(4) YES 0
USER_AVATAR_HEIGHT int(4) YES 0
USER_ACCEPT_ADMIN_EMAILS char(3) YES
USER_BIRTHDAY varchar(10) MUL 0
USER_PUBLIC_BIRTHDAY int(1) 0
USER_TIME_FORMAT varchar(30) YES
USER_IGNORE_LIST text YES
USER_FLOOD_CONTROL_OVERRIDE mediumint(8) YES
USER_STYLE mediumint(4) 0
USER_UNAPPROVED_POST_NOTIFY tinyint(1) 0
USER_TEXT_EDITOR varchar(10) YES standard
USER_HIDE_LEFT_COLUMN tinyint(1) 1
USER_HIDE_RIGHT_COLUMN tinyint(1) 1
USER_CUSTOM_TITLE varchar(255) YES
USER_LANGUAGE varchar(50) YES
USER_MOOD varchar(50) YES
USER_REPORT_POST_NOTIFY tinyint(1) 0
USER_RELATIVE_TIME tinyint(1) YES

Last edited by gliderdad; 01/15/2007 6:56 PM.