Allowing Only One Vote

arsenalfan14

My ratings page is up and running, but somebody stuffed the ballot, giving all team members, except one 0's to make their scores lower.

What's the code to check a person's IP and allow only one vote per IP per match?

Also, trying to accomplish this:

<?

   if ( $matches_rs->Fields("matches_live") == 1 ) {
    print "<a href="null">test</a>";
   } 

   ?>

But I'm getting a parse error. How can I fix it?

The_Chancer

<?

   if ( $matches_rs->Fields("matches_live") == 1 ) {
    print "<a href=\"null\">test</a>";
   } 

   ?>

That'll fix your parse error...

As to get the IP

$_SERVER['REMOTE_ADDR'] will give you that....

arsenalfan14

Cheers my good man!

arsenalfan14

If I use:

$_SERVER['REMOTE_ADDR'] will give you that....

I'd like to get the IP in a text format.

Also, how can I limit a person to one vote per IP per match_id?

This is what I have:

<?

require ( "conn.inc.php" );

// First, check whether the add vote form was submitted
if ( $_POST['add_votes'] ) {
	foreach ( $_POST as $key => $val ) {
		if ( eregi ( "rating", $key ) ) {
			$player_rating = explode ( "_", $val );
			$sql = 'INSERT INTO rating ( player_id, match_id, rating_value ) VALUES (' . $player_rating[0] . ',' . $_POST['match_id'] . ',' .  $player_rating[1] . ')';
			$add_rating_rs = $conn->Execute($sql) or die ( $conn->ErrorMsg() );
		}
	}
	header ( "Location: results.php?match_id=" . $_POST['match_id'] );
	exit;	
}

I want to get the user's IP and have it inserted in a field called, user_ip in the ratings table.

arsenalfan14

I was hoping to at least get PHP working to let me get a visitors IP address and insert it into the TABLE 'rating' within the next couple of hours.

Allowing one vote per IP can wait.

pablodelapena

I don't know how your storing your results, but if you have a seperate table for them you could make a coloumn in it for the user's IP address. Then when they search before you add another row to the table check to see if there is a row already containing that Polls ID and the user's IP. If it returns a row then redirect themmeslewhere as they ahve already posted. If it does not carry on as normal and allow the vote.

arsenalfan14

Thanks. I'm not storing my results.

I can't figure out:

1) How to get the IP?

2) How to insert it into my table.

Here's my code all of mySQL/PHP queries at the top of the page.

<?

require ( "database_conn.inc.php" );

// First, check whether the add vote form was submitted
if ( $_POST['add_votes'] ) {
	foreach ( $_POST as $key => $val ) {
		if ( eregi ( "rating", $key ) ) {
			$player_rating = explode ( "_", $val );
			$sql = 'INSERT INTO rating ( player_id, match_id, rating_value ) VALUES (' . $player_rating[0] . ',' . $_POST['match_id'] . ',' .  $player_rating[1] . ')';
			$add_rating_rs = $conn->Execute($sql) or die ( $conn->ErrorMsg() );
		}
	}
	header ( "Location: results.php?match_id=" . $_POST['match_id'] );
	exit;	
}

// Now check whether the match passed in is the most recent. If it is, carry on to the voting page
// otherwise redirect to the results page for the match in question.

$latest_match_rs = $conn->Execute ( "SELECT match_date FROM matches ORDER BY match_date ASC LIMIT 0,1") or die ( $conn->ErrorMsg() );
$latest_match_timestamp = $latest_match_rs->Fields("match_date");

$match_rs = $conn->Execute ( "SELECT * FROM matches, team WHERE matches.match_opponent=team.team_id AND matches.match_id=" . $_GET['match_id'] ) or die ( $conn->ErrorMsg() );
$this_match_timestamp = $match_rs->Fields("match_date");

// Now redirect to the results page if there is a match to vote on later than the one passed in
if ( $latest_match_timestamp > $this_match_timestamp ) {
	header ( "Location: results.php?match_id=" . $match_rs->Fields("match_date") );
	exit;
}

$arse_squad_rs = $conn->Execute ( "SELECT * FROM player, match_squad WHERE match_squad.team_id=1 AND match_id=" . $_GET['match_id'] . " AND match_squad.player_id=player.player_id ORDER BY player_position ASC" ) or die ( $conn->ErrorMsg() );
$sub_on = $arse_squad_rs->Fields("match_sub_on_min");
$sub_off = $arse_squad_rs->Fields("match_sub_off_min");
$playerid = $arse_squad_rs->Fields("player_id");

$match_type_rs = $conn->Execute ( "SELECT * FROM type_match, matches WHERE matches.match_type=type_match.type_id AND matches.match_id=" . $_GET['match_id'] . "" ) or die ( $conn->ErrorMsg() );
 $typeofmatch = $match_type_rs->Fields("type_name");

?>

Then at the bottom, by the submit button I have:

<td width="91" bgcolor="cc0033" align="center" valign="middle"><input name="add_votes" type="submit" id="add_votes" value="Submit" class="bttn">
          					<input name="match_id" type="hidden" id="match_id" value="<?=($_GET['match_id'])?>"></td>

Thanks for helping me out.

pablodelapena

$_SERVER['REMOTE_ADDR'] will give you the users IP address.

arsenalfan14

I saw that, BUT I can't figure out where to include it to make sure it gets inserted into my table.

Thanks!

The_Chancer

You can put it into the insert query...

insert into table (IP) VALUES ('".$_SERVER['REMOTE_ADDR']."')

Works no probs...

arsenalfan14

Thanks. Tried it, didn't enter anything into the table.

TABLE ratings
ip = varchar (15)

<?

// First, check whether the add vote form was submitted
if ( $_POST['add_votes'] ) {
	foreach ( $_POST as $key => $val ) {
		if ( eregi ( "rating", $key ) ) {
			$player_rating = explode ( "_", $val );
			$sql = 'INSERT INTO rating ( player_id, match_id, rating_value, host, ip ) VALUES (' . $player_rating[0] . ',' . $_POST['match_id'] . ',' .  $player_rating[1] . ',' . $_SERVER['REMOTE_ADDR'] . ')';
			$add_rating_rs = $conn->Execute($sql) or die ( $conn->ErrorMsg() );
		}
	}
	header ( "Location: results.php?match_id=" . $_POST['match_id'] );
	exit;	
}