• Hi,

    I’m trying to do something a little different.
    Basically I want to include in the new user email some custom values that are pulled from the wp DB (or any other mysql DB).
    I know that if I add custom additional fields on registration, they will be available as %whatevercustomfield% for the notification emails.

    What I need is slightly different. I want to pull %myowncustomfield_in_WP_DB% and insert them into the email too.

    I’ve searched the wp_users table but that’s not where RPR saves the custom fields. So where does RPR save these fields in the database? What part of the code do I have to hack to have RPR grab my custom fields and include them in the email?

    Thanks,

    Peter

    http://ww.wp.xz.cn/plugins/register-plus-redux/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter petervnv

    (@petervnv)

    Answering (partially) my own question, I see that RPR stores custom fields in wp_usermeta table.

    Is it possible for RPR to grab data from my own custom field, even if it’s in wp_users table, and insert that data into the new user welcome email?

    Or, alternatively, I could use another plugin to fire off a custom welcome email after the RPR one has been sent.

    Unfortunately this seems to cause a conflict in RPR because it is already hooked into wp_new_user_notification. Any help or ideas on how to get this done?

    Thread Starter petervnv

    (@petervnv)

    OK, my question boils down to this.

    I need 2 custom fields for registration that the user neither sees nor inputs anything. (alt_id and alt_pass)
    alt_id must be an integer between 1000 amd 9999, alt_pass is a random 8 character password.
    Now I have created a table in wp named alt_table where I created columns alt_id and alt_pass and have already populated them.

    What I would like to figure out how to do, is have RPR update the (initially blank I presume since they’re hidden from the registering user) user_meta fields alt_id and alt_pass with the values already existing in the alt_table.

    Is this possible? I’ve been looking into RPR sourcecode but I’m getting overwhelmed.

    Conceptually I think that somewhere in rpr_activate.php or rpr_signup.php, it should be possible to run a mysql query like $wpdb->get_var(“SELECT alt_pass FROM alt_table WHERE user_id = ‘current user or whatever’ “) and do the same to grab alt_id, then use those values to run update_user_meta once the account has been activated.

    Is my thinking correct or am I way off base here?

    Any help or pointers much appreciated.

    Thanks and Happy New Year

    Hello Petervnv, maybe you can give me a light with this question…
    You found where RPR stores the used invitation codes, but do you have idea where are stored the not used codes?

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘where in wordpress database does RPR store custom fields?’ is closed to new replies.