In order to save programming time we would like to use CB for a contest. People goto the website, register via CB registration, and are entered into the user table (contest poo) from which a weekly script that we'll create will run and pick x number of winners from.

We created some additional fields, namely cb_ContestParticipant (as we have other users who are doctors and uneligable) and cb_ContestWinnder (that our custom php cron job will run every week and update the database convert x number of cb_ContestWinner=0 to cb_ContestWinner=1 along with a cb_WinnerPickDate that will be populated to different each batch of contest winners (winners will be chosen every week for about 6-8 weeks.

What's the best way to do this? At the moment I can't think of a way around hacking the registration page just a little so it will have a hidden field cb_ContestParticipant with a value of 1 so that we'll know this is a contest registratiion.

(We also use the DB user table to house Doctor profiles for visitors of the site to come and get their numbers and other misc info about their practice.) I thought of just using groups as a differentiator but I want this to be idiot-proof. There is no registration to the site at all. This contest will be the first instance where we need it at the same time want them separate from the users already in the db.


Thanks!
Will P

Normally I'd agree with you Krileon but we're already using it to house our database of doctors so I thought it would be easier to use CB (plus we're more familiar with it, even hacking it the few times it's been necessary).

Breezeforms has a SaaS pricetag on it and our clients aren't looking to spend money every month just for a contest.

I have the registration form in place, I mainly need to know how to make sure there are hidden fields that update the db in there. I'll try the CB conditional and see if that works.

The other thing is the CBredirect plugin. I installed it and am trying to use it to redirect users who register to a 'thank you' page. It looks like I set it up correctly, but I'm still getting the default CB registration message, which I'm not sure where it's even coming from.

I got it working.

Using the CBredirect registration redirects to the article of my choosing.

CBconditional allowed me to put a hidden field to flag the registering user as a contest participant.

Using another extension might have been better in the long run, but with as much CB can do and my familiarity with it now it's hard to beat even for tasks like this.