The Joomla! Forum™

// GET FIELDS FROM CB

$qb->select( 'r.cb_xxxxx AS xxxxx' );
put rest of any fields you want to display

// SORT

$qb->order( 'cb_playerlastname' );

make sure you remove the join statements, and reference to the email select.

Nick - I messed around with it some, the only way I could get it to work is to just have the cb fields, and take out the email and join clause. Since they are in different tables, the join clause has to identify both fields that are the same in both tables, which is 'id' . I will let you know if I c...

Nick - I will let you know when I get the report working to display all, just have to mess with it a little...

Chuck

For these fields in virtuemart configuration page, are yours set this way, here are mine: User Registration Settings Use silent (hidden) user registration? (Checked Yes) When enabled, users don't need to fill in a username and password for a new account. Instead the email address is used for the new...

Hoping that maybe CB subscription will make the flow better.....the only thing I really hate with CB / VM is when they register, sometimes they don't log back in and do the checkout.  I have to nag them.  How can we get it to not let them complete the registration unless they checkout?&nbs...

Nick -
For CB subscriptions, do you think it would be functional enough for me to do away with VM?

All I basically need anyway is a payment required for each registration.

Chuck

Nick- Glad to hear it is working out so far. First question you had, do you mean getting Jamboreport so registered users can run it?  I just published it by doing a new menu entry -mainmenu, new, selecting component, jamboreport, publish it to registered users only.....  Let me know if you...

If I could somehow make the CB trigger a process that takes you straight to the account information screen and so that any required fields be filled out, then I would not have to delete the accounts, I could just delete some of the fields that should be updated.  I am afraid that they wouldn't ...

Nickolai, I checked out your site, real nice. I noticed your registration is using Acctexp - how does that work with CB ?  I know it is a component that locks accounts after they expire, is that all it does, and do the fields get stored in CB as normal? I thought about using it also, but all I ...

Nickolai and augustnyr, I think that would be a rather extensive hack, to try to pull in all the purchase info into the CB user profile, I actually thought about it before I did what is in place now.  I think the ultimate solution is if someone could build a report module on to Virtuemart and h...

I am using Community Builder, that is integrated with Virtuemart and Letterman.  Latest versions of all with security fixes. The integration with virtuemart allows the billing fields to be displayed underneath the community builder fields.  I setup all the cb fields differently based on th...