View Single Post
Old 03-14-2009, 05:23 AM   #2 (permalink)
Seraskier
The Contributor
 
Join Date: Mar 2008
Posts: 62
Thanks: 2
Seraskier is on a distinguished road
Default

I think I got it!

Can someone please verify for me that it will work, or make changes to it to where it will work for all occassions.

Code:
<?php
//gain access to database
define("access",true);
require("database.php");

//settings variables
$settings=mysql_query("SELECT * FROM settings");
while($settings=mysql_fetch_array($settings))
{
	$loginwindow=$settings['loginwindow'];
}
echo "Login window: ".$loginwindow." hours<br /><br />";


//current date and time
list($hour,$minute,$second)=split(" ",date("H i s"));
list($month,$day,$year)    =split(" ",date("m d Y"));
$current=mktime($hour-$loginwindow,$minute,$second,$month,$day,$year);

//users registration date and time
$query=mysql_query("SELECT * FROM users WHERE id='93'");
while($row=mysql_fetch_array($query))
{
	list($hr,$mn,$sd)=split(":",$row['signuptime']);
	list($mh,$dy,$yr)=split(" ",$row['signupdate']);
	$signup=mktime($hr,$mn,$sd,$mh,$dy,$yr);
}

echo "Current time: ".$hour." ".$minute." ".$second." | ".$month." ".$day." ".$year."<br />";
echo "Signup time : ".$hr." ".$mn." ".$sd." | ".$mh." ".$dy." ".$yr."<br /><br />";

echo "Current mktime: ".$current."<br />";
echo "Signup mktime : ".$signup;

echo "<br /><br />";

if($signup < $current)
{
	echo "delete";
}
else
{
	echo "do not delete.";
}
?>
Send a message via MSN to Seraskier
Seraskier is offline  
Reply With Quote