voting implementing source (part 2)

Question

up_vote.php like down_vote.php

//HTML Code

<?php

include("qa_config.php");
$ip=$_SERVER['REMOTE_ADDR'];

if($_POST['id'])

{

$id=$_POST['id'];
$id = mysql_escape_String($id);

//Verify IP address in Voting_IP table

$ip_sql=mysql_query("select ip_add from Voting_IP where mes_id_fk='$id' and ip_add='$ip'");
$count=mysql_num_rows($ip_sql);

if($count==0)

{

// Update Vote.

$sql = "update Messages set up=up+1 where mes_id='$id'";
mysql_query( $sql);

// Insert IP address and Message Id in Voting_IP table.

$sql_in = "insert into Voting_IP (mes_id_fk,ip_add) values ('$id','$ip')";
mysql_query( $sql_in);
echo "<script>alert('Thanks for the vote');</script>";

}

else
{
echo "<script>alert('You have already voted');</script>";
}

$result=mysql_query("select up from Messages where mes_id='$id'");
$row=mysql_fetch_array($result);
$up_value=$row['up'];
echo $up_value;

}

?>

???????????

Answer 1

Looks promising - maybe you will release it as a plugin?

Comments

Thanks, gidgreen, for fun! ) But I am not an programmer, I do not know how to do that.

---

I am about voting. If somebody wants to create plugin for anonymous voting, I suggest it must be with preventing abuse with email notification. For example. If someone anonymous cliks up voting bottom, then popping up field, there this anonymous user must enter email, then this user entered his email account end validate his voting. ReCaptcha from google is not practical and a bit difficult to guess words

---

Sorry, it is easy to abuse. I have red that to prevent spam it must have limitation per time ( I am thinking 5 in 1 hour).