T
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
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