Re: Simple solution to voting problem?

["Aaron D. Turner" <aturner@best.com>]

-----BEGIN PGP SIGNED MESSAGE-----


I was going to do this long write up about what I think we should do and
why we should do it.  Then I realized something.  

We shouldn't do anything.

If we have someone do this inside the first 60 days I'll be absolutely
amazed.  To have this happen to our site would mean that were massively
sucessful, otherwise why would someone bother?  We're not a slashdot or
Linux Rules vs NT Sucks site.  There's nothing contriversal about this
article helped me or not.  So let's cross this bridge when we get to it.  
We've got plenty of other issues to worry about which are far more
critical than this.  Plainly, this isn't an issue that we need to worry
about before we go live, hence let's worry about it some other time.

'nuff said.

- -- 
Aaron Turner           | Either which way, one half dozen or another. 
aturner@pobox.com      | http://www.pobox.com/~aturner/

"There is no worse tyranny than to make a man pay for something he does
not want merely because you think it would be good for him." 
- -Benjamin Franklin

All emails from this account are PGP signed.  Lack of a signature is "bad".
PGP Key fingerprint = FB E1 CE ED 57 E4 AB 80  59 6E 60 BF 45 1B 20 E8


On Mon, 24 May 1999, Micah Yoder wrote:

> Robert Myers wrote:
> 
> >         I has suggested a temp table, that could be nuked as well.
> 
> Just using the log file would use less resources, I *think*.
> 
> >         if($aid>-1) {
> >                 my $cursor = $dbh->prepare("
> >                         SELECT id from pollvoters where
> >                                 qid='$qid' AND
> >                                 id='$ENV{REMOTE_ADDR}'");
> >                 $cursor->execute;
> > 
> >                 # print $ENV{REMOTE_ADDR};
> > 
> >                 if ($cursor->fetchrow()) {
> >                         $notes="You have already voted.";
> >                 } else {
> >                         $notes="Your vote has been registered.";
> >                         $dbh->do("
> >                                 INSERT into pollvoters
> >                                 (qid,id,time)
> > VALUES('$qid','$ENV{REMOTE_ADDR}',
> > now())");
> > 
> > What do you make of that?  qid and aid are for tracking the question.
> 
> Looks like it's not even allowing the possibility of two votes for the
> same IP.  Maybe this is acceptable, but as I pointed out earlier, it
> will leave some people out in the cold.
> 
> I guess this isn't a super-critical issue in any case.  If we keep the
> log files we can write a script later to do what needs to be done.
> 


-----BEGIN PGP SIGNATURE-----
Version: 2.6.2

iQCVAwUBN0pX3zM3jpXy1kJtAQFR0QP/QaW05/FjfJV1+NnS6NknmhxR5Sj2vtgP
NvFMQ/dGcRhikjFvNlmtNTeH24ZG7wJR+HB/fbkuUHUr8Sy8b0/b15XVmWL9AE05
Y8Nf+5RJDMYZegFrAhuZc3yPlijiubo1bTSwpytAr4LXl7tkFS9C+tyRUTzO1aNg
0ipEyY5Xc94=
=mpGI
-----END PGP SIGNATURE-----