How to show username when registrate with invite code

I want to fill in a field called "Name sponsor" automatically when the user is redirected to the registration page, after following the link in the mail from CB Invite.

Now it delivers an invitation code that can be seen on the registration page automatically. How can I show the "Name sponsor"being the name of the user that belongs to the invitation code?

thanks for any help / suggetions

You would need to modify CB Invites to output that or modify CB Query Field to have an edit display so a query could be made for the username of the user who sent the invite code. We don't have anything out of the box to display that information.

OK but what kind of query do I need (Select USERNAME FROM DB_IVITES where INVITE_CODE= "#12345") or something like that?
I really don't know the name of the database tables and records.

Of course there is no standard solution, but can it easily (without editing the original code) be done with CB Query Field?

CB Query Field has no edit display so it won't show up on registration or profile edit views. I guess you can try forcing it by substituting in the profile view of a query field into a Custom HTML field, but as the user is not yet registered it probably won't display anything. At any rate the query would be as follows.

Let me try to explain what I want:

User A invites Person B. Person B gets an email with a link to register and the Invite code is automatically filled. Then Person B clicks on the link and goes to the registration page and sees the Invite code already filled in.

What I would like is something like:

If Invitecode is not empty then SponsorName = FormatName WHERE UserA.Invitecode = Invitecode (filled in on the registration form)

Does this make any sense? And is this possible?

You'll have to try using CB Query Field with the above query for that, but I'm unsure if it'll work. Ensure CB Query Field is ordered after CB Invites in CB > Plugin Management in hopes the user object is populated by the invite code before CB Query Field tries to use it in its query.