necrotic — Sun, 02 Feb 2003 20:21:11 +0000

should be

$query="INSERT INTO phesis_poll_check (ip, time, pollid) 
VALUES ('".$ip."', '".$ctime."' , '2')"; 

Timewell — Sun, 02 Feb 2003 11:57:37 +0000

So the code should be:

$query="INSERT INTO phesis_poll_check (ip, time, pollid) VALUES ('".$ip."', '".$ctime."' , '".'2'."')";'

$query="INSERT INTO phesis_poll_check (ip, time, pollid) VALUES (".$ip.", ".$ctime." , ".2.")";'

necrotic — Sun, 02 Feb 2003 04:55:23 +0000

No, just make it '2' without the "."s. They aren't needed.

Busy — Sun, 02 Feb 2003 01:57:40 +0000

the error looks like its "."2"." (to many quotes), try change it to ".2."

Timewell — Sat, 01 Feb 2003 23:36:20 +0000

Right I have added this code, replacing the code given by Bummer.

{ 
message_die(GENERAL_ERROR, 'You have voted more than once in the poll'); 
} 

$sql="SELECT vd.topic_id 
FROM " . TOPICS_TABLE . " vd, " . TOPICS_WATCH_TABLE . " vr 
WHERE vd.topic_id = $topic_id; 

} else { 

I now get a

Parse error: parse error, unexpected T_STRING in /home/virtual/site21/fst/var/www/html/board/posting.php on line 490

This is:

$query="INSERT INTO phesis_poll_check (ip, time, pollid) 
VALUES ('".$ip."', '".$ctime."' , '"."2"."')"; 

and the code i have suggested above is directly above this. Can you solve this error for me?

Timewell — Sat, 01 Feb 2003 16:40:09 +0000

Right well the current code is:

//// Begin IP track hack /// 

   // Need to change this to match the poll ID in the forum 
   $pollid= $HTTP_POST_VARS['vote_id'];  
    
   $ip = getenv("REMOTE_ADDR"); 
   $past = time()-90800; 
   $votevalid=1; 
   $query="DELETE FROM phesis_poll_check WHERE time < ".$past; 
   $db->sql_query($query); 
    
    
   $sql="SELECT ip FROM phesis_poll_check WHERE ip='".$ip."' and pollid='".$pollid."'"; 
   $result = $db->sql_query($sql); 
   $post_info = $db->sql_fetchrow($result); 
    
   $ips=$post_info['ip']; 
   $ctime = time(); 
   if ($ip == $ips) { 
     $votevalid = 0; 
     //require('http://www.wizardsandwars.com/already_voted.php'); 
     exit(); 
       if ( $votevalid == 0 ) { 
         header("Location: " . append_sid("already_voted.$phpEx?redirect=viewtopic.$phpEx", true)); 
       } else {
     $query="INSERT INTO phesis_poll_check (ip, time, pollid) VALUES ('".$ip."', '".$ctime."' , '"."2"."')"; 
     $db->sql_query($query); 
     $votevalid = 1; 
   } 
    
   //// End IP track hack //// 

It is placed inside posting.php here:

$message = $lang['Vote_cast'];
			}
			else
			{
				$message = $lang['Already_voted'];
}
//// Begin IP track hack /// 

   // Need to change this to match the poll ID in the forum 
   $pollid= $HTTP_POST_VARS['vote_id'];  
    
   $ip = getenv("REMOTE_ADDR"); 
   $past = time()-90800; 
   $votevalid=1; 
   $query="DELETE FROM phesis_poll_check WHERE time < ".$past; 
   $db->sql_query($query); 
    
    
   $sql="SELECT ip FROM phesis_poll_check WHERE ip='".$ip."' and pollid='".$pollid."'"; 
   $result = $db->sql_query($sql); 
   $post_info = $db->sql_fetchrow($result); 
    
   $ips=$post_info['ip']; 
   $ctime = time(); 
   if ($ip == $ips) { 
     $votevalid = 0; 
     //require('http://www.wizardsandwars.com/already_voted.php'); 
     exit(); 
       if ( $votevalid == 0 ) { 
         header("Location: " . append_sid("already_voted.$phpEx?redirect=viewtopic.$phpEx", true)); 
       } else {
     $query="INSERT INTO phesis_poll_check (ip, time, pollid) VALUES ('".$ip."', '".$ctime."' , '"."2"."')"; 
     $db->sql_query($query); 
     $votevalid = 1; 
   } 
    
   //// End IP track hack //// 
			
		}
		else
		{
			$message = $lang['No_vote_option'];
		}

But now I have noticed that it registers the vote but it doesn't come up with a page saying that you have voted. Why is this? Could you get it to come up with a page with the results to stop guests from voting repetively?

necrotic — Sat, 01 Feb 2003 02:50:30 +0000

Ahhhh, I thought it would just display a message. I highly doubt you could do that with die() or exit().

Timewell — Sat, 01 Feb 2003 02:37:37 +0000

No it doesn't work. What the script wants to do is to make sure that a user cannot vote again after submitting the vote. It wants to display the voting results. How can I do this?

Timewell — Sat, 01 Feb 2003 02:26:36 +0000

and I put this into posting.php where it says:

else if ( $mode == 'vote' ) right? Just slightly after that?

necrotic — Sat, 01 Feb 2003 02:19:22 +0000

Sure, you can just use

die("Your message here");

and it should work. You won't need exit(); Or you can use exit the same way as die.