03-14-2009, 05:23 AM
|
#2 (permalink)
|
|
The Contributor
Join Date: Mar 2008
Posts: 62
Thanks: 2
|
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.";
}
?>
|
|
|