Not signed in (Sign In)

Categories

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.

Help keep Vanilla free:
Welcome Guest!
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.

Vanilla: Expanding User Account Information (The LUM_User Table)

Bottom of Page

1 to 6 of 6

  1.  
    • CommentAuthoretchps
    • CommentTimeFeb 15th 2008
     # 1
    I've recently inherited administrator responsibilities for a Lussumo Vanilla Community which maintains information for a professional organization. I would like to expand user information to include elements such as: "Dues Payment Method" and "Date Dues Paid". I'm a novice at PHP scripting, but I notice that fields can be added using the "PredefinedAttributes" add-on. However, can't I accomplish the same task by using the mysql "Alter Table" command? It seems to me that adding additional fields to the predefinedattibutes element will complicate database searches.

    I am overlooking something? Are there benifits or pitfalls that I am not aware of?

    Thanks....
    •  
      CommentAuthorFyorl
    • CommentTimeFeb 15th 2008
     # 2
    Simply adding new columns to the database table with the ALTER TABLE command won't do anything unless you somehow tie those into Vanilla.

    I'm pretty sure there's an extension that will handle this for you but I can't remember what it was called.
  3.  # 3

    Vanilla already lets users add custom info to their profile. The Predefined Attributes extension will let you specify some that should always be there.
    •  
      CommentAuthorpbear
    • CommentTimeFeb 15th 2008
     # 4
    I think users can redefine their predefined attributes. This might not be a good idea if someone doesn't want to pay dues.
    • CommentAuthoretchps
    • CommentTimeFeb 15th 2008
     # 5
    After giving this some more thought ... and realizing that user should be restricted from editing their dues status... I'll add a mysql DuesHistory Table and link to it via the UserID Field in the LUM_User table. I'll pick through available PHP code to figure out how to display this information on the "Account" page. Any hints on an easy way to do that?
    •  
      CommentAuthorFyorl
    • CommentTimeFeb 16th 2008
     # 6
    I think there's a delegate for the 'Account' Control that comes right after the rest of the stats. Just have look in the account page template for it

1 to 6 of 6

  1.  
Add your comments
    Username Password
  • Format comments as
 
Back to Discussions Top of Page