Only allow 3 votes a week

[xionhack]

Hello. I have a form, where you can vote for different songs. What I want is for you to only be allowed to vote 3 times a week, the voting system being reset every monday at 12:01 am. How can I do that? Thanks!

[jamesxg1]

Do you mean 3 votes in total or 3 votes per person ?

 

 

James.

[xionhack]

3 votes per person ( the person is signed in to vote.)

[jamesxg1]

Ok, make a table with something like this.

 

Username (VARCHAR) | Votes (INT).

 

and when they vote run a insert setting a username and vote to 1 then on there next vote use a update to change that 1 to 2 with a where username = session ect.

 

James.

[xionhack]

How will it reset every week? and also, they can vote for more than 1 song at the same time.

[jamesxg1]

The voting site with the values will be kept somewhere else and the vote count (the amount of times they have voted) will be kept in the VOTE table and a cron job maybe.

 

James.

[PFMaBiSmAd]

The simplest system is to record (in a database table) each vote, with the member id, datetime of the vote, and what they voted for. Then it is a simple matter to query for the count of votes in the time period you are interested in and if that count is less than the limit, allow a new vote.

[xionhack]

Yes! that is actually what I had in mind. But I dont know which query to put that tells me how many votes have done only this week, or how many votes have left.

[jamesxg1]

$query = "SELECT * FROM `votes` WHERE username = '$username'";
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result)):

if($row['votes'] > 3) {

// no

} else {

// yes

}

endwhile;

[xionhack]

Yes jamesxg1, but its not only 3 votes at the same time, but 3 votes during the whole week! they can do 1 for 3 days, 3 the same day, 2 one day and 1 another, anyway they want!