o Check requests from same machine continously

slimjim

What is wrong with this code ? If a person clicks on a link before the 10 seconds are finished counting down to 0, they are redirected to a error page. Problems is, it seems to work just once, if i go back and click link again i dont get error page and i should, I dont think it is checking the database right.

// Start - To Check requests from same machine continously
if (!$ipsfseconds) $ipsfseconds=10;
$sql_cur_period2 = "and idate>=".(time()-$ipsfseconds);
if(!e(q("select id from previews where ifrom='$REMOTE_ADDR' $sql_cur_period2"))) 
	{
	$errorcode="startpage_skiptoofast"; 
	go();
	exit;
	}

rachel2004

Do an echo of $REMOTE_ADDR and see what it is set to. The script may be doing exactly what it is supposed to do, but you're not aware of what is using in $REMOTE_ADDR the second time around.

slimjim

Not sure where to add the echo, but here is the code, it seems to check it ok the first time, but when i click a link again i get not errorcode.

// Start - To Check requests from same machine continously
if (!$ipsfseconds) $ipsfseconds=10;
$sql_cur_period2 = "and idate>=".(time()-$ipsfseconds);
if(!e(q("select id from previews where ifrom='$REMOTE_ADDR' $sql_cur_period2"))) 
	{
	$errorcode="startpage_skiptoofast"; 
	go();
	exit;
	}

rachel2004

I was thinking of something like the following:

if (!$ipsfseconds) 
    $ipsfseconds=10;
$sql_cur_period2 = "and idate>=".(time()-$ipsfseconds);
if(!e(q("select id from previews where ifrom='$REMOTE_ADDR' $sql_cur_period2"))) 
{
    echo"<p>Inside of if statement where REMOTE_ADDR is assigned to: ".$REMOTE_ADDR."</p>";
    $errorcode="startpage_skiptoofast"; 
    go();
    exit;
}
else 
{
    echo"<p>Inside of else conditional where REMOTE_ADDR is assigned to: ".$REMOTE_ADDR."</p>";
    die("<p>End of script.</p>");
}

This should make it clear what has been assigned (or is still assigned) to $REMOTE_ADDR when you return to the page.

Post back your results.

slimjim

well not understanding it, it is finding the ip address... Feel like taking a look at problem first hand rachel ?

rachel2004

Okay. I make no guarantee that I'll spend too much time helping you troubleshoot, but if I look at the code and see your problem area quickly, I'll let you know. Fair enough? ;-)