Mass Enable Affiliate for Everyone

Discussion in 'aMember Pro v.4' started by skylab, Jan 11, 2013.

  1. skylab

    skylab Member

    Joined:
    Sep 21, 2011
    Messages:
    33
    Any way to enable affiliates to everyone? I've had to import users from vBulletin and in doing so I noticed that none of the users are signed up as an affiliate. There's around 500 members and it'd be easier if I could enable the affiliate network for everyone all at once.
    skylab, Jan 11, 2013
    #1
  2. skylab

    skylab Member

    Joined:
    Sep 21, 2011
    Messages:
    33
    I'm putting the site live tomorrow so I could get a reply on this today, that'd be great. Thanks!
    skylab, Jan 13, 2013
    #2
  3. davidm1

    davidm1 aMember User & Partner

    Joined:
    May 16, 2006
    Messages:
    4,437
    You can do it en mass in phpmyadmin, table am_user / is_affiliate. Set is_affiliate to 1 for all users.

    UPDATE am_user SET is_affiliate ='1' ;

    David
    davidm1, Jan 13, 2013
    #3
  4. skylab

    skylab Member

    Joined:
    Sep 21, 2011
    Messages:
    33
    Duh! Should have realized that one.
    Thanks David for the help!
    skylab, Jan 13, 2013
    #4

Share This Page