Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Exporting bulk invitation codes

I would like to personally email our invitation codes instead of using the forum feature.

Is it possible to export a batch of codes so I can do this?


  • Options
    x00x00 MVP
    edited February 2013

    you should be able just to populate the GDN_Invitation table, then send them off with a valid link. You would need to generate some unique ids. it depends how you are importing as to how you are doing it.

    I would test a few first.

    You can run

    CREATE TRIGGER before_insert BEFORE INSERT ON GDN_Invitation FOR EACH ROW SET new.Code = uuid(), new.DateInserted = now();

    to ensure you get new codes, and dates on insert.

    then you can import a csv like so


    then you want to send links of this format.{Code}

    grep is your friend.

Sign In or Register to comment.