Adding phone fields

Discussion in 'Customization & add-ons' started by techhead, May 7, 2004.

  1. techhead

    techhead Guest

    I'd like to add a phone field to the signup process, but amember recommends using a common field instead of mysql.

    If I choose common field, how does this effect the mysql dbase? Is it part of the mysql at this point or is it stored somewhere else in a different file format? Will it then be part of the backup process? Can it be reloaded later if a restore is needed? Will it be part of the rebuild function? :confused:

    Any help is greatly appreciated
  2. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    all common fields will be saved to "data" file of "members" table in serialized form.
  3. techhead

    techhead Guest

    How to backup Common Field files

    Are these common field files backed up along with the regular mysql backups or is there another file that should be downloaded as the backup?
  4. pilot

    pilot New Member

    Joined:
    May 24, 2003
    Messages:
    178
    The "members" table is in your mysql database and "data" is a field in "members" so when you back up your database, you will see this info in the mysql dump.

    In short... it will be backed up when you back up your database.

    AmemberPro user
  5. trodman

    trodman Guest

    I've also been very curious about this... What are the pros/cons of using either? Are common fields not searchable? I'm assuming there's got to be some trade-off, or why the choice?

    Forgive me if this question is pretty basic, but all of the documentation is written with the assumption that I know the difference, and therefore, there's no explanation.

    Thanks in advance!
  6. pilot

    pilot New Member

    Joined:
    May 24, 2003
    Messages:
    178
    The common field that Alex spoke of is the information saved in serialized from means that 1 field (common) can carry more user details using a prefix of the information that follows ie: phone: 12333 32222 mobile:849389333

    This is easier to transport over to a third party database rather than lots of separate SQL fields

    I think I nearly got the facts rights :p

    Amember user
  7. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    common fields can be searched but it can be slower.

    Only "common" fields can be used for checkboxes and "multiple select" fields. SQL fields shoud be used for any other situation.

Share This Page