How to show username when registrate with invite code

Sorry to bring it up again, but was thinking to set a trigger on _comprofiler table BEFORE/AFTER inserting a new record. I guess it should be something like:

CREATE TRIGGER `invite`
BEFORE INSERT ON `rv6fj_comprofiler`
FOR EACH ROW set NEW.cb_sponsor = (SELECT NAME FROM INVITE_CODES WHERE code = NEW.invite_code)

Could something like this be done? BEFORE or AFTER INSERT?

Thanks for your incredible never ending support!

The only way this will work is if you create a fieldtype plugin that pulls the invite id from GET like CB Invites does then queries for the username based off the invite code (by joining the invites table and the users table).

The query provided on the first page of this topic will work after a user has registered so there's no need to hard code the users name into their _comprofiler row, but it's not going to work at registration like you're wanting because the user object is completely empty so there is no invite code.

The invite email already identifies who sent the invite so I'm not sure why you're going through so much trouble to have this. The easiest way to go about it would be to just modify CB Invites and its field to fit your needs.

Hi Kyle,

Thanks for your response! Reason for me is that my customers can invite other people to join our community. Since I want to be sure that they don't enter a wrong "member" name, I just thought it might be useful to populate it automatically (afterwards).

No problem for me that Field cb_sponsor will be filled after posting the registration form.
Question is which option is the safest / quickest one:
- do something on the server table (AFTER INSERT or TRANSACTION)
- use CB Auto Action (if possible, but I guess not), or
- Modify CB Invites (which is not my strong poitn, but trial and error will get me somewhere).

What do you think?

Thanks a lot for your support!

There's no reason to store the name. Use a CB Query Field with the query provided below.

www.joomlapolis.com/forum/153-professional-member-support/229438-how-to-show-username-when-registrate-with-invite-code?limitstart=0#262960

Replace u.`username` with u.`name` for name.

Eventually it should be stored in the database because the managers must see in the profile who the sponsor is...

Shall try if this works in the Profile View...

Thanks.

By the way is MySQL Field Plugin also available for the Professional?

It doesn't need to be stored for that. CB Query Field will take the users invite code, query it against the database, find out who sent the invite by matching the user id, and display their name (or username, etc..). This works everywhere except registration.

By the way is MySQL Field Plugin also available for the Professional?

Yes, it's available for download in the Professional downloads section as "CB Query Field".