Perl Project Logic Question

[Tyler Cruz]

Hi,

I'm contemplating improving my "Name That Flick" feature, and was wondering
if this is the right logic for what I should be doing.

Name That Flick (http://www.movie-vault.com/namethatflick/) shows a shot
(JPG) from a movie, and visitors are to guess what it is, and check back in
one week for the answer.

I have a members database for my site in mySQL, which contains columns for
firstname, lastname, password, moviequotescore, namethatflick score and a
few others. In order to answer/guess the film, they would need to enter it
in a box. If they get it correct, namthatflick gets incremented by 1.

Now, a little problem. I will be updating the film once a week, so once they
get it, I have to temporarily suspend them from guessing again, or they can
just rack up free points. Thus, I was thinking of adding a new colomn in my
table in MySQL for 'namethatflickcorrect' and it woudl have a Y or N. Y if
they answered it correctly, and N if not. And the form would not let them
guess again if they have a Y.

I keep the movie name and name for the image filename in flatfile databases.

Then when the administrator (me) adds a new movie, it would reset all the
members' namethatflickcorrect' to N. (loading/bandwidth issues?). I'm not
sure if I will archive the old Name that Flick answers/photos, as I think it
may be too much programming (not worth it/overcomplicated)

Anyhow, please let me know if my logic is correct, thanks.

Tyler Cruz
movie-vault.com

 

[Tyler Cruz]

Hi,

That seems like a good idea, with only one fault I believe.. If I ever put
two of the same movie back to back (by accident perhaps) - nobody will be
able to guess it correctly.. I think, also, in the back of my mind, that I'm
somehow afraid of it not completely matching correctly..

Tyler