hotornot?

Anon

Hi,

I am making a hotornot type system for a client and wanted to know if anyone has some possible ways of preventing vote tampering. Here is an example of what I have now:

I am just tracking all the votes for example

Rateeid, vote, ip, time

I do a select to make sure that the ip the user is using has not posted a vote in the last 10 minutes. I know this is a really bad idea that’s what I am asking.

I would also like some possible options on summarizing the vote information. Here is an example of what I have now:

I am currently tracking the (rateeid, vote, ip, time). For example if you vote a picture a record would be inserted into the votes table. The only problem with this is the table could fill us very fast with a lot of meaning less information.

A possible solution would be too make a table where I have a list of files 1-10 and just increment the specific number for the vote.. Then I would only have as many records and images? Do you follow?

Chris

greg252

Why not set a cookie for the vote with an expiration of 10 mins. If the cookie is set, the vote will not take, if not set, the vote is recorded?

bastien

use sessions and store all the voted on items in an array. when they vote, add the item to the array, when the next vote occurs, validate the id against the array and if not there then allow the vote else not allow the vote.

hth

bastien

Oh-Twadi_com

do u have a preview of the hotornot site i love looking round them to get tips

mrchuckles2002

You could try would i did for my voting system. store ips on a seperate table, then before the vote button appears it checks to see if the ip is already present., if they have already voted the button does not appear.

Then u have to have a function that deletes the ip database after 2 weeks, or whatever.

For the voting, the best way is to have 2 collums, no of votes and link rating. every time you rate a site, the number of votes goes up one and the link rating increases by the rate amount (ie if it was 7/10 the rating increases by 7.)

then in your function to display the rating. you need to display the average vote (ie. rating divided by number of votes)

by having a seperate table for ips means that u can see how many people are voting and on what. Also means that one person can vote on loads of things, but not on one thing twice in a given period, like as i suggested 2 weeks.

i'm happy to help further..