SFMEMBERS Table

The SFMEMBERS table in is where additional, Simple:Press specific information is stored for Users in Simple:Press. The columns in the SFMEMBERS table are:

user_id – ID of the User in the WP Users table

display_name – Display name to user for the User on Forum pages

pm – Determines if the User has Permissions to use the PM system

moderator – Determines if the User belongs to a User Group with the Moderator flag set

avatar – Serialized array of the various User Avatars (ie uploaded, pool, etc)

signature – Contains the signature of the User to be appended to the bottom of all Posts by the User

posts – Number of Posts the User has made

lastvisit – Date/Time of the last visit by the User

subscribe – Serialized array of Topics the User has subscribed to

buddies – Serialized array of Users that are in this Users buddy list in the PM system

newposts – Serialized array of Posts that have been made in the Forum since the Users last visit

checktime – Last time the User was on the server and performed an action

admin – Determines if the User is also an Admin

watches – Serialized array of Topics that the User is watching

posted_rated – Serialized array of Posts that the User has given a rating on

admin_options – If the User is an Admin, contains a serialized array of their Admin Options

user_options – Serialized array of options that User has selected in their Profile

feedkey – User Unique feedkey for determining access to RSS feeds based on Permissions