Your premium source for custom modification services for phpBB
Home
ForumsBlogMOD ManagerFAQSearch
Log in
| Your premium source for custom modification services for phpBB |
|
|
Home ForumsBlogMOD ManagerFAQSearch
Log in
|
||
| |||
| Tables — Table Structure |
phpbb_users Base user information, preference settings, and so on. |
| Column Name | Datatype | Default | Column Description |
|---|---|---|---|
| user_id | mediumint(8) |
0 | Unique system-assigned ID. This is not an unsigned value due to the ANONYMOUS user being -1. The original admin user is 2 (unless that row has been deleted). |
| user_active | tinyint(1) |
1 | Big flag: 1 = Active 0 = Inactive For more on this field see the documentation on user registration. |
| username | varchar(25) |
This field is not indexed in a standard phpBB installation. It should be. Usernames should be unique, and an index would enforce that constraint. | |
| user_password | varchar(32) |
A 32 character string resulting from the md5() hash of the user password string. The md5() hash is not reversible; the only means of getting a password are to know it, to guess it, or to brute-force crack it. | |
| user_session_time | int(11) |
0 | This field duplicates the session_time from the phpbb_sessions table. It is a unix_timestamp value for the session. |
| user_session_page | smallint(5) |
0 | This value duplicates a column from the phpbb_sessions table. It contains a code that denotes the page the user is on. These page constants are defined in includes/constants.php. |
| user_lastvisit | int(11) |
0 | A unix_timestamp value that records the user last visit date/time. There is some question as to how thoroughly this value is updated... that some users may visit the board without this field being updated. Under investigation. |
| user_regdate | int(11) |
0 | The user registration date in unix_timestamp format. |
| user_level | tinyint(4) |
0 | Coded field: 0 = Normal User 1 = System Admin 2 = Moderator Note that you should not rely on the moderator status as it could be left "on" when the user is truly no longer a moderator for any areas on the board. |
| user_posts | mediumint(8) unsigned |
0 | The value is a cumulative count of the posts a user has made. It will likely not match the number of posts in the database due to pruning. For more details, refer to the documentation on the topic / post / pruning process. |
| user_timezone | decimal(5,2) |
0 | This field contains the user offset for time zone calculations. |
| user_style | tinyint(4) |
This links to the phpbb_themes table, and contains the themes_id for the theme / style selected by the user. Note that this may be overridden by the board style if selected in the ACP. | |
| user_lang | varchar(255) |
This string value contains the text that will be used to specify the language sub-folder. For example, if this entry is english then the language entries from language/lang_english/lang_main.php will be used. | |
| user_dateformat | varchar(14) |
d M Y H:I | A string containing the user preference for date / time display formats. |
| user_new_privmsg | smallint(5) unsigned |
0 | No description provided |
| user_unread_privmsg | smallint(5) unsigned |
0 | No description provided |
| user_last_privmsg | int(11) |
0 | No description provided |
| user_emailtime | int(11) |
This field is only used when board_email_form is enabled, meaning users send email via the board. It contains the date/time (unix_timestamp) of the most recent email sent by the user, NULL if no email has been sent. | |
| user_viewemail | tinyint(1) |
Bit field: 0 = Do not show email address 1 = Show email address |
|
| user_attachsig | tinyint(1) |
Bit field that determines whether the attach sig box should be checked by default or not. 0 = No (unchecked) 1 = Yes (checked) |
|
| user_allowhtml | tinyint(1) |
1 | Bit field that determines whether the allow html box should be checked by default or not. 0 = No (unchecked) 1 = Yes (checked) |
| user_allowbbcode | tinyint(1) |
1 | Bit field that determines whether the disable bbcode box should be checked by default or not.
1 = No (unchecked)
0 = Yes (checked) Note that this field is reversed as the screen field says "disable" and the database field says "allow". |
| user_allowsmile | tinyint(1) |
1 | Bit field that determines whether the disable smiles box should be checked by default or not.
1 = No (unchecked)
0 = Yes (checked) Note that this field is reversed as the screen field says "disable" and the database field says "allow". |
| user_allowavatar | tinyint(1) |
1 | Bit field set by the board administrator. The user cannot set this field themselves. It is used to control whether the selected user may have an avatar or not. 0 = No 1 = Yes |
| user_allow_pm | tinyint(1) |
1 | Bit field set by the board administrator. The user cannot set this field themselves. It is used to control whether the selected user may send private messages or not. 0 = No 1 = Yes |
| user_allow_viewonline | tinyint(1) |
1 | Bit field that determines whether the user has elected to hide their online status or not. This is reflected on the index and on viewonline. 0 = Hide 1 = Display |
| user_notify | tinyint(1) |
0 | Bit field denoting the default status of the Notify on Reply box on posting 0 = Off 1 = On Note that this field may be changed on each post. |
| user_notify_pm | tinyint(1) |
1 | Bit field storing the user preference for notification on new Private Messages (PM). 0 = No 1 = Yes If set to Yes, the user will get an email every time they receive a new PM. |
| user_popup_pm | tinyint(1) |
0 | Bit field that denotes whether the user has requested a popup when they visit the board and there are new Private Messages. 0 = No popup 1 = Use popup |
| user_rank | int(11) |
0 | Optional foreign key to the phpbb_ranks table. This column only has a value if the user has been assigned a special rank, otherwise the rank is determined by user_posts instead. |
| user_avatar | varchar(100) |
Contains the gallery avatar path (avatar_type = 3) or the uploaded filename (avatar_type = 2) or the remote image location (avatar_type = 1) or nothing (avatar_type = 0) | |
| user_avatar_type | tinyint(4) |
0 | Coded field denoting user avatar type: 0 = No avatar 1 = Uploaded 2 = Remote hosted 3 = Gallery |
| user_email | varchar(255) |
User email address | |
| user_icq | varchar(15) |
ICQ information stored as part of the user profile | |
| user_website | varchar(100) |
A user may enter a website as part of their profile. This makes phpBB forums very attractive to spam registrations. See further documentation on how to prevent this type of registration. | |
| user_from | varchar(100) |
Location information that the user can enter for their profile. | |
| user_sig | text |
This is the user signature. It is defined as a text field, and the length is limited by an entry in the phpbb_config table (max_sig_chars), set by the board administrator. | |
| user_sig_bbcode_uid | varchar(10) |
If the user signature includes BBCode, it will use this ID. See more documentation on how BBCode is stored, parsed, and displayed. | |
| user_aim | varchar(255) |
AIM (AOL Instant Messanger) contact information which is recorded as part of the user profile. | |
| user_yim | varchar(255) |
YIM (Yahoo Instant Messanger) contact information which is recorded as part of the user profile. | |
| user_msnm | varchar(255) |
MSNM contact information which is recorded as part of the user profile. | |
| user_occ | varchar(100) |
Text field allowing the user to note their occupation on their user profile. | |
| user_interests | varchar(255) |
Text field allowing the user to note some specific interests on their user profile. | |
| user_actkey | varchar(32) |
If user activation is turned on, this field will contain a system-generated value that is included in the activation email. When the user clicks the link, their key is compared to the value stored in the database. If it matches, the user is activated. | |
| user_newpasswd | varchar(32) |
This field is used only during the change password process. Normally this field is empty. |
| Rank assigned to User | phpbb_ranks.rank_id = phpbb_users.user_rank |
| Topic starting user | phpbb_users.user_id = phpbb_topics.topic_poster |
| User vote record | phpbb_users.user_id = phpbb_vote_voters.vote_user_id |
| Banned users | phpbb_users.user_id = phpbb_banlist.ban_userid |
| User making the Post | phpbb_users.user_id = phpbb_posts.poster_id |
| Private Message: Sent to user | phpbb_users.user_id = phpbb_privmsgs.privmsgs_to_userid |
| User Watching Topic | phpbb_users.user_id = phpbb_topics_watch.user_id |
| User Session | phpbb_users.user_id = phpbb_sessions.session_user_id |
| User Group cross reference | phpbb_users.user_id = phpbb_user_group.user_id |
| Private Message: Sent from user | phpbb_users.user_id = phpbb_privmsgs.privmsgs_from_userid |
|
HomeForumsMOD ManagerFAQSearch
Register
Log in
|
|
|
Not endorsed by or affiliated with the phpBB Group Powered by phpBB © phpBB Group |
Terms of Service Web design by MomentsOfLight.com 
|