A sweepstakes/giveaway mod?

[VodkaFish]

I did a few searches for certain things like: sweepstakes, giveaway, contest, but didn't come back with much. However, I know there are a lot of ways to do this, so I figured I'd post here first to find out if something like this has been created before.

I'm sure I'm not the only one who does giveaways and such on my site sometimes. Like many, I like to keep most of it to "members only", the members themselves like that, and it also encourages new sign ups. Instead of conducting these things manually, I figure it would be good to build a mod for it.

It's pretty simple actually. Here's my idea:

Add new fields to profile: address line 1, address line 2, state, postal code (and country if you like), and phone number.

Make two new tables in db for sweepstakes:

sweepstakes

sweepstakes_id
sweepstakes_name
sweepstakes_description
sweepstakes_start_date
sweepstakes_end_date
sweepstakes_notes (admin notes basically)
sweepstakes_rules (legal stuff if you need it)
sweepstakes_frequency (how often someone can enter - just once, daily, weekly, monthly)
sweepstakes_quantity

sweepstakes_entries

sweepstakes_id
userid
sweepstakes_entry_datetime

In the admin you can set all the fields for:

Name
Description
State Date
End Date
Notes
Rules
Frequency
Quantity

Then you have another spot with the winners list, as well as a button to manually pick a winner.

You then have a sweepstakes entry page:

The page has the name, description and dates of sweepstakes along with any rules.
- If someone is not logged in they get a message about how the sweepstakes is members only, and if they want to be eligible they have to join and fill out their birthdate, address and phone number.
- If someone is logged in, but does not have birthdate, address and phone number filled out, they get a message saying they need to edit their profile and do so.
- If someone is logged in and has the correct profile fields filled out - they just need to push an "enter me!" button (and perhaps also an "agree to rules" checkbox).
- If someone is logged in and has already entered, they get a message saying so. However - there is a frequency check. Someone have a contest where they only allow people to enter once, others where people are allowed to have an entry every day (or week or month). A simple date check is all that's needed here.

Then, after a contest is done you go into the admin, pick a winner (random) and have a pre-written "you've won" email written - but not sent, you can manually modify it and send it along.

One thing I'm just realizing here is perhaps you also want to set a quanity if you are giving out multiple prizes and have multiple winners chosen. I'll add that to the outline above.

Thoughts, ideas, anything like this out there?