I'd like to use Chronoforms to do a small contest on our site. Users would log in and then answer a quick webform to enter and I'd then pick out a person at random for a submission. I'd like to limit entrants to being able to submit to the contest only once every 24 hours, resetting at midnight pacific time.
Is there a fairly straightfoward way to query the results that are stored in the MySQL table and show an error message if a user tries to submit more than once in a 24 hour period?
Is there a fairly straightfoward way to query the results that are stored in the MySQL table and show an error message if a user tries to submit more than once in a 24 hour period?
Hi e-itguy,
ChronoForms will save the recorddate in the MySQL table (if you created the table in ChronoForms). You could use a DB Record loader to look up the most recent record for the current user and check the time on it. You'd need a little PHP to calculate whether the time was before the last midnight.
Bob
ChronoForms will save the recorddate in the MySQL table (if you created the table in ChronoForms). You could use a DB Record loader to look up the most recent record for the current user and check the time on it. You'd need a little PHP to calculate whether the time was before the last midnight.
Bob
This topic is locked and no more replies can be posted.
